Gretchen Peterson

1
In-stream Monitoring DatabaseSpatial Is
Special

• Presented By
• Gretchen Peterson
• PetersonGIS
• In Conjunction With
• Richard Brocksmith
• Hood Canal Coordinating Council

2
Overview

• Place
• Pacific Northwest
• Hood Canal
• Watershed

3
Overview

• Distributed Data Problem Statement
• Historic in-Stream data were
• In many agencies
• In many formats
• Aspatial
• These are research barriers for projects
  involving historical analysis and/or large
  geographic areas

4
Objectives

• Create a central data location
• Connect data to a GIS
• Allow for ongoing data input

5
Input Data Characteristics

• From three agencies
• Collected between 1989 and 2003
• In paper, Excel, and Access formats
• Locations recorded via hipchain (stream feet) and
  WRIA number

6
Input Data Characteristics

• Under two data collection protocols
• TFW Monitoring Program
• HCSEG StreamTeam Protocol

7
Database Design

• Created vertical table structures

8
Database Design

• Added attributes for dynamic segmentation
• LLIDs
• WDFW hydrology GIS layer derived from WDNR
  hydrology
• Calculated progressive to and from measurements
  based on hipchain feet

9
Dynamic Segmentation
10
Database Design

• Main Tables
• Habitat Conditions
• Parameters
• Ancillary Tables
• Sources
• DataModules
• Etc.

• LocationParameters
• LocationValues
• Measurement Details
• Protocols

11
Data Coverage
12
Output Map Example
13
Output Map Example
14
Output Map Example