Project Tables

Overview

The test and interpreted data tables are stored in the project database. 

A number of constants and assumptions are required in derivations. Many may be set as follows:

  • At a project level on Project_Parameters and Project_Correlation_Parameters
  • For each PointID on Point_Parameters and Point_Correlation_Parameters
  • By depth for a PointID on Point_Material_Properties
  • Some may be set for each push (on CPT_Data – Upper).

This provided you with full control over which level in the hierarchy to use.

Main Group

POINT

When an Elevation is changed the Tool will calculate. The PointID and HoleDepth fields must be defined.

CPT

CPT Data – Upper (CPT_GENERAL)

This table defines each CPT stroke within a PointID, since under some circumstances multiple CPT strokes take place in the same hole. Each stroke has a unique Test Number.

CPT Data – Lower (CPT_DATA)

This table stores the actual raw depth related data for each push and derived results related to each reading.

CPT Correlation - (CPT_DATA_CORRELATION)

One-to-one child of CPT_DATA which stores the derived results related to each reading.


Cone Information - Upper (CPT_CONE_INFORMATION)

The cone and equipment constants are stored on this table. For example, two important constants are the Cone_Area_Ratio and Cone_Sleeve_Offset.

Cone Information - Lower (CPT_CONE_CALIBRATION)

This table can be used to record the calibration dates for each cone.

Lower best Upper Correlations (CPT_DATA_LOWER_BEST_UPPER)

This table is a one-to-one child of CPT_DATA, and stores a selection of correlations with results for Lower Bound, Best Estimate and Upper Bound.

Dissipation Test (CPT_DISSIPATION_TEST_GENERAL and CPT_DISSIPATION_TEST_READINGS)

These tables store the Dissipation Test raw and derived data.

Enviro Data (CPT_DATA_ENVIRONMENTAL)

This table is a one-to-one child of CPT_DATA, and stores environmental and some geophysics related results.

BPT Data (CPT_BPT_GENERAL & CPT_BPT_DATA)

Spherical Ball Penetrometer Data is stored on these tables. In future versions correlations will be added.

Point Correlation Summary (CPT_POINT_CORRELATION_SUMMARY)

This table is populated by the Correlation Summary command / functionality.

Correlation Summary (CPT_STROKE_CORRELATION_SUMMARY)

This table was added to support AGS 4 Format. Currently users must manually enter summary data in this table

Measured CPT Data (Measured_CPT_Data)

Currently users must manually enter summary data in this table.

Thermal Conductivity - Upper (CPT_THERMAL_CONDUCTIVITY_GENERAL)

This table stores the information related to the Thermal Conductivity tests.

Thermal Conductivity - Lower (CPT_THERMAL_CONDUCTIVITY_GENERAL)

This table stores the readings of each Thermal Conductivity test.

Specification – Upper (CPT_POINT_SPECIFICATION)

The calculated result of the Specification Add-In for PointIDs is stored in this table.

Specification – Lower (CPT_POINT_SPECIFICATION_DETAIL)

This table stores the result for each detail expression.

CPT-Liquefaction

Liquefaction Data (CPT_LIQUEFACTION_DATA)

One-to-one child of CPT_DATA which stores liquefaction related correlation results.

Liquefaction Point Parameters (CPT_LIQUEFACTION_POINT_PARAMETERS)

Stores point level parameters for liquefaction correlation calculations.

Liquefaction Project Parameters (CPT_LIQUEFACTION_PROJECT_PARAMETERS)

Stores project level parameters for liquefaction correlation calculations.

CPT-Foundation

Foundation Data (CPT_DATA_FOUNDATION)

One-to-one child of CPT_DATA which stores pile capacity and shallow foundation correlation results.

Foundation Point Parameters – Upper (CPT_FOUNDATION_POINT_PARAMETERS)

Point level parameters used by foundation calculations.

Foundation Point Parameters – Lower (CPT_FOUNDATION_POINT_PARAMETERS_PROFILE)

Depth profile of material type used by pile capacity calculation.

Foundation Project Parameters (CPT_FOUNDATION_PROJECT_PARAMETERS)

Project level parameters used by foundation calculations.

CPT-Configuration

