Name: Mined Land Permits: Beginning 1974
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Mined Land Permits: Beginning 1974

This coverage contains data from the Division of Mineral Resources Mined Lands permit files.
Organization: State of New York
Last updated: 2020-11-12T04:00:33.274780
Tags: aggregate, gravel, mined-land, minerals, mines, stone

Tables

Table 1

@usgov.state_of_new_york_mined_land_permits_beginning_1974.table_1

803.48 KB
6116 rows
26 columns


CREATE TABLE table_1 (
  "mine_id_number" BIGINT,
  "permittee_name" VARCHAR,
  "mine_name" VARCHAR,
  "status" VARCHAR,
  "facility_location" VARCHAR,
  "county" VARCHAR,
  "town" VARCHAR,
  "acres_controlled" DOUBLE,
  "acres_permitted_for_life_of_mine" DOUBLE,
  "acres_affected" DOUBLE,
  "acres_reclaimed" DOUBLE,
  "acres_bb" DOUBLE,
  "acres_bb_range" DOUBLE,
  "commodity" VARCHAR,
  "initial_permit_date" TIMESTAMP,
  "permit_issue_date" TIMESTAMP,
  "permit_end_date" TIMESTAMP,
  "date_of_last_inspection" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "reclamation_type" VARCHAR,
  "financial_security_amount" DOUBLE,
  "underground_mine" VARCHAR,
  "last_modified_date" VARCHAR,
  "map_flag" VARCHAR,
  "georeference" VARCHAR
);