bicimad-geospatial-data-analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# BiciMAD - GeoJSON geospatial data analysis\n",
    "\n",
    "Copyright © 2017 Javi Ramírez <javi.rmrz@gmail.com> | [@rameerez [tw]](http://twitter.com/rameerez) | [GitHub](http://github.com/rameerez)\n",
    "\n",
    "This code is Open Source, released under the MIT License."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Why/what\n",
    "\n",
    "What does BiciMAD's geospatial data look like? Can we do something valuable with it?\n",
    "\n",
    "![BiciMAD's geospatial data](img/bicimad-geospatial-data.jpeg)\n",
    "_Image credit: Fabio Galicia_"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Dataset description\n",
    "\n",
    "BiciMAD packs GPS track info (the GPS route the user took, including speed data) along with some of their rides instances. They provide this data in GeoJSON format. \n",
    "\n",
    "Unfortunately, the GeoJSON stored by BiciMad is not in a valid GeoJSON format :(\n",
    "\n",
    " - Single quotes `(')` should be double quotes `(\")`\n",
    " - A `FeatureCollection` GeoJSON should be of this form:\n",
    "    ```\n",
    "    { \"type\": \"FeatureCollection\",\n",
    "      \"features\": [\n",
    "      .\n",
    "      .\n",
    "      .\n",
    "     ]}\n",
    "    ```\n",
    "    Instead of:\n",
    "    ```\n",
    "    {'FeatureCollection': \n",
    "        {'Features': [\n",
    "        ]}\n",
    "    }\n",
    "    ```\n",
    " - The `features` property should be lowercase\n",
    "    \n",
    "Useful links:\n",
    " - [GeoJSON specification (RFC7946)](https://tools.ietf.org/html/rfc7946)\n",
    " - [Online GeoJSON linter, validator & viewer](http://geojsonlint.com)\n",
    " \n",
    "----"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Global definitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Data describing all bike rides\n",
    "BIKE_RIDES_DATASET = './data/export_20170301_20170406.json'\n",
    "# Data describing all stations (used just for getting stations' coordinates & names)\n",
    "STATIONS_DATASET = './data/stations.json'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Imports & data loading"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "from pprint import pprint\n",
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import math\n",
    "from pandas.io.json import json_normalize"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "import geojsonio"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from bokeh.io import output_file, output_notebook, show\n",
    "from bokeh.models import (\n",
    "  GMapPlot, GMapOptions, ColumnDataSource, Circle, DataRange1d, PanTool, WheelZoomTool, BoxSelectTool\n",
    ")\n",
    "from bokeh.plotting import figure\n",
    "from bokeh.sampledata.sample_geojson import geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"http://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"e4b0ab90-37b0-4061-86ab-73a07466444f\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(global) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof (window._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "    window._bokeh_onload_callbacks = [];\n",
       "    window._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "\n",
       "  \n",
       "  if (typeof (window._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    window._bokeh_timeout = Date.now() + 5000;\n",
       "    window._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    if (window.Bokeh !== undefined) {\n",
       "      var el = document.getElementById(\"e4b0ab90-37b0-4061-86ab-73a07466444f\");\n",
       "      el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
       "    } else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function run_callbacks() {\n",
       "    window._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "    delete window._bokeh_onload_callbacks\n",
       "    console.info(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(js_urls, callback) {\n",
       "    window._bokeh_onload_callbacks.push(callback);\n",
       "    if (window._bokeh_is_loading > 0) {\n",
       "      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    window._bokeh_is_loading = js_urls.length;\n",
       "    for (var i = 0; i < js_urls.length; i++) {\n",
       "      var url = js_urls[i];\n",
       "      var s = document.createElement('script');\n",
       "      s.src = url;\n",
       "      s.async = false;\n",
       "      s.onreadystatechange = s.onload = function() {\n",
       "        window._bokeh_is_loading--;\n",
       "        if (window._bokeh_is_loading === 0) {\n",
       "          console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
       "          run_callbacks()\n",
       "        }\n",
       "      };\n",
       "      s.onerror = function() {\n",
       "        console.warn(\"failed to load library \" + url);\n",
       "      };\n",
       "      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "    }\n",
       "  };var element = document.getElementById(\"e4b0ab90-37b0-4061-86ab-73a07466444f\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid 'e4b0ab90-37b0-4061-86ab-73a07466444f' but no matching script tag was found. \")\n",
       "    return false;\n",
       "  }\n",
       "\n",
       "  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.js\"];\n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "      document.getElementById(\"e4b0ab90-37b0-4061-86ab-73a07466444f\").textContent = \"BokehJS is loading...\";\n",
       "    },\n",
       "    function(Bokeh) {\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if ((window.Bokeh !== undefined) || (force === true)) {\n",
       "      for (var i = 0; i < inline_js.length; i++) {\n",
       "        inline_js[i](window.Bokeh);\n",
       "      }if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!window._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      window._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"e4b0ab90-37b0-4061-86ab-73a07466444f\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (window._bokeh_is_loading === 0) {\n",
       "    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(js_urls, function() {\n",
       "      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(this));"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "output_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = pd.read_json(BIKE_RIDES_DATASET, lines=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## GPS tracks analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# Lets filter our DataFrame and get a DataFrame only with entries containing a not-NaN \"track\" property\n",
    "df_track = df.loc[df.track.notnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>ageRange</th>\n",
       "      <th>idplug_base</th>\n",
       "      <th>idplug_station</th>\n",
       "      <th>idunplug_base</th>\n",
       "      <th>idunplug_station</th>\n",
       "      <th>track</th>\n",
       "      <th>travel_time</th>\n",
       "      <th>unplug_hourTime</th>\n",
       "      <th>user_day_code</th>\n",
       "      <th>user_type</th>\n",
       "      <th>zip_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>115348</th>\n",
       "      <td>{'$oid': '58d18956865e9c3790a34a04'}</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>60</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>156725</td>\n",
       "      <td>{'$date': '2017-03-13T12:00:00.000+0100'}</td>\n",
       "      <td>fce2be1e9634cbcf37fc6898d12d0dff8732ac0b159f07...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117252</th>\n",
       "      <td>{'$oid': '58d1a814865e9c1d0415cd52'}</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>71</td>\n",
       "      <td>15</td>\n",
       "      <td>132</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>261831</td>\n",
       "      <td>{'$date': '2017-03-13T16:00:00.000+0100'}</td>\n",
       "      <td>ba8ccf63ccc66fc4c28adc621bcc15a3a70286ab3a2480...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129814</th>\n",
       "      <td>{'$oid': '58d181be865e9c3790a32858'}</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>36</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>18887</td>\n",
       "      <td>{'$date': '2017-03-14T20:00:00.000+0100'}</td>\n",
       "      <td>1c15cc8e667946f44f0a07aaaf529d3737527d04f1c6b4...</td>\n",
       "      <td>1</td>\n",
       "      <td>28009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130571</th>\n",
       "      <td>{'$oid': '58d181be865e9c3790a32857'}</td>\n",
       "      <td>4</td>\n",
       "      <td>22</td>\n",
       "      <td>13</td>\n",
       "      <td>22</td>\n",
       "      <td>13</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>12680</td>\n",
       "      <td>{'$date': '2017-03-14T21:00:00.000+0100'}</td>\n",
       "      <td>33287e1807327a243dc12ee4d297ef8f56940992257c63...</td>\n",
       "      <td>1</td>\n",
       "      <td>28005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130574</th>\n",
       "      <td>{'$oid': '58d181e8865e9c3790a32901'}</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>49</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>18043</td>\n",
       "      <td>{'$date': '2017-03-14T21:00:00.000+0100'}</td>\n",
       "      <td>ea67a1693aabf82860de4c3eda49ea95dd0939e17b3d21...</td>\n",
       "      <td>1</td>\n",
       "      <td>28047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131154</th>\n",
       "      <td>{'$oid': '58d181f0865e9c3790a32925'}</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>121</td>\n",
       "      <td>4</td>\n",
       "      <td>149</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>15125</td>\n",
       "      <td>{'$date': '2017-03-14T22:00:00.000+0100'}</td>\n",
       "      <td>0e203142eb42fa7178db31ec80aba50695d3408c2872ba...</td>\n",
       "      <td>1</td>\n",
       "      <td>28008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131156</th>\n",
       "      <td>{'$oid': '58d181f5865e9c3790a3293c'}</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>160</td>\n",
       "      <td>9</td>\n",
       "      <td>19</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>17864</td>\n",
       "      <td>{'$date': '2017-03-14T22:00:00.000+0100'}</td>\n",
       "      <td>8ad7e45dc1603c71cd29397bec6fd0cbe785d3de791ff7...</td>\n",
       "      <td>1</td>\n",
       "      <td>28004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131500</th>\n",
       "      <td>{'$oid': '58d181c3865e9c3790a3286b'}</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>77</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>6859</td>\n",
       "      <td>{'$date': '2017-03-14T23:00:00.000+0100'}</td>\n",
       "      <td>3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131813</th>\n",
       "      <td>{'$oid': '58d181b7865e9c3790a3283c'}</td>\n",
       "      <td>4</td>\n",
       "      <td>24</td>\n",
       "      <td>29</td>\n",
       "      <td>23</td>\n",
       "      <td>149</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1853</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>2a192bd4ccebe687f6af157215a528f0c549f0e603455b...</td>\n",
       "      <td>1</td>\n",
       "      <td>28005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131814</th>\n",
       "      <td>{'$oid': '58d181b8865e9c3790a32841'}</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>137</td>\n",
       "      <td>4</td>\n",
       "      <td>43</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1690</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5e0c3f0a0ccc690c35de9056c24afc44e0f7702cb0c8f4...</td>\n",
       "      <td>1</td>\n",
       "      <td>28026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131815</th>\n",
       "      <td>{'$oid': '58d181bb865e9c3790a32849'}</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>133</td>\n",
       "      <td>4</td>\n",
       "      <td>134</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>3233</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>2f3ef37491dfe54d94c8d9f1769cd279f5beca9928278e...</td>\n",
       "      <td>1</td>\n",
       "      <td>28005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131816</th>\n",
       "      <td>{'$oid': '58d181bd865e9c3790a3284f'}</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>149</td>\n",
       "      <td>15</td>\n",
       "      <td>23</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1881</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>fac0c9ae633ef056a83f5f059d8ce1f21c383cdf2f4d58...</td>\n",
       "      <td>1</td>\n",
       "      <td>28003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131817</th>\n",
       "      <td>{'$oid': '58d181be865e9c3790a32855'}</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>107</td>\n",
       "      <td>10</td>\n",
       "      <td>133</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>2002</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131819</th>\n",
       "      <td>{'$oid': '58d181bf865e9c3790a32859'}</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>107</td>\n",
       "      <td>13</td>\n",
       "      <td>133</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>2169</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131820</th>\n",
       "      <td>{'$oid': '58d181bf865e9c3790a3285a'}</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>107</td>\n",
       "      <td>3</td>\n",
       "      <td>52</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>2790</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131821</th>\n",
       "      <td>{'$oid': '58d181c1865e9c3790a32860'}</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>142</td>\n",
       "      <td>9</td>\n",
       "      <td>96</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>2041</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>7f12fe2dce0bd9b2166de102dbef4b0778a5d245726fb8...</td>\n",
       "      <td>1</td>\n",
       "      <td>28008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131822</th>\n",
       "      <td>{'$oid': '58d181c1865e9c3790a32861'}</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>73</td>\n",
       "      <td>16</td>\n",
       "      <td>84</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>5234</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>796d4b092c124ce6637ccb312b285311e235a54fd220b6...</td>\n",
       "      <td>1</td>\n",
       "      <td>28009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131825</th>\n",
       "      <td>{'$oid': '58d181c2865e9c3790a32866'}</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>73</td>\n",
       "      <td>23</td>\n",
       "      <td>52</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>3632</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131826</th>\n",
       "      <td>{'$oid': '58d181c2865e9c3790a32867'}</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>73</td>\n",
       "      <td>19</td>\n",
       "      <td>52</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>3717</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131829</th>\n",
       "      <td>{'$oid': '58d181c4865e9c3790a3286c'}</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>73</td>\n",
       "      <td>9</td>\n",
       "      <td>52</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>3851</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>5c101071f1d4a0b4f051df8442e892813b75c81d225715...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131832</th>\n",
       "      <td>{'$oid': '58d181d9865e9c3790a328bf'}</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>23</td>\n",
       "      <td>12</td>\n",
       "      <td>48</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>5009</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131833</th>\n",
       "      <td>{'$oid': '58d181d9865e9c3790a328c1'}</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "      <td>48</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>5081</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131836</th>\n",
       "      <td>{'$oid': '58d181f4865e9c3790a3293a'}</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>172</td>\n",
       "      <td>3</td>\n",
       "      <td>137</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>11854</td>\n",
       "      <td>{'$date': '2017-03-15T00:00:00.000+0100'}</td>\n",
       "      <td>ab298853eac5935d6e45379bea32adb719df3a661909f6...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132025</th>\n",
       "      <td>{'$oid': '58d181b7865e9c3790a3283d'}</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>35</td>\n",
       "      <td>7</td>\n",
       "      <td>135</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>622</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>d8c80d538f1c51a3369c701457211a79055ab8efe84e06...</td>\n",
       "      <td>1</td>\n",
       "      <td>28045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132028</th>\n",
       "      <td>{'$oid': '58d181b8865e9c3790a32840'}</td>\n",
       "      <td>5</td>\n",
       "      <td>21</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>48</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>316</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>3984c4a5d50116ec9872c130280d64cf1ed566d94a843d...</td>\n",
       "      <td>1</td>\n",
       "      <td>28013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132029</th>\n",
       "      <td>{'$oid': '58d181b9865e9c3790a32842'}</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>135</td>\n",
       "      <td>9</td>\n",
       "      <td>165</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>966</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>cd4104076c3c92de73249b9e90802d32db01bd91a53992...</td>\n",
       "      <td>1</td>\n",
       "      <td>28041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132031</th>\n",
       "      <td>{'$oid': '58d181b9865e9c3790a32844'}</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>134</td>\n",
       "      <td>16</td>\n",
       "      <td>27</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>397</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>b0867a73aaa887f64ea4280c07e70468d54c583705f3f1...</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132033</th>\n",
       "      <td>{'$oid': '58d181ba865e9c3790a32846'}</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>128</td>\n",
       "      <td>21</td>\n",
       "      <td>62</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>553</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>9f1d35465294d18841f497b9ef65abe585f8a0f3cbf09d...</td>\n",
       "      <td>1</td>\n",
       "      <td>28004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132035</th>\n",
       "      <td>{'$oid': '58d181ba865e9c3790a32848'}</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>163</td>\n",
       "      <td>18</td>\n",
       "      <td>166</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>418</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>434d0a030d6361c002ffd40167298ae5b4eec603e3af9b...</td>\n",
       "      <td>1</td>\n",
       "      <td>28010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132036</th>\n",
       "      <td>{'$oid': '58d181bb865e9c3790a3284a'}</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>24</td>\n",
       "      <td>19</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>858</td>\n",
       "      <td>{'$date': '2017-03-15T01:00:00.000+0100'}</td>\n",
       "      <td>75e8700c6e5bd1efec25ca9b695e837455f66cf06a9436...</td>\n",
       "      <td>1</td>\n",
       "      <td>28009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289932</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47961'}</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>74</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>715</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>b2ef0d968642828ba5d3e12fc9843da8c56660bcd5ebab...</td>\n",
       "      <td>1</td>\n",
       "      <td>28009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289934</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47963'}</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>135</td>\n",
       "      <td>17</td>\n",
       "      <td>26</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>970</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>ef8e10f209ae410fa5bda790132ebd9c1532f2392da579...</td>\n",
       "      <td>1</td>\n",
       "      <td>28045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289936</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47965'}</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>59</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>279</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>220dfb5c0c0598a93350acec32cf5453f2c2d781948ce1...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289937</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47966'}</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>163</td>\n",
       "      <td>19</td>\n",
       "      <td>58</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>233</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>a51d4667b643a037dead34526984a618d91550a8d8ee39...</td>\n",
       "      <td>1</td>\n",
       "      <td>28004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289938</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47967'}</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>157</td>\n",
       "      <td>14</td>\n",
       "      <td>130</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>403</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>e505a0a3bdbf1e2d8897974d70623dd9f428affcc773c8...</td>\n",
       "      <td>1</td>\n",
       "      <td>28015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289939</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47968'}</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>142</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1390</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>add433bd2a4fc9907b4d91a6438d0c33864a59dd872d7f...</td>\n",
       "      <td>1</td>\n",
       "      <td>28020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289941</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47969'}</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>142</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1413</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>31b3a715a08254240bef14f7870a7b42fee01a0f16da26...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289942</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4796b'}</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>6</td>\n",
       "      <td>57</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>2321</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>264f1fd07aa6a09d1b6d700bb12b4a5668aa1a73f71857...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289943</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4796c'}</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>87</td>\n",
       "      <td>21</td>\n",
       "      <td>56</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>618</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>32502419c70f57d1804a67b3123dcfde16faff8a6090d0...</td>\n",
       "      <td>1</td>\n",
       "      <td>28007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289945</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4796e'}</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>136</td>\n",
       "      <td>16</td>\n",
       "      <td>79</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>664</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>81a240a0b0e44234467e4b0a339d6a0f72a3d7df782f86...</td>\n",
       "      <td>1</td>\n",
       "      <td>28014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289948</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47971'}</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>98</td>\n",
       "      <td>3</td>\n",
       "      <td>38</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>833</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>f5855808a76ba192bff5f58c88b60bd4046e00d83098c8...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289949</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47972'}</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>49</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>574</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>370328a250de3a6cbaba7f922a1882fc9b44f7f3d1d222...</td>\n",
       "      <td>1</td>\n",
       "      <td>03680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289950</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47973'}</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>168</td>\n",
       "      <td>22</td>\n",
       "      <td>35</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>726</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>10b393e2380e38ccb0d124831230302f988e9a2e7cc832...</td>\n",
       "      <td>1</td>\n",
       "      <td>28015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289951</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47974'}</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>129</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>308</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>7bdc628e79807786937776956301d3b099bed8e190ddae...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289952</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47975'}</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>57</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>338</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>f74f3466116304667b42e8df94842ad9b0e6c9a2683cbb...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289953</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47976'}</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>439</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>e55feef66ca09bf8335227d303eb20ba516179dcbd3098...</td>\n",
       "      <td>1</td>\n",
       "      <td>28013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289957</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4797a'}</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>125</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>791</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>55a1dde0d51ef0098b990f45a8331b559b58f7a197d4b8...</td>\n",
       "      <td>1</td>\n",
       "      <td>28008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289958</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4797b'}</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>172</td>\n",
       "      <td>6</td>\n",
       "      <td>146</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>310</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>ec3bf64db8dcc61331a4f0b360d2fb942cfe0ee56a80bd...</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289959</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4797c'}</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>166</td>\n",
       "      <td>5</td>\n",
       "      <td>96</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>410</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>feb4e523dd8bdaed99a086e02c799b14d10dac34f4d957...</td>\n",
       "      <td>1</td>\n",
       "      <td>28006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289962</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47980'}</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>156</td>\n",
       "      <td>4</td>\n",
       "      <td>142</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>402</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>7471b559470ac9c115db40a361e3c4e28d8dcfe0023ecf...</td>\n",
       "      <td>1</td>\n",
       "      <td>28020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289963</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47981'}</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>174</td>\n",
       "      <td>24</td>\n",
       "      <td>57</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1571</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>fc89c0a887e5dc9424259e68e737cdb67fde60c0158aef...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289964</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47982'}</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>79</td>\n",
       "      <td>6</td>\n",
       "      <td>45</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>927</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>3b1f9f91e0194213409a23f4a58a065871e539e8505514...</td>\n",
       "      <td>1</td>\n",
       "      <td>28007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289965</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47983'}</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>174</td>\n",
       "      <td>15</td>\n",
       "      <td>57</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1539</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>5e6d144ba80275898265ed580b742111b6e6b06c65e9aa...</td>\n",
       "      <td>1</td>\n",
       "      <td>28012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289966</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47984'}</td>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>79</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>923</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>97aa3a0552ed415e3fe56398a1aeed0c6004fc2c33d5ab...</td>\n",
       "      <td>1</td>\n",
       "      <td>28007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289967</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47985'}</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>313</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>7f9d5f10a1bdc65187778658a562310624a1d35717677d...</td>\n",
       "      <td>1</td>\n",
       "      <td>28010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289971</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47989'}</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>23</td>\n",
       "      <td>47</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>270</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>4e4353dbc7cd56a8b4760e61df8b23ba93a2f68f8132c5...</td>\n",
       "      <td>1</td>\n",
       "      <td>28005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289973</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4798b'}</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>21</td>\n",
       "      <td>117</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>385</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>3ef2414f61641985c65b3a447f35e6017741ae698f5fb2...</td>\n",
       "      <td>1</td>\n",
       "      <td>28006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289974</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4798c'}</td>\n",
       "      <td>4</td>\n",
       "      <td>24</td>\n",
       "      <td>135</td>\n",
       "      <td>6</td>\n",
       "      <td>59</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>1263</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>ad10cf2263701c272a1191fb5fb81fbc3490d017ffee05...</td>\n",
       "      <td>1</td>\n",
       "      <td>28045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289976</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca4798e'}</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>45</td>\n",
       "      <td>21</td>\n",
       "      <td>26</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>432</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>ed0eee7b71b57bae149c9dce6ea368d06e3cd666050a85...</td>\n",
       "      <td>1</td>\n",
       "      <td>28024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289980</th>\n",
       "      <td>{'$oid': '58e5e616865e9c221ca47993'}</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "      <td>90</td>\n",
       "      <td>{'FeatureCollection': {'Features': [{'type': '...</td>\n",
       "      <td>375</td>\n",
       "      <td>{'$date': '2017-04-01T22:00:00.000+0100'}</td>\n",
       "      <td>0580d62266cb3c4753b665211f467574747ab36c33e94a...</td>\n",
       "      <td>1</td>\n",
       "      <td>28009</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87788 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         _id  ageRange  idplug_base  \\\n",
       "115348  {'$oid': '58d18956865e9c3790a34a04'}         4           21   \n",
       "117252  {'$oid': '58d1a814865e9c1d0415cd52'}         1            2   \n",
       "129814  {'$oid': '58d181be865e9c3790a32858'}         5            7   \n",
       "130571  {'$oid': '58d181be865e9c3790a32857'}         4           22   \n",
       "130574  {'$oid': '58d181e8865e9c3790a32901'}         4            5   \n",
       "131154  {'$oid': '58d181f0865e9c3790a32925'}         3           10   \n",
       "131156  {'$oid': '58d181f5865e9c3790a3293c'}         4            9   \n",
       "131500  {'$oid': '58d181c3865e9c3790a3286b'}         4           20   \n",
       "131813  {'$oid': '58d181b7865e9c3790a3283c'}         4           24   \n",
       "131814  {'$oid': '58d181b8865e9c3790a32841'}         3           15   \n",
       "131815  {'$oid': '58d181bb865e9c3790a32849'}         5            7   \n",
       "131816  {'$oid': '58d181bd865e9c3790a3284f'}         4           18   \n",
       "131817  {'$oid': '58d181be865e9c3790a32855'}         5            6   \n",
       "131819  {'$oid': '58d181bf865e9c3790a32859'}         5           10   \n",
       "131820  {'$oid': '58d181bf865e9c3790a3285a'}         5            9   \n",
       "131821  {'$oid': '58d181c1865e9c3790a32860'}         3            3   \n",
       "131822  {'$oid': '58d181c1865e9c3790a32861'}         4            7   \n",
       "131825  {'$oid': '58d181c2865e9c3790a32866'}         5           13   \n",
       "131826  {'$oid': '58d181c2865e9c3790a32867'}         5           12   \n",
       "131829  {'$oid': '58d181c4865e9c3790a3286c'}         5           19   \n",
       "131832  {'$oid': '58d181d9865e9c3790a328bf'}         4           16   \n",
       "131833  {'$oid': '58d181d9865e9c3790a328c1'}         4           20   \n",
       "131836  {'$oid': '58d181f4865e9c3790a3293a'}         5            7   \n",
       "132025  {'$oid': '58d181b7865e9c3790a3283d'}         2            5   \n",
       "132028  {'$oid': '58d181b8865e9c3790a32840'}         5           21   \n",
       "132029  {'$oid': '58d181b9865e9c3790a32842'}         4            4   \n",
       "132031  {'$oid': '58d181b9865e9c3790a32844'}         5            4   \n",
       "132033  {'$oid': '58d181ba865e9c3790a32846'}         3           11   \n",
       "132035  {'$oid': '58d181ba865e9c3790a32848'}         5           10   \n",
       "132036  {'$oid': '58d181bb865e9c3790a3284a'}         4            4   \n",
       "...                                      ...       ...          ...   \n",
       "289932  {'$oid': '58e5e616865e9c221ca47961'}         4            3   \n",
       "289934  {'$oid': '58e5e616865e9c221ca47963'}         4            9   \n",
       "289936  {'$oid': '58e5e616865e9c221ca47965'}         0           22   \n",
       "289937  {'$oid': '58e5e616865e9c221ca47966'}         3            1   \n",
       "289938  {'$oid': '58e5e616865e9c221ca47967'}         3            5   \n",
       "289939  {'$oid': '58e5e616865e9c221ca47968'}         3           10   \n",
       "289941  {'$oid': '58e5e616865e9c221ca47969'}         0            4   \n",
       "289942  {'$oid': '58e5e616865e9c221ca4796b'}         3            4   \n",
       "289943  {'$oid': '58e5e616865e9c221ca4796c'}         4           17   \n",
       "289945  {'$oid': '58e5e616865e9c221ca4796e'}         4            9   \n",
       "289948  {'$oid': '58e5e616865e9c221ca47971'}         0           18   \n",
       "289949  {'$oid': '58e5e616865e9c221ca47972'}         4           15   \n",
       "289950  {'$oid': '58e5e616865e9c221ca47973'}         4           14   \n",
       "289951  {'$oid': '58e5e616865e9c221ca47974'}         4           23   \n",
       "289952  {'$oid': '58e5e616865e9c221ca47975'}         3            3   \n",
       "289953  {'$oid': '58e5e616865e9c221ca47976'}         3            5   \n",
       "289957  {'$oid': '58e5e616865e9c221ca4797a'}         3            1   \n",
       "289958  {'$oid': '58e5e616865e9c221ca4797b'}         0           16   \n",
       "289959  {'$oid': '58e5e616865e9c221ca4797c'}         5            4   \n",
       "289962  {'$oid': '58e5e616865e9c221ca47980'}         4            4   \n",
       "289963  {'$oid': '58e5e616865e9c221ca47981'}         4            4   \n",
       "289964  {'$oid': '58e5e616865e9c221ca47982'}         5           22   \n",
       "289965  {'$oid': '58e5e616865e9c221ca47983'}         4            7   \n",
       "289966  {'$oid': '58e5e616865e9c221ca47984'}         5           24   \n",
       "289967  {'$oid': '58e5e616865e9c221ca47985'}         5            2   \n",
       "289971  {'$oid': '58e5e616865e9c221ca47989'}         4            1   \n",
       "289973  {'$oid': '58e5e616865e9c221ca4798b'}         3            1   \n",
       "289974  {'$oid': '58e5e616865e9c221ca4798c'}         4           24   \n",
       "289976  {'$oid': '58e5e616865e9c221ca4798e'}         3            8   \n",
       "289980  {'$oid': '58e5e616865e9c221ca47993'}         4            2   \n",
       "\n",
       "        idplug_station  idunplug_base  idunplug_station  \\\n",
       "115348              60             10                19   \n",
       "117252              71             15               132   \n",
       "129814              36              2                36   \n",
       "130571              13             22                13   \n",
       "130574              49             10                40   \n",
       "131154             121              4               149   \n",
       "131156             160              9                19   \n",
       "131500               1             11                77   \n",
       "131813              29             23               149   \n",
       "131814             137              4                43   \n",
       "131815             133              4               134   \n",
       "131816             149             15                23   \n",
       "131817             107             10               133   \n",
       "131819             107             13               133   \n",
       "131820             107              3                52   \n",
       "131821             142              9                96   \n",
       "131822              73             16                84   \n",
       "131825              73             23                52   \n",
       "131826              73             19                52   \n",
       "131829              73              9                52   \n",
       "131832              23             12                48   \n",
       "131833              23             11                48   \n",
       "131836             172              3               137   \n",
       "132025              35              7               135   \n",
       "132028              10              6                48   \n",
       "132029             135              9               165   \n",
       "132031             134             16                27   \n",
       "132033             128             21                62   \n",
       "132035             163             18               166   \n",
       "132036              90             24                19   \n",
       "...                ...            ...               ...   \n",
       "289932               3              2                74   \n",
       "289934             135             17                26   \n",
       "289936              59             11                19   \n",
       "289937             163             19                58   \n",
       "289938             157             14               130   \n",
       "289939             142              9                10   \n",
       "289941             142             13                10   \n",
       "289942              46              6                57   \n",
       "289943              87             21                56   \n",
       "289945             136             16                79   \n",
       "289948              98              3                38   \n",
       "289949              49              1                26   \n",
       "289950             168             22                35   \n",
       "289951             129              4                46   \n",
       "289952              43              2                57   \n",
       "289953              71              1                27   \n",
       "289957              38              2               125   \n",
       "289958             172              6               146   \n",
       "289959             166              5                96   \n",
       "289962             156              4               142   \n",
       "289963             174             24                57   \n",
       "289964              79              6                45   \n",
       "289965             174             15                57   \n",
       "289966              79              2                45   \n",
       "289967              23              4                 5   \n",
       "289971              43             23                47   \n",
       "289973              16             21               117   \n",
       "289974             135              6                59   \n",
       "289976              45             21                26   \n",
       "289980              32             21                90   \n",
       "\n",
       "                                                    track  travel_time  \\\n",
       "115348  {'FeatureCollection': {'Features': [{'type': '...       156725   \n",
       "117252  {'FeatureCollection': {'Features': [{'type': '...       261831   \n",
       "129814  {'FeatureCollection': {'Features': [{'type': '...        18887   \n",
       "130571  {'FeatureCollection': {'Features': [{'type': '...        12680   \n",
       "130574  {'FeatureCollection': {'Features': [{'type': '...        18043   \n",
       "131154  {'FeatureCollection': {'Features': [{'type': '...        15125   \n",
       "131156  {'FeatureCollection': {'Features': [{'type': '...        17864   \n",
       "131500  {'FeatureCollection': {'Features': [{'type': '...         6859   \n",
       "131813  {'FeatureCollection': {'Features': [{'type': '...         1853   \n",
       "131814  {'FeatureCollection': {'Features': [{'type': '...         1690   \n",
       "131815  {'FeatureCollection': {'Features': [{'type': '...         3233   \n",
       "131816  {'FeatureCollection': {'Features': [{'type': '...         1881   \n",
       "131817  {'FeatureCollection': {'Features': [{'type': '...         2002   \n",
       "131819  {'FeatureCollection': {'Features': [{'type': '...         2169   \n",
       "131820  {'FeatureCollection': {'Features': [{'type': '...         2790   \n",
       "131821  {'FeatureCollection': {'Features': [{'type': '...         2041   \n",
       "131822  {'FeatureCollection': {'Features': [{'type': '...         5234   \n",
       "131825  {'FeatureCollection': {'Features': [{'type': '...         3632   \n",
       "131826  {'FeatureCollection': {'Features': [{'type': '...         3717   \n",
       "131829  {'FeatureCollection': {'Features': [{'type': '...         3851   \n",
       "131832  {'FeatureCollection': {'Features': [{'type': '...         5009   \n",
       "131833  {'FeatureCollection': {'Features': [{'type': '...         5081   \n",
       "131836  {'FeatureCollection': {'Features': [{'type': '...        11854   \n",
       "132025  {'FeatureCollection': {'Features': [{'type': '...          622   \n",
       "132028  {'FeatureCollection': {'Features': [{'type': '...          316   \n",
       "132029  {'FeatureCollection': {'Features': [{'type': '...          966   \n",
       "132031  {'FeatureCollection': {'Features': [{'type': '...          397   \n",
       "132033  {'FeatureCollection': {'Features': [{'type': '...          553   \n",
       "132035  {'FeatureCollection': {'Features': [{'type': '...          418   \n",
       "132036  {'FeatureCollection': {'Features': [{'type': '...          858   \n",
       "...                                                   ...          ...   \n",
       "289932  {'FeatureCollection': {'Features': [{'type': '...          715   \n",
       "289934  {'FeatureCollection': {'Features': [{'type': '...          970   \n",
       "289936  {'FeatureCollection': {'Features': [{'type': '...          279   \n",
       "289937  {'FeatureCollection': {'Features': [{'type': '...          233   \n",
       "289938  {'FeatureCollection': {'Features': [{'type': '...          403   \n",
       "289939  {'FeatureCollection': {'Features': [{'type': '...         1390   \n",
       "289941  {'FeatureCollection': {'Features': [{'type': '...         1413   \n",
       "289942  {'FeatureCollection': {'Features': [{'type': '...         2321   \n",
       "289943  {'FeatureCollection': {'Features': [{'type': '...          618   \n",
       "289945  {'FeatureCollection': {'Features': [{'type': '...          664   \n",
       "289948  {'FeatureCollection': {'Features': [{'type': '...          833   \n",
       "289949  {'FeatureCollection': {'Features': [{'type': '...          574   \n",
       "289950  {'FeatureCollection': {'Features': [{'type': '...          726   \n",
       "289951  {'FeatureCollection': {'Features': [{'type': '...          308   \n",
       "289952  {'FeatureCollection': {'Features': [{'type': '...          338   \n",
       "289953  {'FeatureCollection': {'Features': [{'type': '...          439   \n",
       "289957  {'FeatureCollection': {'Features': [{'type': '...          791   \n",
       "289958  {'FeatureCollection': {'Features': [{'type': '...          310   \n",
       "289959  {'FeatureCollection': {'Features': [{'type': '...          410   \n",
       "289962  {'FeatureCollection': {'Features': [{'type': '...          402   \n",
       "289963  {'FeatureCollection': {'Features': [{'type': '...         1571   \n",
       "289964  {'FeatureCollection': {'Features': [{'type': '...          927   \n",
       "289965  {'FeatureCollection': {'Features': [{'type': '...         1539   \n",
       "289966  {'FeatureCollection': {'Features': [{'type': '...          923   \n",
       "289967  {'FeatureCollection': {'Features': [{'type': '...          313   \n",
       "289971  {'FeatureCollection': {'Features': [{'type': '...          270   \n",
       "289973  {'FeatureCollection': {'Features': [{'type': '...          385   \n",
       "289974  {'FeatureCollection': {'Features': [{'type': '...         1263   \n",
       "289976  {'FeatureCollection': {'Features': [{'type': '...          432   \n",
       "289980  {'FeatureCollection': {'Features': [{'type': '...          375   \n",
       "\n",
       "                                  unplug_hourTime  \\\n",
       "115348  {'$date': '2017-03-13T12:00:00.000+0100'}   \n",
       "117252  {'$date': '2017-03-13T16:00:00.000+0100'}   \n",
       "129814  {'$date': '2017-03-14T20:00:00.000+0100'}   \n",
       "130571  {'$date': '2017-03-14T21:00:00.000+0100'}   \n",
       "130574  {'$date': '2017-03-14T21:00:00.000+0100'}   \n",
       "131154  {'$date': '2017-03-14T22:00:00.000+0100'}   \n",
       "131156  {'$date': '2017-03-14T22:00:00.000+0100'}   \n",
       "131500  {'$date': '2017-03-14T23:00:00.000+0100'}   \n",
       "131813  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131814  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131815  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131816  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131817  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131819  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131820  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131821  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131822  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131825  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131826  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131829  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131832  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131833  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "131836  {'$date': '2017-03-15T00:00:00.000+0100'}   \n",
       "132025  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132028  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132029  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132031  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132033  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132035  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "132036  {'$date': '2017-03-15T01:00:00.000+0100'}   \n",
       "...                                           ...   \n",
       "289932  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289934  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289936  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289937  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289938  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289939  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289941  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289942  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289943  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289945  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289948  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289949  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289950  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289951  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289952  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289953  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289957  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289958  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289959  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289962  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289963  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289964  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289965  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289966  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289967  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289971  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289973  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289974  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289976  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "289980  {'$date': '2017-04-01T22:00:00.000+0100'}   \n",
       "\n",
       "                                            user_day_code  user_type zip_code  \n",
       "115348  fce2be1e9634cbcf37fc6898d12d0dff8732ac0b159f07...          3           \n",
       "117252  ba8ccf63ccc66fc4c28adc621bcc15a3a70286ab3a2480...          3           \n",
       "129814  1c15cc8e667946f44f0a07aaaf529d3737527d04f1c6b4...          1    28009  \n",
       "130571  33287e1807327a243dc12ee4d297ef8f56940992257c63...          1    28005  \n",
       "130574  ea67a1693aabf82860de4c3eda49ea95dd0939e17b3d21...          1    28047  \n",
       "131154  0e203142eb42fa7178db31ec80aba50695d3408c2872ba...          1    28008  \n",
       "131156  8ad7e45dc1603c71cd29397bec6fd0cbe785d3de791ff7...          1    28004  \n",
       "131500  3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...          3           \n",
       "131813  2a192bd4ccebe687f6af157215a528f0c549f0e603455b...          1    28005  \n",
       "131814  5e0c3f0a0ccc690c35de9056c24afc44e0f7702cb0c8f4...          1    28026  \n",
       "131815  2f3ef37491dfe54d94c8d9f1769cd279f5beca9928278e...          1    28005  \n",
       "131816  fac0c9ae633ef056a83f5f059d8ce1f21c383cdf2f4d58...          1    28003  \n",
       "131817  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131819  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131820  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131821  7f12fe2dce0bd9b2166de102dbef4b0778a5d245726fb8...          1    28008  \n",
       "131822  796d4b092c124ce6637ccb312b285311e235a54fd220b6...          1    28009  \n",
       "131825  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131826  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131829  5c101071f1d4a0b4f051df8442e892813b75c81d225715...          3           \n",
       "131832  3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...          3           \n",
       "131833  3ec89a8148c0b835cace234fcc38ddd3a2561d1068a3f4...          3           \n",
       "131836  ab298853eac5935d6e45379bea32adb719df3a661909f6...          1    28012  \n",
       "132025  d8c80d538f1c51a3369c701457211a79055ab8efe84e06...          1    28045  \n",
       "132028  3984c4a5d50116ec9872c130280d64cf1ed566d94a843d...          1    28013  \n",
       "132029  cd4104076c3c92de73249b9e90802d32db01bd91a53992...          1    28041  \n",
       "132031  b0867a73aaa887f64ea4280c07e70468d54c583705f3f1...          1           \n",
       "132033  9f1d35465294d18841f497b9ef65abe585f8a0f3cbf09d...          1    28004  \n",
       "132035  434d0a030d6361c002ffd40167298ae5b4eec603e3af9b...          1    28010  \n",
       "132036  75e8700c6e5bd1efec25ca9b695e837455f66cf06a9436...          1    28009  \n",
       "...                                                   ...        ...      ...  \n",
       "289932  b2ef0d968642828ba5d3e12fc9843da8c56660bcd5ebab...          1    28009  \n",
       "289934  ef8e10f209ae410fa5bda790132ebd9c1532f2392da579...          1    28045  \n",
       "289936  220dfb5c0c0598a93350acec32cf5453f2c2d781948ce1...          0           \n",
       "289937  a51d4667b643a037dead34526984a618d91550a8d8ee39...          1    28004  \n",
       "289938  e505a0a3bdbf1e2d8897974d70623dd9f428affcc773c8...          1    28015  \n",
       "289939  add433bd2a4fc9907b4d91a6438d0c33864a59dd872d7f...          1    28020  \n",
       "289941  31b3a715a08254240bef14f7870a7b42fee01a0f16da26...          0           \n",
       "289942  264f1fd07aa6a09d1b6d700bb12b4a5668aa1a73f71857...          1    28012  \n",
       "289943  32502419c70f57d1804a67b3123dcfde16faff8a6090d0...          1    28007  \n",
       "289945  81a240a0b0e44234467e4b0a339d6a0f72a3d7df782f86...          1    28014  \n",
       "289948  f5855808a76ba192bff5f58c88b60bd4046e00d83098c8...          0           \n",
       "289949  370328a250de3a6cbaba7f922a1882fc9b44f7f3d1d222...          1    03680  \n",
       "289950  10b393e2380e38ccb0d124831230302f988e9a2e7cc832...          1    28015  \n",
       "289951  7bdc628e79807786937776956301d3b099bed8e190ddae...          1    28012  \n",
       "289952  f74f3466116304667b42e8df94842ad9b0e6c9a2683cbb...          1    28012  \n",
       "289953  e55feef66ca09bf8335227d303eb20ba516179dcbd3098...          1    28013  \n",
       "289957  55a1dde0d51ef0098b990f45a8331b559b58f7a197d4b8...          1    28008  \n",
       "289958  ec3bf64db8dcc61331a4f0b360d2fb942cfe0ee56a80bd...          0           \n",
       "289959  feb4e523dd8bdaed99a086e02c799b14d10dac34f4d957...          1    28006  \n",
       "289962  7471b559470ac9c115db40a361e3c4e28d8dcfe0023ecf...          1    28020  \n",
       "289963  fc89c0a887e5dc9424259e68e737cdb67fde60c0158aef...          1    28012  \n",
       "289964  3b1f9f91e0194213409a23f4a58a065871e539e8505514...          1    28007  \n",
       "289965  5e6d144ba80275898265ed580b742111b6e6b06c65e9aa...          1    28012  \n",
       "289966  97aa3a0552ed415e3fe56398a1aeed0c6004fc2c33d5ab...          1    28007  \n",
       "289967  7f9d5f10a1bdc65187778658a562310624a1d35717677d...          1    28010  \n",
       "289971  4e4353dbc7cd56a8b4760e61df8b23ba93a2f68f8132c5...          1    28005  \n",
       "289973  3ef2414f61641985c65b3a447f35e6017741ae698f5fb2...          1    28006  \n",
       "289974  ad10cf2263701c272a1191fb5fb81fbc3490d017ffee05...          1    28045  \n",
       "289976  ed0eee7b71b57bae149c9dce6ea368d06e3cd666050a85...          1    28024  \n",
       "289980  0580d62266cb3c4753b665211f467574747ab36c33e94a...          1    28009  \n",
       "\n",
       "[87788 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_track"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Converting JSONs into valid GeoJSONs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_with_tracks = df_track.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def sanitize_geojson(row):\n",
    "    geojson_features = row[\"track\"][\"FeatureCollection\"][\"Features\"]\n",
    "    valid_geojson = {}\n",
    "    valid_geojson[\"type\"] = \"FeatureCollection\"\n",
    "    valid_geojson[\"features\"] = geojson_features\n",
    "    return valid_geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df_with_tracks[\"GeoJSON\"] = df_with_tracks.apply(sanitize_geojson, axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Yay! We have now a dataframe containing valid GeoJSONs. Let's have a look:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_type</th>\n",
       "      <th>travel_time</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>148394</th>\n",
       "      <td>3</td>\n",
       "      <td>584055</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132725</th>\n",
       "      <td>3</td>\n",
       "      <td>522803</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166176</th>\n",
       "      <td>3</td>\n",
       "      <td>517185</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158909</th>\n",
       "      <td>3</td>\n",
       "      <td>501398</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158907</th>\n",
       "      <td>3</td>\n",
       "      <td>500632</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145025</th>\n",
       "      <td>3</td>\n",
       "      <td>427285</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143097</th>\n",
       "      <td>3</td>\n",
       "      <td>402740</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210757</th>\n",
       "      <td>3</td>\n",
       "      <td>347624</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213588</th>\n",
       "      <td>3</td>\n",
       "      <td>345882</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213587</th>\n",
       "      <td>3</td>\n",
       "      <td>342724</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213907</th>\n",
       "      <td>3</td>\n",
       "      <td>325168</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213586</th>\n",
       "      <td>3</td>\n",
       "      <td>324651</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155449</th>\n",
       "      <td>3</td>\n",
       "      <td>301008</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172354</th>\n",
       "      <td>3</td>\n",
       "      <td>287879</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173371</th>\n",
       "      <td>3</td>\n",
       "      <td>272365</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218690</th>\n",
       "      <td>3</td>\n",
       "      <td>263596</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218688</th>\n",
       "      <td>3</td>\n",
       "      <td>263577</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218687</th>\n",
       "      <td>3</td>\n",
       "      <td>263573</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218689</th>\n",
       "      <td>3</td>\n",
       "      <td>263526</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218791</th>\n",
       "      <td>3</td>\n",
       "      <td>261855</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117252</th>\n",
       "      <td>3</td>\n",
       "      <td>261831</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218794</th>\n",
       "      <td>3</td>\n",
       "      <td>261354</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147075</th>\n",
       "      <td>3</td>\n",
       "      <td>242053</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207445</th>\n",
       "      <td>3</td>\n",
       "      <td>240932</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191427</th>\n",
       "      <td>3</td>\n",
       "      <td>239463</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180385</th>\n",
       "      <td>3</td>\n",
       "      <td>221707</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223269</th>\n",
       "      <td>3</td>\n",
       "      <td>204466</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223266</th>\n",
       "      <td>3</td>\n",
       "      <td>204415</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238852</th>\n",
       "      <td>3</td>\n",
       "      <td>198578</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155603</th>\n",
       "      <td>3</td>\n",
       "      <td>180223</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285609</th>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170511</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250787</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241137</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198219</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166615</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155781</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137993</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207024</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157076</th>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238162</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238089</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189830</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169010</th>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286344</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273696</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244371</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139258</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175161</th>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174259</th>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264707</th>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279117</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213187</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189774</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211882</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215595</th>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228234</th>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240130</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180472</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206867</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>{'type': 'FeatureCollection', 'features': [{'t...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87788 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user_type  travel_time  \\\n",
       "148394          3       584055   \n",
       "132725          3       522803   \n",
       "166176          3       517185   \n",
       "158909          3       501398   \n",
       "158907          3       500632   \n",
       "145025          3       427285   \n",
       "143097          3       402740   \n",
       "210757          3       347624   \n",
       "213588          3       345882   \n",
       "213587          3       342724   \n",
       "213907          3       325168   \n",
       "213586          3       324651   \n",
       "155449          3       301008   \n",
       "172354          3       287879   \n",
       "173371          3       272365   \n",
       "218690          3       263596   \n",
       "218688          3       263577   \n",
       "218687          3       263573   \n",
       "218689          3       263526   \n",
       "218791          3       261855   \n",
       "117252          3       261831   \n",
       "218794          3       261354   \n",
       "147075          3       242053   \n",
       "207445          3       240932   \n",
       "191427          3       239463   \n",
       "180385          3       221707   \n",
       "223269          3       204466   \n",
       "223266          3       204415   \n",
       "238852          3       198578   \n",
       "155603          3       180223   \n",
       "...           ...          ...   \n",
       "285609          0           11   \n",
       "170511          1           11   \n",
       "250787          3           11   \n",
       "241137          3           10   \n",
       "198219          3           10   \n",
       "166615          3           10   \n",
       "155781          3           10   \n",
       "137993          3           10   \n",
       "207024          3           10   \n",
       "157076          1           10   \n",
       "238162          3            9   \n",
       "238089          3            9   \n",
       "189830          3            9   \n",
       "169010          0            9   \n",
       "286344          1            9   \n",
       "273696          3            9   \n",
       "244371          3            9   \n",
       "139258          3            9   \n",
       "175161          3            8   \n",
       "174259          3            8   \n",
       "264707          3            8   \n",
       "279117          3            7   \n",
       "213187          3            7   \n",
       "189774          3            7   \n",
       "211882          3            7   \n",
       "215595          0            7   \n",
       "228234          0            7   \n",
       "240130          3            7   \n",
       "180472          3            6   \n",
       "206867          3            4   \n",
       "\n",
       "                                                  GeoJSON  \n",
       "148394  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "132725  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "166176  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "158909  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "158907  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "145025  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "143097  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "210757  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "213588  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "213587  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "213907  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "213586  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "155449  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "172354  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "173371  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218690  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218688  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218687  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218689  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218791  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "117252  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "218794  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "147075  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "207445  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "191427  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "180385  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "223269  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "223266  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "238852  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "155603  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "...                                                   ...  \n",
       "285609  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "170511  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "250787  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "241137  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "198219  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "166615  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "155781  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "137993  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "207024  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "157076  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "238162  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "238089  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "189830  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "169010  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "286344  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "273696  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "244371  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "139258  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "175161  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "174259  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "264707  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "279117  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "213187  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "189774  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "211882  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "215595  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "228234  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "240130  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "180472  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "206867  {'type': 'FeatureCollection', 'features': [{'t...  \n",
       "\n",
       "[87788 rows x 3 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_with_tracks.sort_values(by=['travel_time'], ascending=False)[[\"user_type\", \"travel_time\", \"GeoJSON\"]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There's more columns, obviously, but that's our GeoJSONs sorted by travel_time.\n",
    "\n",
    "Since the first ones, the longest ones, belong only to mantainance purposes (user_type = 3), let's filter by user_type and get only annual pass holders' tracks."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'features': [{'geometry': {'coordinates': [-3.6840577999999997,\n",
       "     40.4262994997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4521,\n",
       "    'speed': 7.27,\n",
       "    'var': '28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 42,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6843165997222203, 40.4225665],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4462,\n",
       "    'speed': 7.11,\n",
       "    'var': '28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 12,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.68222249972222, 40.4212747997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4402,\n",
       "    'speed': 3.36,\n",
       "    'var': \"28009,ES,Madrid,Madrid,CALLE O'DONNELL,Madrid\"},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6805816, 40.4187574997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4342,\n",
       "    'speed': 6.38,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6794983, 40.4148162997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4282,\n",
       "    'speed': 4.33,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.67827109972222, 40.4120331],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4222,\n",
       "    'speed': 5.69,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6767390997222202, 40.4105125997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4163,\n",
       "    'speed': 5.77,\n",
       "    'var': '28007,ES,Madrid,Madrid,AVDA MENENDEZ PELAYO 75,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6758984999999997, 40.4087656],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4103,\n",
       "    'speed': 1.55,\n",
       "    'var': '28007,ES,Madrid,Madrid,CALLE CONDE DE CARTAGENA 11,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6733608, 40.4075060997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 4043,\n",
       "    'speed': 5.91,\n",
       "    'var': '28007,ES,Madrid,Madrid,CALLE ANTONIO DIAZ-CA�ABATE 33,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6703427997222198, 40.4062478],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 3984,\n",
       "    'speed': 2.22,\n",
       "    'var': '28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6673083, 40.4052369997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 636,\n",
       "    'speed': 4.5,\n",
       "    'var': '28007,ES,Madrid,Madrid,CALLE FEDERICO MORENO TORROBA 9,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6701125, 40.4062835], 'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 576,\n",
       "    'speed': 6.75,\n",
       "    'var': '28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.67322799972222, 40.4068983],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 517,\n",
       "    'speed': 8.16,\n",
       "    'var': '28007,ES,Madrid,Madrid,AVDA MEDITERRANEO 28,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6742466, 40.4091870997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 457,\n",
       "    'speed': 11.66,\n",
       "    'var': '28007,ES,Madrid,Madrid,CALLE AMADO NERVO 15,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6772133, 40.4123124997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 397,\n",
       "    'speed': 5.36,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.67925, 40.414464], 'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 337,\n",
       "    'speed': 6.69,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6804898, 40.4180759997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 278,\n",
       "    'speed': 6.97,\n",
       "    'var': '28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6822153, 40.4213385997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 218,\n",
       "    'speed': 1.44,\n",
       "    'var': \"28009,ES,Madrid,Madrid,CALLE O'DONNELL,Madrid\"},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.68290929972222, 40.4219357997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 158,\n",
       "    'speed': 1.8,\n",
       "    'var': '28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 4,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6827838, 40.4244373], 'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 99,\n",
       "    'speed': 4.69,\n",
       "    'var': '28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 31,Madrid'},\n",
       "   'type': 'Feature'},\n",
       "  {'geometry': {'coordinates': [-3.6827617999999998, 40.4266897997222],\n",
       "    'type': 'Point'},\n",
       "   'properties': {'secondsfromstart': 39,\n",
       "    'speed': 5.47,\n",
       "    'var': '28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 45,Madrid'},\n",
       "   'type': 'Feature'}],\n",
       " 'type': 'FeatureCollection'}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_with_tracks[df_with_tracks['user_type'] == 1].sort_values(by=['travel_time'], ascending=False).iloc[1600][\"GeoJSON\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Visualizing an individual GeoJSON\n",
    "What does this geospatial data look like?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dfg = gpd.read_file('geojson-example.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>secondsfromstart</th>\n",
       "      <th>speed</th>\n",
       "      <th>var</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4521</td>\n",
       "      <td>7.27</td>\n",
       "      <td>28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 42,Madrid</td>\n",
       "      <td>POINT (-3.6840578 40.4262994997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4462</td>\n",
       "      <td>7.11</td>\n",
       "      <td>28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 12,Madrid</td>\n",
       "      <td>POINT (-3.68431659972222 40.4225665)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4402</td>\n",
       "      <td>3.36</td>\n",
       "      <td>28009,ES,Madrid,Madrid,CALLE ODONNELL,Madrid</td>\n",
       "      <td>POINT (-3.68222249972222 40.4212747997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4342</td>\n",
       "      <td>6.38</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid</td>\n",
       "      <td>POINT (-3.6805816 40.4187574997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4282</td>\n",
       "      <td>4.33</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid</td>\n",
       "      <td>POINT (-3.6794983 40.4148162997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4222</td>\n",
       "      <td>5.69</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid</td>\n",
       "      <td>POINT (-3.67827109972222 40.4120331)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4163</td>\n",
       "      <td>5.77</td>\n",
       "      <td>28007,ES,Madrid,Madrid,AVDA MENENDEZ PELAYO 75...</td>\n",
       "      <td>POINT (-3.67673909972222 40.4105125997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4103</td>\n",
       "      <td>1.55</td>\n",
       "      <td>28007,ES,Madrid,Madrid,CALLE CONDE DE CARTAGEN...</td>\n",
       "      <td>POINT (-3.6758985 40.4087656)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4043</td>\n",
       "      <td>5.91</td>\n",
       "      <td>28007,ES,Madrid,Madrid,CALLE ANTONIO DIAZ-CA�A...</td>\n",
       "      <td>POINT (-3.6733608 40.4075060997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3984</td>\n",
       "      <td>2.22</td>\n",
       "      <td>28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Ma...</td>\n",
       "      <td>POINT (-3.67034279972222 40.4062478)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>636</td>\n",
       "      <td>4.50</td>\n",
       "      <td>28007,ES,Madrid,Madrid,CALLE FEDERICO MORENO T...</td>\n",
       "      <td>POINT (-3.6673083 40.4052369997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>576</td>\n",
       "      <td>6.75</td>\n",
       "      <td>28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Ma...</td>\n",
       "      <td>POINT (-3.6701125 40.4062835)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>517</td>\n",
       "      <td>8.16</td>\n",
       "      <td>28007,ES,Madrid,Madrid,AVDA MEDITERRANEO 28,Ma...</td>\n",
       "      <td>POINT (-3.67322799972222 40.4068983)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>457</td>\n",
       "      <td>11.66</td>\n",
       "      <td>28007,ES,Madrid,Madrid,CALLE AMADO NERVO 15,Ma...</td>\n",
       "      <td>POINT (-3.6742466 40.4091870997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>397</td>\n",
       "      <td>5.36</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid</td>\n",
       "      <td>POINT (-3.6772133 40.4123124997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>337</td>\n",
       "      <td>6.69</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid</td>\n",
       "      <td>POINT (-3.67925 40.414464)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>278</td>\n",
       "      <td>6.97</td>\n",
       "      <td>28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid</td>\n",
       "      <td>POINT (-3.6804898 40.4180759997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>218</td>\n",
       "      <td>1.44</td>\n",
       "      <td>28009,ES,Madrid,Madrid,CALLE ODONNELL,Madrid</td>\n",
       "      <td>POINT (-3.6822153 40.4213385997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>158</td>\n",
       "      <td>1.80</td>\n",
       "      <td>28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 4...</td>\n",
       "      <td>POINT (-3.68290929972222 40.4219357997222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>99</td>\n",
       "      <td>4.69</td>\n",
       "      <td>28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 3...</td>\n",
       "      <td>POINT (-3.6827838 40.4244373)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>39</td>\n",
       "      <td>5.47</td>\n",
       "      <td>28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 4...</td>\n",
       "      <td>POINT (-3.6827618 40.4266897997222)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    secondsfromstart  speed  \\\n",
       "0               4521   7.27   \n",
       "1               4462   7.11   \n",
       "2               4402   3.36   \n",
       "3               4342   6.38   \n",
       "4               4282   4.33   \n",
       "5               4222   5.69   \n",
       "6               4163   5.77   \n",
       "7               4103   1.55   \n",
       "8               4043   5.91   \n",
       "9               3984   2.22   \n",
       "10               636   4.50   \n",
       "11               576   6.75   \n",
       "12               517   8.16   \n",
       "13               457  11.66   \n",
       "14               397   5.36   \n",
       "15               337   6.69   \n",
       "16               278   6.97   \n",
       "17               218   1.44   \n",
       "18               158   1.80   \n",
       "19                99   4.69   \n",
       "20                39   5.47   \n",
       "\n",
       "                                                  var  \\\n",
       "0    28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 42,Madrid   \n",
       "1    28001,ES,Madrid,Madrid,CALLE VELAZQUEZ 12,Madrid   \n",
       "2        28009,ES,Madrid,Madrid,CALLE ODONNELL,Madrid   \n",
       "3    28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid   \n",
       "4    28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid   \n",
       "5         28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid   \n",
       "6   28007,ES,Madrid,Madrid,AVDA MENENDEZ PELAYO 75...   \n",
       "7   28007,ES,Madrid,Madrid,CALLE CONDE DE CARTAGEN...   \n",
       "8   28007,ES,Madrid,Madrid,CALLE ANTONIO DIAZ-CA�A...   \n",
       "9   28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Ma...   \n",
       "10  28007,ES,Madrid,Madrid,CALLE FEDERICO MORENO T...   \n",
       "11  28007,ES,Madrid,Madrid,PLAZA CONDE DE CASAL,Ma...   \n",
       "12  28007,ES,Madrid,Madrid,AVDA MEDITERRANEO 28,Ma...   \n",
       "13  28007,ES,Madrid,Madrid,CALLE AMADO NERVO 15,Ma...   \n",
       "14        28009,ES,Madrid,Madrid,PASEO URUGUAY,Madrid   \n",
       "15   28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid   \n",
       "16   28009,ES,Madrid,Madrid,PASEO FERNAN NU�EZ,Madrid   \n",
       "17       28009,ES,Madrid,Madrid,CALLE ODONNELL,Madrid   \n",
       "18  28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 4...   \n",
       "19  28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 3...   \n",
       "20  28001,ES,Madrid,Madrid,CALLE NU�EZ DE BALBOA 4...   \n",
       "\n",
       "                                      geometry  \n",
       "0          POINT (-3.6840578 40.4262994997222)  \n",
       "1         POINT (-3.68431659972222 40.4225665)  \n",
       "2   POINT (-3.68222249972222 40.4212747997222)  \n",
       "3          POINT (-3.6805816 40.4187574997222)  \n",
       "4          POINT (-3.6794983 40.4148162997222)  \n",
       "5         POINT (-3.67827109972222 40.4120331)  \n",
       "6   POINT (-3.67673909972222 40.4105125997222)  \n",
       "7                POINT (-3.6758985 40.4087656)  \n",
       "8          POINT (-3.6733608 40.4075060997222)  \n",
       "9         POINT (-3.67034279972222 40.4062478)  \n",
       "10         POINT (-3.6673083 40.4052369997222)  \n",
       "11               POINT (-3.6701125 40.4062835)  \n",
       "12        POINT (-3.67322799972222 40.4068983)  \n",
       "13         POINT (-3.6742466 40.4091870997222)  \n",
       "14         POINT (-3.6772133 40.4123124997222)  \n",
       "15                  POINT (-3.67925 40.414464)  \n",
       "16         POINT (-3.6804898 40.4180759997222)  \n",
       "17         POINT (-3.6822153 40.4213385997222)  \n",
       "18  POINT (-3.68290929972222 40.4219357997222)  \n",
       "19               POINT (-3.6827838 40.4244373)  \n",
       "20         POINT (-3.6827618 40.4266897997222)  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x112713a58>"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAANsAAAD8CAYAAAD+KtHOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAEGBJREFUeJzt3X+MHOV9x/H3B/+onVrOVeBI9R3u\nOSU4hUZgaQWuLNTiikKBmktyUUitBFVUSP0hSABjLFWq7QYKWAIjETWyIIJKqDUCy4ApIqQ2LZUS\nh7vaYIyBukFJOCL50vpCXY7G2N/+sXN4fbd7++v22Z3bz0s6sTM3z+530X38PDPzzIwiAjNrvbPa\nXYBZt3DYzBJx2MwScdjMEnHYzBJx2MwScdjMEnHYzBJx2MwSmdvuAupxzjnnRH9/f7vLsC4yPDz8\n84hYMhPvlauw9ff3MzQ01O4yrItI+vFMvZeHkWaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxm\niThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJ\nOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZok4bGaJOGxmiThsZonU\nHDZJcyTtl7Q7W14uaZ+kI5J2SJo/Tdtlko5Luj1bXiDph5JelXRI0ubmv4pZZ6unZ7sFOFyyfC/w\nQEScBxwDbpym7f3A8yXL/wesiYiLgIuBqyStqqMWs9ypKWyS+oBrgIezZQFrgCezTR4DBiq0HQDe\nAQ5NrIui49nivOwnGqjfLDdq7dm2AXcAp7Lls4GxiPgoW34X6J3cSNIiYAMwZZiYDUsPAEeBFyNi\nX521m+VK1bBJuhY4GhHDDbz/JopDzeOTfxERJyPiYqAPuETSb1f4/JskDUkaGh0dbaAEs84wt4Zt\nVgNrJV0NLAAWAw8CPZLmZr1bHzBSpu2lwKCk+4Ae4JSkDyPioYkNImJM0l7gKuD1yW8QEduB7QCF\nQsFDTcutqj1bRGyMiL6I6AeuB/ZExDpgLzCYbXYD8HSZtpdFRH/Wdhtwd0Q8JGmJpB4ASQuBK4A3\nZ+ILmXWqZs6zbQBulXSE4j7cIwCS1kraUqXtrwN7Jb0GvEJxn213E7WYdTxF5GdkVigUYmhoqN1l\nWBeRNBwRhZl4L88gMUvEYTNLxGEzS8RhM0vEYTNLxGEzS8RhM0vEYTNLpJa5kdaAXftH2PrCW7w3\nNs7SnoWsv3IFAyunXBhhXcRha4Fd+0fYuPMg4ydOAjAyNs7GnQcBHLgu5rA1qVwPtvWFtz4O2oTx\nEyfZ+sJbDlsXc9iaUKkHmxy0Ce+NjacszzqMD5A0oVIPNkcqu/3SnoUpyrIO5bA1oVJPdTKChfPm\nnLFu4bw5rL9yRYqyrEM5bE2o1FP19izkb7/wOXp7FqKSZe+vdTfvszVh/ZUrpuyjTfRgAyt7HS47\ng8PWhIkw+Xya1cJha5J7MKuV99nMEnHP1iKermWTOWwt4OlaVo6HkS0w3XQt614OWwtUOtnt6Vrd\nzWFrgUonuz1dq7s5bC2w/soVnq5lU/gASQv4ZLeV47C1iE9222QOWxN8Ls3q4bA1yOfSrF4+QNIg\nn0uzejlsDfK5NKuXh5ENWtqzkJEywVras9D7claWe7YGVTqXdvlnl7Bx50FGxsYJTu/L7dpf7pHj\n1k0ctgYNrOwte+uDvW+Olt2Xu+2JV1l+53OsvmePg9elPIxsQrlzad/YcaDstiezxymPjI2z/slX\nP25v3cM92wyrZf7jiZPB5mcPJajGOonDNsPK7cuVc+yDEwmqsU7iYeQMmzwvMtpcj3UOh60FSvfl\nLt78XcbGp/ZiPQvnpS7L2qzmYaSkOZL2S9qdLS+XtE/SEUk7JM2fpu0ySccl3Z4tnytpr6Q3JB2S\ndEvzX6UzbVp7IfPOOvN25PPOEpvWXtimiqxd6tlnuwU4XLJ8L/BARJwHHANunKbt/cDzJcsfAbdF\nxAXAKuAvJF1QRy25MbCyl61fuuiMUwRbv3SRj0R2oZqGkZL6gGuAu4BbJQlYA/xxtsljwCbg78q0\nHQDeAf53Yl1E/Az4Wfb6fyQdBnqBNxr9Ip3Ml9sY1N6zbQPuAE5ly2cDYxHxUbb8LsWwnEHSImAD\nsLnSG0vqB1YC+2qsxSyXqoZN0rXA0YgYbuD9N1Ecah6v8N6LgKeAr0fE+xW2uUnSkKSh0dHRBkow\n6wy1DCNXA2slXQ0sABYDDwI9kuZmvVsfUG4O0qXAoKT7gB7glKQPI+IhSfMoBu3xiNhZ6cMjYjuw\nHaBQKPhIuuVW1Z4tIjZGRF9E9APXA3siYh2wFxjMNrsBeLpM28sioj9ruw24OwuagEeAwxFx/8x8\nFbPO1swMkg0UD5YcobgP9wiApLWStlRpuxr4KrBG0oHs5+omasmtXftHWH3PHk9S7gKKyM/IrFAo\nxNDQULvLmDGTb60Axct0/ODEziFpOCIKM/FenhvZRr61Qndx2Nqo0i0Uyl0BbvnnsLVRpctxBN53\nm4UctjZaf+UKVGZ9gIeSs5DD1kYDK3srXoLju3TNPg5bm/X6iTddw2FrMz/xpnv44tE28xNvuofD\n1gF8CU538DDSLBGHzSwRh80sEYfNLBGHzSwRh80sEYfNLBGHzSwRn9TuUH566ezjnq0DTdwuofTp\npd/YcYC/2nWw3aVZExy2DlTudgkBPP6Dn/ii0hxz2DpQpWvZfFFpvjlsHWi6a9l8UWl+OWwdqNLt\nEsAXleaZw9aBBlb2sm7VsimB80Wl+eawdahvDnyOB7588RnPdfPNW/PN59k6mC8qnV3cs5kl4rCZ\nJeKwmSXifbZZwPMo88Fhy5nJwbr8s0t4anjk4+ldI2PjbNxZnEPpwHUWDyNzpNwE5cd/8BM/dion\nHLYcqTRBuRxP6+o8DluO1BMgT+vqPA5bjkz3PLdSntbVmRy2HKn0EI51q5Z5WlcO+GhkjvghHPnm\nsOXMdPMlfb6tszlss8TEaQGfb+tcNe+zSZojab+k3dnyckn7JB2RtEPS/GnaLpN0XNLtJeu+I+mo\npNeb+woG5U8L+HxbZ6nnAMktwOGS5XuBByLiPOAYcOM0be8Hnp+07lHgqjo+36ZR6bSAz7d1jprC\nJqkPuAZ4OFsWsAZ4MtvkMWCgQtsB4B3gUOn6iPhX4L8bqtqmqHRawOfbOketPds24A7gVLZ8NjAW\nER9ly+8CU3YMJC0CNgCbm6zTqvCzuTtf1QMkkq4FjkbEsKTfq/P9N1Ecah4vdob1k3QTcBPAsmXL\nGnqPbtDIaQEfvUyrlqORq4G1kq4GFgCLgQeBHklzs96tDyh399BLgUFJ9wE9wClJH0bEQ7UWGBHb\nge0AhUKh0lRAo77bKPjoZXpVh5ERsTEi+iKiH7ge2BMR64C9wGC22Q3A02XaXhYR/VnbbcDd9QTN\nWsdHL9NrZrrWBuBWSUco7sM9AiBpraQt1RpL+gfg+8AKSe9Kmu5opjVg1/4RVt+zh+V3Psfqe/ac\ncetyH71Mr66T2hHxEvBS9vpHwCVltnkGeKbM+k2Tlr9Sz2dbfaoNE5f2LGSkTLB89LJ1PBF5lqo2\nTPTRy/Q8XWuWqjZM9KTm9By2WaqWYaJvApuWh5GzlIeJncc92yzlk9ydx2GbxXySu7N4GGlA5aOX\nm545VKGF1cthM6Dy0cux8RN+jvcMcdgMmP5ktqdwzQyHzQCmPUpZ6xSu6aaHmQ+QWGZgZS+bnz3E\nsQ9OTPldtSlcu/aPsOmZQ4yNn27rAyxTuWezj/31H11Y97m5iaOYpUGb4KsIzuSezT7WyLm5ckcx\nS/kqgtMcNjtDvVO4qoXJVxGc5rBZUyrNwYTapod106wV77NZU8rNwQT4tU/Mq/rMgXLPm9u48+Cs\nPYrpns2a0sylOtNdczcbezeHzZrW6KU63XZrBg8jrW267cayDpu1Tbddc+dhpLVNt92awWGztuqm\nWzN4GGmWiMNmlojDZpaIw2aWiMNmlojDZpaIw2aWiMNmlojDZpaIw2aWiMNmlojDZpaIw2aWiMNm\nlojDZpaIw2aWiMNmlkjNYZM0R9J+Sbuz5eWS9kk6ImmHpPnTtF0m6bik20vWXSXpraz9nc19DbPO\nV0/PdgtwuGT5XuCBiDgPOAbcOE3b+4HnJxYkzQG+BfwhcAHwFUkX1FGLWe7UFDZJfcA1wMPZsoA1\nwJPZJo8BAxXaDgDvAKXPi70EOBIRP4qIXwL/CFzXyBcwy4tae7ZtwB3AqWz5bGAsIj7Klt8Fpty1\nRdIiYAOwedKveoGfliyXbZ+9x02ShiQNjY6O1liuWeepGjZJ1wJHI2K4gfffRHGoebyBtgBExPaI\nKEREYcmSJY2+jVnb1XIru9XAWklXAwuAxcCDQI+kuVnv1geUexrCpcCgpPuAHuCUpA+BYeDcku0q\ntTebNar2bBGxMSL6IqIfuB7YExHrgL3AYLbZDcDTZdpeFhH9WdttwN0R8RDwCvCZ7Ijm/Ox9n5mJ\nL2TWqZo5z7YBuFXSEYr7cI8ASForact0DbPe8C+BFyge4XwiIg5N18Ys7xQR7a6hZoVCIYaGhtpd\nhnURScMRUZiJ9/IMErNEHDazRBw2s0QcNrNEHDazRBw2s0QcNrNEHDazRBw2s0QcNrNEHDazRBw2\ns0QcNrNEHDazRBw2s0QcNrNEHDazRBw2s0QcNrNEHDazRBw2s0QcNrNEHDazRBw2s0QcNrNEHDaz\nRBw2s0Ryda9/SaPAj2vY9Bzg5y0up5Vcf3uV1v8bETEjDwbMVdhqJWloph6G0A6uv71aVb+HkWaJ\nOGxmiczWsG1vdwFNcv3t1ZL6Z+U+m1knmq09m1nHyW3YJP2NpNckHZD0XUlLK2y3LPv9YUlvSOrP\n1q+R9O+SXpf0mKS5Oav/97P6D0j6N0nn5az+l7O2ByS9J2lXzuqXpLskvZ397uaqHxoRufwBFpe8\nvhn4doXtXgKuyF4vAj5B8R+ZnwLnZ+u3ADfmpf7s9dvAb2Wv/xx4NE/1T9rmKeBreaof+BPg74Gz\nsuVPVfvM3PZsEfF+yeKvAlN2PiVdAMyNiBezNscj4gPgbOCXEfF2tumLwBdbXPIZmqyfbPvF2etP\nAu+1sNwpZqD+iW0WA2uApD3bDNT/Z8CWiDiV/e5otc9MOnSaaZLuAr4G/AK4vMwm5wNjknYCy4Hv\nAXdSnB0wV1IhIoaAQeDcNFWf1mj9EXES+FPgnySNA+8Dq9JUfVqT9U8YAP550h9/Ek3W/5vAlyV9\nHhgFbo6I/5j2A1N23Q109d8DXi/zc92k7TYCm8u0H8z+R36a4j8sT5ENF4HfAV4Gfgh8EziQs/p3\nApdmr9cDD+ep/pJtnge+mMO/n+PAbdnrLwAvV62nlWFJ9QMsA14vs34V8C8ly18FvlVmuz8AnshL\n/cAS4D8ntX8jL/WXLJ8D/BewIG9/P8CbwPLstYBfVPuc3O6zSfpMyeJ1FL/8ZK8APZImJpKuAd7I\n2n8q+++vABuAb7eu2qmarP8Y8ElJ52frrwAOt6rWcpr9/58ZBHZHxIetqbKyGah/F6eHnr9L8YDV\n9Nr5L0qT/xo9RXFI8BrwLNCbrS9QMqSi+If4GnAQeBSYn63fSvEP9C3g6zms//PZulcpHjH7dJ7q\nz373EnBVTv9+eoDnsvXfBy6q9pmeQWKWSG6HkWZ547CZJeKwmSXisJkl4rCZJeKwmSXisJkl4rCZ\nJfL/4dJEKmpP+U4AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1124a0f60>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dfg.plot()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "`geojsonio` not working properly. It will redirect to geojson.io instead of embedding an iframe in the notebook. Problem described [here](https://github.com/jwass/geojsonio.py/issues/6). Inserting an image instead:\n",
    "![BiciMAD GeoJSON](img/bicimad-geojson.png)\n",
    "So, as we can see, we have a bunch of geo **points**. We need to find a way to convert those into actual **tracks**."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## From individual GeoJSONs to a huuuuge array of features\n",
    "\n",
    "Work in progress... this part may not work at all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "starting_string = '''{\n",
    "  \"type\": \"FeatureCollection\", '''\n",
    "\n",
    "with open(\"test.txt\", \"a\") as myfile:\n",
    "    myfile.write(starting_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def append_row_features_to_file(row)\n",
    "    geojson_features = row[\"GeoJSON\"][\"Features\"]\n",
    "    features_string = ''' \"features\": ''' + str(geojson_features).replace('\\'', '\\\"')   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ⚠️ Work in progress! ⚠️\n",
    "\n",
    "## To-do:\n",
    "\n",
    "- Find suitable library to plot GeoJSONs (geojsonio? Use an external website and just use JavaScript?)\n",
    "- Find a way to convert from geo points to actual tracks (as lines)\n",
    "- Find a way to plot every track into a map\n",
    "- Streets with most traffic (heatmap?)\n",
    "- Overlap known bike lanes and see if there is unused lanes / streets needing bike lanes - is Madrid bike-friendly?\n",
    "- Are there \"blind spots\"? i.e.: parts of the city needing a station / service coverage?"
   ]
  }
 ],
 "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.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}