# Presentation: 386310

## The Pacific Northwest Water Quality Data Exchange

*Idaho Department of Environmental Quality*
*Alaska Department of Environmental Conservation*
*Environmental Protection Agency, Region X*

***The Pacific Northwest ******Water Quality Data Exchange***

## Challenge Grant Objectives

- Provide access to a comprehensive collection of Water Quality data for the Pacific Northwest
- Apply Network principles
- Enable participation from a wide range of data sources
- Design data exchange flow to support partner needs and eventual upload to EPA STORET

**Notes:**
Provide access to a comprehensive collection of Water Quality data for the Pacific Northwest
Support jointly regulated watersheds.

Apply Network principles
Use of Nodes

Enable participation from a wide range of data sources
List them – local, state and federal agencies, tribes, watershed councils, etc
Use of host database, metadata registry, partners without nodes.

Design data exchange flow to support partner needs and eventual upload to EPA STORET
Primary objective is to support information access and exchange between partners.  Long term vision is to include STORET as a potential node on the exchange to provide data.  Also to upload data to STORET from the Exchange

## Collaboration is Key to Success

- Active Participants
- Environmental Protection Agency Region 10
- Nestucca-Neskowin Watersheds Council (Oregon)
- Northwest Indian Fisheries Commission
- State of Alaska Department of Environmental Conservation
- State of Idaho Department of Environmental Quality
- State of Idaho Soil Conservation Commission
- State of Oregon Department of Environmental Quality
- State of Washington Department of Ecology
- University of Idaho -  Water Resources Research Institute
- Windsor Solutions, Inc.

## Collaboration is Key to Success

- Affiliates
- Coeur d’Alene Tribe
- Confederated Tribes of the Siletz Indians
- Idaho National Engineering and Environmental Laboratories
- King County (Washington) Department of Natural Resources
- Long Tom Watershed Council (Oregon)
- National Park Service
- Nez Perce Tribe
- Pacific States Marine Fisheries Commission – StreamNet
- Rogue Valley Council of Governments (Oregon)
- South Coast Watersheds Council (Oregon)
- State of Oregon Watershed Enhancement Board
- Surfrider Foundation
- Tanana Chiefs Council

## Collaboration is Key to Success

- Related, Collaborative Project Contacts
- Environmental Data Standards Council – Environmental Sampling, Analysis, and Results Standard
- National Water Quality Monitoring Council – Water Quality Data Elements
- USGS -NWIS / EPA –STORET Data Integration
- Environmental Protection Agency – OEI / CDX
- Environmental Protection Agency – OWOW / STORET

## Vision for the Exchange Data Flow

**Notes:**
Identify Exchange partners
Describe node connection architecture
Describe use of host database by non-node partners
Describe use of metadata registry for source discovery
Describe use of access application
Describe STORET FUTURE availability on the Exchange and upload.

## Components of the Exchange Flow

- DET

- FCD

- TPA

-  Data Exchange Template
-  data elements
-  relationships and conditions
-  derive XML schema

## Data Exchange Template

**Data Exchange Template**

## XML Schema

## Components of the Exchange Flow

- DET

- FCD

- TPA

-  Data Exchange Template
-  data elements
-  relationships and conditions
-  derive XML schema

-  Flow Configuration Document
-  method definition, parameters
-  query flow: filtering, wildcards,
- 	paging, ordering, errors
-  load flow: process sequence, security

## Flow Configuration Document

## Components of the Exchange Flow

- DET

- FCD

- TPA

-  Data Exchange Template
-  data elements
-  relationships and conditions
-  derive XML schema

-  Trading Partner Agreement
-  roles and responsibilities
-  data stewardship
-  administration

-  Flow Configuration Document
-  method definition, parameters
-  query flow: filtering, wildcards,
- 	paging, ordering, errors
-  load flow: process sequence, security

## Trading Partner Agreement

## http://deq12.deq.state.or.us/pnwwqx/

**Accessing the Exchange**

## Next Steps

- Engage additional Exchange partners
- Municipalities, other agencies
- Watershed councils, volunteer groups
- Pilot ambient WQ data flow with EPA-STORET

**Notes:**

Implement flow support on primary Exchange nodes (Q1 2004)
Initially installed on OR and WA nodes with ID data being served through the host database

Conduct pilot testing (Q1 2004)
Establish links between primary nodes

Rollout to additional Exchange partners (Q2-Q4 2004)
Deploy the flow support processes on other partner nodes
Include additional data in host database

Enhance data access application (Q2 2004)
Use POC as basis
Expect that partners may establish links from their own internal systems
Expect that future natural resource portals may supercede the Exchange version in complexity and capability

## Thank you!

- Contact Curtis Cude for details
- _[Cude.curtis@deq.state.or.us](mailto:Cude.curtis@deq.state.or.us)_
- 503-229-6086