|
<< Click to Display Table of Contents >> Navigation: Professional > Interfaces > Graphics Interfaces > LogPlot > EQuIS for 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 |
|
|
|
|
Copyright © 2024 EarthSoft, Inc. • Modified: 26 Jul 2022