ST_DWithin predicate. Two geometries are in the same component if they are within the specified distance of each other. Returns a component ID for each row.
geometryis the geometry column to analyze.distanceis the maximum distance threshold for considering two geometries as connected.useSpheroidis whether to use a spheroidal distance calculation (default: false).partitionByis 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. WherobotsDB compares every pair of rows that share a value, so the work for each value grows with the square of its row count. To keep a few large groups apart, filter the data to one group at a time and call the function withoutpartitionBy. Component IDs from separate calls can repeat, so keep the group column with the component ID when you combine the results.
Signatures
Parameters
Return type
The connected component ID for each row.

