TrainOptimizationChallenge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "import os\n",
    "import collections\n",
    "import datetime\n",
    "import time\n",
    "import re\n",
    "import random\n",
    "from collections import defaultdict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "A dictionary is saved!\n"
     ]
    }
   ],
   "source": [
    "filepath = \"sample_files\\\\01_dummy.json\"\n",
    "\n",
    "with open(filepath) as j_obj:\n",
    "    data = json.load(j_obj)\n",
    "    print ('A dictionary is saved!')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Helper functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_TimeString(time_obj):\n",
    "    tme = time_obj.strftime('%H:%M:%S')\n",
    "    return tme"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_TimeTimedelta(time_obj):\n",
    "    minutes = time_obj.minute\n",
    "    sec = time_obj.second\n",
    "    tot_sec = (minutes*60) + sec\n",
    "    d = datetime.timedelta(seconds = tot_sec)\n",
    "    return d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_TimeTimedate(tme):\n",
    "    \"\"\"since all my inputs are datetime.time, convert them to timedate object for manipulation\"\"\"\n",
    "    try:\n",
    "        converted_timedate = datetime.datetime.combine(datetime.date(1,1,1),tme[0])\n",
    "    except:\n",
    "        converted_timedate = datetime.datetime.combine(datetime.date(1,1,1),tme)\n",
    "    return converted_timedate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_StrTime(str_tme):\n",
    "    tme = datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time()\n",
    "    return tme"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_IntTime(tme):\n",
    "    \"\"\"convert an integear to timedate, then convert to timedelta.\"\"\"\n",
    "    if tme >= 60:\n",
    "        minute,sec = divmod(tme,60)\n",
    "        str_tme = ':'.join(['00',str(minute),str(sec)])\n",
    "    else:\n",
    "        str_tme = ':'.join(['00','00',str(tme)])\n",
    "    dt = datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time()   \n",
    "    return dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\" A Python Class\n",
    "A simple Python graph class, demonstrating the essential facts and functionalities of graphs.\n",
    "\"\"\"\n",
    "\n",
    "class Graph(object):\n",
    "\n",
    "    def __init__(self, graph_dict=None):\n",
    "        \"\"\" initializes a graph object. If no dictionary or None is given,an empty dictionary will be used.\"\"\"\n",
    "        if graph_dict == None:\n",
    "            graph_dict = {}\n",
    "        self.__graph_dict = graph_dict\n",
    "\n",
    "    def vertices(self):\n",
    "        \"\"\" returns the vertices of a graph \"\"\"\n",
    "        return list(self.__graph_dict.keys())\n",
    "\n",
    "    def edges(self):\n",
    "        \"\"\" returns the edges of a graph \"\"\"\n",
    "        return self.__generate_edges()\n",
    "\n",
    "    def __generate_edges(self):\n",
    "        \"\"\" A static method generating the edges of the graph \"graph\". Edges are represented as sets with one \n",
    "            (a loop back to the vertex) or two vertices. \"\"\"\n",
    "        edges = []\n",
    "        #value vertex checked for is the key\n",
    "        for vertex in self.__graph_dict:\n",
    "            #get the value of graph[vertex]\n",
    "            #neighbour is the values/edges to each key/vertex\n",
    "            if isinstance(vertex,int):\n",
    "                for neighbour in self.__graph_dict[vertex]:\n",
    "                    if {neighbour, vertex} not in edges:\n",
    "                        edges.append({vertex, neighbour})\n",
    "        return edges\n",
    "\n",
    "    def __str__(self):\n",
    "        res = \"vertices: \"\n",
    "        for k in self.__graph_dict:\n",
    "            res += str(k) + \" \"\n",
    "        res += \"\\nedges: \"\n",
    "        for edge in self.__generate_edges():\n",
    "            res += str(edge) + \" \"\n",
    "        return res\n",
    "\n",
    "    def find_all_paths(self,start_vertex,end_vertex, path=[]):\n",
    "        \"\"\" find all paths from start_vertex to end_vertex in graph \"\"\"\n",
    "        graph = self.__graph_dict \n",
    "        path = path + [start_vertex]\n",
    "        if start_vertex == end_vertex:\n",
    "            return [path]\n",
    "        if start_vertex not in graph: #check for dict key\n",
    "            return []\n",
    "        paths = []\n",
    "        for vertex in graph[start_vertex]: #loop thru graph dict using key, obtaining the dict value\n",
    "            if vertex not in path:\n",
    "                extended_paths = self.find_all_paths(vertex, end_vertex, path) #reloading funct with list with vertices.\n",
    "                for p in extended_paths: \n",
    "                    paths.append(p)\n",
    "        return paths\n",
    "    \n",
    "    def add_vertex(self, vertex):\n",
    "        \"\"\" If the vertex \"vertex\" is not in self.__graph_dict, a key \"vertex\" with an empty list as a value \n",
    "            is added to the dictionary. Otherwise nothing has to be done.\"\"\"\n",
    "        if vertex not in self.__graph_dict:\n",
    "            self.__graph_dict[vertex] = []\n",
    "\n",
    "    def add_edge(self, edge):\n",
    "        \"\"\" assumes that edge is of type set, tuple or list;between two vertices can be multiple edges! \"\"\"\n",
    "        edge = set(edge)\n",
    "        (vertex1, vertex2) = tuple(edge)\n",
    "        if vertex1 in self.__graph_dict:\n",
    "            self.__graph_dict[vertex1].append(vertex2)\n",
    "        else:\n",
    "            self.__graph_dict[vertex1] = [vertex2]\n",
    "\n",
    "   \n",
    "    def find_isolated_nodes(graph):\n",
    "        \"\"\" returns a list of isolated nodes. \"\"\"\n",
    "        isolated = []\n",
    "        for node in graph:\n",
    "            if not graph[node]:\n",
    "                isolated += node\n",
    "        return isolated   "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting Resource"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def extract_Resources(json_file, json_key, lst_name = []):\n",
    "    for resource in json_file['resources']:\n",
    "        if json_key == 'release_time':\n",
    "            tme = resource['release_time']\n",
    "            found_tme = re.findall(r'(\\d+)',tme)\n",
    "            lst_name.append(int(found_tme[0]))\n",
    "        else:\n",
    "            lst_name.append(resource[json_key])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create generic object\n",
    "Resource = collections.namedtuple('Resource',['resource_id','release_time', 'following_allowed'])\n",
    "\n",
    "class TrainResource():\n",
    "    r_id,r_time,following = [],[],[]\n",
    "    extract_Resources(data,'id',r_id)\n",
    "    extract_Resources(data,'release_time',r_time)\n",
    "    extract_Resources(data,'following_allowed',following)\n",
    "    \n",
    "    combined = list(zip(r_id,r_time,following))\n",
    "    \n",
    "    def __init__(self):\n",
    "        self._resource = [Resource(a,b,c) for a,b,c in self.combined]\n",
    "        \n",
    "    def __len__(self):\n",
    "        return len(self._resource)\n",
    "\n",
    "    def __getitem__(self, position):\n",
    "        return self._resource[position]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "resource = TrainResource()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Extracting Connections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_ConnectID(json_file,lst_name=[]):\n",
    "    for si in data['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            if (sect_req['connections']):\n",
    "                lst_name.append(si['id'])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_ConnectSI(json_file,lst_name=[]):\n",
    "    for si in data['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            if (sect_req['connections']):\n",
    "                for connection in sect_req['connections']:\n",
    "                    lst_name.append(connection['onto_service_intention'])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_ConnectSM(json_file,lst_name=[]):\n",
    "    for si in data['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            if (sect_req['connections']):\n",
    "                for connection in sect_req['connections']:\n",
    "                    lst_name.append(connection['onto_section_marker'])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_ConnectTime(json_file,lst_name=[]):\n",
    "    \"\"\"To extract connections time\"\"\"\n",
    "    for si in data['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            if (sect_req['connections']):\n",
    "                for connection in sect_req['connections']:\n",
    "                    time = connection['min_connection_time']\n",
    "                    tme = re.findall(r'\\d?\\d[MS]',time)\n",
    "                    if (len(tme) == 1) & (tme[0][-1] == 'S'):\n",
    "                        str_tme = ':'.join(['00','00',tme[0][:-1]])\n",
    "                    elif (len(tme) == 1) & (tme[0][-1] == 'M'):\n",
    "                        str_tme = ':'.join(['00',tme[0][:-1],'00'])\n",
    "                    else:\n",
    "                        str_tme = ':'.join(['00',tme[0][:-1],tme[1][:-1]])\n",
    "                    lst_name.append(datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time())\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "Connections = collections.namedtuple('Connections',['route_id','on_si','on_sm','min_connect_time'])\n",
    "\n",
    "class Connects:\n",
    "    route_id, on_si,on_sm,connect_time = [],[],[],[]\n",
    "    extract_ConnectID(data,route_id)\n",
    "    extract_ConnectSI(data,on_si)\n",
    "    extract_ConnectSM(data,on_sm)\n",
    "    extract_ConnectTime(data,connect_time)\n",
    "    \n",
    "    combined = list(zip(route_id,on_si,on_sm,connect_time))\n",
    "    \n",
    "    def __init__(self):\n",
    "        self._connect = [Connections(a,b,c,d) for a,b,c,d in self.combined]\n",
    "        \n",
    "    def __len__(self):\n",
    "        return len(self._connect)\n",
    "\n",
    "    def __getitem__(self, position):\n",
    "        return self._connect[position]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "connections = Connects()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Train Routes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_AltMarkerEntry(json_file,lst_name=[]):\n",
    "    \"\"\"To extract alternative marker\"\"\"\n",
    "    for route in json_file['routes']:\n",
    "        for id in route['route_paths']:\n",
    "            for route_section in id['route_sections']:\n",
    "                try:\n",
    "                    lst_name.append(route_section['route_alternative_marker_at_entry'][0])\n",
    "                except:\n",
    "                    lst_name.append(0)\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_AltMarkerExit(json_file,lst_name=[]):\n",
    "    \"\"\"To extract alternative marker\"\"\"\n",
    "    for route in data['routes']:\n",
    "        for id in route['route_paths']:\n",
    "            for route_section in id['route_sections']:\n",
    "                try:\n",
    "                    lst_name.append(route_section['route_alternative_marker_at_exit'][0])\n",
    "                except:\n",
    "                    lst_name.append(0)\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_RSData(json_file,json_key,lst_name = []):\n",
    "    \"\"\"3rd loop, sequence_number/penalty\"\"\"\n",
    "    for route in json_file['routes']:\n",
    "        for id in route['route_paths']:\n",
    "            for route_section in (id['route_sections']):\n",
    "                if json_key == 'penalty':\n",
    "                    txt_to_check = route_section['penalty']\n",
    "                    if txt_to_check is None:\n",
    "                        lst_name.append(0)\n",
    "                    else:\n",
    "                        lst_name.append(route_section['penalty'])\n",
    "                else:\n",
    "                    lst_name.append(route_section[json_key])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_SectionMarker(json_file,lst_name=[]):\n",
    "    \"\"\"3rd loop, section marker\"\"\"\n",
    "    for route in json_file['routes']:\n",
    "        for id in route['route_paths']:\n",
    "            for section_marker in (id['route_sections']):\n",
    "                try:\n",
    "                    lst_name.append(section_marker['section_marker'][0])\n",
    "                except:\n",
    "                    lst_name.append(0)\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_RoutePathID(json_file,lst_name = []):\n",
    "    '''extract route paths id of recommended routes(2nd depth)'''\n",
    "    for route in json_file['routes']:\n",
    "        for id in (route['route_paths']):\n",
    "            length = len(id['route_sections'])\n",
    "            y = 1\n",
    "            while y <= length:\n",
    "                lst_name.append(id['id'])\n",
    "                y +=1\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_TrainIDRoutesAltMarker(json_file,lst_name=[]):\n",
    "    \"\"\"Extract ID of suggested routes of trains for route alternative marker\"\"\"\n",
    "    for index,route in enumerate(json_file['routes']):\n",
    "        train_id = route['id']\n",
    "        total = 0\n",
    "        for id in route['route_paths']:\n",
    "            num_lst = []\n",
    "            for index,sm in enumerate(id['route_sections'],1):\n",
    "                num_lst.append(index)\n",
    "                num = num_lst[-1]\n",
    "            total = total + num\n",
    "        y = 1\n",
    "        while y <= total:\n",
    "            lst_name.extend([train_id] * 2)\n",
    "            y += 1\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_TrainIDRoutes(json_file,lst_name=[]):\n",
    "    \"\"\"Extract ID of suggested routes of trains\"\"\"\n",
    "    for index,route in enumerate(json_file['routes']):\n",
    "        train_id = route['id']\n",
    "        total = 0\n",
    "        for id in route['route_paths']:\n",
    "            num_lst = []\n",
    "            for index,sm in enumerate(id['route_sections'],1):\n",
    "                num_lst.append(index)\n",
    "                num = num_lst[-1]\n",
    "            total = total + num\n",
    "        y = 1\n",
    "        while y <= total:\n",
    "            lst_name.append(train_id)\n",
    "            y += 1\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_MinRunTime(json_file,lst_name=[]):\n",
    "    \"\"\"Min running time for each route section\"\"\"\n",
    "    for route in data['routes']:\n",
    "        for time in route['route_paths']:\n",
    "            for run_time in (time['route_sections']):\n",
    "                time = run_time['minimum_running_time']\n",
    "                tme = re.findall(r'\\d?\\d[MS]',time)\n",
    "                if (len(tme) == 1) & (tme[0][-1] == 'S'):\n",
    "                    str_tme = ':'.join(['00','00',tme[0][:-1]])\n",
    "                elif (len(tme) == 1) & (tme[0][-1] == 'M'):\n",
    "                    str_tme = ':'.join(['00',tme[0][:-1],'00'])\n",
    "                else:\n",
    "                    str_tme = ':'.join(['00',tme[0][:-1],tme[1][:-1]])\n",
    "                lst_name.append(datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time())\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def extract_ResourceOccupation(json_file,lst_name=[]):\n",
    "    for route in json_file['routes']:\n",
    "        for id in route['route_paths']:\n",
    "            for section_marker in (id['route_sections']):\n",
    "                resource_lst = []\n",
    "                for resource in section_marker['resource_occupations']:\n",
    "                    r = resource['resource']\n",
    "                    resource_lst.append(r)\n",
    "                lst_name.append(resource_lst)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create generic object\n",
    "Route = collections.namedtuple('Route',['train_id','route_path_id','seq_num','sect_marker','ram_entry','ram_exit',\n",
    "                                        'min_run_time','penalty','resource'])\n",
    "\n",
    "class TrainRoutes:\n",
    "    #get data from json file using customized functions\n",
    "    sequence_numbers,section_markers,route_path_ids,train_ids,penalty,min_run_time= [],[],[],[],[],[]\n",
    "    ram_entry,ram_exit,resource = [],[],[]\n",
    "    extract_RSData(data,'sequence_number',sequence_numbers)\n",
    "    extract_SectionMarker(data,section_markers)\n",
    "    extract_RoutePathID(data,route_path_ids)\n",
    "    extract_TrainIDRoutes(data,train_ids)\n",
    "    extract_AltMarkerEntry(data,ram_entry)\n",
    "    extract_AltMarkerExit(data,ram_exit)\n",
    "    extract_RSData(data,'penalty',penalty)\n",
    "    extract_MinRunTime(data,min_run_time)\n",
    "    extract_ResourceOccupation(data,resource)\n",
    "    \n",
    "    #\n",
    "    combined = list(zip(train_ids,route_path_ids,sequence_numbers,section_markers,ram_entry,ram_exit,min_run_time,penalty,resource))\n",
    "    \n",
    "    def __init__(self):\n",
    "        self._routes = [Route(a,b,c,d,e,f,g,h,i) for a,b,c,d,e,f,g,h,i in self.combined]\n",
    "        \n",
    "    def __len__(self):\n",
    "        return len(self._routes)\n",
    "\n",
    "    def __getitem__(self, position):\n",
    "        return self._routes[position]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_route = TrainRoutes()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Service Intentions (trains to be scheduled)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_ID(json_key,json_file,lst_name=[]):\n",
    "    '''Extraction service intention ID or route ID(1st loop)'''\n",
    "    if json_key == 'service_intentions':\n",
    "        for si in json_file[json_key]:\n",
    "            length = len(si['section_requirements'])\n",
    "            y = 1\n",
    "            while y <= length:\n",
    "                lst_name.append(si['id'])\n",
    "                y +=1\n",
    "    elif json_key == 'routes':\n",
    "        for route in json_file[json_key]:\n",
    "            lst_name.append(route['id'])\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_SIData(json_file,json_key,lst_name=[]):\n",
    "    \"\"\"To extract section_requirements of SI (sequence_num,sect_mark,entry_wgt,exit_wgt)\"\"\"\n",
    "    for si in json_file['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            try:\n",
    "                lst_name.append(sect_req[json_key])\n",
    "            except:\n",
    "                lst_name.append(0)\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_Timings(json_file,json_key,lst_name=[]):\n",
    "    \"\"\"To extract section_requirements of SI\"\"\"\n",
    "    for si in json_file['service_intentions']:\n",
    "        for index,sect_req in enumerate(si['section_requirements']):\n",
    "            #timings = ['entry_earliest','exit_earliest','exit_latest']\n",
    "            #for time in timings:\n",
    "            try:\n",
    "                tme = sect_req[json_key]\n",
    "                dt = datetime.datetime.strptime(tme,\"%H:%M:%S\").time()\n",
    "                lst_name.append(dt)\n",
    "            except:\n",
    "                lst_name.append(0)\n",
    "    return lst_name "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extract_MinStopTime(json_file,lst_name=[]):\n",
    "    \"\"\"To extract Minimum Stopping Time\"\"\"\n",
    "    for si in json_file['service_intentions']:\n",
    "        for sect_req in si['section_requirements']:\n",
    "            try:\n",
    "                time = sect_req['min_stopping_time']\n",
    "                tme = re.findall(r'\\d?\\d[MS]',time)\n",
    "                if (len(tme) == 1) & (tme[0][-1] == 'S'):\n",
    "                    str_tme = ':'.join(['00','00',tme[0][:-1]])\n",
    "                elif (len(tme) == 1) & (tme[0][-1] == 'M'):\n",
    "                    str_tme = ':'.join(['00',tme[0][:-1],'00'])\n",
    "                else:\n",
    "                    str_tme = ':'.join(['00',tme[0][:-1],tme[1][:-1]])\n",
    "                lst_name.append(datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time())\n",
    "            except:\n",
    "                lst_name.append(0)\n",
    "    return lst_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.time(0, 0, 10)"
      ]
     },
     "execution_count": 200,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "txt = 'PT10S'\n",
    "tme = re.findall(r'\\d?\\d[MS]',txt)\n",
    "if (len(tme) == 1) & (tme[0][-1] == 'S'):\n",
    "    str_tme = ':'.join(['00','00',tme[0][:-1]])\n",
    "elif (len(tme) == 1) & (tme[0][-1] == 'M'):\n",
    "    str_tme = ':'.join(['00',tme[0][:-1],'00'])\n",
    "else:\n",
    "    str_tme = ':'.join(['00',tme[0][:-1],tme[1][:-1]])\n",
    "datetime.datetime.strptime(str_tme,\"%H:%M:%S\").time()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create generic object\n",
    "Service_Intention = collections.namedtuple('SI',['si_id','seq_num','sect_marker','entry_earliest','entry_latest','exit_earliest',\n",
    "                                                 'exit_latest','stop_time','entry_wgt','exit_wgt'])\n",
    "\n",
    "class SI_Routes:\n",
    "    #get data from json file using customized functions\n",
    "    si_sequence_numbers,si_section_markers,si_id,ent_early,ent_late = [],[],[],[],[]\n",
    "    ext_early,ext_late = [],[]\n",
    "    stop_time,entry_delay_weight,exit_delay_weight = [],[],[]\n",
    "    extract_SIData(data,'sequence_number',si_sequence_numbers)\n",
    "    extract_SIData(data,'section_marker',si_section_markers)\n",
    "    extract_ID('service_intentions',data,si_id)\n",
    "    extract_Timings(data,'entry_earliest',ent_early)\n",
    "    extract_Timings(data,'entry_latest',ent_late)\n",
    "    extract_Timings(data,'exit_earliest',ext_early)\n",
    "    extract_Timings(data,'exit_latest',ext_late)\n",
    "    extract_MinStopTime(data,stop_time)\n",
    "    extract_SIData(data,'entry_delay_weight',entry_delay_weight)\n",
    "    extract_SIData(data,'exit_delay_weight',exit_delay_weight)\n",
    "    \n",
    "    \n",
    "    combined = list(zip(si_id,si_sequence_numbers,si_section_markers,ent_early,ent_late,ext_early,ext_late,\n",
    "                        stop_time,entry_delay_weight,exit_delay_weight))\n",
    "    \n",
    "    def __init__(self):\n",
    "        self._routes = [Service_Intention(a,b,c,d,e,f,g,h,i,j) for a,b,c,d,e,f,g,h,i,j in self.combined]\n",
    "        \n",
    "    def __len__(self):\n",
    "        return len(self._routes)\n",
    "\n",
    "    def __getitem__(self, position):\n",
    "        return self._routes[position]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "si = SI_Routes()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Starts Here"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of train routes:  318\n"
     ]
    }
   ],
   "source": [
    "route_alternative = []\n",
    "for r in train_route:\n",
    "    to_append = r.train_id,r.route_path_id,r.sect_marker,r.seq_num,(r.ram_entry,r.ram_exit) #r.penalty\n",
    "    route_alternative.append(to_append)\n",
    "print ('Number of train routes: ',len(route_alternative))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create a list with the indices of the train_id to extract the rows attached to a train_id\n",
    "lst = [0]\n",
    "for idx,r in enumerate(train_route[:-1]):\n",
    "    if r.train_id == train_route.train_ids[idx+1]:\n",
    "        pass\n",
    "    else:\n",
    "        lst.append(idx+1)\n",
    "lst.append(idx+2)\n",
    "#output is [0,14,28], which tells me train_id '1' belongs to row (0 to 14), train_id '2' belongs to (14 to 28)\n",
    "\n",
    "train_indexes = []\n",
    "for idx,l in enumerate(lst[:-1]):\n",
    "    paired = (l,lst[idx+1])\n",
    "    train_indexes.append(paired)\n",
    "\n",
    "#create a graph for each train route\n",
    "all_graphs = []\n",
    "for idx in train_indexes:\n",
    "    #extract only route for the same train_id\n",
    "    route = route_alternative[idx[0]:idx[1]]\n",
    "    \n",
    "    graph = defaultdict(list)\n",
    "    for index,tup in enumerate(route[:-1]):\n",
    "        graph['train_id'] = route[0][0]\n",
    "        if tup[3] < route[index+1][3]:\n",
    "        #checks current exit against next entry\n",
    "            if tup[4][1] == route[index+1][4][0]:\n",
    "                exit = tup[3]\n",
    "                nxt_entry = route[index+1][3]    \n",
    "                graph[exit] = [nxt_entry]\n",
    "    missing_graph = defaultdict(list)\n",
    "    #obtain all exit values\n",
    "    exit_lst = [{x[3]:x[4][1]} for x in route if isinstance(x[4][1],str)]\n",
    "    #iterate over them to get entry values and sequence\n",
    "    for ra in route:\n",
    "        for row in exit_lst:\n",
    "            for k,v in row.items():\n",
    "                #compare entry values to defined exit values\n",
    "                if (ra[4][0] == v) & (ra[3] > k):\n",
    "                    #obtain exit values\n",
    "                    seq = ra[3]\n",
    "                    missing_graph[k] = [seq]\n",
    "    \n",
    "    #update graph with missing_graph entries\n",
    "    for k, v in missing_graph.items():\n",
    "        if graph.get(k,[]) == v:\n",
    "            pass\n",
    "        else:\n",
    "            graph[k] = graph.get(k, []) + v\n",
    "    #all_graphs['train_id'] = []\n",
    "    all_graphs.append(graph)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 4 graphs\n",
      "There are 4 suggested paths\n"
     ]
    }
   ],
   "source": [
    "all_paths = []\n",
    "path_dict = defaultdict(list) \n",
    "for graph in all_graphs:\n",
    "    t_id = graph['train_id']\n",
    "    path_dict['train_id'] = t_id\n",
    "    section_marker = [s.sect_marker for s in si if s.si_id == t_id]\n",
    "    start_vertex = [r.seq_num for r in train_route if (r.sect_marker == section_marker[0]) & (r.train_id == t_id)]\n",
    "    end_vertex = [r.seq_num for r in train_route if (r.sect_marker == section_marker[-1]) & (r.train_id == t_id)]\n",
    "       \n",
    "    g = Graph(graph)\n",
    "    vertices = [[x,y] for x in start_vertex for y in end_vertex]\n",
    "    for vertex in vertices:\n",
    "        start,end = vertex[0],vertex[1]\n",
    "        path = g.find_all_paths(start,end)\n",
    "        path_dict['path'] = path\n",
    "        all_penalty,penalty = [],[]\n",
    "        flatten_path = [seq_num for p in path for seq_num in p]\n",
    "        for seq_num in flatten_path:\n",
    "            seq_penalty = [r.penalty for r in train_route if (r.seq_num == seq_num) & (r.train_id == t_id)][0]\n",
    "            penalty.append(seq_penalty)\n",
    "        sum_penalty = sum(penalty)\n",
    "        all_penalty.append(sum_penalty)\n",
    "        path_dict['penalty'] = all_penalty\n",
    "        all_paths.append(path_dict.copy())\n",
    "\n",
    "print ('There are {} graphs'.format(len(all_graphs)))\n",
    "print ('There are {} suggested paths'.format(len(all_paths)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 4 trains to be scheduled\n",
      "The IDs are:  {18825, 20423, 20425, 18823}\n"
     ]
    }
   ],
   "source": [
    "#identify how many service intentions(trains) to schedule\n",
    "lst = []\n",
    "for s_i in si:\n",
    "    lst.append(s_i.si_id)\n",
    "    trains = set(lst)\n",
    "print ('There are {} trains to be scheduled'.format(len(trains)))\n",
    "print ('The IDs are: ',trains)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 93 unique sequences and they are {1, 5, 10, 15, 20, 25, 30, 35, 37, 40, 45, 50, 52, 55, 60, 65, 70, 72, 75, 80, 85, 90, 95, 100, 102, 105, 110, 115, 120, 122, 125, 130, 135, 140, 142, 145, 150, 155, 160, 162, 165, 170, 172, 175, 177, 180, 185, 187, 190, 195, 200, 205, 210, 212, 215, 220, 225, 230, 235, 237, 240, 245, 250, 255, 257, 260, 262, 265, 270, 275, 277, 280, 285, 287, 290, 295, 300, 305, 403, 404, 405, 406, 407, 408, 409, 410, 411, 500, 501, 502, 503, 504, 505}\n"
     ]
    }
   ],
   "source": [
    "#identify how many vertices (aka sequence number) there are\n",
    "lst = []\n",
    "for r in train_route:\n",
    "    lst.append(r.seq_num)\n",
    "    vertex = set(lst)\n",
    "print ('There are {} unique sequences and they are {}'.format(len(vertex),vertex))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Building the list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "18825 scheduled and completed\n",
      "20423 scheduled and completed\n",
      "20425 scheduled and completed\n",
      "18823 scheduled and completed\n",
      "there are 4 trains scheduled\n"
     ]
    }
   ],
   "source": [
    "solution = {'problem_instance_label': data['label'],\n",
    "           'problem_instance_hash': data['hash'],\n",
    "           'hash':data['hash'],\n",
    "            'train_runs':[]\n",
    "           }\n",
    "\n",
    "train_run_sections = []\n",
    "for train in trains:\n",
    "    t_id = train\n",
    "    path_lst = random.choice([path['path'] for path in all_paths if path['train_id'] == t_id])\n",
    "    if len(path_lst) > 1:\n",
    "        c_path = random.choice(path_lst)\n",
    "    else:\n",
    "        c_path = path_lst[0]\n",
    "    \n",
    "    marker_seq = sorted([(r.sect_marker,r.seq_num) for r in train_route for seq in c_path if (r.seq_num == seq) & (r.train_id == t_id)],\n",
    "                        key = lambda x:x[1])\n",
    "    \n",
    "    extract_route_section_id = sorted([(r.train_id,r.seq_num) for r in train_route for seq in c_path if (r.seq_num == seq) & (r.train_id == t_id)],\n",
    "                                      key = lambda x:x[1])\n",
    "    route_section_id = ['#'.join([str(t[0]),str(t[1])]) for t in extract_route_section_id]\n",
    "    \n",
    "    \n",
    "    #train_runs_lst = [{'service_intention_id':t_id,'train_run_sections':[]}]\n",
    "    train_runs_lst = {'service_intention_id':t_id}\n",
    "    lst = []\n",
    "    for index,path in enumerate(marker_seq,1):\n",
    "        section_requirement,sequence_number = path[0],path[1]\n",
    "        lst.append({'section_requirement':section_requirement,'sequence_number':index,\n",
    "                'entry_time':[(s_i.entry_earliest or s_i.entry_latest) for s_i in si if (s_i.sect_marker == section_requirement) & (s_i.si_id == t_id)],\n",
    "                'exit_time':[(s_i.exit_earliest or s_i.exit_latest) for s_i in si if (s_i.sect_marker == section_requirement) & (s_i.si_id == t_id)],\n",
    "                'route':t_id,\n",
    "               'route_section_id':route_section_id[index-1],\n",
    "                'route_path':[r.route_path_id for r in train_route if (r.seq_num == sequence_number) & (r.train_id == t_id)][0]\n",
    "               })\n",
    "    \n",
    "    train_runs_lst['train_run_sections'] = lst\n",
    "    train_run_sections.append(train_runs_lst)\n",
    "    print ('{} scheduled and completed'.format(t_id))\n",
    "solution['train_runs'] = train_run_sections\n",
    "print ('there are {} trains scheduled'.format(len(solution)))    \n",
    "    \n",
    " #train_runs_lst['train_run_sections'] = lst\n",
    "    #train_run_sections.append(train_runs_lst)\n",
    "    \n",
    "\n",
    "#solution['train_runs'] = train_run_sections\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "for lst in solution['train_runs']:\n",
    "    last = None\n",
    "    for row in lst['train_run_sections']:\n",
    "        if last is not None:\n",
    "            row[\"entry_time\"] = last[\"exit_time\"]\n",
    "    \n",
    "        t_id = row['route']\n",
    "        section_requirement = row['section_requirement']\n",
    "        route_section_id = row['route_section_id']\n",
    "        seq_n = int(re.findall(r'\\d+',route_section_id)[1])\n",
    "        converted_entry_time = convert_TimeTimedate(row['entry_time'])\n",
    "        exit_time = (converted_entry_time + delta).time()\n",
    "        #check if 'exit_time' is [0] or []\n",
    "        if (0 in row['exit_time']) | (not row['exit_time']) :\n",
    "            #update row(current) with exit time and state of last changed to row.\n",
    "            row[\"exit_time\"] = [exit_time]\n",
    "        last = row\n",
    "        \n",
    "\n",
    "       \n",
    "        if [s.sect_marker for s in si if (s.si_id == t_id) & (s.sect_marker == section_requirement)]:\n",
    "            #get stop time and min run time\n",
    "            try:\n",
    "                stop_time = convert_TimeTimedelta([s.stop_time for s in si if (s.sect_marker == section_requirement) \n",
    "                                             & (s.si_id == t_id)][0])\n",
    "            except:\n",
    "                stop_time = datetime.timedelta(seconds=0)\n",
    "            min_run_time = convert_TimeTimedelta([t.min_run_time for t in train_route if (t.train_id == t_id) \n",
    "                                                  & (t.seq_num == seq_n) & (t.sect_marker == section_requirement)][0])\n",
    "            tot_run_time = (stop_time + min_run_time)\n",
    "        else:\n",
    "            tot_run_time = convert_TimeTimedelta([t.min_run_time for t in train_route if (t.train_id == t_id) \n",
    "                                                  & (t.seq_num == seq_n) & (t.sect_marker == section_requirement)][0])\n",
    "        exit_time = (converted_entry_time + tot_run_time).time()\n",
    "        if (row['exit_time'] == []) | (row['exit_time'] == [0]):\n",
    "            row['exit_time'] = [exit_time]\n",
    "        else: #check the existing exit value\n",
    "            if (exit_time >= row['exit_time'][0]):\n",
    "                row['exit_time'] = [exit_time]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'hash': 759370455,\n",
       " 'problem_instance_hash': 759370455,\n",
       " 'problem_instance_label': '01_dummy',\n",
       " 'train_runs': [{'service_intention_id': 18825,\n",
       "   'train_run_sections': [{'entry_time': [datetime.time(7, 5)],\n",
       "     'exit_time': [datetime.time(7, 7)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#1',\n",
       "     'section_requirement': 'ZLOE_Halt',\n",
       "     'sequence_number': 1},\n",
       "    {'entry_time': [datetime.time(7, 7)],\n",
       "     'exit_time': [datetime.time(7, 7, 32)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#5',\n",
       "     'section_requirement': 'ZLOE',\n",
       "     'sequence_number': 2},\n",
       "    {'entry_time': [datetime.time(7, 7, 32)],\n",
       "     'exit_time': [datetime.time(7, 8, 2)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#10',\n",
       "     'section_requirement': 'ZUET40',\n",
       "     'sequence_number': 3},\n",
       "    {'entry_time': [datetime.time(7, 8, 2)],\n",
       "     'exit_time': [datetime.time(7, 8, 32)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#15',\n",
       "     'section_requirement': 'ZUEZSW',\n",
       "     'sequence_number': 4},\n",
       "    {'entry_time': [datetime.time(7, 8, 32)],\n",
       "     'exit_time': [datetime.time(7, 9, 2)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#20',\n",
       "     'section_requirement': 'ZLST',\n",
       "     'sequence_number': 5},\n",
       "    {'entry_time': [datetime.time(7, 9, 2)],\n",
       "     'exit_time': [datetime.time(7, 9, 32)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#25',\n",
       "     'section_requirement': 'ZAU90',\n",
       "     'sequence_number': 6},\n",
       "    {'entry_time': [datetime.time(7, 9, 32)],\n",
       "     'exit_time': [datetime.time(7, 10, 2)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#30',\n",
       "     'section_requirement': 'ZAU',\n",
       "     'sequence_number': 7},\n",
       "    {'entry_time': [datetime.time(7, 10, 2)],\n",
       "     'exit_time': [datetime.time(7, 10, 32)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#35',\n",
       "     'section_requirement': 'ZAUZBT',\n",
       "     'sequence_number': 8},\n",
       "    {'entry_time': [datetime.time(7, 10, 32)],\n",
       "     'exit_time': [datetime.time(7, 11, 6)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#37',\n",
       "     'section_requirement': 'ZWIE_Halt',\n",
       "     'sequence_number': 9},\n",
       "    {'entry_time': [datetime.time(7, 11, 6)],\n",
       "     'exit_time': [datetime.time(7, 11, 50)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#40',\n",
       "     'section_requirement': 'ZWIE',\n",
       "     'sequence_number': 10},\n",
       "    {'entry_time': [datetime.time(7, 11, 50)],\n",
       "     'exit_time': [datetime.time(7, 12, 20)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#45',\n",
       "     'section_requirement': 'ZWIE70',\n",
       "     'sequence_number': 11},\n",
       "    {'entry_time': [datetime.time(7, 12, 20)],\n",
       "     'exit_time': [datetime.time(7, 12, 50)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#50',\n",
       "     'section_requirement': 'ZEN10',\n",
       "     'sequence_number': 12},\n",
       "    {'entry_time': [datetime.time(7, 12, 50)],\n",
       "     'exit_time': [datetime.time(7, 13, 24)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#52',\n",
       "     'section_requirement': 'ZEN_Halt',\n",
       "     'sequence_number': 13},\n",
       "    {'entry_time': [datetime.time(7, 13, 24)],\n",
       "     'exit_time': [datetime.time(7, 14, 11)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#55',\n",
       "     'section_requirement': 'ZEN',\n",
       "     'sequence_number': 14},\n",
       "    {'entry_time': [datetime.time(7, 14, 11)],\n",
       "     'exit_time': [datetime.time(7, 14, 41)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#60',\n",
       "     'section_requirement': 'ZEN60',\n",
       "     'sequence_number': 15},\n",
       "    {'entry_time': [datetime.time(7, 14, 41)],\n",
       "     'exit_time': [datetime.time(7, 15, 11)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#65',\n",
       "     'section_requirement': 'ZWOL10',\n",
       "     'sequence_number': 16},\n",
       "    {'entry_time': [datetime.time(7, 15, 11)],\n",
       "     'exit_time': [datetime.time(7, 15, 41)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#70',\n",
       "     'section_requirement': 'ZWOL40',\n",
       "     'sequence_number': 17},\n",
       "    {'entry_time': [datetime.time(7, 15, 41)],\n",
       "     'exit_time': [datetime.time(7, 16, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#72',\n",
       "     'section_requirement': 'ZWOL_Halt',\n",
       "     'sequence_number': 18},\n",
       "    {'entry_time': [datetime.time(7, 16, 15)],\n",
       "     'exit_time': [datetime.time(7, 17, 9)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#75',\n",
       "     'section_requirement': 'ZWOL',\n",
       "     'sequence_number': 19},\n",
       "    {'entry_time': [datetime.time(7, 17, 9)],\n",
       "     'exit_time': [datetime.time(7, 17, 39)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#80',\n",
       "     'section_requirement': 'ZWOL70',\n",
       "     'sequence_number': 20},\n",
       "    {'entry_time': [datetime.time(7, 17, 39)],\n",
       "     'exit_time': [datetime.time(7, 18, 9)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#85',\n",
       "     'section_requirement': 'ZWOL80',\n",
       "     'sequence_number': 21},\n",
       "    {'entry_time': [datetime.time(7, 18, 9)],\n",
       "     'exit_time': [datetime.time(7, 18, 42)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#90',\n",
       "     'section_requirement': 'ZWOL-KIL05',\n",
       "     'sequence_number': 22},\n",
       "    {'entry_time': [datetime.time(7, 18, 42)],\n",
       "     'exit_time': [datetime.time(7, 19, 12)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#95',\n",
       "     'section_requirement': 'ZWOL-KIL06',\n",
       "     'sequence_number': 23},\n",
       "    {'entry_time': [datetime.time(7, 19, 12)],\n",
       "     'exit_time': [datetime.time(7, 19, 42)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#100',\n",
       "     'section_requirement': 'KILW',\n",
       "     'sequence_number': 24},\n",
       "    {'entry_time': [datetime.time(7, 19, 42)],\n",
       "     'exit_time': [datetime.time(7, 20, 16)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#102',\n",
       "     'section_requirement': 'KIL_Halt',\n",
       "     'sequence_number': 25},\n",
       "    {'entry_time': [datetime.time(7, 20, 16)],\n",
       "     'exit_time': [datetime.time(7, 21, 1)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#105',\n",
       "     'section_requirement': 'KIL',\n",
       "     'sequence_number': 26},\n",
       "    {'entry_time': [datetime.time(7, 21, 1)],\n",
       "     'exit_time': [datetime.time(7, 21, 31)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#110',\n",
       "     'section_requirement': 'KILO',\n",
       "     'sequence_number': 27},\n",
       "    {'entry_time': [datetime.time(7, 21, 31)],\n",
       "     'exit_time': [datetime.time(7, 22, 1)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#115',\n",
       "     'section_requirement': 'KIL50',\n",
       "     'sequence_number': 28},\n",
       "    {'entry_time': [datetime.time(7, 22, 1)],\n",
       "     'exit_time': [datetime.time(7, 22, 31)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#120',\n",
       "     'section_requirement': 'KIL-RUES07',\n",
       "     'sequence_number': 29},\n",
       "    {'entry_time': [datetime.time(7, 22, 31)],\n",
       "     'exit_time': [datetime.time(7, 23, 5)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#122',\n",
       "     'section_requirement': 'RUES_Halt',\n",
       "     'sequence_number': 30},\n",
       "    {'entry_time': [datetime.time(7, 23, 5)],\n",
       "     'exit_time': [datetime.time(7, 24, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#125',\n",
       "     'section_requirement': 'RUES',\n",
       "     'sequence_number': 31},\n",
       "    {'entry_time': [datetime.time(7, 24, 15)],\n",
       "     'exit_time': [datetime.time(7, 24, 45)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#130',\n",
       "     'section_requirement': 'RUES60',\n",
       "     'sequence_number': 32},\n",
       "    {'entry_time': [datetime.time(7, 24, 45)],\n",
       "     'exit_time': [datetime.time(7, 25, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#135',\n",
       "     'section_requirement': 'RUESO',\n",
       "     'sequence_number': 33},\n",
       "    {'entry_time': [datetime.time(7, 25, 15)],\n",
       "     'exit_time': [datetime.time(7, 25, 45)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#140',\n",
       "     'section_requirement': 'TWNO',\n",
       "     'sequence_number': 34},\n",
       "    {'entry_time': [datetime.time(7, 25, 45)],\n",
       "     'exit_time': [datetime.time(7, 26, 19)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#142',\n",
       "     'section_requirement': 'TW_Halt',\n",
       "     'sequence_number': 35},\n",
       "    {'entry_time': [datetime.time(7, 26, 19)],\n",
       "     'exit_time': [datetime.time(7, 27, 11)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#145',\n",
       "     'section_requirement': 'TW',\n",
       "     'sequence_number': 36},\n",
       "    {'entry_time': [datetime.time(7, 27, 11)],\n",
       "     'exit_time': [datetime.time(7, 27, 41)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#150',\n",
       "     'section_requirement': 'TWO',\n",
       "     'sequence_number': 37},\n",
       "    {'entry_time': [datetime.time(7, 27, 41)],\n",
       "     'exit_time': [datetime.time(7, 28, 11)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#155',\n",
       "     'section_requirement': 'TW80',\n",
       "     'sequence_number': 38},\n",
       "    {'entry_time': [datetime.time(7, 28, 11)],\n",
       "     'exit_time': [datetime.time(7, 28, 41)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#160',\n",
       "     'section_requirement': 'TW90',\n",
       "     'sequence_number': 39},\n",
       "    {'entry_time': [datetime.time(7, 28, 41)],\n",
       "     'exit_time': [datetime.time(7, 29, 11)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#165',\n",
       "     'section_requirement': 'TW-ORD10',\n",
       "     'sequence_number': 40},\n",
       "    {'entry_time': [datetime.time(7, 29, 11)],\n",
       "     'exit_time': [datetime.time(7, 29, 41)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#170',\n",
       "     'section_requirement': 'TW-ORD11',\n",
       "     'sequence_number': 41},\n",
       "    {'entry_time': [datetime.time(7, 29, 41)],\n",
       "     'exit_time': [datetime.time(7, 30, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#172',\n",
       "     'section_requirement': 'ORD_Halt',\n",
       "     'sequence_number': 42},\n",
       "    {'entry_time': [datetime.time(7, 30, 15)],\n",
       "     'exit_time': [datetime.time(7, 31)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#175',\n",
       "     'section_requirement': 'ORD',\n",
       "     'sequence_number': 43},\n",
       "    {'entry_time': [datetime.time(7, 31)],\n",
       "     'exit_time': [datetime.time(7, 31, 52)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#180',\n",
       "     'section_requirement': 'ORD-HG13',\n",
       "     'sequence_number': 44},\n",
       "    {'entry_time': [datetime.time(7, 31, 52)],\n",
       "     'exit_time': [datetime.time(7, 32, 22)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#185',\n",
       "     'section_requirement': 'HGW',\n",
       "     'sequence_number': 45},\n",
       "    {'entry_time': [datetime.time(7, 32, 22)],\n",
       "     'exit_time': [datetime.time(7, 32, 56)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#187',\n",
       "     'section_requirement': 'HG_Halt',\n",
       "     'sequence_number': 46},\n",
       "    {'entry_time': [datetime.time(7, 32, 56)],\n",
       "     'exit_time': [datetime.time(7, 33, 56)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#190',\n",
       "     'section_requirement': 'HG',\n",
       "     'sequence_number': 47},\n",
       "    {'entry_time': [datetime.time(7, 33, 56)],\n",
       "     'exit_time': [datetime.time(7, 34, 26)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#195',\n",
       "     'section_requirement': 'HGO',\n",
       "     'sequence_number': 48},\n",
       "    {'entry_time': [datetime.time(7, 34, 26)],\n",
       "     'exit_time': [datetime.time(7, 35, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#200',\n",
       "     'section_requirement': 'HG-AU18',\n",
       "     'sequence_number': 49},\n",
       "    {'entry_time': [datetime.time(7, 35, 15)],\n",
       "     'exit_time': [datetime.time(7, 35, 53)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#205',\n",
       "     'section_requirement': 'HG-AU19',\n",
       "     'sequence_number': 50},\n",
       "    {'entry_time': [datetime.time(7, 35, 53)],\n",
       "     'exit_time': [datetime.time(7, 36, 23)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#210',\n",
       "     'section_requirement': 'AUW',\n",
       "     'sequence_number': 51},\n",
       "    {'entry_time': [datetime.time(7, 36, 23)],\n",
       "     'exit_time': [datetime.time(7, 36, 57)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#212',\n",
       "     'section_requirement': 'AU_Halt',\n",
       "     'sequence_number': 52},\n",
       "    {'entry_time': [datetime.time(7, 36, 57)],\n",
       "     'exit_time': [datetime.time(7, 38, 2)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#215',\n",
       "     'section_requirement': 'AU',\n",
       "     'sequence_number': 53},\n",
       "    {'entry_time': [datetime.time(7, 38, 2)],\n",
       "     'exit_time': [datetime.time(7, 38, 32)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#220',\n",
       "     'section_requirement': 'AUO',\n",
       "     'sequence_number': 54},\n",
       "    {'entry_time': [datetime.time(7, 38, 32)],\n",
       "     'exit_time': [datetime.time(7, 39, 14)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#225',\n",
       "     'section_requirement': 'AU-WAE21',\n",
       "     'sequence_number': 55},\n",
       "    {'entry_time': [datetime.time(7, 39, 14)],\n",
       "     'exit_time': [datetime.time(7, 39, 49)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#230',\n",
       "     'section_requirement': 'AU-WAE23',\n",
       "     'sequence_number': 56},\n",
       "    {'entry_time': [datetime.time(7, 39, 49)],\n",
       "     'exit_time': [datetime.time(7, 40, 19)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#235',\n",
       "     'section_requirement': 'WAEW',\n",
       "     'sequence_number': 57},\n",
       "    {'entry_time': [datetime.time(7, 40, 19)],\n",
       "     'exit_time': [datetime.time(7, 40, 53)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#237',\n",
       "     'section_requirement': 'WAE_Halt',\n",
       "     'sequence_number': 58},\n",
       "    {'entry_time': [datetime.time(7, 40, 53)],\n",
       "     'exit_time': [datetime.time(7, 41, 47)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#240',\n",
       "     'section_requirement': 'WAE',\n",
       "     'sequence_number': 59},\n",
       "    {'entry_time': [datetime.time(7, 41, 47)],\n",
       "     'exit_time': [datetime.time(7, 42, 17)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#245',\n",
       "     'section_requirement': 'WAEO',\n",
       "     'sequence_number': 60},\n",
       "    {'entry_time': [datetime.time(7, 42, 17)],\n",
       "     'exit_time': [datetime.time(7, 42, 47)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#250',\n",
       "     'section_requirement': 'WAE80',\n",
       "     'sequence_number': 61},\n",
       "    {'entry_time': [datetime.time(7, 42, 47)],\n",
       "     'exit_time': [datetime.time(7, 43, 24)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#255',\n",
       "     'section_requirement': 'WAE-RI25',\n",
       "     'sequence_number': 62},\n",
       "    {'entry_time': [datetime.time(7, 43, 24)],\n",
       "     'exit_time': [datetime.time(7, 44)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#260',\n",
       "     'section_requirement': 'WAE-RI26',\n",
       "     'sequence_number': 63},\n",
       "    {'entry_time': [datetime.time(7, 44)],\n",
       "     'exit_time': [datetime.time(7, 44, 34)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#262',\n",
       "     'section_requirement': 'RI_Halt',\n",
       "     'sequence_number': 64},\n",
       "    {'entry_time': [datetime.time(7, 44, 34)],\n",
       "     'exit_time': [datetime.time(7, 45, 40)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#265',\n",
       "     'section_requirement': 'RI',\n",
       "     'sequence_number': 65},\n",
       "    {'entry_time': [datetime.time(7, 45, 40)],\n",
       "     'exit_time': [datetime.time(7, 46, 13)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#270',\n",
       "     'section_requirement': 'RI-HAF28',\n",
       "     'sequence_number': 66},\n",
       "    {'entry_time': [datetime.time(7, 46, 13)],\n",
       "     'exit_time': [datetime.time(7, 46, 43)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#275',\n",
       "     'section_requirement': 'HAF',\n",
       "     'sequence_number': 67},\n",
       "    {'entry_time': [datetime.time(7, 46, 43)],\n",
       "     'exit_time': [datetime.time(7, 47, 17)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#277',\n",
       "     'section_requirement': 'BAE_Halt',\n",
       "     'sequence_number': 68},\n",
       "    {'entry_time': [datetime.time(7, 47, 17)],\n",
       "     'exit_time': [datetime.time(7, 48, 30)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#280',\n",
       "     'section_requirement': 'BAE',\n",
       "     'sequence_number': 69},\n",
       "    {'entry_time': [datetime.time(7, 48, 30)],\n",
       "     'exit_time': [datetime.time(7, 49)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#285',\n",
       "     'section_requirement': 'BAE-FRB30',\n",
       "     'sequence_number': 70},\n",
       "    {'entry_time': [datetime.time(7, 49)],\n",
       "     'exit_time': [datetime.time(7, 49, 34)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#287',\n",
       "     'section_requirement': 'FRB_Halt',\n",
       "     'sequence_number': 71},\n",
       "    {'entry_time': [datetime.time(7, 49, 34)],\n",
       "     'exit_time': [datetime.time(7, 50, 57)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#290',\n",
       "     'section_requirement': 'FRB',\n",
       "     'sequence_number': 72},\n",
       "    {'entry_time': [datetime.time(7, 50, 57)],\n",
       "     'exit_time': [datetime.time(7, 51, 36)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#295',\n",
       "     'section_requirement': 'FRB-PF33',\n",
       "     'sequence_number': 73},\n",
       "    {'entry_time': [datetime.time(7, 51, 36)],\n",
       "     'exit_time': [datetime.time(7, 52, 15)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#300',\n",
       "     'section_requirement': 'PFW',\n",
       "     'sequence_number': 74},\n",
       "    {'entry_time': [datetime.time(7, 52, 15)],\n",
       "     'exit_time': [datetime.time(7, 56, 20)],\n",
       "     'route': 18825,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18825#305',\n",
       "     'section_requirement': 'PF_Halt',\n",
       "     'sequence_number': 75}]},\n",
       "  {'service_intention_id': 20423,\n",
       "   'train_run_sections': [{'entry_time': [datetime.time(6, 48)],\n",
       "     'exit_time': [datetime.time(6, 51)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#1',\n",
       "     'section_requirement': 'ZUE_Halt',\n",
       "     'sequence_number': 1},\n",
       "    {'entry_time': [datetime.time(6, 51)],\n",
       "     'exit_time': [datetime.time(6, 51, 40)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#5',\n",
       "     'section_requirement': 'ZUE_X',\n",
       "     'sequence_number': 2},\n",
       "    {'entry_time': [datetime.time(6, 51, 40)],\n",
       "     'exit_time': [datetime.time(6, 52, 12)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#10',\n",
       "     'section_requirement': 'ZUEC',\n",
       "     'sequence_number': 3},\n",
       "    {'entry_time': [datetime.time(6, 52, 12)],\n",
       "     'exit_time': [datetime.time(6, 52, 42)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#15',\n",
       "     'section_requirement': 'ZUEZSW',\n",
       "     'sequence_number': 4},\n",
       "    {'entry_time': [datetime.time(6, 52, 42)],\n",
       "     'exit_time': [datetime.time(6, 53, 12)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#20',\n",
       "     'section_requirement': 'ZLST',\n",
       "     'sequence_number': 5},\n",
       "    {'entry_time': [datetime.time(6, 53, 12)],\n",
       "     'exit_time': [datetime.time(6, 53, 42)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#25',\n",
       "     'section_requirement': 'ZAU90',\n",
       "     'sequence_number': 6},\n",
       "    {'entry_time': [datetime.time(6, 53, 42)],\n",
       "     'exit_time': [datetime.time(6, 54, 12)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#30',\n",
       "     'section_requirement': 'ZAU',\n",
       "     'sequence_number': 7},\n",
       "    {'entry_time': [datetime.time(6, 54, 12)],\n",
       "     'exit_time': [datetime.time(6, 54, 42)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#35',\n",
       "     'section_requirement': 'ZAUZBT',\n",
       "     'sequence_number': 8},\n",
       "    {'entry_time': [datetime.time(6, 54, 42)],\n",
       "     'exit_time': [datetime.time(6, 55, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#37',\n",
       "     'section_requirement': 'ZWIE_Halt',\n",
       "     'sequence_number': 9},\n",
       "    {'entry_time': [datetime.time(6, 55, 16)],\n",
       "     'exit_time': [datetime.time(6, 56, 1)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#40',\n",
       "     'section_requirement': 'ZWIE',\n",
       "     'sequence_number': 10},\n",
       "    {'entry_time': [datetime.time(6, 56, 1)],\n",
       "     'exit_time': [datetime.time(6, 56, 31)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#45',\n",
       "     'section_requirement': 'ZWIE70',\n",
       "     'sequence_number': 11},\n",
       "    {'entry_time': [datetime.time(6, 56, 31)],\n",
       "     'exit_time': [datetime.time(6, 57, 1)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#50',\n",
       "     'section_requirement': 'ZEN10',\n",
       "     'sequence_number': 12},\n",
       "    {'entry_time': [datetime.time(6, 57, 1)],\n",
       "     'exit_time': [datetime.time(6, 58)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#52',\n",
       "     'section_requirement': 'ZEN_Halt',\n",
       "     'sequence_number': 13},\n",
       "    {'entry_time': [datetime.time(6, 58)],\n",
       "     'exit_time': [datetime.time(6, 58, 46)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#55',\n",
       "     'section_requirement': 'ZEN',\n",
       "     'sequence_number': 14},\n",
       "    {'entry_time': [datetime.time(6, 58, 46)],\n",
       "     'exit_time': [datetime.time(6, 59, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#60',\n",
       "     'section_requirement': 'ZEN60',\n",
       "     'sequence_number': 15},\n",
       "    {'entry_time': [datetime.time(6, 59, 16)],\n",
       "     'exit_time': [datetime.time(6, 59, 46)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#65',\n",
       "     'section_requirement': 'ZWOL10',\n",
       "     'sequence_number': 16},\n",
       "    {'entry_time': [datetime.time(6, 59, 46)],\n",
       "     'exit_time': [datetime.time(7, 0, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#70',\n",
       "     'section_requirement': 'ZWOL40',\n",
       "     'sequence_number': 17},\n",
       "    {'entry_time': [datetime.time(7, 0, 16)],\n",
       "     'exit_time': [datetime.time(7, 0, 50)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#72',\n",
       "     'section_requirement': 'ZWOL_Halt',\n",
       "     'sequence_number': 18},\n",
       "    {'entry_time': [datetime.time(7, 0, 50)],\n",
       "     'exit_time': [datetime.time(7, 1, 44)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#75',\n",
       "     'section_requirement': 'ZWOL',\n",
       "     'sequence_number': 19},\n",
       "    {'entry_time': [datetime.time(7, 1, 44)],\n",
       "     'exit_time': [datetime.time(7, 2, 14)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#80',\n",
       "     'section_requirement': 'ZWOL70',\n",
       "     'sequence_number': 20},\n",
       "    {'entry_time': [datetime.time(7, 2, 14)],\n",
       "     'exit_time': [datetime.time(7, 2, 44)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#85',\n",
       "     'section_requirement': 'ZWOL80',\n",
       "     'sequence_number': 21},\n",
       "    {'entry_time': [datetime.time(7, 2, 44)],\n",
       "     'exit_time': [datetime.time(7, 3, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#90',\n",
       "     'section_requirement': 'ZWOL-KIL05',\n",
       "     'sequence_number': 22},\n",
       "    {'entry_time': [datetime.time(7, 3, 16)],\n",
       "     'exit_time': [datetime.time(7, 3, 46)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#95',\n",
       "     'section_requirement': 'ZWOL-KIL06',\n",
       "     'sequence_number': 23},\n",
       "    {'entry_time': [datetime.time(7, 3, 46)],\n",
       "     'exit_time': [datetime.time(7, 4, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#100',\n",
       "     'section_requirement': 'KILW',\n",
       "     'sequence_number': 24},\n",
       "    {'entry_time': [datetime.time(7, 4, 16)],\n",
       "     'exit_time': [datetime.time(7, 4, 50)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#102',\n",
       "     'section_requirement': 'KIL_Halt',\n",
       "     'sequence_number': 25},\n",
       "    {'entry_time': [datetime.time(7, 4, 50)],\n",
       "     'exit_time': [datetime.time(7, 5, 36)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#105',\n",
       "     'section_requirement': 'KIL',\n",
       "     'sequence_number': 26},\n",
       "    {'entry_time': [datetime.time(7, 5, 36)],\n",
       "     'exit_time': [datetime.time(7, 6, 6)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#110',\n",
       "     'section_requirement': 'KILO',\n",
       "     'sequence_number': 27},\n",
       "    {'entry_time': [datetime.time(7, 6, 6)],\n",
       "     'exit_time': [datetime.time(7, 6, 36)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#115',\n",
       "     'section_requirement': 'KIL50',\n",
       "     'sequence_number': 28},\n",
       "    {'entry_time': [datetime.time(7, 6, 36)],\n",
       "     'exit_time': [datetime.time(7, 7, 6)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#120',\n",
       "     'section_requirement': 'KIL-RUES07',\n",
       "     'sequence_number': 29},\n",
       "    {'entry_time': [datetime.time(7, 7, 6)],\n",
       "     'exit_time': [datetime.time(7, 7, 40)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#122',\n",
       "     'section_requirement': 'RUES_Halt',\n",
       "     'sequence_number': 30},\n",
       "    {'entry_time': [datetime.time(7, 7, 40)],\n",
       "     'exit_time': [datetime.time(7, 8, 49)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#125',\n",
       "     'section_requirement': 'RUES',\n",
       "     'sequence_number': 31},\n",
       "    {'entry_time': [datetime.time(7, 8, 49)],\n",
       "     'exit_time': [datetime.time(7, 9, 19)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#130',\n",
       "     'section_requirement': 'RUES60',\n",
       "     'sequence_number': 32},\n",
       "    {'entry_time': [datetime.time(7, 9, 19)],\n",
       "     'exit_time': [datetime.time(7, 9, 49)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#135',\n",
       "     'section_requirement': 'RUESO',\n",
       "     'sequence_number': 33},\n",
       "    {'entry_time': [datetime.time(7, 9, 49)],\n",
       "     'exit_time': [datetime.time(7, 10, 19)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#140',\n",
       "     'section_requirement': 'TWNO',\n",
       "     'sequence_number': 34},\n",
       "    {'entry_time': [datetime.time(7, 10, 19)],\n",
       "     'exit_time': [datetime.time(7, 10, 53)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#142',\n",
       "     'section_requirement': 'TW_Halt',\n",
       "     'sequence_number': 35},\n",
       "    {'entry_time': [datetime.time(7, 10, 53)],\n",
       "     'exit_time': [datetime.time(7, 11, 44)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#145',\n",
       "     'section_requirement': 'TW',\n",
       "     'sequence_number': 36},\n",
       "    {'entry_time': [datetime.time(7, 11, 44)],\n",
       "     'exit_time': [datetime.time(7, 12, 14)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#150',\n",
       "     'section_requirement': 'TWO',\n",
       "     'sequence_number': 37},\n",
       "    {'entry_time': [datetime.time(7, 12, 14)],\n",
       "     'exit_time': [datetime.time(7, 12, 52)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#155',\n",
       "     'section_requirement': 'TW-ORDD11',\n",
       "     'sequence_number': 38},\n",
       "    {'entry_time': [datetime.time(7, 12, 52)],\n",
       "     'exit_time': [datetime.time(7, 13, 30)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#160',\n",
       "     'section_requirement': 'TW-ORDD12',\n",
       "     'sequence_number': 39},\n",
       "    {'entry_time': [datetime.time(7, 13, 30)],\n",
       "     'exit_time': [datetime.time(7, 14, 4)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#162',\n",
       "     'section_requirement': 'ORDD_Halt',\n",
       "     'sequence_number': 40},\n",
       "    {'entry_time': [datetime.time(7, 14, 4)],\n",
       "     'exit_time': [datetime.time(7, 15, 20)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#165',\n",
       "     'section_requirement': 'ORDD',\n",
       "     'sequence_number': 41},\n",
       "    {'entry_time': [datetime.time(7, 15, 20)],\n",
       "     'exit_time': [datetime.time(7, 15, 50)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#170',\n",
       "     'section_requirement': 'ORDD-HGO15',\n",
       "     'sequence_number': 42},\n",
       "    {'entry_time': [datetime.time(7, 15, 50)],\n",
       "     'exit_time': [datetime.time(7, 16, 20)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#175',\n",
       "     'section_requirement': 'HGOW',\n",
       "     'sequence_number': 43},\n",
       "    {'entry_time': [datetime.time(7, 16, 20)],\n",
       "     'exit_time': [datetime.time(7, 16, 54)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#177',\n",
       "     'section_requirement': 'HGO_Halt',\n",
       "     'sequence_number': 44},\n",
       "    {'entry_time': [datetime.time(7, 16, 54)],\n",
       "     'exit_time': [datetime.time(7, 17, 45)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#180',\n",
       "     'section_requirement': 'HGO',\n",
       "     'sequence_number': 45},\n",
       "    {'entry_time': [datetime.time(7, 17, 45)],\n",
       "     'exit_time': [datetime.time(7, 18, 15)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#185',\n",
       "     'section_requirement': 'HGOO',\n",
       "     'sequence_number': 46},\n",
       "    {'entry_time': [datetime.time(7, 18, 15)],\n",
       "     'exit_time': [datetime.time(7, 18, 45)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#190',\n",
       "     'section_requirement': 'HGO-SBG16',\n",
       "     'sequence_number': 47},\n",
       "    {'entry_time': [datetime.time(7, 18, 45)],\n",
       "     'exit_time': [datetime.time(7, 19, 28)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#195',\n",
       "     'section_requirement': 'HGO-SBG17',\n",
       "     'sequence_number': 48},\n",
       "    {'entry_time': [datetime.time(7, 19, 28)],\n",
       "     'exit_time': [datetime.time(7, 19, 58)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#200',\n",
       "     'section_requirement': 'HGO-SBG18',\n",
       "     'sequence_number': 49},\n",
       "    {'entry_time': [datetime.time(7, 19, 58)],\n",
       "     'exit_time': [datetime.time(7, 20, 28)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#205',\n",
       "     'section_requirement': 'SBG10',\n",
       "     'sequence_number': 50},\n",
       "    {'entry_time': [datetime.time(7, 20, 28)],\n",
       "     'exit_time': [datetime.time(7, 20, 58)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#210',\n",
       "     'section_requirement': 'SBG30',\n",
       "     'sequence_number': 51},\n",
       "    {'entry_time': [datetime.time(7, 20, 58)],\n",
       "     'exit_time': [datetime.time(7, 21, 28)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#215',\n",
       "     'section_requirement': 'SBG',\n",
       "     'sequence_number': 52},\n",
       "    {'entry_time': [datetime.time(7, 21, 28)],\n",
       "     'exit_time': [datetime.time(7, 22, 2)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#220',\n",
       "     'section_requirement': 'SBG-LITT20',\n",
       "     'sequence_number': 53},\n",
       "    {'entry_time': [datetime.time(7, 22, 2)],\n",
       "     'exit_time': [datetime.time(7, 22, 39)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#225',\n",
       "     'section_requirement': 'SBG-LITT21',\n",
       "     'sequence_number': 54},\n",
       "    {'entry_time': [datetime.time(7, 22, 39)],\n",
       "     'exit_time': [datetime.time(7, 23, 15)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#230',\n",
       "     'section_requirement': 'SBG-LITT24',\n",
       "     'sequence_number': 55},\n",
       "    {'entry_time': [datetime.time(7, 23, 15)],\n",
       "     'exit_time': [datetime.time(7, 23, 45)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#235',\n",
       "     'section_requirement': 'LITTN',\n",
       "     'sequence_number': 56},\n",
       "    {'entry_time': [datetime.time(7, 23, 45)],\n",
       "     'exit_time': [datetime.time(7, 24, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#240',\n",
       "     'section_requirement': 'LITT',\n",
       "     'sequence_number': 57},\n",
       "    {'entry_time': [datetime.time(7, 24, 16)],\n",
       "     'exit_time': [datetime.time(7, 24, 46)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#245',\n",
       "     'section_requirement': 'LITTS',\n",
       "     'sequence_number': 58},\n",
       "    {'entry_time': [datetime.time(7, 24, 46)],\n",
       "     'exit_time': [datetime.time(7, 25, 16)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#250',\n",
       "     'section_requirement': 'LITT90',\n",
       "     'sequence_number': 59},\n",
       "    {'entry_time': [datetime.time(7, 25, 16)],\n",
       "     'exit_time': [datetime.time(7, 25, 46)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#255',\n",
       "     'section_requirement': 'LITT-BAA25',\n",
       "     'sequence_number': 60},\n",
       "    {'entry_time': [datetime.time(7, 25, 46)],\n",
       "     'exit_time': [datetime.time(7, 26, 20)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#257',\n",
       "     'section_requirement': 'BAA_Halt',\n",
       "     'sequence_number': 61},\n",
       "    {'entry_time': [datetime.time(7, 26, 20)],\n",
       "     'exit_time': [datetime.time(7, 27, 24)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#260',\n",
       "     'section_requirement': 'BAA',\n",
       "     'sequence_number': 62},\n",
       "    {'entry_time': [datetime.time(7, 27, 24)],\n",
       "     'exit_time': [datetime.time(7, 27, 54)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#265',\n",
       "     'section_requirement': 'BAA70',\n",
       "     'sequence_number': 63},\n",
       "    {'entry_time': [datetime.time(7, 27, 54)],\n",
       "     'exit_time': [datetime.time(7, 28, 24)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#270',\n",
       "     'section_requirement': 'BAA90',\n",
       "     'sequence_number': 64},\n",
       "    {'entry_time': [datetime.time(7, 28, 24)],\n",
       "     'exit_time': [datetime.time(7, 28, 54)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#275',\n",
       "     'section_requirement': 'BAAN',\n",
       "     'sequence_number': 65},\n",
       "    {'entry_time': [datetime.time(7, 28, 54)],\n",
       "     'exit_time': [datetime.time(7, 29, 24)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#280',\n",
       "     'section_requirement': 'BAAL',\n",
       "     'sequence_number': 66},\n",
       "    {'entry_time': [datetime.time(7, 29, 24)],\n",
       "     'exit_time': [datetime.time(7, 29, 54)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#285',\n",
       "     'section_requirement': 'ZGN',\n",
       "     'sequence_number': 67},\n",
       "    {'entry_time': [datetime.time(7, 29, 54)],\n",
       "     'exit_time': [datetime.time(7, 30, 24)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#290',\n",
       "     'section_requirement': 'ZG40',\n",
       "     'sequence_number': 68},\n",
       "    {'entry_time': [datetime.time(7, 30, 24)],\n",
       "     'exit_time': [datetime.time(7, 30, 39)],\n",
       "     'route': 20423,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20423#295',\n",
       "     'section_requirement': 'ZG_Halt',\n",
       "     'sequence_number': 69}]},\n",
       "  {'service_intention_id': 20425,\n",
       "   'train_run_sections': [{'entry_time': [datetime.time(7, 18)],\n",
       "     'exit_time': [datetime.time(7, 21)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#1',\n",
       "     'section_requirement': 'ZUE_Halt',\n",
       "     'sequence_number': 1},\n",
       "    {'entry_time': [datetime.time(7, 21)],\n",
       "     'exit_time': [datetime.time(7, 21, 40)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#5',\n",
       "     'section_requirement': 'ZUE_X',\n",
       "     'sequence_number': 2},\n",
       "    {'entry_time': [datetime.time(7, 21, 40)],\n",
       "     'exit_time': [datetime.time(7, 22, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#10',\n",
       "     'section_requirement': 'ZUEC',\n",
       "     'sequence_number': 3},\n",
       "    {'entry_time': [datetime.time(7, 22, 12)],\n",
       "     'exit_time': [datetime.time(7, 22, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#15',\n",
       "     'section_requirement': 'ZUEZSW',\n",
       "     'sequence_number': 4},\n",
       "    {'entry_time': [datetime.time(7, 22, 42)],\n",
       "     'exit_time': [datetime.time(7, 23, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#20',\n",
       "     'section_requirement': 'ZLST',\n",
       "     'sequence_number': 5},\n",
       "    {'entry_time': [datetime.time(7, 23, 12)],\n",
       "     'exit_time': [datetime.time(7, 23, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#25',\n",
       "     'section_requirement': 'ZAU90',\n",
       "     'sequence_number': 6},\n",
       "    {'entry_time': [datetime.time(7, 23, 42)],\n",
       "     'exit_time': [datetime.time(7, 24, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#30',\n",
       "     'section_requirement': 'ZAU',\n",
       "     'sequence_number': 7},\n",
       "    {'entry_time': [datetime.time(7, 24, 12)],\n",
       "     'exit_time': [datetime.time(7, 24, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#35',\n",
       "     'section_requirement': 'ZAUZBT',\n",
       "     'sequence_number': 8},\n",
       "    {'entry_time': [datetime.time(7, 24, 42)],\n",
       "     'exit_time': [datetime.time(7, 25, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#37',\n",
       "     'section_requirement': 'ZWIE_Halt',\n",
       "     'sequence_number': 9},\n",
       "    {'entry_time': [datetime.time(7, 25, 16)],\n",
       "     'exit_time': [datetime.time(7, 26, 1)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#40',\n",
       "     'section_requirement': 'ZWIE',\n",
       "     'sequence_number': 10},\n",
       "    {'entry_time': [datetime.time(7, 26, 1)],\n",
       "     'exit_time': [datetime.time(7, 26, 31)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#45',\n",
       "     'section_requirement': 'ZWIE70',\n",
       "     'sequence_number': 11},\n",
       "    {'entry_time': [datetime.time(7, 26, 31)],\n",
       "     'exit_time': [datetime.time(7, 27, 1)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#50',\n",
       "     'section_requirement': 'ZEN10',\n",
       "     'sequence_number': 12},\n",
       "    {'entry_time': [datetime.time(7, 27, 1)],\n",
       "     'exit_time': [datetime.time(7, 28)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#52',\n",
       "     'section_requirement': 'ZEN_Halt',\n",
       "     'sequence_number': 13},\n",
       "    {'entry_time': [datetime.time(7, 28)],\n",
       "     'exit_time': [datetime.time(7, 28, 46)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#55',\n",
       "     'section_requirement': 'ZEN',\n",
       "     'sequence_number': 14},\n",
       "    {'entry_time': [datetime.time(7, 28, 46)],\n",
       "     'exit_time': [datetime.time(7, 29, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#60',\n",
       "     'section_requirement': 'ZEN60',\n",
       "     'sequence_number': 15},\n",
       "    {'entry_time': [datetime.time(7, 29, 16)],\n",
       "     'exit_time': [datetime.time(7, 29, 46)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#65',\n",
       "     'section_requirement': 'ZWOL10',\n",
       "     'sequence_number': 16},\n",
       "    {'entry_time': [datetime.time(7, 29, 46)],\n",
       "     'exit_time': [datetime.time(7, 30, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#70',\n",
       "     'section_requirement': 'ZWOL40',\n",
       "     'sequence_number': 17},\n",
       "    {'entry_time': [datetime.time(7, 30, 16)],\n",
       "     'exit_time': [datetime.time(7, 30, 50)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#72',\n",
       "     'section_requirement': 'ZWOL_Halt',\n",
       "     'sequence_number': 18},\n",
       "    {'entry_time': [datetime.time(7, 30, 50)],\n",
       "     'exit_time': [datetime.time(7, 31, 44)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#75',\n",
       "     'section_requirement': 'ZWOL',\n",
       "     'sequence_number': 19},\n",
       "    {'entry_time': [datetime.time(7, 31, 44)],\n",
       "     'exit_time': [datetime.time(7, 32, 14)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#80',\n",
       "     'section_requirement': 'ZWOL70',\n",
       "     'sequence_number': 20},\n",
       "    {'entry_time': [datetime.time(7, 32, 14)],\n",
       "     'exit_time': [datetime.time(7, 32, 44)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#85',\n",
       "     'section_requirement': 'ZWOL80',\n",
       "     'sequence_number': 21},\n",
       "    {'entry_time': [datetime.time(7, 32, 44)],\n",
       "     'exit_time': [datetime.time(7, 33, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#90',\n",
       "     'section_requirement': 'ZWOL-KIL05',\n",
       "     'sequence_number': 22},\n",
       "    {'entry_time': [datetime.time(7, 33, 16)],\n",
       "     'exit_time': [datetime.time(7, 33, 46)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#95',\n",
       "     'section_requirement': 'ZWOL-KIL06',\n",
       "     'sequence_number': 23},\n",
       "    {'entry_time': [datetime.time(7, 33, 46)],\n",
       "     'exit_time': [datetime.time(7, 34, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#100',\n",
       "     'section_requirement': 'KILW',\n",
       "     'sequence_number': 24},\n",
       "    {'entry_time': [datetime.time(7, 34, 16)],\n",
       "     'exit_time': [datetime.time(7, 34, 50)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#102',\n",
       "     'section_requirement': 'KIL_Halt',\n",
       "     'sequence_number': 25},\n",
       "    {'entry_time': [datetime.time(7, 34, 50)],\n",
       "     'exit_time': [datetime.time(7, 35, 36)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#105',\n",
       "     'section_requirement': 'KIL',\n",
       "     'sequence_number': 26},\n",
       "    {'entry_time': [datetime.time(7, 35, 36)],\n",
       "     'exit_time': [datetime.time(7, 36, 6)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#110',\n",
       "     'section_requirement': 'KILO',\n",
       "     'sequence_number': 27},\n",
       "    {'entry_time': [datetime.time(7, 36, 6)],\n",
       "     'exit_time': [datetime.time(7, 36, 36)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#115',\n",
       "     'section_requirement': 'KIL50',\n",
       "     'sequence_number': 28},\n",
       "    {'entry_time': [datetime.time(7, 36, 36)],\n",
       "     'exit_time': [datetime.time(7, 37, 6)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#120',\n",
       "     'section_requirement': 'KIL-RUES07',\n",
       "     'sequence_number': 29},\n",
       "    {'entry_time': [datetime.time(7, 37, 6)],\n",
       "     'exit_time': [datetime.time(7, 37, 40)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#122',\n",
       "     'section_requirement': 'RUES_Halt',\n",
       "     'sequence_number': 30},\n",
       "    {'entry_time': [datetime.time(7, 37, 40)],\n",
       "     'exit_time': [datetime.time(7, 38, 49)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#125',\n",
       "     'section_requirement': 'RUES',\n",
       "     'sequence_number': 31},\n",
       "    {'entry_time': [datetime.time(7, 38, 49)],\n",
       "     'exit_time': [datetime.time(7, 39, 19)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#130',\n",
       "     'section_requirement': 'RUES60',\n",
       "     'sequence_number': 32},\n",
       "    {'entry_time': [datetime.time(7, 39, 19)],\n",
       "     'exit_time': [datetime.time(7, 39, 49)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#135',\n",
       "     'section_requirement': 'RUESO',\n",
       "     'sequence_number': 33},\n",
       "    {'entry_time': [datetime.time(7, 39, 49)],\n",
       "     'exit_time': [datetime.time(7, 40, 19)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#140',\n",
       "     'section_requirement': 'TWNO',\n",
       "     'sequence_number': 34},\n",
       "    {'entry_time': [datetime.time(7, 40, 19)],\n",
       "     'exit_time': [datetime.time(7, 40, 53)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#142',\n",
       "     'section_requirement': 'TW_Halt',\n",
       "     'sequence_number': 35},\n",
       "    {'entry_time': [datetime.time(7, 40, 53)],\n",
       "     'exit_time': [datetime.time(7, 41, 44)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#145',\n",
       "     'section_requirement': 'TW',\n",
       "     'sequence_number': 36},\n",
       "    {'entry_time': [datetime.time(7, 41, 44)],\n",
       "     'exit_time': [datetime.time(7, 42, 14)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#150',\n",
       "     'section_requirement': 'TWO',\n",
       "     'sequence_number': 37},\n",
       "    {'entry_time': [datetime.time(7, 42, 14)],\n",
       "     'exit_time': [datetime.time(7, 42, 52)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#155',\n",
       "     'section_requirement': 'TW-ORDD11',\n",
       "     'sequence_number': 38},\n",
       "    {'entry_time': [datetime.time(7, 42, 52)],\n",
       "     'exit_time': [datetime.time(7, 43, 30)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#160',\n",
       "     'section_requirement': 'TW-ORDD12',\n",
       "     'sequence_number': 39},\n",
       "    {'entry_time': [datetime.time(7, 43, 30)],\n",
       "     'exit_time': [datetime.time(7, 44)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#162',\n",
       "     'section_requirement': 'ORDD_Halt',\n",
       "     'sequence_number': 40},\n",
       "    {'entry_time': [datetime.time(7, 44)],\n",
       "     'exit_time': [datetime.time(7, 45, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#165',\n",
       "     'section_requirement': 'ORDD',\n",
       "     'sequence_number': 41},\n",
       "    {'entry_time': [datetime.time(7, 45, 16)],\n",
       "     'exit_time': [datetime.time(7, 45, 46)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#170',\n",
       "     'section_requirement': 'ORDD-HGO15',\n",
       "     'sequence_number': 42},\n",
       "    {'entry_time': [datetime.time(7, 45, 46)],\n",
       "     'exit_time': [datetime.time(7, 46, 16)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#175',\n",
       "     'section_requirement': 'HGOW',\n",
       "     'sequence_number': 43},\n",
       "    {'entry_time': [datetime.time(7, 46, 16)],\n",
       "     'exit_time': [datetime.time(7, 46, 46)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#177',\n",
       "     'section_requirement': 'HGO_Halt',\n",
       "     'sequence_number': 44},\n",
       "    {'entry_time': [datetime.time(7, 46, 46)],\n",
       "     'exit_time': [datetime.time(7, 47, 37)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#180',\n",
       "     'section_requirement': 'HGO',\n",
       "     'sequence_number': 45},\n",
       "    {'entry_time': [datetime.time(7, 47, 37)],\n",
       "     'exit_time': [datetime.time(7, 48, 7)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#185',\n",
       "     'section_requirement': 'HGOO',\n",
       "     'sequence_number': 46},\n",
       "    {'entry_time': [datetime.time(7, 48, 7)],\n",
       "     'exit_time': [datetime.time(7, 48, 37)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#190',\n",
       "     'section_requirement': 'HGO-SBG16',\n",
       "     'sequence_number': 47},\n",
       "    {'entry_time': [datetime.time(7, 48, 37)],\n",
       "     'exit_time': [datetime.time(7, 49, 20)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#195',\n",
       "     'section_requirement': 'HGO-SBG17',\n",
       "     'sequence_number': 48},\n",
       "    {'entry_time': [datetime.time(7, 49, 20)],\n",
       "     'exit_time': [datetime.time(7, 49, 50)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#200',\n",
       "     'section_requirement': 'HGO-SBG18',\n",
       "     'sequence_number': 49},\n",
       "    {'entry_time': [datetime.time(7, 49, 50)],\n",
       "     'exit_time': [datetime.time(7, 50, 20)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#205',\n",
       "     'section_requirement': 'SBG10',\n",
       "     'sequence_number': 50},\n",
       "    {'entry_time': [datetime.time(7, 50, 20)],\n",
       "     'exit_time': [datetime.time(7, 50, 50)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#210',\n",
       "     'section_requirement': 'SBG30',\n",
       "     'sequence_number': 51},\n",
       "    {'entry_time': [datetime.time(7, 50, 50)],\n",
       "     'exit_time': [datetime.time(7, 51, 20)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#215',\n",
       "     'section_requirement': 'SBG',\n",
       "     'sequence_number': 52},\n",
       "    {'entry_time': [datetime.time(7, 51, 20)],\n",
       "     'exit_time': [datetime.time(7, 51, 54)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#220',\n",
       "     'section_requirement': 'SBG-LITT20',\n",
       "     'sequence_number': 53},\n",
       "    {'entry_time': [datetime.time(7, 51, 54)],\n",
       "     'exit_time': [datetime.time(7, 52, 31)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#225',\n",
       "     'section_requirement': 'SBG-LITT21',\n",
       "     'sequence_number': 54},\n",
       "    {'entry_time': [datetime.time(7, 52, 31)],\n",
       "     'exit_time': [datetime.time(7, 53, 7)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#230',\n",
       "     'section_requirement': 'SBG-LITT24',\n",
       "     'sequence_number': 55},\n",
       "    {'entry_time': [datetime.time(7, 53, 7)],\n",
       "     'exit_time': [datetime.time(7, 53, 37)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#235',\n",
       "     'section_requirement': 'LITTN',\n",
       "     'sequence_number': 56},\n",
       "    {'entry_time': [datetime.time(7, 53, 37)],\n",
       "     'exit_time': [datetime.time(7, 54, 8)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#240',\n",
       "     'section_requirement': 'LITT',\n",
       "     'sequence_number': 57},\n",
       "    {'entry_time': [datetime.time(7, 54, 8)],\n",
       "     'exit_time': [datetime.time(7, 54, 38)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#245',\n",
       "     'section_requirement': 'LITTS',\n",
       "     'sequence_number': 58},\n",
       "    {'entry_time': [datetime.time(7, 54, 38)],\n",
       "     'exit_time': [datetime.time(7, 55, 8)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#250',\n",
       "     'section_requirement': 'LITT90',\n",
       "     'sequence_number': 59},\n",
       "    {'entry_time': [datetime.time(7, 55, 8)],\n",
       "     'exit_time': [datetime.time(7, 55, 38)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#255',\n",
       "     'section_requirement': 'LITT-BAA25',\n",
       "     'sequence_number': 60},\n",
       "    {'entry_time': [datetime.time(7, 55, 38)],\n",
       "     'exit_time': [datetime.time(7, 56, 8)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#257',\n",
       "     'section_requirement': 'BAA_Halt',\n",
       "     'sequence_number': 61},\n",
       "    {'entry_time': [datetime.time(7, 56, 8)],\n",
       "     'exit_time': [datetime.time(7, 57, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#260',\n",
       "     'section_requirement': 'BAA',\n",
       "     'sequence_number': 62},\n",
       "    {'entry_time': [datetime.time(7, 57, 12)],\n",
       "     'exit_time': [datetime.time(7, 57, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#265',\n",
       "     'section_requirement': 'BAA70',\n",
       "     'sequence_number': 63},\n",
       "    {'entry_time': [datetime.time(7, 57, 42)],\n",
       "     'exit_time': [datetime.time(7, 58, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#270',\n",
       "     'section_requirement': 'BAA90',\n",
       "     'sequence_number': 64},\n",
       "    {'entry_time': [datetime.time(7, 58, 12)],\n",
       "     'exit_time': [datetime.time(7, 58, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#275',\n",
       "     'section_requirement': 'BAAN',\n",
       "     'sequence_number': 65},\n",
       "    {'entry_time': [datetime.time(7, 58, 42)],\n",
       "     'exit_time': [datetime.time(7, 59, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#280',\n",
       "     'section_requirement': 'BAAL',\n",
       "     'sequence_number': 66},\n",
       "    {'entry_time': [datetime.time(7, 59, 12)],\n",
       "     'exit_time': [datetime.time(7, 59, 42)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#285',\n",
       "     'section_requirement': 'ZGN',\n",
       "     'sequence_number': 67},\n",
       "    {'entry_time': [datetime.time(7, 59, 42)],\n",
       "     'exit_time': [datetime.time(8, 0, 12)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#290',\n",
       "     'section_requirement': 'ZG40',\n",
       "     'sequence_number': 68},\n",
       "    {'entry_time': [datetime.time(8, 0, 12)],\n",
       "     'exit_time': [datetime.time(8, 0, 27)],\n",
       "     'route': 20425,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '20425#295',\n",
       "     'section_requirement': 'ZG_Halt',\n",
       "     'sequence_number': 69}]},\n",
       "  {'service_intention_id': 18823,\n",
       "   'train_run_sections': [{'entry_time': [datetime.time(6, 35)],\n",
       "     'exit_time': [datetime.time(6, 37)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#1',\n",
       "     'section_requirement': 'ZLOE_Halt',\n",
       "     'sequence_number': 1},\n",
       "    {'entry_time': [datetime.time(6, 37)],\n",
       "     'exit_time': [datetime.time(6, 37, 32)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#5',\n",
       "     'section_requirement': 'ZLOE',\n",
       "     'sequence_number': 2},\n",
       "    {'entry_time': [datetime.time(6, 37, 32)],\n",
       "     'exit_time': [datetime.time(6, 38, 2)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#10',\n",
       "     'section_requirement': 'ZUET40',\n",
       "     'sequence_number': 3},\n",
       "    {'entry_time': [datetime.time(6, 38, 2)],\n",
       "     'exit_time': [datetime.time(6, 38, 32)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#15',\n",
       "     'section_requirement': 'ZUEZSW',\n",
       "     'sequence_number': 4},\n",
       "    {'entry_time': [datetime.time(6, 38, 32)],\n",
       "     'exit_time': [datetime.time(6, 39, 2)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#20',\n",
       "     'section_requirement': 'ZLST',\n",
       "     'sequence_number': 5},\n",
       "    {'entry_time': [datetime.time(6, 39, 2)],\n",
       "     'exit_time': [datetime.time(6, 39, 32)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#25',\n",
       "     'section_requirement': 'ZAU90',\n",
       "     'sequence_number': 6},\n",
       "    {'entry_time': [datetime.time(6, 39, 32)],\n",
       "     'exit_time': [datetime.time(6, 40, 2)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#30',\n",
       "     'section_requirement': 'ZAU',\n",
       "     'sequence_number': 7},\n",
       "    {'entry_time': [datetime.time(6, 40, 2)],\n",
       "     'exit_time': [datetime.time(6, 40, 32)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#35',\n",
       "     'section_requirement': 'ZAUZBT',\n",
       "     'sequence_number': 8},\n",
       "    {'entry_time': [datetime.time(6, 40, 32)],\n",
       "     'exit_time': [datetime.time(6, 41, 6)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#37',\n",
       "     'section_requirement': 'ZWIE_Halt',\n",
       "     'sequence_number': 9},\n",
       "    {'entry_time': [datetime.time(6, 41, 6)],\n",
       "     'exit_time': [datetime.time(6, 41, 50)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#40',\n",
       "     'section_requirement': 'ZWIE',\n",
       "     'sequence_number': 10},\n",
       "    {'entry_time': [datetime.time(6, 41, 50)],\n",
       "     'exit_time': [datetime.time(6, 42, 20)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#45',\n",
       "     'section_requirement': 'ZWIE70',\n",
       "     'sequence_number': 11},\n",
       "    {'entry_time': [datetime.time(6, 42, 20)],\n",
       "     'exit_time': [datetime.time(6, 42, 50)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#50',\n",
       "     'section_requirement': 'ZEN10',\n",
       "     'sequence_number': 12},\n",
       "    {'entry_time': [datetime.time(6, 42, 50)],\n",
       "     'exit_time': [datetime.time(6, 43, 24)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#52',\n",
       "     'section_requirement': 'ZEN_Halt',\n",
       "     'sequence_number': 13},\n",
       "    {'entry_time': [datetime.time(6, 43, 24)],\n",
       "     'exit_time': [datetime.time(6, 44, 11)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#55',\n",
       "     'section_requirement': 'ZEN',\n",
       "     'sequence_number': 14},\n",
       "    {'entry_time': [datetime.time(6, 44, 11)],\n",
       "     'exit_time': [datetime.time(6, 44, 41)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#60',\n",
       "     'section_requirement': 'ZEN60',\n",
       "     'sequence_number': 15},\n",
       "    {'entry_time': [datetime.time(6, 44, 41)],\n",
       "     'exit_time': [datetime.time(6, 45, 11)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#65',\n",
       "     'section_requirement': 'ZWOL10',\n",
       "     'sequence_number': 16},\n",
       "    {'entry_time': [datetime.time(6, 45, 11)],\n",
       "     'exit_time': [datetime.time(6, 45, 41)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#70',\n",
       "     'section_requirement': 'ZWOL40',\n",
       "     'sequence_number': 17},\n",
       "    {'entry_time': [datetime.time(6, 45, 41)],\n",
       "     'exit_time': [datetime.time(6, 46, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#72',\n",
       "     'section_requirement': 'ZWOL_Halt',\n",
       "     'sequence_number': 18},\n",
       "    {'entry_time': [datetime.time(6, 46, 15)],\n",
       "     'exit_time': [datetime.time(6, 47, 9)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#75',\n",
       "     'section_requirement': 'ZWOL',\n",
       "     'sequence_number': 19},\n",
       "    {'entry_time': [datetime.time(6, 47, 9)],\n",
       "     'exit_time': [datetime.time(6, 47, 39)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#80',\n",
       "     'section_requirement': 'ZWOL70',\n",
       "     'sequence_number': 20},\n",
       "    {'entry_time': [datetime.time(6, 47, 39)],\n",
       "     'exit_time': [datetime.time(6, 48, 9)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#85',\n",
       "     'section_requirement': 'ZWOL80',\n",
       "     'sequence_number': 21},\n",
       "    {'entry_time': [datetime.time(6, 48, 9)],\n",
       "     'exit_time': [datetime.time(6, 48, 42)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#90',\n",
       "     'section_requirement': 'ZWOL-KIL05',\n",
       "     'sequence_number': 22},\n",
       "    {'entry_time': [datetime.time(6, 48, 42)],\n",
       "     'exit_time': [datetime.time(6, 49, 12)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#95',\n",
       "     'section_requirement': 'ZWOL-KIL06',\n",
       "     'sequence_number': 23},\n",
       "    {'entry_time': [datetime.time(6, 49, 12)],\n",
       "     'exit_time': [datetime.time(6, 49, 42)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#100',\n",
       "     'section_requirement': 'KILW',\n",
       "     'sequence_number': 24},\n",
       "    {'entry_time': [datetime.time(6, 49, 42)],\n",
       "     'exit_time': [datetime.time(6, 50, 16)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#102',\n",
       "     'section_requirement': 'KIL_Halt',\n",
       "     'sequence_number': 25},\n",
       "    {'entry_time': [datetime.time(6, 50, 16)],\n",
       "     'exit_time': [datetime.time(6, 51, 1)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#105',\n",
       "     'section_requirement': 'KIL',\n",
       "     'sequence_number': 26},\n",
       "    {'entry_time': [datetime.time(6, 51, 1)],\n",
       "     'exit_time': [datetime.time(6, 51, 31)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#110',\n",
       "     'section_requirement': 'KILO',\n",
       "     'sequence_number': 27},\n",
       "    {'entry_time': [datetime.time(6, 51, 31)],\n",
       "     'exit_time': [datetime.time(6, 52, 1)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#115',\n",
       "     'section_requirement': 'KIL50',\n",
       "     'sequence_number': 28},\n",
       "    {'entry_time': [datetime.time(6, 52, 1)],\n",
       "     'exit_time': [datetime.time(6, 52, 31)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#120',\n",
       "     'section_requirement': 'KIL-RUES07',\n",
       "     'sequence_number': 29},\n",
       "    {'entry_time': [datetime.time(6, 52, 31)],\n",
       "     'exit_time': [datetime.time(6, 53, 5)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#122',\n",
       "     'section_requirement': 'RUES_Halt',\n",
       "     'sequence_number': 30},\n",
       "    {'entry_time': [datetime.time(6, 53, 5)],\n",
       "     'exit_time': [datetime.time(6, 54, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#125',\n",
       "     'section_requirement': 'RUES',\n",
       "     'sequence_number': 31},\n",
       "    {'entry_time': [datetime.time(6, 54, 15)],\n",
       "     'exit_time': [datetime.time(6, 54, 45)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#130',\n",
       "     'section_requirement': 'RUES60',\n",
       "     'sequence_number': 32},\n",
       "    {'entry_time': [datetime.time(6, 54, 45)],\n",
       "     'exit_time': [datetime.time(6, 55, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#135',\n",
       "     'section_requirement': 'RUESO',\n",
       "     'sequence_number': 33},\n",
       "    {'entry_time': [datetime.time(6, 55, 15)],\n",
       "     'exit_time': [datetime.time(6, 55, 45)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#140',\n",
       "     'section_requirement': 'TWNO',\n",
       "     'sequence_number': 34},\n",
       "    {'entry_time': [datetime.time(6, 55, 45)],\n",
       "     'exit_time': [datetime.time(6, 56, 19)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#142',\n",
       "     'section_requirement': 'TW_Halt',\n",
       "     'sequence_number': 35},\n",
       "    {'entry_time': [datetime.time(6, 56, 19)],\n",
       "     'exit_time': [datetime.time(6, 57, 11)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#145',\n",
       "     'section_requirement': 'TW',\n",
       "     'sequence_number': 36},\n",
       "    {'entry_time': [datetime.time(6, 57, 11)],\n",
       "     'exit_time': [datetime.time(6, 57, 41)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#150',\n",
       "     'section_requirement': 'TWO',\n",
       "     'sequence_number': 37},\n",
       "    {'entry_time': [datetime.time(6, 57, 41)],\n",
       "     'exit_time': [datetime.time(6, 58, 11)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#155',\n",
       "     'section_requirement': 'TW80',\n",
       "     'sequence_number': 38},\n",
       "    {'entry_time': [datetime.time(6, 58, 11)],\n",
       "     'exit_time': [datetime.time(6, 58, 41)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#160',\n",
       "     'section_requirement': 'TW90',\n",
       "     'sequence_number': 39},\n",
       "    {'entry_time': [datetime.time(6, 58, 41)],\n",
       "     'exit_time': [datetime.time(6, 59, 11)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#165',\n",
       "     'section_requirement': 'TW-ORD10',\n",
       "     'sequence_number': 40},\n",
       "    {'entry_time': [datetime.time(6, 59, 11)],\n",
       "     'exit_time': [datetime.time(6, 59, 41)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#170',\n",
       "     'section_requirement': 'TW-ORD11',\n",
       "     'sequence_number': 41},\n",
       "    {'entry_time': [datetime.time(6, 59, 41)],\n",
       "     'exit_time': [datetime.time(7, 0, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#172',\n",
       "     'section_requirement': 'ORD_Halt',\n",
       "     'sequence_number': 42},\n",
       "    {'entry_time': [datetime.time(7, 0, 15)],\n",
       "     'exit_time': [datetime.time(7, 1)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#175',\n",
       "     'section_requirement': 'ORD',\n",
       "     'sequence_number': 43},\n",
       "    {'entry_time': [datetime.time(7, 1)],\n",
       "     'exit_time': [datetime.time(7, 1, 52)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#180',\n",
       "     'section_requirement': 'ORD-HG13',\n",
       "     'sequence_number': 44},\n",
       "    {'entry_time': [datetime.time(7, 1, 52)],\n",
       "     'exit_time': [datetime.time(7, 2, 22)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#185',\n",
       "     'section_requirement': 'HGW',\n",
       "     'sequence_number': 45},\n",
       "    {'entry_time': [datetime.time(7, 2, 22)],\n",
       "     'exit_time': [datetime.time(7, 2, 56)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#187',\n",
       "     'section_requirement': 'HG_Halt',\n",
       "     'sequence_number': 46},\n",
       "    {'entry_time': [datetime.time(7, 2, 56)],\n",
       "     'exit_time': [datetime.time(7, 3, 56)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#190',\n",
       "     'section_requirement': 'HG',\n",
       "     'sequence_number': 47},\n",
       "    {'entry_time': [datetime.time(7, 3, 56)],\n",
       "     'exit_time': [datetime.time(7, 4, 26)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#195',\n",
       "     'section_requirement': 'HGO',\n",
       "     'sequence_number': 48},\n",
       "    {'entry_time': [datetime.time(7, 4, 26)],\n",
       "     'exit_time': [datetime.time(7, 5, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#200',\n",
       "     'section_requirement': 'HG-AU18',\n",
       "     'sequence_number': 49},\n",
       "    {'entry_time': [datetime.time(7, 5, 15)],\n",
       "     'exit_time': [datetime.time(7, 5, 53)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#205',\n",
       "     'section_requirement': 'HG-AU19',\n",
       "     'sequence_number': 50},\n",
       "    {'entry_time': [datetime.time(7, 5, 53)],\n",
       "     'exit_time': [datetime.time(7, 6, 23)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#210',\n",
       "     'section_requirement': 'AUW',\n",
       "     'sequence_number': 51},\n",
       "    {'entry_time': [datetime.time(7, 6, 23)],\n",
       "     'exit_time': [datetime.time(7, 6, 57)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#212',\n",
       "     'section_requirement': 'AU_Halt',\n",
       "     'sequence_number': 52},\n",
       "    {'entry_time': [datetime.time(7, 6, 57)],\n",
       "     'exit_time': [datetime.time(7, 8, 2)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#215',\n",
       "     'section_requirement': 'AU',\n",
       "     'sequence_number': 53},\n",
       "    {'entry_time': [datetime.time(7, 8, 2)],\n",
       "     'exit_time': [datetime.time(7, 8, 32)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#220',\n",
       "     'section_requirement': 'AUO',\n",
       "     'sequence_number': 54},\n",
       "    {'entry_time': [datetime.time(7, 8, 32)],\n",
       "     'exit_time': [datetime.time(7, 9, 14)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#225',\n",
       "     'section_requirement': 'AU-WAE21',\n",
       "     'sequence_number': 55},\n",
       "    {'entry_time': [datetime.time(7, 9, 14)],\n",
       "     'exit_time': [datetime.time(7, 9, 49)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#230',\n",
       "     'section_requirement': 'AU-WAE23',\n",
       "     'sequence_number': 56},\n",
       "    {'entry_time': [datetime.time(7, 9, 49)],\n",
       "     'exit_time': [datetime.time(7, 10, 19)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#235',\n",
       "     'section_requirement': 'WAEW',\n",
       "     'sequence_number': 57},\n",
       "    {'entry_time': [datetime.time(7, 10, 19)],\n",
       "     'exit_time': [datetime.time(7, 10, 53)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#237',\n",
       "     'section_requirement': 'WAE_Halt',\n",
       "     'sequence_number': 58},\n",
       "    {'entry_time': [datetime.time(7, 10, 53)],\n",
       "     'exit_time': [datetime.time(7, 11, 47)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#240',\n",
       "     'section_requirement': 'WAE',\n",
       "     'sequence_number': 59},\n",
       "    {'entry_time': [datetime.time(7, 11, 47)],\n",
       "     'exit_time': [datetime.time(7, 12, 17)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#245',\n",
       "     'section_requirement': 'WAEO',\n",
       "     'sequence_number': 60},\n",
       "    {'entry_time': [datetime.time(7, 12, 17)],\n",
       "     'exit_time': [datetime.time(7, 12, 47)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#250',\n",
       "     'section_requirement': 'WAE80',\n",
       "     'sequence_number': 61},\n",
       "    {'entry_time': [datetime.time(7, 12, 47)],\n",
       "     'exit_time': [datetime.time(7, 13, 24)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#255',\n",
       "     'section_requirement': 'WAE-RI25',\n",
       "     'sequence_number': 62},\n",
       "    {'entry_time': [datetime.time(7, 13, 24)],\n",
       "     'exit_time': [datetime.time(7, 14)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#260',\n",
       "     'section_requirement': 'WAE-RI26',\n",
       "     'sequence_number': 63},\n",
       "    {'entry_time': [datetime.time(7, 14)],\n",
       "     'exit_time': [datetime.time(7, 14, 34)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#262',\n",
       "     'section_requirement': 'RI_Halt',\n",
       "     'sequence_number': 64},\n",
       "    {'entry_time': [datetime.time(7, 14, 34)],\n",
       "     'exit_time': [datetime.time(7, 15, 40)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#265',\n",
       "     'section_requirement': 'RI',\n",
       "     'sequence_number': 65},\n",
       "    {'entry_time': [datetime.time(7, 15, 40)],\n",
       "     'exit_time': [datetime.time(7, 16, 13)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#270',\n",
       "     'section_requirement': 'RI-HAF28',\n",
       "     'sequence_number': 66},\n",
       "    {'entry_time': [datetime.time(7, 16, 13)],\n",
       "     'exit_time': [datetime.time(7, 16, 43)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#275',\n",
       "     'section_requirement': 'HAF',\n",
       "     'sequence_number': 67},\n",
       "    {'entry_time': [datetime.time(7, 16, 43)],\n",
       "     'exit_time': [datetime.time(7, 17, 17)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#277',\n",
       "     'section_requirement': 'BAE_Halt',\n",
       "     'sequence_number': 68},\n",
       "    {'entry_time': [datetime.time(7, 17, 17)],\n",
       "     'exit_time': [datetime.time(7, 18, 30)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#280',\n",
       "     'section_requirement': 'BAE',\n",
       "     'sequence_number': 69},\n",
       "    {'entry_time': [datetime.time(7, 18, 30)],\n",
       "     'exit_time': [datetime.time(7, 19)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#285',\n",
       "     'section_requirement': 'BAE-FRB30',\n",
       "     'sequence_number': 70},\n",
       "    {'entry_time': [datetime.time(7, 19)],\n",
       "     'exit_time': [datetime.time(7, 19, 34)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#287',\n",
       "     'section_requirement': 'FRB_Halt',\n",
       "     'sequence_number': 71},\n",
       "    {'entry_time': [datetime.time(7, 19, 34)],\n",
       "     'exit_time': [datetime.time(7, 20, 57)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#290',\n",
       "     'section_requirement': 'FRB',\n",
       "     'sequence_number': 72},\n",
       "    {'entry_time': [datetime.time(7, 20, 57)],\n",
       "     'exit_time': [datetime.time(7, 21, 36)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#295',\n",
       "     'section_requirement': 'FRB-PF33',\n",
       "     'sequence_number': 73},\n",
       "    {'entry_time': [datetime.time(7, 21, 36)],\n",
       "     'exit_time': [datetime.time(7, 22, 15)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#300',\n",
       "     'section_requirement': 'PFW',\n",
       "     'sequence_number': 74},\n",
       "    {'entry_time': [datetime.time(7, 22, 15)],\n",
       "     'exit_time': [datetime.time(7, 26, 20)],\n",
       "     'route': 18823,\n",
       "     'route_path': 'standard',\n",
       "     'route_section_id': '18823#305',\n",
       "     'section_requirement': 'PF_Halt',\n",
       "     'sequence_number': 75}]}]}"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "solution"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Convert file to json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "for train_run in solution['train_runs']:\n",
    "    for row in train_run['train_run_sections']:\n",
    "        row['entry_time'] = convert_TimeString(row['entry_time'][0])\n",
    "        row['exit_time'] = convert_TimeString(row['exit_time'][0])\n",
    "        sm = row['section_requirement']\n",
    "        if sm in [s.sect_marker for s in si if (s.si_id == row['route'])]:\n",
    "            pass\n",
    "        else:\n",
    "            row['section_requirement'] = None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(\"01_mysolution_new.json\",\"w\") as f:\n",
    "    json.dump(solution,f,indent = 4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "upload finished with status 200\n",
      "validation finished with status 200\n",
      "\n",
      "There are 10 warnings and 2 errors\n",
      "\n",
      "the solution has 2 errors. It will not be accepted as a feasible solution. See the error messages for details.\n",
      "\n",
      "Errors:\n",
      "- Entry time 07:30:24 after einMax 07:25 (+ max. Bandabweichung PT5M) for Train run sections with route_section_id \"20423#295\" and Section Marker \"ZG_Halt\" in service_intention \"20423\"\n",
      "- Entry time 08:00:12 after einMax 07:55 (+ max. Bandabweichung PT5M) for Train run sections with route_section_id \"20425#295\" and Section Marker \"ZG_Halt\" in service_intention \"20425\"\n",
      "\n",
      "Warnings:\n",
      "- Solution with VP-Label \"01_dummy\" and problem_instance_hash \"759370455\" has a wrong Hash! Hash: 759370455, expected: -969145936\n",
      "- Entry time 07:52:15 after einMax 07:48 for Train run sections with route_section_id \"18825#305\" and Section Marker \"PF_Halt\" in service_intention \"18825\"\n",
      "- Entry time 07:40:19 after einMax 07:38 for Train run sections with route_section_id \"18825#237\" and Section Marker \"WAE_Halt\" in service_intention \"18825\"\n",
      "- Exit time 07:56:20 after exit_latest 07:55 for Train run sections with route_section_id \"18825#305\" and Section Marker \"PF_Halt\" in service_intention \"18825\"\n",
      "- Entry time 07:10:19 after einMax 07:09 for Train run sections with route_section_id \"20423#142\" and Section Marker \"TW_Halt\" in service_intention \"20423\"\n",
      "- Exit time 07:30:39 after exit_latest 07:29 for Train run sections with route_section_id \"20423#295\" and Section Marker \"ZG_Halt\" in service_intention \"20423\"\n",
      "- Exit time 08:00:27 after exit_latest 07:59 for Train run sections with route_section_id \"20425#295\" and Section Marker \"ZG_Halt\" in service_intention \"20425\"\n",
      "- Entry time 07:22:15 after einMax 07:18 for Train run sections with route_section_id \"18823#305\" and Section Marker \"PF_Halt\" in service_intention \"18823\"\n",
      "- Entry time 07:10:19 after einMax 07:08 for Train run sections with route_section_id \"18823#237\" and Section Marker \"WAE_Halt\" in service_intention \"18823\"\n",
      "- Exit time 07:26:20 after exit_latest 07:25 for Train run sections with route_section_id \"18823#305\" and Section Marker \"PF_Halt\" in service_intention \"18823\"\n"
     ]
    }
   ],
   "source": [
    "%run validate_solution.py"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}