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 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 data.

Data and maps

Menu

Category

European data

Records

70366

Table definition

PeriodLength	Period length	number of months in aggregation period.	tinyint(1)	0
DryFreshNoOfSamples	Dry fresh ratio number of samples	number of samples taken in ratio of dry weight to fresh weight as a percentage.	tinyint(1)	0
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.	smallint(2)	0
LowNoOfSamples	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).	smallint(2)	0
HighNoOfSamples	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).	smallint(2)	0
FatNoOfSamples	Fat content number of samples	number of samples of fat content as a percentage of total wet matter.	smallint(2)	0
LowMinimum	Low range minimum	minimum concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	numeric(9)	0
Low10Percentile	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).	numeric(9)	0
LowMean	Low range mean	mean concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	numeric(13)	0
LowMedian	Low range median	median concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).	numeric(9)	0
HighMean	High range mean	mean 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).	numeric(13)	0
HighMedian	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).	numeric(9)	0
FatMinimum	Fat content minimum	minimum fat content as a percentage of total wet matter.	numeric(5)	0
FatMaximum	Fat content maximum	maximum fat content as a percentage of total wet matter.	numeric(5)	0
High90Percentile	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).	numeric(9)	0
HighMaximum	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).	numeric(13)	0
DryFreshMean	Dry fresh ratio mean	mean ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
DryFreshMinimum	Dry fresh ratio minimum	minimum ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
DryFreshMaximum	Dry fresh ratio maximum	maximum ratio of dry weight to fresh weight as a percentage.	numeric(5)	0
FatMean	Fat content mean	mean fat content as a percentage of total wet matter.	numeric(5)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	nvarchar(2)	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(50)	-1
Determinand	Determinand	determinand name.	nvarchar(100)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	0
CASNo	Chemical Abstract Service Number	Chemical Abstract Service Number of determinand.	nvarchar(20)	0
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
Species	Species	species monitored.	nvarchar(10)	-1
Tissue	Tissue	tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body.	nvarchar(2)	-1
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet.	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0