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!
Data
The QualityWaterD table contains disaggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-water transitional, coastal or marine water monitoring stations, provided by national sources only. 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.
[+] Show table definition (records: 945950)
Day | Day | day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0. | int(4) | -1 |
Month | Month | month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0. | int(4) | -1 |
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 |
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 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | -1 |
Concentration | Concentration | concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <. | float(8) | 0 |
Salinity | Salinity | salinity of sample. | float(8) | 0 |
SampleDepth | Sample depth | depth at which sample taken in m below water surface | float(8) | -1 |
ThermoPos | Thermocline position | vertical position relative to thermocline at transitional, coastal and marine water station. AT=above thermocline, IT=in thermocline, BT=below thermocline. | varchar(2) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
HaloPos | Halocline position | vertical position relative to halocline at transitional, coastal and marine water station. AH=above halocline, IH=in halocline, BH=below halocline. | varchar(2) | 0 |
LimitOfDetectionFlag | Limit of detection or determination flag | flag to indicate sample below analytical limit of detection or determination in format <. | varchar(1) | 0 |
The QualityBiota table contains aggregated data on hazardous substances in biota, 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.
[+] Show table definition (records: 59298)
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). | 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 |
DryFreshNoOfSamples | Dry fresh ratio number of samples | number of samples taken in ratio of dry weight to fresh weight as a percentage. | int(4) | 0 |
FatNoOfSamples | Fat content number of samples | number of samples of fat content as a percentage of total wet matter. | int(4) | 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). | int(4) | 0 |
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 |
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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 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). | float(8) | 0 |
FatMaximum | Fat content maximum | maximum fat content as a percentage of total wet matter. | float(8) | 0 |
FatMean | Fat content mean | mean fat content as a percentage of total wet matter. | float(8) | 0 |
FatMinimum | Fat content minimum | minimum fat content as a percentage of total wet matter. | float(8) | 0 |
DryFreshMaximum | Dry fresh ratio maximum | maximum ratio of dry weight to fresh weight as a percentage. | float(8) | 0 |
DryFreshMean | Dry fresh ratio mean | mean ratio of dry weight to fresh weight as a percentage. | float(8) | 0 |
DryFreshMinimum | Dry fresh ratio minimum | minimum ratio of dry weight to fresh weight as a percentage. | float(8) | 0 |
Tissue | Tissue | tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body. | varchar(2) | -1 |
Basis | Basis | basis of measurement. D=dry, L=lipid (fat), W=wet. | varchar(1) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Species | Species | species monitored. | varchar(20) | -1 |
The QualityHSWaterD table contains disaggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. 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.
[+] Show table definition (records: 3346)
Day | Day | day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0. | int(4) | -1 |
Month | Month | month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0. | int(4) | -1 |
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 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | -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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
Concentration | Concentration | concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to . | float(8) | 0 |
Salinity | Salinity | salinity of sample. | float(8) | 0 |
SampleDepth | Sample depth | depth at which sample taken in m below water surface | float(8) | -1 |
ThermoPos | Thermocline position | vertical position relative to thermocline at transitional, coastal and marine water station. AT=above thermocline, IT=in thermocline, BT=below thermocline. | varchar(2) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
HaloPos | Halocline position | vertical position relative to halocline at transitional, coastal and marine water station. AH=above halocline, IH=in halocline, BH=below halocline. | varchar(2) | 0 |
LimitOfDetectionFlag | Limit of detection or determination flag | flag to indicate sample below analytical limit of detection or determination in format . | varchar(1) | 0 |
The QualitySediment table contains aggregated data on hazardous substances in sediment, 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.
[+] Show table definition (records: 18852)
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 |
Fraction | Fraction | upper limit of particle size in analysed fraction in µm. | int(4) | 0 |
NoOfSamples | Number of samples | number of samples in aggregation period. | int(4) | 0 |
PeriodLength | Period length | number of months in aggregation period. | int(4) | 0 |
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 |
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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
SedimentBottom | Bottom of sediment layer | bottom of analysed sediment layer measured from the sediment surface in cm. Value -1 means that this information is not available. | float(8) | -1 |
SedimentTop | Top of sediment layer | top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface. Value -1 means that this information is not available. | float(8) | -1 |
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 |
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 |
OrganicCarbon | Organic carbon | organic carbon content as a percentage of total dry weight. | float(8) | 0 |
BottomDepth | Bottom depth of sediment | depth of sea bottom at sampling site in m. | float(8) | 0 |
DryWetRatio | Dry wet ratio | ratio of dry weight to wet weight as a percentage. | 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 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Basis | Basis | basis of measurement. D=dry, L=lipid (fat), W=wet. | varchar(1) | 0 |
GrainType | Grain type | sediment type description. M=mud, FS=fine sand, MS=middle sand, CS=coarse sand, G=gravel. | varchar(2) | 0 |
The Pressures table contains proxy pressure data on the upstream catchment or drainage basin of the Eionet-Water transitional water monitoring stations, or within the River Basin District to which the coastal water monitoring stations have been assigned, provided by national sources. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressures data with their respective Stations and Quality data.
[+] Show table definition (records: 220)
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 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
PopulationDensity | Population density | population density of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set) in capita/km2. | float(8) | 0 |
LanduseTotalAgriculture | Total agricultural land use | total agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2. | float(8) | 0 |
LanduseUrban | Urban land use | urban agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 1.1. | float(8) | 0 |
LanduseWetland | Wetland land use | wetland agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 4.1 plus 4.2. | float(8) | 0 |
LanduseOther | Other land use | other land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). | float(8) | 0 |
LanduseOtherAgriculture | Other agricultural land use | other agricultural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.2 plus 2.4. | float(8) | 0 |
LandusePasture | Pastoral land use | pastoral land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. | float(8) | 0 |
LanduseArableLand | Arable land use | arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1. | float(8) | 0 |
LanduseForest | Landuse forest | forested land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.1. | float(8) | 0 |
LanduseNature | Natural land use | natural land use as a percentage of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 3.2 plus 3.3. | float(8) | 0 |
Waste | Waste | waste disposal ground in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
Spoil | Spoil | dredged spoil disposal ground in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
OtherDischarge | Other discharge | direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". Y=yes, N=no. | varchar(1) | 0 |
Port | Port | presence of port facilities in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
SewageDischarge | Sewage discharge | direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". U=UWWT, NU=Non-UWWT, BU=Both. | varchar(2) | 0 |
Marina | Marina | presence of a marina in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
OilExtraction | Oil extraction | exploration for or extraction of oil in the transitional, coastal or marine water body. Y = yes, N = no. | varchar(1) | 0 |
OtherActivities | Other activities | any other activities in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
IndustrialDischarge | Industrial discharge | direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". E=EPER, NE=Non-EPER, BE=Both. | varchar(2) | 0 |
LandFill | Landfill | transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites. Y=yes, N=no. | varchar(1) | 0 |
Mariculture | Mariculture | fish and shellfish farming in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Fishing | Fishing | commercial fishing activity in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
GasExtraction | Gas extraction | exploration for or extraction of gas in the transitional, coastal or marine water body. Y=yes, N=no. | varchar(1) | 0 |
The QualityBiotaD table contains disaggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. 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.
[+] Show table definition (records: 16711)
Day | Day | day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0. | int(4) | -1 |
Month | Month | month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0. | int(4) | -1 |
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 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | -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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
Concentration | Concentration | concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <. | float(8) | 0 |
DryFreshRatio | Dry fresh ratio | ratio of dry weight to fresh weight as a percentage. | float(8) | 0 |
Fat | Fat | fat content as a percentage of total wet matter. | float(8) | 0 |
Species | Species | species monitored. | varchar(20) | -1 |
Tissue | Tissue | tissue element of species monitored. LI=liver, MU=muscle, SB=soft body, WO=whole body. | varchar(2) | -1 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Basis | Basis | basis of measurement. D=dry, L=lipid (fat), W=wet. | varchar(1) | 0 |
LimitOfDetectionFlag | Limit of detection or determination flag | flag to indicate sample below analytical limit of detection or determination in format <. | varchar(1) | 0 |
The Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.
[+] Show table definition (records: 174)
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 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
Unit | Unit | unit of measurement. | nvarchar(30) | 0 |
WaterBodyID | Water body ID | national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
WaterBodyName | Water body name | name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
SeaAreaName | Sea area name | name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName. | nvarchar(255) | 0 |
SeaConventionArea | Marine convention area | name of Marine Convention area of which regional sea is a part. | nvarchar(255) | 0 |
SeaRegionName | Sea region name | name of regional sea of which local sea area is a part. | nvarchar(255) | 0 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Country | Country name | official short name in English. ISO 3166-1. | nvarchar(255) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | 0 |
Load | Load | estimated load of determinand. | float(8) | 0 |
Method | Method of estimation | OutY=calculations including outlier values, OutN=calculations excluding outlier values, FloodY=calculations accounting for flood events, FloodN=calculations not accounting for flood events, XSS=loads calculated by extrapolation from concentrations (of micropollutants) in suspended sediment, Other=other methods. | varchar(20) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
DischargeType | Discharge type | I=industrial, M=municipal, T=total. | varchar(1) | 0 |
Estimate | Estimate type | L=lower estimate based on treating determinand values that are less than the limits of detection as zero, U=upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X=unspecified. | varchar(1) | 0 |
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.
[+] Show table definition (records: 309241)
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 |
The Stations table contains the Eionet-Water transitional, coastal and 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 Stations with their respective Quality and Pressures data.
[+] Show table definition (records: 38117)
TCMMatrix | Matrix | environmental compartments measured at transitional, coastal or marine water station. B=biota, S=sediment, W=water column. Any combination allowed, listed alphabetically with no separator (e.g. BSW). | varchar(3) | 0 |
WaterBodyType | Water body type | RV=river, CN=canal, T=transitional water, C=coastal water, M=marine water. | varchar(2) | 0 |
Mixing | Mixing characteristics | mixing characteristics at transitional, coastal or marine water monitoring station: FM = Fully mixed, PM = Partially mixed, VS = Vertically stratified. | varchar(2) | 0 |
PhysChemStation | Physico-Chemicals category station | physico-chemical conditions monitored at station. R=represenatative station type, I=impact station type. | varchar(1) | 0 |
StationClass | Station class | proximity to land, defined by comparing supplied station co-ordinates with maps. Coast=within 20 km of closest land or island, Open Water=more than 20 km from closest land or island. | varchar(10) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
DataSource | Data source | source of data: Eionet-Water, ICES. | varchar(50) | 0 |
HazsubsStation | Hazardous substances category station | hazardous substances monitored at station type: R = Represenatative station, I = Impact station. | varchar(1) | 0 |
ReferenceStation | Reference Station | reference station type, found in catchments or associated River Basin Districts with little or no human activity, natural landscape higher than 90%, and minimally impacted by inflow from adjacent coastal or marine waters. Concentrations of nutrients or hazardous substances occurring naturally would give an indication of background levels. For volatile sunthetic substances, data from these stations might be used to assess the significance of atmospheric deposition. River and lake stations can be of more than one type. 1=yes, 0=no. | int(4) | 0 |
SeaConventionArea | Marine Convention Area | name of Marine Convention area of which regional sea is a part. | nvarchar(255) | 0 |
SeaRegionName | Sea region name | name of regional sea of which local sea area is a part. | nvarchar(255) | 0 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
WaterBodyID | Water body ID | national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
WaterBodyName | Water body name | name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
SeaAreaName | Sea area name | name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName. | nvarchar(255) | 0 |
NationalStationID | National Station ID | identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station. | nvarchar(255) | 0 |
Region | Region | national region in which water body is located. | nvarchar(255) | 0 |
WaterbaseName | Waterbase name | national name of station or groundwater body. | 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 |
Country | Country name | official short name in English. ISO 3166-1. | nvarchar(255) | 0 |
CatchmentName | Catchment name | name of major catchment or basin. | nvarchar(255) | 0 |
Temperature | Mean annual temperature | mean annual temperature at transitional, coastal or marine water station in degrees Celsius. | float(8) | 0 |
TidalMean | Mean tidal range | mean tidal range at transitional, coastal or marine water station in m. | float(8) | 0 |
SalinityMinimum | Minimum annual salinity | minimum annual salinity measured at transitional, coastal or marine water station. | float(8) | 0 |
SeaDepth | Mean annual depth | mean annual sea depth at transitional, coastal or marine water station in m. | float(8) | 0 |
SeaResidence | Residence time | residence time of transitional or coastal water body in days. | float(8) | 0 |
MainlandCoast | Mainland coast | distance of marine station from nearest mainland coast expressed in km. | float(8) | 0 |
SalinityMaximum | Maximum annual salinity | maximum annual salinity measured at transitional, coastal or marine water station. | float(8) | 0 |
SalinityMean | Mean annual salinity | mean annual salinity measured at transitional, coastal or marine water station. | float(8) | 0 |
ClosestCoast | Closest coast | distance of marine station from closest coast expressed in km. Only shown if different from MainlandCoast. | float(8) | 0 |
Latitude | Latitude | (Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
Longitude | Longitude | (X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
WaterBodyTypeDesc | Water body type description | additional water body description, e.g. Bay, Coastal Lagoon, Embayment, Estuary, Fjord. | varchar(50) | 0 |
WaterDataSet | Water data set | RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity. | varchar(3) | 0 |
StationReporting | Station reporting purpose | reporting purpose of the transitional, coastal or marine water station. EC=European Commission, MC=Marine Conventions, N=national purposes. Station can be for more than one reporting purpose, listed alphabetically with no separator (e.g. ECN). | varchar(10) | 0 |
The QualityHSWater table contains aggregated data on hazardous substances 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.
[+] Show table definition (records: 1070)
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 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
Unit | Unit | unit of measurement. | nvarchar(30) | 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 |
The FluxStations table contains the physical characteristics of the Eionet-Water transitional, coastal and marine water stations used to monitor riverine input loads, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the FluxStations with their respective Input (load) data.
[+] Show table definition (records: 322)
WaterBodyID | Water body ID | national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
WaterBodyName | Water body name | name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it. | nvarchar(255) | 0 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
SeaConventionArea | Marine convention area | name of Marine Convention area of which regional sea is a part. | nvarchar(255) | 0 |
SeaRegionName | Sea region name | name of regional sea of which local sea area is a part. | nvarchar(255) | 0 |
WaterbaseName | Waterbase name | national name of station or groundwater body. | nvarchar(255) | 0 |
NationalStationID | National station ID | identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station. | nvarchar(255) | 0 |
RiverName | River name | national name of river. | nvarchar(255) | 0 |
SeaAreaName | Sea area name | name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName. | 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 |
Country | Country name | official short name in English. ISO 3166-1. | nvarchar(255) | 0 |
CatchmentName | Catchment name | name of major catchment or basin. | nvarchar(255) | 0 |
Latitude | Latitude | (Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
Longitude | Longitude | (X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided. | float(8) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
DataSource | Data source | source of data: Eionet-Water, ICES. | varchar(50) | 0 |
WaterDataSet | Water data set | RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity. | varchar(3) | 0 |
The QualitySedimentD table contains disaggregated data on hazardous substances in sediment, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. 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.
[+] Show table definition (records: 19151)
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 |
Day | Day | day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0. | int(4) | -1 |
Fraction | Fraction | upper limit of particle size in analysed fraction in µm. | int(4) | 0 |
Month | Month | month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0. | int(4) | -1 |
Remarks | Remarks | remarks, comments or explanatory notes. | nvarchar(255) | 0 |
SampleID | Sample ID | unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. | nvarchar(50) | -1 |
Sampler | Sampler | name of sampling equipment used. | nvarchar(255) | 0 |
Unit | Unit | unit of measurement. | nvarchar(30) | 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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
OrganicCarbon | Organic carbon | organic carbon content as a percentage of total dry weight. | float(8) | 0 |
SedimentBottom | Bottom of sediment layer | bottom of analysed sediment layer measured from the sediment surface in cm. | float(8) | -1 |
SedimentTop | Top of sediment layer | top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface. | float(8) | -1 |
BottomDepth | Bottom depth of sediment | depth of sea bottom at sampling site in m. | float(8) | 0 |
Concentration | Concentration | concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to <. | float(8) | 0 |
DryWetRatio | Dry wet ratio | ratio of dry weight to wet weight as a percentage. | float(8) | 0 |
LimitOfDetectionFlag | Limit of detection or determination flag | flag to indicate sample below analytical limit of detection or determination in format <. | varchar(1) | 0 |
Basis | Basis | basis of measurement. D=dry, L=lipid (fat), W=wet. | varchar(1) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
GrainType | Grain type | sediment type description. M=mud, FS=fine sand, MS=middle sand, CS=coarse sand, G=gravel. | varchar(2) | 0 |
The Inputs table contains data on the yearly riverine inputs of loads to transitional, coastal and marine waters which are monitored at Eionet-Water flux stations, provided by national sources or Marine Conventions. Each flux station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective Flux Stations data.
[+] Show table definition (records: 16830)
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 |
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 |
CASNo | Chemical Abstract Service Number | Chemical Abstract Service Number of determinand. | nvarchar(20) | 0 |
Determinand | Determinand | determinand name. | nvarchar(255) | -1 |
Load | Load | estimated load of determinand. | float(8) | 0 |
CountryCode | Country code | abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. | varchar(2) | 0 |
Estimate | Estimate type | L=lower estimate based on treating determinand values that are less than the limits of detection as zero, U=upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X=unspecified. | varchar(1) | -1 |
Method | Method of estimation | OutY=calculations including outlier values, OutN=calculations excluding outlier values, FloodY=calculations accounting for flood events, FloodN=calculations not accounting for flood events, XSS=loads calculated by extrapolation from concentrations (of micropollutants) in suspended sediment, Other=other methods. | varchar(20) | 0 |
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water selects validated monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. The added value of Waterbase is that data collected through the Eionet-Water process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEA's indicator-based factsheets.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-2 or scan the QR code.
PDF generated on 06 Jun 2023, 04:56 AM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others