Data Mapping

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Interfaces > LogPlot >

Data Mapping

LogPlot creates a new file for every location selected.

 

Location Tab in the LogPlot interface pulls a subset of data from VW_LOCATION.

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Setup

Start Depth

 

 

 



 

 

Ending Depth

DT_LOCATION

TOTAL_DEPTH

 

 

 

 

 

Easting

DT_COORDINATE

X_COORD

 

 

Coordinate type selected in the LogPlot Interface SetUp tab

 

 

Nothing

DT_COORDINATE

Y_COORD

 

 

Coordinate type selected in the LogPlot Interface SetUp tab

 

 

Elevation

DT_COORDINATE

ELEV

 

 

Coordinate type selected in the LogPlot Interface SetUp tab

 

 

Comments

 

 

 

 

Date Created, username, computer, EQuIS version, facility, db

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

End Line

Left Depth

DT_LOCATION

TOTAL_DEPTH

 

 

 

 

 

Right Depth

DT_LOCATION

TOTAL_DEPTH

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

End Text

Depth

DT_LOCATION

TOTAL_DEPTH

 

Text Column

 

 

 

Text

 

 

 

 

User entered End Text in Setup tab

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

E-Text

 

User defined. Pick the table, field, whereclause and the E-Text Tab Name to specify what to export and which tab to export to. This info is exported for the selected location.

 

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

DownHole Point Data

Depth

DT_DOWNHOLE_POINT_DATA

Depth

 

Curve/Text

 

 

 

Value

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Water Table

Depth/Top

DT_WATER_TABLE

depth

 

 

Selected in drop-down in Water Table/Well Construction Tab

Yes

 

Base (Optional)

 

 

 

 

 

 

 

Symbol

 

140 or 141

 

 

 

 

 

Size

 

0.3

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Well Material

Depth

DT_WELL_SEGMENT

0-START_DEPTH

 

Text Column

 

 

 

Text

 

MATERIAL_TYPE_CODE

 

 

 

 

 

LogPlot Table

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Well Description

Depth

DT_WELL_SEGMENT

0-START_DEPTH

 

Text column

 

 

 

Text

 

remark

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Well Construction

Top

DT_WELL_SEGMENT

0-START_DEPTH

 

 

 

 

 

Base

DT_WELL_SEGMENT

0-START_DEPTH

 

 

If END_DEPTH is null then START_DEPTH is used

 

 

Outer Diam

DT_WELL_SEGMENT

OUTER_DIAMETER

 

 

 

 

 

Inner Diam

DT_WELL_SEGMENT

INNER_DIAMETER

 

 

Set for plotting diameter NOT the physical inner diameter, so for screen, the inner diameter should be 0

 

 

Material

DT_WELL_SEGMENT

SEGMENT_TYPE

 

 

 

 

 

Offset

 

 

 

 

 

 

 

Caption

 

 

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample ID

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint (START_DEPTH, END_DEPTH)

 

Text Column

Based on selection in the "by midpoint"

 

 

Text

 

SYS_SAMPLE_CODE/SAMPLE_NAME

 

 

Based on selection in the "Identify Sample By"

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample ID

Top

DT_SAMPLE

0-START-DEPTH

 

Lithology

 

 

 

Base

DT_SAMPLE

0-START-DEPTH

 

 

 

 

 

Lithology

 

 

 

 

 

 

 

Contact

 

 

 

 

 

 

 

Description

DT_SAMPLE

SYS_SAMPLE_CODE/SAMPLE_NAME

 

 

Based on selection in "Identify Sample By"

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sampled Intervals

Top

DT_SAMPLE

0-START-DEPTH

 

FILLBAR

 

 

 

Base

DT_SAMPLE

0-START-DEPTH

 

 

 

 

 

Fill

 

 

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab

Field Notes

Required

Sample Type

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint (START_DEPTH, END_DEPTH)

 

Text Column

Based on selection in "by midpoint"

 

 

Text

DT_SAMPLE

SAMPLE_TYPE_CODE

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample Method

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint(START_DEPTH, END_DEPTH)

 

Text Column

Based on selection "by the midpoint"

 

 

Text

DT_SAMPLE

SAMPLE_METHOD

 

 

 

 

 

LogPlot

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample Method

Top

DT_SAMPLE

0-START_DEPTH

 

Lithology

 

 

 

Base

DT_SAMPLE

0-END_DEPTH

 

 

 

 

 

Lithology

 

 

 

 

 

 

 

Contact

 

 

 

 

 

 

 

Description

DT_SAMPLE

SAMPLE_METHOD

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample Desc

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint (START_DEPTH, END_DEPTH)

 

