This data release consists of a ZIP file that includes: two Excel workbooks, detailed metadata files, and data directories. The Hydraulic Properties Database (HPD; Table-of-AQtests.xlsm) is an interactive Excel workbook that catalogues single-well, aquifer-test results at Pahute Mesa and vicinity. Results from 1,459 single-well, aquifer-test analyses are uniquely identified to 360 tested wells. The Integrated Borehole Workbook (Borehole_Index_PM.xlsm) is an interactive Excel workbook that presents integrated results from slug tests and pumping aquifer tests that took place in 17 boreholes in Pahute Mesa and vicinity from 1962 to 2013. The Metadata folder has detailed metadata.xml files for both Excel workbooks. Directories labeled USGS, NavarroPDF, or NavarroAQT are accompanying data that both Excel workbooks access through hyperlinks and are required to be downloaded for the Excel workbooks to properly function.

This data release contains California Department of Water Resource borehole data that were regularized by the US Geological Survey. This dataset contains borehole lithologic data, and geospatial data of water wells in the Hat Creek basin California, located east of Mount Shasta in southern California. The borehole dataset is released as an excel table and includes (1) individual borehole location, and (2) downhole lithologic interval data derived from well drillers’ lithology logs.

This data release contains California Department of Water Resource borehole data that were regularized by the US Geological Survey. This dataset contains borehole lithologic data, and geospatial data of water wells in the Hat Creek basin California, located east of Mount Shasta in southern California. The borehole dataset is released as an excel table and includes (1) individual borehole location, and (2) downhole lithologic interval data derived from well drillers’ lithology logs.

This data release contains digital data generated by the U.S. Geological Survey under cooperative agreements with San Bernardino Valley Municipal Water District to characterize the three-dimensional hydrogeology of the Yucaipa groundwater subbasin, located east of Los Angeles in southern California. This dataset contains borehole lithologic data, and geospatial data of a three-dimensional hydrogeologic framework model (HFM).The borehole dataset is released as a series of .csv ascii files including (1) individual borehole location, and (2) downhole lithologic interval data derived from well drillers’ lithology logs and parsed to a series of textural descriptors. The geospatial data include polygon and polyline feature classes that are a 2-dimensional representations of the HFM. The polygon feature class is a cellular array where each model cell has multiple attributes including XY location, and interpolated elevations and thicknesses of the hydrogeologic units. The polyline feature class is a series of lines that represent the extent and location of faults included in the HFM. Sources of geologic and hydrogeologic data can be found in the metadata.

This digital dataset was created as part of a U.S. Geological Survey study, done in cooperation with the Sonoma County Water Agency and the City of Petaluma, to be used as the digital hydrogeologic input data for numerical simulation of the groundwater system of the Petaluma Valley Watershed, Sonoma County, California. Elevation, thickness, and extent of the hydrostratigraphic units define the geohydrologic layering of the digital framework model. The location of faults may be used to define the location of potential horizontal flow barriers in numerical simulation of the groundwater system. The intended uses of this dataset include, but are not limited to, natural resource modeling, mapping, and visualization applications. This digital dataset represents the three-dimensional hydrogeologic framework for the Petaluma Valley Watershed, Sonoma County, California. The data define the elevation, thickness, and extent of the principal hydrostratigraphic units of the region, and faults that cut these units. The digital data describe the following eight hydrostratigraphic units: Qal, Quaternary alluvial deposits; BM, Holocene Bay Mud deposits; Qmix, Quaternary mixed unit; WG, Wilson Grove Formation; PF, Petaluma Formation; SV, Sonoma Volcanics; TV, Tolay Volcanics; BSMT, Basement rocks. Most of the three-dimensional hydrogeologic framework data are contained within a single polygon feature class (HFM_300m_polys), which contains a mesh of polygons that represent model cells that have multiple attributes including X, Y, elevation, and thickness of each hydrostratigraphic unit. Faults are provided as a separate line features class (HFM_faults). Two additional ascii files contain the model output from 3D geologic framework and lithologic properties models for the Petaluma groundwater basin. An additional tabular data file contains specific capacity data calculated from well pumping tests.

This digital dataset was created as part of a U.S. Geological Survey study, done in cooperation with the Sonoma County Water Agency and the City of Petaluma, to be used as the digital hydrogeologic input data for numerical simulation of the groundwater system of the Petaluma Valley Watershed, Sonoma County, California. Elevation, thickness, and extent of the hydrostratigraphic units define the geohydrologic layering of the digital framework model. The location of faults may be used to define the location of potential horizontal flow barriers in numerical simulation of the groundwater system. The intended uses of this dataset include, but are not limited to, natural resource modeling, mapping, and visualization applications. This digital dataset represents the three-dimensional hydrogeologic framework for the Petaluma Valley Watershed, Sonoma County, California. The data define the elevation, thickness, and extent of the principal hydrostratigraphic units of the region, and faults that cut these units. The digital data describe the following eight hydrostratigraphic units: Qal, Quaternary alluvial deposits; BM, Holocene Bay Mud deposits; Qmix, Quaternary mixed unit; WG, Wilson Grove Formation; PF, Petaluma Formation; SV, Sonoma Volcanics; TV, Tolay Volcanics; BSMT, Basement rocks. Most of the three-dimensional hydrogeologic framework data are contained within a single polygon feature class (HFM_300m_polys), which contains a mesh of polygons that represent model cells that have multiple attributes including X, Y, elevation, and thickness of each hydrostratigraphic unit. Faults are provided as a separate line features class (HFM_faults). Two additional ascii files contain the model output from 3D geologic framework and lithologic properties models for the Petaluma groundwater basin. An additional tabular data file contains specific capacity data calculated from well pumping tests.

