Data Dictionary



  
  

Export to Excel

Field Name Description Size Type Requirements Examples and Guidance Active
USGS Site Number US Geological Survey site monitoring number, from the National Water Information System (NWIS) database. Entered into EIM as a Location Alias. 40 AlphaNumeric 465033122570202 Y
UTM Easting Universal Transverse Mercator easting coordinate (X-axis) of the field location.In meters. 8 Numeric. Valid Values. REQUIRED FOR;UTM

Valid Values:

Zone 10:  350000.0  to  731300.0

Zone 11:  271250.0  to  518176.0

Y
UTM Northing Universal Transverse Mercator northing coordinate (Y-axis) of the field location.In meters. 9 Numeric. Valid Values. REQUIRED FOR;UTM

Valid Values:

Zone 10:  5042900.0  to  5454800.0

Zone 11:  5042930.0  to  5454795.0

Y
UTM Zone Universal Transverse Mercator zone of the field location. 2 Numeric. Valid Values. REQUIRED FOR;UTM

Valid Values:

10

11

Y
Warning(s) A value or values in a record does not match an EIM valid value or values. To view error details, click the "View Processed Records" button to bring up the dataset, and then click the "Warnings" link under "Submittal Status." Alternatively, you can click the "View Error Records" button to see all the error details at once. Although we would like these errors fixed, Warnings will not prevent the data submittal process from being considered complete. If you think a value with a Warning should be added to EIM, please contact your Data Coordinator. Instructional "Result Parameter Name you entered is not found in EIM." "Result Method you entered is not found in EIM." Y
Water Body Name Common name of a particular stream or river. 100 Alphanumeric. Valid Values. Administrative; Horn Creek, Puyallup River, Cowlitz River Y
Water Body Type

General classification of the water body being sampled. This water body type is confirmed and recorded as part of the STREAM field protocols.

Selecting a specific water body type will only return sites defined in the field as the selected type.

50 Alphanumeric. Valid Values. Administrative; River/Stream Y
Water Level Parameters Parameters specifically related to water levels in wells. 0 Not a Field (information or instruction) Informational; Y
Water Resource Inventory Area (WRIA) Washington State Water Resource Inventory Area (WRIA), typically a major watershed, in which the field Location exists. There are 62 WRIAs in Washington State. 2 Numeric. Valid Values. Administrative;

WRIA 12 - Chambers-Clover

Valid Values: 01-62

Look up WRIAs here:  https://ecology.wa.gov/Water-Shorelines/Water-supply/Water-availability/Watershed-look-up 

Y
Watershed

Equivalent to USGS Hydrologic Unit, 5th Level, 10-digit HUC. Land area where all surface and groundwater drains toward the same point.

Searching by watershed will only return sites within the selected watershed

50 Alphanumeric. Valid Values. Administrative; 1711001204-Lower Sammamish River Y
Well A monitoring Location that is a well. Well metadata contains details about well construction and use.(An EIM Location is the physical place where sample collection, measurements, or observations occur. It is uniquely identified by a Location ID and Location Name. Each Location is required to have a documented geographic position, reported by EIM as latitude and longitude values.) 0 Not a Field (information or instruction) Informational; Y
Well Casing Material Material from which the well casing is made. 15 Alphanumeric. Valid Values. Optional;

Valid Values:

  • Concrete
  • Iron
  • Plastic, other
  • PTFE/Teflon
  • PVC
  • Steel, other
  • Steel, Stainless
  • Other
Y
Well Completion Depth The depth of the completed well below land surface.In feet or meters. 5 Numeric. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Ex. "48.84"

Usually found on the well log.

Y
Well Completion Depth Units Units in which a Well Completion Depth is expressed. 5 Numeric. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values

FT Feet

M  Meters

Y
Well Completion Type The type of completion or nature of the openings that allow water to enter the well. 30 Alphanumeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values

Cased, Open Interval
Uncased, Open Interval
Cased, Open-Ended
Other

Y
Well Construction Comment Comments or other important information about the construction of a well. 2000 Alphanumeric. Free Text. Optional;

Ex. "Well constructed by owner-depth unknown"

Ex. "Log available, deepened from 180 to 263 ft"

Y
Well Construction End Date Date that well construction was completed. 10 Date. Format: MM/DD/YYYY. REQUIRED for WELLS IF;available Ex. "01/28/2000" Y
Well Construction Method The method used to create the borehole and construct the well. 2 Alphanumeric. Valid Values. REQUIRED for WELLS IF;available

Valid Values

  • AP  air percussion
  • AR  air rotary
  • BA  bored / augered
  • CT  cable tool
  • DR  driven / direct push
  • DU  dug
  • HR  hydraulic / mud rotary
  • JE   jetted
  • RR  reverse circulation rotary
  • SO  sonic
Y
Well Maximum Casing Diameter The diameter of the outermost permanent casing used to complete the well.In centimeters or inches. 5 Numeric. Optional;

Ex. "2.00"

Report the inner diameter of the well itself and not that of the outer protective casing.

Y
Well Maximum Casing Diameter Units Units in which Well Maximum Casing Diameter is expressed. 2 Alphanumeric. Valid Values. REQUIRED IF;Well Maximum Casing Diameter is reported

Valid Values:

IN - inches

CM - centimeters

Y
Well Open Interval Depth (Upper/Lower) Distance from the land surface to the top and bottom of the Well Open Interval. Open interval includes screens, perforations, etc.In feet or meters 0 Not a Field (information or instruction) Informational; Ex. "20 / 25 FT" Y
Well Open Interval Depth Units Units in which the Well Open Interval Upper and Lower Depth is expressed. 2 Alphanumeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values:

