Bug #96760 Add ST_LocaPoint(),ST_PointFromLocaPoint(),ST_Lat/LongFromLocaPoint() function

Submitted: 5 Sep 2019 2:56 Modified: 6 Sep 2019 6:39
Reporter: Yoshiaki Yamasaki Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2019 2:56] Yoshiaki Yamasaki
Description:
LocaPoint is a type of geocoding system. LocaPoint has the following advantages over GeoHash.

 [Advantages]
   - The code is easy for humans to recognize. Therefore, it can minimize human error.

I want MySQL to implement a Spatial function that can handle not only GeoHash but also LocaPoint.

Note:
http://lpaddress.com/

How to repeat:
N/A

Suggested fix:
Add following Spatial functions.
 - ST_LocaPoint()
 - ST_LatFromLocaPoint()
 - ST_LongFromLocaPoint()
 - ST_PointFromLocaPoint()
[6 Sep 2019 6:39] MySQL Verification Team
Hello Yamasaki,

Thank you for the feature request!

regards,
Umesh

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.