Eastern Washington Hydrography Integration Project


WA Hydrography Steering Committee - Project Approval




We agree to support this project and to help ensure its success

as described in the attached Project Plan.


Steering Committee:


Rick Jordan, PNW Clearinghouse Representative           

US Forest Service


Deborah Naslund, Forest Practices Division

WA Department of Natural Resources


Stephen Bernath, Water Quality Program          

WA Department of Ecology


Jim Eby, Information Technology Division

WA Department of Fish & Wildlife


David Jennings, Office of Drinking Water

WA Department of Health


Debbie Stewart, Applications & Data Services

WA Department of Ecology


Elizabeth Lanzer, Environmental GIS Management

WA Department of Transportation



Steering Committee Support:


­­­­Joy Paulus, Project Coordinator                                       

Salmon & Watershed Information Management (SWIM)


John Tooley, Technical Services Lead                           

WA Department of Ecology


Carl Harris, Hydrography Data Steward            

WA Department of Natural Resources


Tim Young, GIS Manager

WA Department of Fish & Wildlife



Eastern Washington Hydrography Framework Integration

Project Authorization Package

July 18, 2005


Project Description:


Problem Statement

Natural resource and environmental management has shifted from an issue specific approach to an integrated landscape and watershed planning approach.  This shift has increased the need for agency coordination and data sharing.  At the same time, cross-organizational demands for access to surface water information have grown with the growth in watershed-based initiatives. Local watershed planning groups, citizens, tribes, and consultants make frequent data requests to multiple state agencies for separate but similar data. This is driving the need for one contiguous, framework of surface water data that all organizations can tie critical information to.


Project Statement

The PNW Hydrography Framework Project participants are in the process of building a seamless GIS hydrography layer for Washington, Oregon, and northern California to support similar environmental initiatives.  This data will be housed on the PNW Hydrography Framework Clearinghouse http://hydro.reo.gov/, which is a dedicated site for the storage and retrieval of the regions hydrography data.  Additionally, it also allows appropriate Framework Partners the ability to checkout areas of interest, perform edits to the data, and then resubmit it back to the Framework thus encouraging the maintenance of one cohesive set of data that’s usable by all.


This project will re-examine the process used for western Washington integration and will complete this work for the remaining part of the state. The hydrography data from this project will be integrated and published to the PNW Hydrography Framework Clearinghouse. This will provide multiple users access to coordinated surface water information via an Internet application.


Project Objectives

The primary purpose of this project is to perform the technical data integration programming, editing, documentation and posting of all affected WRIA’s in eastern Washington.  This means that 22 WRIA’s  (32, 35, 38, 39, 40, 41, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 58, 59, 60, 61, 62) will need to be edited in order to mesh the federal and state data into one integrated hydrography data set.  This integration work will be done following the agreed upon pour points provided and agreed upon by the USFS and WDNR. The PNW Hydrography Frameworks standards and protocols will be followed during the project.


It is critical the WRIA’s are loaded into the Clearinghouse beginning with the downstream Columbia River WRIA’s and a similar approach being taken with the Snake, Spokane Rivers and Crab Creek as well.  A suggested order to following would be:

30, 31, 32, 33, 34, 35, 36, 37  / 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 58, 59, 60, 61


Critical Success Factors


Project Benefits

·        Improve the regional hydrography information base.

·        Help avoid duplication of effort by making a single, integrated hydrography layer available to a wide range of users for use and updating

·        Help strengthen interagency relationships


Relationship to Other Salmon/Watershed Data Stores

The data model was designed so that all agencies and organizations can utilize the core spatial and tabular information directly.  Additionally, the model supports the incorporation of data specific to each organization without physically joining it to the spatial elements.  This ability will allow all salmon and watershed information to be housed and stewarded within the appropriate agency or organization, yet be shared, analyzed, and displayed within the context of a single set of spatial hydrography data when needed.



·        That the USFS will deliver the applicable sub-basin data to Ecology as needed and outlined in the project plan

·        That the BLM will be able to complete their integration work along the Oregon/Washington border and load that data into the Clearinghouse

·        That long-term funding for the Clearinghouse support will be addressed by the state agencies and funds will be allocated to continue infrastructure operations.


Risk Assessment

This project is of a moderate risk since active participation and buy-in from the affected state agencies has been difficult to achieve.  

Other items of concern are:


Project Organization 

Project Funding Sponsors – SWIMTAC, USFS, WDOH & WSDOT

Project Manager – Joy Paulus

Steering Committee - Stephen Bernath, Jim Eby, Debbie Stewart, Rick Jordan,

  Deb Naslund, David Jennings, Elizabeth Lanzer

Steering Committee Support – Carl Harris, Tim Young, John Tooley

Technical Team – Dan Saul, Martin Hudson, Rick Jordan and Mike Woodall


Project Tasks, Output Product and Workload

Specific tasks include:

·        Technical coordination between DNR, WDOE, WDFW, USFS & BLM.


·        Discuss possible efficiencies with participants on improving the process used for western WA integration

·        Document the integration process and finalize documentation

·        Develop production schedule for remaining WRIAs

·        Implement production schedule


Timelines and Deliverable Products/Milestones


·        Total Estimate:  740 hours or 87 days

·        Duration:  August 1, 2005 through March 30, 2006

·        Contracting Resource Requirements:

§         ¼ FTE for 1 month @ senior level

§         ½ FTE for 7 month @ mid-level

Note:  This estimate does not include in-kind hourly donations




1)      22 fully integrated WRIA’s including: watercourse, water bodies, and water shoreline (700 hrs)

2)      11 non integrated WRIA’s loaded into the Clearinghouse for a total of 33 WRIA’s (40 hrs)

