I am working on a semester project for my GIS Programming and Customization course. I built a model that receives updated crime point data from the City of Denver as an input.
The sequence of tools that I have strung together in the model are as follows: Select Layer by Attributes (because I only want to use crime points that represent reports of domestic violence), Create Feature Class, Add Field (this is a numeric field named "Count"), and Calculate Field (populates all records with the value of 1).
Now I have a new feature class that consists of points where domestic violence crimes have been reported and each record is populated with the value of 1 in the "Count" field. I want to join this data to a separate polygon feature class (Census Neighborhood Demographics), so that my resulting polygon feature class ends up with a "Sum Count" field that represents the total number of domestic violence crimes that have been reported in that neighborhood.
I tried including the Spatial Join tool in my model in order to complete this step, but when I run the model (or try using the tool manually), my output polygon feature class still shows every record populated with the value of 1, rather than the sum of crime points.
I have done this whole process manually before, but by right-clicking on my target layer and choosing to join it to another layer based on spatial location. I noticed that this operation is called "Join Data". The dialog window is very different than that of the Spatial Join tool. I have tried searching for a tool called "Join Data", with no success.
Does anyone have any suggestion for how I can make my model do what I was able to do manually by right-clicking on my target layer and opening the "Join Data" tool? I am very open to using a snippet of Python script, but I am new to the programming language and am not sure how to accomplish my goal with code.
Any input is appreciated! Thanks in advance.