Data Dictionary



  
  

Export to Excel

Field Name Description Size Type Requirements Examples and Guidance Active
Ecology Program or other Responsible Entity Name of the Ecology program and region OR external entity under which a Study was conducted. 30 Alphanumeric. Valid Values. REQUIRED;

Ex. "Ecy Toxics Cleanup Program, Southwest Region" or "Ecy Water Quality Program, multi-region or statewide"


Pick a valid value from the drop-down list in the Study form.

If Pollution Liability Insurance Agency (PLIA) Ecology Contact is not required.

Y
Ecology Region The Ecology Region where the Location exists. 50 Alphanumeric. Valid Values. System-generated; Y
Ecoregion III

Ecoregions are geographic areas defined by distinct physical geographic characteristics. These areas can be used to organize ecology and climate information expected in a specific region. Washington State boundaries enclose or overlap nine defined Level III Ecoregions.

Searching by one or more of these regions will return all sites that fall within the selected region(s) and fall within Washington State.

50 Alphanumeric. Valid Values. Administrative;

Valid Values:

  • Coast Range (1)
  • Puget Lowland (2)
  • Willamette Valley (3)
  • Cascades (4)
  • Eastern Cascade Slope and Foothills (9)
  • Columbia Plateau (10)
  • Blue Mountains (11)
  • Northern Rockies (15)
  • North Cascades (77)

See a map and list Washington State Level III and IV Ecoregions here: http://ecologicalregions.info/data/wa/wa_eco.pdf

Y
Ecoregion IV

Ecoregions are geographic areas defined by distinct physical geographic characteristics. These areas can be used to organize ecology and climate information expected in a specific region. Washington State intersects ninety-nine defined Level IV Ecoregions.

Searching by one or more of these regions will return all sites that fall within the selected region(s). Level IV Ecoregions are subdivisions of Level III Ecoregions.

50 Alphanumeric. Valid Values. Administrative;

Ex. "Coastal Lowlands" (1a)


See a map and list Washington State Level III and IV Ecoregions here: http://ecologicalregions.info/data/wa/wa_eco.pdf

Y
EIM Data Entry Review Status

Indicates if data loaded into EIM has undergone a documented review for accuracy and completeness of data entry. The review process varies by environmental program within Ecology.

This field differs from the QA Assessment Level, which is a rank of overall data quality according to Study-specific quality assurance procedures.

15 Alphanumeric. Valid Values. REQUIRED FOR;Ecology staff only

Valid Values:

Reviewed - Data loaded into EIM has undergone a documented review for accuracy and completeness of data entry.

Not Reviewed - Data loaded into EIM has NOT undergone a documented review for accuracy and completeness of data entry.

This field is for internal use only and is not available for external data submitters. All studies loaded to EIM by external partners default to "Not Reviewed." If the receiving program at Ecology has a documented EIM data review process, the EIM data coordinator who loads the study into EIM can set the Status to "Reviewed" if and when appropriate.

An Ecology program that does not have a documented EIM data entry review process should choose "Not Reviewed" when entering a study. A program that has a documented process should follow their guidance to determine when the study's EIM Data Entry Review Status should be set to "Reviewed."

Y
EIM Suspect Data Category A flag assigned by the EIM data quality coordinator to indicate suspect or rejected data as a result of a periodic EIM data quality review. Suspect Data Codes are also assigned to indicate the general nature of the problem. There can also be a Suspect Data Comment that provides additional information. 50 Alphanumeric. Valid Values. Administrative;

Valid Values:

  • Suspect
  • Reject
Y
EIM Suspect Data Code A code assigned by the EIM data quality coordinator to indicate the nature of the problem with data flaged as suspect or rejected. This occurs as a result of a periodic EIM data quality review. There can also be a Suspect Data Comment that provides additional information. 50 Alphanumeric. Valid Values. Administrative; Method/Parameter Mismatch Y
EIM Suspect Data Comment Comment by the EIM data quality coordinator about suspect or rejected data providing additional infomation about the nature of the problem. This occurs as a result of a periodic EIM data quality review. It is accompanied by an EIM Suspect Data Category and Code. 2000 Alphanumeric. Free Text. Administrative; Y
Elevation The distance of a field location above or below a vertical reference point. In feet or meters. 12 Numeric. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Note: This is the elevation of the point specified in column AH (Elevation of).

