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 20 of 29)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
SOIL: BOULDERS (> ABOUT 200 MM)  BS5930 Boulders (> c. 200 mm)  04-JUN-03   
SOIL: COBBLES (ABOUT 60 TO 200 MM)  BS5930 Cobbles (c. 60 to 200 mm)  10  04-JUN-03   
GR  SOIL: GRAVEL (ABOUT 2 TO 60 MM)  BS5930 Gravel (c. 2 to 60 mm)  15  04-JUN-03   
GRC  SOIL: COARSE GRAVEL (ABOUT 20 TO 60 MM)  BS5930 Coarse Gravel (c. 20 to 60 mm)  20  04-JUN-03   
GRM  SOIL: MEDIUM GRAVEL (ABOUT 6 TO 20 MM)  BS5930 Medium Gravel (c. 6 to 20 mm)  25  04-JUN-03   
GRF  SOIL: FINE GRAVEL (ABOUT 2 TO 6 MM)  BS5930 Fine Gravel (c. 2 to 6 mm)  30  04-JUN-03   
SA  SOIL: SAND (ABOUT 0.06 TO 2 MM)  BS5930 Sand (c. 0.06 to 2 mm)  35  04-JUN-03   
SAC  SOIL: COARSE SAND (ABOUT 0.6 TO 2 MM)  BS5930 Coarse Sand (c. 0.6 to 2 mm)  40  04-JUN-03   
SAM  SOIL: MEDIUM SAND (ABOUT 0.2 TO 0.6 MM)  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)  BS5930 Fine Sand (c. 0.06 to 0.2 mm)  50  04-JUN-03   
SI  SOIL: SILT (ABOUT 0.002 TO 0.06 MM)  BS5930 Silt (c. 0.002 to 0.06 mm)  55  04-JUN-03   
SIC  SOIL: COARSE SILT (ABOUT 0.02 TO 0.06 MM)  BS5930 Coarse Silt (c. 0.02 to 0.06 mm)  60  04-JUN-03   
SIM  SOIL: MEDIUM SILT (ABOUT 0.006 TO 0.02 MM)  BS5930 Medium Silt (c. 0.006 to 0.02 mm)  65  04-JUN-03   
SIF  SOIL: FINE SILT (ABOUT 0.002 TO 0.006 MM)  BS5930 Fine Silt (c. 0.002 to 0.006 mm)  70  04-JUN-03   
CLSI  SOIL: CLAY / SILT (ABOUT 0.002 MM)  BS5930 Clay / Silt (c. 0.002 mm)  75  04-JUN-03   
CL  SOIL: CLAY (< ABOUT 0.002 MM)  BS5930 Clay (< c. 0.002 mm)  80  04-JUN-03   
RUD  BEDDED ROCK: RUDACEOUS (> ABOUT 2 MM)  BS5930 Rudaceous Rock (> c. 2 mm)  85  04-JUN-03   
AREN  BEDDED ROCK: ARENACEOUS (ABOUT 0.06 TO 2 MM)  BS5930 Arenaceous Rock (c. 0.06 to 2 mm)  90  04-JUN-03   
ARENC  BEDDED ROCK: COARSE ARENACEOUS (ABOUT 0.6 TO 2 MM)  BS5930 Coarse Arenaceous Rock (c. 0.6 to 2 mm)  95  04-JUN-03   
ARENM  BEDDED ROCK: MEDIUM ARENACEOUS (ABOUT 0.2 TO 0.6 MM)  BS5930 Medium Arenaceous Rock (c. 0.2 to 0.6 mm)  100  04-JUN-03