Western 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:


Ken Adee, 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, WA Hydrography Data Steward                             

WA Department of Natural Resources


Tim Young, GIS Manager

WA Department of Fish & Wildlife



Western Washington Hydrography Framework Integration

Project Authorization Package

August 9, 2004


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 all of 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 hydrography data, and then resubmit them back to the Framework thus encouraging the maintenance of one cohesive set of data that’s usable by all.


The DNR recently completed the conversion of its legacy HYDRO (Data ’96) layer for the state of Washington to this new Framework model and it covers all of western and eastern Washington.  The Framework partners have agreed that, in certain watersheds, the converted data will not be posted to the Clearinghouse until it is integrated with hydrography data from the federal partners.  The process of integrating these two separate hydrography data sets into one seamless data layer is complex and time consuming but needs to be undertaken. 


This project will develop the process for and completion of this work so that initially western Washington hydrography data is 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 western Washington.  This means that 20 WRIA’s  (1, 3, 4, 5, 7, 8, 9, 10, 11, 16, 17, 18, 19, 20, 21, 22, 26, 27, 28, 29) 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.


Initially WRIA 5 was used to test the BLM conversion routines.  Now, we will building off this success, and proceed initially with validating the project time and cost estimates by tackling data integration on a more complex WRIA.  Following the conversion and posting of WRIA 26 to the PNW Clearinghouse, then the remaining 18 western Washington WRIA’s will be processed in the order set by the technical team.  The 18 WRIA’s consist of # 1, 3, 4, 7, 8, 9, 10, 11, 27, 28, 29, 16, 17, 18, 19, 20, 21,  & 22.


Critical Success Factors

  • Active participation by the Steering Committee
  • Active participation by the Technical Team
  • Active participation and support from the PNW Hydro Clearinghouse
  • Database contentsAgreement that the data will be institutionalized by each of the key Natural Resource agencies (WDNR, WDFW, Ecology)
  • Agreement from the Natural Resource agencies on the care and feeding of these data sets once they are populated into the Clearinghouse


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.

·        Provide a process for Framework data integration effort across eastern Washington.

·        Help strengthen interagency relationships with regard to the project.


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.


The Hydrography Framework Project is endorsed by the Washington Geographic Information Council (WAGIC), the Oregon Geographic Information Council (OGIC), the Inter-organizational Information Coordinating Council (IRICC), the Washington Governor’s Joint Natural Resources Commission, the Washington Salmon Recovery Funding Board, the Oregon Watershed Enhancement Board, the Puget Sound Water Quality Action Team, and dozens of private, state, federal, & tribal organizations across the Pacific Northwest.



·        That DNR delivers all listed WRIA’s to Ecology by August 20, 2004

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

·        That 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 moderate risk since active participation and buy-in from the affected state agencies has been difficult to achieve. This risk is somewhat mitigated since we have a similar goal in getting the final hydrography data completed and on the web for state agency use.

  • PNW Clearinghouse data loading has not been tested in Washington so estimates are not available
  • Review process and reviewer’s of the resulting data have not been formally identified
  • A consistent and strong commitment from WA Hydro Framework participants is not apparent at this point in time


Project Organization 

Project Funding Sponsors – SWIMTAC, USFS, WDOH & WSDOT

Project Manager Joy Paulus

Steering Committee - Steve Bernath, Jim Eby, Debbie Stewart, Ken Adee,

  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.

·        Technical refresh on the BLM integration process

·        Customize BLM integration tool to meet the needs of Washington Framework integration

·        Initial implementation on WRIA 9 & 26 to verify time and cost estimates on integration of federal and state Hydrography Framework data sets

·        Discuss possible efficiencies with participants on improving the process

·        Document the integration process and finalize documentation

·        Develop production schedule for remain WRIA integration

·        Implement production schedule


Timelines and Deliverable Products/Milestones

·        Timeline:  

·        Total Estimate:  792 hours or 99 days

·        Duration:  July 30, 2004 through March 30,2005

·        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




·        Deliverables:

1)      20 fully integrated WRIA’s including: watercourse, water bodies, and water shoreline

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

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

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

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

6)      Posting of a 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

Steve 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 – WRIA 26 Processing

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

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

Mike Woodall 720 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’05-’07.


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 Western WA Integration Proposal & Next Steps for Eastern WA



July 10, 2004

Oct. 30 2004


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

Steering Committee


July 10, 2004

July 30, 2004


Meeting: Project Kick-off Meeting and

Initiate discussions on the funding of the PNW Hydro Clearinghouse

Steering Committee


July 30, 2004

Sept. 15, 2004


Identify funding opportunities for of eastern WA basins

SWIM & Member Agencies


July 30, 2004

Oct. 30, 2004


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



Aug 20, 2004

Aug 20, 2004


Set up meeting to identify of stewardship of eastern WA

Harris/ USFS


Oct. 1 2004

Oct. 30, 2004


Pull together a preliminary plan for continuing this integration effort into eastern Washington



Nov 1, 2004

Mar. 30, 2004


Product: Path forward and agreement from participants


AML Re-write and Programming & Procedural Documentation –Test Against WRIA 9



Aug. 1, 2004

Aug. 20, 2004


Modify BLM AML’s for WA data integration






Procedural Documentation for Data Integration






QA/QC procedures documented by WDFW & DNR

Hudson/ Harris


Aug 1, 2004

Aug 30, 2004


Product: WA AMLS and procedural documents for data integration


Test of Implementation Procedures on WRIA 26



Aug. 20, 2004

Sept. 10, 2004


Test Procedures and AML on WRIA 26

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, 2004

Sept. 24, 2004


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

Technical Team





Meeting: Steering Committee & technical team meet to approve results

Steering Committee


Sept. 24, 2004

Sept. 24, 2004


Product: Accepted procedures and results for Production Phase














Production Implementation Schedule Set



Sept. 24, 2004

Sept. 24, 2004


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






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


Production Integration on 18 Western WA WRIA’s



Sept. 10, 2004

Mar 30, 2005


Obtain USFS & DNR Data Sets






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






Integrate DNR &USFS Watercourse






Integrate DNR &USFS Water bodies






Integrate DNR &USFS Water shoreline






Run QA/QC procedures on completed WRIA






WDFW to verify WRIA for final assurance


4 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.9 until all Western WA WRIA’s  are complete






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


Project Closure & Documentation



Feb. 1, 2005

Mar 30, 2005


Finalize Western Washington Data Integration Project Documentation



Feb. 1, 2005

Mar. 15, 2005


Pull together all technical documentation



Feb. 1, 2005

Mar. 15, 2005


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

Steering & Technical Team


Mar. 30, 2004

Mar. 30, 2004


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


Project Summary