Marine and freshwater sediment surface (or mudline) elevations are measured relative to a reference point like mean sea level (field AN).  They are often (but not always) negative values.  Ex. "-7.2"

Valid Values:

-9999999.999
           to
0000000.000
           to
9999999.999

Y
Elevation Accuracy Best estimate of elevation accuracy at a field location. 2 Numeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values:

 1  ± 0.1 ft (0.03 m)
 2  ± 1 ft (0.3 m)
 3  ± 3 ft (1 m)
 4  ± 10 ft (3 m)
 5  ± 20 ft (6 m)
 6  ± 40 ft (12 m)
 7  ± 100 ft or greater (30 m)

Y
Elevation Collection Method The method used to measure elevation at a field location. 2 Numeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values:

 2   Survey - conventional   
 4   GPS consumer unit or unknown (code phase)
13  GPS high-end consumer unit (DGPS or WAAS enabled)
 5   GPS survey-grade (carrier    phase)
 6   GPS real time survey-grade    (kinematic)
 3   Digital elevation model (DEM) - sourceunspecified
12  Digital elevation model (DEM) - lidar
 1   Bathymetric sounding
14  Meter wheel
 8   Paper map interpolation    

Y
Elevation Datum Vertical reference point from which elevation was measured at a field location. 2 Numeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values:

1 - NAVD88 - N. American Vertical Datum of 1988


GPS unit = Check unit’s settings for datum.

Google Earth and EIM Map = NAVD88

Local datum = You must convert your elevation data to NAVD88 if you used another datum, including local datums.  Download help for “Converting Local Elevation Datums to NAVD88.”

For sediment elevations, leave this field blank. See Sediment Elevation Reference (Column AN)

Y
Elevation of Point at which the elevation at a field location was measured. 50 Alphanumeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemisty data only

Valid Values:

  • Land Surface
  • Top of Well Casing
  • Well Water Level Measuring Point
  • Sediment Surface

If you choose Land Surface, Well Water Level Measuring Point or TOC Height (AQ) is required.

Use “Well Water Level Measuring Point” only if your measuring point is not the top of casing (like an access port).

Y
Elevation Range

Land surface elevation is determined for each location in Watershed Health Monitoring (WHM) during site selection.

Searching via a specific elevation range will only return sites that have elevations within your selected range.

0 Not a Field (information or instruction) Informational; 0 to 5000 meters Y
Elevation Reference / Sediment Elevation Reference The reference point used to calculate the elevation of a field location OR reference point for the depth (elevation) of a marine or freshwater sediment field location. 2 Numeric. Valid Values. REQUIRED ONLY FOR;marine or freshwater sediment locations with elevation specified in the Elevation field.

For data entry, do not fill this out unless the location is a sediment location (marine or freshwater). All other elevations entered into EIM are auto-populated with 11, Standard Vertical Datum.

If you used a reference point not listed here, contact your Data Coordinator.

Valid Values:

1  Mean Sea Level (MSL)
2  Mean High Water (MHW)
3  Columbia River datum (CRD)
4  Lake Washington Ship Canal Datum (LWSC)
5  Mean Lower Low Water (MLLW)
6  Minimum Operating Pool (MOP)
14 Lake Washington Low Water (LWLW)

Y
Elevation Units Units in which the elevation of a field location is expressed. 2 Alphanumeric. Valid Values. REQUIRED for WELLS;except for EIWs with GW chemistry data only

Valid Values:

FT  feet
M   meters

Y
Field Collection Area

The area in which the collection of field data occurred.

For benthic macroinvertebrate (e.g. kick-net area) and periphyton (surface area of substrate scraped) count data.

Also for spatial composite samples.

10 Numeric. REQUIRED FOR;macro-invertebrate and periphyton counts.

Ex. "8.20"

Download help for “Periphyton Counts”

Download help for "Benthic Organism Counts - Freshwater"

Download help for "Benthic Organism Counts - Marine"

Y
Field Collection Area Units Units of measure associated with Field Collection Area. 10 Alphanumeric. Valid Values. REQUIRED IF;Field Collection Area is populated

