next
previous
items

Waterbase - Water Quantity (1 table)

Data Table
This page was archived on 25 Aug 2017 with reason: A new version has been published
Dataset is a flat table of all reported time series related to Water Quantity.
Category
European data
Table definition

Water quantity - flat table (114616 records)

Field name Field Definition Note Data type Primary key
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
Files

Permalinks

Document Actions