EQuIS for RockWorks - Mapping Document

<< Click to Display Table of Contents >>

Navigation:  Professional > Interfaces > Graphics Interfaces > Rockworks >

EQuIS for RockWorks - Mapping Document

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Location

Name

DT_LOCATION

SYS_LOC_CODE

 

Yes

 

Symbol

RT_SYMBOL

SYMBOL_CODE

STATUS_FLAG = 'A' AND APP_CODE = 'RW2002' AND PLACE_TYPE = 'SYS_LOC_CODE,' if null '5/16,711,680'

No

 

Easting

VW_LOCATION

X_COORD

 

Yes

 

Northing

VW_LOCATION

Y_COORD

 

Yes

 

Total Depth

VW_LOCATION

TOTAL_DEPTH

Depends on selection of Location Depth or well depth

Yes

 

Total Depth

DT_WELL

DEPTH_OF_WELL

Depends on selection of Location Depth or well depth

 

 

Longitude

DT_COORDINATE

X_COORD

COORD_TYPE_CODE like %long%

No

 

Latitude

DT_COORDINATE

Y_COORD

COORD_TYPE_CODE like %lat%

No

 

Range

DT_LOCATION_PARAMETER

PARAM_VALUE

PARAM_CODE = 'Range'

No

 

Township

DT_LOCATION_PARAMETER

PARAM_VALUE

PARAM_CODE = 'Township'

No

 

Section

DT_LOCATION_PARAMETER

PARAM_VALUE

PARAM_CODE = 'Section'

No

 

Legal Description

DT_LOCATION_PARAMETER

PARAM_VALUE

PARAM_CODE = 'Fraction'

No

 

Meridian

 

 

 

 

 

API Number

 

 

 

 

 

Comments

 

 

 

 

 

 

Field in Rockworks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Orientation

depth

DT_LITHOLOGY

START_DEPTH

 

No

 

Azimuth

DT_LITHOLOGY

bearing

 

No

 

Inclination

DT_LITHOLOGY

plunge

 

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Lithology

Depth to Top

FN_LITHOLOGY
DT_LITHOLOGY

START_DEPTH

 

Yes

 

Depth to Base

FN_LITHOLOGY
DT_LITHOLOGY
DT_LOCATION

END_DEPTH
(in DT_LITHOLOGY)
Final End Depth is from DT_LOCATION.TOTAL_DEPTH

 

Yes

 

Keyword

FN_LITHOLOGY
DT_LITHOLOGY

MATERIAL_NAME

 

Yes

 

Comment

FN_LITHOLOGY
DT_LITHOLOGY

REMARK_1 /REMARK_2

Depends


 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Stratigraphy

Depth to Top

FN_LITHOLOGY
DT_LITHOLOGY

START_DEPTH

 

Yes

 

Depth to Base

FN_LITHOLOGY
DT_LITHOLOGY
DT_LOCATION

END_DEPTH
(in DT_LITHOLOGY)
Final End Depth is from
DT_LOCATION.TOTAL_DEPTH

 

Yes

 

Formation

FN_LITHOLOGY
DT_LITHOLOGY

GEO_UNIT_CODE_1 GEO_UNIT_CODE_2 GEO_UNIT_CODE_3 GEO_UNIT_CODE_4 GEO_UNIT_CODE_5

Depends on selection of

geounitcode.

No

 

 

Note: There are five geologic unit fields in DT_LITHOLOGY: GEOLOGIC_UNIT_CODE_1 through GEOLOGIC_UNIT_CODE_5.  In order for these to be selectable in the Stratigraphy section of EQuIS for RockWorks, RT_GEO_UNIT_TYPE must be populated as shown below.  EQuIS for RockWorks will display the 5 records, but only one can be chosen for export.

 

15135-RW_GeoUnitType

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

I-Data

Depth to Top

Analytical Results Report / Sample Parameter Report

START_DEPTH

Crosstab

No

 

Depth to Base

Analytical Results Report / Sample Parameter Report

END_DEPTH

 

No

 

Analyte

Analytical Results Report / Sample Parameter Report

REPORT_RESULT_VALUE

 

No

 

Notes:

