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 additional California counties of Trinity, Ventura, Alameda, San Diego, Sierra, Orange, Lassen, Sonoma, Inyo, Tuolumne, Mariposa, Los Angeles, Fresno, and Madera have been included because the WCRs were initially incorrectly assigned to one county and are now reported with their correct county assignment. This dataset differs from the data provided in OSWCR because it includes data for some additional fields such as NumberOpenIntervals, USGS_SiteNumber, and SWRCB_DDW_PublicSupplyWell and doesn't include some fields that are in OSWCR, some data attributed in OSWCR were checked for accuracy and updated, and more precise locations were determined for some wells. The additional fields provide more detail about the open or perforated intervals in the well, various identification numbers for the wells, and generalized lithology, and were populated where they could be identified. Some attributes have been provided by cooperating entities as indicated in the REFERENCE field. About 60 percent of the locations are georeferenced to finer resolution based on county Assessor's Parcel Number (APN), 911, or local water authority geospatial datasets. The attributed information is linked to the redacted publicly available Department of Water Resources well completion report image when the link can be resolved. This dataset is for information purposes only. All attribute values should be verified by reviewing the original Well Completion Report. California Water Code Section 13752 allows for the release of redacted copies of well completion reports to the public. DWR is the authoritative source of these data. https://data.ca.gov/dataset/well-completion-reports Version History Summary: Version 1.0 posted online August 8, 2019 (available upon request) Version 2.0 posted online January 24, 2023 (https://doi.org/10.5066/P9R1V41Q) Version 3.0 posted online July 21, 2023 (available upon request) Version 4.0 posted online September 24, 2024

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

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

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

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.

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

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

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.

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 Casing Data 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 110392 rows across 14 variables.