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

13313

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
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
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
CaSNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
OrganicCarbon	Organic carbon	mean organic carbon content expressed as % of total dry weight.	float(8)	0
DryWetRatio	Dry wet ratio	mean ratio of dry weight to wet weight expressed as %.	float(8)	0
BottomDepth	Bottom depth of sediment	bottom depth where the sediment sample was taken at transitional, coastal or marine water monitoring station expressed in m, measured from the water surface.	float(8)	0
SedimentTop	Top of sediment layer	top of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available.	float(8)	0
SedimentBottom	Bottom of sediment layer	bottom of analysed sediment layer measured from the sediment surface expressed in cm. Value "-1" indicates data not available.	float(8)	0
Mean	Mean	mean concentration in aggregation period.	float(8)	0
Minimum	Minimum	Minimum concentration during aggregation period.	float(8)	0
Maximum	Maximum	maximum concentration during aggregation period.	float(8)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements	varchar(2)	0
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
Basis	Basis	basis of aggregate: D = Dry, W = Wet.	varchar(1)	0