AnsweredAssumed Answered

Error in crash count while spatial joining with road segments

Question asked by msuesri on Apr 20, 2018
Latest reply on Apr 20, 2018 by msuesri

I am trying to join the crash data along segments and within 150 ft radius of intersections with the nearest segments. I am using Spatial Join, with roads layer, selecting "closest to it" option and "sum" as an answer to the question "How do you want the attributes to be summarized?", because I want the total count of crashes (both midblock and intersection) along each segment. Though the spatial join is successful, I am getting a wrong count of total crashes, and I can validate this by checking the crash data. In the joined data, the total count of crashes combining all segments is more than the total count of crashes in the crash data. This makes me think, probably, some crashes are getting counted more than once during the spatial join. Clearly, this method is not working. Please suggest if you have any other methodology for solving this issue, it does not have to be necessarily a spatial join. Thank you for your help.