Summarizing Union Fields

1186
1
Jump to solution
10-06-2016 09:12 AM
Labels (1)
StephenCoppola
New Contributor III

Good Afternoon ESRI Community,

My challenge is we need to sum several fields which come from a resultant Union operation.  There could 50+ fields that we need to sum, so the Field Calculator interface can be cumbersome. Our team is new to ArcPy, any suggestions on how to collect the fields of interest and then add their values to a new "total" field would be much appreciated.   Also, a solution that can be integrated into Model Builder would also be helpful.

Thank you for your time and help.

Very Respectfully,

scop_sts 

0 Kudos
1 Solution

Accepted Solutions
DarrenWiens2
MVP Honored Contributor

You don't need to use Arcpy (but you certainly can). You could use either Summary Statistics or Dissolve, setting the statistics fields to your 50+ fields and statistics type to SUM for all. You can do this manually through the interface, or build a list for Python ([[field1, 'SUM'],[field2,'SUM']...]) by looping through the output of ListFields.

View solution in original post

1 Reply
DarrenWiens2
MVP Honored Contributor

You don't need to use Arcpy (but you certainly can). You could use either Summary Statistics or Dissolve, setting the statistics fields to your 50+ fields and statistics type to SUM for all. You can do this manually through the interface, or build a list for Python ([[field1, 'SUM'],[field2,'SUM']...]) by looping through the output of ListFields.