{ "cells": [ { "cell_type": "markdown", "id": "85d42f7d-033a-4f5c-91cf-8ea002887b29", "metadata": {}, "source": [ "© Alexander Jüstel, Fraunhofer IEG, Institution for Energy Infrastructures and Geothermal Systems, RWTH Aachen University,\n", "GNU Lesser General Public License v3.0\n", "\n", "# 15 Calculating Heat Demand Density along Street segments\n", "\n", "This notebook illustrates how to calculate the heat demand density along street segments. Here the heat demand of the adjacent buildings will attributed to the closest street segment (LineString)." ] }, { "cell_type": "markdown", "id": "17d501ce-0d07-4c36-be3e-a2563c799c00", "metadata": {}, "source": [ "## Importing Libraries" ] }, { "cell_type": "code", "execution_count": 1, "id": "6bb3a62f-e33b-48e4-8e97-efcd7a530db9", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "C:\\Users\\ale93371\\Anaconda3\\envs\\pygeomechanical\\lib\\site-packages\\numpy\\_distributor_init.py:30: UserWarning: loaded more than 1 DLL from .libs:\n", "C:\\Users\\ale93371\\Anaconda3\\envs\\pygeomechanical\\lib\\site-packages\\numpy\\.libs\\libopenblas.FB5AE2TYXYH2IJRDKGDGQ3XBKLKTF43H.gfortran-win_amd64.dll\n", "C:\\Users\\ale93371\\Anaconda3\\envs\\pygeomechanical\\lib\\site-packages\\numpy\\.libs\\libopenblas64__v0.3.23-246-g3d31191b-gcc_10_3_0.dll\n", " warnings.warn(\"loaded more than 1 DLL from .libs:\"\n" ] } ], "source": [ "import geopandas as gpd\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import shapely\n", "\n", "from pyheatdemand import processing " ] }, { "cell_type": "markdown", "id": "2897d513-bd6b-4969-b2fa-14f725ae9d35", "metadata": {}, "source": [ "## Loading Heat Demand Data\n", "\n", "The heat demand data utilized here can be downloaded from https://www.opengeodata.nrw.de/produkte/umwelt_klima/klima/raumwaermebedarfsmodell/." ] }, { "cell_type": "code", "execution_count": 2, "id": "6385761f-9d63-4c67-95d0-8a0b5d551fda", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | WB_HU | \n", "geometry | \n", "
|---|---|---|
| 0 | \n", "768.012128 | \n", "POINT (292705.144 5627871.339) | \n", "
| 1 | \n", "1010.052042 | \n", "POINT (292705.613 5627867.064) | \n", "
| 2 | \n", "849.072467 | \n", "POINT (292429.547 5627523.452) | \n", "
| 3 | \n", "454.138112 | \n", "POINT (292561.555 5627797.114) | \n", "
| 4 | \n", "2335.658552 | \n", "POINT (292403.666 5627494.653) | \n", "
| \n", " | full_id | \n", "osm_id | \n", "osm_type | \n", "highway | \n", "bicycle | \n", "service | \n", "zone_traff | \n", "turn_lanes | \n", "source_max | \n", "ref | \n", "... | \n", "name_etymo | \n", "oneway | \n", "foot | \n", "width | \n", "surface | \n", "sidewalk | \n", "name | \n", "maxspeed | \n", "lit | \n", "geometry | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "w5155813 | \n", "5155813 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "7 | \n", "asphalt | \n", "both | \n", "Hanbrucher StraÃe | \n", "30 | \n", "yes | \n", "LINESTRING (292758.350 5627929.657, 292768.884... | \n", "
| 1 | \n", "w5215882 | \n", "5215882 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "no | \n", "yes | \n", "NaN | \n", "asphalt | \n", "both | \n", "Am Neuenhof | \n", "30 | \n", "yes | \n", "LINESTRING (292687.050 5627901.427, 292681.924... | \n", "
| 2 | \n", "w12077876 | \n", "12077876 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Am Backes | \n", "30 | \n", "yes | \n", "LINESTRING (292300.152 5627645.147, 292300.800... | \n", "
| 3 | \n", "w12078449 | \n", "12078449 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "Q66190 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "asphalt | \n", "NaN | \n", "Leo-Blech-StraÃe | \n", "30 | \n", "yes | \n", "LINESTRING (292341.172 5627706.044, 292313.565... | \n", "
| 4 | \n", "w12078450 | \n", "12078450 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "asphalt | \n", "NaN | \n", "NekesstraÃe | \n", "30 | \n", "NaN | \n", "LINESTRING (292383.174 5627774.798, 292335.277... | \n", "
5 rows × 33 columns
\n", "| \n", " | geometry | \n", "WB_HU | \n", "
|---|---|---|
| 0 | \n", "LINESTRING (292726.502 5627866.823, 292705.144... | \n", "768.012128 | \n", "
| 1 | \n", "LINESTRING (292725.657 5627862.826, 292705.613... | \n", "1010.052042 | \n", "
| 2 | \n", "LINESTRING (292726.502 5627866.823, 292705.144... | \n", "768.012128 | \n", "
| 3 | \n", "LINESTRING (292725.657 5627862.826, 292705.613... | \n", "1010.052042 | \n", "
| 4 | \n", "LINESTRING (292413.265 5627537.473, 292429.547... | \n", "849.072467 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 153 | \n", "LINESTRING (292421.857 5627634.247, 292419.748... | \n", "21470.730216 | \n", "
| 154 | \n", "LINESTRING (292458.715 5627625.513, 292456.294... | \n", "11794.683169 | \n", "
| 155 | \n", "LINESTRING (292565.484 5627742.419, 292561.759... | \n", "12185.490605 | \n", "
| 156 | \n", "LINESTRING (292599.944 5627826.338, 292596.116... | \n", "16881.994814 | \n", "
| 157 | \n", "LINESTRING (292642.319 5627824.162, 292637.298... | \n", "19894.327553 | \n", "
158 rows × 2 columns
\n", "| \n", " | WB_HU | \n", "full_id | \n", "osm_id | \n", "osm_type | \n", "highway | \n", "bicycle | \n", "service | \n", "zone_traff | \n", "turn_lanes | \n", "source_max | \n", "... | \n", "oneway | \n", "foot | \n", "width | \n", "surface | \n", "sidewalk | \n", "name | \n", "maxspeed | \n", "lit | \n", "geometry | \n", "HD_normalized | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | \n", "923948.221657 | \n", "w5215882 | \n", "5215882 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "no | \n", "yes | \n", "NaN | \n", "asphalt | \n", "both | \n", "Am Neuenhof | \n", "30 | \n", "yes | \n", "LINESTRING (292687.050 5627901.427, 292681.924... | \n", "1741.960760 | \n", "
| 8 | \n", "25628.624084 | \n", "w13745756 | \n", "13745756 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Pieter-Bruegel-StraÃe | \n", "30 | \n", "yes | \n", "LINESTRING (292677.282 5627843.170, 292667.040... | \n", "278.830764 | \n", "
| 11 | \n", "72448.930662 | \n", "w13745760 | \n", "13745760 | \n", "way | \n", "residential | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "asphalt | \n", "NaN | \n", "Jean-Lejeune-StraÃe | \n", "30 | \n", "NaN | \n", "LINESTRING (292432.216 5627559.482, 292410.911... | \n", "793.926439 | \n", "
| 15 | \n", "1778.064170 | \n", "w38532829 | \n", "38532829 | \n", "way | \n", "path | \n", "designated | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "yes | \n", "designated | \n", "NaN | \n", "asphalt | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LINESTRING (292760.238 5628176.202, 292771.633... | \n", "3.223262 | \n", "
| 22 | \n", "38124.672958 | \n", "w201078988 | \n", "201078988 | \n", "way | \n", "service | \n", "NaN | \n", "driveway | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LINESTRING (292410.911 5627573.158, 292401.356... | \n", "1952.001877 | \n", "
5 rows × 35 columns
\n", "