DART Data Access in Real Time Project ID 1996-019-00 FY2013-FY2017

1. DARTData Access in Real Time Project ID 1996-019-00FY2013-FY2017 Columbia Basin Research University of Washington

2. Purpose of DART To provide web-based data repository and analysis services for the real-time management and long-term planning of Columbia Basin fisheries, water and hydroelectric resources

3. DART Objectives • Integration of primary regional data sources • Monitor juvenile & adult fish status • Assist agencies in analysis of data • Develop new analysis tools to promote efficient coordination of Columbia Basin research and management

4. How DART Fits In (average queries/day) DART actively maintains relationships with16 regional projects

5. The design of DARThas evolved to accommodate the increasing variety and amount data

6. In 1994 DART gathered data from 21 sites in near Real-Time Project Data

7. Project Water Quality Flow Ocean Data Screw Traps PIT Rls PIT Obs DART now gathers data from 1055 Sites DART usage has increased linearly for two decades

8. Overview of Analysis

10. DART Web-based Data Retrieval and Analytical Processing • Archive regional data and provide standardized access of data from 1938 through the present • Data extraction and graphs tools efficiently integrate data by location and time • Online analyses for user defined selections of real-time and historical data • Complex data aggregation and analysis for monitoring status and trends of populations • Specialized data retrieval and analyses for scientists and managers upon request

11. Newest Tool Columbia Basin Instream Arrays & Subbasins with Interrogation and Recapture datasets WDFW needed to analyze complex movement of individual fish

12. Notable Management Results 1996 at request of BPA to serve needs of NOAA and TMT inseason management, developed aggregation processes to identify and report on the migration of ESU / DPS populations based on PTAGIS data 2002 developed Adult PIT Tag Conversion Rate analysis tool in response to NOAA and expanded to further meet requests from Grant County PUD and Douglas County PUD 2002 provided reservoir elevations and flows for the NW Power and Conservation Council’s Power Supply Outlook Update web page on a daily basis 2006 implemented a life stage filter to identify and aggregate PIT Tag observations by life stage 2009 developed ability to examine winter runs to all appropriate web-based queries in response to Yakima Basin Fish & Wildlife Recovery Board request 2009 in response to NW River Partners and AMIP developed Adult Passage All Species Summary report that includes comparison by species of current year cumulative passage to 4 and 10 year running averages 2010 at request of Hood River Production Program Confederated Tribes of Warm Springs, developed the PIT Tag Release and Observation Summary with Tag File Selection query for generating survival and travel time estimates 2011 developed Valid Sample List and Sample Time reporting for the Integrated Status and Effectiveness Monitoring Program (ISEMP) to assist Idaho Fish and Game, Nez Perce Tribe, Quantitative Consultants, Inc., NOAA in "year-around" PIT tagging operation at Lower Granite Dam Ladder Trap to estimate escapement of adult spring/summer Chinook salmon and steelhead in Snake River tributaries 2011 in cooperation with WDFW and response to AMI, developed report and analysis suite, integrating PTAGIS interrogation and recapture datasets, to address the growing needs for specialized reporting for the PIT Tag Instream Arrays being deployed in Intensively Monitored Watersheds (IMWs)

13. Benefits Fish and Wildlife Management • The DART project provide valuable information on fish populations and the hydrosystem to research, management and the public. • Database: a single portal of historical and real time information increases data management efficiency. • Analysis Tools: designed in collaboration with researchers and managers, fish status, trends and river conditions are efficiently evaluated. • Forecast Tools: daily forecasts of juvenile/adult salmon passage plus temperature and dissolved gas levels allow in-season adaptive management of hydrosystem operations. • Staff: provides data integration, data aggregation, data assembly, and analysis to users in the region.

14. DART will continue to meet these needs into the future Increasingly complex management and reseaerch requires more powerful data management tools Staff J. Anderson (PI), S. Iltis (Web content, Sys Admin), C. Van Holmes (Database Manager), C. Muongchanh (Project Administrator)

