EQuIS for gINT Mappings

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Interfaces > gINT >

EQuIS for gINT Mappings

The mappings between the default "gint us.gpj" and EQuIS (Import Mapping), and between EQuIS and the output database using the default "gint us.gdt" are as shown below. Customization of these mappings may be required for different gINT database templates and project databases.

 

Modifications to the import mapping are made in the gINT.xsd and gINT.vb files, which are available from the Help Desk to anyone with a licensed version of the EQuIS for gINT interface. (The format files distributed with the installation are encrypted, gINT.xse and gINT.vbe.)

 

Modifications to the export mapping are made in the gint us.gdx file.

 

Import Mapping

 

gINT Table

gINT Field

Maps To

EQuIS Table

EQuIS Field

PROJECT

Client

==>

DT_FACILITY

CLIENT

PROJECT

Name

==>

DT_FACILITY

FACILITY_NAME

PROJECT

Number

==>

DT_FACILITY

FACILITY_CODE

PROJECT

Location

==>

DT_FACILITY

Split on comma (,) to CITY and STATE

PROJECT

Depth Log Page

==>

DT_FACILITY

REMARK

(default)

"Unknown"

==>

DT_FACILITY

COORD_TYPE_CODE

(default)

"Primary"

==>

DT_FACILITY

IDENTIFIER

POINT

PointID

==>

DT_LOCATION

SYS_LOC_CODE

POINT

HoleDepth

==>

DT_LOCATION

TOTAL_DEPTH

POINT

Date Started

==>

DT_LOCATION

START_DATE

POINT

Date Completed

==>

DT_LOCATION

END_DATE

POINT

Elevation

==>

DT_LOCATION

ELEV

POINT

Hole Size

==>

DT_LOCATION

DIAMETER

POINT

Any File

==>

DT_LOCATION

(Not Mapped)

POINT

Contractor

==>

DT_LOCATION

DRILLING_SUBCONTRACTOR

POINT

Method

==>

DT_LOCATION

DRILLING_METHOD

POINT

Logged By

==>

DT_LOCATION

DRILLER

POINT

Checked By

==>

DT_LOCATION

INSPECTOR

POINT

Notes

==>

DT_LOCATION

REMARK_1

POINT

Water Depth During

==>

DT_WATER_TABLE

DEPTH where SEQUENCE = "Water Depth During"

POINT

Water Depth At End

==>

DT_WATER_TABLE

DEPTH where SEQUENCE = "Water Depth at End"

POINT

Water Depth After

==>

DT_WATER_TABLE

DEPTH where SEQUENCE = "Water Depth After"

POINT

Hours After

==>

DT_LOCATION

REFERENCE_POINT where SEQUENCE = "Water Depth After"

POINT

Depth Log Page

==>

DT_LOCATION

REMARK_2

POINT

North

==>

DT_COORDINATE

Y_COORD

 

Export Mapping

 

EQuIS Table

EQuIS Field

Maps to

gINT Table

gINT Field

DT_FACILITY

CLIENT

==>

PROJECT

Client

DT_FACILITY

FACILITY_NAME (if exists, otherwise FACILITY_CODE)

==>

PROJECT

Name

DT_FACILITY

FACILITY_CODE

==>

PROJECT

Number

DT_FACILITY

CITY, STATE, COUNTRY

==>

PROJECT

Location

DT_LOCATION

SYS_LOC_CODE

==>

POINT

PointID

DT_LOCATION

TOTAL_DEPTH (if exists, otherwise 0)

==>

POINT

HoleDepth

DT_LOCATION

START_DATE

==>

POINT

Date Started

DT_LOCATION

END_DATE

==>

POINT

Date Completed

DT_LOCATION

ELEV

==>

POINT

Elevation

DT_LOCATION

DIAMETER + DIAMETER_UNIT (if exists)

==>

POINT

Hole Size

DT_LOCATION

NULL

==>

POINT

Any File

DT_LOCATION

COMPANY_NAME

==>

POINT

Contractor

DT_LOCATION

DRILLING_METHOD

==>

POINT

Method

DT_LOCATION

DRILLER

==>

POINT

Logged By

DT_LOCATION

INSPECTOR

==>

POINT

Checked By

DT_LOCATION

REMARK_1

