<< 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 |
START_DEPTH |
|
Yes |
|
Depth to Base |
FN_LITHOLOGY |
END_DEPTH |
|
Yes |
|
Keyword |
FN_LITHOLOGY |
MATERIAL_NAME |
|
Yes |
|
Comment |
FN_LITHOLOGY |
REMARK_1 /REMARK_2 |
Depends |
|
Field in RockWorks |
EQuIS Table, View or Function |
EQuIS Field |
Notes |
Required |
---|---|---|---|---|---|
Stratigraphy |
Depth to Top |
FN_LITHOLOGY |
START_DEPTH |
|
Yes |
|
Depth to Base |
FN_LITHOLOGY |
END_DEPTH |
|
Yes |
|
Formation |
FN_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.
|
|
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 |
Copyright © 2023 EarthSoft, Inc • Modified: 02 Apr 2020