About this Dataset

Abandoned Mine Locations

Mineral Information Layer for Oregon-Release 3 (MILO-Release 3) is a geospatial database that stores and manages information regarding Oregons mineral occurrences, prospects, and mines. Understand that recreation in or around inactive mine sites is extremely dangerous, and can result in serious injury or death. Stay out and stay alive!
Organization: State of Oregon
Last updated: 2024-02-09T16:08:58.173824
Tags: aggregate, baker, benton, borrow-pit, clackamas, clatsop, columbia, coos, crook, curry, deschutes, douglas, gemstone, geoscientificinformation, gilliam, grant, gravel-pit, harney, hood-river, industrial-mineral, jackson, jefferson, josephine, klamath, lake, lane, lincoln, linn, malheur, marion, metallic-mineral, milo-mineral-information-layer-for-oregon, mine, mineral-fuel, mineral-occurrence, mineral-resource, morrow, multnomah, north-america, oregon, polk, prospect, quarry, sand-and-gravel, sherman, stone, tillamook, umatilla, union, united-states-of-america, wallowa, wasco, washington, wheeler, yamhill, zeolite

Tables

Table 1

@usgov.state_of_oregon_abandoned_mine_locations.table_1

2.34 MB
23,316 rows
62 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "commodity" VARCHAR,
  "type" VARCHAR,
  "commodityabbreviation" VARCHAR,
  "odotid" VARCHAR,
  "usgsid" VARCHAR,
  "mlrrid" VARCHAR,
  "operatingstatus" VARCHAR,
  "sitename" VARCHAR,
  "synonym" VARCHAR,
  "owner" VARCHAR,
  "county" VARCHAR,
  "miningdistrict" VARCHAR,
  "location" VARCHAR,
  "plsssectionfraction" VARCHAR,
  "section" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "topomap24k" VARCHAR,
  "topomap100k" VARCHAR,
  "elevationfeet" BIGINT,
  "commoditiesproduced" VARCHAR,
  "productsize" VARCHAR,
  "productinfo" VARCHAR,
  "orematerial" VARCHAR,
  "deposittype" VARCHAR,
  "workingstype" VARCHAR,
  "workingsdescription" VARCHAR,
  "yearofdiscovery" VARCHAR,
  "yearproductionstarted" VARCHAR,
  "fullreference1" VARCHAR,
  "shortreference1" VARCHAR,
  "pages1" VARCHAR,
  "fullreference2" VARCHAR,
  "shortreference2" VARCHAR,
  "pages2" VARCHAR,
  "fullreference3" VARCHAR,
  "shortreference3" VARCHAR,
  "pages3" VARCHAR,
  "fullreference4" VARCHAR,
  "shortreference4" VARCHAR,
  "pages4" VARCHAR,
  "fullreference5" VARCHAR,
  "shortreference5" VARCHAR,
  "pages5" VARCHAR,
  "datasourceid" VARCHAR,
  "mapunit" VARCHAR,
  "mapunitname" VARCHAR,
  "thematicunitlabel" VARCHAR,
  "thematicrocktype" VARCHAR,
  "thematicage" VARCHAR,
  "thematicterranegroup" VARCHAR,
  "thematicformation" VARCHAR,
  "thematicmember" VARCHAR,
  "thematicunit" VARCHAR,
  "thematiclithology" VARCHAR,
  "arcjoinid" VARCHAR,
  "milo_id" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);