A DECISION SUPPORT SYSTEM FOR WATER QUALITY DATA AUGMENTATION: A CASE STUDY1

ABSTRACT: Recent developments in water quality monitoring have generated interest in combining non-probability and probability data to improve water quality assessment. The Interagency Task Force on Water Quality Monitoring has taken the lead in exploring data combination possibilities. In this paper we take a developed statistical algorithm for combining the two data types and present an efficient process for implementing the desired data augmentation. In a case study simulated Environmental Protection Agency (EPA) Environmental Monitoring and Assessment Program (EMAP) probability data are combined with auxiliary monitoring station data. Auxiliary stations were identified on the STORET water quality database. The sampling frame is constructed using ARC/INFO and EPA's Reach File-3 (RF3) hydrography data. The procedures for locating auxiliary stations, constructing an EMAP-SWS sampling frame, simulating pollutant exposure, and combining EMAP and auxiliary stations were developed as a decision support system (DSS). In the case study with EMAP, the DSS was used to quantify the expected increases in estimate precision. The benefit of using auxiliary stations in EMAP estimates was measured as the decrease in standard error of the estimate.     

ACIDIFICATION AND FISH OCCURRENCE IN THE UPPER CHEAT RWER DRAINAGE,WEST VIRGINIA1

ABSTRACT: The decline of many fish populations within the mid-Appalachian region has been attributed to stream acidification as a result of acid precipitation. Many previous attempts to examine relationships between fish occurrence and acidification have been hindered by a lack of data on water quality and fish distributions. To assess relationships between water quality and bedrock type in the upper Cheat River drainage, we used EPA STORET water quality data (1969–1993) and calculated mean pH and mean alkalinity of streams associated with four bedrock types (Hampshire, Chemung, Mauch Chunk, and Pottsville). We examined the relationship between fish occurrence and bedrock type for 53 headwater streams. We found that acidity in headwater streams associated with Pottsville and Mauch Chunk groups often exceeded biological thresholds for acid-sensitive fish species (pH < 5.5). Streams associated with the Pottsville group typically had fewer cyprinid species and fewer total species than those associated with Mauch Chunk, Chemung, and Hampshire bedrock types. The congruent occurrence of streams with low buffering capacity, streams with pH > 5.5, and streams with low fish species richness indicate that acidification has influenced fish distributions in the upper Cheat River drainage.     

THE ENVIRONMENTAL DISPLAY MANAGER: A TOOL FOR WATER QUALITY DATA INTEGRATION1

ABSTRACT: The Environmental Display Manager, EDM, is a development system on an IBM 3090 mainframe at the U.S. EPA National Computer Center in Research Triangle Park, North Carolina. EDM provides mapping, display, analysis support, and information management capabilities to workstations located across the United States, and connected to EPA through federal, state, academic, and private communications networks. Through interactive software, EDM can quickly support analyses, create maps and graphics, and generate reports that integrate millions of pieces of environmental data. The concept of EDM is to provide easy access to environmental information, to provide automated environmental analyses and reports, and then to provide data, graphics, images, text, and documents that can be used by numerous output devices, software packages, and computers. The mapping cumponent works with an electronic version of the 54,000 7.5 minute quad sheets of the U.S. Geological Survey. The software also works with a hydrographic data base of the surface waters of the United States. With the maps, a user can look at the rivers in any state, can zoom in on a small pond, and can overlay and identify particular features such as industrial waste dischargers and factories. The hydrography allows routing for modeling programs, identification of upstream and downstream components, and linkage of environmental features associated with surface waters. Alternatively, users can query data based on latitude/longitude, city name, EPA permit number, state agency and station code, river name or number, and river cataloging unit. The maps can be overlaid with roads and environmental sites such as: municipal and industrial dischargers, Superfund sites, public drinking water supplies, water quality monitoring stations, stream gages, and city locations. Retrievals from related systems can be performed for selected sites creating graphics showing water quality trends, discharge monitoring reports, and permit discharge limits.     

UNCERTAINTY ANALYSIS OF RUNOFF ESTIMATES FROM A RUNOFF CONTOUR MAP1