Point Parameters (CPT_POINT_PARAMETERS)

This table stores the Point level constants and assumption values related to derived parameters and soil behaviour type calculations. Hence if you wish to set the groundwater depth for all strokes for a PointID then that value should be entered into the Groundwater_Depth field on the CPT_POINT_PARAMETERS Table.

Point Correlation Parameters - Upper (CPT_POINT_CORRELATION_PARAMETERS)

Point level constants for correlations are stored in this table.

Point Correlation Parameters - Lower (CPT_POINT_MATERIAL_PROPERTIES)

A bulk unit weight, u_o, e, N_k, N_{kt}, S_u \text{ } LBS_u \text{ } BE, S_u \text{ } UB, FC depth profile may be defined for each PointID on the CPT_POINT_MATERIAL_PROPERTIES table. The depth ranges for a particular PointID must not overlap in any way. You will not be able to save the table if overlapping depth ranges are entered.

Project Parameters (CPT_PROJECT_PARAMETERS)

Project level constants and parameters related to derived parameter and soil behaviour type calculations are stored on this table.

Project Correlation Parameters (CPT_PROJECT_CORRELATION_PARAMETERS)

Project level correlation parameters and constants are stored on this table.

Project Output Options (CPT_PROJECT_OUTPUT_OPTIONS)

This table stores the project level report output options.

Point Symbology (CPT_POINT_SYMBOLOGY)

This table stores Point level overrides for the settings on CPT_PROJECT_SYMBOLOGY and DG_CPT_SYMBOLOGY.

Project Symbology (CPT_PROJECT_SYMBOLOGY)

This table stores Project level overrides for the settings on DG_CPT_SYMBOLOGY. You can set scales, line types etc. for each parameter here for the entire project.

Soil Class Method (CPT_SOIL_CLASS_METHOD)

Definition of project specific Soil Behaviour Type methods.

Soil Class Zones (CPT_SOIL_CLASS_ZONES and CPT_SOIL_CLASS_DATA)

Definition of project specific Soil Behaviour Type zones and polygon data.

Formula Configuration (CPT_FORMULA_CONFIGURATION)

This is a hidden table, and stores Project level formulas.

Data Correction Configuration (CPT_DATA_CORRECTION_FORMULA_CONFIG)

This is a hidden table and stores Project level Data Correction formulas.

CPT Box (CPT_BOX_CONFIGURATION and CPT_BOX_POINTS)

The CPT Box tables store both the results of the calculations and the coordinates of the CPT Boxes

CPT BOX Configuration

The CPT Box Configuration table stores the information related to the MIF Coordinate System.

CPT BOX Bottom Layer

This table stores the Minimum_Thickness and Maximum_Thickness of layers and set up an output features.

CPT Box Brush Pattern

The table stores a custom list of Name and the Brush Patterns.

Lab-Strength/Consol

Pocket Penetrometer and Lab Vane results (LAB_POCKET_PENETROMETER and LAB_VANE)

The table stores the laboratory vane and pocket penetrometer test results to be printed in graphs and logs.

Triaxial Test Results (LAB_SOIL_TRIAXIAL_TOTAL and LAB_SOIL_TRIAXIAL_STRESS)

The tables store the Triaxial test results to be printed in graphs and logs.

 



IS-BH

In Situ Tests (VANE_PP_TV)

The table stores the in situ vane and pocket penetrometer test results to be printed in graphs and logs.

Analysis

Design Line (DESIGN_LINE and DESIGN_LINE_DATA)

These tables define the design line for Cone Resistance and all correlations. In the case of Cone Resistance the data is written to the CPT_ Data table, and can display on log and fence reports. For correlations the data is optionally displayed on Graph reports, and not written to CPT_Data. You can assign the Design Line to use on the Project_Parameter and Point_Parameter tables.

Specification (SPECIFICATION and SPECIFICATION_CPT)

These tables define the specification analysis. The results are written to CPT_Specification and CPT_Point_Specification_Detail tables. You can assign the Specification material to use on the Project_Parameter and Point_Parameter tables.

Options

Project Options (PROJECT_OPTIONS)

Options in a Project Level.

Point options (POINT_OPTIONS)

Options in Point Level.


On this page