Vocabularies — details

DIC_GRAIN_SIZE_5930

A dictionary of grain size using the BS5930 scheme.

No. Column name Data type Notes
1 CODE Varchar(5) Primary key
2 DESCRIPTION Varchar(60)  
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 29)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
B  SOIL: BOULDERS (> ABOUT 200 MM)  C  BS5930 Boulders (> c. 200 mm)  5  04-JUN-03   
C  SOIL: COBBLES (ABOUT 60 TO 200 MM)  C  BS5930 Cobbles (c. 60 to 200 mm)  10  04-JUN-03   
GR  SOIL: GRAVEL (ABOUT 2 TO 60 MM)  C  BS5930 Gravel (c. 2 to 60 mm)  15  04-JUN-03   
GRC  SOIL: COARSE GRAVEL (ABOUT 20 TO 60 MM)  C  BS5930 Coarse Gravel (c. 20 to 60 mm)  20  04-JUN-03   
GRM  SOIL: MEDIUM GRAVEL (ABOUT 6 TO 20 MM)  C  BS5930 Medium Gravel (c. 6 to 20 mm)  25  04-JUN-03   
GRF  SOIL: FINE GRAVEL (ABOUT 2 TO 6 MM)  C  BS5930 Fine Gravel (c. 2 to 6 mm)  30  04-JUN-03   
SA  SOIL: SAND (ABOUT 0.06 TO 2 MM)  C  BS5930 Sand (c. 0.06 to 2 mm)  35  04-JUN-03   
SAC  SOIL: COARSE SAND (ABOUT 0.6 TO 2 MM)  C  BS5930 Coarse Sand (c. 0.6 to 2 mm)  40  04-JUN-03   
SAM  SOIL: MEDIUM SAND (ABOUT 0.2 TO 0.6 MM)  C  BS5930 Medium Sand (c. 0.2 to 0.6 mm)  45  04-JUN-03   
SAF  SOIL: FINE SAND (ABOUT 0.06 TO 0.2 MM)  C  BS5930 Fine Sand (c. 0.06 to 0.2 mm)  50  04-JUN-03