Tutorial 53: Creation of Non-Element Dataframes
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.
Toolkit Release
[1]:
#pip install
Imports
SIR 3S Toolkit
Regular Import/Init
[ ]:
SIR3S_SIRGRAF_DIR = r"C:\3S\SIR 3S\SirGraf-90-15-00-24_Quebec-Upd2" #change to local path
[3]:
from sir3stoolkit.core import wrapper
[4]:
wrapper
[4]:
<module 'sir3stoolkit.core.wrapper' from 'C:\\Users\\aUsername\\3S\\sir3stoolkit\\src\\sir3stoolkit\\core\\wrapper.py'>
[5]:
wrapper.Initialize_Toolkit(SIR3S_SIRGRAF_DIR)
Additional Import/Init for Dataframes class
[6]:
from sir3stoolkit.mantle.dataframes import SIR3S_Model_Dataframes
[7]:
s3s = SIR3S_Model_Dataframes()
Initialization complete
Additional
[8]:
import pandas as pd
from shapely.geometry import Point
import re
import folium
from folium.plugins import HeatMap
import numpy as np
import geopandas as gpd
from shapely import wkt
import matplotlib.pyplot as plt
import contextily as cx
Open Model
[9]:
s3s.OpenModel(dbName=r"Toolkit_Tutorial53_Model.db3",
providerType=s3s.ProviderTypes.SQLite,
Mid="M-1-0-1",
saveCurrentlyOpenModel=False,
namedInstance="",
userID="",
password="")
Model is open for further operation
Calculate Model
[10]:
s3s.ExecCalculation(True) # To ensure result data
Model Calculation is complete
Generate Non-Element Dataframes
AGSN (Longitudinal Sections)
We can use the method generate_longitudinal_section_dataframes() to obtain a list indexed by (lfdnr-1) filled with size-2-tuples with 0 - Supply and 1 - Return..
[11]:
dfs = s3s.generate_longitudinal_section_dataframes()
[2026-03-03 15:33:02,655] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.AGSN_HydraulicProfile
[2026-03-03 15:33:02,662] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.AGSN_HydraulicProfile.
[2026-03-03 15:33:02,677] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.AGSN_HydraulicProfile.
[2026-03-03 15:33:02,678] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 9 model_data properties.
[2026-03-03 15:33:02,678] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Lfdnr', 'Aktiv', 'AllNodesAndLinks', 'ObjsString', 'MainWay', 'Tk', 'Pk', 'InVariant']...
[2026-03-03 15:33:02,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 10)
[2026-03-03 15:33:02,707] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 1.
[2026-03-03 15:33:02,722] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:02,722] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:02,858] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:02,868] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:03,198] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:03,269] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:03,270] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:03,343] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:03,344] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:03,408] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:03,409] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:03,411] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:03,411] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:03,414] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:03,429] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:03,829] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:04,087] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:04,088] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:04,123] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:04,124] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:04,130] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:04,132] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:04,134] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:04,135] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:04,136] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:04,137] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:04,283] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:04,365] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:04,365] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:04,449] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:04,449] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:04,532] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:04,533] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:04,536] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:04,537] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:04,540] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:04,576] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:05,239] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:05,448] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:05,453] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:05,498] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 2.
[2026-03-03 15:33:05,499] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:05,501] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:05,508] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:05,512] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:05,513] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:05,515] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:05,515] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:05,518] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:05,727] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:05,877] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:05,877] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:05,995] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:05,995] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:06,089] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:06,089] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:06,098] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:06,100] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:06,103] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:06,144] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:06,807] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:07,024] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:07,035] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:07,081] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:07,082] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:07,087] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:07,092] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:07,094] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:07,096] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:07,098] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:07,099] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:07,277] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:07,378] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:07,378] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:07,477] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:07,477] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:07,590] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:07,604] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:07,648] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:08,295] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:08,495] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:08,495] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:08,541] INFO in sir3stoolkit.mantle.dataframes: Retrieving Hydraulic Profile with Lfdnr: 3.
[2026-03-03 15:33:08,543] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:08,544] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:08,550] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:08,555] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:08,556] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:08,561] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:08,561] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:08,563] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:08,730] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:08,836] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:08,836] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:08,933] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:08,934] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:09,035] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:09,035] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:09,038] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:09,040] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:09,044] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:09,083] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:09,709] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:10,091] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:10,094] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:10,176] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:10,178] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...
[2026-03-03 15:33:10,189] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:10,195] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:10,197] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:10,200] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.
[2026-03-03 15:33:10,200] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.
[2026-03-03 15:33:10,206] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...
[2026-03-03 15:33:10,523] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:10,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:10,698] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (44, 50)
[2026-03-03 15:33:10,841] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...
[2026-03-03 15:33:10,841] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:11,008] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used
[2026-03-03 15:33:11,008] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.
[2026-03-03 15:33:11,015] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:11,017] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] 44 tks remain after filtering for given tks.
[2026-03-03 15:33:11,021] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.
[2026-03-03 15:33:11,045] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...
[2026-03-03 15:33:14,061] INFO in sir3stoolkit.mantle.dataframes: [results] 2244 fully NaN columns dropped.
[2026-03-03 15:33:14,760] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 1364)
[2026-03-03 15:33:14,760] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...
[12]:
dfs[0][0].head() # Lfdnr 1, Vl
[12]:
| tk | 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 | fkKI | fkKK | A | DTTR | DWVERL | DWVERLABS | IAKTIV | IRTRENN | JV | MVEC_start | MVEC_end | MVEC_sequence | PDAMPF | PHR | PMIN | PVEC_start | PVEC_end | PVEC_sequence | PVECMAX_INST_start | PVECMAX_INST_end | PVECMAX_INST_sequence | PVECMIN_INST_start | PVECMIN_INST_end | PVECMIN_INST_sequence | QMAV | QMI | QMK | RHOI | RHOK | RHOVEC_start | RHOVEC_end | RHOVEC_sequence | SVEC_start | SVEC_end | SVEC_sequence | TI | TK | TTRVEC_start | TTRVEC_end | TTRVEC_sequence | TVEC_start | TVEC_end | TVEC_sequence | VAV | VI | VK | VOLDA | WVL | ZVEC_start | ZVEC_end | ZVEC_sequence | l_sum | AGSN_Lfdnr | AGSN_Name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5691533564979419761 | Rohr V-E0 V-K1683S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 15.351700 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5025945677694931826 | OSM: Knoten 476971238 -> Knoten 299394923; Län... | 39785520 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5691533564979419761 | 5691533564979419761 | False | 713619.921383 | 5.578219e+06 | False | 5691533564979419761 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713619.921 5578218.954, 713614.649... | 5398100694284104779 | 4825391580467484032 | 0.0 | 0.000362 | 352.0946 | 5.405251 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.402028 | -55.93392 | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 15.351700 | (0.0, 7.67585, 15.3517) | 666.0 | 665.9989 | 0.000000 | 0.000362 | (0.0, 0.0001807726, 0.0003615452) | 666.0000 | 665.9989 | (666.0, 665.9995, 665.9989) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 15415.81 | 541.49 | 542.29 | (541.49, 541.89, 542.29) | 15.351701 | 1 | Längsschnitt | ||
| 1 | 5048873293262650113 | Rohr V-K1683S V-K1693S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 12.508950 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5216742060270992761 | OSM: Knoten 299394923 -> Knoten 4105649557; Lä... | 39785520 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5048873293262650113 | 5048873293262650113 | False | 713614.648712 | 5.578233e+06 | False | 5048873293262650113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.649 5578233.372, 713614.465... | 4825391580467484032 | 5180617780362861593 | 0.0 | 0.000295 | 345.6885 | 4.324201 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.327583 | -56.3209 | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 12.508950 | (0.0, 6.254475, 12.50895) | 665.9989 | 665.998 | 0.000362 | 0.000656 | (0.0003615452, 0.0005088433, 0.0006561414) | 665.9989 | 665.9980 | (665.9989, 665.9985, 665.998) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 15405.72 | 542.29 | 542.99 | (542.29, 542.64, 542.99) | 27.860648 | 1 | Längsschnitt | ||
| 2 | 5715081934973525403 | Rohr V-K2163S V-K1693S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 6.265505 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 4919359344392474301 | OSM: Knoten 299394922 -> Knoten 4105649557; Lä... | 595926249 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5715081934973525403 | 5715081934973525403 | False | 713614.369043 | 5.578252e+06 | False | 5715081934973525403 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.369 5578252.145, 713614.465... | 4964920487041183545 | 5180617780362861593 | 0.0 | 0.000148 | 345.08 | 2.1621 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169) | 15.5488 | 0.16408 | -56.51383 | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2) | 0.0 | 6.265505 | (0.0, 6.265505) | 665.9976 | 665.998 | 0.000804 | 0.000656 | (0.0008036994, 0.0006561416) | 665.9976 | 665.9980 | (665.9976, 665.998) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15397.65 | 543.33 | 542.99 | (543.33, 542.99) | 34.126153 | 1 | Längsschnitt | ||
| 3 | 5413647981880727734 | Rohr V-K2043S V-K2163S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 14.407540 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5299861566239260044 | OSM: Knoten 299394921 -> Knoten 299394922; Län... | 595926249 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5413647981880727734 | 5413647981880727734 | False | 713616.883649 | 5.578266e+06 | False | 5413647981880727734 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.884 5578266.331, 713614.369... | 4794016231137548967 | 4964920487041183545 | 0.0 | 0.000339 | 375.1682 | 5.405251 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.377303 | -56.95052 | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 14.407540 | (0.0, 7.20377, 14.40754) | 665.9966 | 665.9976 | 0.001143 | 0.000804 | (0.001143009, 0.0009733541, 0.0008036994) | 665.9966 | 665.9976 | (665.9966, 665.9971, 665.9976) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15393.61 | 544.03 | 543.33 | (544.03, 543.6801, 543.33) | 48.533695 | 1 | Längsschnitt | ||
| 4 | 5134010500800575790 | Rohr V-K2033S V-K2043S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 13.515840 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5204837016964086891 | OSM: Knoten 4105649561 -> Knoten 299394921; Lä... | 408665320 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5134010500800575790 | 5134010500800575790 | False | 713614.238695 | 5.578280e+06 | False | 5134010500800575790 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.239 5578279.586, 713616.884... | 5473123125979010325 | 4794016231137548967 | 0.0 | 0.000318 | 359.9277 | 4.864726 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.353951 | -57.34774 | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 13.515840 | (0.0, 6.75792, 13.51584) | 665.9956 | 665.9966 | 0.001461 | 0.001143 | (0.001461318, 0.001302163, 0.001143009) | 665.9956 | 665.9966 | (665.9956, 665.9961, 665.9966) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15384.03 | 544.54 | 544.03 | (544.54, 544.285, 544.03) | 62.049538 | 1 | Längsschnitt |
[13]:
dfs[0][1].head() # Lfdnr 1 RL
[13]:
| tk | 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 | fkKI | fkKK | A | DTTR | DWVERL | DWVERLABS | IAKTIV | IRTRENN | JV | MVEC_start | MVEC_end | MVEC_sequence | PDAMPF | PHR | PMIN | PVEC_start | PVEC_end | PVEC_sequence | PVECMAX_INST_start | PVECMAX_INST_end | PVECMAX_INST_sequence | PVECMIN_INST_start | PVECMIN_INST_end | PVECMIN_INST_sequence | QMAV | QMI | QMK | RHOI | RHOK | RHOVEC_start | RHOVEC_end | RHOVEC_sequence | SVEC_start | SVEC_end | SVEC_sequence | TI | TK | TTRVEC_start | TTRVEC_end | TTRVEC_sequence | TVEC_start | TVEC_end | TVEC_sequence | VAV | VI | VK | VOLDA | WVL | ZVEC_start | ZVEC_end | ZVEC_sequence | l_sum | AGSN_Lfdnr | AGSN_Name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5025945677694931826 | Rohr R-E0 R-K4163S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 15.351700 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5691533564979419761 | OSM: Knoten 476971238 -> Knoten 299394923; Län... | 39785520 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5025945677694931826 | 5025945677694931826 | False | 713621.921383 | 5.578219e+06 | False | 5025945677694931826 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713621.921 5578218.954, 713616.649... | 5160850648779674898 | 4851678476955084637 | 0.0 | 0.000362 | 352.0946 | 5.405251 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.402028 | 4.533213 | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 15.351700 | (0.0, 7.67585, 15.3517) | 662.6788 | 662.6799 | 0.020268 | 0.019906 | (0.02026793, 0.02008715, 0.01990638) | 662.6787 | 662.6798 | (662.6787, 662.6793, 662.6798) | -12.72968 | -12.72968 | -12.72968 | 0.0 | 0.0 | 541.43 | 542.20 | (541.43, 541.815, 542.2) | 15.351701 | 1 | Längsschnitt | ||
| 1 | 5216742060270992761 | Rohr R-K4163S R-K4173S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 12.508950 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5048873293262650113 | OSM: Knoten 299394923 -> Knoten 4105649557; Lä... | 39785520 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5216742060270992761 | 5216742060270992761 | False | 713616.648712 | 5.578233e+06 | False | 5216742060270992761 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.649 5578233.372, 713616.465... | 4851678476955084637 | 5469753985021987570 | 0.0 | 0.000295 | 345.6885 | 4.324201 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.327583 | 4.869907 | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 12.508950 | (0.0, 6.254475, 12.50895) | 662.6799 | 662.6807 | 0.019906 | 0.019612 | (0.01990638, 0.01975908, 0.01961179) | 662.6798 | 662.6808 | (662.6798, 662.6803, 662.6808) | -12.72968 | -12.72968 | -12.72968 | 0.0 | 0.0 | 542.20 | 542.93 | (542.2, 542.565, 542.93) | 27.860648 | 1 | Längsschnitt | ||
| 2 | 4919359344392474301 | Rohr R-K4643S R-K4173S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 6.265505 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5715081934973525403 | OSM: Knoten 299394922 -> Knoten 4105649557; Lä... | 595926249 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 4919359344392474301 | 4919359344392474301 | False | 713616.369043 | 5.578252e+06 | False | 4919359344392474301 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.369 5578252.145, 713616.465... | 5207603338578264169 | 5469753985021987570 | 0.0 | 0.000148 | 345.08 | 2.1621 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169) | 15.5488 | 0.16408 | 5.135553 | 5.269090 | 5.135555 | (5.26909, 5.135555) | 5.269090 | 5.135555 | (5.26909, 5.135555) | 5.269090 | 5.135555 | (5.26909, 5.135555) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2) | 0.0 | 6.265505 | (0.0, 6.265505) | 662.6812 | 662.6807 | 0.019464 | 0.019612 | (0.01946423, 0.01961179) | 662.6812 | 662.6808 | (662.6812, 662.6808) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 543.29 | 542.93 | (543.29, 542.93) | 34.126153 | 1 | Längsschnitt | ||
| 3 | 5299861566239260044 | Rohr R-K4523S R-K4643S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 14.407540 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5413647981880727734 | OSM: Knoten 299394921 -> Knoten 299394922; Län... | 595926249 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5299861566239260044 | 5299861566239260044 | False | 713618.883649 | 5.578266e+06 | False | 5299861566239260044 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713618.884 5578266.331, 713616.369... | 5191457421068378074 | 5207603338578264169 | 0.0 | 0.000339 | 337.6514 | 4.864726 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.377303 | 5.26909 | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 14.407540 | (0.0, 7.20377, 14.40754) | 662.6822 | 662.6812 | 0.019125 | 0.019464 | (0.01912492, 0.01929457, 0.01946423) | 662.6823 | 662.6812 | (662.6823, 662.6816, 662.6812) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 544.12 | 543.29 | (544.12, 543.705, 543.29) | 48.533695 | 1 | Längsschnitt | ||
| 4 | 5204837016964086891 | Rohr R-K4513S R-K4523S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 13.515840 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5134010500800575790 | OSM: Knoten 4105649561 -> Knoten 299394921; Lä... | 408665320 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5204837016964086891 | 5204837016964086891 | False | 713616.238695 | 5.578280e+06 | False | 5204837016964086891 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.239 5578279.586, 713618.884... | 4875054825941361274 | 5191457421068378074 | 0.0 | 0.000318 | 359.9277 | 4.864726 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.353951 | 5.575968 | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 13.515840 | (0.0, 6.75792, 13.51584) | 662.6832 | 662.6822 | 0.018807 | 0.019125 | (0.01880661, 0.01896576, 0.01912492) | 662.6831 | 662.6823 | (662.6831, 662.6826, 662.6823) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 544.60 | 544.12 | (544.6, 544.36, 544.12) | 62.049538 | 1 | Längsschnitt |
[14]:
dfs[1][0].head() # Lfdnr 2 VL
[14]:
| tk | 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 | fkKI | fkKK | A | DTTR | DWVERL | DWVERLABS | IAKTIV | IRTRENN | JV | MVEC_start | MVEC_end | MVEC_sequence | PDAMPF | PHR | PMIN | PVEC_start | PVEC_end | PVEC_sequence | PVECMAX_INST_start | PVECMAX_INST_end | PVECMAX_INST_sequence | PVECMIN_INST_start | PVECMIN_INST_end | PVECMIN_INST_sequence | QMAV | QMI | QMK | RHOI | RHOK | RHOVEC_start | RHOVEC_end | RHOVEC_sequence | SVEC_start | SVEC_end | SVEC_sequence | TI | TK | TTRVEC_start | TTRVEC_end | TTRVEC_sequence | TVEC_start | TVEC_end | TVEC_sequence | VAV | VI | VK | VOLDA | WVL | ZVEC_start | ZVEC_end | ZVEC_sequence | l_sum | AGSN_Lfdnr | AGSN_Name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5691533564979419761 | Rohr V-E0 V-K1683S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 15.351700 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5025945677694931826 | OSM: Knoten 476971238 -> Knoten 299394923; Län... | 39785520 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5691533564979419761 | 5691533564979419761 | False | 713619.921383 | 5.578219e+06 | False | 5691533564979419761 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713619.921 5578218.954, 713614.649... | 5398100694284104779 | 4825391580467484032 | 0.0 | 0.000362 | 352.0946 | 5.405251 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.402028 | -55.93392 | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | -55.46401 | -55.93392 | (-55.46401, -55.69896, -55.93392) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 15.351700 | (0.0, 7.67585, 15.3517) | 666.0 | 665.9989 | 0.000000 | 0.000362 | (0.0, 0.0001807726, 0.0003615452) | 666.0000 | 665.9989 | (666.0, 665.9995, 665.9989) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 15415.81 | 541.49 | 542.29 | (541.49, 541.89, 542.29) | 15.351701 | 2 | Längsschnitt in mlc | ||
| 1 | 5048873293262650113 | Rohr V-K1683S V-K1693S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 12.508950 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5216742060270992761 | OSM: Knoten 299394923 -> Knoten 4105649557; Lä... | 39785520 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5048873293262650113 | 5048873293262650113 | False | 713614.648712 | 5.578233e+06 | False | 5048873293262650113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.649 5578233.372, 713614.465... | 4825391580467484032 | 5180617780362861593 | 0.0 | 0.000295 | 345.6885 | 4.324201 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.327583 | -56.3209 | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | -55.93392 | -56.32089 | (-55.93392, -56.12741, -56.32089) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 12.508950 | (0.0, 6.254475, 12.50895) | 665.9989 | 665.998 | 0.000362 | 0.000656 | (0.0003615452, 0.0005088433, 0.0006561414) | 665.9989 | 665.9980 | (665.9989, 665.9985, 665.998) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 15405.72 | 542.29 | 542.99 | (542.29, 542.64, 542.99) | 27.860648 | 2 | Längsschnitt in mlc | ||
| 2 | 5715081934973525403 | Rohr V-K2163S V-K1693S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 6.265505 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 4919359344392474301 | OSM: Knoten 299394922 -> Knoten 4105649557; Lä... | 595926249 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5715081934973525403 | 5715081934973525403 | False | 713614.369043 | 5.578252e+06 | False | 5715081934973525403 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.369 5578252.145, 713614.465... | 4964920487041183545 | 5180617780362861593 | 0.0 | 0.000148 | 345.08 | 2.1621 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169) | 15.5488 | 0.16408 | -56.51383 | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -56.51382 | -56.32089 | (-56.51382, -56.32089) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2) | 0.0 | 6.265505 | (0.0, 6.265505) | 665.9976 | 665.998 | 0.000804 | 0.000656 | (0.0008036994, 0.0006561416) | 665.9976 | 665.9980 | (665.9976, 665.998) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15397.65 | 543.33 | 542.99 | (543.33, 542.99) | 34.126153 | 2 | Längsschnitt in mlc | ||
| 3 | 5413647981880727734 | Rohr V-K2043S V-K2163S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 14.407540 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5299861566239260044 | OSM: Knoten 299394921 -> Knoten 299394922; Län... | 595926249 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5413647981880727734 | 5413647981880727734 | False | 713616.883649 | 5.578266e+06 | False | 5413647981880727734 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.884 5578266.331, 713614.369... | 4794016231137548967 | 4964920487041183545 | 0.0 | 0.000339 | 375.1682 | 5.405251 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.377303 | -56.95052 | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -56.95052 | -56.51382 | (-56.95052, -56.73217, -56.51382) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 14.407540 | (0.0, 7.20377, 14.40754) | 665.9966 | 665.9976 | 0.001143 | 0.000804 | (0.001143009, 0.0009733541, 0.0008036994) | 665.9966 | 665.9976 | (665.9966, 665.9971, 665.9976) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15393.61 | 544.03 | 543.33 | (544.03, 543.6801, 543.33) | 48.533695 | 2 | Längsschnitt in mlc | ||
| 4 | 5134010500800575790 | Rohr V-K2033S V-K2043S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 13.515840 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5204837016964086891 | OSM: Knoten 4105649561 -> Knoten 299394921; Lä... | 408665320 | 0 | 1 | 0.005 | 0 | 350 | 345.6 | Vorlauf | 5134010500800575790 | 5134010500800575790 | False | 713614.238695 | 5.578280e+06 | False | 5134010500800575790 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713614.239 5578279.586, 713616.884... | 5473123125979010325 | 4794016231137548967 | 0.0 | 0.000318 | 359.9277 | 4.864726 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.353951 | -57.34774 | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -57.34774 | -56.95052 | (-57.34774, -57.14913, -56.95052) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 13.515840 | (0.0, 6.75792, 13.51584) | 665.9956 | 665.9966 | 0.001461 | 0.001143 | (0.001461318, 0.001302163, 0.001143009) | 665.9956 | 665.9966 | (665.9956, 665.9961, 665.9966) | -12.72968 | -12.72968 | -12.72968 | 0.0 | -15384.03 | 544.54 | 544.03 | (544.54, 544.285, 544.03) | 62.049538 | 2 | Längsschnitt in mlc |
[15]:
dfs[1][1].head() # Lfdnr 2 RL
[15]:
| tk | 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 | fkKI | fkKK | A | DTTR | DWVERL | DWVERLABS | IAKTIV | IRTRENN | JV | MVEC_start | MVEC_end | MVEC_sequence | PDAMPF | PHR | PMIN | PVEC_start | PVEC_end | PVEC_sequence | PVECMAX_INST_start | PVECMAX_INST_end | PVECMAX_INST_sequence | PVECMIN_INST_start | PVECMIN_INST_end | PVECMIN_INST_sequence | QMAV | QMI | QMK | RHOI | RHOK | RHOVEC_start | RHOVEC_end | RHOVEC_sequence | SVEC_start | SVEC_end | SVEC_sequence | TI | TK | TTRVEC_start | TTRVEC_end | TTRVEC_sequence | TVEC_start | TVEC_end | TVEC_sequence | VAV | VI | VK | VOLDA | WVL | ZVEC_start | ZVEC_end | ZVEC_sequence | l_sum | AGSN_Lfdnr | AGSN_Name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5025945677694931826 | Rohr R-E0 R-K4163S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 15.351700 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5691533564979419761 | OSM: Knoten 476971238 -> Knoten 299394923; Län... | 39785520 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5025945677694931826 | 5025945677694931826 | False | 713621.921383 | 5.578219e+06 | False | 5025945677694931826 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713621.921 5578218.954, 713616.649... | 5160850648779674898 | 4851678476955084637 | 0.0 | 0.000362 | 352.0946 | 5.405251 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.402028 | 4.533213 | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | 4.533215 | 4.869910 | (4.533215, 4.70156, 4.86991) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 15.351700 | (0.0, 7.67585, 15.3517) | 662.6788 | 662.6799 | 0.020268 | 0.019906 | (0.02026793, 0.02008715, 0.01990638) | 662.6787 | 662.6798 | (662.6787, 662.6793, 662.6798) | -12.72968 | -12.72968 | -12.72968 | 0.0 | 0.0 | 541.43 | 542.20 | (541.43, 541.815, 542.2) | 15.351701 | 2 | Längsschnitt in mlc | ||
| 1 | 5216742060270992761 | Rohr R-K4163S R-K4173S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 12.508950 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5048873293262650113 | OSM: Knoten 299394923 -> Knoten 4105649557; Lä... | 39785520 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5216742060270992761 | 5216742060270992761 | False | 713616.648712 | 5.578233e+06 | False | 5216742060270992761 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.649 5578233.372, 713616.465... | 4851678476955084637 | 5469753985021987570 | 0.0 | 0.000295 | 345.6885 | 4.324201 | 0.0 | 0.0 | 26.18786 | -1033.169 | -1033.169 | (-1033.169, -1033.169, -1033.169) | 15.5488 | 0.327583 | 4.869907 | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | 4.869910 | 5.135555 | (4.86991, 5.00273, 5.135555) | -3719.409 | -3719.409 | -3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 12.508950 | (0.0, 6.254475, 12.50895) | 662.6799 | 662.6807 | 0.019906 | 0.019612 | (0.01990638, 0.01975908, 0.01961179) | 662.6798 | 662.6808 | (662.6798, 662.6803, 662.6808) | -12.72968 | -12.72968 | -12.72968 | 0.0 | 0.0 | 542.20 | 542.93 | (542.2, 542.565, 542.93) | 27.860648 | 2 | Längsschnitt in mlc | ||
| 2 | 4919359344392474301 | Rohr R-K4643S R-K4173S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 6.265505 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5715081934973525403 | OSM: Knoten 299394922 -> Knoten 4105649557; Lä... | 595926249 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 4919359344392474301 | 4919359344392474301 | False | 713616.369043 | 5.578252e+06 | False | 4919359344392474301 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.369 5578252.145, 713616.465... | 5207603338578264169 | 5469753985021987570 | 0.0 | 0.000148 | 345.08 | 2.1621 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169) | 15.5488 | 0.16408 | 5.135553 | 5.269090 | 5.135555 | (5.26909, 5.135555) | 5.269090 | 5.135555 | (5.26909, 5.135555) | 5.269090 | 5.135555 | (5.26909, 5.135555) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2) | 0.0 | 6.265505 | (0.0, 6.265505) | 662.6812 | 662.6807 | 0.019464 | 0.019612 | (0.01946423, 0.01961179) | 662.6812 | 662.6808 | (662.6812, 662.6808) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 543.29 | 542.93 | (543.29, 542.93) | 34.126153 | 2 | Längsschnitt in mlc | ||
| 3 | 5299861566239260044 | Rohr R-K4523S R-K4643S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 14.407540 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5413647981880727734 | OSM: Knoten 299394921 -> Knoten 299394922; Län... | 595926249 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5299861566239260044 | 5299861566239260044 | False | 713618.883649 | 5.578266e+06 | False | 5299861566239260044 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713618.884 5578266.331, 713616.369... | 5191457421068378074 | 5207603338578264169 | 0.0 | 0.000339 | 337.6514 | 4.864726 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.377303 | 5.26909 | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 5.575970 | 5.269090 | (5.57597, 5.42253, 5.26909) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 14.407540 | (0.0, 7.20377, 14.40754) | 662.6822 | 662.6812 | 0.019125 | 0.019464 | (0.01912492, 0.01929457, 0.01946423) | 662.6823 | 662.6812 | (662.6823, 662.6816, 662.6812) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 544.12 | 543.29 | (544.12, 543.705, 543.29) | 48.533695 | 2 | Längsschnitt in mlc | ||
| 4 | 5204837016964086891 | Rohr R-K4513S R-K4523S | 4816511167455310973 | 4779752876656844188 | 5204829332281547346 | 13.515840 | 0 | 0.05 | 1 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 5029128874972463118 | 5134010500800575790 | OSM: Knoten 4105649561 -> Knoten 299394921; Lä... | 408665320 | 0 | 2 | 0.005 | 0 | 350 | 345.6 | Rücklauf | 5204837016964086891 | 5204837016964086891 | False | 713616.238695 | 5.578280e+06 | False | 5204837016964086891 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LINESTRING (713616.239 5578279.586, 713618.884... | 4875054825941361274 | 5191457421068378074 | 0.0 | 0.000318 | 359.9277 | 4.864726 | 0.0 | 0.0 | 26.18786 | 1033.169 | 1033.169 | (1033.169, 1033.169, 1033.169) | 15.5488 | 0.353951 | 5.575968 | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 5.889195 | 5.575970 | (5.889195, 5.73258, 5.57597) | 3719.409 | 3719.409 | 3719.409 | 865.2 | 865.2 | 865.2 | 865.2 | (865.2, 865.2, 865.2) | 0.0 | 13.515840 | (0.0, 6.75792, 13.51584) | 662.6832 | 662.6822 | 0.018807 | 0.019125 | (0.01880661, 0.01896576, 0.01912492) | 662.6831 | 662.6823 | (662.6831, 662.6826, 662.6823) | 12.72968 | 12.72968 | 12.72968 | 0.0 | 0.0 | 544.60 | 544.12 | (544.6, 544.36, 544.12) | 62.049538 | 2 | Längsschnitt in mlc |
Edge dataframe
Can be used to create user-defined graphs.
[16]:
(s3s.generate_edge_dataframe()).head(5)
[2026-03-03 15:33:16,246] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe
[2026-03-03 15:33:16,252] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 524 element(s) of element type ObjectTypes.Pipe.
[2026-03-03 15:33:16,258] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:16,259] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:17,472] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:17,799] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:17,804] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (524, 6)
[2026-03-03 15:33:17,809] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Valve
[2026-03-03 15:33:17,815] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 12 element(s) of element type ObjectTypes.Valve.
[2026-03-03 15:33:17,826] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:17,829] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:18,834] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:18,923] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:18,927] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (12, 6)
[2026-03-03 15:33:18,936] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.FlapValve
[2026-03-03 15:33:18,947] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 3 element(s) of element type ObjectTypes.FlapValve.
[2026-03-03 15:33:18,955] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:18,959] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:19,030] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:19,117] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:19,118] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (3, 6)
[2026-03-03 15:33:19,128] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pump
[2026-03-03 15:33:19,134] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 2 element(s) of element type ObjectTypes.Pump.
[2026-03-03 15:33:19,145] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:19,149] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:19,575] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:19,616] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:19,619] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (2, 6)
[2026-03-03 15:33:19,623] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingConsumer
[2026-03-03 15:33:19,630] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 337 element(s) of element type ObjectTypes.DistrictHeatingConsumer.
[2026-03-03 15:33:19,640] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:19,644] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:19,928] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:20,036] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:20,040] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (337, 6)
[2026-03-03 15:33:20,047] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingFeeder
[2026-03-03 15:33:20,051] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.DistrictHeatingFeeder.
[2026-03-03 15:33:20,058] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:20,061] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:20,119] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.
[2026-03-03 15:33:20,160] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:20,163] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 6)
[2026-03-03 15:33:20,168] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.HeatExchanger
[2026-03-03 15:33:20,174] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 1 element(s) of element type ObjectTypes.HeatExchanger.
[2026-03-03 15:33:20,180] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 1 model_data properties.
[2026-03-03 15:33:20,184] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Fkcont'], geometry, end nodes...
[2026-03-03 15:33:20,290] INFO in sir3stoolkit.mantle.dataframes: [model_data] 4 non-empty end node columns were created.
[2026-03-03 15:33:20,363] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832
[2026-03-03 15:33:20,396] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (1, 8)
[2026-03-03 15:33:20,424] INFO in sir3stoolkit.mantle.dataframes: [edge dataframe] Retrieved 880 edges from 17 element types.
[16]:
| tk | Fkcont | geometry | fkKI | fkKK | element type | fkKI2 | fkKK2 | |
|---|---|---|---|---|---|---|---|---|
| 0 | 5442010239090746007 | 5029128874972463118 | LINESTRING (713620.268 5578828.419, 713602.295... | 5669301360686511351 | 5397948523091900401 | Pipe | NaN | NaN |
| 1 | 4917786378639043296 | 5029128874972463118 | LINESTRING (713602.295 5578860.106, 713574.062... | 5397948523091900401 | 5239335112004772156 | Pipe | NaN | NaN |
| 2 | 4762482310382009633 | 5029128874972463118 | LINESTRING (713574.062 5578909.873, 713553.84 ... | 5239335112004772156 | 5298886695042021307 | Pipe | NaN | NaN |
| 3 | 4987229536643024523 | 5029128874972463118 | LINESTRING (713553.84 5578945.533, 713553.394 ... | 5298886695042021307 | 4993257270457791438 | Pipe | NaN | NaN |
| 4 | 5722206630503885118 | 5029128874972463118 | LINESTRING (713553.394 5578952.352, 713556.294... | 4993257270457791438 | 5317865645994989592 | Pipe | NaN | NaN |