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 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. The data has been compiled and processed by ETC-ICM and EEA. Please refer to the metadata for additional information.
[+] Show table definition
Sample data by monitoring site (WISE4_DisaggregatedData, 22699536 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.
| FieldName | Definition | DataType |
|---|---|---|
| UID | Unique identifier of the record in the EEA WISE SOE database. | int |
| versionId | Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data. | nvarchar (255) |
| beginLifeSpanVersion | Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database. | datetime |
| monitoringSiteIdentifier | Unique international identifier of the monitoring site in which the data were obtained. | nvarchar (42) |
| monitoringSiteIdentifierScheme | Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode'). | nvarchar (255) |
| parameterWaterBodyCategory | Water body category code, as defined in the codelist. | nvarchar (255) |
| observedPropertyDeterminandCode | Unique code of the determinand monitored, as defined in the codelist. | nvarchar (255) |
| procedureAnalysedFraction | Specification of which fraction of the sample was analysed. | nvarchar (255) |
| procedureAnalysedMedia | Type of media monitored. | nvarchar (255) |
| resultUom | Unit of measure for the reported values. | nvarchar (255) |
| phenomenonTimeSamplingDate | Date in which the sample was taken. | datetime |
| resultObservedValue | Observed value (e.g. concentration) of the determinand in the sample. | float |
| resultQualityObservedValueBelowLOQ | Flag to indicate whether the sample value was below the analytical limit of quantification (LOQ). | smallint |
| procedureLOQValue | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | float |
| procedureAnalyticalMethod | CEN/ISO code of the analytical method. | nvarchar (255) |
| parameterSampleDepth | Depth at which sample was taken in meter below water surface. | float |
| resultObservationStatus | Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. | nvarchar (255) |
| Remarks | Remarks, comments or explanatory notes. | nvarchar (max) |
| waterbaseObservationStatus | Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability | nvarchar (100) |
| waterbaseRemarks | Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing. | nvarchar (max) |
Annual statistics data by monitoring site (WISE4_AggregatedData, 8742960 records)
Annual mean values and other statistics of determinands on water quality, by monitoring site.
| FieldName | Definition | DataType |
|---|---|---|
| UID | Unique identifier of the record in the EEA WISE SOE database. | int |
| versionId | Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data. | nvarchar (255) |
| beginLifeSpanVersion | Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database. | datetime |
| monitoringSiteIdentifier | Unique international identifier of the monitoring site in which the data were obtained. | nvarchar (42) |
| monitoringSiteIdentifierScheme | Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode'). | nvarchar (255) |
| parameterWaterBodyCategory | Water body category code, as defined in the codelist. | nvarchar (255) |
| observedPropertyDeterminandCode | Unique code of the determinand monitored, as defined in the codelist. | nvarchar (255) |
| procedureAnalysedFraction | Specification of which fraction of the sample was analysed. | nvarchar (255) |
| procedureAnalysedMedia | Type of media monitored. | nvarchar (255) |
| resultUom | Unit of measure for the reported values. | nvarchar (255) |
| phenomenonTimeReferenceYear | Year during which the data were sampled. | int |
| parameterSamplingPeriod | The period of the year during which the data used for the aggregation were sampled. | nvarchar (22) |
| procedureLOQValue | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | float |
| resultNumberOfSamples | Number of sample values included in the aggregated data. | int |
| resultQualityNumberOfSamplesBelowLOQ | Number of sample values below LOQ included in the aggregated data. | int |
| resultQualityMinimumBelowLOQ | Flag to indicate whether the minimum sample value used for the aggregation was below the analytical limit of quantification (LOQ). | smallint |
| resultMinimumValue | Minimum sample value of the data used for aggregation. | float |
| resultQualityMeanBelowLOQ | Flag to indicate whether the mean value is below the highest LOQ. | smallint |
| resultMeanValue | Mean value of the data used for aggregation. | float |
| resultQualityMaximumBelowLOQ | Flag to indicate whether the maximum sample value used for the aggregation was below the analytical limit of quantification (LOQ). | smallint |
| resultMaximumValue | Maximum sample value of the data used for aggregation. | float |
| resultQualityMedianBelowLOQ | Flag to indicate whether the median value is below the highest LOQ. | smallint |
| resultMedianValue | Median value of the data used for aggregation. | float |
| resultStandardDeviationValue | Standard deviation value of the data used for aggregation. | float |
| procedureAnalyticalMethod | CEN/ISO code of the analytical method. | nvarchar (255) |
| parameterSampleDepth | Depth at which sample was taken in meter below water surface. | float |
| resultObservationStatus | Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. | nvarchar (255) |
| Remarks | Remarks, comments or explanatory notes. | nvarchar (max) |
| waterbaseObservationStatus | Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability | nvarchar (100) |
| waterbaseRemarks | Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing. | nvarchar (max) |
Annual statistics data by water body (WISE4_AggregatedDataByWaterBody, 19789 records)
Annual mean values and other statistics of determinands on water quality, by water body.
| FieldName | Definition | DataType |
|---|---|---|
| UID | Unique identifier of the record in the EEA WISE SOE database. | int |
| versionId | Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data. | nvarchar (255) |
| beginLifeSpanVersion | Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database. | datetime |
| waterBodyIdentifier | Unique international identifier of the water body in which the data were obtained. | nvarchar (42) |
| waterBodyIdentifierScheme | Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode'). | nvarchar (255) |
| parameterWaterBodyCategory | Water body category code, as defined in the codelist. | nvarchar (255) |
| observedPropertyDeterminandCode | Unique code of the determinand monitored, as defined in the codelist. | nvarchar (255) |
| procedureAnalysedFraction | Specification of which fraction of the sample was analysed. | nvarchar (255) |
| procedureAnalysedMedia | Type of media monitored. | nvarchar (255) |
| resultUom | Unit of measure for the reported values. | nvarchar (255) |
| phenomenonTimeReferenceYear | Year during which the data were sampled. | int |
| parameterSamplingPeriod | The period of the year during which the data used for the aggregation were sampled. | nvarchar (22) |
| procedureLOQValue | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | float |
| resultNumberOfSamples | Number of sample values included in the aggregated data. | int |
| resultQualityNumberOfSamplesBelowLOQ | Number of sample values below LOQ included in the aggregated data. | int |
| resultQualityMinimumBelowLOQ | Flag to indicate whether the minimum sample value used for the aggregation was below the analytical limit of quantification (LOQ). | smallint |
| resultMinimumValue | Minimum sample value of the data used for aggregation. | float |
| resultQualityMeanBelowLOQ | Flag to indicate whether the mean value is below the highest LOQ. | smallint |
| resultMeanValue | Mean value of the data used for aggregation. | float |
| resultQualityMaximumBelowLOQ | Flag to indicate whether the maximum sample value used for the aggregation was below the analytical limit of quantification (LOQ). | smallint |
| resultMaximumValue | Maximum sample value of the data used for aggregation. | float |
| resultQualityMedianBelowLOQ | Flag to indicate whether the median value is below the highest LOQ. | smallint |
| resultMedianValue | Median value of the data used for aggregation. | float |
| resultStandardDeviationValue | Standard deviation value of the data used for aggregation. | float |
| resultNumberOfSitesClass1 | Number of monitoring sites with annual average concentration of the given determinand within Class 1 boundaries. | int |
| resultNumberOfSitesClass2 | Number of monitoring sites with annual average concentration of the given determinand within Class 2 boundaries. | int |
| resultNumberOfSitesClass3 | Number of monitoring sites with annual average concentration of the given determinand within Class 3 boundaries. | int |
| resultNumberOfSitesClass4 | Number of monitoring sites with annual average concentration of the given determinand within Class 4 boundaries. | int |
| resultNumberOfSitesClass5 | Number of monitoring sites with annual average concentration of the given determinand within Class 5 boundaries. | int |
| resultObservationStatus | Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. | nvarchar (255) |
| Remarks | Remarks, comments or explanatory notes. | nvarchar (max) |
| waterbaseObservationStatus | Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability | nvarchar (100) |
| waterbaseRemarks | Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing. | nvarchar (max) |
Annual biology EQR data by monitoring site (WISE4_BiologyEQRData, 20932 records)
Annually aggregated biological ecological quality ratio (EQR) data from rivers and lakes, by monitoring site.
| FieldName | Definition | DataType |
|---|---|---|
| UID | Unique identifier of the record in the EEA WISE SOE database. | int |
| versionId | Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data. | nvarchar (255) |
| beginLifeSpanVersion | Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database. | datetime |
| monitoringSiteIdentifier | Unique international identifier of the monitoring site in which the data were obtained. | nvarchar (42) |
| monitoringSiteIdentifierScheme | Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode'). | nvarchar (255) |
| parameterWaterBodyCategory | Water body category code, as defined in the codelist. | nvarchar (255) |
| parameterNCSWaterBodyType | Type of water body as defined by the member state. | nvarchar (50) |
| observedPropertyDeterminandBiologyEQRCode | Determinand code for biological metrics, as defined in the vocabulary. | nvarchar (255) |
| phenomenonTimeReferenceYear | Year during which the data were sampled. | int |
| parameterSamplingPeriod | The period of the year during which the data used for the aggregation were sampled. | nvarchar (22) |
| resultEcologicalStatusClassValue | Ecological status class (or ecological potential class, for artificial and heavily modified water bodies) assessed on the basis of the reported biological determinand. | nvarchar (255) |
| resultNumberOfSamples | Number of sample values included in the aggregated data. | int |
| resultEQRValue | Mean value of the biological metric converted to the national Ecological Quality Ratio (EQR) scale. | float |
| resultNormalisedEQRValue | Mean value of metric converted to normalised EQR scale (Ecological Quality Ratio). | float |
| resultObservationStatus | Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. | nvarchar (255) |
| Remarks | Remarks, comments or explanatory notes. | nvarchar (max) |
| waterbaseObservationStatus | Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability | nvarchar (100) |
| waterbaseRemarks | Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing. | nvarchar (max) |
Classification procedure for ecological status or potential status based on biology EQR data (WISE4_BiologyEQRClassificationProcedure, 1459 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.
| FieldName | Definition | DataType |
|---|---|---|
| UID | Unique identifier of the record in the EEA WISE SOE database. | int |
| versionId | Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data. | nvarchar (255) |
| beginLifeSpanVersion | Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database. | datetime |
| CountryCode | Abbreviation of EEA Member or Collaborating Country, as defined in the codelist. | nvarchar (2) |
| observedPropertyDeterminandBiologyEQRCode | Determinand code for biological metrics, as defined in the vocabulary. | nvarchar (255) |
| parameterWaterBodyCategory | Water body category code, as defined in the codelist. | nvarchar (255) |
| parameterNCSWaterBodyType | Type of water body as defined by the member state. | nvarchar (255) |
| parameterWFDIntercalibrationWaterBodyType | Type of water body as defined by the WFD Intercalibration process. | nvarchar (255) |
| 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. | nvarchar (255) |
| parameterICStatusOfDeterminandBiologyEQR | Has the biological determinand been intercalibrated? | smallint |
| parameterBoundaryValueClasses12 | Boundary between High and Good ecological status or potential classes, for a given biological determinand and water body type. | float |
| parameterBoundaryValueClasses23 | Boundary between Good and Moderate ecological status or potential classes, for a given biological determinand and water body type. | float |
| parameterBoundaryValueClasses34 | Boundary between Moderate and Poor ecological status or potential classes, for a given biological determinand and water body type. | float |
| parameterBoundaryValueClasses45 | Boundary between Poor and Bad ecological status or potential classes, for a given biological determinand and water body type. | float |
| procedureBiologicalAnalyticalMethodDescription | Written explanation and/or URL (free text). If possible, use CEN/ISO code (http://dd.eionet.europa.eu/data_element.jsp?mode=view&delem_idf=CEN_ISO) | nvarchar (255) |
| resultObservationStatus | Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. | nvarchar (255) |
| Remarks | Remarks, comments or explanatory notes. | nvarchar (max) |
| waterbaseObservationStatus | Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability | nvarchar (100) |
| waterbaseRemarks | Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing. | nvarchar (max) |
Waterbase-Water Quality (CSV files)
(ZIP archive)
Waterbase-Water Quality (SQLLite file)
(ZIP archive)
Field descriptions of all data tables.
Table definitions (XLSX file)
(Microsoft Excel (Office 2010))
Table definitions (CSV file)
(ZIP archive)
List and description of codes of fields present in the data tables
Code lists (XLSX file)
(Microsoft Excel (Office 2010))
Code lists (CSV files)
(text/comma-separated-values)
Rights:
Disclaimer:
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 2016 by EEA member countries and cooperating countries, in the scope of the current WISE SoE - Water Quality (WISE-4) reporting obligation and River quality (EWN-1), Lake quality (EWN-2) and Groundwater quality (EWN-3) reporting obligations.
The national data deliveries are compiled by ETC/ICM 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:
Processors:
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-water-quality or scan the QR code.
PDF generated on 02 Apr 2023, 04:45 AM
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