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	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

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.

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	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	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