Data

Reference Waterbase - Lakes

Data

Prod-ID: DAT-9-en

Created 30 Sep 2003 Published 30 Sep 2003 Last modified 15 Dec 2022

8 min read

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

Reference Waterbase is the EEA's database on the status and quality of Europe's rivers, lakes and groundwater bodies

Data and maps

Menu

European data

Reference WATERBASE - Lakes: chemical QualityWater data

The QualityWater table contains data on nutrients and organic matter measured at the 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.

[+] Show table definition (records: 184994)

Median	Median	Median concentration during aggregation period	float(8)	0
75Percentile	75Percentile	75th percentile concentration during aggregation period	float(8)	0
90Percentile	90Percentile	90th percentile concentration during aggregation period	float(8)	0
StandardDeviation	StandardDeviation	Standard deviation of concentration during aggregation period	float(8)	0
10Percentile	10Percentile	10th percentile concentration during aggregation period	float(8)	0
25Percentile	25Percentile	25th 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
Mean	Mean	Average concentration during aggregation period	float(8)	0
NoOfSamples	NoOfSamples	Number of samples in aggregation period	int(4)	0
Year	Year	Year of aggregation period in format YYYY	int(4)	0
PeriodLength	PeriodLength	Number of months in aggregation period	int(4)	0
Unit	Unit	Unit of measurement as defined in meta data section "Unit"	nvarchar(30)	0
AggregationPeriod	AggregationPeriod	Period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months	nvarchar(10)	0
Countrycode	Country code	ISO 3166-alpha-2 code elements	nvarchar(2)	0
WaterbaseID	WaterbaseID	Internally produced, unique identifier used to represent the monitoring stations for rivers or lakes or the groundwater bodies	nvarchar(20)	-1
Determinand	Determinand	Determinand name as defined in meta data section "Unit"	nvarchar(30)	0

ASCII Delimited (zip) (ZIP archive)
2.82 MB Download file
Lakes: QualityWater metadata table (text/comma-separated-values)
2.34 KB Download file
Access 2000 (zip) (ZIP archive)
3.62 MB Download file

Reference WATERBASE - Lakes: stations' pressures characteristic data

The Pressure table contains proxy pressure data on the upstream catchments of EUROWATERNET lake monitoring stations. Each station has been assigned a unique WATERBASE identifier (WaterbaseID) which can be used to link the Pressure data with their respective Stations and Quality data.

[+] Show table definition (records: 48)

LanduseOther	LanduseOther	Other land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseOtherAgriculture	LanduseOtherAgriculture	Other agricultural land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseArableLand	LanduseArableLand	Arable land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LandusePasture	LandusePasture	Pastural land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseNature	LanduseNature	Natural land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseForest	LanduseForest	Forested land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseTotalAgriculture	LanduseTotalAgriculture	Total agricultural land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
PopulationDensity	PopulationDensity	Population density (capita/km2) of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseUrban	LanduseUrban	Urban land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
LanduseWetland	LanduseWetland	Wetland land use as % of the upstream catchment area of the river or lake monitoring station or within the area of the groundwater body	float(8)	0
CountryCode	CountryCode	ISO 3166-alpha-2 code elements	nvarchar(2)	0
WaterbaseID	WaterbaseID	Internally produced, unique identifier used to represent the monitoring stations for rivers or lakes or the groundwater bodies	varchar(20)	-1

pressures_lakes_en_v3.xls (Microsoft Excel spreadsheet)
28.50 KB Download file
pressures_lakes_en_v3.mdb (application/msaccess)
140.00 KB Download file
pressures_lakes_en_v3.csv (text/comma-separated-values)
5.11 KB Download file
pressures_lakes_en_v3.dbf (dBASE document)
10.86 KB Download file
Lakes: stations' pressures metadata table (text/comma-separated-values)
2.79 KB Download file

Reference WATERBASE - Lakes: stations characteristic data

The Stations table contains data on the EUROWATERNET lake monitoring stations' physical characteristics. Each station has been assigned a unique WATERBASE identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressure data.

[+] Show table definition (records: 1214)

