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.

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.

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

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

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

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.

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

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

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 Geologic Log Generalized Lithology 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 207 rows across 11 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.