AGS4 Link Mapping Project Template File Mapping to Geotechnical_v2 Format [d34917]
Created the AGS4_Geotechnical_v2.link Mapping Project Template file that maps a selection of the groups included in the Association of Geotechnical and Geoenvironmental Specialists (AGS) Version 4.0.4 format to the EQuIS Geotechnical_v2 format (Geotechnical_v2.zip) to import data to EQuIS. Detailed descriptions of the mappings are provided in the Defined_Mappings_AGS4_Geotechnical_v2.xlsx file.
Geotechnical CPT Parameters Report – Add 'depth_unit' into Template Y-axis Chart [d33942]
Updated the Geotechnical CPT Parameter report charts to display a measurement unit for depth.
Geotechnical Export - AGS 4 Report – New Report to Export EQuIS Data in AGS Format [d31222]
Created the "Geotechnical Export - AGS 4" report (EarthSoft.Reports.Library.d31073.dll) so that users can export geotechnical and geoenvironmental data from EQuIS into the standard Association of Geotechnical and Geoenvironmental Specialists (AGS) format. The report follows AGS Version 4.0.4 formatting rules.
Geotechnical Lab Summary Report – Add DRY_DENSITY and WET_DENSITY to 'Calculated Information' [d30845]
The DRY_DENSITY and WET_DENSITY parameters are now selectable in the Geotechnical Lab Summary Parameter "Calculated Information".
Geotechnical Lab Summary Report – Include Unconfined Compressive Strength/Unconsolidated Undrained Strength Results in 'Calculated Information' [d34108]
Added two new selections of "Unconfined Compressive Strength" and "Unconsolidated Undrained Strength" to the "Display Raw Data/Calculated Information" parameter of the Geotechnical Lab Summary report.
Geotechnical Lab Test Status Report – New Grid Report to Display Geotechnical Lab Test Completion [d33821]
Created the "Geotechnical Lab Test Status" report in EarthSoft.Reports.Library.176839.dll file that summarizes the status of the geotechnical lab tests of the selected tasks and/or locations.
Geotechnical Refval EDD – Update Example Refval EDD File [d34145]
Updated the Geotech_Refvals_EDD.xlsx file to have:
- New NOTE_TYPES for the RT_NOTE_TYPE table that will be used in future Geotechnical Widgets.
- Reference values for the 'Unconf_Compression_Rock' and 'Unconf_Comp_Rock_Readings' sections of the format to be added to the RT_GEO_TEST_PARAM_TYPE and RT_GEO_RESULT_CODE tables.
Geotechnical Results Report – New Test Results Grid Report [d31136]
Created the "Geotechnical Results" report (EarthSoft.Reports.Library.d30189.dll) to return information from the DT_SAMPLE, DT_GEO_TEST and DT_GEO_RESULT tables based on the report parameter selections.
Geotechnical Unconfined Compression and Unconsolidated Undrained Reports – Update Display [d31239]
Fixed an issue in the 'Geotechnical Unconfined Compression' and 'Geotechnical Unconsolidated Undrained' reports where the Y-axis labels did not display in the report chart when metric units were selected. Also improved the space between the top of the curve and Y-axis maximum value when Y-axis maximum value is less than 10.
Geotechnical_v2 Format – Add Identifier Column and Default Mapping to Environmental_Test_Results [d31633]
Added identifier field to the Environmental_Test_Results section of the Geotechnical_v2 format.
Geotechnical_v2 Format – Add 'measurement_date' as a PK to the CPT_Details Section [d30810]
Added "measurement_date" to the Primary Key of the CPT_Details section of the Geotechnical_v2 format.
Geotechnical_v2 Format – Add Missing Units to DT_GEO_DISCONTINUITY [d33755]
Added discontinuity_aperture_measurement_unit and discontinuity_wall_strength_unit to the DISCONTINUITY section.
Geotechnical_v2 Format – Automatically Map '%' as the param_unit for water_content Values in Multiple Sections of the Format [d30814]
Added a default mapping of '%' for the DT_GEO_TEST_PARAMETER.PARAM_UNIT and
DT_GEO_RESULT.RESULT_UNIT for water_content, OC_ashcontent, and
organic_content values in the following sections of the Geotechnical_v2
format:
- Sieve
- Organic_Content
- Unconf_Compression
- Unconsolidated_Undrained
Geotechnical_v2 Format – 'Equipment_Parameter' Section Should Not Require facility_code to Be Populated [d30817]
Updated the Geotechnical_v2 format so that facility_code and task_code are no longer required fields in the Equipment_Parameter section.
Geotechnical_v2 Format – Fix Spelling for 'intitial_wet_density' [d30812]
Fixed the spelling for "initial_wet_density" in the Consolidation_Details section of the Geotechnical_v2 format.
Geotechnical_v2 Format – Geo_Test_Parameters Section Not Finding Correct Date [d34005]
Fixed an issue when locating the correct GEO_TEST_ID for the GEO_TEST_PARAMETER section.
Geotechnical_v2 Format – Unable to Generate GEO_TEST_ID in LOTE [d33759]
Fixed a bug in the Geotechnical_v2 format where Test IDs were not assigned correctly for Language Other Than English (LOTE) users.
Schema – Geotechnical – Add 'ei_profile_fieldresults' Database Function [d31167]
Added ei_profile_fieldresults database function to the Geotechnical Schema to be available as an option in EnviroInsite Templates.
Schema – Geotechnical – Add Missing Units to DT_GEO_DISCONTINUITY [d31746]
Updated the DT_GEO_DISCONTINUITY table in the Geotechnical Schema to include APERTURE_MEASUREMENT_UNIT
and WALL_STRENGTH_UNIT fields.
Schema – Geotechnical – Update EQUIS.GEOTECH_CPT_ROD_BREAK with Additional DT_DOWNHOLE_POINT_DATA Fields [d31670]
Added ORIGINAL_DEPTH and REPORTABLE_YN fields to the EQUIS.GEOTECH_CPT_ROD_BREAK database function in the Geotechnical Schema file (schema.geotech.xse). This allows users to modify depths in records without losing the record.