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(2000)  
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 USER_ENTERED Varchar(10)  
10 DATE_ENTERED Date  
11 USER_UPDATED Varchar(10)  
12 DATE_UPDATED Date  
13 TRANSFER Char(1)  
14 DEFINITION_BKING Varchar(4000)  
15 STATUS Char(1)  


Sample data (rows 1 to 20 of 3025)

CODE DESCRIPTION RCS_STATUS TRANSLATION Q1 Q2 Q3 Q4 USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER DEFINITION_BKING STATUS
!  Applicable, but try as we might, we cannot find a value  ?  Not available          TMCM  22-MAY-20      I  Not Available  C 
+#*CSR  Metamorphic carbonate sedimentary rock  N  Metamorphic carbonate sedimentary rock          AWEL  07-MAR-00  TMCM  30-AUG-18    Not Available  C 
+#*DSR  Metadolostone and metamagnesite-stone  N  Metadolostone and metamagnesite-stone          AWEL  08-MAR-00  TMCM  30-AUG-18    Not Available  C 
+#*HSR  Hybrid metasedimentary rock  N  Hybrid metasedimentary rock          AWEL  08-MAR-00  TMCM  30-AUG-18    Not Available  C 
+#*ISR  Meta-ironstone  N  Meta-ironstone          AWEL  08-MAR-00  TMCM  30-AUG-18    Not Available  O 
+#*LSR  Metalimestone  N  Metalimestone          AWEL  08-MAR-00  TMCM  30-AUG-18    Not Available  O 
+#*MHS  Miscellaneous hydroxide, oxide and silicate metasedimentary rock  N  Miscellaneous hydroxide, oxide and silicate metasedimentary rock          AWEL  02-AUG-02  TMCM  30-AUG-18    Not Available  C 
+#*MOD  Metasedimentary rock based on modal composition - In the Rock Classification Scheme, a metasedimentary rock is classified within this category if it cannot be classified according to protolith name. British Geological Survey Research Report RR/99/02, section 3.2 and figs. 1, 5-7.  A  Metasedimentary rock based on modal composition          AWEL  08-MAR-00  TMCM  22-FEB-19    Not Available  C 
+#*NCS  Non-clastic siliceous metasedimentary rock  N  Non-clastic siliceous metasedimentary rock          AWEL  02-AUG-02  TMCM  30-AUG-18    Not Available  C 
+#*PSP  Metaphosphorite  N  Metaphosphorite          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  O 
+#*RSR  Siliciclastic rudaceous metasedimentary rock  N  Siliciclastic rudaceous metasedimentary rock          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  C 
+#*SAR  Siliciclastic arenaceous metasedimentary rock  N  Siliciclastic arenaceous metasedimentary rock          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  C 
+#*SAS  Siliciclastic argillaceous metasedimentary rock  N  Siliciclastic argillaceous metasedimentary rock          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  C 
+#*SNC  Metasedimentary rock composed of non-carbonate salts  N  Metasedimentary rock composed of non-carbonate salts          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  C 
+#*SPN  Metasedimentary rock based on protolith name - In the Rock Classification Scheme, a metasedimentary rock is classified within this category if its sedimentary protolith is clearly recognisable. British Geological Survey Research Report RR/99/02, section 3.1 and fig. 1. See also: sedimentary rock and sediment.  A  Metasedimentary rock based on protolith name          AWEL  08-MAR-00  TMCM  22-FEB-19    Not Available  C 
+#*SRO  Metasedimentary rock rich in organic matter  N  Metasedimentary rock rich in organic matter          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  O 
+#*SSR  Metasedimentary rock - In the Rock Classification Scheme, a rock is classified within this category if it is known to be a metamorphic rock derived from a sedimentary protolith, either because of its lithological characteristics or its lithological associations. The class includes metasedimentary rock based on protolith name, metasedimentary rock based on modal composition, and metasedimentary rock based on textural attributes. British Geological Survey Research Report RR/99/02, section 3 and fig. 1.  A  Metasedimentary rock          AWEL  08-MAR-00  TMCM  22-FEB-19    Not Available  C 
+#*SSS  Siliciclastic metasedimentary rock  N  Siliciclastic metasedimentary rock          AWEL  22-JUL-02  TMCM  30-AUG-18    Not Available  C 
+#*TEX  Metasedimentary rock based on textural attributes - In the Rock Classification Scheme, a metasedimentary rock is classified within this category if neither the exact nature of the protolith nor the modal composition is known. This class includes paraschist, paragneiss, and paragranofels. British Geological Survey Research Report RR/99/02, section 3.3 and fig. 1.  A  Metasedimentary rock based on textural attributes          AWEL  08-MAR-00  TMCM  22-FEB-19    Not Available  C 
+#MET  Metamorphic rock - In the Rock Classification Scheme, this high level class includes metasedimentary rock, metavolcaniclastic rock, meta-igneous rock, metamorphic rock with unknown protolith, mechanically broken and reconstituted rock, metasomatic-rock and hydrothermal-rock. Metamorphism encompasses all the solid state changes that occur between the upper and lower limits of metamorphism. Major changes in bulk composition are referred to as metasomatism. British Geological Survey Research Report RR/99/02, section 1 and fig. 1.  A  Metamorphic rock          AWEL  08-MAR-00  TMCM  22-FEB-19    Not Available  C