Waterbase - TCM: FluxStations

Data Table

This page was archived on 26 Jun 2015 with 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.

Data and maps

Menu

Category

European data

Records

100

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