==>

POINT

Notes

DT_LOCATION

DEPTH

==>

POINT

Water Depth During

DT_LOCATION

DEPTH

==>

POINT

Water Depth End

DT_LOCATION

DEPTH

==>

POINT

Water Depth After

DT_LOCATION

REFERENCE_POINT

==>

POINT

Hours After

DT_COORDINATE

Y_COORD

==>

POINT

North

DT_COORDINATE

X_COORD

==>

POINT

East

DT_LOCATION

PLUNGE

==>

POINT

Plunge

DT_WELL_SEGMENT

SYS_LOC_CODE

==>

WELL

PointID

DT_WELL_SEGMENT

START_DEPTH

==>

WELL

Depth

DT_WELL_SEGMENT

END_DEPTH

==>

WELL

Bottom

DT_WELL_SEGMENT

SEGMENT_TYPE

==>

WELL

Graphic

DT_WELL_SEGMENT

SCREEN_TYPE

==>

WELL

Pointer

DT_WELL_SEGMENT

REMARK

==>

WELL

Description

DT_LITHOLOGY

SYS_LOC_CODE

==>

LITHOLOGY

PointID

DT_LITHOLOGY

START_DEPTH

==>

LITHOLOGY

Depth

DT_LITHOLOGY

END_DEPTH

==>

LITHOLOGY

Bottom

DT_LITHOLOGY

CUSTOM_FIELD_1

==>

LITHOLOGY

USCS

DT_LITHOLOGY

MATERIAL_NAME

==>

LITHOLOGY

Graphic

DT_LITHOLOGY

REMARK_1

==>

LITHOLOGY

Description

DT_LITHOLOGY

CUSTOM_FIELD_3

==>

LITHOLOGY

Line Type

DT_LITHOLOGY

SYS_LOC_CODE

==>

REMARKS

PointID

DT_LITHOLOGY

START_DEPTH

==>

REMARKS

Depth

DT_LITHOLOGY

REMARK_2

==>

REMARKS

Description

DT_SAMPLE

SYS_LOC_CODE

==>

SAMPLE

PointID

DT_SAMPLE

SYS_LOC_CODE

==>

SAMPLE

Code

DT_SAMPLE

START_DEPTH (if exists, otherwise 0)

==>

SAMPLE

Depth

DT_SAMPLE

SAMPLE_METHOD

==>

SAMPLE

Type

DT_SAMPLE

SAMPLE_NAME

==>

SAMPLE

Number

DT_SAMPLE

(END_DEPTH - START_DEPTH)*12

==>

SAMPLE

Length

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "Recovery Length"

==>

SAMPLE

Recovery Length

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "RQD Length"

==>

SAMPLE

RQD Length

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "Blows 1st"

==>

SAMPLE

Blows 1st

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "Blows 2nd"

==>

SAMPLE

Blows 2nd

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "Blows 3rd"

==>

SAMPLE

Blows 3rd

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "Blows 4th"

==>

SAMPLE

Blows 4th

DT_SAMPLE_PARAMETER

PARAM_VALUE where PARAM = "ID"

==>

SAMPLE

PID

DT_DOWNHOLE_POINT_DATA

SYS_LOC_CODE

==>

CPT

PointID

DT_DOWNHOLE_POINT_DATA

DEPTH

==>

CPT

Depth

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

==>

CPT

Friction

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

==>

CPT

Cone Resistance

DT_DOWNHOLE_POINT_DATA

SYS_LOC_CODE

==>

TESTS

PointID

DT_DOWNHOLE_POINT_DATA

SYS_SAMPLE_CODE

==>

TESTS

Code

DT_DOWNHOLE_POINT_DATA

START_DEPTH (if exists, otherwise 0)

==>

TESTS

Depth

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

==>

TESTS

Pocket Penetrometer

DT_STATIC_PROPS

W

==>

TESTS

Moisture Content

DT_STATIC_PROPS

DRY_UNIT

==>

TESTS

Dry Density

DT_ATTERBERG

LIQUID_LIMIT

==>

TESTS

Liquid Limit

DT_ATTERBERG

PLASTIC_LIMIT

==>

TESTS

Plastic Limit

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

==>

TESTS

Fines

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

==>

TESTS

Other Tests