Vocabularies — details

DIC_ROCK_ALL

The entire version 3 of the BGS Rock Classification Scheme. This table is populated directly from the 3 supplying tables (BGS.ROCK_NAME_V3, BGS.ROCK_COMPOSITE and BGS.DIC_ROCK_DUMMY). All entries in these supplying tables are also held in BGS.DIC_ROCK_ALL. NOTE: no user has anything other than SELECT access to BGS.DIC_ROCK_ALL - its contents are entirely controlled by triggers on the supplying tables.

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  H  08-MAR-00  16-JAN-08 
+#^PRS  RN  METAPYROCLASTIC ROCKS AND METAPYROCLASTIC SEDIMENTS  Metapyroclastic rocks and metapyroclastic sediments  H  08-MAR-00  16-JAN-08 
+#^RSR  RN  METAVOLCANICLASTIC IGNEOUS ROCK AND METAVOLCANICLASTIC IGNEOUS SEDIMENT  Metavolcaniclastic igneous rock and metavolcaniclastic sediment  H  08-MAR-00  16-JAN-08 
+#^SSR  RN  METAVOLCANICLASTIC SEDIMENTARY ROCK AND METAVOLCANICLASTIC SEDIMENT  Metavolcaniclastic sedimentary rock and metavolcaniclastic sediment  H  08-MAR-00  16-JAN-08 
+#~IR  RN  META-IGNEOUS ROCK AND META-IGNEOUS SEDIMENT  Meta-igneous rock and meta-igneous sediment  H  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  H  08-MAR-00  16-JAN-08 
+#MET  RN  METAMORPHIC ROCKS AND METASEDIMENTS  Metamorphic rocks and metasediments  H  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  H  08-MAR-00  16-JAN-08 
+#UTEX  RN  METAMORPHIC ROCKS UNKNOWN PROTOLITH BASED ON TEXTURAL ATTRIBUTES  Metamorphic rocks unknown protolith based on textural attributes  H  08-MAR-00  16-JAN-08 
+*CSSR  RN  CARBONATE SEDIMENTS AND CARBONATE SEDIMENTARY ROCKS  Carbonate sediments and carbonate sedimentary rocks  H  08-MAR-00  16-JAN-08