speeds3.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Visualizing Public Transportation Speeds with Python\n",
    "When people choose between driving and public transportation for urban trips, travel time (and public transportation frequency) is the most influential factor in their decision. Here we use Python to evaluate public transportation timetable speed between stops to look for slow spots. First we load some libraries:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas\n",
    "import tempfile\n",
    "import datetime\n",
    "import gtfstk\n",
    "import folium\n",
    "import haversine\n",
    "from functools import reduce\n",
    "from multiprocessing import Pool"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next we create some helper functions. We make a function url2gtfs to extend the gtfstk library so it can load a library directly without downloading it first. We create parseTime to deal with date fields that go past 24 hours in timetables. Next we make tripToSegments to split up each public transportation vehicle's \"trip\" into \"segments\" between stops. And last we create function to plot each segment."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def url2gtfs(url):\n",
    "    r = requests.get(url)\n",
    "    with tempfile.NamedTemporaryFile() as f:\n",
    "      f.write(r._content)\n",
    "      return gtfstk.read_gtfs(f.name, dist_units='mi')\n",
    "\n",
    "\n",
    "def parseTime(time): # to deal with times after midnight\n",
    "    if int(time.split(':')[0]) > 23:\n",
    "        return datetime.datetime.strptime('2:' + str(int(time.split(':')[0]) - 24) + ':'\n",
    "                                          + time.split(':')[1] + ':' + time.split(':')[2], '%d:%H:%M:%S')\n",
    "    else:\n",
    "        return datetime.datetime.strptime('1:' + time, '%d:%H:%M:%S')\n",
    "\n",
    "\n",
    "def tripToSegments(trip_id):\n",
    "    stop_times = gtfs.stop_times[gtfs.stop_times['trip_id'] == trip_id]\n",
    "    segments = []\n",
    "    for i in range(len(stop_times)-1):\n",
    "        origin = gtfs.stops[gtfs.stops['stop_id'] == stop_times['stop_id'].iloc[i]]\n",
    "        destination = gtfs.stops[gtfs.stops['stop_id'] == stop_times['stop_id'].iloc[i+1]]\n",
    "        distance = haversine.haversine((origin['stop_lat'], origin['stop_lon']),\n",
    "                         (destination['stop_lat'], destination['stop_lon']),\n",
    "                         miles=True)\n",
    "        startTime = parseTime(stop_times['departure_time'].iloc[i])\n",
    "        stopTime = parseTime(stop_times['arrival_time'].iloc[i+1])\n",
    "        duration = (stopTime - startTime).seconds\n",
    "        if duration == 0:\n",
    "            speed = 0 # when the laws of physics do not apply\n",
    "        else:\n",
    "            speed = distance / duration * 60 * 60\n",
    "        segments.append({'origin_id': origin['stop_id'].iloc[0],\n",
    "                         'destination_id': destination['stop_id'].iloc[0],\n",
    "                         'distance': distance,\n",
    "                         'duration': duration,\n",
    "                         'speed': speed})\n",
    "    return(segments)\n",
    "\n",
    "def plotSegment(segment):\n",
    "    origin = gtfs.stops[gtfs.stops['stop_id'] == segment.name[0]]\n",
    "    destination = gtfs.stops[gtfs.stops['stop_id'] == segment.name[1]]\n",
    "    folium.PolyLine(locations=[(origin.stop_lat.iloc[0], origin.stop_lon.iloc[0]),\n",
    "                               (destination.stop_lat.iloc[0], destination.stop_lon.iloc[0])],\n",
    "                    popup=str(segment.speed['min']),\n",
    "                    weight=segment.speed['min']\n",
    "                   ).add_to(foliumMap)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here we specify the General Transit Feed Specification (GTFS) feed for the public transportation agency we want to analyze. Then we can look at the routes in that feed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://gitlab.com/LACMTA/gtfs_rail/raw/master/gtfs_rail.zip' # Los Angeles County Metro\n",
    "# url = 'http://github.com/transitland/gtfs-archives-not-hosted-elsewhere/raw/master/amtrak.zip' # Amtrak\n",
    "gtfs = url2gtfs(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>route_id</th>\n",
       "      <th>route_short_name</th>\n",
       "      <th>route_long_name</th>\n",
       "      <th>route_desc</th>\n",
       "      <th>route_type</th>\n",
       "      <th>route_color</th>\n",
       "      <th>route_text_color</th>\n",
       "      <th>route_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Blue Line (801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>004DAC</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/blue-line/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Red Line (802)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>EE3A43</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/red-line/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>803</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Green Line (803)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2EAB00</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/green-line/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>804</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Gold Line (804)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>DA7C20</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/gold-line/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>806</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Expo Line (806)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0177A5</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/expo-line/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>805</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Metro Purple Line (805)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9561A9</td>\n",
       "      <td>FFFFFF</td>\n",
       "      <td>http://www.metro.net/around/rail/purple-line/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  route_id route_short_name          route_long_name  route_desc  route_type  \\\n",
       "0      801              NaN    Metro Blue Line (801)         NaN           0   \n",
       "1      802              NaN     Metro Red Line (802)         NaN           1   \n",
       "2      803              NaN   Metro Green Line (803)         NaN           0   \n",
       "3      804              NaN    Metro Gold Line (804)         NaN           0   \n",
       "4      806              NaN    Metro Expo Line (806)         NaN           0   \n",
       "5      805              NaN  Metro Purple Line (805)         NaN           1   \n",
       "\n",
       "  route_color route_text_color                                      route_url  \n",
       "0      004DAC           FFFFFF    http://www.metro.net/around/rail/blue-line/  \n",
       "1      EE3A43           FFFFFF     http://www.metro.net/around/rail/red-line/  \n",
       "2      2EAB00           FFFFFF   http://www.metro.net/around/rail/green-line/  \n",
       "3      DA7C20           FFFFFF    http://www.metro.net/around/rail/gold-line/  \n",
       "4      0177A5           FFFFFF    http://www.metro.net/around/rail/expo-line/  \n",
       "5      9561A9           FFFFFF  http://www.metro.net/around/rail/purple-line/  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gtfs.routes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next we pick the route we want to analyse and the direction (0.0 or 1.0). We filter the GTFS data for the route and direction, and split the trips into segments. Here we have the min, max, mean speed between each stop pair."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"8\" halign=\"left\">distance</th>\n",
       "      <th colspan=\"5\" halign=\"left\">duration</th>\n",
       "      <th colspan=\"8\" halign=\"left\">speed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>...</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin_id</th>\n",
       "      <th>destination_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>80121</th>\n",
       "      <th>80123</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>0.910273</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>230.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>14.249816</td>\n",
       "      <td>6.204441e-01</td>\n",
       "      <td>13.654098</td>\n",
       "      <td>13.654098</td>\n",
       "      <td>13.654098</td>\n",
       "      <td>14.895380</td>\n",
       "      <td>14.895380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80122</th>\n",
       "      <th>80121</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>1.110767e-16</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>0.685952</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>177.747307</td>\n",
       "      <td>...</td>\n",
       "      <td>180.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>14.122148</td>\n",
       "      <td>1.640630e+00</td>\n",
       "      <td>10.289281</td>\n",
       "      <td>13.719042</td>\n",
       "      <td>13.719042</td>\n",
       "      <td>15.433922</td>\n",
       "      <td>15.433922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80123</th>\n",
       "      <th>80124</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>1.110767e-16</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>0.547751</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>170.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>180.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>11.612220</td>\n",
       "      <td>6.844721e-01</td>\n",
       "      <td>10.955026</td>\n",
       "      <td>10.955026</td>\n",
       "      <td>10.955026</td>\n",
       "      <td>12.324404</td>\n",
       "      <td>12.324404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80124</th>\n",
       "      <th>80125</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>1.110767e-16</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>0.512530</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>16.851746</td>\n",
       "      <td>1.537103e+00</td>\n",
       "      <td>15.375900</td>\n",
       "      <td>15.375900</td>\n",
       "      <td>15.375900</td>\n",
       "      <td>18.451081</td>\n",
       "      <td>18.451081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80125</th>\n",
       "      <th>80126</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>5.553836e-17</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>0.332504</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>10.932578</td>\n",
       "      <td>9.971961e-01</td>\n",
       "      <td>9.975122</td>\n",
       "      <td>9.975122</td>\n",
       "      <td>9.975122</td>\n",
       "      <td>11.970147</td>\n",
       "      <td>11.970147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80126</th>\n",
       "      <th>80127</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>4.443068e-16</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>0.994773</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>170.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>180.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>21.089003</td>\n",
       "      <td>1.243073e+00</td>\n",
       "      <td>19.895470</td>\n",
       "      <td>19.895470</td>\n",
       "      <td>19.895470</td>\n",
       "      <td>22.382403</td>\n",
       "      <td>22.382403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80127</th>\n",
       "      <th>80128</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>1.526340</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>230.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>23.893999</td>\n",
       "      <td>1.040357e+00</td>\n",
       "      <td>22.895103</td>\n",
       "      <td>22.895103</td>\n",
       "      <td>22.895103</td>\n",
       "      <td>24.976476</td>\n",
       "      <td>24.976476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80128</th>\n",
       "      <th>80129</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>0.638851</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>21.005114</td>\n",
       "      <td>1.915945e+00</td>\n",
       "      <td>19.165524</td>\n",
       "      <td>19.165524</td>\n",
       "      <td>19.165524</td>\n",
       "      <td>22.998628</td>\n",
       "      <td>22.998628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80129</th>\n",
       "      <th>80130</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>0.522143</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>17.167829</td>\n",
       "      <td>1.565934e+00</td>\n",
       "      <td>15.664301</td>\n",
       "      <td>15.664301</td>\n",
       "      <td>15.664301</td>\n",
       "      <td>18.797161</td>\n",
       "      <td>18.797161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80130</th>\n",
       "      <th>80131</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>0.977151</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>32.128270</td>\n",
       "      <td>2.930524e+00</td>\n",
       "      <td>29.314534</td>\n",
       "      <td>29.314534</td>\n",
       "      <td>29.314534</td>\n",
       "      <td>35.177441</td>\n",
       "      <td>35.177441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80131</th>\n",
       "      <th>80132</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>0.971643</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>139.196866</td>\n",
       "      <td>...</td>\n",
       "      <td>160.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>25.651948</td>\n",
       "      <td>3.642507e+00</td>\n",
       "      <td>21.861969</td>\n",
       "      <td>21.861969</td>\n",
       "      <td>29.149292</td>\n",
       "      <td>29.149292</td>\n",
       "      <td>29.149292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80132</th>\n",
       "      <th>80133</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>3.332301e-16</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>0.879870</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>28.929703</td>\n",
       "      <td>2.638773e+00</td>\n",
       "      <td>26.396092</td>\n",
       "      <td>26.396092</td>\n",
       "      <td>26.396092</td>\n",
       "      <td>31.675310</td>\n",
       "      <td>31.675310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80133</th>\n",
       "      <th>80134</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>1.273532</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>230.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>19.936435</td>\n",
       "      <td>8.680424e-01</td>\n",
       "      <td>19.102987</td>\n",
       "      <td>19.102987</td>\n",
       "      <td>19.102987</td>\n",
       "      <td>20.839622</td>\n",
       "      <td>20.839622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80134</th>\n",
       "      <th>80135</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>0.561476</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>110.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>18.461071</td>\n",
       "      <td>1.683894e+00</td>\n",
       "      <td>16.844283</td>\n",
       "      <td>16.844283</td>\n",
       "      <td>16.844283</td>\n",
       "      <td>20.213140</td>\n",
       "      <td>20.213140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80135</th>\n",
       "      <th>80136</th>\n",
       "      <td>1021.0</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>2.221534e-16</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>1.098758</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>170.401567</td>\n",
       "      <td>...</td>\n",
       "      <td>180.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1021.0</td>\n",
       "      <td>23.293455</td>\n",
       "      <td>1.373012e+00</td>\n",
       "      <td>21.975161</td>\n",
       "      <td>21.975161</td>\n",
       "      <td>21.975161</td>\n",
       "      <td>24.722056</td>\n",
       "      <td>24.722056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80136</th>\n",
       "      <th>80137</th>\n",
       "      <td>999.0</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>1.110779e-16</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>0.963716</td>\n",
       "      <td>999.0</td>\n",
       "      <td>110.390390</td>\n",
       "      <td>...</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>999.0</td>\n",
       "      <td>31.689751</td>\n",
       "      <td>2.890390e+00</td>\n",
       "      <td>28.911472</td>\n",
       "      <td>28.911472</td>\n",
       "      <td>28.911472</td>\n",
       "      <td>34.693766</td>\n",
       "      <td>34.693766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80137</th>\n",
       "      <th>80138</th>\n",
       "      <td>999.0</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>1.110779e-16</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>0.725943</td>\n",
       "      <td>999.0</td>\n",
       "      <td>50.390390</td>\n",
       "      <td>...</td>\n",
       "      <td>60.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>999.0</td>\n",
       "      <td>54.020643</td>\n",
       "      <td>1.088630e+01</td>\n",
       "      <td>43.556596</td>\n",
       "      <td>43.556596</td>\n",
       "      <td>43.556596</td>\n",
       "      <td>65.334894</td>\n",
       "      <td>65.334894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80138</th>\n",
       "      <th>80139</th>\n",
       "      <td>999.0</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>0.892721</td>\n",
       "      <td>999.0</td>\n",
       "      <td>240.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>999.0</td>\n",
       "      <td>13.390820</td>\n",
       "      <td>3.554493e-15</td>\n",
       "      <td>13.390820</td>\n",
       "      <td>13.390820</td>\n",
       "      <td>13.390820</td>\n",
       "      <td>13.390820</td>\n",
       "      <td>13.390820</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         distance                                              \\\n",
       "                            count      mean           std       min       25%   \n",
       "origin_id destination_id                                                        \n",
       "80121     80123            1021.0  0.910273  2.221534e-16  0.910273  0.910273   \n",
       "80122     80121            1021.0  0.685952  1.110767e-16  0.685952  0.685952   \n",
       "80123     80124            1021.0  0.547751  1.110767e-16  0.547751  0.547751   \n",
       "80124     80125            1021.0  0.512530  1.110767e-16  0.512530  0.512530   \n",
       "80125     80126            1021.0  0.332504  5.553836e-17  0.332504  0.332504   \n",
       "80126     80127            1021.0  0.994773  4.443068e-16  0.994773  0.994773   \n",
       "80127     80128            1021.0  1.526340  2.221534e-16  1.526340  1.526340   \n",
       "80128     80129            1021.0  0.638851  0.000000e+00  0.638851  0.638851   \n",
       "80129     80130            1021.0  0.522143  0.000000e+00  0.522143  0.522143   \n",
       "80130     80131            1021.0  0.977151  2.221534e-16  0.977151  0.977151   \n",
       "80131     80132            1021.0  0.971643  2.221534e-16  0.971643  0.971643   \n",
       "80132     80133            1021.0  0.879870  3.332301e-16  0.879870  0.879870   \n",
       "80133     80134            1021.0  1.273532  2.221534e-16  1.273532  1.273532   \n",
       "80134     80135            1021.0  0.561476  2.221534e-16  0.561476  0.561476   \n",
       "80135     80136            1021.0  1.098758  2.221534e-16  1.098758  1.098758   \n",
       "80136     80137             999.0  0.963716  1.110779e-16  0.963716  0.963716   \n",
       "80137     80138             999.0  0.725943  1.110779e-16  0.725943  0.725943   \n",
       "80138     80139             999.0  0.892721  0.000000e+00  0.892721  0.892721   \n",
       "\n",
       "                                                       duration              \\\n",
       "                               50%       75%       max    count        mean   \n",
       "origin_id destination_id                                                      \n",
       "80121     80123           0.910273  0.910273  0.910273   1021.0  230.401567   \n",
       "80122     80121           0.685952  0.685952  0.685952   1021.0  177.747307   \n",
       "80123     80124           0.547751  0.547751  0.547751   1021.0  170.401567   \n",
       "80124     80125           0.512530  0.512530  0.512530   1021.0  110.401567   \n",
       "80125     80126           0.332504  0.332504  0.332504   1021.0  110.401567   \n",
       "80126     80127           0.994773  0.994773  0.994773   1021.0  170.401567   \n",
       "80127     80128           1.526340  1.526340  1.526340   1021.0  230.401567   \n",
       "80128     80129           0.638851  0.638851  0.638851   1021.0  110.401567   \n",
       "80129     80130           0.522143  0.522143  0.522143   1021.0  110.401567   \n",
       "80130     80131           0.977151  0.977151  0.977151   1021.0  110.401567   \n",
       "80131     80132           0.971643  0.971643  0.971643   1021.0  139.196866   \n",
       "80132     80133           0.879870  0.879870  0.879870   1021.0  110.401567   \n",
       "80133     80134           1.273532  1.273532  1.273532   1021.0  230.401567   \n",
       "80134     80135           0.561476  0.561476  0.561476   1021.0  110.401567   \n",
       "80135     80136           1.098758  1.098758  1.098758   1021.0  170.401567   \n",
       "80136     80137           0.963716  0.963716  0.963716    999.0  110.390390   \n",
       "80137     80138           0.725943  0.725943  0.725943    999.0   50.390390   \n",
       "80138     80139           0.892721  0.892721  0.892721    999.0  240.000000   \n",
       "\n",
       "                            ...                     speed             \\\n",
       "                            ...        75%    max   count       mean   \n",
       "origin_id destination_id    ...                                        \n",
       "80121     80123             ...      240.0  240.0  1021.0  14.249816   \n",
       "80122     80121             ...      180.0  240.0  1021.0  14.122148   \n",
       "80123     80124             ...      180.0  180.0  1021.0  11.612220   \n",
       "80124     80125             ...      120.0  120.0  1021.0  16.851746   \n",
       "80125     80126             ...      120.0  120.0  1021.0  10.932578   \n",
       "80126     80127             ...      180.0  180.0  1021.0  21.089003   \n",
       "80127     80128             ...      240.0  240.0  1021.0  23.893999   \n",
       "80128     80129             ...      120.0  120.0  1021.0  21.005114   \n",
       "80129     80130             ...      120.0  120.0  1021.0  17.167829   \n",
       "80130     80131             ...      120.0  120.0  1021.0  32.128270   \n",
       "80131     80132             ...      160.0  160.0  1021.0  25.651948   \n",
       "80132     80133             ...      120.0  120.0  1021.0  28.929703   \n",
       "80133     80134             ...      240.0  240.0  1021.0  19.936435   \n",
       "80134     80135             ...      120.0  120.0  1021.0  18.461071   \n",
       "80135     80136             ...      180.0  180.0  1021.0  23.293455   \n",
       "80136     80137             ...      120.0  120.0   999.0  31.689751   \n",
       "80137     80138             ...       60.0   60.0   999.0  54.020643   \n",
       "80138     80139             ...      240.0  240.0   999.0  13.390820   \n",
       "\n",
       "                                                                         \\\n",
       "                                   std        min        25%        50%   \n",
       "origin_id destination_id                                                  \n",
       "80121     80123           6.204441e-01  13.654098  13.654098  13.654098   \n",
       "80122     80121           1.640630e+00  10.289281  13.719042  13.719042   \n",
       "80123     80124           6.844721e-01  10.955026  10.955026  10.955026   \n",
       "80124     80125           1.537103e+00  15.375900  15.375900  15.375900   \n",
       "80125     80126           9.971961e-01   9.975122   9.975122   9.975122   \n",
       "80126     80127           1.243073e+00  19.895470  19.895470  19.895470   \n",
       "80127     80128           1.040357e+00  22.895103  22.895103  22.895103   \n",
       "80128     80129           1.915945e+00  19.165524  19.165524  19.165524   \n",
       "80129     80130           1.565934e+00  15.664301  15.664301  15.664301   \n",
       "80130     80131           2.930524e+00  29.314534  29.314534  29.314534   \n",
       "80131     80132           3.642507e+00  21.861969  21.861969  29.149292   \n",
       "80132     80133           2.638773e+00  26.396092  26.396092  26.396092   \n",
       "80133     80134           8.680424e-01  19.102987  19.102987  19.102987   \n",
       "80134     80135           1.683894e+00  16.844283  16.844283  16.844283   \n",
       "80135     80136           1.373012e+00  21.975161  21.975161  21.975161   \n",
       "80136     80137           2.890390e+00  28.911472  28.911472  28.911472   \n",
       "80137     80138           1.088630e+01  43.556596  43.556596  43.556596   \n",
       "80138     80139           3.554493e-15  13.390820  13.390820  13.390820   \n",
       "\n",
       "                                                \n",
       "                                75%        max  \n",
       "origin_id destination_id                        \n",
       "80121     80123           14.895380  14.895380  \n",
       "80122     80121           15.433922  15.433922  \n",
       "80123     80124           12.324404  12.324404  \n",
       "80124     80125           18.451081  18.451081  \n",
       "80125     80126           11.970147  11.970147  \n",
       "80126     80127           22.382403  22.382403  \n",
       "80127     80128           24.976476  24.976476  \n",
       "80128     80129           22.998628  22.998628  \n",
       "80129     80130           18.797161  18.797161  \n",
       "80130     80131           35.177441  35.177441  \n",
       "80131     80132           29.149292  29.149292  \n",
       "80132     80133           31.675310  31.675310  \n",
       "80133     80134           20.839622  20.839622  \n",
       "80134     80135           20.213140  20.213140  \n",
       "80135     80136           24.722056  24.722056  \n",
       "80136     80137           34.693766  34.693766  \n",
       "80137     80138           65.334894  65.334894  \n",
       "80138     80139           13.390820  13.390820  \n",
       "\n",
       "[18 rows x 24 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "route_id = '806'\n",
    "direction_id = 1.0\n",
    "\n",
    "trip_ids = gtfs.trips[(gtfs.trips['route_id'] == route_id) & (gtfs.trips['direction_id'] == direction_id)]['trip_id']\n",
    "p = Pool(8)\n",
    "segments = reduce(lambda x, y: x + y, p.map(tripToSegments, trip_ids))\n",
    "segmentsDF = pandas.DataFrame(segments).groupby(['origin_id', 'destination_id']).describe()\n",
    "segmentsDF"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And finally we plot the route where the width of the line is the speed between each stop pair. The Expo Line really is much slower into downtown than along the rest of the line."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><iframe src=\"data:text/html;base64,CiAgICAgICAgPCFET0NUWVBFIGh0bWw+CiAgICAgICAgPGhlYWQ+CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICA8bWV0YSBodHRwLWVxdWl2PSJjb250ZW50LXR5cGUiIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD1VVEYtOCIgLz4KICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9sZWFmbGV0LzAuNy4zL2xlYWZsZXQuanMiPjwvc2NyaXB0PgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vYWpheC5nb29nbGVhcGlzLmNvbS9hamF4L2xpYnMvanF1ZXJ5LzEuMTEuMS9qcXVlcnkubWluLmpzIj48L3NjcmlwdD4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9qcy9ib290c3RyYXAubWluLmpzIj48L3NjcmlwdD4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9MZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy8yLjAuMi9sZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy5taW4uanMiPjwvc2NyaXB0PgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgPHNjcmlwdCBzcmM9Imh0dHBzOi8vY2RuanMuY2xvdWRmbGFyZS5jb20vYWpheC9saWJzL2xlYWZsZXQubWFya2VyY2x1c3Rlci8wLjQuMC9sZWFmbGV0Lm1hcmtlcmNsdXN0ZXItc3JjLmpzIj48L3NjcmlwdD4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9sZWFmbGV0Lm1hcmtlcmNsdXN0ZXIvMC40LjAvbGVhZmxldC5tYXJrZXJjbHVzdGVyLmpzIj48L3NjcmlwdD4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvbGVhZmxldC8wLjcuMy9sZWFmbGV0LmNzcyIgLz4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvY3NzL2Jvb3RzdHJhcC5taW4uY3NzIiAvPgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLXRoZW1lLm1pbi5jc3MiIC8+CiAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vZm9udC1hd2Vzb21lLzQuMS4wL2Nzcy9mb250LWF3ZXNvbWUubWluLmNzcyIgLz4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvTGVhZmxldC5hd2Vzb21lLW1hcmtlcnMvMi4wLjIvbGVhZmxldC5hd2Vzb21lLW1hcmtlcnMuY3NzIiAvPgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9sZWFmbGV0Lm1hcmtlcmNsdXN0ZXIvMC40LjAvTWFya2VyQ2x1c3Rlci5EZWZhdWx0LmNzcyIgLz4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvbGVhZmxldC5tYXJrZXJjbHVzdGVyLzAuNC4wL01hcmtlckNsdXN0ZXIuY3NzIiAvPgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL3Jhdy5naXRodWJ1c2VyY29udGVudC5jb20vcHl0aG9uLXZpc3VhbGl6YXRpb24vZm9saXVtL21hc3Rlci9mb2xpdW0vdGVtcGxhdGVzL2xlYWZsZXQuYXdlc29tZS5yb3RhdGUuY3NzIiAvPgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgPHN0eWxlPgoKICAgICAgICAgICAgaHRtbCwgYm9keSB7CiAgICAgICAgICAgICAgICB3aWR0aDogMTAwJTsKICAgICAgICAgICAgICAgIGhlaWdodDogMTAwJTsKICAgICAgICAgICAgICAgIG1hcmdpbjogMDsKICAgICAgICAgICAgICAgIHBhZGRpbmc6IDA7CiAgICAgICAgICAgICAgICB9CgogICAgICAgICAgICAjbWFwIHsKICAgICAgICAgICAgICAgIHBvc2l0aW9uOmFic29sdXRlOwogICAgICAgICAgICAgICAgdG9wOjA7CiAgICAgICAgICAgICAgICBib3R0b206MDsKICAgICAgICAgICAgICAgIHJpZ2h0OjA7CiAgICAgICAgICAgICAgICBsZWZ0OjA7CiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgIDwvc3R5bGU+CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgPHN0eWxlPiAjbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4IHsKICAgICAgICAgICAgICAgIHBvc2l0aW9uIDogcmVsYXRpdmU7CiAgICAgICAgICAgICAgICB3aWR0aCA6IDEwMC4wJTsKICAgICAgICAgICAgICAgIGhlaWdodDogMTAwLjAlOwogICAgICAgICAgICAgICAgbGVmdDogMC4wJTsKICAgICAgICAgICAgICAgIHRvcDogMC4wJTsKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgPC9zdHlsZT4KICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICA8L2hlYWQ+CiAgICAgICAgPGJvZHk+CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgPGRpdiBjbGFzcz0iZm9saXVtLW1hcCIgaWQ9Im1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOCIgPjwvZGl2PgogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgIDwvYm9keT4KICAgICAgICA8c2NyaXB0PgogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCgogICAgICAgICAgICB2YXIgc291dGhXZXN0ID0gTC5sYXRMbmcoLTkwLCAtMTgwKTsKICAgICAgICAgICAgdmFyIG5vcnRoRWFzdCA9IEwubGF0TG5nKDkwLCAxODApOwogICAgICAgICAgICB2YXIgYm91bmRzID0gTC5sYXRMbmdCb3VuZHMoc291dGhXZXN0LCBub3J0aEVhc3QpOwoKICAgICAgICAgICAgdmFyIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOCA9IEwubWFwKCdtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTgnLCB7CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjZW50ZXI6WzM0LC0xMThdLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgem9vbTogOSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG1heEJvdW5kczogYm91bmRzLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbGF5ZXJzOiBbXSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNyczogTC5DUlMuRVBTRzM4NTcKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICB2YXIgdGlsZV9sYXllcl8yOTA3YmFiOTJhOTM0MmNkYjlhMWZiMzgzZmMwMzNlMCA9IEwudGlsZUxheWVyKAogICAgICAgICAgICAgICAgJ2h0dHBzOi8ve3N9LnRpbGUub3BlbnN0cmVldG1hcC5vcmcve3p9L3t4fS97eX0ucG5nJywKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBtYXhab29tOiAxOCwKICAgICAgICAgICAgICAgICAgICBtaW5ab29tOiAxLAogICAgICAgICAgICAgICAgICAgIGF0dHJpYnV0aW9uOiAnRGF0YSBieSA8YSBocmVmPSJodHRwOi8vb3BlbnN0cmVldG1hcC5vcmciPk9wZW5TdHJlZXRNYXA8L2E+LCB1bmRlciA8YSBocmVmPSJodHRwOi8vd3d3Lm9wZW5zdHJlZXRtYXAub3JnL2NvcHlyaWdodCI+T0RiTDwvYT4uJywKICAgICAgICAgICAgICAgICAgICBkZXRlY3RSZXRpbmE6IGZhbHNlCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKS5hZGRUbyhtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTgpOwoKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgcG9seV9saW5lXzE4Zjg2YmUxZjQ5MTRhMzBhZDRlZjM0ZjhmMmQ5NDhkID0gTC5wb2x5bGluZSgKICAgICAgICAgICAgICAgICAgICBbWzM0LjA0MDczNDk5OTk5OTk5OCwgLTExOC4yNjYxMTc5OTk5OTk5OV0sIFszNC4wMjkxMTE5OTk5OTk5OTgsIC0xMTguMjczNjAzMDAwMDAwMDFdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDEzLjY1NDA5ODA3MzEsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfMThmODZiZTFmNDkxNGEzMGFkNGVmMzRmOGYyZDk0OGQpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9kMzNmZmUyYmFmZDQ0Zjg4OWQ1ODE4NmZjNjRkOTEyOSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9kYjk3ZWNkNjYzYWQ0YjY2YjYwZGJiNzliZjY2ZjY5MSA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfZGI5N2VjZDY2M2FkNGI2NmI2MGRiYjc5YmY2NmY2OTEiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDEzLjY1NDA5ODA3MzE8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZDMzZmZlMmJhZmQ0NGY4ODlkNTgxODZmYzY0ZDkxMjkuc2V0Q29udGVudChodG1sX2RiOTdlY2Q2NjNhZDRiNjZiNjBkYmI3OWJmNjZmNjkxKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfMThmODZiZTFmNDkxNGEzMGFkNGVmMzRmOGYyZDk0OGQuYmluZFBvcHVwKHBvcHVwX2QzM2ZmZTJiYWZkNDRmODg5ZDU4MTg2ZmM2NGQ5MTI5KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfZGJhYTRhN2E5ZDE5NDJiNThlMWFhNDBmYjY2ODEzYjkgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDQ4NjA5OTk5OTk5OTk2LCAtMTE4LjI1ODgyMl0sIFszNC4wNDA3MzQ5OTk5OTk5OTgsIC0xMTguMjY2MTE3OTk5OTk5OTldXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDEwLjI4OTI4MTMzNzEsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfZGJhYTRhN2E5ZDE5NDJiNThlMWFhNDBmYjY2ODEzYjkpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9jMGMwOTBmNTQ1NTQ0MjQ4OTZkYTQ2NjU4MmFmOTlhOSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF84YmY5MzAwZDJjNjE0NDQxOWViOTg0Y2ZjYmNkNjcxMSA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfOGJmOTMwMGQyYzYxNDQ0MTllYjk4NGNmY2JjZDY3MTEiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDEwLjI4OTI4MTMzNzE8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYzBjMDkwZjU0NTU0NDI0ODk2ZGE0NjY1ODJhZjk5YTkuc2V0Q29udGVudChodG1sXzhiZjkzMDBkMmM2MTQ0NDE5ZWI5ODRjZmNiY2Q2NzExKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfZGJhYTRhN2E5ZDE5NDJiNThlMWFhNDBmYjY2ODEzYjkuYmluZFBvcHVwKHBvcHVwX2MwYzA5MGY1NDU1NDQyNDg5NmRhNDY2NTgyYWY5OWE5KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfMmE0MDNjYzNhMmUzNDFkZTg3ODVhOTFmY2M3Y2M4N2IgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDI5MTExOTk5OTk5OTk4LCAtMTE4LjI3MzYwMzAwMDAwMDAxXSwgWzM0LjAyMjEyMzAwMDAwMDAwMSwgLTExOC4yNzgxMTc5OTk5OTk5OV1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMTAuOTU1MDI1OTUyNiwKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV8yYTQwM2NjM2EyZTM0MWRlODc4NWE5MWZjYzdjYzg3Yik7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzY1ZjRmOTJiNjdmMDRiYWRhYTFjNGY1MGU0YWIxMjY4ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzI4MGYwMjgxZTllMzRmM2JhY2ViOWE3ZjQ1MzQxYTlkID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF8yODBmMDI4MWU5ZTM0ZjNiYWNlYjlhN2Y0NTM0MWE5ZCIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMTAuOTU1MDI1OTUyNjwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF82NWY0ZjkyYjY3ZjA0YmFkYWExYzRmNTBlNGFiMTI2OC5zZXRDb250ZW50KGh0bWxfMjgwZjAyODFlOWUzNGYzYmFjZWI5YTdmNDUzNDFhOWQpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV8yYTQwM2NjM2EyZTM0MWRlODc4NWE5MWZjYzdjYzg3Yi5iaW5kUG9wdXAocG9wdXBfNjVmNGY5MmI2N2YwNGJhZGFhMWM0ZjUwZTRhYjEyNjgpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV83NTQ2NTY4YmY0YWU0NjE5OTIxZjZkYjhmM2NkMzlmYiA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMjIxMjMwMDAwMDAwMDEsIC0xMTguMjc4MTE3OTk5OTk5OTldLCBbMzQuMDE4MjI3MDAwMDAwMDAzLCAtMTE4LjI4NTczNDAwMDAwMDAxXV0sCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgd2VpZ2h0OiAxNS4zNzU5MDA0ODEzLAogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTguYWRkTGF5ZXIocG9seV9saW5lXzc1NDY1NjhiZjRhZTQ2MTk5MjFmNmRiOGYzY2QzOWZiKTsKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfY2FmYzZjODRiODBiNDE4Y2I0NWM2ODhmYTZlOGI4OTkgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCd9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfYWQ4NDE5YjA5MzQ0NGQ5NmIzZWFiZDcyNGUzZmEyMDkgPSAkKCcgICAgICAgICA8ZGl2IGlkPSJodG1sX2FkODQxOWIwOTM0NDRkOTZiM2VhYmQ3MjRlM2ZhMjA5IiAgICAgICAgICAgICAgICAgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+ICAgICAgICAgICAgICAgICAxNS4zNzU5MDA0ODEzPC9kaXY+ICAgICAgICAgICAgICAgICAnKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwX2NhZmM2Yzg0YjgwYjQxOGNiNDVjNjg4ZmE2ZThiODk5LnNldENvbnRlbnQoaHRtbF9hZDg0MTliMDkzNDQ0ZDk2YjNlYWJkNzI0ZTNmYTIwOSk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgcG9seV9saW5lXzc1NDY1NjhiZjRhZTQ2MTk5MjFmNmRiOGYzY2QzOWZiLmJpbmRQb3B1cChwb3B1cF9jYWZjNmM4NGI4MGI0MThjYjQ1YzY4OGZhNmU4Yjg5OSk7CgogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgcG9seV9saW5lXzYxODAwMTcxNDgzZDQ3NmZiYjMzYTdiMTJmYWUzM2UzID0gTC5wb2x5bGluZSgKICAgICAgICAgICAgICAgICAgICBbWzM0LjAxODIyNzAwMDAwMDAwMywgLTExOC4yODU3MzQwMDAwMDAwMV0sIFszNC4wMTgyNDUsIC0xMTguMjkxNTRdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDkuOTc1MTIyMTc4OTIsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfNjE4MDAxNzE0ODNkNDc2ZmJiMzNhN2IxMmZhZTMzZTMpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9iMjFlNWQ5MzkwZmI0MmYzYjUyMmQ0YWRmZGYwNzg1YyA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9lZjgxYzA0N2FiODg0OTQ3YWNiNzM5MjI2YmE0NTQxMSA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfZWY4MWMwNDdhYjg4NDk0N2FjYjczOTIyNmJhNDU0MTEiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDkuOTc1MTIyMTc4OTI8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYjIxZTVkOTM5MGZiNDJmM2I1MjJkNGFkZmRmMDc4NWMuc2V0Q29udGVudChodG1sX2VmODFjMDQ3YWI4ODQ5NDdhY2I3MzkyMjZiYTQ1NDExKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfNjE4MDAxNzE0ODNkNDc2ZmJiMzNhN2IxMmZhZTMzZTMuYmluZFBvcHVwKHBvcHVwX2IyMWU1ZDkzOTBmYjQyZjNiNTIyZDRhZGZkZjA3ODVjKTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfZTBlMGFmM2ZhNTQ0NDMzMTg3ZGM4YmI0MGZiNDkwYzkgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDE4MjQ1LCAtMTE4LjI5MTU0XSwgWzM0LjAxODMzMDk5OTk5OTk5NiwgLTExOC4zMDg5MTAwMDAwMDAwMV1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMTkuODk1NDY5NjMxNiwKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV9lMGUwYWYzZmE1NDQ0MzMxODdkYzhiYjQwZmI0OTBjOSk7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2NkZWUxZTc2M2Q1ZDRkNTdhNTM5MmU0MTQ1MTQ1OGRkID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzE2ZDY5YTNlZjIzZTQ1NTA5ZmMzNTgyYmMwOWY4ZGZmID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF8xNmQ2OWEzZWYyM2U0NTUwOWZjMzU4MmJjMDlmOGRmZiIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMTkuODk1NDY5NjMxNjwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9jZGVlMWU3NjNkNWQ0ZDU3YTUzOTJlNDE0NTE0NThkZC5zZXRDb250ZW50KGh0bWxfMTZkNjlhM2VmMjNlNDU1MDlmYzM1ODJiYzA5ZjhkZmYpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV9lMGUwYWYzZmE1NDQ0MzMxODdkYzhiYjQwZmI0OTBjOS5iaW5kUG9wdXAocG9wdXBfY2RlZTFlNzYzZDVkNGQ1N2E1MzkyZTQxNDUxNDU4ZGQpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV8wMGU2ZGYyMTc1Y2M0ZDZjYmQ5NWJiMmM3MmM4ZDNlMSA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMTgzMzA5OTk5OTk5OTYsIC0xMTguMzA4OTEwMDAwMDAwMDFdLCBbMzQuMDIyNTI1OTk5OTk5OTk5LCAtMTE4LjMzNTA3OF1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMjIuODk1MTAzMzQ5MSwKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV8wMGU2ZGYyMTc1Y2M0ZDZjYmQ5NWJiMmM3MmM4ZDNlMSk7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzYyM2JiNTAyODgzNjRkMzk4YzAzMjJiOGU0ZTc3NGU0ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzM0ZmFkYWM0NGEwODQyNDY4Njk2YTY3OGI1YjNiNzMzID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF8zNGZhZGFjNDRhMDg0MjQ2ODY5NmE2NzhiNWIzYjczMyIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMjIuODk1MTAzMzQ5MTwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF82MjNiYjUwMjg4MzY0ZDM5OGMwMzIyYjhlNGU3NzRlNC5zZXRDb250ZW50KGh0bWxfMzRmYWRhYzQ0YTA4NDI0Njg2OTZhNjc4YjViM2I3MzMpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV8wMGU2ZGYyMTc1Y2M0ZDZjYmQ5NWJiMmM3MmM4ZDNlMS5iaW5kUG9wdXAocG9wdXBfNjIzYmI1MDI4ODM2NGQzOThjMDMyMmI4ZTRlNzc0ZTQpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV81NzQ5ZGE3ZGVmNzQ0OGIyOGJkMzk2MzMyN2U4YjIzZSA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMjI1MjU5OTk5OTk5OTksIC0xMTguMzM1MDc4XSwgWzM0LjAyMzk4MDk5OTk5OTk5OSwgLTExOC4zNDYwOTQ5OTk5OTk5OV1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMTkuMTY1NTIzNzQ1MSwKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV81NzQ5ZGE3ZGVmNzQ0OGIyOGJkMzk2MzMyN2U4YjIzZSk7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzI5NDIxYTM4ODA5NzRjOWI4ZGIxMWRlY2ViNTE4NmJlID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzE4ODQ1YjEzY2YxYzRiZGQ5MmFmY2IxYWQ1YjYwYmUyID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF8xODg0NWIxM2NmMWM0YmRkOTJhZmNiMWFkNWI2MGJlMiIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMTkuMTY1NTIzNzQ1MTwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8yOTQyMWEzODgwOTc0YzliOGRiMTFkZWNlYjUxODZiZS5zZXRDb250ZW50KGh0bWxfMTg4NDViMTNjZjFjNGJkZDkyYWZjYjFhZDViNjBiZTIpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV81NzQ5ZGE3ZGVmNzQ0OGIyOGJkMzk2MzMyN2U4YjIzZS5iaW5kUG9wdXAocG9wdXBfMjk0MjFhMzg4MDk3NGM5YjhkYjExZGVjZWI1MTg2YmUpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV9jMjFlNjY3ODJjY2I0YzE2ODFhMzhhN2QzNWExNDUxNSA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMjM5ODA5OTk5OTk5OTksIC0xMTguMzQ2MDk0OTk5OTk5OTldLCBbMzQuMDI0ODAzMDAwMDAwMDA2LCAtMTE4LjM1NTE1OTAwMDAwMDAxXV0sCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgd2VpZ2h0OiAxNS42NjQzMDEyNDE0LAogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTguYWRkTGF5ZXIocG9seV9saW5lX2MyMWU2Njc4MmNjYjRjMTY4MWEzOGE3ZDM1YTE0NTE1KTsKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMmFlYzA1MmNlMDljNDQ0NjlhZTFmNzZkNTUwNmNmNDAgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCd9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfODVlNzEwYTQyNjhjNGIxZmI1ZmU3NTRmM2VmMDZlOTQgPSAkKCcgICAgICAgICA8ZGl2IGlkPSJodG1sXzg1ZTcxMGE0MjY4YzRiMWZiNWZlNzU0ZjNlZjA2ZTk0IiAgICAgICAgICAgICAgICAgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+ICAgICAgICAgICAgICAgICAxNS42NjQzMDEyNDE0PC9kaXY+ICAgICAgICAgICAgICAgICAnKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzJhZWMwNTJjZTA5YzQ0NDY5YWUxZjc2ZDU1MDZjZjQwLnNldENvbnRlbnQoaHRtbF84NWU3MTBhNDI2OGM0YjFmYjVmZTc1NGYzZWYwNmU5NCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgcG9seV9saW5lX2MyMWU2Njc4MmNjYjRjMTY4MWEzOGE3ZDM1YTE0NTE1LmJpbmRQb3B1cChwb3B1cF8yYWVjMDUyY2UwOWM0NDQ2OWFlMWY3NmQ1NTA2Y2Y0MCk7CgogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgcG9seV9saW5lXzAzYjI4Y2Y4ZjVhMDQ5MDliYmQ3MmExNDlkNDEzYjJkID0gTC5wb2x5bGluZSgKICAgICAgICAgICAgICAgICAgICBbWzM0LjAyNDgwMzAwMDAwMDAwNiwgLTExOC4zNTUxNTkwMDAwMDAwMV0sIFszNC4wMjYzNTUwMDAwMDAwMDIsIC0xMTguMzcyMTJdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDI5LjMxNDUzNDA4MjQsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfMDNiMjhjZjhmNWEwNDkwOWJiZDcyYTE0OWQ0MTNiMmQpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8yZjQ5NWE1NjNmMjk0MmE2YTk4M2E1ODNmY2IxZmJiNCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF8xY2NiMmM1NzhmODU0ZDQwOGVlYjA0MmE1M2I0YmRlNSA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfMWNjYjJjNTc4Zjg1NGQ0MDhlZWIwNDJhNTNiNGJkZTUiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDI5LjMxNDUzNDA4MjQ8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMmY0OTVhNTYzZjI5NDJhNmE5ODNhNTgzZmNiMWZiYjQuc2V0Q29udGVudChodG1sXzFjY2IyYzU3OGY4NTRkNDA4ZWViMDQyYTUzYjRiZGU1KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfMDNiMjhjZjhmNWEwNDkwOWJiZDcyYTE0OWQ0MTNiMmQuYmluZFBvcHVwKHBvcHVwXzJmNDk1YTU2M2YyOTQyYTZhOTgzYTU4M2ZjYjFmYmI0KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfNGI0YTNmN2Q3ODJhNDY4MmJmZGY3MjdmNWE2MTFmY2QgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDI2MzU1MDAwMDAwMDAyLCAtMTE4LjM3MjEyXSwgWzM0LjAyNzg5NjAwMDAwMDAwNSwgLTExOC4zODg5ODYwMDAwMDAwMl1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMjEuODYxOTY4NzI1OCwKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV80YjRhM2Y3ZDc4MmE0NjgyYmZkZjcyN2Y1YTYxMWZjZCk7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2FjYTlkMzgzZGY4ZDQxY2NiYmQ1MDczZmM1YjMxNWY3ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2QzYmQ2NDE0NTY3ZjRjYWI5YzU3NjdlNDhiMDc2NmRmID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF9kM2JkNjQxNDU2N2Y0Y2FiOWM1NzY3ZTQ4YjA3NjZkZiIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMjEuODYxOTY4NzI1ODwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9hY2E5ZDM4M2RmOGQ0MWNjYmJkNTA3M2ZjNWIzMTVmNy5zZXRDb250ZW50KGh0bWxfZDNiZDY0MTQ1NjdmNGNhYjljNTc2N2U0OGIwNzY2ZGYpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV80YjRhM2Y3ZDc4MmE0NjgyYmZkZjcyN2Y1YTYxMWZjZC5iaW5kUG9wdXAocG9wdXBfYWNhOWQzODNkZjhkNDFjY2JiZDUwNzNmYzViMzE1ZjcpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV8xMGUyMGM2ODE0N2U0YWIyODI2NGJjZjRiNjAxYjI0ZiA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMjc4OTYwMDAwMDAwMDUsIC0xMTguMzg4OTg2MDAwMDAwMDJdLCBbMzQuMDI5MzIyOTk5OTk5OTk4LCAtMTE4LjQwNDI1NTAwMDAwMDAxXV0sCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgd2VpZ2h0OiAyNi4zOTYwOTE4MTc0LAogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTguYWRkTGF5ZXIocG9seV9saW5lXzEwZTIwYzY4MTQ3ZTRhYjI4MjY0YmNmNGI2MDFiMjRmKTsKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfOTU1ZDY3MjkwNzJhNDg3YmE4NzNmMmQyOWI4MWYzMjUgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCd9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNzY2MmE0MDk0ODc1NDA1MmE1NmQwMTIyZGM2YWMxNGMgPSAkKCcgICAgICAgICA8ZGl2IGlkPSJodG1sXzc2NjJhNDA5NDg3NTQwNTJhNTZkMDEyMmRjNmFjMTRjIiAgICAgICAgICAgICAgICAgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+ICAgICAgICAgICAgICAgICAyNi4zOTYwOTE4MTc0PC9kaXY+ICAgICAgICAgICAgICAgICAnKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzk1NWQ2NzI5MDcyYTQ4N2JhODczZjJkMjliODFmMzI1LnNldENvbnRlbnQoaHRtbF83NjYyYTQwOTQ4NzU0MDUyYTU2ZDAxMjJkYzZhYzE0Yyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgcG9seV9saW5lXzEwZTIwYzY4MTQ3ZTRhYjI4MjY0YmNmNGI2MDFiMjRmLmJpbmRQb3B1cChwb3B1cF85NTVkNjcyOTA3MmE0ODdiYTg3M2YyZDI5YjgxZjMyNSk7CgogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgcG9seV9saW5lXzQwM2E5YThkMWI4MTQzMzk5NjcyZGNjMTQ0NjI1MzNmID0gTC5wb2x5bGluZSgKICAgICAgICAgICAgICAgICAgICBbWzM0LjAyOTMyMjk5OTk5OTk5OCwgLTExOC40MDQyNTUwMDAwMDAwMV0sIFszNC4wMzY4MTU5OTk5OTk5OTUsIC0xMTguNDI0NTc2XV0sCiAgICAgICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgd2VpZ2h0OiAxOS4xMDI5ODY2NjA3LAogICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXBfM2E3MGJmMWE3ZTZjNDZiZWJhMmMwMDQyOTkxZGEyMTguYWRkTGF5ZXIocG9seV9saW5lXzQwM2E5YThkMWI4MTQzMzk5NjcyZGNjMTQ0NjI1MzNmKTsKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfOWY2ODg1Yjg3YWQ0NDFiMzgzNTY0ZDUwNDU4OTdlZjggPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCd9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfZTQwZmRkN2QyYmJmNDY1MGJkZDVmZjcwOWZlYjdlMWQgPSAkKCcgICAgICAgICA8ZGl2IGlkPSJodG1sX2U0MGZkZDdkMmJiZjQ2NTBiZGQ1ZmY3MDlmZWI3ZTFkIiAgICAgICAgICAgICAgICAgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+ICAgICAgICAgICAgICAgICAxOS4xMDI5ODY2NjA3PC9kaXY+ICAgICAgICAgICAgICAgICAnKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzlmNjg4NWI4N2FkNDQxYjM4MzU2NGQ1MDQ1ODk3ZWY4LnNldENvbnRlbnQoaHRtbF9lNDBmZGQ3ZDJiYmY0NjUwYmRkNWZmNzA5ZmViN2UxZCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgcG9seV9saW5lXzQwM2E5YThkMWI4MTQzMzk5NjcyZGNjMTQ0NjI1MzNmLmJpbmRQb3B1cChwb3B1cF85ZjY4ODViODdhZDQ0MWIzODM1NjRkNTA0NTg5N2VmOCk7CgogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgcG9seV9saW5lXzc1Mzk0NjA5OWU0NjRmYjc5OTBmMGM2YmU5MGRlODMyID0gTC5wb2x5bGluZSgKICAgICAgICAgICAgICAgICAgICBbWzM0LjAzNjgxNTk5OTk5OTk5NSwgLTExOC40MjQ1NzZdLCBbMzQuMDM1NDA4MDAwMDAwMDA0LCAtMTE4LjQzNDIzNF1dLAogICAgICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIHdlaWdodDogMTYuODQ0MjgzMzY2NywKICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFwXzNhNzBiZjFhN2U2YzQ2YmViYTJjMDA0Mjk5MWRhMjE4LmFkZExheWVyKHBvbHlfbGluZV83NTM5NDYwOTllNDY0ZmI3OTkwZjBjNmJlOTBkZTgzMik7CiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2NlZjRhMzJjOTU4YTQ0ZDQ4NmFmMmNhNTI4ZmEyMzY2ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2RlNGU5YWYzMzJlYzRjODliZDk3N2FmOTI5M2EwYjY5ID0gJCgnICAgICAgICAgPGRpdiBpZD0iaHRtbF9kZTRlOWFmMzMyZWM0Yzg5YmQ5NzdhZjkyOTNhMGI2OSIgICAgICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPiAgICAgICAgICAgICAgICAgMTYuODQ0MjgzMzY2NzwvZGl2PiAgICAgICAgICAgICAgICAgJylbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9jZWY0YTMyYzk1OGE0NGQ0ODZhZjJjYTUyOGZhMjM2Ni5zZXRDb250ZW50KGh0bWxfZGU0ZTlhZjMzMmVjNGM4OWJkOTc3YWY5MjkzYTBiNjkpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIHBvbHlfbGluZV83NTM5NDYwOTllNDY0ZmI3OTkwZjBjNmJlOTBkZTgzMi5iaW5kUG9wdXAocG9wdXBfY2VmNGEzMmM5NThhNDRkNDg2YWYyY2E1MjhmYTIzNjYpOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAgICAgCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIHBvbHlfbGluZV9iNTA0OTU1YmFmNDc0MGFjOTAwNGY3OTg1NmU1NzZlNiA9IEwucG9seWxpbmUoCiAgICAgICAgICAgICAgICAgICAgW1szNC4wMzU0MDgwMDAwMDAwMDQsIC0xMTguNDM0MjM0XSwgWzM0LjAzMTcwNTAwMDAwMDAwMiwgLTExOC40NTI4OTZdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDIxLjk3NTE2MDc2OTMsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfYjUwNDk1NWJhZjQ3NDBhYzkwMDRmNzk4NTZlNTc2ZTYpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8zZmNmZDcxYzhiNzQ0YjY0OTc2NTM0NzIwYTI3ZjBkZCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9lZDVkZjE2ZGRlMzk0YzM5OWIwMzdmOTJmOGYxYjFmNCA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfZWQ1ZGYxNmRkZTM5NGMzOTliMDM3ZjkyZjhmMWIxZjQiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDIxLjk3NTE2MDc2OTM8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfM2ZjZmQ3MWM4Yjc0NGI2NDk3NjUzNDcyMGEyN2YwZGQuc2V0Q29udGVudChodG1sX2VkNWRmMTZkZGUzOTRjMzk5YjAzN2Y5MmY4ZjFiMWY0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfYjUwNDk1NWJhZjQ3NDBhYzkwMDRmNzk4NTZlNTc2ZTYuYmluZFBvcHVwKHBvcHVwXzNmY2ZkNzFjOGI3NDRiNjQ5NzY1MzQ3MjBhMjdmMGRkKTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfMDM3ZmRlMmFlZDViNGRlODg1YTNjNDI5MDQ5NjcwMDcgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDMxNzA1MDAwMDAwMDAyLCAtMTE4LjQ1Mjg5Nl0sIFszNC4wMjc5OTUwMDAwMDAwMDQsIC0xMTguNDY5MTE5OTk5OTk5OTldXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDI4LjkxMTQ3MTY1MDUsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfMDM3ZmRlMmFlZDViNGRlODg1YTNjNDI5MDQ5NjcwMDcpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF84Yjc4YmQ1ZDE2YjU0MjI0YjUzZjMzZWI3YzkzZTczNiA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF85NDg2ZTliZjIwODM0NTRjYjM0ZTQ3MDk3YWFhOTY4OCA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfOTQ4NmU5YmYyMDgzNDU0Y2IzNGU0NzA5N2FhYTk2ODgiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDI4LjkxMTQ3MTY1MDU8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfOGI3OGJkNWQxNmI1NDIyNGI1M2YzM2ViN2M5M2U3MzYuc2V0Q29udGVudChodG1sXzk0ODZlOWJmMjA4MzQ1NGNiMzRlNDcwOTdhYWE5Njg4KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfMDM3ZmRlMmFlZDViNGRlODg1YTNjNDI5MDQ5NjcwMDcuYmluZFBvcHVwKHBvcHVwXzhiNzhiZDVkMTZiNTQyMjRiNTNmMzNlYjdjOTNlNzM2KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfMTg0ODMwMzRhYzdiNGRjYmJkOWY1ZmZiMGVhN2VhODYgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDI3OTk1MDAwMDAwMDA0LCAtMTE4LjQ2OTExOTk5OTk5OTk5XSwgWzM0LjAyMzE1NDk5OTk5OTk5NiwgLTExOC40ODAzNzJdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDQzLjU1NjU5NjA4MjUsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfMTg0ODMwMzRhYzdiNGRjYmJkOWY1ZmZiMGVhN2VhODYpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9mNWU2NmQ0NTQ1ODU0ZWUwODZlZWUxZTc5ZmJhODM4NSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF84ODc0MTU1MmZkMGY0MTYxYmJmODU4MDZiOWY1NjNkNyA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfODg3NDE1NTJmZDBmNDE2MWJiZjg1ODA2YjlmNTYzZDciICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDQzLjU1NjU5NjA4MjU8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZjVlNjZkNDU0NTg1NGVlMDg2ZWVlMWU3OWZiYTgzODUuc2V0Q29udGVudChodG1sXzg4NzQxNTUyZmQwZjQxNjFiYmY4NTgwNmI5ZjU2M2Q3KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfMTg0ODMwMzRhYzdiNGRjYmJkOWY1ZmZiMGVhN2VhODYuYmluZFBvcHVwKHBvcHVwX2Y1ZTY2ZDQ1NDU4NTRlZTA4NmVlZTFlNzlmYmE4Mzg1KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBwb2x5X2xpbmVfNTE1NDFlNGM5NzM2NGIyYzgzNWNjYjlhYWU5OTZhNGQgPSBMLnBvbHlsaW5lKAogICAgICAgICAgICAgICAgICAgIFtbMzQuMDIzMTU0OTk5OTk5OTk2LCAtMTE4LjQ4MDM3Ml0sIFszNC4wMTQwMDk5OTk5OTk5OTksIC0xMTguNDkxMzg0MDAwMDAwMDFdXSwKICAgICAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB3ZWlnaHQ6IDEzLjM5MDgxOTUzMTUsCiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcF8zYTcwYmYxYTdlNmM0NmJlYmEyYzAwNDI5OTFkYTIxOC5hZGRMYXllcihwb2x5X2xpbmVfNTE1NDFlNGM5NzM2NGIyYzgzNWNjYjlhYWU5OTZhNGQpOwogICAgICAgICAgICAKICAgICAgICAKICAgICAgICAgICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9kODU4OTc3NGU3NDg0MzRmYWZiZGIyMGZkNGM3NTI5NyA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJ30pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF83ZTM3YzZlMmQ4NDU0Y2NlOWQ4NDU1ZDQwZDdlY2E3ZiA9ICQoJyAgICAgICAgIDxkaXYgaWQ9Imh0bWxfN2UzN2M2ZTJkODQ1NGNjZTlkODQ1NWQ0MGQ3ZWNhN2YiICAgICAgICAgICAgICAgICBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij4gICAgICAgICAgICAgICAgIDEzLjM5MDgxOTUzMTU8L2Rpdj4gICAgICAgICAgICAgICAgICcpWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZDg1ODk3NzRlNzQ4NDM0ZmFmYmRiMjBmZDRjNzUyOTcuc2V0Q29udGVudChodG1sXzdlMzdjNmUyZDg0NTRjY2U5ZDg0NTVkNDBkN2VjYTdmKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBwb2x5X2xpbmVfNTE1NDFlNGM5NzM2NGIyYzgzNWNjYjlhYWU5OTZhNGQuYmluZFBvcHVwKHBvcHVwX2Q4NTg5Nzc0ZTc0ODQzNGZhZmJkYjIwZmQ0Yzc1Mjk3KTsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgIAogICAgICAgIDwvc2NyaXB0PgogICAgICAgIA==\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;\"></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x110bbeb00>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "foliumMap = folium.Map(location=[34, -118], zoom_start=9)\n",
    "segmentsDF.apply(plotSegment, axis=1)\n",
    "foliumMap"
   ]
  }
 ],
 "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}