topic Re: Create Sum of Fields from Multiple Layers in ArcGIS Pro Questions

Create Sum of Fields from Multiple Layers

TSmoothC — Wed, 17 Apr 2024 13:48:28 GMT

Hello,

I'm trying to figure out how to create a new layer that reflects the sum of one field from each of the underlying layers.

For example, consider three overlapping circular polygons (each circular polygon is a different layer with the an identically names field VALUE). The first circular polygon has a VALUE of 1, the second circular polygon has a VALUE of 2, and the third circular polygon has a VALUE of 3.

I'm trying to create a new layer that sums the VALUE field from the underlying circular polygons and brings those values to the surface (please see attached image for what I want this new layer to look like.

What tool can I use to accomplish this task? I'm sorry if this is a simple question... Thank you for your time!

Re: Create Sum of Fields from Multiple Layers

Robert_LeClair — Wed, 17 Apr 2024 21:37:46 GMT

I'm thinking a Spatial Join (Analysis) GP tool with a SUM Field Map parameter will do the job here!

Re: Create Sum of Fields from Multiple Layers

Dale_Honeycutt — Wed, 17 Apr 2024 23:13:01 GMT

Use the Union tool with your three layers as input. Using your example of 3 simple layers, the output of Union will be 7 polygons which is what you need to sum your attributes.

To demonstrate, I made three feature classes, Circle1, Circle2, and Circle3 that look like your example. Each of these feature classes has a field Stuff (integer) which I used to label the 3 layers shown below.

Below is the attribute table that is the result of Union (I called the output Venn). The FID_Circle1 column is the OBJECTID of the Circle1 layer, FID_Circle2 is the OBJECTID of the Circle2 layer, and so forth.

The attribute table of Venn has 3 fields named 'Stuff' that is actually the alias name of the field... if you open the Fields View found while viewing the attribute table, you'll see that their actual field name is Stuff, Stuff1, and Stuff12. It's just Pro's way of uniquely identifying duplicate field names.

Here's the Field View of Venn

I added the SumOfStuff field using the Add Field tool, then used the Calculate Field tool with this expression:

I just clicked the 3 different 'Stuff' fields in the list and it populates the expression with the real field name..(Kinda confusing, right?)

Here's the result, labeled by SumOfStuff