Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Transitional, coastal and marine waters / Waterbase - TCM: Stations

Waterbase - TCM: Stations

The Stations table contains the physical characteristics of the Eurowaternet transitional, coastal and marine water 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.
Category
European data
Records
35154
Table definition
SeaConventionArea Marine convention area Marine Convention area of which regional sea is a part: BSC, HELCOM, HELCOM/OSPAR, OSPAR, UNEP/MAP. nvarchar(50) 0
WaterbaseName Waterbase name name of the transitional, coastal or marine water monitoring station. nvarchar(200) 0
Temperature Mean Annual Temperature Mean annual temperature at transitional, coastal or marine water monitoring station expressed in degree Celsius. float(8) 0
ClosestCoast Closest coast distance of marine station from closest coast expressed in km (if different from MainCoast). float(8) 0
SalinityMean Mean annual salinity mean annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
CatchmentName Catchment name Catchment name at the national level, referring to major river catchment or basin draining into transitional or coastal water. nvarchar(200) 0
Longitude Longitude (X) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
NationalStationID National station ID Identifier of the transitional, coastal or marine water monitoring station, unique at the national level. 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. Where national station identifiers are not available for data provided by Marine Conventions, the national station identifier will be populated with a unique value based on a combination of Convention, quality data table and co-ordinate position. nvarchar(200) 0
SeaResidence Residence time residence time of transitional or coastal water body expressed in number of days. float(8) 0
SalinityMaximum Maximum Annual Salinity maximum annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
MainCoast Mainland coast distance of marine station from nearest mainland coast expressed in km. float(8) 0
WaterBodyType Water body type T = Transitional water, C = Coastal water, M = Marine water. varchar(1) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 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
StationType Station type type of transitional, coastal or marine water monitoring station: B = Reference, R(PHYS) = Station representative of general conditions in terms of physico-chemical quality elements (organic matter and nutrients), I(PHYS) = Station impacted directly by discharges affecting physico-chemical conditions (organic matter and nutrients), R(HZ) = Station representative of general conditions in terms of hazardous substances, I(HZ) = Station impacted directly by discharges containing hazardous substances. Stations can be of more than one type, listed ordered as above, with no separator e.g. BR(PHYS)R(HZ). nvarchar(30) 0
Region Region region in which water body is located at the national level. varchar(200) 0
SeaRegionName Sea region name name of regional sea of which sea area is a part. nvarchar(200) 0
WaterBodyName Water body name water body name as defined for the Water Framework Directive. nvarchar(200) 0
WaterBodyTypeDesc Water body type description additional water body description, e.g. Estuary, Fjord, Coastal Lagoon, Embayment. varchar(50) 0
StnReporting Station reporting purpose reporting purpose of the transitional, coastal or marine water monitoring station: EC = European Commission, MC = Marine Conventions, N = National purposes. Station can be for more than one reporting purpose, listed alphabetically with no separator (e.g. ECN). varchar(10) 0
StationClass Station class Proximity to land, defined by comparing supplied station co-ordinates with maps: Coast = within 20 km of closest land or island, Open Water = more than 20 km from closest land or island. varchar(10) 0
SeaDepth Mean annual depth mean annual depth at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
TidalMean Mean tidal range mean tidal range at transitional, coastal or marine water monitoring station expressed in m. float(8) 0
WaterDataset Water data set TCM = Transitional, Coastal and Marine water. varchar(3) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). varchar(200) -1
Country Country name (ISO 3166-1) Official short name in English. nvarchar(50) 0
SalinityMinimum Minimum annual salinity minimum annual salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
Latitude Latitude (Y) International geographical co-ordinates of the monitoring station in decimal degrees format. float(8) 0
Matrix Matrix Environmental compartments measured at transitional, coastal or marine water monitoring station: B = Biota, S = Sediment, W = Water column. Any combination allowed, listed alphabetically with no separator (e.g. BSW). varchar(3) 0
Mixing Mixing characteristics mixing characteristics at transitional, coastal or marine water monitoring station: FM = Fully mixed, PM = Partially mixed, VS = Vertically stratified. varchar(2) 0
DataSource Data Source Source of data: Eurowaternet, ICES. varchar(50) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100