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 3638 to 3657 of 3677 Displaying rows 3658 to 3677 of 3677 No next page Already at the end

Row CODE SOURCE_CODE DESCRIPTION TRANSLATION STATUS USER_ENTERED DATE_ENTERED USER_UPDATED DATE_UPDATED TRANSFER RCS_STATUS
3658 ZSVC  RN  Silt, sandy, gravelly, clayey [Unlithified Deposits Coding Scheme]  Clayey gravelly sandy silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3659 ZSVL  RN  Silt, sandy, gravelly, cobbly [Unlithified Deposits Coding Scheme]  Cobbly gravelly sandy silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3660 ZSVLB  RN  Silt, sandy, gravelly, cobbly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery cobbly gravelly sandy silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
3661 ZSVP  RN  Silt, sandy, gravelly, peaty [Unlithified Deposits Coding Scheme]  Peaty gravelly sandy silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3662 ZSVPL  RN  Silt, sandy, gravelly, peaty, cobbly [Unlithified Deposits Coding Scheme]  Cobbly peaty gravelly sandy silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3663 ZV  RN  Silt, gravelly [Unlithified Deposits Coding Scheme]  Gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3664 ZVB  RN  Silt, gravelly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3665 ZVC  RN  Silt, gravelly, clayey [Unlithified Deposits Coding Scheme]  Clayey gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3666 ZVCS  RN  Silt, gravelly, clayey, sandy [Unlithified Deposits Coding Scheme]  Sandy clayey gravelly silt [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
3667 ZVL  RN  Silt, gravelly, cobbly [Unlithified Deposits Coding Scheme]  Cobbly gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3668 ZVLB  RN  Silt, gravelly, cobbly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery cobbly gravelly silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
3669 ZVLBS  RN  Silt, gravelly, cobbly, bouldery, sandy [Unlithified Deposits Coding Scheme]  Sandy bouldery cobbly gravelly silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
3670 ZVLS  RN  Silt, gravelly, cobbly, sandy [Unlithified Deposits Coding Scheme]  Sandy cobbly gravelly silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
3671 ZVP  RN  Silt, gravelly, peaty [Unlithified Deposits Coding Scheme]  Peaty gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3672 ZVPL  RN  Silt, gravelly, peaty, cobbly [Unlithified Deposits Coding Scheme]  Cobbly peaty gravelly silt [UDCS]  AWEL  09-JAN-02  TMCM  30-AUG-18   
3673 ZVPSC  RN  Silt, gravelly, peaty, sandy, clayey [Unlithified Deposits Coding Scheme]  Clayey sandy peaty gravelly silt [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
3674 ZVS  RN  Silt, gravelly, sandy [Unlithified Deposits Coding Scheme]  Sandy gravelly silt [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
3675 ZVSC  RN  Silt, gravelly, sandy, clayey [Unlithified Deposits Coding Scheme]  Clayey sandy gravelly silt [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
3676 ZVSL  RN  Silt, gravelly, sandy, cobbly [Unlithified Deposits Coding Scheme]  Cobbly sandy gravelly silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
3677 ZVSLB  RN  Silt, gravelly, sandy, cobbly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery cobbly sandy gravelly silt [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 3638 to 3657 of 3677 Displaying rows 3658 to 3677 of 3677 No next page Already at the end