v.25.7New Feature

Add a function to write Geo types

Official CH changelog text
Add a function to write Geo types into WKB format. #82935 (Konstantin Vedernikov).
Introduces a new function in ClickHouse to serialize Geo types into the Well-Known Binary (WKB) format.

Why it matters

This feature enables efficient binary representation of geographic data types, facilitating interoperability with other GIS systems and improving storage and transmission efficiency compared to textual formats.

How to use it

Use the new serialization function on Geo data columns or expressions to convert them into WKB format. For example, apply the function in a SELECT statement to output WKB-encoded geographic data.

Related resources

PreviousNext