Cluster comparisson

cluster_1.sql

SELECT
dbscan_cid,
st_union(geom) geom
FROM (
    SELECT
    ST_ClusterDBSCAN(geom, 0.23, 1) OVER () dbscan_cid,
    geom
    FROM gb_retailpoint
    ) kmeans GROUP BY dbscan_cid;

SELECT
kmeans_cid,
st_union(geom) geom
FROM (
    SELECT
    ST_ClusterKMeans(geom, 50) OVER () kmeans_cid,
    geom
    FROM gb_retailpoint
    ) kmeans GROUP BY kmeans_cid;