Waterbase - TCM: QualityBiota

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 QualityBiota table contains aggregated 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.

Data and maps

Menu

Category

European data

Records

40145

Table definition

HighRangeNoOfSamples	High range number of samples	number of samples in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).	int(4)	0
DryDreshNoOfSamples	Dry fresh ratio number of samples	number of samples taken in ratio of dry weight to fresh weight of biota expressed as %.	int(4)	0
FatNoOfSamples	Fat number of samples	number of samples of fat content of biota expressed as % of total wet matter.	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
LowRangeNoOfSamples	Low range number of samples	number of samples in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	int(4)	0
Unit	Unit	unit of measurement.	nvarchar(30)	0
Aggregationperiod	Aggregation period	period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years.	nvarchar(20)	0
CASNo	Chemical abstract service number	chemical abstract service number of determinand.	nvarchar(20)	0
Determinand	Determinand	determinand name.	nvarchar(200)	0
FatMinimum	Fat minimum	minimum fat content of biota expressed as % of total wet matter.	float(8)	0
FatMaximum	Fat maximum	maximum fat content of biota expressed as % of total wet matter.	float(8)	0
DryFreshMinimum	Dry fresh ratio minimum	minimum ratio of dry weight to fresh weight of biota expressed as %.	float(8)	0
DryFreshMaximum	Dry fresh ratio maximum	maximum ratio of dry weight to fresh weight of biota expressed as %.	float(8)	0
FatMean	Fat mean	mean fat content of biota expressed as % of total wet matter.	float(8)	0
HighRange90Percentile	High range 90th percentile	90th Percentile concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).	float(8)	0
HighRangeMaximum	High range maximum	maximum concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).	float(8)	0
DryFreshMean	Dry fresh ratio mean	mean ratio of dry weight to fresh weight of biota expressed as %.	float(8)	0
LowRangeMedian	Low range median	median concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	float(8)	0
HighRangeMean	High range mean	average concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).	float(8)	0
HighRangeMedian	High range median	median concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).	float(8)	0
LowRangeMinimum	Low range minimum	minimum concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	float(8)	0
LowRange10Percentile	Low range 10th percentile	10th Percentile concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	float(8)	0
LowRangeMean	Low range mean	Average concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	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
Basis	Basis	basis of aggregate: D = Dry, L = Lipid (fat), W = Wet.	varchar(1)	0
CountryCode	Country Code	ISO3166 two digit code.	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