Skip to content
πŸŽ‰ Apache Sedona 1.9.1 is out now! πŸ—ΊοΈ Geography SQL functions, Box2D & Box3D types, raster Python UDFs & more. Read the release notes β†’

ST_GeogFromGeoHash

Introduction: Create Geography from geohash string and optional precision. When precision is omitted, the full precision of the geohash string is used.

Format:

ST_GeogFromGeoHash (geohash: String)

ST_GeogFromGeoHash (geohash: String, precision: Integer)

Return type: Geography

Since: v1.9.1

Example:

SELECT ST_GeogFromGeoHash('s00twy01mt', 4)

Output:

POLYGON ((0.7 0.9, 1.1 0.9, 1.1 1.1, 0.7 1.1, 0.7 0.9))