FY07-09 proposal 200704700

Jump to Reviews and Recommendations

Section 1. Administrative

Proposal titleHydrography Spatial Data Enhancement Project - WDFW & WDNR Operational Data Updates and Integration to the PNW Hydrography Clearinghouse for the WA Columbia Basin
Proposal ID200704700
OrganizationInteragency Committee (IAC)
Short descriptionSynchronize Washington State’s regulatory data improvements with the regions hydrography data. WDFW and WDNR, data additions and updates from their stream typing and fish habitat databases with be identified and assessed for inclusion.
Information transferAll hydrography data updates will be loading into the PNW Hydrography Clearinghouse for access and download by all organizations and the public free of charge.
Proposal contact person or principal investigator
Contacts
ContactOrganizationEmail
Form submitter
Joy Paulus Salmon & Watershed Information joyp@iac.wa.gov
All assigned contacts

Section 2. Locations

Province / subbasin: Mainstem/Systemwide / Systemwide

LatitudeLongitudeWaterbodyDescription
Eastern WA - Whole Columbia Basin. WRIA's 25 to 62 where applicable

Section 3. Focal species

primary: All Anadromous Fish
primary: All Anadromous Salmonids
secondary: All Anadromous Fish
secondary: All Anadromous Salmonids

Section 4. Past accomplishments

YearAccomplishments

Section 5. Relationships to other projects

Funding sourceRelated IDRelated titleRelationship
Other: SWIMTAC/USFS [no entry] WA Hydrography Federal & State Data Integration Projects This project builds off the success of the WA Federal & State Hydrography Data Integration Projects. See details at: http://www.ecy.wa.gov/services/gis/data/hydro/24k/eastern/EasternProjectPlan2.htm and at: http://www.ecy.wa.gov/services/gis/data/hydro/24k/wahyfw24k-w.htm This project will help support NHD and StreamNet efforts in the region by providing more accurate and updated data from the states regulatory agencies.

Section 6. Biological objectives

Biological objectivesFull descriptionAssociated subbasin planStrategy
Hydro Base Data For Biological Data Collection Creates and maintains the spatial hydro data that's needed to support and tie biological field data collection efforts to an integrated fed/state spatial data set None [Strategy left blank]

Section 7. Work elements (coming back to this)

