Data

Waterbase - Water Quality

Data

Prod-ID: DAT-163-en

Created 05 Apr 2019 Published 09 Apr 2019 Last modified 15 Dec 2022

16 min read

Topics: Water and marine environment

This page was archived on 16 Sep 2020 with reason: Other (replaced by two other datasets https://www.eea.europa.eu/data-and-maps/data/waterbase-water-quality-icm and https://www.eea.europa.eu/data-and-maps/data/waterbase-biology)

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, on the quantity of Europe's water resources, and on the emissions to surface waters from point and diffuse sources of pollution.

Data and maps

Menu

European data

Waterbase - Water Quality (6 tables)

The dataset contains time series of nutrients, organic matter, hazardous substances and other chemicals in rivers, lakes and groundwater, as well as data on biological quality elements (BQEs) such as phytobenthos and macroinvertebrates in rivers and lakes. A list of monitoring site identifiers with selected attributes, reported through WFD and WISE Spatial data reporting, is added to dataset as spatial reference. The data has been compiled and processed by EEA. Please refer to the metadata for additional information.

[+] Show table definition

T_WISE4_DisaggregatedData (33848578 records)

Raw disaggregated water quality data on the observed values (e.g. concentrations) of determinands in rivers, lakes and groundwater as reported by EEA Member Countries on an annual basis.

Element name	Element definition	Value definitions
monitoringSiteIdentifier	Unique international identifier of the monitoring site in which the data were obtained.
monitoringSiteIdentifierScheme	Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode').	eionetMonitoringSiteCode: EIONET identifier; euMonitoringSiteCode: WFD identifier
parameterWaterBodyCategory	Water body category code, as defined in the codelist.	see Vocabulary
observedPropertyDeterminandCode	Unique code of the determinand monitored, as defined in the codelist.	see Vocabulary
procedureAnalysedFraction	Specification of which fraction of the sample was analysed.	dissolved: Dissolved (filtered) sample was analysed; SPM: Suspended particulate matter of the sample was analysed; total: Total (unfiltered) sample was analysed
procedureAnalysedMedia	Type of media monitored.	biota: biota; sediment: sediment; water: water
resultUom	Unit of measure for the reported values.	see Vocabulary
phenomenonTimeSamplingDate	Date in which the sample was taken.
resultObservedValue	Observed value (e.g. concentration) of the determinand in the sample.
resultQualityObservedValueBelowLOQ	Flag to indicate whether the sample value was below the analytical limit of quantification (LOQ).	0: false; 1: true
procedureLOQValue	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).
procedureAnalyticalMethod	CEN/ISO code of the analytical method.
parameterSampleDepth	Depth at which sample was taken in meter below water surface.
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	A: Record is confirmed as correct; L: Missing observed value, the data were not collected; M: Missing observed value, the data can not exist; N: Missing observed value, observed value is not relevant or not significant; O: Missing observed value, no further information is available or record reported in the past should be deleted; W: Missing observed value, data are included in another source category; X: Reported value includes data from another source category (categories); Y: The source category does not exactly match the standard definition
Remarks	Remarks, comments or explanatory notes.
metadata_versionId	Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion	Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode	Status of the feature or record regarding its registration.	valid: accepted and valid reported feature or record; stable: accepted and valid reported record, confirmed by the reporter as correct; experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus	Status of the record regarding its reliability.	A: Normal record; U: Record with lower reliability; V: Unvalidated record
metadata_statements	Aditional information or statements regarding the reliability of the feature or record.
UID	Unique identifier of the record in the EEA WISE_SOE database.

T_WISE4_AggregatedData (3211183 records)

Annual mean values and other statistics of determinands on water quality, by monitoring site.

