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

FY07-09 proposal 200738800

Section 1. Administrative

Proposal title	Fish Passage Data System (Key Functions Previously Performed by the Fish Passage Center)
Proposal ID	200738800
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.
Proposal contact person or principal investigator

Contacts

Contact	Organization	Email
Form submitter
Nancy Walters	Pacific States Marine Fisheries Commission	nancy_walters@psmfc.org
All assigned contacts
Nancy Walters	Pacific States Marine Fisheries Commission	nancy_walters@psmfc.org

Section 2. Locations

Province / subbasin: Mainstem/Systemwide / Systemwide

Latitude	Longitude	Waterbody	Description

Section 3. Focal species

primary: Anadromous Fish

Section 4. Past accomplishments

Year	Accomplishments

Section 5. Relationships to other projects

Funding source	Related ID	Related title	Relationship
BPA	198712700	Smolt Monitoring By Non-Feder	Coordination
BPA	199008000	Columbia Basin Pit-Tag Informa	Data Programs
[Funding Source left blank]	[no entry]	COE Biological Services for Transportation Program	Smolt Monitoring
BPA	198201300	Coded-Wire Tag Recovery	Potential Geo-Referencing
BPA	198810804	Streamnet (CIS/NED)	Potential Geo-Referencing
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	Full description	Associated subbasin plan	Strategy
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
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
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.

Section 7. Work elements (coming back to this)

Work element name	Work element title	Description	Start date	End date	Est 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 Coordinate Implementation of the Smolt Monitoring			Metrics
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 Coordinate Implementation of the Smolt Monitoring			Metrics
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 Coordinate Implementation of the Smolt Monitoring			Metrics
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 Manage real-time database of smolt monitoring			Metrics
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 Manage real-time database of smolt monitoring			Metrics
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 Manage real-time database of smolt monitoring			Metrics
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 Routine analysis and reporting			Metrics
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 Routine analysis and reporting			Metrics
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 Routine analysis and reporting			Metrics
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 Manage real-time database of smolt monitoring			Metrics
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 Coordinate Implementation of the Smolt Monitoring			Metrics
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 Coordinate Implementation of the Smolt Monitoring			Metrics
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 Manage real-time database of smolt monitoring			Metrics
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 Manage real-time database of smolt monitoring			Metrics

Section 8. Budgets

Itemized estimated budget

Item	Note	FY07	FY08	FY09
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/org	Item or service provided	FY 07 est value ($)	FY 08 est value ($)	FY 09 est value ($)	Cash or in-kind?	Status
Totals		$0	$0	$0

Section 9. Project future

FY 2010 estimated budget: $1,001,342
FY 2011 estimated budget: $1,001,342

Comments: [Outyear comment field left blank]

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	Under Review
NPCC DRAFT FUNDING RECOMMENDATIONS (Sep 15, 2006) [full Council recs]
$0	$0	$0	$0		Basinwide

ISRP PRELIMINARY REVIEW (Jun 2, 2006)

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.

ISRP FINAL REVIEW (Aug 31, 2006)

Recommendation: Fundable