About this Dataset

WellSTAR: Oil And Gas Wells

This online map represents oil and gas wells in the CalGEM Well Statewide Tracking and Reporting System, or WellSTAR. Wells are displayed by well type and well status.

CalGEM is the Geologic Energy Management Division of the California Department of Conservation, formerly the Division of Oil, Gas, and Geothermal Resources (as of January 1, 2020).

WellSTAR homepage

Update Frequency: As Needed
Organization: State of California
Last updated: 2024-03-30T02:38:23.927846
Tags: calgem, california-department-of-conservation, california-natural-resources-agency, caopendata, division-of-oil-gas-and-geothermal-resources, doc, doggr, geologic-energy-management-division, geothermal-resources, oil-and-gas, wellstar

Tables

Table 1

@usgov.ca_gov_wellstar_oil_and_gas_wells_2ce1a.table_1

15.71 MB
241,906 rows
29 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "api" BIGINT,
  "leasename" VARCHAR,
  "wellnumber" VARCHAR,
  "welldesignation" VARCHAR,
  "wellstatus" VARCHAR,
  "welltype" VARCHAR,
  "welltypelabel" VARCHAR,
  "operatorname" VARCHAR,
  "operatorcode" VARCHAR,
  "fieldname" VARCHAR,
  "areaname" VARCHAR,
  "place" VARCHAR,
  "district" VARCHAR,
  "countyname" VARCHAR,
  "section" BIGINT,
  "township" VARCHAR,
  "range" VARCHAR,
  "basemeridian" VARCHAR,
  "gissource" VARCHAR,
  "isconfidential" VARCHAR,
  "isdirectionallydrilled" VARCHAR,
  "spuddate" TIMESTAMP,
  "inhpz" VARCHAR,
  "wellsymbol" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);