DIC_MIN_SITE_TYPE
A dictionary of mineral working sites where minerals are stored, loaded, produced, unloaded or transported.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(6) |
Primary key
|
2 |
DESCRIPTION |
Varchar(500) |
|
3 |
TRANSLATION |
Varchar(50) |
|
4 |
STATUS |
Char(1) |
|
5 |
DATE_ENTERED |
Date |
|
6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 14 of 14)
CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
! |
Not Available - Applicable but try as we might,we can't find a value. |
Not Available |
C |
13-FEB-07 |
|
- |
Not Applicable |
Not Applicable |
C |
13-FEB-07 |
|
? |
Not Entered - We haven't assigned a value yet |
Not Entered |
C |
13-FEB-07 |
|
O |
A surface mineral working. It may be termed Quarry, Sand Pit, Clay Pit or Opencast Coal Site |
Open-pit or surface workings |
C |
13-FEB-07 |
23-FEB-07 |
OU |
Working is partly surface and partly underground, working the same bodies for the same commodities
|
Open-pit and underground
|
C |
13-FEB-07 |
|
P |
Power station which produces Desulphogypsum and, or, Pulverised Fuel Ash or Furnace Bottom Ash |
Power Station |
C |
13-FEB-07 |
16-JUL-07 |
R |
A site where mineral commodities are unloaded from rail trucks and stored |
Rail depot
|
C |
13-FEB-07 |
23-FEB-07 |
U |
Working is wholly underground, access by shaft, adit or drift. Working may be termed Colliery, Mine, Drift Mine, Slant, Level, Adit or Ingoing Eye |
Underground workings
|
C |
13-FEB-07 |
04-OCT-07 |
W |
Sea, river or canal wharf where mineral commodities are unloaded and stored
|
Wharf
|
C |
13-FEB-07 |
|
C |
Wooden troughs in which scrap iron was placed in order to precipitate copper metal from mine drainage water |
Copper precipitation pit |
C |
16-JUL-07 |
|
S |
Steel works which produce Slags as a byproduct of blast furnace steel smelting |
Steel Works |
C |
16-JUL-07 |
07-JAN-08 |
T |
Tip at a mine, quarry or other location from which mineral is being extracted. Working may be termed Slate Waste Tip, Shale Bing, Coal Tip or Coal Bing |
Tip |
C |
11-OCT-07 |
11-OCT-07 |
L |
Wellsite, or other surface plant, extracting liquid or gas. Working may be for brine, oil or natural gas |
Liquid or gas extraction |
C |
07-JAN-08 |
10-JAN-08 |
A |
Recycled material, construction and demolition materials recovered for use as secondary aggregates |
Recycled |
C |
29-JAN-08 |
|