So I have a database of lats/longs representing incidents occurring on or near roadways.
My goal is to identify the street block areas with the highest number of incidents in the database. I don't have any other map layers I'm using for this.
What I'd like to do is, for each point, see how many other points are a given defined distance away (a quarter of a mile, for instance). The result would then show where the clusters are.
Any recommendations on the best way to do this? I have copies of both QGIS (with the spatial query plugin) and ArcMap, although I'm much more familiar with QGIS.
Also, I should note that these are lat/longs for the entire country. Is there a best national coordinate system to use when measuring distances?
– Mike Jun 02 '14 at 14:31