Data

Waterbase - Lakes

Data

Prod-ID: DAT-9-en

Created 07 Jun 2012 Published 18 Jun 2012 Last modified 15 Dec 2022

23 min read

This page was archived on 07 Jul 2014 with reason: Other (New version data-and-maps/data/waterbase-lakes-10 was published)

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

Data and maps

Menu

European data

Waterbase - Lakes (5 tables)

The dataset contains data on nutrients, organic matter, hazardous substances and other chemical determinands in water, proxy pressure data on the upstream catchments and physical characteristics of the WISE-SoE lake monitoring stations. ***WARNING:*** Records, where errors and other quality issues and inconsistencies have been detected, have been removed from the dataset only in the most severe cases (missing primary key values, duplicates...). The other "problematic" records are left in. Each data table contains a set of special QA fields which are used to flag the particular quality issues detected in the individual records. The QA fields and flag codes are described in the QA documentation.

[+] Show table definition

Physical Characteristics of Lake Monitoring Stations (Waterbase_lakes_v12_Stations, 3837 records)

Physical characteristics of the WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
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(3)
WFD_EU_CD	Unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station.		text(50)
LakeName	Name of lake.		text(150)
WaterCategory	Water Category, as defined in the codelist.		text(2)
WaterBodyID	National identification code of water body in which station is located		text(50)
WaterBodyName	Name of water body in which station is located.		text(255)
CatchmentName	Name of major catchment or basin.		text(150)
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	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
CatchmentArea	Catchment area upstream of the station, in kilometres squared.		single
Altitude	Altitude of station in metres above sea level.		long
RepresentativeStation	Station is representative, reflecting general quality of rivers/lakes/transitional or coastal water bodies or marine water areas.		text(1)
ReferenceStation	Station is reference station - 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)
ImpactStation	Station is impact station - located within the zone where initial mixing of discharges takes place with receiving waters.		text(1)
LargestStation	Station is largest station - most important station, including the nationally most important or well known rivers or lakes.		text(1)
Geology	The dominnt geology in the catchment, given according to the WFD Annex 2 categories.	siliceous, calcareous, organic (peat)	text(50)
WaterColourAverage	Long-term average concentration of water colour, expressing the concentration of humic substances at the station.		single
WaterColourLevel	Average level of water colour as defined by the WFD intercalibration typology.	low (90 mg/l Pt = polyhumic).	text(8)
AlkalinityAverage	Long-term average of alkalinity of water at the station		single
AlkalinityLevel	Long-term average level of alkalinity as defined by the WFD intercalibration typology.	low alk. (1 meq/L)	text(8)
HMWB	River/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.		single
MeanDepth	Mean depth of the lake in metres.		single
MaximumDepth	Maximum depth of the lake in metres.		single
ResidenceTime	Average lake residence time in years.		single
Volume	Volume of water in lake in million cubic metres.		single
Reservoir	Reservoir or natural lake.	Y - reservoir, N - natural lake	text(1)
SamplingDepth	Depth at which sample taken in metres below the lake surface.		text(20)
Remarks	Remarks, comments or explanatory notes		text(255)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Proxy Pressures of Lakes (Waterbase_lakes_v12_Pressures, 2207 records)

Proxy pressure data on the upstream catchments of WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
PopulationDensity	Population density of the upstream catchment of the river monitoring station		single
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 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(50)
Remarks	Remarks, comments or explanatory notes		text(255)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Nutrients and General Physico-Chemical Determinands in Lakes (Waterbase_lakes_v12_Nutrients, 345004 records)

