About this Dataset

Well Completion Reports

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.
Organization: State of California
Last updated: 2023-08-12T10:14:08.909744
Tags: california-department-of-water-resources, groundwater, well-completion-reports, wells

Tables

Geologic Logs - Generalized Lithology And Texture Classification (Under Development)

@usgov.ca_gov_well_completion_reports_dfe76.geologic_logs_generalized_lithology_and_texture_classi_95643055

2.41 MB
455,252 rows
12 columns

CREATE TABLE geologic_logs_generalized_lithology_and_texture_classi_95643055 (
  "wcrnumber" VARCHAR,
  "intervalstart" VARCHAR,
  "intervalend" VARCHAR,
  "texture" VARCHAR,
  "texturequalifier" VARCHAR,
  "texturemodifier1" VARCHAR,
  "texturemodifier2" VARCHAR,
  "color1" VARCHAR,
  "color2" VARCHAR,
  "colorqualifier" VARCHAR,
  "classification" VARCHAR,
  "data_source" VARCHAR
);