ST_GEOMPOINTFROMGEOHASH

Introduced or updated: v1.2.413

Returns a GEOMETRY object for the point that represents center of a geohash.

Syntax

ST_GEOMPOINTFROMGEOHASH(<geohash>)

Arguments

Arguments	Description
<geohash>	The argument must be a geohash.

Return Type

Geometry.

Examples

SELECT
  ST_GEOMPOINTFROMGEOHASH(
    's02equ0'
  ) AS pipeline_geometry;

┌──────────────────────────────────────────────┐
│               pipeline_geometry              │
│                   Geometry                   │
├──────────────────────────────────────────────┤
│ POINT(1.0004425048828125 2.0001983642578125) │
└──────────────────────────────────────────────┘