Running clustering queries

[Max Pyziur]

Greetings,

I have a dataset of filling stations with point geometries (about 80k 
U.S. filling stations)

I'm trying to find/make clusters of this data (with a criteria like say 
minimum of 3 stations w/in 500 feet of each other.

I've found these webpages; but as yet I can't produce any sort of 
meaningful results.

I would appreciate any and all guidence. Thank you.

Max Pyziur
pyz at brama.com


##########
Webpages:
Examples Of Spatial Clustering With PostGIS - February 28, 2024
https://mapscaping.com/examples-of-spatial-clustering-with-postgis/

ST_ClusterDBSCAN
https://postgis.net/docs/ST_ClusterDBSCAN.html

PostGIS Clustering with DBSCAN | Crunchy Data Blog
https://www.crunchydata.com/blog/postgis-clustering-with-dbscan

clustering - PostGIS nest ST_ClusterKMeans on results of ST_ClusterKMeans 
- Geographic Information Systems Stack Exchange
https://gis.stackexchange.com/questions/396029/postgis-nest-st-clusterkmeans-on-results-of-st-clusterkmeans