This Well Completion Report dataset represents an index of records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This dataset is for informational purposes only. All attribute values should be verified by reviewing the original Well Completion Report. Known issues include: - Missing and duplicate records - Missing values (either missing on original Well Completion Report, or not key entered into database) - Incorrect values (e.g. incorrect Latitude, Longitude, Record Type, Planned Use, Total Completed Depth) - Limited spatial resolution: The majority of well completion reports have been spatially registered to the center of the 1x1 mile Public Land Survey System section that the well is located in.

This Well Completion Report dataset represents an index of records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This dataset is for informational purposes only. All attribute values should be verified by reviewing the original Well Completion Report. Known issues include: - Missing and duplicate records - Missing values (either missing on original Well Completion Report, or not key entered into database) - Incorrect values (e.g. incorrect Latitude, Longitude, Record Type, Planned Use, Total Completed Depth) - Limited spatial resolution: The majority of well completion reports have been spatially registered to the center of the 1x1 mile Public Land Survey System section that the well is located in.

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 release contains water supply well records from Amador, Calaveras, El Dorado, Nevada, Placer, Sacramento, San Bernardino, Sutter, and Yuba counties. The USGS California Water Science Center GAMA project has provided additional attributes: top of open interval; number of open intervals; and various other identifiers such as public supply well number and USGS site number where they can be identified. In some cases, locations are georeferenced to finer resolution based on county APN or 911 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 Cod ...

