1 / 15

A monitoring data summary tool

A monitoring data summary tool. Alan Williams 2008 GIS / Data Management Conference March 31 – April 3, 2008 Fort Collins, CO. Goal. Efficiently generate data summaries quick and easy consistent repeatable accurate using your live monitoring data. Challenges.

mariko
Download Presentation

A monitoring data summary tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A monitoring data summary tool Alan Williams2008 GIS / Data Management ConferenceMarch 31 – April 3, 2008 Fort Collins, CO

  2. Goal • Efficiently generate data summaries • quick and easy • consistent • repeatable • accurate • using your live monitoring data

  3. Challenges • There are many summary challenges with a large growing dataset. • Timely data summaries • When can we get it done? • Is it easy to do? • Consistent results year to year • Are the data summaries repeatable? • Can your replacement do them after you leave? • Can adjustments be made easily • Can summary calculations be easily checked? • Can edits, additions or subtractions be made?

  4. Approaches • Export data to a package for summary calculation and analysis • Excel, SAS, SYSTAT • Do summary calculations in your database • Use Queries and other database tools • Some combination of the two

  5. Our Strategy • Use tools in Access to calculate summary metrics in a sister summary database • Use a separate database to capture and define the database snapshot that the summary represents • Compartmentalize each metric calculation • Ensure calculations are done properly • Facilitate updates, additions, and edits • Document calculations and keep that and the means of calculation with the data

  6. Our Implementation • Define a standard input data format • Collaborate to design and document a set of queries that calculate a metric • Automate exporting metrics into a results table • Analyze, display and report with metrics from the results table

  7. Example Data Tables Summary Tables

  8. Automated Calculations • Re-run the calculations after significant data additions • Calculated metric output is “time stamped” to provide an audit trail

  9. Summary Viewer • Allows side-by-side comparisons of metrics

  10. Summary Reports • Provides detailed overview of metrics that can be exported to PDF for inclusion in a report.

  11. Summary Export and Analysis • Metrics then also available for export

  12. Collaborative effort Forest vegetation monitoring A number of networks in the east worked together during protocol development Despite similar approaches differences in protocols and database design exist Working to share development of some data summary tools Agree on common data transfer tables Develop lists of desired summaries

  13. Summary Tool Model 2) Calculation Queries 1) Transfer Table 4) Summary Queries & Tools 3)Results Table

  14. Advantages Summary tool features Standard input tables Compartmentalize each calculation Share work of query development Test datasets will be employed to test calculation accuracies Timestamp calculations to track errors and help with summary versioning

  15. Questions… • Alan Williams • Ecologist / Data Manager • Natural Resources - NCR • Shenandoah National Park • 3655 USHWY 211 E • Luray, VA 22835 • Phone:540-999-3431 • Email: Alan_Williams@nps.gov

More Related