Geotechnical_v2 Format

<< Click to Display Table of Contents >>

Navigation:  Geotech > Formats >

Geotechnical_v2 Format

Format Name: Geotechnical_v2

File Name: Geotechnical_v2.zip

Dependencies: Licensed EQuIS Geotech and Geotechnical Schema

Source: Available on the EarthSoft Community Center Downloads Dashboard > Products > EQuIS Geotech

 

Description: The Geotechnical_v2 format is designed to upload geotechnical data to the appropriate EQuIS database tables.

 

Installation Instructions: Download the Geotechnical_v2 format from the EarthSoft Community Center and unblock the *.zip file.  

 

Overview: The Geotechnical_v2 format includes sections to update facility information, location data, boring and drilling information, well data, geological descriptions, insitu testing, CPT, lab testing, and gINT specific parameters.

 

 

Note: Before using the Geotechnical_v2 format, users should ensure the appropriate reference values are loaded.  Please use the Geotech_Refvals format and associated Geotech_Refvals_EDD.xlsx file to add the necessary reference values. More information is available Geotech_Refvals Format article.

 

 

Format Section

EQuIS Table(s)

Purpose

Facility

DT_FACILITY

AT_FACILITY

Describes the facility and their parameters, such as addresses and project managers.

Facility_Parameter

DT_FACILITY_PARAMETER

Describes facility parameters.

Project_Task

DT_TASK

DT_TASK_PARAMETER

Describes project information within a facility.

Task_Parameter

DT_TASK_PARAMETER

Describes project parameters.

Location_Data

DT_LOCATION

AT_LOCATION

DT_LOCATION_PARAMETER

Describes locations within a facility, and includes information such as location code, depth to bedrock, drilling method, location type, etc.

Location_Parmeter

DT_LOCATION_PARAMETER

Describes location parameters.

Drill_Activity

DT_DRILL_ACTIVITY

Describes general information pertaining to the drilling activities resulting from the soil boring.

Drill_Parameter

DT_DRILL_PARAMETER

Describes drill activity parameters.

Test_Pit

DT_EXCAVATION

DT_LOCATION_PARAMETER

Describes excavations at specific locations in order to study or sample the composition and structure of the subsurface.

Traverse_Details

DT_GEO_TRAVERSE

Describes a traverse, including location, slope, and orientation.

Equipment

DT_EQUIPMENT

Describes equipment information.

Equipment_Parameter

DT_EQUIPMENT_PARAMETER

Describes equipment parameters.

Hole_Survey

DT_GEO_HOLE_SURVEY

DT_GEO_HOLE_SURVEY_RESULT

Describes data collected when a hole is surveyed. Stores information about the survey event including the company, technician, and date.

Rock_Field_Data

DT_GEO_ROCK_FIELD

Describes geotechnical parameters used to rank rock mass quality.

Water_Level

DT_WATER_LEVEL

Describes water level information.

Major_Structures

DT_GEO_MAJOR_STRUCTURE

Describes major structure information.

Well_Development

DT_WELL_DEVELOPMENT

Describes development of a well.

Aquifer_Test

DT_AQUIFER_TEST

Describes data regarding tests performed on specific aquifers.

Aquifer_Test_Parameter

DT_AQUIFER_TEST_PARAMETER

Describes additional parameters associated with pumping tests.

Hydrogeo_Parameter

DT_HYDRO_PAR

Describes hydrogeologic parameter information of specific locations, such as sampling zone or test date.

Flow

DT_FLOW

Describes flow.

Coring

DT_GEO_CORING

Describes coring information related to rock and soil material.

Field_Sample

DT_SAMPLE

DT_FIELD_SAMPLE

DT_SAMPLE_PARAMETER

DT_STATIC_PROPS

DT_SDG

Describes data for samples collected at a site and location.

Sample_Parameter

DT_SAMPLE_PARAMETER

Describe sample parameters.

Casing

