Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 34059: 2003-017-00 EXP ISEMP - UPPER COL SALMON RECOVERY BOARD DATA MGT
Project Number:
Title:
Integrated Status and Effectiveness Monitoring Program (ISEMP)
BPA PM:
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
34059
Contract Title:
2003-017-00 EXP ISEMP - UPPER COL SALMON RECOVERY BOARD DATA MGT
Continuation of Contract:
n/a
Contract Status:
Closed
Contract Description:
AMENDMENT DESCRIPTION

This contract amendment (CCR 12877) will facilitate the ISEMP's continued effort to standardize and document data collection, under which the program has begun adapting its existing protocols and writing 6 new protocols that contain standard operating procedures, sample design, data handling, analysis, and operational requirements.  These protocols will continue to ensure that data collection methods in the Upper Columbia in the 2008 field season and beyond will be documented and carried out in a standardized manner by data collectors aligned with the Upper Columbia Data Management Strategy.  In addition, as part of the ongoing effort to design efficient and useful data management tools, the ISEMP is updating the Aquatic Resource Schema (ARS, the database that houses the myriad data generated in the Upper Columbia annually) and building new, and updating existing, Automated Template Modules (ATM, the tools by which local data collectors enter their data into the ARS).  
Part of protocol development, and central to the development of the ARS and ATMs, is the documentation of the metadata for each protocol.  This work needs to be done in a timely manner so that the Scientific Data Management team at NOAA can update the ARS in time to allow for the ISEMP to create new ATMs and update existing ATMs for the coming 2008 field season.  This work requires knowledge of databases, familiarity with the protocols, and access to the data collectors.  

The Upper Columbia Data Steward possesses all the required skills and knowledge to perform this task quickly and efficiently.  However, part of the Data Steward’s responsibilities is to load historical data from the Upper Columbia into the ARS by June 2008, which is a time-consuming task.  In order to facilitate the Data Steward prioritizing the documenting of protocol metadata and to allow the loading of historical data to continue as scheduled, the ISEMP is proposing to fund a technician for 12 weeks from April through June to load the historical data into the ARS, work that would otherwise require a significant portion of the Data Steward’s time.  The technician would have the database skills necessary to be able to perform the task in an efficient and timely manner and would be closely supervised by the Data Steward.  The transfer of the data loading task to the temporary employee will allow the Data Steward to work on tasks that require more advanced skill sets that the Data Steward possess.  This amendment to the UCSRB’s contract with BPA is for work beginning April 1 through June 30 in the amount of: 25 hrs/week, 12 weeks @ $15/hour = $4,500, with 9% overhead = $4,905.

Project #2003-017-00 (Project) seeks to develop two novel monitoring and evaluation programs: (i) subbasin-scale pilot status and trend monitoring efforts for anadromous salmonids and their habitat in the Wenatchee, John Day and South Fork Salmon River subbasins, and (ii) effectiveness monitoring for suites of habitat restoration projects in selected watersheds within the three target subbasins.  This work – critical for implementing the 2000 NMFS FCRPS Biological Opinion (RPA Actions 180, 181, and 183) (BiOp) – builds on current status and trend monitoring programs within each of these subbasins.  Several regional and local organizations are funding and implementing these programs.  In short, this project will integrate existing and new monitoring and evaluation activities in three pilot subbasins to help ensure that provisions of the BiOp are satisfied.

This contract is one of several contracts that will implement this project.  The final report for this contract will contain data that will 1) be submitted to NOAA FISHERIES (also a contractor under this project) for use in a project level integrated Annual Report and 2) be submitted to BPA as a contract final report according to the terms of this contract.  This Scope of Work (SOW) will enable the Bonneville Power Administration (Bonneville) to help implement the Project's data management goals within the Upper Columbia region.  Specifically, within this SOW, the Upper Columbia Salmon Recovery Board (UCSRB) will oversee the administration of BPA funds to help implement the Data Steward position.

The UCSRB is developing a long-term agreement between funding entities and the UCSRB for the purpose of collaboratively funding the stewardship of the Upper Columbia region’s fish and aquatic resource data using existing Integrated Status and Effectiveness Monitoring (ISEMP) data management tools that were specifically created for use with the Upper Columbia Monitoring Strategy.  This long-term agreement is not in place as yet and since the existing infrastructure is insufficient for handling the large amounts of data being collected by the ISEMP contractors in the Wenatchee and Entiat subbasins in an efficient and timely manner, the ISEMP is helping fund the Data Steward position for one year.  The amount contributed under this BPA contract is not the full amount necessary to complete the deliverables outlined and a match will be used to fully fund the Data Steward position for the contract period.  

