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

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 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.

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.

The table OSWCR 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 1048237 rows across 45 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.

This is the 2022 version of the Aquifer Risk Map. The 2021 version of the Aquifer Risk Map is available here.This aquifer risk map is developed to fulfill requirements of SB-200 and is intended to help prioritize areas where domestic wells and state small water systems may be accessing raw source groundwater that does not meet primary drinking water standards (maximum contaminant level or MCL). In accordance with SB-200, the risk map is to be made available to the public and is to be updated annually starting January 1, 2021. The Fund Expenditure Plan states the risk map will be used by Water Boards staff to help prioritize areas for available SAFER funding. This is the final 2022 map based upon feedback received from the 2021 map. A summary of methodology updates to the 2022 map can be found here.This map displays raw source groundwater quality risk per square mile section. The water quality data is based on depth-filtered, declustered water quality results from public and domestic supply wells. The process used to create this map is described in the 2022 Aquifer Risk Map Methodology document. Data processing scripts are available on GitHub. Download/export links are provided in this app under the Data Download widget.This draft version was last updated December 1, 2021. Water quality risk: This layer contains summarized water quality risk per square mile section and well point. The section water quality risk is determined by analyzing the long-tern (20-year) section average and the maximum recent (within 5 years) result for all sampled contaminants. These values are compared to the MCL and sections with values above the MCL are “high risk”, sections with values within 80%-100% of the MCL are “medium risk” and sections with values below 80% of the MCL are “low risk”. The specific contaminants above or close to the MCL are listed as well. The water quality data is based on depth-filtered, de-clustered water quality results from public and domestic supply wells.Individual contaminants: This layer shows de-clustered water quality data for arsenic, nitrate, 1,2,3-trichloropropane, uranium, and hexavalent chromium per square mile section. Domestic Well Density: This layer shows the count of domestic well records per square mile. The domestic well density per square mile is based on well completion report data from the Department of Water Resources Online System for Well Completion Reports, with records drilled prior to 1970 removed and records of “destruction” removed.State Small Water Systems: This layer displays point locations for state small water systems based on location data from the Division of Drinking Water.Public Water System Boundaries: This layer displays the approximate service boundaries for public water systems based on location data from the Division of Drinking Water.Reference layers: This layer contains several reference boundaries, including boundaries of CV-SALTS basins with their priority status, Groundwater Sustainability Agency boundaries, census block group boundaries, county boundaries, and groundwater unit boundaries. ArcGIS Web Application

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 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.

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 Geologic Log Free Form 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 352263 rows across 4 variables.

This feature class represents well statistics for different well use categories. This polygon feature class is based on the Public Land Survey System (PLSS) sections, and summarizes the well count, as well as average, minimum, and maximum well depths for domestic, public, and production wells. This PLSS section layer is based on the PLSNET layer that the Department of Pesticide Regulation hosts, which includes projected sections. Well statistics are based on records from the California Department of Water Resources' (DWR) Online System for Well Completion Reports (OSWCR). Statistics are provided for private supply wells, public supply wells, and production wells. Production wells include those wells that are designated as irrigation, municipal, public, or industrial on Well Completion Reports. Limitations of the underlying Well Completion Reports data include missing and incorrect values. Statistics are based on Well Completion Report records with WCR Types 'New' and 'Modification or Repair' and may double count wells in some cases. This feature class is for qualitative informational purposes only.

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.

This dataset identifies the number of individually-owned domestic wells, and the number of households relying upon domestic water supply in the state of California. The number of wells and households are summarized for each Public Land Survey System (PLSS) section. The well locations were determined from more than 635,000 scanned well-completion reports (WCRs) provided by the California Department of Water Resources in 2011. This is only a partial sample of the total number of WCRs (estimated at 1 to 2 million in total). The number of domestic wells was estimated based upon a spatially distributed and randomized survey that determined the Township Ratio (TR) for each township in the state (4,692 in total). Each township generally contains 36 sections (6 x 6). The total number of wells within a section was multiplied by the corresponding TR to estimate the number of domestic wells within each section. See the "TRatio" column in the attribute table. Each section within the same township will have the same Township Ratio. The domestic household data are from the 1990 US Census. These data were provided at the census tract level and were subsequently aggregated to PLSS sections that contained a domestic well. In the case where census tract data identified households using domestic supply, but there were no domestic wells within the tract, the household data were distributed evenly to all sections within the tract. In San Luis Obispo County, the scanned WCRs were incomplete. Therefore, a surrogate method was used. The total number of households reported by the 1990 census did not change; only the distribution of where those households existed within the tract changed. A WCR was considered an individually-owned domestic well if the primary use of the well was identified as being domestic, the owner was an individual, and the well was not destroyed as of 1990. See the larger body work (Johnson and Belitz 2015) for more details.

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.

(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: Checking the “DWR TSS Wells” box under the “Groundwater Levels” tab on the left side of the screen. Clicking on any one of the well location symbols that appear on the interactive map. 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 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.