Vocabularies — details

DIC_GRAIN_SIZE_BGS

Dictionary of grain size using the BGS RCS modified Wentworth scheme.

No. Column name Data type Notes
1 CODE Varchar(5) Primary key
2 DESCRIPTION Varchar(100)  
3 STATUS Char(1)  
4 TRANSLATION Varchar(60)  
5 ORDER_CTRL Numeric(22)  
6 DATE_ENTERED Date  
7 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 27)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
GR  SEDIMENTARY CLASTS: GRAVEL (> 2 MM, < -1 PHI)  C  BGS Gravel (> 2 mm, < -1 phi)  5  04-JUN-03   
GRB  SEDIMENTARY CLASTS: BOULDERS (> 256 MM, < -8 PHI)  C  BGS Boulders (> 256 mm, < -8 phi)  10  04-JUN-03   
GRC  SEDIMENTARY CLASTS: COBBLES (64 TO 256 MM, -6 TO -8 PHI)  C  BGS Cobbles (64 to 256 mm, -6 to -8 phi)  15  04-JUN-03   
GRP  SEDIMENTARY CLASTS: PEBBLES (4 TO 64 MM, -2 TO -6 PHI)  C  BGS Pebbles (4 to 64 mm, -2 to -6 phi)  20  04-JUN-03   
GRG  SEDIMENTARY CLASTS: GRANULES (2 TO 4 MM, -1 TO -2 PHI)  C  BGS Granules (2 to 4 mm, -1 to -2 phi)  25  04-JUN-03   
SA  SEDIMENTARY CLASTS: SAND (0.032 TO 2 MM, -1 TO +5 PHI)  C  BGS Sand (0.032 to 2 mm, -1 to +5 phi)  30  04-JUN-03   
SAVC  SEDIMENTARY CLASTS: VERY-COARSE-SAND (1 TO 2 MM, 0 TO -1 PHI)  C  BGS Very-Coarse-Sand (1 to 2 mm, 0 to -1 phi)  35  04-JUN-03   
SAC  SEDIMENTARY CLASTS: COARSE-SAND (0.5 TO 1 MM, 0 TO +1 PHI)  C  BGS Coarse-Sand (0.5 to 1 mm, 0 to +1 phi)  40  04-JUN-03   
SAM  SEDIMENTARY CLASTS: MEDIUM-SAND (0.25 TO 0.5 MM, +1 TO +2 PHI)  C  BGS Medium-Sand (0.25 to 0.5 mm, +1 to +2 phi)  45  04-JUN-03   
SAF  SEDIMENTARY CLASTS: FINE-SAND (0.125 TO 0.25 MM, +2 TO +3 PHI)  C  BGS Fine-Sand (0.125 to 0.25 mm, +2 to +3 phi)  50  04-JUN-03   
SAVF  SEDIMENTARY CLASTS: VERY-FINE-SAND (0.032 TO 0.125 MM, +3 TO +5 PHI)  C  BGS Very-Fine-Sand (0.032 to 0.125 mm, +3 to +5 phi)  55  04-JUN-03   
MU  SEDIMENTARY CLASTS: MUD (< 0.032 MM, > +5 PHI)  C  BGS Mud (< 0.032 mm, > +5 phi)  60  04-JUN-03   
MUSI  SEDIMENTARY CLASTS: SILT (0.004 TO 0.032 MM, +5 TO +8 PHI)  C  BGS Silt (0.004 to 0.032 mm, +5 to +8 phi)  65  04-JUN-03   
MUCL  SEDIMENTARY CLASTS: CLAY (< 0.004 MM, > +8 PHI)  C  BGS Clay (< 0.004 mm, > +8 phi)  70  04-JUN-03   
BVOL  VOLCANICLASTIC FRAGMENTS: BLOCKS AND BOMBS (> 64 MM, < -6 PHI)  C  BGS Blocks And Bombs (> 64 mm, < -6 phi)  75  04-JUN-03   
LVOL  VOLCANICLASTIC FRAGMENTS: LAPILLI (2 TO 64 MM, -1 TO -6 PHI)  C  BGS Lapilli (2 to 64 mm, -1 to -6 phi)  80  04-JUN-03   
CVOL  VOLCANICLASTIC FRAGMENTS: COARSE-ASH-GRAINS (0.032 TO 2 MM, -1 TO +5 PHI)  C  BGS Coarse-Ash-Grains (0.032 to 2 mm, -1 to +5 phi)  85  04-JUN-03   
FVOL  VOLCANICLASTIC FRAGMENTS: FINE-ASH-GRAINS (< 0.032 MM, > +5 PHI)  C  BGS Fine-Ash-Grains (< 0.032 mm, > +5 phi)  90  04-JUN-03   
VCG  CRYSTALLINE ROCKS: VERY-COARSE-CRYSTALLINE (> 16 MM, < -4 PHI)  C  BGS Very-Coarse-Crystalline (> 16 mm, < -4 phi)  95  04-JUN-03   
CG  CRYSTALLINE ROCKS: COARSE-CRYSTALLINE (2 TO 16 MM, -1 TO -4 PHI)  C  BGS Coarse-Crystalline (2 to 16 mm, -1 to -4 phi)  100  04-JUN-03