Vital Signs Water Quality Data Management: NPSTORET and STORET EDD

1. Vital Signs Water Quality Data Management: NPSTORET and STORET EDD Cabrillo National Monument, CA National Park Service by Dean Tucker Water Resources Division Fort Collins, CO San Diego "Meeting of the Networks"

2. Lassen Volcanic National Park, CA Vital Signs WQ Data Mgt • Vital Signs/Natural Resource Challenge WQ Data • What/Why STORET? • NPS Vital Signs WQ Data Flow • NPSTORET • STORET EDD San Diego "Meeting of the Networks"

3. Vital Signs WQ Data Mgt Physical Chemical Other Biological

4. What is STORET? EPA Database for Ambient Water Quality and Biological Data San Diego "Meeting of the Networks"

5. What is STORET? • STOrage and RETrieval • Began in DOI in 1964 Legacy STORET • 1 Million (plus) Sites • 200 Million (plus) Observations San Diego "Meeting of the Networks"

6. What is STORET? • State Environmental & Health Organizations • Other Federal Agencies (National Park Service) • Citizen Volunteers • Watershed Managers Clean Water Act 305(b) Assessments 303(d) Lists • 303(d) Impaired • Blue Creek • Badwater Spring • Poison Lake • Dirty Lagoon

7. NPS Data in STORET • 17,477 Sites • 2,543,143 Obs. • 2,206 Parameters • 191 NPS Units San Diego "Meeting of the Networks" Olympic National Park, WA

8. What is STORET? NPS data was here Now it is here December 2004 Old STORET STORET Legacy Data Center New STORET http://www.epa.gov/storet

9. What is STORET? • Data of Documented Quality • Oracle Database • Data Standards for Data Sharing (ITIS, EPA) • Locally Owned and Operated • EPA Maintained • Public Read-Only Access to EPA Data Warehouse San Diego "Meeting of the Networks"

10. What is STORET? • Sample Media • Air • Bottom Sediment • Soil • Water • Biological • Individual • Subject Taxa • Tissue • Subject Taxa • Bio- Part • Species Abundance • Aquatic Vegetation • Terrestrial Plants • Benthic Macroinverts • Birds • Reptiles • Amphibians • Bacteria/Viral • Phytoplankton/Zooplankton • Fish/Nekton Medium Intent Community

11. What is STORET? Sample Types • Routine • Field Replicate • Depletion Replicate • Created from Sample • Composite - with Parents • Sample from Sample • Composite- W/O Parents • Integrated Time Series • Integrated Flow Proportioned • Integrated Horizontal Profile • Integrated Vertical Profile • Field Measurement/ • Observation Types • Replicate Measurement • Habitat Evaluation • Observation • Measurement San Diego "Meeting of the Networks"

12. What is STORET? Organization Programs Projects Stations Metadata Trips Data Loggers Collection Procedures Gear Configurations Handling Procedures Analytical Procedures Lab Sample Prep. Procedures Characteristics Laboratory Info Staff/Personnel Citations QA/QC Station Visits Op. Periods Monitoring Activities Results

13. Redwoods NP, CA Why STORET? • Under the Clean Water Act, states are responsible for developing and enforcing water quality standards on all lands within their boundary. • Approximately 80% of states used legacy STORET. • With few exceptions, most states now use new STORET. San Diego "Meeting of the Networks"

14. Stations in STORET as of 1/25/2006 237,136 Stations in STORET National Data Warehouse San Diego "Meeting of the Networks"

15. Why STORET? • Robust, full-featured, well-supported database • NPS runs its copy of STORET; EPA runs the National Data Warehouse • Public can access data at: http://www.epa.gov/storet San Diego "Meeting of the Networks"

16. Why STORET? • Complies with ITFM and NWQMC metadata recommendations • NPS-77 states that the NPS should provide water quality monitoring data to STORET • NPS has made a significant investment in old STORET with 2.5 million obs. at 17,477 stations for 191 parks San Diego "Meeting of the Networks"

