All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo 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!
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) |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-lakes-6/waterbase-lakes-quality or scan the QR code.
PDF generated on 26 Apr 2024, 09:32 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
Document Actions
Share with others