Environmental Data Platform

ADO - Discharge hydrological datasets

Go to full metadata Linkset {json} Linked data {json}

Daily time-series of discharge stations present within the Alpine space, obtained from different providers. Is made up of four columns: id station, date, discharge and the data quality information given by its different providers. The database contains observational daily discharge data deriving from the first measurement (differs for each region) to the present, with more than 1400 stations. These data were collected from multiple data providers within the ADO study region, covering the countries Austria, France, Germany, Italy, Slovenia and Switzerland. The spanned period is 1869-2021. The missing dates were added in order to have continuous time-series.

hydrology, water lever, discharge, database, ground station, cct, Environmental monitoring facilities, Hydrography

Restricted data access to project's partners

Eurac Research - Center for Sensing Solutions
supportcss@eurac.edu
Viale Druso, 1 / Drususallee 1, eurac research, Bolzano, Autonomous Province of Bolzano, 39100, Italy


Text, table

Inland waters

Snippet code
Copy to clipboard 
#To set up the connection, the following two packages are required.

library(DBI)
library(RPostgres)

#Using the tidyverse in R, we can circumvent the direct usage of SQL language, and can use the more user-friendly dplyr syntax. For this we need these packages.

library(dplyr)
library(dbplyr)

#For data wrangling and visualization we will use these packages.

library(sf)
library(lubridate)
library(ggplot2)
library(mapview)

#Set up the connection
#The following sets up the connection to the SQL database. This is currently only possible within the ScientificNet. The parameters are copied from the documentation.

conn <- dbConnect(Postgres(), 
                  dbname = "climate_data", 
                  host = "10.7.18.68", 
                  port = 5432, 
                  user = "climate_user",
                  password = "meteo_data")
##################################
#List the available tables.

dbListTables(conn)

#The daily values are stored in the table stations_data.
tbl(conn, "stations_data")

#The climatologies (averages for the period 1981-2010) values are stored in the table climatologies.
tbl(conn, "climatologies")

#And finally the metadata with the station locations and more info on the processing in metadata.
tbl(conn, "metadata")

##########################
#Additional examples for create map and plots are available at: http://edp-doc.eurac.edu/cdb_doc/notebooks/Access-CDB-R-ubuntu.html
##########################
Related docs
Name Description Link Date published Category
Connection to PostgreSQL database Necessary steps to connect to the PostgreSQL DB. Example with the Cimate Database. Available only inside ScientificNet Link June 10, 2021 PostgreSQL
Climatic and Hydrological timeseries This page contains description and documentastion of Climate DB, ADO and 4DMED projects Link April 14, 2023 PostgreSQL