DT_WELL_SEGMENT

Describes casing information associated with drilling a well.

Depth_Remarks

DT_NOTE

Describes depth related notes and observations during drilling process.

Water_Table

DT_WATER_TABLE

DT_WELL

Describes water table data, as encountered during drilling and subsequent stabilization.

COC

DT_CHAIN_OF_CUSTODY

Describes information about chain of custody.

Backfill

DT_GEO_BACKFILL

Describes data regarding backfill information for boreholes or an excavation.

Well_Data

DT_WELL

DT_MEASURE_DATUM

Describes general information relating to well installation

Well_Construction

DT_WELL_SEGMENT

Describes information relating to well construction and well segments.

Standard_Penetration

DT_GEO_STANDARD_PENETRATION

Describes details about geotechnical standard penetration test results.

Coordinates

DT_COORDINATE

Associates locations with spatial coordinates and related metadata.

Geography

DT_GEOGRAPHY

Describes location geometries.

Note

DT_NOTE

Record notes, and allows notes to be structured and associated with various tables in the database.

Lithology_Data

DT_LITHOLOGY

DT_LITHOLOGY_COMPONENT

Describes lithology data for the borings.

Lithology_Component

DT_LITHOLOGY_COMPONENT

Describes lithologic components at specific locations. This can include existing DT_LITHOLOGY data like angularity and moisture; or additional data such as hardness and plasticity.

Discontinuity

DT_GEO_DISCONTINUITY

Describes discontinuity information, such as fractures and joints.

Fracture_Spacing

DT_GEO_FRACTURE_SPACING

Describes fracture spacing in rocks.

Pumping_Test

DT_PUMP_RATE

Describes extraction and injection wells.

Hand_Penetrometer_Test

DT_GEO_TEST

DT_GEO_RESULT

Describes Hand Penetrometer tests and results.

Vane_Test

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Describes Vane tests and results.

Dynamic_CPT

DT_GEO_TEST

DT_GEO_RESULT

Describes Dynamic Cone Penetration tests and results.

Electrical_Resistivity

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Describes Electrical Resistivity test and results.

Environmental_Basic_Results

DT_BASIC_RESULT

Contains basic results related to environmental tests.  

Environmental_Test_Results

DT_TEST

DT_RESULT

DT_SDG

Contains data concerning analytical tests and results performed on samples.

Thermal_Resistivity

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Describes Thermal Resistivity test and results.

Water_Content_Density

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test data for water content values and density values.

Atterberg

DT_GEO_TEST

DT_GEO_RESULT

Contains test details about the consistency and behavior of fine-grained soil.

Atterberg_Readings

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test reading data about the consistency and behavior of fine-grained soil.

Sieve

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains test details used to assess the particle size distribution of a granular material.

Sieve_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data used to assess the particle size distribution of a granular material.

Sieve_D6913

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains test details used to assess the particle size distribution of a granular material based on ASTM D6913.

Sieve_Readings_D6913

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data used to assess the particle size distribution of a granular material based on ASTM D6913.

Hydrometer

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test details used to assess the particle distribution for silt and clay size particles finer than the number 200 sieve.

Hydrometer_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data used to assess the particle distribution for silt and clay size particles finer than the number 200 sieve.

Hydrometer_D7928

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains test details used to assess the particle distribution for material finer than the number 200 sieve based on ASTM D7928.

Hydrometer_Readings_D7928

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data used to assess the particle distribution for material finer than the number 200 sieve based on ASTM D7928.

Organic_Content

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains parameters related to determining the water content, ash content, and organic material of soils.

Specific_Gravity

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains details about the specific gravity of soil.

Compaction

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test details about the results for a Proctor test.

Compaction_Readings

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test reading data for a Proctor test.

Unconf_Compression

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test details for an Unconfined Compression test on a soil sample.

UnconfComp_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data for an Unconfined Compression test on a soil sample.

