Hello,
I have a feature class with polygons that can overlap in some cases. I'd like to merge the intersecting polygons into one geometry (but not all the geometries into one) and then sum a field of these merging geometries.
I've tried using the “Pairwise Dissolve” tool, which does a good job of merging my geometries, but in terms of statistical calculation, the sum is based on the entire feature class and not just the intersecting geometries. Is there a way to do this?
Thanks
Solved! Go to Solution.
So I tested this workflow and I "think" it will get you where you need to be.
1. Add a new field (Float or Double) called SUM_AREA or whatever you'd prefer to call it.
2. Calculate geometry of the new SUM_AREA field to get the square area of each polygon.
3. Add a second new field (Short) called ID or whatever you'd prefer to call it.
4. Select all the polygons that touch or intersect with each other and calculate the ID field with1, 2, 3, 4, etc.
5. Run the Pairwise Dissolve GP tool with the Dissolve Field being ID and the Statistics Field being the SUM_AREA field with SUM as the statistic type.
6. A new feature class is created with total sum by ID areas.
I believe this will give you the output you're looking for. Let me know if you have additional questions!
Perhaps you can illustrate what you want to see in the table?
If those are multipart shapes, can you use a MultipartToSinglePart tool on the result, then use a Spatial join of the original data back to that.
Of course, here's an example of my attribute table. Each line corresponds to a geometry.
And after the merge, the sum was done on the whole table, not just the intersecting geometries.
So I tested this workflow and I "think" it will get you where you need to be.
1. Add a new field (Float or Double) called SUM_AREA or whatever you'd prefer to call it.
2. Calculate geometry of the new SUM_AREA field to get the square area of each polygon.
3. Add a second new field (Short) called ID or whatever you'd prefer to call it.
4. Select all the polygons that touch or intersect with each other and calculate the ID field with1, 2, 3, 4, etc.
5. Run the Pairwise Dissolve GP tool with the Dissolve Field being ID and the Statistics Field being the SUM_AREA field with SUM as the statistic type.
6. A new feature class is created with total sum by ID areas.
I believe this will give you the output you're looking for. Let me know if you have additional questions!
Thank you very much, it worked well on my example.