Data on nutrients and organic matter in water measured at WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
Year	Year of aggregation period in which samples were taken/Year in which sample was taken.		long
AggregationPeriod	Period of aggregation of measurement data. Value streamlined and unified by the ETC.		text(20)
AggregationPeriod_original	Period of aggregation of measurement data. Original value reported by country.		text(100)
AggregationMonths	Detailed specification of aggregation period by months.		text(150)
AggregationLength	Number of months in aggregation period.		long
Determinand_Nutrients	Name of nutrient, organic matter or general physico-chemical determinand.		text(50)
Unit_Nutrients	Unit of measurement of nutrients or organic matter.		text(7)
CEN_ISO	CEN/ISO code of the methods.		text(150)
NumberOfSamples	Number of samples included in aggregated data.		long
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.		single
LimitOfQuantification	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).		single
Minimum	Minimum disaggregated sample concentration value of the input data used for aggregation.		single
Mean	Mean concentration value of aggregated data.		single
Maximum	Maximum disaggregated sample concentration value of the input data used for aggregation.		single
Median	Median concentration value of aggregated data.		single
StandardDeviation	Standard deviation of concentration values of aggregated data.		single
SampleDepth	Depth at which sample taken in metres below water surface.		decimal
TotalDepth	Total depth of water column at the sampling location and at the time of sampling (in meters).		single
NoOfSubsites	Number of subsites		long
MethodSubsitesSpatialAggreg	Method of subsite aggregation - if several subsites across the water body profile are joined into one monitoring station.		text(255)
Remarks	Remarks, comments or explanatory notes		text(255)
AggregatedBy	Subject(s) that aggregated the data.		text(20)
QA_MVissues			long
QA_LRviolations	Quality assessment field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	text(100)
QA_outlier	Quality assessment field - outlier flag.	Outlier code assigned to the record. Details are explained in the QA documentation.	long
QA_CRviolations	Quality assessment field - list of chemical rules violations.	List of codes of chemical rules violated by record. Details are explained in the QA documentation.	text(50)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Hazardous Substances and Other Chemical Determinands in Lakes (Waterbase_lakes_v12_HazSubs, 73479 records)

Data on hazardous substances and other chemical determinands in water measured at WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
Year	Year of aggregation period in which samples were taken/Year in which sample was taken.		long
Determinand_HazSubs	Name of hazardous substance or other chemical determinand.		text(150)
Unit_HazSubs	Unit of measurement of hazardous substance.		text(20)
CASNumber	Chemical Abstract Service Number of the hazardous substance or other chemical determinand.		text(64)
CEN_ISO	CEN/ISO code of the methods.		text(150)
NumberOfSamples	Number of samples included in aggregated data.		long
NumberOfSamplesBelowLOQ	Number of samples below limit of quantification within aggregation period		long
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.		single
LimitOfQuantification	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).		single
Minimum	Minimum disaggregated sample concentration value of the input data used for aggregation.		single
Mean	Mean concentration value of aggregated data.		single
Maximum	Maximum disaggregated sample concentration value of the input data used for aggregation.		single
Median	Median concentration value of aggregated data.		single
StandardDeviation	Standard deviation of concentration values of aggregated data.		single
SampleDepth	Depth at which sample taken in metres below water surface.		decimal
NoOfSubsites	Number of subsites		long
MethodSubsitesSpatialAggreg	Method of subsite aggregation - if several subsites across the water body profile are joined into one monitoring station.		text(255)
Remarks	Remarks, comments or explanatory notes		text(255)
AggregatedBy	Subject(s) that aggregated the data.		text(20)
QA_MVissues			long
QA_LRviolations	Quality assessment field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	text(100)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Supportive Determinands for hazardous substances in Lakes (Waterbase_lakes_v12_SuppDet, 48096 records)

