I have a file geodatabase named ElectionData2012.gdb containing two feature classes:
- Counties: The feature data for California counties
PrecinctVotingData: Feature data for California precincts for the 2012 election. Has two relevant attributes:
a. total_votes: a field containing the total number of individuals who voted in the precinct
b. proposition_37_yes_votes: a field containing the number of individuals that voted for the measure in the precinct
I want to conduct my analysis and aggregate the precinct total votes and yes vote data up to the county level. To complete this I used spatial join tool:
- target feature: county
- join feature: PrecinctVotingData
And for the merge rule I used sum for the total and the yes votes but the total votes in the original shapefile and the spatial join layer are not the same cause some of the precinct lines cross the county lines.
How can I clean this up if I want to get the total value from all of the precincts attached to the counties correct.
I use ArcGIS 10.3