All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Year | Year | year of aggregation period or year in which sample taken, in format YYYY. | int(4) | 0 |
Month | Month | month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). | int(4) | 0 |
Day | Day | day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). | int(4) | 0 |
Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
Basis | Basis | basis of aggregate: D = Dry, L = Lipid (fat), W = Wet. | nvarchar(1) | 0 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | 0 |
CASNo | Chemical abstract service number | chemical abstract service number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(200) | 0 |
DryFreshRatio | Dry fresh ratio | ratio of dry weight to fresh weight of biota monitored expressed as %. | float(8) | 0 |
Fat | Fat | fat content of biota expressed as % of total wet matter. | float(8) | 0 |
LimitOfDetection | Limit of detection | concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected, i.e. there is a 95% probability that the determinand will be detected. | float(8) | 0 |
LimitOfDetermination | Limit of determination | the smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | float(8) | 0 |
Concentration | Concentration | concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. | float(8) | 0 |
Tissue | Tissue | code of tissue element of species monitored: LI = Liver, MU = Muscle, SB = Soft body, WO = Whole body. | varchar(2) | 0 |
LimitOfDetectionFlag | Limit of detection flag | flag to indicate sample below analytical limit of detection in format <. | varchar(1) | 0 |
CountryCode | Country code | ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
WaterbaseID | Waterbase ID | Internally produced, unique identifier used to represent the transitional, coastal or marine water monitoring station, in the format: CountryCode_WaterDataSet_NationalStationID (e.g. GB_TCM_12345). | varchar(200) | -1 |
Species | Species | code of species monitored. | varchar(20) | 0 |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters/waterbase-tcm-qualitybiotad or scan the QR code.
PDF generated on 23 Apr 2024, 08:36 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others