Intergate H3 Function Geotoh3 from Uber

Why it matters

To provide native support for hierarchical hexagonal geospatial indexing within ClickHouse, enabling efficient geographic data analysis and queries by converting geographic coordinates (latitude and longitude) into H3 hexagon indices.

How to use it

Use the geoToH3 function in your SQL queries by passing latitude, longitude, and H3 resolution as arguments, for example:

SELECT geoToH3(latitude, longitude, resolution) FROM table

This will return the H3 index of the specified geographic point at the given resolution.