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:

1. Load parcel layer (points) and census tract layer (shapes)
2. Select one census tract, and use "Selection by Location" to select all parcels that fall within the census tract.
3. Open attributes table
4. Copy and paste into Excel
5. 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.

Thank you

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:

1. Load parcel layer (points) and census tract layer (shapes)
2. Select one census tract, and use "Selection by Location" to select all parcels that fall within the census tract.
3. Open attributes table
4. Copy and paste into Excel
5. 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.