Waterbase - TCM: QualitySediment

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 QualitySediment table contains aggregated data on hazardous substances in sediment, 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

200

Table definition

NoOfSamples	Number of samples	number of samples in aggregation period	int(4)	0
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
Fraction	Fraction	upper limit of particle size in analysed fraction expressed in µm. Blank if whole sediment has been analysed.	int(4)	0
Unit	Unit	unit of measurement.	nvarchar(30)	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
DryWetRatio	Dry wet ratio	average ratio of dry weight to wet weight expressed as %.	float(8)	0
SedimentTop	Top of sediment layer	top of analysed sediment layer measured from the sediment surface expressed in cm. Value will be 0 if top of sediment layer is the sediment surface for at least one sample in the aggregate.	float(8)	0
SedimentBottom	Bottom of sediment layer	bottom of analysed sediment layer measured from the sediment surface expressed in cm.	float(8)	0
OrganicCarbon	Organic carbon	average organic carbon content expressed as % of total dry weight.	float(8)	0
Median	Median	median concentration value in aggregation period.	float(8)	0
StandardDeviation	Standard deviation	standard deviation of concentration values in aggregation period.	float(8)	0
SedimentDepth	Depth of sediment	depth of sediment at transitional, coastal or marine water monitoring station expressed in m.	float(8)	0
Mean	Mean	mean concentration value in aggregation period.	float(8)	0
Minimum	Minimum	minimum concentration value in aggregation period.	float(8)	0
Maximum	Maximum	maximum concentration during aggregation period.	float(8)	0
Basis	Basis	basis of aggregate: D = Dry, W = Wet.	varchar(1)	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
GrainType	Grain type	sediment type description if no analysis of grain size: M = Mud, FS = Fine sand, MS = Middle sand, CS = Coarse sand, G = Gravel.	varchar(2)	0