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

1070

Table definition

NoOfObservations	Number of observations	number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.	int(4)	0
PeriodLength	Period length	number of months in aggregation period.	int(4)	0
Year	Year	year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.	int(4)	-1
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
Determinand	Determinand	determinand name.	nvarchar(255)	-1
Unit	Unit	unit of measurement.	nvarchar(30)	0
WaterbaseID	Waterbase ID	internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(255)	-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.	nvarchar(20)	0
AggregationPeriod	Aggregation period	period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).	nvarchar(20)	-1
Minimum	Minimum	minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	float(8)	0
MinimumDepth	Minimum depth	minimum depth limit for samples included in aggregate in m.	float(8)	0
SalinityMean	Mean salinity	mean salinity measured at transitional, coastal or marine water station.	float(8)	0
Maximum	Maximum	maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	float(8)	0
MaximumDepth	Maximum depth	maximum depth limit for samples included in aggregate in m.	float(8)	0
Mean	Mean	mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.	float(8)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	varchar(2)	0