This data release was prepared as part of an agreement between the California Department of Water Resources (DWR) and the United States Geological Survey (USGS) to support the Sustainable Groundwater Management Act (SGMA). Of the many components of that agreement, there is a specific task requiring the Enhancement of Digital Well Completion Reports. Well-completion reports (WCRs) contain information about the wells, such as construction characteristics and lithologic data that is very valuable to SGMA. The data set presented here is a compilation of lithologic information transcribed verbatim from a subset of WCRs contained in the DWR Online System for Well Completion Reports (OSWCR). The format of the lithologic descriptions follows the DWR free form entry method, which allows for any material description to be entered into the OSWCR without standardization. The lithologic descriptions for all depth intervals recorded (in feet below land surface) by the driller on the WCR are captured verbatim, with no regularization or correction for typographical or spelling errors. Some degree of data processing may be required by a user of this dataset depending on its intended use. This data release is intended to be updated as new WCRs are transcribed over time. WCR lithologic data featured in version 1.0 (published March 2023) focused on 5,841 WCRs from many types of wells located primarily along the length of the California Aqueduct in the Central Valley of California. WCR lithologic data added in version 2.0 (published June 2024) were from 4,958 select public-supply wells from throughout the state that had previously been included in a compilation of WCR location and construction data made by the USGS Groundwater Ambient Monitoring and Assessment-Priority Basin Project (GAMA-PBP). WCR lithologic data added in this version 3.0 (published July 2025) are from 8,448 more public-supply wells from throughout the state. As of July 2025, approximately 57 percent of the WCRs in this dataset are also in the GAMA-PBP compilation of refined location information and construction characteristic data from WCRs primarily from water-supply wells in select locations throughout the State (Borkovich and others, 2025; https://doi.org/10.5066/P93ICKAF). Subsequent revisions planned for the GAMA-PBP data release include compiling refined location information and construction characteristic data for more WCRs with lithologic data in this data release. The GAMA-PBP data release includes a flag to indicate which WCRs also have lithologic data compiled in this data release. All attributed values should be verified by reviewing the original WCR which can be retrieved from the California Open Data Portal WCR website (California DWR, 2025): https://data.ca.gov/dataset/well-completion-reports 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. Version 1.0 posted March 28, 2023 Version 2.0 posted June 12, 2024 Version 3.0 posted July 18, 2025

The table Well Numbers is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 134673 rows across 5 variables.

The table OSWCR Data Dictionary is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 45 rows across 4 variables.

This dataset represents a water shortage vulnerability analysis performed by DWR using modified PLSS sections pulled from the Well Completion Report PLSS Section Summaries. The attribute table includes water shortage vulnerability indicators and scores from an analysis done by CA Department of Water Resources, joined to modified PLSS sections. Several relevant summary statistics from the Well Completion Reports are included in this table as well. This data is from the 2024 analysis.

Water Code Division 6 Part 2.55 Section 8 Chapter 10 (Assembly Bill 1668) effectively requires California Department of Water Resources (DWR), in consultation with other agencies and an advisory group, to identify small water suppliers and “rural communities” that are at risk of drought and water shortage. Following legislation passed in 2021 and signed by Governor Gavin Newsom, the Water Code Division 6, Section 10609.50 through 10609.80 (Senate Bill 552 of 2021) effectively requires the California Department of Water Resources to update the scoring and tool periodically in partnership with the State Water Board and other state agencies. This document describes the indicators, datasets, and methods used to construct this deliverable.  This is a statewide effort to systematically and holistically consider water shortage vulnerability statewide of rural communities, focusing on domestic wells and state small water systems serving between 4 and 14 connections. The indicators and scoring methodology will be revised as better data become available and stake-holders evaluate the performance of the indicators, datasets used, and aggregation and ranking method used to aggregate and rank vulnerability scores. Additionally, the scoring system should be adaptive, meaning that our understanding of what contributes to risk and vulnerability of drought and water shortage may evolve. This understanding may especially be informed by experiences gained while navigating responses to future droughts.”

A spatial analysis was performed on the 2020 Census Block Groups, modified PLSS sections, and small water system service areas using a variety of input datasets related to drought vulnerability and water shortage risk and vulnerability. These indicator values were subsequently rescaled and summed for a final vulnerability score for the sections and small water system service areas. The 2020 Census Block Groups were joined with ACS data to represent the social vulnerability of communities, which is relevant to drought risk tolerance and resources. These three feature datasets contain the units of analysis (modified PLSS sections, block groups, small water systems service areas) with the model indicators for vulnerability in the attribute table. Model indicators are calculated for each unit of analysis according to the Vulnerability Scoring documents provided by Julia Ekstrom (Division of Regional Assistance).

All three feature classes are DWR analysis zones that are based off existing GIS datasets. The spatial data for the sections feature class is extracted from the Well Completion Reports PLSS sections to be aligned with the work and analysis that SGMA is doing. These are not true PLSS sections, but a version of the projected section lines in areas where there are gaps in PLSS. The spatial data for the Census block group feature class is downloaded from the Census. ACS (American Communities Survey) data is joined by block group, and statistics calculated by DWR have been added to the attribute table. The spatial data for the small water systems feature class was extracted from the State Water Resources Control Board (SWRCB) SABL dataset, using a definition query to filter for active water systems with 3000 connections or less. None of these datasets are intended to be the authoritative datasets for representing PLSS sections, Census block groups, or water service areas. The spatial data of these feature classes is used as units of analysis for the spatial analysis performed by DWR.

These datasets are intended to be authoritative datasets of the scoring tools required from DWR according to Senate Bill 552. Please refer to the Drought and Water Shortage Vulnerability Scoring: California's Domestic Wells and State Smalls Systems documentation for more information on indicators and scoring. These estimated indicator scores may sometimes be calculated in several different ways, or may have been calculated from data that has since be updated. Counts of domestic wells may be calculated in different ways. In order to align with DWR SGMO's (State Groundwater Management Office) California Groundwater Live dashboards, domestic wells were calculated using the same query. This includes all domestic wells in the Well Completion Reports dataset that are completed after 12/31/1976, and have a 'RecordType' of 'WellCompletion/New/Production or Monitoring/NA'.

Please refer to the Well Completion Reports metadata for more information. The associated data are considered DWR enterprise GIS data, which meet all appropriate requirements of the DWR Spatial Data Standards, specifically the DWR Spatial Data Standard version 3.4, dated September 14, 2022. DWR makes no warranties or guarantees — either expressed or implied— as to the completeness, accuracy, or correctness of the data.

DWR neither accepts nor assumes liability arising from or for any incorrect, incomplete, or misleading subject data. Comments, problems, improvements, updates, or suggestions should be forwarded to GIS@water.ca.gov.

This data release is a compilation of construction depth information for 12,383 active and inactive public-supply wells (PSWs) in California from various data sources. Construction data from multiple sources were indexed by the California State Water Resources Control Board Division of Drinking Water (DDW) primary station code (PS Code). Five different data sources were compared with the following priority order: 1, Local sources from select municipalities and water purveyors (Local); 2, Local DDW district data (DDW); 3, The United States Geological Survey (USGS) National Water Information System (NWIS); 4, The California State Water Resources Control Board Groundwater Ambient Monitoring and Assessment Groundwater Information System (SWRCB); and 5, USGS attribution of California Department of Water Resources well completion report data (WCR). For all data sources, the uppermost depth to the well's open or perforated interval was attributed as depth to top of perforations (ToP). The composite depth to bottom of well (Composite BOT) field was attributed from available construction data in the following priority order: 1, Depth to bottom of perforations (BoP); 2, Depth of completed well (Well Depth); 3; Borehole depth (Hole Depth). PSW ToPs and Composite BOTs from each of the five data sources were then compared and summary construction depths for both fields were selected for wells with multiple data sources according to the data-source priority order listed above. Case-by-case modifications to the final selected summary construction depths were made after priority order-based selection to ensure internal logical consistency (for example, ToP must not exceed Composite BOT). This data release contains eight tab-delimited text files. WellConstructionSourceData_Local.txt contains well construction-depth data, Composite BOT data-source attribution, and local agency data-source attribution for the Local data. WellConstructionSourceData_DDW.txt contains well construction-depth data and Composite BOT data-source attribution for the DDW data. WellConstructionSourceData_NWIS.txt contains well construction-depth data, Composite BOT data-source attribution, and USGS site identifiers for the NWIS data. WellConstructionSourceData_SWRCB.txt contains well construction-depth data and Composite BOT data-source attribution for the SWRCB data. WellConstructionSourceData_WCR.txt contains contains well construction depth data and Composite BOT data-source attribution for the WCR data. WellConstructionCompilation_ToP.txt contains all ToP data listed by data source. WellConstructionCompilation_BOT.txt contains all Composite BOT data listed by data source. WellConstructionCompilation_Summary.txt contains summary ToP and Composite BOT values for each well with data-source attribution for both construction fields. All construction depths are in units of feet below land surface and are reported to the nearest foot.

This Well Completion Report dataset represents an index of records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This dataset is for informational purposes only. All attribute values should be verified by reviewing the original Well Completion Report. Known issues include: - Missing and duplicate records - Missing values (either missing on original Well Completion Report, or not key entered into database) - Incorrect values (e.g. incorrect Latitude, Longitude, Record Type, Planned Use, Total Completed Depth) - Limited spatial resolution: The majority of well completion reports have been spatially registered to the center of the 1x1 mile Public Land Survey System section that the well is located in.

The table WCR Links is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 953885 rows across 2 variables.

This feature class represents an index of records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). This feature class is for informational purposes only. All attribute values should be verified by reviewing the original Well Completion Report. Known issues include: - Missing and duplicate records - Missing values (either missing on original Well Completion Report, or not key entered into database) - Incorrect values (e.g. incorrect Latitude, Longitude, Record Type, Planned Use, Total Completed Depth) - Limited spatial resolution: The majority of well completion reports have been spatially registered to the center of the 1x1 mile Public Land Survey System section that the well is located in.