Unconf_Compression_Rock

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test details for an  Unconfined Compression test on a rock sample.

Unconf_Comp_Rock_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data for an Unconfined Compression test on a rock sample.

Unconsolidated_Undrained

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test details for an Unconsolidated Undrained triaxial test.

UnconsolUndrain_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains test reading data for an Unconsolidated Undrained triaxial test.

Consolidation_Details

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains the initial properties for a Consolidation specimen.

Consolidation_Load_Readings

DT_GEO_TEST

DT_GEO_RESULT

Contains load related test details for a Consolidation test.

Consolidation_Time_Readings

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains time related test reading data for a Consolidation test.

Direct_Shear

DT_GEO_TEST

DT_GEO_RESULT

Contains details about the shear strength parameters of soil.

Triaxial

DT_GEO_TEST

DT_GEO_RESULT

Contains details from a compression test of a soil sample to measure its strength.

Permeability

DT_GEO_TEST

DT_GEO_RESULT

Contains test to determine the drainage characteristics of relatively fine-grained soils and is usually performed on undisturbed samples.

CBR_Details

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains test details for different compaction points in a California Bearing Ratio test.

CBR_Moisture

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains moisture related details for different compaction points in a California Bearing Ratio test.

CBR_Load_Test

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains test results for different points in a California Bearing Ratio test.

CBR_Penetration

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains penetration test readings for different compaction points in a California Bearing Ratio test.

Expansion

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Parameters used in determining the expansion index.

Geo_Test_Parameter

DT_GEO_TEST_PARAMETER

Describes geotechnical test parameters.

Other_Lab_Results

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Describes tests and results that do not belong in the other lab testing sections.

CPT_Data

DT_DOWNHOLE_POINT_DATA

Contains downhole data from  a Cone Penetration Test (CPT).

CPT_Details

DT_LOCATION_PARAMETER

Contains test details for a CPT.

Dissipation_Data

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

Contains the pore pressure readings associated with a CPT Pore Pressure Dissipation test.

Dissipation_Details

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

Contains the details in regard to a CPT Pore Pressure Dissipation test.

Downhole_Point_Data

DT_DOWNHOLE_POINT_DATA

Contains data from downhole logging methods such as Cone Penetration Tests and geophysics.

DMT_Data

DT_DOWNHOLE_POINT_DATA

Contains downhole data from a Flat Dilatometer Test (DMT).

DMT_Details

DT_LOCATION_PARAMETER

Contains test details for a DMT.

Texas_Cone

DT_GEO_STANDARD_PENETRATION

Describes Texas Cone Penetration test details.

Lab_Assignment

DT_GEO_LAB_ASSIGN

Stores general information regarding the lab test assignment.

Lab_Assignment_Test

DT_GEO_LAB_ASSIGN_TEST

Stores detailed lab test assignment information per sample.

Reporting_Parameters

DT_NOTE

Used to carry over specific parameters needed to generate custom export from the data in EQuIS.

File

DT_FILE

Loads supplementary information in to EQuIS.

File_Parameter

DT_FILE_PARAMETER

Loads supplementary information in to EQuIS.

Group

RT_GROUP

Reference table for user-defined facility, location, material, and analyte groups.

Group_Member

RT_GROUP_MEMBER

Reference table for members of RT_GROUP_MEMBER.

 

 

There are several differences between the Geotechnical and Geotechnical_v2 formats. The Geotechnical_v2 format has additional lab testing sections and the order and available columns have changed in various sections. Additionally, users can update facility information through the Geotechnical_v2 format.  

 

Columns in the Geotechnical_v2 format use different tables for their reference value lookups. The EQuIS EDD (Electronic Data Deliverable) Description file includes which tables are used for the reference value source. Download the EQuIS EDD Description file in EDP or the Enterprise EDP EDD Upload Widget.  

 

For information about the custom checks utilized in this format, please see the EDD Description Files.