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 version of the release contains data from 262,649 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 in California. A subset of WCRs for 5969 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-2023, and these data were compiled as part of those studies. Ninety-two WCRs from the additi ...

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 maybe 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 focused on WCRs located primarily along the length of the California Aqueduct in the Central Valley of California. WCR lithologic data added in version 2.0 are from select public-supply wells (PSWs). The PSWs included in this update are those which have had their locations refined and construction characteristics captured as part of the USGS Groundwater Ambient Monitoring and Assessment Program-Priority Basin Project (GAMA-PBP) WCR attribution project. Users can find the list of attributed water supply wells compiled by the GAMA-PBP in Borkovich and others, 2023, https://doi.org/10.5066/P93ICKAF. All attributed values should be verified by reviewing the original WCR which can be retrieved from the California Open Data Portal WCR website: 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 14, 2024 Changes in version 2.0 1) Lithologic data captured from 4,832 well completion reports have been added to the previously published data set. 2) Additional previously unpublished data for well completion reports included in version 1.0 identified while compiling version 2.0 are also included in this update. 3) Added a new column to the data table that contains the publication date for each entry to help track version history. 4) Updates author information to include users who have contributed to the compilation effort following the publication of version 1.0. 5) Some minor revisions were made to the text of the first process step to improve clarity.

Methodology

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.

Usage

Date data was updated: 7/5/2022

OSWCR.csv: Records from the California Department of Water Resourcesí Online System of Well Completion Reports.

OSWCR_DataDictionary.csv: Data dictionary for OSWCR.csv

WCRLinks.csv: Table of links to Well Completion Report PDFs. This table is related to OSWCR via the WCRNumber field.

WCRLinks_DataDictionary.csv: Data dictionary for WCRLinks.csv

WellNumbers.csv: Table of state and local well numbers that are stored in OSWCR

GeologicLog_FreeForm.csv: OSWCR provides three different methods to enter lithologic information. The ìFree Formî method allows users to enter any material description they wish for each depth interval.

GeologicLog_QuickPick.csv: OSWCR provides three different methods to enter lithologic information. The ìQuick Pickî method provides a set of standard values for material type, color, and texture, but also allows the user to enter any additional descriptive information.

GeologicLog_USCS.csv: OSWCR provides three different methods to enter lithologic information. The ìUSCS/ASTM D2488î method provides standard values for soil classification, with along with soil color and other descriptive information.

GeologicLog_GeneralizedLithology: This table provides generalized lithology descriptions and texture classifications that have been interpreted from well completion reports by various programs. This table is under development.

CasingData.csv: Casing data that have been entered into OSWCR including the weld type, casing material type, and casing specifications.

AnnularMaterial.csv: Annular fill data that have been entered into OSWCR including the Fill Type and Fill Type Details.

BoreholeInformation.csv: Diameter of the boreholes and the depth range over which that diameter applies

Submittal_Template_For_Suggested_Corrections.xlsx: Template for submitting suggested Well Completion Report database corrections.

Well owner information has been redacted from the attached tables and from the PDFs that these tables link to.

The attached data and data structure are subject to change, and are for informational purposes only.

All values listed in these tables should be verified by reviewing the original Well Completion Report.

Known issues include:

- Missing values (either missing on original Well Completion Report, or not key entered into database)

- Incorrect values (e.g. wrong Latitude, Longitude, Record Type, Planned Use, Total Completed Depth)

The California Department of Water Resources welcomes feedback to improve the accuracy of the Well Completion Report database.

Please email suggested corrections to benjamin.brezing@water.ca.gov using the attached Submittal_Template_For_Suggested_Corrections.xlsx file.

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

🇺🇸 미국

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.

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