This data release contains a geospatial database related to a digital 3D hydrogeologic framework model (3D HFM) of the Eel River Valley groundwater basin, California. The geospatial database contains two main data elements: (1) input data to the 3D HFM; (2) interpolated elevations and thicknesses of hydrogeologic units as a cellular array, which are a spatial representation of the 3D HFM results. Three hydrogeologic framework models of the same extent and similar conceptualization but successively increasing complexity were developed to characterize the structure, thickness, and extent of the materials within the basin; data from each phase of model-building are contained in this data release. The Phase 1 3D HFM has three hydrogeologic units (HGUs) and is based on a state-scale geologic map and generalized geologic cross sections, with no faults. The Phase 2 3D HFM has four HGUs and refines the elevation and thickness of the HGUs using data from detailed geologic maps and on structure contour and isopach maps that were based on formation tops picked from oil and gas well logs; the model includes faults. The Phase 3 3D HFM has seven HGUs and further refines the elevation and thickness of the HGUs using additional detailed geologic map data and stratigraphic interpretation of lithology data from water wells; the model includes faults. Each 3D HFM is a digital representation of the subsurface configuration of the HGUs that can be visualized in three dimensions and directly incorporated into numerical flow models. Input data to the 3D HFMs included in this data release include surface map data polygons of the hydrogeologic units, fault traces, and structure contour and isopach data that were used in the Phase 2 and 3 HFMs to define the extent and thickness of the deepest basin-filling hydrogeologic unit. Textural (grain size) data were compiled from driller’s lithologic logs from water wells. Well locations are included as point data within the geospatial database; the lithologic data from downhole intervals in each borehole are tabulated in spreadsheet form. The interpolated elevations and thickness of stratigraphic units are presented as a cellular array: essentially a “flattened”, two-dimensional representation of the digital 3D geologic framework, which defines the elevation and thickness of the HGUs within the 3D HFMs from each phase of model construction. The elevation and thickness of the geologic units are contained within a single polygon feature class ModelCells, which contains a mesh of polygons that represent model cells that have multiple attributes including XY location, elevation and thickness of each hydrogeologic unit. The spatial data are accompanied by non-spatial tables that describe the sources of geologic information, a glossary of terms, a description of model units, and a Data Dictionary that duplicates the Entity and Attribute information contained in the metadata file. Spatial data are also presented as shapefiles.

This data release contains a geospatial database related to a digital 3D hydrogeologic framework model (3D HFM) of the Eel River Valley groundwater basin, California. The geospatial database contains two main data elements: (1) input data to the 3D HFM; (2) interpolated elevations and thicknesses of hydrogeologic units as a cellular array, which are a spatial representation of the 3D HFM results. Three hydrogeologic framework models of the same extent and similar conceptualization but successively increasing complexity were developed to characterize the structure, thickness, and extent of the materials within the basin; data from each phase of model-building are contained in this data release. The Phase 1 3D HFM has three hydrogeologic units (HGUs) and is based on a state-scale geologic map and generalized geologic cross sections, with no faults. The Phase 2 3D HFM has four HGUs and refines the elevation and thickness of the HGUs using data from detailed geologic maps and on structure contour and isopach maps that were based on formation tops picked from oil and gas well logs; the model includes faults. The Phase 3 3D HFM has seven HGUs and further refines the elevation and thickness of the HGUs using additional detailed geologic map data and stratigraphic interpretation of lithology data from water wells; the model includes faults. Each 3D HFM is a digital representation of the subsurface configuration of the HGUs that can be visualized in three dimensions and directly incorporated into numerical flow models. Input data to the 3D HFMs included in this data release include surface map data polygons of the hydrogeologic units, fault traces, and structure contour and isopach data that were used in the Phase 2 and 3 HFMs to define the extent and thickness of the deepest basin-filling hydrogeologic unit. Textural (grain size) data were compiled from driller’s lithologic logs from water wells. Well locations are included as point data within the geospatial database; the lithologic data from downhole intervals in each borehole are tabulated in spreadsheet form. The interpolated elevations and thickness of stratigraphic units are presented as a cellular array: essentially a “flattened”, two-dimensional representation of the digital 3D geologic framework, which defines the elevation and thickness of the HGUs within the 3D HFMs from each phase of model construction. The elevation and thickness of the geologic units are contained within a single polygon feature class ModelCells, which contains a mesh of polygons that represent model cells that have multiple attributes including XY location, elevation and thickness of each hydrogeologic unit. The spatial data are accompanied by non-spatial tables that describe the sources of geologic information, a glossary of terms, a description of model units, and a Data Dictionary that duplicates the Entity and Attribute information contained in the metadata file. Spatial data are also presented as shapefiles.

