ST_GeomFromGeoHash
Name
ST_GeomFromGeoHash — Return a geometry from a GeoHash string.
Synopsis
geometry
ST_GeomFromGeoHash
(
text
geohash
, integer
precision=full_precision_of_geohash
)
;
Description
Return a geometry from a GeoHash string. The geometry will be a polygon representing the GeoHash bounds.
If no
precision
is specified ST_GeomFromGeoHash returns a polygon based on full precision of the input GeoHash string.
If
precision
is specified ST_GeomFromGeoHash will use that many characters from the GeoHash to create the polygon.
Availability: 2.1.0
Examples
The cells are returned together so their relative sizes remain visible in a shared coordinate frame.
SELECT ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0', 4) AS "precision 4", ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0', 5) AS "precision 5", ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0', 6) AS "precision 6";