Skip to main content
Generates a Point geometry representing the center of the GeoHash cell defined by the input string. If precision is not specified, the full GeoHash precision is used. Providing a precision value limits the GeoHash characters used to determine the Point coordinates.

​
Signatures

ST_PointFromGeoHash(geoHash: String, precision: Integer)

​
Parameters

​
geoHash
String
required
A GeoHash string.
​
precision
Integer
required
The number of decimal places.

​
Return type

The resulting geometry.

​
Example

SELECT ST_PointFromGeoHash('s00twy01mt', 4)

POINT (0.87890625 0.966796875)