This data release was prepared as part of an agreement between the California Department of Water Resources (DWR) and the United States Geological Survey (USGS) to support the Sustainable Groundwater Management Act (SGMA). Of the many components of that agreement, there is a specific task requiring the Enhancement of Digital Well Completion Reports. Well-completion reports (WCRs) contain information about the wells, such as construction characteristics and lithologic data that is very valuable to SGMA. The data set presented here is a compilation of lithologic information transcribed verbatim from a subset of WCRs contained in the DWR Online System for Well Completion Reports (OSWCR). The format of the lithologic descriptions follows the DWR free form entry method, which allows for any material description to be entered into the OSWCR without standardization. The lithologic descriptions for all depth intervals recorded (in feet below land surface) by the driller on the WCR are captured verbatim, with no regularization or correction for typographical or spelling errors. Some degree of data processing may be required by a user of this dataset depending on its intended use. This data release is intended to be updated as new WCRs are transcribed over time. WCR lithologic data featured in version 1.0 (published March 2023) focused on 5,841 WCRs from many types of wells located primarily along the length of the California Aqueduct in the Central Valley of California. WCR lithologic data added in version 2.0 (published June 2024) were from 4,958 select public-supply wells from throughout the state that had previously been included in a compilation of WCR location and construction data made by the USGS Groundwater Ambient Monitoring and Assessment-Priority Basin Project (GAMA-PBP). WCR lithologic data added in this version 3.0 (published July 2025) are from 8,448 more public-supply wells from throughout the state. As of July 2025, approximately 57 percent of the WCRs in this dataset are also in the GAMA-PBP compilation of refined location information and construction characteristic data from WCRs primarily from water-supply wells in select locations throughout the State (Borkovich and others, 2025; https://doi.org/10.5066/P93ICKAF). Subsequent revisions planned for the GAMA-PBP data release include compiling refined location information and construction characteristic data for more WCRs with lithologic data in this data release. The GAMA-PBP data release includes a flag to indicate which WCRs also have lithologic data compiled in this data release. All attributed values should be verified by reviewing the original WCR which can be retrieved from the California Open Data Portal WCR website (California DWR, 2025): https://data.ca.gov/dataset/well-completion-reports California Water Code Section 13752 allows for the release of redacted copies of well completion reports to the public. DWR is the authoritative source of these data. Version 1.0 posted March 28, 2023 Version 2.0 posted June 12, 2024 Version 3.0 posted July 18, 2025

This data release was prepared as part of an agreement between the California Department of Water Resources (DWR) and the United States Geological Survey (USGS) to support the Sustainable Groundwater Management Act (SGMA). Of the many components of that agreement, there is a specific task requiring the Enhancement of Digital Well Completion Reports. Well-completion reports (WCRs) contain information about the wells, such as construction characteristics and lithologic data that is very valuable to SGMA. The data set presented here is a compilation of lithologic information transcribed verbatim from a subset of WCRs contained in the DWR Online System for Well Completion Reports (OSWCR). The format of the lithologic descriptions follows the DWR free form entry method, which allows for any material description to be entered into the OSWCR without standardization. The lithologic descriptions for all depth intervals recorded (in feet below land surface) by the driller on the WCR are captured verbatim, with no regularization or correction for typographical or spelling errors. Some degree of data processing may be required by a user of this dataset depending on its intended use. This data release is intended to be updated as new WCRs are transcribed over time. WCR lithologic data featured in version 1.0 (published March 2023) focused on 5,841 WCRs from many types of wells located primarily along the length of the California Aqueduct in the Central Valley of California. WCR lithologic data added in version 2.0 (published June 2024) were from 4,958 select public-supply wells from throughout the state that had previously been included in a compilation of WCR location and construction data made by the USGS Groundwater Ambient Monitoring and Assessment-Priority Basin Project (GAMA-PBP). WCR lithologic data added in this version 3.0 (published July 2025) are from 8,448 more public-supply wells from throughout the state. As of July 2025, approximately 57 percent of the WCRs in this dataset are also in the GAMA-PBP compilation of refined location information and construction characteristic data from WCRs primarily from water-supply wells in select locations throughout the State (Borkovich and others, 2025; https://doi.org/10.5066/P93ICKAF). Subsequent revisions planned for the GAMA-PBP data release include compiling refined location information and construction characteristic data for more WCRs with lithologic data in this data release. The GAMA-PBP data release includes a flag to indicate which WCRs also have lithologic data compiled in this data release. All attributed values should be verified by reviewing the original WCR which can be retrieved from the California Open Data Portal WCR website (California DWR, 2025): https://data.ca.gov/dataset/well-completion-reports California Water Code Section 13752 allows for the release of redacted copies of well completion reports to the public. DWR is the authoritative source of these data. Version 1.0 posted March 28, 2023 Version 2.0 posted June 12, 2024 Version 3.0 posted July 18, 2025