About this Dataset

I07 WellCompletionReports

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.
Organization: State of California
Last updated: 2025-07-23T20:13:11.967550
Tags: california, california-department-of-water-resources, dwr, dwr-gis-atlas, entire-period-of-record, groundwater, records, reports, wcr, well, well-completion-reports, well-design, well-destruction, well-drilling, wells

Tables

Table 1

@usgov.ca_gov_i07_wellcompletionreports_03533.table_1

152.25 MB
1,084,437 rows
54 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "wcrnumber" VARCHAR,
  "legacylognumber" VARCHAR,
  "regionoffice" VARCHAR,
  "countyname" VARCHAR,
  "localpermitagency" VARCHAR,
  "permitdate" VARCHAR,
  "permitnumber" VARCHAR,
  "ownerassignedwellnumber" VARCHAR,
  "welllocation" VARCHAR,
  "city" VARCHAR,
  "planneduseformeruse" VARCHAR,
  "drillername" VARCHAR,
  "drillerlicensenumber" VARCHAR,
  "recordtype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "methodofdeterminationll" VARCHAR,
  "llaccuracy" VARCHAR,
  "horizontaldatum" VARCHAR,
  "groundsurfaceelevation" DOUBLE,
  "elevationaccuracy" VARCHAR,
  "elevationdeterminationmethod" VARCHAR,
  "verticaldatum" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" VARCHAR,
  "baselinemeridian" VARCHAR,
  "apn" VARCHAR,
  "dateworkended" VARCHAR,
  "workflowstatus" VARCHAR,
  "totaldrilldepth" DOUBLE,
  "totalcompleteddepth" DOUBLE,
  "topofperforatedinterval" DOUBLE,
  "bottomofperforatedinterval" DOUBLE,
  "casingdiameter" DOUBLE,
  "drillingmethod" VARCHAR,
  "fluid" VARCHAR,
  "staticwaterlevel" DOUBLE,
  "totaldrawdown" DOUBLE,
  "testtype" VARCHAR,
  "pumptestlength" DOUBLE,
  "wellyield" DOUBLE,
  "wellyieldunitofmeasure" VARCHAR,
  "otherobservations" VARCHAR,
  "mtrs" VARCHAR,
  "draw" BIGINT,
  "wcrlinks" VARCHAR,
  "receiveddate" VARCHAR,
  "globalid" VARCHAR,
  "shape" VARCHAR,
  "b118welluse" VARCHAR
);