{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5556432f",
   "metadata": {},
   "source": [
    "# Tutorial 52: General Creation of 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 about elements such as Nodes, Pipes, etc. existing in a SIR 3S Model. The methods presented are not user-defined and neither efficient, but get you the most important information quickly. For more detailed methods of creating dataframes, see Tutorial 51."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e2d40c36",
   "metadata": {},
   "source": [
    "# Toolkit Release"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7fb5a07b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#pip install "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6773e12",
   "metadata": {},
   "source": [
    "# Imports"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "134689cf",
   "metadata": {},
   "source": [
    "## SIR 3S Toolkit"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69665f68",
   "metadata": {},
   "source": [
    "### Regular Import/Init"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "79d0fb2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "SIR3S_SIRGRAF_DIR = r\"C:\\3S\\SIR 3S\\SirGraf-90-15-00-24_Quebec-Upd2\" #change to local path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0f41d17a",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sir3stoolkit.core import wrapper"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d539c981",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<module 'sir3stoolkit.core.wrapper' from 'C:\\\\Users\\\\aUsername\\\\3S\\\\sir3stoolkit\\\\src\\\\sir3stoolkit\\\\core\\\\wrapper.py'>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wrapper"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "37d59df0",
   "metadata": {},
   "outputs": [],
   "source": [
    "wrapper.Initialize_Toolkit(SIR3S_SIRGRAF_DIR)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ebf2c56e",
   "metadata": {},
   "source": [
    "### Additional Import/Init for Dataframes class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "893f889e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sir3stoolkit.mantle.dataframes import SIR3S_Model_Dataframes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4b65297f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Initialization complete\n"
     ]
    }
   ],
   "source": [
    "s3s = SIR3S_Model_Dataframes()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2007993a",
   "metadata": {},
   "source": [
    "## Additional"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3a443734",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from shapely.geometry import Point\n",
    "import re\n",
    "import folium\n",
    "from folium.plugins import HeatMap\n",
    "import numpy as np\n",
    "import geopandas as gpd\n",
    "from shapely import wkt\n",
    "import matplotlib.pyplot as plt\n",
    "import contextily as cx"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d9a78e4d",
   "metadata": {},
   "source": [
    "# Open Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "20ff3c21",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Model is open for further operation\n"
     ]
    }
   ],
   "source": [
    "s3s.OpenModel(dbName=r\"Toolkit_Tutorial52_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": "95781c49",
   "metadata": {},
   "source": [
    "# Calculate Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "410661f7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Model Calculation is complete\n"
     ]
    }
   ],
   "source": [
    "s3s.ExecCalculation(True) # To ensure result data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ccc8f89c",
   "metadata": {},
   "source": [
    "# Generate Element Dataframes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8d6189f7",
   "metadata": {},
   "source": [
    "We can use the [generate_element_dataframe()](https://3sconsult.github.io/sir3stoolkit/references/sir3stoolkit.mantle.html#sir3stoolkit.mantle.dataframes.SIR3S_Model_Dataframes.generate_element_dataframe) method to quickly generate basic dataframes containing all instances of hydraulic element types (Node, Pipe, etc.) in a SIR 3S model. "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e94e2f37",
   "metadata": {},
   "source": [
    "All model_data and most result values (self.GetResultProperties_from_elementType(onlySelectedVectors=True)) for the static timestamp are included. Result values are given as floats, unless they are in vectorized form (relevant only for pipes), in that case they are strings."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bfe6454d",
   "metadata": {},
   "source": [
    "The pd.Dataframe will automatically be transformed into a gpd.GeoDataFrame if a SRID is defined in the model, after a geometry column is created."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "16e105ab",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['AGSN_HydraulicProfile', 'AirVessel', 'Arrow', 'Atmosphere', 'BlockConnectionNode', 'CalcPari', 'CharacteristicLossTable', 'CharacteristicLossTable_Row', 'Circle', 'Compressor', 'CompressorTable', 'CompressorTable_Row', 'ControlEngineeringNexus', 'ControlMode', 'ControlPointTable', 'ControlPointTable_Row', 'ControlValve', 'ControlVariableConverter', 'ControlVariableConverterRSTE', 'CrossSectionTable', 'CrossSectionTable_Row', 'DPGR_DPKT_DatapointDpgrConnection', 'DPGR_DataPointGroup', 'DPKT_Datapoint', 'DamageRatesTable', 'DamageRatesTable_Row', 'DeadTimeElement', 'Demand', 'DifferentialRegulator', 'DirectionalArrow', 'DistrictHeatingConsumer', 'DistrictHeatingFeeder', 'Divider', 'DriveEfficiencyTable', 'DriveEfficiencyTable_Row', 'DrivePowerTable', 'DrivePowerTable_Row', 'EBES_FeederGroups', 'EfficiencyConverterTable', 'EfficiencyConverterTable_Row', 'ElementQuery', 'EnergyRecoveryTable', 'EnergyRecoveryTable_Row', 'EnvironmentTemp', 'FWBZ_DistrictHeatingReferenceValues', 'FlapValve', 'FlowControlUnit', 'FluidQualityParamSet', 'FluidQualityParamSet_OS', 'FluidThermalPropertyGroup', 'FreeDuct', 'FunctionGenerator', 'FunctionTable', 'FunctionTable_Row', 'GasComponent', 'GasMixture', 'GeneralSection', 'Gravitation', 'HeatExchanger', 'HeatFeederConsumerStation', 'HeaterCooler', 'Histeresis', 'House', 'Hydrant', 'Integrator', 'LAYR_Layer', 'LoadFactorTable', 'LoadFactorTable_Row', 'LogicalComparison', 'LogicalStorage', 'MeasuredVariableTable', 'MeasuredVariableTable_Row', 'MinMaxSelection', 'Multiplier', 'NetValve', 'Node', 'NonReturnValvesTable', 'NonReturnValvesTable_Row', 'NumericalDisplay', 'ObjectContainerSymbol', 'OpenContainer', 'Oval', 'PARZ_TransientCalculationParameters', 'PhaseSeparation', 'PidController', 'Pipe', 'PipeGroup', 'PipeTable', 'PipeTable_Row', 'PipeVertex', 'Polygon', 'Polyline', 'PressureRegulator', 'PressureZone', 'Pt1Controller', 'Pump', 'PumpCharTable', 'PumpCharTable_Row', 'PumpGroup', 'PumpOfPumpGroup', 'PumpSpeedTable', 'PumpSpeedTable_Row', 'RART_ControlMode', 'REGP_ControlParameters', 'RMES_DPTS_RmesInternalDataPoint', 'Rectangle', 'RegulatorsTable', 'RegulatorsTable_Row', 'ReturnTemperaturTable', 'ReturnTemperaturTable_Row', 'RoundRectangle', 'SIRGRAF', 'SPLZ_TimeSeries', 'SafetyValve', 'SetpointDevice', 'SolarCollector', 'StandPipe', 'Street', 'SummingPoint', 'SwitchInBlock', 'TemperatureTable', 'TemperatureTable_Row', 'Text', 'ThermalOutputTable', 'ThermalOutputTable_Row', 'ThermophysPropTable', 'ThermophysPropTable_Row', 'TransitionSymbol', 'Transmitter', 'TransportVariable', 'USCH_UserDefinedProperties', 'Unknown', 'VARA_ColorScale', 'VARA_ROWS_WidthOrScale', 'VRCT_ViewRectangle', 'Valve', 'ValveLiftTable', 'ValveLiftTable_Row', 'VarFlowTable', 'VarFlowTable_Row', 'VarPressureTable', 'VarPressureTable_Row', 'VentOpenCloseTable', 'VentOpenCloseTable_Row', 'VentValve', 'VentilatedPressureAirVessel', 'WBLZ_ThermalBalance', 'WeatherDataTable', 'WeatherDataTable_Row']\n"
     ]
    }
   ],
   "source": [
    "object_types = [item for item in dir(s3s.ObjectTypes) if not (item.startswith('__') and item.endswith('__'))]\n",
    "print(object_types) # Check for hydraulic elmement types"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fb750618",
   "metadata": {},
   "source": [
    "This function allows for little user definition the only paramters are element_type and tks of that element type to exclusively use. For more user defined dataframe creation see Tutorial 52."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8446b05",
   "metadata": {},
   "source": [
    "## Node"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1929d1bb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[2026-03-03 15:24:53,718] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Node ...\n",
      "[2026-03-03 15:24:53,719] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Node ...\n",
      "[2026-03-03 15:24:53,952] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Node\n",
      "[2026-03-03 15:24:53,952] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 517 element(s) of element type ObjectTypes.Node.\n",
      "[2026-03-03 15:24:53,983] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Node.\n",
      "[2026-03-03 15:24:53,985] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 37 model_data properties.\n",
      "[2026-03-03 15:24:53,986] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Ktyp', 'Zkor', 'QmEin', 'Lfakt', 'Fkpzon', 'Fkfstf', 'Fkutmp', 'Fkfqps', 'Fkcont', 'Fk2lknot', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'Qakt', 'Xkor', 'Ykor', 'NodeNamePosition', 'ShowNodeName', 'KvrKlartext', 'NumberOfVERB', 'HasBlockConnection', 'Tk', 'Pk', 'InVariant', 'GeometriesDiffer', 'SymbolFactor', 'bz.Drakonz', 'bz.Fk', 'bz.Fkpvar', 'bz.Fkqvar', 'bz.Fklfkt', 'bz.PhEin', 'bz.Tm', 'bz.Te', 'bz.PhMin'], geometry...\n",
      "[2026-03-03 15:24:56,899] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n",
      "[2026-03-03 15:24:56,899] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (517, 39)\n",
      "[2026-03-03 15:24:57,166] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Node; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n",
      "[2026-03-03 15:24:57,166] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Node\n",
      "[2026-03-03 15:24:57,485] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n",
      "[2026-03-03 15:24:57,489] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n",
      "[2026-03-03 15:24:57,496] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 517 element(s) of element type ObjectTypes.Node.\n",
      "[2026-03-03 15:24:57,504] INFO in sir3stoolkit.mantle.dataframes: [results] Using 73 result properties.\n",
      "[2026-03-03 15:24:57,555] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n",
      "[2026-03-03 15:25:04,916] INFO in sir3stoolkit.mantle.dataframes: [results] 26884 fully NaN columns dropped.\n",
      "[2026-03-03 15:25:05,311] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 10857)\n",
      "[2026-03-03 15:25:05,311] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Node ...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tk</th>\n",
       "      <th>Name</th>\n",
       "      <th>Ktyp</th>\n",
       "      <th>Zkor</th>\n",
       "      <th>QmEin</th>\n",
       "      <th>Lfakt</th>\n",
       "      <th>Fkpzon</th>\n",
       "      <th>Fkfstf</th>\n",
       "      <th>Fkutmp</th>\n",
       "      <th>Fkfqps</th>\n",
       "      <th>Fkcont</th>\n",
       "      <th>Fk2lknot</th>\n",
       "      <th>Beschreibung</th>\n",
       "      <th>Idreferenz</th>\n",
       "      <th>Iplanung</th>\n",
       "      <th>Kvr</th>\n",
       "      <th>Qakt</th>\n",
       "      <th>Xkor</th>\n",
       "      <th>Ykor</th>\n",
       "      <th>NodeNamePosition</th>\n",
       "      <th>ShowNodeName</th>\n",
       "      <th>KvrKlartext</th>\n",
       "      <th>NumberOfVERB</th>\n",
       "      <th>HasBlockConnection</th>\n",
       "      <th>Tk</th>\n",
       "      <th>Pk</th>\n",
       "      <th>InVariant</th>\n",
       "      <th>GeometriesDiffer</th>\n",
       "      <th>SymbolFactor</th>\n",
       "      <th>bz.Drakonz</th>\n",
       "      <th>bz.Fk</th>\n",
       "      <th>bz.Fkpvar</th>\n",
       "      <th>bz.Fkqvar</th>\n",
       "      <th>bz.Fklfkt</th>\n",
       "      <th>bz.PhEin</th>\n",
       "      <th>bz.Tm</th>\n",
       "      <th>bz.Te</th>\n",
       "      <th>bz.PhMin</th>\n",
       "      <th>geometry</th>\n",
       "      <th>BCIND</th>\n",
       "      <th>DP</th>\n",
       "      <th>DPH</th>\n",
       "      <th>H</th>\n",
       "      <th>HMAX_INST</th>\n",
       "      <th>HMIN_INST</th>\n",
       "      <th>IAKTIV</th>\n",
       "      <th>LFAKTAKT</th>\n",
       "      <th>P</th>\n",
       "      <th>PDAMPF</th>\n",
       "      <th>PH</th>\n",
       "      <th>PHMINMAXDIF</th>\n",
       "      <th>PH_EIN</th>\n",
       "      <th>PH_MIN</th>\n",
       "      <th>PMAX_INST</th>\n",
       "      <th>PMIN_INST</th>\n",
       "      <th>QM</th>\n",
       "      <th>RHO</th>\n",
       "      <th>T</th>\n",
       "      <th>TTR</th>\n",
       "      <th>VOLD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4612618373909997110</td>\n",
       "      <td>V-K2133S</td>\n",
       "      <td>QKON</td>\n",
       "      <td>543.56</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5520728169779652386</td>\n",
       "      <td>4798673252636751115</td>\n",
       "      <td>5591325053703727727</td>\n",
       "      <td>-1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>5611267768413515094</td>\n",
       "      <td>Anfangsknoten generiert von SirDB</td>\n",
       "      <td>3S96AE619D388EA6F4CC9F24456148E088</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>714332.858074</td>\n",
       "      <td>5.578924e+06</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Vorlauf</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>4612618373909997110</td>\n",
       "      <td>4612618373909997110</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0</td>\n",
       "      <td>4612618373909997110</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (714332.858 5578924.328)</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.00786</td>\n",
       "      <td>0.00786</td>\n",
       "      <td>1.121165</td>\n",
       "      <td>1.121165</td>\n",
       "      <td>1.121165</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.772049</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>0.772049</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.772049</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.772049</td>\n",
       "      <td>1.772049</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4619205996903908050</td>\n",
       "      <td>V-K983S</td>\n",
       "      <td>QKON</td>\n",
       "      <td>548.26</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5520728169779652386</td>\n",
       "      <td>4798673252636751115</td>\n",
       "      <td>5591325053703727727</td>\n",
       "      <td>-1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>5130743098019975840</td>\n",
       "      <td>Anfangsknoten generiert von SirDB</td>\n",
       "      <td>3S56C0B9A1652EF8E9B7AB8C5DEACA2DC4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>713611.070733</td>\n",
       "      <td>5.578598e+06</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Vorlauf</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>4619205996903908050</td>\n",
       "      <td>4619205996903908050</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0</td>\n",
       "      <td>4619205996903908050</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (713611.071 5578598.067)</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-103.87130</td>\n",
       "      <td>-103.87130</td>\n",
       "      <td>-77.653320</td>\n",
       "      <td>-77.653320</td>\n",
       "      <td>-77.653320</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-77.463350</td>\n",
       "      <td>15.5488</td>\n",
       "      <td>-78.463350</td>\n",
       "      <td>-78.46335</td>\n",
       "      <td>-78.463350</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-77.463350</td>\n",
       "      <td>-77.463350</td>\n",
       "      <td>0.0</td>\n",
       "      <td>865.2</td>\n",
       "      <td>665.8970</td>\n",
       "      <td>0.015023</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4619682681341516951</td>\n",
       "      <td>R-K2803S</td>\n",
       "      <td>QKON</td>\n",
       "      <td>554.99</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5520728169779652386</td>\n",
       "      <td>4798673252636751115</td>\n",
       "      <td>5591325053703727727</td>\n",
       "      <td>-1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>5367059433340055050</td>\n",
       "      <td>Anfangsknoten generiert von SirDB</td>\n",
       "      <td>3S7BD49C919428AD75D6EA1203195E860E</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>713542.639481</td>\n",
       "      <td>5.578805e+06</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>Rücklauf</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>4619682681341516951</td>\n",
       "      <td>4619682681341516951</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0</td>\n",
       "      <td>4619682681341516951</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>POINT (713542.639 5578804.842)</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-93.81168</td>\n",
       "      <td>-93.81168</td>\n",
       "      <td>21.135280</td>\n",
       "      <td>21.135280</td>\n",
       "      <td>21.135280</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.665260</td>\n",
       "      <td>15.5488</td>\n",
       "      <td>19.665260</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>19.665260</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.665260</td>\n",
       "      <td>20.665260</td>\n",
       "      <td>0.0</td>\n",
       "      <td>865.2</td>\n",
       "      <td>662.4618</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    tk      Name  Ktyp    Zkor  QmEin  Lfakt  \\\n",
       "0  4612618373909997110  V-K2133S  QKON  543.56      0      1   \n",
       "1  4619205996903908050   V-K983S  QKON  548.26      0      1   \n",
       "2  4619682681341516951  R-K2803S  QKON  554.99      0      1   \n",
       "\n",
       "                Fkpzon               Fkfstf               Fkutmp  Fkfqps  \\\n",
       "0  5520728169779652386  4798673252636751115  5591325053703727727      -1   \n",
       "1  5520728169779652386  4798673252636751115  5591325053703727727      -1   \n",
       "2  5520728169779652386  4798673252636751115  5591325053703727727      -1   \n",
       "\n",
       "                Fkcont             Fk2lknot  \\\n",
       "0  5029128874972463118  5611267768413515094   \n",
       "1  5029128874972463118  5130743098019975840   \n",
       "2  5029128874972463118  5367059433340055050   \n",
       "\n",
       "                        Beschreibung                          Idreferenz  \\\n",
       "0  Anfangsknoten generiert von SirDB  3S96AE619D388EA6F4CC9F24456148E088   \n",
       "1  Anfangsknoten generiert von SirDB  3S56C0B9A1652EF8E9B7AB8C5DEACA2DC4   \n",
       "2  Anfangsknoten generiert von SirDB  3S7BD49C919428AD75D6EA1203195E860E   \n",
       "\n",
       "   Iplanung  Kvr  Qakt           Xkor          Ykor  NodeNamePosition  \\\n",
       "0         1    1     0  714332.858074  5.578924e+06                 1   \n",
       "1         1    1     0  713611.070733  5.578598e+06                 1   \n",
       "2         1    2     0  713542.639481  5.578805e+06                 1   \n",
       "\n",
       "  ShowNodeName KvrKlartext  NumberOfVERB HasBlockConnection  \\\n",
       "0        False     Vorlauf             0              False   \n",
       "1        False     Vorlauf             0              False   \n",
       "2        False    Rücklauf             0              False   \n",
       "\n",
       "                    Tk                   Pk InVariant GeometriesDiffer  \\\n",
       "0  4612618373909997110  4612618373909997110     False            False   \n",
       "1  4619205996903908050  4619205996903908050     False            False   \n",
       "2  4619682681341516951  4619682681341516951     False            False   \n",
       "\n",
       "   SymbolFactor  bz.Drakonz                bz.Fk  bz.Fkpvar  bz.Fkqvar  \\\n",
       "0           0.2           0  4612618373909997110         -1         -1   \n",
       "1           0.2           0  4619205996903908050         -1         -1   \n",
       "2           0.2           0  4619682681341516951         -1         -1   \n",
       "\n",
       "   bz.Fklfkt  bz.PhEin  bz.Tm  bz.Te  bz.PhMin  \\\n",
       "0         -1         0      0      0         0   \n",
       "1         -1         0      0      0         0   \n",
       "2         -1         0      0      0         0   \n",
       "\n",
       "                         geometry  BCIND         DP        DPH          H  \\\n",
       "0  POINT (714332.858 5578924.328)   17.0    0.00786    0.00786   1.121165   \n",
       "1  POINT (713611.071 5578598.067)   17.0 -103.87130 -103.87130 -77.653320   \n",
       "2  POINT (713542.639 5578804.842)   17.0  -93.81168  -93.81168  21.135280   \n",
       "\n",
       "   HMAX_INST  HMIN_INST  IAKTIV  LFAKTAKT          P   PDAMPF         PH  \\\n",
       "0   1.121165   1.121165     1.0       1.0   1.772049   0.0123   0.772049   \n",
       "1 -77.653320 -77.653320     0.0       1.0 -77.463350  15.5488 -78.463350   \n",
       "2  21.135280  21.135280     0.0       1.0  20.665260  15.5488  19.665260   \n",
       "\n",
       "   PHMINMAXDIF     PH_EIN  PH_MIN  PMAX_INST  PMIN_INST   QM     RHO  \\\n",
       "0      0.00000   0.772049     0.0   1.772049   1.772049  0.0  1000.3   \n",
       "1    -78.46335 -78.463350     0.0 -77.463350 -77.463350  0.0   865.2   \n",
       "2      0.00000  19.665260     0.0  20.665260  20.665260  0.0   865.2   \n",
       "\n",
       "          T       TTR  VOLD  \n",
       "0   10.0000  0.000000   0.0  \n",
       "1  665.8970  0.015023   0.0  \n",
       "2  662.4618  0.000000   0.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(s3s.generate_element_dataframe(element_type=s3s.ObjectTypes.Node, tks=None)).head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "42c338bc",
   "metadata": {},
   "source": [
    "## Pipe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "7ac84f6c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[2026-03-03 15:25:05,404] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.Pipe ...\n",
      "[2026-03-03 15:25:05,406] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.Pipe ...\n",
      "[2026-03-03 15:25:05,568] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.Pipe\n",
      "[2026-03-03 15:25:05,568] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n",
      "[2026-03-03 15:25:05,577] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.Pipe.\n",
      "[2026-03-03 15:25:05,579] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 46 model_data properties.\n",
      "[2026-03-03 15:25:05,580] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'FkdtroRowd', 'Fkltgr', 'Fkstrasse', 'L', 'Lzu', 'Rau', 'Jlambs', 'Lambda0', 'Zein', 'Zaus', 'Zuml', 'Asoll', 'Indschall', 'Baujahr', 'Hal', 'Fkcont', 'Fk2lrohr', 'Beschreibung', 'Idreferenz', 'Iplanung', 'Kvr', 'LineWidthMM', 'DottedLine', 'DN', 'Di', 'KvrKlartext', 'HasClosedNSCHs', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'GeometriesDiffer', 'bz.Fk', 'bz.Qsvb', 'bz.Irtrenn', 'bz.Leckstatus', 'bz.Leckstart', 'bz.Leckend', 'bz.Leckort', 'bz.Leckmenge', 'bz.Imptnz', 'bz.Zvlimptnz', 'bz.Kantenzv', 'bz.ITrennWithNSCH'], geometry, end nodes...\n",
      "[2026-03-03 15:25:07,256] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n",
      "[2026-03-03 15:25:07,431] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n",
      "[2026-03-03 15:25:07,431] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (524, 50)\n",
      "[2026-03-03 15:25:07,501] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.Pipe; at timestamp: 2023-02-13 00:00:00.000 +01:00 ...\n",
      "[2026-03-03 15:25:07,501] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.Pipe\n",
      "[2026-03-03 15:25:07,566] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] Only static timestamp 2023-02-13 00:00:00.000 +01:00 is used\n",
      "[2026-03-03 15:25:07,566] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n",
      "[2026-03-03 15:25:07,573] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 524 element(s) of element type ObjectTypes.Pipe.\n",
      "[2026-03-03 15:25:07,575] INFO in sir3stoolkit.mantle.dataframes: [results] Using 82 result properties.\n",
      "[2026-03-03 15:25:07,598] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n",
      "[2026-03-03 15:25:13,201] INFO in sir3stoolkit.mantle.dataframes: [results] 26724 fully NaN columns dropped.\n",
      "[2026-03-03 15:25:14,794] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 16244)\n",
      "[2026-03-03 15:25:14,797] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.Pipe ...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tk</th>\n",
       "      <th>Name</th>\n",
       "      <th>FkdtroRowd</th>\n",
       "      <th>Fkltgr</th>\n",
       "      <th>Fkstrasse</th>\n",
       "      <th>L</th>\n",
       "      <th>Lzu</th>\n",
       "      <th>Rau</th>\n",
       "      <th>Jlambs</th>\n",
       "      <th>Lambda0</th>\n",
       "      <th>Zein</th>\n",
       "      <th>Zaus</th>\n",
       "      <th>Zuml</th>\n",
       "      <th>Asoll</th>\n",
       "      <th>Indschall</th>\n",
       "      <th>Baujahr</th>\n",
       "      <th>Hal</th>\n",
       "      <th>Fkcont</th>\n",
       "      <th>Fk2lrohr</th>\n",
       "      <th>Beschreibung</th>\n",
       "      <th>Idreferenz</th>\n",
       "      <th>Iplanung</th>\n",
       "      <th>Kvr</th>\n",
       "      <th>LineWidthMM</th>\n",
       "      <th>DottedLine</th>\n",
       "      <th>DN</th>\n",
       "      <th>Di</th>\n",
       "      <th>KvrKlartext</th>\n",
       "      <th>HasClosedNSCHs</th>\n",
       "      <th>Tk</th>\n",
       "      <th>Pk</th>\n",
       "      <th>InVariant</th>\n",
       "      <th>Xkor</th>\n",
       "      <th>Ykor</th>\n",
       "      <th>GeometriesDiffer</th>\n",
       "      <th>bz.Fk</th>\n",
       "      <th>bz.Qsvb</th>\n",
       "      <th>bz.Irtrenn</th>\n",
       "      <th>bz.Leckstatus</th>\n",
       "      <th>bz.Leckstart</th>\n",
       "      <th>bz.Leckend</th>\n",
       "      <th>bz.Leckort</th>\n",
       "      <th>bz.Leckmenge</th>\n",
       "      <th>bz.Imptnz</th>\n",
       "      <th>bz.Zvlimptnz</th>\n",
       "      <th>bz.Kantenzv</th>\n",
       "      <th>bz.ITrennWithNSCH</th>\n",
       "      <th>geometry</th>\n",
       "      <th>fkKI</th>\n",
       "      <th>fkKK</th>\n",
       "      <th>A</th>\n",
       "      <th>DTTR</th>\n",
       "      <th>DWVERL</th>\n",
       "      <th>DWVERLABS</th>\n",
       "      <th>IAKTIV</th>\n",
       "      <th>IRTRENN</th>\n",
       "      <th>JV</th>\n",
       "      <th>MVEC_start</th>\n",
       "      <th>MVEC_end</th>\n",
       "      <th>MVEC_sequence</th>\n",
       "      <th>PDAMPF</th>\n",
       "      <th>PHR</th>\n",
       "      <th>PMIN</th>\n",
       "      <th>PVEC_start</th>\n",
       "      <th>PVEC_end</th>\n",
       "      <th>PVEC_sequence</th>\n",
       "      <th>PVECMAX_INST_start</th>\n",
       "      <th>PVECMAX_INST_end</th>\n",
       "      <th>PVECMAX_INST_sequence</th>\n",
       "      <th>PVECMIN_INST_start</th>\n",
       "      <th>PVECMIN_INST_end</th>\n",
       "      <th>PVECMIN_INST_sequence</th>\n",
       "      <th>QMAV</th>\n",
       "      <th>QMI</th>\n",
       "      <th>QMK</th>\n",
       "      <th>RHOI</th>\n",
       "      <th>RHOK</th>\n",
       "      <th>RHOVEC_start</th>\n",
       "      <th>RHOVEC_end</th>\n",
       "      <th>RHOVEC_sequence</th>\n",
       "      <th>SVEC_start</th>\n",
       "      <th>SVEC_end</th>\n",
       "      <th>SVEC_sequence</th>\n",
       "      <th>TI</th>\n",
       "      <th>TK</th>\n",
       "      <th>TTRVEC_start</th>\n",
       "      <th>TTRVEC_end</th>\n",
       "      <th>TTRVEC_sequence</th>\n",
       "      <th>TVEC_start</th>\n",
       "      <th>TVEC_end</th>\n",
       "      <th>TVEC_sequence</th>\n",
       "      <th>VAV</th>\n",
       "      <th>VI</th>\n",
       "      <th>VK</th>\n",
       "      <th>VOLDA</th>\n",
       "      <th>WVL</th>\n",
       "      <th>ZVEC_start</th>\n",
       "      <th>ZVEC_end</th>\n",
       "      <th>ZVEC_sequence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4614463970292122863</td>\n",
       "      <td>Rohr R-K4383S R-K4183S</td>\n",
       "      <td>4689226368751411179</td>\n",
       "      <td>4779752876656844188</td>\n",
       "      <td>5431845028903382031</td>\n",
       "      <td>7.780674</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>4713734746689397424</td>\n",
       "      <td>OSM: Knoten 450994211 -&gt; Knoten 476971188; Län...</td>\n",
       "      <td>166815824</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0</td>\n",
       "      <td>999</td>\n",
       "      <td>994.0</td>\n",
       "      <td>Rücklauf</td>\n",
       "      <td></td>\n",
       "      <td>4614463970292122863</td>\n",
       "      <td>4614463970292122863</td>\n",
       "      <td>False</td>\n",
       "      <td>714262.482930</td>\n",
       "      <td>5.578857e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>4614463970292122863</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>LINESTRING (714262.483 5578857.42, 714269.543 ...</td>\n",
       "      <td>4730066059089961857</td>\n",
       "      <td>4917189080965035120</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-4.292815e-10</td>\n",
       "      <td>-4.292815e-10</td>\n",
       "      <td>(-4.292815e-10, -4.292815e-10)</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.615081</td>\n",
       "      <td>1.61508</td>\n",
       "      <td>1.688655</td>\n",
       "      <td>(1.61508, 1.688655)</td>\n",
       "      <td>1.61508</td>\n",
       "      <td>1.688655</td>\n",
       "      <td>(1.61508, 1.688655)</td>\n",
       "      <td>1.61508</td>\n",
       "      <td>1.688655</td>\n",
       "      <td>(1.61508, 1.688655)</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>(1000.3, 1000.3)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.780674</td>\n",
       "      <td>(0.0, 7.780674)</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>7.780674</td>\n",
       "      <td>(0.0, 7.780674)</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(10.0, 10.0)</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>545.09</td>\n",
       "      <td>544.34</td>\n",
       "      <td>(545.09, 544.34)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4615723899944629797</td>\n",
       "      <td>Rohr V-K203S V-K213S</td>\n",
       "      <td>4689226368751411179</td>\n",
       "      <td>4779752876656844188</td>\n",
       "      <td>5728726059620036726</td>\n",
       "      <td>64.287240</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>4938076287810941486</td>\n",
       "      <td>OSM: Knoten 390310977 -&gt; Knoten 1368674233; Lä...</td>\n",
       "      <td>24633100</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0</td>\n",
       "      <td>999</td>\n",
       "      <td>994.0</td>\n",
       "      <td>Vorlauf</td>\n",
       "      <td></td>\n",
       "      <td>4615723899944629797</td>\n",
       "      <td>4615723899944629797</td>\n",
       "      <td>False</td>\n",
       "      <td>713738.296567</td>\n",
       "      <td>5.579220e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>4615723899944629797</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>LINESTRING (713738.297 5579219.902, 713793.23 ...</td>\n",
       "      <td>5129584372458662150</td>\n",
       "      <td>5332825919690090061</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.582965e-09</td>\n",
       "      <td>2.582965e-09</td>\n",
       "      <td>(2.582965e-09, 2.582965e-09, 2.582965e-09, 2.5...</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-74.2059</td>\n",
       "      <td>-74.20590</td>\n",
       "      <td>-73.920440</td>\n",
       "      <td>(-74.2059, -74.16512, -74.12434, -74.08356, -7...</td>\n",
       "      <td>-74.20590</td>\n",
       "      <td>-73.920440</td>\n",
       "      <td>(-74.2059, -74.16512, -74.12434, -74.08356, -7...</td>\n",
       "      <td>-74.20590</td>\n",
       "      <td>-73.920440</td>\n",
       "      <td>(-74.2059, -74.16512, -74.12434, -74.08356, -7...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>(1000.3, 1000.3, 1000.3, 1000.3, 1000.3, 1000....</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.287240</td>\n",
       "      <td>(0.0, 9.183891, 18.36778, 27.55167, 36.73557, ...</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>107.3669</td>\n",
       "      <td>43.079700</td>\n",
       "      <td>(107.3669, 98.18304, 88.99916, 79.81527, 70.63...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0, 10.0)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>565.84</td>\n",
       "      <td>562.93</td>\n",
       "      <td>(565.84, 565.4243, 565.0086, 564.5929, 564.177...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4621030304810285220</td>\n",
       "      <td>Rohr R-K2573S R-K2583S</td>\n",
       "      <td>5516336706687055417</td>\n",
       "      <td>4779752876656844188</td>\n",
       "      <td>5644881417512616095</td>\n",
       "      <td>3.956838</td>\n",
       "      <td>0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>5625716875961234775</td>\n",
       "      <td>OSM: Knoten 476971211 -&gt; Knoten 264607350; Län...</td>\n",
       "      <td>24386111</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0</td>\n",
       "      <td>100</td>\n",
       "      <td>107.1</td>\n",
       "      <td>Rücklauf</td>\n",
       "      <td></td>\n",
       "      <td>4621030304810285220</td>\n",
       "      <td>4621030304810285220</td>\n",
       "      <td>False</td>\n",
       "      <td>713650.613400</td>\n",
       "      <td>5.578990e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>4621030304810285220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>LINESTRING (713650.613 5578990.488, 713649.498...</td>\n",
       "      <td>5070795580168283912</td>\n",
       "      <td>5725848577942138606</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.956838</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.680974e-08</td>\n",
       "      <td>1.680974e-08</td>\n",
       "      <td>(1.680974e-08, 1.680974e-08)</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.86233</td>\n",
       "      <td>19.87508</td>\n",
       "      <td>19.862340</td>\n",
       "      <td>(19.87508, 19.86234)</td>\n",
       "      <td>19.87508</td>\n",
       "      <td>19.862340</td>\n",
       "      <td>(19.87508, 19.86234)</td>\n",
       "      <td>19.87508</td>\n",
       "      <td>19.862340</td>\n",
       "      <td>(19.87508, 19.86234)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>(1000.3, 1000.3)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.956838</td>\n",
       "      <td>(0.0, 3.956838)</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>9.999994</td>\n",
       "      <td>12017.9000</td>\n",
       "      <td>12021.860000</td>\n",
       "      <td>(12017.9, 12021.86)</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>(10.0, 10.0)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>563.01</td>\n",
       "      <td>563.14</td>\n",
       "      <td>(563.01, 563.14)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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    A      DTTR DWVERL DWVERLABS IAKTIV IRTRENN   JV  \\\n",
       "0  4917189080965035120  0.0       0.0    0.0       0.0    1.0     0.0  0.0   \n",
       "1  5332825919690090061  0.0       0.0    0.0       0.0    1.0     0.0  0.0   \n",
       "2  5725848577942138606  0.0  3.956838    0.0       0.0    0.0     0.0  0.0   \n",
       "\n",
       "     MVEC_start      MVEC_end  \\\n",
       "0 -4.292815e-10 -4.292815e-10   \n",
       "1  2.582965e-09  2.582965e-09   \n",
       "2  1.680974e-08  1.680974e-08   \n",
       "\n",
       "                                       MVEC_sequence  PDAMPF  PHR      PMIN  \\\n",
       "0                     (-4.292815e-10, -4.292815e-10)  0.0123  0.0  1.615081   \n",
       "1  (2.582965e-09, 2.582965e-09, 2.582965e-09, 2.5...  0.0123  0.0  -74.2059   \n",
       "2                       (1.680974e-08, 1.680974e-08)  0.0123  0.0  19.86233   \n",
       "\n",
       "   PVEC_start   PVEC_end                                      PVEC_sequence  \\\n",
       "0     1.61508   1.688655                                (1.61508, 1.688655)   \n",
       "1   -74.20590 -73.920440  (-74.2059, -74.16512, -74.12434, -74.08356, -7...   \n",
       "2    19.87508  19.862340                               (19.87508, 19.86234)   \n",
       "\n",
       "   PVECMAX_INST_start  PVECMAX_INST_end  \\\n",
       "0             1.61508          1.688655   \n",
       "1           -74.20590        -73.920440   \n",
       "2            19.87508         19.862340   \n",
       "\n",
       "                               PVECMAX_INST_sequence  PVECMIN_INST_start  \\\n",
       "0                                (1.61508, 1.688655)             1.61508   \n",
       "1  (-74.2059, -74.16512, -74.12434, -74.08356, -7...           -74.20590   \n",
       "2                               (19.87508, 19.86234)            19.87508   \n",
       "\n",
       "   PVECMIN_INST_end                              PVECMIN_INST_sequence QMAV  \\\n",
       "0          1.688655                                (1.61508, 1.688655) -0.0   \n",
       "1        -73.920440  (-74.2059, -74.16512, -74.12434, -74.08356, -7...  0.0   \n",
       "2         19.862340                               (19.87508, 19.86234)  0.0   \n",
       "\n",
       "   QMI  QMK    RHOI    RHOK  RHOVEC_start  RHOVEC_end  \\\n",
       "0 -0.0 -0.0  1000.3  1000.3        1000.3      1000.3   \n",
       "1  0.0  0.0  1000.3  1000.3        1000.3      1000.3   \n",
       "2  0.0  0.0  1000.3  1000.3        1000.3      1000.3   \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                                   (1000.3, 1000.3)         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)  9.999994  9.999994   \n",
       "\n",
       "   TTRVEC_start    TTRVEC_end  \\\n",
       "0        0.0000      7.780674   \n",
       "1      107.3669     43.079700   \n",
       "2    12017.9000  12021.860000   \n",
       "\n",
       "                                     TTRVEC_sequence  TVEC_start  TVEC_end  \\\n",
       "0                                    (0.0, 7.780674)        10.0      10.0   \n",
       "1  (107.3669, 98.18304, 88.99916, 79.81527, 70.63...        10.0      10.0   \n",
       "2                                (12017.9, 12021.86)        10.0      10.0   \n",
       "\n",
       "                                      TVEC_sequence  VAV   VI   VK VOLDA  WVL  \\\n",
       "0                                      (10.0, 10.0) -0.0 -0.0 -0.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  0.0   0.0  0.0   \n",
       "2                                      (10.0, 10.0)  0.0  0.0  0.0   0.0  0.0   \n",
       "\n",
       "   ZVEC_start  ZVEC_end                                      ZVEC_sequence  \n",
       "0      545.09    544.34                                   (545.09, 544.34)  \n",
       "1      565.84    562.93  (565.84, 565.4243, 565.0086, 564.5929, 564.177...  \n",
       "2      563.01    563.14                                   (563.01, 563.14)  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(s3s.generate_element_dataframe(element_type=s3s.ObjectTypes.Pipe, tks=None)).head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "219eb668",
   "metadata": {},
   "source": [
    "As can be seen some result values are in vectorized form, since pipes have result values that are calculated for interior points."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "808b2c79",
   "metadata": {},
   "source": [
    "## DistrictHeatingConsumer"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5d924f90",
   "metadata": {},
   "source": [
    "We can specify the timestamp we want the result data for either as \"2023-02-13 01:00:00.000 +01:00\" or 1 meaning the second element in s3s.GetTimeStamps()[0], otherwise static is used."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "4eaae862",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[2026-03-03 15:25:14,998] INFO in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df for element type: ObjectTypes.DistrictHeatingConsumer ...\n",
      "[2026-03-03 15:25:14,999] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_model_data for element type: ObjectTypes.DistrictHeatingConsumer ...\n",
      "[2026-03-03 15:25:15,083] INFO in sir3stoolkit.mantle.dataframes: [model_data] Generating model_data dataframe for element type: ObjectTypes.DistrictHeatingConsumer\n",
      "[2026-03-03 15:25:15,085] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieved 337 element(s) of element type ObjectTypes.DistrictHeatingConsumer.\n",
      "[2026-03-03 15:25:15,087] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] No properties given → using ALL model_data properties for ObjectTypes.DistrictHeatingConsumer.\n",
      "[2026-03-03 15:25:15,087] INFO in sir3stoolkit.mantle.dataframes: [Resolving model_data Properties] Using 55 model_data properties.\n",
      "[2026-03-03 15:25:15,089] INFO in sir3stoolkit.mantle.dataframes: [model_data] Retrieving model_data properties ['Name', 'Beschreibung', 'Ind0', 'W0', 'Qm0', 'Tvl0', 'Trs0', 'Lfk', 'Rho0', 'Dtmin', 'Indtr', 'Trsk', 'Fktrft', 'A', 'B', 'C', 'Vtyp', 'V0', 'P1soll', 'Dpvlmin', 'Fkzep1vl', 'Tsvl', 'Zevk', 'Dphaus', 'Dprlmin', 'Fkzep1rl', 'Tsrl', 'Imbg', 'Irfv', 'Fkcont', 'Idreferenz', 'Iplanung', 'CPM', 'NumberOfVERB', 'IndtrKlartext', 'M0Estimated', 'W0Estimated', 'Tk', 'Pk', 'InVariant', 'Xkor', 'Ykor', 'ShowDescription', 'PositionOfDescription', 'Angle', 'SymbolFactor', 'GeometriesDiffer', 'bz.Fk', 'bz.Indlast', 'bz.Indlfkt2', 'bz.Fklfkt', 'bz.Fklfkt2', 'bz.Fkqvar', 'bz.Fktevt', 'bz.IndlastKlartext'], geometry, end nodes...\n",
      "[2026-03-03 15:25:16,176] INFO in sir3stoolkit.mantle.dataframes: [model_data] 2 non-empty end node columns were created.\n",
      "[2026-03-03 15:25:16,312] INFO in sir3stoolkit.mantle.dataframes: [model_data] Transforming DataFrame to GeoDataFrame successful with EPSG: 25832\n",
      "[2026-03-03 15:25:16,312] INFO in sir3stoolkit.mantle.dataframes: [model_data] Done. Shape: (337, 59)\n",
      "[2026-03-03 15:25:16,377] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Generating df_results for element type: ObjectTypes.DistrictHeatingConsumer; at timestamp: 2023-02-13 01:00:00.000 +01:00 ...\n",
      "[2026-03-03 15:25:16,377] INFO in sir3stoolkit.mantle.dataframes: [results] Generating results dataframe for element type: ObjectTypes.DistrictHeatingConsumer\n",
      "[2026-03-03 15:25:16,465] INFO in sir3stoolkit.mantle.dataframes: [Resolving Timestamps] 1 valid timestamp(s) will be used.\n",
      "[2026-03-03 15:25:16,465] INFO in sir3stoolkit.mantle.dataframes: [Resolving tks] Retrieved 337 element(s) of element type ObjectTypes.DistrictHeatingConsumer.\n",
      "[2026-03-03 15:25:16,467] INFO in sir3stoolkit.mantle.dataframes: [results] Using 36 result properties.\n",
      "[2026-03-03 15:25:16,474] INFO in sir3stoolkit.mantle.dataframes: [results] Retrieving result values...\n",
      "[2026-03-03 15:25:17,582] INFO in sir3stoolkit.mantle.dataframes: [results] 5392 fully NaN columns dropped.\n",
      "[2026-03-03 15:25:17,987] INFO in sir3stoolkit.mantle.dataframes: [results] Done. Shape: (1, 6740)\n",
      "[2026-03-03 15:25:17,989] DEBUG in sir3stoolkit.mantle.dataframes: [generate_element_dataframe] Merging df_model_data with df_results for element type: ObjectTypes.DistrictHeatingConsumer ...\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tk</th>\n",
       "      <th>Name</th>\n",
       "      <th>Beschreibung</th>\n",
       "      <th>Ind0</th>\n",
       "      <th>W0</th>\n",
       "      <th>Qm0</th>\n",
       "      <th>Tvl0</th>\n",
       "      <th>Trs0</th>\n",
       "      <th>Lfk</th>\n",
       "      <th>Rho0</th>\n",
       "      <th>Dtmin</th>\n",
       "      <th>Indtr</th>\n",
       "      <th>Trsk</th>\n",
       "      <th>Fktrft</th>\n",
       "      <th>A</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>Vtyp</th>\n",
       "      <th>V0</th>\n",
       "      <th>P1soll</th>\n",
       "      <th>Dpvlmin</th>\n",
       "      <th>Fkzep1vl</th>\n",
       "      <th>Tsvl</th>\n",
       "      <th>Zevk</th>\n",
       "      <th>Dphaus</th>\n",
       "      <th>Dprlmin</th>\n",
       "      <th>Fkzep1rl</th>\n",
       "      <th>Tsrl</th>\n",
       "      <th>Imbg</th>\n",
       "      <th>Irfv</th>\n",
       "      <th>Fkcont</th>\n",
       "      <th>Idreferenz</th>\n",
       "      <th>Iplanung</th>\n",
       "      <th>CPM</th>\n",
       "      <th>NumberOfVERB</th>\n",
       "      <th>IndtrKlartext</th>\n",
       "      <th>M0Estimated</th>\n",
       "      <th>W0Estimated</th>\n",
       "      <th>Tk</th>\n",
       "      <th>Pk</th>\n",
       "      <th>InVariant</th>\n",
       "      <th>Xkor</th>\n",
       "      <th>Ykor</th>\n",
       "      <th>ShowDescription</th>\n",
       "      <th>PositionOfDescription</th>\n",
       "      <th>Angle</th>\n",
       "      <th>SymbolFactor</th>\n",
       "      <th>GeometriesDiffer</th>\n",
       "      <th>bz.Fk</th>\n",
       "      <th>bz.Indlast</th>\n",
       "      <th>bz.Indlfkt2</th>\n",
       "      <th>bz.Fklfkt</th>\n",
       "      <th>bz.Fklfkt2</th>\n",
       "      <th>bz.Fkqvar</th>\n",
       "      <th>bz.Fktevt</th>\n",
       "      <th>bz.IndlastKlartext</th>\n",
       "      <th>geometry</th>\n",
       "      <th>fkKI</th>\n",
       "      <th>fkKK</th>\n",
       "      <th>DH</th>\n",
       "      <th>DP</th>\n",
       "      <th>DPH</th>\n",
       "      <th>IAKTIV</th>\n",
       "      <th>INDUV</th>\n",
       "      <th>LFH</th>\n",
       "      <th>LFT</th>\n",
       "      <th>M</th>\n",
       "      <th>MHYUV</th>\n",
       "      <th>MTHUV</th>\n",
       "      <th>PHIRL</th>\n",
       "      <th>PHIVL</th>\n",
       "      <th>QM</th>\n",
       "      <th>RHOI</th>\n",
       "      <th>RHOK</th>\n",
       "      <th>TI</th>\n",
       "      <th>TK</th>\n",
       "      <th>TVMIN</th>\n",
       "      <th>W</th>\n",
       "      <th>WSOLL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4611752310942477664</td>\n",
       "      <td>Fernwärmeverbraucher V-K1203S R-K3683S</td>\n",
       "      <td>Gattendorf;95185;Obere Au;28;None;yes</td>\n",
       "      <td>0</td>\n",
       "      <td>139.0433</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>60</td>\n",
       "      <td>-1</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>830887238</td>\n",
       "      <td>1</td>\n",
       "      <td>4.1903</td>\n",
       "      <td>0</td>\n",
       "      <td>Tabelle Temperatur TEVT, TRS(t)</td>\n",
       "      <td>3.981862</td>\n",
       "      <td>34.91917</td>\n",
       "      <td>4611752310942477664</td>\n",
       "      <td>4611752310942477664</td>\n",
       "      <td>False</td>\n",
       "      <td>713675.300232</td>\n",
       "      <td>5.578705e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>False</td>\n",
       "      <td>4611752310942477664</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4835417738045943522</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>5395645951786400348</td>\n",
       "      <td>Lastfaktor thermisch</td>\n",
       "      <td>POINT (713675.3 5578705.193)</td>\n",
       "      <td>4673701597187411685</td>\n",
       "      <td>4995788945387711669</td>\n",
       "      <td>-1525.83400</td>\n",
       "      <td>-129.462600</td>\n",
       "      <td>-129.462600</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>5.353562</td>\n",
       "      <td>0.5739</td>\n",
       "      <td>5.920521</td>\n",
       "      <td>-15.39335</td>\n",
       "      <td>-15.39335</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>21.31388</td>\n",
       "      <td>865.2</td>\n",
       "      <td>865.2</td>\n",
       "      <td>665.7723</td>\n",
       "      <td>662.7723</td>\n",
       "      <td>682.061</td>\n",
       "      <td>79.79695</td>\n",
       "      <td>79.79695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4612528660388965271</td>\n",
       "      <td>Fernwärmeverbraucher V-K1783S R-K4263S</td>\n",
       "      <td>None;None;None;None;None;yes</td>\n",
       "      <td>0</td>\n",
       "      <td>386.4134</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>60</td>\n",
       "      <td>-1</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>1056287317</td>\n",
       "      <td>1</td>\n",
       "      <td>4.1903</td>\n",
       "      <td>0</td>\n",
       "      <td>Tabelle Temperatur TEVT, TRS(t)</td>\n",
       "      <td>11.065940</td>\n",
       "      <td>34.91917</td>\n",
       "      <td>4612528660388965271</td>\n",
       "      <td>4612528660388965271</td>\n",
       "      <td>False</td>\n",
       "      <td>714251.332395</td>\n",
       "      <td>5.578925e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>False</td>\n",
       "      <td>4612528660388965271</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5554262436821166605</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>5395645951786400348</td>\n",
       "      <td>Lastfaktor thermisch</td>\n",
       "      <td>POINT (714251.332 5578925.001)</td>\n",
       "      <td>5015101891725198603</td>\n",
       "      <td>5751808837348052764</td>\n",
       "      <td>0.07012</td>\n",
       "      <td>0.006878</td>\n",
       "      <td>0.006878</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1000.3</td>\n",
       "      <td>865.2</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>666.0000</td>\n",
       "      <td>10.000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4612562908060328263</td>\n",
       "      <td>Fernwärmeverbraucher V-K1623S R-K4103S</td>\n",
       "      <td>Gattendorf;95185;Langenbachstraße;4;None;yes</td>\n",
       "      <td>0</td>\n",
       "      <td>106.6409</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>1000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>60</td>\n",
       "      <td>-1</td>\n",
       "      <td>2</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5029128874972463118</td>\n",
       "      <td>830818182</td>\n",
       "      <td>1</td>\n",
       "      <td>4.1903</td>\n",
       "      <td>0</td>\n",
       "      <td>Tabelle Temperatur TEVT, TRS(t)</td>\n",
       "      <td>3.053936</td>\n",
       "      <td>34.91917</td>\n",
       "      <td>4612562908060328263</td>\n",
       "      <td>4612562908060328263</td>\n",
       "      <td>False</td>\n",
       "      <td>713271.271817</td>\n",
       "      <td>5.578980e+06</td>\n",
       "      <td>False</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>False</td>\n",
       "      <td>4612562908060328263</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4835417738045943522</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>5395645951786400348</td>\n",
       "      <td>Lastfaktor thermisch</td>\n",
       "      <td>POINT (713271.272 5578979.743)</td>\n",
       "      <td>4965299629814639205</td>\n",
       "      <td>4779536530687993701</td>\n",
       "      <td>-1511.19700</td>\n",
       "      <td>-128.220700</td>\n",
       "      <td>-128.220700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>5.353756</td>\n",
       "      <td>0.5739</td>\n",
       "      <td>4.540978</td>\n",
       "      <td>-11.80654</td>\n",
       "      <td>-11.80654</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>-3.333333e+32</td>\n",
       "      <td>16.34752</td>\n",
       "      <td>865.2</td>\n",
       "      <td>865.2</td>\n",
       "      <td>665.7705</td>\n",
       "      <td>662.7705</td>\n",
       "      <td>682.061</td>\n",
       "      <td>61.20121</td>\n",
       "      <td>61.20121</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    tk                                    Name  \\\n",
       "0  4611752310942477664  Fernwärmeverbraucher V-K1203S R-K3683S   \n",
       "1  4612528660388965271  Fernwärmeverbraucher V-K1783S R-K4263S   \n",
       "2  4612562908060328263  Fernwärmeverbraucher V-K1623S R-K4103S   \n",
       "\n",
       "                                   Beschreibung  Ind0        W0  Qm0  Tvl0  \\\n",
       "0         Gattendorf;95185;Obere Au;28;None;yes     0  139.0433    1    90   \n",
       "1                  None;None;None;None;None;yes     0  386.4134    1    90   \n",
       "2  Gattendorf;95185;Langenbachstraße;4;None;yes     0  106.6409    1    90   \n",
       "\n",
       "   Trs0  Lfk  Rho0  Dtmin  Indtr  Trsk  Fktrft  A     B  C  Vtyp  V0  P1soll  \\\n",
       "0    60    1  1000      3      3    60      -1  2 -0.25 -2     1   1       0   \n",
       "1    60    1  1000      3      3    60      -1  2 -0.25 -2     1   0       0   \n",
       "2    60    1  1000      3      3    60      -1  2 -0.25 -2     1   1       0   \n",
       "\n",
       "   Dpvlmin  Fkzep1vl  Tsvl  Zevk  Dphaus  Dprlmin  Fkzep1rl  Tsrl  Imbg  Irfv  \\\n",
       "0        0        -1     0     0     0.2      0.3        -1     0     0     1   \n",
       "1        0        -1     0     0     0.2      0.3        -1     0     0     1   \n",
       "2        0        -1     0     0     0.2      0.3        -1     0     0     1   \n",
       "\n",
       "                Fkcont  Idreferenz  Iplanung     CPM  NumberOfVERB  \\\n",
       "0  5029128874972463118   830887238         1  4.1903             0   \n",
       "1  5029128874972463118  1056287317         1  4.1903             0   \n",
       "2  5029128874972463118   830818182         1  4.1903             0   \n",
       "\n",
       "                     IndtrKlartext  M0Estimated  W0Estimated  \\\n",
       "0  Tabelle Temperatur TEVT, TRS(t)     3.981862     34.91917   \n",
       "1  Tabelle Temperatur TEVT, TRS(t)    11.065940     34.91917   \n",
       "2  Tabelle Temperatur TEVT, TRS(t)     3.053936     34.91917   \n",
       "\n",
       "                    Tk                   Pk InVariant           Xkor  \\\n",
       "0  4611752310942477664  4611752310942477664     False  713675.300232   \n",
       "1  4612528660388965271  4612528660388965271     False  714251.332395   \n",
       "2  4612562908060328263  4612562908060328263     False  713271.271817   \n",
       "\n",
       "           Ykor ShowDescription  PositionOfDescription  Angle  SymbolFactor  \\\n",
       "0  5.578705e+06           False                      3      0           0.1   \n",
       "1  5.578925e+06           False                      3      0           0.1   \n",
       "2  5.578980e+06           False                      3      0           0.1   \n",
       "\n",
       "  GeometriesDiffer                bz.Fk  bz.Indlast  bz.Indlfkt2  \\\n",
       "0            False  4611752310942477664           0            0   \n",
       "1            False  4612528660388965271           0            0   \n",
       "2            False  4612562908060328263           0            0   \n",
       "\n",
       "             bz.Fklfkt  bz.Fklfkt2  bz.Fkqvar            bz.Fktevt  \\\n",
       "0  4835417738045943522          -1         -1  5395645951786400348   \n",
       "1  5554262436821166605          -1         -1  5395645951786400348   \n",
       "2  4835417738045943522          -1         -1  5395645951786400348   \n",
       "\n",
       "     bz.IndlastKlartext                        geometry                 fkKI  \\\n",
       "0  Lastfaktor thermisch    POINT (713675.3 5578705.193)  4673701597187411685   \n",
       "1  Lastfaktor thermisch  POINT (714251.332 5578925.001)  5015101891725198603   \n",
       "2  Lastfaktor thermisch  POINT (713271.272 5578979.743)  4965299629814639205   \n",
       "\n",
       "                  fkKK          DH          DP         DPH  IAKTIV  INDUV  \\\n",
       "0  4995788945387711669 -1525.83400 -129.462600 -129.462600     0.0   -1.0   \n",
       "1  5751808837348052764     0.07012    0.006878    0.006878     1.0   -1.0   \n",
       "2  4779536530687993701 -1511.19700 -128.220700 -128.220700     0.0   -1.0   \n",
       "\n",
       "        LFH     LFT         M     MHYUV     MTHUV         PHIRL         PHIVL  \\\n",
       "0  5.353562  0.5739  5.920521 -15.39335 -15.39335 -3.333333e+32 -3.333333e+32   \n",
       "1  0.000000  0.0000  0.000000   0.00000   0.00000 -3.333333e+32 -3.333333e+32   \n",
       "2  5.353756  0.5739  4.540978 -11.80654 -11.80654 -3.333333e+32 -3.333333e+32   \n",
       "\n",
       "         QM    RHOI   RHOK        TI        TK    TVMIN         W     WSOLL  \n",
       "0  21.31388   865.2  865.2  665.7723  662.7723  682.061  79.79695  79.79695  \n",
       "1   0.00000  1000.3  865.2   10.0000  666.0000   10.000   0.00000   0.00000  \n",
       "2  16.34752   865.2  865.2  665.7705  662.7705  682.061  61.20121  61.20121  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(s3s.generate_element_dataframe(element_type=s3s.ObjectTypes.DistrictHeatingConsumer, tks=None, timestamp=1)).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
}