slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Vital Signs Water Quality Data Management: NPSTORET and STORET EDD PowerPoint Presentation
Download Presentation
Vital Signs Water Quality Data Management: NPSTORET and STORET EDD

Loading in 2 Seconds...

play fullscreen
1 / 28

Vital Signs Water Quality Data Management: NPSTORET and STORET EDD - PowerPoint PPT Presentation


  • 400 Views
  • Uploaded on

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 Lassen Volcanic National Park, CA Vital Signs WQ Data Mgt Vital Signs/Natural Resource Challenge WQ Data

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Vital Signs Water Quality Data Management: NPSTORET and STORET EDD' - elina


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
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"

slide2

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"

slide3

Vital Signs WQ Data Mgt

Physical

Chemical

Other

Biological

slide4

What is STORET?

EPA Database for Ambient

Water Quality and Biological Data

San Diego "Meeting of the Networks"

slide5

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"

slide6

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
slide7

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

slide8

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

slide9

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"

slide10

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

slide11

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"

slide12

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

slide13

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"

slide14

Stations in STORET as of 1/25/2006

237,136

Stations in STORET

National Data

Warehouse

San Diego "Meeting of the Networks"

slide15

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"

slide16

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"

slide17

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
slide18

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;
slide19

Vital Signs WQ Data Flow

http://www.nature.nps.gov/water/infoanddata/index.htm

San Diego "Meeting of the Networks"

slide20

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"

slide21

NPSTORET Tour

San Diego "Meeting of the Networks"

slide22

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"

slide23

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"

slide24

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"

slide25

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"

slide26

NPSEDD Tour

Station Info

Project Info

Result Info

San Diego "Meeting of the Networks"

slide27

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"

slide28
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