Element name	Element definition	Value definitions
monitoringSiteIdentifier	Unique international identifier of the monitoring site in which the data were obtained.
monitoringSiteIdentifierScheme	Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode').	eionetMonitoringSiteCode: EIONET identifier; euMonitoringSiteCode: WFD identifier
parameterWaterBodyCategory	Water body category code, as defined in the codelist.	see Vocabulary
observedPropertyDeterminandCode	Unique code of the determinand monitored, as defined in the codelist.	see Vocabulary
procedureAnalysedFraction	Specification of which fraction of the sample was analysed.	dissolved: Dissolved (filtered) sample was analysed; SPM: Suspended particulate matter of the sample was analysed; total: Total (unfiltered) sample was analysed
procedureAnalysedMedia	Type of media monitored.	biota: biota; sediment: sediment; water: water
resultUom	Unit of measure for the reported values.	see Vocabulary
phenomenonTimeReferenceYear	Year during which the data were sampled.
parameterSamplingPeriod	The period of the year during which the data used for the aggregation were sampled.
procedureLOQValue	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).
resultNumberOfSamples	Number of sample values included in the aggregated data.
resultQualityNumberOfSamplesBelowLOQ	Number of sample values below LOQ included in the aggregated data.
resultQualityMinimumBelowLOQ	Flag to indicate whether the minimum sample value used for the aggregation was below the analytical limit of quantification (LOQ).	0: false; 1: true
resultMinimumValue	Minimum sample value of the data used for aggregation.
resultQualityMeanBelowLOQ	Flag to indicate whether the mean value is below the highest LOQ.	0: false; 1: true
resultMeanValue	Mean value of the data used for aggregation.
resultQualityMaximumBelowLOQ	Flag to indicate whether the maximum sample value used for the aggregation was below the analytical limit of quantification (LOQ).	0: false; 1: true
resultMaximumValue	Maximum sample value of the data used for aggregation.
resultQualityMedianBelowLOQ	Flag to indicate whether the median value is below the highest LOQ.	0: false; 1: true
resultMedianValue	Median value of the data used for aggregation.
resultStandardDeviationValue	Standard deviation value of the data used for aggregation.
procedureAnalyticalMethod	CEN/ISO code of the analytical method.
parameterSampleDepth	Depth at which sample was taken in meter below water surface.
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	A: Record is confirmed as correct; L: Missing observed value, the data were not collected; M: Missing observed value, the data can not exist; N: Missing observed value, observed value is not relevant or not significant; O: Missing observed value, no further information is available or record reported in the past should be deleted; W: Missing observed value, data are included in another source category; X: Reported value includes data from another source category (categories); Y: The source category does not exactly match the standard definition
Remarks	Remarks, comments or explanatory notes.
metadata_versionId	Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion	Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode	Status of the feature or record regarding its registration.	valid: accepted and valid reported feature or record; stable: accepted and valid reported record, confirmed by the reporter as correct; experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus	Status of the record regarding its reliability.	A: Normal record; U: Record with lower reliability; V: Unvalidated record
metadata_statements	Aditional information or statements regarding the reliability of the feature or record.
UID	Unique identifier of the record in the EEA WISE_SOE database.

T_WISE4_AggregatedDataByWaterBody (20251 records)

Annual mean values and other statistics of determinands on water quality, by water body.

