Vocabularies — view dictionary terms


DIC_ROCK_ALL (3677 rows)
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.


Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1178 to 1197 of 3677 Displaying rows 1198 to 1217 of 3677 Go to the next page - rows 1218 to 1237 of 3677 Go to the end - rows 3658 to 3677 of 3677

Row CODE SOURCE_CODE DESCRIPTION TRANSLATION STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER RCS_STATUS
1198 MAGMBR  RN  Magmatic-breccia  Magmatic-breccia  DJLO  15-DEC-06  TMCM  31-AUG-18 
1199 MAGQG  RN  Quartz-garnet-magnetite-rock  Quartz-garnet-magnetite-rock  AWEL  21-MAY-02  TMCM  31-AUG-18   
1200 MAGTR  RN  Meta-agglomerate, trachytic  Trachytic meta-agglomerate  AWEL  21-JAN-02  TMCM  31-AUG-18   
1201 MAKBST  RN  Meta-ankerite-boundstone  Meta-ankerite-boundstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1202 MAKFST  RN  Meta-ankerite-framestone  Meta-ankerite-framestone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1203 MAKGST  RN  Meta-ankerite-grainstone  Meta-ankerite-grainstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1204 MAKMCS  RN  Meta-ankerite-microstone  Meta-ankerite-microstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1205 MAKMSP  RN  Meta-ankerite-microsparstone  Meta-ankerite-microsparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1206 MAKMST  RN  Meta-ankerite-mudstone  Meta-ankerite-mudstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1207 MAKPSP  RN  Meta-ankerite-pseudosparstone  Meta-ankerite-pseudosparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1208 MAKPST  RN  Meta-ankerite-packstone  Meta-ankerite-packstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1209 MAKSED  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  AWEL  31-JUL-02  TMCM  27-MAY-20   
1210 MAKSPT  RN  Meta-ankerite-sparstone  Meta-ankerite-sparstone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1211 MAKST  RN  Meta-ankeritestone  Meta-ankeritestone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1212 MAKWST  RN  Meta-ankerite-wackestone  Meta-ankerite-wackestone  AWEL  31-JUL-02  TMCM  30-AUG-18   
1213 MALCRT  RN  Meta-alcrete  Meta-alcrete  AWEL  31-JUL-02  TMCM  30-AUG-18   
1214 MALS  RN  Monomineralic aluminium-silicate - These sediments and rocks take the form of clays and claystones. British Geological Survey Research Report RR/99/03, section 9.1 and table 19.  Monomineralic aluminium-silicate  AWEL  08-JUN-01  TMCM  13-MAR-19   
1215 MAND  RN  Meta-andesite  Meta-andesite  GRBA  24-FEB-00  TMCM  30-AUG-18   
1216 MANDA  RN  Meta-andesite, augite  Augite meta-andesite  AWEL  21-JAN-02  TMCM  31-AUG-18   
1217 MANDH  RN  Meta-andesite, hypersthene  Hypersthene meta-andesite  AWEL  21-JAN-02  TMCM  31-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1178 to 1197 of 3677 Displaying rows 1198 to 1217 of 3677 Go to the next page - rows 1218 to 1237 of 3677 Go to the end - rows 3658 to 3677 of 3677