Skip to main content

GEOHASH_DECODE

Converts a Geohash-encoded string into latitude/longitude coordinates.

Syntax

GEOHASH_DECODE('<geohashed-string\>')

Examples

SELECT GEOHASH_DECODE('ezs42');

┌─────────────────────────────────┐
│ geohash_decode('ezs42')
├─────────────────────────────────┤
(-5.60302734375,42.60498046875)
└─────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today