Technical Management Team (TMT) proposal 199601900

FY07-09 proposal 199601900

Section 1. Administrative

Proposal title	Technical Management Team (TMT)
Proposal ID	199601900
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.
Proposal contact person or principal investigator

Contacts

Contact	Organization	Email
Form submitter
Christine Muongchanh	University of Washington	[email protected]
All assigned contacts
Jim Anderson		[email protected]
Christine Muongchanh	University of Washington	[email protected]

Section 2. Locations

Province / subbasin: Mainstem/Systemwide / Systemwide

Latitude	Longitude	Waterbody	Description

Section 3. Focal species

primary: All Anadromous Salmonids
secondary: Resident Fish

Section 4. Past accomplishments

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

Funding source	Related ID	Related title	Relationship
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 objectives	Full description	Associated subbasin plan	Strategy

Section 7. Work elements (coming back to this)

Work element name	Work element title	Description	Start date	End date	Est 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

Item	Note	FY07	FY08	FY09
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/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: $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)