ST_PointFromGeoHash
MariaDB starting with 11.8
ST_PointFromGeoHash was added in MariaDB 11.8.
Syntax
ST_PointFromGeoHash(geohash, srid)
Description
Takes a given geohash string and returns a point where the x is the longitude and the y is the latitude.
The latitude is returned as a numeric value in the interval [180, -180]. The longitude is returned as a numeric value in the interval [90, -90]. If the argument is NULL, the return value is NULL. If the argument is invalid, an ER_GIS_INVALID_DATA is thrown.
Examples
SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("s00twy01mtw037m",0)); +-----------------------------------------------------+ | ST_ASTEXT(ST_POINTFROMGEOHASH("s00twy01mtw037m",0)) | +-----------------------------------------------------+ | POINT(1 1) | +-----------------------------------------------------+ SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,90,20),0)); +---------------------------------------------------------+ | ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,90,20),0)) | +---------------------------------------------------------+ | POINT(180 90) | +---------------------------------------------------------+
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
