Vocabularies — details

DIC_DENS_COMP_STR_5930

A dictionary of rock density/compaction/strength using the BS5930 scheme.

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


Sample data (rows 1 to 20 of 23)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
LSV  VERY LOOSE. USED WHERE RELATIVE DENSITY DETERMINED BY SPT, N-VALUES 0 TO 4  C  BS5930 SPT: Very Loose (N 0-4)  5  04-JUN-03  04-JUL-03 
LS  LOOSE. USED WHERE RELATIVE DENSITY DETERMINED BY SPT, N-VALUES 4 TO 10  C  BS5930 SPT: Loose (N 4-10)  10  04-JUN-03  04-JUL-03 
DENM  MEDIUM DENSE. USED WHERE RELATIVE DENSITY DETERMINED BY SPT, N-VALUES 10 TO 30  C  BS5930 SPT: Medium Dense (N 10-30)  15  04-JUN-03  04-JUL-03 
DEN  DENSE. USED WHERE RELATIVE DENSITY DETERMINED BY SPT, N-VALUES 30 TO 50  C  BS5930 SPT: Dense (N 30-50)  20  04-JUN-03  04-JUL-03 
DENV  VERY DENSE. USED WHERE RELATIVE DENSITY DETERMINED BY SPT, N-VALUES > 50  C  BS5930 SPT: Very Dense (N >50)  25  04-JUN-03  04-JUL-03 
UCOM  UNCOMPACT. USED FOR SILT. EASILY MOULDED OR CRUSHED IN THE FINGERS  C  BS5930 Silt: Uncompact  30  04-JUN-03   
COM  COMPACT. USED FOR SILT. CAN BE MOULDED OR CRUSHED BY STRONG PRESSURE FROM THE FINGERS  C  BS5930 Silt: Compact  35  04-JUN-03   
SFTV  VERY SOFT. USED FOR CLAY. FINGER EASILY PUSHED IN TO 25 MM  C  BS5930 Clay: Very Soft  40  04-JUN-03   
SFT  SOFT. USED FOR CLAY. FINGER PUSHED IN ;UP TO 10 MM  C  BS5930 Clay: Soft  45  04-JUN-03   
FRM  FIRM. USED FOR CLAY. THUMB MAKES IMPRESSION EASILY  C  BS5930 Clay: Firm  50  04-JUN-03   
STI  STIFF. USED FOR CLAY. CAN BE INDENTED SLIGHTLY BY THUMB  C  BS5930 Clay: Stiff  55  04-JUN-03   
STIV  VERY STIFF. USED FOR CLAY. CAN BE INDENTED BY THUMB NAIL  C  BS5930 Clay: Very Stiff  60  04-JUN-03   
HD  HARD (OR VERY WEAK MUDSTONE). USED FOR CLAY. CAN BE SCRATCHED BY THUMB NAIL  C  BS5930 Clay: Hard (Or Very Weak Mudstone)  65  04-JUN-03   
WKV  VERY WEAK. USED FOR ROCK. GRAVEL SIZE LUMPS CAN BE CRUSHED BETWEEN FINGER AND THUMB  C  BS5930 Rock: Very Weak  70  04-JUN-03   
WK  WEAK. USED FOR ROCK. GRAVEL SIZE LUMPS CAN BE BROKEN IN HALF BY HEAVY HAND PRESSURE  C  BS5930 Rock: Weak  75  04-JUN-03   
WKM  MODERATELY WEAK. USED FOR ROCK. ONLY THIN SLABS, CORNERS OR EDGES CAN BE BROKEN OFF WITH HEAVY HAND PRESSURE  C  BS5930 Rock: Moderately Weak  80  04-JUN-03   
STRM  MODERATELY STRONG. USED FOR ROCK. WHEN HELD IN THE HAND, ROCK CAN BE BROKEN BY HAMMER BLOWS  C  BS5930 Rock: Moderately Strong  85  04-JUN-03   
STR  STRONG. USED FOR ROCK. WHEN RESTING ON A SOLID SURFACE, ROCK CAN BE BROKEN BY HAMMER BLOWS  C  BS5930 Rock: Strong  90  04-JUN-03   
STRV  VERY STRONG. USED FOR ROCK. ROCK CHIPPED BY HEAVY HAMMER BLOWS  C  BS5930 Rock: Very Strong  95  04-JUN-03   
STRE  EXTREMELY STRONG. USED FOR ROCK. ROCK RINGS ON HAMMER BLOWS. ONLY BROKEN BY SLEDGE HAMMER  C  BS5930 Rock: Extremely Strong  100  04-JUN-03