Analytics Toolbox for BigQuery

Analytics Toolbox for BigQuery

Github Code

geohash

Geohash is a public domain spatial index.

GEOHASH_BOUNDARY

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

1
2

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

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