CalGEM: Geothermal Wells
State of California
@usgov.ca_gov_calgem_geothermal_wells_1e72c
State of California
@usgov.ca_gov_calgem_geothermal_wells_1e72c
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"wellstatus" VARCHAR,
"welltype" VARCHAR,
"wellsymbol" VARCHAR,
"gissource" VARCHAR,
"apinumber" BIGINT,
"geodistrict" BIGINT,
"district" DOUBLE,
"confidential" VARCHAR,
"releasedate" VARCHAR,
"countyapicode" BIGINT,
"countyname" VARCHAR,
"leasename" VARCHAR,
"wellnumber" VARCHAR,
"operatorcode" VARCHAR,
"operatorname" VARCHAR,
"operatorstatus" VARCHAR,
"fieldcode" VARCHAR,
"fieldname" VARCHAR,
"areacode" VARCHAR,
"areaname" VARCHAR,
"townshipsection" DOUBLE,
"township" VARCHAR,
"range" VARCHAR,
"basemeridian" VARCHAR,
"directional" VARCHAR,
"redrill" VARCHAR,
"spuddate" VARCHAR,
"abddate" VARCHAR,
"compdate" VARCHAR,
"lat83" DOUBLE,
"long83" DOUBLE,
"datumcode" VARCHAR,
"wellstatusdescription" VARCHAR,
"welldesignation" VARCHAR
);
Anyone who has the link will be able to view this.