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

Waterbase - TCM: QualitySedimentD

The QualitySedimentD table contains disaggregated data on hazardous substances in sediment, 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.
Category
European data
Records
13384
Table definition
Fraction Fraction upper limit of particle size in analysed fraction expressed in µm. Blank if whole sediment has been analysed. int(4) 0
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
Sampler Sampler name of sampling equipment used at transitional, coastal or marine water monitoring station. nvarchar(200) 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
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
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
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
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
Basis Basis basis of aggregate: D = Dry, W = Wet. varchar(1) 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
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
Files

Geographic coverage

Document Actions

Comments

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