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 518 to 537 of 3677 Displaying rows 538 to 557 of 3677 Go to the next page - rows 558 to 577 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
538 CVBSZ  RN  Clay, gravelly, bouldery, sandy, silty [Unlithified Deposits Coding Scheme]  Silty sandy bouldery gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
539 CVBZ  RN  Clay, gravelly, bouldery, silty [Unlithified Deposits Coding Scheme]  Silty bouldery gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
540 CVBZS  RN  Clay, gravelly, bouldery, silty, sandy [Unlithified Deposits Coding Scheme]  Sandy silty bouldery gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
541 CVH  RN  Clay, gravelly, shelly [Unlithified Deposits Coding Scheme - Extended]  Shelly gravelly clay [UDCS-X]  TMCM  28-MAY-20     
542 CVL  RN  Clay, gravelly, cobbly [Unlithified Deposits Coding Scheme]  Cobbly gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
543 CVLB  RN  Clay, gravelly, cobbly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery cobbly gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
544 CVLP  RN  Clay, gravelly cobbly peaty [Unlithified Deposits Coding Scheme]  Peaty cobbly gravelly clay [UDCS]  DJLO  05-MAY-09  TMCM  31-AUG-18 
545 CVLS  RN  Clay, gravelly, cobbly, sandy [Unlithified Deposits Coding Scheme]  Sandy cobbly gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
546 CVP  RN  Clay, gravelly, peaty [Unlithified Deposits Coding Scheme]  Peaty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
547 CVPS  RN  Clay, gravelly, peaty, sandy [Unlithified Deposits Coding Scheme]  Sandy peaty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
548 CVPSZ  RN  Clay, gravelly, peaty, sandy, silty [Unlithified Deposits Coding Scheme]  Silty sandy peaty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
549 CVPZ  RN  Clay, gravelly, peaty, silty [Unlithified Deposits Coding Scheme]  Silty peaty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
550 CVS  RN  Clay, gravelly, sandy [Unlithified Deposits Coding Scheme]  Sandy gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
551 CVSB  RN  Clay, gravelly, sandy, bouldery [Unlithified Deposits Coding Scheme]  Bouldery sandy gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
552 CVSH  RN  Clay, gravelly, sandy, shelly [Unlithified Deposits Coding Scheme - Extended]  Shelly sandy gravelly clay [UDCS-X]  TMCM  28-MAY-20     
553 CVSL  RN  Clay, gravelly, sandy, cobbly [Unlithified Deposits Coding Scheme]  Cobbly sandy gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
554 CVSLB  RN  Clay, gravelly, sandy, cobbly, bouldery [Unlithified Deposits Coding Scheme]  Bouldery cobbly sandy gravelly clay [UDCS]  DJLO  20-FEB-09  TMCM  30-AUG-18 
555 CVSZ  RN  Clay, gravelly, sandy, silty [Unlithified Deposits Coding Scheme]  Silty sandy gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
556 CVZ  RN  Clay, gravelly, silty [Unlithified Deposits Coding Scheme]  Silty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   
557 CVZP  RN  Clay, gravelly, silty, peaty [Unlithified Deposits Coding Scheme]  Peaty silty gravelly clay [UDCS]  KAH  10-DEC-02  TMCM  30-AUG-18   

Go to the start - rows 1 to 20 of 3677 Go to the previous page - rows 518 to 537 of 3677 Displaying rows 538 to 557 of 3677 Go to the next page - rows 558 to 577 of 3677 Go to the end - rows 3658 to 3677 of 3677