Waterbase-Rivers: QualityWater

Data Table expired
This content has been archived on 05 Dec 2016, reason: Other (The dataset is replaced by Waterbase - Water Quality dataset, which combines Waterbase - Rivers, Lakes and Groundwater into one. It's available at http://www.eea.europa.eu/data-and-maps/data/waterbase-water-quality/.)
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.
European data
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 <. varchar(1) 0
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Phone: +45 3336 7100