Hydro-meteorological database for watersheds across the CIS

The presented database is a set of hydrological, meteorological, environmental and geometric values for Russia Federation for the period from 2008 to 2020.

Database consist of next items:

Point geometry for hydrological observation stations from Roshydromet network across Russia

Geometry of the catchment for correspond observation station point

Daily hydrological values

Water level

In relative representation (sm)

In meters of Baltic system (m)

Water discharge

as an observed value (qms/s)

as a layer (mm/day)

Daily meteorological values

Maximum and minimum daily temperatures (°C) from ERA5 and ERA5-Land

Total precipitation (mm/day) from ERA5, ERA5-Land, IMERG v06, GPCP v3.2 and MSWEP

Different kind of evaporation (mm/day) corresponded to each variable calculated in GLEAM model

Set of hydro-environmental characteristics derived from HydroATLAS database

Each variable derived from the grid data was calculated for each watershed, taking into account the intersection weights of the watershed contour geometry and grid cells.

Coordinates of hydrological stations were obtained from resource of Federal Agency for Water Resources of Russia Federation—AIS GMVO

To calculate the contours of the catchment areas, a script was developed that builds the contours in accordance with the rasters of flow directions from MERIT Hydro. To assess the quality of the contour construction, the obtained value of the catchment area was compared with the archival value from the corresponded table from AIS GMVO. The average error in determining the area for 2080 catchments is approximately 2%

To derive values for different hydro-environmental values from HydroATLAS were developed approach which calculate aggregated values for catchment, leaning on type of variable: qualitative (Land cover classes, Lithological classes etc.) Or quantitive (Air temperature, Snow cover extent etc.). Every quantitive variable were calculated as mode value for intersected sub-basins and target catchment, e.g. most popular attribute from sub-basins will describe whole catchment which are they relating. Quantitative values were calculated as mean value of attribute from each sub-basin. More detail could be found in publication.

Files are distributed as follows:

Each file has some connection with the unique identifier of the hydrological observation post. Files in netcdf format (hydrological and meteorological series) are named in response to identifier.

Every file which describe geometry (point, polygon, static attributes) has and column named gauge_id with same correspondence.

attributes/static_data.csv – results from HydroATLAS aggregation

geometry/russia_gauges.gpkg – coordinates of hydrological observation stations

gauge_id
name_ru
name_en
geometry

0
49001
р. Ковда – пос. Софпорог
r.Kovda - pos. Sofporog
POINT (31.41892 65.79876)

1
49014
р. Корпи-Йоки – пос. Пяозерский
r.Korpi-Joki - pos. Pjaozerskij
POINT (31.05794 65.77917)

2
49017
р. Тумча – пос. Алакуртти
r.Tumcha - pos. Alakurtti
POINT (30.33082 66.95957)

geometry/russia_ws.gpkg – catchments polygon for each hydrological observation stations             

gauge_id
name_ru
name_en
new_area
ais_dif
geometry

0
9002
р. Енисей – г. Кызыл
r.Enisej - g.Kyzyl
115263.989
0.230
POLYGON ((96.87792 53.72792, 96.87792 53.72708...

1
9022
р. Енисей – пос. Никитино
r.Enisej - pos. Nikitino
184499.118
1.373
POLYGON ((96.87792 53.72708, 96.88042 53.72708...

2
9053
р. Енисей – пос. Базаиха
r.Enisej - pos.Bazaiha
302690.417
0.897
POLYGON ((92.38292 56.11042, 92.38292 56.10958...

Column ais_diff is corresponded to % error in area definition

nc_all_q

netcdf files for hydrological observation stations which has no missing values on discharge for 2008-2020 period

nc_all_h

netcdf files for hydrological observation stations which has no missing values on level for 2008-2020 period

nc_all_q_h

netcdf files for hydrological observation stations which has no missing values on discharge and level for 2008-2020 period

nc_concat

data for all available geometry provided in dataset

More details on processing scripts which were used for development of this database can be found in folder of GitHub repository where I store results for my PhD dissertation

05.04.2023 – Significant data changes. Removed catchments and related files that have more than ±15% absolute error in calculated area relative to AIS GMVO information. Now these are data for 1886 catchments across the Russia.

17.05.2023 – Significant data changes. Major review of parsing algorithm for AIS GMVO data. Fixed the way of how 0.0xx values were read. Use previous versions with caution.

11.10.2023 – Significant data changes. Added 278 catchments for CIS region from GRDC resource. Calculate meteorological and environmental attributes for each catchment. New folder /nc_all_q_h with no missing observations on discharge and level. Now these are data for 2164 catchments across CIS.