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 1858 to 1877 of 3677 Displaying rows 1878 to 1897 of 3677 Go to the next page - rows 1898 to 1917 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
1878 MGNP  RN  Metagranite, porphyritic  Porphyritic metagranite  C  AWEL  23-JAN-02  TMCM  31-AUG-18    U 
1879 MGNPG  RN  Metagranite, pegmatitic  Pegmatitic metagranite  C  AWEL  23-JAN-02  TMCM  31-AUG-18    U 
1880 MGNPMB  RN  Metagranite, pegmatitic-muscovite-biotite  Pegmatitic-muscovite-biotite metagranite  C  AWEL  23-JAN-02  TMCM  31-AUG-18    U 
1881 MGNR  RN  Metagranitic-rock  Metagranitic-rock  C  GRBA  24-FEB-00  TMCM  30-AUG-18    N 
1882 MGNRF  RN  Metagranitic-rock, foliated  Foliated metagranitic-rock  C  AWEL  23-JAN-02  TMCM  31-AUG-18    U 
1883 MGNRG  RN  Metagranitic-rock, gneissose  Gneissose metagranitic-rock  C  AWEL  22-MAR-01  TMCM  31-AUG-18    U 
1884 MGNSH  RN  Metagranite, sheared  Sheared metagranite  C  GRBA  24-FEB-00  TMCM  31-AUG-18    U 
1885 MGNXN  RN  Metagranite, xenolithic  Xenolithic metagranite  C  AWEL  24-JUL-02  TMCM  31-AUG-18    U 
1886 MGPOCM  RN  Microgabbro, plagioclase-olivine-clinopyroxene-macrophyric  Plagioclase-olivine-clinopyroxene-macrophyric microgabbro  C  AWEL  19-MAR-04  TMCM  31-AUG-18    U 
1887 MGQD  RC  Microgranodiorite and quartz-microdiorite  Microgranodiorite and quartz-microdiorite  C  DJLO  02-JUN-06  TMCM  24-AUG-18  I  ? 
1888 MGRAV  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  O  AWEL  02-AUG-02  TMCM  27-MAY-20    - 
1889 MGST  RN  Magnesitestone - Sedimentary rocks composed of magnesite are very rare and the few known examples are formed as primary precipitates. Unlithified equivalents are not known. All rocks composed of magnesite are given the group name magnesite-stone. British Geological Survey Research Report RR/99/03, section 3.2 and fig. 7.  Magnesitestone  C  GRBA  24-FEB-00  TMCM  08-MAR-19    R 
1890 MGTBAT  RC  Tholeiitic microgabbro and tholeiitic basalt  Tholeiitic microgabbro and tholeiitic basalt  C  DJLO  30-NOV-06  TMCM  24-AUG-18  I  ? 
1891 MGUR  RC  Metagabbroic-rock and ultramafic-rock  Metagabbroic-rock and ultramafic-rock  C  DJLO  02-JUN-06  TMCM  24-AUG-18  I  ? 
1892 MGVMDU  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  O  AWEL  31-JUL-02  TMCM  27-MAY-20    - 
1893 MGVSMU  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  O  AWEL  31-JUL-02  TMCM  27-MAY-20    - 
1894 MGVSTY  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  O  AWEL  31-JUL-02  TMCM  27-MAY-20    - 
1895 MGYMDS  RN  Gypsum-metamudstone  Gypsum-metamudstone  C  AWEL  30-JUL-02  TMCM  31-AUG-18    N 
1896 MGYPGS  RN  Metagypsum-grainstone  Metagypsum-grainstone  C  AWEL  30-JUL-02  TMCM  31-AUG-18    N 
1897 MGYPGV  RN  This dictionary entry was unnecessary and has been deleted. The code is retained to prevent its re-use in future.  Dictionary entry deleted  O  AWEL  30-JUL-02  TMCM  27-MAY-20    - 

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1858 to 1877 of 3677 Displaying rows 1878 to 1897 of 3677 Go to the next page - rows 1898 to 1917 of 3677 Go to the end - rows 3658 to 3677 of 3677