v.25.7New Feature
Add geospatial
Add the geospatial functionspolygonsIntersectCartesianandpolygonsIntersectSphericalto check if two polygons intersect. #81882 (Paul Lamb).
Why it matters
These functions solve the need for geometric intersection checks between polygons in spatial data analysis. They enable users to identify if two polygons overlap either in Cartesian coordinate space or on a spherical surface, enhancing spatial query capabilities in ClickHouse.How to use it
Use the functions by passing two polygon arguments as inputs. ChoosepolygonsIntersectCartesian for planar Cartesian coordinates or polygonsIntersectSpherical for geographic spherical coordinates. Both functions return a boolean indicating whether the polygons intersect.