Abstract

The U.S. Geological Survey (USGS), in cooperation with Texas Tech University, constructed a dataset of selected reservoir storage (daily and instantaneous values), reservoir elevation (daily and instantaneous values), and water-quality data from 59 reservoirs throughout Texas. The period of record for the data is as large as January 1965–January 2010. Data were acquired from existing databases, spreadsheets, delimited text files, and hard-copy reports. The goal was to obtain as much data as possible; therefore, no data acquisition restrictions specifying a particular time window were used. Primary data sources include the USGS National Water Information System, the Texas Commission on Environmental Quality Surface Water-Quality Management Information System, and the Texas Water Development Board monthly Texas Water Condition Reports. Additional water-quality data for six reservoirs were obtained from USGS Texas Annual Water Data Reports. Data were combined from the multiple sources to create as complete a set of properties and constituents as the disparate databases allowed. By devising a unique per-reservoir short name to represent all sites on a reservoir regardless of their source, all sampling sites at a reservoir were spatially pooled by reservoir and temporally combined by date. Reservoir selection was based on various criteria including the availability of water-quality properties and constituents that might affect the trophic status of the reservoir and could also be important for understanding possible effects of climate change in the future. Other considerations in the selection of reservoirs included the general reservoir-specific period of record, the availability of concurrent reservoir storage or elevation data to match with water-quality data, and the availability of sample depth measurements. Additional separate selection criteria included historic information pertaining to blooms of golden algae. Physical properties and constituents were water temperature, reservoir storage, reservoir elevation, specific conductance, dissolved oxygen, pH, unfiltered salinity, unfiltered total nitrogen, filtered total nitrogen, unfiltered nitrate plus nitrite, unfiltered phosphorus, filtered phosphorus, unfiltered carbon, carbon in suspended sediment, total hardness, unfiltered noncarbonate hardness, filtered noncarbonate hardness, unfiltered calcium, filtered calcium, unfiltered magnesium, filtered magnesium, unfiltered sodium, filtered sodium, unfiltered potassium, filtered potassium, filtered chloride, filtered sulfate, unfiltered fluoride, and filtered fluoride. When possible, USGS and Texas Commission on Environmental Quality water-quality properties and constituents were matched using the database parameter codes for individual physical properties and constituents, descriptions of each physical property or constituent, and their reporting units. This report presents a collection of delimited text files of source-aggregated, spatially pooled, depth-dependent, instantaneous water-quality data as well as instantaneous, daily, and monthly storage and elevation reservoir data.

First posted June 2, 2011