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 |
PeriodLength | Period length | number of months in aggregation period. | int(4) | 0 |
NoOfObservations | Number of observations | number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. | int(4) | 0 |
AggregationPeriod | Aggregation period | period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = data aggregated between two years. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(200) | 0 |
Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
MeanSalinity | Mean salinity | average salinity of samples included in aggregate. | float(8) | 0 |
MinimumDepth | Minimum depth | minimum depth limit for samples included in aggregate expressed in m. | float(8) | 0 |
MaximumDepth | Maximum depth | maximum depth limit for samples included in aggregate expressed in m. | float(8) | 0 |
Mean | Mean | mean concentration value in aggregation period. | float(8) | 0 |
Minimum | Minimum | minimum concentration value in aggregation period. | float(8) | 0 |
Maximum | Maximum | maximum concentration during aggregation period. | float(8) | 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 |
AggregationMethod | Aggregation method | description of aggregation process: MeanOfMinimum = Minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean = Average of all samples on same date and in same depth profile calculated then average of averages calculated by year. | 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-qualitywater or scan the QR code.
PDF generated on 28 Mar 2024, 10:20 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