Waterbase - TCM: FluxStations

Data Table expired
This content has been archived on 26 Jun 2015, reason: Other (New version data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-11 was published)
The FluxStations table contains the physical characteristics of the Eurowaternet transitional, coastal and marine water stations used to monitor riverine input loads. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the FluxStations with their respective Input (load) data.
European data
Table definition
SeaConventionArea Sea convention area marine Convention area of which regional sea is a part: BSC, HELCOM, HELCOM/OSPAR, OSPAR, UNEP/MAP. nvarchar(50) 0
SeaRegionName Sea region name name of regional sea of which sea area is a part. nvarchar(200) 0
CatchmentName Catchment name catchment name at the national level, referring to major river catchment or basin draining into transitional or coastal water. nvarchar(100) 0
NationalStationID National station ID identifier of the transitional, coastal or marine water flux station, unique at the national level. The identifier should be the same as previously supplied to represent the (flux) river monitoring station. nvarchar(200) 0
SeaAreaName Sea area name name of local sea area in which station is located. WaterBodyName and SeaAreaName may be the same. nvarchar(200) 0
RiverName River name river name at the national level. nvarchar(200) 0
WaterBodyName Water body name water body name as defined for the Water Framework Directive. nvarchar(200) 0
Country Country name (ISO 3166-1) Official short name in English. nvarchar(50) 0
WaterbaseName Waterbase Name name of the transitional, coastal or marine water monitoring station. nvarchar(200) 0
Longitude Longitude (X) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
CountryCode Country Code ISO 3166-alpha-2 code elements. varchar(2) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the flux monitoring station, in the format CountryCode_WaterDataSetF_NationalStationID (e.g. GB_TCMF_12345). Due to the inclusion of the WaterDataSet code and the “F” (TCMF), the WaterbaseID for a flux station will always differ from the WaterbaseID of other stations, even if the same NationalStationID is used. varchar(200) -1
DataSource Data source source of data: Eurowaternet, ICES. varchar(50) 0
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Phone: +45 3336 7100