All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
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 river 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 River Monitoring Stations (Waterbase_rivers_v12_Stations, 12071 records)
Physical characteristics of the WISE-SoE river 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, '_RV_' and NationalStationID | text(100) |
NationalStationID | Identifier of the river 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) | |
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 river sub-site in relation to the principal monitoring site. | 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 |
Proxy Pressures of Rivers (Waterbase_rivers_v12_Pressures, 8028 records)
Proxy pressure data on the upstream catchments of WISE-SoE river 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, '_RV_' and NationalStationID | text(100) |
NationalStationID | Identifier of the river 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 Rivers (Waterbase_rivers_v12_Nutrients, 1024279 records)
Data on nutrients and organic matter in water measured at WISE-SoE river 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, '_RV_' and NationalStationID | text(100) |
NationalStationID | Identifier of the river 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. | text(20) | |
AggregationPeriod_original | 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 | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
AggregatedBy | Subject(s) that aggregated the data. | text(20) | |
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 |
Hazardous Substances and Other Chemical Determinands in Rivers (Waterbase_rivers_v12_HazSubs, 644142 records)
Data on hazardous substances and other chemical determinands in water measured at WISE-SoE river 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, '_RV_' and NationalStationID | text(100) |
NationalStationID | Identifier of the river 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 | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
AggregatedBy | Subject(s) that aggregated the data. | text(20) | |
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_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 Rivers (Waterbase_rivers_v12_SuppDet, 64599 records)
Data on supportive determinands, supplementing information on hazardous substances in water measured at WISE-SoE river 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, '_RV_' and NationalStationID | text(100) |
NationalStationID | Identifier of the river 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 | 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_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 |
This separate dataset contains data for the biological quality elements (BQEs) phytobenthos and macroinvertebrates from WISE-SoE river 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 rivers data.
[+] Show table definition
Physical Characteristics of River Monitoring Stations (Waterbase_rivers_v12_StationsBiology, 4688 records)
Physical Characteristics of the WISE-SoE River 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 river 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) | |
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 river sub-site in relation to the principal monitoring site. | text(50) | |
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 Rivers (Waterbase_rivers_v12_Biology, 8678 records)
EQR (ecological quality ratio) values for phytobenthos and macroinvertebrates in rivers measured at WISE-SoE river 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 river 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 Rivers (Waterbase_rivers_v12_Classification, 1256 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 |
Definition and field description of all data tables.
Lists and description of codes of selected fields present in the Waterbase-Rivers data tables
Quality control documentation briefly presents ETC-ICM and EEA activities focused on quality of Waterbase-Rivers dataset and results of these activities. In addition warning is given on the use of certain records for analytical purposes.
Graphical annexes.
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the WISE-SoE data collection (formerly known as Eurowaternet and Eionet-Water) 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-rivers-8 or scan the QR code.
PDF generated on 06 Jun 2023, 11:33 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