Accepted Solutions
Hi Dan,
Great news, Esri tech support found a solution to this problem!
First, run the Intersect tool between parcels and zoning, in order to divide the zoning polygons that extend beyond a given parcel's boundaries. The Shape_Area field will automatically be recalculated for the feature class output by the Intersect tool, but you can confirm the area is correct by creating a new field and using the Calculate Geometry tool.
Next, set the Summarize Within tool to summarize the Shape_Area field of the output of the Intersect using the parameters in the image below:
Finally, export features from the output (right-click on output of Summarize Within tool in Contents > Data >Export Features) using the expression below (I arbitrarily selected 0.01 for the ratio of summarized zone area to parcel area to account for multipart parcels but this can be modified as desired. The original test used 0.5 in the screen shot, but a lot of parcels will get omitted with such a large cutoff.)
This creates an almost perfect match between parcel and zoning. This procedure can be used in many other situations where you are looking for a match of area of largest overlap.
Hi Dan,
How could a query be done for the largest area using this method? I have tried this with my dataset and unfortunately I can't get it to work. I'm trying to select from among a parcel dataset with over 200,000 items those which most overlap with another dataset of zoning polygons (containing hundreds of items) whose shapes don't always match or coincide. I've tried running Count Overlapping Features, which takes a long time to run, and also spit out the table with the original OID's. The Count_FC of 2 is what I need. No matter what joining method I use, I cannot then perform a selection on the parcels with the join--somewhere in the process, ArcGIS Pro freezes up just trying to do the work and it doesn't happen. But even if I get it to work, this would be just picking any parcels that have any kind of intersection with the other layer, not necessarily the largest overlap.
Select by Location "Have their center in" is the best closest approximation to what I'm looking for, but unfortunately when the parcel shape and the zoning shape are very different, the appropriate associated parcel will get missed.
Parcels are black, and zoning is green in this example, where the parcels that are most appropriate to be selected don't have their centre in the zoning:
If I just use "Intersect", parcels intersecting the borders of the zoning polygon get chosen in addition as the appropriate parcels, which are not relevant at all and are unwanted.
Trying to remove the unwanted polygons from the selection one by one is very time-consuming, imperfect, and inefficient. I would love to know if there's a process to just get the parcels that are affected by the zoning polygons, no less, and no more, using geoprocessing.
I've also tried using the Spatial Join - Largest Overlap tool, but I'm getting a runtime error and the script won't complete:
What can I do?
Ok, so I created an "Intersect" subset of parcels intersecting zoning and made a new feature class, which made the file size manageable (3700 features).
I then used Count Overlapping Features with the table option, and selected a subset where Count_FC is 2. I joined the table to the Overlapping Features output and made a new feature class. Then I joined this using Original OID to the OID of the Intersect subset. Using joined features, this seemed to help reduce the amount of parcels selected and include funny-shaped polygons whose centres aren't in the zoning polygons. But I still have the edge polygons to get rid of from my subset.
Selected parcels are in the pale green.
What do I do from here to eliminate them? It still goes back to the original problem: I only wanted parcels who share the largest overlap with the zoning.
P.S. - I tried a subset of 2100 items to run the Largest Overlap tool, and this did not prevent the runtime error, so this error is something else most likely.
Hi Dan,
Great news, Esri tech support found a solution to this problem!
First, run the Intersect tool between parcels and zoning, in order to divide the zoning polygons that extend beyond a given parcel's boundaries. The Shape_Area field will automatically be recalculated for the feature class output by the Intersect tool, but you can confirm the area is correct by creating a new field and using the Calculate Geometry tool.
Next, set the Summarize Within tool to summarize the Shape_Area field of the output of the Intersect using the parameters in the image below:
Finally, export features from the output (right-click on output of Summarize Within tool in Contents > Data >Export Features) using the expression below (I arbitrarily selected 0.01 for the ratio of summarized zone area to parcel area to account for multipart parcels but this can be modified as desired. The original test used 0.5 in the screen shot, but a lot of parcels will get omitted with such a large cutoff.)
This creates an almost perfect match between parcel and zoning. This procedure can be used in many other situations where you are looking for a match of area of largest overlap.