Work element nameWork element titleDescriptionStart dateEnd dateEst budget
Create/Manage/Maintain Database Year 1 - Assessment & Start up of Columbia Basin Integration Enhancement Project kick-off, planning and agreements from participants and contract hiring 11/1/2006 1/12/2007 $22,836
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - Define Integrate Decision Rules and Procedures Define Integrate Decision Rules and Procedures - Procedural documents for data enhancement integration 1/15/2007 3/16/2007 $11,884
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - Pilot Project Results & Acceptance Project Team Buy-off on Pilot Project Results & Accepted procedures and results from Testing Phase 5/7/2007 5/14/2007 $10,253
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - PNW Hydro Clearinghouse Infrastructure Contractor Support The Clearinghouse is used to store hydrography data for Washington, Oregon, and northern California. It is an ArcIMS site dedicated to the storage and retrieval of data and allows partners the ability to checkout areas of interest, perform edits to the data, and then resubmit data back to the Framework. This covers contractor costs for: Application support; ArcSDE administration; Support of the transaction environment: Oracle database administration; Systems administration; and Telecommunication services. 11/1/2006 9/30/2007 $25,000
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - Production Implementation Schedule Set Production Implementation Schedule Set - Documented cost & implementation schedule for the integration of remaining 15 WRIA 5/14/2007 5/25/2007 $3,495
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - Production Integration on 15 Columbia Basin WRIA’s 26 - 40 Production Integration on 15 Columbia Basin WRIA’s 26 - 40 - Fully integrated hydrography framework data posted to the PNW Hydro Clearinghouse of 5/28/2007 9/30/2007 $335,750
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 1 - WRIA 25 Pilot Project Programming and Procedural Documentation, Training and Integration Test Against WRIA 25 Pilot Project - integrated watercourse, water bodies, water shoreline data for WRIA 25 loaded into the PNW Clearinghouse 3/18/2007 4/30/2007 $197,661
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 2 - PNW Hydro Clearinghouse Infrastructure Contractor Support The Clearinghouse is used to store hydrography data for Washington, Oregon, and northern California. It is an ArcIMS site dedicated to the storage and retrieval of data and allows partners the ability to checkout areas of interest, perform edits to the data, and then resubmit data back to the Framework. This covers contractor costs for: Application support; ArcSDE administration; Support of the transaction environment: Oracle database administration; Systems administration; and Telecommunication services. 10/1/2007 9/30/2008 $25,000
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 2 - Production Implementation Schedule Set Production Implementation Schedule Set - Procedural documents for data enhancement integration are finalized 10/1/2007 10/30/2007 $4,728
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 2 - Production Integration on 20 Columbia Basin WRIA’s 41 – 62 Production Integration on 20 Columbia Basin WRIA’s 41 – 62 - Documented cost & implementation schedule for the integration of remaining 20 Year 2 WRIA’s in the Columbia Basin 11/1/2007 9/30/2008 $448,057
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 3 - PNW Hydro Clearinghouse Infrastructure Contractor Support The Clearinghouse is used to store hydrography data for Washington, Oregon, and northern California. It is an ArcIMS site dedicated to the storage and retrieval of data and allows partners the ability to checkout areas of interest, perform edits to the data, and then resubmit data back to the Framework. This covers contractor costs for: Application support; ArcSDE administration; Support of the transaction environment: Oracle database administration; Systems administration; and Telecommunication services. 10/1/2008 9/30/2009 $25,000
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 3 - Production Implementation Schedule Set Production Implementation Schedule Set - Documented cost & implementation schedule for the integration of 13 ID/OR cross-border WRIA’s in the Columbia Basin 10/1/2008 10/30/2008 $8,888
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 3 - Production Integration on 13 WRIA’s Bordering ID & OR Production Integration on 13 WRIA’s Bordering ID & OR - Fully integrated cross border hydrography framework data posted to the PNW Hydro Clearinghouse 11/1/2008 7/30/2009 $210,808
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics
Create/Manage/Maintain Database Year 3 - Project Closure & Documentation Project Closure & Documentation - Complete set of project, programming and technical documents for use and acceptance of the final project product 8/1/2009 9/30/2009 $16,816
Biological objectives
Hydro Base Data For Biological Data Collection
Metrics

Section 8. Budgets

Itemized estimated budget
ItemNoteFY07FY08FY09
Personnel State GIS Technical Staff $87,786 $50,479 $28,618
Fringe Benefits State GIS Technical Staff $18,435 $10,601 $6,010
Overhead State GIS Staff - salaries & benefits $42,095 $24,206 $13,723
Capital Equipment 3 Servers $40,063 $0 $0
Travel Cross border coordination $0 $0 $4,160
Other GIS Contracting Services - programming & analysis $393,500 $367,500 $184,000
Other PNW Clearinghouse Infrastructure Support Services $25,000 $25,000 $25,000
Totals $606,879 $477,786 $261,511
Total estimated FY 2007-2009 budgets
Total itemized budget: $1,346,176
Total work element budget: $1,346,176
Cost sharing
Funding source/orgItem or service providedFY 07 est value ($)FY 08 est value ($)FY 09 est value ($)Cash or in-kind?Status
Ecology Staff Support $2,133 $450 $450 In-Kind Confirmed
WDFW Staff Support $2,133 $450 $450 In-Kind Confirmed
WDNR Staff Support $2,133 $450 $450 In-Kind Confirmed
Totals $6,399 $1,350 $1,350

Section 9. Project future

FY 2010 estimated budget: $0
FY 2011 estimated budget: $0
Comments:

Future O&M costs:

Termination date:
Comments:

Final deliverables:

