Waterbase - TCM: QualityBiotaD

Data Table expired
This content has been archived on 26 Jun 2015, reason: Other (New version data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-11 was published)
The QualityBiotaD table contains disaggregated data on hazardous substances in biota, 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.
European data
Table definition
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
Unit Unit unit of measurement. nvarchar(30) 0
Basis Basis basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. nvarchar(1) 0
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
Determinand Determinand determinand name. nvarchar(200) 0
DryFreshRatio Dry fresh ratio ratio of dry weight to fresh weight of biota monitored expressed as %. float(8) 0
Fat Fat fat content of biota expressed as % of total wet matter. float(8) 0
LimitOfDetection Limit of detection concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected, i.e. there is a 95% probability that the determinand will be detected. float(8) 0
LimitOfDetermination Limit of determination the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). 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
Tissue Tissue code of tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. varchar(2) 0
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. 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
Species Species code of species monitored. varchar(20) 0
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Phone: +45 3336 7100