Compilation of total dissolved solids concentrations and specific conductance measurements in the Upper Colorado River Basin, 1894

Dates

Publication Date: 2024-01-31
Start Date: 1894-08-30
End Date: 2022-09-30

Citation

Wise, D. R., 2024, Compilation of total dissolved solids concentrations and specific conductance measurements in the Upper Colorado River Basin, 1894 – 2022: U.S. Geological Survey data release, https://doi.org/10.5066/P9B0SJYS.

Summary

This data release contains total dissolved solids (TDS) concentrations and specific conductance (SC) measurements collected at surface-water monitoring locations and groundwater monitoring wells within the Upper Colorado River Basin (UCRB) between 1894 and 2022. Discrete TDS and SC results were obtained from the Water Quality Portal (WQP). Continuous SC monitoring results were obtained from the USGS National Water Information System (NWIS). The data set includes 127,294 TDS results that were collected at 12,339 sites between 1900 and 2022, and 705,918 SC results that were collected at 19,630 sites between 1894 and 2022. The SC results represented 244,784 discrete measurements at 19,625 sites and 461,134 mean daily values from continuous [...]

Summary

This data release contains total dissolved solids (TDS) concentrations and specific conductance (SC) measurements collected at surface-water monitoring locations and groundwater monitoring wells within the Upper Colorado River Basin (UCRB) between 1894 and 2022. Discrete TDS and SC results were obtained from the Water Quality Portal (WQP). Continuous SC monitoring results were obtained from the USGS National Water Information System (NWIS). The data set includes 127,294 TDS results that were collected at 12,339 sites between 1900 and 2022, and 705,918 SC results that were collected at 19,630 sites between 1894 and 2022. The SC results represented 244,784 discrete measurements at 19,625 sites and 461,134 mean daily values from continuous monitoring at 193 sites. The data retrieved from the WQP were harmonized to create a standardized and readily usable dataset. The harmonization process included the synthesis of parameter names and fractions, the reconciliation of remarks and other data qualifiers, the resolution of duplicate records, and basic checks of the data quality. The harmonized results at 230 sites were selected for additional data processing because those sites were potential calibration targets for TDS watershed modeling for the UCRB using the USGS Spatially Referenced Regression on Watershed attributes (SPARROW) model. The 230 sites met the minimum criteria for the number and seasonal distribution of samples, the length of the sampling period, and the amount of overlap with the streamflow record at a nearby gage. The measured TDS concentrations at those sites were supplemented with estimated TDS concentrations that were determined from relations between measured TDS and SC results within the UCRB. A site-specific regression of TDS on SC was used to estimate TDS from SC at 143 sites, while a regional conversion factor between TDS and SC was used to estimate TDS from SC at 87 sites. The final TDS data for the 230 sites included 50,003 measured values from the WQP, 378,147 values estimated using the equation from a site-specific regression of TDS on SC (with 350,840 based on mean daily SC values), and 30,880 values estimated using a regional median ratio between TDS and SC.

Contacts

Point of Contact :: Daniel R Wise, U.S. Geological Survey, NW-PACIFIC ISLAND REG
Originator :: Daniel R Wise
Metadata Contact :: Daniel R Wise, U.S. Geological Survey, NW-PACIFIC ISLAND REG
Publisher :: U.S. Geological Survey
Distributor :: U.S. Geological Survey - ScienceBase
SDC Data Owner :: Oregon Water Science Center
USGS Mission Area :: Water Resources

Attached Files

Click on title to download individual files attached to this item.

all_ucol_sal_site_nhd.csv “NHD V2 indexing for UCOL surface-water salinity sites”		330.42 KB	text/csv
q_combined_cross_walk.csv “Listing of combined streamflow records”		756 Bytes	text/csv
tds_sc_site_full_site_atts.csv “Attributes for all sites with TDS and SC data”		2.28 MB	text/csv
tds_sc_site_spa_atts.csv “Attributes for sites used to calibrate the SPARROW TDS model”		35.47 KB	text/csv
ucol_sparrow_cal_wq_sites.csv “List of sites used in the SPARROW TDS model”		4.81 KB	text/csv
ucol_sparrow_rem_cal_qa.csv “List of sites removed after regression review”		88 Bytes	text/csv
ucol_tds_sc_full.csv “All available TDS and SC results for the UCOL available from the WQP”		37.44 MB	text/csv
ucol_wqp_deleted_records.csv “Records deleted from data set as a result of preliminary reviews”		8.46 KB	text/csv
wq_combined_cross_walk.csv “Listing of combined water-quality records”		17.24 KB	text/csv
processing_scripts.zip “R scripts used to process data”		32.79 KB	application/zip
ucol_salinity_data_release_metadata.xml “Data release metadata file” Original FGDC Metadata	View	60.03 KB	application/fgdc+xml
ucol_tds_sc_sparrow.csv “TDS and SC results for sites used in the SPARROW TDS model”		28.05 MB	text/csv

Purpose

This data release was compiled to provide a comprehensive data set of total dissolved solids concentrations and specific conductance values that can be used to assess surface-water salinity conditions in the Upper Colorado River basin.

Compilation of total dissolved solids concentrations and specific conductance measurements in the Upper Colorado River Basin, 1894 – 2022

Dates

Citation

Summary

Summary

Contacts

Attached Files

Purpose

Map

Spatial Services

Communities

Tags

Provenance

Additional Information

Identifiers

Item Actions

View Item as ...

Save Item as ...

View Item...