Section 10. Narrative and other documents


Reviews and recommendations

FY07 budget FY08 budget FY09 budget Total budget Type Category Recommendation
NPCC FINAL FUNDING RECOMMENDATIONS (Oct 23, 2006) [full Council recs]
$0 $0 $0 $0 Expense Basinwide Do Not Fund
NPCC DRAFT FUNDING RECOMMENDATIONS (Sep 15, 2006) [full Council recs]
$0 $0 $0 $0 Basinwide

ISRP PRELIMINARY REVIEW (Jun 2, 2006)

Recommendation: Not fundable

NPCC comments: The authors propose to enhance the collection and organization of spatial hydrography data for Washington, Oregon, and Northern California, and make it readily and freely available on the web. The value of well-integrated natural resource databases for a variety of users can be imagined. However, the proposal provides no references to establish the need for these databases or how extensively they are (would be) used. URLs that point the reviewer to the existing databases are found at the end of the narrative, but the proposal gives no sense of how the integration of these databases could have fish and wildlife benefits in the Columbia River Basin. The Fish and Wildlife Program, BiOp's, or other such plans or programs are not mentioned. Other, Washington-state datasets are discussed in a general way, but no specifics or references/URLs are provided. The proponents made very little attempt to link this effort with other Fish and Wildlife Program supported projects. It is not clear how this activity would be linked to all the other databases in the Columbia River Basin, if at all. This effort began as regional partnership for development of data sharing system. How does this relate to StreamNet? Do we have duplication? There are a lot of other systems doing similar things, but the issue of duplication is not addressed. They should describe how this system would work in relation to all other database efforts in the Fish and Wildlife Program. The proposal provides a very detailed presentation of objectives and specific tasks, with detailed timelines (even meetings are scheduled). This is a good, systematic plan for accomplishing the tasks, starting with setting up rules for incorporating and integrating data. After that data rules are established, WRIA 25 would be implemented as a test case. After appropriate adjustments, including feedback from the agencies, they would proceed to implement the other WRIAs. The only thing missing is a tie to particular Columbia River Basin objectives. This project might have many benefits to focal and non-focal species, but the specific value of this effort/datasets was not addressed in the proposal. No qualifications statements/resumes for the participants are provided.


ISRP FINAL REVIEW (Aug 31, 2006)

Recommendation: Not fundable

NPCC comments: The authors propose to enhance the collection and organization of spatial hydrography data for Washington, Oregon, and Northern California, and make it readily and freely available on the web. The value of well-integrated natural resource databases for a variety of users can be imagined. However, the proposal provides no references to establish the need for these databases or how extensively they are (would be) used. URLs that point the reviewer to the existing databases are found at the end of the narrative, but the proposal gives no sense of how the integration of these databases could have fish and wildlife benefits in the Columbia River Basin. The Fish and Wildlife Program, BiOp's, or other such plans or programs are not mentioned. Other, Washington-state datasets are discussed in a general way, but no specifics or references/URLs are provided. The proponents made very little attempt to link this effort with other Fish and Wildlife Program supported projects. It is not clear how this activity would be linked to all the other databases in the Columbia River Basin, if at all. This effort began as regional partnership for development of data sharing system. How does this relate to StreamNet? Do we have duplication? There are a lot of other systems doing similar things, but the issue of duplication is not addressed. They should describe how this system would work in relation to all other database efforts in the Fish and Wildlife Program. The proposal provides a very detailed presentation of objectives and specific tasks, with detailed timelines (even meetings are scheduled). This is a good, systematic plan for accomplishing the tasks, starting with setting up rules for incorporating and integrating data. After that data rules are established, WRIA 25 would be implemented as a test case. After appropriate adjustments, including feedback from the agencies, they would proceed to implement the other WRIAs. The only thing missing is a tie to particular Columbia River Basin objectives. This project might have many benefits to focal and non-focal species, but the specific value of this effort/datasets was not addressed in the proposal. No qualifications statements/resumes for the participants are provided.