Scottish Marine and Freshwater Science Report Volume 9 No 14
This is table 2 included in the report. It is also included in the Appendix as table A2.
The column headings are:
Drone_id
Description: Model of drone
Discrete/Continuous/categorical:Categorical
Range or Levels: 3 levels/types of drone
Flight_session_number
Description: flight in which drone was detected by plane mounted LiDAR
Discrete/Continuous/categorical: Categorical
Range or Levels: 7 levels, values 1-7
Notes:Combine flight number with drone id to make unique
Position_of_drone
Description: whether drone was in a fixed position or moving
Discrete/Continuous/categorical: Categorical
Range or Levels: 2 levels, Fixed or In movement
Height_band
Description: height of the drone
Discrete/Continuous/categorical: Categorical
Range or Levels: 8 levels, from 10m to 80m
Notes:Height band in 10m bands
Difference_GPS
Description: difference between the GPS measurement of drone height and the measurement from LiDAR
Discrete/Continuous/categorical:Continuous
Range or Levels:From -0.94 to 0.71
Notes:One drone model not recording these values (DJI Matrice)
Difference_photogrammetry
Description: difference between the GPS measurement of drone height and the measurement from photogrammetry
Discrete/Continuous/categorical: Continuous
Range or Levels:From 0.17 to 0.33
Notes:Only two measurements
The variables in sediment_data.csv describe the contaminant data in sediment used in the 2017 assessment of the UK's Clean Seas Environment Monitoring Programme. This file gives more details about each variable.
seriesID
Description: timeseries identifier
Unit:
Type: categorical
Levels: 2505
Note: identifies the data (a station / contaminant combination) that were grouped together into a timeseries and modelled to assess status and trends
station
Description: station identifier
Unit:
Type: categorical
Levels: 109
Note: monitoring station – links to station information in sediment_station.csv
year
Description: monitoring year
Unit:
Type: discrete
Range: 1999, 2016
Note: for some data suppliers, monitoring is in winter and e.g. sampling in December 2015 and January 2016 would be regarded as having come from the same monitoring year
date
Description: sampling date
Unit:
Type: discrete
Range: 1999-01-18, 2016-10-26
Note:
sampleID
Description: sample identifier
Unit:
Type: categorical
Levels: 4044
Note:
matrix
Description: sample matrix
Unit:
Type: categorical
Levels: SED63, SEDTOT
Note: see ICES reference codes for MATRX
group
Description: contaminant group
Unit:
Type: categorical
Levels: BDE, CB, metal, PAH.parent
Note:
BDE = polybrominated diphenyl ethers
CB = polychlorinated biphenyls
PAH.parent = parent polycyclic aromatic hydrocarbons
determinand
Description: contaminant
Unit:
Type: categorical
Levels: 26
Note: see ICES reference codes for PARAM; data submitted as CHRTR have been relabelled as CHR
metoa
Description: method of chemical analysis
Unit:
Type: categorical
Levels: 16
Note: see ICES reference codes for METOA
Description: concentration of contaminant
Unit: mg kg^{-1} dw (metals), ug kg^{-1} dw (organics)
Type: continuous
Range: 0.00027, 314000
Note: all contaminant concentrations are expressed on a dry weight basis
qflag
Description: less-than qualifier for concentration measurement
Unit:
Type: categorical
Levels: "", "<"
Note:
“<” indicates a value below the limit of detection
"” indicates a value above the limit of detection
uncertainty
Description: uncertainty in the concentration measurement
Unit: as for concentration
Type: continuous
Range: 0.0000035, 23680
Note: analytical uncertainty expressed as the standard deviation
normConc
Description: normalised concentration of contaminant
Unit: as for concentration
Type: continuous
Range: 0.0048, 473765
Note: the concentration normalised to 5% aluminium (metals) or 2.5% organic carbon (organics); the normalisation process is explained here; some normalised concentrations are ‘missing’ because the normaliser (aluminium or organic carbon) concentration was not reported or because the uncertainty in the normalised concentration was greater than the normalised concentration
normConc.qflag
Description: less-than qualifier for normalised measurement
Unit:
Type: categorical
Levels: "", "<"
Note: see qflag
normConc.uncertainty
Description: uncertainty in the normalised measurement
Unit: as for concentration
Type: continuous
Range: 0.0000099, 47494
Note: analytical uncertainty expressed as the standard deviation
AL
Description: aluminium concentration
Unit: %
Type: continuous
Range: 0.013, 48.2
Note: all values are above the limit of detection
AL.uncertainty
Description: uncertainty in aluminium measurement
Unit: %
Type: continuous
Range: 0.0005, 5.49
Note: analytical uncertainty expressed as the standard deviation
CORG
Description: organic carbon concentration
Unit: %
Type: continuous
Range: 0.03, 9.7
Note:
CORG.qflag
Description: less-than qualifier for organic carbon measurement
Unit:
Type: categorical
Levels: "", "<"
Note: see qflag
CORG.uncertainty
Description: uncertainty in organic carbon measurement
Unit: %
Type: continuous
Range: 0.001, 17.1
Note: analytical uncertainty expressed as the standard deviation
DRYWT
Description: dry weight of the sample
Unit: %
Type: continuous
Range: 8.33, 94.8
Note: all values are above the limit of detection
DRYWT.uncertainty
Description: uncertainty in dry weight measurement
Unit: %
Type: continuous
Range: 0.036, 3.35
Note: analytical uncertainty expressed as the standard deviation