Convert coordinates to H3 cells, traverse the hexagonal grid, and run spatial aggregations directly in SQL. H3 min/max statistics let the query planner skip irrelevant Parquet files on large tables.
Indexing, traversal, and spatial predicates without leaving the query
Convert coordinates into H3 cells, then group, count, and join by cell. Sixteen resolutions span continent-scale buckets down to sub-meter precision.
Find neighbors, draw rings and disks, walk paths between cells, and move up or down the resolution hierarchy. Hex topology is built in, not bolted on.
PostGIS-style functions for distance, containment, area, centroid, and buffer. Existing spatial SQL ports across with minimal change.
Spatial queries on large tables only read the files that matter
Each Parquet file records the H3 cell range of its rows. Spatial predicates let the planner drop any file whose range does not intersect the query region.
Cell equality, parent and child containment, and distance filters. Composes with Delta partitioning and Z-ordering on the same table.
H3 indexing and spatial functions built into the SQL engine.