Element name	Element definition	Value definitions
waterBodyIdentifier	Unique international identifier of the water body in which the data were obtained.
waterBodyIdentifierScheme	Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode').	eionetGroundwaterBodyCode: Groundwater body identifier is an EIONET identifier; eionetSurfaceWaterBodyCode: Surface water body identifier is an EIONET identifier; euGroundwaterBodyCode: Groundwater body identifier is a WFD identifier; euSurfaceWaterBodyCode: Surface water body identifier is a WFD identifier
parameterWaterBodyCategory	Water body category code, as defined in the codelist.	see Vocabulary
observedPropertyDeterminandCode	Unique code of the determinand monitored, as defined in the codelist.	see Vocabulary
procedureAnalysedFraction	Specification of which fraction of the sample was analysed.	dissolved: Dissolved (filtered) sample was analysed; SPM: Suspended particulate matter of the sample was analysed; total: Total (unfiltered) sample was analysed
procedureAnalysedMedia	Type of media monitored.	biota: biota; sediment: sediment; water: water
resultUom	Unit of measure for the reported values.	see Vocabulary
phenomenonTimeReferenceYear	Year during which the data were sampled.
parameterSamplingPeriod	The period of the year during which the data used for the aggregation were sampled.
procedureLOQValue	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).
resultNumberOfSamples	Number of sample values included in the aggregated data.
resultQualityNumberOfSamplesBelowLOQ	Number of sample values below LOQ included in the aggregated data.
resultQualityMinimumBelowLOQ	Flag to indicate whether the minimum sample value used for the aggregation was below the analytical limit of quantification (LOQ).	0: false; 1: true
resultMinimumValue	Minimum sample value of the data used for aggregation.
resultQualityMeanBelowLOQ	Flag to indicate whether the mean value is below the highest LOQ.	0: false; 1: true
resultMeanValue	Mean value of the data used for aggregation.
resultQualityMaximumBelowLOQ	Flag to indicate whether the maximum sample value used for the aggregation was below the analytical limit of quantification (LOQ).	0: false; 1: true
resultMaximumValue	Maximum sample value of the data used for aggregation.
resultQualityMedianBelowLOQ	Flag to indicate whether the median value is below the highest LOQ.	0: false; 1: true
resultMedianValue	Median value of the data used for aggregation.
resultStandardDeviationValue	Standard deviation value of the data used for aggregation.
resultNumberOfSitesClass1	Number of monitoring sites with annual average concentration of the given determinand within Class 1 boundaries.
resultNumberOfSitesClass2	Number of monitoring sites with annual average concentration of the given determinand within Class 2 boundaries.
resultNumberOfSitesClass3	Number of monitoring sites with annual average concentration of the given determinand within Class 3 boundaries.
resultNumberOfSitesClass4	Number of monitoring sites with annual average concentration of the given determinand within Class 4 boundaries.
resultNumberOfSitesClass5	Number of monitoring sites with annual average concentration of the given determinand within Class 5 boundaries.
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	A: Record is confirmed as correct; L: Missing observed value, the data were not collected; M: Missing observed value, the data can not exist; N: Missing observed value, observed value is not relevant or not significant; O: Missing observed value, no further information is available or record reported in the past should be deleted; W: Missing observed value, data are included in another source category; X: Reported value includes data from another source category (categories); Y: The source category does not exactly match the standard definition
Remarks	Remarks, comments or explanatory notes.
metadata_versionId	Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion	Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode	Status of the feature or record regarding its registration.	valid: accepted and valid reported feature or record; stable: accepted and valid reported record, confirmed by the reporter as correct; experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus	Status of the record regarding its reliability.	A: Normal record; U: Record with lower reliability; V: Unvalidated record
metadata_statements	Aditional information or statements regarding the reliability of the feature or record.
UID	Unique identifier of the record in the EEA WISE_SOE database.

T_WISE4_BiologyEQRData (29741 records)

Annually aggregated biological ecological quality ratio (EQR) data from rivers and lakes, by monitoring site.

