next
previous
items

Data

Reference Waterbase - Lakes

Data
Prod-ID: DAT-9-en
Created 23 May 2003 Published 23 May 2003 Last modified 15 Dec 2022
5 min read
This is an old version, kept for reference only.

Go to latest version
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

European data

Reference WATERBASE - Lakes: chemical quality 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
Reference WATERBASE - Lakes: stations characteristic data

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

Metadata

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.

 

Permalinks

Geographic coverage

Temporal coverage

Document Actions