Within ArcMap, I have a point dataset representing accident data, and a road dataset. My goal is to attribute the road dataset with a count of how many particular accidents occured on each road segment. I can't however figure out how to produce a count of point/line intersections. I have tried a spatial join using 'one to many', however this doesn't produce a count, just multiple lines for a road with more than one accident. I've also tried a intersect, however ArcMap has told me this is not possible.


Right click your road file, joins and relates > join.

Select join data from another layer based on spatial location in the first dropdown box.

Choose your point layer in the second dropdown box as the layer to join to the line layer.

Select "each line will be given a summary of the numeric attributes of the points that are" then select "intersected by it" below that.

Your new shapefile will have a "count" field added to it representing how many points intersect that line.

Join one to many

enter image description here


This post by ESRI helped me- It uses the example of polygons instead of points. I had buffered my accident points, as some were not quite intersecting the roads. If you are trying to do this with points then I would recommend doing the same. http://support.esri.com/technical-article/000008599

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.