Waterbase - Water Quantity
Data
Prod-ID:
DAT-58-en
expired
Created 30 Sep 2016
Published 11 Oct 2016
Last modified 09 Oct 2018
11
min read
This is an old version, kept for reference only.
Go to latest version
Go to latest version
Topics:
Water and marine environment
,
This page was archived on 25 Sep 2018 with reason:
Other
(New version data-and-maps/data/waterbase-water-quantity-10 was published)
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)
-
Temporal coverage:
- 1901-2014
-
Last upload:
- 11 Oct 2016
-
Geographic coverage:
-
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 , freshwater , wise , water scarcity , water management , groundwater , reservoirs , water exploitation index , 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 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
The original data is available in the EIONET Central Data Repository.
-
Owners:
- European Environment Agency (EEA)
-
Processors:
- European Topic Centre on Inland, Coastal and Marine waters (ICM)
Permalinks
- Permalink to this version
- 1028e56bea8d41cfb11be818067b4912
- Permalink to latest version
- DAT-58-en
Older versions
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-water-quantity-9 or scan the QR code.
PDF generated on 19 Sep 2019, 05:39 PM
Document Actions
Share with others