FY 2007 Solicitation Homepage

Project Proposal Request for FY 2007 - FY 2009 Funding

Proposal 199601900: Technical Management Team (TMT)

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 Christine Muongchanh

Proposal Type: Ongoing
Proposal Number: 199601900
Proposal Name: Technical Management Team (TMT)
BPA Project Manager: John Piccininni
Agency, Institution or Organization: University of Washington
Short Description: The project provides single-point, internet-based access to a subset of information to guide and support BPA's independent decisions pertaining to its responsibilities under the Power Act and Endangered Species Act, as well as tools for data analysis.
Information Transfer: The expected outcomes of the project are quantitative. Data generated by this project are primary and there are no restrictions on the use of the data. The public can acess data through DART website: www.cbr.washington.edu.
 
Project Proposal Contacts
Contact Organization Address Phone/Email Roles Notes
Form Submitter
Christine Muongchanh University of Washington 1325 - 4th Ave., Suite 1820
Seattle, WA 98101
Ph: [left blank]
Fax: 206-616-7452
Email: cket@cbr.washington.edu
Form Submitter
All Assigned Contacts
Jim Anderson
Ph:
Fax:
Email: jim@cbr.washington.edu
Project Lead
Christine Muongchanh University of Washington 1325 - 4th Ave., Suite 1820
Seattle, WA 98101
Ph: [left blank]
Fax: 206-616-7452
Email: cket@cbr.washington.edu
Form Submitter

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
All Anadromous Salmonids
Resident Fish

