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 (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) | 0 |
PeriodLength | Period length | number of months in aggregation period. | int(4) | 0 |
NumberOfSamples | Number of samples | number of samples in aggregation period. | int(4) | 0 |
NoOfSubsites | Number of subsites | int(4) | 0 | |
QA_outlier | Quality assurance field - outlier flag | the highlighted data quality issues are explained in the QA documentation | int(4) | 0 |
QA_station_problem | Quality assurance field - stations data quality issues flag | the highlighted stations data quality issues are explained in the QA documentation | int(4) | 0 |
SampleDepth | Sample depth | Depth at which sample taken in metres below water surface. | numeric(5) | 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. | numeric(9) | 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%). | numeric(9) | 0 |
Mean | Mean | mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | numeric(9) | 0 |
Minimum | Minimum | minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | numeric(9) | 0 |
Maximum | Maximum | maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | numeric(9) | 0 |
Median | Median | median concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | numeric(9) | 0 |
StandardDeviation | Standard deviation | standard deviation of concentration values of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. | numeric(9) | 0 |
Conductivity | Conductivity | Conductivity is the ability of water to lead electricity, and is proportional to the concentration of dissolved salts in the water sample. | numeric(9) | 0 |
pH | pH | pH = -log[H] | numeric(9) | 0 |
Temperature | Mean annual water temperature | C (degrees Celsius) | numeric(5) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | nvarchar(2) | -1 |
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(50) | -1 |
NationalStationID | National station ID | Identifier of the monitoring station for rivers, lakes, transitional, coastal and marine waters unique at the national level. Areas are recorded and reported as a discrete location, but location may relate to a station at a fixed geographical point, a broader area in which sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Where national station identifiers are not available for data provided by Marine Conventions, the national station identifier will be populated with a unique value based on a combination of Convention, quality data table and co-ordinate position. | nvarchar(50) | 0 |
Determinand | Determinand | determinand name. | nvarchar(50) | 0 |
Unit | Unit | unit of measurement. | 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) | 0 |
MethodOfAggregation | Method of aggregation | Method of aggregation (dimension and summary statistic) | nvarchar(150) | 0 |
CEN_ISO | CEN/ISO | CEN/ISO code of the methods. | nvarchar(100) | 0 |
LimitFlag | Limit of Detection or Determination Flag | Flag to indicate sample below analytical limit of detection or determination | nvarchar(3) | 0 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
QA_LRviolations | Quality assurance field - numerical list of logical rules violated in record | tested logical rules are explanained in QA documentation. | nvarchar(50) | 0 |
QA_CRviolations | Quality assurance field - numerical list of chemical rules violated by record | tested chemical rules are explanained in QA documentation | nvarchar(20) | 0 |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-rivers-5/waterbase-rivers-quality or scan the QR code.
PDF generated on 29 Mar 2024, 02:25 AM
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