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 was 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 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | 0 |
Determinand | Determinand | determinand name. | nvarchar(200) | 0 |
Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
SampleDepth | Sample depth | depth at which sample taken expressed as m below surface with value >=0. | float(8) | 0 |
Salinity | Salinity | salinity of sample or salinity to which sample concentration is normalised in practical salinity units (psu). | 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 |
ThermoPos | Thermocline position | vertical position relative to thermocline at transitional, coastal or marine water monitoring station: AT = Above thermocline, IT = In thermocline, BT = Below thermocline. | varchar(2) | 0 |
HaloPos | Halocline position | vertical position relative to halocline at transitional, coastal or marine water monitoring station: AH = Above halocline, IH = In halocline, BH = Below halocline. | varchar(2) | 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 |
LimitOfDetectionFlag | Limit of detection flag | flag to indicate sample below analytical limit of detection in format <. | varchar(1) | 0 |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters/waterbase-tcm-qualitywaterd or scan the QR code.
PDF generated on 23 Apr 2024, 11:28 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