Waterbase - Water Quantity (9 tables)

Data Table

This is an old version, kept for reference only.

Go to latest version

This page was archived on 11 Oct 2016 with reason: Other (New version data-and-maps/data/waterbase-water-quantity-9/waterbase-water-quantity-microsoft-access-database-2-tables was published)

Dataset contains all time series related to water quantity data, reported by member and collaborating countries. Reported data have been assessed and processed by the ETC-ICM and the EEA. ***WARNING:*** Records, where errors and other quality issues and inconsistencies have been detected, have been removed from the dataset only in certain cases. The other "problematic" records are left in. Data tables contain special QA fields which are used to flag the particular quality issues detected in the individual records. The QA fields and flag codes are described in the QA documentation.

Data and maps

Menu

Category

European data

Table definition

Geographical Entities of Water Quantity monitoring (Waterbase_WQ_v9_gentities, 11320 records)

Geographical entities of the WISE-SoE Water quantity monitoring. They may be related to areas such as River Basin Districts (RBD), Sub-Units (SU) or Nomenclature of Territorial Units for Statistics (NUTS). Fields RBDcode, SubUnitCode and NUTS refer to the area in which the geographical entity is located or to which it belongs.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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)
GEntityName	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)
GEntityType	Type of the geographical entity to which the data is directly related.	C - Country; RBD - River Basin District; NUTS - Level 1, 2 or 3 of Nomenclature of Territorial Units for Statistics; SU - Sub-Unit; W - Well; R - Reservoir; RG - Rain Gauge Station; SF - Stream flow station; LI - Large Item (City, Industry, Agricultural Unit)	text(4)
RBDcode	River Basin District Code		text(50)
SubUnitCode	National identification code of Sub-Unit.		text(50)
NUTS	The lowest possible level code of the Nomenclature of Territorial Units for Statistics (NUTS1, NUTS2 or NUTS3) in which the geographical entity is located.		text(5)

Characteristics of Rain Gauge Stations (Waterbase_WQ_v9_rain_gauge_stations, 3260 records)

Basic information on rain gauge stations used in the WISE-SoE Water quantity monitoring. It is assumed that these stations were used to calculate the areal precipitation requested in the water balance of this area (see table WQ-Area).

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
Altitude	Altitude of station in metres above sea level.		single
RiverBasinName	Name of river basin where the station is located.		text(255)
RiverBasinArea	Area (in km2) of river basin where the station is located.		single
SubcatchmentName	Name of sub-catchment where the station is located.		text(255)
SubcatchmentArea	Area (in km2) of sub-catchment where the station is located.		single
WFDstation	Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station.		text(3)
EIONETstation	Specification yes / no, whether the monitoring station was reported as EIONET station.		text(3)
DataPeriod_from	Starting year of available data		long
DataPeriod_to	Ending year of available data		long
TimeScale	Smallest possible scale of available data that can be provided upon request.		text(8)
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)

Characteristics of Reservoirs (Waterbase_WQ_v9_reservoirs, 228 records)

Basic information on reservoirs used in the WISE-SoE Water quantity monitoring. The total volume of water entering in (Inflow) and released from (Outflow) a natural or manmade reservoir in various temporal scales may be stored in table WQ-TimeSeries.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
ReservoirType	Reservoir type	Natural, Man-made	text(8)
StorageCapacity	Storage capacity of the reservoir in hm3.		single
LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA).		long
LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA).		long
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)
Altitude	Altitude of the reservoir		long

Characteristics of Stream Flow Stations (Waterbase_WQ_v9_stream_flow_stations, 2074 records)

Basic information on stream flow stations used in the WISE-SoE Water quantity monitoring. Measured stream flow data on selected gauging stations within the RBD at daily time scale may be also stored in table WQ-TimeSeries. This table stores metadata of stream flow measurements and supplementary statistics such as mean, min, max, monthly values plus the dates of min and max observations.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
Altitude	Altitude of station in metres above sea level.		single
RiverName	National name of river.		text(150)
RiverBasinName	Name of river basin where the station is located.		text(255)
RiverBasinArea	Area (in km2) of river basin where the station is located.		single
SubcatchmentName	Name of sub-catchment where the station is located.		text(255)
SubcatchmentArea	Area (in km2) of sub-catchment where the station is located.		single
WFDstation	Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station.		text(3)
EIONETstation	Specification yes / no, whether the monitoring station was reported as EIONET station.		text(3)
DataPeriod_from	Starting year of available data		long
DataPeriod_to	Ending year of available data		long
MinDischarge	Lowest recorded stream flow in m3/s.		single
MinDischarge_date	Date of the lowest recorded stream flow in format YYYY-MM-DD.		text(10)
MaxDischarge	Highest recorded stream flow in m3/s.		single
MaxDischarge_date	Date of the highest recorded stream flow in format YYYY-MM-DD.		text(10)
LTAA	Long Term Annual Average in m3/s.		single
LTA_month1	Long term average stream flow of month 1 (January) in m3/s.		single
LTA_month2	Long term average stream flow of month 2 (February) in m3/s.		single
LTA_month3	Long term average stream flow of month 3 (March) in m3/s.		single
LTA_month4	Long term average stream flow of month 4 (April) in m3/s.		single
LTA_month5	Long term average stream flow of month 5 (May) in m3/s.		single
LTA_month6	Long term average stream flow of month 6 (June) in m3/s.		single
LTA_month7	Long term average stream flow of month 7 (July) in m3/s.		single
LTA_month8	Long term average stream flow of month 8 (August) in m3/s.		single
LTA_month9	Long term average stream flow of month 9 (September) in m3/s.		single
LTA_month10	Long term average stream flow of month 10 (October) in m3/s.		single
LTA_month11	Long term average stream flow of month 11 (November) in m3/s.		single
LTA_month12	Long term average stream flow of month 12 (December) in m3/s.		single
LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA).		long
LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA).		long
QA_LRviolations	Quality assessment field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	long
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)

