ST_PointFromGeoHash
Name
ST_PointFromGeoHash — Return a point from a GeoHash string.
Synopsis
point
ST_PointFromGeoHash
(
text
geohash
, integer
precision=full_precision_of_geohash
)
;
Description
Return a point from a GeoHash string. The point represents the center point of the GeoHash.
If no
precision
is specified ST_PointFromGeoHash returns a point based on full precision of the input GeoHash string.
If
precision
is specified ST_PointFromGeoHash will use that many characters from the GeoHash to create the point.
Availability: 2.1.0
Examples
SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0'));
st_astext
------------------------------
POINT(-115.172816 36.114646)
SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0', 4));
st_astext
-----------------------------------
POINT(-115.13671875 36.123046875)
SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0', 10));
st_astext
-------------------------------------------
POINT(-115.172815918922 36.1146435141563)