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 2378 to 2397 of 3677 Displaying rows 2398 to 2417 of 3677 Go to the next page - rows 2418 to 2437 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
2398 MTOLPG  RN  Metaleucotonalite, pegmatitic  Pegmatitic metaleucotonalite  AWEL  25-JAN-02  TMCM  31-AUG-18   
2399 MTOP  RN  Metatonalite, porphyritic  Porphyritic metatonalite  AWEL  25-JAN-02  TMCM  31-AUG-18   
2400 MTOPG  RN  Metatonalite, pegmatitic  Pegmatitic metatonolite  AWEL  25-JAN-02  TMCM  31-AUG-18   
2401 MTPEAT  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   
2402 MTPH  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   
2403 MTR  RN  Metatrachyte  Metatrachyte  GRBA  24-FEB-00  TMCM  30-AUG-18   
2404 MTRAND  RN  Metatrachyandesite  Metatrachyandesite  GRBA  24-FEB-00  TMCM  30-AUG-18   
2405 MTRBA  RN  Metatrachybasalt  Metatrachybasalt  GRBA  24-FEB-00  TMCM  30-AUG-18   
2406 MTRBI  RN  Metatrachyte, biotite  Biotite metatrachyte  AWEL  25-JAN-02  TMCM  31-AUG-18   
2407 MTRCBY  RN  Metatroctolite, bytownite  Bytownite metatroctolite  AWEL  25-JAN-02  TMCM  31-AUG-18   
2408 MTRCM  RN  Metatrachyte, comenditic  Comenditic metatrachyte  AWEL  25-JAN-02  TMCM  30-AUG-18   
2409 MTRDA  RN  Metatrachydacite  Metatrachydacite  GRBA  24-FEB-00  TMCM  30-AUG-18   
2410 MTRNT  RN  Metatrachyandesite (TAS)  Metatrachyandesite (TAS)  AWEL  22-JAN-02  TMCM  24-AUG-18   
2411 MTROCT  RN  Metatroctolite  Metatroctolite  AWEL  25-JAN-02  TMCM  30-AUG-18   
2412 MTRPT  RN  Metatrachyte, pantelleritic  Pantelleritic metatrachyte  AWEL  25-JAN-02  TMCM  30-AUG-18   
2413 MTRR  RN  Metatrachytic-rock  Metatrachytic-rock  GRBA  24-FEB-00  TMCM  30-AUG-18   
2414 MTRT  RN  Metatrachyte (TAS)  Metatrachyte (TAS)  GRBA  24-FEB-00  TMCM  30-AUG-18   
2415 MTUF  RN  Metatuff  Metatuff  GRBA  24-FEB-00  TMCM  30-AUG-18   
2416 MTUFB  RN  Metatuff, basaltic  Basaltic metatuff  AWEL  27-MAR-01  TMCM  31-AUG-18   
2417 MTUFBA  RN  Metatuff, basalt  Basalt metatuff  DJLO  23-MAY-06  TMCM  31-AUG-18 

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 2378 to 2397 of 3677 Displaying rows 2398 to 2417 of 3677 Go to the next page - rows 2418 to 2437 of 3677 Go to the end - rows 3658 to 3677 of 3677