topic Spatial join more time effeciently? in Data Management Questions https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62666#M3644 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff;">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?&nbsp;</SPAN></P></BODY></HTML> Mon, 15 Aug 2016 11:17:15 GMT BachirHamadeh 2016-08-15T11:17:15Z Spatial join more time effeciently? https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62666#M3644 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff;">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?&nbsp;</SPAN></P></BODY></HTML> Mon, 15 Aug 2016 11:17:15 GMT https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62666#M3644 BachirHamadeh 2016-08-15T11:17:15Z Re: Spatial join more time effeciently? https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62667#M3645 <HTML><HEAD></HEAD><BODY><P>Well 2million join to&nbsp;100k is quite&nbsp;a lot, but I wouldn't think it would take weeks to process.</P><P>Is your data properly indexed, in a local fgdb etc etc.</P><P>Have you tried using the Spatial Join tool rather than the interface inside ArcMap.</P></BODY></HTML> Mon, 15 Aug 2016 12:01:45 GMT https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62667#M3645 NeilAyres 2016-08-15T12:01:45Z Re: Spatial join more time effeciently? https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62668#M3646 <HTML><HEAD></HEAD><BODY><P>It is &nbsp;properly indexed and is a fgdb. Thing is am not just just figuring out how many points are there in a road segment. But the point has a table attribute with 12 fields that am actually joining to the segments. Maybe thats why it is taking too long.</P></BODY></HTML> Tue, 16 Aug 2016 01:20:22 GMT https://community.esri.com/t5/data-management-questions/spatial-join-more-time-effeciently/m-p/62668#M3646 BachirHamadeh 2016-08-16T01:20:22Z