Write to us
Call us
Waterbase - TCM: Inputs
The Inputs table contains data on the yearly riverine inputs of loads to transitional, coastal and marine waters which are monitored at Eionet-Water flux stations, provided by national sources or Marine Conventions. Each flux station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective Flux Stations data.
| Year | Year | year of aggregation period, or year in which sample taken, in format YYYY. | int(4) | -1 |
| Unit | Unit | unit of measurement. | nvarchar(30) | 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 |
| CaSNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
| Determinand | Determinand | determinand name. | nvarchar(200) | -1 |
| Load | Load | estimated load of determinand. | float(8) | 0 |
| CountryCode | Country code | ISO 3166-alpha-2 code elements | varchar(2) | 0 |
| Estimate | Estimate type | L = Lower estimate based on treating determinand values that are less than the limits of detection as zero, U = Upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X = Unspecified. | varchar(1) | -1 |
| Method | Method of estimation | OutY = Calculations including outlier values, OutN = Calculations excluding outlier values, FloodY = Calculations accounting for flood events, FloodN = Calculations not accounting for flood events, XSS = Loads calculated by extrapolation from concentrations (of micropollutants) in suspended sediment, Other = Other methods. | varchar(20) | 0 |
Document Actions
Share with others