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 1598 to 1617 of 3677 Displaying rows 1618 to 1637 of 3677 Go to the next page - rows 1638 to 1657 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
1618 MDA  RN  Metadacite  Metadacite  GRBA  24-FEB-00  TMCM  30-AUG-18   
1619 MDAD  RC  Microdiorite, andesite and diorite  Microdiorite, andesite and diorite  DJLO  23-MAY-06  TMCM  24-AUG-18 
1620 MDADR  RC  Microdiorite and appinitic dioritic-rock  Microdiorite and appinitic dioritic-rock  DJLO  25-SEP-06  TMCM  24-AUG-18 
1621 MDAM  RC  Metadolerite and amphibolite  Metadolerite and amphibolite  DJLO  23-MAY-06  TMCM  24-AUG-18 
1622 MDAN  RC  Microdiorite and andesite  Microdiorite and andesite  DJLO  23-MAY-06  TMCM  24-AUG-18 
1623 MDAR  RN  Metadacitic-rock  Metadacitic-rock  GRBA  24-FEB-00  TMCM  30-AUG-18   
1624 MDAT  RN  Metadacite (TAS)  Metadacite (TAS)  GRBA  24-FEB-00  TMCM  30-AUG-18   
1625 MDCB  RC  Mudstone, chert and smectite-claystone  Mudstone, chert and smectite-claystone  DJLO  23-MAY-06  TMCM  24-AUG-18 
1626 MDCH  RC  Mudstone and chert  Mudstone and chert  DJLO  23-MAY-06  TMCM  24-AUG-18 
1627 MDCL  RC  Mudstone, chert and limestone  Mudstone, chert and limestone  DJLO  02-DEC-04  TMCM  24-AUG-18 
1628 MDCO  RC  Mudstone and [subequal/subordinate] conglomerate  Mudstone and [subequal/subordinate] conglomerate  DJLO  23-MAY-06  TMCM  24-AUG-18 
1629 MDCOAL  RN  Metadull-coal  Metadull-coal  AWEL  31-JUL-02  TMCM  31-AUG-18   
1630 MDCS  RC  Metadolostone and calcsilicate-rock  Metadolostone and calcsilicate-rock  DJLO  23-MAY-06  TMCM  24-AUG-18 
1631 MDFEST  RC  Mudstone and ironstone  Mudstone and ironstone  DJLO  05-DEC-06  TMCM  24-AUG-18 
1632 MDGV  RN  Gravel, muddy [Obsolete code: use VM]  Muddy gravel  AWEL  31-MAY-02  TMCM  02-OCT-20   
1633 MDGYAN  RC  Mudstone with gypsum-stone and/or anhydrite-stone  Mudstone with gypsum-stone and/or anhydrite-stone  DJLO  16-MAY-07  TMCM  24-AUG-18 
1634 MDHA  RC  Mudstone and halite-stone  Mudstone and halite-stone  DJLO  25-MAY-06  TMCM  24-AUG-18 
1635 MDHLM  RN  Mudstone, hemipelagic, laminated  Laminated hemipelagic mudstone  AWEL  16-MAR-04  TMCM  31-AUG-18   
1636 MDI  RN  Metadiorite  Metadiorite  GRBA  24-FEB-00  TMCM  30-AUG-18   
1637 MDIAMT  RN  Metadiamictite  Metadiamictite  AWEL  31-JUL-02  TMCM  30-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1598 to 1617 of 3677 Displaying rows 1618 to 1637 of 3677 Go to the next page - rows 1638 to 1657 of 3677 Go to the end - rows 3658 to 3677 of 3677