Functions to calculate area and perimeter

Why it matters

This feature provides users with built-in capabilities to compute the geometric properties of spatial data, such as the area and perimeter of shapes. It simplifies spatial data analysis and avoids the need for external tools by integrating these calculations directly into ClickHouse queries.

How to use it

Users can apply the new functions by calling area(geometry) and perimeter(geometry) within their SQL queries. For example:

SELECT area(geom) AS geom_area, perimeter(geom) AS geom_perimeter
FROM spatial_table
WHERE ...

where geom is a column of a geometry type.