FY 2007 Solicitation Homepage

Project Proposal Request for FY 2007 - FY 2009 Funding

Proposal 200738800: Fish Passage Data System (Key Functions Previously Performed by the Fish Passage Center)

Download this document in MS Word format
Open this document in PDF format

Table of Contents
Part 1. Administration and Budgeting
Section 1: General Administrative
Section 2: Project Location
Section 3: Project Species
Section 4: Past Accomplishments
Section 5: Relationship to Other Projects
Section 6: Biological Objectives
Section 7: Work Elements
Section 8: Budget
Section 9: Project Future
Section 10: Documents
Part 2. Reviews
Part 1 of 2. Administration and Budgeting
Section 1: General Administrative Information
Process Information:
Date Proposal Submitted & Finalized Status Form Generator
January 10, 2006 Finalized Nancy Walters

Proposal Type: New
Proposal Number: 200738800
Proposal Name: Fish Passage Data System (Key Functions Previously Performed by the Fish Passage Center)
Agency, Institution or Organization: Pacific States Marine Fisheries Commission (PSMFC)
Short Description: BPA issued a solicitation in December 2005 to transfer key functions previously performed by the Fish Passage Center to be transferred to other existing and capable entities in the region with a continuity of the activities. The solicitation included thr
Information Transfer: 1. Plan and implement the annual smolt monitoring program; 2. Gather, organize, analyze, house, and make widely available monitoring and research information related to juvenile and adult passage, and to the implementation of the water management and passage measures that are part of the Council’s program; 3. Provide technical information necessary to assist the agencies and tribes in formulating in-season flow and spill requests that implement the water management measures in the Council’s program, while also assisting the agencies and tribes in making sure that operating criteria for storage reservoirs are satisfied; and 4. In general, provide the technical assistance necessary to coordinate recommendations for storage reservoir and river operations that, to the extent possible, avoid potential conflicts between anadromous and resident fish.
 
Project Proposal Contacts
Contact Organization Address Phone/Email Roles Notes
Form Submitter
Nancy Walters Pacific States Marine Fisheries Commission 205 SE Spokane Street, Suite 100
Portland OR 97202-6413
Ph: 503-595-3228
Fax: 503-595-3232
Email: nancy_walters@psmfc.org
Form Submitter
All Assigned Contacts
Nancy Walters Pacific States Marine Fisheries Commission 205 SE Spokane Street, Suite 100
Portland OR 97202-6413
Ph: 503-595-3228
Fax: 503-595-3232
Email: nancy_walters@psmfc.org
Contract Manager

Section 2: Project Location
Sponsor Province: Mainstem/Systemwide ARG Province: No Change
Sponsor Subbasin: Systemwide ARG Subbasin: No Change
Location(s) at which the action will be implemented
Latitude Longitude Waterbody Location Description County/State Subbasin Primary?
No Locations Entered

Section 3: Focal Species
Focal Species:
Primary Secondary Additional Species
Anadromous Fish

Section 4: Past Accomplishments
Past Accomplishments for Each Fiscal Year of This Project This proposal is for funding a new project, and has no past accomplishments.

Section 5: Relationships to Other Projects
Other Current Projects Related to this Project (any funding source)
Funding Source Related ID Related Project Title Relationship
[Funding Source left blank] [no entry] COE Biological Services for Transportation Program Smolt Monitoring
BPA 198201300 Coded-Wire Tag Recovery Potential Geo-Referencing
BPA 198712700 Smolt Monitoring By Non-Feder Coordination
BPA 198810804 Streamnet (CIS/NED) Potential Geo-Referencing
BPA 199008000 Columbia Basin Pit-Tag Informa Data Programs
BPA 199602000 Pit Tagging Spring/Summer Chin Data Programs
BPA 199602100 Gas Bubble Disease Mon & Resea Data Programs
BPA 199701501 Imnaha R Smolt Monitoring NPT Data Programs

