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

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

Abstract

This dataset was supplied to the Bioregional Assessment Programme by a third party and is presented here as originally supplied. Metadata was not provided and has been compiled by the Bioregional Assessment Programme based on the known details at the time of acquisition.

These well completion reports contain information on the stratigraphy, location and many other aspects of drilling of each CSG or petroleum exploration well.

Two and a half years after the completion of drilling, well completion reports become public domain and can be downloaded from the state agency websites.

Dataset History

All open domain well completion reports for the Clarence-Moreton bioregion were downloaded individually (usually as pdf) from the Qld QDEX system (http://www.dnrm.qld.gov.au/mapping-data/qdex-reports).

Dataset Citation

Queensland Department of Natural Resources and Mines (2014) CLM - Queensland well completion reports. Bioregional Assessment Source Dataset. Viewed 28 September 2017, http://data.bioregionalassessments.gov.au/dataset/e66a0708-2d10-4f21-bbe1-c986f5e0d4e7.

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.

SDE feature class created nightly from Station Header points (GISLIB.STN_ET_GEOM) and attribute data from PROD. Originally created 9/10/2010 for use in the Water Well Construction web application.

URL: https://geoscience.data.qld.gov.au/dataset/cr120828

Cassio 213 is a Water Observation and Monitoring bore operated by QGC Pty Limited (QGC), in Petroleum Lease, (PL) 1008 (in the Surat Basin). The aim of the bore was to assess the potential changes to surface-groundwater connectivity and interactions with the subsurface expression of groundwater, including areas adjacent to the Dawson River. The bore was drilled to 25.00m MDGL and targeted the Lower Juandah Coal Measures. Three wireline runs, a Packer Test and a Rising Head Test was performed post drilling. The well was developed and completed as a groundwater monitoring bore.

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

Link to the ScienceBase Item Summary page for the item described by this metadata record. Service Protocol: Link to the ScienceBase Item Summary page for the item described by this metadata record. Application Profile: Web Browser. Link Function: information

Well lithology records in this layer come from the Department of Environmental Conservation's Water Supply Data Composite. Managed by the Water Resources Section in the Drinking Water and Groundwater Protection Division, these database reports contain borehole lithology records submitted by Vermont licensed well drillers. Lithologic logs may contain information such as descriptions of materials encountered (e.g., sand, clay, rock, etc.), depth to bedrock, water bearing zones, etc. Data are reported in feet below ground surface. Licensed well drillers have been required to submit well completion reports on a form prepared by the Secretary of the Agency of Natural Resources for each well drilled or modified to the State since 1966. Well tags have been required since 1986. NOTE: the data contained herein are only as accurate as what was submitted to the State of Vermont by licensed well drillers; many wells have been completed but not reported, many reports have missing information, were recorded inaccurately, or poorly located geographically. Data are updated daily.Private Wells from the Well Completion Report Database can be found here: Private Wells

Link to the ScienceBase Item Summary page for the item described by this metadata record. Service Protocol: Link to the ScienceBase Item Summary page for the item described by this metadata record. Application Profile: Web Browser. Link Function: information

URL: https://geoscience.data.qld.gov.au/dataset/cr122368

RM28-24 1 WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr123614

Moon 4 Well Completion Report

URL: https://geoscience.data.qld.gov.au/dataset/cr120601

PL 1037, ATLAS 31, WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr107628

PL 260, AEL LONGSWAMP 32, WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr111988

PL 1018, OER RILEY 46, WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr086043

PL 297, OER COMBABULA 42, WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr120382

PL 100, FV18-66 1, WELL COMPLETION REPORT

URL: https://geoscience.data.qld.gov.au/dataset/cr120827

Pleiades 171 is a Water Observation and Monitoring bore operated by QGC Pty Limited (QGC), in Petroleum Lease, (PL) 1008 (in the Surat Basin). The aim of the bore was to assess the potential changes to surface-groundwater connectivity and interactions with the subsurface expression of groundwater, including areas adjacent to the Dawson River. The bore was drilled to 25.00m MDGL and targeted the Upper Juandah Coal Measures. Three wireline runs and a Rising Head Test was performed post drilling. The well was developed and completed as a groundwater monitoring bore.

URL: https://geoscience.data.qld.gov.au/dataset/cr120935

PL 1037, ATLAS 37, WELL COMPLETION REPORT