<< 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 Geotech 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. Note that the result_value field is not required even if the detect_flag = 'Y'. |
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_Location_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 and are associated with a location. |
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.
Copyright © 2024 EarthSoft, Inc. • Modified: 11 Jul 2024