Section 6: Biological Objectives
Biological Objectives of this Proposed Project
Biological Objective Full Description Associated Subbasin Plan Strategy Page Nos
Coordinate Implementation of the Smolt Monitoring Implement the current (2005) sampling plan as described in manuals available on FPC website (see link in Task C, below). Provide training on data collection parameters and protocols, and provide capabilities for daily data uploads from all remote monitoring sites. Data uploads must satisfy the data transfer specifications of the entity responsible for SOW 1. Task A: Transition IN: Analyze present FPC system for supporting the work of other contractors that sample smolts and collect data at 13 remote sites. All ETL procedures are currently implemented using custom-developed FoxPro applications. None Implement the current (2005) sampling plan as described in manuals available on FPC website (see link in Task C, below). Provide training on data collection parameters and protocols, and provide capabilities for daily data uploads from all remote monitor [Pg no blank]
Manage real-time database of smolt monitoring This SOW addresses the data “warehouse” function for 2006 SMP and GBT data and other historical datasets presently housed at the FPC. It requires very close cooperation and coordination with the entity(ies) selected to coordinate data collection and uploading (SOW 3, data providers) and to perform routine data analysis and reporting (SOW 2, data user). Control of 2006 data begins when the data are uploaded from remote collection sites and ends when quality checked data are presented for public access daily (real-time) and at year-end. Real-time functionality, access to data, and measured data accuracy are critical. None Control of 2006 data begins when the data are uploaded from remote collection sites and ends when quality checked data are presented for public access daily (real-time) and at year-end. Real-time functionality, access to data, and measured data accuracy [Pg no blank]
Routine analysis and reporting Reporting will rely primarily on website access to real-time data queries and summaries, with an annual report to summarize and analyze the year’s results. The FPC website shows reports that are currently used. This SOW does NOT explicitly include statistical support to produce or revise a sampling design for 2006, assuming that the current sampling design would suffice. Analysis and reporting will use SMP data obtained via the internet from the entity responsible for SOW 1 and secondary data obtained from other websites. None Analysis and reporting will use SMP data obtained via the internet from the entity responsible for SOW 1 and secondary data obtained from other websites. [Pg no blank]

Section 7: Work Elements
Work Elements and Associated Biological Objectives
Work Element Name Work Element Title Description Start Date End Date Estimated Budget
Produce Environmental Compliance Documentation Produce Environmental Compliance Documentation PSMFC will prepare and submit any required ESA applications, modifications, and compliance reporting. Because the Smolt Monitoring Program is considered to be an integral part of Systems operation in the NMFS Biological Opinion , PSMFC has contacted NOAA Fisheries to determine whether the programs are either: 1) covered under existing take authorization; or 2) whether additional take authorization is needed; or 3) to proceed under Section 10, Section 7, or one of the 4(d) limits. It is our preliminary understanding that the ESA take authorization will not be needed. If needed, PSMFC will develop a submittal package for NOAA. PSMFC will be responsible for preparing and submitting all permit compliance reports. 3/1/2007 2/28/2010 $166,729
Biological Objectives Metrics
Coordinate Implementation of the Smolt Monitoring
No Metrics for this Work Element

Provide Technical Review Provide Technical Review PSMFC will relocate existing hardware and software systems and infrastructure that have been in operation for years. Initially, this equipment will be operated in ‘as-is’ condition. PSMFC will develop a plan to modernize these systems and infrastructure in order to better manage the reliability required for this real-time system. 3/1/2007 2/28/2010 $194,517
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element

Provide Technical Review Provide Technical Review The objective of a fishway inspection is to assess passage conditions at the time of the inspection and assure that facilities are operating according to established criteria. The agency inspector is responsible for coordinating immediate problems or out-of-criteria conditions to project personnel for resolution. The inspection reports and this final report by the Operations Coordinator will serve to alert the operating agency of problems that were noted during the inspections and areas that may require resolution. The Fishway Inspection Program implements decisions regarding operation of juvenile and adult facilities, including special operations such as outages and emergency maintenance. 3/1/2007 2/28/2010 $166,729
Biological Objectives Metrics
Coordinate Implementation of the Smolt Monitoring
No Metrics for this Work Element

Provide Technical Review Provide Technical Review Description: Implement the current (2005) sampling plan as described in manuals available on the FPC website. Provide training on data collection parameters and protocols, and provide capabilities for daily data uploads from all remote monitoring sites. Data uploads must satisfy the data transfer specifications of the entity responsible for SOW 1. PSMFC assumes that the SMP policy board and technical steering committee will develop the future SMP program design. 3/1/2007 2/28/2010 $166,729
Biological Objectives Metrics
Coordinate Implementation of the Smolt Monitoring
No Metrics for this Work Element

Create/Manage/Maintain Database Create/Manage/Maintain Database The relational data stored in the SQL-Server operational database is replicated near-real time using transactional replication services that are purchased off-the-shelf from Microsoft. This architecture implements a flexible concurrency management strategy by allowing one set of data to be modified, while the other set of data is essentially read only. This minimizes lock contention of the DBMS and improves overall performance of the system 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element

