Data

Waterbase - Water Quantity

Data

Prod-ID: DAT-58-en

Created 13 Nov 2009 Published 11 Jun 2010 Last modified 15 Dec 2022

5 min read

This is an old version, kept for reference only.

Go to latest version

Topics: Water and marine environment

This page was archived on 25 Aug 2017 with reason: A new version has been 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, and on the quantity of Europe's water resources

Data and maps

Menu

European data

Waterbase - Water Quantity (1 table)

Dataset is a flat table of all reported time series related to Water Quantity.

[+] Show table definition

Water quantity - flat table (114616 records)

Field name	Field Definition	Note	Data type
CountryCode	Abbreviation of EEA Member or Collaborating Country	ISO3166 two digit code	text(2)
gentity_name	Name of the geographical entity to which the data is directly related. If it is a station this field gives the name of the station. If it is a region it gives the name of the region.		text(200)
gentity_code	Code of the geographical entity to which the data is directly related. If it is a station this field gives the code of the station. If it is a region it gives the code of the region. For most regional categories e.g. Country, RBD, NUTS the codes are defined on the European level. For stations the codes are given by the member states.		text(50)
longitude	In case the gentity is a station (point data), the longitude of its location. Otherwise or if not specified it is left null.	(X) International geographical co-ordinates in decimal degrees format. Coordinates that were reported in non-specified projected coordinates system were removed.	double
latitude	In case the gentity is a station (point data), the latitude of its location. Otherwise or if not specified it is left null.	(Y) International geographical co-ordinates in decimal degrees format. Coordinates that were reported in non-specified projected coordinates system were removed.	double
variable	The name of the measured variable		text(200)
unit	The unit of the measured variable		text(10)
timestep	The time step of the time series	annual, seasonal, monthly, daily (only for steamflow)	text(10)
year	The reporting year		integer
index	The index of the time series value within the given year.	Annual time series have always index=1. The range of other time series are as follows: - seasonal: 1(wet season) – 2 (dry season) - monthly: 1-12 (starting with January i.e. calendar year, not hydrological year) - daily: 1-365 or 366 depending of the year, starting with January 1st.	integer
val	A real number giving the measured value of the variable		double

Waterbase-Water Quantity (Microsoft Access database file) (ZIP archive)
729.28 KB Download file
Waterbase-Water quantity (CSV file) (ZIP archive)
530.91 KB Download file

Additional information

Tables metadata

Definition and field description of the data table.

Tables metadata (XLS file) (Microsoft Excel spreadsheet)
26.00 KB Download file
Tables metadata (CSV file) (Plain Text)
2.02 KB Download file

Country codes and abbreviations (13 records)

Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Water Quantity version 5

Country codes and abbreviations (13 records) (Plain Text)
221 Bytes Download file

Metadata

Reporting obligations (ROD)

WISE SoE - Water Quantity (WISE-3)

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Disclaimer:

Data in Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are 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:

Central to the Water Quantity database concept is the gentity. A gentity is short for geographical entity and can be a) a point, typically a station e.g. measuring precipitation or streamflow or b) an area e.g. a River Basin District or a Country. Other possible types of geographical entities such as lines or networks do not apply to the water quantity database.

All data stored in the database are directly or indirectly related with one gentity. Most of the reported water quantity data are stored in form of time series, which in return are related to gentities. The published dataset is a flat file of all reported time series related to Water Quantity. It is produced from the Water Quantity database by joining data from individual database tables.

Data sources

The European Topic Centre on Water. Version 5, date of delivery (date sent to the Data Service): 07/06/2010

Owners:

European Environment Agency (EEA)

Processors:

European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water selects validated monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. The added value of Waterbase is that data collected through the Eionet-Water process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEA's indicator-based factsheets.

Water quantity database is published again, first time after 3 years. In 2007 the old dataset structure was abandoned and development of new structure and new system for collecting data have started. First data collection test was run in 2008. In 2009 a new reporting system was established and used by country reporters in another data collection test which has provided data for this dataset.