Section 4: Past Accomplishments
Past Accomplishments for Each Fiscal Year of This Project
Fiscal Year Accomplishments
2005 Updated and enhanced PIT Tag Adult Returns Observation Summary report to include by Brood Year summary option; Updated Pacific Northwest Index, a terrestrial climate index, for 1891-2004 based on data from National Climatic Data Center
2004 Provided more than 61 special data analyses by request to users; Fully integrated YKFP adult passage data into DART through a distributed database solution; Expanded Columbia Basin Performance Measures analysis tool
2003 Assisted Yakima-Klickitat Fisheries Project (YKFP) database development and assimilated historical YKFP adult counts at Prosser and Roza dams; Developed and launched Adult ESU Travel Time analysis web pages; DART served 357,976 individual data requests
2002 Expanded Bonneville adult passage dataset back through 1949; added coil specific PIT-tag data to allow CJS survival and travel-time analysis; launched release summary query at ISAB request; Added Tag Coordinator as standard PIT-tag query selection
2001 Interacted & coordinated w/expanded number of primary sites; Acquired and assimilated USGS Historical water temperature data for the Snake River Basin, as well as USACE mainstem turbidity data; Extended current ESU definitions and reports to historical yr
2000 17,481 weekly accesses in Apr 2000; Added oceanographic and climate data; upgraded DART to E-450 Solaris; Gave ISRP review of DART and on-site demo at CBR/UW; Tested conversion to Oracle capabilities w/recommendations to BPA; Added JavaDart
1999 10,590 weekly accesses in April 1999; Added hourly water quality at USACE's request; Upgraded graphics; Upgraded and added new reporting functions for USGS and USACE; Y2K conversion for all internal applications; Responded to 238K web users via DART web
1998 Interacted and coordinated with primary sites; 10,643 weekly accesses in April 1998; Updated processing scripts; Added PNI Index, recreational fishing page; Updated USGS data; System upgrade and migration to data warehouse status; Built PIT Tag ESU
1997 Interacted and coordinated with primary sites; 10,010 weekly accesses in Apri 1997; Updated processing scripts; Added adult features; Added CWT data, USGS data; Daily maintenance and backups; BPA interface for TMT requests; Automated reporting to USACE
1996 Interacted and coordinated with primate sites (PSMFS, USACE, FPC); 3,736 weekly accesses in April 1996; Added new river and PIT-Tag features; Created numerous reports, scripts and web pages; created data processing scripts; added new databases
1995 Initial analysis, design, and implementation of DART; 1,358 weekly accesses in Dec 1995; Designed DART main web page; Inter-organizational contact and coordination; Automated data acquisition; Graphics design (joint effort w/Dr. Skalski's group)

Section 5: Relationships to Other Projects
Other Current Projects Related to this Project (any funding source)
Funding Source Related ID Related Project Title Relationship
BPA 198712700 Smolt Monitoring By Non-Feder Collaborate with Council projects to provide a full suite of reporting and analysis functions to support the Smolt Monitoring Project# 1987-127-00.
BPA 198812025 YKFP Management, Data, Habitat DART maintains an ODBC connection to the primary YKFP database and provides synchronized reporting of the YKFP adult passage data.
BPA 198910800 Modeling & Eval Supp/Crisp Provide raw data, technical support services, database services, and web access to analyses produced by Proj# 1989-108-00. Analyses produced by this project include: predictions of smolt out-migration timing, adult upstream migration timing, and water quality conditions.
BPA 199008000 Columbia Basin Pit-Tag Informa DART works in close association with PTAGIS, defining data file formats for daily data transfer and providing Data quality feeback to PTAGIS and Tag Coordinators.
BPA 199105100 M&E Statistical Support For Li Provide raw data, technical support services, database services, and web access to the statistical tools and RM&E analyses produced by Proj# 1991-051-00: Adult Escapement, PIT Tag Survival and Travel Time Analysis, Coded-Wire-Tag Smolt-to-Adult Ratios, and predictions of smolt out-migration timing.
BPA 199602100 Gas Bubble Disease Mon & Resea Collaborate with Council projects to provide a full suite of reporting and analysis functions to support the Gas Bubble Disease Monitoring & Research Project# 1996-021-00.

Section 6: Biological Objectives
Biological Objectives of this Proposed Project There are no biological objectives associated with this proposal.

Section 7: Work Elements
Work Elements and Associated Biological Objectives
Work Element Name Work Element Title Description Start Date End Date Estimated Budget
Coordination Coordination with Regional Entities We will review the 2006 services through a series of meetings with regional entities. In response to the review, we will propose changes to the web tools and reports to better meet the reporting and analysis needs of the region. 10/1/2006 9/30/2009 $18,461
Biological Objectives Metrics
No Metrics for this Work Element

Manage and Administer Projects Project Management Manage the project work flow, financial management and other administrative functions related to the project. 10/1/2006 9/30/2009 $221,534
Biological Objectives Metrics
No Metrics for this Work Element

Manage and Administer Projects Quarterly Reports We will generate the progress reports in Pisces two weeks after each quarter. 10/1/2006 9/30/2009 $41,621
Biological Objectives Metrics
No Metrics for this Work Element

Produce Annual Report Summary of work accomplishments At the end of the fiscal year, we will generate an annual report that summarizes the accomplishments for the year. 10/1/2006 9/30/2009 $35,580
Biological Objectives Metrics
No Metrics for this Work Element

Produce Status Report Fish Passage Routine Reports Should reporting and analysis functions of the FPC be amended to DART, we will generate web-based weekly status reports and annual reports of adult and juvenile passage. We will also prepare reports required as part of the permitting process for the smolt monitoring program. 10/1/2006 9/30/2009 $154,402
Biological Objectives Metrics
No Metrics for this Work Element

Analyze/Interpret Data Regional Monitoring and Evaluation Services Provide monitoring, evaluation, and data products and services (via the Internet) on single and associated FWP-funded and ESA-mandated activities, especially efforts to predict, track, and evaluate the efficacy of proposed or actual actions. A variety of tools are provided to allow independent evaluation of life-stage survival of ESA-listed salmon and steelhead, including hydrosystem survival performance rates required by current biological opinions and as adopted in FWP. Services will be functional throughout the calendar year with a focus on providing in-depth support during juvenile and adult migration seasons. 10/1/2006 9/30/2009 $283,630
Biological Objectives Metrics
No Metrics for this Work Element

Analyze/Interpret Data University Fish Passage Consortium Analysis The University Fish Passage Consortium will conduct analysis and review of pre-season, in-season and post-season fish passage monitoring, reports, and analysis. Analysis may also include review of the fish passage monitoring program and specific analysis of issues brought to the Consortium by state and tribal fisheries agencies. The results will be reported to the NPCC through the ISAB. 10/1/2006 9/30/2009 $221,534
Biological Objectives Metrics
No Metrics for this Work Element

Create/Manage/Maintain Database Database and System Administration Provide, maintain, and improve fundamental hardware, software, and procedural systems necessary for this scope of work. Database design, tuning, and development work will continue in order to meet the demands of increasingly complex, resource-intensive data integration and analysis. Maintaining and upgrading the database architecture is essential to efficiently support our expanding data services, both for in-house analysis needs and requests from public and private users. We will continue to develop QA/QC procedures and policies for all integrated data sets and coordinate with primary sources to provide feedback. Our database facilities are maintained using scheduled semi-weekly database mirroring and backups and daily data uploads. Daily local area network operations are maintained by our system administrator. We maintain a service contract on the Sun Enterprise 450 Server, which insures that any equipment failures are repaired in 24 hours. 10/1/2006 9/30/2009 $392,719
Biological Objectives Metrics
No Metrics for this Work Element

Disseminate Raw/Summary Data and Results Data Access in Real Time (DART) Internet Service Continue to provide the publicly accessible, web-enabled Columbia River DART (Data Access in Real Time) query system and web site. DART permits interactive selection of data items, time frame, presentation format, etc. from an integrated subset of historical and current fishery, hydrographic, project operation, and environmental information vital to year-round planning and in-season decision-making for operation of the Federal Columbia River Power System. Data is presented in user-selected formats including graphics, data tables (CSV compatible) and HTML tables. The services are to be functional throughout the calendar year. Scheduled biweekly database mirroring and backups and daily data uploads limit access to 95% of a 24/7 schedule. Database mirroring and backups occurs between 1 am to 5 am when usage of the database would be limited. The daily data uploads are coordinated with data availability from primary sources in order to provide the most up-to-date data as it is made available. This work element would include the routine reporting of fish passage data including the addition of descaling, fork-length, sampling mortality, GBT and incidental species catch data from the Smolt Monitoring Program and Gas Bubble Trauma monitoring efforts. It would also include the expanded reporting of hourly water quality data relevant to fish. 10/1/2006 9/30/2009 $265,169
Biological Objectives Metrics
No Metrics for this Work Element

Submit/Acquire Data Acquire/Integrate Current and Historical Datasets Interact with regional data managers to increase collections of historic data sets not yet available via the Internet, then merge and load data into the database for access via the website. Data sets will be added as directed by BPA and regional needs. We will develop and employ automated and manual processes to acquire, merge and load the data into the database. Specific information available for integration includes expanded parameters and locations on ocean conditions, pacific climactic oscillation indices, and local adult passage counts from state and tribal sources. This work element would include the data collection needs to report and analyze fish passage data, including adult dam counts, smolt counts and indices, smolt mortalities, descaling, fork-length and GBT information. 10/1/2006 9/30/2009 $93,984
Biological Objectives Metrics
No Metrics for this Work Element


Section 8: Budget

Itemized Estimated Budget
Item Note FY 2007 Cost FY 2008 Cost FY 2009 Cost
Personnel FTEs: PI, data mgr, operations mgr, web specialist, res. consultant, analyst, computer support $230,725 $241,791 $253,409
Fringe Benefits % varies by faculty & staff status $62,329 $65,336 $68,494
Supplies Books, misc. hardware and software $1,500 $1,500 $1,500
Travel Up to 7 trips to regional meetings related to project $6,092 $6,092 $6,092
Capital Equipment 1st yr upgrade Sun Server; thereafter PC replacements $70,000 $2,000 $3,000
Overhead FAC at 26% of Total Modified Direct Costs $79,616 $83,301 $87,169
Other Services and lease $23,170 $24,270 $25,370
Other Subcontract: University Fish Passage Analysis Group $124,210 $128,635 $133,033
Totals $597,642 $552,925 $578,067

Total Estimated FY 2007-2009 Budgets
Total Itemized Budget$1,728,634
Total Work Element budget$1,728,634

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
$ 0 $ 0
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


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

FY 2007 Budget
$331,279
FY 2008 Budget
$277,279
FY 2009 Budget
$277,279
Total NPCC Rec
$885,837
Budget Type:Expense
Budget Category:Basinwide
Recommendation:Fund
Comments:


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

FY 2007 Budget
$331,279
FY 2008 Budget
$277,279
FY 2009 Budget
$277,279
Total NPCC Rec
$885,836
FY 2007 MSRT Rec
$331,279
FY 2008 MSRT Rec
$277,279
FY 2009 MSRT Rec
$277,279
Total MSRT Rec
$885,836
Budget Category:Basinwide
Comments:

Local or MSRT Comments: Tasks within the three fish passage monitoring projects (199105100, 199601900, and 200732100) need to be well coordinated to avoid duplication. This project should receive a slight increase (5%) to their FY 2006 budget level to support increased costs. A one time expense of $54,000 has been included in FY 2007 for the purchase of a new server.


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

Recommendation: Fundable (Qualified)
NPCC Comments: This is an exemplary proposal among the database projects, for a project that appears to provide products of widespread use and value. The project title should be probably be changed, however, to reflect the fact that this is DART enhanced with additional analytical functions. The primary significance to regional programs is to the Power Act sections requiring improved passage survival and flows. The proposal includes excellent M&E.

The proposal presents a brief but clear background on the utility of the second-tier database provided by this project, although the ultimate value of this data to fish management is not explicitly described. A clear rationale is provided for the need for the integrated environmental data and fish passage data and analysis provided by DART. Detailed lists of the analyses provided by DART are included, as well as a number of analyses for which data and analytical assistance was provided.

The project’s history is described in an excellent interpretive narrative on actions tied to their accomplishments, the process of their evolution and the reasons why. It discusses the types of internal monitoring performed through post-season analysis of passage predictions. A figure of monthly usage from 1998-2005 is provided, as well as a list of entities using DART between 2004-2005, and the number of hosts served by season. Less clear, however, is how useful this information has been to all the regional entities that tapped it. Also, how is this information accessed? Are the raw data they capture and make available checked for accuracy? Are DART analyses peer-reviewed? Have their second-tier databases been used effectively for adaptive management?

A new element includes absorbing some of the routine analysis function of the Fish Passage Center. Part of the proposal is to continue the Fish Passage Consortium, a group of PNW university faculty with expertise in fish passage issues. The Council and Bonneville will need to specifically distinguish which work elements should be funded to fulfill the tasks of the FPC, if the FPC is not funded. There always has been some overlap with FPC, DART and NOAA, but the ISRP has considered this a value added to the program rather than redundant.

A long list of measurable objectives relate to the reporting and analysis functions of DART as well as newly added functions. These relate to provision of information to managers to analyze proposed hydro operations on fish (pre-season), tracking fish passage (in-season), and measuring the effect of the hydrosystem on fish (post-season). Fourteen objectives are listed. Methods are presented in detail with an explanatory background section.

M&E is built into this project throughout. In the last review the ISRP recommended that the next proposal from this sponsor should include an evaluative summary of usage that indicates the distribution of use across different types of users and products, the details of a plan for how DART assesses demand for current and new products, the type of outreach that is done to assess demand, and methods used to inform and expand the user base. The sponsors have responded to this recommendation in their project operations, the results of which are reported in this proposal. The amount, distribution, and type of use are monitored quarterly for potential improvement in services. Post-season evaluations of pre-season predictions are conducted on a routine basis. Services are reviewed at the end of the year in a series of regional meetings to identify areas of needed modification. The project has excellent provisions for information transfer of data, analysis, support services, and for adaptive modification of information transfer practices on the basis of feedback.


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

Recommendation: Fundable (Qualified)
NPCC Comments: This is an exemplary proposal among the database projects, for a project that appears to provide products of widespread use and value. The project title should be probably be changed, however, to reflect the fact that this is DART enhanced with additional analytical functions. The primary significance to regional programs is to the Power Act sections requiring improved passage survival and flows. The proposal includes excellent M&E.

The proposal presents a brief but clear background on the utility of the second-tier database provided by this project, although the ultimate value of this data to fish management is not explicitly described. A clear rationale is provided for the need for the integrated environmental data and fish passage data and analysis provided by DART. Detailed lists of the analyses provided by DART are included, as well as a number of analyses for which data and analytical assistance was provided.

The project’s history is described in an excellent interpretive narrative on actions tied to their accomplishments, the process of their evolution and the reasons why. It discusses the types of internal monitoring performed through post-season analysis of passage predictions. A figure of monthly usage from 1998-2005 is provided, as well as a list of entities using DART between 2004-2005, and the number of hosts served by season. Less clear, however, is how useful this information has been to all the regional entities that tapped it. Also, how is this information accessed? Are the raw data they capture and make available checked for accuracy? Are DART analyses peer-reviewed? Have their second-tier databases been used effectively for adaptive management?

A new element includes absorbing some of the routine analysis function of the Fish Passage Center. Part of the proposal is to continue the Fish Passage Consortium, a group of PNW university faculty with expertise in fish passage issues. The Council and Bonneville will need to specifically distinguish which work elements should be funded to fulfill the tasks of the FPC, if the FPC is not funded. There always has been some overlap with FPC, DART and NOAA, but the ISRP has considered this a value added to the program rather than redundant.

A long list of measurable objectives relate to the reporting and analysis functions of DART as well as newly added functions. These relate to provision of information to managers to analyze proposed hydro operations on fish (pre-season), tracking fish passage (in-season), and measuring the effect of the hydrosystem on fish (post-season). Fourteen objectives are listed. Methods are presented in detail with an explanatory background section.

M&E is built into this project throughout. In the last review the ISRP recommended that the next proposal from this sponsor should include an evaluative summary of usage that indicates the distribution of use across different types of users and products, the details of a plan for how DART assesses demand for current and new products, the type of outreach that is done to assess demand, and methods used to inform and expand the user base. The sponsors have responded to this recommendation in their project operations, the results of which are reported in this proposal. The amount, distribution, and type of use are monitored quarterly for potential improvement in services. Post-season evaluations of pre-season predictions are conducted on a routine basis. Services are reviewed at the end of the year in a series of regional meetings to identify areas of needed modification. The project has excellent provisions for information transfer of data, analysis, support services, and for adaptive modification of information transfer practices on the basis of feedback.

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