Create/Manage/Maintain Database Create/Manage/Maintain Database Reporting will rely primarily on website access to real-time data queries and summaries, with an annual report to summarize and analyze the year’s results. The FPC website shows reports that are currently used. This SOW does NOT explicitly include statistical support to produce or revise a sampling design for 2006, assuming that the current sampling design would suffice. Analysis and reporting will use SMP data obtained via the internet from the entity responsible for SOW 1 and secondary data obtained from other websites. 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Routine analysis and reporting
No Metrics for this Work Element

Create/Manage/Maintain Database Create/Manage/Maintain Database PSMFC Information Technology Services will provide for the routine and non-routine archive / backup and recovery of the SMP Fish Passage Data System which includes all system objects such as files, data, databases, source codes, DDL, documentation and other assets. The standard backup process includes daily incremental backups stored on-site, and weekly full backups. Full system backups are stored at a safe location separate from PSMFC 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element

Disseminate Raw/Summary Data and Results Disseminate Raw/Summary Data and Results Provide routine Smolt Monitoring, Gas Bubble, Water Condition, Spawning, Adult, Hatchery data and analysis. 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Routine analysis and reporting
No Metrics for this Work Element

Disseminate Raw/Summary Data and Results Disseminate Raw/Summary Data and Results PSMFC proposes to maintain the “Weekly Report” that is developed and distributed to Fisheries Managers and other interested parties. 3/1/2007 2/28/2010 $166,729
Biological Objectives Metrics
Coordinate Implementation of the Smolt Monitoring
No Metrics for this Work Element

Disseminate Raw/Summary Data and Results Disseminate Raw/Summary Data and Results PSMFC will provide internet access to the SMP data warehouse (conceptually illustrated as the “Obtain SMP Data” dataflow). The warehouse will include data stored in the SQL-Server database, raw files, documentation and other type of information. The data will be available via HTTP or FTP protocols utilizing PSMFC computing facilities infrastructure. PSMFC Information Technology Services will provide for the routine and non-routine archive / backup and recovery of the SMP Fish Passage Data System which includes all system objects such as files, data, databases, source codes, DDL, documentation and other assets. The standard backup process includes daily incremental backups stored on-site, and weekly full backups. Full system backups are stored at a safe location separate from PSMFC headquarters office. 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element

Disseminate Raw/Summary Data and Results Disseminate Raw/Summary Data and Results Internet users will specify a query in their internet web browser, the query will access the FPDS SQL Server database (or file systems) and data will be delivered back to the end user. 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Routine analysis and reporting
No Metrics for this Work Element

Submit/Acquire Data Submit/Acquire Data PSMFC will utilize existing data structures, processes and methods to collect and transmit SMP data. These methods are described in the FPC32 application -- the "FPC32 Smolt Monitoring Program Remote Site Data Entry Program" 3/1/2007 2/28/2010 $166,729
Biological Objectives Metrics
Coordinate Implementation of the Smolt Monitoring
No Metrics for this Work Element

Submit/Acquire Data Submit/Acquire Data PSMFC will provide any assistance and specifications that are defined in "FPC32 Smolt Monitoring Program Remote Site Data Entry Program" to any entity in order to facilitate the collection and uploading of SMP data 3/1/2007 2/28/2010 $194,517
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element

Submit/Acquire Data Submit/Acquire Data PSMFC will audit incoming data regularly for completeness and accuracy as described in SOW 1. PSMFC will utilized the methods adapted from “Sampling Techniques ” and documented by the FPC Biometrician. 3/1/2007 2/28/2010 $222,305
Biological Objectives Metrics
Manage real-time database of smolt monitoring
No Metrics for this Work Element


Section 8: Budget

Itemized Estimated Budget
Item Note FY 2007 Cost FY 2008 Cost FY 2009 Cost
Personnel [blank] $488,591 $508,136 $528,460
Fringe Benefits [blank] $193,590 $201,333 $209,387
Supplies [blank] $89,128 $92,693 $96,401
Travel [blank] $7,582 $7,885 $8,200
Overhead [blank] $111,298 $115,750 $120,380
Totals $890,189 $925,797 $962,828

Total Estimated FY 2007-2009 Budgets
Total Itemized Budget$2,778,814
Total Work Element budget$2,778,814

Cost sharing
Funding Source or Organization Item or Service Provided FY 2007 Est Value ($) FY 2008 Est Value ($) FY 2009 Est Value ($) Cash or in-kind? Status

Section 9: Project Future
Project Future Costs and/or Termination
FY 2010 Est Budget FY 2011 Est Budget Comments
$1,001,342 $1,041,395 [Outyear comment field left blank]
Future Operations & Maintenance Costs
 
Termination Date Comments
 
Final Deliverables

Section 10: Narrative
Document Type Size Date

