Waterbase-Rivers: Stations

Data Table

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/.)

The Stations table contains the physical characteristics of the WISE-SoE 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. Each record has a special quality assurance field. Its meaning is explained in the QA documentation which can be found in the "Additional information" part.

Data and maps

Menu

Category

European data

Records

6369

Table definition

SubsiteLocation	Sub-site location in river	Location of the river sub-site in relation to the principal monitoring site (e.g. right bank, middle, or left bank).	nvarchar(50)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
SeaConventionArea	Marine convention area	name of Marine Convention area of which regional sea is a part.	nvarchar(255)	0
StationSize	Station size	size of station based on upstream catchment area. Small < 50 km², Medium >= 50 km² and < 250 km², Large >= 250 km² and < 1000 km², Very Large >= 1000 km² and < 2500 km², Largest >= 2500 km².	nvarchar(50)	0
Geology	Geology	The dominating geology in the catchment, given according to the WFD Annex 2 categories: Siliceous, calcareous or organic (peat).	nvarchar(10)	0
WaterColourLevel	Water colour average level	Average level of water colour as defined by the WFD intercalibration typology: Low (<30 mg/l Pt = oligohumic), moderate (30-90 mg/l Pt = mesohumic) or high (>90 mg/l Pt = polyhumic).	nvarchar(20)	0
AlkalinityLevel	Alkalinity level	Long-term average level of alkalinity as defined by the WFD intercalibration typology: Low alk. (<0.2 meq/L), moderate alk. (0.2-1 meq/L) or high alk. (>1 meq/L).	nvarchar(20)	0
HMWB	Heavily modified water body	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.	nvarchar(1)	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
CatchmentName	Catchment name	name of major catchment or basin.	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
Region	Region	national region in which water body is located.	nvarchar(255)	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.	int(4)	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.	int(4)	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.	int(4)	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.	int(4)	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.	int(4)	0
QA_coordinates_err	Quality assurance field - station coordinations quality issues flag	the highlighted station coordinations quality issues are explained in the QA documentation	int(4)	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
CatchmentArea	Catchment area	catchment area upstream of the station, in km². 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
WaterColourAverage	Water colour long-term average concentration	Long-term average concentration of water colour, expressing the concentration of humic substances at the station.	numeric(5)	0
AlkalinityAverage	Alkalinity average	Long-term average of alkalinity of water at the station.	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 m³ /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)	-1
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
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
RiverName	River name	national name of river.	nvarchar(255)	0
WaterBodyType	Water body type	RV=river, CN=canal, T=transitional water, C=coastal water, M=marine water.	nvarchar(2)	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
ArtificialWB	Artificial water body	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.	nvarchar(1)	0
Purpose	Purpose of monitoring station	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.	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