{ "cells": [ { "cell_type": "markdown", "id": "5556432f", "metadata": {}, "source": [ "# Tutorial 53: Creation of Non-Element Dataframes" ] }, { "cell_type": "markdown", "id": "8899e69a", "metadata": {}, "source": [ "This Example demonstrates the capabilities of the class Dataframes_SIR3S_Model that extends SIR3S_Model be abilities to work directley with pandas dataframes. It is shown how to create dataframes containing information that does not concern individual elements types such as Nodes, Pipes, etc. but instead concerning more abstract SIR 3S data such as longitudinal sections or concatenations of multiple element types like hydraulic edges." ] }, { "cell_type": "markdown", "id": "e2d40c36", "metadata": {}, "source": [ "# Toolkit Release" ] }, { "cell_type": "code", "execution_count": 1, "id": "7fb5a07b", "metadata": {}, "outputs": [], "source": [ "#pip install " ] }, { "cell_type": "markdown", "id": "d6773e12", "metadata": {}, "source": [ "# Imports" ] }, { "cell_type": "markdown", "id": "134689cf", "metadata": {}, "source": [ "## SIR 3S Toolkit" ] }, { "cell_type": "markdown", "id": "69665f68", "metadata": {}, "source": [ "### Regular Import/Init" ] }, { "cell_type": "code", "execution_count": null, "id": "79d0fb2c", "metadata": {}, "outputs": [], "source": [ "SIR3S_SIRGRAF_DIR = r\"C:\\3S\\SIR 3S\\SirGraf-90-15-00-24_Quebec-Upd2\" #change to local path" ] }, { "cell_type": "code", "execution_count": 3, "id": "0f41d17a", "metadata": {}, "outputs": [], "source": [ "from sir3stoolkit.core import wrapper" ] }, { "cell_type": "code", "execution_count": 4, "id": "d539c981", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wrapper" ] }, { "cell_type": "code", "execution_count": 5, "id": "37d59df0", "metadata": {}, "outputs": [], "source": [ "wrapper.Initialize_Toolkit(SIR3S_SIRGRAF_DIR)" ] }, { "cell_type": "markdown", "id": "ebf2c56e", "metadata": {}, "source": [ "### Additional Import/Init for Dataframes class" ] }, { "cell_type": "code", "execution_count": 6, "id": "893f889e", "metadata": {}, "outputs": [], "source": [ "from sir3stoolkit.mantle.dataframes import SIR3S_Model_Dataframes" ] }, { "cell_type": "code", "execution_count": 7, "id": "4b65297f", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Initialization complete\n" ] } ], "source": [ "s3s = SIR3S_Model_Dataframes()" ] }, { "cell_type": "markdown", "id": "2007993a", "metadata": {}, "source": [ "## Additional" ] }, { "cell_type": "code", "execution_count": 8, "id": "3a443734", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "from shapely.geometry import Point\n", "import re\n", "import folium\n", "from folium.plugins import HeatMap\n", "import numpy as np\n", "import geopandas as gpd\n", "from shapely import wkt\n", "import matplotlib.pyplot as plt\n", "import contextily as cx" ] }, { "cell_type": "markdown", "id": "d9a78e4d", "metadata": {}, "source": [ "# Open Model" ] }, { "cell_type": "code", "execution_count": 9, "id": "20ff3c21", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Model is open for further operation\n" ] } ], "source": [ "s3s.OpenModel(dbName=r\"Toolkit_Tutorial53_Model.db3\",\n", " providerType=s3s.ProviderTypes.SQLite,\n", " Mid=\"M-1-0-1\",\n", " saveCurrentlyOpenModel=False,\n", " namedInstance=\"\",\n", " userID=\"\",\n", " password=\"\")" ] }, { "cell_type": "markdown", "id": "812d0b6f", "metadata": {}, "source": [ "# Calculate Model" ] }, { "cell_type": "code", "execution_count": 10, "id": "b55b96a8", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Model Calculation is complete\n" ] } ], "source": [ "s3s.ExecCalculation(True) # To ensure result data" ] }, { "cell_type": "markdown", "id": "34cb086c", "metadata": {}, "source": [ "# Generate Non-Element Dataframes" ] }, { "cell_type": "markdown", "id": "91b1def2", "metadata": {}, "source": [ "## AGSN (Longitudinal Sections)" ] }, { "cell_type": "markdown", "id": "f61492a3", "metadata": {}, "source": [ "We can use the method [generate_longitudinal_section_dataframes()](https://3sconsult.github.io/sir3stoolkit/references/sir3stoolkit.mantle.html#sir3stoolkit.mantle.dataframes.SIR3S_Model_Dataframes.generate_longitudinal_section_dataframes) to obtain a list indexed by (lfdnr-1) filled with size-2-tuples with 0 - Supply and 1 - Return.." ] }, { "cell_type": "code", "execution_count": 11, "id": "05990293", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "[2026-03-03 15:33:02,655] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.AGSN_HydraulicProfile\n", "[2026-03-03 15:33:02,662] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.AGSN_HydraulicProfile.\n", "[2026-03-03 15:33:02,677] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.AGSN_HydraulicProfile.\n", "[2026-03-03 15:33:02,678] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 9 model_data properties.\n", "[2026-03-03 15:33:02,678] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Lfdnr', 'Aktiv', 'AllNodesAndLinks', 'ObjsString', 'MainWay', 'Tk', 'Pk', 'InVariant']...\n", "[2026-03-03 15:33:02,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 10)\n", "[2026-03-03 15:33:02,707] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 1.\n", "[2026-03-03 15:33:02,722] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:02,722] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:02,868] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:03,198] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:03,269] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:03,270] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:03,343] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:03,344] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:03,408] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:03,409] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:03,411] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:03,411] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:03,414] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:03,429] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:03,829] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:04,087] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:04,088] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:04,123] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:04,124] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:04,130] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:04,132] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:04,134] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:04,135] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:04,136] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:04,137] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:04,283] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:04,365] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:04,365] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:04,449] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:04,449] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:04,532] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:04,533] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:04,536] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:04,537] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:04,540] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:04,576] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:05,239] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:05,448] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:05,453] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:05,498] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 2.\n", "[2026-03-03 15:33:05,499] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:05,501] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:05,508] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:05,512] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:05,513] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:05,515] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:05,515] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:05,518] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:05,727] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:05,877] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:05,877] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:05,995] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:05,995] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:06,089] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:06,089] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:06,098] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:06,100] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:06,103] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:06,144] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:06,807] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:07,024] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:07,035] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:07,081] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:07,082] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:07,087] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:07,092] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:07,094] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:07,096] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:07,098] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:07,099] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:07,277] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:07,378] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:07,378] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:07,477] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:07,477] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:07,604] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:07,648] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:08,295] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:08,495] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:08,495] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:08,541] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 3.\n", "[2026-03-03 15:33:08,543] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:08,544] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:08,550] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:08,555] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:08,556] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:08,561] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:08,561] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:08,563] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:08,730] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:08,836] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:08,836] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:08,933] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:08,934] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:09,035] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:09,035] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:09,038] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:09,040] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:09,044] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:09,083] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:09,709] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:10,091] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:10,094] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:10,176] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:10,178] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-03 15:33:10,189] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:10,195] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:10,197] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:10,200] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-03 15:33:10,200] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-03 15:33:10,206] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-03 15:33:10,523] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:10,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:10,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-03-03 15:33:10,841] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-03 15:33:10,841] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:11,008] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-03 15:33:11,008] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-03 15:33:11,015] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:11,017] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-03-03 15:33:11,021] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-03 15:33:11,045] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-03 15:33:14,061] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.\n", "[2026-03-03 15:33:14,760] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)\n", "[2026-03-03 15:33:14,760] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n" ] } ], "source": [ "dfs = s3s.generate_longitudinal_section_dataframes()" ] }, { "cell_type": "code", "execution_count": 12, "id": "0c93b1c9", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tkNameFkdtroRowdFkltgrFkstrasseLLzuRauJlambsLambda0ZeinZausZumlAsollIndschallBaujahrHalFkcontFk2lrohrBeschreibungIdreferenzIplanungKvrLineWidthMMDottedLineDNDiKvrKlartextHasClosedNSCHsTkPkInVariantXkorYkorGeometriesDifferbz.Fkbz.Qsvbbz.Irtrennbz.Leckstatusbz.Leckstartbz.Leckendbz.Leckortbz.Leckmengebz.Imptnzbz.Zvlimptnzbz.Kantenzvbz.ITrennWithNSCHgeometryfkKIfkKKADTTRDWVERLDWVERLABSIAKTIVIRTRENNJVMVEC_startMVEC_endMVEC_sequencePDAMPFPHRPMINPVEC_startPVEC_endPVEC_sequencePVECMAX_INST_startPVECMAX_INST_endPVECMAX_INST_sequencePVECMIN_INST_startPVECMIN_INST_endPVECMIN_INST_sequenceQMAVQMIQMKRHOIRHOKRHOVEC_startRHOVEC_endRHOVEC_sequenceSVEC_startSVEC_endSVEC_sequenceTITKTTRVEC_startTTRVEC_endTTRVEC_sequenceTVEC_startTVEC_endTVEC_sequenceVAVVIVKVOLDAWVLZVEC_startZVEC_endZVEC_sequencel_sumAGSN_LfdnrAGSN_Name
05691533564979419761Rohr V-E0 V-K1683S48165111674553109734779752876656844188520482933228154734615.35170000.051000010000050291288749724631185025945677694931826OSM: Knoten 476971238 -> Knoten 299394923; Län...39785520010.0050350345.6Vorlauf56915335649794197615691533564979419761False713619.9213835.578219e+06False569153356497941976100000000000LINESTRING (713619.921 5578218.954, 713614.649...539810069428410477948253915804674840320.00.000362352.09465.4052510.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.402028-55.93392-55.46401-55.93392(-55.46401, -55.69896, -55.93392)-55.46401-55.93392(-55.46401, -55.69896, -55.93392)-55.46401-55.93392(-55.46401, -55.69896, -55.93392)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.015.351700(0.0, 7.67585, 15.3517)666.0665.99890.0000000.000362(0.0, 0.0001807726, 0.0003615452)666.0000665.9989(666.0, 665.9995, 665.9989)12.7296812.7296812.729680.015415.81541.49542.29(541.49, 541.89, 542.29)15.3517011Längsschnitt
15048873293262650113Rohr V-K1683S V-K1693S48165111674553109734779752876656844188520482933228154734612.50895000.051000010000050291288749724631185216742060270992761OSM: Knoten 299394923 -> Knoten 4105649557; Lä...39785520010.0050350345.6Vorlauf50488732932626501135048873293262650113False713614.6487125.578233e+06False504887329326265011300000000000LINESTRING (713614.649 5578233.372, 713614.465...482539158046748403251806177803628615930.00.000295345.68854.3242010.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.327583-56.3209-55.93392-56.32089(-55.93392, -56.12741, -56.32089)-55.93392-56.32089(-55.93392, -56.12741, -56.32089)-55.93392-56.32089(-55.93392, -56.12741, -56.32089)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.012.508950(0.0, 6.254475, 12.50895)665.9989665.9980.0003620.000656(0.0003615452, 0.0005088433, 0.0006561414)665.9989665.9980(665.9989, 665.9985, 665.998)12.7296812.7296812.729680.015405.72542.29542.99(542.29, 542.64, 542.99)27.8606481Längsschnitt
25715081934973525403Rohr V-K2163S V-K1693S4816511167455310973477975287665684418852048293322815473466.26550500.051000010000050291288749724631184919359344392474301OSM: Knoten 299394922 -> Knoten 4105649557; Lä...595926249010.0050350345.6Vorlauf57150819349735254035715081934973525403False713614.3690435.578252e+06False571508193497352540300000000000LINESTRING (713614.369 5578252.145, 713614.465...496492048704118354551806177803628615930.00.000148345.082.16210.00.026.18786-1033.169-1033.169(-1033.169, -1033.169)15.54880.16408-56.51383-56.51382-56.32089(-56.51382, -56.32089)-56.51382-56.32089(-56.51382, -56.32089)-56.51382-56.32089(-56.51382, -56.32089)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2)0.06.265505(0.0, 6.265505)665.9976665.9980.0008040.000656(0.0008036994, 0.0006561416)665.9976665.9980(665.9976, 665.998)-12.72968-12.72968-12.729680.0-15397.65543.33542.99(543.33, 542.99)34.1261531Längsschnitt
35413647981880727734Rohr V-K2043S V-K2163S48165111674553109734779752876656844188520482933228154734614.40754000.051000010000050291288749724631185299861566239260044OSM: Knoten 299394921 -> Knoten 299394922; Län...595926249010.0050350345.6Vorlauf54136479818807277345413647981880727734False713616.8836495.578266e+06False541364798188072773400000000000LINESTRING (713616.884 5578266.331, 713614.369...479401623113754896749649204870411835450.00.000339375.16825.4052510.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.377303-56.95052-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.014.407540(0.0, 7.20377, 14.40754)665.9966665.99760.0011430.000804(0.001143009, 0.0009733541, 0.0008036994)665.9966665.9976(665.9966, 665.9971, 665.9976)-12.72968-12.72968-12.729680.0-15393.61544.03543.33(544.03, 543.6801, 543.33)48.5336951Längsschnitt
45134010500800575790Rohr V-K2033S V-K2043S48165111674553109734779752876656844188520482933228154734613.51584000.051000010000050291288749724631185204837016964086891OSM: Knoten 4105649561 -> Knoten 299394921; Lä...408665320010.0050350345.6Vorlauf51340105008005757905134010500800575790False713614.2386955.578280e+06False513401050080057579000000000000LINESTRING (713614.239 5578279.586, 713616.884...547312312597901032547940162311375489670.00.000318359.92774.8647260.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.353951-57.34774-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.013.515840(0.0, 6.75792, 13.51584)665.9956665.99660.0014610.001143(0.001461318, 0.001302163, 0.001143009)665.9956665.9966(665.9956, 665.9961, 665.9966)-12.72968-12.72968-12.729680.0-15384.03544.54544.03(544.54, 544.285, 544.03)62.0495381Längsschnitt
\n", "
" ], "text/plain": [ " tk Name FkdtroRowd \\\n", "0 5691533564979419761 Rohr V-E0 V-K1683S 4816511167455310973 \n", "1 5048873293262650113 Rohr V-K1683S V-K1693S 4816511167455310973 \n", "2 5715081934973525403 Rohr V-K2163S V-K1693S 4816511167455310973 \n", "3 5413647981880727734 Rohr V-K2043S V-K2163S 4816511167455310973 \n", "4 5134010500800575790 Rohr V-K2033S V-K2043S 4816511167455310973 \n", "\n", " Fkltgr Fkstrasse L Lzu Rau Jlambs \\\n", "0 4779752876656844188 5204829332281547346 15.351700 0 0.05 1 \n", "1 4779752876656844188 5204829332281547346 12.508950 0 0.05 1 \n", "2 4779752876656844188 5204829332281547346 6.265505 0 0.05 1 \n", "3 4779752876656844188 5204829332281547346 14.407540 0 0.05 1 \n", "4 4779752876656844188 5204829332281547346 13.515840 0 0.05 1 \n", "\n", " Lambda0 Zein Zaus Zuml Asoll Indschall Baujahr Hal \\\n", "0 0 0 0 0 1000 0 0 \n", "1 0 0 0 0 1000 0 0 \n", "2 0 0 0 0 1000 0 0 \n", "3 0 0 0 0 1000 0 0 \n", "4 0 0 0 0 1000 0 0 \n", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5025945677694931826 \n", "1 5029128874972463118 5216742060270992761 \n", "2 5029128874972463118 4919359344392474301 \n", "3 5029128874972463118 5299861566239260044 \n", "4 5029128874972463118 5204837016964086891 \n", "\n", " Beschreibung Idreferenz Iplanung \\\n", "0 OSM: Knoten 476971238 -> Knoten 299394923; Län... 39785520 0 \n", "1 OSM: Knoten 299394923 -> Knoten 4105649557; Lä... 39785520 0 \n", "2 OSM: Knoten 299394922 -> Knoten 4105649557; Lä... 595926249 0 \n", "3 OSM: Knoten 299394921 -> Knoten 299394922; Län... 595926249 0 \n", "4 OSM: Knoten 4105649561 -> Knoten 299394921; Lä... 408665320 0 \n", "\n", " Kvr LineWidthMM DottedLine DN Di KvrKlartext HasClosedNSCHs \\\n", "0 1 0.005 0 350 345.6 Vorlauf \n", "1 1 0.005 0 350 345.6 Vorlauf \n", "2 1 0.005 0 350 345.6 Vorlauf \n", "3 1 0.005 0 350 345.6 Vorlauf \n", "4 1 0.005 0 350 345.6 Vorlauf \n", "\n", " Tk Pk InVariant Xkor \\\n", "0 5691533564979419761 5691533564979419761 False 713619.921383 \n", "1 5048873293262650113 5048873293262650113 False 713614.648712 \n", "2 5715081934973525403 5715081934973525403 False 713614.369043 \n", "3 5413647981880727734 5413647981880727734 False 713616.883649 \n", "4 5134010500800575790 5134010500800575790 False 713614.238695 \n", "\n", " Ykor GeometriesDiffer bz.Fk bz.Qsvb bz.Irtrenn \\\n", "0 5.578219e+06 False 5691533564979419761 0 0 \n", "1 5.578233e+06 False 5048873293262650113 0 0 \n", "2 5.578252e+06 False 5715081934973525403 0 0 \n", "3 5.578266e+06 False 5413647981880727734 0 0 \n", "4 5.578280e+06 False 5134010500800575790 0 0 \n", "\n", " bz.Leckstatus bz.Leckstart bz.Leckend bz.Leckort bz.Leckmenge \\\n", "0 0 0 0 0 0 \n", "1 0 0 0 0 0 \n", "2 0 0 0 0 0 \n", "3 0 0 0 0 0 \n", "4 0 0 0 0 0 \n", "\n", " bz.Imptnz bz.Zvlimptnz bz.Kantenzv bz.ITrennWithNSCH \\\n", "0 0 0 0 0 \n", "1 0 0 0 0 \n", "2 0 0 0 0 \n", "3 0 0 0 0 \n", "4 0 0 0 0 \n", "\n", " geometry fkKI \\\n", "0 LINESTRING (713619.921 5578218.954, 713614.649... 5398100694284104779 \n", "1 LINESTRING (713614.649 5578233.372, 713614.465... 4825391580467484032 \n", "2 LINESTRING (713614.369 5578252.145, 713614.465... 4964920487041183545 \n", "3 LINESTRING (713616.884 5578266.331, 713614.369... 4794016231137548967 \n", "4 LINESTRING (713614.239 5578279.586, 713616.884... 5473123125979010325 \n", "\n", " fkKK A DTTR DWVERL DWVERLABS IAKTIV IRTRENN \\\n", "0 4825391580467484032 0.0 0.000362 352.0946 5.405251 0.0 0.0 \n", "1 5180617780362861593 0.0 0.000295 345.6885 4.324201 0.0 0.0 \n", "2 5180617780362861593 0.0 0.000148 345.08 2.1621 0.0 0.0 \n", "3 4964920487041183545 0.0 0.000339 375.1682 5.405251 0.0 0.0 \n", "4 4794016231137548967 0.0 0.000318 359.9277 4.864726 0.0 0.0 \n", "\n", " JV MVEC_start MVEC_end MVEC_sequence PDAMPF \\\n", "0 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "1 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "2 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169) 15.5488 \n", "3 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "4 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "\n", " PHR PMIN PVEC_start PVEC_end \\\n", "0 0.402028 -55.93392 -55.46401 -55.93392 \n", "1 0.327583 -56.3209 -55.93392 -56.32089 \n", "2 0.16408 -56.51383 -56.51382 -56.32089 \n", "3 0.377303 -56.95052 -56.95052 -56.51382 \n", "4 0.353951 -57.34774 -57.34774 -56.95052 \n", "\n", " PVEC_sequence PVECMAX_INST_start PVECMAX_INST_end \\\n", "0 (-55.46401, -55.69896, -55.93392) -55.46401 -55.93392 \n", "1 (-55.93392, -56.12741, -56.32089) -55.93392 -56.32089 \n", "2 (-56.51382, -56.32089) -56.51382 -56.32089 \n", "3 (-56.95052, -56.73217, -56.51382) -56.95052 -56.51382 \n", "4 (-57.34774, -57.14913, -56.95052) -57.34774 -56.95052 \n", "\n", " PVECMAX_INST_sequence PVECMIN_INST_start PVECMIN_INST_end \\\n", "0 (-55.46401, -55.69896, -55.93392) -55.46401 -55.93392 \n", "1 (-55.93392, -56.12741, -56.32089) -55.93392 -56.32089 \n", "2 (-56.51382, -56.32089) -56.51382 -56.32089 \n", "3 (-56.95052, -56.73217, -56.51382) -56.95052 -56.51382 \n", "4 (-57.34774, -57.14913, -56.95052) -57.34774 -56.95052 \n", "\n", " PVECMIN_INST_sequence QMAV QMI QMK RHOI \\\n", "0 (-55.46401, -55.69896, -55.93392) 3719.409 3719.409 3719.409 865.2 \n", "1 (-55.93392, -56.12741, -56.32089) 3719.409 3719.409 3719.409 865.2 \n", "2 (-56.51382, -56.32089) -3719.409 -3719.409 -3719.409 865.2 \n", "3 (-56.95052, -56.73217, -56.51382) -3719.409 -3719.409 -3719.409 865.2 \n", "4 (-57.34774, -57.14913, -56.95052) -3719.409 -3719.409 -3719.409 865.2 \n", "\n", " RHOK RHOVEC_start RHOVEC_end RHOVEC_sequence SVEC_start \\\n", "0 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "1 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "2 865.2 865.2 865.2 (865.2, 865.2) 0.0 \n", "3 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "4 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "\n", " SVEC_end SVEC_sequence TI TK TTRVEC_start \\\n", "0 15.351700 (0.0, 7.67585, 15.3517) 666.0 665.9989 0.000000 \n", "1 12.508950 (0.0, 6.254475, 12.50895) 665.9989 665.998 0.000362 \n", "2 6.265505 (0.0, 6.265505) 665.9976 665.998 0.000804 \n", "3 14.407540 (0.0, 7.20377, 14.40754) 665.9966 665.9976 0.001143 \n", "4 13.515840 (0.0, 6.75792, 13.51584) 665.9956 665.9966 0.001461 \n", "\n", " TTRVEC_end TTRVEC_sequence TVEC_start \\\n", "0 0.000362 (0.0, 0.0001807726, 0.0003615452) 666.0000 \n", "1 0.000656 (0.0003615452, 0.0005088433, 0.0006561414) 665.9989 \n", "2 0.000656 (0.0008036994, 0.0006561416) 665.9976 \n", "3 0.000804 (0.001143009, 0.0009733541, 0.0008036994) 665.9966 \n", "4 0.001143 (0.001461318, 0.001302163, 0.001143009) 665.9956 \n", "\n", " TVEC_end TVEC_sequence VAV VI VK \\\n", "0 665.9989 (666.0, 665.9995, 665.9989) 12.72968 12.72968 12.72968 \n", "1 665.9980 (665.9989, 665.9985, 665.998) 12.72968 12.72968 12.72968 \n", "2 665.9980 (665.9976, 665.998) -12.72968 -12.72968 -12.72968 \n", "3 665.9976 (665.9966, 665.9971, 665.9976) -12.72968 -12.72968 -12.72968 \n", "4 665.9966 (665.9956, 665.9961, 665.9966) -12.72968 -12.72968 -12.72968 \n", "\n", " VOLDA WVL ZVEC_start ZVEC_end ZVEC_sequence \\\n", "0 0.0 15415.81 541.49 542.29 (541.49, 541.89, 542.29) \n", "1 0.0 15405.72 542.29 542.99 (542.29, 542.64, 542.99) \n", "2 0.0 -15397.65 543.33 542.99 (543.33, 542.99) \n", "3 0.0 -15393.61 544.03 543.33 (544.03, 543.6801, 543.33) \n", "4 0.0 -15384.03 544.54 544.03 (544.54, 544.285, 544.03) \n", "\n", " l_sum AGSN_Lfdnr AGSN_Name \n", "0 15.351701 1 Längsschnitt \n", "1 27.860648 1 Längsschnitt \n", "2 34.126153 1 Längsschnitt \n", "3 48.533695 1 Längsschnitt \n", "4 62.049538 1 Längsschnitt " ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[0][0].head() # Lfdnr 1, Vl" ] }, { "cell_type": "code", "execution_count": 13, "id": "805f2968", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tkNameFkdtroRowdFkltgrFkstrasseLLzuRauJlambsLambda0ZeinZausZumlAsollIndschallBaujahrHalFkcontFk2lrohrBeschreibungIdreferenzIplanungKvrLineWidthMMDottedLineDNDiKvrKlartextHasClosedNSCHsTkPkInVariantXkorYkorGeometriesDifferbz.Fkbz.Qsvbbz.Irtrennbz.Leckstatusbz.Leckstartbz.Leckendbz.Leckortbz.Leckmengebz.Imptnzbz.Zvlimptnzbz.Kantenzvbz.ITrennWithNSCHgeometryfkKIfkKKADTTRDWVERLDWVERLABSIAKTIVIRTRENNJVMVEC_startMVEC_endMVEC_sequencePDAMPFPHRPMINPVEC_startPVEC_endPVEC_sequencePVECMAX_INST_startPVECMAX_INST_endPVECMAX_INST_sequencePVECMIN_INST_startPVECMIN_INST_endPVECMIN_INST_sequenceQMAVQMIQMKRHOIRHOKRHOVEC_startRHOVEC_endRHOVEC_sequenceSVEC_startSVEC_endSVEC_sequenceTITKTTRVEC_startTTRVEC_endTTRVEC_sequenceTVEC_startTVEC_endTVEC_sequenceVAVVIVKVOLDAWVLZVEC_startZVEC_endZVEC_sequencel_sumAGSN_LfdnrAGSN_Name
05025945677694931826Rohr R-E0 R-K4163S48165111674553109734779752876656844188520482933228154734615.35170000.051000010000050291288749724631185691533564979419761OSM: Knoten 476971238 -> Knoten 299394923; Län...39785520020.0050350345.6Rücklauf50259456776949318265025945677694931826False713621.9213835.578219e+06False502594567769493182600000000000LINESTRING (713621.921 5578218.954, 713616.649...516085064877967489848516784769550846370.00.000362352.09465.4052510.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.4020284.5332134.5332154.869910(4.533215, 4.70156, 4.86991)4.5332154.869910(4.533215, 4.70156, 4.86991)4.5332154.869910(4.533215, 4.70156, 4.86991)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.015.351700(0.0, 7.67585, 15.3517)662.6788662.67990.0202680.019906(0.02026793, 0.02008715, 0.01990638)662.6787662.6798(662.6787, 662.6793, 662.6798)-12.72968-12.72968-12.729680.00.0541.43542.20(541.43, 541.815, 542.2)15.3517011Längsschnitt
15216742060270992761Rohr R-K4163S R-K4173S48165111674553109734779752876656844188520482933228154734612.50895000.051000010000050291288749724631185048873293262650113OSM: Knoten 299394923 -> Knoten 4105649557; Lä...39785520020.0050350345.6Rücklauf52167420602709927615216742060270992761False713616.6487125.578233e+06False521674206027099276100000000000LINESTRING (713616.649 5578233.372, 713616.465...485167847695508463754697539850219875700.00.000295345.68854.3242010.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.3275834.8699074.8699105.135555(4.86991, 5.00273, 5.135555)4.8699105.135555(4.86991, 5.00273, 5.135555)4.8699105.135555(4.86991, 5.00273, 5.135555)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.012.508950(0.0, 6.254475, 12.50895)662.6799662.68070.0199060.019612(0.01990638, 0.01975908, 0.01961179)662.6798662.6808(662.6798, 662.6803, 662.6808)-12.72968-12.72968-12.729680.00.0542.20542.93(542.2, 542.565, 542.93)27.8606481Längsschnitt
24919359344392474301Rohr R-K4643S R-K4173S4816511167455310973477975287665684418852048293322815473466.26550500.051000010000050291288749724631185715081934973525403OSM: Knoten 299394922 -> Knoten 4105649557; Lä...595926249020.0050350345.6Rücklauf49193593443924743014919359344392474301False713616.3690435.578252e+06False491935934439247430100000000000LINESTRING (713616.369 5578252.145, 713616.465...520760333857826416954697539850219875700.00.000148345.082.16210.00.026.187861033.1691033.169(1033.169, 1033.169)15.54880.164085.1355535.2690905.135555(5.26909, 5.135555)5.2690905.135555(5.26909, 5.135555)5.2690905.135555(5.26909, 5.135555)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2)0.06.265505(0.0, 6.265505)662.6812662.68070.0194640.019612(0.01946423, 0.01961179)662.6812662.6808(662.6812, 662.6808)12.7296812.7296812.729680.00.0543.29542.93(543.29, 542.93)34.1261531Längsschnitt
35299861566239260044Rohr R-K4523S R-K4643S48165111674553109734779752876656844188520482933228154734614.40754000.051000010000050291288749724631185413647981880727734OSM: Knoten 299394921 -> Knoten 299394922; Län...595926249020.0050350345.6Rücklauf52998615662392600445299861566239260044False713618.8836495.578266e+06False529986156623926004400000000000LINESTRING (713618.884 5578266.331, 713616.369...519145742106837807452076033385782641690.00.000339337.65144.8647260.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.3773035.269095.5759705.269090(5.57597, 5.42253, 5.26909)5.5759705.269090(5.57597, 5.42253, 5.26909)5.5759705.269090(5.57597, 5.42253, 5.26909)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.014.407540(0.0, 7.20377, 14.40754)662.6822662.68120.0191250.019464(0.01912492, 0.01929457, 0.01946423)662.6823662.6812(662.6823, 662.6816, 662.6812)12.7296812.7296812.729680.00.0544.12543.29(544.12, 543.705, 543.29)48.5336951Längsschnitt
45204837016964086891Rohr R-K4513S R-K4523S48165111674553109734779752876656844188520482933228154734613.51584000.051000010000050291288749724631185134010500800575790OSM: Knoten 4105649561 -> Knoten 299394921; Lä...408665320020.0050350345.6Rücklauf52048370169640868915204837016964086891False713616.2386955.578280e+06False520483701696408689100000000000LINESTRING (713616.239 5578279.586, 713618.884...487505482594136127451914574210683780740.00.000318359.92774.8647260.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.3539515.5759685.8891955.575970(5.889195, 5.73258, 5.57597)5.8891955.575970(5.889195, 5.73258, 5.57597)5.8891955.575970(5.889195, 5.73258, 5.57597)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.013.515840(0.0, 6.75792, 13.51584)662.6832662.68220.0188070.019125(0.01880661, 0.01896576, 0.01912492)662.6831662.6823(662.6831, 662.6826, 662.6823)12.7296812.7296812.729680.00.0544.60544.12(544.6, 544.36, 544.12)62.0495381Längsschnitt
\n", "
" ], "text/plain": [ " tk Name FkdtroRowd \\\n", "0 5025945677694931826 Rohr R-E0 R-K4163S 4816511167455310973 \n", "1 5216742060270992761 Rohr R-K4163S R-K4173S 4816511167455310973 \n", "2 4919359344392474301 Rohr R-K4643S R-K4173S 4816511167455310973 \n", "3 5299861566239260044 Rohr R-K4523S R-K4643S 4816511167455310973 \n", "4 5204837016964086891 Rohr R-K4513S R-K4523S 4816511167455310973 \n", "\n", " Fkltgr Fkstrasse L Lzu Rau Jlambs \\\n", "0 4779752876656844188 5204829332281547346 15.351700 0 0.05 1 \n", "1 4779752876656844188 5204829332281547346 12.508950 0 0.05 1 \n", "2 4779752876656844188 5204829332281547346 6.265505 0 0.05 1 \n", "3 4779752876656844188 5204829332281547346 14.407540 0 0.05 1 \n", "4 4779752876656844188 5204829332281547346 13.515840 0 0.05 1 \n", "\n", " Lambda0 Zein Zaus Zuml Asoll Indschall Baujahr Hal \\\n", "0 0 0 0 0 1000 0 0 \n", "1 0 0 0 0 1000 0 0 \n", "2 0 0 0 0 1000 0 0 \n", "3 0 0 0 0 1000 0 0 \n", "4 0 0 0 0 1000 0 0 \n", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5691533564979419761 \n", "1 5029128874972463118 5048873293262650113 \n", "2 5029128874972463118 5715081934973525403 \n", "3 5029128874972463118 5413647981880727734 \n", "4 5029128874972463118 5134010500800575790 \n", "\n", " Beschreibung Idreferenz Iplanung \\\n", "0 OSM: Knoten 476971238 -> Knoten 299394923; Län... 39785520 0 \n", "1 OSM: Knoten 299394923 -> Knoten 4105649557; Lä... 39785520 0 \n", "2 OSM: Knoten 299394922 -> Knoten 4105649557; Lä... 595926249 0 \n", "3 OSM: Knoten 299394921 -> Knoten 299394922; Län... 595926249 0 \n", "4 OSM: Knoten 4105649561 -> Knoten 299394921; Lä... 408665320 0 \n", "\n", " Kvr LineWidthMM DottedLine DN Di KvrKlartext HasClosedNSCHs \\\n", "0 2 0.005 0 350 345.6 Rücklauf \n", "1 2 0.005 0 350 345.6 Rücklauf \n", "2 2 0.005 0 350 345.6 Rücklauf \n", "3 2 0.005 0 350 345.6 Rücklauf \n", "4 2 0.005 0 350 345.6 Rücklauf \n", "\n", " Tk Pk InVariant Xkor \\\n", "0 5025945677694931826 5025945677694931826 False 713621.921383 \n", "1 5216742060270992761 5216742060270992761 False 713616.648712 \n", "2 4919359344392474301 4919359344392474301 False 713616.369043 \n", "3 5299861566239260044 5299861566239260044 False 713618.883649 \n", "4 5204837016964086891 5204837016964086891 False 713616.238695 \n", "\n", " Ykor GeometriesDiffer bz.Fk bz.Qsvb bz.Irtrenn \\\n", "0 5.578219e+06 False 5025945677694931826 0 0 \n", "1 5.578233e+06 False 5216742060270992761 0 0 \n", "2 5.578252e+06 False 4919359344392474301 0 0 \n", "3 5.578266e+06 False 5299861566239260044 0 0 \n", "4 5.578280e+06 False 5204837016964086891 0 0 \n", "\n", " bz.Leckstatus bz.Leckstart bz.Leckend bz.Leckort bz.Leckmenge \\\n", "0 0 0 0 0 0 \n", "1 0 0 0 0 0 \n", "2 0 0 0 0 0 \n", "3 0 0 0 0 0 \n", "4 0 0 0 0 0 \n", "\n", " bz.Imptnz bz.Zvlimptnz bz.Kantenzv bz.ITrennWithNSCH \\\n", "0 0 0 0 0 \n", "1 0 0 0 0 \n", "2 0 0 0 0 \n", "3 0 0 0 0 \n", "4 0 0 0 0 \n", "\n", " geometry fkKI \\\n", "0 LINESTRING (713621.921 5578218.954, 713616.649... 5160850648779674898 \n", "1 LINESTRING (713616.649 5578233.372, 713616.465... 4851678476955084637 \n", "2 LINESTRING (713616.369 5578252.145, 713616.465... 5207603338578264169 \n", "3 LINESTRING (713618.884 5578266.331, 713616.369... 5191457421068378074 \n", "4 LINESTRING (713616.239 5578279.586, 713618.884... 4875054825941361274 \n", "\n", " fkKK A DTTR DWVERL DWVERLABS IAKTIV IRTRENN \\\n", "0 4851678476955084637 0.0 0.000362 352.0946 5.405251 0.0 0.0 \n", "1 5469753985021987570 0.0 0.000295 345.6885 4.324201 0.0 0.0 \n", "2 5469753985021987570 0.0 0.000148 345.08 2.1621 0.0 0.0 \n", "3 5207603338578264169 0.0 0.000339 337.6514 4.864726 0.0 0.0 \n", "4 5191457421068378074 0.0 0.000318 359.9277 4.864726 0.0 0.0 \n", "\n", " JV MVEC_start MVEC_end MVEC_sequence PDAMPF \\\n", "0 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "1 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "2 26.18786 1033.169 1033.169 (1033.169, 1033.169) 15.5488 \n", "3 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "4 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "\n", " PHR PMIN PVEC_start PVEC_end PVEC_sequence \\\n", "0 0.402028 4.533213 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 0.327583 4.869907 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 0.16408 5.135553 5.269090 5.135555 (5.26909, 5.135555) \n", "3 0.377303 5.26909 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 0.353951 5.575968 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " PVECMAX_INST_start PVECMAX_INST_end PVECMAX_INST_sequence \\\n", "0 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 5.269090 5.135555 (5.26909, 5.135555) \n", "3 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " PVECMIN_INST_start PVECMIN_INST_end PVECMIN_INST_sequence \\\n", "0 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 5.269090 5.135555 (5.26909, 5.135555) \n", "3 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " QMAV QMI QMK RHOI RHOK RHOVEC_start RHOVEC_end \\\n", "0 -3719.409 -3719.409 -3719.409 865.2 865.2 865.2 865.2 \n", "1 -3719.409 -3719.409 -3719.409 865.2 865.2 865.2 865.2 \n", "2 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "3 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "4 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "\n", " RHOVEC_sequence SVEC_start SVEC_end SVEC_sequence \\\n", "0 (865.2, 865.2, 865.2) 0.0 15.351700 (0.0, 7.67585, 15.3517) \n", "1 (865.2, 865.2, 865.2) 0.0 12.508950 (0.0, 6.254475, 12.50895) \n", "2 (865.2, 865.2) 0.0 6.265505 (0.0, 6.265505) \n", "3 (865.2, 865.2, 865.2) 0.0 14.407540 (0.0, 7.20377, 14.40754) \n", "4 (865.2, 865.2, 865.2) 0.0 13.515840 (0.0, 6.75792, 13.51584) \n", "\n", " TI TK TTRVEC_start TTRVEC_end \\\n", "0 662.6788 662.6799 0.020268 0.019906 \n", "1 662.6799 662.6807 0.019906 0.019612 \n", "2 662.6812 662.6807 0.019464 0.019612 \n", "3 662.6822 662.6812 0.019125 0.019464 \n", "4 662.6832 662.6822 0.018807 0.019125 \n", "\n", " TTRVEC_sequence TVEC_start TVEC_end \\\n", "0 (0.02026793, 0.02008715, 0.01990638) 662.6787 662.6798 \n", "1 (0.01990638, 0.01975908, 0.01961179) 662.6798 662.6808 \n", "2 (0.01946423, 0.01961179) 662.6812 662.6808 \n", "3 (0.01912492, 0.01929457, 0.01946423) 662.6823 662.6812 \n", "4 (0.01880661, 0.01896576, 0.01912492) 662.6831 662.6823 \n", "\n", " TVEC_sequence VAV VI VK VOLDA WVL \\\n", "0 (662.6787, 662.6793, 662.6798) -12.72968 -12.72968 -12.72968 0.0 0.0 \n", "1 (662.6798, 662.6803, 662.6808) -12.72968 -12.72968 -12.72968 0.0 0.0 \n", "2 (662.6812, 662.6808) 12.72968 12.72968 12.72968 0.0 0.0 \n", "3 (662.6823, 662.6816, 662.6812) 12.72968 12.72968 12.72968 0.0 0.0 \n", "4 (662.6831, 662.6826, 662.6823) 12.72968 12.72968 12.72968 0.0 0.0 \n", "\n", " ZVEC_start ZVEC_end ZVEC_sequence l_sum AGSN_Lfdnr \\\n", "0 541.43 542.20 (541.43, 541.815, 542.2) 15.351701 1 \n", "1 542.20 542.93 (542.2, 542.565, 542.93) 27.860648 1 \n", "2 543.29 542.93 (543.29, 542.93) 34.126153 1 \n", "3 544.12 543.29 (544.12, 543.705, 543.29) 48.533695 1 \n", "4 544.60 544.12 (544.6, 544.36, 544.12) 62.049538 1 \n", "\n", " AGSN_Name \n", "0 Längsschnitt \n", "1 Längsschnitt \n", "2 Längsschnitt \n", "3 Längsschnitt \n", "4 Längsschnitt " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[0][1].head() # Lfdnr 1 RL" ] }, { "cell_type": "code", "execution_count": 14, "id": "d7e59196", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tkNameFkdtroRowdFkltgrFkstrasseLLzuRauJlambsLambda0ZeinZausZumlAsollIndschallBaujahrHalFkcontFk2lrohrBeschreibungIdreferenzIplanungKvrLineWidthMMDottedLineDNDiKvrKlartextHasClosedNSCHsTkPkInVariantXkorYkorGeometriesDifferbz.Fkbz.Qsvbbz.Irtrennbz.Leckstatusbz.Leckstartbz.Leckendbz.Leckortbz.Leckmengebz.Imptnzbz.Zvlimptnzbz.Kantenzvbz.ITrennWithNSCHgeometryfkKIfkKKADTTRDWVERLDWVERLABSIAKTIVIRTRENNJVMVEC_startMVEC_endMVEC_sequencePDAMPFPHRPMINPVEC_startPVEC_endPVEC_sequencePVECMAX_INST_startPVECMAX_INST_endPVECMAX_INST_sequencePVECMIN_INST_startPVECMIN_INST_endPVECMIN_INST_sequenceQMAVQMIQMKRHOIRHOKRHOVEC_startRHOVEC_endRHOVEC_sequenceSVEC_startSVEC_endSVEC_sequenceTITKTTRVEC_startTTRVEC_endTTRVEC_sequenceTVEC_startTVEC_endTVEC_sequenceVAVVIVKVOLDAWVLZVEC_startZVEC_endZVEC_sequencel_sumAGSN_LfdnrAGSN_Name
05691533564979419761Rohr V-E0 V-K1683S48165111674553109734779752876656844188520482933228154734615.35170000.051000010000050291288749724631185025945677694931826OSM: Knoten 476971238 -> Knoten 299394923; Län...39785520010.0050350345.6Vorlauf56915335649794197615691533564979419761False713619.9213835.578219e+06False569153356497941976100000000000LINESTRING (713619.921 5578218.954, 713614.649...539810069428410477948253915804674840320.00.000362352.09465.4052510.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.402028-55.93392-55.46401-55.93392(-55.46401, -55.69896, -55.93392)-55.46401-55.93392(-55.46401, -55.69896, -55.93392)-55.46401-55.93392(-55.46401, -55.69896, -55.93392)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.015.351700(0.0, 7.67585, 15.3517)666.0665.99890.0000000.000362(0.0, 0.0001807726, 0.0003615452)666.0000665.9989(666.0, 665.9995, 665.9989)12.7296812.7296812.729680.015415.81541.49542.29(541.49, 541.89, 542.29)15.3517012Längsschnitt in mlc
15048873293262650113Rohr V-K1683S V-K1693S48165111674553109734779752876656844188520482933228154734612.50895000.051000010000050291288749724631185216742060270992761OSM: Knoten 299394923 -> Knoten 4105649557; Lä...39785520010.0050350345.6Vorlauf50488732932626501135048873293262650113False713614.6487125.578233e+06False504887329326265011300000000000LINESTRING (713614.649 5578233.372, 713614.465...482539158046748403251806177803628615930.00.000295345.68854.3242010.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.327583-56.3209-55.93392-56.32089(-55.93392, -56.12741, -56.32089)-55.93392-56.32089(-55.93392, -56.12741, -56.32089)-55.93392-56.32089(-55.93392, -56.12741, -56.32089)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.012.508950(0.0, 6.254475, 12.50895)665.9989665.9980.0003620.000656(0.0003615452, 0.0005088433, 0.0006561414)665.9989665.9980(665.9989, 665.9985, 665.998)12.7296812.7296812.729680.015405.72542.29542.99(542.29, 542.64, 542.99)27.8606482Längsschnitt in mlc
25715081934973525403Rohr V-K2163S V-K1693S4816511167455310973477975287665684418852048293322815473466.26550500.051000010000050291288749724631184919359344392474301OSM: Knoten 299394922 -> Knoten 4105649557; Lä...595926249010.0050350345.6Vorlauf57150819349735254035715081934973525403False713614.3690435.578252e+06False571508193497352540300000000000LINESTRING (713614.369 5578252.145, 713614.465...496492048704118354551806177803628615930.00.000148345.082.16210.00.026.18786-1033.169-1033.169(-1033.169, -1033.169)15.54880.16408-56.51383-56.51382-56.32089(-56.51382, -56.32089)-56.51382-56.32089(-56.51382, -56.32089)-56.51382-56.32089(-56.51382, -56.32089)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2)0.06.265505(0.0, 6.265505)665.9976665.9980.0008040.000656(0.0008036994, 0.0006561416)665.9976665.9980(665.9976, 665.998)-12.72968-12.72968-12.729680.0-15397.65543.33542.99(543.33, 542.99)34.1261532Längsschnitt in mlc
35413647981880727734Rohr V-K2043S V-K2163S48165111674553109734779752876656844188520482933228154734614.40754000.051000010000050291288749724631185299861566239260044OSM: Knoten 299394921 -> Knoten 299394922; Län...595926249010.0050350345.6Vorlauf54136479818807277345413647981880727734False713616.8836495.578266e+06False541364798188072773400000000000LINESTRING (713616.884 5578266.331, 713614.369...479401623113754896749649204870411835450.00.000339375.16825.4052510.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.377303-56.95052-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-56.95052-56.51382(-56.95052, -56.73217, -56.51382)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.014.407540(0.0, 7.20377, 14.40754)665.9966665.99760.0011430.000804(0.001143009, 0.0009733541, 0.0008036994)665.9966665.9976(665.9966, 665.9971, 665.9976)-12.72968-12.72968-12.729680.0-15393.61544.03543.33(544.03, 543.6801, 543.33)48.5336952Längsschnitt in mlc
45134010500800575790Rohr V-K2033S V-K2043S48165111674553109734779752876656844188520482933228154734613.51584000.051000010000050291288749724631185204837016964086891OSM: Knoten 4105649561 -> Knoten 299394921; Lä...408665320010.0050350345.6Vorlauf51340105008005757905134010500800575790False713614.2386955.578280e+06False513401050080057579000000000000LINESTRING (713614.239 5578279.586, 713616.884...547312312597901032547940162311375489670.00.000318359.92774.8647260.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.353951-57.34774-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-57.34774-56.95052(-57.34774, -57.14913, -56.95052)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.013.515840(0.0, 6.75792, 13.51584)665.9956665.99660.0014610.001143(0.001461318, 0.001302163, 0.001143009)665.9956665.9966(665.9956, 665.9961, 665.9966)-12.72968-12.72968-12.729680.0-15384.03544.54544.03(544.54, 544.285, 544.03)62.0495382Längsschnitt in mlc
\n", "
" ], "text/plain": [ " tk Name FkdtroRowd \\\n", "0 5691533564979419761 Rohr V-E0 V-K1683S 4816511167455310973 \n", "1 5048873293262650113 Rohr V-K1683S V-K1693S 4816511167455310973 \n", "2 5715081934973525403 Rohr V-K2163S V-K1693S 4816511167455310973 \n", "3 5413647981880727734 Rohr V-K2043S V-K2163S 4816511167455310973 \n", "4 5134010500800575790 Rohr V-K2033S V-K2043S 4816511167455310973 \n", "\n", " Fkltgr Fkstrasse L Lzu Rau Jlambs \\\n", "0 4779752876656844188 5204829332281547346 15.351700 0 0.05 1 \n", "1 4779752876656844188 5204829332281547346 12.508950 0 0.05 1 \n", "2 4779752876656844188 5204829332281547346 6.265505 0 0.05 1 \n", "3 4779752876656844188 5204829332281547346 14.407540 0 0.05 1 \n", "4 4779752876656844188 5204829332281547346 13.515840 0 0.05 1 \n", "\n", " Lambda0 Zein Zaus Zuml Asoll Indschall Baujahr Hal \\\n", "0 0 0 0 0 1000 0 0 \n", "1 0 0 0 0 1000 0 0 \n", "2 0 0 0 0 1000 0 0 \n", "3 0 0 0 0 1000 0 0 \n", "4 0 0 0 0 1000 0 0 \n", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5025945677694931826 \n", "1 5029128874972463118 5216742060270992761 \n", "2 5029128874972463118 4919359344392474301 \n", "3 5029128874972463118 5299861566239260044 \n", "4 5029128874972463118 5204837016964086891 \n", "\n", " Beschreibung Idreferenz Iplanung \\\n", "0 OSM: Knoten 476971238 -> Knoten 299394923; Län... 39785520 0 \n", "1 OSM: Knoten 299394923 -> Knoten 4105649557; Lä... 39785520 0 \n", "2 OSM: Knoten 299394922 -> Knoten 4105649557; Lä... 595926249 0 \n", "3 OSM: Knoten 299394921 -> Knoten 299394922; Län... 595926249 0 \n", "4 OSM: Knoten 4105649561 -> Knoten 299394921; Lä... 408665320 0 \n", "\n", " Kvr LineWidthMM DottedLine DN Di KvrKlartext HasClosedNSCHs \\\n", "0 1 0.005 0 350 345.6 Vorlauf \n", "1 1 0.005 0 350 345.6 Vorlauf \n", "2 1 0.005 0 350 345.6 Vorlauf \n", "3 1 0.005 0 350 345.6 Vorlauf \n", "4 1 0.005 0 350 345.6 Vorlauf \n", "\n", " Tk Pk InVariant Xkor \\\n", "0 5691533564979419761 5691533564979419761 False 713619.921383 \n", "1 5048873293262650113 5048873293262650113 False 713614.648712 \n", "2 5715081934973525403 5715081934973525403 False 713614.369043 \n", "3 5413647981880727734 5413647981880727734 False 713616.883649 \n", "4 5134010500800575790 5134010500800575790 False 713614.238695 \n", "\n", " Ykor GeometriesDiffer bz.Fk bz.Qsvb bz.Irtrenn \\\n", "0 5.578219e+06 False 5691533564979419761 0 0 \n", "1 5.578233e+06 False 5048873293262650113 0 0 \n", "2 5.578252e+06 False 5715081934973525403 0 0 \n", "3 5.578266e+06 False 5413647981880727734 0 0 \n", "4 5.578280e+06 False 5134010500800575790 0 0 \n", "\n", " bz.Leckstatus bz.Leckstart bz.Leckend bz.Leckort bz.Leckmenge \\\n", "0 0 0 0 0 0 \n", "1 0 0 0 0 0 \n", "2 0 0 0 0 0 \n", "3 0 0 0 0 0 \n", "4 0 0 0 0 0 \n", "\n", " bz.Imptnz bz.Zvlimptnz bz.Kantenzv bz.ITrennWithNSCH \\\n", "0 0 0 0 0 \n", "1 0 0 0 0 \n", "2 0 0 0 0 \n", "3 0 0 0 0 \n", "4 0 0 0 0 \n", "\n", " geometry fkKI \\\n", "0 LINESTRING (713619.921 5578218.954, 713614.649... 5398100694284104779 \n", "1 LINESTRING (713614.649 5578233.372, 713614.465... 4825391580467484032 \n", "2 LINESTRING (713614.369 5578252.145, 713614.465... 4964920487041183545 \n", "3 LINESTRING (713616.884 5578266.331, 713614.369... 4794016231137548967 \n", "4 LINESTRING (713614.239 5578279.586, 713616.884... 5473123125979010325 \n", "\n", " fkKK A DTTR DWVERL DWVERLABS IAKTIV IRTRENN \\\n", "0 4825391580467484032 0.0 0.000362 352.0946 5.405251 0.0 0.0 \n", "1 5180617780362861593 0.0 0.000295 345.6885 4.324201 0.0 0.0 \n", "2 5180617780362861593 0.0 0.000148 345.08 2.1621 0.0 0.0 \n", "3 4964920487041183545 0.0 0.000339 375.1682 5.405251 0.0 0.0 \n", "4 4794016231137548967 0.0 0.000318 359.9277 4.864726 0.0 0.0 \n", "\n", " JV MVEC_start MVEC_end MVEC_sequence PDAMPF \\\n", "0 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "1 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "2 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169) 15.5488 \n", "3 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "4 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "\n", " PHR PMIN PVEC_start PVEC_end \\\n", "0 0.402028 -55.93392 -55.46401 -55.93392 \n", "1 0.327583 -56.3209 -55.93392 -56.32089 \n", "2 0.16408 -56.51383 -56.51382 -56.32089 \n", "3 0.377303 -56.95052 -56.95052 -56.51382 \n", "4 0.353951 -57.34774 -57.34774 -56.95052 \n", "\n", " PVEC_sequence PVECMAX_INST_start PVECMAX_INST_end \\\n", "0 (-55.46401, -55.69896, -55.93392) -55.46401 -55.93392 \n", "1 (-55.93392, -56.12741, -56.32089) -55.93392 -56.32089 \n", "2 (-56.51382, -56.32089) -56.51382 -56.32089 \n", "3 (-56.95052, -56.73217, -56.51382) -56.95052 -56.51382 \n", "4 (-57.34774, -57.14913, -56.95052) -57.34774 -56.95052 \n", "\n", " PVECMAX_INST_sequence PVECMIN_INST_start PVECMIN_INST_end \\\n", "0 (-55.46401, -55.69896, -55.93392) -55.46401 -55.93392 \n", "1 (-55.93392, -56.12741, -56.32089) -55.93392 -56.32089 \n", "2 (-56.51382, -56.32089) -56.51382 -56.32089 \n", "3 (-56.95052, -56.73217, -56.51382) -56.95052 -56.51382 \n", "4 (-57.34774, -57.14913, -56.95052) -57.34774 -56.95052 \n", "\n", " PVECMIN_INST_sequence QMAV QMI QMK RHOI \\\n", "0 (-55.46401, -55.69896, -55.93392) 3719.409 3719.409 3719.409 865.2 \n", "1 (-55.93392, -56.12741, -56.32089) 3719.409 3719.409 3719.409 865.2 \n", "2 (-56.51382, -56.32089) -3719.409 -3719.409 -3719.409 865.2 \n", "3 (-56.95052, -56.73217, -56.51382) -3719.409 -3719.409 -3719.409 865.2 \n", "4 (-57.34774, -57.14913, -56.95052) -3719.409 -3719.409 -3719.409 865.2 \n", "\n", " RHOK RHOVEC_start RHOVEC_end RHOVEC_sequence SVEC_start \\\n", "0 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "1 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "2 865.2 865.2 865.2 (865.2, 865.2) 0.0 \n", "3 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "4 865.2 865.2 865.2 (865.2, 865.2, 865.2) 0.0 \n", "\n", " SVEC_end SVEC_sequence TI TK TTRVEC_start \\\n", "0 15.351700 (0.0, 7.67585, 15.3517) 666.0 665.9989 0.000000 \n", "1 12.508950 (0.0, 6.254475, 12.50895) 665.9989 665.998 0.000362 \n", "2 6.265505 (0.0, 6.265505) 665.9976 665.998 0.000804 \n", "3 14.407540 (0.0, 7.20377, 14.40754) 665.9966 665.9976 0.001143 \n", "4 13.515840 (0.0, 6.75792, 13.51584) 665.9956 665.9966 0.001461 \n", "\n", " TTRVEC_end TTRVEC_sequence TVEC_start \\\n", "0 0.000362 (0.0, 0.0001807726, 0.0003615452) 666.0000 \n", "1 0.000656 (0.0003615452, 0.0005088433, 0.0006561414) 665.9989 \n", "2 0.000656 (0.0008036994, 0.0006561416) 665.9976 \n", "3 0.000804 (0.001143009, 0.0009733541, 0.0008036994) 665.9966 \n", "4 0.001143 (0.001461318, 0.001302163, 0.001143009) 665.9956 \n", "\n", " TVEC_end TVEC_sequence VAV VI VK \\\n", "0 665.9989 (666.0, 665.9995, 665.9989) 12.72968 12.72968 12.72968 \n", "1 665.9980 (665.9989, 665.9985, 665.998) 12.72968 12.72968 12.72968 \n", "2 665.9980 (665.9976, 665.998) -12.72968 -12.72968 -12.72968 \n", "3 665.9976 (665.9966, 665.9971, 665.9976) -12.72968 -12.72968 -12.72968 \n", "4 665.9966 (665.9956, 665.9961, 665.9966) -12.72968 -12.72968 -12.72968 \n", "\n", " VOLDA WVL ZVEC_start ZVEC_end ZVEC_sequence \\\n", "0 0.0 15415.81 541.49 542.29 (541.49, 541.89, 542.29) \n", "1 0.0 15405.72 542.29 542.99 (542.29, 542.64, 542.99) \n", "2 0.0 -15397.65 543.33 542.99 (543.33, 542.99) \n", "3 0.0 -15393.61 544.03 543.33 (544.03, 543.6801, 543.33) \n", "4 0.0 -15384.03 544.54 544.03 (544.54, 544.285, 544.03) \n", "\n", " l_sum AGSN_Lfdnr AGSN_Name \n", "0 15.351701 2 Längsschnitt in mlc \n", "1 27.860648 2 Längsschnitt in mlc \n", "2 34.126153 2 Längsschnitt in mlc \n", "3 48.533695 2 Längsschnitt in mlc \n", "4 62.049538 2 Längsschnitt in mlc " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[1][0].head() # Lfdnr 2 VL" ] }, { "cell_type": "code", "execution_count": 15, "id": "3b215f64", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tkNameFkdtroRowdFkltgrFkstrasseLLzuRauJlambsLambda0ZeinZausZumlAsollIndschallBaujahrHalFkcontFk2lrohrBeschreibungIdreferenzIplanungKvrLineWidthMMDottedLineDNDiKvrKlartextHasClosedNSCHsTkPkInVariantXkorYkorGeometriesDifferbz.Fkbz.Qsvbbz.Irtrennbz.Leckstatusbz.Leckstartbz.Leckendbz.Leckortbz.Leckmengebz.Imptnzbz.Zvlimptnzbz.Kantenzvbz.ITrennWithNSCHgeometryfkKIfkKKADTTRDWVERLDWVERLABSIAKTIVIRTRENNJVMVEC_startMVEC_endMVEC_sequencePDAMPFPHRPMINPVEC_startPVEC_endPVEC_sequencePVECMAX_INST_startPVECMAX_INST_endPVECMAX_INST_sequencePVECMIN_INST_startPVECMIN_INST_endPVECMIN_INST_sequenceQMAVQMIQMKRHOIRHOKRHOVEC_startRHOVEC_endRHOVEC_sequenceSVEC_startSVEC_endSVEC_sequenceTITKTTRVEC_startTTRVEC_endTTRVEC_sequenceTVEC_startTVEC_endTVEC_sequenceVAVVIVKVOLDAWVLZVEC_startZVEC_endZVEC_sequencel_sumAGSN_LfdnrAGSN_Name
05025945677694931826Rohr R-E0 R-K4163S48165111674553109734779752876656844188520482933228154734615.35170000.051000010000050291288749724631185691533564979419761OSM: Knoten 476971238 -> Knoten 299394923; Län...39785520020.0050350345.6Rücklauf50259456776949318265025945677694931826False713621.9213835.578219e+06False502594567769493182600000000000LINESTRING (713621.921 5578218.954, 713616.649...516085064877967489848516784769550846370.00.000362352.09465.4052510.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.4020284.5332134.5332154.869910(4.533215, 4.70156, 4.86991)4.5332154.869910(4.533215, 4.70156, 4.86991)4.5332154.869910(4.533215, 4.70156, 4.86991)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.015.351700(0.0, 7.67585, 15.3517)662.6788662.67990.0202680.019906(0.02026793, 0.02008715, 0.01990638)662.6787662.6798(662.6787, 662.6793, 662.6798)-12.72968-12.72968-12.729680.00.0541.43542.20(541.43, 541.815, 542.2)15.3517012Längsschnitt in mlc
15216742060270992761Rohr R-K4163S R-K4173S48165111674553109734779752876656844188520482933228154734612.50895000.051000010000050291288749724631185048873293262650113OSM: Knoten 299394923 -> Knoten 4105649557; Lä...39785520020.0050350345.6Rücklauf52167420602709927615216742060270992761False713616.6487125.578233e+06False521674206027099276100000000000LINESTRING (713616.649 5578233.372, 713616.465...485167847695508463754697539850219875700.00.000295345.68854.3242010.00.026.18786-1033.169-1033.169(-1033.169, -1033.169, -1033.169)15.54880.3275834.8699074.8699105.135555(4.86991, 5.00273, 5.135555)4.8699105.135555(4.86991, 5.00273, 5.135555)4.8699105.135555(4.86991, 5.00273, 5.135555)-3719.409-3719.409-3719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.012.508950(0.0, 6.254475, 12.50895)662.6799662.68070.0199060.019612(0.01990638, 0.01975908, 0.01961179)662.6798662.6808(662.6798, 662.6803, 662.6808)-12.72968-12.72968-12.729680.00.0542.20542.93(542.2, 542.565, 542.93)27.8606482Längsschnitt in mlc
24919359344392474301Rohr R-K4643S R-K4173S4816511167455310973477975287665684418852048293322815473466.26550500.051000010000050291288749724631185715081934973525403OSM: Knoten 299394922 -> Knoten 4105649557; Lä...595926249020.0050350345.6Rücklauf49193593443924743014919359344392474301False713616.3690435.578252e+06False491935934439247430100000000000LINESTRING (713616.369 5578252.145, 713616.465...520760333857826416954697539850219875700.00.000148345.082.16210.00.026.187861033.1691033.169(1033.169, 1033.169)15.54880.164085.1355535.2690905.135555(5.26909, 5.135555)5.2690905.135555(5.26909, 5.135555)5.2690905.135555(5.26909, 5.135555)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2)0.06.265505(0.0, 6.265505)662.6812662.68070.0194640.019612(0.01946423, 0.01961179)662.6812662.6808(662.6812, 662.6808)12.7296812.7296812.729680.00.0543.29542.93(543.29, 542.93)34.1261532Längsschnitt in mlc
35299861566239260044Rohr R-K4523S R-K4643S48165111674553109734779752876656844188520482933228154734614.40754000.051000010000050291288749724631185413647981880727734OSM: Knoten 299394921 -> Knoten 299394922; Län...595926249020.0050350345.6Rücklauf52998615662392600445299861566239260044False713618.8836495.578266e+06False529986156623926004400000000000LINESTRING (713618.884 5578266.331, 713616.369...519145742106837807452076033385782641690.00.000339337.65144.8647260.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.3773035.269095.5759705.269090(5.57597, 5.42253, 5.26909)5.5759705.269090(5.57597, 5.42253, 5.26909)5.5759705.269090(5.57597, 5.42253, 5.26909)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.014.407540(0.0, 7.20377, 14.40754)662.6822662.68120.0191250.019464(0.01912492, 0.01929457, 0.01946423)662.6823662.6812(662.6823, 662.6816, 662.6812)12.7296812.7296812.729680.00.0544.12543.29(544.12, 543.705, 543.29)48.5336952Längsschnitt in mlc
45204837016964086891Rohr R-K4513S R-K4523S48165111674553109734779752876656844188520482933228154734613.51584000.051000010000050291288749724631185134010500800575790OSM: Knoten 4105649561 -> Knoten 299394921; Lä...408665320020.0050350345.6Rücklauf52048370169640868915204837016964086891False713616.2386955.578280e+06False520483701696408689100000000000LINESTRING (713616.239 5578279.586, 713618.884...487505482594136127451914574210683780740.00.000318359.92774.8647260.00.026.187861033.1691033.169(1033.169, 1033.169, 1033.169)15.54880.3539515.5759685.8891955.575970(5.889195, 5.73258, 5.57597)5.8891955.575970(5.889195, 5.73258, 5.57597)5.8891955.575970(5.889195, 5.73258, 5.57597)3719.4093719.4093719.409865.2865.2865.2865.2(865.2, 865.2, 865.2)0.013.515840(0.0, 6.75792, 13.51584)662.6832662.68220.0188070.019125(0.01880661, 0.01896576, 0.01912492)662.6831662.6823(662.6831, 662.6826, 662.6823)12.7296812.7296812.729680.00.0544.60544.12(544.6, 544.36, 544.12)62.0495382Längsschnitt in mlc
\n", "
" ], "text/plain": [ " tk Name FkdtroRowd \\\n", "0 5025945677694931826 Rohr R-E0 R-K4163S 4816511167455310973 \n", "1 5216742060270992761 Rohr R-K4163S R-K4173S 4816511167455310973 \n", "2 4919359344392474301 Rohr R-K4643S R-K4173S 4816511167455310973 \n", "3 5299861566239260044 Rohr R-K4523S R-K4643S 4816511167455310973 \n", "4 5204837016964086891 Rohr R-K4513S R-K4523S 4816511167455310973 \n", "\n", " Fkltgr Fkstrasse L Lzu Rau Jlambs \\\n", "0 4779752876656844188 5204829332281547346 15.351700 0 0.05 1 \n", "1 4779752876656844188 5204829332281547346 12.508950 0 0.05 1 \n", "2 4779752876656844188 5204829332281547346 6.265505 0 0.05 1 \n", "3 4779752876656844188 5204829332281547346 14.407540 0 0.05 1 \n", "4 4779752876656844188 5204829332281547346 13.515840 0 0.05 1 \n", "\n", " Lambda0 Zein Zaus Zuml Asoll Indschall Baujahr Hal \\\n", "0 0 0 0 0 1000 0 0 \n", "1 0 0 0 0 1000 0 0 \n", "2 0 0 0 0 1000 0 0 \n", "3 0 0 0 0 1000 0 0 \n", "4 0 0 0 0 1000 0 0 \n", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5691533564979419761 \n", "1 5029128874972463118 5048873293262650113 \n", "2 5029128874972463118 5715081934973525403 \n", "3 5029128874972463118 5413647981880727734 \n", "4 5029128874972463118 5134010500800575790 \n", "\n", " Beschreibung Idreferenz Iplanung \\\n", "0 OSM: Knoten 476971238 -> Knoten 299394923; Län... 39785520 0 \n", "1 OSM: Knoten 299394923 -> Knoten 4105649557; Lä... 39785520 0 \n", "2 OSM: Knoten 299394922 -> Knoten 4105649557; Lä... 595926249 0 \n", "3 OSM: Knoten 299394921 -> Knoten 299394922; Län... 595926249 0 \n", "4 OSM: Knoten 4105649561 -> Knoten 299394921; Lä... 408665320 0 \n", "\n", " Kvr LineWidthMM DottedLine DN Di KvrKlartext HasClosedNSCHs \\\n", "0 2 0.005 0 350 345.6 Rücklauf \n", "1 2 0.005 0 350 345.6 Rücklauf \n", "2 2 0.005 0 350 345.6 Rücklauf \n", "3 2 0.005 0 350 345.6 Rücklauf \n", "4 2 0.005 0 350 345.6 Rücklauf \n", "\n", " Tk Pk InVariant Xkor \\\n", "0 5025945677694931826 5025945677694931826 False 713621.921383 \n", "1 5216742060270992761 5216742060270992761 False 713616.648712 \n", "2 4919359344392474301 4919359344392474301 False 713616.369043 \n", "3 5299861566239260044 5299861566239260044 False 713618.883649 \n", "4 5204837016964086891 5204837016964086891 False 713616.238695 \n", "\n", " Ykor GeometriesDiffer bz.Fk bz.Qsvb bz.Irtrenn \\\n", "0 5.578219e+06 False 5025945677694931826 0 0 \n", "1 5.578233e+06 False 5216742060270992761 0 0 \n", "2 5.578252e+06 False 4919359344392474301 0 0 \n", "3 5.578266e+06 False 5299861566239260044 0 0 \n", "4 5.578280e+06 False 5204837016964086891 0 0 \n", "\n", " bz.Leckstatus bz.Leckstart bz.Leckend bz.Leckort bz.Leckmenge \\\n", "0 0 0 0 0 0 \n", "1 0 0 0 0 0 \n", "2 0 0 0 0 0 \n", "3 0 0 0 0 0 \n", "4 0 0 0 0 0 \n", "\n", " bz.Imptnz bz.Zvlimptnz bz.Kantenzv bz.ITrennWithNSCH \\\n", "0 0 0 0 0 \n", "1 0 0 0 0 \n", "2 0 0 0 0 \n", "3 0 0 0 0 \n", "4 0 0 0 0 \n", "\n", " geometry fkKI \\\n", "0 LINESTRING (713621.921 5578218.954, 713616.649... 5160850648779674898 \n", "1 LINESTRING (713616.649 5578233.372, 713616.465... 4851678476955084637 \n", "2 LINESTRING (713616.369 5578252.145, 713616.465... 5207603338578264169 \n", "3 LINESTRING (713618.884 5578266.331, 713616.369... 5191457421068378074 \n", "4 LINESTRING (713616.239 5578279.586, 713618.884... 4875054825941361274 \n", "\n", " fkKK A DTTR DWVERL DWVERLABS IAKTIV IRTRENN \\\n", "0 4851678476955084637 0.0 0.000362 352.0946 5.405251 0.0 0.0 \n", "1 5469753985021987570 0.0 0.000295 345.6885 4.324201 0.0 0.0 \n", "2 5469753985021987570 0.0 0.000148 345.08 2.1621 0.0 0.0 \n", "3 5207603338578264169 0.0 0.000339 337.6514 4.864726 0.0 0.0 \n", "4 5191457421068378074 0.0 0.000318 359.9277 4.864726 0.0 0.0 \n", "\n", " JV MVEC_start MVEC_end MVEC_sequence PDAMPF \\\n", "0 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "1 26.18786 -1033.169 -1033.169 (-1033.169, -1033.169, -1033.169) 15.5488 \n", "2 26.18786 1033.169 1033.169 (1033.169, 1033.169) 15.5488 \n", "3 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "4 26.18786 1033.169 1033.169 (1033.169, 1033.169, 1033.169) 15.5488 \n", "\n", " PHR PMIN PVEC_start PVEC_end PVEC_sequence \\\n", "0 0.402028 4.533213 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 0.327583 4.869907 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 0.16408 5.135553 5.269090 5.135555 (5.26909, 5.135555) \n", "3 0.377303 5.26909 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 0.353951 5.575968 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " PVECMAX_INST_start PVECMAX_INST_end PVECMAX_INST_sequence \\\n", "0 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 5.269090 5.135555 (5.26909, 5.135555) \n", "3 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " PVECMIN_INST_start PVECMIN_INST_end PVECMIN_INST_sequence \\\n", "0 4.533215 4.869910 (4.533215, 4.70156, 4.86991) \n", "1 4.869910 5.135555 (4.86991, 5.00273, 5.135555) \n", "2 5.269090 5.135555 (5.26909, 5.135555) \n", "3 5.575970 5.269090 (5.57597, 5.42253, 5.26909) \n", "4 5.889195 5.575970 (5.889195, 5.73258, 5.57597) \n", "\n", " QMAV QMI QMK RHOI RHOK RHOVEC_start RHOVEC_end \\\n", "0 -3719.409 -3719.409 -3719.409 865.2 865.2 865.2 865.2 \n", "1 -3719.409 -3719.409 -3719.409 865.2 865.2 865.2 865.2 \n", "2 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "3 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "4 3719.409 3719.409 3719.409 865.2 865.2 865.2 865.2 \n", "\n", " RHOVEC_sequence SVEC_start SVEC_end SVEC_sequence \\\n", "0 (865.2, 865.2, 865.2) 0.0 15.351700 (0.0, 7.67585, 15.3517) \n", "1 (865.2, 865.2, 865.2) 0.0 12.508950 (0.0, 6.254475, 12.50895) \n", "2 (865.2, 865.2) 0.0 6.265505 (0.0, 6.265505) \n", "3 (865.2, 865.2, 865.2) 0.0 14.407540 (0.0, 7.20377, 14.40754) \n", "4 (865.2, 865.2, 865.2) 0.0 13.515840 (0.0, 6.75792, 13.51584) \n", "\n", " TI TK TTRVEC_start TTRVEC_end \\\n", "0 662.6788 662.6799 0.020268 0.019906 \n", "1 662.6799 662.6807 0.019906 0.019612 \n", "2 662.6812 662.6807 0.019464 0.019612 \n", "3 662.6822 662.6812 0.019125 0.019464 \n", "4 662.6832 662.6822 0.018807 0.019125 \n", "\n", " TTRVEC_sequence TVEC_start TVEC_end \\\n", "0 (0.02026793, 0.02008715, 0.01990638) 662.6787 662.6798 \n", "1 (0.01990638, 0.01975908, 0.01961179) 662.6798 662.6808 \n", "2 (0.01946423, 0.01961179) 662.6812 662.6808 \n", "3 (0.01912492, 0.01929457, 0.01946423) 662.6823 662.6812 \n", "4 (0.01880661, 0.01896576, 0.01912492) 662.6831 662.6823 \n", "\n", " TVEC_sequence VAV VI VK VOLDA WVL \\\n", "0 (662.6787, 662.6793, 662.6798) -12.72968 -12.72968 -12.72968 0.0 0.0 \n", "1 (662.6798, 662.6803, 662.6808) -12.72968 -12.72968 -12.72968 0.0 0.0 \n", "2 (662.6812, 662.6808) 12.72968 12.72968 12.72968 0.0 0.0 \n", "3 (662.6823, 662.6816, 662.6812) 12.72968 12.72968 12.72968 0.0 0.0 \n", "4 (662.6831, 662.6826, 662.6823) 12.72968 12.72968 12.72968 0.0 0.0 \n", "\n", " ZVEC_start ZVEC_end ZVEC_sequence l_sum AGSN_Lfdnr \\\n", "0 541.43 542.20 (541.43, 541.815, 542.2) 15.351701 2 \n", "1 542.20 542.93 (542.2, 542.565, 542.93) 27.860648 2 \n", "2 543.29 542.93 (543.29, 542.93) 34.126153 2 \n", "3 544.12 543.29 (544.12, 543.705, 543.29) 48.533695 2 \n", "4 544.60 544.12 (544.6, 544.36, 544.12) 62.049538 2 \n", "\n", " AGSN_Name \n", "0 Längsschnitt in mlc \n", "1 Längsschnitt in mlc \n", "2 Längsschnitt in mlc \n", "3 Längsschnitt in mlc \n", "4 Längsschnitt in mlc " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[1][1].head() # Lfdnr 2 RL" ] }, { "cell_type": "markdown", "id": "99262e9b", "metadata": {}, "source": [ "## Edge dataframe" ] }, { "cell_type": "markdown", "id": "03bb371a", "metadata": {}, "source": [ "Can be used to create user-defined graphs." ] }, { "cell_type": "markdown", "id": "b868fb8d", "metadata": {}, "source": [ "[generate_edge_dataframe()](https://3sconsult.github.io/sir3stoolkit/references/sir3stoolkit.mantle.html#sir3stoolkit.mantle.dataframes.SIR3S_Model_Dataframes.generate_edge_dataframe)" ] }, { "cell_type": "code", "execution_count": 16, "id": "ee8eb2be", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "[2026-03-03 15:33:16,246] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-03 15:33:16,252] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-03 15:33:16,258] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:16,259] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:17,472] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:17,799] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:17,804] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (524, 6)\n", "[2026-03-03 15:33:17,809] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Valve\n", "[2026-03-03 15:33:17,815] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 12 element(s) of element type ObjectTypes.Valve.\n", "[2026-03-03 15:33:17,826] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:17,829] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:18,834] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:18,923] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:18,927] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (12, 6)\n", "[2026-03-03 15:33:18,936] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.FlapValve\n", "[2026-03-03 15:33:18,947] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.FlapValve.\n", "[2026-03-03 15:33:18,955] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:18,959] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:19,030] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:19,117] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:19,118] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 6)\n", "[2026-03-03 15:33:19,128] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pump\n", "[2026-03-03 15:33:19,134] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 2 element(s) of element type ObjectTypes.Pump.\n", "[2026-03-03 15:33:19,145] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:19,149] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:19,575] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:19,616] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:19,619] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (2, 6)\n", "[2026-03-03 15:33:19,623] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingConsumer\n", "[2026-03-03 15:33:19,630] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 337 element(s) of element type ObjectTypes.DistrictHeatingConsumer.\n", "[2026-03-03 15:33:19,640] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:19,644] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:19,928] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:20,036] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:20,040] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (337, 6)\n", "[2026-03-03 15:33:20,047] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingFeeder\n", "[2026-03-03 15:33:20,051] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.DistrictHeatingFeeder.\n", "[2026-03-03 15:33:20,058] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:20,061] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:20,119] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-03 15:33:20,160] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:20,163] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 6)\n", "[2026-03-03 15:33:20,168] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.HeatExchanger\n", "[2026-03-03 15:33:20,174] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.HeatExchanger.\n", "[2026-03-03 15:33:20,180] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-03-03 15:33:20,184] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-03-03 15:33:20,290] INFO in sir3stoolkit.mantle.dataframes: [model_data] 4 non-empty end node columns were created.\n", "[2026-03-03 15:33:20,363] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-03 15:33:20,396] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 8)\n", "[2026-03-03 15:33:20,424] INFO in sir3stoolkit.mantle.dataframes: [edge dataframe] Retrieved 880 edges from 17 element types.\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tkFkcontgeometryfkKIfkKKelement typefkKI2fkKK2
054420102390907460075029128874972463118LINESTRING (713620.268 5578828.419, 713602.295...56693013606865113515397948523091900401PipeNaNNaN
149177863786390432965029128874972463118LINESTRING (713602.295 5578860.106, 713574.062...53979485230919004015239335112004772156PipeNaNNaN
247624823103820096335029128874972463118LINESTRING (713574.062 5578909.873, 713553.84 ...52393351120047721565298886695042021307PipeNaNNaN
349872295366430245235029128874972463118LINESTRING (713553.84 5578945.533, 713553.394 ...52988866950420213074993257270457791438PipeNaNNaN
457222066305038851185029128874972463118LINESTRING (713553.394 5578952.352, 713556.294...49932572704577914385317865645994989592PipeNaNNaN
\n", "
" ], "text/plain": [ " tk Fkcont \\\n", "0 5442010239090746007 5029128874972463118 \n", "1 4917786378639043296 5029128874972463118 \n", "2 4762482310382009633 5029128874972463118 \n", "3 4987229536643024523 5029128874972463118 \n", "4 5722206630503885118 5029128874972463118 \n", "\n", " geometry fkKI \\\n", "0 LINESTRING (713620.268 5578828.419, 713602.295... 5669301360686511351 \n", "1 LINESTRING (713602.295 5578860.106, 713574.062... 5397948523091900401 \n", "2 LINESTRING (713574.062 5578909.873, 713553.84 ... 5239335112004772156 \n", "3 LINESTRING (713553.84 5578945.533, 713553.394 ... 5298886695042021307 \n", "4 LINESTRING (713553.394 5578952.352, 713556.294... 4993257270457791438 \n", "\n", " fkKK element type fkKI2 fkKK2 \n", "0 5397948523091900401 Pipe NaN NaN \n", "1 5239335112004772156 Pipe NaN NaN \n", "2 5298886695042021307 Pipe NaN NaN \n", "3 4993257270457791438 Pipe NaN NaN \n", "4 5317865645994989592 Pipe NaN NaN " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "(s3s.generate_edge_dataframe()).head(5)" ] }, { "cell_type": "markdown", "id": "50b157ad", "metadata": {}, "source": [] } ], "metadata": { "kernelspec": { "display_name": "base", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.8" } }, "nbformat": 4, "nbformat_minor": 5 }