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.

 

Assumptions

·        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

Timeline  

·        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

 

 

Deliverables

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:

    WDNR, WDFW, ECY, WSDOT, IAC & USFS

 

 

Detailed Tasks and Deliverables:

 

 

Tasks

Lead/ Assignment

Hours

Start Date

End Date

 

 

 

 

 

 

 

INITIAL PHASE

 

 

 

 

1.0

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

Paulus

8

July 10, 2005

Oct. 30 2005

1.1

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

Steering Committee

2

July 10, 2005

July 30, 2005

1.2

Meeting: Project Kick-off Meeting and

Initiate discussions on this years funding of the PNW Hydro Clearinghouse

Steering Committee

2

July 30, 2005

Sept. 15, 2005

1.3

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

Woodall

4

Aug 20, 2005

Aug 20, 2005

 

Product: Path forward and agreement from participants

2.0

Review & Modification of Aml’s & Procedural Documentation

Saul

52

Aug. 1, 2005

Aug. 20, 2005

2.1

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

Saul

20

 

 

2.2

Procedural Documentation for Data Integration

Saul

16

 

 

2.3

QA/QC procedures documented by WDFW & DNR

Hudson/ Harris

16

Aug 1, 2005

Aug 30, 2005

 

Product: WA AMLS and procedural documents for data integration

3.0

Test Updated Implementation Procedures on WRIA 30

Saul

40

Aug. 20, 2005

Sept. 10, 2005

3.1

Test Updated Procedures and AML on one WRIA TBD

Saul/ Woodall

20

 

 

3.2

QA on Data and Modify Procedures if necessary

Saul

8

 

 

3.3

Load data into the PNW Clearinghouse

Saul/ Woodall

8

 

 

3.4

USFS to Provide User Acceptance and Verification of Data Loading

USFS

4

 

 

 

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

4.0

Project Team Buyoff on Resulting Data

Paulus

16

Sept. 10, 2005

Sept. 24, 2005

4.1

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

Technical Team

 

 

 

4.2

Meeting: Steering Committee & technical team meet to approve results

Steering Committee

2

Sept. 24, 2005

Sept. 24, 2005

 

Product: Accepted procedures and results for Production Phase

 

 

 

 

 

 

 

PRODUCTION PHASE

 

 

 

 

5.0

Production Implementation Schedule Set

Paulus

4

Sept. 24, 2005

Sept. 24, 2005

5.1

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

Paulus

4

 

 

 

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

6.0

Production Integration on 21 Eastern WA WRIA’s

Woodall

700

Sept. 24, 2005

Mar 1, 2006

6.1

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

Woodall

 

 

 

6.2

Import Integrate DNR &USFS Watercourse

Woodall

 

 

 

6.3

Import Integrate DNR &USFS Water bodies

Woodall

 

 

 

6.4

Import Integrate DNR &USFS Water shoreline

Woodall

 

 

 

6.5

Run QA/QC procedures on completed WRIA

Woodall

 

 

 

6.6

WDFW to verify WRIA for final assurance

WDFW

2 hrs/ WRIA

 

 

6.7

Move Completed WRIA to the PNW Clearinghouse

Woodall

 

 

 

6.8

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

USFS

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

7.0

Project Closure & Documentation

Paulus

14

Feb. 1, 2006

May 30, 2006

7.1

Finalize Eastern Washington Data Integration Project Documentation

Paulus

8

Feb. 1, 2006

May 15, 2006

7.2

Pull together all technical documentation

Saul

4

Feb. 1, 2006

May 15, 2006

7.3

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

Steering & Technical Team

2

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