All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
Chemicals table - this table contains data on chemical quality measured at the EUROWATERNET lake monitoring stations. Chemical and Station data can be linked using the 2 fields: Cry_cd and Stn_id
[+] Show table definition (records: 171177)
Min | Minimum concentration over aggregation period | float(8) | 0 | |
No_samples | Number of samples in aggregation period | int(4) | 0 | |
P90 | 90th Percentile concentration over aggregation period | float(8) | 0 | |
Country | Country name (ISO 3166-1) | official short name in English | nvarchar(100) | 0 |
Remarks | Remarks | varchar(255) | 0 | |
Mean | Average concentration over aggregation period | float(8) | 0 | |
Std | Standard Deviation of concentration over aggregation period | float(8) | 0 | |
P10 | 10th Percentile concentration over aggregation period | float(8) | 0 | |
Stn_id | National Station ID: Used to link data provided by the participating countries and Waterbase | varchar(20) | -1 | |
Limnion | varchar(4) | 0 | ||
P75 | 75th Percentile concentration over aggregation period | float(8) | 0 | |
Determinand_nm | Determinand name | varchar(100) | 0 | |
Max | Maximum concentration over the aggregation period | float(8) | 0 | |
Cry_cd | International Country Code (ISO 3166-1-Alpha-2 code elements) | varchar(2) | -1 | |
Determinand | Determinand code | varchar(10) | 0 | |
Period | Period of aggregation of data | Annual = aggregated over the whole year, Summer = aggregated over the summer months; Winter = aggregated over winter months | varchar(50) | 0 |
Year | Year of measurements | Range: 1931 - 1939, 1949 - 2001 | int(4) | 0 |
P25 | 25th Percentile concentration over aggregation period | float(8) | 0 | |
Units | Unit of measurement | As defined in Metadata section | varchar(10) | 0 |
Median | Median concentration over aggregation period | float(8) | 0 | |
Months | Number of months in period of aggregation | int(4) | 0 |
Stations table - this table contains data on the EUROWATERNET lake monitoring stations' physical characteristics. Each station is unique according to the combination of the 2 fields: Cry_cd and Stn_id
[+] Show table definition (records: 1111)
Country | Country name (ISO 3166-1) | official short name in English | nvarchar(100) | 0 |
Rev_year | int(4) | 0 | ||
Rep | Indicates whether the lake is considered a representative lake (value=1) or not (value=0) | Boolean | 0 | |
Stn_type | nvarchar(1) | 0 | ||
Imp | Indicates whether the lake is considered as one of the most important lakes (value=1) or not (value=0) | boolean | 0 | |
Cry_cd | International Country Code (ISO 3166-1-Alpha-2 code elements) | varchar(2) | -1 | |
Lar | Indicates whether the lake is considered as one of the largest lakes (value=1) or not (value=0) | boolean | 0 | |
Lat | Latitude | (Y) International Geographical Co-ordinates of the monitoring station in decimal format | float(8) | 0 |
Mean_dep | Mean depth of lake in metres | Equals volume/surface area | float(8) | 0 |
Max_dep | Maximum depth of lake in metres | float(8) | 0 | |
Long | Longitude | (X) International Geographical Co-ordinates of the monitoring station in decimal format | float(8) | 0 |
Stn_id | National Station ID: used to link data provided by the participating countries and Waterbase | varchar(20) | -1 | |
Res | Indicates whether the lake is a reservoir (value=1) or a natural lake (value=0) | Boolean | 0 | |
Region | Region where the station is located, provided at national level | varchar(100) | 0 | |
Alt | Altitude of lake surface in metres | float(8) | 0 | |
Ref | Indicates whether the lake is considered a reference lake (value=1) or not (value=0) | boolean | 0 | |
Ret_time | Average water residence time expressed as years | Equals volume/annual flow | float(8) | 0 |
Vol | Volume of water in lake as million cubic metres | Equals surface area*mean depth | float(8) | 0 |
Area | Surface area of the lake in square kilometers | float(8) | 0 | |
Remarks | Additional important information on lake | varchar(200) | 0 | |
Catch_area | Upstream catchment area of lake | float(8) | 0 | |
Stn_name | National lake name | varchar(200) | 0 |
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 or scan the QR code.
PDF generated on 08 Jun 2023, 07:22 AM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others