Observations

 

 

Observations

Each record in the Observations table records a single measurement at a specified location and interval.

 

Field Name

Description

Data Type

Must be Populated?

Location

Unique location id

Text String

Yes

Interval

Text string used to identify the vertical interval of a measurement location. 

Text String

Yes

SampleID

Text String used to identify a unique sample.  This value would typically be shared by other Observation records that are derived from the same sample

Text String

No

Date

Measurement date.  May include time as well.

Date - Time

Yes

Value

Measured value.

Numeric - Floating Point

Yes

Formatted Value

Text string used in data table or posted values in place of numeric value from the Value field. This is useful for those cases where you want the reported value to appear in the identical format as reported by the lab.   If are using Microsoft Excel to store your data then if the value in this field is a numerical value then make sure to add a single apostrophe before the number so that Excel will treat it as a text string.

Text String

No

Constituent

Name of measured parameter

Text String

Yes

Media

Media in which measurement is made.  There must be a record in the Constituents table that corresponds to the constituent-media pair in every record of the Observations table.

Text String

Yes

Fraction

Indicates fraction, principally for metals, which can be measured as either total or dissolved.

Text String

Yes

Flag

Qualifier flag as reported by lab.  ND or < used to indicate a non-detect value in a post value or classed post plot.

Text String

No

Detection Limit

Detection limit value

Numeric - Floating Point

No

Non-Detect

Boolean field indicating whether a row contains a non-detect value.

Boolean (TRUE or False) in Excel

No – presumed false if left null

Duplicate

Boolean field indicating whether a row contains the value of a field duplicate

Boolean (TRUE or False) in Excel

No – presumed false if left null

 

The Location / Interval pair in an Observations record must correspond to a record in the Intervals data table and the Constituent / Media / Fraction must correspond to a record in the Constituent data table.

 

Non-Detects - Place TRUE in the non-detect field to indicate that the observation is a non-detect.  Posted values and classed post plots will show "ND" as the value, unless you have elected to plot the mean value and at least one of the values is not a non-detect. In that circumstance, the mean will be calculated based on the value in the data field. Tabulated values will post "<" and the detection limit.  If no detection limit has been specified then it simply use "ND". Contours, time history charts, pie charts and radial diagrams are generated using the numeric value in the Value field. You may elect to put in a value that is some fraction of the detection limit or simply put in a zero value.