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 dataset contains data on nutrients and organic matter, proxy pressure data on the upstream catchments and physical characteristics of the WISE-SoE lake monitoring stations.
[+] Show table definition
Pressures (1454 records)
Proxy pressure data on the upstream catchments of WISE-SoE lake monitoring stations.
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
| WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_RV_' and NationalStationID | text(60) | yes |
| NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(60) | ||
| PopulationDensity | Population density of the upstream catchment of the river monitoring station | double | ||
| UWWT | Point source pressure from urban waste water treatment discharges. | text(1) | ||
| OverflowsDischarges | Point source pressure from overflows and urban discharges. | text(1) | ||
| IPPC | Point source pressure from IPPC installations. | text(1) | ||
| nonIPPC | Point source pressure from non-IPPC installations? | text(1) | ||
| Fertiliser | Diffuse sources pressures from agricultural fertiliser use. | text(1) | ||
| Pesticide | Diffuse sources pressures from agricultural pesticide use. | text(1) | ||
| Livestock | Diffuse sources pressures from agricultural livestock. | text(1) | ||
| TransportInfrastructure | Diffuse sources pressures from transport and infrastructure without connection to sewers | text(1) | ||
| PublicWaterSupply | Water abstractions pressures due to public water supply. | text(1) | ||
| Industry | Water abstractions pressures due to industry. | text(1) | ||
| Irrigation | Water abstractions pressures due to irrigation. | text(1) | ||
| Cooling | Water abstractions pressures due to needs for cooling water, e.g. for nuclear power plants or other industrial activities. | text(1) | ||
| WaterFlowRegulation | Water flow regulation and morphological alterations | text(20) | ||
| Remarks | Remarks, comments or explanatory notes (free text). | text(255) | ||
| QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of rules violated by record. Details are explained in the QA documentation | text(50) | |
| QA_datatype_errors | Quality assurance field - data type and data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation | text(150) |
Quality (296820 records)
Data on nutrients and organic matter in water measured at WISE-SoE lake monitoring stations.
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
| WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_RV_' and NationalStationID | text(60) | yes |
| NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(60) | ||
| Year | Year of aggregation period in which samples were taken | integer | yes | |
| AggregationPeriod | Period of aggregation | original values as provided by reporter | text(30) | yes |
| AggregationPeriod_unif | Period of aggregation unified | unified aggregation periods values allowing better analysis of time series | text(30) | |
| PeriodLength | Number of months in aggregation period. | integer | ||
| Determinand | Name of nutrients, organic matter or general physico-chemical determinands. | text(50) | yes | |
| Unit | Unit of measurement of nutrients or organic matter. | text(10) | ||
| CEN_ISO | CEN/ISO code of the methods. | text(150) | ||
| NumberOfSamples | Number of samples included in aggregated data. | integer | ||
| LimitOfDetection | Concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected i.e. there is a 95% probability that the determinand will be detected. | double | ||
| LimitOfQuantification | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | double | ||
| Mean | Mean concentration value of aggregated data. | double | ||
| Minimum | Minimum concentration value of aggregated data. | double | ||
| Maximum | Maximum concentration value of aggregated data. | double | ||
| Median | Median concentration value of aggregated data. | double | ||
| StandardDeviation | Standard deviation of concentration values of aggregated data. | double | ||
| SampleDepth | Depth at which sample taken in metres below water surface. | double | ||
| TotalDepth | Total depth of water column at the sampling location and at the time of sampling (meters) | double | ||
| NoOfSubsites | Number of subsites | integer | ||
| MethodOfAggregation | Method of Subsites Spatial Aggregation field is used only if the data are spatially aggregated (No. of subsites > 1), e.g. several subsites across lake depth profile are joined to one monitoring station. | text(255) | ||
| Remarks | Remarks, comments or explanatory notes. | memo | ||
| QA_LRviolations | Quality assurance field - list of logical rules violations. | List of codes of logical rules violated by record. Details are explained in the QA documentation. | text(255) | |
| QA_outlier | Quality assurance field - outlier flag. | List of codes of outlier rules violated by record. Details are explained in the QA documentation. | integer | |
| QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of rules violated by record. Details are explained in the QA documentation | text(50) | |
| QA_datatype_error | Quality assurance field - data type and data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation | text(150) |
Stations (3201 records)
Physical characteristics of the WISE-SoE lake monitoring stations.
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
| WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(60) | yes |
| NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(60) | ||
| NationalStationName | National name of the monitoring station | text(150) | ||
| WFDStation | Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station. | text(1) | ||
| WFD_EU_CD | Internally produced, unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station. | text(30) | ||
| LakeName | Name of lake. | text(150) | ||
| WaterCategory | Water Category, as defined in the codelist. | LK - Lake, RS - Reservoir | text(2) | |
| WaterBodyID | National identification code of water body (if available) in which station is located | text(50) | ||
| WaterBodyName | Name of water body in which station is located | text(150) | ||
| CatchmentName | Name of major catchment or basin | text(150) | ||
| EUCD_NATRB | European Code for National River Basin District | text(10) | ||
| RBDcode | River Basin District Code | text(50) | ||
| RBDname | Name of the River Basin District. | text(150) | ||
| Region | National region in which water body is located | text(50) | ||
| Longitude | (X) International geographical co-ordinates in decimal degrees format | double | ||
| Latitude | (Y) International geographical co-ordinates in decimal degrees format | double | ||
| CatchmentArea | Catchment area upstream of the station, in kilometres squared | double | ||
| Altitude | Altitude of station in metres above sea level. | double | ||
| ReferenceStation | 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. | text(1) | ||
| RepresentativeStation | Representative station type, reflecting the general quality of lakes | text(1) | ||
| LargestStation | Largest, most important station type, including the nationally most important or well known lakes. | text(1) | ||
| ImpactStation | Impact station type, located within the zone where initial mixing of discharges takes place with receiving waters. | text(1) | ||
| Geology | The dominating geology in the catchment, given according to the WFD Annex 2 categories | Siliceous, calcareous or organic (peat). | text(20) | |
| WaterColourAverage | Long-term average concentration of water colour, expressing the concentration of humic substances at the station. | double | ||
| WaterColourLevel | Average level of water colour as defined by the WFD intercalibration typology. | Low (<30 mg/l Pt = oligohumic), moderate (30-90 mg/l Pt = mesohumic) or high (>90 mg/l Pt = polyhumic). | text(10) | |
| AlkalinityAverage | Long-term average of alkalinity of water at the station | double | ||
| AlkalinityLevel | Long-term average level of alkalinity as defined by the WFD intercalibration typology | Low alk. (<0.2 meq/L), moderate alk. (0.2-1 meq/L) or high alk. (>1 meq/L). | text(10) | |
| HMWB | Lake is identified as heavily modified in terms of hydromorphological impacts, such as impoundments and high water level fluctuations, according to WFD-compliant national guidelines | text(1) | ||
| ArtificialWB | Station is located in an artificial water body, (e.g. artificial water reservoir) in terms of hydromorphological impacts, such as impoundments and high water level fluctuations, according to WFD- compliant national guidelines. | text(1) | ||
| Purpose | The purpose of the monitoring station in terms of to which directives, conventions or agreements will the data from the station be used for reporting. | text(255) | ||
| Location | Location of the lake monitoring site | text(150) | ||
| SurfaceArea | Surface area of lake in square kilometres | double | ||
| MeanDepth | Mean depth of the lake in metres. | double | ||
| MaximumDepth | Maximum depth of the lake in metres. | double | ||
| ResidenceTime | Average lake residence time in years | double | ||
| Volume | Volume of water in lake in million cubic metres. | double | ||
| LakeReservoir | Reservoir or natural lake. | Y - reservoir, N - natural lake | text(1) | |
| SamplingDepth | Depth at which sample taken in metres below the lake surface. | text(150) | ||
| Remarks | Remarks, comments or explanatory notes. | text(255) | ||
| QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of rules violated by record. Details are explained in the QA documentation | text(50) | |
| QA_datatype_errors | Quality assurance field - data type and data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation | text(150) |
Waterbase-Lakes (Microsoft Access database file)
(ZIP archive)
Waterbase-Lakes (CSV files)
(ZIP archive)
Definition and field description of all data tables.
Tables metadata (XLS file)
(Microsoft Excel spreadsheet)
Tables metadata (CSV files)
(ZIP archive)
Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Lakes version 10
Country codes and abbreviations (34 records)
(text/comma-separated-values)
Quality control documentation briefly presents ETC/Water and EEA activities focused on quality of Waterbase-Lakes dataset and results of these activities. In addition warning is given on the use of certain records for analytical purposes.
QA documentation
(PDF document)
Reporting obligations (ROD)
Rights:
Disclaimer:
Units:
Oxygen Saturation: %
Temperature: °C
Chlorophyll a: µg/l
Conductivity: µS/cm
Secchi Depth: m
Total Organic Carbon: mg/l C
Kjeldahl Nitrogen, Nitrate, Nitrite, Non-ionised Ammonia, Total Ammonium, Total Inorganic Nitrogen, Total Nitrogen, Total Organic Nitrogen, Total Oxidised Nitrogen: mg/l N
BOD5, BOD7, COD, CODCr, CODMn, Dissolved Oxygen: mg/l O2
Orthophosphate, Total Phosphorus: mg/l P
Silicate: mg/l Si
Data sources
The European Topic Centre on Water. Version 10, date of delivery (date sent to the Data Service): 08 April 2010
Owners:
Processors:
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the WISE-SoE data collection (formerly known as Eionet-Water and Eurowaternet) process. WISE-SoE data collection 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 WISE-SoE data collection 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-6 or scan the QR code.
PDF generated on 10 Jun 2023, 04:58 PM
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