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 Eionet-Water transitional, coastal and marine water monitoring stations, provided by national sources or Marine Conventions. 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.
Category
European data
Records
40684
Table definition
SeaConventionArea Marine convention area name of Marine Convention area. nvarchar(200) 0
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) 0
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(200) 0
SeaRegionName Sea region name regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. nvarchar(200) 0
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) 0
Region Region region in which water body is located at the national level. nvarchar(200) 0
WaterbodyID Water body 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) 0
Country Country Official short name in English nvarchar(50) 0
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) 0
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) 0
SeaDepth Mean annual depth mean annual depth at transitional, coastal or marine water monitoring station expressed in m. float(8) 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
Temperature Mean Annual Temperature mean annual temperature at transitional, coastal or marine water monitoring station expressed in degrees Celsius (oC). float(8) 0
TidalMean Mean tidal range mean tidal range at transitional, coastal or marine water monitoring station expressed in m. 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 salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 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
Longitude Longitude (X) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
Latitude Latitude (Y) international geographical co-ordinates of the monitoring station in decimal degrees. float(8) 0
MainlandCoast Mainland coast distance of marine station from nearest mainland coast expressed in km. float(8) 0
TCMMatrix 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
PhysChemStatio Physico-Chemicals category station physico-chemical conditions monitored at station type: R = Represenatative station, I = Impact station. varchar(1) 0
HazSubsStation Hazardous substances category station hazardous substances monitored at station type: R = Represenatative station, I = Impact station. varchar(1) 0
StationReporting 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
WaterDataset Water data set RV = River, LK = Lake, GW = Groundwater, TCM = Transitional, Coastal or Marine Water, QA = Water Quantity. varchar(3) 0
WaterBodyType Water body type RV = River, CN = Canal, T = Transitional water, C = Coastal water, M = Marine water. varchar(2) 0
WaterBodyTypeDesc Water body type description additional water body description, e.g. Estuary, Fjord, Coastal Lagoon, Embayment. varchar(50) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
WaterbaseID WaterbaseID 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). nvarchar(200) -1
DataSource Data source source of data: Eionet-Water, ICES. varchar(50) 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
ReferenceStation ReferenceStation reference station: 1 = Yes, 0 = No. varchar(1) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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