The table Geologic Log USCS is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 12891 rows across 6 variables.

The table Geologic Log Quick Pick is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 30255 rows across 7 variables.

There are 487 onshore oil and gas fields in California encompassing 3,392 square miles of aggregated area. The California State Water Resources Control Board (State Water Board) initiated a Regional Monitoring Program (RMP) in July 2015, intended to determine where and to what degree groundwater quality may be at potential risk to contamination related to oil and gas development activities including well stimulation, well integrity issues, produced water ponds, and underground injection. The first step in monitoring groundwater in and near oil and gas fields is to prioritize the 487 fields using consistent statewide analysis of available data that indicate potential risk of groundwater to oil and gas development. There were limited existing data on potential groundwater risk factors available for oil and gas fields across the state. During 2014-2016, the U.S. Geological Survey (USGS) extracted and compiled data from various sources, including the California Division of Oil, Gas, and Geothermal Resources (DOGGR) and the Department of Water Resources (DWR). In 2014, total well depths for groundwater wells in California were extracted from digital copies of well completion reports provided to the USGS by DWR. This digital dataset contains 16,912 well depths for domestic, municipal, irrigation, industrial, and agricultural wells that were overlying oil and gas fields or within 5 kilometers of a field boundary. Wells were attributed with approximate _location, well use, and depth using information provided by DWR, and were attributed with land surface elevations using the California National Elevation Dataset. Wells were also attributed with the nearest oil and gas field using DOGGR All Wells geospatial data included in this data release.

