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

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