Waterbase-Lakes: QualityWater

Data Table

This page was archived on 07 Jul 2014 with reason: Other (New version data-and-maps/data/waterbase-lakes-10 was published)

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.

Data and maps

Menu

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