The table Borehole Information is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 56552 rows across 4 variables.

The table Annular Material is part of the dataset Well Completion Reports from the California Department of Water Resource, available at https://redivis.com/datasets/h89s-2rga9nge3. It contains 345487 rows across 7 variables.

(Webpage Under Development)

The Department of Water Resources (DWR) provides Technical Support Services (TSS) to assist Groundwater Sustainability Agencies (GSAs) with the implementation of their Groundwater Sustainability Plans (GSPs) and other local entities to better understand groundwater conditions. These services support data collection, groundwater monitoring, and improved understanding of groundwater conditions to help advance sustainable groundwater management efforts across California.

Through the TSS program, DWR has partnered with GSAs and other entities on projects across the state to drill and construct groundwater monitoring wells, install groundwater level recording and telemetry equipment, perform downhole camera and geophysical surveys, and collect and analyze groundwater for general chemistry. The data and reports generated from these efforts are publicly available to support ongoing groundwater management and planning.

Additional information can be found on the Assistance and Engagement webpage.

Summary of Completed TSS Projects

To date, DWR has completed TSS projects in 35 groundwater subbasins, constructing 234 monitoring wells at 92 sites statewide. Each of these wells have been assigned a State Well Number (SWN), have had a Well Completion Report (WCR) submitted to DWRs Online System for Well Completion Reports (OSWCR), and have been registered either through the California Statewide Groundwater Elevation Monitoring (CASGEM) Online System or the Sustainable Groundwater Management Act (SGMA) Portal’s Monitoring Network Module (MNM).

Groundwater level data from these wells are collected by the GSA or DWR and submitted to CASGEM and/or the MNM. These data can be viewed on the Water Data Library (WDL).

WCRs for these wells can be found using the Well Completion Report Map Application.

A summary table of completed TSS wells including their associated well name(s), site code(s), SWN(s), and WCR number(s), can be viewed and/or downloaded here: DWR Completed TSS Wells

An interactive GIS map containing a feature set of all completed TSS wells can be accessed here: GIS Map of Completed TSS Wells

The individual TSS well locations, associated borehole lithologic information, and groundwater level data can be viewed on the SGMA Data Viewer by:

1. Checking the “DWR TSS Wells” box under the “Groundwater Levels” tab on the left side of the screen.

2. Clicking on any one of the well location symbols that appear on the interactive map.

3. Clicking on one of the associated Site Code numbers that appear in the results table.

Completed TSS Projects by Groundwater Subbasin

Below is a list of subbasins in which TSS projects have been completed. These projects are organized by DWR Region (Northern Region, North Central Region, South Central Region, and Southern Region). Each subbasin listed below has one or more completed TSS project. As more TSS projects are completed, they will be added to this list.

