Waterbase - TCM: Inputs
|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|
|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|
For references, please go to www.eea.europa.eu/soer or scan the QR code.
This briefing is part of the EEA's report The European Environment - State and Outlook 2015. The EEA is an official agency of the EU, tasked with providing information on Europe's environment.
PDF generated on 26 May 2016, 09:28 AM