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 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: 264853)
| 25Percentile | 25th percentile | 25th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| 75Percentile | 75th percentile | 75th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| 90Percentile | 90th percentile | 90th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| Median | Median | median concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| StandardDeviation | Standard deviation | standard deviation of concentration values of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| 10Percentile | 10th percentile | 10th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| Mean | Mean | mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| Minimum | Minimum | minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| Maximum | Maximum | maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | float(8) | 0 |
| Year | Year | year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. | int(4) | -1 |
| 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 |
| AggregationPeriod | Aggregation period | period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). | nvarchar(20) | -1 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 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, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). | nvarchar(255) | -1 |
| Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
| Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
ASCII Delimited (zip)
(ZIP archive)
Access 2000 (zip)
(ZIP archive)
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: 539)
| LanduseOther | Other land use | other land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). | float(8) | 0 |
| LanduseOtherAgriculture | Other agricultural land use | other agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.2 plus 2.4. | float(8) | 0 |
| LanduseArableLand | Arable land use | arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. | float(8) | 0 |
| LandusePasture | Pastoral land use | pastoral land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. | float(8) | 0 |
| LanduseNature | Natural land use | natural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.2 plus 3.3. | float(8) | 0 |
| LanduseForest | Landuse forest | forested land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.1. | float(8) | 0 |
| LanduseTotalAgriculture | Total agricultural land use | total agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2. | float(8) | 0 |
| PopulationDensity | Population density | population density of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set) in capita/km2. | float(8) | 0 |
| LanduseUrban | Urban land use | urban agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 1.1. | float(8) | 0 |
| LanduseWetland | Wetland land use | wetland agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 4.1 plus 4.2. | float(8) | 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, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). | nvarchar(255) | -1 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
pressures_lakes_en_v6.csv
(text/comma-separated-values)
pressures_lakes_en_v6.mdb
(application/msaccess)
pressures_lakes_en_v6.xls
(Microsoft Excel spreadsheet)
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: 1605)
| LakeResidenceTime | Average water residence time expressed as years | average lake residence time in years. Calculated as volume/annual flow. | float(8) | 0 |
| LakeVolume | Lake volume | volume of water in lake in million m3. | float(8) | 0 |
| LakeArea | Lake area | surface area of lake in km2. | float(8) | 0 |
| Latitude | Latitude | (Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided. | 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 | catchment area upstream of the station, in km2. For lakes, the catchment area upstream of the lake is shown. If more than one station exists in the lake, the catchment area value should be the same for all stations. | float(8) | 0 |
| Altitude | Altitude | altitude of station in m above sea level. For lakes, the altitude of the lake is provided. | float(8) | 0 |
| Longitude | Longitude | (X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
| ImpactStation | Impact station | impact station type, located within the zone where initial mixing of discharges takes place with receiving waters. Concentrations may be worst-case. Impact stations may be used to assess the compliance of discharges with standards established for hazardous substances and may be included in operational monitoring programmes as required by the WFD. Data are not required from investigative monitoring stations. River and lake stations can be of more than one type. 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 | largest, most important station type, including the nationally most important or well known rivers or lakes. Some stations are likely to be monitored for the EU Exchange of Information Decision. River and lake stations can be of more than one type. 1=yes, 0=no. | int(4) | 0 |
| ReferenceLake | Reference lake | reference station type, found in catchments or associated River Basin Districts with little or no human activity, natural landscape higher than 90%, and minimally impacted by inflow from adjacent coastal or marine waters. Concentrations of nutrients or hazardous substances occurring naturally would give an indication of background levels. For volatile sunthetic substances, data from these stations might be used to assess the significance of atmospheric deposition. River and lake stations can be of more than one type. 1=yes, 0=no. | int(4) | 0 |
| RepresentativeLake | Representative lake | representative station type, reflecting the general quality of rivers, lakes, transitional or coastal water bodies or marine water areas. Quality influenced by diffuse and/or point sources of pollution from upstream activities. Pollutants from point sources would be fully mixed and diluted within the ambient water flow/volume. Stations may be part of national networks monitoring nutrients, organic matter and hazardous substances. They may be included in surveillance and/or operational monitoring programmes as required by the WFD. River and lake stations can be of more than one type. 1=yes, 0=no. | int(4) | 0 |
| NationalStationID | National station ID | identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station. | nvarchar(255) | 0 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
| Country | Country name | official short name in English. ISO 3166-1. | nvarchar(255) | 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, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). | nvarchar(255) | -1 |
| WaterbaseName | Waterbase name | national name of station or groundwater body. | nvarchar(255) | 0 |
| Region | Region | national region in which water body is located. | nvarchar(255) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
| DataSource | Data source | source of data: Eionet-Water, ICES. | varchar(50) | 0 |
| WaterDataSet | Water data set | RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity. | varchar(3) | 0 |
stations_lakes_en_v6.mdb
(application/msaccess)
stations_lakes_en_v6.csv
(text/comma-separated-values)
stations_lakes_en_v6.xls
(Microsoft Excel spreadsheet)
Lakes: metadata of the QualityWater table
(text/comma-separated-values)
Lakes: metadata of the Stations table
(text/comma-separated-values)
Lakes: metadata of the Pressures table
(text/comma-separated-values)
Reporting obligations (ROD)
Rights:
Units:
Alkalinity: meq/l BOD5, BOD7: mg/l O2 Chlorophyll a: µg/l COD, CODCr, CODMn, Dissolved Oxygen: mg/l O2 Conductivity, Conductivity (20 oC): µS/cm Kjeldahl Nitrogen, Nitrate, Nitrite, Non-ionised Ammonia, Organic Nitrogen, Total Ammonium, Total Inorganic Nitrogen, Total Nitrogen, Total Oxidised Nitrogen, Total Organic Nitrogen: mg/l N Orthophosphate, Total Phosphorus: mg/l P Oxygen Saturation: % pH: pH Secchi Depth Transparency: m Total Organic Carbon: mg/l C
Data sources
The European Topic Centre on Water. Version 6, date of delivery (date sent to the Data Service): 16/03/2006
Owners:
Processors:
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.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-lakes-2 or scan the QR code.
PDF generated on 25 Apr 2024, 07:05 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