WA EIM Field Name

EIM Datatype

EQuIS Mapping

Sort Order

Remap

EQuIS Notes

Order

Location_ID

varchar(15)

dt_location.sys_loc_code

1

Users will need to post process their data. Note that EIM field is varchar(15) and EQuIS field is varchar(20). Make sure this data does not get truncated.

A

Location_Name

varchar(40)

dt_location.loc_name

2

B

Location_Setting

varchar(30)

No Mapping

3

Import/Export: EIM enumeration lookup list.

See Location Setting tab

C

Location_Description

varchar(20000)

dt_location.loc_desc

4

EQuIS field is varchar(255)

D

Ecology_FacilitySite_ID

varchar(10)

No Mapping

5

Check this mapping for import/export

E

Is_Location_A_Well

varchar(1)

Conditional: If sys_loc_code exist in dt_well,

populate with "Y", therwise, populate with "N"

6

If "N" then Well Only fields should not be populated by the export

F

Address

varchar(200)

No Mapping

7

G

City

varchar(40)

No Mapping

8

H

State

varchar(2)

dt_location.loc_state_code

9

I

Zip_Code

varchar(10)

No Mapping

10

J

County

varchar(20)

dt_location.loc-county_code

11

K

NHC_Reach_Code

numeric(14)

No Mapping for report/export

See EQuIS notes for import/export mapping

12

L

NHD_Reach_Measure

decimal

dt_location.stream_mile

13

For Import/Export we may want to make this a conditional mapping based on Location Setting

M

Coordinate_System

varchar(8)

dt_coordinate.coord_type_code

Only one set of coordinates will be exported

See EQuIS notes

14

Y

Add remap to EIM coord_type. Only one set of coordinates will be exported. If more than one dt_coordinate.coord_type_code exists, remap will be set up to only export one set of coord_type values

N

Latitude_Degrees

integer(2)

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

15

O

Latitude_Minutes

integer(2)

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

16

P

Latitude_Seconds

decimal

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

17

Q

Longitude_Degrees

decimal

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

18

R

Longitude_Minutes

integer(2)

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

19

S

Longitude_Seconds

integer(2)

No Mapping - EQuIS reports LAT/LONG values

in degrees decimal

20

T

Latitude_Decimal_Degrees

decimal

y_coord if dt_coordinate.coord_type_code ="LAT/LONG"

21

U

Longitude_Decimal_Degrees

decimal

x_coord if dt_coordinate.coord_type_code = "LAT/LONG"

22

V

State_Plane_X_Coordinate

decimal

x_coord if dt_coordinate.coord_type_code ="SPCS"

23

W

State_Plane_Y_Coordinate

decimal

y_coord if dt_coordinate.coord_type_code = "SPCS"

24

X

State_Plane_Zone

varchar(1)

dt_coordinate.coord_zone

25

enum: N or S

Y

UTM_Easting

decimal

x_coord if dt_coordinate.coord_type_code = "UTM"

26

Z

UTM_Northing

decimal

y coord if dt_coordinate.coord_type_code = "UTM"

27

AA

UTM_Zone

numeric(2)

dt_coordinate.coord_zone

28

enum; 10 or 11

AB

Horizontal_Coordinates_Represent

numeric(2)

dt_coordinate.reference_point

29

Y

Report/Export: remap

Import/Export: enum: coord_represent

AC

Horizontal_Datum

numeric(2)

dt_coorinate.horz_datum_code

30

Y

Report/Export: remap

Import/Export: enum: horz_datum

AD

Horizontal_Coordinate_Accuracy

numeric(2)

dt_coordinate.horz_accuracy_value

Import only: dt_coordinate.horz_accuracy_unit = "m"

31

Y

Report/Export: remap

Import/Export: enum: horz_accuracy

AE

Horizontal_Coordinate_Collection_Method

numeric(2)

dt_coordinate.horz_collect_method_code

32

Y

Report/Export: remap

Import/Export: enum: horz_collect_method

AF

Paper_Map_Scale

numeric(2)

dt_coordinate.source_scale

33

Y

Report/Export: remap

Import/Export: enum: map_scale

AG

Elevation_of

varchar(50)

Conditional: report/export - If "Is_Location_A_Well=Y",

default to "Top of Well Casing"

See EQuIS Notes for import/export mapping

34

Import/Export: No database mapping. If "Is_Location_A_Well = Y", and "Elevation of" = "Top of Well Casing" then the following fields are required: Elevation, Elevation Units, Elevation Datum, Elevation Accuracy, Elevation Collection Method, GroundLocation Type, Well Completion Depth, Well Completion Depth Unit, Well Completion Type

AH

Elevation

decimal

dt_well.top_casing_elev

35

Import/Export - Conditionally Required (see EQuIS "Elevation of" notes)

AI

Elevation_Units

varchar(2)

dt_location.unit

36

enum: FT or M

Import/Export - Conditionally Required

See EQuIS notes for "Elevation of"

AJ

Elevation_Datum

numeric(2)

dt_coordinate.elev_datum_code

37

Import/Export - Conditionally Required

See EQuIS notes for "Elevation of"

AK

Elevation_Accuracy

numeric(2)

dt_coordinate_.elev_accuracy_value

38

Y

Import/Export: EIM enumeration lookup list

Import/Export - Conditionally Required

See EQuIS notes for "Elevation of"

AL

Elevation_Collection_Method

