Bug #96761 Add ST_GeoHex(),ST_PolygonFromGeoHex() function
Submitted: 5 Sep 2019 3:00 Modified: 6 Sep 2019 6:40
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 3:00] Yoshiaki Yamasaki
Description:
GeoHex is a type of geocoding system. GeoHex has the following advantages over GeoHash.

 [Advantages]
   - Easy distance calculation between meshes.(Equal distance to neighboring mesh)
   - Cool interface for entertainment!! :D
     http://geohex.net/
   etc

   * Details are described in these documents.
     https://www.slideshare.net/sa2da/foss4g-2010-tokyo-ltgeohex
     https://www.slideshare.net/sa2da/about-geohex-5134812

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

Note:
http://geohex.net/
https://sites.google.com/site/geohexdocs/

How to repeat:
N/A

Suggested fix:
Add following Spatial functions.
 - ST_GeoHex()
 - ST_PolygonFromGeoHex()
[6 Sep 2019 6:40] MySQL Verification Team
Hello Yamasaki-San,

Thank you for the feature request!

regards,
Umesh