Database Behind The Citiwatts Toolbox
Introduction
The database built for citiwatts is a spatial Data Warehouse made available to the platform for visualization and computation purposes.
There are different kinds of data:
- raster datasets (at hectare level)
- vector datasets (NUTS/LAU regions, points of interest, ...)
- non-spatial datasets (mostly NUTS/LAU related and linked to existing vector layers)
The datasets can be accessed via a geospatial server (GeoServer) which provides different services (WMS/WFS/...) that allows anyone to display, include or use those datasets.
The datasets can be found on the Tuleap repository
Query
Please note that aggregations when selecting NUTS or LAU regions are pre-computed and therefore, faster than aggregations of hectare selections, which are computed on-the-fly.
Indicators
Depending on the layers, various statistical parameters such as minimum value, maximum value and mean value are among the indicators. An explanation of defining indicators for the layers integrated into the Hotmaps database can be found here.
Technologies
The technologies used for the database are:
PostgreSQL version 9.6 PostGIS version 2.3 GeoServer version 2.11.2
References
Simon Pezzutto, Stefano Zambotti, Silvia Croce, Pietro Zambelli, Giulia Garegnani, Chiara Scaramuzzino, Ramón Pascual Pascuas, Alyona Zubaryeva, Franziska Haas, Dagmar Exner (EURAC), Andreas Mueller (e-think), Michael Hartner (TUW), Tobias Fleiter, Anna-Lena Klingler, Matthias Kühnbach, Pia Manz, Simon Marwitz, Matthias Rehfeldt, Jan Steinbach, Eftim Popovski (Fraunhofer ISI) Reviewed by Lukas Kranzl, Sara Fritz (TUW) Hotmaps Project, D2.3 WP2 Report – Open Data Set for the EU28, 2018 www.hotmaps-project.eu
How To Cite
The citiwatts and Hotmaps teams, in citiwatts wiki, Database behind the citiwatts toolbox (2025)
Authors And Reviewers
Written by the citiwatts and Hotmaps teams and namely by:
EASILab - HES-SO Marie-Esther Mabillard HES-SO Daniel Hunacek and Lucien Zuber