next
previous
items

Reference WATERBASE - Lakes: stations characteristic data

Data Table
This page was archived on 07 Jul 2014 with reason: Other (New version data-and-maps/data/waterbase-lakes-10 was published)
The Stations table contains data on the EUROWATERNET lake monitoring stations' physical characteristics. 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.
Category
European data
Records
1214
Table definition
LakeResidenceTime LakeResidenceTime Average lake residence time expressed in years. Calculated as volume/annual flow float(8) 0
LakeVolume LakeVolume Volume of the lake in Mio m3 float(8) 0
LakeArea LakeArea Surface area of the lake in km2 float(8) 0
Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format float(8) 0
LakeMaxDepth LakeMaxDepth Maximum depth of lake in m float(8) 0
LakeMeanDepth LakeMeanDepth Mean depth of lake in m float(8) 0
CatchmentArea CatchmentArea 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 format float(8) 0
Reservoir Reservoir Indicates whether the lake is a reservoir or ntural lake (1 = reservoir; 0 = lake) int(4) 0
LargestLake LargestLake Indicates whether the lake is considered as one of the largest lakes (1 = yes; 0 = no) int(4) 0
ReferenceLake ReferenceLake Indicates whether the lake is considered a reference lake (1 = yes; 0 = no) int(4) 0
RepresentativeLake RepresentativeLake Indicates whether the lake is considered a representative lake (1 = yes; 0 = no) int(4) 0
NationalStationID NationalStationID Provided at national level nvarchar(20) 0
Region Region Region in which water body is located at the national level nvarchar(100) 0
CountryCode Country code ISO 3166-alpha-2 code elements nvarchar(2) 0
Country Country Official short name in English nvarchar(50) 0
WaterbaseName WaterbaseName Name of the river station, lake or groundwater body nvarchar(200) 0
WaterbaseID WaterbaseID Internally produced, unique identifier used to represent the monitoring stations for rivers or lakes or the groundwater bodies varchar(20) -1
WaterBodyType WaterBodyType R = River, L = Lake, GW = Groundwater varchar(2) 0
Files

Permalinks

Document Actions