Waterbase - Water Quantity

Data

Prod-ID: DAT-58-en

Created 30 Sep 2016 Published 11 Oct 2016 Last modified 20 Apr 2017

11 min read

Topics: Water ,

Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, on the quantity of Europe's water resources, and on the emissions to surface waters from point and diffuse sources of pollution.

European data

Waterbase - Water Quantity (7 tables)

The dataset contains time series of water quantity data, reported by EEA member countries and cooperating countries. The data has been compiled and processed by ETC-ICM and EEA. Please refer to the metadata for additional information.

[+] Show table definition

Monitoring Data (WISE3_MonitoringData, 2908930 records)

Streamflow and groundwater level observations, by monitoring site.

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
monitoringSiteIdentifier	Unique international identifier of the monitoring site in which the data were obtained.	nvarchar (42)
monitoringSiteIdentifierScheme	Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode').	nvarchar (255)
observedProperty	Unique code of the parameter being reported, as defined in the code list.	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedValue	Mean value of the observed parameter.	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Reservoir Data (WISE3_ReservoirData, 12634 records)

Mean inflow volume, mean outflow volume and mean stock volume, during each time period, for artificial or natural reservoirs, reported by water body and expressed in million cubic metre.

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
waterBodyIdentifier	Unique international identifier of the water body in which the data were obtained.	nvarchar (42)
waterBodyIdentifierScheme	Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode').	nvarchar (255)
observedProperty	Unique code of the parameter being reported, as defined in the code list.	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedValue	Volume, in million cubic metre.	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Renewable Freshwater Resources (WISE3_RenewableFreshwaterResources, 12632 records)

The data in the RenewableFreshwaterResources table provides an overview of renewable freshwater resources available on the spatial unit (SU, RBD or country) and of their different flows (internal flow and actual external inflow). By definition, the concept of renewable resources excludes non-renewable resources available from the potential use of water reserves (essentially groundwater).

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
spatialUnitIdentifier	Unique international identifier of the spatial unit for which the data is being reported.	nvarchar (255)
spatialUnitIdentifierScheme	Specification of whether the spatial unit is a country ('countryCode'), a Water Framework Directive river basin district ('euRBDCode') or a Water Framework Directive sub-unit ('euSubUnitCode'). For data providers that do not report under the WFD, spatial units equivalent to river basin districts ('eionetRBDCode') or sub-units ('eionetSubUnitCode') should be used.	nvarchar (255)
observedProperty	Renewable freshwater resources parameter	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedVolume	Measured water volume in million cubic metres (hm3).	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Additional Water Resources (WISE3_AdditionalWaterResources, 1954 records)

The data in the AdditionalWaterResources table provides an overview of additional water resources available on the spatial unit (SU, RBD or country) from non-freshwater sources (seawater and transitional water, such as brackish water), desalinated water and reused water. In addition, water imports and exports are requested on this category.

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
spatialUnitIdentifier	Unique international identifier of the spatial unit for which the data is being reported.	nvarchar (255)
spatialUnitIdentifierScheme	Specification of whether the spatial unit is a country ('countryCode'), a Water Framework Directive river basin district ('euRBDCode') or a Water Framework Directive sub-unit ('euSubUnitCode'). For data providers that do not report under the WFD, spatial units equivalent to river basin districts ('eionetRBDCode') or sub-units ('eionetSubUnitCode') should be used.	nvarchar (255)
observedProperty	Additional water resources parameter	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedVolume	Measured water volume in million cubic metres (hm3).	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Water Abstraction (WISE3_WaterAbstraction, 20842 records)

The data in the WaterAbstraction table provides an overview of the volume of water abstraction on the spatial unit (SU, RBD or country) from freshwater resources (surface and groundwater) for different sectors.

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
spatialUnitIdentifier	Unique international identifier of the spatial unit for which the data is being reported.	nvarchar (255)
spatialUnitIdentifierScheme	Specification of whether the spatial unit is a country ('countryCode'), a Water Framework Directive river basin district ('euRBDCode') or a Water Framework Directive sub-unit ('euSubUnitCode'). For data providers that do not report under the WFD, spatial units equivalent to river basin districts ('eionetRBDCode') or sub-units ('eionetSubUnitCode') should be used.	nvarchar (255)
observedProperty	Water abstraction parameter	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedVolume	Measured water volume in million cubic metres (hm3).	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Water Use (WISE3_WaterUse, 4011 records)

