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

Go To Top

Final remarks

How To Cite

The citiwatts and Hotmaps teams, in citiwatts wiki, Database behind the citiwatts toolbox (2025)

Authors And Reviewers

Written by the OpenGIS4ET/citiwatts and Hotmaps teams and namely by:

EASILab - HES-SO Marie-Esther Mabillard HES-SO Daniel Hunacek and Lucien Zuber

License

Creative Commons Attribution 4.0 International License

This work is licensed under a Creative Commons CC BY 4.0 International License.

SPDX-License-Identifier: CC-BY-4.0

License-Text: https://spdx.org/licenses/CC-BY-4.0.html

Acknowledgement

The project “Open Geographic Information System for Energy Transition” (OpenGIS4ET, Project Number 111 786) has been supported by partners of the ERA-Net Smart Energy Systems and Mission Innovation through the Joint Call 2020. As such, this project has received funding from the

Energy Technology Development and Demonstration (EUDP), Denmark (Project No.: 64021-6026),
Federal Ministry for Economic Affairs and Climate Action, Germany (Project No.: 03EI4050B),
The Austrian Research Promotion Agency (FFG), Austria (Project No.: 889031),
Swiss Federal Office of Energy (SFOE), Switzerland (Project No.: 502364).

The OpenGIS4ET project builts on the H2020 Hotmaps Project.

For more details please refer to the About page of this wiki.

Disclaimers

The content and views expressed in this material are those of the authors and do not necessarily reflect the views or opinion of the ERA-Net SES initiative. Any reference given does not necessarily imply the endorsement by ERA-Net SES.

The citiwatts toolbox is a living platform: As the research project as well as its sister and follow-up projects evolve, (new) functionalities are refined and bugs are addressed and solved. The toolbox is hosted in two environments: the development server and the production server. The development server has the most up-to-date version, with most of issues and bugs solved, but it might be unstable as developers keep working on it daily. The production server instead is a stable environment.

Go To Top