Skip to main content
These functions aren’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.
Geospatial functions allow working with location-based data, including points, coordinates, polygons, and spatial indexes. They enable conversion, querying, and analysis of geographic information

H3 Functions

H3_LATLNG_TO_CELL

Converts latitude/longitude into an H3 cell index (INT).

H3_LATLNG_TO_CELLADDRESS

Converts lat/lng into an H3 cell address (STRING).

H3_CELL_TO_PARENT

Gets the parent cell index for a given cell.

H3_CELLADDRESS_TO_PARENT

Gets the parent cell address for a given cell address.

H3_CELL_TO_CELLADDRESS

Converts an H3 numeric cell index to its alphanumeric cell address.

H3_CELLADDRESS_TO_CELL

Converts H3 cell address back to numeric index.

H3_CELL_TO_LATLNG

Returns the lat/lng center of a cell as an array [lat, lng].

H3_CELLADDRESS_TO_LATLNG

Returns the lat/lng center of a cell address.

H3_CELL_TO_BOUNDARY_AS_GEOJSON

Returns the cell boundary as a GeoJSON polygon.

H3_POINT_TO_CELL

Converts an ST_POINT geometry to an H3 index.

H3_POINT_TO_CELLADDRESS

Converts an ST_POINT geometry to an H3 cell address.

H3_POLYGON_TO_CELLS

Returns list of H3 cell indices covering a GeoJSON polygon.

H3_POLYGON_TO_CELLADDRESSES

Returns list of H3 cell addresses covering a GeoJSON polygon.

H3_GRID_DISK

Returns neighboring cells within hex distance k.

Bing Tile Functions

BING_TILE_AT

Returns the Bing tile ID at the given location and zoom level.

BING_TILE_QUADKEY

Converts a Bing tile ID to its QuadKey representation.

ST Functions

ST_POINT

Creates a GEOGRAPHY point (lng, lat).

ST_CONTAINS

Checks whether one geography fully contains another.
Last modified on October 15, 2026