Waterbase-Lakes: Stations

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 the physical characteristics of the Eurowaternet 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 Pressure data.

Data and maps

Menu

Category

European data

Records

1419

Table definition

LakeResidenceTime	Lake Residence Time	average lake residence time expressed as years.	float(8)	0
LakeVolume	Lake Volume	volume of water in lake in Mio m3.	float(8)	0
LakeArea	Lake Area	surface area of 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	Lake Maximum Depth	maximum depth of the lake in m.	float(8)	0
LakeMeanDepth	Lake Mean Depth	mean depth of the lake in m.	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 format.	float(8)	0
Reservoir	Reservoir	indicates whether the lake is a reservoir or a natural lake (1 = yes (reservoir), 0 = no (lake)).	int(4)	0
LargestLake	Largest Lake	indicates whether the lake is considered as one of the largest lakes (1 = yes, 0 = no).	int(4)	0
ReferenceLake	Reference Lake	indicates whether the lake is considered a reference lake (1 = yes, 0 = no).	int(4)	0
RepresentativeLake	Representative Lake	indicates whether the lake is considered a representative lake (1 = yes, 0 = no).	int(4)	0
Country	Country	official 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 the name of the groundwater body.	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
WaterDataset	Water data set	RV = river, LK = lake, GW = groundwater, TCM = transitional, coastal or marine water, QA = water quantity.	varchar(3)	0
Region	Region	region in which water body is located at the national level.	varchar(100)	0
CountryCode	Country Code	ISO3166 two digit code	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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1
DataSource	Data source	source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC.	varchar(50)	0