A Data Management Approach to Support Aquatic Resources Monitoring

• ISEMP Coordinators– Chris Jordan, NOAA-Fisheries– Pamela Nelle, Terraqua, Inc.– Carol Volk, Volk Consulting– Chris Beasley, Quantitative Consultants, Inc.– Nicolaas Bouwes, Eco Logical Research, Inc.– Steve Rentmeester, Environmental Data Services

• NOAA – Science Data Management Team– Jeff Cowen, NOAA-Fisheries– Rod Davidson, Saber Consulting

• US Bureau of Reclamation – PN Region– Mike Beaty– Melanie Paquin– Greg Gault– Kristin Swoboda

Integrated Status and Effectiveness Monitoring Program (ISEMP)

• Pilot effectiveness and status and trend monitoring

• Design and implement watershed-scale experiments (IMW)

• Develop, test, and implement- Protocols

- Sampling designs- Metrics and indicators- Evaluation tools- Data management tools

Document Protocol

Field Collection

Data Entry

Agency Storage

Agency Analysis

Local Analysis

Regional Sharing

Regional Analysis

?Questions

Requirements

• Ability to integrate data across multiple survey types

• Support development of indicators, metrics, protocols, sampling designs, and experimental designs

• Ability to support range of analytical methods (hypothesis testing, time series, structural equations, mapping, etc)

• Handle large volumes of data from many sources

• Adapt to changing requirements

Assumptions• Protocols will evolve (questions evolve and

improvements in measurement technology).

• Metadata can be used for data documentation, discovery, validation and analysis

• Data to be maintained by data generators and QA/QC to be performed at time of data entry

Data Integrity

• Data entry complies to protocol• Ensuring that all metadata is included

– Why (statistical design)– How (protocol and methods)– Where (site name, network location)– When (date and time)– Who (agencies and crew members)– What (the data)

ARSAttribute

ARSObject

MethodAttribute

MethodObject

Method

ARSSurveyType

Protocol

What How

Approach requires two data dictionary - What is observed - How it is observed

Survey Types• Fine Sediment• Fish Capture / PIT Tagging• Habitat• Macro Invertebrates• Site Selection• Smolt Trap• Snorkel/Electro Fishing• Spawning Ground• Water Quality

Protocol Manager

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

Automated Template Module

End