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(500)  
4 TRANSLATION Varchar(500)  
5 STATUS Char(1)  
6 DATE_ENTERED Date  
7 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 3310)

CODE SOURCE_CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
+#*TEX  RN  METAMORPHIC SEDIMENTARY ROCK BASED ON TEXTURAL ATTRIBUTES  Metamorphic sedimentary rocks based on textural attributes  08-MAR-00  16-JAN-08 
+#^PRS  RN  METAPYROCLASTIC ROCKS AND METAPYROCLASTIC SEDIMENTS  Metapyroclastic rocks and metapyroclastic sediments  08-MAR-00  16-JAN-08 
+#^RSR  RN  METAVOLCANICLASTIC IGNEOUS ROCK AND METAVOLCANICLASTIC IGNEOUS SEDIMENT  Metavolcaniclastic igneous rock and metavolcaniclastic sediment  08-MAR-00  16-JAN-08 
+#^SSR  RN  METAVOLCANICLASTIC SEDIMENTARY ROCK AND METAVOLCANICLASTIC SEDIMENT  Metavolcaniclastic sedimentary rock and metavolcaniclastic sediment  08-MAR-00  16-JAN-08 
+#~IR  RN  META-IGNEOUS ROCK AND META-IGNEOUS SEDIMENT  Meta-igneous rock and meta-igneous sediment  08-MAR-00  16-JAN-08 
+#~MOD  RN  METAMORPHIC ROCKS WITH IGNEOUS PROTOLITH BASED ON MODAL COMPOSITION  Metamorphic rocks with igneous protolith based on modal composition  08-MAR-00  16-JAN-08 
+#MET  RN  METAMORPHIC ROCKS AND METASEDIMENTS  Metamorphic rocks and metasediments  08-MAR-00  16-JAN-08 
+#UMOD  RN  METAMORPHIC ROCKS WITH UNKNOWN PROTOLITH BASED ON MODAL COMPOSITION  Metamorphic rocks with unknown protolith based on modal composition  08-MAR-00  16-JAN-08 
+#UTEX  RN  METAMORPHIC ROCKS UNKNOWN PROTOLITH BASED ON TEXTURAL ATTRIBUTES  Metamorphic rocks unknown protolith based on textural attributes  08-MAR-00  16-JAN-08 
+*CSSR  RN  CARBONATE SEDIMENTS AND CARBONATE SEDIMENTARY ROCKS  Carbonate sediments and carbonate sedimentary rocks  08-MAR-00  16-JAN-08