Waterbase-Lakes: Hazardous substances

Data Table expired
This content has been archived on 07 Jul 2014, reason: Other (New version data-and-maps/data/waterbase-lakes-10 was published)
The HazSub table contains data on hazardous substances in water measured at WISE-SoE lake monitoring stations. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the HazSubs data with their respective Stations and Pressures data. Each record has three special quality assurance fields. Their meaning is explained in the QA documentation which can be found in the "Additional information" section.
European data
Table definition
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
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. smallint(2) 0
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. smallint(2) 0
NoOfSubsites Number of subsites smallint(2) 0
NumberOfSamples Number of samples number of samples in aggregation period. smallint(2) 0
QA_outlier Quality assurance field - outlier flag the highlighted data quality issues are explained in the QA documentation smallint(2) 0
SampleDepth Sample depth depth at which sample taken in m below water surface float(8) 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. float(8) 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%). float(8) 0
Concentration Concentration concentration of determinand in sample. 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
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. float(8) 0
Hardness Water hardness float(8) 0
Na Concentration of natrium mg/l float(8) 0
K Concentration of kalium mg/l float(8) 0
HCO3 Concentration of hydrogen carbonate mg/l float(8) 0
Cl Concentration of chloride mg/l float(8) 0
SO4 Concentration of sulphate mg/l float(8) 0
SuspendedParticulateMatter Concentration of suspended particulate matter (such as clay or other mineral particles, detrital particles, bacteria and algal cells) mg/l float(8) 0
DissolvedOrganicMatter Concentration of dissolved organic matter mg/l float(8) 0
pH pH pH = -log[H] float(8) 0
Temperature Mean annual water temperature C (degrees Celsius) float(8) 0
Ca Concentration of calcium mg/l float(8) 0
Mg Concentration magnesium mg/l float(8) 0
CountryCode Country Code ISO3166 two digit code nvarchar(2) -1
WaterbaseID Unique Waterbase Identifier represents the EWN groundwater body code nvarchar(60) -1
Determinand_HazSubs Name of Hazardous Substance Determinand nvarchar(50) 0
Unit_HazSubs Unit unit of measurement of hazardous substances nvarchar(10) 0
CASNumber CAS Number Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. nvarchar(20) 0
SampleAnalysis Sample analysis code F = Analysis undertaken on filtered water sample; S=Analysis undertaken on suspended matter; T=Analysis undertaken on unfiltered water sample nvarchar(1) 0
CEN_ISO CEN/ISO CEN/ISO code of the methods. nvarchar(150) 0
MethodOfAggregation Method of aggregation Method of aggregation (dimension and summary statistic) nvarchar(255) 0
LimitFlag Limit of Detection or Determination Flag Flag to indicate sample below analytical limit of detection or determination nvarchar(1) 0
Remarks Remarks nvarchar(255) 0
QA_station_problems Quality assurance field - stations data quality issues flag the highlighted stations data quality issues are explained in the QA documentation nvarchar(25) 0
QA_datatype_errors Quality assurance field - data type and data definition errors list of field names and their values where values do not follow official specifications. Details are explained in the QA documentation nvarchar(255) 0
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Phone: +45 3336 7100