<< Click to Display Table of Contents >> Navigation:  EnviroInsite > EQuIS Database > EQuIS Tables > EQuIS Tables and Fields Used to Generate EnviroInsite Boring Logs

The Data Sources sections of this article describe the tables and fields of the EQuIS Schema that EnviroInsite uses to generate boring logs. The fields listed include those accessed by EnviroInsite to display data directly, as well as fields used to query data for display or to generate calculated values. Italicized fields are available if the Geotech Schema is applied.  

 

Data Sources for Specific Boring Log Elements:

•Header or Footer

•Lithology

•Sample Interval

•Downhole Point

•Downhole Interval: Geotechnical Sample Elements

•Downhole / Point Data: Geotechnical Test and Result Elements

 

For information on configuring the boring log elements (headers [Page, Data, and Title Block], footer, and downhole [chart/log] section), see the Boring Log Template Design Window. For information relating to EnviroInsite database functions used with EnviroInsite templates in Boring Logs or Subsurface Profiles, see EQuIS Functions. For additional options, see Downhole Intervals or Downhole Point Data.

 

The display of data on an EnviroInsite boring log can also be dynamic and controlled through parameter configurations in EQuIS reference and data tables (see Parameter Configurations for Boring Log Data).

 

 

Data Sources for Boring Log Header or Footer Elements

 

This section describes tables and fields that may be accessed to generate elements contained in the boring log header or footer.

 

Note that data from DT_DRILL_ACTIVITY may be filtered if a DT_TASK.TASK_CODE is selected when creating a Boring Log. When a TASK_CODE is selected along with locations in the Select Borings window, header data will be filtered by the chosen TASK_CODE. Only DT_DRILL_ACTIVITY records with this TASK_CODE will be plotted on the boring log. For more details, see Header Elements > DT_WATER_TABLE and DT_DRILL_ACTIVITY.

 

Users can select from various EQuIS tables and fields to be plotted in EnviroInsite Boring Log headers/footers. For more information see Header Elements > EQuIS Field Tab.

 

1EnviroInsite uses these fields in the background for querying data. They are not available for display on the boring logs.

2EnviroInsite uses the values in these fields to output a calculated value.

Italics - Italicized fields are available in the header/footer if the Geotech Schema is applied.

 

 

Data Sources for Lithology Elements

 

Lithology elements are displayed in the downhole section of the full page boring logs. These elements may be plotted using hatch symbology or as simple text values.

 

 

 

 

Data Sources for Sample Interval Elements

 

Sample interval elements are displayed in the downhole section of the full page boring logs. These elements may be plotted as fill or other types to indicate the sample depth range or simple text values representative of values in DT_SAMPLE_PARAMETER.

 

 

 

Data Sources for Downhole Point Data Elements

 

Downhole point data elements are displayed in the downhole section of the full page boring logs. These elements may be plotted as simple text values or in profile charts. For more options, see Downhole Point Data.

 

 

 

Data Sources for Well Construction Data Elements

 

Well construction data elements are displayed in the downhole section of the full page boring logs. These elements may be plotted using scaled drawings or simple schematics. The values are all accessed from DT_WELL_SEGMENT. Records from DT_WELL_SEGMENT may refer to either annular fill material or well hardware. The SEGMENT_TYPE record is used to distinguish between the two, based on selections made with EnviroInsite. For more options, see Well Construction.

 

 

 

Data Sources for Downhole Interval: Geotechnical Sample Elements

 

The geotechnical data sources require that the database is configured for EQuIS Geotech.  

 

Geotechnical sample elements are displayed in the downhole section of the boring log via the Downhole Interval Data section in the Boring Log Template Design window. These elements are either directly mapped to values in the database fields named or they are calculated and plotted as fill/symbol or simple text values based on values in DT_GEO_STANDARD_PENETRATION or DT_GEO_CORING.

 

 

 

 

Data Sources for Downhole / Point Data: Geotechnical Test and Result Elements

 

The geotechnical data sources require that the database is configured with the EQuIS Geotech.  

 

Geotechnical test and result elements are displayed in the downhole section of the boring log as defined in the Downhole/Point Data section in the Boring Log Template Design window. These elements may be directly mapped from the database or based on filter logic, and are plotted as either simple text values or profile charts.

 

The GEO_RESULT_CODEs, defined in RT_GEO_RESULT are user-configured parameter codes that define the type of result being stored. Accordingly for these codes, the Boring Log Template Design window displays the user-defined name, rather than the field name. Certain GEO_RESULT_CODEs are hard coded in the EarthSoft Geotechnical_v2 format.

 

The Sample-Test-Result geotechnical data are stored in three tables, where DT_SAMPLE and DT_GEO_RESULT records are related via DT_GEO_TEST as follows:

•DT_SAMPLE.SAMPLE_ID = DT_GEO_TEST.OBJECT_EUID

•DT_GEO_TEST GEO_TEST_ID=DT_GEO_RESULT.GEO_TEST_ID