Data on supportive determinands, supplementing information on hazardous substances in water measured at WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
Year	Year of aggregation period in which samples were taken/Year in which sample was taken.		long
Determinand_Supportive	Name of supportive determinand, that is needed for correct interpretation of some hazardous substances.		text(20)
Unit_DetSupport	Unit of measurement of hazardous substances supportive determinands.		text(20)
NumberOfSamples	Number of samples included in aggregated data.		long
Minimum	Minimum disaggregated sample concentration value of the input data used for aggregation.		single
Mean	Mean concentration value of aggregated data.		single
Maximum	Maximum disaggregated sample concentration value of the input data used for aggregation.		single
Median	Median concentration value of aggregated data.		single
StandardDeviation	Standard deviation of concentration values of aggregated data.		single
AggregatedBy	Subject(s) that aggregated the data.		text(20)
QA_MVissues			long
QA_outlier	Quality assessment field - outlier flag.	Outlier code assigned to the record. Details are explained in the QA documentation.	long
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Waterbase-Lakes (Microsoft Access database file) (ZIP archive)
14.87 MB Download file
Waterbase-Lakes (CSV files) (ZIP archive)
8.77 MB Download file

Waterbase - Biology in lakes (3 tables)

This separate dataset contains data for the biological quality elements (BQEs) phytobenthos and macroinvertebrates from WISE-SoE lake monitoring stations. The data are reported as ecological quality ratios (EQRs) (for more explanation, see illustration in additional information part) together with information on the national classification systems for ecological status. The dataset is a result of the first regular data flow for Biological elements in rivers and lakes (2011) and it is the first time the biological data are published in Waterbase. In the next updates the data will be published in one dataset together with the other Waterbase lakes data.

[+] Show table definition

Physical Characteristics of Lake Monitoring Stations (Waterbase_lakes_v12_StationsBiology, 912 records)

Physical Characteristics of the WISE-SoE Lake monitoring stations containing biological data.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_RV_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
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(3)
WFD_EU_CD	Unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station.		text(50)
RiverName	National name of river.		text(150)
LakeName	Name of lake.		text(150)
WaterCategory	Water Category, as defined in the codelist.		text(2)
WaterBodyID	National identification code of water body in which station is located		text(50)
WaterBodyName	Name of water body in which station is located.		text(255)
CatchmentName	Name of major catchment or basin.		text(150)
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)
SeaAreaName	Name of the local sea into which the river discharges or in which the TCM station is located.		text(150)
SeaRegionName	Name of regional sea of which local sea area is a part.		text(150)
SeaConventionArea	Name of Marine Convention area of which regional sea is a part.		text(8)
Longitude	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
CatchmentArea	Catchment area upstream of the station, in kilometres squared.		single
Altitude	Altitude of station in metres above sea level.		long
RepresentativeStation	Station is representative, reflecting general quality of rivers/lakes/transitional or coastal water bodies or marine water areas.		text(1)
ReferenceStation	Station is reference station - 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)
ImpactStation	Station is impact station - located within the zone where initial mixing of discharges takes place with receiving waters.		text(1)
LargestStation	Station is largest station - most important station, including the nationally most important or well known rivers or lakes.		text(1)
FluxStation	Station is flux station - used for assessment of international, transboundary loads or loads entering Europe's Seas.		text(1)
Geology	The dominnt geology in the catchment, given according to the WFD Annex 2 categories.	siliceous, calcareous, organic (peat)	text(50)
WaterColourAverage	Long-term average concentration of water colour, expressing the concentration of humic substances at the station.		single
WaterColourLevel	Average level of water colour as defined by the WFD intercalibration typology.	low (90 mg/l Pt = polyhumic).	text(8)
AlkalinityAverage	Long-term average of alkalinity of water at the station		single
AlkalinityLevel	Long-term average level of alkalinity as defined by the WFD intercalibration typology.	low alk. (1 meq/L)	text(8)
HMWB	River/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)
LengthFromSource	River length from source to monitoring station in kilometres		single
RiverDischarge	Mean long term annual river discharge in m3 /s at the monitoring station.		single
SubsiteLocation	Location of the lake sub-site in relation to the principal monitoring site.		text(50)
Location	Location of the lake monitoring site.		text(150)
SurfaceArea	Surface area of lake in square kilometres.		single
MeanDepth	Mean depth of the lake in metres.		single
MaximumDepth	Maximum depth of the lake in metres.		single
ResidenceTime	Average lake residence time in years.		single
Volume	Volume of water in lake in million cubic metres.		single
Reservoir	Reservoir or natural lake.	Y - reservoir, N - natural lake	text(1)
SamplingDepth	Depth at which sample taken in metres below the lake surface.		text(20)
Remarks	Remarks, comments or explanatory notes		text(255)
CountryCodeETC	Specification of region within country, in case of more than one data provider per country.	BE-FL = Flanders, BE-WA = Wallonia; GB-EW = England & Wales, GB-NI = Northern Ireland, GB-SC = Scotland	text(5)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Biology in Lakes (Waterbase_lakes_v12_Biology, 3000 records)