ABSTRACT: The U.S. Environmental Protection Agency (EPA) in cooperation with the U.S. Geological Survey (USGS) conducted an analysis to quantify the uncertainty associated with interpolating runoff to specific sites using a runoff contour map. We interpolated runoff to 93 gaged watersheds from a runoff contour map using (1) hand interpolation to the watershed outlet, (2) a computer interpolation to the watershed outlet, and (3) hand interpolation to the watershed centroid. We compared the interpolated values to the actual gaged values and found that there was a bias in the average interpolated value for runoff estimated at basin outlets, with interpolated values being less than the actual. We found no significant difference between the hand interpolation method and the computer interpolation method except that the computer method tended to have higher variability due to factors inherent to the software used. There were no strong spatial correlations or regional patterns in the runoff interpolations, which indicates that there are no regional biases introduced in the development of the contour map. We determined that we could estimate runoff, on the average, within approximately 8.9 cm (3.5 in; 15 percent) of the measured value using the three methods. The results of this work indicate that runoff contour maps can he used in regional studies to estimate runoff to ungaged systems with quantifiable uncertainty.     

A Tool for Automated Load Duration Curve Creation1

Abstract: A recent study by the Texas Bacteria Total Maximum Daily Load (TMDL) Task Force has recommended the use of load duration curves as a primary tool in calculating bacterial TMDLs. This method is attractive because it effectively integrates flow regimes into TMDL analyses, clearly communicates data through a method that is understandable to the general public, and has been successfully applied in TMDL studies in other states. To ease the creation of load duration curves, an automated load duration curve creation tool called LDCurve has been created within a Microsoft Excel framework. Web services and a webscraper are used to retrieve U.S. Geological Survey streamflow data and Texas Commission on Environmental Quality water quality data. Data are imported to the spreadsheet, combined to create flow and load duration curves, and plotted. Final steps result in a preliminary estimate of the overall load reductions needed to meet water quality standards in the modeled segment. LDCurve is currently only applicable in the state of Texas, but may be updated to model water quality throughout the nation using analogous web services from the EPA STORET database. By using automated data retrievals and computations, the LDCurve tool reduces the amount of time required to create curves and calculate load reductions to a matter of minutes. LDCurve and all supporting materials are available online for free download at: http://tools.crwr.utexas.edu/LDCurve/ .     

A Web‐Based Decision Support System for Assessing Regional Water‐Quality Conditions and Management Actions1

Booth, Nathaniel L., Eric J. Everman, I‐Lin Kuo, Lori Sprague, and Lorraine Murphy, 2011. A Web‐Based Decision Support System for Assessing Regional Water‐Quality Conditions and Management Actions. Journal of the American Water Resources Association (JAWRA) 47(5):1136‐1150. DOI: 10.1111/j.1752‐1688.2011.00573.x Abstract: The U.S. Geological Survey National Water Quality Assessment Program has completed a number of water‐quality prediction models for nitrogen and phosphorus for the conterminous United States as well as for regional areas of the nation. In addition to estimating water‐quality conditions at unmonitored streams, the calibrated SPAtially Referenced Regressions On Watershed attributes (SPARROW) models can be used to produce estimates of yield, flow‐weighted concentration, or load of constituents in water under various land‐use condition, change, or resource management scenarios. A web‐based decision support infrastructure has been developed to provide access to SPARROW simulation results on stream water‐quality conditions and to offer sophisticated scenario testing capabilities for research and water‐quality planning via a graphical user interface with familiar controls. The SPARROW decision support system (DSS) is delivered through a web browser over an Internet connection, making it widely accessible to the public in a format that allows users to easily display water‐quality conditions and to describe, test, and share modeled scenarios of future conditions. SPARROW models currently supported by the DSS are based on the modified digital versions of the 1:500,000‐scale River Reach File (RF1) and 1:100,000‐scale National Hydrography Dataset (medium‐resolution, NHDPlus) stream networks.     

Evaluating the effects of spatial monitoring policy on groundwater quality portrayal

