Analytics Toolbox for BigQuery

Analytics Toolbox for BigQuery

geohash

Geohash is a public domain spatial index.

ST_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.geohash.ST_BOUNDARY('ezrqcjzgdr3');
-- POLYGON((-1.00000128149986 41.9999988377094, -0.999999940395355 41.9999988377094, ...

VERSION

Description

Returns the current version of the geohash module.

Return type

STRING

Example

1
2
SELECT carto-os.geohash.VERSION();
-- 1.0.0