AnsweredAssumed Answered

Spatial join more time effeciently?

Question asked by Jakesully1990 on Aug 15, 2016
Latest reply on Aug 15, 2016 by Jakesully1990

I have over two million crashes located as points through GPS coordinates in the state of Pennsylvania. I also have over a hundread thousand road segments in the state and would like to know the number of crashes per segment. I am right clicking the segment feature class and using join with the point feature class and choisibg summarize sum to do this. I did the analysis on a single county and it worked except when i extrapolated the time to do this for the entire state, i came out with several several weeks with non-stop processing. Is there any way I can process this faster without reducing the number of segments i am merging the crashes to? 

Outcomes