Element name	Element definition	Value definitions
monitoringSiteIdentifier	Unique international identifier of the monitoring site in which the data were obtained.
monitoringSiteIdentifierScheme	Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode').	eionetMonitoringSiteCode: EIONET identifier; euMonitoringSiteCode: WFD identifier
parameterWaterBodyCategory	Water body category code, as defined in the codelist.	see Vocabulary
parameterNCSWaterBodyType	Type of water body as defined by the member state.
observedPropertyDeterminandBiologyEQRCode	Determinand code for biological metrics, as defined in the vocabulary.	see Vocabulary
phenomenonTimeReferenceYear	Year during which the data were sampled.
parameterSamplingPeriod	The period of the year during which the data used for the aggregation were sampled.
resultEcologicalStatusClassValue	Ecological status class (or ecological potential class, for artificial and heavily modified water bodies) assessed on the basis of the reported biological determinand.	1: High status or maximum potential; 2: Good status or potential; 3: Moderate status or potential; 345: Moderate, poor or bad status or potential; 4: Poor status or potential; 5: Bad status or potential
resultNumberOfSamples	Number of sample values included in the aggregated data.
resultEQRValue	Mean value of the biological metric converted to the national Ecological Quality Ratio (EQR) scale.
resultNormalisedEQRValue	Mean value of metric converted to normalised EQR scale (Ecological Quality Ratio).
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	A: Record is confirmed as correct; L: Missing observed value, the data were not collected; M: Missing observed value, the data can not exist; N: Missing observed value, observed value is not relevant or not significant; O: Missing observed value, no further information is available or record reported in the past should be deleted; W: Missing observed value, data are included in another source category; X: Reported value includes data from another source category (categories); Y: The source category does not exactly match the standard definition
Remarks	Remarks, comments or explanatory notes.
metadata_versionId	Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion	Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode	Status of the feature or record regarding its registration.	valid: accepted and valid reported feature or record; stable: accepted and valid reported record, confirmed by the reporter as correct; experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus	Status of the record regarding its reliability.	A: Normal record; U: Record with lower reliability; V: Unvalidated record
metadata_statements	Aditional information or statements regarding the reliability of the feature or record.
UID	Unique identifier of the record in the EEA WISE_SOE database.

T_WISE4_BiologyEQRClassificationProcedure (2553 records)

Information on national classification system for each biological determinand and waterbody type, including the boundaries of ecological status classes (and of ecological potential classes, for artificial or heavily modified waterbodies). This table is valid for biological EQR data only.

Element name	Element definition	Value definitions
CountryCode	Abbreviation of EEA Member or Collaborating Country.
observedPropertyDeterminandBiologyEQRCode	Determinand code for biological metrics, as defined in the vocabulary.	see Vocabulary
parameterWaterBodyCategory	Water body category code, as defined in the codelist.	see Vocabulary
parameterNCSWaterBodyType	Type of water body as defined by the member state.
parameterWFDIntercalibrationWaterBodyType	Type of water body as defined by the WFD Intercalibration process.	see Vocabulary
parameterNaturalAWBHMWB	Specification of whether a water body is identified as natural, artificial (AWB) or heavily modified (HMWB). AWBs are surface water bodies which have been created in a location where no water body existed before and which have not been created by the direct physical alteration, movement or realignment of an existing water body. HMWB are bodies of water which as a result of physical alterations by human activity are substantially changed in character and cannot, therefore, meet "good ecological status" (GES). In this context physical alterations mean changes to e.g. the size, slope, discharge, form and shape of river bed of a water body.	AWB: Artificial water body; HMWB: Heavily modified water body; Natural: Natural water body
parameterICStatusOfDeterminandBiologyEQR	Flag indicating whether the biological determinand has been intercalibrated.	0: false; 1: true
parameterBoundaryValueClasses12	Boundary between High and Good ecological status or potential classes, for a given biological determinand and water body type.
parameterBoundaryValueClasses23	Boundary between Good and Moderate ecological status or potential classes, for a given biological determinand and water body type.
parameterBoundaryValueClasses34	Boundary between Moderate and Poor ecological status or potential classes, for a given biological determinand and water body type.
parameterBoundaryValueClasses45	Boundary between Poor and Bad ecological status or potential classes, for a given biological determinand and water body type.
procedureBiologicalAnalyticalMethodDescription	Description of the biological analytical method
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	A: Record is confirmed as correct; L: Missing observed value, the data were not collected; M: Missing observed value, the data can not exist; N: Missing observed value, observed value is not relevant or not significant; O: Missing observed value, no further information is available or record reported in the past should be deleted; W: Missing observed value, data are included in another source category; X: Reported value includes data from another source category (categories); Y: The source category does not exactly match the standard definition
Remarks	Remarks, comments or explanatory notes.
metadata_versionId	Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion	Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode	Status of the feature or record regarding its registration.	valid: accepted and valid reported feature or record; stable: accepted and valid reported record, confirmed by the reporter as correct; experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus	Status of the record regarding its reliability.	A: Normal record; U: Record with lower reliability; V: Unvalidated record
metadata_statements	Aditional information or statements regarding the reliability of the feature or record.
UID	Unique identifier of the record in the EEA WISE_SOE database.

