Waterbase - TCM: QualityHSWaterD

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 QualityHSWaterD table contains disaggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. 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

1943

Table definition

Year	Year	year of aggregation period, or year in which sample taken, in format YYYY.	int(4)	0
Month	Month	month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0).	int(4)	0
Day	Day	day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0).	int(4)	0
Determinand	Determinand	determinand name.	nvarchar(200)	0
Unit	Unit	unit of measurement.	nvarchar(30)	0
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
SampleID	Sample ID	unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.	nvarchar(50)	0
CaSNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
Concentration	Concentration	concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit.	float(8)	0
SampleDepth	Sample depth	depth at which sample taken expressed as m below surface with value >=0.	float(8)	0
Salinity	Salinity	salinity of sample or salinity to which sample concentration is normalised in practical salinity units (psu).	float(8)	0
HaloPos	Halocline position	vertical position relative to halocline at transitional, coastal and marine water monitoring station: AH = Above Halocline, IH = In Halocline, BH = Below Halocline.	varchar(2)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	varchar(2)	0
LimitOfDetectionFlag	Limit Of Detection Flag	flag to indicate sample below analytical limit of detection in format <.	varchar(1)	0
ThermoPos	Thermocline position	vertical position relative to thermocline at transitional, coastal and marine water monitoring station: AT = Above Thermocline, IT = In Thermocline, BT = Below Thermocline.	varchar(2)	0