Vocabularies — details

DIC_COMMODITY

Dictionary of saleable commodities (eg. barytes) produced by mines and quarries.

No. Column name Data type Notes
1 COMMODITY_CODE Varchar(6) Primary key
2 COMMODITY_NAME Varchar(78)  
3 COMMODITY_DESCRIPTION Varchar(150)  
4 DATE_ENTERED Date  
5 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 94)

COMMODITY_CODE COMMODITY_NAME COMMODITY_DESCRIPTION DATE_ENTERED DATE_UPDATED
SLW  Slate Waste  Waste from slate workings, a secondary aggregate, can be used as fill or decorative stone  29-FEB-00  11-APR-06 
MSG  Marine Sand & Gravel  Sand & gravel dredged from the sea floor; size range: 0.063 micron - 80mm. Gravel (Coarse aggregate) ranges 4mm - 80mm in size.  29-FEB-00  11-APR-06 
WIT  Witherite  Witherite  29-FEB-00  24-JUL-02 
AG  Silver  Silver ores  29-FEB-00   
ALA  Alabaster  Gypsum used as a decorative stone  29-FEB-00   
CR  Chromite  Chromium ores  29-FEB-00   
COL  Colliery Spoil  Coal and other materials as secondary aggregates, or for coal processing  29-FEB-00   
MIN  Mineral  Unspecified mineral commodity  29-FEB-00   
PFA  Pulverised Fuel Ash  By-product of electricity generation, secondary aggregate  29-FEB-00   
FBA  Furnace Bottom Ash  By-product of electricity generation, lightweight and secondary aggregate  29-FEB-00   
QUW  Quarry Waste  Unspecified waste from quarry operations, secondary aggregate  29-FEB-00  11-APR-06 
SLA  Slag (inc. BOS and EAF slags)  By-product of steel making, secondary aggregate  29-FEB-00   
SAG  Sand & Gravel  Natural material in a size range: 0.063 micron - 80mm. Gravel (Coarse aggregate) ranges 4mm - 80mm in size. Often silica, flint or chert predominates.  29-FEB-00  12-OCT-05 
SAL  Salt  Halite, NACl, either as rock salt from mining operations or precipitated from Brines  29-FEB-00  30-SEP-04 
SLT  Slate  Fine-grained metamorphic rocks with well developed cleavage often used for roofing or flooring  29-FEB-00  11-APR-06 
SN  Tin  Tin ores  29-FEB-00   
ANT  Anhydrite  Anhydrous Calcium Sulphate, CaSO4  29-FEB-00   
AU  Gold  Gold ores  29-FEB-00   
BAL  Ball Clay  Fine grained, highly plastic, sedimentary clays which fire to a light or near white colour  29-FEB-00  25-JAN-08 
BAR  Barytes  Barium sulphate, BaSO4  29-FEB-00