Data
Waterbase - Water Quantity
Go to latest version
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
Permalinks
- Permalink to this version
- 1028e56bea8d41cfb11be818067b4912
- Permalink to latest version
- DAT-58-en
Older versions
Geographic coverage
Temporal coverage
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 04 Feb 2023, 10:53 AM
Document Actions
Share with others