EQR (ecological quality ratio) values for phytobenthos and macroinvertebrates in lakes measured at WISE-SoE lake monitoring stations.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterCategory	Water Category, as defined in the codelist.		text(2)
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_RV_' and NationalStationID	text(100)
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(100)
WaterbodyTypeNCS	Type of waterbody type as used in the national classification system.		text(255)
WaterbodyTypeIC	Type of waterbody as defined by the WFD Intercalibration process		text(255)
Year	Year of aggregation period in which samples were taken/Year in which sample was taken.		long
AggregationPeriod	Period of aggregation of measurement data.		text(20)
AggregationMonths	Detailed specification of aggregation period by months.		text(150)
AggregationLength	Number of months in aggregation period.		long
DeterminandBiology	Impact-specific determinand name for biological metrics.		text(255)
UnitBiology	Unit of biological metrics.		text(255)
BQE	Biological Quality Element	PB = phytobenthos, MI = macroinvertebrates	text(255)
MetricScale	The scale of the biological metric.	EQR	text(255)
DeterminandStatusClass	Ecological status class of a monitoring station calculated for a single biological quality element.	H = high, G = good, M = moderate, P = poor, B = bad.	text(255)
NumberOfSamples	Number of samples included in aggregated data.		long
MinValue	Minimum disaggregated sample concentration value of the input data used for aggregation.		double
MeanValue	Mean concentration value of aggregated data.		double
MaxValue	Maximum disaggregated sample concentration value of the input data used for aggregation.		double
MedianValue	Median concentration value of aggregated data.		double
StDevValue	Standard deviation of concentration values of aggregated data.		double
TotalDepth	Total depth of water column at the sampling location and at the time of sampling (in meters).		double
NoOfSubsites	Number of subsites		long
MethodSubsitesSpatialAggreg	Method of subsite aggregation - if several subsites across the water body profile are joined into one monitoring station.		text(255)
Remarks	Remarks, comments or explanatory notes		text(255)
CountryCodeETC	Specification of region within country, in case of more than one data provider per country.	BE-FL = Flanders, BE-WA = Wallonia; GB-EW = England & Wales, GB-NI = Northern Ireland, GB-SC = Scotland	text(5)
MeanValueNationalEQR	Mean value of metric converted to EQR scale (Ecological Quality Ratio).	EQR is usually calculated as metric value divided by reference value, but different methods are used depending on the metric and the country.	double
MeanValueNormalisedEQR	Mean value of metric converted to normalised EQR scale (Ecological Quality Ratio).	The normalised EQR is a scaled version of the national EQR, where the boundaries of ecological status classes are 0.8, 0.6, 0.4 and 0.2.	double
QA_MVissues	Quality assessment field - main meassurement value issue flag	A code identifying an issue or an error in the main meassurement value of the record. Details are explained in the QA documentation.	long
QA_LRviolations	Quality assessment field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	text(100)
QA_outlier	Quality assessment field - outlier flag.	Outlier code assigned to the record. Details are explained in the QA documentation.	long
QA_CRviolations	Quality assessment field - list of chemical rules violations.	List of codes of chemical rules violated by record. Details are explained in the QA documentation.	text(50)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
QA_DDviolations	Quality assessment field - 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.	memo

