MySQL tutorial: ST_LATFROMGEOHASH [EN]
top of page
CerebroSQL

MySQL: 

ST_LATFROMGEOHASH

ST_LatFromGeoHash(geohash_str)

Returns the latitude from a geohash string value, as a double-precision
number in the range [?90, 90].

The ST_LatFromGeoHash() decoding function reads no more than 433
characters from the geohash_str argument. That represents the upper
limit on information in the internal representation of coordinate
values. Characters past the 433rd are ignored, even if they are
otherwise illegal and produce an error.

ST_LatFromGeoHash() handles its arguments as described in the
introduction to this section.

URL: https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html

Example

mysql> SELECT ST_LatFromGeoHash(ST_GeoHash(45,-20,10));
+------------------------------------------+
| ST_LatFromGeoHash(ST_GeoHash(45,-20,10)) |
+------------------------------------------+
| -20 |
+------------------------------------------+

bottom of page