The Data Steward will assist all ISEMP contractors and other agencies that manage monitoring data related to fish and aquatic resources in the Upper Columbia region and do so in a coordinated fashion.  The development of a Data Steward position is founded on several successful data management developments led by the ISEMP in the Upper Columbia in recent years.  For example, the need for a coordinated data management system was specifically identified as a key objective in the Upper Columbia Regional Technical Team’s (RTT) draft Strategic Plan.   BPA and NOAA Fisheries have developed the Status,Trend and Effectiveness Monitoring (STEM) Databank, Aquatic Resources Schema (ARS)  and Automated Template Module (ATM) tools for the Wenatchee and Entiat River basin under the ISEMP.   All of these long-term status and trend monitoring efforts need to be coordinated and managed to serve local and regional needs under programmatic initiatives such as the Federal Columbia River Power System Biological Opinion (FCRPS BiOp) mandates, Endangered Species Act recovery implementation, PUD hatchery program monitoring requirements, the Northwest Power and Conservation Council’s fish and wildlife program, and State and Tribal salmon recovery and management efforts.  The Data Steward would provide technical expertise to the ISEMP contractors and other data collectors working in the Upper Columbia and would create or utilize data management tools to organize, upload, store, analyze, and report monitoring data for the Upper Columbia ESU/DPS.

Programmatic fisheries and aquatic resource management programs, such as those identified above, require a burgeoning amount of data in order to answer increasingly complicated and inter-dependent questions that help to inform a larger and more diverse set of interests.  Current ways of storing and processing fisheries and habitat data is uncoordinated.  Individual agency computers do not effectively meet the novel, evolving, and collective needs of these agencies and the public in recovery planning, effectiveness monitoring, and decision making.  By not coordinating data management needs, there is a risk of duplication of effort and wasting of resources.  Also, many agencies need data to be more accessible through a coordinated, centralized, web-based data management system.  Consequently, the development of a regionally coordinated data management system is a necessary step to effective monitoring and evaluation.
Account Type(s):
Expense
Contract Start Date:
08/15/2007
Contract End Date:
08/14/2008
Current Contract Value:
$42,070
Expenditures:
$42,070

* Expenditures data includes accruals and are based on data through 31-Aug-2019.

Env. Compliance Lead:
Work Order Number:
129074
Task Number:
1
Contract Type:
Contract
Pricing Method:
Cost Reimbursement (CNF)
Click the map to see this Contract’s location details.

Full Name Organization Write Permission Contact Type Email Work Phone
David Byrnes Bonneville Power Administration Yes COTR dmbyrnes@bpa.gov (503) 230-3171
Terry Holtcamp Jr Bonneville Power Administration No Contracting Officer taholtcamp@bpa.gov (503) 230-3518
Chris Jordan National Oceanic and Atmospheric Administration Yes Technical Contact chris.jordan@noaa.gov (541) 754-4629
Paul Krueger Bonneville Power Administration Yes F&W Approver pqkrueger@bpa.gov (503) 230-5723
Julie Morgan Upper Columbia Salmon Recovery Board Yes Contract Manager julie.morgan@ucsrb.org (509) 662-4710
Pamela Nelle Terraqua, Inc. Yes Supervisor pamela@terraqua.biz (509) 885-8143
Carol (NOAA) Volk National Oceanic and Atmospheric Administration Yes Interested Party carol.volk@noaa.gov (206) 302-2465
Mike Ward Terraqua, Inc. Yes Interested Party wardski@wildblue.net (509) 486-2426
James White Upper Columbia Salmon Recovery Board Yes Technical Contact james.white@ucsrb.org (509) 662-4142


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Complete
Coordinated data management for Upper Columbia basin A: 160. Regional database management 08/14/2008 08/14/2008
Funding Package - Submit draft to COTR B: 119. Manage and administer data steward position 06/15/2008
Attach Progress Report in Pisces C: 132. Submit Progress Report for the period Aug 15, 2007 to Aug 14, 2008 08/01/2008
2003-2006 data loaded into STEM databank E: 160. Load historical data into ISEMP STEM Databank 06/30/2008

Viewing of Implementation Metrics
Viewing of Environmental Metrics

Primary Focal Species Work Statement Elements

Sort WE ID WE Title NEPA Public Involvement NOAA USFWS NHPA Has Provisions Inadvertent Discovery Completed
A 160 Regional database management 02/09/2007
B 119 Manage and administer data steward position 02/09/2007
C 132 Submit Progress Report for the period Aug 15, 2007 to Aug 14, 2008 02/09/2007
D 185 Periodic Status Reports for BPA 02/09/2007
E 160 Load historical data into ISEMP STEM Databank 02/09/2007