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:
|
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: 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
|
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
|
338 records
|