(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

See web image layer here.The aquifer risk map is being 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 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.Methodology for the draft aquifer risk map available for download.This layer shows domestic well density. 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, excluding wells drilled prior to 1970.

This data release provides borehole location and lithology information from selected boreholes in the East Mesa and surrounding areas of Imperial County, California. The area of focus includes parts of the Imperial, Ogilby, and Amos Valley groundwater basins. The purpose of the study is to estimate the future Total Dissolved Solids (TDS) concentration in groundwater pumped by the LCWPS into the All-American Canal. The borehole data included in this data release can be used to evaluate the hydrogeologic framework of the study area, and determine the geometry, extent, and physical characteristics of hydrogeologic materials within the aquifer system. Borehole location and lithology data were sourced from the California Department of Water Resources Online System of Well Completion Reports (OSWCR; California Department of Water Resources, 2021) as well as direct communication with California Department of Water Resources (California Department of Water Resources, 2024); the U.S. Bureau of Reclamation Final Environmental Impact Statement Geohydrology Appendix for the All-American Canal Lining Project (U.S. Bureau of Reclamation, 1994); well log archives from the U.S. Bureau of Reclamation Yuma Area Office (U.S. Bureau of Reclamation, 2023); the U.S. Geological Survey (USGS) Professional Paper Series number 486 chapter K (Loeltz and others, 1975); a USGS publication detailing the characterization of the groundwater system near the Lower Colorado Water Supply Project (Coes and others, 2015), geothermal well reports (Coplen and others, 1973; Elders and others, 1974), and geothermal wells from California Geologic Energy Management Division (CalGEM; California Department of Conservation, 2024).

The aquifer risk map is being 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 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.Methodology for the draft aquifer risk map available for download.Water quality risk: This layer contains summarized water quality risk per census block group, square mile section, and well point. The overall census block group water quality risk is based on four risk factors (the count of chemicals with a long-term average (20 year) or recent result (within 2 years) above the MCL, the count of chemicals with a long-term average (20 year) or recent result (within 2 years) within 80% of the MCL, the average magnitude or results above the MCL, and the percent area with chemicals above the MCL or within 80% of the MCL). The specific chemicals that contribute to these risk factors are listed as well. Higher values for each individual risk factor contribute to a higher overall score. The scores are converted to percentiles to normalize the results. The water quality data is based on depth-filtered, declustered water quality results from public and domestic supply wells, collected following a similar methodology as the Domestic Well Needs Assessment White Paper. This layer also displays the total estimated count of domestic wells per census block group, based on the Department of Water Resources Online System for Well Completion Reports, and the total estimated count of domestic well user population, based on the United States Geological Survey Road-Enhanced Methodology (Johnson and Belitz, 2019). To provide comments or feedback on this map, please email SAFER@waterboards.ca.gov or Emily.Houlihan@Waterboards.ca.gov. Individual chemicals: This layer shows declustered water quality data for arsenic, nitrate, 1,2,3-trichloropropane, uranium, and hexavalent chromium per square mile section. The intent of the aquifer risk map is to help prioritize areas where domestic well users and state small water systems may be accessing groundwater that does not meet primary drinking water standards (maximum contaminant level or MCL) and will be updated annually starting January 1, 2021. The section water quality data is based on depth-filtered water quality results from public and domestic supply wells, collected following a similar methodology as the Domestic Well Needs Assessment White Paper. This layer contains the long-term average (20 years) as well as the count of recent results (within 2 years) above the MCL, between 80% - 100% of the MCL, and below 80% of the MCL for each square mile section. Drinking water users: This layer shows the locations of state small water systems and domestic well density. The state small water system locations were collected by the Rural Community Assistance Corporation. The locations are approximate and may not exactly represent well locations or service boundaries. 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. This layer also contains the public water system boundaries (available on the State Water Board REST endpoint) for reference.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.

The Industry Activity Report provides the most current data available for Alberta's drilling activity. Included in the report are data for new licenses, spuds, land sales, rig activity and well completions. Please see the related tab for PDF report versions.

The Aquifer Risk Map Web Tool contains all archived maps, including this 2023 Aquifer Risk Map.The Aquifer Risk Map is developed to fulfill requirements of SB-200 (Monning, 2019) and is intended to help prioritize areas where domestic wells and state small water systems may be accessing groundwater that does not meet primary drinking water standards (maximum contaminant level or MCL). In accordance with SB-200, the map is made available to the public and updated annually starting January 1, 2021. This web map is part of the 2023 Aquifer Risk Map. The Fund Expenditure Plan states the risk map will be used by Water Boards staff to help prioritize areas for available SAFER funding.

This web map includes the following layers:Water Quality Risk: water quality risk estimates per square mile section for all contaminants with an MCL. Water quality risk is listed as “high” (average or recent concentration in section is above MCL for one or more contaminants), “medium” (average or recent concentration in section is between 80% - 100% of MCL for one or more contaminants), “low” (average or recent concentration in section is less than 80% of MCL for all measured contaminants) or “unknown” (no water quality data available in section).Individual Contaminant Risk: water quality risk estimates for nitrate, arsenic, 1,2,3-trichloropropane, hexavalent chromium, and uranium per square mile section.State Small Water Systems (DDW): state small water systems (5-14 connections) location from the Division of Drinking Water joined with water quality risk section estimates from the 2023 Aquifer Risk Map.Domestic Well Records (OSWCR): the approximate count and location of domestic well completion reports submitted to the Department of Water Resources. This is used as a proxy to identify domestic well locations.Public Water System Boundaries (DDW): the approximate boundaries of public drinking water systems, from the Division of Drinking Water. For reference only.Census Areas: Census block groups and census tract boundaries containing demographic information from the 2021 American Community Survey (B19013 Median Household Income and B03002 race/ethnicity) joined with summarized water quality risk estimates from the 2023 Aquifer Risk Map (count of high risk domestic wells and state small water systems per census area).Reference Boundaries: Various geographic boundaries including counties, basins, GSA’s, CV-SALTS basin prioritization status, Disadvantaged Community (DAC) status, and legislative boundaries. For reference only.CalEnviroScreen 4.0: CalEnviroScreen scores from OEHHA. For reference only.Groundwater Level Percentiles (DWR): Groundwater depth in various monitoring wells compared to the historic average at that well. For reference only.

The water quality risk is based on depth-filtered, de-clustered water quality results from public and domestic supply wells. The methodology used to determine water quality risk is outlined here. For more information about the SAFER program, please email SAFER@waterboards.ca.gov. For technical questions or feedback on the map please email GAMA@waterboards.ca.gov.

This dataset represents a water shortage social vulnerability analysis performed by DWR using Census 2021 block groups as the unit of analysis. This feature class includes water shortage social vulnerability indicators and scores from an analysis done by CA Department of Water Resources, joined to the 2021 Census Block Groups. Most of the indicators were pulled from the ACS (American Communities Survey). These indicators were joined to the block groups to represent a spatial analysis of the social vulnerability of communities to water shortages. The goal of this data is to provide a spatial representation of social and economic factors that can affect water shortage vulnerability in the state of California. Model indicators included in the attribute table are percent of the population 65 and older, percent of households with no vehicles, percent of population 25 and older without a high school diploma. Please note that all of these model indicators are estimated values pulled from the ACS (American Communities Survey). All model indicators are added together using sum-rank methods outlined in the Drought and Water Shortage Risk Scoring: California's Domestic Wells and State Smalls Systems document and CDC standards for sum-rank methods. This data is for the 2022 analysis using 2017-2021 ACS estimates and 2021 Census block groups. From the draft Drought and Water Shortage Vulnerability Scoring document: “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. " A spatial analysis was performed on the 2021 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. These indicator values were subsequently rescaled and summed for a final physical vulnerability score for the sections and small water system service areas. The 2021 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. 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.

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.