For more information on the USGS-the Federal source for science about the Earth, its natural and living resources, natural hazards, and the environment-visit http://www.usgs.gov or call 1-888-ASK-USGS
For an overview of USGS information products, including maps, imagery, and publications, visit http://www.usgs.gov/pubprodTo order this and other USGS information products, visit http://store.usgs.gov Suggested citation: Voss, Frank, and Maule, Alec, 2013, Development of a database-driven system for simulating water temperature in the lower Yakima River main stem, Washington, for various climate scenarios: U.S. Geological Survey Open-File Report 2013-1010, 20 p.Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government.Although this report is in the public domain, permission must be secured from the individual copyright owners to reproduce any copyrighted material contained within this report.
Tables
AbstractA model for simulating daily maximum and mean water temperatures was developed by linking two existing models: one developed by the U.S. Geological Survey and one developed by the Bureau of Reclamation. The study area included the lower Yakima River main stem between the Roza Dam and West Richland, Washington. To automate execution of the labor-intensive models, a database-driven model automation program was developed to decrease operation costs, to reduce user error, and to provide the capability to perform simulations quickly for multiple management and climate change scenarios. Microsoft © SQL Server 2008 R2 Integration Services packages were developed to (1) integrate climate, flow, and stream geometry data from diverse sources (such as weather stations, a hydrologic model, and field measurements) into a single relational database; (2) programmatically generate heavily formatted model input files; (3) iteratively run water temperature simulations; (4) process simulation results for export to other models; and (5) create a database-driven infrastructure that facilitated experimentation with a variety of scenarios, node permutations, weather data, and hydrologic conditions while minimizing costs of running the model with various model configurations.As a proof-of-concept exercise, water temperatures were simulated for a "Current Conditions" scenario, where local weather data from 1980 through 2005 were used as input, and for "Plus 1" and "Plus 2" climate warming scenarios, where the average annual air temperatures used in the Current Conditions scenario were increased by 1degree Celsius (°C) and by 2°C, respectively.Average monthly mean daily water temperatures simulated for the Current Conditions scenario were compared to measured values at the Bureau of Reclamation Hydromet gage at Kiona, Washington, for 2002-05. Differences ranged between 1.9° and 1.1°C for February, March, May, and June, and were less than 0.8°C for the remaining months of the year. The difference between current conditions and measured monthly values for the two warm...