MySQL Bugs: #96760: Add ST_LocaPoint(),ST_PointFromLocaPoint(),ST

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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()

Hello Yamasaki,

Thank you for the feature request!

regards,
Umesh