Compilation of multi-agency specific conductance observations for streams within the Chesapeake Bay watershed
공공데이터포털
Freshwater salinization is an emerging issue for freshwater environments in the Chesapeake Bay, USA region. Salinization is often described by measurements of specific conductance (SC). This data release contains specific conductance observations collected by multiple regional agencies for streams within the Chesapeake Bay Watershed. This inventory compiles and harmonizes data from the Water Quality Portal (WQP), which is a data repository developed by the National Water Quality Monitoring Council and supported by the U.S. Environmental Protection Agency and U.S. Geological Survey, and the U.S. Geological Survey National Water Information System (NWIS). Both discrete measures of SC, which are single measures taken on a particular time and day, and continuous measures of SC, which are repeated measures of SC taken at regular, short intervals, such as 15-minute or hourly intervals, were compiled for this data release. The discrete data were also processed to screen out non-relevant observations and harmonize units. The WQP uses "MonitoringLocationIdentifier" to identify each unique site and monitoring activities, and this term is used throughout the data release to differentiate among unique sites and monitoring activities as well. The data release includes four items: 1. ["Site_inventory_for_specific_conductance_measures.csv"]: This is a site inventory of all locations where SC data had been collected and compiled for the data release. This file includes information on the monitoring location (coordinates, state, and county), the organization responsible for the data collection, the type of data available (discrete, continuous, or both) and its unique monitoring location and activity. 2. ["Discrete_specific_conductance_results.txt"]: This file contains all discrete SC observations. Identifying information (coordinates, monitoring location name and identifier), along with the observation value, units, and multiple flagging columns which denoted whether any changes were made to the observation or units during the processing steps. Full details are included in the "readme_file_for_Ches_Bay_specific_conductance_inventory.pdf" file. 3. ["Continuous_specific_conductance_results.zip"]: This zipped folder contains 89 .csv files for all the continuous USGS SC data available in the Chesapeake Bay watershed. Each file name includes each unique MonitoringLocationIdentifier. 4. ["readme_file_for_Ches_Bay_specific_conductance_inventory.pdf"]: This document describes all the processing and harmonization steps to generate the site inventory and discrete SC dataset, and for downloading the high frequency SC datasets.
Datasets and scripts used for estimating streamflow and base flow within the nontidal Chesapeake Bay riverine system, water years 2006-15
공공데이터포털
This U.S. Geological Survey (USGS) data release contains estimated daily streamflow and base flow for HUC12 in the nontidal areas of the Chesapeake Bay watershed, monthly average streamflow and base flow, flow statistics, MATLAB scripts, and a document that describes how to create similar datasets in other watersheds. Daily streamflow was estimated for all the nontidal parts of the Chesapeake Bay watershed with the program "Unit Flows in Networks of Channels" (UFINCH; Holtschlag, 2016), together with the observations of measured streamflow at gages at the downstream ends of major rivers. The estimated streamflow was aggregated at the HUC12 level and reformatted as an Optimal Hydrograph Separation (OHS) input file using MATLAB scripts. Base flow was calculated at each HUC12 outlet using the base flow index (BFI) hydrograph separation methods developed by Wahl and Wahl (Wahl and Wahl, 1988; Wahl and Wahl, 1995) and by Eckhardt (Eckhardt, 2005) with the parameter estimation method developed by Collischonn and Fan (Collischonn and Fan, 2013) which are incorporated into the OHS program (Raffensperger and others, 2017). This data release supports the following publication: • Buffington, P.C., and Capel, P.D., 2020, Estimating streamflow and base flow within the nontidal Chesapeake Bay riverine system: U.S. Geological Survey Scientific Investigations Report 2020-5055, 26 p., https://doi.org/10.3133/sir20205055. References cited: • Collischonn, W. and Fan, F.M., 2013, Defining parameters for Eckhardt's digital baseflow filter: Hydrological Processes, v. 27, no. 18, p. 2614-2622, https://doi.org/10.1002/hyp.9391. • Eckhardt, K., 2005, How to construct recursive digital filters for baseflow separation: Hydrological Processes, v. 19, no. 2, p. 507-515, https://doi.org/10.1002/hyp.5675. • Holtschlag, D.J., 2016, UFINCH-A method for simulating unit and daily flows in networks of channels described by NHDPlus using continuous flow data at U.S. Geological Survey streamgages: U.S. Geological Survey Scientific Investigations Report 2016-5074, 17 p., https://doi.org/10.3133/sir20165074. • Raffensperger, J.P., Baker, A.C., Blomquist, J.D., and Hopple, J.A., 2017, Optimal hydrograph separation using a recursive digital filter constrained by chemical mass balance, with application to selected Chesapeake Bay watersheds: U.S. Geological Survey Scientific Investigations Report 2017-5034, 51 p., https://doi.org/10.3133/sir20175034. • Wahl, K.L., and Wahl, T.L., 1988, Effects of regional ground water declines on streamflows in the Oklahoma Panhandle, in Symposium on Water-Use Data for Water Resources Management, Tucson, Arizona, American Water Resources Association, p. 239-249. • Wahl, K.L., and Wahl, T.L., 1995, Determining the flow of Comal Springs at New Braunfels, Texas, Texas Water '95: San Antonio, Texas, American Society of Civil Engineers, p. 77-86, http://www.usbr.gov/tsc/techreferences/hydraulics_lab/pubs/PAP/PAP-0708.pdf.
Datasets and scripts used for estimating streamflow and base flow within the nontidal Chesapeake Bay riverine system, water years 2006-15
공공데이터포털
This U.S. Geological Survey (USGS) data release contains estimated daily streamflow and base flow for HUC12 in the nontidal areas of the Chesapeake Bay watershed, monthly average streamflow and base flow, flow statistics, MATLAB scripts, and a document that describes how to create similar datasets in other watersheds. Daily streamflow was estimated for all the nontidal parts of the Chesapeake Bay watershed with the program "Unit Flows in Networks of Channels" (UFINCH; Holtschlag, 2016), together with the observations of measured streamflow at gages at the downstream ends of major rivers. The estimated streamflow was aggregated at the HUC12 level and reformatted as an Optimal Hydrograph Separation (OHS) input file using MATLAB scripts. Base flow was calculated at each HUC12 outlet using the base flow index (BFI) hydrograph separation methods developed by Wahl and Wahl (Wahl and Wahl, 1988; Wahl and Wahl, 1995) and by Eckhardt (Eckhardt, 2005) with the parameter estimation method developed by Collischonn and Fan (Collischonn and Fan, 2013) which are incorporated into the OHS program (Raffensperger and others, 2017). This data release supports the following publication: • Buffington, P.C., and Capel, P.D., 2020, Estimating streamflow and base flow within the nontidal Chesapeake Bay riverine system: U.S. Geological Survey Scientific Investigations Report 2020-5055, 26 p., https://doi.org/10.3133/sir20205055. References cited: • Collischonn, W. and Fan, F.M., 2013, Defining parameters for Eckhardt's digital baseflow filter: Hydrological Processes, v. 27, no. 18, p. 2614-2622, https://doi.org/10.1002/hyp.9391. • Eckhardt, K., 2005, How to construct recursive digital filters for baseflow separation: Hydrological Processes, v. 19, no. 2, p. 507-515, https://doi.org/10.1002/hyp.5675. • Holtschlag, D.J., 2016, UFINCH-A method for simulating unit and daily flows in networks of channels described by NHDPlus using continuous flow data at U.S. Geological Survey streamgages: U.S. Geological Survey Scientific Investigations Report 2016-5074, 17 p., https://doi.org/10.3133/sir20165074. • Raffensperger, J.P., Baker, A.C., Blomquist, J.D., and Hopple, J.A., 2017, Optimal hydrograph separation using a recursive digital filter constrained by chemical mass balance, with application to selected Chesapeake Bay watersheds: U.S. Geological Survey Scientific Investigations Report 2017-5034, 51 p., https://doi.org/10.3133/sir20175034. • Wahl, K.L., and Wahl, T.L., 1988, Effects of regional ground water declines on streamflows in the Oklahoma Panhandle, in Symposium on Water-Use Data for Water Resources Management, Tucson, Arizona, American Water Resources Association, p. 239-249. • Wahl, K.L., and Wahl, T.L., 1995, Determining the flow of Comal Springs at New Braunfels, Texas, Texas Water '95: San Antonio, Texas, American Society of Civil Engineers, p. 77-86, http://www.usbr.gov/tsc/techreferences/hydraulics_lab/pubs/PAP/PAP-0708.pdf.
Water-quality trends for rivers and streams in the Delaware River Basin using Weighted Regressions on Time, Discharge, and Season (WRTDS) models, Seasonal Kendall Trend (SKT) tests, and multisource data, Water Year 1978-2018.
공공데이터포털
This data release provides water-quality trends for rivers and streams in the Delaware River Basin determined using the Weighted Regressions on Time, Discharge, and Season (WRTDS) model and the Seasonal Kendall Trend (SKT) test. Sixteen water-quality parameters were assessed, including nutrients (ammonia, nitrate, filtered orthophosphate, total nitrogen, total phosphorus, and unfiltered orthophosphate), major ions (calcium, chloride, magnesium, potassium, sodium, and sulfate), salinity indicators (total dissolved solids and specific conductance), and sediment (total suspended solids and suspended sediment concentration). The child items include the input and output data used in the modeling and testing of water-quality trends. The attached files include the scripts used in these analyses, a readMe files for these scripts and tables summarizing information about the sites used in the analysis. These trends build off the national efforts of Oelsner and others (2017) and Murphy and others (2018), with some variations in data screening and processing. One major divergence from these previous efforts was that screened site-parameter combinations were screened for the longest period of record that passed various temporal and seasonal criteria ("maximum calibration" approach) instead of screening by pre-defined trend periods. An additional difference was that water-quality data were combined from multiple monitoring locations and collecting organizations using hierarchical clustering based on the distance between monitoring locations on the same stream reach (as determined by the National Hydrography Dataset comid). Data that were a part of these "cluster sites" were manually reviewed prior to running SKT and WRTDS. Input data for SKT includes 124 sites (including individual sites and cluster sites) and 1,208 site-parameter combinations. Input data for WRTDS, which required additional screening beyond those used for the SKT test and a paired streamflow gage, includes 62 sites and 476 site-parameter combinations. For both methods, some site-parameter combinations were not run due to the amount of censored data, or the results were rejected due to poor model fit. Trends are reported for four trend periods (1978-2018, 1998-2018, 2003-2018, and 2008-2018), as the available screened data allow, and for the entire screened period of record for each parameter at each site. This collection of trend results leverages the monitoring efforts of many collecting organizations across the Delaware River Basin and can serve to better understand changing water-quality conditions across this basin. References Cited: Murphy, J.C., Farmer, W.H., Sprague, L.A., De Cicco, L.A., and Hirsch, R.M., 2018, Water-quality trends and trend component estimates for the Nation's rivers and streams using Weighted Regressions on Time, Discharge, and Season (WRTDS) models and generalized flow normalization, 1972-2012: U.S. Geological Survey data release, https://doi.org/10.5066/F7TQ5ZS3. Oelsner, G.P., Sprague, L.A., Murphy, J.C., Zuellig, R.E., Johnson, H.M., Ryberg, K.R., Falcone, J.A., Stets, E.G., Vecchia, A.V., Riskin, M.L., De Cicco, L.A., Mills, T.J., Farmer, W.H., 2017, Water-quality trends in the Nation’s rivers and streams 1972–2012—Data preparation, statistical methods, and trend results: U.S. Geological Survey Scientific Investigations Report, http://dx.doi.org/10.3133/sir20175006. Shoda, M.E., Murphy, J.C., Falcone, J.A., and Duris, J.W., 2019, Multisource surface-water-quality data and U.S. Geological Survey streamgage match for the Delaware River Basin: U.S. Geological Survey data release, https://doi.org/10.5066/P9PX8LZO. National Water Quality Monitoring Council, Water Quality Portal (WQP), https://www.waterqualitydata.us/. Accessed 2020-11-03.
Water-quality trends for rivers and streams in the Delaware River Basin using Weighted Regressions on Time, Discharge, and Season (WRTDS) models, Seasonal Kendall Trend (SKT) tests, and multisource data, Water Year 1978-2018.
공공데이터포털
This data release provides water-quality trends for rivers and streams in the Delaware River Basin determined using the Weighted Regressions on Time, Discharge, and Season (WRTDS) model and the Seasonal Kendall Trend (SKT) test. Sixteen water-quality parameters were assessed, including nutrients (ammonia, nitrate, filtered orthophosphate, total nitrogen, total phosphorus, and unfiltered orthophosphate), major ions (calcium, chloride, magnesium, potassium, sodium, and sulfate), salinity indicators (total dissolved solids and specific conductance), and sediment (total suspended solids and suspended sediment concentration). The child items include the input and output data used in the modeling and testing of water-quality trends. The attached files include the scripts used in these analyses, a readMe files for these scripts and tables summarizing information about the sites used in the analysis. These trends build off the national efforts of Oelsner and others (2017) and Murphy and others (2018), with some variations in data screening and processing. One major divergence from these previous efforts was that screened site-parameter combinations were screened for the longest period of record that passed various temporal and seasonal criteria ("maximum calibration" approach) instead of screening by pre-defined trend periods. An additional difference was that water-quality data were combined from multiple monitoring locations and collecting organizations using hierarchical clustering based on the distance between monitoring locations on the same stream reach (as determined by the National Hydrography Dataset comid). Data that were a part of these "cluster sites" were manually reviewed prior to running SKT and WRTDS. Input data for SKT includes 124 sites (including individual sites and cluster sites) and 1,208 site-parameter combinations. Input data for WRTDS, which required additional screening beyond those used for the SKT test and a paired streamflow gage, includes 62 sites and 476 site-parameter combinations. For both methods, some site-parameter combinations were not run due to the amount of censored data, or the results were rejected due to poor model fit. Trends are reported for four trend periods (1978-2018, 1998-2018, 2003-2018, and 2008-2018), as the available screened data allow, and for the entire screened period of record for each parameter at each site. This collection of trend results leverages the monitoring efforts of many collecting organizations across the Delaware River Basin and can serve to better understand changing water-quality conditions across this basin. References Cited: Murphy, J.C., Farmer, W.H., Sprague, L.A., De Cicco, L.A., and Hirsch, R.M., 2018, Water-quality trends and trend component estimates for the Nation's rivers and streams using Weighted Regressions on Time, Discharge, and Season (WRTDS) models and generalized flow normalization, 1972-2012: U.S. Geological Survey data release, https://doi.org/10.5066/F7TQ5ZS3. Oelsner, G.P., Sprague, L.A., Murphy, J.C., Zuellig, R.E., Johnson, H.M., Ryberg, K.R., Falcone, J.A., Stets, E.G., Vecchia, A.V., Riskin, M.L., De Cicco, L.A., Mills, T.J., Farmer, W.H., 2017, Water-quality trends in the Nation’s rivers and streams 1972–2012—Data preparation, statistical methods, and trend results: U.S. Geological Survey Scientific Investigations Report, http://dx.doi.org/10.3133/sir20175006. Shoda, M.E., Murphy, J.C., Falcone, J.A., and Duris, J.W., 2019, Multisource surface-water-quality data and U.S. Geological Survey streamgage match for the Delaware River Basin: U.S. Geological Survey data release, https://doi.org/10.5066/P9PX8LZO. National Water Quality Monitoring Council, Water Quality Portal (WQP), https://www.waterqualitydata.us/. Accessed 2020-11-03.