Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Transitional, coastal and marine waters / Waterbase - TCM: QualitySediment

Waterbase - TCM: QualitySediment

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

Geographical coverage

[+] Show Map

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100