How to merge adjacent polygons to one which sum of attribute values is between 10000 and 20000000?

Question

That what I have is a huge number of polygons that contain attribute field representing the number of offices inside each polygon. I want to merge all adjacent polygons which sum of offices is between 10000 and 20000. I am using ArcGIS 10.4 and I have idea to use Dissolve tool, Integrate tool and Merge tool, but I am not sure about steps in order to solve this.

Probably some coding should be used here.

DanPatterson_Retired · Answer

Dissolve removes the boundaries between features based on the attributes,  there is no builtin way to constrain it further with a 'sum to within' option.  In fact adjacency checks for attributes are generally quite difficult.  This would be further complicated, if not impossible, if there were not gaps in the geometry, since dissolving on an attribute which appears in all polygons would effectively produce a large continuous polygon.

Perhaps an image of what you have might be useful.  In the interim, you could try selecting polygons below some threshold value, then aggregate those to larger units through dissolve.

JaredPilbeam2_0-1730227010773.png