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