slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
I&M Data Management Meeting Las Vegas, Nevada March 12, 2002 PowerPoint Presentation
Download Presentation
I&M Data Management Meeting Las Vegas, Nevada March 12, 2002

Loading in 2 Seconds...

play fullscreen
1 / 31

I&M Data Management Meeting Las Vegas, Nevada March 12, 2002 - PowerPoint PPT Presentation


  • 337 Views
  • Uploaded on

Vital Signs Water Quality Data Management STORET, Metadata, and the NPS Water Quality Database Templates by Dean Tucker NPS Water Resources Division I&M Data Management Meeting Las Vegas, Nevada March 12, 2002 NPS Vital Signs Monitoring Networks Physical Chemical Other Biological

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 'I&M Data Management Meeting Las Vegas, Nevada March 12, 2002' - JasminFlorian


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

STORET, Metadata, and the NPS Water Quality Database Templates

by

Dean Tucker

NPS Water Resources Division

I&M Data Management Meeting

Las Vegas, Nevada

March 12, 2002

slide2

NPS Vital Signs Monitoring Networks

Physical

Chemical

Other

Biological

storet background
STORET Background

EPA Database for Ambient

Water Quality and Biological Data

storet background4
STORET Background
  • STORage and RETrieval
  • Began in DOI in 1964
  • 1 Million (plus) Sites
  • 200 Million (plus) Observations
storet background5
STORET Background

At a conservative $10.00 per obs. (field plus lab work), data are worth $2 billion!!!

storet background6
STORET Background
  • State Environmental & Health Organizations
  • Federal Agencies (EPA, NPS, BuRec, USFS)
  • Citizen Volunteers
  • Watershed Managers
storet background7

Old

STORET

STORET

Legacy Data Center

New STORET

STORET Background
storet background8
STORET Background
  • 17 Two-Day Joint Application Design 1991-92
    • Links to GIS
    • Data of Documented Quality
  • User Validation
    • Four National Conferences, 1991-1996
  • Prototype Testing by 200 Users, 1997
    • Feedback Incorporated into System
storet background9
STORET Background
  • Features
    • Data of Documented Quality
    • Graphical User Interface
    • Data Standards for Data Sharing
  • Implementation
    • Scaleable - Watershed to National
      • Locally Owned and Operated
      • EPA Maintained
    • Public Read-Only Access to EPA Data Warehouse

NPSTORET

slide10

Organization

Programs

Projects

Data Loggers

Trips

Simplified STORET Schematic

Sampling

Stations

Operating Periods

Station

Visits

Monitoring

Activities

Results

storet background11
STORET Background
  • Sample Medium
    • 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

storet background12
STORET Background
  • Field Measurement/Observations
      • Replicate Measurement
      • Habitat Evaluation
      • Observation
      • Measurement

Samples

  • 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
why storet
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.
  • Twenty-one states already have data in new STORET as of 3/05/2002.
why storet15
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
why storet16
Why STORET?
  • Fully compliant 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 observations at 17,477 stations for 191 parks
reporting vital signs network water quality data
Reporting Vital Signs NetworkWater Quality Data
  • Who:
  • Why:
  • When:
  • What:
  • How:

Every Vital Signs Network

Required by Implementation Plan

At Least Annually

NWQMC Metadata Elements

Access Templates

slide18
Terms Of Reference

National Water-Quality Monitoring Council

Approved by the Advisory Committee on Water Information February 18, 1998 Revisions approved by Council August 24, 2000.

Purpose, scope, applicability, and functions

Purpose -- The overall purpose of the National Council is to champion and support water-quality information aspects of natural-resources management and environmental protection. The National Council has a broad mandate that encompasses water quality monitoring and assessment that includes considerations of water quality in relation to water quantity. The purpose of the National Council is to coordinate and provide guidance and technical support for the voluntary implementation of the recommendations presented in the Strategy for Improving Water-Quality Monitoring in the United States (the strategy) by government agencies and the private sector. The intent of the strategy, presented in the final report of the ITFM, is to stimulate the monitoring improvements needed to achieve comparable and scientifically defensible information on interpretations and evaluations of water-quality conditions.

