Response for project 199601900: Technical Management Team (Tmt

Comment on proposed FY 2006 budget

Last Fiscal Year received: $265,000. A level funding at $265K will allow us to add a small Travel budget for 2-3 trips to Portland to participate in regional meetings.

Accomplishments since the last review

2004 Expanded juvenile and adult Columbia Basin ESU population data services to include: Upper Columbia River Spring Chinook, Upper Willamette Spring Chinook, Mid Columbia River Steelhead, and Lower Columbia River Steelhead. 2004 Acquired and assimilated historical and real-time oxygen saturation data from U.S. Army Corps of Engineers to the river environment data set. 2004 Updated Pacific Northwest Index, a terrestrial climate index, for 1891-2003 based on data from National Climatic Data Center. 2004 Expanded Columbia Basin Performance Measures analysis tool to include exposure calculations for Adult PIT-tag passage to hydrosystem conditions. 2004 Updated analysis services with new Coded Wire Tag Smolt-to-Adult Ratios (SAR) estimates and PIT-tag survival and travel time estimates. 2004 DART served 449,785 individual data requests. 2004 Provided more than 61 special data analyses by request to users at Idaho Department of Fish and Game, USACE, University of Idaho, WDFW, NOAA, Pacific Institute for the Mathematical Sciences, Virginia Institute of Marine Science, Connell High School, USGS, Idaho Power, Fish Passage Center, Carollo Engineers, Seattle City Light, Nez Perce, DCPUD, CCPUD, GCPUD, PNL, NPPC, Washington State Legislature, John R. Stevenson-Fisheries Biologist, British Petroleum, Lands Energy Consulting, PNGC Power, Farmington High School, Hampton Affiliates, EVS Environment, Mobrand, KWA Ecological Sciences Inc., Grand Valley State University, ODFW, Colville Tribes, Washington State Department of Ecology, Portland State University, and Eastern Oregon University. 2004 Integrated trap collection counts for six trap locations in the Mid-Columbia region with historical and daily data from Chelan PUD, Douglas PUD, Washington Department of Fish and Wildlife, and US Fish and Wildlife Service. The trap data set was integrated with the USGS stream flow data set as part of the DART daily services. 2004 Fully integrated YKFP adult passage data into DART through a distributed database solution. 2004 Added trend statistics to PIT Tag Survival and Travel Time Analysis and Smolt-to-Adult Ratio (SAR) Estimates for Coded Wire Tag. 2004 Adult Escapement for the Columbia Basin data and trend statistics presentation was developed and launched to allow comparison of interim target abundances set by NMFS in their April 2002 memo ( with historical trend data. 2004 DART provided data services, programming and web logistics to present the USACE’s requested Bonneville daily and cumulated fallback analysis. 2004 Updated and enhanced javaDART to provide improved user interface, menus help, and expanded flexibility. Launched as a java applet. 2004 Provided BPA with potential spill reduction analysis relative to ESU passage in the FCRPS. 2004 Continued integration of data sets from and coordination with primary sites: PSMFC, U.S. Army Corps of Engineers, Grant County PUD, Douglas County PUD, Chelan County PUD, USGS, PFEL, NWS, NCDC, USBR, SnoTel, NOAA, YKFP, USFWS, and Fish Passage Center. 2004 Further developed and enhanced PIT-tag Adult Conversion Rate report and PIT-tag Adult Conversion Rate observation detail report with overwintering and release km information. 2004 Synchronized adult passage data with the adult passage data set available through the USACE Northwest Division's interactive database query system. At the same time, historical chinook run designations were re-assigned to match current run timings as defined by the USACE and YKFP. 2004 Developed and implemented Adult Passage Annual Summary report for total adult salmon passage counts for all adult species at a selected project for all years in the Columbia River DART database (1938 to the present). 2004 Updated and enhanced PIT Tag Adult Returns Observation Summary report to include by Brood Year summary option.

FY 2006 goals and anticipated accomplishments

At the level funding, our goals and accomplishments will be to maintain the same data integration services performed in the past. We will continue to respond to user requests for integrated data sets, tool enhancement and additional development of on-line processing tools for realtime analysis. This will include development of additional ocean condition indicators based on the Pacific Decadal Oscillation and upwelling indices. This contract implements Reasonable and Prudent Actions (RPAs) of the 2000 NOAA Fisheries and USFWS Biological Opinions governing operations of the Federal Columbia River Power System (FCRPS): 1. RPA 180: Develop and implement a basinwide hierarchical monitoring program… To determine population and environmental status (including assessment of performance measures and standards) and allow ground-truthing of regional databases. 2. RPA 198: Common data management system… for fish populations, water quality, and habitat data. This contract also provides data integration and Internet-based information access for monitoring, evaluation, and decision support to systemwide and mainstem-specific strategies of the Northwest Power Conservation Council’s Fish and Wildlife Program (FWP), including 2004 mainstem amendments. These basinwide strategies pertain principally to (1) the “naturalization” of the mainstem environment, (2) improving juvenile and adult mainstem passage, and (3) dissemination of data and information for research, monitoring, evaluation, decision support, and program oversight. Finally, this contract provides (1) Internet-based data integration, management, and presentation services as well as (2) juvenile and adult mainstem passage modeling supporting federal decisions affecting the operation of the FCRPS. These services compliment but do not replace services provided by the Fish Passage Center, StreamNet, PTAGIS, etc. which, along with services provided by this contract, provide a regional information service to all interested parties. The DART project provides the region web-based access to specialized fish analysis tools developed at Columbia Basin Research by the research groups of Drs. Anderson and Skalski. Analysis capabilities provided by these web integrated tools include: • Analysis of the real-time movement of juvenile salmon and steelhead through the hydrosystem using smolt migrating timing predictions (Realtime) developed by Dr. Skalski and a juvenile passage predictions (CRiSP) developed by Dr. Anderson • Prediction of adult salmon upstream passage timing and run size uses models developed by Dr. Anderson • Web available flexible querying and analyses of estimated smolt-to-adult ratios for Coded Wire Tagged stocks from Washington, Oregon, and Idaho • Web available flexible querying and analyses of juvenile fish survival identified by stock and release groups using statistical software (SURPH) developed by Dr. Skalski • Detailed analysis of adult PIT tag returns including age structure, travel time, conversion rates of PIT-tagged adult migrants from Bonneville to upstream projects • Detail and summary statistics of PIT-tagged ESU stocks, including detailed passage timing • On-line analytical processing for reach specific survival and travel time estimates. These features and others provided by the DART website are not available at other regional facilities such as the Fish Passage Center or PSMFC. Thus, DART provides unique and valuable analysis services for hydrosystem operations planning, real-time monitoring, and post-season analysis of passage conditions. In providing specialized analysis, DART compliments the Fish Passage Center responsibilities for housing passage data and providing technical assistance to the agencies and tribes. While the Fish Passage Center is charged with assisting agencies and tribes in developing requests for flow and spill programs, DART compliments this function by providing regional groups an independent source of integrated information and additional analysis capabilities for evaluating water and fishery actions.

Subbasin planning

How is this project consistent with subbasin plans?

This project is not directly related to a specific subbasin plan, but the data integration and analysis tools do assist with subbasin planning.

How do goals match subbasin plan priorities?

Other comments