Part 2 of 2. Reviews of Proposal
Administrative Review Group (ARG) Results
Account Type:
Expense
No changes were made to this proposal


BPA's in lieu Funding Review of new project proposals (August 3, 2006) [Download letter and table]

BPA's in lieu Rating: 1.0
Approx. BPA share of total costs: BPA 100%
Status of Cost Share:
Notes: FPC (assume all activities are included in program or mainstem amendment)


NPCC Final Funding Recommendations (October 23, 2006) [Full NPCC Council Recs]

FY 2007 Budget
$ 0
FY 2008 Budget
$ 0
FY 2009 Budget
$ 0
Total NPCC Rec
$ 0
Budget Type:Expense
Budget Category:Basinwide
Recommendation:Under Review
Comments: A portion of the unallocated balance will be available for the Council to make final project funding recommendations for fish passage science and analysis.


NPCC Draft Funding Recommendations (September 15, 2006) [Full NPCC Council Recs]

FY 2007 Budget
$ 0
FY 2008 Budget
$ 0
FY 2009 Budget
$ 0
Total NPCC Rec
$ 0
FY 2007 MSRT Rec
$ 0
FY 2008 MSRT Rec
$ 0
FY 2009 MSRT Rec
$ 0
Total MSRT Rec
$ 0
Budget Category:Basinwide
Comments: A portion of the unallocated balance will be available for the Council to make final project funding recommendations for fish passage science and analysis.


Independent Scientific Review Panel Final Review (August 31, 2006) [Download full document]

Recommendation: Fundable
NPCC Comments: This is a proposal to replace most of the functions of the current Fish Passage Center (FPC), which is a required element in the Fish and Wildlife Program. This proposal provides clearly defined objectives and work elements, and the methods for each work element are sufficiently detailed. The ISRP rates this proposal as fundable. The ISRP recommends close coordination with Project Proposal ID# 200728700 (if funded) because that project will have a coordination role of several former fish passage center functions and provide a review process for technical analysis and technical products.

Although not required to respond, we include other comments for the sponsors to consider:

Rationale and significance to subbasin plans and regional programs: The Council’s Mainstem Amendments (2003) should be referred to as requiring this project to provide technical support to the state, tribal, and federal fishery managers.

Project history: This section was stated as not applicable. However, for such a long-running project there have been a number of important accomplishments and completed documents that could be listed in this section. At least a one-page summary should be included.

Monitoring and evaluation: The major functions of the FPC are M&E. However, the proposal includes nothing regarding the broader monitoring aspects such as coordinating or participating with other regional RM&E programs such as CSMEP. The proposal needs to provide some detail of how they will develop this broader monitoring plan and give details of how they will coordinate and participate with other regional RM&E programs.

Facilities, equipment, and personnel: A good description of facilities and equipment is provided. An organizational chart with names and positions is included and is helpful. However, resumes for personnel on the chart are not provided and should be, so reviewers can determine if personnel have necessary qualifications for accomplishing the project.


Independent Scientific Review Panel Preliminary Review (June 2, 2006) [Download full document]

Recommendation: Fundable
NPCC Comments: This is a proposal to replace most of the functions of the current Fish Passage Center (FPC), which is a required element in the Fish and Wildlife Program. This proposal provides clearly defined objectives and work elements, and the methods for each work element are sufficiently detailed. The ISRP rates this proposal as fundable. The ISRP recommends close coordination with Project Proposal ID# 200728700 (if funded) because that project will have a coordination role of several former fish passage center functions and provide a review process for technical analysis and technical products.

Although not required to respond, we include other comments for the sponsors to consider:

Rationale and significance to subbasin plans and regional programs: The Council’s Mainstem Amendments (2003) should be referred to as requiring this project to provide technical support to the state, tribal, and federal fishery managers.

Project history: This section was stated as not applicable. However, for such a long-running project there have been a number of important accomplishments and completed documents that could be listed in this section. At least a one-page summary should be included.

Monitoring and evaluation: The major functions of the FPC are M&E. However, the proposal includes nothing regarding the broader monitoring aspects such as coordinating or participating with other regional RM&E programs such as CSMEP. The proposal needs to provide some detail of how they will develop this broader monitoring plan and give details of how they will coordinate and participate with other regional RM&E programs.

Facilities, equipment, and personnel: A good description of facilities and equipment is provided. An organizational chart with names and positions is included and is helpful. However, resumes for personnel on the chart are not provided and should be, so reviewers can determine if personnel have necessary qualifications for accomplishing the project.

Maintained by the Columbia Basin Fish & Wildlife Authority. Please direct comments or questions to the webmaster.