What size sample is sufficient for spatially sampling ambient groundwater quality? Water quality data are only as spatially accurate as the geographic sampling strategies used to collect them. This research used sequential sampling and regression analysis to evaluate groundwater quality spatial sampling policy changes proposed by California's Department of Water Resources. Iterative or sequential sampling of a hypothetical groundwater basin's water quality produced data sets from sample sizes ranging from 2.8% to 95% coverage of available point sample sites. Contour maps based on these sample data sets were compared to an original (control), mapped hypothetical data set, to determine at which point map information content and pattern portrayal are not improved by increasing sample sizes. Comparing series of contour maps of ground water quality concentration is a common means of evaluating the geographic extent of groundwater quality change. Comparisons included visual inspection of contout maps and statistical tests on digital versions of these map files, including correlation and regression products. This research demonstrated that, down to about 15% sample site coverage, there is no difference between contour maps produced from the different sampling strategies and the contout map of the original data set.     

MASS BALANCE MODEL ESTIMATION OF PHOSPHORUS CONCENTRATIONS IN RESERVOIRS1

ABSTRACT: Mass balance models have been common tools in lake quality management for some years. However, verification for use on reservoirs, especially in the Western United States, has been seriously lacking, In this study, such a verification is attempted using data from the U.S EPA National Eutrophication Survey. Several models from the literature are compared for accuracy in application to the western reservoir data. Model standard error and correlation between estimated and observed reservoir phosphorus concentrations are the Criteria used for comparison. Standard errors am further used to calculate uncertainty of trophic state classification based on estimated phosphorus concentration. The model proposed by Dillon and Rigler (1974) proved most accurate, with a correlation coefficient of 0.86 and standard error of 0.2, based on logarithmic transformed values. Deficiencies in the other models appear to & from coefficients fit to lake data and from inappropriate model formulation.     

THE EFFECTS OF ARTIFICIAL CIRCULATION ON A HYPEREUTROPHIC LAKE1

ABSTRACT: Crystal Lake, a small urban lake in Robbinsdale, MN, had been artificially circulated for 12 years before a detailed water quality evaluation was undertaken. In 1986, the circulation system was shut off for a two-year assessment. Although the lake remained hypereutrophic, the use of the lake, which included shoreline fishing and feeding ducks and geese, did not appear to be seriously impaired by the absence of artificial circulation. The circulation system was returned to service in October 1987 (there are 16 diffusers in this 0.31 km^?2 lake). Continuous limnological data from October 1987 through October 1988, plus several sampling dates in 1989, compares to the two non-circulation years (1986 and 1987) as follows: there was a two- to three-fold increase in the lake's concentration of total phosphorus, total Kjeldahl nitrogen, and chlorophyll and a similar decrease in Secchi disk transparency. The surface oxygen concentration was reduced and the deep waters were nearly anoxic. In fact, following a wind storm in 1988, the entire lake became anoxic due to the mixing of high BOD throughout the water column, and a summertime fish-kill resulted. All of these occurrences are related to the artificial circulation of the lake.     

URBAN STORMWATER QUANTITY/QUALITY MODELING USING THE SCS METHOD AND EMPIRICAL EQUATIONS1

ABSTRACT: Runoff depth and pollutant loading (Biological Oxygen Demand [BOD₅], Total Suspended Solids [TSS], Total Kjeldahl Nitrogen [TKN] and lead [Pb]) computations of urban stormwater runoff from four small sites (i.e., 14.7–58.3 ac) in South Florida were performed using the Soil Conservation Service (SCS) hydrology method and empirical equations developed by the U.S. Environmental Protection Agency (EPA). Each site had different predominant land uses (i.e., low density residential, high density residential, highway and commercial). Quantity and quality data from 95 storm events at these sites were measured by the U.S. Geological Survey (USGS), and used for calibration of the methodology to derive appropriate input parameters. Calibrated input parameters were developed for each land use to test the applicability of the methodology in small sub-tropical urban watersheds, and to provide hydrologists with a way to select appropriate parameter values for planning studies. A total of 16 independent rainfall events were used for verification of the methodology. Comparisons of predicted versus measured data for both hydrographs and pollutant loadings were performed.     

