Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Rivers

Waterbase - Rivers

Note: new version is available!
Topics: ,
Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources

European data

Waterbase-Rivers: Pressures

The Pressures table contains proxy pressure data on the upstream catchments of Eionet-Water river monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressures data with their respective Stations and Quality data.

[+] Show table definition (records:   2739)

PopulationDensity Population density population density of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set) in capita/km2. numeric(5) 0
LanduseUrban Urban land use urban agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 1.1. numeric(5) 0
LanduseWetland Wetland land use wetland agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 4.1 plus 4.2. numeric(5) 0
LanduseNature Natural land use natural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.2 plus 3.3. numeric(5) 0
LanduseForest Land use forest forested land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.1. numeric(5) 0
LandusetotalAgriculture Total agricultural land use total agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2. numeric(5) 0
LanduseOtherAgriculture Other agricultural land use other agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.2 plus 2.4. numeric(5) 0
LanduseArableLand Arable land use arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. numeric(5) 0
LandusePasture Land use pasture pastoral land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. numeric(5) 0
LanduseOther Other land use other land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). numeric(5) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) 0
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(50) -1
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
Waterbase-Rivers: Quality

The Quality table contains data on nutrients and organic matter in water measured at Eionet-Water river monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data. Each record has two special quality assurance fields. They are explained in QA documentation which can be found in "Additional information" part.

[+] Show table definition (records:   596767)

NumberOfSamples Number of samples number of samples in aggregation period. smallint(2) 0
Year Year year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. int(4) -1
PeriodLength Period length number of months in aggregation period. int(4) 0
QA_outlier Quality assurance field - outlier flag mean value is an outlier for current station and determinand time series: 1=yes, 0=no. bit(1) 0
LimitofDetection Limit of detection 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. numeric(9) 0
LimitofDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). numeric(9) 0
Mean Mean mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Minimum Minimum minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Maximum Maximum maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Median Median median concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
StandardDeviation Standard deviation standard deviation of concentration values of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
10percentile 10th percentile 10th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
90percentile 90th percentile 90th percentile concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) 0
WaterbaseId Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(50) -1
Determinand Determinand determinand name. nvarchar(50) -1
Unit Unit unit of measurement. nvarchar(20) 0
AggregationPeriod Aggregation period period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). nvarchar(20) -1
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
QA_LRviolations Quality assurance field - numerical list of logical rules violated in record tested logical rules are explanained in QA documentation. nvarchar(100) 0
Waterbase-Rivers: Microsoft Access database (3 tables)

Database contains all data tables. Includes also simple relation structure. Detailed table definitions are displayed in the section with individual tables.

Waterbase-Rivers: Stations

The Stations table contains the physical characteristics of the Eionet-Water river monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressures data.

[+] Show table definition (records:   3591)

RevisionYear Revision year last year of revision or update of characteristics in format YYYY. int(4) 0
ParametersNutrients Parameters nutrients nutrients and organic matter monitored at station. 1=yes, 0=no. bit(1) 0
ParametersHazSubs Parameters hazardous substances hazardous substances monitored at station. 1=yes, 0=no. bit(1) 0
ReferenceStation Reference station reference station type, 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. Concentrations of nutrients or hazardous substances occurring naturally would give an indication of background levels. For volatile sunthetic substances, data from these stations might be used to assess the significance of atmospheric deposition. River and lake stations can be of more than one type. 1=yes, 0=no. bit(1) 0
FluxStation Flux station flux station type, used for assessment of international, transboundary loads or loads entering Europe's seas. River and lake stations can be of more than one type. 1=yes, 0=no. bit(1) 0
ImpactStation Impact station impact station type, located within the zone where initial mixing of discharges takes place with receiving waters. Concentrations may be worst-case. Impact stations may be used to assess the compliance of discharges with standards established for hazardous substances and may be included in operational monitoring programmes as required by the WFD. Data are not required from investigative monitoring stations. River and lake stations can be of more than one type. 1=yes, 0=no. bit(1) 0
LargeStstation Largest station largest, most important station type, including the nationally most important or well known rivers or lakes. Some stations are likely to be monitored for the EU Exchange of Information Decision. River and lake stations can be of more than one type. 1=yes, 0=no. bit(1) 0
RepresentativeStation Representative station representative station type, reflecting the general quality of rivers, lakes, transitional or coastal water bodies or marine water areas. Quality influenced by diffuse and/or point sources of pollution from upstream activities. Pollutants from point sources would be fully mixed and diluted within the ambient water flow/volume. Stations may be part of national networks monitoring nutrients, organic matter and hazardous substances. They may be included in surveillance and/or operational monitoring programmes as required by the WFD. River and lake stations can be of more than one type. 1=yes, 0=no. bit(1) 0
CatchmentArea Catchment area catchment area upstream of the station, in km2. For lakes, the catchment area upstream of the lake is shown. If more than one station exists in the lake, the catchment area value should be the same for all stations numeric(9) 0
Altitude Altitude altitude of station in m above sea level. For lakes, the altitude of the lake is provided. numeric(5) 0
Longitude Longitude (X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided. numeric(5) 0
Latitude Latitude (Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided. numeric(5) 0
RiverLength River length river length from monitoring station to source in km. numeric(5) 0
RiverDischarge River discharge mean long term annual river discharge in m3 /s at the monitoring station. numeric(5) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) 0
Country Country name official short name in English. ISO 3166-1. nvarchar(255) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(50) -1
DataSource Data source source of data: Eionet-Water, ICES. nvarchar(50) 0
WaterDataSet Water data set RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity. nvarchar(255) 0
WaterBodyType Water body type RV=river, CN=canal, T=transitional water, C=coastal water, M=marine water. nvarchar(2) 0
SeaConventionArea Marine convention area name of Marine Convention area of which regional sea is a part. nvarchar(255) 0
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
StationSize Station size size of station based on upstream catchment area. Small < 50 km2, Medium >= 50 km2 and < 250 km2, Large >= 250 km2 and < 1000 km2, Very Large >= 1000 km2 and < 2500 km2, Largest >= 2500 km2. nvarchar(50) 0
WaterBodyID Water body ID national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. nvarchar(255) 0
WaterBodyName Water body name name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. nvarchar(255) 0
RiverbasinDistrict River basin district name or identifier of the River Basin District in which the water body is located. River Basin Districts as required/defined by the Water Framework Directive. nvarchar(255) 0
SeaAreaName Sea area name name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName. nvarchar(255) 0
SeaRegionName Sea region name name of regional sea of which local sea area is a part. nvarchar(255) 0
WaterbaseName Waterbase name name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or the name of the groundwater body. nvarchar(255) 0
NationalStationid National station ID identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station. nvarchar(255) 0
RiverName River name national name of river. nvarchar(255) 0
CatchmentName Catchment name name of major catchment or basin. nvarchar(255) 0
Region Region national region in which water body is located. nvarchar(255) 0
StationType Station type type of monitoring station: B=reference, F=flux, I=impact, L=largest, most important, R=representative. Stations can be of more than one type, listed alphabetically with no separator (e.g. FL). nvarchar(50) 0

Additional information

Tables metadata

File contains metadata definitions of all data tables.

QA documentation

Quality control documentation briefly presents 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.

Country codes and abbreviations (33 records)

Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Rivers version 7

Metadata

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water 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 Eionet-Water 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.

 
Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100