Overview

This section lists library tables that are important to calculation of the CPT Tool and reports.

DG_COM_UNIT_CONVERSION

This table contains a list of the units, conversion factors and equations, and is referenced to convert values from one unit to another throughout the CPT Tool.

DG_CPT_AUTO_FILTER

This table is a simple lookup for the filter options.

DG_CPT_CORRELATION_SUMMARY_CONFIG

This table stores Library level data for the correlation summary function.

DG_CPT_DATA_CORRECTION_FORMULA_CONFIG

This table stores Library level data correction formulas.

DG_CPT_DEPTH_ELEVATION_SCALE

Attribute table used by log reports.

DG_CPT_FENCE_BLOCK

Lookup and attribute table used by fence reports.

DG_CPT_FIELD_MAP

Stores the table and field name configuration used by the CPT Tool calculation. This allows you to set non-standard field and table names. If a parameter is missing the DGD name is used as default.

This table also stores units, field rules and default values used for Unit Conversion for each unit system.

It allows users to link user created project tables to the CPT Tool, such that when data is changes on user defined table the CPT calculation can be prompted.

DG_CPT_FORMULA_CONFIGURATION

These table stores Library level formulas for the Formula Tool.

DG_CPT_LOG_BLOCK

Lookup and attribute table used by dynamic log reports.

DG_CPT_MEASUREMENT_SYSTEM

This table is a simple lookup for the measurement system type options, based on the GEF standard.

DG_CPT_MODIFIED_TIME_FACTOR

Used for dissipation analysis.

DG_CPT_PILE_AXIAL_CAPACITY_LCPC_BEARING

Used for pile axial capacity calculations.

DG_CPT_PILE_AXIAL_CAPACITY_LCPC_FRICTION

Used for pile axial capacity calculations.

DG_CPT_PILE_AXIAL_CAPACITY_LCPC_SOIL

Used for pile axial capacity calculations.

DG_CPT_PORE_PRESSURE_FILTER_POSITION

Used for dissipation analysis.

DG_CPT_SCALE_TYPE

This table is a simple lookup for the soil classification graph type options.

DG_CPT_SOIL_CLASS_DATA

This table stores the soil classification polygon data. Users can add their own classification methods.

DG_CPT_SOIL_CLASS_METHOD

This table stores the names and graphing options for each soil classification method.

DG_CPT_SOIL_CLASS_ZONES

This table stores the descriptions and graphics for each soil classification zone.

DG_CPT_SOIL_TYPE

This table is a simple lookup for the soil type options.

DG_CPT_SYMBOLOGY

This table stores the library defaults for line colour and types etc. The field references are used by reports and should not be altered.

DG_CPT_SYMBOLOGY_SCALES_UNITS

Stores parameter scales for each Unit System.

DG_CPT_TERMINATION

This table is a simple lookup of reasons for terminating a CPT stroke, based on the GEF standard.

DG_CPT_TEST_METHOD

List of test standards.

DG_CPT_TRANSFER_SUMMARY_DESC_CONSISTENCY

This table stores the target table and field names soil description and consistency data summary transfer.

DG_CPT_TYPE

List of AGS Format CPT Types.

DG_CPT_ZERO_LOCATION

This table is a simple lookup for zero location.

DG_IMPORT_USER_IMPORT_PARAMETERS

Stores user import parameters for the Import Tool.

DG_LOG_SOIL_STRENGTH

This table stores the soil consistency and relative density terms and ranges. These are used to calculate the fields Relative_Density_Term_# and Undrained_Shear_Strength_Term_# on CPT_DATA table.

PROJECT_OPTION.Classification_Standard defines which set of terms are used in this project.