AN AUTO-CAD-BASED WATERSHED INFORMATION SYSTEM FOR THE HYDROLOGIC MODEL HEC-11

ABSTRACT: A micro computer based Watershed Information System (W.LS.) is developed to assist in the preparation of input files for the hydrologic simulation model HEC-1. This system consists of three phases. Phase I utilizes the capabilities of AutoCAD version 9 and three programs, BASINS, PLANES, and CHANNELS, to extract, organize, and display watershed data. Phase II uses the program CN to calculate some HEC-1 parameter values. Phase II utilizes the program HECUPDATE to create HEC-1 input files. The system input includes topographic, soils, land use, watershed geometry data, and a skeletal HEC-1 input file. Output from the system includes a summary User Reference File, a Soils File, a Land Use File, a Watershed Geometry File, a Curve Number File, and a HEC-1 input file, which is ready to run. The W.I.S. has been applied to Macks Creek Watershed in southwest Idaho.     

Model simulations of dissolved oxygen characteristics of Minnesota lakes: Past and future

A deterministic, one-dimensional, unsteady numerical model has been developed, tested, and applied to simulate mean daily dissolved oxygen (DO) characteristics in 27 lake classes in the state of Minnesota. Reaeration and photosynthesis are the oxygen sources, while respiration, sedimentary, and biochemical water column oxygen demand are the sinks of oxygen in the model. The lake classes are differentiated by surface area (A _s), maximum depth (H _max), and trophic status expressed as Secchi depth (Z _s). Because lake stratification is most important to lake oxygen dynamics, simulated DO characteristics are plotted in terms of a stratification parameterA _s/H _max ^0.25 and Secchi depthZ _s. Simulations provide DO profiles on a daily time scale. Specific DO characteristics of ecological and environmental interest are epilimnetic DO, hypolimnetic DO, DO gradient from surface to bottom, and DO minima and maxima. Specific results are as follows: Simulated mean daily and weekly DO values in the epilimnion of all lakes for both past and future climate scenarios are near saturation over the summer season. Hypolimnetic DO values depend strongly on lake morphometry, trophic status, and time throughout the summer season. Future climate conditions are specified as the historical records from 1955 to 1979, adjusted (monthly) by the 2 × CO₂ GISS model output to account for doubling of atmospheric CO₂. With this climate change, weekly averaged epilimnetic DO is projected to drop by less than 2 mg/liter, and will remain above 7 mg/liter throughout the open water season. The hypolimnetic DO reductions after climate change are on the order of 2–8 mg/liter. Periods of anoxia are longer by as much as 80 days. Those changes would alter water quality dynamics in lakes and have a profound effect on lake ecosystems including indigenous fishes. The results presented are useful for evaluating environmental management options.     

THE DEVELOPMENT AND IMPLEMENTATION OF A GIS-BASED CONTAMINANT SOURCE INVENTORY OVER THE SPOKANE AQUIFER,SPOKANE COUNTY WASHINGTON1

ABSTRACT: U.S. Environmental Protection Agency (EPA) statutes require identification of all potential sources of contamination within a wellhead protection area. All wells over Spokane County's aquifer are included in one wellhead protection zone called the Aquifer Sensitive Area (ASA). A GIS-based Contaminant Source Inventory (CSI) was developed for the ASA. Datasets listing businesses and agencies within the ASA were imported into the GIS from state, county, city, and local agencies. These datasets were selected, joined, and sorted using GIS relational database capabilities into one ASA “business master file.” Map files were projected and transformed into common coordinates. Next, business sites within the master file were spatially related by address to the digital map files. Likely Critical Materials Users (CMU) were identified by sorting on selected standard Industrial Codes (SIC). Additional files of CMUs were imported into the Contaminant Source Inventory. GIS queries were performed to locate specific materials, quantities, and storage facilities, and to analyze CMU activity within selected buffer zones. This project demonstrated the usefulness of GIS technology in the development, management, maintenance, and analysis of vast quantities of data associated with a local wellhead protection pro. gram.     

Determining regional water quality patterns and their ecological relationships

