Erfrischungskarte Daten

This repository contains the original data for the Erfrischungskarte, as well as the code used to estimate hourly values for cold wind volume and temperature.

The Wind_Temperature folder contains the raw (values for specific hours) and clean data (quantiles for all hours from 9:00 to 21:00), in a Geojson format, for wind and temperature. The folder also encompasses a R code (Kaltluftvolum_Lufttemperatur.R) used to compute the estimates and quantiles for all hours.
The POI's folder contains the raw point data (pools, green areas, picnic tables, etc.) as well as a Geojson file containing all data points (erfrischungskarte_poi.geojson).

Original data sources

The information on temperature and cold air is based on processed climate model data from the Berlin Senatsverwaltung für Stadtentwicklung und Wohnen. For both topics, data is available for different times of the day. These data were interpolated to obtain data for each hour of the day. The shadows were calculated from a digital terrain model. The map is supplemented by points of interests, i.e. places that could be interesting in connection with the data. These come from various sources: The coordinates of the green spaces were created from a data set on the public green space inventory. This is maintained by the district street and green space offices and made available on the Berlin geodata portal. The locations of the fountains can also be found in the geodata portal and are part of the extensive ATKIS dataset, which is regularly updated by the district surveying offices. The locations of bathing places come from the State Office for Health and Social Affairs (LaGeSo). The information on outdoor swimming pools and indoor swimming pools is currently only available as a list via Berlin.de. They were transferred into a geodata set by means of webscraping. Benches, picnic tables and drinking fountains were exported from Open Street Map, a freely accessible collection of geodata.