Write to us
Call us
Waterbase - TCM: Discharges
The Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.
| Year | Year | year of aggregation period, or year in which sample taken, in format YYYY. | int(4) | 0 |
| SeaRegionName | Sea region name | regional sea name of which sea area is a part. Consistent with Marine Convention nomenclature. | nvarchar(200) | 0 |
| SeaConventionArea | Marine Convention Area | name of Marine Convention area. | nvarchar(200) | 0 |
| Determinand | Determinand | determinand name. | nvarchar(200) | 0 |
| CaSNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
| 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) | 0 |
| 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) | 0 |
| 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) | 0 |
| Load | Load | estimated load 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 | CountryCode | ISO 3166-alpha-2 code elements | varchar(2) | 0 |
| DischargeType | Discharge type | I = Industrial, M = Municipal, T = Total. | varchar(1) | 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) | 0 |
| Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
Document Actions
Share with others