Geotechnical Module Installation and Configuration

<< Click to Display Table of Contents >>

 >Geotechnical Module >

Geotechnical Module Installation and Configuration

Setup for the EQuIS Geotechnical Module involves installing the module and updating existing databases with the Geotechnical Module Schema.

 

Installing the Geotechnical Module

 

To install the Geotechnical Module, select the Geotechnical Module during the installation of EQuIS Professional. If EQuIS Professional is already installed, the installer can be run again to add the Geotechnical Module. Be sure to install the tutorial files.

 

When complete, verify that the EarthSoft.Interfaces.gINT.dll file is in the EQuIS Professional folder (e.g., C:\Program Files\EarthSoft\EQuIS) and that the GeoTechnical folder is in the Tutorial folder (e.g., C:\Program Files\EarthSoft\EQuIS\Tutor\GeoTechnical).

 

 

Geotechnical Schema

 

The EQuIS Geotechnical Schema (schema.geotech.xml/e) replaces previous geotechnical schemas, which will no longer be offered. Data from the previous geotechnical schema are not automatically migrated into the new schema. The Geotechnical Schema is available for download in the Products\Geotechnical folder on the Downloads Dashboard on the EarthSoft Community Center.

 

The Geotechnical Schema stores geotechnical data in the following new tables:

RT_GEO_TEST_PARAM_TYPE

RT_GEO_RESULT_CODE

DT_GEO_STANDARD_PENETRATION

DT_GEO_CORING

DT_GEO_DISCONTINUITY

DT_GEO_FRACTURE_SPACING

DT_GEO_BACKFILL

DT_GEO_TEST

DT_GEO_TEST_PARAMETER

DT_GEO_RESULT

 

The DT_SAMPLE table has been modified to include new fields DIAMETER and DIAMETER_UNIT.  

 

The DT_LITHOLOGY table has been modified to include a new field END_DEPTH (numeric/decimal data-type), which is required when the MATERIAL_NAME field is populated.

 

The DT_LOCATION table has been modified to include new fields OFFSET, STATION, and ROUTE. These new fields were added in conjunction with the Geotechnical Schema but are also part of the standard EQuIS Schema.

 

 

Update an Existing Database

 

Update the database with schema.geotech.xme. Note the database must already be updated to EQuIS 7.

 

For SQL Server, follow the updating database steps in the help article Update EQuIS Database.

 

The DT_LITHOLOGY table has been modified to include the field END_DEPTH (numeric/decimal data-type), which is required when the MATERIAL_NAME field is populated. For existing databases, the update process will populate END_DEPTH with the same value that is computed with the EQUIS.LITHOLOGY database function (also in the view VW_LITHOLOGY). Since END_DEPTH is a required field, and there is a possibility that it cannot be populated, the database update process may fail. To verify if there is a problem, a couple of SQL queries have been posted to the forum, under topic "Adding END_DEPTH as a new (required) column in the DT_LITHOLOGY table". Additionally, a new view named VW_LITHOLOGY_GAP_OVERLAP is in the database to identify if gaps/overlaps exist between sections in the lithology.