Table of Contents

Introduction

The database built for Hotmaps 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 Gitlab repository

To Top

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.

To Top

Indicators

Indicators are defined here. 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.

To Top

Technologies

The technologies used for the database are:

  • PostgreSQL version 9.6
  • PostGIS version 2.3
  • GeoServer version 2.11.2

To Top

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

To Top

How to cite

Daniel Hunacek and Lucien Zuber, in Hotmaps Wiki, Database behind the Hotmaps toolbox (September 2020)

To Top

Authors and reviewers

This page was written by Daniel Hunacek and Lucien Zuber HES-SO.

☑ This page was reviewed by Mostafa Fallahnejad EEG - TU Wien.

To Top

License

Copyright © 2016-2020: Daniel Hunacek, Lucien Zuber

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

To Top

Acknowledgement

We would like to convey our deepest appreciation to the Horizon 2020 Hotmaps Project (Grant Agreement number 723677), which provided the funding to carry out the present investigation

To Top

View in another language:

Bulgarian* Czech* Danish* German* Greek* Spanish* Estonian* Finnish* French* Irish* Croatian* Hungarian* Italian* Lithuanian* Latvian* Maltese* Dutch* Polish* Portuguese (Portugal, Brazil)* Romanian* Slovak* Slovenian* Swedish*

* machine translated