Skip to main content
Assign a connected component id to each geometry based on the ST_Contains predicate. Two geometries are in the same component if they are connected through any chain of geometries where one contains another. SQL reference: ST_ContainsCC

Signature

Parameters

ColumnOrName
required
Geometry column or name.
Optional[ColumnOrName]
default:"None"
Optional column to partition by before computing components.

Returns

Column
A long indicating the connected component id.