Waterbase - TCM: QualityHSWater

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 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.

Data and maps

Menu

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