Skip to main content
Performs a DBSCAN clustering across the entire dataframe. Returns a struct containing the cluster ID and a boolean indicating if the record is a core point in the cluster.
  • epsilon is the maximum distance between two points for them to be considered as part of the same cluster.
  • minPoints is the minimum number of neighbors a single record must have to form a cluster.
  • useSpheroid is whether to use ST_DistanceSpheroid or ST_Distance as the distance metric.
ST_DBSCAN

​
Signatures

ST_DBSCAN(geom: Geometry, epsilon: Double, minPoints: Integer, useSpheroid: Boolean)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
epsilon
Double
required
The maximum distance between two points to be considered in the same cluster.
​
minPoints
Integer
required
The minimum number of points to form a cluster.
​
useSpheroid
Boolean
required
Whether to use spheroidal distance calculation.

​
Return type

A struct containing the result fields.

​
Example

SELECT ST_DBSCAN(geom, 1.0, 2, False)

{true, 85899345920}