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 2238 to 2257 of 3677 Displaying rows 2258 to 2277 of 3677 Go to the next page - rows 2278 to 2297 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
2258 MRYPT  RN  Metarhyolite, pantelleritic  Pantelleritic metarhyolite  AWEL  21-JAN-02  TMCM  30-AUG-18   
2259 MRYR  RN  Metarhyolitic-rock  Metarhyolitic-rock  GRBA  24-FEB-00  TMCM  30-AUG-18   
2260 MRYRBP  RN  Metarhyolitic-rock, biotite-phyric  Biotite-phyric metarhyolitic-rock  AWEL  21-JAN-02  TMCM  31-AUG-18   
2261 MRYT  RN  Metarhyolite (TAS)  Metarhyolite (TAS)  GRBA  24-FEB-00  TMCM  30-AUG-18   
2262 MS  RN  Mud, sandy [Unlithified Deposits Coding Scheme - Extended]  Sandy mud [UDCS-X]  TMCM  28-MAY-20     
2263 MSACL  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   
2264 MSANN  RN  Metasannaite  Metasannaite  AWEL  31-JUL-02  TMCM  30-AUG-18   
2265 MSAPEL  RN  Metasapropelite  Metasapropelite  AWEL  31-JUL-02  TMCM  31-AUG-18   
2266 MSARS  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  22-JUL-02  TMCM  27-MAY-20   
2267 MSAS  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  22-JUL-02  TMCM  27-MAY-20   
2268 MSBARE  RN  Metasublithic-arenite  Metasublithic-arenite  AWEL  15-MAY-02  TMCM  30-AUG-18   
2269 MSCI  RC  Mudstone, siltstone, sandstone, coal, ironstone and ferricrete  Mudstone, siltstone, sandstone, coal, ironstone and ferricrete  DJLO  02-DEC-04  TMCM  24-AUG-18 
2270 MSCOAL  RN  Metasapropelic-coal  Metasapropelic-coal  AWEL  31-JUL-02  TMCM  31-AUG-18   
2271 MSD  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  GRBA  24-FEB-00  TMCM  27-MAY-20   
2272 MSDDLO  RN  Metadolostone, sandy  Sandy metadolostone  AWEL  11-JUN-02  TMCM  31-AUG-18   
2273 MSDI  RC  Mudstone, sandstone and ironstone  Mudstone, sandstone and ironstone  DJLO  05-JUN-06  TMCM  24-AUG-18 
2274 MSDM  RC  Metasandstone and metamudstone  Metasandstone and metamudstone  DJLO  05-JUN-06  TMCM  24-AUG-18 
2275 MSDMST  RN  Metasiderite-mudstone  Metasiderite-mudstone  AWEL  31-JUL-02  TMCM  31-AUG-18   
2276 MSDR  RN  Metasedimentary rock based on grain size or crystal size  Metasedimentary rock based on grain size or crystal size  GRBA  24-FEB-00  TMCM  30-AUG-18   
2277 MSDRSP  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   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 2238 to 2257 of 3677 Displaying rows 2258 to 2277 of 3677 Go to the next page - rows 2278 to 2297 of 3677 Go to the end - rows 3658 to 3677 of 3677