Bug #96760 Add ST_LocaPoint(),ST_PointFromLocaPoint(),ST_Lat/LongFromLocaPoint() function
Submitted: 5 Sep 2:56 Modified: 6 Sep 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
Triage: Needs Triage: D5 (Feature request)

[5 Sep 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 6:39] Umesh Shastry
Hello Yamasaki,

Thank you for the feature request!

regards,
Umesh