1 / 14

In-stream Monitoring Database Spatial Is Special

In-stream Monitoring Database Spatial Is Special. Presented By: Gretchen Peterson PetersonGIS In Conjunction With: Richard Brocksmith Hood Canal Coordinating Council. O verview. Place Pacific Northwest Hood Canal Watershed. O verview.

martinjames
Download Presentation

In-stream Monitoring Database Spatial Is Special

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 • LocationParameters • LocationValues • Measurement Details • Protocols • Main Tables: • Habitat Conditions • Parameters • Ancillary Tables: • Sources • DataModules • Etc.

  11. Data Coverage

  12. Output Map Example

  13. Output Map Example

  14. Output Map Example

More Related