Waterbase - Water Quantity

Data
Prod-ID: DAT-58-en
Created 21 Sep 2018 Published 25 Sep 2018 Last modified 09 Oct 2018
15 min read
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 (8 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 EEA. A list of monitoring site identifiers with selected attributes, reported through WFD and WISE Spatial data reporting, is added to dataset as spatial reference. Please refer to the metadata for additional information.

[+] Show table definition

T_WISE3_MonitoringData (3242922 records)

Streamflow and groundwater level observations, by monitoring site.

Element nameElement definitionValue definitions
monitoringSiteIdentifier Unique international identifier of the monitoring site in which the data were obtained.
monitoringSiteIdentifierScheme Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode'). eionetMonitoringSiteCode: EIONET identifier;
euMonitoringSiteCode: WFD identifier
phenomenonTimePeriod Reference time period of the reported result.
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_ReservoirData (26392 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.

Element nameElement definitionValue definitions
waterBodyIdentifier Unique international identifier of the water body in which the data were obtained.
waterBodyIdentifierScheme Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode'). eionetGroundwaterBodyCode: Groundwater body identifier is an EIONET identifier;
eionetSurfaceWaterBodyCode: Surface water body identifier is an EIONET identifier;
euGroundwaterBodyCode: Groundwater body identifier is a WFD identifier;
euSurfaceWaterBodyCode: Surface water body identifier is a WFD identifier
phenomenonTimePeriod Reference time period of the reported result.
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_RenewableFreshwaterResources (20945 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).

Element nameElement definitionValue definitions
spatialUnitIdentifier Unique international identifier of the spatial unit for which the data is being reported. see Vocabulary
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. see Vocabulary
phenomenonTimePeriod Reference time period of the reported result.
resultObservedVolume Measured water volume in million cubic metres (hm3).
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_AdditionalWaterResources (2248 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.

Element nameElement definitionValue definitions
spatialUnitIdentifier Unique international identifier of the spatial unit for which the data is being reported. see Vocabulary
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. see Vocabulary
phenomenonTimePeriod Reference time period of the reported result.
resultObservedVolume Measured water volume in million cubic metres (hm3).
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_WaterAbstraction (29358 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.

Element nameElement definitionValue definitions
spatialUnitIdentifier Unique international identifier of the spatial unit for which the data is being reported. see Vocabulary
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. see Vocabulary
phenomenonTimePeriod Reference time period of the reported result.
resultObservedVolume Measured water volume in million cubic metres (hm3).
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
stable: accepted and valid reported record, confirmed by the reporter as correct;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_WaterUse (5712 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).

Element nameElement definitionValue definitions
spatialUnitIdentifier Unique international identifier of the spatial unit for which the data is being reported. see Vocabulary
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. see Vocabulary
phenomenonTimePeriod Reference time period of the reported result.
resultObservedVolume Measured water volume in million cubic metres (hm3).
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
stable: accepted and valid reported record, confirmed by the reporter as correct;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

T_WISE3_WaterReturns (1934 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.

Element nameElement definitionValue definitions
spatialUnitIdentifier Unique international identifier of the spatial unit for which the data is being reported. see Vocabulary
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. see Vocabulary
phenomenonTimePeriod Reference time period of the reported result.
resultObservedVolume Measured water volume in million cubic metres (hm3).
resultObservationStatus Status of the observed value in terms of its availability, relevancy, correctness or specifics of its source category. A: Record is confirmed as correct;
L: Missing observed value, the data were not collected;
M: Missing observed value, the data can not exist;
N: Missing observed value, observed value is not relevant or not significant;
O: Missing observed value, no further information is available or record reported in the past should be deleted;
W: Missing observed value, data are included in another source category;
X: Reported value includes data from another source category (categories);
Y: The source category does not exactly match the standard definition
Remarks Remarks, comments or explanatory notes.
metadata_versionId Unique metadata identifier of version of the feature or record. Url that points either to the source of the reported data or to a page providing information on the data origin.
metadata_beginLifeSpanVersion Timestamp when feature or record was created. In case of reported data it's the release date and time of the respective CDR envelope.
metadata_statusCode Status of the feature or record regarding its registration. valid: accepted and valid reported feature or record;
stable: accepted and valid reported record, confirmed by the reporter as correct;
experimental: derived feature or record, e.g. legacy record converted to the new structure by EEA or records with updated spatial identifiers
metadata_observationStatus Status of the record regarding its reliability. A: Normal record;
U: Record with lower reliability;
V: Unvalidated record
metadata_statements Aditional information or statements regarding the reliability of the feature or record.
UID Unique identifier of the record in the EEA WISE_SOE database.

 

WISE3_MonitoringSite_DerivedData (13451 records)

List of monitoring site identifiers present in the WISE3 dataset tables. Contains selected information reported through WFD or WISE5 spatial data reporting.

Element nameElement definitionValue definitions
monitoringSiteIdentifier Unique international identifier of the monitoring site.
monitoringSiteIdentifierScheme Specification of whether the monitoring site is a WFD monitoring site ('euMonitoringSiteCode') or not ('eionetMonitoringSiteCode'). eionetMonitoringSiteCode: EIONET identifier;
euMonitoringSiteCode: WFD identifier
waterBodyIdentifier Unique international identifier of the water body being monitored.
waterBodyIdentifierScheme Specification of whether the water body is a WFD water body ('euGroundwaterBodyCode' or 'euSurfaceWaterBodyCode') or not ('eionetGroundwaterBodyCode' or 'eionetSurfaceWaterBodyCode'). eionetGroundwaterBodyCode: Groundwater body identifier is an EIONET identifier;
eionetSurfaceWaterBodyCode: Surface water body identifier is an EIONET identifier;
euGroundwaterBodyCode: Groundwater body identifier is a WFD identifier;
euSurfaceWaterBodyCode: Surface water body identifier is a WFD identifier
confidentialityStatus Information about the sensitivity and confidentiality status of the monitoring site location. F: Free for publication;
N: Not for publication
lon Longitude of the monitoring site. It is not provided for monitoring sites where publication is restricted.
lat Latitude of the monitoring site. It is not provided for monitoring sites where publication is restricted.
  • Waterbase-Water Quantity (CSV files)
    Download file
  • Waterbase-Water Quantity (SQLite file)
    Download file

Additional information

Dataset definition

Definition of the dataset

Metadata

 
Document Actions
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100