DIC_MQ_PIT_STATUS
Dictionary table containing codes for use of mineral sites past and present, e.g. active, landfill.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(255) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Varchar(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 9 of 9)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| A |
Site which is actively extracting mineral products, or in the case of wharfs and rail depots, is actively handing minerals
|
Active |
C |
18-OCT-07 |
|
| C |
Site which, at date of entry, has ceased to extract minerals. May be considered as 'Closed' by operator. May be considered to have 'Active', 'Dormant' or 'Expired' planning permissions by Mineral Planning Authority
|
Ceased |
C |
18-OCT-07 |
|
| D |
Site which, at date of entry, is not extracting minerals, but which still has a valid planning permission to do so, and can restart at any time. May be considered 'Mothballed' by operator. May be considered to have 'Active' or 'Dormant' planning permissi |
Inactive |
C |
18-OCT-07 |
|
| H |
Historic building stone sites where not currently active and location is not known for certain
|
Historic |
C |
18-OCT-07 |
|
| R |
Site which has ceased producing minerals and has been restored to a non -mineral use May be considered to have 'Expired' planning permission by Mineral Planning Authority.
|
Restored |
C |
18-OCT-07 |
|
| S |
Sites which are used for other purposes than extraction, but which are still covered by the Mines and Quarries Acts, e.g. tourist mines. |
Special |
C |
18-OCT-07 |
|
| T |
Landfill taking place in void created by mineral extraction. May be considered to have 'Active' planning permissions by Mineral Planning Authority.
|
Tipping |
C |
18-OCT-07 |
|
| Y |
Sites which have been notified by operators or Mineral Planners but have not started extracting mineral at date of entry. Will be considered to have 'Active' planning permissions by Mineral Planning Authority.
|
Yet to Begin |
C |
18-OCT-07 |
|
| ? |
Not Entered. We have not assigned a value yet (and it might not be applicable). |
Not Entered |
C |
18-OCT-07 |
|
