Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using ArcGIS 10.1 for Desktop.

I have generated a table which has road segments which get inundated during different flood events. I want to be able to add a pie chart to the map which shows that during each flood ARI (1y, 2y, 5y, 10y, 20y, 50y and 100y) x% of the road network in the AOI gets inundated.

I tried the following:

enter image description here

and get

enter image description here

The table looks like

enter image description here

Is it possible for me to add python code for the chart to add all the 1y lengths and display that number only, 2y total lengths etc only so that you get a pie chart with just the 7 categories. I need to automate this as it needs to be run in several areas and some of the input data changes.

share|improve this question
I hope I understand your requirements correctly. You want one chart for all roads? Use [Sumarize] (…) to calculate the sum of the length for the field ARI. Use the new table to create your chart. – Jens Sep 19 '12 at 7:20
"The only worse design than a pie chart is several of them." Edward Tufte – radek Sep 19 '12 at 9:34
Thanks Jen -I need the sum for the 7 ARI categories individually. – GeorgeC Sep 19 '12 at 13:15
@radek, I love that quote. I can't stand pie charts and the constant misuse of them. – Fezter Aug 10 '15 at 0:46

If you perform a Dissolve command on your road data layer using the ARI field as the dissolve field it will create a new layer with one row for each unique value in the ARI field. You can the recalculate the length of each dissolved line and make the pie chart using the new layer.

share|improve this answer
Yes but the question was can it be done in the same dataset without having to create a new one. In excel you can use a function to sum a column where another column full fills a criteria -can the same be done in python? – GeorgeC Sep 19 '12 at 13:13

Use Summary Statistics to select each field (1y, 2y etc) and sum them individually. Do not select a Case field. Unfortunately this will create a new output feature class.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.