{ "cells": [ { "cell_type": "markdown", "id": "5556432f", "metadata": {}, "source": [ "# Tutorial 53: General 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": 2, "id": "79d0fb2c", "metadata": {}, "outputs": [], "source": [ "SIR3S_SIRGRAF_DIR = r\"C:\\3S\\SIR 3S\\SirGraf-90-15-00-20x64_Quebec-Upd1\" #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\"C:\\Users\\aUsername\\3S\\PT3S\\PT3S\\Examples\\Example3.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": "34cb086c", "metadata": {}, "source": [ "# Generate Non-Element Dataframes" ] }, { "cell_type": "markdown", "id": "91b1def2", "metadata": {}, "source": [ "## AGSN (Longitudinal Sections)" ] }, { "cell_type": "markdown", "id": "f61492a3", "metadata": {}, "source": [ "[generate_longitudinal_section_dataframes()](https://3sconsult.github.io/sir3stoolkit/references/sir3stoolkit.mantle.html#sir3stoolkit.mantle.dataframes.SIR3S_Model_Dataframes.generate_longitudinal_section_dataframes)" ] }, { "cell_type": "code", "execution_count": 10, "id": "05990293", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "[2026-01-23 14:24:01,319] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.AGSN_HydraulicProfile\n", "[2026-01-23 14:24:01,329] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.AGSN_HydraulicProfile.\n", "[2026-01-23 14:24:01,348] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.AGSN_HydraulicProfile.\n", "[2026-01-23 14:24:01,349] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 9 model_data properties.\n", "[2026-01-23 14:24:01,351] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Lfdnr', 'Aktiv', 'AllNodesAndLinks', 'ObjsString', 'MainWay', 'Tk', 'Pk', 'InVariant']...\n", "[2026-01-23 14:24:01,387] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 10)\n", "[2026-01-23 14:24:01,392] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 1.\n", "[2026-01-23 14:24:01,408] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:01,410] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:01,411] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:01,415] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:01,416] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:01,418] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:01,419] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:01,420] 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-01-23 14:24:02,069] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:02,169] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:02,180] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:02,181] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:02,288] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:02,376] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:02,377] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:02,380] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:02,381] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:02,384] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:02,422] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:03,681] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:03,686] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:03,707] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:03,707] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:03,707] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:03,714] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:03,716] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:03,718] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:03,720] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:03,722] 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-01-23 14:24:03,900] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:04,007] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:04,007] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:04,007] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:04,109] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:04,225] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:04,227] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:04,230] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:04,232] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:04,235] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:04,269] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:06,265] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:06,267] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:06,284] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 2.\n", "[2026-01-23 14:24:06,288] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:06,290] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:06,291] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:06,298] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:06,300] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:06,304] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:06,305] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:06,307] 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-01-23 14:24:06,550] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:06,688] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:06,690] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:06,692] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:06,800] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:06,919] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:06,919] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:06,923] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:06,924] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:06,927] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:06,964] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:08,158] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:08,158] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:08,169] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:08,169] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:08,169] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:08,178] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:08,179] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:08,181] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:08,183] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:08,183] 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-01-23 14:24:08,338] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:08,432] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:08,432] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:08,434] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:08,507] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:08,588] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:08,588] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:08,596] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:08,598] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:08,601] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:08,621] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:09,689] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:09,690] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:09,703] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 3.\n", "[2026-01-23 14:24:09,704] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:09,705] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:09,706] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:09,709] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:09,711] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:09,714] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:09,715] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:09,716] 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-01-23 14:24:09,871] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:09,961] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:09,961] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:09,966] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:10,046] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:10,121] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:10,121] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:10,125] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:10,126] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:10,129] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:10,156] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:11,163] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:11,167] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:11,171] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:11,171] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:11,179] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:11,183] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:11,185] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:11,187] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-01-23 14:24:11,188] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-01-23 14:24:11,189] 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-01-23 14:24:11,359] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:11,461] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:11,463] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n", "[2026-01-23 14:24:11,465] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n", "[2026-01-23 14:24:11,552] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:11,647] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-01-23 14:24:11,647] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-01-23 14:24:11,651] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:11,653] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n", "[2026-01-23 14:24:11,655] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-01-23 14:24:11,686] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-01-23 14:24:12,850] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n", "[2026-01-23 14:24:12,851] 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": 11, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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.ITrennWithNSCHgeometryfkKIfkKKAACALCCPICPKDHDPDRAGREDDRAKONZDSIDSKDTTRDWVERLDWVERLABSETAAVFSHRHVECIAKTIVIRTRENNJVJV2LAMBDALECKEINAUSLECKMENGELECKORTLINEPACKLINEPACKGEOMLINEPACKRATEMAINELEMENTMAVMIMKMKONDMMAX_INSTMMIN_INSTMVECMVECMAX_INSTMVECMIN_INSTPAVPDAMPFPHRPHVECPMAXPMINPRPVECPVECMAX_INSTPVECMIN_INSTQI2QK2QMAVQMIQMKQMMAX_INSTQMMIN_INSTQMVECQSVBRHOAVRHOIRHOKRHOVECSVECTAVTITKTTRVECTVECTVECMAX_INSTTVECMIN_INSTVAVVIVKVMAX_INSTVMIN_INSTVOLDAWALTERIWALTERKWVLZAUSZEINZHKNRZVECl_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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00484443.120160.66196899999.099999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.079.74765\\t79.74765\\t79.7476599999.099999.099999.00.7010740.00234599999.099999.05.80067999999.05.878785\\t5.83973\\t5.800685.878785\\t5.83973\\t5.800685.878785\\t5.83973\\t5.8006899999.099999.0287.0915287.0915287.091599999.099999.099999.099999.099999.0965.7965.7012965.7\\t965.7006\\t965.70120\\t7.67585\\t15.351799999.089.9999989.998020\\t0.002422066\\t0.00484413290\\t89.99902\\t89.9980299999.099999.00.8803150.8803150.88031499999.099999.00.099999.099999.010082.8899999.099999.099999.0541.49\\t541.89\\t542.2915.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00394743.580790.5451599999.099999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.079.74765\\t79.74765\\t79.7476599999.099999.099999.00.7010270.0019199999.099999.05.73247599999.05.80068\\t5.766575\\t5.7324755.80068\\t5.766575\\t5.7324755.80068\\t5.766575\\t5.73247599999.099999.0287.0915287.0915287.091599999.099999.099999.099999.099999.0965.7012965.7021965.7012\\t965.7017\\t965.70210\\t6.254475\\t12.5089599999.089.9980289.99640.004844132\\t0.006817694\\t0.00879125789.99802\\t89.99722\\t89.996499999.099999.00.8803140.8803140.88031399999.099999.00.099999.099999.010081.8199999.099999.099999.0542.29\\t542.64\\t542.9927.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00197743.504070.27257599999.099999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.0-79.74765\\t-79.7476599999.099999.099999.00.7009950.00095799999.099999.05.69931799999.05.699315\\t5.7324755.699315\\t5.7324755.699315\\t5.73247599999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.099999.0965.7026965.7021965.7026\\t965.70210\\t6.26550599999.089.995689.99640.0107683\\t0.00879125789.99561\\t89.996499999.099999.0-0.880313-0.880313-0.88031399999.099999.00.099999.099999.0-10080.9299999.099999.099999.0543.33\\t542.9934.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00454643.243230.62302899999.099999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.0-79.74765\\t-79.74765\\t-79.7476599999.099999.099999.00.700960.002299999.099999.05.63082399999.05.630825\\t5.66507\\t5.6993155.630825\\t5.66507\\t5.6993155.630825\\t5.66507\\t5.69931599999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.099999.0965.7037965.7026965.7037\\t965.7032\\t965.70260\\t7.20377\\t14.4075499999.089.9937489.99560.01531452\\t0.01304141\\t0.010768389.99374\\t89.99466\\t89.9956199999.099999.0-0.880312-0.880312-0.88031399999.099999.00.099999.099999.0-10080.4899999.099999.099999.0544.03\\t543.6801\\t543.3348.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00426542.494920.57435499999.099999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.0-79.74765\\t-79.74765\\t-79.7476599999.099999.099999.00.7009130.00206499999.099999.05.58046599999.05.580465\\t5.605645\\t5.6308255.580465\\t5.605645\\t5.6308255.580465\\t5.605645\\t5.63082599999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.099999.0965.7048965.7037965.7048\\t965.7043\\t965.70370\\t6.75792\\t13.5158499999.089.99289.993740.01957938\\t0.01744695\\t0.0153145289.992\\t89.99286\\t89.9937499999.099999.0-0.880312-0.880311-0.88031299999.099999.00.099999.099999.0-10079.4799999.099999.099999.0544.54\\t544.285\\t544.0362.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 ACALC CPI CPK DH DP \\\n", "0 4825391580467484032 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 5180617780362861593 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 5180617780362861593 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 4964920487041183545 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 4794016231137548967 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " DRAGRED DRAKONZ DSI DSK DTTR DWVERL DWVERLABS ETAAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 0.004844 43.12016 0.661968 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 0.003947 43.58079 0.54515 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 0.001977 43.50407 0.272575 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 0.004546 43.24323 0.623028 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 0.004265 42.49492 0.574354 99999.0 \n", "\n", " FS HR HVEC IAKTIV IRTRENN JV JV2 LAMBDA \\\n", "0 99999.0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 \n", "\n", " LECKEINAUS LECKMENGE LECKORT LINEPACK LINEPACKGEOM LINEPACKRATE \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MAINELEMENT MAV MI MK MKOND MMAX_INST MMIN_INST \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MVEC MVECMAX_INST MVECMIN_INST PAV \\\n", "0 79.74765\\t79.74765\\t79.74765 99999.0 99999.0 99999.0 \n", "1 79.74765\\t79.74765\\t79.74765 99999.0 99999.0 99999.0 \n", "2 -79.74765\\t-79.74765 99999.0 99999.0 99999.0 \n", "3 -79.74765\\t-79.74765\\t-79.74765 99999.0 99999.0 99999.0 \n", "4 -79.74765\\t-79.74765\\t-79.74765 99999.0 99999.0 99999.0 \n", "\n", " PDAMPF PHR PHVEC PMAX PMIN PR \\\n", "0 0.701074 0.002345 99999.0 99999.0 5.800679 99999.0 \n", "1 0.701027 0.00191 99999.0 99999.0 5.732475 99999.0 \n", "2 0.700995 0.000957 99999.0 99999.0 5.699317 99999.0 \n", "3 0.70096 0.0022 99999.0 99999.0 5.630823 99999.0 \n", "4 0.700913 0.002064 99999.0 99999.0 5.580465 99999.0 \n", "\n", " PVEC PVECMAX_INST \\\n", "0 5.878785\\t5.83973\\t5.80068 5.878785\\t5.83973\\t5.80068 \n", "1 5.80068\\t5.766575\\t5.732475 5.80068\\t5.766575\\t5.732475 \n", "2 5.699315\\t5.732475 5.699315\\t5.732475 \n", "3 5.630825\\t5.66507\\t5.699315 5.630825\\t5.66507\\t5.699315 \n", "4 5.580465\\t5.605645\\t5.630825 5.580465\\t5.605645\\t5.630825 \n", "\n", " PVECMIN_INST QI2 QK2 QMAV QMI \\\n", "0 5.878785\\t5.83973\\t5.80068 99999.0 99999.0 287.0915 287.0915 \n", "1 5.80068\\t5.766575\\t5.732475 99999.0 99999.0 287.0915 287.0915 \n", "2 5.699315\\t5.732475 99999.0 99999.0 -287.0915 -287.0915 \n", "3 5.630825\\t5.66507\\t5.699315 99999.0 99999.0 -287.0915 -287.0915 \n", "4 5.580465\\t5.605645\\t5.630825 99999.0 99999.0 -287.0915 -287.0915 \n", "\n", " QMK QMMAX_INST QMMIN_INST QMVEC QSVB RHOAV RHOI \\\n", "0 287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 965.7 \n", "1 287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 965.7012 \n", "2 -287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 965.7026 \n", "3 -287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 965.7037 \n", "4 -287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 965.7048 \n", "\n", " RHOK RHOVEC SVEC TAV \\\n", "0 965.7012 965.7\\t965.7006\\t965.7012 0\\t7.67585\\t15.3517 99999.0 \n", "1 965.7021 965.7012\\t965.7017\\t965.7021 0\\t6.254475\\t12.50895 99999.0 \n", "2 965.7021 965.7026\\t965.7021 0\\t6.265505 99999.0 \n", "3 965.7026 965.7037\\t965.7032\\t965.7026 0\\t7.20377\\t14.40754 99999.0 \n", "4 965.7037 965.7048\\t965.7043\\t965.7037 0\\t6.75792\\t13.51584 99999.0 \n", "\n", " TI TK TTRVEC \\\n", "0 89.99999 89.99802 0\\t0.002422066\\t0.004844132 \n", "1 89.99802 89.9964 0.004844132\\t0.006817694\\t0.008791257 \n", "2 89.9956 89.9964 0.0107683\\t0.008791257 \n", "3 89.99374 89.9956 0.01531452\\t0.01304141\\t0.0107683 \n", "4 89.992 89.99374 0.01957938\\t0.01744695\\t0.01531452 \n", "\n", " TVEC TVECMAX_INST TVECMIN_INST VAV VI \\\n", "0 90\\t89.99902\\t89.99802 99999.0 99999.0 0.880315 0.880315 \n", "1 89.99802\\t89.99722\\t89.9964 99999.0 99999.0 0.880314 0.880314 \n", "2 89.99561\\t89.9964 99999.0 99999.0 -0.880313 -0.880313 \n", "3 89.99374\\t89.99466\\t89.99561 99999.0 99999.0 -0.880312 -0.880312 \n", "4 89.992\\t89.99286\\t89.99374 99999.0 99999.0 -0.880312 -0.880311 \n", "\n", " VK VMAX_INST VMIN_INST VOLDA WALTERI WALTERK WVL ZAUS \\\n", "0 0.880314 99999.0 99999.0 0.0 99999.0 99999.0 10082.88 99999.0 \n", "1 0.880313 99999.0 99999.0 0.0 99999.0 99999.0 10081.81 99999.0 \n", "2 -0.880313 99999.0 99999.0 0.0 99999.0 99999.0 -10080.92 99999.0 \n", "3 -0.880313 99999.0 99999.0 0.0 99999.0 99999.0 -10080.48 99999.0 \n", "4 -0.880312 99999.0 99999.0 0.0 99999.0 99999.0 -10079.47 99999.0 \n", "\n", " ZEIN ZHKNR ZVEC l_sum AGSN_Lfdnr \\\n", "0 99999.0 99999.0 541.49\\t541.89\\t542.29 15.351701 1 \n", "1 99999.0 99999.0 542.29\\t542.64\\t542.99 27.860648 1 \n", "2 99999.0 99999.0 543.33\\t542.99 34.126153 1 \n", "3 99999.0 99999.0 544.03\\t543.6801\\t543.33 48.533695 1 \n", "4 99999.0 99999.0 544.54\\t544.285\\t544.03 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": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[0].head() # Lfdnr 1 VL" ] }, { "cell_type": "code", "execution_count": 12, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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.ITrennWithNSCHgeometryfkKIfkKKAACALCCPICPKDHDPDRAGREDDRAKONZDSIDSKDTTRDWVERLDWVERLABSETAAVFSHRHVECIAKTIVIRTRENNJVJV2LAMBDALECKEINAUSLECKMENGELECKORTLINEPACKLINEPACKGEOMLINEPACKRATEMAINELEMENTMAVMIMKMKONDMMAX_INSTMMIN_INSTMVECMVECMAX_INSTMVECMIN_INSTPAVPDAMPFPHRPHVECPMAXPMINPRPVECPVECMAX_INSTPVECMIN_INSTQI2QK2QMAVQMIQMKQMMAX_INSTQMMIN_INSTQMVECQSVBRHOAVRHOIRHOKRHOVECSVECTAVTITKTTRVECTVECTVECMAX_INSTTVECMIN_INSTVAVVIVKVMAX_INSTVMIN_INSTVOLDAWALTERIWALTERKWVLZAUSZEINZHKNRZVECl_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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00493526.633040.40886399999.099999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.0-79.74765\\t-79.74765\\t-79.7476599999.099999.099999.00.1976850.00237899999.099999.03.95368799999.04.0256\\t3.98964\\t3.9536854.0256\\t3.98964\\t3.9536854.0256\\t3.98964\\t3.95368599999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.099999.0983.7845983.7839983.7845\\t983.7842\\t983.78390\\t7.67585\\t15.351799999.059.8310559.832290.3167359\\t0.3142685\\t0.31180159.83105\\t59.83167\\t59.8323199999.099999.0-0.864133-0.864133-0.86413399999.099999.00.099999.099999.00.099999.099999.099999.0541.43\\t541.815\\t542.215.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00402127.2380.34071999999.099999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.0-79.74765\\t-79.74765\\t-79.7476599999.099999.099999.00.1976950.00193799999.099999.03.88519999999.03.953685\\t3.919445\\t3.88523.953685\\t3.919445\\t3.88523.953685\\t3.919445\\t3.885299999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.099999.0983.7839983.7833983.7839\\t983.7836\\t983.78330\\t6.254475\\t12.5089599999.059.8322959.83330.311801\\t0.3097906\\t0.3077859.83231\\t59.83279\\t59.8333199999.099999.0-0.864134-0.864133-0.86413499999.099999.00.099999.099999.00.099999.099999.099999.0542.2\\t542.565\\t542.9327.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00201426.413190.16549299999.099999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.079.74765\\t79.7476599999.099999.099999.00.1977020.0009799999.099999.03.85143999999.03.85144\\t3.88523.85144\\t3.88523.85144\\t3.885299999.099999.0287.0915287.0915287.091599999.099999.099999.099999.099999.0983.7831983.7833983.7831\\t983.78330\\t6.26550599999.059.833859.83330.305766\\t0.3077859.8338\\t59.8333199999.099999.00.8641340.8641340.86413499999.099999.00.099999.099999.00.099999.099999.099999.0543.29\\t542.9334.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00463127.027020.38939399999.099999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.079.74765\\t79.74765\\t79.7476599999.099999.099999.00.1977090.00223199999.099999.03.77359499999.03.773595\\t3.812515\\t3.851443.773595\\t3.812515\\t3.851443.773595\\t3.812515\\t3.8514499999.099999.0287.0915287.0915287.091599999.099999.099999.099999.099999.0983.7825983.7831983.7825\\t983.7828\\t983.78310\\t7.20377\\t14.4075499999.059.8349659.83380.3011346\\t0.3034503\\t0.30576659.83496\\t59.83438\\t59.833899999.099999.00.8641340.8641350.86413499999.099999.00.099999.099999.00.099999.099999.099999.0544.12\\t543.705\\t543.2948.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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00434527.36960.36992399999.099999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.079.74765\\t79.74765\\t79.7476599999.099999.099999.00.197720.00209399999.099999.03.7293899999.03.72938\\t3.751485\\t3.7735953.72938\\t3.751485\\t3.7735953.72938\\t3.751485\\t3.77359599999.099999.0287.0915287.0915287.091599999.099999.099999.099999.099999.0983.782983.7825983.782\\t983.7822\\t983.78250\\t6.75792\\t13.5158499999.059.8360659.834960.2967899\\t0.2989623\\t0.301134659.83606\\t59.83551\\t59.8349699999.099999.00.8641350.8641350.86413599999.099999.00.099999.099999.00.099999.099999.099999.0544.6\\t544.36\\t544.1262.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 ACALC CPI CPK DH DP \\\n", "0 4851678476955084637 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 5469753985021987570 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 5469753985021987570 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 5207603338578264169 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 5191457421068378074 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " DRAGRED DRAKONZ DSI DSK DTTR DWVERL DWVERLABS ETAAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 0.004935 26.63304 0.408863 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 0.004021 27.238 0.340719 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 0.002014 26.41319 0.165492 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 0.004631 27.02702 0.389393 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 0.004345 27.3696 0.369923 99999.0 \n", "\n", " FS HR HVEC IAKTIV IRTRENN JV JV2 LAMBDA \\\n", "0 99999.0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 \n", "\n", " LECKEINAUS LECKMENGE LECKORT LINEPACK LINEPACKGEOM LINEPACKRATE \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MAINELEMENT MAV MI MK MKOND MMAX_INST MMIN_INST \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "3 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "4 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MVEC MVECMAX_INST MVECMIN_INST PAV \\\n", "0 -79.74765\\t-79.74765\\t-79.74765 99999.0 99999.0 99999.0 \n", "1 -79.74765\\t-79.74765\\t-79.74765 99999.0 99999.0 99999.0 \n", "2 79.74765\\t79.74765 99999.0 99999.0 99999.0 \n", "3 79.74765\\t79.74765\\t79.74765 99999.0 99999.0 99999.0 \n", "4 79.74765\\t79.74765\\t79.74765 99999.0 99999.0 99999.0 \n", "\n", " PDAMPF PHR PHVEC PMAX PMIN PR \\\n", "0 0.197685 0.002378 99999.0 99999.0 3.953687 99999.0 \n", "1 0.197695 0.001937 99999.0 99999.0 3.885199 99999.0 \n", "2 0.197702 0.00097 99999.0 99999.0 3.851439 99999.0 \n", "3 0.197709 0.002231 99999.0 99999.0 3.773594 99999.0 \n", "4 0.19772 0.002093 99999.0 99999.0 3.72938 99999.0 \n", "\n", " PVEC PVECMAX_INST \\\n", "0 4.0256\\t3.98964\\t3.953685 4.0256\\t3.98964\\t3.953685 \n", "1 3.953685\\t3.919445\\t3.8852 3.953685\\t3.919445\\t3.8852 \n", "2 3.85144\\t3.8852 3.85144\\t3.8852 \n", "3 3.773595\\t3.812515\\t3.85144 3.773595\\t3.812515\\t3.85144 \n", "4 3.72938\\t3.751485\\t3.773595 3.72938\\t3.751485\\t3.773595 \n", "\n", " PVECMIN_INST QI2 QK2 QMAV QMI \\\n", "0 4.0256\\t3.98964\\t3.953685 99999.0 99999.0 -287.0915 -287.0915 \n", "1 3.953685\\t3.919445\\t3.8852 99999.0 99999.0 -287.0915 -287.0915 \n", "2 3.85144\\t3.8852 99999.0 99999.0 287.0915 287.0915 \n", "3 3.773595\\t3.812515\\t3.85144 99999.0 99999.0 287.0915 287.0915 \n", "4 3.72938\\t3.751485\\t3.773595 99999.0 99999.0 287.0915 287.0915 \n", "\n", " QMK QMMAX_INST QMMIN_INST QMVEC QSVB RHOAV RHOI \\\n", "0 -287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 983.7845 \n", "1 -287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 983.7839 \n", "2 287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 983.7831 \n", "3 287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 983.7825 \n", "4 287.0915 99999.0 99999.0 99999.0 99999.0 99999.0 983.782 \n", "\n", " RHOK RHOVEC SVEC TAV \\\n", "0 983.7839 983.7845\\t983.7842\\t983.7839 0\\t7.67585\\t15.3517 99999.0 \n", "1 983.7833 983.7839\\t983.7836\\t983.7833 0\\t6.254475\\t12.50895 99999.0 \n", "2 983.7833 983.7831\\t983.7833 0\\t6.265505 99999.0 \n", "3 983.7831 983.7825\\t983.7828\\t983.7831 0\\t7.20377\\t14.40754 99999.0 \n", "4 983.7825 983.782\\t983.7822\\t983.7825 0\\t6.75792\\t13.51584 99999.0 \n", "\n", " TI TK TTRVEC \\\n", "0 59.83105 59.83229 0.3167359\\t0.3142685\\t0.311801 \n", "1 59.83229 59.8333 0.311801\\t0.3097906\\t0.30778 \n", "2 59.8338 59.8333 0.305766\\t0.30778 \n", "3 59.83496 59.8338 0.3011346\\t0.3034503\\t0.305766 \n", "4 59.83606 59.83496 0.2967899\\t0.2989623\\t0.3011346 \n", "\n", " TVEC TVECMAX_INST TVECMIN_INST VAV VI \\\n", "0 59.83105\\t59.83167\\t59.83231 99999.0 99999.0 -0.864133 -0.864133 \n", "1 59.83231\\t59.83279\\t59.83331 99999.0 99999.0 -0.864134 -0.864133 \n", "2 59.8338\\t59.83331 99999.0 99999.0 0.864134 0.864134 \n", "3 59.83496\\t59.83438\\t59.8338 99999.0 99999.0 0.864134 0.864135 \n", "4 59.83606\\t59.83551\\t59.83496 99999.0 99999.0 0.864135 0.864135 \n", "\n", " VK VMAX_INST VMIN_INST VOLDA WALTERI WALTERK WVL ZAUS \\\n", "0 -0.864133 99999.0 99999.0 0.0 99999.0 99999.0 0.0 99999.0 \n", "1 -0.864134 99999.0 99999.0 0.0 99999.0 99999.0 0.0 99999.0 \n", "2 0.864134 99999.0 99999.0 0.0 99999.0 99999.0 0.0 99999.0 \n", "3 0.864134 99999.0 99999.0 0.0 99999.0 99999.0 0.0 99999.0 \n", "4 0.864135 99999.0 99999.0 0.0 99999.0 99999.0 0.0 99999.0 \n", "\n", " ZEIN ZHKNR ZVEC l_sum AGSN_Lfdnr \\\n", "0 99999.0 99999.0 541.43\\t541.815\\t542.2 15.351701 1 \n", "1 99999.0 99999.0 542.2\\t542.565\\t542.93 27.860648 1 \n", "2 99999.0 99999.0 543.29\\t542.93 34.126153 1 \n", "3 99999.0 99999.0 544.12\\t543.705\\t543.29 48.533695 1 \n", "4 99999.0 99999.0 544.6\\t544.36\\t544.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": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[1].head() # Lfdnr 1 RL" ] }, { "cell_type": "markdown", "id": "54af12b2", "metadata": {}, "source": [ "## Longitudinal Sections Vector" ] }, { "cell_type": "code", "execution_count": 13, "id": "a658cce3", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "[2026-01-23 14:24:13,119] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.AGSN_HydraulicProfile\n[2026-01-23 14:24:13,119] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.AGSN_HydraulicProfile.\n[2026-01-23 14:24:13,119] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.AGSN_HydraulicProfile.\n[2026-01-23 14:24:13,126] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 9 model_data properties.\n[2026-01-23 14:24:13,128] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Lfdnr', 'Aktiv', 'AllNodesAndLinks', 'ObjsString', 'MainWay', 'Tk', 'Pk', 'InVariant']...\n[2026-01-23 14:24:13,162] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 10)\n[2026-01-23 14:24:13,167] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 1.\n[2026-01-23 14:24:13,170] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:13,170] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:13,170] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:13,179] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:13,179] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:13,186] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:13,186] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:13,196] 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-01-23 14:24:13,602] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:13,886] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:13,886] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:13,896] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:14,019] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:14,153] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:14,153] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:14,153] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:14,153] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:14,162] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:14,216] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:15,536] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:15,536] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:15,546] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:15,546] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:15,546] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:15,554] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:15,554] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:15,559] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:15,559] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:15,559] 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-01-23 14:24:15,715] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:15,804] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:15,804] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:15,808] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:15,905] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:15,982] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:15,982] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:15,984] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:15,987] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:15,988] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:16,019] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:16,989] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:16,991] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:17,005] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 2.\n[2026-01-23 14:24:17,007] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:17,008] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:17,010] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:17,015] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:17,016] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:17,018] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:17,019] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:17,020] 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-01-23 14:24:17,179] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:17,266] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:17,270] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:17,270] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:17,356] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:17,441] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:17,441] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:17,444] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:17,446] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:17,449] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:17,472] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:18,432] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:18,434] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:18,440] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:18,445] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:18,446] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:18,449] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:18,449] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:18,453] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:18,453] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:18,455] 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-01-23 14:24:18,600] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:18,696] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:18,696] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:18,702] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:18,787] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:18,876] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:18,876] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:18,879] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:18,882] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:18,883] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:18,902] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:19,886] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:19,890] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:19,900] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 3.\n[2026-01-23 14:24:19,900] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:19,902] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:19,903] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:19,906] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:19,907] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:19,908] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:19,910] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:19,911] 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-01-23 14:24:20,036] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:20,112] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:20,112] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:20,117] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:20,180] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:20,254] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:20,259] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:20,261] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:20,263] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:20,264] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:20,269] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:21,282] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:21,286] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:21,299] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:21,299] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:21,300] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:21,304] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:21,304] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:21,306] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n[2026-01-23 14:24:21,308] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n[2026-01-23 14:24:21,308] 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-01-23 14:24:21,449] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n[2026-01-23 14:24:21,520] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n[2026-01-23 14:24:21,520] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)\n[2026-01-23 14:24:21,520] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe ...\n[2026-01-23 14:24:21,612] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n[2026-01-23 14:24:21,681] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n[2026-01-23 14:24:21,681] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n[2026-01-23 14:24:21,684] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n[2026-01-23 14:24:21,686] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.\n[2026-01-23 14:24:21,687] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n[2026-01-23 14:24:21,715] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n[2026-01-23 14:24:22,678] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 3608)\n[2026-01-23 14:24:22,678] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\nc:\\Users\\aUsername\\AppData\\Local\\anaconda3\\Lib\\site-packages\\geopandas\\geodataframe.py:1968: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling `frame.insert` many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1) instead. To get a de-fragmented frame, use `newframe = frame.copy()`\n super().__setitem__(key, value)\n" ] } ], "source": [ "dfs_vector = s3s.generate_longitudinal_section_vector_dataframes()" ] }, { "cell_type": "code", "execution_count": 14, "id": "ecf68d90", "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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.ITrennWithNSCHgeometryfkKIfkKKAACALCCPICPKDHDPDRAGREDDRAKONZDSIDSKDTTRDWVERLDWVERLABSETAAVFSHRIAKTIVIRTRENNJVJV2LAMBDALECKEINAUSLECKMENGELECKORTLINEPACKLINEPACKGEOMLINEPACKRATEMAINELEMENTMAVMIMKMKONDMMAX_INSTMMIN_INSTPAVPDAMPFPHRPMAXPMINPRQI2QK2QMAVQMIQMKQMMAX_INSTQMMIN_INSTQSVBRHOAVRHOIRHOKTAVTITKVAVVIVKVMAX_INSTVMIN_INSTVOLDAWALTERIWALTERKWVLZAUSZEINZHKNRl_sumAGSN_LfdnrAGSN_NameMVEC_0MVEC_1MVEC_2MVEC_3MVEC_4MVEC_5MVEC_6MVEC_7MVEC_8MVEC_9MVEC_10PVEC_0PVEC_1PVEC_2PVEC_3PVEC_4PVEC_5PVEC_6PVEC_7PVEC_8PVEC_9PVEC_10PVECMAX_INST_0PVECMAX_INST_1PVECMAX_INST_2PVECMAX_INST_3PVECMAX_INST_4PVECMAX_INST_5PVECMAX_INST_6PVECMAX_INST_7PVECMAX_INST_8PVECMAX_INST_9PVECMAX_INST_10PVECMIN_INST_0PVECMIN_INST_1PVECMIN_INST_2PVECMIN_INST_3PVECMIN_INST_4PVECMIN_INST_5PVECMIN_INST_6PVECMIN_INST_7PVECMIN_INST_8PVECMIN_INST_9PVECMIN_INST_10RHOVEC_0RHOVEC_1RHOVEC_2RHOVEC_3RHOVEC_4RHOVEC_5RHOVEC_6RHOVEC_7RHOVEC_8RHOVEC_9RHOVEC_10SVEC_0SVEC_1SVEC_2SVEC_3SVEC_4SVEC_5SVEC_6SVEC_7SVEC_8SVEC_9SVEC_10TTRVEC_0TTRVEC_1TTRVEC_2TTRVEC_3TTRVEC_4TTRVEC_5TTRVEC_6TTRVEC_7TTRVEC_8TTRVEC_9TTRVEC_10TVEC_0TVEC_1TVEC_2TVEC_3TVEC_4TVEC_5TVEC_6TVEC_7TVEC_8TVEC_9TVEC_10ZVEC_0ZVEC_1ZVEC_2ZVEC_3ZVEC_4ZVEC_5ZVEC_6ZVEC_7ZVEC_8ZVEC_9ZVEC_10
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00484443.120160.66196899999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.7010740.00234599999.05.80067999999.099999.099999.0287.0915287.0915287.091599999.099999.099999.099999.0965.7965.701299999.089.9999989.998020.8803150.8803150.88031499999.099999.00.099999.099999.010082.8899999.099999.099999.015.3517011Längsschnitt79.7476579.7476579.74765NaNNaNNaNNaNNaNNaNNaNNaN5.8787855.8397305.800680NaNNaNNaNNaNNaNNaNNaNNaN5.8787855.8397305.800680NaNNaNNaNNaNNaNNaNNaNNaN5.8787855.8397305.800680NaNNaNNaNNaNNaNNaNNaNNaN965.7000965.7006965.7012NaNNaNNaNNaNNaNNaNNaNNaN07.67585015.35170NaNNaNNaNNaNNaNNaNNaNNaN0.0000000.0024220.004844NaNNaNNaNNaNNaNNaNNaNNaN90.0000089.9990289.99802NaNNaNNaNNaNNaNNaNNaNNaN541.49541.89542.29NaNNaNNaNNaNNaNNaNNaNNaN
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00394743.580790.5451599999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.7010270.0019199999.05.73247599999.099999.099999.0287.0915287.0915287.091599999.099999.099999.099999.0965.7012965.702199999.089.9980289.99640.8803140.8803140.88031399999.099999.00.099999.099999.010081.8199999.099999.099999.027.8606481Längsschnitt79.7476579.7476579.74765NaNNaNNaNNaNNaNNaNNaNNaN5.8006805.7665755.732475NaNNaNNaNNaNNaNNaNNaNNaN5.8006805.7665755.732475NaNNaNNaNNaNNaNNaNNaNNaN5.8006805.7665755.732475NaNNaNNaNNaNNaNNaNNaNNaN965.7012965.7017965.7021NaNNaNNaNNaNNaNNaNNaNNaN06.25447512.50895NaNNaNNaNNaNNaNNaNNaNNaN0.0048440.0068180.008791NaNNaNNaNNaNNaNNaNNaNNaN89.9980289.9972289.99640NaNNaNNaNNaNNaNNaNNaNNaN542.29542.64542.99NaNNaNNaNNaNNaNNaNNaNNaN
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00197743.504070.27257599999.099999.099999.00.00.00.15272799999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.7009950.00095799999.05.69931799999.099999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.0965.7026965.702199999.089.995689.9964-0.880313-0.880313-0.88031399999.099999.00.099999.099999.0-10080.9299999.099999.099999.034.1261531Längsschnitt-79.74765-79.74765NaNNaNNaNNaNNaNNaNNaNNaNNaN5.6993155.732475NaNNaNNaNNaNNaNNaNNaNNaNNaN5.6993155.732475NaNNaNNaNNaNNaNNaNNaNNaNNaN5.6993155.732475NaNNaNNaNNaNNaNNaNNaNNaNNaN965.7026965.7021NaNNaNNaNNaNNaNNaNNaNNaNNaN06.265505NaNNaNNaNNaNNaNNaNNaNNaNNaN0.0107680.008791NaNNaNNaNNaNNaNNaNNaNNaNNaN89.9956189.99640NaNNaNNaNNaNNaNNaNNaNNaNNaN543.33542.99NaNNaNNaNNaNNaNNaNNaNNaNNaN
\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", "\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", "\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", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5025945677694931826 \n", "1 5029128874972463118 5216742060270992761 \n", "2 5029128874972463118 4919359344392474301 \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", "\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", "\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", "\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", "\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", "\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", "\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", "\n", " fkKK A ACALC CPI CPK DH DP \\\n", "0 4825391580467484032 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 5180617780362861593 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 5180617780362861593 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " DRAGRED DRAKONZ DSI DSK DTTR DWVERL DWVERLABS ETAAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 0.004844 43.12016 0.661968 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 0.003947 43.58079 0.54515 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 0.001977 43.50407 0.272575 99999.0 \n", "\n", " FS HR IAKTIV IRTRENN JV JV2 LAMBDA LECKEINAUS \\\n", "0 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 0.0 0.0 0.152727 99999.0 99999.0 99999.0 \n", "\n", " LECKMENGE LECKORT LINEPACK LINEPACKGEOM LINEPACKRATE MAINELEMENT MAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MI MK MKOND MMAX_INST MMIN_INST PAV PDAMPF PHR \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.701074 0.002345 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.701027 0.00191 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.700995 0.000957 \n", "\n", " PMAX PMIN PR QI2 QK2 QMAV QMI QMK \\\n", "0 99999.0 5.800679 99999.0 99999.0 99999.0 287.0915 287.0915 287.0915 \n", "1 99999.0 5.732475 99999.0 99999.0 99999.0 287.0915 287.0915 287.0915 \n", "2 99999.0 5.699317 99999.0 99999.0 99999.0 -287.0915 -287.0915 -287.0915 \n", "\n", " QMMAX_INST QMMIN_INST QSVB RHOAV RHOI RHOK TAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 965.7 965.7012 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 965.7012 965.7021 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 965.7026 965.7021 99999.0 \n", "\n", " TI TK VAV VI VK VMAX_INST VMIN_INST VOLDA \\\n", "0 89.99999 89.99802 0.880315 0.880315 0.880314 99999.0 99999.0 0.0 \n", "1 89.99802 89.9964 0.880314 0.880314 0.880313 99999.0 99999.0 0.0 \n", "2 89.9956 89.9964 -0.880313 -0.880313 -0.880313 99999.0 99999.0 0.0 \n", "\n", " WALTERI WALTERK WVL ZAUS ZEIN ZHKNR l_sum \\\n", "0 99999.0 99999.0 10082.88 99999.0 99999.0 99999.0 15.351701 \n", "1 99999.0 99999.0 10081.81 99999.0 99999.0 99999.0 27.860648 \n", "2 99999.0 99999.0 -10080.92 99999.0 99999.0 99999.0 34.126153 \n", "\n", " AGSN_Lfdnr AGSN_Name MVEC_0 MVEC_1 MVEC_2 MVEC_3 MVEC_4 \\\n", "0 1 Längsschnitt 79.74765 79.74765 79.74765 NaN NaN \n", "1 1 Längsschnitt 79.74765 79.74765 79.74765 NaN NaN \n", "2 1 Längsschnitt -79.74765 -79.74765 NaN NaN NaN \n", "\n", " MVEC_5 MVEC_6 MVEC_7 MVEC_8 MVEC_9 MVEC_10 PVEC_0 PVEC_1 \\\n", "0 NaN NaN NaN NaN NaN NaN 5.878785 5.839730 \n", "1 NaN NaN NaN NaN NaN NaN 5.800680 5.766575 \n", "2 NaN NaN NaN NaN NaN NaN 5.699315 5.732475 \n", "\n", " PVEC_2 PVEC_3 PVEC_4 PVEC_5 PVEC_6 PVEC_7 PVEC_8 PVEC_9 PVEC_10 \\\n", "0 5.800680 NaN NaN NaN NaN NaN NaN NaN NaN \n", "1 5.732475 NaN NaN NaN NaN NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " PVECMAX_INST_0 PVECMAX_INST_1 PVECMAX_INST_2 PVECMAX_INST_3 \\\n", "0 5.878785 5.839730 5.800680 NaN \n", "1 5.800680 5.766575 5.732475 NaN \n", "2 5.699315 5.732475 NaN NaN \n", "\n", " PVECMAX_INST_4 PVECMAX_INST_5 PVECMAX_INST_6 PVECMAX_INST_7 \\\n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "\n", " PVECMAX_INST_8 PVECMAX_INST_9 PVECMAX_INST_10 PVECMIN_INST_0 \\\n", "0 NaN NaN NaN 5.878785 \n", "1 NaN NaN NaN 5.800680 \n", "2 NaN NaN NaN 5.699315 \n", "\n", " PVECMIN_INST_1 PVECMIN_INST_2 PVECMIN_INST_3 PVECMIN_INST_4 \\\n", "0 5.839730 5.800680 NaN NaN \n", "1 5.766575 5.732475 NaN NaN \n", "2 5.732475 NaN NaN NaN \n", "\n", " PVECMIN_INST_5 PVECMIN_INST_6 PVECMIN_INST_7 PVECMIN_INST_8 \\\n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "\n", " PVECMIN_INST_9 PVECMIN_INST_10 RHOVEC_0 RHOVEC_1 RHOVEC_2 RHOVEC_3 \\\n", "0 NaN NaN 965.7000 965.7006 965.7012 NaN \n", "1 NaN NaN 965.7012 965.7017 965.7021 NaN \n", "2 NaN NaN 965.7026 965.7021 NaN NaN \n", "\n", " RHOVEC_4 RHOVEC_5 RHOVEC_6 RHOVEC_7 RHOVEC_8 RHOVEC_9 RHOVEC_10 \\\n", "0 NaN NaN NaN NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN NaN NaN NaN \n", "\n", " SVEC_0 SVEC_1 SVEC_2 SVEC_3 SVEC_4 SVEC_5 SVEC_6 SVEC_7 SVEC_8 \\\n", "0 0 7.675850 15.35170 NaN NaN NaN NaN NaN NaN \n", "1 0 6.254475 12.50895 NaN NaN NaN NaN NaN NaN \n", "2 0 6.265505 NaN NaN NaN NaN NaN NaN NaN \n", "\n", " SVEC_9 SVEC_10 TTRVEC_0 TTRVEC_1 TTRVEC_2 TTRVEC_3 TTRVEC_4 \\\n", "0 NaN NaN 0.000000 0.002422 0.004844 NaN NaN \n", "1 NaN NaN 0.004844 0.006818 0.008791 NaN NaN \n", "2 NaN NaN 0.010768 0.008791 NaN NaN NaN \n", "\n", " TTRVEC_5 TTRVEC_6 TTRVEC_7 TTRVEC_8 TTRVEC_9 TTRVEC_10 TVEC_0 \\\n", "0 NaN NaN NaN NaN NaN NaN 90.00000 \n", "1 NaN NaN NaN NaN NaN NaN 89.99802 \n", "2 NaN NaN NaN NaN NaN NaN 89.99561 \n", "\n", " TVEC_1 TVEC_2 TVEC_3 TVEC_4 TVEC_5 TVEC_6 TVEC_7 TVEC_8 TVEC_9 \\\n", "0 89.99902 89.99802 NaN NaN NaN NaN NaN NaN NaN \n", "1 89.99722 89.99640 NaN NaN NaN NaN NaN NaN NaN \n", "2 89.99640 NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " TVEC_10 ZVEC_0 ZVEC_1 ZVEC_2 ZVEC_3 ZVEC_4 ZVEC_5 ZVEC_6 ZVEC_7 \\\n", "0 NaN 541.49 541.89 542.29 NaN NaN NaN NaN NaN \n", "1 NaN 542.29 542.64 542.99 NaN NaN NaN NaN NaN \n", "2 NaN 543.33 542.99 NaN NaN NaN NaN NaN NaN \n", "\n", " ZVEC_8 ZVEC_9 ZVEC_10 \n", "0 NaN NaN NaN \n", "1 NaN NaN NaN \n", "2 NaN NaN NaN " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs_vector[0].head(3) # Lfdnr 1 VL" ] }, { "cell_type": "code", "execution_count": 15, "id": "7cf9ae39", "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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.ITrennWithNSCHgeometryfkKIfkKKAACALCCPICPKDHDPDRAGREDDRAKONZDSIDSKDTTRDWVERLDWVERLABSETAAVFSHRIAKTIVIRTRENNJVJV2LAMBDALECKEINAUSLECKMENGELECKORTLINEPACKLINEPACKGEOMLINEPACKRATEMAINELEMENTMAVMIMKMKONDMMAX_INSTMMIN_INSTPAVPDAMPFPHRPMAXPMINPRQI2QK2QMAVQMIQMKQMMAX_INSTQMMIN_INSTQSVBRHOAVRHOIRHOKTAVTITKVAVVIVKVMAX_INSTVMIN_INSTVOLDAWALTERIWALTERKWVLZAUSZEINZHKNRl_sumAGSN_LfdnrAGSN_NameMVEC_0MVEC_1MVEC_2MVEC_3MVEC_4MVEC_5MVEC_6MVEC_7MVEC_8MVEC_9MVEC_10PVEC_0PVEC_1PVEC_2PVEC_3PVEC_4PVEC_5PVEC_6PVEC_7PVEC_8PVEC_9PVEC_10PVECMAX_INST_0PVECMAX_INST_1PVECMAX_INST_2PVECMAX_INST_3PVECMAX_INST_4PVECMAX_INST_5PVECMAX_INST_6PVECMAX_INST_7PVECMAX_INST_8PVECMAX_INST_9PVECMAX_INST_10PVECMIN_INST_0PVECMIN_INST_1PVECMIN_INST_2PVECMIN_INST_3PVECMIN_INST_4PVECMIN_INST_5PVECMIN_INST_6PVECMIN_INST_7PVECMIN_INST_8PVECMIN_INST_9PVECMIN_INST_10RHOVEC_0RHOVEC_1RHOVEC_2RHOVEC_3RHOVEC_4RHOVEC_5RHOVEC_6RHOVEC_7RHOVEC_8RHOVEC_9RHOVEC_10SVEC_0SVEC_1SVEC_2SVEC_3SVEC_4SVEC_5SVEC_6SVEC_7SVEC_8SVEC_9SVEC_10TTRVEC_0TTRVEC_1TTRVEC_2TTRVEC_3TTRVEC_4TTRVEC_5TTRVEC_6TTRVEC_7TTRVEC_8TTRVEC_9TTRVEC_10TVEC_0TVEC_1TVEC_2TVEC_3TVEC_4TVEC_5TVEC_6TVEC_7TVEC_8TVEC_9TVEC_10ZVEC_0ZVEC_1ZVEC_2ZVEC_3ZVEC_4ZVEC_5ZVEC_6ZVEC_7ZVEC_8ZVEC_9ZVEC_10
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00493526.633040.40886399999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.1976850.00237899999.03.95368799999.099999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.0983.7845983.783999999.059.8310559.83229-0.864133-0.864133-0.86413399999.099999.00.099999.099999.00.099999.099999.099999.015.3517011Längsschnitt-79.74765-79.74765-79.74765NaNNaNNaNNaNNaNNaNNaNNaN4.0256003.9896403.953685NaNNaNNaNNaNNaNNaNNaNNaN4.0256003.9896403.953685NaNNaNNaNNaNNaNNaNNaNNaN4.0256003.9896403.953685NaNNaNNaNNaNNaNNaNNaNNaN983.7845983.7842983.7839NaNNaNNaNNaNNaNNaNNaNNaN07.67585015.35170NaNNaNNaNNaNNaNNaNNaNNaN0.3167360.3142690.311801NaNNaNNaNNaNNaNNaNNaNNaN59.8310559.8316759.83231NaNNaNNaNNaNNaNNaNNaNNaN541.43541.815542.20NaNNaNNaNNaNNaNNaNNaNNaN
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00402127.2380.34071999999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.1976950.00193799999.03.88519999999.099999.099999.0-287.0915-287.0915-287.091599999.099999.099999.099999.0983.7839983.783399999.059.8322959.8333-0.864134-0.864133-0.86413499999.099999.00.099999.099999.00.099999.099999.099999.027.8606481Längsschnitt-79.74765-79.74765-79.74765NaNNaNNaNNaNNaNNaNNaNNaN3.9536853.9194453.885200NaNNaNNaNNaNNaNNaNNaNNaN3.9536853.9194453.885200NaNNaNNaNNaNNaNNaNNaNNaN3.9536853.9194453.885200NaNNaNNaNNaNNaNNaNNaNNaN983.7839983.7836983.7833NaNNaNNaNNaNNaNNaNNaNNaN06.25447512.50895NaNNaNNaNNaNNaNNaNNaNNaN0.3118010.3097910.307780NaNNaNNaNNaNNaNNaNNaNNaN59.8323159.8327959.83331NaNNaNNaNNaNNaNNaNNaNNaN542.20542.565542.93NaNNaNNaNNaNNaNNaNNaNNaN
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.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.00201426.413190.16549299999.099999.099999.00.00.00.15488499999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.099999.00.1977020.0009799999.03.85143999999.099999.099999.0287.0915287.0915287.091599999.099999.099999.099999.0983.7831983.783399999.059.833859.83330.8641340.8641340.86413499999.099999.00.099999.099999.00.099999.099999.099999.034.1261531Längsschnitt79.7476579.74765NaNNaNNaNNaNNaNNaNNaNNaNNaN3.8514403.885200NaNNaNNaNNaNNaNNaNNaNNaNNaN3.8514403.885200NaNNaNNaNNaNNaNNaNNaNNaNNaN3.8514403.885200NaNNaNNaNNaNNaNNaNNaNNaNNaN983.7831983.7833NaNNaNNaNNaNNaNNaNNaNNaNNaN06.265505NaNNaNNaNNaNNaNNaNNaNNaNNaN0.3057660.307780NaNNaNNaNNaNNaNNaNNaNNaNNaN59.8338059.83331NaNNaNNaNNaNNaNNaNNaNNaNNaN543.29542.930NaNNaNNaNNaNNaNNaNNaNNaNNaN
\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", "\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", "\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", "\n", " Fkcont Fk2lrohr \\\n", "0 5029128874972463118 5691533564979419761 \n", "1 5029128874972463118 5048873293262650113 \n", "2 5029128874972463118 5715081934973525403 \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", "\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", "\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", "\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", "\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", "\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", "\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", "\n", " fkKK A ACALC CPI CPK DH DP \\\n", "0 4851678476955084637 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 5469753985021987570 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 5469753985021987570 0.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " DRAGRED DRAKONZ DSI DSK DTTR DWVERL DWVERLABS ETAAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 0.004935 26.63304 0.408863 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 0.004021 27.238 0.340719 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 0.002014 26.41319 0.165492 99999.0 \n", "\n", " FS HR IAKTIV IRTRENN JV JV2 LAMBDA LECKEINAUS \\\n", "0 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 0.0 0.0 0.154884 99999.0 99999.0 99999.0 \n", "\n", " LECKMENGE LECKORT LINEPACK LINEPACKGEOM LINEPACKRATE MAINELEMENT MAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 \n", "\n", " MI MK MKOND MMAX_INST MMIN_INST PAV PDAMPF PHR \\\n", "0 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.197685 0.002378 \n", "1 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.197695 0.001937 \n", "2 99999.0 99999.0 99999.0 99999.0 99999.0 99999.0 0.197702 0.00097 \n", "\n", " PMAX PMIN PR QI2 QK2 QMAV QMI QMK \\\n", "0 99999.0 3.953687 99999.0 99999.0 99999.0 -287.0915 -287.0915 -287.0915 \n", "1 99999.0 3.885199 99999.0 99999.0 99999.0 -287.0915 -287.0915 -287.0915 \n", "2 99999.0 3.851439 99999.0 99999.0 99999.0 287.0915 287.0915 287.0915 \n", "\n", " QMMAX_INST QMMIN_INST QSVB RHOAV RHOI RHOK TAV \\\n", "0 99999.0 99999.0 99999.0 99999.0 983.7845 983.7839 99999.0 \n", "1 99999.0 99999.0 99999.0 99999.0 983.7839 983.7833 99999.0 \n", "2 99999.0 99999.0 99999.0 99999.0 983.7831 983.7833 99999.0 \n", "\n", " TI TK VAV VI VK VMAX_INST VMIN_INST VOLDA \\\n", "0 59.83105 59.83229 -0.864133 -0.864133 -0.864133 99999.0 99999.0 0.0 \n", "1 59.83229 59.8333 -0.864134 -0.864133 -0.864134 99999.0 99999.0 0.0 \n", "2 59.8338 59.8333 0.864134 0.864134 0.864134 99999.0 99999.0 0.0 \n", "\n", " WALTERI WALTERK WVL ZAUS ZEIN ZHKNR l_sum AGSN_Lfdnr \\\n", "0 99999.0 99999.0 0.0 99999.0 99999.0 99999.0 15.351701 1 \n", "1 99999.0 99999.0 0.0 99999.0 99999.0 99999.0 27.860648 1 \n", "2 99999.0 99999.0 0.0 99999.0 99999.0 99999.0 34.126153 1 \n", "\n", " AGSN_Name MVEC_0 MVEC_1 MVEC_2 MVEC_3 MVEC_4 MVEC_5 MVEC_6 \\\n", "0 Längsschnitt -79.74765 -79.74765 -79.74765 NaN NaN NaN NaN \n", "1 Längsschnitt -79.74765 -79.74765 -79.74765 NaN NaN NaN NaN \n", "2 Längsschnitt 79.74765 79.74765 NaN NaN NaN NaN NaN \n", "\n", " MVEC_7 MVEC_8 MVEC_9 MVEC_10 PVEC_0 PVEC_1 PVEC_2 PVEC_3 \\\n", "0 NaN NaN NaN NaN 4.025600 3.989640 3.953685 NaN \n", "1 NaN NaN NaN NaN 3.953685 3.919445 3.885200 NaN \n", "2 NaN NaN NaN NaN 3.851440 3.885200 NaN NaN \n", "\n", " PVEC_4 PVEC_5 PVEC_6 PVEC_7 PVEC_8 PVEC_9 PVEC_10 PVECMAX_INST_0 \\\n", "0 NaN NaN NaN NaN NaN NaN NaN 4.025600 \n", "1 NaN NaN NaN NaN NaN NaN NaN 3.953685 \n", "2 NaN NaN NaN NaN NaN NaN NaN 3.851440 \n", "\n", " PVECMAX_INST_1 PVECMAX_INST_2 PVECMAX_INST_3 PVECMAX_INST_4 \\\n", "0 3.989640 3.953685 NaN NaN \n", "1 3.919445 3.885200 NaN NaN \n", "2 3.885200 NaN NaN NaN \n", "\n", " PVECMAX_INST_5 PVECMAX_INST_6 PVECMAX_INST_7 PVECMAX_INST_8 \\\n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "\n", " PVECMAX_INST_9 PVECMAX_INST_10 PVECMIN_INST_0 PVECMIN_INST_1 \\\n", "0 NaN NaN 4.025600 3.989640 \n", "1 NaN NaN 3.953685 3.919445 \n", "2 NaN NaN 3.851440 3.885200 \n", "\n", " PVECMIN_INST_2 PVECMIN_INST_3 PVECMIN_INST_4 PVECMIN_INST_5 \\\n", "0 3.953685 NaN NaN NaN \n", "1 3.885200 NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "\n", " PVECMIN_INST_6 PVECMIN_INST_7 PVECMIN_INST_8 PVECMIN_INST_9 \\\n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "\n", " PVECMIN_INST_10 RHOVEC_0 RHOVEC_1 RHOVEC_2 RHOVEC_3 RHOVEC_4 \\\n", "0 NaN 983.7845 983.7842 983.7839 NaN NaN \n", "1 NaN 983.7839 983.7836 983.7833 NaN NaN \n", "2 NaN 983.7831 983.7833 NaN NaN NaN \n", "\n", " RHOVEC_5 RHOVEC_6 RHOVEC_7 RHOVEC_8 RHOVEC_9 RHOVEC_10 SVEC_0 \\\n", "0 NaN NaN NaN NaN NaN NaN 0 \n", "1 NaN NaN NaN NaN NaN NaN 0 \n", "2 NaN NaN NaN NaN NaN NaN 0 \n", "\n", " SVEC_1 SVEC_2 SVEC_3 SVEC_4 SVEC_5 SVEC_6 SVEC_7 SVEC_8 SVEC_9 \\\n", "0 7.675850 15.35170 NaN NaN NaN NaN NaN NaN NaN \n", "1 6.254475 12.50895 NaN NaN NaN NaN NaN NaN NaN \n", "2 6.265505 NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " SVEC_10 TTRVEC_0 TTRVEC_1 TTRVEC_2 TTRVEC_3 TTRVEC_4 TTRVEC_5 \\\n", "0 NaN 0.316736 0.314269 0.311801 NaN NaN NaN \n", "1 NaN 0.311801 0.309791 0.307780 NaN NaN NaN \n", "2 NaN 0.305766 0.307780 NaN NaN NaN NaN \n", "\n", " TTRVEC_6 TTRVEC_7 TTRVEC_8 TTRVEC_9 TTRVEC_10 TVEC_0 TVEC_1 \\\n", "0 NaN NaN NaN NaN NaN 59.83105 59.83167 \n", "1 NaN NaN NaN NaN NaN 59.83231 59.83279 \n", "2 NaN NaN NaN NaN NaN 59.83380 59.83331 \n", "\n", " TVEC_2 TVEC_3 TVEC_4 TVEC_5 TVEC_6 TVEC_7 TVEC_8 TVEC_9 TVEC_10 \\\n", "0 59.83231 NaN NaN NaN NaN NaN NaN NaN NaN \n", "1 59.83331 NaN NaN NaN NaN NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN NaN NaN NaN NaN NaN \n", "\n", " ZVEC_0 ZVEC_1 ZVEC_2 ZVEC_3 ZVEC_4 ZVEC_5 ZVEC_6 ZVEC_7 ZVEC_8 \\\n", "0 541.43 541.815 542.20 NaN NaN NaN NaN NaN NaN \n", "1 542.20 542.565 542.93 NaN NaN NaN NaN NaN NaN \n", "2 543.29 542.930 NaN NaN NaN NaN NaN NaN NaN \n", "\n", " ZVEC_9 ZVEC_10 \n", "0 NaN NaN \n", "1 NaN NaN \n", "2 NaN NaN " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs_vector[1].head(3) # Lfdnr 1 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-01-23 14:24:23,543] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-01-23 14:24:23,546] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-01-23 14:24:23,550] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:23,550] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:23,678] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:23,714] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:23,714] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (524, 6)\n", "[2026-01-23 14:24:23,719] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Valve\n", "[2026-01-23 14:24:23,720] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 12 element(s) of element type ObjectTypes.Valve.\n", "[2026-01-23 14:24:23,723] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:23,723] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:23,919] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:23,936] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:23,936] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (12, 6)\n", "[2026-01-23 14:24:23,944] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.FlapValve\n", "[2026-01-23 14:24:23,947] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.FlapValve.\n", "[2026-01-23 14:24:23,949] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:23,949] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:23,965] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:23,982] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:23,982] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 6)\n", "[2026-01-23 14:24:23,986] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pump\n", "[2026-01-23 14:24:23,988] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 2 element(s) of element type ObjectTypes.Pump.\n", "[2026-01-23 14:24:23,991] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:23,993] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:24,128] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:24,147] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:24,148] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (2, 6)\n", "[2026-01-23 14:24:24,150] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingConsumer\n", "[2026-01-23 14:24:24,152] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 337 element(s) of element type ObjectTypes.DistrictHeatingConsumer.\n", "[2026-01-23 14:24:24,154] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:24,154] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:24,245] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:24,271] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:24,276] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (337, 6)\n", "[2026-01-23 14:24:24,278] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingFeeder\n", "[2026-01-23 14:24:24,281] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.DistrictHeatingFeeder.\n", "[2026-01-23 14:24:24,283] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:24,284] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:24,305] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-01-23 14:24:24,326] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:24,327] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 6)\n", "[2026-01-23 14:24:24,331] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.HeatExchanger\n", "[2026-01-23 14:24:24,332] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.HeatExchanger.\n", "[2026-01-23 14:24:24,335] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.\n", "[2026-01-23 14:24:24,336] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...\n", "[2026-01-23 14:24:24,384] INFO in sir3stoolkit.mantle.dataframes: [model_data] 4 non-empty end node columns were created.\n", "[2026-01-23 14:24:24,409] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-01-23 14:24:24,411] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 8)\n", "[2026-01-23 14:24:24,418] 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 }