Title,Note,,, WATERBASE-Lakes: Stations,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.,,, Item,Definition,Note,Data Type,Key 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),Yes Altitude,Altitude,altitude of monitoring station in m above sea level.,float(8),No CatchmentArea,Catchment Area,upstream catchment area in km2.,float(8),No Country,Country,official short name in English,nvarchar(50),No CountryCode,Country Code,ISO3166 two digit code,varchar(2),No DataSource,Data source,"source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC.",varchar(50),No LakeArea,Lake Area,surface area of lake in km2.,float(8),No LakeMaxDepth,Lake Maximum Depth,maximum depth of the lake in m.,float(8),No LakeMeanDepth,Lake Mean Depth,mean depth of the lake in m.,float(8),No LakeResidenceTime,Lake Residence Time,average lake residence time expressed as years.,float(8),No LakeVolume,Lake Volume,volume of water in lake in Mio m3.,float(8),No LargestLake,Largest Lake,"indicates whether the lake is considered as one of the largest lakes (1 = yes, 0 = no).",int(4),No Latitude,Latitude,(Y) International geographical co-ordinates of the monitoring station in decimal degrees format.,float(8),No Longitude,Longitude,(X) International geographical co-ordinates of the monitoring station in decimal degrees format.,float(8),No 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),No ReferenceLake,Reference Lake,"indicates whether the lake is considered a reference lake (1 = yes, 0 = no).",int(4),No Region,Region,region in which water body is located at the national level.,varchar(100),No RepresentativeLake,Representative Lake,"indicates whether the lake is considered a representative lake (1 = yes, 0 = no).",int(4),No Reservoir,Reservoir,"indicates whether the lake is a reservoir or a natural lake (1 = yes (reservoir), 0 = no (lake)).",int(4),No 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),No WaterDataset,Water data set,"RV = river, LK = lake, GW = groundwater, TCM = transitional, coastal or marine water, QA = water quantity.",varchar(3),No