Waterbase-Lakes: Quality

Data Table

This page was archived on 07 Jul 2014 with reason: Other (New version data-and-maps/data/waterbase-lakes-10 was published)

The Quality table contains data on nutrients and organic matter 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 Quality data with their respective Stations and Pressures data. Each record has five special quality assurance fields. Their meaning is explained in the QA documentation which can be found in the "Additional information" section.

Data and maps

Menu

Category

European data

Records

251230

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 latest data request.	smallint(2)	0
PeriodLength	Period length	number of months in aggregation period.	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
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.	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 have been replaced with a value equivalent to half the limit of detection or determination.	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 have been replaced with a value equivalent to half the limit of detection or determination.	float(8)	0
TotalDepth	Total depth of water column	Total depth of water column at the sampling location and at the time of sampling (meters)	float(8)	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.	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
Alkalinity	Alkalinity	Long-term average alkalinity.	float(8)	0
Conductivity	Conductivity	Conductivity is the ability of water to lead electricity, and is proportional to the concentration of dissolved salts in the water sample.	float(8)	0
pH	pH	pH = -log[H]	float(8)	0
Temperature	Mean annual water temperature	C (degrees Celsius)	float(8)	0
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 groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).	nvarchar(60)	-1
Determinand	Determinand	determinand name.	nvarchar(30)	0
Unit	Unit	unit of measurement.	nvarchar(10)	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(30)	0
MethodOfAggregation	Method of aggregation	Method of aggregation (dimension and summary statistic)	nvarchar(0)	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
CEN_ISO	CEN/ISO	CEN/ISO code of the methods.	nvarchar(150)	0
Limitflag	Limit of Detection or Determination Flag	Flag to indicate sample below analytical limit of detection or determination	nvarchar(1)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0
QA_LRviolations	Quality assurance field - numerical list of logical rules violated in record	tested logical rules are explanained in QA documentation.	nvarchar(255)	0
QA_CRviolations	Quality assurance field - numerical list of chemical rules violated by record	tested chemical rules are explanained in QA documentation	nvarchar(20)	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