FT - feet

M - meters

Y
Well Open Interval Lower Depth Distance from land surface to the bottom of the Well Open Interval. Open interval includes screens, perforations, etc.In feet or meters. 10 Numeric. REQUIRED for WELLS IF;except for EIWs with GW chemistry data only

Ex. "25.0"

Usually depth to bottom of well screen. To include more information about this, use Well Construction Comment.

For open-ended wells, use Completion Depth for both Upper and Lower Depth

Y
Well Open Interval Upper Depth Distance from the land surface to the top of the Well Open Interval. Open interval includes screens, perforations, etc.In feet or meters. 10 Numeric. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Ex. "20.0"

Usually depth to top of well screen. To include more information about this, use Well Construction Comment.

For open-ended wells, use Completion Depth for both Upper and Lower Depth

Y
Well Owner First Name, Last Name, and Organization Name

The first and last name of the well owner and/or the organization to which the well belongs, if any.

This information is not made public.

50 Alphanumeric. Free Text. REQUIRED for WELLS IF;available

Ex.

First Name: "John"

Last Name: "Jones"

Organization Name: "City of Olympia"

Y
Well Tag ID

The unique Washington State Department of Ecology Well Tag ID, consisting of three letters and three numbers (e.g. ABC123).

The ID is stamped on an aluminum tag and typically affixed to the well by the driller at the time of construction or later by Ecology staff.  The ID is also included on the well log submitted by the driller. 

6 Alphanumeric. Free Text/Preferred Format. REQUIRED for WELLS IF;available

Format "AAB123"

Leave blank If you don’t have a valid well tag ID and it is not practical to get one.

Must be the unique number off the Ecology well tag attached to a well.  If a well is not tagged, tags are available from Ecology.

Because it is unique and recognized throughout Washington, the Well Tag ID is often used in EIM as the Location ID and the Location Name.

Y
Well Water Level Accuracy Indicates the estimated accuracy of a well water measurement. 3 Alphanumeric. Valid Values. REQUIRED FOR;well water level measurements

Valid Values:

Accuracy in feet
WL2  +0.01ft
WL1  +0.1ft
WL0  +1ft
WL6  >1ft


Y
Well Water Level Measuring Point / Top of Casing (TOC) The point from which the well water level was measured - usually top of casing (TOC). Metadata includes ID (MP1), elevation (for those who survey to TOC), height (in relation to land surface, such as 3 ft), description (TOC), and effective date. 0 Not a Field (information or instruction) Informational; Y
Well Water Level Measuring Point or TOC Description Description of the point on the well from which water levels are measured. Often top of well casing (TOC). 2000 Alphanumeric. Free Text. REQUIRED for WELLS;except for EIWs with GW chemistry data only Ex. "Top of casing, notch on north side" Y
Well Water Level Measuring Point or TOC Height Distance from the point where the water level was measured to the land surface. Often top of well casing (TOC) or synonymous with “casing stickup.” 5 Numeric. REQUIRED for WELLS IF;elevation is measured at land surface except for EIWs with GW chemistry data only

Ex. "2.8" (above ground)

Ex. "-0.5" (below ground) Measuring points below land surface are reported as negative values.

This is NOT the well ELEVATION – see the Elevation field (AI) for that.

Y
Well Water Level Measuring Point or TOC Height Units Units in which the Well Water Level Measuring Point or TOC Height is expressed. 2 Alphanumeric. Valid Values. REQUIRED for WELLS IF;Well Water Level Measuring Point or TOC Height is populated.

Valid Values:

FT  feet
M   meters

Y
Well Water Level Measuring Point or TOC ID ID for the point on the well where water levels are measured. 8 Alphanumeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Ex. "MP1," "TOC1"

Use value you submitted in the Location spreadsheet (Well Water Level Measuring Point or TOC ID). EIM uses this to tie water level depths to the well elevation in order to calculate water level elevation.You can also use the Water Levels te

Y
Well Water Level Measuring Point or TOC ID ID for the point on the well where water levels are measured. Often top of well casing (TOC). 8 Alphanumeric. Valid Values. REQUIRED FOR;except for EIWs with GW chemistry data only

Valid Values:

MP1 - measuring point - like an access port,
MP2 - use for a secondary measuring point,
TOC1 - use when you measure from top of casing,
TOC2 - use for a secondary measuring point at the top of casing or when the casing gets cut off

If the top of casing gets cut off or you have more than one measuring point, contact your EIM Data Coordinator for a new ID.

Y
Well Water Level Measuring Point or TOC Start Date Date on which the measuring point was first used. 10 Date. Format: MM/DD/YYYY. Optional; Ex. "10/22/1999" Y
Well Water Level Measuring Point or TOC System ID A unique, system-generated ID assigned to each Well Measuring Point by EIM when the record is inserted. 10 Numeric. System-generated; 3456789 Y
WQX Loaded Date/Time The date and time that a particular Study's data was sent to EPA's WQX (Water Quality eXchange) for loading into EPA's STORET data system. 19 Date/Time. Format: MM/DD/YYYY HH:MM:SS (24-hour). System-generated; 07/09/2013 Y
Zip Code Zip Code or Canadian Postal Code of the field Location’s physical address. 10 Alphanumeric. Format 98504 or 98504-7600 or V5K-0A Optional; 98513; 98513-2220; V0B-1H0 Y
Page 7 of 7    <<--    <-    ->  ->>
337 records