Personal tools

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

Geographical coverage

[+] Show Map

Document Actions

Comments

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