Aggregate totals in a Zip Code data set by State

3313
2
Jump to solution
09-15-2014 12:17 PM
DavidEvans2
New Contributor II

To all the Problem solvers out there:

I have a data set that provides a total number of contributions broken down by zip code for a certain month e.g. total contributions in Zip Code 10001 in August might be $400, while 10002 is $0 etc…

I would like to determine the sum of these contributions by State. My zip code layer contains a field that identifies the State that the zip code is located in, so I can easily use the Select by Attributes builder and the Statistics function within the Attribute table to create a selection and then determine the total for each state, however, I’m sure there must be a smarter way then having to perform the same set of operations 50 times over (Using Model Builder perhaps?).

I’d appreciate any advice on how to achieve this, there may be a specific tool in the ArcToolBox that do exactly what I need which I am overlooking.

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
RiyasDeen
Regular Contributor

Hi David,

What you need is summary statistics ArcGIS Desktop .

In Table: your dataset

Out table: Specify a table to be created

statistics_fields: Your contribution field, with statistics type sum

Case Field: your state code column.

You summary will come out grouped by state code in the output table.

View solution in original post

2 Replies
RiyasDeen
Regular Contributor

Hi David,

What you need is summary statistics ArcGIS Desktop .

In Table: your dataset

Out table: Specify a table to be created

statistics_fields: Your contribution field, with statistics type sum

Case Field: your state code column.

You summary will come out grouped by state code in the output table.

View solution in original post

DavidEvans2
New Contributor II

Thank you Riyas! Your solution does exactly what I needed. The output is a table, but I can easily join that back to another shapefile to visualize the output.You are a star!

0 Kudos