Skip to main content
U.S. flag

An official website of the United States government

Attributed California Water Supply Well Completion Report Data for Selected Areas, Derived from CA WCR OSCWR Data (ver. 3.0, July 2023)

July 24, 2023

This Well Completion Report geospatial dataset represents an index to a subset of records available from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This version of the release contains data from about 255,000 well completion reports (WCRs) for water supply wells from Amador, Butte, Calaveras, Colusa, El Dorado, Glenn, Kern, Kings, Merced, Monterey, Nevada, Placer, Riverside, Sacramento, San Benito, San Bernardino, San Luis Obispo, San Joaquin, Santa Clara, Santa Cruz, Shasta, Stanislaus, Sutter, Tehama, Tulare, and Yuba counties. A subset of WCRs for wells that are not water supply wells also are included. The California Groundwater Ambient Monitoring and Assessment Program Priority Basin Project (GAMA-PBP) did studies of water quality in groundwater resources used by domestic wells in parts of those counties in 2012-2022, and these data were compiled as part of those studies. A few WCRs from additional counties have been included because the WCRs were initially incorrectly assigned to one county and are now reported with their correct county assignment. This dataset differs from the data provided in OSWCR because it includes data for some additional fields and doesn't include some fields that are in OSWCR, some data attributed in OSWCR were checked for accuracy and updated, and more precise locations were determined for some wells. The additional fields provide more detail about the open or perforated intervals in the well, various identification numbers for the wells, and generalized lithology, and were populated where they could be identified. Some attributes have been provided by cooperating entities as indicated in the REFERENCE field. About 60 percent of the locations are georeferenced to finer resolution based on county APN, 911, or local water authority geospatial datasets. The attributed information is linked to the redacted publicly available image when the link can be resolved.

This dataset is for information purposes only. All attribute values should be verified by reviewing the original Well Completion Report. California Water Code Section 13752 allows for the release of redacted copies of well completion reports to the public.

DWR is the authoritative source of these data.

Changes in Version 3.0
1) Four authors were added to include USGS staff who worked on the project since publication of Version 2.0
2) About 33,000 new rows were added to the dataset, for well completion reports from six additional counties: Monterey, Kern, San Benito, San Luis Obispo, Santa Clara, and Santa Cruz.
3) Text in the Abstract/Summary, Purpose, Process Steps, and Use Constraints sections and for some of the attribute descriptions were revised to improve clarity of explanations.
4) A data field were added for identifying included wells that had lithology information published in the data release by Haugen and others, 2023 (
5) Minor corrections made to entries in the original about 220,00 rows of data. Version 1.0 and 2.0 can be obtained by request from J.G. Borkovich

First release: 2018
Revised: January 2023 (ver. 2.0)
Revised: July 2023 (ver. 3.0)

Publication Year 2023
Title Attributed California Water Supply Well Completion Report Data for Selected Areas, Derived from CA WCR OSCWR Data (ver. 3.0, July 2023)
DOI 10.5066/P93ICKAF
Authors Joseph G Borkovich, Jose A Arroyo-Lopez, Emily A Haugen, Sylvia V Stork, Adelia M McGregor, Mariia Balkan, Sherman Peng, Monica R. Jasper, Vong Lor, Andrew L Soldavini, Christian L Estrada, Connor J Mcvey, Deanna P Grechkosey, James E Koepke, Nicole A Oldham, Robert C Vroman, Renee Handley, George L Bennett, Kirsten E Faulkner, Jaylen M Luckett, Hannah M Mitchell, Sean L Wenrick
Product Type Data Release
Record Source USGS Digital Object Identifier Catalog
USGS Organization Sacramento Projects Office (USGS California Water Science Center)