You are here: Home / Data and maps / Datasets / Waterbase - Lakes / Waterbase-Lakes: QualityWater

Waterbase-Lakes: QualityWater

Data Table
The QualityWater table contains data on nutrients and organic matter in water measured at Eurowaternet lake 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
256129
Table definition
25Percentile 25th Percentile 25th Percentile concentration over aggregation period. float(8) 0
75Percentile 75th percentile 75th Percentile concentration during aggregation period. float(8) 0
90Percentile 90th Percentile 90th Percentile concentration during aggregation period. float(8) 0
Median Median median concentration during aggregation period. float(8) 0
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
Mean Mean average 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
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
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 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 ISO3166 two digit code varchar(2) 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
Files

Geographic coverage

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100