{ "cells": [ { "cell_type": "markdown", "id": "51318db4", "metadata": {}, "source": [ "# Tutorial 56: Nominal Diameter Tables" ] }, { "cell_type": "markdown", "id": "0d2f2a27", "metadata": {}, "source": [ "## SIR 3S Toolkit" ] }, { "cell_type": "markdown", "id": "b0a268ca", "metadata": {}, "source": [ "### Regular Import/Init" ] }, { "cell_type": "code", "execution_count": 1, "id": "af4c5450", "metadata": {}, "outputs": [], "source": [ "SIR3S_SIRGRAF_DIR = r\"C:\\3S\\SIR 3S\\SirGraf-90-15-00-24_Quebec-Upd2\" #change to local path" ] }, { "cell_type": "code", "execution_count": 2, "id": "5ef15f78", "metadata": {}, "outputs": [], "source": [ "from sir3stoolkit.core import wrapper" ] }, { "cell_type": "code", "execution_count": 3, "id": "e0ff7415", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wrapper" ] }, { "cell_type": "code", "execution_count": 4, "id": "eba83a9a", "metadata": {}, "outputs": [], "source": [ "wrapper.Initialize_Toolkit(SIR3S_SIRGRAF_DIR)" ] }, { "cell_type": "markdown", "id": "e919a4d1", "metadata": {}, "source": [ "### Additional Import/Init for Dataframes class" ] }, { "cell_type": "code", "execution_count": 5, "id": "d386e0bc", "metadata": {}, "outputs": [], "source": [ "from sir3stoolkit.mantle.dataframes import SIR3S_Model_Dataframes" ] }, { "cell_type": "code", "execution_count": 6, "id": "194afca0", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Initialization complete\n" ] } ], "source": [ "s3s = SIR3S_Model_Dataframes()" ] }, { "cell_type": "markdown", "id": "e1013018", "metadata": {}, "source": [ "## Additional" ] }, { "cell_type": "code", "execution_count": 7, "id": "ffec4423", "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": "ab5184d3", "metadata": {}, "source": [ "# Open Model" ] }, { "cell_type": "code", "execution_count": 8, "id": "35154b33", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Model is open for further operation\n" ] } ], "source": [ "s3s.OpenModel(dbName=r\"Toolkit_Tutorial56_Model.db3\",\n", " providerType=s3s.ProviderTypes.SQLite,\n", " Mid=\"M-1-0-1\",\n", " saveCurrentlyOpenModel=False,\n", " namedInstance=\"\",\n", " userID=\"\",\n", " password=\"\")" ] }, { "cell_type": "markdown", "id": "a8e09cb3", "metadata": {}, "source": [ "# View Nominal Diameter Tables" ] }, { "cell_type": "markdown", "id": "3e7e703b", "metadata": {}, "source": [ "We can use the function [get_dataframes_from_nominal_diameter_tables()](https://3sconsult.github.io/sir3stoolkit/references/sir3stoolkit.mantle.html#sir3stoolkit.mantle.dataframes.SIR3S_Model_Dataframes.get_dataframes_from_nominal_diameter_tables) to obtain a dictionary of all nominal diameter tables." ] }, { "cell_type": "code", "execution_count": 9, "id": "985ff074", "metadata": {}, "outputs": [], "source": [ "_, dfs, tks = s3s.get_dataframes_from_nominal_diameter_tables()" ] }, { "cell_type": "code", "execution_count": 10, "id": "9c4840c7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "0: 4929824488020291605: STDROHR\n", "1: 4862079620528720750: FLEXWELL-F\n", "2: 5157457566256524875: STDROHR_2\n", "3: 4927972999088213410: KMR\n" ] } ], "source": [ "for id, tk in enumerate(tks):\n", " print(f\"{id}: {tk}: {s3s.GetValue(tk, 'Name')[0]}\")" ] }, { "cell_type": "markdown", "id": "724f1864", "metadata": {}, "source": [ "Now we can view the individual nominal diameter tables." ] }, { "cell_type": "markdown", "id": "5c379b0c", "metadata": {}, "source": [ "## STDROHR" ] }, { "cell_type": "code", "execution_count": 11, "id": "79db8661", "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", "
tk_mergeTable NameNameFkDnDiDaSWsteigWtiefeKtPnAusfallzeitReparaturRehabilitationTkPkInVariant
05515865002497708428STDROHRDN 349298244880202916053300000000055158650024977084285515865002497708428False
15623248152587240406STDROHRDN 449298244880202916054400000000056232481525872404065623248152587240406False
25195383577550917235STDROHRDN 549298244880202916055500000000051953835775509172355195383577550917235False
\n", "
" ], "text/plain": [ " tk_merge Table Name Name Fk Dn Di Da S \\\n", "0 5515865002497708428 STDROHR DN 3 4929824488020291605 3 3 0 0 \n", "1 5623248152587240406 STDROHR DN 4 4929824488020291605 4 4 0 0 \n", "2 5195383577550917235 STDROHR DN 5 4929824488020291605 5 5 0 0 \n", "\n", " Wsteig Wtiefe Kt Pn Ausfallzeit Reparatur Rehabilitation \\\n", "0 0 0 0 0 0 0 0 \n", "1 0 0 0 0 0 0 0 \n", "2 0 0 0 0 0 0 0 \n", "\n", " Tk Pk InVariant \n", "0 5515865002497708428 5515865002497708428 False \n", "1 5623248152587240406 5623248152587240406 False \n", "2 5195383577550917235 5195383577550917235 False " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[tks[0]].head(3)" ] }, { "cell_type": "markdown", "id": "440bcaaa", "metadata": {}, "source": [ "## KMR" ] }, { "cell_type": "code", "execution_count": 12, "id": "2acc3e35", "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", "
tk_mergeTable NameNameFkDnDiDaSWsteigWtiefeKtPnAusfallzeitReparaturRehabilitationTkPkInVariant
05636244102636904922KMRDN 2549279729990882134102522,326,92,3000,1900010056362441026369049225636244102636904922False
14845758090437917162KMRDN 3249279729990882134103228,533,72,6000,19500020048457580904379171624845758090437917162False
25728256818453294508KMRDN 5049279729990882134105054,560,32,9000,22500030057282568184532945085728256818453294508False
\n", "
" ], "text/plain": [ " tk_merge Table Name Name Fk Dn Di Da \\\n", "0 5636244102636904922 KMR DN 25 4927972999088213410 25 22,3 26,9 \n", "1 4845758090437917162 KMR DN 32 4927972999088213410 32 28,5 33,7 \n", "2 5728256818453294508 KMR DN 50 4927972999088213410 50 54,5 60,3 \n", "\n", " S Wsteig Wtiefe Kt Pn Ausfallzeit Reparatur Rehabilitation \\\n", "0 2,3 0 0 0,19 0 0 0 100 \n", "1 2,6 0 0 0,195 0 0 0 200 \n", "2 2,9 0 0 0,225 0 0 0 300 \n", "\n", " Tk Pk InVariant \n", "0 5636244102636904922 5636244102636904922 False \n", "1 4845758090437917162 4845758090437917162 False \n", "2 5728256818453294508 5728256818453294508 False " ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dfs[tks[3]].head(3)" ] }, { "cell_type": "markdown", "id": "07b1c459", "metadata": {}, "source": [ "# df pipes" ] }, { "cell_type": "markdown", "id": "418ada40", "metadata": {}, "source": [ "When creating a element dataframe of pipes, the nominal diameter table values will automatically be added with the prefix \"PipeTable:\"." ] }, { "cell_type": "code", "execution_count": 13, "id": "3ef2bd60", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "[2026-03-27 18:30:38,411] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n", "[2026-03-27 18:30:38,414] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n", "[2026-03-27 18:30:39,221] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-27 18:30:39,232] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-27 18:30:39,308] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n", "[2026-03-27 18:30:39,310] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n", "[2026-03-27 18:30:39,313] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n", "[2026-03-27 18:30:45,561] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n", "[2026-03-27 18:30:46,019] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n", "[2026-03-27 18:30:46,020] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (524, 67)\n", "[2026-03-27 18:30:46,141] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n", "[2026-03-27 18:30:46,141] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n", "[2026-03-27 18:30:46,271] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n", "[2026-03-27 18:30:46,272] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n", "[2026-03-27 18:30:46,276] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n", "[2026-03-27 18:30:46,281] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n", "[2026-03-27 18:30:46,326] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n", "[2026-03-27 18:30:56,801] INFO in sir3stoolkit.mantle.dataframes: [results] 26724 fully NaN columns dropped.\n", "[2026-03-27 18:31:00,716] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 16244)\n", "[2026-03-27 18:31:00,723] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n" ] } ], "source": [ "df_pipes = s3s.generate_element_dataframe(element_type=s3s.ObjectTypes.Pipe)" ] }, { "cell_type": "code", "execution_count": 14, "id": "05b5f57d", "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", "
tkNameFkdtroRowdFkltgrFkstrasseLLzuRauJlambsLambda0ZeinZausZumlAsollIndschallBaujahrHalFkcontFk2lrohrBeschreibungIdreferenzIplanungKvrLineWidthMMDottedLineDNDiKvrKlartextHasClosedNSCHsTkPkInVariantXkorYkorGeometriesDifferbz.Fkbz.Qsvbbz.Irtrennbz.Leckstatusbz.Leckstartbz.Leckendbz.Leckortbz.Leckmengebz.Imptnzbz.Zvlimptnzbz.Kantenzvbz.ITrennWithNSCHgeometryfkKIfkKKPipeTable: Table NamePipeTable: NamePipeTable: FkPipeTable: DnPipeTable: DiPipeTable: DaPipeTable: SPipeTable: WsteigPipeTable: WtiefePipeTable: KtPipeTable: PnPipeTable: AusfallzeitPipeTable: ReparaturPipeTable: RehabilitationPipeTable: TkPipeTable: PkPipeTable: InVariantADTTRDWVERLDWVERLABSIAKTIVIRTRENNJVMVEC_startMVEC_endMVEC_sequencePDAMPFPHRPMINPVEC_startPVEC_endPVEC_sequencePVECMAX_INST_startPVECMAX_INST_endPVECMAX_INST_sequencePVECMIN_INST_startPVECMIN_INST_endPVECMIN_INST_sequenceQMAVQMIQMKRHOIRHOKRHOVEC_startRHOVEC_endRHOVEC_sequenceSVEC_startSVEC_endSVEC_sequenceTITKTTRVEC_startTTRVEC_endTTRVEC_sequenceTVEC_startTVEC_endTVEC_sequenceVAVVIVKVOLDAWVLZVEC_startZVEC_endZVEC_sequence
04614463970292122863Rohr R-K4383S R-K4183S4689226368751411179477975287665684418854318450289033820317.78067400.051000010000050291288749724631184713734746689397424OSM: Knoten 450994211 -> Knoten 476971188; Län...166815824520.0050999994.0Rücklauf46144639702921228634614463970292122863False714262.4829305.578857e+06False461446397029212286300000000000LINESTRING (714262.483 5578857.42, 714269.543 ...47300660590899618574917189080965035120KMRDN 9994927972999088213410999994.01014.010.0001.212000195046892263687514111794689226368751411179False0.07.7806740.00.01.00.00.05.748007e-105.748007e-10(5.748007e-10, 5.748007e-10)0.01230.01.6150571.6150551.68863(1.615055, 1.68863)1.6150551.68863(1.615055, 1.68863)1.6150551.68863(1.615055, 1.68863)0.00.00.01000.31000.31000.30001000.3000(1000.3, 1000.3)0.07.780674(0.0, 7.780674)9.9999949.999994166.698300174.479000(166.6983, 174.479)10.000010.000(10.0, 10.0)0.00.00.00.00.0545.09544.34(545.09, 544.34)
14615723899944629797Rohr V-K203S V-K213S46892263687514111794779752876656844188572872605962003672664.28724000.051000010000050291288749724631184938076287810941486OSM: Knoten 390310977 -> Knoten 1368674233; Lä...24633100510.0050999994.0Vorlauf46157238999446297974615723899944629797False713738.2965675.579220e+06False461572389994462979700000000000LINESTRING (713738.297 5579219.902, 713793.23 ...51295843724586621505332825919690090061KMRDN 9994927972999088213410999994.01014.010.0001.212000195046892263687514111794689226368751411179False0.064.287240.00.01.00.00.0-2.983143e-10-2.983143e-10(-2.983143e-10, -2.983143e-10, -2.983143e-10, ...0.01230.03.3047693.3047703.59023(3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ...3.3047703.59023(3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ...3.3047703.59023(3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ...-0.0-0.0-0.01000.31000.31000.30001000.3000(1000.3, 1000.3, 1000.3, 1000.3, 1000.3, 1000....0.064.287240(0.0, 9.183891, 18.36778, 27.55167, 36.73557, ...9.9999949.999994107.36690043.079700(107.3669, 98.18304, 88.99916, 79.81527, 70.63...10.000010.000(10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0)-0.0-0.0-0.00.00.0565.84562.93(565.84, 565.4243, 565.0086, 564.5929, 564.177...
24621030304810285220Rohr R-K2573S R-K2583S5516336706687055417477975287665684418856448814175126160953.95683800.051000010000050291288749724631185625716875961234775OSM: Knoten 476971211 -> Knoten 264607350; Län...24386111020.0050100107.1Rücklauf46210303048102852204621030304810285220False713650.6134005.578990e+06False462103030481028522000000000000LINESTRING (713650.613 5578990.488, 713649.498...50707955801682839125725848577942138606KMRDN 1004927972999088213410100107.1114.33.6000.32500060055163367066870554175516336706687055417False0.00.00229116.26220.0643470.00.00.211137-4.251046e+00-4.251046e+00(-4.251046, -4.251046)0.1980230.0008352.1986622.2103702.19866(2.21037, 2.19866)2.2103702.19866(2.21037, 2.19866)2.2103702.19866(2.21037, 2.19866)-15.30376-15.30376-15.30376983.7663983.7645983.7663983.7645(983.7663, 983.7645)0.03.956838(0.0, 3.956838)59.8673959.8710.0554510.053159(0.05545081, 0.05315936)59.867459.871(59.8674, 59.871)-0.479662-0.479662-0.4796620.00.0563.01563.14(563.01, 563.14)
\n", "
" ], "text/plain": [ " tk Name FkdtroRowd \\\n", "0 4614463970292122863 Rohr R-K4383S R-K4183S 4689226368751411179 \n", "1 4615723899944629797 Rohr V-K203S V-K213S 4689226368751411179 \n", "2 4621030304810285220 Rohr R-K2573S R-K2583S 5516336706687055417 \n", "\n", " Fkltgr Fkstrasse L Lzu Rau Jlambs \\\n", "0 4779752876656844188 5431845028903382031 7.780674 0 0.05 1 \n", "1 4779752876656844188 5728726059620036726 64.287240 0 0.05 1 \n", "2 4779752876656844188 5644881417512616095 3.956838 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 4713734746689397424 \n", "1 5029128874972463118 4938076287810941486 \n", "2 5029128874972463118 5625716875961234775 \n", "\n", " Beschreibung Idreferenz Iplanung \\\n", "0 OSM: Knoten 450994211 -> Knoten 476971188; Län... 166815824 5 \n", "1 OSM: Knoten 390310977 -> Knoten 1368674233; Lä... 24633100 5 \n", "2 OSM: Knoten 476971211 -> Knoten 264607350; Län... 24386111 0 \n", "\n", " Kvr LineWidthMM DottedLine DN Di KvrKlartext HasClosedNSCHs \\\n", "0 2 0.005 0 999 994.0 Rücklauf \n", "1 1 0.005 0 999 994.0 Vorlauf \n", "2 2 0.005 0 100 107.1 Rücklauf \n", "\n", " Tk Pk InVariant Xkor \\\n", "0 4614463970292122863 4614463970292122863 False 714262.482930 \n", "1 4615723899944629797 4615723899944629797 False 713738.296567 \n", "2 4621030304810285220 4621030304810285220 False 713650.613400 \n", "\n", " Ykor GeometriesDiffer bz.Fk bz.Qsvb bz.Irtrenn \\\n", "0 5.578857e+06 False 4614463970292122863 0 0 \n", "1 5.579220e+06 False 4615723899944629797 0 0 \n", "2 5.578990e+06 False 4621030304810285220 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 (714262.483 5578857.42, 714269.543 ... 4730066059089961857 \n", "1 LINESTRING (713738.297 5579219.902, 713793.23 ... 5129584372458662150 \n", "2 LINESTRING (713650.613 5578990.488, 713649.498... 5070795580168283912 \n", "\n", " fkKK PipeTable: Table Name PipeTable: Name \\\n", "0 4917189080965035120 KMR DN 999 \n", "1 5332825919690090061 KMR DN 999 \n", "2 5725848577942138606 KMR DN 100 \n", "\n", " PipeTable: Fk PipeTable: Dn PipeTable: Di PipeTable: Da \\\n", "0 4927972999088213410 999 994.0 1014.0 \n", "1 4927972999088213410 999 994.0 1014.0 \n", "2 4927972999088213410 100 107.1 114.3 \n", "\n", " PipeTable: S PipeTable: Wsteig PipeTable: Wtiefe PipeTable: Kt \\\n", "0 10.0 0 0 1.212 \n", "1 10.0 0 0 1.212 \n", "2 3.6 0 0 0.325 \n", "\n", " PipeTable: Pn PipeTable: Ausfallzeit PipeTable: Reparatur \\\n", "0 0 0 0 \n", "1 0 0 0 \n", "2 0 0 0 \n", "\n", " PipeTable: Rehabilitation PipeTable: Tk PipeTable: Pk \\\n", "0 1950 4689226368751411179 4689226368751411179 \n", "1 1950 4689226368751411179 4689226368751411179 \n", "2 600 5516336706687055417 5516336706687055417 \n", "\n", " PipeTable: InVariant A DTTR DWVERL DWVERLABS IAKTIV IRTRENN \\\n", "0 False 0.0 7.780674 0.0 0.0 1.0 0.0 \n", "1 False 0.0 64.28724 0.0 0.0 1.0 0.0 \n", "2 False 0.0 0.002291 16.2622 0.064347 0.0 0.0 \n", "\n", " JV MVEC_start MVEC_end \\\n", "0 0.0 5.748007e-10 5.748007e-10 \n", "1 0.0 -2.983143e-10 -2.983143e-10 \n", "2 0.211137 -4.251046e+00 -4.251046e+00 \n", "\n", " MVEC_sequence PDAMPF PHR \\\n", "0 (5.748007e-10, 5.748007e-10) 0.0123 0.0 \n", "1 (-2.983143e-10, -2.983143e-10, -2.983143e-10, ... 0.0123 0.0 \n", "2 (-4.251046, -4.251046) 0.198023 0.000835 \n", "\n", " PMIN PVEC_start PVEC_end \\\n", "0 1.615057 1.615055 1.68863 \n", "1 3.304769 3.304770 3.59023 \n", "2 2.198662 2.210370 2.19866 \n", "\n", " PVEC_sequence PVECMAX_INST_start \\\n", "0 (1.615055, 1.68863) 1.615055 \n", "1 (3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ... 3.304770 \n", "2 (2.21037, 2.19866) 2.210370 \n", "\n", " PVECMAX_INST_end PVECMAX_INST_sequence \\\n", "0 1.68863 (1.615055, 1.68863) \n", "1 3.59023 (3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ... \n", "2 2.19866 (2.21037, 2.19866) \n", "\n", " PVECMIN_INST_start PVECMIN_INST_end \\\n", "0 1.615055 1.68863 \n", "1 3.304770 3.59023 \n", "2 2.210370 2.19866 \n", "\n", " PVECMIN_INST_sequence QMAV QMI \\\n", "0 (1.615055, 1.68863) 0.0 0.0 \n", "1 (3.30477, 3.34555, 3.38633, 3.42711, 3.46789, ... -0.0 -0.0 \n", "2 (2.21037, 2.19866) -15.30376 -15.30376 \n", "\n", " QMK RHOI RHOK RHOVEC_start RHOVEC_end \\\n", "0 0.0 1000.3 1000.3 1000.3000 1000.3000 \n", "1 -0.0 1000.3 1000.3 1000.3000 1000.3000 \n", "2 -15.30376 983.7663 983.7645 983.7663 983.7645 \n", "\n", " RHOVEC_sequence SVEC_start SVEC_end \\\n", "0 (1000.3, 1000.3) 0.0 7.780674 \n", "1 (1000.3, 1000.3, 1000.3, 1000.3, 1000.3, 1000.... 0.0 64.287240 \n", "2 (983.7663, 983.7645) 0.0 3.956838 \n", "\n", " SVEC_sequence TI TK \\\n", "0 (0.0, 7.780674) 9.999994 9.999994 \n", "1 (0.0, 9.183891, 18.36778, 27.55167, 36.73557, ... 9.999994 9.999994 \n", "2 (0.0, 3.956838) 59.86739 59.871 \n", "\n", " TTRVEC_start TTRVEC_end \\\n", "0 166.698300 174.479000 \n", "1 107.366900 43.079700 \n", "2 0.055451 0.053159 \n", "\n", " TTRVEC_sequence TVEC_start TVEC_end \\\n", "0 (166.6983, 174.479) 10.0000 10.000 \n", "1 (107.3669, 98.18304, 88.99916, 79.81527, 70.63... 10.0000 10.000 \n", "2 (0.05545081, 0.05315936) 59.8674 59.871 \n", "\n", " TVEC_sequence VAV VI \\\n", "0 (10.0, 10.0) 0.0 0.0 \n", "1 (10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0) -0.0 -0.0 \n", "2 (59.8674, 59.871) -0.479662 -0.479662 \n", "\n", " VK VOLDA WVL ZVEC_start ZVEC_end \\\n", "0 0.0 0.0 0.0 545.09 544.34 \n", "1 -0.0 0.0 0.0 565.84 562.93 \n", "2 -0.479662 0.0 0.0 563.01 563.14 \n", "\n", " ZVEC_sequence \n", "0 (545.09, 544.34) \n", "1 (565.84, 565.4243, 565.0086, 564.5929, 564.177... \n", "2 (563.01, 563.14) " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_pipes.head(3)" ] }, { "cell_type": "markdown", "id": "039e7bf7", "metadata": {}, "source": [ "We can access for example the heat loss of pipes, that is saved in the nominal diameter table." ] }, { "cell_type": "code", "execution_count": 15, "id": "b5d769af", "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", "
tkNamePipeTable: Table NamePipeTable: Kt
04614463970292122863Rohr R-K4383S R-K4183SKMR1.212
14615723899944629797Rohr V-K203S V-K213SKMR1.212
24621030304810285220Rohr R-K2573S R-K2583SKMR0.325
\n", "
" ], "text/plain": [ " tk Name PipeTable: Table Name \\\n", "0 4614463970292122863 Rohr R-K4383S R-K4183S KMR \n", "1 4615723899944629797 Rohr V-K203S V-K213S KMR \n", "2 4621030304810285220 Rohr R-K2573S R-K2583S KMR \n", "\n", " PipeTable: Kt \n", "0 1.212 \n", "1 1.212 \n", "2 0.325 " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_pipes[[\"tk\", \"Name\", \"PipeTable: Table Name\", \"PipeTable: Kt\"]].head(3)" ] } ], "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 }