Skip to main content
Computes spatial connected components across the entire dataframe using the ST_Overlaps predicate. Two geometries are in the same component if they overlap (share some but not all interior points, and are of the same dimension). Returns a component ID for each row. ST_OverlapsCC
  • geometry is the geometry column to analyze.
  • partitionBy is an optional column to partition the data before computing connected components. When provided, the spatial predicate is only evaluated between rows that share the same partition value. This can significantly improve performance on large datasets.

​
Signatures

ST_OverlapsCC(geometry: Geometry)

ST_OverlapsCC(geometry: Geometry, partitionBy: Column)

​
Parameters

​
geometry
Geometry
required
The input geometry.
​
partitionBy
Column
The partition by value.

​
Return type

The connected component ID for each row.

​
Example

SELECT ST_OverlapsCC(geom) FROM my_table

85899345920