title,note,,,
Waterbase-Groundwater: Bodies,The Bodies table contains the physical characteristics of the Eionet-Water groundwater bodies. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Bodies with their respective Quality and Pressures data.,,,

item,definition,note,data type,key
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),Yes
AquiferType,Aquifer type,"predominant aquifer type (Porous media, Fractured media, Karstic media).",nvarchar(20),No
Country,Country name (ISO 3166-1),official short name in English ,nvarchar(100),No
CountryCode,Country code,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.,nvarchar(2),No
DataSource,Data source,"source of data: Eionet-Water, ICES.",nvarchar(50),No
GwBodyArea,Groundwater body area,Groundwater body area in km2 ,numeric(9),No
GwBodyThickness,Groundwater body thickness,mean thickness of the groundwater body in m.,numeric(5),No
GwDepthTo,Depth to groundwater,mean depth to groundwater from the surface to the top of the groundwater body in m.,numeric(5),No
GwHorizon,Groundwater horizon,"groundwater horizon in which the groundwater body is mainly situated: 1=top horizon, etc.",int(4),No
Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255),No
WaterbaseName,Waterbase name,"name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or name of the groundwater body.",nvarchar(255),No
WaterDataSet,Water data set,"RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity.",nvarchar(5),No


title,note,,,
Waterbase-Groundwater: Pressures,The Pressure table contains proxy pressure data within the area of the groundwater body. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressure data with their respective Bodies and Quality data.,,,

item,definition,note,data type,key
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),Yes
AnnualPrecipitation,Annual precipitation,mean long term average annual precipitation over the groundwater body in mm/year.,numeric(5),No
CountryCode,Country code,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.,nvarchar(2),No
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.",numeric(5),No
Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255),No


title,note,,,
Waterbase-Groundwater: Quality,"The QualityWater table contains data on nutrients, organic matter and selected pesticides in groundwater bodies. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the QualityWater data with their respective Bodies and Pressure data. Each record has two special quality assurance fields. They are explained in QA documentation which can be found in ""Additional information"" part. ",,,

item,definition,note,data type,key
AggregationPeriod,Period of aggregation,"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),Yes
Determinand,Determinand,determinand name.,nvarchar(50),Yes
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),Yes
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),Yes
25Percentile,25th percentile,"25th percentile 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),No
75Percentile,75th percentile,"75th percentile 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),No
CountryCode,Country code,abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements.,nvarchar(2),No
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),No
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),No
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),No
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),No
NoOfSites,Number of sites,number of sampling sites investigated in aggregation period.,int(4),No
QA_LRviolations,Quality assurance field - numerical list of logical rules violated in record,tested logical rules are explanained in QA documentation.,nvarchar(100),No
QA_Outlier,Quality assurance field - outlier flag,"mean value is an outlier for current station and determinand time series: 1=yes, 0=no.",bit(1),No
Remarks,Remarks,"remarks, comments or explanatory notes.",nvarchar(255),No
Unit,Unit,unit of measurement.,nvarchar(20),No