ST_FROMGEOHASH

Returns the latitude and longitude coordinates of the center of the given geohash.

Syntax

Examples

ST_FROMGEOHASH example

SELECT ST_FROMGEOHASH ('ezs42')
-- {'Latitude': 42.60498046875, 'Longitude': -5.60302734375}

ST_FROMGEOHASH example

SELECT ST_FROMGEOHASH ('9q9j8ue2v71y5zzy0s4q')
-- {'Latitude': 37.554162000000034, 'Longitude': -122.30609999999993}

ST_FROMGEOHASH example

SELECT ST_FROMGEOHASH ('ezs42')['latitude']
-- 42.60498046875

ST_FROMGEOHASH example

SELECT ST_FROMGEOHASH ('ezs42')['longitude']
-- -5.60302734375

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.