Write to us
Call us
Waterbase - TCM: QualityWater
The QualityWater table contains aggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations and Pressures data.
| NoOfObservations | Number of observations | number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. | int(4) | 0 |
| PeriodLength | Period length | number of months in aggregation period. | int(4) | 0 |
| Year | Year | year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. | int(4) | -1 |
| Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
| Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
| Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
| WaterbaseID | Waterbase ID | internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). | nvarchar(255) | -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. | nvarchar(20) | 0 |
| AggregationPeriod | Aggregation period | period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). | nvarchar(20) | -1 |
| Minimum | Minimum | minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. | float(8) | 0 |
| MinimumDepth | Minimum depth | minimum depth limit for samples included in aggregate in m. | float(8) | 0 |
| SalinityMean | Mean salinity | mean salinity measured at transitional, coastal or marine water station. | float(8) | 0 |
| Maximum | Maximum | maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. | float(8) | 0 |
| MaximumDepth | Maximum depth | maximum depth limit for samples included in aggregate in m. | float(8) | 0 |
| Mean | Mean | mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit. | float(8) | 0 |
| CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Document Actions
Share with others