Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

Groundwater-Quality Time-Series Analyses and Potential Explanatory Factors of Drought-Response Patterns at Public-Supply Wells, San Joaquin Valley, California, 2000-2022

Metadata Updated: July 20, 2024

This data release documents time-series analyses of aqueous-chemistry data from public-supply wells (PSWs) and associated potential explanatory factors to characterize responses of groundwater quality to drought and recovery periods in California’s San Joaquin Valley (SJV) during 2000-2022. Annual median nitrate values were computed for PSWs throughout the SJV during the period of study. Median annual nitrate values were calculated at all PSWs with available data in the SJV, resulting in a total of 698 PSWs with complete annual records after single-year linear gap imputation. A total of 237 of these records were classified as “low variance” because they contained proportions of identical values exceeding 80 percent or had standard deviations less than the study reporting level of 0.452 milligram of nitrate as nitrogen per liter. Annual nitrate anomalies were computed for the 461 remaining nitrate records not classified as “low variance” by detrending using the Hodrick-Prescott filter and z-score standardizing resultant values by subtracting the mean and dividing by the standard deviation. Resultant time series of nitrate anomalies were clustered into two groups sharing similar time-series characteristics quantified by the nonparametric correlation coefficient, Spearman’s rho. Potential explanatory factors based on time-series characteristics or extrinsic factors used in prior studies to characterize groundwater nitrate concentrations in the SJV were compiled to help explain differences among cluster groups. Additionally, concentration changes for nitrate, total dissolved solids (TDS), arsenic, and fluoride in the regulatory monitoring dataset were computed for two selected hydrologic stress periods representative of an historic drought (Dsp; 2012-2016) and subsequent recovery period (Rsp; 2016-2019). Change values were computed by differencing the annual median concentration of the last year with available data in a given stress period with that of the first, including the year before the onset of the stress period to compare with antecedent conditions when possible. This data release contains eight tables formatted as tab-delimited text files. The Nitrate_Medians.txt table contains complete, annual nitrate time series data for 698 PSWs in the SJV during 2000-2022. The Nitrate_Anomalies.txt table contains annual nitrate anomalies computed for the 461 annual nitrate median records not classified as “low variance.” The Nitrate_Clusters.txt table contains cluster group assignments and corresponding silhouette widths (a common cluster validation index) for the 461 records that were submitted for time-series clustering analysis. The Potential_Explanatory_Factors.txt table contains potential explanatory factors for the 698 PSWs that had complete annual nitrate records. The Nitrate_Stress_Period_Change_Analysis.txt, TDS_Stress_Period_Change_Analysis.txt, Arsenic_Stress_Period_Change_Analysis.txt, and Fluoride_Stress_Period_Change_Analysis.txt tables contain differenced median annual concentration values for nitrate, TDS, arsenic, and fluoride during Dsp and Rsp. A total of 3,256, 1,803, 2,316, and 2,167 PSWs had at least one computed concentration difference during one or both of the two stress periods for nitrate, TDS, arsenic, and fluoride, respectively.

Access & Use Information

Public: This dataset is intended for public access and use. License: No license information was provided. If this work was prepared by an officer or employee of the United States government as part of that person's official duties it is considered a U.S. Government Work.

Downloads & Resources

Dates

Metadata Created Date July 20, 2024
Metadata Updated Date July 20, 2024

Metadata Source

Harvested from DOI EDI

Additional Metadata

Resource Type Dataset
Metadata Created Date July 20, 2024
Metadata Updated Date July 20, 2024
Publisher U.S. Geological Survey
Maintainer
@Id http://datainventory.doi.gov/id/dataset/45f735006e34e0e09062622bf4329b61
Identifier USGS:659c62e1d34e3265ab16292d
Data Last Modified 20240417
Category geospatial
Public Access Level public
Bureau Code 010:12
Metadata Context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
Metadata Catalog ID https://datainventory.doi.gov/data.json
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Harvest Object Id 00c12f25-b71c-46f2-9ff8-5f1b89cef456
Harvest Source Id 52bfcc16-6e15-478f-809a-b1bc76f1aeda
Harvest Source Title DOI EDI
Metadata Type geospatial
Old Spatial -121.7754,34.9445,-118.6736,38.4767
Publisher Hierarchy White House > U.S. Department of the Interior > U.S. Geological Survey
Source Datajson Identifier True
Source Hash 81688da40ab8fec14c876fb563b055a68a56a73e79a05b5bc695b8c649138fed
Source Schema Version 1.1
Spatial {"type": "Polygon", "coordinates": -121.7754, 34.9445, -121.7754, 38.4767, -118.6736, 38.4767, -118.6736, 34.9445, -121.7754, 34.9445}

Didn't find what you're looking for? Suggest a dataset here.