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 EarthSoft Support to anyone with licensing for 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