Waterbase - TCM: Inputs

Data Table

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.

Data and maps

Menu

Category

European data

Records

15839

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