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.

 

Assumptions

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

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

Paulus

16

July 10, 2004

Oct. 30 2004

1.1

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

Steering Committee

2

July 10, 2004

July 30, 2004

1.2

Meeting: Project Kick-off Meeting and

Initiate discussions on the funding of the PNW Hydro Clearinghouse

Steering Committee

2

July 30, 2004

Sept. 15, 2004

1.3

Identify funding opportunities for of eastern WA basins

SWIM & Member Agencies

On-going

July 30, 2004

Oct. 30, 2004

1.4

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

Woodall

4

Aug 20, 2004

Aug 20, 2004

1.4

Set up meeting to identify of stewardship of eastern WA

Harris/ USFS

4

Oct. 1 2004

Oct. 30, 2004

1.5

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

Harris

12

Nov 1, 2004

Mar. 30, 2004

 

Product: Path forward and agreement from participants

2.0

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

Saul

56

Aug. 1, 2004

Aug. 20, 2004

2.1

Modify BLM AML’s for WA data integration

Saul

40

 

 

2.2

Procedural Documentation for Data Integration

Saul

16

 

 

2.3

QA/QC procedures documented by WDFW & DNR

Hudson/ Harris

16

Aug 1, 2004

Aug 30, 2004

 

Product: WA AMLS and procedural documents for data integration

3.0

Test of Implementation Procedures on WRIA 26

Saul

60

Aug. 20, 2004

Sept. 10, 2004

3.1

Test Procedures and AML on WRIA 26

Saul/ Woodall

40

 

 

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

Sept. 24, 2004

4.1

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

Technical Team

 

 

 

4.2

Meeting: Steering Committee & technical team meet to approve results

Steering Committee

2

Sept. 24, 2004

Sept. 24, 2004

 

Product: Accepted procedures and results for Production Phase

 

 

 

 

 

 

 

PRODUCTION PHASE

 

 

 

 

5.0

Production Implementation Schedule Set

Paulus

4

Sept. 24, 2004

Sept. 24, 2004

5.1

Adjust schedule and delivery dates, as needed, based on results from WRIA 26 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 18 Western WA WRIA’s

Woodall

720

Sept. 10, 2004

Mar 30, 2005

6.1

Obtain USFS & DNR Data Sets

Woodall

 

 

 

6.2

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

Woodall

 

 

 

6.3

Integrate DNR &USFS Watercourse

Woodall

 

 

 

6.4

Integrate DNR &USFS Water bodies

Woodall

 

 

 

6.5

Integrate DNR &USFS Water shoreline

Woodall

 

 

 

6.6

Run QA/QC procedures on completed WRIA

Woodall

 

 

 

6.7

WDFW to verify WRIA for final assurance

WDFW

4 hrs/ WRIA

 

 

6.8

Move Completed WRIA to the PNW Clearinghouse

Woodall

 

 

 

6.9

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

USFS

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

7.0

Project Closure & Documentation

Paulus

14

Feb. 1, 2005

Mar 30, 2005

7.1

Finalize Western Washington Data Integration Project Documentation

Paulus

8

Feb. 1, 2005

Mar. 15, 2005

7.2

Pull together all technical documentation

Saul

4

Feb. 1, 2005

Mar. 15, 2005

7.3

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

Steering & Technical Team

2

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