All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Physical Characteristics of Lakes Monitoring Stations (Waterbase_lakes_v11_Stations, 3509 records)
Physical characteristics of the WISE-SoE lake monitoring stations.
Field name | Definition | Note | data type |
---|---|---|---|
RecordID | Unique record identifier | long | |
RecordReported | Date when the record was reported by the data provider. | text(10) | |
CountryCode | Abbreviation of EEA Member or Collaborating Country | ISO 3166-1-alpha-2 code elements | text(2) |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(100) |
NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(100) | |
NationalStationName | National name of the monitoring station | text(150) | |
WFDstation | Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station. | text(3) | |
WFD_EU_CD | Unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station. | text(50) | |
LakeName | Name of lake. | text(150) | |
WaterCategory | Water Category, as defined in the codelist. | text(2) | |
WaterBodyID | National identification code of water body in which station is located | text(50) | |
WaterBodyName | Name of water body in which station is located. | text(255) | |
CatchmentName | Name of major catchment or basin. | text(150) | |
RBDcode | River Basin District Code | text(20) | |
RBDname | Name of the River Basin District. | text(150) | |
Region | National region in which water body is located | text(50) | |
Longitude | International geographical longitude (x) co-ordinate in decimal degrees format. | decimal | |
Latitude | International geographical latitude (x) co-ordinate in decimal degrees format. | decimal | |
CatchmentArea | Catchment area upstream of the station, in kilometres squared. | decimal | |
Altitude | Altitude of station in metres above sea level. | long | |
RepresentativeStation | Station is representative, reflecting general quality of rivers/lakes/transitional or coastal water bodies or marine water areas. | text(1) | |
ReferenceStation | Station is reference station - found in catchments or associated River Basin Districts with little or no human activity, natural landscape higher than 90%, and minimally impacted by inflow from adjacent coastal or marine waters. | text(1) | |
ImpactStation | Station is impact station - located within the zone where initial mixing of discharges takes place with receiving waters. | text(1) | |
LargestStation | Station is largest station - most important station, including the nationally most important or well known rivers or lakes. | text(1) | |
Geology | The dominnt geology in the catchment, given according to the WFD Annex 2 categories. | siliceous, calcareous, organic (peat) | text(50) |
WaterColourAverage | Long-term average concentration of water colour, expressing the concentration of humic substances at the station. | decimal | |
WaterColourLevel | Average level of water colour as defined by the WFD intercalibration typology. | low (<30 mg/l Pt = oligohumic), moderate (30-90 mg/l Pt = mesohumic) or high (>90 mg/l Pt = polyhumic). | text(8) |
AlkalinityAverage | Long-term average of alkalinity of water at the station | decimal | |
AlkalinityLevel | Long-term average level of alkalinity as defined by the WFD intercalibration typology. | low alk. (<0.2 meq/L), moderate alk. (0.2-1 meq/L) or high alk. (>1 meq/L) | text(8) |
HMWB | River/Lake is identified as heavily modified in terms of hydromorphological impacts, such as impoundments and high water level fluctuations, according to WFD-compliant national guidelines | text(1) | |
ArtificialWB | Station is located in an artificial water body, (e.g. artificial water reservoir) in terms of hydromorphological impacts, such as impoundments and high water level fluctuations, according to WFD-compliant national guidelines. | text(1) | |
Purpose | The purpose of the monitoring station in terms of to which directives, conventions or agreements will the data from the station be used for reporting. | text(255) | |
Location | Location of the lake monitoring site. | text(150) | |
SurfaceArea | Surface area of lake in square kilometres. | decimal | |
MeanDepth | Mean depth of the lake in metres. | decimal | |
MaximumDepth | Maximum depth of the lake in metres. | decimal | |
ResidenceTime | Average lake residence time in years. | decimal | |
Volume | Volume of water in lake in million cubic metres. | decimal | |
Reservoir | Reservoir or natural lake. | Y - reservoir, N - natural lake | text(1) |
SamplingDepth | Depth at which sample taken in metres below the lake surface. | text(20) | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
QA_station_issues | Quality assessment field - stations data quality issues flag | List of codes of station data issues detected in the record. Details are explained in the QA documentation. | text(100) |
QA_DDviolations | Quality assessment field - data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. | memo |
Proxy Pressures of Lakes (Waterbase_lakes_v11_Pressures, 2029 records)
Proxy pressure data on the upstream catchments of WISE-SoE lake monitoring stations.
Field name | Definition | Note | data type |
---|---|---|---|
RecordID | Unique record identifier | long | |
RecordReported | Date when the record was reported by the data provider. | text(10) | |
CountryCode | Abbreviation of EEA Member or Collaborating Country | ISO 3166-1-alpha-2 code elements | text(2) |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(100) |
NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(100) | |
PopulationDensity | Population density of the upstream catchment of the river monitoring station | decimal | |
UWWT | Point source pressure from urban waste water treatment discharges. | text(1) | |
OverflowsDischarges | Point source pressure from overflows and urban discharges. | text(1) | |
IPPC | Point source pressure from IPPC installations. | text(1) | |
nonIPPC | Point source pressure from non-IPPC installations | text(1) | |
Fertiliser | Diffuse sources pressures from agricultural fertiliser use. | text(1) | |
Pesticide | Diffuse sources pressures from agricultural pesticide use. | text(1) | |
Livestock | Diffuse sources pressures from livestock. | text(1) | |
TransportInfrastructure | Diffuse sources pressures from transport and infrastructure without connection to sewers. | text(1) | |
PublicWaterSupply | Water abstractions pressures due to public water supply. | text(1) | |
Industry | Water abstractions pressures due to industry. | text(1) | |
Irrigation | Water abstractions pressures due to irrigation. | text(1) | |
Cooling | Water abstractions pressures due to needs for cooling water, e.g. for nuclear power plants or other industrial activities. | text(1) | |
WaterFlowRegulation | Water flow regulation and morphological alterations. | text(50) | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
QA_station_issues | Quality assessment field - stations data quality issues flag | List of codes of station data issues detected in the record. Details are explained in the QA documentation. | text(100) |
QA_DDviolations | Quality assessment field - data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. | memo |
Nutrients and General Physico-Chemical Determinands in Lakes (Waterbase_lakes_v11_Nutrients, 318184 records)
Data on nutrients and organic matter in water measured at WISE-SoE lake monitoring stations.
Field name | Definition | Note | data type |
---|---|---|---|
RecordID | Unique record identifier | long | |
RecordReported | Date when the record was reported by the data provider. | text(10) | |
CountryCode | Abbreviation of EEA Member or Collaborating Country | ISO 3166-1-alpha-2 code elements | text(2) |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(100) |
NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(100) | |
Year | Year of aggregation period in which samples were taken/Year in which sample was taken. | long | |
AggregationPeriod | Period of aggregation of measurement data. | Values are standardized | text(20) |
AggregationPeriod_original | Original aggregation period value reported by dat provider. | text(100) | |
AggregationMonths | Detailed specification of aggregation period by months. | text(150) | |
AggregationLength | Number of months in aggregation period. | long | |
Determinand_Nutrients | Name of nutrient, organic matter or general physico-chemical determinand. | text(50) | |
Unit_Nutrients | Unit of measurement of nutrients or organic matter. | text(7) | |
CEN_ISO | CEN/ISO code of the methods. | text(150) | |
NumberOfSamples | Number of samples included in aggregated data. | long | |
LimitOfDetection | 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. | decimal | |
LimitOfQuantification | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | decimal | |
Minimum | Minimum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Mean | Mean concentration value of aggregated data. | decimal | |
Maximum | Maximum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Median | Median concentration value of aggregated data. | decimal | |
StandardDeviation | Standard deviation of concentration values of aggregated data. | decimal | |
SampleDepth | Depth at which sample taken in metres below water surface. | decimal | |
TotalDepth | Total depth of water column at the sampling location and at the time of sampling (in meters). | decimal | |
NoOfSubsites | Number of subsites | long | |
MethodSubsitesSpatialAggreg | Method of subsite aggregation - if several subsites across the water body profile are joined into one monitoring station. | text(255) | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
AggregatedBy | Subject(s) that aggregated the data. | text(20) | |
QA_MVissues | long | ||
QA_LRviolations | Quality assessment field - list of logical rules violations. | List of codes of logical rules violated by record. Details are explained in the QA documentation. | text(100) |
QA_outlier | Quality assessment field - outlier flag. | Outlier code assigned to the record. Details are explained in the QA documentation. | long |
QA_CRviolations | Quality assessment field - list of chemical rules violations. | List of codes of chemical rules violated by record. Details are explained in the QA documentation. | text(50) |
QA_station_issues | Quality assessment field - stations data quality issues flag | List of codes of station data issues detected in the record. Details are explained in the QA documentation. | text(100) |
QA_DDviolations | Quality assessment field - data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. | memo |
Hazardous Substances and Other Chemical Determinands in Lakes (Waterbase_lakes_v11_HazSubs, 57193 records)
Data on hazardous substances and other chemical determinands in water measured at WISE-SoE lake monitoring stations.
Field name | Definition | Note | data type |
---|---|---|---|
RecordID | Unique record identifier | long | |
RecordReported | Date when the record was reported by the data provider. | text(10) | |
CountryCode | Abbreviation of EEA Member or Collaborating Country | ISO 3166-1-alpha-2 code elements | text(2) |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(100) |
NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(100) | |
Year | Year of aggregation period in which samples were taken/Year in which sample was taken. | long | |
Determinand_HazSubs | Name of hazardous substance or other chemical determinand. | text(150) | |
Unit_HazSubs | Unit of measurement of hazardous substance. | text(20) | |
CASNumber | Chemical Abstract Service Number of the hazardous substance or other chemical determinand. | text(64) | |
CEN_ISO | CEN/ISO code of the methods. | text(150) | |
NumberOfSamples | Number of samples included in aggregated data. | long | |
NumberOfSamplesBelowLOQ | Number of samples below limit of quantification within aggregation period | long | |
LimitOfDetection | 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. | decimal | |
LimitOfQuantification | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | decimal | |
Minimum | Minimum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Mean | Mean concentration value of aggregated data. | decimal | |
Maximum | Maximum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Median | Median concentration value of aggregated data. | decimal | |
StandardDeviation | Standard deviation of concentration values of aggregated data. | decimal | |
SampleDepth | Depth at which sample taken in metres below water surface. | decimal | |
NoOfSubsites | Number of subsites | long | |
MethodSubsitesSpatialAggreg | Method of subsite aggregation - if several subsites across the water body profile are joined into one monitoring station. | text(255) | |
Remarks | Remarks, comments or explanatory notes | text(255) | |
AggregatedBy | Subject(s) that aggregated the data. | text(20) | |
QA_MVissues | long | ||
QA_LRviolations | Quality assessment field - list of logical rules violations. | List of codes of logical rules violated by record. Details are explained in the QA documentation. | text(100) |
QA_station_issues | Quality assessment field - stations data quality issues flag | List of codes of station data issues detected in the record. Details are explained in the QA documentation. | text(50) |
QA_DDviolations | Quality assessment field - data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. | memo |
Supportive Determinands for hazardous substances in Lakes (Waterbase_lakes_v11_SuppDet, 39861 records)
Data on supportive determinands, supplementing information on hazardous substances in water measured at WISE-SoE lake monitoring stations.
Field name | Definition | Note | data type |
---|---|---|---|
RecordID | Unique record identifier | long | |
RecordReported | Date when the record was reported by the data provider. | text(10) | |
CountryCode | Abbreviation of EEA Member or Collaborating Country | ISO 3166-1-alpha-2 code elements | text(2) |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode, '_LK_' and NationalStationID | text(100) |
NationalStationID | Identifier of the lake monitoring station, unique at the national level. | text(100) | |
Year | Year of aggregation period in which samples were taken/Year in which sample was taken. | long | |
Determinand_Supportive | Name of supportive determinand, that is needed for correct interpretation of some hazardous substances. | text(20) | |
Unit_DetSupport | Unit of measurement of hazardous substances supportive determinands. | text(20) | |
NumberOfSamples | Number of samples included in aggregated data. | long | |
Minimum | Minimum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Mean | Mean concentration value of aggregated data. | decimal | |
Maximum | Maximum disaggregated sample concentration value of the input data used for aggregation. | decimal | |
Median | Median concentration value of aggregated data. | decimal | |
StandardDeviation | Standard deviation of concentration values of aggregated data. | decimal | |
AggregatedBy | Subject(s) that aggregated the data. | text(20) | |
QA_MVissues | long | ||
QA_outlier | Quality assessment field - outlier flag. | Outlier code assigned to the record. Details are explained in the QA documentation. | long |
QA_station_issues | Quality assessment field - stations data quality issues flag | List of codes of station data issues detected in the record. Details are explained in the QA documentation. | text(100) |
QA_DDviolations | Quality assessment field - data definition errors | List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. | memo |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-lakes-7/waterbase-lakes-quality or scan the QR code.
PDF generated on 20 Apr 2024, 11:23 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others