Waterbase - TCM: Discharges

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 Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.

Data and maps

Menu

Category

European data

Records

Table definition

Year	Year	year of aggregation period, or year in which sample taken, in format YYYY.	int(4)
SeaRegionName	Sea region name	regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature.	nvarchar(200)
SeaConventionArea	Marine Convention Area	name of Marine Convention area.	nvarchar(200)
Determinand	Determinand	determinand name.	nvarchar(200)
CaSNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)
WaterbodyID	Water body ID	national identification code of water body (if applicable) in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station.	nvarchar(200)
WaterBodyName	Water body name	name of water body in which monitoring station is located. Water body as defined / required by Water Framework Directive. A water body may contain more than one monitoring station.	nvarchar(200)
SeaAreaName	Sea area name	sea area name or identifier into which river discharges, marine water is located, or direct discharge enters. Consistent with Marine Convention nomenclature.	nvarchar(200)
Load	Load	estimated load of determinand.	float(8)
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)
CountryCode	CountryCode	ISO 3166-alpha-2 code elements	varchar(2)
DischargeType	Discharge type	I = Industrial, M = Municipal, T = Total.	varchar(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)
Unit	Unit	unit of measurement.	nvarchar(30)