TIL: grouping spatial objects by their proximity to each other is solved by the “Density-based spatial clustering of applications with noise (DBSCAN)” algorithm.
https://en.wikipedia.org/wiki/DBSCAN
And thanks to PostGIS I could solve a difficult task today in a matter of minutes.
Thanks, #postgis #postgresql