16. Examples of DART Cites in Literature • Anderson, JJ, Gurarie, E & Zabel, RW 2005. Mean free-path length theory of predator-prey interactions: Application to juvenile salmon migration. Ecological Modelling, 186, 196-211. • Clemens, BJ, Clements, SP, Karnowski, MD, Jepsen, DB, Gitelman, AI & Schreck, CB. 2009. Effects of Transportation and Other Factors on Survival Estimates of Juvenile Salmonids in the Unimpounded Lower Columbia River. Transactions of the American Fisheries Society, 138, 169-188. • Crozier, LG, Hendry, AP, Lawson, PW, Quinn, TP, Mantua, NJ, Battin, J, Shaw, RG & Huey, RB. 2008. Potential responses to climate change in organisms with complex life histories: evolution and plasticity in Pacific salmon. Evolutionary Applications, 1, 252-270. • Haskell, CA, Tiffan, KF & Rondorf, DW. 2006. Food habits of juvenile American shad and dynamics of zooplankton in the lower Columbia River. Northwest Science, 80, 47-64. • Hershberger, PK et al., 2010. Amplification and transport of an endemic fish disease by an introduced species. Biological Invasions, 12, 3665-3675. • Johnson, GE, Anglea, SM, Adams, NS & Wik, TO. 2005. Evaluation of a prototype surface flow bypass for juvenile salmon and steelhead at the powerhouse of Lower Granite Dam, Snake River, Washington, 1996-2000. North American Journal of Fisheries Management, 25, 138-151. • Johnson, LL, Willis, ML, Olson, OP, Pearce, RW, Sloan, CA & Ylitalo, GM. 2010. Contaminant Concentrations in Juvenile Fall Chinook Salmon from Columbia River Hatcheries. North American Journal of Aquaculture, 72, 73-92. • Keefer, ML, Boggs, CT, Peery, C & Caudill, CC. 2008. Overwintering distribution, behavior, and survival of adult summer steelhead: Variability among Columbia River populations. North American Journal of Fisheries Management, 28, 81-96. • Keefer, ML, Moser, ML, Boggs, CT, Daigle, WR & Peery, CA. 2009. Effects of Body Size and River Environment on the Upstream Migration of Adult Pacific Lampreys. North American Journal of Fisheries Management, 29, 1214-1224. • Keefer, ML, Peery, CA & Caudill, CC. 2008. Migration timing of Columbia River spring Chinook salmon: Effects of temperature, river discharge, anti ocean environment. Transactions of the American Fisheries Society, 137, 1120-1133. • Larsen, DA, Beckman, BR, Cooper, KA, Barrett, D, Johnston, M, Swanson, P & Dickhoff, WW. 2004. Assessment of high rates of precocious male maturation in a spring Chinook salmon supplementation hatchery program. Transactions of the American Fisheries Society, 133, 98-120. • Maier, GO & Simenstad, CA. 2009. The Role of Marsh-Derived Macrodetritus to the Food Webs of Juvenile Chinook Salmon in a Large Altered Estuary. Estuaries and Coasts, 32, 984-998. • McLellan, HJ., Hayes, SG & Scholz, AT. 2008. Effects of reservoir operations on hatchery coastal rainbow trout in Lake Roosevelt, Washington. North American Journal of Fisheries Management, 28, 1201-1213.

17. Cited in Published Literature • Meeuwig, MH & Bayer, JM. 2005. Morphology and aging precision of statoliths from larvae of Columbia River basin lampreys. North American Journal of Fisheries Management, 25, 38-48. • Meeuwig, MH, Bayer, JM & Reiche, RA. 2006. Morphometric discrimination of early life-stage Lampetra tridentata and L. richardsoni (Petromyzonidae) from the Columbia River Basin. Journal of Morphology, 267, 623-633. • Meeuwig, MH, Bayer, JM & Seelye, JG. 2005. Effects of temperature on survival and development of early life-stage pacific and western brook lampreys. Transactions of the American Fisheries Society, 134, 19-27. • Mueller, RP, Moursund, RA & Bleich, MD. 2006. Tagging juvenile pacific lamprey with passive integrated transponders: Methodology, short-term mortality, and influence on swimming performance. North American Journal of Fisheries Management, 26, 361-366. • Naughton, GP, Caudill, CC, Keefer, ML, Bjornn, TC, Peery, CA & Stuehrenberg, LC. 2006. Fallback by adult sockeye salmon at Columbia River dams. North American Journal of Fisheries Management, 26, 380-390. • Naughton, GP, Caudill, CC, Peery, CA, Clabough, TS, Jepson, MA, Bjornn, TC & Stuehrenberg, LC. 2007. Experimental evaluation of fishway modifications on the passage behaviour of adult Chinook salmon and steelhead at Lower Granite Dam, Snake River, USA. River Research and Applications, 23, 99-111. • Naughton, GP, Jepson, MA, Peery, CA, Brun, CV & Graham, JC. 2009. Effects of Temporary Tributary Use on Escapement Estimates of Adult Fall Chinook Salmon in the Deschutes River, Oregon. North American Journal of Fisheries Management, 29, 1511-1518. • Paulsen, CM, Hinrichsen, RA & Fisher, TR. 2007. Measure twice, estimate once: Pacific salmon population viability analysis for highly variable populations. Transactions of the American Fisheries Society, 136, 346-364. • Reischel, TS & Bjornn, TC. 2003. Influence of fishway placement on fallback of adult salmon at the Bonneville Dam on the Columbia River. North American Journal of Fisheries Management, 23, 1215-1224. • Salinger, DH, & Anderson, JJ. 2006. Effects of water temperature and flow on adult salmon migration swim speed and delay. Transactions of the American Fisheries Society, 135, 188-199. • Smith, SG, Muir, WD, Hockersmith, EE, Zabel, RW, Graves, RJ, Ross, CV, Connor, WP & Arnsberg, BD. 2003. Influence of river conditions on survival and travel time of Snake River subyearling fall chinook salmon. North American Journal of Fisheries Management, 23, 939-961. • Tiffan, KF, Haskell, CA & Rondorf, DW. 2003. Thermal exposure of juvenile fall chinook salmon migrating through a lower Snake River Reservoir. Northwest Science, 77, 100-109.