The data in the WaterUse table provides an overview of the volume of water used on the spatial unit (SU, RBD or country) for different sectors of economic activity or purposes. Contains information about water use (spatial information, water use by sector).

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
spatialUnitIdentifier	Unique international identifier of the spatial unit for which the data is being reported.	nvarchar (255)
spatialUnitIdentifierScheme	Specification of whether the spatial unit is a country ('countryCode'), a Water Framework Directive river basin district ('euRBDCode') or a Water Framework Directive sub-unit ('euSubUnitCode'). For data providers that do not report under the WFD, spatial units equivalent to river basin districts ('eionetRBDCode') or sub-units ('eionetSubUnitCode') should be used.	nvarchar (255)
observedProperty	Water use parameter	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedVolume	Measured water volume in million cubic metres (hm3).	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Water Returns (WISE3_WaterReturns, 1321 records)

The data in the WaterReturns table provides an overview of the volume of water returns on the spatial unit (SU, RBD or country), disaggregated in treated and non-treated effluents and leakage losses.

FieldName	Definition	DataType
UID	Unique identifier of the record in the EEA WISE SOE database.	int
versionId	Reported data: url to the data source; Derived data: url to a summary information describing the origin of the data.	nvarchar (255)
beginLifeSpanVersion	Reported data: the delivery date of the source data to the Reportnet. Derived data: the entry date to the EEA WISE SOE database.	datetime
spatialUnitIdentifier	Unique international identifier of the spatial unit for which the data is being reported.	nvarchar (255)
spatialUnitIdentifierScheme	Specification of whether the spatial unit is a country ('countryCode'), a Water Framework Directive river basin district ('euRBDCode') or a Water Framework Directive sub-unit ('euSubUnitCode'). For data providers that do not report under the WFD, spatial units equivalent to river basin districts ('eionetRBDCode') or sub-units ('eionetSubUnitCode') should be used.	nvarchar (255)
observedProperty	Water return parameter	nvarchar (255)
phenomenonTimePeriod	Reference time period of the reported result.	nvarchar (16)
resultObservedVolume	Measured water volume in million cubic metres (hm3).	float
resultObservationStatus	Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category.	nvarchar (255)
Remarks	Remarks, comments or explanatory notes.	nvarchar (max)
waterbaseObservationStatus	Status flag of the observation. The most common are 'A' - Normal value, 'V' - Unvalidated value, 'U' - Low reliability	nvarchar (100)
waterbaseRemarks	Explanation of the 'U' status, if indicated in the waterbaseObservationStatus field, and any additional information entered during the data processing.	nvarchar (max)

Waterbase-Water Quantity (Microsoft Access database file) (ZIP archive)
33.99 MB Download file
Waterbase-Water Quantity (CSV files) (ZIP archive)
24.92 MB Download file
Waterbase-Water Quantity (SQLite file) (ZIP archive)
37.31 MB Download file

Additional information

Table definitions

Definition and field description of the data tables.

Table definitions (XLSX file) (Microsoft Excel (Office 2010))
7.37 KB Download file
Table definitions (CSV file) (ZIP archive)
6.55 KB Download file

Code lists

Lists and description of codes of fields present in the water quantity data tables

Code lists (XLSX file) (Microsoft Excel (Office 2010))
24.84 KB Download file
Code lists (CSV file) (text/comma-separated-values)
71.69 KB Download file

Metadata

Reporting obligations (ROD)

WISE SoE - Water Quantity (WISE-3)

Temporal coverage:

1901-2014

Last upload:

11 Oct 2016

Geographic coverage:

Austria , Belgium , Bosnia and Herzegovina , Bulgaria , Croatia , Cyprus , Czech Republic , Denmark , Estonia , Finland , France , Greece , Hungary , Iceland , Ireland , Kosovo , Latvia , Liechtenstein , Lithuania , Macedonia (FYR) , Montenegro , Netherlands , Poland , Portugal , Romania , Serbia , Slovakia , Slovenia , Spain , Sweden , Switzerland , Turkey , United Kingdom

Tags:

geospatial data , surface water , urban waste water , freshwater abstraction , waste water , water resource management , water resources , wise state of the environment(soe) , point data , rain water , water quantity , groundwater level , water use , water , water information system for europe , waterbase , streamflow , water exploitation index , wise , water scarcity , water management , groundwater , reservoirs , freshwater , renewable freshwater resources

Rights:

By downloading Waterbase, you are accepting and agreeing to the EEA data policy (http://www.eea.europa.eu/legal/eea-data-policy).

Disclaimer:

Waterbase data is collected and published to produce comparable indicators of pressures, state and impacts on European waters. Waterbase is intended for a European-wide scale of analysis. It is not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.

Methodology:

This Waterbase contains data on freshwater resources availability, water abstraction and water use at national or regional scale.

The data was delivered between 2002 and 2016 by EEA member countries and cooperating countries, in the scope of the current WISE SoE - Water Quantity (WISE-3) reporting obligation and of the former State & Quantity of Water Resources (EWN-4) reporting obligation.

The national data deliveries are compiled by ETC/ICM into a European-wide Waterbase. The data is used for EEA core set indicators that assess the state, trends in water related pressures and monitor the progress of European policy objectives.

Data sources