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

Data and maps

Menu

Category

European data

Records

59298

Table definition

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).	int(4)	0
PeriodLength	Period length	number of months in aggregation period.	int(4)	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.	int(4)	-1
DryFreshNoOfSamples	Dry fresh ratio number of samples	number of samples taken in ratio of dry weight to fresh weight as a percentage.	int(4)	0
FatNoOfSamples	Fat content number of samples	number of samples of fat content as a percentage of total wet matter.	int(4)	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).	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
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).	float(8)	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).	float(8)	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).	float(8)	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).	float(8)	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).	float(8)	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).	float(8)	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).	float(8)	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).	float(8)	0
FatMaximum	Fat content maximum	maximum fat content as a percentage of total wet matter.	float(8)	0
FatMean	Fat content mean	mean fat content as a percentage of total wet matter.	float(8)	0
FatMinimum	Fat content minimum	minimum fat content as a percentage of total wet matter.	float(8)	0
DryFreshMaximum	Dry fresh ratio maximum	maximum ratio of dry weight to fresh weight as a percentage.	float(8)	0
DryFreshMean	Dry fresh ratio mean	mean ratio of dry weight to fresh weight as a percentage.	float(8)	0
DryFreshMinimum	Dry fresh ratio minimum	minimum ratio of dry weight to fresh weight as a percentage.	float(8)	0
Tissue	Tissue	tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body.	varchar(2)	-1
Basis	Basis	basis of measurement. D=dry, L=lipid (fat), W=wet.	varchar(1)	0
CountryCode	Country code	abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.	varchar(2)	0
Species	Species	species monitored.	varchar(20)	-1