LakeResidenceTime	LakeResidenceTime	Average lake residence time expressed in years. Calculated as volume/annual flow	float(8)	0
LakeVolume	LakeVolume	Volume of the lake in Mio m³	float(8)	0
LakeArea	LakeArea	Surface area of the lake in km²	float(8)	0
Latitude	Latitude	(Y) International geographical co-ordinates of the monitoring station in decimal degrees format	float(8)	0
LakeMaxDepth	LakeMaxDepth	Maximum depth of lake in m	float(8)	0
LakeMeanDepth	LakeMeanDepth	Mean depth of lake in m	float(8)	0
CatchmentArea	CatchmentArea	Upstream catchment area in km²	float(8)	0
Altitude	Altitude	Altitude of monitoring station in m above sea level	float(8)	0
Longitude	Longitude	(X) International geographical co-ordinates of the monitoring station in decimal degrees format	float(8)	0
Reservoir	Reservoir	Indicates whether the lake is a reservoir or ntural lake (1 = reservoir; 0 = lake)	int(4)	0
LargestLake	LargestLake	Indicates whether the lake is considered as one of the largest lakes (1 = yes; 0 = no)	int(4)	0
ReferenceLake	ReferenceLake	Indicates whether the lake is considered a reference lake (1 = yes; 0 = no)	int(4)	0
RepresentativeLake	RepresentativeLake	Indicates whether the lake is considered a representative lake (1 = yes; 0 = no)	int(4)	0
NationalStationID	NationalStationID	Provided at national level	nvarchar(20)	0
Region	Region	Region in which water body is located at the national level	nvarchar(100)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements	nvarchar(2)	0
Country	Country	Official short name in English	nvarchar(50)	0
WaterbaseName	WaterbaseName	Name of the river station, lake or groundwater body	nvarchar(200)	0
WaterbaseID	WaterbaseID	Internally produced, unique identifier used to represent the monitoring stations for rivers or lakes or the groundwater bodies	varchar(20)	-1
WaterBodyType	WaterBodyType	R = River, L = Lake, GW = Groundwater	varchar(2)	0

stations_lakes_en_v3.csv (text/comma-separated-values)
188.38 KB Download file
stations_lakes_en_v3.dbf (dBASE document)
779.56 KB Download file
stations_lakes_en_v3.xls (Microsoft Excel spreadsheet)
634.50 KB Download file
stations_lakes_en_v3.mdb (application/msaccess)
352.00 KB Download file
Lakes: stations' metadata table (text/comma-separated-values)
2.60 KB Download file

Metadata

Rights:: EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).
Units:: Oxygen saturation: % Chlorophyll a: µg/l El. Conductivity: µS/cm Secchi depth transparency: m Alkalinity: meq/l Total organic carbon: mg/l C Nitrate and nitrite nitrogen (oxidised nitrogen), Nitrite, Kjeldahl Nitrogen, Total Nitrogen, Ammonia Nitrogen, Nitrate: mg/l N BOD7, CODCr, COD unspecified, Oxygen concentration, CODMn, BOD5: mg/l O2 Orthophosphate, Total Phosphorus: mg/l P pH: pH
Data sources: The European Topic Centre on Water. Version 3, date of delivery (date sent to the Data Service): 17/09/2003
Owners:: European Environment Agency (EEA)
Processors:: European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

Additional information

The data contained in this database can be accessed through a series of web pages which form part of the EEA Data Service's public web site. Pre-defined applications have been designed to assist the user to extract and analyse the data in a format that is both helpful and meaningful. Reference Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eurowaternet (EWN) process. EWN selects validated, mostly aggregated, monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. Although many countries make their highly aggregated data available over the Internet, the level and form of aggregation often varies from country to country making detailed quantitative comparisons difficult. The added value of Reference Waterbase is that data collected through the EWN process are from statistically stratified monitoring stations and groundwater bodies and are comparable at European level. These data are primarily used in the production of the EEA's indicator-based factsheets. Data disclaimer: The data in Reference Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.

For references, please go to https://www.eea.europa.eu/data-and-maps/data/reference-waterbase-lakes-2 or scan the QR code.

PDF generated on 20 Apr 2024, 05:09 PM