Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Lakes / Waterbase-Lakes: Quality

Waterbase-Lakes: Quality

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.
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
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100