
Analytics Toolbox for BigQuery
clustering
This module contains functions that perform clustering on geographies.
ST_CLUSTERKMEANS
Description
Takes a set of points and partition them into clusters using the k-mean. It uses the k-means algorithm. Returns an array of tuples with the cluster index for each of the input features and the input geometry.
geog
:ARRAY<GEOGRAPHY>
points to be clustered.numberOfClusters
:INT64
|NULL
numberOfClusters that will be generated. IfNULL
the default valueMath.sqrt(<NUMBER OF POINTS>/2)
is used.
Return type
ARRAY<STRUCT<cluster INT64, geom GEOGRAPHY>>
Example
|
|

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.