Environmental Data Platform
The EO4MULTIHAZARDS Events Database provides the scientific community with reliable data and promotes comprehensive research efforts on multi-hazard events. The collected datasets come from various sources and are updated automatically or manually when new data becomes available. The following is a list of data sources: - EMDAT portal provides a REST-API for authorized users to download data. - EFFIS portal provides a standard and open Web Feature Service (WFS) for downloading datasets. - British Geological Survey collects events datasets in United Kingdom and uploads new data to the database as it becomes available. Additionally the DB contains a list of Earth Observation datasets, useful to study natural hazard events. The collected information is available for visualization, but the full dataset is not downloadable due to license restrictions on the input data. Events are accessible via the web interface without restriction, and query results are available for download. Additional information is available on the Web Interface page. For this project, we harmonized the input datasets into a common format to easily compare them. The database was created in the project EO4MULTIHAZARDS, funded by the The European Space Agency’s (ESA).
natural hazard, risk, cct, Human health and safety, Natural risk zones
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 |
2000-01-01T00:00:00Z 
Text, table
Environment
Go to full metadata#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
##########################| 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 |