Write to us
Call us
Waterbase - TCM: FluxStations
The FluxStations table contains the physical characteristics of the Eionet-Water transitional, coastal and marine water stations used to monitor riverine input loads, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the FluxStations with their respective Input (load) data.
| WaterBodyID | Water body ID | national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
| WaterBodyName | Water body name | name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
| SeaConventionArea | Marine convention area | name of Marine Convention area of which regional sea is a part. | nvarchar(255) | 0 |
| SeaRegionName | Sea region name | name of regional sea of which local sea area is a part. | nvarchar(255) | 0 |
| WaterbaseName | Waterbase name | national name of station or groundwater body. | nvarchar(255) | 0 |
| NationalStationID | National station ID | identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station. | nvarchar(255) | 0 |
| RiverName | River name | national name of river. | nvarchar(255) | 0 |
| SeaAreaName | Sea area name | name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName. | nvarchar(255) | 0 |
| WaterbaseID | Waterbase ID | internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). | nvarchar(255) | -1 |
| Country | Country name | official short name in English. ISO 3166-1. | nvarchar(255) | 0 |
| CatchmentName | Catchment name | name of major catchment or basin. | nvarchar(255) | 0 |
| Latitude | Latitude | (Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
| Longitude | Longitude | (X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
| DataSource | Data source | source of data: Eionet-Water, ICES. | varchar(50) | 0 |
| WaterDataSet | Water data set | RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity. | varchar(3) | 0 |
Document Actions
Share with others