v.1.1.54292New Feature

Added pointInPolygon Function for Coordinate Operations

Added the pointInPolygon function for working with coordinates on a coordinate plane.
Added the pointInPolygon function to determine if a given point lies inside a polygon on a coordinate plane.

Why it matters

This feature was created to enable efficient spatial queries and geometric computations directly within ClickHouse. It solves the problem of determining point-in-polygon relationships, which is useful for geographic data analysis, location-based filtering, and spatial joins, enhancing the analytical capabilities and flexibility for users working with coordinate data.

How to use it

Use the pointInPolygon function by passing coordinates of the point and the polygon vertices. For example:

SELECT pointInPolygon(point, polygon) FROM table

where point is represented as a tuple or array of coordinates and polygon is an array of coordinate tuples representing the polygon vertices.