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!
PeriodLength | Period length | number of months in aggregation period. | tinyint(1) | 0 |
DryFreshNoOfSamples | Dry fresh ratio number of samples | number of samples taken in ratio of dry weight to fresh weight as a percentage. | tinyint(1) | 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. | smallint(2) | 0 |
LowNoOfSamples | Low range number of samples | number of samples in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). | smallint(2) | 0 |
HighNoOfSamples | High range number of samples | number of samples in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). | smallint(2) | 0 |
FatNoOfSamples | Fat content number of samples | number of samples of fat content as a percentage of total wet matter. | smallint(2) | 0 |
LowMinimum | Low range minimum | minimum concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). | numeric(9) | 0 |
Low10Percentile | Low range 10th percentile | 10th percentile concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). | numeric(9) | 0 |
LowMean | Low range mean | mean concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). | numeric(13) | 0 |
LowMedian | Low range median | median concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero). | numeric(9) | 0 |
HighMean | High range mean | mean concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). | numeric(13) | 0 |
HighMedian | High range median | median concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). | numeric(9) | 0 |
FatMinimum | Fat content minimum | minimum fat content as a percentage of total wet matter. | numeric(5) | 0 |
FatMaximum | Fat content maximum | maximum fat content as a percentage of total wet matter. | numeric(5) | 0 |
High90Percentile | High range 90th percentile | 90th percentile concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). | numeric(9) | 0 |
HighMaximum | High range maximum | maximum concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection). | numeric(13) | 0 |
DryFreshMean | Dry fresh ratio mean | mean ratio of dry weight to fresh weight as a percentage. | numeric(5) | 0 |
DryFreshMinimum | Dry fresh ratio minimum | minimum ratio of dry weight to fresh weight as a percentage. | numeric(5) | 0 |
DryFreshMaximum | Dry fresh ratio maximum | maximum ratio of dry weight to fresh weight as a percentage. | numeric(5) | 0 |
FatMean | Fat content mean | mean fat content as a percentage of total wet matter. | numeric(5) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | nvarchar(2) | 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(50) | -1 |
Determinand | Determinand | determinand name. | nvarchar(100) | -1 |
Unit | Unit | unit of measurement. | nvarchar(20) | 0 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | 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 |
Species | Species | species monitored. | nvarchar(10) | -1 |
Tissue | Tissue | tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body. | nvarchar(2) | -1 |
Basis | Basis | basis of measurement. D=dry, L=lipid (fat), W=wet. | nvarchar(1) | 0 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-3/waterbase-tcm-qualitybiota or scan the QR code.
PDF generated on 02 May 2024, 11:32 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