A multivariate statistical method for analyzing spatial patterns of water quality in Georgia and Kansas was tested using data in the US Environmental Protection Agency's STORET data system. Water quality data for Georgia and Kansas were organized by watersheds. We evaluated three questions: (a) can distinctive regional water quality patterns be detected and predicted using only a few water quality variables, (b) are regional water quality patterns correlated with terrestrial biotic regions, and (c) are regional water quality patterns correlated with fish distributions? Using existing data, this method can distinguish regions with water quality very different from the average conditions (as in Georgia), but it does not discriminate well between regions that do not have diverse water quality conditions (as in Kansas). Data that are spatially and temporally adequate for representing large regions and for multivariate statistical analysis are available for only a few common water quality parameters. Regional climate, lithology, and biotic regimes all have the potential to affect water quality, and terrestrial biotic regions and fish distributions do compare with regional water quality patterns, especially in a state like Georgia, where watershed characteristics are diverse. Thus, identifiable relationships between watershed characteristics and water quality should allow the development of an integrated landaquatic classification system that would be a valuable tool for resource management. Because geographical distributions of species may be limited by Zoogeographic and environmental factors, the recognition of patterns in fish distributions that correlate with regional water quality patterns could influence management strategies and aid regional assessments.     

Water Quality and Plankton in the United States Nearshore Waters of Lake Huron

Our goal in the development of a nearshore monitoring method has been to evaluate and refine an in situ mapping approach to assess the nearshore waters across the Great Lakes. The report here for Lake Huron is part of a broader effort being conducted across all five Great Lakes. We conducted an intensive survey for the United States nearshore of Lake Huron along a continuous shoreline transect (523?km) from Port Huron, Michigan, to Detour Passage. A depth contour of 20?m was towed with a conductivity-temperature depth profiler, fluorometer, transmissometer, and laser optical plankton counter. Multiple cross-contour tows (10-30?m) on the cruise dates were used to characterize the variability across a broader range of the nearshore. The cross-contour tows were comparable with the alongshore contour indicating that the 20-m contour does a good job of representing the nearshore region (10-30?m). Strong correlations were observed between water quality and spatially associated watershed land use. A repeat tow separated by several weeks investigated temporal variability in spatial patterns within a summer season. Strong correlations were observed across each variable for the temporal repeat across broad- and fine-scale spatial dimensions. The survey results for Lake Huron nearshore are briefly compared with a similar nearshore survey in Lake Superior. The biomass concentrations of lower food web components of Lake Huron were notably approximately 54-59?% of those in Lake Superior. The towed instrumentation survey supported the recent view of a change in Lake Huron to an ultra-oligotrophic state, which has been uncharacteristic in recent history.     

Modeling water and sediment contamination of Lake Pontchartrain following pump-out of Hurricane Katrina floodwater

Levee failure and overtopping as a result of Hurricane Katrina caused major flooding of New Orleans, Louisiana. Floodwaters, which were contaminated with heavy metals, organic chemicals, and fecal coliform bacteria (FCB), were pumped into neighboring Lake Pontchartrain during dewatering. The impact of levee failure on water and benthic sediment concentrations in the lake was investigated by applying a numerical water quality model coupled to a three-dimensional, numerical hydrodynamic model. The model was used to compute water and benthic sediment concentrations throughout the lake for lead, arsenic, benzo(a)pyrene (BaP), and 1,1-dichloro-2,2-bis(p-chlorophenyl)ethylene (DDE), and water concentrations for FCB. Computed concentrations resulting from actual pumped discharges with levee failure and overtopping were compared to computed concentrations resulting from pumped discharges without levee failure or overtopping, and concentrations from both sets of conditions were compared to ecological water and sediment quality screening guideline values. The model indicated that incremental increases above pre-Katrina benthic sediment concentrations are about a factor of 10 greater with dewatering of the floodwaters than with dewatering of storm water without flooding. However, these increases for the metals are small relative to pre-Katrina concentrations. The results showed that the ecological screening-level sediment quality guideline values were exceeded for BaP and DDE in areas near the south shoreline of the lake as a result of floodwater pump-out, whereas, this was not the case for storm water removal without flooding. The model showed that lake water column concentrations should be about the same during both dewatering conditions regardless of whether there is flooding or not.     

