Vocabularies — details

DIC_MQ_PIT_STATUS

Dictionary table containing codes for use of mineral sites past and present, e.g. active, historic, 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
Site which is actively extracting mineral products, or in the case of wharfs and rail depots, is actively handing minerals   Active  18-OCT-07   
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  18-OCT-07   
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  18-OCT-07   
Historic building stone sites where not currently active and location is not known for certain   Historic  18-OCT-07   
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  18-OCT-07   
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  18-OCT-07   
Landfill taking place in void created by mineral extraction. May be considered to have 'Active' planning permissions by Mineral Planning Authority.   Tipping  18-OCT-07   
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  18-OCT-07   
Not Entered. We have not assigned a value yet (and it might not be applicable).   Not Entered  18-OCT-07