Valid values and descriptions:

ft2 - square feet

m2 - square meters

cm2 - square centimeters

Y
Field Collection Comment Comments or descriptive information about the collection of data in the field. 2000 Alphanumeric. Free Text. Optional;

Ex. "Cows in stream upgradient of sampling site"

You can enter only ONE Field Collection Comment per field collection event. Field collection event is defined as all Measurements collected at the same Location, from the same depth, on the same date, at the same time, with the same matrix and source OR all Samples collected at the same Location, from the same depth, on the same date, at the same time, with the same matrix and source, with the same Sample ID. In the case of Samples, this means you can only have one Field Collection Comment for each Sample ID. If you enter more than one Field Collection Comment per field collection event, EIM will only accept the first one loaded. All Results associated with a specific field collection event will have the same Field Collection Comment. If you want to comment about a particular result or group of results within a field collection event, enter it as a Result Comment or Result Additional Comment.

Download help for “How to Use EIM’s Comment fields.”

Y
Field Collection Date Accuracy Indicates how accurate the measurement date is. 1 Alphanumeric. Valid Values. REQUIRED;

Valid values and descriptions:

D - Day
M - Month
W - Week
Y - Year

Most values should be “D.”

For some older water level measurements, the day was not logged. In those cases the accuracy of the date provided in Field Collection Start Date can be indicated here.

Y
Field Collection Date Range The oldest (start) and most recent (end) field collection dates in a Study.  EIM calculates the range.  You can search by Field Collection Date Range. 10 Date. Format: MM/DD/YYYY. System-generated; 6/3/1997 - 3/26/1998 Y
Field Collection Depth Units Units of measure associated with the Field Collection Upper Depth and Field Collection Lower Depth. 10 Alphanumeric. Valid Values. REQUIRED FOR;results where Field Collection Upper and Lower Depth is populated.

Valid values and descriptions:

cm - centimeters,
m - meters,
in - inches,
ft - feet

Y
Field Collection End Date Date that field collection ended for a Study. Calculated using the last Field Collection Start Date from the Study's Result data. 10 Date. Format: MM/DD/YYYY. System-generated; Ex. "05/16/2010." Y
Field Collection End Date The date that data collection in the field ended. 10 Date. Format: MM/DD/YYYY. Optional;

Ex. "06/23/1999"

Leave blank for discrete samples.

Only for data collection that took place over time, such as for temporal composites and other special cases.

Y
Field Collection End Date/Time The concatenated date and time that data collection in the field ended. This is system-generated from Field Collection End Date and Field Collection End Time. 20 Date/Time. Format: MM/DD/YYYY HH:MM:SS (24-hour). System-generated; Ex. "03/23/2003 16:39:04" Y
Field Collection End Time Time that field data collection ended, in local time. EIM automatically assigns time zone (PDT or PST) based on Field Collection End Date. 8 Time. Format: HH:MM:SS (24-hour). Optional;

Ex. "15:22:14"

Only for data collection took place over time, such as for temporal composites and other special cases.

Y
Field Collection Lower Depth

Distance from Reference Point to lower boundary where field data was collected.

Positive values represent depths below reference point.

Negative values represent distance above reference point.

If a discrete sample is collected at one depth, Upper and Lower Depth are the same value.

10 Numeric. REQUIRED FOR;Sediment, sediment porewater, and soil data; Chemistry data from EIWs; Water column profile data

Ex. Composite Sample: "7.5" if soil sample was taken between 5 and 7.5 feet below land surface. 

Ex. Discrete Sample: "5" if soil sample was taken 5 feet below land surface.

Download help for “Entering Field Collection Depth or Height.”

Things that do NOT go in this field:

Y
Field Collection Reference Point

Point from which the collection depth of the field data was measured.

30 Alphanumeric. Valid Values. REQUIRED FOR;­Sediment, sediment porewater, and soil data; Chemistry data from Temporary Environmental Investiga

Valid values:

Land Surface
Water Surface
Sediment Surface
Floor of Structure

