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.
Displaying rows 1998 to 2017 of 3677
| Row | CODE | SOURCE_CODE | DESCRIPTION | TRANSLATION | STATUS | USER_ENTERED | DATE_ENTERED | USER_UPDATED | DATE_UPDATED | TRANSFER | RCS_STATUS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1998 | MLPST | RN | Metalapillistone | Metalapillistone | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 1999 | MLPTPH | 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 | GRBA | 24-FEB-00 | TMCM | 27-MAY-20 | - | |
| 2000 | MLPTUF | RN | Metalapilli-tuff | Metalapilli-tuff | C | GRBA | 24-FEB-00 | TMCM | 30-AUG-18 | N | |
| 2001 | MLSGRV | RN | Metalimestone, gravelly | Gravelly metalimestone | C | AWEL | 31-JUL-02 | TMCM | 31-AUG-18 | U | |
| 2002 | MLSMYL | RN | Metalimestone, mylonitic | Mylonitic metalimestone | C | AWEL | 20-FEB-01 | TMCM | 31-AUG-18 | U | |
| 2003 | MLTC | RC | Calcareous-basaltic metatuff and calcareous-basaltic metalava | Calcareous-basaltic metatuff and calcareous-basaltic metalava | C | DJLO | 05-JUN-06 | TMCM | 24-AUG-18 | I | ? |
| 2004 | MLTFAN | RN | Metalapilli-tuff, andesitic | Andesitic metalapilli-tuff | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2005 | MLTFDA | RN | Metalapilli-tuff, dacitic | Dacitic metalapilli-tuff | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2006 | MLTFRY | RN | Metalapilli-tuff, rhyolitic | Rhyolitic metalapilli-tuff | C | AWEL | 23-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2007 | MLTMGE | RN | Metalithomarge | Metalithomarge | C | AWEL | 31-JUL-02 | TMCM | 31-AUG-18 | N | |
| 2008 | MLTROC | RN | Melatroctolite | Melatroctolite | C | AWEL | 11-JUN-02 | TMCM | 31-AUG-18 | N | |
| 2009 | MLTU | RC | Metalava and metatuff | Metalava and metatuff | C | DJLO | 05-JUN-06 | TMCM | 24-AUG-18 | I | ? |
| 2010 | MLUCTI | RN | Metaleucitite | Metaleucitite | C | AWEL | 24-JAN-02 | TMCM | 30-AUG-18 | N | |
| 2011 | MLUCTO | RN | Metaleucitolite | Metaleucitolite | C | AWEL | 23-JAN-02 | TMCM | 30-AUG-18 | N | |
| 2012 | MLUCTR | RN | Metaleucitic rock | Metaleucitic rock | C | GRBA | 08-MAY-00 | TMCM | 30-AUG-18 | N | |
| 2013 | MLVAAD | RN | Augite-andesite, metalava | Augite-andesite metalava | C | AWEL | 24-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2014 | MLVAN | RN | Metalava, andesite | Andesite metalava | C | AWEL | 21-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2015 | MLVBAT | RN | Metalava, basaltic-trachyandesite | Basaltic-trachyandesite metalava | C | AWEL | 21-JAN-02 | TMCM | 31-AUG-18 | U | |
| 2016 | MLVCB | RN | Metalava, calcareous-basaltic | Calcareous-basaltic metalava | C | DJLO | 05-JUN-06 | TMCM | 31-AUG-18 | I | U |
| 2017 | MLVDA | RN | Metalava, dacite | Dacite metalava | C | AWEL | 24-JAN-02 | TMCM | 31-AUG-18 | U |
Displaying rows 1998 to 2017 of 3677