Discrete and high-frequency chloride (Cl) and specific conductance (SC) data sets and Cl-SC regression equations used for analysis of 93 USGS water quality monitoring stations in the eastern United States
공공데이터포털
High frequency estimated chloride (Cl) and observed specific conductance (SC) data sets, along with response variables derived from those data sets, were used in an analysis to quantify the extent to which deicer applications in winter affect water quality in 93 U.S. Geological Survey water quality monitoring stations across the eastern United States. The analysis was documented in the following publication: Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology. This data release contains five child items: 1) Input datasets of discrete specific conductance (SC) and chloride (Cl) observations used to develop regression models describing the relationship between chloride and SC 2) The predicted chloride concentrations generated by applying the sites-specific and regional regression models to high-frequency SC datasets 3) The regression equations for 56 USGS water quality monitoring stations across the eastern Unite States, as well as three regions 4) Response variables describing temporal patterns in SC and chloride, calculated by using the estimated high-frequency chloride time series datasets and high-frequency SC datasets 5) Watershed characteristics describing the land use, geology, climate, and deicer application rates for the 93 watersheds included in the Moore et. al (in review) study.
Estimated high-frequency chloride concentrations
공공데이터포털
This data set includes estimated chloride concentrations for the 93 USGS water quality monitoring stations located across the eastern United States. Chloride concentrations were predicted using regression equations that established the relationship between simultaneous measurements of chloride and specific conductance (SC). Site-specific models were developed and applied when data were available, and regional regression models were used where there were insufficient data available to establish a site-specific regression model. These models were applied to high-frequency SC data sets to produce high-frequency predicted chloride concentrations at 2-minute to 1-hour intervals, depending on the frequency at which SC is measured at each site. Up to four chloride concentration estimations may be available for a particular site, depending on whether a simple linear regression was developed (SLR), a piecewise regression was developed (SEG), and whether or not site-specific models were developed and applied. The best-fitting regional regression model was applied to all 93 sites. Regions include the southeast, Mid-Atlantic, Mid-Atlantic carbonate (e.g., underlain with carbonate bedrock), and New England, and correspond to the regions included in Moore and others (in review). Each file is labeled by its short name. Please see "Chloride_site_information.csv" for the corresponding site IDs and the USGS station numbers. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Estimated high-frequency chloride concentrations
공공데이터포털
This data set includes estimated chloride concentrations for the 93 USGS water quality monitoring stations located across the eastern United States. Chloride concentrations were predicted using regression equations that established the relationship between simultaneous measurements of chloride and specific conductance (SC). Site-specific models were developed and applied when data were available, and regional regression models were used where there were insufficient data available to establish a site-specific regression model. These models were applied to high-frequency SC data sets to produce high-frequency predicted chloride concentrations at 2-minute to 1-hour intervals, depending on the frequency at which SC is measured at each site. Up to four chloride concentration estimations may be available for a particular site, depending on whether a simple linear regression was developed (SLR), a piecewise regression was developed (SEG), and whether or not site-specific models were developed and applied. The best-fitting regional regression model was applied to all 93 sites. Regions include the southeast, Mid-Atlantic, Mid-Atlantic carbonate (e.g., underlain with carbonate bedrock), and New England, and correspond to the regions included in Moore and others (in review). Each file is labeled by its short name. Please see "Chloride_site_information.csv" for the corresponding site IDs and the USGS station numbers. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Response variables derived from predicted high-frequency chloride concentrations and specific conductance values
공공데이터포털
This data set contains 18 metrics used to describe patterns in specific conductance (SC) and chloride concentrations in 93 streams located across the eastern United States. These data were quantified for an analysis described in Moore and others (in review). All metrics were quantified for a water year and a median was taken across all years for which data were available to provide a single value for each site. High-frequency SC and chloride were measured or estimated at sub-daily time steps from 2-minute intervals to hourly intervals (e.g., high-frequency) depending on the site. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Response variables derived from predicted high-frequency chloride concentrations and specific conductance values
공공데이터포털
This data set contains 18 metrics used to describe patterns in specific conductance (SC) and chloride concentrations in 93 streams located across the eastern United States. These data were quantified for an analysis described in Moore and others (in review). All metrics were quantified for a water year and a median was taken across all years for which data were available to provide a single value for each site. High-frequency SC and chloride were measured or estimated at sub-daily time steps from 2-minute intervals to hourly intervals (e.g., high-frequency) depending on the site. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Chloride-specific conductance regression model forms for estimating high-frequency chloride concentrations
공공데이터포털
The file "Chloride_specific_conductance_regression_model_forms_for_estimating_high-frequency_chloride_concentrations.csv" contains the regression equation forms for two types of regressions: 1) single linear (SLR) and 2) piecewise (or segmented; SEG) regression between specific conductance (SC) and chloride (Cl) concentrations for 56 USGS water-quality monitoring stations across the eastern United States, plus four regional regressions developed by pooling data for sites within a region (see Moore and others (in review) for more information). Some sites, and all regions, have both SLR and SEG models reported in this table. The analysis included in the Moore and others (in review) study used results from the SLR models if those are the only model reported, or the SEG models are both reported. This data set includes the slope, intercept, model correlation coefficient (R2) and the number of observations used to develop the regression equation for the SLR models. For the SEG models, information on the slopes and intercepts for the two linear segments are included in addition to the coefficient of determination (R2) and number of observations. Breakpoint estimates (the point separating the two line segments) and uncertainties are only reported for the SEG models. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Chloride-specific conductance regression model forms for estimating high-frequency chloride concentrations
공공데이터포털
The file "Chloride_specific_conductance_regression_model_forms_for_estimating_high-frequency_chloride_concentrations.csv" contains the regression equation forms for two types of regressions: 1) single linear (SLR) and 2) piecewise (or segmented; SEG) regression between specific conductance (SC) and chloride (Cl) concentrations for 56 USGS water-quality monitoring stations across the eastern United States, plus four regional regressions developed by pooling data for sites within a region (see Moore and others (in review) for more information). Some sites, and all regions, have both SLR and SEG models reported in this table. The analysis included in the Moore and others (in review) study used results from the SLR models if those are the only model reported, or the SEG models are both reported. This data set includes the slope, intercept, model correlation coefficient (R2) and the number of observations used to develop the regression equation for the SLR models. For the SEG models, information on the slopes and intercepts for the two linear segments are included in addition to the coefficient of determination (R2) and number of observations. Breakpoint estimates (the point separating the two line segments) and uncertainties are only reported for the SEG models. Moore, J., R. Fanelli, and A. Sekellick. In review. High-frequency data reveal deicing salts drive elevated conductivity and chloride along with pervasive and frequent exceedances of the EPA aquatic life criteria for chloride in urban streams. Submitted to Environmental Science and Technology.
Surrogate regression models for computation of time series chloride concentrations, Chester County, Pennsylvania (2023)
공공데이터포털
In cooperation with state and county agencies, including the Chester County Water Resources Authority (CCWRA), the U.S. Geological Survey (USGS) has collected discrete stream samples for analysis of chloride concentrations at three real-time streamflow and water-quality monitoring (specific conductance) stations located in Chester County, Pennsylvania. Data were collected from 2010-2023 at these stations for the application of predicting chloride concentrations using real-time continuous specific conductance and streamflow data. Regression equations were developed by relating discrete-sample chloride and discrete specific conductance data, as well as continuous streamflow data. Regression equations included possible explanatory variables of discrete specific conductance and continuous streamflow and the response variable of chloride concentration with base-10 logarithmic (log) transformations. Data files in .CSV format include the variables of datetime, specific conductance (microsiemens per centimeter at 25 degrees Celsius, uS/cm), streamflow (Q, cubic feet per second), chloride concentrations (milligrams per liter, mg/L), and calculated or transformed variables of log specific conductance, log streamflow, and log chloride concentrations. Data are included for 3 stream sites: Valley Creek at PA Turnpike Bridge near Valley Forge, PA (USGS station 01473169) with discrete Cl and SC data from nearby downstream site Valley Creek at Wilson Road near Valley Forge, PA (USGS station 01473170) White Clay Creek near Strickersville, PA (USGS station 01478245) Brandywine Creek at Chadds Ford, PA (USGS station 01481000) For the model developed for station 01473169, discrete Cl and SC data come from station 01473170, and continuous Q data comes from station 01473169. For the model developed for station 01478245, discrete Cl and SC data and continuous Q data come from station 01478245. For the model developed for station 01481000, discrete Cl and SC data and continuous Q data come from station 01481000.