Waterbase - Lakes (3 tables)

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 dataset contains data on nutrients and organic matter, proxy pressure data on the upstream catchments and physical characteristics of the WISE-SoE lake monitoring stations.

Data and maps

Menu

Category

European data

Table definition

Pressures (1454 records)

Proxy pressure data on the upstream catchments of WISE-SoE lake monitoring stations.

Field name	Field Definition	Note	Data type	Primary key
CountryCode	Abbreviation of EEA Member or Collaborating Country		text(2)	yes
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_RV_' and NationalStationID	text(60)	yes
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(60)
PopulationDensity	Population density of the upstream catchment of the river monitoring station		double
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 agricultural 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(20)
Remarks	Remarks, comments or explanatory notes (free text).		text(255)
QA_station_problem	Quality assurance field - stations data quality issues flag	List of codes of rules violated by record. Details are explained in the QA documentation	text(50)
QA_datatype_errors	Quality assurance field - data type and 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	text(150)

Quality (296820 records)

Data on nutrients and organic matter in water measured at WISE-SoE lake monitoring stations.

Field name	Field Definition	Note	Data type	Primary key
CountryCode	Abbreviation of EEA Member or Collaborating Country		text(2)	yes
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_RV_' and NationalStationID	text(60)	yes
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(60)
Year	Year of aggregation period in which samples were taken		integer	yes
AggregationPeriod	Period of aggregation	original values as provided by reporter	text(30)	yes
AggregationPeriod_unif	Period of aggregation unified	unified aggregation periods values allowing better analysis of time series	text(30)
PeriodLength	Number of months in aggregation period.		integer
Determinand	Name of nutrients, organic matter or general physico-chemical determinands.		text(50)	yes
Unit	Unit of measurement of nutrients or organic matter.		text(10)
CEN_ISO	CEN/ISO code of the methods.		text(150)
NumberOfSamples	Number of samples included in aggregated data.		integer
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.		double
LimitOfQuantification	The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%).		double
Mean	Mean concentration value of aggregated data.		double
Minimum	Minimum concentration value of aggregated data.		double
Maximum	Maximum concentration value of aggregated data.		double
Median	Median concentration value of aggregated data.		double
StandardDeviation	Standard deviation of concentration values of aggregated data.		double
SampleDepth	Depth at which sample taken in metres below water surface.		double
TotalDepth	Total depth of water column at the sampling location and at the time of sampling (meters)		double
NoOfSubsites	Number of subsites		integer
MethodOfAggregation	Method of Subsites Spatial Aggregation field is used only if the data are spatially aggregated (No. of subsites > 1), e.g. several subsites across lake depth profile are joined to one monitoring station.		text(255)
Remarks	Remarks, comments or explanatory notes.		memo
QA_LRviolations	Quality assurance field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	text(255)
QA_outlier	Quality assurance field - outlier flag.	List of codes of outlier rules violated by record. Details are explained in the QA documentation.	integer
QA_station_problem	Quality assurance field - stations data quality issues flag	List of codes of rules violated by record. Details are explained in the QA documentation	text(50)
QA_datatype_error	Quality assurance field - data type and 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	text(150)

Stations (3201 records)

Physical characteristics of the WISE-SoE lake monitoring stations.

Field name	Field Definition	Note	Data type	Primary key
CountryCode	Abbreviation of EEA Member or Collaborating Country		text(2)	yes
WaterbaseID	Internally produced, unique Waterbase identifier	combination of CountryCode, '_LK_' and NationalStationID	text(60)	yes
NationalStationID	Identifier of the lake monitoring station, unique at the national level.		text(60)
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(1)
WFD_EU_CD	Internally produced, unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station.		text(30)
LakeName	Name of lake.		text(150)
WaterCategory	Water Category, as defined in the codelist.	LK - Lake, RS - Reservoir	text(2)
WaterBodyID	National identification code of water body (if available) in which station is located		text(50)
WaterBodyName	Name of water body in which station is located		text(150)
CatchmentName	Name of major catchment or basin		text(150)
EUCD_NATRB	European Code for National River Basin District		text(10)
RBDcode	River Basin District Code		text(50)
RBDname	Name of the River Basin District.		text(150)
Region	National region in which water body is located		text(50)
Longitude	(X) International geographical co-ordinates in decimal degrees format		double
Latitude	(Y) International geographical co-ordinates in decimal degrees format		double
CatchmentArea	Catchment area upstream of the station, in kilometres squared		double
Altitude	Altitude of station in metres above sea level.		double
ReferenceStation	Reference station type, 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)
RepresentativeStation	Representative station type, reflecting the general quality of lakes		text(1)
LargestStation	Largest, most important station type, including the nationally most important or well known lakes.		text(1)
ImpactStation	Impact station type, located within the zone where initial mixing of discharges takes place with receiving waters.		text(1)
Geology	The dominating geology in the catchment, given according to the WFD Annex 2 categories	Siliceous, calcareous or organic (peat).	text(20)
WaterColourAverage	Long-term average concentration of water colour, expressing the concentration of humic substances at the station.		double
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(10)
AlkalinityAverage	Long-term average of alkalinity of water at the station		double
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(10)
HMWB	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		double
MeanDepth	Mean depth of the lake in metres.		double
MaximumDepth	Maximum depth of the lake in metres.		double
ResidenceTime	Average lake residence time in years		double
Volume	Volume of water in lake in million cubic metres.		double
LakeReservoir	Reservoir or natural lake.	Y - reservoir, N - natural lake	text(1)
SamplingDepth	Depth at which sample taken in metres below the lake surface.		text(150)
Remarks	Remarks, comments or explanatory notes.		text(255)
QA_station_problem	Quality assurance field - stations data quality issues flag	List of codes of rules violated by record. Details are explained in the QA documentation	text(50)
QA_datatype_errors	Quality assurance field - data type and 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	text(150)