17. Vital Signs WQ Data Flow Shenandoah NP, VA Network Responsibilities: • Enter data into NPSTORET or STORET Electronic Data Deliverable (EDD) format; • Transmit data files along with QAPP, SOP, and any other relevant documentation to WRD at least annually; • Assist WRD as necessary in answering questions and QAing the data; and • Incorporate QA/QC changes

18. Vital Signs WQ Data Flow WRD Responsibilities: • Develop and maintain NPSTORET and STORET EDD; • Assist Networks in configuring and using NPSTORET and NPSEDD; • Receive data files along with QAPP, SOP, and any other relevant documentation from Networks at least annually; • QA/QC the data files and return edits to Network; • Use SIM and other tools to upload the data into the NPS’ copy of STORET;

19. Vital Signs WQ Data Flow http://www.nature.nps.gov/water/infoanddata/index.htm San Diego "Meeting of the Networks"

20. Virgin Islands National Park, VI NPSTORET • Microsoft Access-based • N.R. Database Template for Water Quality • Tailored to serve STORET San Diego "Meeting of the Networks"

21. NPSTORET Tour San Diego "Meeting of the Networks"

22. Haleakala NP, HI NPSTORET Version 1.00 • Import Stations and Results from Legacy STORET and the U.S. Geological Survey’s NWIS system (including automatic characteristic creation) • Develop a customizable NPSTORET installation routine • Streamline data submissions to WRD • Finish the data QA routines • Finish the SIM Export routines San Diego "Meeting of the Networks"

23. Isle Royale NP, MI NPSTORET Future Versions • Create Analytical Groups which combine individual characteristics for reports, statistics, export, etc. • Provide a user interface to enter user-defined water quality criteria for use in screening water quality data • Allow users to enter their own user-defined data qualifiers/lab remarks • Print the existing visit/activity/results from the Results Template • Modify Data Analysis based on Lab Remark Codes • Develop Help for the Options and Import Forms • Monthly analysis options for statistics and graphics • Depth profile graphics • Data logger support • Add some non-parametric and trend analysis statistics • Additional biological data support • Enhance column major imports • Interface enhancements • Create additional graphs (scatter plot results for one characteristic versus results for a second characteristic, error plot of results to show mean and standard deviation) • Enable import translations - allow users to specify that field value "a" be translated to value "b" on import (same concept as the standard translations we are doing for NWIS and legacy station types) • Supplement/correct station info on import San Diego "Meeting of the Networks"

24. North Cascades NP, WA NPSTORET User Board • Velma Decker, CACO • Fred Dieffenbach, NETN • Patrick Flaherty, APHN • Bill Gawley, ACAD • Ron Holmes, NOCA/NCCN • Brenda Wells, CUPN San Diego "Meeting of the Networks"

25. Rocky Mountain National Park, CO NPSEDD – “Eddy” • STORET Electronic Data Deliverable • Hybrid of several state and federal EDDs adapted for NPS • Set of Microsoft Excel spreadsheets designed to collect the data necessary to drive SIM San Diego "Meeting of the Networks"

26. NPSEDD Tour Station Info Project Info Result Info San Diego "Meeting of the Networks"

27. Key Websites National Park Service Water Resources Division • http://www.nature.nps.gov/water/infoanddata/ (Vital Signs Data Mgt.) • http://www.nature.nps.gov/water/horizon.htm (Horizon Reports) • http://www1.nrintra.nps.gov/wrd/dui/ (Designated Use & Impairment) Environmental Protection Agency • http://www.epa.gov/storet/ (Main STORET) • http://www.epa.gov/storet/dbtop.html (Modern and Legacy Data) U.S. Geological Survey • http://waterdata.usgs.gov/nwis (National Water Information System) • http://nhd.usgs.gov/ (National Hydrography Dataset) San Diego "Meeting of the Networks"

28. Contact Info:Dean F. Tucker(970)-225-3516Dean_Tucker@NPS.GOVAdditional Info:http://www.nature.nps.gov/water/infoanddata/index.htm National Park Service San Diego "Meeting of the Networks" Great Smoky Mountains National Park, NC/TN