(http://water.usgs.gov/wicp/acwi/monitoring)

slide19
Methods and Data Comparability Board (http://wi.water.usgs.gov/pmethods/index.html)

Chartered under the NWQMC

Recommend monitoring approaches that facilitate collaboration and yield comparable data and assessment results

Core set of data elements (metadata) for reporting water quality monitoring results

slide20

Track the:

Who:

What:

Where:

When:

Why:

How:

of the monitoring effort

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

(http://wi.water.usgs.gov/pmethods/elements/elements.html)

slide21

Who?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

1.0 Contact

Contact Information:

  • Data Owner
  • Sample Collector, Measurer, or Observer
  • Lab Analyzer
slide22

What?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

2.0 Results

What was measured/observed/analyzed?:

  • Analyte, Constituent, Parameter,

Contaminant, Organism, Characteristic

  • Filtered Fraction, Sample Medium
  • Units, Field or Lab Measured
  • Chemical Abstract Service Number, Biological

Systematic Identifier, ITIS Serial Number

slide23

Where?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

5.0 Location

Locational Information for Sample

or Measurement/Observation:

  • Station ID
  • Name of Waterbody: (http://geonames.usgs.gov/gnishome.html)
  • Station Type (e.g. stream/river, canal, spring, estuary, etc.)
  • Latitude/Longitude Coordinates (datum, source, scale, accuracy)
  • Elevation (datum, source, scale, and units)
  • Bottom Depth of Station and Units
  • Geographic Data and Other Attributes
slide24

When?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

4.0 Date/Time

When was the sample collected/analyzed

or measurement/observation made?:

  • Begin Date/End Date
  • Begin Time/End Time
  • Collection, Processing, and Analysis
slide25

Why?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

3.0 Reason for Sampling

Project Monitoring Purpose, Goals, Objectives

  • Overall Project
  • Individual Stations
  • Individual Samples

reconnaissance/occurrence survey

trend analysis

permit compliance

storm event

research

regulatory benchmark

bioaccumulation

deposition

other as applicable

slide26

How?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

6.0 Sample Collection

Sample Collection:

  • Sample Type

Field Measurement/Observation

Sample

Sample Created from Sample

Composite Sample w/ Parents

Quality Control Sample

  • Media Sampled
  • Sample Temperature
  • Sample Identification
  • Sample Collection Method
  • Sample Preservation/Treatment

Metadata Capstone:

slide27

How?

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

7.0 Sample Analysis

Sample Analysis:

  • Analytical Method Number
  • Sample Size
  • Serial Dilution
  • Composite Sample
  • Run Batch
  • (Spiking) Amount or Dose Added
  • Detection/Quantitation Limits, Types

Metadata Capstone:

slide28

NWQMC/MDCB Recommended Standard

Water Quality Data Elements

Who

What

  • Recommended
  • Minimum Set
  • As Applicable
  • Chemical and

Microbiological

Where

How

When

Why

reporting vital signs network water quality data29
Reporting Vital Signs NetworkWater Quality Data
  • Natural Resource Database Template Input Screens
    • Projects - Why
    • Stations - Where
    • Metadata - How
    • Results – What, When, Who
  • Transmit Files to WRD Along with QAPP, SOP, and Other Relevant Documentation
  • QA/QC and STORET Import Module (SIM)
  • Upload to STORET National Data Warehouse
useful web site references
Useful Web Site References
  • STORET Web Site: http://www.epa.gov/storet.
  • NWQMC Water Quality Data Elements: http://wi.water.usgs.gov/pmethods/elements/elements.html.
  • National Water Quality Monitoring Council: http://water.usgs.gov/wicp/acwi/monitoring. 
  • Natural Resource Database Template: http://www.nature.nps.gov/im/apps/template.
slide31

Vital Signs Water Quality Data Management

STORET, Metadata, and the NPS Water Quality Database Templates

by

Dean Tucker

NPS Water Resources Division

I&M Data Management Meeting

Las Vegas, Nevada

March 12, 2002