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 1818 to 1837 of 3677 Displaying rows 1838 to 1857 of 3677 Go to the next page - rows 1858 to 1877 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
1838 MGDGN  RN  Metagranodiorite, gneissose  Gneissose metagranodiorite  AWEL  29-JAN-01  TMCM  31-AUG-18   
1839 MGDH  RC  Hornfelsed metagabbroic-rock and hornfelsed metamicrogabbroic-rock  Hornfelsed metagabbroic-rock and hornfelsed metamicrogabbroic-rock  DJLO  01-JUN-06  TMCM  24-AUG-18 
1840 MGDHB  RN  Metagranodiorite, hornblende  Hornblende metagranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1841 MGDHBB  RN  Metagranodiorite, hornblende-biotite  Hornblende-biotite metagranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1842 MGDHP  RN  Metagranodiorite, k-feldspar-megacrystic-hornblende  K-feldspar-megacrystic-hornblende metagranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1843 MGDL  RN  Metaleucogranodiorite  Metaleucogranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1844 MGDM  RN  Metamelagranodiorite  Metamelagranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1845 MGDP  RN  Metagranodiorite, porphyritic  Porphyritic metagranodiorite  AWEL  23-JAN-02  TMCM  31-AUG-18   
1846 MGFPF  RN  Microgranodiorite, foliated-feldspar-phyric  Foliated-feldspar-phyric microgranodiorite  AWEL  10-JUN-02  TMCM  31-AUG-18   
1847 MGHB  RC  Metagabbro and hornblende schist  Metagabbro and hornblende schist  DJLO  01-JUN-06  TMCM  24-AUG-18 
1848 MGHR  RN  Magnetite-garnet-hypersthene-rock  Magnetite-garnet-hypersthene-rock  AWEL  19-SEP-01  TMCM  31-AUG-18   
1849 MGHRS  RN  Magnetite-garnet-hypersthene-rock, schistose  Schistose magnetite-garnet-hypersthene-rock  AWEL  19-SEP-01  TMCM  31-AUG-18   
1850 MGHY  RN  Metagranodiorite, hypersthene  Hypersthene metagranodiorite  AWEL  11-JUN-02  TMCM  31-AUG-18   
1851 MGLCL  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   
1852 MGLMDT  RN  Metamudstone, glauconitic  Glauconitic metamudstone  AWEL  31-JUL-02  TMCM  31-AUG-18   
1853 MGMA  RC  Microgranodiorite, microdiorite and andesite  Microgranodiorite, microdiorite and andesite  DJLO  01-JUN-06  TMCM  24-AUG-18 
1854 MGMG  RC  Metagabbro and metamicrogabbro  Metagabbro and metamicrogabbro  DJLO  01-JUN-06  TMCM  24-AUG-18 
1855 MGMMG  RC  Metagabbroic-rock and metamicrogabbroic-rock  Metagabbroic-rock and metamicrogabbroic-rock  DJLO  02-JUN-06  TMCM  24-AUG-18 
1856 MGMP  RC  Microgranite and porphyritic microgranite  Microgranite and porphyritic microgranite  DJLO  01-JUN-06  TMCM  24-AUG-18 
1857 MGN  RN  Metagranite  Metagranite  GRBA  24-FEB-00  TMCM  30-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1818 to 1837 of 3677 Displaying rows 1838 to 1857 of 3677 Go to the next page - rows 1858 to 1877 of 3677 Go to the end - rows 3658 to 3677 of 3677