Locations

<< Click to Display Table of Contents >>

Locations

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.