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 Eurowaternet flux stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective FluxStations data.

Data and maps

Menu

Category

European data

Records

6794

Table definition

Year	Year	year of aggregation period or year in which sample taken, in format YYYY.	int(4)	0
CASNo	Chemical abstract service number	chemical abstract service number of determinand.	nvarchar(20)	0
Determinand	Determinand	determinand name.	nvarchar(200)	0
Unit	Unit	unit of measurement.	nvarchar(30)	0
Value	Value	Measured value of determinand.	float(8)	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.	varchar(20)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	varchar(2)	0
WaterbaseID	Waterbase ID	Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345).	varchar(200)	-1
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)	0