All completed TSS projects have several associated documents and datasets, including a Well Installation Summary Report, TSS Agreement between DWR and the GSA, CEQA Notice of Exemption (NOE), Land Use or License Agreement, Local Drilling Permit, Composite Lithologic Log, Survey Report, and a Water Quality Analytical Report. Some projects also include downhole geophysical logs. These data and reports can be accessed by clicking on the subbasin below in which the project is located.

Northern Region

Antelope Subbasin

Big Valley Subbasin

Butte Valley Subbasin

Colusa Subbasin

Corning Subbasin

Enterprise Subbasin

Red Bluff Subbasin

Shasta Valley Subbasin

Sierra Valley Subbasin

Wyandotte Creek Subbasin

North Central Region

Cosumnes Subbasin

Eastern San Joaquin Subbasin

North Yuba Subbasin

Petaluma Valley Subbasin

Santa Rosa Plain Subbasin

Solano Subbasin

Sonoma Valley Subbasin

South Yuba Subbasin

Tracy Subbasin

Ukiah Valley Subbasin

Yolo Subbasin

South Central Region

Delta Mendota Subbasin

Kaweah Subbasin

Kern County Subbasin

Kings Subbasin

Paso Robles Area Subbasin

Tule Subbasin

Turlock Subbasin

Southern Region

Borrego Springs Subbasin

Cuyama Valley Subbasin

Indian Wells Subbasin

Indio Subbasin

Mound Subbasin

Oxnard Plain Subbasin

Pleasant Valley Subbasin

The Department of Water Resources (DWR) Enterprise Monitoring Well Network dataset contains information regarding wells monitored by DWR. The wells included in this dataset have been completed, a well completion report (WCR) has been submitted through the Online System for Well Completion Reports (OSWCR), and have been registered either through the California Statewide Groundwater Elevation Monitoring (CASGEM) Online System or the Sustainable Groundwater Management Act (SGMA) Portal’s Monitoring Network Module (MNM). This dataset will be updated on a monthly basis.

The Department of Water Resources Telemetered Wells dataset contains information regarding wells within the DWR monitoring network that have telemetry equipment installed. The wells included in this dataset have been completed, a well completion report (WCR) has been submitted through the Online System for Well Completion Reports (OSWCR), and have been registered either through the California Statewide Groundwater Elevation Monitoring (CASGEM) Online System or the Sustainable Groundwater Management Act (SGMA) Portal’s Monitoring Network Module (MNM).

Well construction data for 11,917 domestic and 2,390 public-supply wells in the Central Valley were compiled as part of the U.S. Geological Survey (USGS) National Water Quality Assessment Project (NAWQA) and California State Water Resources Control Board (SWRCB) Groundwater Ambient Monitoring and Assessment Program Priority Basin Project (GAMA-PBP). Data were compiled for wells reported in the USGS National Water Information System (NWIS) database and from well information reported to the SWRCB Department of Drinking Water (SWRCB-DDW). Driller’s log data were transcribed from scanned images of well completion reports filed with California Department of Water Resources (DWR). The wells reported in this data release were filtered by water use to select domestic and public-supply wells and omit other water uses. The compilation was then assumed to be representative of the total population of domestic and public-supply wells in the Central Valley. The wells in the compilation were constructed between 1911 and 2008 but are not grouped or separated by date. The data were used to produce two point data sets containing well location and construction information (depth from land surface to the top and bottom of the well screen, hereafter well-screen tops and bottoms; and screen length), and 12 interpolated GIS raster surfaces created by using Empirical Bayesian Kriging on a 1600 by 1600 meter (1 square-mile) grid. The tables are also included in csv format. The 12 rasters comprise predicted values for well screen tops and bottoms and their 10th and 90th quantile values. The interpolated surfaces may also be used to calculate volumes of water-supply in the Central Valley defined by the well-screen tops and bottoms.