Primary tabs

Biota Summaries for the National Performance Framework Clean Seas Indicator 2019 and Scotland's Marine Assessment 2020

The variables in biota_summaries.csv describe summary measures of status and trends for contaminant and biological effect timeseries in biota. The summary measures are used to construct the National Performance Framework Clean Seas Indicator 2019. They are also used for the assessment of the status and trends of selected contaminant and biological effect groups for Scotland's Marine Assessment 2020. The column headers are:

seriesID
Description: timeseries identifier
Unit:
Type: categorical
Levels: 835
Note: the raw data for each timeseries can be found in biota_data.csv

region
Description: assessment region
Unit:
Type: categorical
Levels: 4
Note: the regions are the Scottish component of the biogeographic regions used for Charting Progress 2 and for UK MSFD reporting purposes. There are 5 regions in Scottish waters, but there are no stations in the Atlantic North-West Approaches because it is difficult to sample. The Northern North Sea, Minches and Western Scotland and Irish Sea (Clyde & Solway) are used in the Clean Seas Indicator. The Scottish Continental Shelf is not used in the Indicator because it is difficult to get sufficient spatial coverage for regional assessments for both biota and sediment.

station
Description: station identifier
Unit:
Type: categorical
Levels: 95
Note:

latitude
Description: station latitude
Unit: decimal degrees
Type: continuous
Range: 54.75, 60.78
Note: these are nominal positions: sampling occurs in a pre-defined area centred on this position.

longitude
Description: station longitude
Unit: decimal degrees
Type: continuous
Range: -6.38, -0.62
Note: these are nominal positions: sampling occurs in a pre-defined area centred on this position.

MSTAT
Description: station type
Unit:
Type: categorical
Levels: B, RH, I
Note:
B = baseline stations in remote areas subject only to diffuse inputs of contaminants
RH = representative stations broadly representative of contaminant levels in the region
I = impacted stations located close to a point source

species
Description: species
Unit:
Type: categorical
Levels: 5
Note:
Limanda limanda: AphiaID = 127139
Mytilus edulis: AphiaID = 140480
Nucella lapillus: AphiaID = 140403
Platichthys flesus: AphiaID = 127141
Pleuronectes platessa: AphiaID = 127143

sex
Description: sex
Unit:
Type: categorical
Levels: Female, Male
Note: only provided for EROD timeseries which are analysed separately by sex

group
Description: contaminant group
Unit:
Type: categorical
Levels: BDE, bioeffect, CB, imposex, metal, PAH.parent
Note:
BDE = polybrominated diphenyl ethers
bioeffect = biological effects
CB = polychlorinated biphenyls
PAH.parent = parent polycyclic aromatic hydrocarbons

determinand
Description: contaminant
Unit:
Type: categorical
Levels: 28
Note: see ICES reference codes for PARAM

last_year
Description: last year with monitoring data
Unit:
Type: integer
Range: 2013, 2018
Note:

status
Description: the estimated (natural) logarithm of the mean concentration in the last monitoring year
Unit: log ug/kg ww (contaminants), log ug/ml (PYR1OHEQ), log pmol/min/mg protein (EROD)
Type: continuous
Range: -3.9, 7.78
Note: for VDS, status is the square root of the estimated mean VDS in the last monitoring year

se_status
Description: the standard error on the estimated log mean concentration in the last monitoring year
Unit: log ug/kg ww (contaminants), log ug/ml (PYR1OHEQ), log pmol/min/mg protein (EROD)
Type: continuous
Range: 0.025, 1.36
Note: for VDS, se_status is the standard error of the estimated square root mean VDS in the last monitoring year

EAC_id
Description: the identifier of the EAC measure or its equivalent
Unit:
Type: categorical
Levels: EAC, EC, FEQG
Note:
EAC = Environmental Assessment Criterion
EC = European Commission food standard
FEQG = Federal Environmental Quality Guideline

EAC
Description: the value of the EAC or its equivalent
Unit: ug/kg ww (contaminants), ug/ml (PYR1OHEQ), pmol/min/mg protein (EROD), st (VDS)
Type: continuous
Range: 0.32, 1500
Note:

status_EAC
Description: the log ratio of the estimated mean concentration in the last monitoring year to the EAC (or its equivalent)
Unit: dimensionless
Type: continuous
Range: -6.7, 2
Note:
For contaminants, PYR1OHEQ and EROD, a value above / below 0 indicates that the estimated mean concentration in the last monitoring year is above / below the EAC; the standard error is given by the variable se_status
For VDS, status_EAC is the ratio of the estimated square root mean VDS in the last monitoring year to the square root EAC; a value above / below 1 indicates that the estimated mean VDS in the last monitoring year is above / below the EAC; the standard error is given by the variable se_status divided by the square root EAC

BAC
Description: the Background Assessment Concentration (BAC)
Unit: ug/kg ww (contaminants), ug/ml (PYR1OHEQ), pmol/min/mg protein (EROD), st (VDS)
Type: continuous
Range: 0.011, 212
Note:

status_BAC
Description: the log ratio of the estimated mean concentration in the last monitoring year to the BAC
Unit: dimensionless
Type: continuous
Range: -3.1, 7.02
Note:
For contaminants, PYR1OHEQ and EROD, a value above / below 0 indicates that the estimated mean concentration in the last monitoring year is above / below the BAC; the standard error is given by the variable se_status
For VDS, status_BAC is the ratio of the estimated square root mean VDS in the last monitoring year to the square root BAC; a value above / below 1 indicates that the estimated mean VDS in the last monitoring year is above / below the BAC; the standard error is given by the variable se_status divided by the square root BAC

trend
Description: the estimated yearly change in log concentration
Unit: log ug/kg ww/y (contaminants), log ug/ml/y (PYR1OHEQ), log pmol/min/mg protein/y (EROD)
Type: continuous
Range: -44, 31
Note: for VDS, trend is the estimated odds ratio of the VDS of an individual being above the EAC in one year relative to the previous year; values below / above 1 indicate a decreasing / increasing trend in VDS

se_trend
Description: the standard error on the estimated yearly change in log concentration
Unit: dimensionless
Type: continuous
Range: 0.014, 15.2
Note: for VDS, se_trend is the standard error on the estimated odds ratio of the VDS of an individual being above the EAC in one year relative to the previous year

Data Preview: Note that by default the preview only displays up to 100 records. Use the pager to flip through more records or adjust the start and end fields to display the number of records you wish to see.