Waterbase - TCM: QualityBiota

This website has limited functionality with javascript off. Please make sure javascript is enabled in your browser.

Data Table

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.

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