Geotechnical Export

Report Name: Geotechnical Export - AGS 4

File Name: EarthSoft.Reports.Library.d31073.dll

Dependencies: Licensed EQuIS Geotech and Geotechnical Schema

Software: EQuIS Professional and Enterprise

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: .ags

Description: The Geotechnical Export - AGS 4 report exports data from EQuIS and outputs it using Association of Geotechnical and Geoenvironmental Specialists (AGS) formatting rules. This report filters the results based on the selected task code. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotechnical Schema applied to the database. The Geotechnical Export - AGS 4 report (EarthSoft.Reports.Library.d31073.dll) is available for download in the Products\EQuIS Geotech folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Additional Details:

The Geotechnical Export - AGS 4 report exports data from EQuIS in compliance with the AGS Format. The AGS Format is used to transfer data between systems without change to the systems themselves. More information about the AGS Format and AGS Rules can be found here.

Note: The Geotechnical Export - AGS 4 report follows the suggested data type decimal precision for numeric values. Fourteen (14) characters is the maximum number of values to the left of the decimal for numeric values.

Note: The Geotechnical Export - AGS 4 report does not support tasks that have data stored in multiple units. The report will use the first unit found for all data, and will not perform any unit conversions.

To visualize AGS files in Microsoft Excel, please use the converter here.

Information about importing AGS data into EQuIS can be found in the Mapping AGS Data to EQuIS Geotechnical_v2 Format in EQuIS Link article.

Tables: The following AGS sections are available in the Geotechnical Export - AGS 4 report. The sections are output in the order outlined below and pull information from the specified EQuIS tables.

AGS Section	EQuIS Table(s)	Contents
PROJ	DT_TASK DT_TASK_PARAMETER	Project Information
ABBR	DT_DRILL_PARAMETER DT_GEO_BACKFILL DT_GEO_RESULT DT_GEO_TEST DT_LITHOLOGY DT_RESULT DT_SAMPLE DT_TEST	Abbreviation Definitions
TRAN	DT_TASK_PARAMETER	Data File Transmission Information / Data Status
TYPE		Definition of Data Types
UNIT	RT_UNIT	Definition of Units
BKFL	DT_GEO_BACKFILL	Exploratory Hole Backfill Details
CDIA	DT_WELL_SEGMENT	Casing Diameter by Depth
CHIS	DT_DRILL_ACTIVITY	Chiseling Details
CMPG	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Compaction Tests – General
CMPT	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Compaction Tests – Data
CORE	DT_GEO_CORING	Coring Information
DETL	DT_LITHOLOGY	Stratum Detail Descriptions
DISC	DT_GEO_DISCONTINUITY	Discontinuity Data
DOBS	DT_DRILL_ACTIVITY	Drilling/Advancement Observations and Parameters
DREM	DT_LOCATION DT_NOTE	Depth Related Remarks
ERES	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE RT_ANALYTE	Environmental Contaminant Testing
FLSH	DT_DRILL_PARAMETER	Drilling Flush Details
FRAC	DT_GEO_FRACTURE_SPACING	Fracture Spacing
GCHM	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Geotechnical Chemistry Testing
GEOL	DT_LITHOLOGY	Field Geological Descriptions
GRAG	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Particle Size Distribution Analysis – General
GRAT	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Particle Size Distribution Analysis – Data
HDIA	DT_DRILL_ACTIVITY	Hole Diameter by Depth
HDPH	DT_DRILL_ACTIVITY DT_EXCAVATION DT_LOCATION_PARAMETER	Depth Related Exploratory Hole Information
HORN	DT_GEO_HOLE_SURVEY DT_GEO_HOLE_SURVEY_RESULT	Exploratory Hole Orientation and Inclination
IDEN	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	In Situ Density Tests
IPEN	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	In Situ Hand Penetrometer Tests
IPID	DT_BASIC_RESULT	On-Site Volatile Headspace Testing by Photo Ionization Detector
ISPT	DT_GEO_STANDARD_PENETRATION	Standard Penetration Test Results
IVAN	DT_GEO_RESULT DT_GEO_TEST DT_LOCATION	In Situ Vane Tests
LBSG	DT_GEO_LAB_ASSIGN	Testing Schedule
LBST	DT_GEO_LAB_ASSIGN DT_GEO_LAB_ASSIGN_TEST DT_SAMPLE RT_GEO_TEST_METHOD	Testing Schedule Details
LDEN	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Density Tests
LLPL	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Liquid and Plastic Limit Tests
LNMC	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Water / Moisture Content Tests
LOCA	DT_COORDINATE DT_LOCATION	Location Details
LPEN	DT_GEO_RESULT DT_GEO_TEST DT_SAMPLE	Laboratory Hand Penetrometer Tests
LVAN	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Laboratory Vane Tests
MOND	DT_LOCATION DT_LOCATION_PARAMETER RT_LOCATION_PARAM_TYPE	Monitoring Readings
MONG	DT_LOCATION DT_WELL	Monitoring Installations and Instruments
PIPE	DT_LOCATION DT_WELL DT_WELL_SEGMENT	Monitoring Installation Pipe Work
PTIM	DT_DRILL_ACTIVITY	Boring/Drilling Progress by Time
PUMG	DT_PUMP_RATE	Pumping Tests – General
PUMT	DT_PUMP_RATE	Pumping Tests – Data
RUCS	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Rock Uniaxial Compressive Strength and Deformability Tests
SAMP	DT_FIELD_SAMPLE DT_SAMPLE DT_SAMPLE_PARAMETER	Sample Information
SCDG	DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_LOCATION DT_LOCATION_PARAMETER	Static Cone Dissipation Tests – General
SCDT	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_LOCATION DT_LOCATION_PARAMETER	Static Cone Dissipation Tests – Data
SCPG	DT_EQUIPMENT_PARAMETER DT_LOCATION DT_LOCATION_PARAMETER DT_WATER_TABLE	Static Cone Penetration Tests – General
SCPP	DT_DOWNHOLE_POINT_DATA DT_LOCATION_PARAMETER	Static Cone Penetration Tests – Derived Parameters
SCPT	DT_DOWNHOLE_POINT_DATA DT_LOCATION_PARAMETER	Static Cone Penetration Tests – Data
TRIG	DT_GEO_TEST DT_SAMPLE	Triaxial Tests – Total Stress – General
TRIT	DT_GEO_RESULT DT_GEO_TEST DT_GEO_TEST_PARAMETER DT_SAMPLE	Triaxial Tests – Total Stress – Data
WADD	DT_DRILL_PARAMETER	Water Added Records
WSTG	DT_WATER_TABLE	Water Strike – General
WSTD	DT_WATER_TABLE	Water Strike – Details

Report Parameters

Task	Parameter for selecting single task code.
AGS Version	Parameter for selecting the AGS Version. This parameter is defaulted to “4.0.4”. In the future, more AGS versions will be supported.