Measurements of Water Quality Constituents in Groundwater Within 1 Mile (1.61 km) of Orphaned Wells in the United States
Dates
Start Date
1905-10-21
End Date
2023-08-15
Publication Date
2024-01-10
Citation
Haase, K.B., Gianoutsos, N.J., and Skinner, C.C., 2024, Measurements of Water Quality Constituents in Groundwater Within 1 Mile (1.61 km) of Orphaned Wells in the United States: U.S. Geological Survey data release, https://doi.org/10.5066/P91O39OU.
Summary
This is a combined dataset from the USGS Orphaned Well Dataset (Grove and Merrill, 2022) and publicly available data from the USGS National Water Information System, NWIS, obtained via the Water Quality Portal using the USGS Python dataretrieval library. This dataset is composed of water quality measurements from groundwater sites located within 1 mile of the locations of unplugged orphaned wells listed in the United States Documented Unplugged Orphaned Oil and Gas Well Dataset. This dataset contains measurements of common water quality parameter (pH, temperature, specific conductance, TDS), dissolved light hydrocarbons and their isotopes (Methane, δ13C in methane, δ2H in methane, ethane, δ13C in ethane, propane, and butane), constituents [...]
Summary
This is a combined dataset from the USGS Orphaned Well Dataset (Grove and Merrill, 2022) and publicly available data from the USGS National Water Information System, NWIS, obtained via the Water Quality Portal using the USGS Python dataretrieval library.
This dataset is composed of water quality measurements from groundwater sites located within 1 mile of the locations of unplugged orphaned wells listed in the United States Documented Unplugged Orphaned Oil and Gas Well Dataset.
This dataset contains measurements of common water quality parameter (pH, temperature, specific conductance, TDS), dissolved light hydrocarbons and their isotopes (Methane, δ13C in methane, δ2H in methane, ethane, δ13C in ethane, propane, and butane), constituents that can indicate the presence of brines and geologic fluids and be used to assess corrosivity (calcium, chloride, bromide, alkalinity), measurements that can be used to assess the potential for biogenic methane production (sulfate, sulfur isotopes, oxidation/reduction potential), as well as isotopic tracers of hydrologic processes (δ2H and δ18O in water and tritium).
The data include supporting information about the water quality measurement sites that can help provide context to the water quality measurements. The data is presented in several ways, including all individual measurements, the average water quality near each orphaned well in the dataset, water quality measurements averaged near orphaned well (less than 100 meters), and averaged for distances at further away (100 meters to 1.61 kilometers), as well as the combined subset of data where there are measurements for both the near (less than 100 meters) and far (between 100 meters an 1.61 kilometer) radius. This data release also includes the script and input file used to retrieve and format the data from NWIS to allow use in other projects.
This project was supported by the USGS Community For Data Integration (CDI).
https://www.usgs.gov/centers/community-for-data-integration-cdi
Click on title to download individual files attached to this item.
Measurements Water Quality Constituents in Groundwater Within 1 mile of Orphaned Wells in the United States.xml “Metadata associated with the data release files” Original FGDC Metadata
View
26.29 KB
application/fgdc+xml
All_GWQ_Data_1_61km_From_OW.csv “All water quality measurements within 1 mile of an orphan”
59.87 MB
text/csv
Avg_GWQ_1_61km_From_OW.csv “Average water quality measurements within 1.61 km (1 mile) of an orphaned well”
18.52 MB
text/csv
Avg_GWQ_100m_Or_Less_From_OW.csv “Average water quality measurements within 100m of an Orphaned Well”
157.17 KB
text/csv
Avg_GWQ_100m_to_1_61km_From_OW.csv “Average water quality measurements between 100m and 1.61 km of an Orphaned Well”
17.69 MB
text/csv
Data_Collection_Script.zip “Python Script used to create the dataset, inputs, and instructions”
42.3 KB
application/zip
Data_Dictionary_GWQ_Near_OW_USA.xlsx “Data dictionary describing the tables in the data release files”
These data were collected with the goal of creating a dataset to enable users to study linkages between unplugged orphaned wells and water quality. The water quality source data obtained NWIS was collected for a range of water quality assessment needs, and few, if any were expressly collected for the purpose of studying water quality relationships with unplugged orphaned wells. End users are encouraged to carefully examine the data, especially the reporting dates, which for some values likely pre-date the corresponding orphaned well entering orphaned status.
This dataset was created by using the locations of orphaned wells in the USGS Documented Orphaned Well Dataset (Grove and Merrill, 2022) to find water quality data stored in the Water Quality Data Portal (www.waterqualitydata.us).
