|
<< Click to Display Table of Contents >> Navigation: Geotech > Functions > Geotechnical Function – EQUIS.GEOTECH_DMT_DATA |
The EQUIS.GEOTECH_DMT_DATA function queries the raw Dilatometer Test (DMT) data parameters stored in the DT_DOWNHOLE_POINT_DATA and DT_LOCATION_PARAMETER tables to calculate correlated DMT parameters.
The EQUIS.GEOTECH_DMT_DATA function creates a function report called Geotechnical DMT Data. It is also used in the Geotechnical DMT Parameters Export report.
The function calculates the parameters based on the unit defined in DT_TASK_PARAMETER.PARAM_VALUE for DT_TASK_PARAMETER.PARAM_CODE = ‘cpt_output_unit’. The PARAM_VALUE must be either ‘E’ for English, or ‘M’ for Metric. If the value is empty, then the function will calculate the results in English units. The function checks the PARAM_UNIT associated with the raw CPT parameter and converts the values accordingly. Please note that the function only supports converting values if the stored units are MPa, KPa, or TSF.
Note: The function only supports one record for DT_TASK_PARAMETER.PARAM_CODE = ‘cpt_output_unit’ per facility. |
|---|
The ‘pressure_unit’ field included in the output applies to all reported fields that have ‘TSF/MPa’ listed in the Unit column in function output table provided later in the article. The ‘unit_weight_unit’ field applies to the ‘unit_weight’ field included in the output.
The DMT location must have an associated water depth value (DT_WATER_TABLE.DEPTH where DT_WATER_TABLE.TYPE = ‘DMT’). In addition, the function requires the following values to be present in the database for the calculations to occur:
•Depth (DT_DOWNHOLE_POINT_DATA.DEPTH)
•Delta A Average (DT_LOCATION_PARAMETER.PARAM_CODE = ‘delta_a_average’).
•Delta B Average (DT_LOCATION_PARAMETER.PARAM_CODE = ‘delta_b_average’).
•ZM Average (DT_LOCATION_PARAMETER.PARAM_CODE = ‘zm_average’).
•A (DT_DOWNHOLE_POINT_DATA.PARAM_CODE = ‘dmt_a’).
•B (DT_DOWNHOLE_POINT_DATA.PARAM_CODE = ‘dmt_b’).
Note: The function always expects the calibration data (Delta A, Delta B, and Zm) to be stored in bar units. It is not checking the PARAM_UNIT associated with the parameters. |
|---|
The following table lists the DMT parameters that the EQUIS.GEOTECH_DMT_DATA function outputs, including function field name, associated unit, and equation used (when applicable).
Field |
Function |
Unit |
Equation (if applicable) |
|---|---|---|---|
A |
a |
TSF/MPa |
|
B |
b |
TSF/MPa |
|
C |
c |
TSF/MPa |
|
Corrected First Reading, p0 |
p0 |
TSF/MPa |
|
Corrected Second Reading, p1 |
p1 |
TSF/MPa |
|
Corrected Reading, p2 |
p2 |
TSF/MPa |
|
Equilibrium Pore Pressure, u0 |
u0 |
TSF/MPa |
|
Total Stress, σV0 |
total_stress |
TSF/MPa |
|
Effective Stress, |
eff_stress |
TSF/MPa |
|
Material Index, ID |
id |
|
|
Dilatometer Modulus, ED |
ed |
TSF/MPa |
|
RM |
rm |
|
If Kd > 10
If ID ≤ 0.6
If ID ≥ 3
If 0.6 < ID < 3
where
If RM > 0.85
|
Vertical Drained Constrained Modulus, M |
m |
TSF/MPa |
|
Coefficient Earth Pressure In Situ, K0 |
k0 |
|
for ID < 1.2 |
Horizontal Stress Index, KD |
kd |
|
|
Over Consolidation Ratio 1, |
ocr_1 |
|
|
Over Consolidation Ratio 2, |
ocr_2 |
|
for ID < 1.2 |
Effective Friction Angle (1) |
eff_friction_angle1 |
|
|
Unit Weight |
unit_weight |
pcf/kgm3 |
|
Undrained Shear Strength, Su |
su |
TSF/MPa |
for ID < 1.2 |
ID SBT |
id_sbt |
|
ID< 0.1 then IDSBT = 1 ID< 0.35 then IDSBT = 2 ID< 0.6 then IDSBT = 3 ID< 0.9 then IDSBT = 4 ID< 1.2 then IDSBT = 5 ID< 1.8 then IDSBT = 6 ID< 3.3 then IDSBT = 7 Else ID then IDSBT = 8 |
Copyright © 2024 EarthSoft, Inc. • Modified: 06 Sep 2023