Do 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
The Stations table contains the physical characteristics of the Eurowaternet 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 Pressure data.
[+] Show table definition (records: 1419)
| LakeResidenceTime | Lake Residence Time | average 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 format. | 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 format. | float(8) | 0 |
| Reservoir | Reservoir | indicates whether the lake is a reservoir or a natural lake (1 = yes (reservoir), 0 = no (lake)). | int(4) | 0 |
| LargestLake | Largest Lake | indicates whether the lake is considered as 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 | indicates whether the lake is considered a representative lake (1 = yes, 0 = no). | int(4) | 0 |
| Country | Country | official short name in English | nvarchar(50) | 0 |
| WaterbaseName | Waterbase Name | name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or the 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(100) | 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 |
| DataSource | Data source | source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC. | varchar(50) | 0 |
stations_lakes_en_v4.mdb
(application/msaccess)
stations_lakes_en_v4.dbf
(dBASE document)
stations_lakes_en_v4.csv
(text/comma-separated-values)
stations_lakes_en_v4.xls
(Microsoft Excel spreadsheet)
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: 264)
| 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 | Pastural Land Use | pastural 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 | Landuse Wetland | wetland land use as % of 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 | 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 |
pressures_lakes_en_v4.xls
(Microsoft Excel spreadsheet)
pressures_lakes_en_v4.mdb
(application/msaccess)
pressures_lakes_en_v4.dbf
(dBASE document)
pressures_lakes_en_v4.csv
(text/comma-separated-values)
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.
[+] Show table definition (records: 256129)
| 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 |
ASCII Delimited (zip)
(ZIP archive)
Access 2000 (zip)
(ZIP archive)
Lakes: metadata of the Stations table
(text/comma-separated-values)
Lakes: metadata of the QualityWater table
(text/comma-separated-values)
Lakes: metadata of the Pressures table
(text/comma-separated-values)
Reporting obligations (ROD)
Rights:
Units:
Oxygen Saturation: % Chlorophyll a: µg/l Electrical 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, Oxygen Concentration, CODMn, BOD5: mg/l O2 Orthophosphate, Total Phosphorus: mg/l P pH: pH
Data sources
The European Topic Centre on Water. Version 4, date of delivery (date sent to the Data Service): 31/03/2004
Owners:
Processors:
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eurowaternet (EWN) process. EWN 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 EWN 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.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-lakes or scan the QR code.
PDF generated on 25 Apr 2024, 04:23 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14