3)      Successful posting of integrated data to the PNW Hydrography Framework Clearinghouse

4)      Documentation detailing the specifics of data integration between state and federal jurisdictions

5)      AML programs and procedures for automating the integration of hydro data

6)      Project plan for accomplishing the remaining WRIA integration work in eastern Washington

7)      Update the posted documentation and link to the data on the Natural Resource Information Portal



Estimated Budget/Resource Impacts:


Steering Committee Members:

Resource commitment of about 8 - 12 hours per member to cover meetings, reviews and assessment of the project’s progress

Stephen Bernath, Water Quality Program, Ecology

Jim Eby, Information Technology Division, WDFW

Debbie Stewart, Applications & Data Services, Ecology

Ken Adee, PNW Clearinghouse, USFS

Deb Naslund, Forest Practices Division, WDNR

David Jennings, Office of Drinking Water, WDOH

Elizabeth Lanzer, Environmental GIS Management, WSDOT


Agency Staff Resources:

Joy Paulus                    80 hours in-kind contribution for coordination & mgmt.

John Tooley                  20 hours in-kind contribution for project management

                Carl Harris                   80 hrs in-kind contribution for Framework coordination

Dan Saul                      42 hrs fee based programming services and

                        40 hr in-kind contribution

Martin Hudson             120 hr in-kind contribution - QA/QC route integrity review

USFS                           40 hr in-kind contribution – QA/QC data review

Mike Woodall             700 hrs fee based data integration services


On-going Operations Costs:

WA state agencies need to seek agency funding for the on-going maintenance of the PNW Clearinghouse.  These costs will continue to be prorated between the federal and state partners.  Washington States share of $25,000 needs to be folded into the Natural Resource Agencies biennial budgets for FY’07-’09.


Data layer improvements and upgrades should be folded into state agencies existing data collection and update budgets and don’t necessary reflect new costs.


Funding Sources:

Funding for this project is provided by:

    SWIMTAC $25,000            USFS $19,000      WDOH $15,000     WSDOT $7,000


In-Kind funding provided by:




Detailed Tasks and Deliverables:




Lead/ Assignment


Start Date

End Date














Assessment & Agreement on Eastern WA Integration Proposal & Next Steps for Eastern WA



July 10, 2005

Oct. 30 2005


Comment on project proposal, roles, project time line, commitments and identify agency signatures for Project Authorization

Steering Committee


July 10, 2005

July 30, 2005


Meeting: Project Kick-off Meeting and

Initiate discussions on this years funding of the PNW Hydro Clearinghouse

Steering Committee


July 30, 2005

Sept. 15, 2005


Produce Status Table for Reporting Progress by WRIA & HUC and Status of Data Delivery and QA/QC



Aug 20, 2005

Aug 20, 2005


Product: Path forward and agreement from participants


Review & Modification of Aml’s & Procedural Documentation



Aug. 1, 2005

Aug. 20, 2005


Review/Modify AML’s from western  WA data integration project






Procedural Documentation for Data Integration






QA/QC procedures documented by WDFW & DNR

Hudson/ Harris


Aug 1, 2005

Aug 30, 2005


Product: WA AMLS and procedural documents for data integration


Test Updated Implementation Procedures on WRIA 30



Aug. 20, 2005

Sept. 10, 2005


Test Updated Procedures and AML on one WRIA TBD

Saul/ Woodall





QA on Data and Modify Procedures if necessary






Load data into the PNW Clearinghouse

Saul/ Woodall





USFS to Provide User Acceptance and Verification of Data Loading






Product: Integrated watercourse, water bodies, water shoreline data for WRIA 26 loaded into the PNW Clearinghouse


Project Team Buyoff on Resulting Data



Sept. 10, 2005

Sept. 24, 2005


Data review period – 2 weeks.  Comments due by Sept. 23, 2005

Technical Team





Meeting: Steering Committee & technical team meet to approve results

Steering Committee


Sept. 24, 2005

Sept. 24, 2005


Product: Accepted procedures and results for Production Phase














Production Implementation Schedule Set



Sept. 24, 2005

Sept. 24, 2005


Adjust schedule and delivery dates, as needed, based on results from WRIA 30 integration work. Forward results to Steering Committee






Product: Documented cost & implementation schedule for the integration of remaining 19 WRIA


Production Integration on 21 Eastern WA WRIA’s



Sept. 24, 2005

Mar 1, 2006


Following integration procedure documentation being processing data sets in priority WRIA order






Import Integrate DNR &USFS Watercourse






Import Integrate DNR &USFS Water bodies






Import Integrate DNR &USFS Water shoreline






Run QA/QC procedures on completed WRIA






WDFW to verify WRIA for final assurance


2 hrs/ WRIA




Move Completed WRIA to the PNW Clearinghouse






USFS to verify and review loaded data on the Clearinghouse – QA/QC


2 hrs/ WRIA










Step through Tasks 6.2 through 6.8 until all Eastern Washington WRIA’s  are completed






Product: Fully integrated hydrography framework data posted to the PNW Hydro Clearinghouse


Project Closure & Documentation



Feb. 1, 2006

May 30, 2006


Finalize Eastern Washington Data Integration Project Documentation



Feb. 1, 2006

May 15, 2006


Pull together all technical documentation



Feb. 1, 2006

May 15, 2006


Meeting:  Steering committee & technical team meet to close out project

Steering & Technical Team


Mar. 30, 2006

May 30, 2006


Product: Complete set of project, programming and technical documents for use on eastern WA data integration effort and acceptance of the product



Revision History


version 2  8-24-2005

version 1  7-12-2005