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 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
18852
Table definition
Year Year year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. int(4) -1
Fraction Fraction upper limit of particle size in analysed fraction in µm. int(4) 0
NoOfSamples Number of samples number of samples in aggregation period. int(4) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
Determinand Determinand determinand name. nvarchar(255) -1
Unit Unit unit of measurement. nvarchar(30) 0
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(255) -1
AggregationPeriod Aggregation period period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). nvarchar(20) -1
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 in cm. Value -1 means that this information is not available. float(8) -1
SedimentTop Top of sediment layer top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface. Value -1 means that this information is not available. float(8) -1
Mean Mean mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. float(8) 0
Minimum Minimum minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. float(8) 0
OrganicCarbon Organic carbon organic carbon content as a percentage of total dry weight. float(8) 0
BottomDepth Bottom depth of sediment depth of sea bottom at sampling site in m. float(8) 0
DryWetRatio Dry wet ratio ratio of dry weight to wet weight as a percentage. float(8) 0
Maximum Maximum maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. float(8) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. varchar(2) 0
Basis Basis basis of measurement. D=dry, L=lipid (fat), W=wet. varchar(1) 0
GrainType Grain type sediment type description. 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