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 Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.

Data and maps

Menu

Category

European data

Records

365

Table definition

Year	Year	year of aggregation period, or year in which sample taken, in format YYYY.	int(4)	-1
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
CaSNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
Unit	Unit	unit of measurement.	nvarchar(30)	0
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.	nvarchar(20)	-1
WaterbaseID	WaterbaseID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	nvarchar(200)	-1
Determinand	Determinand	determinand name.	nvarchar(200)	-1
AggregationPeriod	Aggregation period	period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period.	nvarchar(20)	0
SalinityMean	Mean salinity	mean salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu).	float(8)	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 in aggregation period.	float(8)	0
Maximum	Maximum	maximum concentration during aggregation period.	float(8)	0
Minimum	Minimum	Minimum concentration during aggregation period.	float(8)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	varchar(2)	0