umitanuki/kmeans-postgresql — Issue #4: Getting never more than 3 clusters, unless manual initial points were given.
Author: jonathanslenders
Created: 2011-12-29 15:40:15+00:00
State: open

Somehow, we get never more than 3 clusters. Except for a few points, all of them fall into a single cluster.

We are using postgis, using the following query:

SELECT id, kmeans(ARRAY[ ST_X(point), ST_Y(point)], 40) OVER () AS k, id, FROM our_table ORDER BY k DESC;

Is there any way to improve the initial choosen points?