Data Driven Charts and Summary Reports

1091
4
09-08-2011 09:43 AM
Status: Open
Labels (1)
PhilHolleran
Occasional Contributor

 

ArcGIS 10’s Data Driven Pages functionality greatly improved the creation of mapbooks by allowing a reference layer to determine the extent and scale of the map.  It would be nice to see this functionality expanded into charts and summary reports.
 

This could be done by allowing the active feature in the reference layer to serve as the basis of a “select by location” statement to create a dynamic “selection layer” in the map document.  This selection layer would then drive dynamic charts and summary reports which could be added to the page.  The end result would be a page with a map, a chart, and a summary report.  
 

For instance, the reference layer could be pressure zones within a water distribution system.  The "selection layer" would be configured to select all water mains within the active pressure zone.  Each page would have:
 

  - a reference map for the pressure zone, 

  - a pie chart summarizing the condition of the water mains in the zone (driven by the “selection layer”), and 

  - some summary statistics about the mains in the zone (also driven by the “selection layer”).
 

Combined with ArcPy scripting, this functionality could be used to regularly generate executive reports on assets maintained within the geodatabase - allowing for spatially-enabled reporting.

 

 

4 Comments
ChrisMathers
This seems like it would make an export take a very long time due to processing to make the selection and then the graphs. Besides that I love this idea. It would be awesome to see a DDP with dynamic graphs.
ChrisFox
At 10.1 with the new function ExportReport you will be able to create a dynamic map series with an accompaning report. By using the dataset option "Extent" you can automate the process of for each map extent creating a report specific to the features within the extent. This will get you part of the way, but I definetly see the value in having dynamic graphing capabilities as well.
HaydenLewis
Dear santa.....
HalilCakir
Excellent idea.. I do not understand why this capability is not there already....