Usefulness of natural regions for lake management: Analysis of variation among lakes in northwestern Wisconsin,USA

A map of summer total phosphorus in lakes was compiled recently for a three-state area of the upper Midwest for purposes of identifying regional patterns of total phosphorus in lakes and attainable lake trophic state. Spatial patterns in total phosphorus from approximately 3000 lakes were studied in conjunction with maps of geographic characteristics that tend to affect phosphorus balance in lakes to identify regions of similarity in phosphorus concentrations in lakes or similarity in the mosaic of values as compared to adjacent areas. While degrees of relative homogeneity are apparent at many scales, the map was designed at a scale that would yield regions with sufficient homogeneity to be useful for lake management throughout the area. In this study, data from 210 lakes in a 1560-mi² area in northwestern Wisconsin, sampled by the Wisconsin Department of Natural Resources in the spring of 1988 (subsequent to the compilation of the phosphorus map), were examined to: (1) substantiate the existence of the regions depicted on the map in northwest Wisconsin, (2) determine the nature and relative precision of the regional boundaries, (3) determine the relative importance of natural and anthropogenic watershed characteristics, lake types, lake area, and lake depth in explaining within-region differences in lake phosphorus, and (4) demonstrate how the regions might be used by local lake managers.     

Assessing Surface Water Quality and Its Relation with Urban Land Cover Changes in the Lake Calumet Area, Greater Chicago

Urban land use and land cover change significantly affect spatial and temporal patterns of runoff, which in turn impacts surface water quality. With the exponential growth in urban areas over the past three decades, changes in land use and land cover to cater for the growth of cities has been a conspicuous spectacle in urban spaces. The main goal of this study was to assess the impacts of land cover change on runoff and surface water quality using a partial area hydrology framework. The study employed ArcHydro GIS extension and a modified version of Long-Term Hydrologic and Nonpoint Source Pollution model (L-THIA-NPS) in estimating runoff and nonpoint source pollutant concentration around Lake Calumet between 1992 and 2001. Data employed include National Land Cover Data set, rainfall data, digital elevation model (DEM), Soil Survey Geographic (SSURGO) data, and The United States Environmental Protection Agency’s STORET (storage and retrieval) water quality data. The model was able to predict surface water quality reasonably well over the study period. Sensitivity analysis facilitated a manual calibration of the model. Model validation was executed by comparing simulated results following calibration and observed water quality data for the study area. The study demonstrates that the level of concentration of nonpoint source pollutants in surface water within an urban watershed heavily depends on the spatiotemporal variations in areas that contribute towards runoff compared to the spatial extent of change in major land use/land cover.     

Geospatial and Temporal Analysis of a 20‐Year Record of Landsat‐Based Water Clarity in Minnesota's 10,000 Lakes

A large 20‐year database on water clarity for all Minnesota lakes ≥8 ha was analyzed statistically for spatial distributions, temporal trends, and relationships with in‐lake and watershed factors that potentially affect lake clarity. The database includes Landsat‐based water clarity estimates expressed in terms of Secchi depth (SD_Landsat), an integrative measure of water quality, for more than 10,500 lakes for time periods centered around 1985, 1990, 1995, 2000, and 2005. Minnesota lake clarity is lower (more turbid) in the south and southwest and clearer in the north and northeast; this pattern is evident at the levels of individual lakes and ecoregions. Temporal trends in clarity were detected in ~11% of the lakes: 4.6% had improving clarity and 6.2% had decreasing clarity. Ecoregions in southern and western Minnesota, where agriculture is the predominant land use, had higher percentages of lakes with decreasing clarity than the rest of the state, and small and shallow lakes had higher percentages of decreasing clarity trends than large and deep lakes. The mean SD_Landsat statewide remained stable from 1985 to 2005 but decreased in ecoregions dominated by agricultural land use. Deep lakes had higher clarity than shallow lakes statewide and for lakes grouped by land cover. SD_Landsat decreased as the percentage of agriculture and/or urban area increased at county and catchment levels and it increased with increasing forested land.