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 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 |
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 |
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 |
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 30 May 2023, 07:51 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