T_WISE4_MonitoringSite_DerivedData (56464 records)

List of monitoring site identifiers present in the WISE4 dataset tables. Contains selected information reported through WFD or WISE5 spatial data reporting.

Element name	Element definition	Value definitions
monitoringSiteIdentifier	Unique international identifier of the monitoring site.
monitoringSiteIdentifierScheme	Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode').	eionetMonitoringSiteCode: EIONET identifier; euMonitoringSiteCode: WFD identifier
waterBodyIdentifier	Unique international identifier of the water body being monitored.
waterBodyIdentifierScheme	Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode').	eionetGroundwaterBodyCode: Groundwater body identifier is an EIONET identifier; eionetSurfaceWaterBodyCode: Surface water body identifier is an EIONET identifier; euGroundwaterBodyCode: Groundwater body identifier is a WFD identifier; euSurfaceWaterBodyCode: Surface water body identifier is a WFD identifier
confidentialityStatus	Information about the sensitivity and confidentiality status of the monitoring site location.	F: Free for publication; N: Not for publication
lon	Longitude of the monitoring site. It is not provided for monitoring sites where publication is restricted.
lat	Latitude of the monitoring site. It is not provided for monitoring sites where publication is restricted.

Waterbase-Water Quality (CSV files)
Download file
Waterbase-Water Quality (SQLite file)
Download file

Additional information

Dataset definition

Definition of the dataset

Dataset definition (CSV file) (ZIP archive)
9.30 KB Download file

Metadata

Reporting obligations (ROD)

WISE SoE - Water Quality (WISE-4)

Relation:

Derived data set: Environmental Accounting Reference Layers - SDI

Rights:

By downloading Waterbase, you are accepting and agreeing to the EEA data policy (http://www.eea.europa.eu/legal/eea-data-policy).

Disclaimer:

Waterbase data is collected and published to produce comparable indicators of pressures, state and impacts on European waters. Waterbase is intended for a European-wide scale of analysis. It is 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.

Methodology:

This Waterbase contains data on nutrients, organic matter, hazardous substances and other chemical substances in surface water and groundwater. It also includes biological data in rivers and lakes, which is reported as ecological quality ratios (EQRs).

The data was delivered between 2000 and 2019 by EEA member countries and cooperating countries, in the scope of the current WISE SoE - Water Quality (WISE-4/WISE-6) reporting obligation and River quality (EWN-1), Lake quality (EWN-2) and Groundwater quality (EWN-3) reporting obligations. Data from 2016 to 2019 also include EU Member States reporting in relation to WFD Watchlist.

The national data deliveries are compiled into a European-wide Waterbase. The data is used for EEA core set indicators that assess the state, trends in water related pressures and monitor the progress of European policy objectives.

Data sources

The original data is available in the EIONET Central Data Repository.

Owners:

European Environment Agency (EEA)

Processors:

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

Permalinks

Permalink to this version: de7e9f32691745999bf3112ae2c4ee6b
Permalink to latest version: DAT-163-en

Older versions

26 Sep 2018 - Waterbase - Water Quality

13 Oct 2016 - Waterbase - Water Quality

Geographic coverage

Albania Austria Belgium Bosnia and Herzegovina Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Iceland Ireland Italy Kosovo (UNSCR 1244/99) Latvia Liechtenstein Lithuania Luxembourg Malta Montenegro Netherlands North Macedonia Norway Poland Portugal Romania Serbia Slovakia Slovenia Spain Sweden Switzerland Turkey United Kingdom