title,note,,, Waterbase-Groundwater: Bodies ,The Bodies table contains the list of all WISE-SoE groundwater bodies reported for both the WISE-SoE data collection process and the Water Framework Directive. Detailed information about physical characteristics of the bodies and proxy pressure data within the area of the groundwater body are not provided. The data were not reported by all countries yet. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Bodies with their respective Quality. ,,, item,definition,note,data type,key 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 groundwat",nvarchar(50),-1 BodyName,Groundwater body name, ,nvarchar(255),0 EWNCode,EWN-Code,"Internally produced, unique identifier of the groundwater body. ",nvarchar(50),0 WFDbody,WFD body,Groundwater body is a Water framework directive body. 1=yes. ,tinyint(1),0 title,note,,, Waterbase-Groundwater: Quality ,"The Quality 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 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 groundwat",nvarchar(50),-1 AggregatedBy,Data aggregated by,"provides the information, whether the data were reported by country as aggregated (AggregatedBy = country) or as disaggregated (AggregatedBy = ETC/W) ",nvarchar(10),0 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(10),0 Ammonium_Cass_01,Ammonium class <=0.1 mg/l,"The number of sampling sites with average concentration of disaggregated values of Ammonium <= 0.1 mg/l, within the aggregation period.",int(4),0 Ammonium_class_01_03,Ammonium class > 0.1 to <= 0.3 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Ammonium between > 0.1 and <= 0.3 mg/l, within the aggregation period.",int(4),0 Ammonium_class_03_05,Ammonium class > 0.3 to <= 0.5 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Ammonium between > 0.3 and <= 0.5 mg/l, within the aggregation period.",int(4),0 Ammonium_class_05,Ammonium class > 0.5 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Ammonium > 0.5 mg/l, within the aggregation period.",int(4),0 Determinand,Determinand,determinand name. ,nvarchar(50),0 Determinant_code,Determinand code,"Identification number of the determinand monitored, as defined in the codelist. ",int(4),0 Dissolvedoxygen_class_2,Dissolved Oxygen class <= 2 mg/l,"The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen <= 2 mg/l, within the aggregation period.",int(4),0 Dissolvedoxygen_class_2_5,Dissolved Oxygen class > 2 to <= 5 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen between > 2 and <= 5 mg/l, within the aggregation period.",int(4),0 Dissolvedoxygen_class_5,Dissolved Oxygen class > 5 mg/l,"The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen > 5 mg/l, within the aggregation period.",int(4),0 Drinkingwatersites,Drinking water sites ,Number of sampling sites used for drinking water purposes. ,int(4),0 Industrialsites,Industrial sites,Number of sampling sites used for industrial purposes. ,int(4),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 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 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 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 Nitrate_class_10,Nitrate class <= 10 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrate <= 10 mg/l, within the aggregation period.",int(4),0 Nitrate_class_10_25,Nitrate class > 10 to <= 25 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrate between > 10 and <= 25 mg/l, within the aggregation period.",int(4),0 Nitrate_class_25_50,Nitrate class > 25 to <= 50 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrate between > 25 and <= 50 mg/l, within the aggregation period.",int(4),0 Nitrate_class_50,Nitrate class > 50 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrate > 50 mg/l, within the aggregation period.",int(4),0 Nitrite_class_001,Nitrite class <= 0.01 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrite <= 0.01 mg/l, within the aggregation period.",int(4),0 Nitrite_class_001_003,Nitrite class > 0.01 to <= 0.03 mg/l,"The number of sampling sites with average concentration of disaggregated values of Nitrite between > 0.01 and <= 0.03 mg/l, within the aggregation period.",int(4),0 Nitrite_class_003_006,Nitrite class > 0.03 to <= 0.06 mg/l,"The number of sampling sites with average concentration of disaggregated values of Nitrite between > 0.03 and <= 0.06 mg/l, within the aggregation period.",int(4),0 Nitrite_class_006_01,Nitrite class > 0.06 to <= 0.1 mg/l,"The number of sampling sites with average concentration of disaggregated values of Nitrite between > 0.06 and <= 0.1 mg/l, within the aggregation period.",int(4),0 Nitrite_class_01,Nitrite class > 0.1 mg/l ,"The number of sampling sites with average concentration of disaggregated values of Nitrite > 0.1 mg/l, within the aggregation period.",int(4),0 NoOfSamples,Number of samples,Number of samples included in aggregated data. ,int(4),0 NoOfSites,Number of sites,number of sampling sites investigated in aggregation period. ,int(4),0 Othersites,Other sites,Number of sampling sites used for other purposes. ,int(4),0 Pesticides_class_gt_01,Pesticides class > 0.1 µg/l,"the number of sampling sites with at least one value exceeding concentration of 0.1 µg/l, within the aggregation period ",int(4),0 Pesticides_class_le_01,Pesticides class < 0.1 µg/l,"the number of sampling sites with at least one value above LOQ and bellow the concentration of 0.1 µg/l, within the aggregation period ",int(4),0 Pesticides_class_lt_(lod),Pesticides class bellow LOQ,"the number of sampling sites with all individual values below the limit of quantification (LOQ), within the aggregation period. ",int(4),0 QA_LRviolations,Quality assurance field - numerical list of logical rules violated in record,tested logical rules are explanained in QA documentation. ,nvarchar(20),0 QA_Outlier,Quality assurance field - outlier flag,"mean value is an outlier for current station and determinand time series: 1=yes, 0=no. ",tinyint(1),0 Remarks,Remarks,"remarks, comments or explanatory notes. ",nvarchar(255),0 Samplingfrequency,Average sampling frequency,Average frequency that the sampling sites were monitored during the aggregation period. ,numeric(5),0 Surveillancesites,Surveillance sites,Number of sampling sites used for surveillance purposes. ,int(4),0 Unit,Unit ,unit of measurement. ,nvarchar(5),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),0