I am finding it difficult to get a solution to my problem.
I have about 2,000 geocoded locations. Some points are less than 10 miles away from each other and so I would like to cluster these points and then plot a route using clustered locations (makes routing look cleaner).
I tried the Integrate tool and set tolerance to 25 miles but it does not retain information of all points (doesnt sum up fields in the feature class just displays the center point of the integral)
I downloaded the R tool but couldnt get it to work. Also looked into Buffer tool but again it did not sum up the individual fields within the buffer just drew circles around each point.
Can anyone help? The goal is to get my 2000 pts to about 200 by specifying that if a group of points are 25 miles away from each they count as 1, their individual fields should thus be summed up since it is like an aggregate of the points. Thanks.
However, I was able to find a work around when working with a smaller dataset. first, duplicated your geocoded points by exporting them as a shapefile. Working with your new shapefile, use the integrate tool and specify the distance (miles or meters). This would generate a new integrated shapefile with fewer points (each point at the epicenter based on your distance criteria) you then manually copy the integrated points to an excel sheet using the identify tool and clicking on each integrated shapefile.\
Like I said this only works on very small datasets. Since it gets very rigorous.
Still waiting for a smarter way of doing this. Hope it helps.
After you use the Integrate tool you will get the centres of the clusters that you want, am I correct? When you have these, make a buffer of 25 miles around them. Then in model builder make model which selects all points within the buffer and gives them the number of the buffer (say OID) in a new field say 'Bufferaloc", after that all your geocodedpoints will have a field which contains the number of the buffer that they are into. After that just Dissolve based on that field and you will be able to retain attributes. Just an idea... Ivan