v.21.11New Features

Implements h3ToGeoBoundary function by Ivan Veselov

Implements the h3ToGeoBoundary function. #28952 (Ivan Veselov).
Introduces the h3ToGeoBoundary function to ClickHouse, enabling extraction of geographical boundaries from H3 hexagon indexes.

Why it matters

This feature allows users to convert H3 hexagon indexes into their corresponding geographic polygon boundaries, facilitating spatial analysis and visualization of geospatial data stored in the H3 format within ClickHouse.

How to use it

Use the h3ToGeoBoundary function in your queries by passing an H3 index as input to retrieve the geographic boundary polygon. For example:

SELECT h3ToGeoBoundary(h3_index) FROM table_name;