Data

Waterbase - Rivers

Data

Prod-ID: DAT-4-en

Created 21 Jun 2005 Published 21 Jun 2005 Last modified 15 Dec 2022

11 min read

This page was archived on 05 Dec 2016 with reason: Other (The dataset is replaced by Waterbase - Water Quality dataset, which combines Waterbase - Rivers, Lakes and Groundwater into one. It's available at http://www.eea.europa.eu/data-and-maps/data/waterbase-water-quality/.)

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

Data and maps

Menu

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: 2696)

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	Pastoral land use	pastoral 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, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1

pressures_rivers_en_v5.xls (Microsoft Excel spreadsheet)
474.50 KB Download file
pressures_rivers_en_v5.mdb (application/msaccess)
500.00 KB Download file
pressures_rivers_en_v5.csv (text/comma-separated-values)
360.60 KB Download file
pressures_rivers_en_v5.dbf (dBASE document)
1.04 MB Download file

Waterbase-Rivers: QualityWater

The QualityWater 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.

[+] Show table definition (records: 526536)

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	mean 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
NumberOfSamples	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	nvarchar(4)	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, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1

ASCII Delimited (zip) (ZIP archive)
9.14 MB Download file
Access 2000 (zip) (ZIP archive)
12.03 MB Download file

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: 3495)

Latitude	Latitude	(Y) international geographical co-ordinates of the monitoring station in decimal degrees.	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 degrees.	float(8)	0
LargestStation	Largest station	largest station: 1 =yes, 0 = no.	int(1)	0
RepresentativeStation	Representative station	representative station: 1 =yes, 0 = no.	int(1)	0
ReferenceStation	Reference station	reference station: 1 =yes, 0 = no.	int(1)	0
FluxStation	Flux station	flux station: 1 =yes, 0 = no.	int(1)	0
ImpactStation	Impact station	impact station: 1 = yes, 0 = no.	int(1)	0
RevisionYear	Revision year	last year of revision or update of characteristics.	int(4)	0
ParametersNutrients	Parameters nutrients	nutrients and organic matter monitored at station: 1 =yes, 0 = no.	int(1)	0
ParametersHazsubs	Parameters hazardous substances	hazardous substances monitored at station: 1 =yes, 0 = no.	int(1)	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 contain more than one monitoring station.	nvarchar(200)	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(200)	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: 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(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(200)	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(200)	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(200)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements	varchar(2)	0
Country	Country name (ISO 3166-1)	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 name of the groundwater body.	nvarchar(200)	0
WaterBodyType	Water body type	RV = Rivers, LK = Lakes, GW = Groundwater, TCM = Transitional, Coastal and Marine Waters, QA = Water Quantity.	varchar(2)	0
Region	Region	region in which water body is located at the national level.	nvarchar(200)	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, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1
DataSource	Data source	source of data: Eionet-Water, ICES.	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

stations_rivers_en_v5.dbf (dBASE document)
6.46 MB Download file
stations_rivers_en_v5.xls (Microsoft Excel spreadsheet)
1.32 MB Download file
stations_rivers_en_v5.csv (text/comma-separated-values)
833.89 KB Download file
stations_rivers_en_v5.mdb (application/msaccess)
1.32 MB Download file

Additional information

Rivers: metadata of the Pressures table

Rivers: metadata of the Pressures table (text/comma-separated-values)
4.15 KB Download file

Rivers: metadata of the QualityWater table

Rivers: metadata of the QualityWater table (text/comma-separated-values)
2.46 KB Download file

Rivers: metadata of the Stations table

Rivers: metadata of the Stations table (text/comma-separated-values)
5.38 KB Download file

Metadata

Reporting obligations (ROD)

River quality (EWN-1)

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Units:

BOD5, BOD7, COD, CODCr, Dissolved Oxygen, CODMn: mg/l O2 Chlorophyll a: µg/l Kjeldahl Nitrogen, Nitrate, Nitrite, Non-ionised Ammonia, Organic Nitrogen, Total Ammonium, Total Inorganic Nitrogen, Total Oxidised Nitrogen, Total Nitrogen: mg/l N Orthophosphate, Total Phosphorus: mg/l P Oxygen Saturation: % pH: pH Total Organic Carbon: mg/l C

Data sources

The European Topic Centre on Water. Version 5, date of delivery (date sent to the Data Service): 25/04/2005

Owners:

European Environment Agency (EEA)

Processors:

European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

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.

For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-rivers-1 or scan the QR code.

PDF generated on 25 Apr 2024, 01:28 PM