Waterbase - TCM: Inputs

Data Table expired
This page was archived on 26 Jun 2015 with reason: Other (New version data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-11 was published)
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.
European data
Table definition
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
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Phone: +45 3336 7100