All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
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) |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-water-quantity-8/waterbase-water-quantity-microsoft-access-database-2-tables or scan the QR code.
PDF generated on 03 Dec 2024, 03:50 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others