Write to us
Call us
Waterbase - TCM: Input
The Input table contains data on the yearly riverine input 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 (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. | smallint(2) | 0 |
| Load | Load | estimated load of determinand. | real(4) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | nvarchar(2) | -1 |
| 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(60) | -1 |
| NationalStationID | National station ID | Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. | nvarchar(50) | 0 |
| Determinand | Determinand | determinand name. | nvarchar(30) | 0 |
| CASNumber | CAS Number | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | nvarchar(10) | 0 |
| Unit | Unit | unit of measurement. | nvarchar(20) | 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. | nvarchar(1) | 0 |
| 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. | nvarchar(10) | 0 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
Document Actions
Share with others