DMR All Mines by US Government | Environmental and Climate Sciences

About this Dataset

DMR All Mines

This service presents location, status, and other information regarding mining operations regulated under the Surface Mining and Reclamation Act of 1975 (SMARA) in California. The data presented in this service is reported by mine operators in annual reports provided to the California Department of Conservation Division of Mine Reclamation (DMR) under Public Resources Code section 2207. While DMR attempts to populate Mines Online with accurate map coordinate data, the DMR cannot guarantee the accuracy of operator-reported location information.
Organization: State of California
Last updated: 2024-03-30T01:07:55.381809
Tags: california, california-department-of-conservation, california-natural-resources-agency, cnra, division-of-mine-reclamation, dmr, doc, land-use, lead-agency, minerals, mines, mines-and-mineral-resources, mining, smara, surface-mining-and-reclamation-act

Tables

Table 1

@usgov.ca_gov_dmr_all_mines_fe8a4.table_1

309.33 KB
1971 rows
35 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mine_id" VARCHAR,
  "minename" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "las_code" DOUBLE,
  "las_name" VARCHAR,
  "reportyear" DOUBLE,
  "reporttype" DOUBLE,
  "acres_dist" DOUBLE,
  "minestatus" VARCHAR,
  "rec_status" VARCHAR,
  "operator" VARCHAR,
  "opt_street" VARCHAR,
  "opt_city" VARCHAR,
  "opt_state" VARCHAR,
  "opt_zip" VARCHAR,
  "optcountry" VARCHAR,
  "owner" VARCHAR,
  "owr_street" VARCHAR,
  "owr_city" VARCHAR,
  "owr_state" VARCHAR,
  "owr_zip" VARCHAR,
  "owrcountry" VARCHAR,
  "rp_number" VARCHAR,
  "priproduct" VARCHAR,
  "other_prod" VARCHAR,
  "opt_type" VARCHAR,
  "permit_num" VARCHAR,
  "permitacre" VARCHAR,
  "mech_total" DOUBLE,
  "faceamount" DOUBLE
);