geohash

Geohash is a public domain spatial index.

GEOHASH_BOUNDARY

GEOHASH_BOUNDARY(index)

Description

Returns a geography representing the geohash cell. It will return null on error (invalid input).

• index: STRING The Geohash cell index. The maximum length supported is 17.

Return type

GEOGRAPHY

Example

carto-un

SELECT `carto-un`.carto.GEOHASH_BOUNDARY('ezrqcjzgdr3');
-- POLYGON((-1.00000128149986 41.9999988377094, -0.999999940395355 41.9999988377094, ...

carto-un-eu

SELECT `carto-un-eu`.carto.GEOHASH_BOUNDARY('ezrqcjzgdr3');
-- POLYGON((-1.00000128149986 41.9999988377094, -0.999999940395355 41.9999988377094, ...

manual

SELECT carto.GEOHASH_BOUNDARY('ezrqcjzgdr3');
-- POLYGON((-1.00000128149986 41.9999988377094, -0.999999940395355 41.9999988377094, ...

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.