FY07-09 proposal 199601900

Jump to Reviews and Recommendations

Section 1. Administrative

Proposal titleTechnical Management Team (TMT)
Proposal ID199601900
OrganizationUniversity of Washington
Short descriptionThe 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 transferThe 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.
Proposal contact person or principal investigator
Contacts
ContactOrganizationEmail
Form submitter
Christine Muongchanh University of Washington cket@cbr.washington.edu
All assigned contacts
Jim Anderson jim@cbr.washington.edu
Christine Muongchanh University of Washington cket@cbr.washington.edu

Section 2. Locations

Province / subbasin: Mainstem/Systemwide / Systemwide

LatitudeLongitudeWaterbodyDescription

Section 3. Focal species

primary: All Anadromous Salmonids
secondary: Resident Fish

Section 4. Past accomplishments

YearAccomplishments
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

Funding sourceRelated IDRelated titleRelationship
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 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 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 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 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 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 objectivesFull descriptionAssociated subbasin planStrategy

Section 7. Work elements (coming back to this)

Work element nameWork element titleDescriptionStart dateEnd dateEst 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
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
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
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
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
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
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
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
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
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

Section 8. Budgets

Itemized estimated budget
ItemNoteFY07FY08FY09
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/orgItem or service providedFY 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: $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]
$331,279 $277,279 $277,279 $885,837 Expense Basinwide Fund
NPCC DRAFT FUNDING RECOMMENDATIONS (Sep 15, 2006) [full Council recs]
$331,279 $277,279 $277,279 $0 Basinwide

ISRP PRELIMINARY REVIEW (Jun 2, 2006)

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.


ISRP FINAL REVIEW (Aug 31, 2006)

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.