Y
Field Collection Start Date Date that field collection began for a Study. Calculated using the first Field Collection Start Date from the Study's Result data. 10 Date. Format: MM/DD/YYYY. System-generated; 10/22/2009 Y
Field Collection Start Date Date that field collection began. 10 Date. Format: MM/DD/YYYY. REQUIRED; Ex. "06/23/1999" Y
Field Collection Start Date/Time Date and time that field collection began. 19 Date/Time. Format: MM/DD/YYYY HH:MM:SS (24-hour). System-generated; 06/15/1996 13:24:30 Y
Field Collection Start Time Time that field data collection began, in local time. EIM automatically assigns time zone (PDT or PST) based on Field Collection Start Date. 8 Time. Format: HH:MM:SS (24-hour). REQUIRED IF available; Ex. "15:22:14" Y
Field Collection System ID A unique, system-generated ID assigned by EIM to each data collection event. 10 Numeric. System-generated; Ex. "348745" Y
Field Collection Type General type of data collection conducted in field. 11 Alphanumeric. Valid Values. REQUIRED;

Valid Values:

  • Sample - discrete sample collected in the field that is sent to a lab for analysis.
  • Measurement – discrete data collected in the field (in-situ) using an instrument, like pH meter
  • Observation - record of an unsuccessful measurement or sampling attempt.
  • QC Blank - lab method blank data for uncorrected low-level PCB congeners by EPA1668C, B, or A and MEL730138 v1.0.

Measurements are collected in-situ. If you removed environmental media and analyzed it in a secondary location, such as a vehicle, enter as a Sample and enter a Result Lab Name (BC) of “Mobile lab at data collector field site.”

For Observations, use only if a sample or measurement was planned or required but not obtained. Download help for "Entering Observations."

For Time-Series data, (deployed instrument that collected continuous measurements) use the Time-Series Template.

Download help for “Low-Level PCB Congener Data.”

Y
Field Collection Upper Depth

Distance from Reference Point to upper boundary where field data was collected.

Positive values represent depths below reference point.

Negative values represent distance above reference point.

If a discrete sample is collected at one depth, Upper and Lower Depth are the same value.

10 Numeric. REQUIRED FOR;Sediment, sediment porewater, and soil data; Chemistry data from Temporary Environmental Investigat

Ex. Composite Sample:  "5" if soil sample was taken between 5 and 7.5 feet below land surface.

Ex. Discrete Sample: "5" if soil sample was taken 5 feet below land surface.

Must be a number.

Download help for “Entering Field Collection Depth or Height.”

Things that do NOT go in this field:

Y
Field Collector Name or type of organization that collected the data. 15 Alphanumeric. Valid Values. REQUIRED;

Valid values and descriptions

Business - Business, Trained Staff
ConsDistrict - Conservation District
Consultant - Consultant, Professional
Ecology - WA Dept of Ecology
GovFed - Government, Misc Federal
GovLocal - Government, Misc Local
GovState - Government, Misc State
GovTribal - Government, Tribal
HealthLocal - Health Dept, Local
HealthState - Health Dept, State
NGO - Non-Governmental Organization
NOAA - National Oceanic and Atmospheric Administration
UNIVERSITY - University
USACE - US Army Corps of Engineers
USEPA - US Environmental Protection Agency
USGS - US Geological Survey
USNPS - US National Parks Service
UtilityPrivate - Utility, Private
UtilityPublic - Utility, Public
Volunteer - Volunteer, Trained
WDFW - WA Dept of Fish and Wildlife
WDNR - WA Dept of Natural Resources
WellDriller - Well Driller
WellOwner - Well Owner

Y
Field Filtered Flag Indicates if a sample was filtered in the field (not the lab). 1 Alphanumeric. Valid Values. REQUIRED IF;Fraction Analyzed is Dissolved

Valid Values:

  • Y - Yes
  • N - No
  • U - Unknown

Document filtration method in Sample Preparation Method field (Column AB).

Important for groundwater samples.

Y
Fraction Analyzed

Indicates the fraction (total, dissolved, or suspended) of an aqueous sample that was analyzed, unless Sample Source is Plant Tissue, Freshwater Taxonomy or Salt/Marine Taxonomy.

Also includes analyses performed on lab-generated leachates derived from solid samples.

15 Alphanumeric. Valid Values. REQUIRED FOR;Samples with Sample Matrix of “Water,” unless Sample Source is “Freshwater Taxonomy” or “Salt/Marin

