v.23.5New Feature

Geographical Data Types Production-Ready

Official CH changelog text
Geographical data types (Point, Ring, Polygon, and MultiPolygon) are production-ready. #50022 (Alexey Milovidov).
Production-ready support for geographical data types including Point, Ring, Polygon, and MultiPolygon in ClickHouse.

Why it matters

This feature provides native support for common geographical data types, enabling users to efficiently store, query, and analyze spatial data within ClickHouse. It solves the problem of managing geospatial information by offering robust and optimized data types tailored for geographical applications.

How to use it

Users can start leveraging these geographical data types by defining columns with types like Point, Ring, Polygon, or MultiPolygon in their tables. These types can then be used in INSERT, SELECT, and spatial queries directly.

Related resources

PreviousNext