Linked Questions

10
votes
1answer
4k views

Grouping map points into fixed cluster sizes?

I have a dataset of 655 lat/long pairs which I'd like to split into about 100 groups. A group should have 5-10 pairs which are geographically close to each other. Dense groups should have more ...
7
votes
2answers
3k views

How can I cluster all points in a postgis table together based on their distance from each other?

I have a PostGIS (in postgres 9.3) table which has Points. I want to figure out the "clusters" in the data. If 2 points are < X distance apart, they should be added to a cluster, and this should be ...
4
votes
2answers
3k views

Merge point features within a given radius [duplicate]

I have a file in QGIS with 5000 points. Some of the points are really close to each other (5m). How can I cluster the point features to one point feature if they are within 5m? The new points should ...
5
votes
4answers
3k views

How to merge close points into polygon?

I have a set of coordinates (points & no overlaps) in a single table,each containing attribute number fields,like in the following image. I want to merge these points into smallest polygons by ...
2
votes
1answer
2k views

Spatial clustering with PostGIS including attributes

Spatial clustering with PostGIS including attributes I have a points table with some attributes like : year, type, etc. And I'd like to do a points clustering in PostGIS. I followed the subject in ...
6
votes
3answers
839 views

Trying to combine nearby points into a polygon

We have collected millions of cell phone strength readings. I am trying to group points of the same strenght that are within a distance of each other in to a polygon. I asked on the postgis mailing ...
8
votes
2answers
978 views

What are my options for Server side clustering using open source GIS tools?

I need to make a webapp that will show over 40K Points on a map. These points are all across the globe. Using WFS Service and OpenLayers, it is possible to do clustering on small set of points, but ...
3
votes
1answer
2k views

Get a single cluster from cloud of points with specified maximum diameter in postgis

I have on the order of 2M Geometry Collections with N (median: 2, stddev: 6.6, 75th: 6, 95th: 21) Point objects (repeated points allowed and important) in a PostGIS table. I want to identify clusters ...
3
votes
1answer
1k views

Using PostGIS ST_ClusterWithin() on table?

I am using the postgis ST_ClusterWithin function to cluster my spatial data in a table. I want to get the rows of the table as a result of the query clustering query (maybe the Pk's of each element in ...
7
votes
1answer
1k views

How to include aggregate field values of clustered points

I am creating a map that has point features representing things like campgrounds, picnic areas, boat launches, etc. In cases where many points are clustered in an area (representing amenities for the ...
2
votes
1answer
436 views

How to select centroid of multiple nearby points with same attribute

This question is very similar to #131823, that is not solved yet. I want to merge several points like bus stops into one single point in the centroid of all selected points. The bus stops have a ...
1
vote
1answer
761 views

Clustering 40k+ points from shapefile and populating Google Maps/Webapp?

I just started a new Python/Django webapp job related to GIS (and i'm totally new to GIS). Here is my task and what i have found so far, and i am stuck as to finding out what's the best way or the ...
3
votes
2answers
693 views

Limit radius of ST_Clusterwithin (PostGIS)

I have a set of over 800k points and I am looking to cluster them within specified circle radius. I need them to be clustered to maximise the number of points within the circle. This is to model how ...
2
votes
2answers
478 views

Excluding nearest points from the SQL query result by distance in Postgis?

I have a PostGIS 2.4 database with the table that contains more than 300 000 Point features (with big density on the map on high zooms like 10-12 if you will draw them). So I need to query that table ...
1
vote
0answers
688 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...

15 30 50 per page