Valid Values:

  • Dissolved
  • Total
  • Suspended
  • Lab Leachate
Y
Groundwater Location Type The primary use or type of well or monitoring location. 50 Alphanumeric. Valid Values. REQUIRED for WELLS;

Download help for "Temporary Environmental Investigation Wells"

Dewatering Well
Geothermal Well
In-Water Piezometer
Injection Well - ASR
Injection Well - Carbon Sequestration
Injection Well - Remediation
Irrigation Well
Monitoring Well
Pumping Well - Remediation

Soil Gas Probe
Stockwater Well
Temporary Well - EIW
Water Supply Well - Domestic
Water Supply Well - Industrial
Water Supply Well - Public
Other

Y
Help Field Active Flag Flag to indicate if a help field is active or not. 2 Alphanumeric. Valid Values. REQUIRED;

Valid Values:

  • Y - Yes
  • N - No
Y
Help Field Description A description of the help field. 4000 Alphanumeric. Free Text. REQUIRED; Y
Help Field Example An example for the help field. 4000 Alphanumeric. Free Text. Optional; CAS Number for Arsenic: 7440-38-2. Y
Help Field ID The unique identifier assigned by EIM when a help field is entered into the system. 10 Numeric. System-generated; Y
Help Field Name The name of the help field. 100 Alphanumeric. Free Text. REQUIRED; Y
Help Field Specification

Denotes the database specifications for the help field, including format (alphanumeric, date, etc.), maximum field size, whether required or other, and valid values or other.

1024 Alphanumeric. Valid Values. System-generated; Y
Horizontal Coordinate Accuracy Best estimate of horizontal coordinate accuracy for a field location. 2 Numeric. Valid Values. REQUIRED;

Valid Values:

1  ± 0.1 ft (0.03 m)
2  ± 1 ft (0.3 m)
3  ± 3 ft (1 m)
4  ± 10 ft (3 m)
5  ± 20 ft (6 m)
6  ± 40 ft (12 m)
7  ± 100 ft (30 m)
8  ± 180 ft (55 m)
9  ± 250 ft (76 m)
10  ± 500 ft (152 m)
11  ± 1000 ft or greater (300 m)

Y
Horizontal Coordinate Collection Method Method used to collect the horizontal coordinates for a field location. 2 Numeric. Valid Values. REQUIRED;

Valid Values:

8    Survey - conventional
13  Computer map (GIS-based, including EIM or Google Earth)
16  GPS consumer unit or unknown (code phase)
29  GPS high-end consumer unit (DGPS or WAAS enabled)
15  GPS survey-grade unit (carrier phase)
17  GPS real time survey-grade (kinematic)
19  Paper map interpolation

Y
Horizontal Coordinates Represent General description of what the COORDINATES represent. 2 Numeric. Valid Values. REQUIRED;

Valid Values:

24 Discrete monitoring point
25 Centroid of monitoring area
26 Stream segment, can include riparian zone
27 Transect, start point
28 Transect, center point

For coordinates that do not represent a discrete monitoring point (25-28), use the Location Description field (Column D) to describe the monitoring area, stream segment, or transect where data were collected.

26 applies to a length of stream segment. Only use it when you are collecting data from multiple points within a stream segment and you want all those data to be associated with a single EIM location. It is most commonly used for habitat data.

Y
Horizontal Datum Model used to project the horizontal position of the field location to a map. 2 Numeric. Valid Values. REQUIRED;

Valid Values:

2  NAD83 - N. American Datum of 1983
3  NAD83HARN - High Accuracy Reference Network
4  WGS84 - World Geodetic System of 1984

Common datums:

GPS Unit = Check unit’s settings for datum

EIM Map = NAD83HARN

Google Earth = WGS84

Locations using Washington State Plane Coordinate System (SPCS) should only use NAD83 or NAD83HARN.

Y
Inactive / Mark for Delete Way to suspend an outdated or incorrect parameter, method, taxon, or lab from further use. These entries are sometimes later deleted if data cleanup allows them to be. 1 Alphanumeric. Valid Values. Administrative; Y
Page 2 of 7    <<--    <-    ->    -->>
338 records