I have a shapefile of census tracts and another shapefile of "neighborhoods" with values that I need to have joined to the census tracts. I know I need to apportion the area of the neighborhood shapefile to the census tracts (the neighborhoods are larger than the census tracts and I ultimately need the data by census tract) and then allocate the number of properties that paid property taxes in the neighborhoods to the census tracts proportionately. Hopefully I don't have that backwards.
Any suggestions?
Best Answer
What you're trying to do is known as apportionment. This takes a numerical attribute value of a feature and divides it in some way between pieces that feature is split into. There are a number of different solutions. In fact, there's a specific tool for it in the Business Analyst extension, but you probably don't have that. Esri has also published a presentation outlining three different apportionment methods using core functionality (ie, no extensions required). There's also an Esri Blog entry on splitting polygons, and while it uses lines and polygons rather than polygons and polygons as you have, the principle is the same.
The basic solution is you're going to want to use Make Feature Layer on the polygons you want to apportion and be sure to set a Use Ratio Policy on any fields you want to apportion. This allows the use of Split (and Merge) Policies when running Overlay tools like Identity or Intersect. Once you've enabled that, when you run the desired overlay tool using the feature layer as an input, it will divide the field value between the created pieces based on their area ratios. The blog post linked above gives a much more thorough and step-by-step explanation.
Note you can apportion different ways, and what's described above is by area. This may or may not work well for what you're trying to do depending on boundaries. For example if you divide up a county into parts and apportion them equally by area, that's not a very accurate population distribution since you know population is going to be concentrated in and around cities, not evenly dispersed across the entire county.
I should point out you may have several steps here. If your neighborhoods are bigger than census tracts, you may first need to apportion your tracts and then dissolve that result (aggregate) with sum statistics to get a single value for your neighborhoods. Without a clear picture of your data, it's hard to say exactly what your workflow will be.
I don't really have a convenient dataset to test this out with, so it may not work exactly as advertised.
I understand you have neighborhoods with a numeric attribute field that is paid tax count. You want that count divided up among tracts, which are typically but not always smaller than neighborhoods. This means a tract may need to pull from multiple neighborhoods to get a total.
Again, be aware this method apportions by area - if you have a concentration of small properties in one corner of a neighborhood and the rest are large but it's being split evenly to two tracts, both tracts will get an equal count.