Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

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

Waterbase - Lakes

Note: new version is available!
Topics: ,
Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources

European data

Waterbase-Lakes: Stations

The Stations table contains the physical characteristics of the Eionet-Water lake monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressures data.

[+] Show table definition (records:   1464)

LakeResidenceTime Lake residence time mean lake residence time expressed as years. float(8) 0
LakeVolume Lake volume volume of water in lake in Mio m3. float(8) 0
LakeArea Lake area surface area of lake in km2. float(8) 0
Latitude Latitude (Y) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
LakeMaxDepth Lake maximum depth maximum depth of the lake in m. float(8) 0
LakeMeanDepth Lake mean depth mean depth of the lake in m. float(8) 0
CatchmentArea Catchment area upstream catchment area in km2. 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. float(8) 0
Impactstation Impact station impact station: 1 = yes, 0 = no. int(4) 0
Reservoir Reservoir reservoir or natural lake: 1 = yes (reservoir), 0 = no (lake). int(4) 0
LargestLake Largest lake one of the largest lakes: 1 = yes, 0 = no. int(4) 0
ReferenceLake Reference lake indicates whether the lake is considered a reference lake (1 = yes, 0 = no). int(4) 0
RepresentativeLake Representative lake representative lake: 1 = yes, 0 = no. int(4) 0
Country Country official short name in English. nvarchar(50) 0
WaterbaseName WaterbaseName name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or name of the groundwater body. nvarchar(200) 0
NationalStationID National station ID national station identifier for rivers, lakes, transitional, coastal and marine waters and water quantity monitoring station. For transitional, coastal and marine waters, areas are recorded and reported as a discrete location, but location may relate to a station at a fixed geographical point, a broader area in which sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. When calculating loads, the national station identifier used should be the same ID previously supplied to represent the (flux) river monitoring station. nvarchar(200) 0
WaterDataset Water data set RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine Water, QA = Water Quantity. varchar(3) 0
Region Region region in which water body is located at the national level. varchar(200) 0
CountryCode Country code ISO 3166-alpha-2 code elements. 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
DataSource Data source source of data: Eionet-Water, ICES. varchar(50) 0
Waterbase-Lakes: Pressures

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

[+] Show table definition (records:   503)

LanduseOther Other land use other land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseOtherAgriculture Other agricultural land use other agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseArableLand Arable land use arable land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LandusePasture Pastoral land use pastoral land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseNature Natural land use natural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseForest Landuse forest forested land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseTotalAgriculture Total agricultural land use total agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
PopulationDensity Population density population density (capita/km2) of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseUrban Urban land use urban land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseWetland Wetland land use wetland land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements. 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, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). varchar(200) -1
Waterbase-Lakes: QualityWater

The QualityWater table contains data on nutrients and organic matter in water measured at Eionet-Water lake monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

[+] Show table definition (records:   289645)

25Percentile 25th percentile 25th percentile concentration during 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 mean concentration during aggregation period. float(8) 0
Minimum Minimum minimum concentration value in 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
NumberOfSamples 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 ISO 3166-alpha-2 code elements. 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, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). varchar(200) -1

Additional information

Lakes: metadata of the Stations table
Lakes: metadata of the Pressures table
Lakes: metadata of the QualityWater table

Metadata

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water selects validated 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. The added value of Waterbase is that data collected through the Eionet-Water process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEA's indicator-based factsheets.

 
Document Actions

Comments

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