Title,Note,,, Waterbase-Rivers: Stations,The Stations table contains the physical characteristics of the Eionet-Water 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.,,, Item,Definition,note,Data Type,Key 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 CatchmentName,Catchment name,"catchment name at the national level. For transitional, coastal and marine waters, catchment name refers to major river catchment or basin draining into transitional or coastal water.",nvarchar(200) ,No Country,Country name (ISO 3166-1),short name in English,nvarchar(50),No CountryCode,Country code,ISO 3166-alpha-2 code elements,varchar(2) ,No DataSource,Data source,"source of data: Eionet-Water, ICES.",varchar(50),No FluxStation,Flux station,"flux station: 1 =yes, 0 = no.",int(1) ,No ImpactStation,Impact station,"impact station: 1 = yes, 0 = no.",int(1) ,No LargestStation,Largest station,"largest station: 1 =yes, 0 = no.",int(1) ,No Latitude,Latitude,(Y) international geographical co-ordinates of the monitoring station in decimal degrees.,float(8),No Longitude,Longitude,(X) international geographical co-ordinates of the monitoring station in decimal degrees.,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 ParametersHazsubs,Parameters hazardous substances,"hazardous substances monitored at station: 1 =yes, 0 = no.",int(1) ,No ParametersNutrients,Parameters nutrients,"nutrients and organic matter monitored at station: 1 =yes, 0 = no.",int(1) ,No ReferenceStation,Reference station,"reference station: 1 =yes, 0 = no.",int(1) ,No Region,Region,region in which water body is located at the national level.,nvarchar(200) ,No RepresentativeStation,Representative station,"representative station: 1 =yes, 0 = no.",int(1) ,No RevisionYear,Revision year,last year of revision or update of characteristics.,int(4),No RiverBasinDistrict,River basin district,national 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(200) ,No RiverDischarge,River discharge,mean long term annual river discharge in m3/s at the monitoring station.,float(8),No RiverLength,River length,river length from monitoring station to source in km.,float(8),No RiverName,River name,river name at the national level.,nvarchar(200) ,No SeaAreaName,Sea area name,"sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature.",nvarchar(100),No SeaConventionArea,Marine convention area,name of marine convention area.,nvarchar(100),No SeaRegionName,Sea region name,regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature.,nvarchar(100),No StationSize,Station size,"size of station based on upstream catchment area: < 50 km2: Small, >= 50 km2 and < 250 km2: Medium, >= 250 km2 and < 1000 km2: Large, >= 1000 km2 and < 2500 km2: Very Large, >= 2500 km2: Largest.",nvarchar(20),No StationType,Station type,"type of monitoring station: B = Reference, F = Flux, I = Impact, L = Largest, Most Important, R = Representative. Stations can be of more than one type, listed alphabetically with no separator (e.g. FL).",nvarchar(30),No WaterbaseID,Waterbase ID,"internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).",varchar(200),Yes WaterbaseName,Waterbase name,"name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or name of the groundwater body.",nvarchar(200),No WaterBodyID,Waterbody ID,national identification code of water body (if applicable) in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station.,nvarchar(200) ,No WaterBodyName,Water body name,name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station.,nvarchar(200) ,No WaterBodyType,Water body type,"RV = Rivers, LK = Lakes, GW = Groundwater, TCM = Transitional, Coastal and Marine Waters, QA = Water Quantity. ",varchar(2),No WaterDataset,Water data set,"RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine Water, QA = Water Quantity.",varchar(3),No