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 1778 to 1797 of 3677 Displaying rows 1798 to 1817 of 3677 Go to the next page - rows 1818 to 1837 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
1798 MG1KMB  RN  Meta-group-1-kimberlite  Meta-group-1-kimberlite  GRBA  24-FEB-00  TMCM  30-AUG-18   
1799 MG2KMB  RN  Meta-group-2-kimberlite  Meta-group-2-kimberlite  GRBA  24-FEB-00  TMCM  30-AUG-18   
1800 MGAL  RC  Aplitic microgranite and leucogranite  Aplitic microgranite and leucogranite  DJLO  01-JUN-06  TMCM  24-AUG-18 
1801 MGAYLU  RN  Metagaylussite  Metagaylussite  AWEL  31-JUL-02  TMCM  30-AUG-18   
1802 MGB  RN  Metagabbro  Metagabbro  GRBA  24-FEB-00  TMCM  30-AUG-18   
1803 MGBA  RC  Microgabbro and basalt  Microgabbro and basalt  DJLO  01-JUN-06  TMCM  24-AUG-18 
1804 MGBAN  RN  Meta-analcime-gabbro  Meta-analcime-gabbro  AWEL  26-MAR-04  TMCM  30-AUG-18   
1805 MGBANH  RN  Meta-analcime-gabbro, hornblende  Hornblende meta-analcime-gabbro  AWEL  26-MAR-04  TMCM  31-AUG-18   
1806 MGBBBY  RN  Metagabbro, biotite-bytownite  Biotite-bytownite metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1807 MGBBY  RN  Metagabbro, bytownite  Bytownite metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1808 MGBF  RC  Microgabbro and feldspar-phyric basalt  Microgabbro and feldspar-phyric basalt  DJLO  01-JUN-06  TMCM  24-AUG-18 
1809 MGBFLX  RN  Metagabbro, fluxioned  Fluxioned metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1810 MGBFO  RN  Metagabbro, foliated  Foliated metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1811 MGBFP  RN  Metagabbro, feldspar-phyric  Feldspar-phyric metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1812 MGBG  RC  Microgabbro, basalt and analcime-gabbro  Microgabbro, basalt and analcime-gabbro  DJLO  01-JUN-06  TMCM  24-AUG-18 
1813 MGBGB  RC  Microgabbro and gabbro  Microgabbro and gabbro  DJLO  07-DEC-06  TMCM  24-AUG-18 
1814 MGBGN  RN  Metagabbro, gneissose  Gneissose metagabbro  AWEL  21-FEB-01  TMCM  31-AUG-18   
1815 MGBHB  RN  Metagabbro, hypersthene-bearing  Hypersthene-bearing metagabbro  AWEL  16-FEB-01  TMCM  31-AUG-18   
1816 MGBHYP  RN  Metaorthopyroxene-gabbro, hypersthene  Hypersthene metaorthopyroxene-gabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   
1817 MGBM  RN  Metagabbro, migmatitic  Migmatitic metagabbro  AWEL  23-JAN-02  TMCM  31-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 1778 to 1797 of 3677 Displaying rows 1798 to 1817 of 3677 Go to the next page - rows 1818 to 1837 of 3677 Go to the end - rows 3658 to 3677 of 3677