Text Column

Based on selection in "by midpoint."

 

 

Text

DT_SAMPLE

SAMPLE_DESC

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

BlowCounts

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint (START_DEPTH, END_DEPTH)

 

Text Column

Based on Selection in "by midpoint"

 

 

Text

DT_SAMPLE_PARAMETER

PARAM_VALUE

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Sample Parameter

Depth

DT_SAMPLE

(0-START_DEPTH) or midpoint (START_DEPTH, END_DEPTH)

A different tab is created for each sample parameter, Sample parameters can be exported as TEXT-COLUMN, VERT-TEXT, LITH, FILLBAR, HISTOGRAM or CURVE. The depth information comes from DT_SAMPLE, START_DEPTH and END_DEPTH

 

Based on selection in "by midpoint". The user can opt to export Sample Parameters that respect or ignore the filters applied in the Sample Tab of the interface.

 

 

Text

DT_SAMPLE_PARAMETER

PARAM_VALUE

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

STATIC_MATERIAL_PROPERTIES

Depth

DT_SAMPLE

Depth for each sample

A different tab is created for each static material property

Text Column

 

 

 

Text

 

Corresponding value based on which static material property is picked

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Lithology

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in the Layer drop-down in the Lithology Tab

Text Column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

MATERIAL_NAME

 

 

Based on selection in "layer"

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Lithology

Top

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in the Layer drop-down in the Lithology Tab

Lith

 

 

 

Base

N_LITHOLOGY/V54.LITHOLOGY

END_DEPTH

 

 

 

 

 

Lithology

N_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

MATERIAL_NAME

 

 

 

 

 

Contact

N_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

CUSTOM_FIELD_3

CUSTOM_FIELD_3 should have values solid, dashed or none

 

 

 

 

Description

N_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

REMARK_1 or REMARK_2 along with color, moisture, odor and observation

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Note

LogPlot Tab Type

Field Notes

Required

Lithology

Top

DT_LITHOLOGY

START_DEPTH

Only when GEO_UNIT_CODE is picked in the Layer drop-down in the Lithology Tab

Lith

 

 

 

Base

DT_LITHOLOGY

START_DEPTH

 

 

logically calculated from DT_LITHOLOGY

 

 

Lithology

DT_LITHOLOGY

GEO_UNOT_TYPE_DESC

 

 

the GEO_UNIT_CODE selected

 

 

Contact

 

 

 

 

 

 

 

Description

RT_GEO_UNIT_TYPE

GEO_UNIT_TYPE_DESC

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

LithDesc

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in Layer drop-down in Lithology Tab

Text Column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

REMARK_1/REMARK_2

 

 

 

 

 

LogPlot

Tab

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Observation

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in the Layer drop-down in Lithology Tab.

Text column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

Observation

 

 

 

 

 

LogPlot Tabs

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Color

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in Layer drop-down in Lithology Tab

Text Column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

COLOR

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Moisture

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in Layer drop-down in Lithology Tab

Text Column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

MOISTURE

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Odor

Depth

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

START_DEPTH

Only when lithology is picked in Layer drop-down in Lithology Tab

Text Column

 

 

 

Text

FN_LITHOLOGY/V54.LITHOLOGY(DT_LITHOLOGY)

ODOR

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Drill Method

Top

DT_DRILL_ACTIVITY

START_DEPTH if null 0

Only when lithology is picked in Layer drop-down in Lithology Tab

VERT-TEXT

 

 

 

Base

DT_DRILL_ACTIVITY/DT_LOCATION

DT_DRILL_ACTIVITY.END_DEPTH if null then (-1) * DT_LOCATION.TOTAL_DEPTH

 

 

 

 

 

Text

DT_DRILL_ACTIVITY

DRILL_METHOD

 

 

 

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

Interval

Depth

DT_LITHOLOGY

START_DEPTH

 

Text Column

Depth

 

 

Text

DT_LITHOLOGY

START_DEPTH (thickness is calculated for the material or GEO_UNIT_CODE selected)

 

 

Thickness annotated in brackets

 

 

LogPlot Tab

Field in LogPlot

EQuIS Table, View or Function

EQuIS Field

Table Notes

LogPlot Tab Type

Field Notes

Required

I-Data (for selected chemicals)

Depth

Analytical Results

START_DEPTH

A different tab is created for each sample parameter, Sample parameters can be exported as TEXT-COLUMN, VERT-TEXT, LITH, FILLBAR, HISTOGRAM or CURVE. The depth information comes from DT_SAMPLE and START_DEPTH

 

 

 

 

Value

Analytical Results

REPORT_RESULT_VALUE