Vocabularies — details

DIC_ROCK_NAMEV3

Dictionary table which is part of version 3 of the BGS Rock Classification Scheme. The main part of the RCS - it contains only single lithologies.

No. Column name Data type Notes
1 CODE Varchar(6) Primary key
2 DESCRIPTION Varchar(500)  
3 RCS_STATUS Char(1)  
4 TRANSLATION Varchar(500)  
5 Q1 Varchar(30)  
6 Q2 Varchar(30)  
7 Q3 Varchar(30)  
8 Q4 Varchar(30)  
9 DATE_ENTERED Date  
10 DATE_UPDATED Date  
11 DEFINITION_BKING Varchar(4000)  


Sample data (rows 1 to 20 of 2757)

CODE DESCRIPTION RCS_STATUS TRANSLATION Q1 Q2 Q3 Q4 DATE_ENTERED DATE_UPDATED DEFINITION_BKING
MCWERL  MICROWEHRLITE  Microwehrlite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; CI M>90%; olivine 40-90%, clinopyroxene 5-60%, orthopyroxene <5%, of Ol+Cpx+Opx 
MDA  METADACITE  Metadacite          24-FEB-00  13-OCT-05  Not Available 
MCQNO  QUARTZ-MICRONORITE  Quartz-micronorite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz 5-20% of QAPF, feldspar >90% plagioclase (>50% An), pyroxene 5-90%, (<5% clinopyroxene), plagioclase 10-90% & olivine <5% of Px+Plag+Ol, +/-mica/amphibole 
MCQSY  QUARTZ-MICROSYENITE  Quartz-microsyenite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz 5-20% of QAPF, feldspar 65-90% alkali feldspar, +/- mica/amphibole 
MCQZLT  MICROQUARTZOLITE  Microquartzolite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline extrusive/intrusive rock; quartz >90%, feldspar <10% of QAPF, +/- mica/amphibole 
MCSY  MICROSYENITE  Microsyenite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz <5% of QAPF, feldspar 65-90% alkali feldspar, +/- mica/amphibole 
MCSYGN  MICROSYENOGRANITE  Microsyenogranite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock, quartz 20-60% of QAPF, feldspar 65-90% alkali feldspar; +/-mica/amphibole 
MCSYR  MICROSYENITIC-ROCK  Microsyenitic-rock          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz <20% or felspathoids <10% of QAPF, feldspar <35% plagioclase +/- mica/amphibole 
MCTO  MICROTONALITE  Microtonalite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz 20-60% of QAPF, feldspar >90% plagioclase, +/- mica/amphibole 
MCTRCT  MICROTROCTOLITE  Microtroctolite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz <5% of felsics, feldspar >90% plagioclase (>50% An), plagioclase 10-90% , pyroxene >5%, olivine 5-90%, of Plag+Px+Ol +/- amphibole 
MCUMR  MICRO-ULTRAMAFIC-ROCK  Micro-ultramafic-rock          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; CI M>90%; +/- amphibole/pyroxene/olivine/feldspar (mainly plagioclase) 
MCWEBS  MICROWEBSTERITE  Microwebsterite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; CI M>90%; olivine <5%,clinopyroxene 5-90%, orthopyroxene 5-90% of Ol+Cpx+Opx, +/- amphibole/feldspar 
MCILMT  MICRO-ILMENITITE  Micro-ilmenitite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0,25-2mm crystalline intrusive rock; ilmenite >90% 
MCKALO  MICROKALSILITOLITE  Microkalsilitolite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm exotic crystalline extrusive/intrusive rock; kalsilite >10%; none known 
MCLCO  MICROLEUCITOLITE  Microleucitolite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock containing leucite phenocrysts, dominant/only felspathoid; feldspathoids >60%, feldspar <40% of QPAF, +/- mica/pyroxene 
MCLHZ  MICROLHERZOLITE  Microlherzolite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock, CI M>90%, olivine 40-90%, 5-55% ortho-pyroxene & 50-55% clinopyroxene of Ol+Opx+Cpx. +/-Amphibole 
MCLMST  METACALCITE-MUDSTONE  Metacalcite-mudstone          24-FEB-00  24-OCT-05  Not Available 
MCLST  METACALCITE-LIMESTONE  Metacalcite-limestone          24-FEB-00  24-OCT-05  Not Available 
MCMAG  MICROMAGNETITITE  Micromagnetitite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm crystalline intrusive rock; magnetite >90% 
MCMZ  MICROMONZONITE  Micromonzonite          24-FEB-00  16-JAN-08  Medium-grained, av. between 0.25-2mm normal crystalline intrusive rock; quartz <5% of QAPF, feldspar 35-65% plagioclase, +/- mica/amphibole