Personal tools

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: QualityWater

The QualityWater table contains data on nutrients and organic matter in water measured at Eurowaternet river monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the QualityWater data with their respective Stations and Pressure data.

[+] Show table definition (records:   492752)

StandardDeviation Standard Deviation standard Deviation of concentration during aggregation period. float(8) 0
10Percentile 10th Percentile 10th Percentile concentration during aggregation period. float(8) 0
90Percentile 90th Percentile 90th Percentile concentration during aggregation period float(8) 0
Minimum Minimum minimum concentration during aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. float(8) 0
Median Median median concentration during aggregation period. float(8) 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. float(8) 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%). float(8) 0
Mean Mean average concentration during aggregation period. float(8) 0
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
PeriodLength Period Length number of months in aggregation period. int(4) 0
NoOfSamples Number Of Samples number of samples in aggregation period. int(4) 0
AggregationPeriod Aggregation Period period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
Determinand Determinand determinand name. nvarchar(200) 0
Unit Unit unit of measurement. nvarchar(30) 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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). varchar(200) -1
LimitOfDetectionFlag Limit Of Detection Flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
Waterbase-Rivers: Pressures

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

[+] Show table definition (records:   2400)

LanduseOther Other Land Use other land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseOtherAgriculture Other Agricultural Land Use other agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseArableLand Arable Land Use arable land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LandusePasture Pastural Land Use pastural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseNature Natural Land Use natural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseForest Forested Land Use forested land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseTotalAgriculture Total Agricultural Land Use total agricultural land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
PopulationDensity Population Density population density (capita/km2) of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseUrban Urban Land Use urban land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
LanduseWetland Wetland Land Use wetland land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). varchar(200) -1
Waterbase-Rivers: Stations

The Stations table contains the physical characteristics of the Eurowaternet 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 Pressure data.

[+] Show table definition (records:   3438)

Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
RiverDischarge River Discharge mean long term annual river discharge in m3/s at the monitoring station. float(8) 0
RiverLength River Length river length from monitoring station to source in km. float(8) 0
CatchmentArea Catchment area upstream catchment area in km2. float(8) 0
Altitude Altitude altitude of monitoring station in m above sea level. float(8) 0
Longitude Longitude (X) International Geographical Co-ordinates of the monitoring station in decimal format. float(8) 0
RevisionYear Revision Year last year of revision or update of characteristics. int(4) 0
SeaRegionName Sea Region Name regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. nvarchar(100) 0
SeaConventionArea Marine Convention Area name of Marine Convention area. nvarchar(100) 0
WaterBodyName Water Body Name name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may have more than one monitoring station in it. nvarchar(100) 0
RiverBasinDistrict River Basin District national 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(100) 0
SeaAreaName Sea Area Name sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature. nvarchar(100) 0
StationType Station Type type of monitoring station. For rivers, lakes and groundwater: B = Reference, R = Representative, F = Flux, L = Largest, Most Important, I = Impact. For transitional, coastal and marine waters: B = Reference, R(PHYS) = station Representative of general conditions in terms of physico-chemical quality elements (organic matter and nutrients), I(PHYS) = station Impacted directly by discharges affecting physico-chemical conditions (organic matter and nutrients), R(HZ) = station Representative of general conditions in terms of hazardous substances, I(HZ) = station Impacted directly by discharges containing hazardous substances. Stations can be of more than one type. If so, types will be listed alphabetically with no separator e.g. FL or R(PHYS)R(HZ). nvarchar(30) 0
StationSize Station Size size of station based on upstream catchment area: < 50 km2: Small, >= 50 km2 and < 250 km2: Medium, >= 250 km2 and < 1000 km2: Large, >= 1000 km2 and < 2500 km2: Very Large, >= 2500 km2: Largest. nvarchar(20) 0
WaterbodyID Waterbody ID national identification code of water body (if applicable) in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station. nvarchar(100) No WaterBodyName Water Body Name Name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may have more than one monitoring station in it. nvarchar(100) 0
NationalStationID National Station ID national station identifier for rivers, lakes, transitional, coastal and marine waters and water quantity monitoring station. For transitional, coastal and marine waters, areas are recorded and reported as a discrete location, but location may relate to a station at a fixed geographical point, a broader area in which sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. When calculating loads, the national station identifier used should be the same ID previously supplied to represent the (flux) river monitoring station. nvarchar(200) 0
RiverName River Name river name at the national level. nvarchar(100) 0
CatchmentName Catchment name catchment name at the national level. For transitional, coastal and marine waters, catchment name refers to major river catchment or basin draining into transitional or coastal water. nvarchar(100) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
Country Country official short name in English. nvarchar(50) 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(200) 0
Region Region region in which water body is located at the national level. varchar(100) 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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). varchar(200) -1
DataSource Data source source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC. varchar(50) 0
WaterDataset Water data set RV = river, LK = lake, GW = groundwater, TCM = transitional, coastal or marine water, QA = water quantity. varchar(3) 0

Additional information

Rivers: metadata of the Pressures table
Rivers: metadata of the Stations table
Rivers: metadata of the QualityWater table

Metadata

Additional information

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

 

Comments

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