Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Transitional, coastal and marine waters / Waterbase - TCM: QualityHSWater

Waterbase - TCM: QualityHSWater

The QualityHSWater table contains aggregated data on hazardous substances in seawater, measured at Eurowaternet transitional, coastal or marine water monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressure data.
Category
European data
Records
266
Table definition
Year Year year of aggregation period or year in which sample taken, in format YYYY. int(4) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
NoOfObservations Number of observations number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. int(4) 0
Unit Unit unit of measurement. nvarchar(60) 0
AggregationPeriod Aggregation period Period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. nvarchar(20) 0
CASNo Chemical abstract service number chemical abstract service number of determinand. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
MinimumDepth Minimum depth minimum depth limit for samples included in aggregate expressed in m. float(8) 0
MaximumDepth Maximum depth Maximum depth limit for samples included in aggregate expressed in m. float(8) 0
Mean Mean mean concentration value in aggregation period. float(8) 0
Maximum Maximum maximum concentration value in aggregation period. float(8) 0
MeanSalinity Mean salinity average salinity of samples included in aggregate. float(8) 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
AggregationMethod Aggregation method description of aggregation process: MeanOfMinimum = Minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean = Average of all samples on same date and in same depth profile calculated then average of averages calculated by year. varchar(20) 0
Files

Geographic coverage

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100