The QualityWater table contains data on nutrients and organic matter in water measured at Eurowaternet river monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the QualityWater data with their respective Stations and Pressure data.
Category
European data
Records
492752
Table definition
StandardDeviation
Standard Deviation
standard Deviation of concentration during aggregation period.
float(8)
0
10Percentile
10th Percentile
10th Percentile concentration during aggregation period.
float(8)
0
90Percentile
90th Percentile
90th Percentile concentration during aggregation period
float(8)
0
Minimum
Minimum
minimum concentration during aggregation period.
float(8)
0
Maximum
Maximum
maximum concentration during aggregation period.
float(8)
0
Median
Median
median concentration during aggregation period.
float(8)
0
LimitOfDetection
Limit Of Detection
concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected, i.e. there is a 95% probability that the determinand will be detected.
float(8)
0
LimitOfDetermination
Limit Of Determination
the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).
float(8)
0
Mean
Mean
average concentration during aggregation period.
float(8)
0
Year
Year
year of aggregation period, or year in which sample taken, in format YYYY.
int(4)
0
PeriodLength
Period Length
number of months in aggregation period.
int(4)
0
NoOfSamples
Number Of Samples
number of samples in aggregation period.
int(4)
0
AggregationPeriod
Aggregation Period
period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period.
nvarchar(20)
0
CountryCode
Country code
ISO 3166-alpha-2 code elements
varchar(2)
0
Determinand
Determinand
determinand name.
nvarchar(200)
0
Unit
Unit
unit of measurement.
nvarchar(30)
0
WaterbaseID
Waterbase ID
internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).
varchar(200)
-1
LimitOfDetectionFlag
Limit Of Detection Flag
flag to indicate sample below analytical limit of detection in format <.
Document Actions
Share with others