ISEMP Objectives

1
ISEMP Objectives

• Subbasin-scale
• Programmatic coordination, design, planning and
  implementation
• Indicators and metric development and testing
• Protocol development, refinement and testing
• Sampling design development and testing
• Effectiveness and status and trend monitoring
  experimental design and implementation
• Program-scale
• Evaluation tools development and testing
• Data management tools development and testing

2
Requirements to meet objectives

• Large volume of data from many agencies and
  projects
• Ability to summarize based on how, when, and
  where data was collected
• Ability to support range of analytical methods
  (hypothesis testing, time series, structural
  equations, mapping, etc)
• Ability to adapt to changing requirements

3
Compilation of Historic Data in the John Day Basin
Acquiring data 80 hours in 3 month
period Process data 1300 hours over 12
months Analyze data -in progress
4
What we found

• Large quantity of historic data
• Multiple data types
• water quality
• habitat
• fish abundance
• No consistent data format
• No central data storage within agencies
• Agencies struggling with multiple reporting
  responsibilities

5
Limiting Factor for any ME Program
Messy field data
Regional data analysis
-centralized source -standardized
format -metadata -processing tool -summary
analysis -distribution
-large volume -multiple types -multiple
sources -multiple formats
6
ISEMP Data Management Strategy

• Data Storage and Analysis
• RME Status and Trend Monitoring Database
• Metadata tracking
• Protocol manager tool
• Data dictionary
• Data Processing and Reporting
• Database templates
• Data Distribution
• Salmon Data Management website
• ISEMP website
• Geo-databases

7
RME Status and Trend Monitoring Database

• Central Data Repository
• provides data validation, long-term storage, and
  backup
• supports multi-users
• supports web based user interface
• Supports Data Analysis
• protocols attached to individual data value
• summary statistics for sites and years
• derived metrics
• selections based on network location
  (upstream/downstream)

8
RME Status and Trend Monitoring Database Schema
Field Data and Derived Data (Individual Values)
AttrName
AttrValue
AttrUnits
Geo-Spatial (NHD Plus)
Protocol Manager
Watershed
Monitoring Event
Stream
Collection Characteristics
Reach
Site Characteristics
9
ISEMP Data Management Strategy

• Data Storage and Analysis
• RME Status and Trend Monitoring Database
• Metadata tracking
• Protocol manager tool
• Data dictionary
• Data Processing and Reporting
• Database templates
• Data Distribution
• Salmon Data Management website
• ISEMP website
• Geo-databases

10
Metadata Tracking

• Protocol Manager
• Allows users to select from existing, modify
  existing, or create new protocol documentation
• Increases ease, accuracy, and efficiency of
  documenting protocols
• Data Dictionary
• Defines all metrics and values within protocols

11
ISEMP Data Management Strategy

• Data Storage and Analysis
• RME Status and Trend Monitoring Database
• Metadata Tracking
• Protocol manager tool
• Data dictionary
• Data Processing and Reporting
• Database templates
• Data Distribution
• Salmon Data Management website
• ISEMP website
• Geo-databases

12
Database Templates

• Data capture and reporting
• Standard format for data entry
• Supports multiple reporting responsibilities
• Technology transfer
• Leverages insights from historic data compilation
• Simple database design
• Supports new attributes or summary metrics
• Data Analysis
• Automates standard metrics and analysis
• Frees staff to ask more advanced questions

13
(No Transcript)
14
(No Transcript)
15
ISEMP Data Management

• Data Storage and Analysis
• RME Status and Trend Monitoring Database
• Protocols
• Protocol manager tool
• Data dictionary
• Data Entry, Processing, and Reporting
• Database templates
• Data Distribution
• Salmon Data Management website
• ISEMP website
• Geo-databases

16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
Geo-database

• MS Access database managed by ArcGIS
• Stores geo-spatial data (GIS layers)
• Contains metadata
• Single projection
• Easily distributed via web or CD
• Supports advanced geo-spatial analysis

20
(No Transcript)
21
Regional Data Analysis
Approved Protocol
Standard Analyses
Central Repository
Protocols
Validation
Database Template
Protocol Manager
Data Collection
22
Deliverables
1. Agency and regional tools for data
processing Template databases 2. Centralized
data repository Data storage Metadata
tracking Data analysis 3. Tools for data
distribution Web interface database General
project website Geo-databases
23

24
The End
25
Data storage and analysis

• EPAs STORET
• No protocols
• No motivation from agencies
• No tools for analysis
• Streamnet
• Houses project descriptions, not necessarily raw
  data
• USFS NRIS
• Fixed protocols

26
Protocol Manager Schema
Organization
Reference
Program
Method
Method Attribute
Protocol
Project
Method Shape
27
Adaptive Data Management
Approved Protocol
Regional Data Analysis
Central Repository
Protocol Manager
Protocols
Standard Analyses
Validation
Data Collection
Database Template