The T-Data/I-Data tabs in the EQuIS for RockWorks interface No longer separate out analytes by differing detection limits into separate columns in RockWorks.

Also, the interface now labels the columns more clearly to enable folks to export both groundwater data and soil data at the same time.

Note that you will only be able to model one matrix (either groundwater or soil) at a time, but you will now be able to export both simultaneously and very easily.

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

T-Data

Depth to Top

Analytical Results

START_DEPTH

Crosstab

No

 

Depth to Base

Analytical Results

END_DEPTH

 

No

 

Sample Date

Analytical Results

SAMPLE_DATE

 

No

 

Analyte

Analytical Results

REPORT_RESULT_VALUE

 

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

P-Data

Depth

DT_DOWNHOLE_POINT_DATA

depth

Crosstab

No

 

downhole Point Data

DT_DOWNHOLE_POINT_DATA

PARAM_VALUE

 

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Fractures

Depth

DT_WELL_SEGMENT

START_DEPTH

 

No

 

Azimuth

DT_LITHOLOGY

BEARING

 

No

 

Inclination

DT_LITHOLOGY

PLUNGE

 

No

 

Radius

DT_WELL_SEGMENT

OUTER_DIAMETER

 

No

 

Aperture

DT_WELL_SEGMENT

THICKNESS

 

No

 

Color

DT_LITHOLOGY

COLOR

Null values default to 0 (Black) when exported. See RockWorks documentation for additional information on color values.

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Water Levels

Date of Sample

Water Level Report

MEASUREMENT_DATE

 

No

 

Depth to Top

Water Level Report

WATER_DEPTH

 

No

 

Depth to Base

Water Level Report

WATER_DEPTH

 

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Symbols

Depth

DT_WELL_SEGMENT

START_DEPTH

 

No

 

Caption

DT_WELL_SEGMENT

SEGMENT_TYPE

 

No

 

Symbol

RT_SYMBOL

SYMBOL_CODE

 

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Patterns

Depth to Top

DT_WELL_SEGMENT

START_DEPTH

 

No

 

Depth to Base

DT_WELL_SEGMENT

END_DEPTH

 

No

 

Pattern

RT_SYMBOL OR DT_WELL_SEGMENT

SYMBOL_CODE

STATUS_FLAG = 'A' AND APP_CODE = 'RW2004' AND PLACE_TYPE = 'segment_type' and PLACE_CODE_TYPE = 'MATERIAL_TYPE_CODE,' if null '8/3.0/32,639/16,777,215'

No

 

Caption

DT_WELL_SEGMENT

SEGMENT_TYPE:MATERIAL_TYPE_CODE

segment_type and

MATERIAL_TYPE_CODE separated

by a ":"

No

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Bitmaps

 

Yet to implement

 

 

 

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Vector

 

Yet to implement

 

 

 

 

 

Field in Rockworks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Well

Construction

Depth to Top

DT_WELL_SEGMENT

START_DEPTH

 

No

 

Depth to Base

DT_WELL_SEGMENT

END_DEPTH

 

No

 

Outer Diameter

DT_WELL_SEGMENT

INNER_DIAMETER

 

No

 

Inner Diameter

DT_WELL_SEGMENT

OUTER_DIAMETER

 

No

 

Material

DT_WELL_SEGMENT

SEGMENT_TYPE:MATERIAL_TYPE_CODE

SEGMENT_TYPE and

MATERIAL_TYPE_CODE separated

by a ":"

No

 

Offset

DT_WELL_SEGMENT

 

 

 

 

Caption

DT_WELL_SEGMENT

SEGMENT_TYPE:MATERIAL_TYPE_CODE

SEGMENT_TYPE and

MATERIAL_TYPE_CODE separated

by a ":"

 

 

 

Field in RockWorks

EQuIS Table, View or Function

EQuIS Field

Notes

Required

Utilities

SYS_LOC_CODE

Analytical Results

SYS_LOC_CODE

Crosstab

No

 

START_DEPTH

Analytical Results

START_DEPTH

 

No

 

END_DEPTH

Analytical Results

END_DEPTH

 

No

 

ANALYTE

Analytical Results

REPORT_RESULT_VALUE

All the analytes seen in the crosstab for the utilities tab are exported to RockWorks.

No