Geotechnical Module Installation and Configuration
Copyright © 2019 EarthSoft, Inc • Modified: 02 Aug 2019
Setup for the EQuIS Geotechnical Module involves installing the module and updating existing databases with the Geotechnical Module Schema.
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).
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:
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 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.