Vocabularies — details

DIC_ROCK_ALL

Dictionary table based on the entire version 3 of the BGS Rock Classification Scheme and is populated directly from the 3 supplying tables (BGS.ROCK_NAME_V3, BGS.ROCK_COMPOSITE and BGS.DIC_ROCK_DUMMY). It contains both the base rock names and addditional codes required for specific application, eg. composite names for use on digital geological maps. It is formally approved as the official source of ALL database codes to be used in BGS corporate databases and MUST be followed.

No. Column name Data type Notes
1 CODE Varchar(6) Primary key
2 SOURCE_CODE Varchar(6)  
3 DESCRIPTION Varchar(2000)  
4 TRANSLATION Varchar(500)  
5 STATUS Char(1)  
6 USER_ENTERED Varchar(10)  
7 DATE_ENTERED Date  
8 USER_UPDATED Varchar(10)  
9 DATE_UPDATED Date  
10 TRANSFER Char(1)  
11 RCS_STATUS Char(1)  


Sample data (rows 1 to 20 of 3677)

CODE SOURCE_CODE DESCRIPTION TRANSLATION STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER RCS_STATUS
!  RD  Applicable, but try as we might, we cannot find a value  Not available  C  PSG  06-JAN-04  TMCM  24-AUG-18    ? 
+#*CSR  RN  Metamorphic carbonate sedimentary rock  Metamorphic carbonate sedimentary rock  C  AWEL  07-MAR-00  TMCM  30-AUG-18    N 
+#*DSR  RN  Metadolostone and metamagnesite-stone  Metadolostone and metamagnesite-stone  C  AWEL  08-MAR-00  TMCM  30-AUG-18    N 
+#*HSR  RN  Hybrid metasedimentary rock  Hybrid metasedimentary rock  C  AWEL  08-MAR-00  TMCM  30-AUG-18    N 
+#*ISR  RN  Meta-ironstone  Meta-ironstone  O  AWEL  08-MAR-00  TMCM  30-AUG-18    N 
+#*LSR  RN  Metalimestone  Metalimestone  O  AWEL  08-MAR-00  TMCM  30-AUG-18    N 
+#*MHS  RN  Miscellaneous hydroxide, oxide and silicate metasedimentary rock  Miscellaneous hydroxide, oxide and silicate metasedimentary rock  C  AWEL  02-AUG-02  TMCM  30-AUG-18    N 
+#*MOD  RN  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.  Metasedimentary rock based on modal composition  C  AWEL  08-MAR-00  TMCM  22-FEB-19    A 
+#*NCS  RN  Non-clastic siliceous metasedimentary rock  Non-clastic siliceous metasedimentary rock  C  AWEL  02-AUG-02  TMCM  30-AUG-18    N 
+#*PSP  RN  Metaphosphorite  Metaphosphorite  O  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*RSR  RN  Siliciclastic rudaceous metasedimentary rock  Siliciclastic rudaceous metasedimentary rock  C  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*SAR  RN  Siliciclastic arenaceous metasedimentary rock  Siliciclastic arenaceous metasedimentary rock  C  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*SAS  RN  Siliciclastic argillaceous metasedimentary rock  Siliciclastic argillaceous metasedimentary rock  C  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*SNC  RN  Metasedimentary rock composed of non-carbonate salts  Metasedimentary rock composed of non-carbonate salts  C  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*SPN  RN  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.  Metasedimentary rock based on protolith name  C  AWEL  08-MAR-00  TMCM  22-FEB-19    A 
+#*SRO  RN  Metasedimentary rock rich in organic matter  Metasedimentary rock rich in organic matter  O  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*SSR  RN  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.  Metasedimentary rock  C  AWEL  08-MAR-00  TMCM  22-FEB-19    A 
+#*SSS  RN  Siliciclastic metasedimentary rock  Siliciclastic metasedimentary rock  C  AWEL  22-JUL-02  TMCM  30-AUG-18    N 
+#*TEX  RN  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.  Metasedimentary rock based on textural attributes  C  AWEL  08-MAR-00  TMCM  22-FEB-19    A 
+#MET  RN  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.  Metamorphic rock  C  AWEL  08-MAR-00  TMCM  22-FEB-19    A