I am trying to introduce some people to ArcGIS Maps for Office. When playing around with some test data, I noticed I was unable to aggregate my data by county, I am however able to aggregate the data by zip,state, and etc. Am I missing something there or did that data need to be transformed before hand before one computes it at the county level?
Example Columns:
Location Name | Location Description | City | State | County | Zip | Total_Collection | Latitude | Longitude | Dates Available |
Solved! Go to Solution.
Thank you Kyle, appears as if this may be a bug. I have reported this to our team and we will be investigating further.
Hi Kyle,
Thank you for your inquiry. I was able to aggregate counties but my guess is, I was able to accomplish this by adding data using Cell Range. See the steps below and the sample data I used!
1. Open excel & sign in
2. Add Map (Add data from Excel using the Data format Cell Range as default)
3. Click Select range
4. Highlight the selected data range
5. Location Type is States
6. Select Map Style by column
7. (I selected) Column B
8. Select Add data
OBJECTID | Counties | States | STATE_FIPS | CNTY_FIPS | FIPS | AREA | POP1990 | POP2000 | POP90_SQMI | Shape_Length | Shape_Area |
1 | Lake of the Woods | Minnesota | 27 | 077 | 27077 | 1784.063 | 4076 | 4651 | 2 | 4.05546 | 0.56545 |
2 | Ferry | Washington | 53 | 019 | 53019 | 2280.232 | 6295 | 7199 | 3 | 3.786161 | 0.718059 |
3 | Stevens | Washington | 53 | 065 | 53065 | 2529.979 | 30948 | 40652 | 12 | 4.876296 | 0.795486 |
4 | Okanogan | Washington | 53 | 047 | 53047 | 5306.18 | 33350 | 38640 | 6 | 6.673169 | 1.66911 |
5 | Pend Oreille | Washington | 53 | 051 | 53051 | 1445.029 | 8915 | 11752 | 6 | 3.101655 | 0.455726 |
6 | Boundary | Idaho | 16 | 021 | 16021 | 1279.299 | 8332 | 10068 | 7 | 2.943635 | 0.404983 |
7 | Lincoln | Montana | 30 | 053 | 30053 | 3746.091 | 17481 | 18859 | 5 | 5.308776 | 1.180135 |
8 | Flathead | Montana | 30 | 029 | 30029 | 5232.031 | 59218 | 73438 | 11 | 7.973459 | 1.642156 |
9 | Glacier | Montana | 30 | 035 | 30035 | 3124.457 | 12121 | 12626 | 4 | 5.221489 | 0.985039 |
10 | Toole | Montana | 30 | 101 | 30101 | 1943.26 | 5046 | 4556 | 3 | 3.356589 | 0.613868 |
11 | Liberty | Montana | 30 | 051 | 30051 | 1485.946 | 2295 | 2222 | 2 | 3.071839 | 0.468896 |
12 | Hill | Montana | 30 | 041 | 30041 | 2917.361 | 17654 | 16862 | 6 | 4.545181 | 0.920879 |
13 | Sheridan | Montana | 30 | 091 | 30091 | 1686.583 | 4732 | 4006 | 3 | 3.213947 | 0.533393 |
Please let me know if this was helpful!
Best,
Shannon | Product Engineer
Thank you for the response.
I have been able to achieve what you have shown above, but I am trying to do it at the county level within a single state.
Example:
Location Name | Location Description | County | State | Total_Collection | Dates Available |
Site 1 | 203 East US Highway 18 | Bennett | South Dakota | 62 | Nov. 16 - Dec. 1 |
Site 2 | Junction of US Hwy 85 and US Hwy 212 | Butte | South Dakota | 63 | Nov. 16 - Dec. 1 |
Site 3 | 801 1st Ave. E | Clark | South Dakota | 10 | Nov. 23 - Dec. 8 |
Site 4 | 99 S. Commercial St. | Clark | South Dakota | 22 | Nov. 23 - Dec. 8 |
Site 5 | 710 SD Hwy 28 | Clark | South Dakota | 5 | Nov. 23 - Dec. 8 |
Where with the above data I would be trying show the total collection for each county. Bennett would be 62, Butte 63, and Clark if sum aggregated it would be 37. Like I mentioned before I am able to get that function to work with every other location type, just not counties.
As you can see below, it will just stack the counties with out aggregating them.
The option below I am looking for; shown with zip code:
Thanks,
Kyle
Thank you Kyle, appears as if this may be a bug. I have reported this to our team and we will be investigating further.
Thank you for your assistance.