I am working with land parcel data and Arcmap 10.1. Each land parcel has a code (1,2,3,4) depending on the type of water supply source that it uses. I am trying to take a tally of each code within each census tract. I've been able to devise a very primitive method to do this:
- Load parcel layer (points) and census tract layer (shapes)
- Select one census tract, and use "Selection by Location" to select all parcels that fall within the census tract.
- Open attributes table
- Copy and paste into Excel
- Use Excel to get the sum
There are around 4000 census tracts, and I would have to do this for every parcel. I then tried spatial join. However, there are too many data points for the computer to handle.
Once I can get a spatial join, then it would be very simple. I have other data that is much more manageable, and I tried spatial join and tallying up the data by forming a new field on the attributes table, and it worked.
The main problem is that spatial join is taking way too long.