numeric(2)

dt_coordinate.elev_colllect_method_code

39

Y

Import/Export: EIM enumeration lookup list

Import/Export - Conditionally Required

See EQuIS notes for "Elevation of"

AM

Sediment_Elevation_Reference

numeric(2)

No Mapping

40

Import/Export: EIM enumeration lookup list

AN

Well_Water_Level_Measuring_Point_or_TOC_ID

varchar(8)

Conditional: report/export - If "Is_Location_A_Well=Y",

default to "TOC1"
See EQuIS notes for import/export mapping

41

Import/Export - Conditionally Required

See EQuIS notes for "Elevation of"

Need to add import/export logic for VVs: MP1, MP2, TOC1, TOC2

enum: TOC_ID

AO

Well_Water_Level_Measuring_Point_or_TOC_Description

varchar(40)

No Mapping

42

AP

Well_Water_Level_Measuring_Point_or_TOC_Height

numeric

dt_well.stickup_height

43

Import/Export - need to add logic for conditionally require field

AQ

Well_Water_Level_Measuring_Point_or_TOC_Height_Units

varchar(2)

dt_well.stickup_unit

44

No conversion for import/export - WA_EIM only accepts "ft" or "m". May need conversion to ft or m, conversion would apply to value in dt_well.stickup_height

Import/Export - need to add logic for conditionally require field

AR

Well_Water_Level_Measuring_Point_or_TOC_Start_Date

date(mm/dd/yy)

No Mapping for report/export.
See EQuIS notes for import/export mapping

45

Import/Export mapping: dt_measured_datum.start_date

AS

Well_Tag_ID

varchar(6)

dt_well.well_id

46

The Washington Department Ecology Well Tag ID

AT

Well_Owner_Organization_Name

varchar(50)

dt_well.well_owner

47

AU

Well_Owner_Last_Name

varchar(50)

No Mapping

48

AV

Well_Owner_First_Name

varchar(50)

No Mapping

49

AW

Groundwater_Location_Type

varchar(30)

dt_location.loc_type_2

50

Y

Import/Export: EIM enumeration lookup list

AX

Well_Completion_Depth

decimal

dt_well.depth_of_well

51

AY

Well_Completion_Depth_Units

varchar(2)

dt_well.depth_unit

52

FT or M

AZ

Well_Completion_Type

varchar(30)

dt_well.head_configuration

53

Y

Check mapping for Import/export

enum: head_configuration

BA

Well_Open_Interval_Upper_Depth

decimal

report/export: dt_well_segment.start_depth

If dt_well_segment.segment_type = "SCREEN"

54

Import/Export mapping: On import map to dt_well_segment.start_depth, default segment_type to "SCREEN" and if "Well Casing Material" is not populated default material_type_code to "SCREEN". On export, if dt_well_segment.segment_type = "SCREEN" export value in start_depth

BB

Well_Open_Interval_Lower_Depth

decimal

report/export: dt_well_segment.end_depth

If dt_well_segment.segment_type = "SCREEN"

55

Import/Export mapping: On import map to dt_well_segment.end_depth. This field should only be mapped if "Well_Open_Interval_Upper_Depth" is also populated, if not populated display eerror. On export, if dt_well_segment.segment_type = "SCREEN" export value in end_depth

BC

Well_Open_Interval_Units

varchar(2)

report/export: dt_well_segment.depth_unit

If dt_well_segment.segment_type = "SCREEN"

56

Import/Export mapping: On import map to ddt_well_segment.depth_unit. This field should only be mapped if "Well_Open_Interval_Upper_Depth" is also populated, if not display error. On export, if dt_well_segment.segment_type = "SCREEN" export value in depth_unit

BD

Well_Maximum_Casing_Diameter

decimal

report/export: dt_well_segment.outer_diameter

57

BE

Well_Maximum_Casing_Diameter_Units

varchar(2)

report/export: dt_well_segment.inner_diameter

58

CM or IN

BF

Well_Casing_Material

varchar(15)

report/export: dt_well_segment.material_type_code

59

Import/Export: EIM enumeration lookup list

BG

Well_Construction_End_Date

date(mm/dd/yy)

dt_well.construct_complete_date

60

BH

Well_Construction_Method

varchar(2)

No Mapping

61

enum: well_construction_method

Import/Export - map to dt_well.custom_field_1

BI

Well_Construction_Comment

varchar(20000)

dt_well.remark

62

BJ

Is_Well_Upgradient_Of_A_FacilitySite

varchar(1)

No Mapping for report/export

See EQuIS notes for import/export mapping

63

Y or N at _subfacility_location.gradient (this mapping needs review)

BK

Aquifier_Test_Conducted

varchar(1)

Conditional mapping: report/export - if there is a record in

dt_aquifer_test.sys_loc_code export "Y", if not, export "N"

64

Import/Export: On import if value = "Y" display warning = "No direct EQuIS mapping". On export, - if there is a record in dt_aquifer_test.sys_loc_code export "Y" if not export "N"

BL

Naturally_Flowing_Well

varchar(1)

No Mapping for report/export

See EQuIS notes for import/export mapping

65

Import/Export - dt_well.custom_field_2

Y or N

BM

Default Mappings

Default

Mapping

Notes:

Selection must include coord_type_code, location or location groups.

The well-related fields do not need to be populated if the location is not a well. Well-related fields are columns from Elevation_of to the last column.