Details
-
New Feature
-
Status: In Testing (View Workflow)
-
Major
-
Resolution: Unresolved
Description
The GIS function ST_GeoHash takes as input:
- (longitude, latitude, max_length), OR
- (point, max_length)
The longitue parameter is a numeric value in the interval [180, -180], the latitude is a numeric value in the interval [90, -90].
In the case of point, the x coordinate is treated as the latitude and the y coordinate is treated as the latitude. Even in the case of a point, the same constraints apply.
The max_length parameter is the upper limit on the resulting string size and cannot exceed 100.
The function returns the geohash corresponding to the input values.
Attachments
Issue Links
- blocks
-
MDEV-34159 Implement the GIS function ST_LatFromGeoHash
- In Testing
-
MDEV-34160 Implement the GIS function ST_LongFromGeoHash
- In Testing
- is part of
-
MDEV-17398 Implement Geographic functions available in MySQL 8.0
- In Testing
-
MDEV-34120 GSoC 2024, Spatial (GIS) functions in MariaDB
- In Testing