ST_PointFromGeoHash
Returns the center point of the specified GeoHash.
Behavior Type
Syntax
ST_PointFromGeoHash(GeoHash)
Arguments
GeoHash |
A valid GeoHash string of arbitrary length. |
Returns
GEOGRAPHY POINT
Examples
The following examples show how to use ST_PointFromGeoHash.
Returns the geography point of a high-level GeoHash and uses ST_AsText to convert that point into Well-Known Text:
=> SELECT ST_AsText(ST_PointFromGeoHash('dr')); ST_AsText ------------------------- POINT (-73.125 42.1875) (1 row)
Returns the geography point of a detailed GeoHash and uses ST_AsText to convert that point into Well-Known Text:
=> SELECT ST_AsText(ST_PointFromGeoHash('1234567890bcdefhjkmn')); ST_AsText --------------------------------------- POINT (-122.196077187 -88.2297377551) (1 row)