https://community.esri.com/t5/arcgis-dashboards-questions/help-using-spatial-join-tool/m-p/1411280#M9432 <P>I'm trying to use the spatial join tool to determine "crime" that happens closest to police stations, using ArcGis pro. I have 2 separate attribute tables, one for crimes in a region with fields: address, district, Offense (from a list of 3 types)- the other is for police stations with fields: address, city, state.</P><P>the question for the problem set is to determine the number of crimes committed closest to each police station and generate a table with the number of crimes for each station.</P><P>So, I'm using the spatial join tool where TARGET features are the police stations, where JOIN features are the crimes. I'm using a one-to-one operation type, with Closest as my match option. My thought to solve this was the generate a new output field that used the count merge rule to sum the offense field. It returns a value of 1 for each police station. Clearly I'm not asking the tool to give me the analysis that I want, and I'm not sure how to fix this.</P><P>any help greatly appreciated.</P> Wed, 17 Apr 2024 22:37:29 GMT f1aret 2024-04-17T22:37:29Z https://community.esri.com/t5/arcgis-dashboards-questions/help-using-spatial-join-tool/m-p/1411280#M9432 <P>I'm trying to use the spatial join tool to determine "crime" that happens closest to police stations, using ArcGis pro. I have 2 separate attribute tables, one for crimes in a region with fields: address, district, Offense (from a list of 3 types)- the other is for police stations with fields: address, city, state.</P><P>the question for the problem set is to determine the number of crimes committed closest to each police station and generate a table with the number of crimes for each station.</P><P>So, I'm using the spatial join tool where TARGET features are the police stations, where JOIN features are the crimes. I'm using a one-to-one operation type, with Closest as my match option. My thought to solve this was the generate a new output field that used the count merge rule to sum the offense field. It returns a value of 1 for each police station. Clearly I'm not asking the tool to give me the analysis that I want, and I'm not sure how to fix this.</P><P>any help greatly appreciated.</P> Wed, 17 Apr 2024 22:37:29 GMT https://community.esri.com/t5/arcgis-dashboards-questions/help-using-spatial-join-tool/m-p/1411280#M9432 f1aret 2024-04-17T22:37:29Z