Waterbase - Water Quality (5 tables)

Data Table

10 min read

This is an old version, kept for reference only.

Go to latest version

This page was archived on 26 Sep 2018 with reason: Other (New version data-and-maps/data/waterbase-water-quality-1/waterbase-water-quality-5-tables was published)

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.

Data and maps

Menu

Category

European data

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)