Classification system for Ecological Status Classes in Lakes (Waterbase_lakes_v12_Classification, 407 records)

Information about national classification system for each biological determinand and waterbody type, including reference conditions and class boundaries for ecological status or potential.

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
WaterCategory	Water Category, as defined in the codelist.		text(2)
DeterminandBiology	Impact-specific determinand name for biological metrics.		text(255)
BQE	Biological Quality Element	PB = phytobenthos, MI = macroinvertebrates	text(255)
ImpactBio	The dominant physical or chemical anthropogenic impact for which the biological metric is an indicator.	Acidification, Eutrophication, General degradation, or Hydromorphology.	text(255)
MetricName	Name or other description of biological metric		text(255)
SamplingMethodBio	Description of the sampling method for biological data		text(50)
AnalysisMethodBio	Description of the analysis method (identification and quantification) for biological data		text(255)
WaterbodyTypeNCS	Type of waterbody type as used in the national classification system.		text(255)
HMWB	River/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(3)
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(3)
ReferenceCondition	Ecological reference condition of waterbody	Specific for each biological determinand and waterbody type	Double
HG_Boundary	Boundary between High and Good ecological status classes	Specific for each biological determinand and waterbody type; in national EQR scale	Double
GM_Boundary	Boundary between Good and Moderate ecological status classes	Specific for each biological determinand and waterbody type; in national EQR scale	Double
MP_Boundary	Boundary between Moderate and Poor ecological status classes	Specific for each biological determinand and waterbody type; in national EQR scale	Double
PB_Boundary	Boundary between Poor and Bad ecological status classes	Specific for each biological determinand and waterbody type; in national EQR scale	Double
IntercalibratedDeterminandBiology	Has the biological determinand been intercalibrated?	yes or no	text(3)
IntercalibratedClassBoundaries	Are the class boundaries of the biological determinand correct for the given waterbody type, according to the intercalibration?	yes or no	text(3)
IntercalibratedWaterbodyType	Has the waterbody type been included in intercalibration?	yes or no	text(3)
Remarks	Remarks, comments or explanatory notes		text(255)
CountryCodeETC	Specification of region within country, in case of more than one data provider per country.	BE-FL = Flanders, BE-WA = Wallonia; GB-EW = England & Wales, GB-NI = Northern Ireland, GB-SC = Scotland	text(5)
QA_DDviolations	Quality assessment field - 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.	memo

Waterbase-Biology in lakes (Microsoft Access database file) (ZIP archive)
257.09 KB Download file
Waterbase-Biology in lakes (CSV files) (ZIP archive)
140.92 KB Download file

Additional information

Tables metadata

Definition and field description of all data tables.

Tables metadata (XLS file) (Microsoft Excel spreadsheet)
140.00 KB Download file
Tables metadata (CSV files) (ZIP archive)
6.96 KB Download file

Code lists

Lists and description of codes of selected fields present in the Waterbase-Lakes data tables

Code lists (XLS file) (Microsoft Excel spreadsheet)
140.00 KB Download file
Code lists (CSV files) (ZIP archive)
17.55 KB Download file

QA documentation

Quality control documentation briefly presents ETC/ICM 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 (ZIP archive)
44.71 KB Download file

Graphics

Graphical annexes.

Illustration of reporting of biological metric values and class boundaries in EQR scale. (JPEG image)
140.67 KB Download file

Metadata

Reporting obligations (ROD)

Lake quality (EWN-2)

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Disclaimer:

Data in Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.

Data sources

The European Topic Centre on Inland, Coastal and Marin waters. Version 12, date of delivery (date sent to the Data Service): 15/06/2012.

Owners:

European Environment Agency (EEA)

Processors:

European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

Additional information

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-8 or scan the QR code.

PDF generated on 20 Apr 2024, 06:25 AM