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 - Lakes / Waterbase-Lakes: Stations

Waterbase-Lakes: Stations

The Stations table contains the physical characteristics of the WISE-SoE lake 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 two special quality assurance fields. Its meaning is explained in the QA documentation which can be found in the "Additional information" section.
Category
European data
Records
2544
Table definition
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. float(8) 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. float(8) 0
Altitude Altitude altitude of station in m above sea level. For lakes, the altitude of the lake is provided. float(8) 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. float(8) 0
SurfaceArea Surface area Surface area of lake in square kilometres. float(8) 0
MeanDepth Mean depth Mean depth of the lake in metres. float(8) 0
MaximumDepth Maximum depth Maximum depth of the lake in metres. float(8) 0
ResidenceTime Residence time Average lake residence time in years calculated as volume/annual flow. float(8) 0
Volume Lake volume Volume of water in lake in million cubic metres. float(8) 0
WaterColourAverage Water colour long-term average concentration Long-term average concentration of water colour, expressing the concentration of humic substances at the station. float(8) 0
AlkalinityAverage Alkalinity average Long-term average of alkalinity of water at the station. float(8) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) -1
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(60) -1
NationalStationID National station ID Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. nvarchar(60) 0
EU_CD WFD code of monitoring station nvarchar(30) 0
EUCD_NATRB WFD code of river basin district nvarchar(15) 0
WaterbaseName Waterbase name national name of station or groundwater body. nvarchar(255) 0
SamplingDepth Sampling depth Depth at which sample taken in metres below the lake surface. nvarchar(255) 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
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
QA_station_problems Quality assurance field - stations data quality issues flag the highlighted stations data quality issues are explained in the QA documentation nvarchar(50) 0
QA_datatype_errors Quality assurance field - data type and data definition errors list of field names and their values where values do not follow official specifications. Details are explained in the QA documentation 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
LakeReservoir Reservoir, non-natural lake nvarchar(1) 0
Location Location Location of the lake monitoring site (e.g. main outlet of lake, centre of lake, etc.) nvarchar(255) 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(10) 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(10) 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. nvarchar(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. nvarchar(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. nvarchar(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. nvarchar(1) 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
LakeName Name of Lake 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(50) 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
Files

Geographic coverage

Comments

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