I have one table which has a large number of points in the column(name as geom). I want to get all those points that are in close proximity to 10 meters. Not close to the specific point but the clusters of points in close proximity to each other. What will be the query of PostGIS for this?
Asked
Active
Viewed 18 times
0
-
Welcome to StackOverflow! Are you looking to points in proximity of a specific point or do you want to find all clusters of points in close proximity to each other? – Dima Chubarov Apr 26 '22 at 15:05
-
All clusters of the points – Israr ul haq Apr 26 '22 at 15:15
-
So this is a question about spatial clustering, not a question about distance calculations. I vote to reopen the question. I suggest the author edit the question to clarify it. – Dima Chubarov Apr 26 '22 at 15:35
-
Postgis has several clustering algorithms implemented. For example loot at the DBSCAN implementation https://postgis.net/docs/ST_ClusterDBSCAN.html – Dima Chubarov Apr 26 '22 at 15:47