Characteristics of Wells (Waterbase_WQ_v9_wells, 3205 records)

Basic information on wells used in the WISE-SoE Water quantity monitoring (groundwater level measuring). Groundwater level observations from wells located within the reporting unit (RBD or other) in various temporal scales may be stored in table WQ-TimeSeries.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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	International geographical longitude (x) co-ordinate in decimal degrees format.		decimal
Latitude	International geographical latitude (x) co-ordinate in decimal degrees format.		decimal
Altitude	Altitude of station in metres above sea level.		single
GWBname	Name of the groundwater body		text(255)
GWBoutsideRB	Flag identifying whether or not the groundwater body is expanding outside the river basin.		text(1)
GWBoutsideRBD	Flag identifying whether or not the groundwater body is expanding outside the river basin district.		text(1)
MinLevel_month	Month in which the minimum groundwater level is expected.		long
MaxLevel_month	Month in which the maximummum groundwater level is expected.		long
LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA).		long
LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA).		long
LTAA	Long Term Annual Average in m.		single
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)

Characteristics of Large Items (Waterbase_WQ_v9_large_items, 38 records)

Basic information on large items - major water users (big cities, large industries, large agricultural units) - used in the WISE-SoE Water quantity monitoring (describing the volume of freshwater used per item). Actual measurements of water used in cities, industries, agricultural units in various temporal scales may be stored in table WQ-TimeSeries.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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)
LIcategory	Category of the large item.		text(20)
LIclass	Class of the large item.	1: The item belongs to Class 1, the class grouping the largest abstraction sites, together representing 50 to 70% of the activity (as a rule of thumb for domestic use, class 1 should be made of those agglomerations that together host in the range of 50% - 70% of total population per district); 2: The item belongs to Class 2, the intermediate class; 3: The item belongs to Class 3, the class of smallest abstraction sites, representing 60 to 80% in number (or more) and in the range of 5 to 15% in cumulated activity.	long

Characteristics of Areas (Waterbase_WQ_v9_areas, 141 records)

Basic information on areas - country, river basin district, sub-unit, NUTS - used in the WISE-SoE Water quantity monitoring (reporting measurements i.e. water use, water balance or water abstraction). Actual measurements are stored in table WQ-TimeSeries.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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)
AreaType	Type of the area.	C - Country; NUTS - Level 1, 2 or 3 of Nomenclature of Territorial Units for Statistics; RBD - River basin District; SU - Sub-unit	text(4)
WU_LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA) for water use variables.		long
WU_LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA) for water use variables.		long
WB_LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA) for water balance variables.		long
WB_LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA) for water balance variables.		long
WB_Returned_Unit	The hydrological unit to which the "returned after use" effluent is discharged (if it is different than the one where the water was originally abstracted).		text(255)
WB_Reused_Unit	The hydrological unit to which the reused water is made available (if it is different than the one where the water was originally abstracted).		text(255)
WB_Artif_GW_Origin	Information on where artificial groundwater recharge originates from.		text(20)
WA_LTAA_year_from	Starting year of reference period used to calculate long term annual average (LTAA) for water abstraction variables.		long
WA_LTAA_year_to	Ending year of reference period used to calculate long term annual average (LTAA) for water abstraction variables.		long
QA_ALRviolations	Quality assessment field - list of areal logical rules violations.	List of codes of areal logical rules violated by Water quantity record. Details are explained in the QA documentation.	memo
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of station data issues detected in the record. Details are explained in the QA documentation.	text(100)

Water Abstraction Sources (Waterbase_WQ_v9_water_abstraction_sources, 39 records)

Table contains list of non-freshwater abstraction sources per sector and area.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	Code of geographical entity that uniquely identifies the area (see WQ-Area table).		text(50)
SectorCode	Code of sector for which water is abstracted.		text(50)
WaterSource	The main water source type for the specific sector and area (region).		text(20)

Water Quantity Time Series (Waterbase_WQ_v9_TimeSeries, 2316217 records)

Table contains time series data for all measured variables of the WISE-SoE Water quantity monitoring. Time series are related to exactly one geographical entity, which is a station, a reservoir, another point entity or an area (region) e.g. a river basin district.

FieldName	Definition	Note	DataType
RecordID	Unique record identifier		long
RecordReported	Date when the records was reported by the data provider		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country from which territory the data come from.	ISO 3166-1-alpha-2 code elements	text(2)
GEntityCode	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)
Year	The reporting year.		long
TimeStep	A fixed time step for the time series.		text(8)
Index	The index of the time series value within the given reporting 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).	long
VariableCode	The name or code of the measured variable.		text(100)
Unit	The unit of the measurement for the time series.		text(4)
Value	The measured value of the variable.		single
QA_LRviolations	Quality assessment field - list of logical rules violations.	List of codes of logical rules violated by record. Details are explained in the QA documentation.	text(150)
QA_ALRviolations	Quality assessment field - list of areal logical rules violations.	List of codes of areal logical rules violated by Water quantity record. Details are explained in the QA documentation.	memo
QA_outlier	Quality assessment field - outlier flag.	Outlier code assigned to the record. Details are explained in the QA documentation.	text(255)