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 10 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