EQuIS Geotech Functions

EQuIS Geotech uses database functions to facilitate reporting and to generate graphics using EnviroInsite templates (e.g., boring logs, subsurface profile).

Geotechnical Database Functions

The following geotechnical database functions are installed when the Geotech Schema (schema.geotech.xme) is applied to the database.

•EQUIS.GEOTECH_CPT_DATA – Queries the raw Cone Penetration Test (CPT) data parameters stored in the DT_DOWNHOLE_POINT_DATA table to calculate several correlated CPT parameters.

•EQUIS.GEOTECH_CPT_DISSIPATION_DATA – Queries the results of a CPT Dissipation test to calculate the pore pressure and normalized excess pore pressure results.

•EQUIS.GEOTECH_CPT_ROD_BREAK – Identifies apparent rod breaks that occurred during CPT activities based on sleeve resistance measurements.

•EQUIS.GEOTECH_DMT_DATA – 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.

•EQUIS.GEOTECH_IC_QTN – Calculates the Normalized Cone Resistance (Qtn) and Soil Behavior Type Index (Ic) parameters by using the iterative stress exponent method.

•EQUIS.GEOTECH_LAB_ASSIGN_SAMPLES – Provides a summary of the lab tests assigned to samples within a facility.

•EQUIS.GEOTECH_NSBT – Determines the Normalized Soil Behavior Type (SBTn) parameter.

•EQUIS.GEOTECH_UNCONF_COMP – Queries Unconfined Compression test details from the DT_GEO_RESULT and DT_GEO_TEST_PARAMETER tables, where DT_GEO_TEST.TEST_TYPE = ‘Unconf_Compression’. Based on the parameters present, the function calculates other result values.

•EQUIS.GEOTECH_UNCONF_COMP_READINGS – Queries the Unconfined Compression test reading parameters stored in the DT_GEO_RESULT and DT_GEO_TEST_PARAMETER tables, where DT_GEO_TEST.TEST_TYPE = ‘Unconf_Compression’ and ‘UnconfComp_Readings’. Based on the available data, the function calculates other result values.

•EQUIS.GEOTECH_UNCONSOL_UNDRAIN – Queries the WATER_CONTENT, DRY_DENSITY, WET_DENSITY, STRAIN_RATE, and other sample test information from the DT_GEO_RESULT and DT_GEO_TEST_PARAMETER tables. Based on the presence of the parameters listed above, the following parameters are calculated: strength, strain at failure, saturation, void ratio, undrained shear strength, and the height diameter ratio. This function also returns the appropriate image file.

•EQUIS.GEOTECH_UNCONSOL_UNDRAIN_READINGS – Follows two methods of calculating the stress and strain values based on the way data were submitted to the database.

EnviroInsite Database Functions

EnviroInsite templates support the plotting of database functions in Boring Logs or Subsurface Profiles. Functions with names starting with “ei_” will be available in the Functions tab in the right pane of the Template Design window.

The EnviroInsite database functions provided with EQuIS Geotech are installed when the Geotech Schema (schema.geotech.xme) is applied to the database and are intended only for geotechnical data and related reports. These database functions are grouped as:

•Downhole data functions

•Downhole graphic functions

•Header/footer data functions (scalar functions)

•Header/footer graphic functions