test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import osmnx as ox\n",
    "import geopandas as gpd\n",
    "from shapely.geometry import Point"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "def streetTalk(lon,lat,cityname,networkType='drive'):\n",
    "    '''\n",
    "    This function takes a lat/lng pair and a city name as inputs, and returns\n",
    "    a conversational string stating nearest street as well as enclosing streets\n",
    "    point: shapely.geometry.Point\n",
    "    cityname: string\n",
    "    networkType: string\n",
    "    '''\n",
    "    try:\n",
    "        #If the map of city is downloaded, use them directly\n",
    "        #citymap_node = gpd.read_file('data/'+cityname+'/nodes/nodes.shp')\n",
    "        citymap_edge = gpd.read_file('data/'+cityname+'/edges/edges.shp')\n",
    "        #print('exist!')\n",
    "    except:\n",
    "        #If the map is not downloaded, download the map of city via OpenStreetMap\n",
    "        G = ox.graph_from_place(cityname + ', USA', network_type=networkType)\n",
    "        #Save the map in shapefile locally\n",
    "        ox.save_load.save_graph_shapefile(G, filename=cityname, folder=None, encoding='utf-8')\n",
    "        print('Map of ' + cityname + 'is saved in shapefile locally!')\n",
    "        #citymap_node = gpd.read_file('data/'+cityname+'/nodes/nodes.shp')\n",
    "        citymap_edge = gpd.read_file('data/'+cityname+'/edges/edges.shp')\n",
    "    \n",
    "    point = Point(lon,lat)\n",
    "    nearest_name, nearest_id, from_id, to_id = nearestSegment(point,citymap_edge)\n",
    "    \n",
    "    enclosing_from = intersectingStreets(from_id,citymap_edge)\n",
    "    enclosing_to = intersectingStreets(to_id,citymap_edge)\n",
    "    \n",
    "    street_from  = enclosing_from[1] if enclosing_from[0] == nearest_name else enclosing_from[0]\n",
    "    street_to  = enclosing_to[1] if enclosing_to[0] == nearest_name else enclosing_to[0]\n",
    "    \n",
    "    #print(len(citymap_node),len(citymap_edge))\n",
    "    conversational = \"{} between {} and {}\".format(nearest_name,street_from,street_to)\n",
    "    print(conversational)\n",
    "    return conversational"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "def nearestSegment(point,city):\n",
    "    '''\n",
    "    This function takes a lat/lon point and a geodataframe of city shapefile\n",
    "    as inputs and returns a name and unique id for nearest street segment to\n",
    "    that point as well as unique ids for the segment's enclosing intersections\n",
    "    point: shapely.geometry.Point (lon/lat)\n",
    "    city: geodataframe of edges of segments in city\n",
    "    return: nearest_name, nearest_id, from_id, to_id\n",
    "    '''\n",
    "    idx = city.geometry.distance(point).sort_values().index[0]\n",
    "    nearest_name = city.loc[idx,'name']\n",
    "    nearest_id = city.loc[idx,'osmid']\n",
    "    from_id = city.loc[idx,'from']\n",
    "    to_id = city.loc[idx,'to']\n",
    "    return nearest_name, nearest_id, from_id, to_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def intersectingStreets(node_id,city):\n",
    "    '''\n",
    "    This function takes a lat/lng pair as an input, and returns the names of\n",
    "    intersecting streets\n",
    "    node_id: node id, string\n",
    "    city: geodataframe of edges of segments in city\n",
    "    return: street_name, street_name_1\n",
    "    '''\n",
    "    return city[(city['from'] == node_id) | (city['to'] == node_id)].name.unique()\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import test data\n",
    "import pandas as pd\n",
    "data = pd.read_csv('data/test_data/squid_test_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>v_value</th>\n",
       "      <th>geometry</th>\n",
       "      <th>image_url</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>original_x</th>\n",
       "      <th>original_y</th>\n",
       "      <th>snapped_x</th>\n",
       "      <th>snapped_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>44:56.1</td>\n",
       "      <td>0.47553</td>\n",
       "      <td>0101000020E610000021882911DE8B5DC092A1BF28000C...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185476</td>\n",
       "      <td>34.093767</td>\n",
       "      <td>-118.185429</td>\n",
       "      <td>34.093755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>45:01.1</td>\n",
       "      <td>0.78636</td>\n",
       "      <td>0101000020E6100000B062E053DF8B5DC0965A1099FA0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185551</td>\n",
       "      <td>34.093602</td>\n",
       "      <td>-118.185506</td>\n",
       "      <td>34.093585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>45:03.1</td>\n",
       "      <td>1.30535</td>\n",
       "      <td>0101000020E6100000DB68A169E08B5DC059149BE7F60B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185634</td>\n",
       "      <td>34.093500</td>\n",
       "      <td>-118.185572</td>\n",
       "      <td>34.093472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>45:05.2</td>\n",
       "      <td>1.29946</td>\n",
       "      <td>0101000020E61000003F0D51EEE18B5DC0C16130A7F20B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185728</td>\n",
       "      <td>34.093376</td>\n",
       "      <td>-118.185665</td>\n",
       "      <td>34.093343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>45:07.1</td>\n",
       "      <td>1.13484</td>\n",
       "      <td>0101000020E610000057954B7EE38B5DC042836005EF0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185834</td>\n",
       "      <td>34.093277</td>\n",
       "      <td>-118.185760</td>\n",
       "      <td>34.093232</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id timestamp  v_value                                           geometry  \\\n",
       "0   1   44:56.1  0.47553  0101000020E610000021882911DE8B5DC092A1BF28000C...   \n",
       "1   2   45:01.1  0.78636  0101000020E6100000B062E053DF8B5DC0965A1099FA0B...   \n",
       "2   3   45:03.1  1.30535  0101000020E6100000DB68A169E08B5DC059149BE7F60B...   \n",
       "3   4   45:05.2  1.29946  0101000020E61000003F0D51EEE18B5DC0C16130A7F20B...   \n",
       "4   5   45:07.1  1.13484  0101000020E610000057954B7EE38B5DC042836005EF0B...   \n",
       "\n",
       "                                           image_url  trip_id  original_x  \\\n",
       "0  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185476   \n",
       "1  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185551   \n",
       "2  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185634   \n",
       "3  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185728   \n",
       "4  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185834   \n",
       "\n",
       "   original_y   snapped_x  snapped_y  \n",
       "0   34.093767 -118.185429  34.093755  \n",
       "1   34.093602 -118.185506  34.093585  \n",
       "2   34.093500 -118.185572  34.093472  \n",
       "3   34.093376 -118.185665  34.093343  \n",
       "4   34.093277 -118.185760  34.093232  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>v_value</th>\n",
       "      <th>geometry</th>\n",
       "      <th>image_url</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>original_x</th>\n",
       "      <th>original_y</th>\n",
       "      <th>snapped_x</th>\n",
       "      <th>snapped_y</th>\n",
       "      <th>conversational string</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>44:56.1</td>\n",
       "      <td>0.47553</td>\n",
       "      <td>0101000020E610000021882911DE8B5DC092A1BF28000C...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185476</td>\n",
       "      <td>34.093767</td>\n",
       "      <td>-118.185429</td>\n",
       "      <td>34.093755</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>45:01.1</td>\n",
       "      <td>0.78636</td>\n",
       "      <td>0101000020E6100000B062E053DF8B5DC0965A1099FA0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185551</td>\n",
       "      <td>34.093602</td>\n",
       "      <td>-118.185506</td>\n",
       "      <td>34.093585</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>45:03.1</td>\n",
       "      <td>1.30535</td>\n",
       "      <td>0101000020E6100000DB68A169E08B5DC059149BE7F60B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185634</td>\n",
       "      <td>34.093500</td>\n",
       "      <td>-118.185572</td>\n",
       "      <td>34.093472</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>45:05.2</td>\n",
       "      <td>1.29946</td>\n",
       "      <td>0101000020E61000003F0D51EEE18B5DC0C16130A7F20B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185728</td>\n",
       "      <td>34.093376</td>\n",
       "      <td>-118.185665</td>\n",
       "      <td>34.093343</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>45:07.1</td>\n",
       "      <td>1.13484</td>\n",
       "      <td>0101000020E610000057954B7EE38B5DC042836005EF0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.185834</td>\n",
       "      <td>34.093277</td>\n",
       "      <td>-118.185760</td>\n",
       "      <td>34.093232</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id timestamp  v_value                                           geometry  \\\n",
       "0   1   44:56.1  0.47553  0101000020E610000021882911DE8B5DC092A1BF28000C...   \n",
       "1   2   45:01.1  0.78636  0101000020E6100000B062E053DF8B5DC0965A1099FA0B...   \n",
       "2   3   45:03.1  1.30535  0101000020E6100000DB68A169E08B5DC059149BE7F60B...   \n",
       "3   4   45:05.2  1.29946  0101000020E61000003F0D51EEE18B5DC0C16130A7F20B...   \n",
       "4   5   45:07.1  1.13484  0101000020E610000057954B7EE38B5DC042836005EF0B...   \n",
       "\n",
       "                                           image_url  trip_id  original_x  \\\n",
       "0  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185476   \n",
       "1  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185551   \n",
       "2  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185634   \n",
       "3  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185728   \n",
       "4  http://storage6.openstreetcam.org/files/photo/...   973407 -118.185834   \n",
       "\n",
       "   original_y   snapped_x  snapped_y conversational string  \n",
       "0   34.093767 -118.185429  34.093755                        \n",
       "1   34.093602 -118.185506  34.093585                        \n",
       "2   34.093500 -118.185572  34.093472                        \n",
       "3   34.093376 -118.185665  34.093343                        \n",
       "4   34.093277 -118.185760  34.093232                        "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['conversational string'] = \"\"\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'timestamp', 'v_value', 'geometry', 'image_url', 'trip_id',\n",
       "       'original_x', 'original_y', 'snapped_x', 'snapped_y',\n",
       "       'conversational string'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Vallejo Villas Street and Via Mia\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Via Marisol between Via Mia and Monterey Road\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Monterey Road between Sinova Street and Via Marisol\n",
      "Sinova Street between McKenzie Avenue and Monterey Road\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Sinova Street\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n",
      "Monterey Road between Edison Street and Armour Avenue\n"
     ]
    },
    {
     "ename": "IndexError",
     "evalue": "index 1 is out of bounds for axis 0 with size 1",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-25-829d56e9a8ec>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m     \u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m10\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mstreetTalk\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m6\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0miloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mi\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m7\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'Los Angeles'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m<ipython-input-19-3735222c9e6e>\u001b[0m in \u001b[0;36mstreetTalk\u001b[0;34m(lon, lat, cityname, networkType)\u001b[0m\n\u001b[1;32m     27\u001b[0m     \u001b[0menclosing_to\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mintersectingStreets\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mto_id\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mcitymap_edge\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     28\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 29\u001b[0;31m     \u001b[0mstreet_from\u001b[0m  \u001b[0;34m=\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mnearest_name\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     30\u001b[0m     \u001b[0mstreet_to\u001b[0m  \u001b[0;34m=\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mnearest_name\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     31\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mIndexError\u001b[0m: index 1 is out of bounds for axis 0 with size 1"
     ]
    }
   ],
   "source": [
    "for i in range(len(data)):\n",
    "    data.iloc[i,10] = streetTalk(data.iloc[i,6],data.iloc[i,7],'Los Angeles')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>v_value</th>\n",
       "      <th>geometry</th>\n",
       "      <th>image_url</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>original_x</th>\n",
       "      <th>original_y</th>\n",
       "      <th>snapped_x</th>\n",
       "      <th>snapped_y</th>\n",
       "      <th>conversational string</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>64</td>\n",
       "      <td>47:30.2</td>\n",
       "      <td>1.22950</td>\n",
       "      <td>0101000020E61000003F78F596138C5DC011F2F92A640B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.188637</td>\n",
       "      <td>34.088978</td>\n",
       "      <td>-118.188696</td>\n",
       "      <td>34.088994</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>65</td>\n",
       "      <td>47:32.2</td>\n",
       "      <td>1.40779</td>\n",
       "      <td>0101000020E6100000B787A8B9138C5DC096432B84630B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.188475</td>\n",
       "      <td>34.088864</td>\n",
       "      <td>-118.188704</td>\n",
       "      <td>34.088974</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>66</td>\n",
       "      <td>47:34.1</td>\n",
       "      <td>1.35059</td>\n",
       "      <td>0101000020E6100000EE4377D80C8C5DC0A21A129B5F0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.188301</td>\n",
       "      <td>34.088813</td>\n",
       "      <td>-118.188284</td>\n",
       "      <td>34.088855</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>67</td>\n",
       "      <td>47:36.2</td>\n",
       "      <td>0.82016</td>\n",
       "      <td>0101000020E61000007CAC64E1098C5DC0290199EB5D0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.188122</td>\n",
       "      <td>34.088758</td>\n",
       "      <td>-118.188103</td>\n",
       "      <td>34.088804</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>68</td>\n",
       "      <td>47:38.2</td>\n",
       "      <td>0.73556</td>\n",
       "      <td>0101000020E6100000686E8DAE068C5DC02F9D261A5C0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187925</td>\n",
       "      <td>34.088708</td>\n",
       "      <td>-118.187908</td>\n",
       "      <td>34.088748</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>69</td>\n",
       "      <td>47:40.1</td>\n",
       "      <td>1.45878</td>\n",
       "      <td>0101000020E610000084F1CA83038C5DC02A0E6F64590B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187757</td>\n",
       "      <td>34.088622</td>\n",
       "      <td>-118.187714</td>\n",
       "      <td>34.088666</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>70</td>\n",
       "      <td>47:42.1</td>\n",
       "      <td>0.94679</td>\n",
       "      <td>0101000020E610000060B2F040008C5DC01891BB72580B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187670</td>\n",
       "      <td>34.088479</td>\n",
       "      <td>-118.187516</td>\n",
       "      <td>34.088637</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>71</td>\n",
       "      <td>47:44.1</td>\n",
       "      <td>0.64751</td>\n",
       "      <td>0101000020E610000060B2F040008C5DC01891BB72580B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187639</td>\n",
       "      <td>34.088324</td>\n",
       "      <td>-118.187516</td>\n",
       "      <td>34.088637</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>72</td>\n",
       "      <td>47:46.1</td>\n",
       "      <td>0.64191</td>\n",
       "      <td>0101000020E6100000BB31E848038C5DC05006C488490B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187626</td>\n",
       "      <td>34.088161</td>\n",
       "      <td>-118.187700</td>\n",
       "      <td>34.088182</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>73</td>\n",
       "      <td>47:48.2</td>\n",
       "      <td>0.82615</td>\n",
       "      <td>0101000020E610000047E3323C048C5DC09D4D3DD1440B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187621</td>\n",
       "      <td>34.088000</td>\n",
       "      <td>-118.187759</td>\n",
       "      <td>34.088038</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>74</td>\n",
       "      <td>47:50.1</td>\n",
       "      <td>0.93726</td>\n",
       "      <td>0101000020E6100000DD680B26058C5DC00C299848400B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187607</td>\n",
       "      <td>34.087842</td>\n",
       "      <td>-118.187814</td>\n",
       "      <td>34.087899</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>75</td>\n",
       "      <td>47:52.2</td>\n",
       "      <td>1.34556</td>\n",
       "      <td>0101000020E61000003BD21B31008C5DC05E86C37B370B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187604</td>\n",
       "      <td>34.087678</td>\n",
       "      <td>-118.187512</td>\n",
       "      <td>34.087631</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>76</td>\n",
       "      <td>47:54.2</td>\n",
       "      <td>0.75372</td>\n",
       "      <td>0101000020E61000003053812D008C5DC00A5298C1330B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187602</td>\n",
       "      <td>34.087516</td>\n",
       "      <td>-118.187511</td>\n",
       "      <td>34.087517</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>77</td>\n",
       "      <td>47:56.1</td>\n",
       "      <td>1.09329</td>\n",
       "      <td>0101000020E6100000DB9B6328008C5DC0A1D8E8762E0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187603</td>\n",
       "      <td>34.087355</td>\n",
       "      <td>-118.187510</td>\n",
       "      <td>34.087355</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>78</td>\n",
       "      <td>47:58.1</td>\n",
       "      <td>1.31558</td>\n",
       "      <td>0101000020E610000081B6C723008C5DC0BAE57FB2290B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187613</td>\n",
       "      <td>34.087184</td>\n",
       "      <td>-118.187508</td>\n",
       "      <td>34.087210</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>79</td>\n",
       "      <td>48:00.1</td>\n",
       "      <td>1.06042</td>\n",
       "      <td>0101000020E610000081B6C723008C5DC0BAE57FB2290B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187618</td>\n",
       "      <td>34.087015</td>\n",
       "      <td>-118.187508</td>\n",
       "      <td>34.087210</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>80</td>\n",
       "      <td>48:02.1</td>\n",
       "      <td>0.76187</td>\n",
       "      <td>0101000020E61000007FF48618008C5DC0F7CB32091E0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187626</td>\n",
       "      <td>34.086853</td>\n",
       "      <td>-118.187506</td>\n",
       "      <td>34.086854</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>81</td>\n",
       "      <td>48:04.1</td>\n",
       "      <td>1.15798</td>\n",
       "      <td>0101000020E61000005F691514008C5DC0C39FF45C190B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187628</td>\n",
       "      <td>34.086711</td>\n",
       "      <td>-118.187505</td>\n",
       "      <td>34.086712</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>82</td>\n",
       "      <td>48:06.1</td>\n",
       "      <td>0.42920</td>\n",
       "      <td>0101000020E61000009E72FB10008C5DC08857FA69150B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187624</td>\n",
       "      <td>34.086590</td>\n",
       "      <td>-118.187504</td>\n",
       "      <td>34.086591</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>83</td>\n",
       "      <td>48:08.1</td>\n",
       "      <td>0.42394</td>\n",
       "      <td>0101000020E6100000D790771D048C5DC0D9CF3D6E0D0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187615</td>\n",
       "      <td>34.086496</td>\n",
       "      <td>-118.187751</td>\n",
       "      <td>34.086347</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>84</td>\n",
       "      <td>48:11.2</td>\n",
       "      <td>0.30559</td>\n",
       "      <td>0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187601</td>\n",
       "      <td>34.086399</td>\n",
       "      <td>-118.187502</td>\n",
       "      <td>34.086258</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>85</td>\n",
       "      <td>48:13.1</td>\n",
       "      <td>0.47298</td>\n",
       "      <td>0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187627</td>\n",
       "      <td>34.086357</td>\n",
       "      <td>-118.187502</td>\n",
       "      <td>34.086258</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>86</td>\n",
       "      <td>48:15.1</td>\n",
       "      <td>0.62877</td>\n",
       "      <td>0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187686</td>\n",
       "      <td>34.086329</td>\n",
       "      <td>-118.187502</td>\n",
       "      <td>34.086258</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>87</td>\n",
       "      <td>48:18.2</td>\n",
       "      <td>0.49248</td>\n",
       "      <td>0101000020E6100000F5A2A108008C5DC06976AB58090B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187760</td>\n",
       "      <td>34.086223</td>\n",
       "      <td>-118.187502</td>\n",
       "      <td>34.086223</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>88</td>\n",
       "      <td>48:21.2</td>\n",
       "      <td>0.90751</td>\n",
       "      <td>0101000020E610000062543E09008C5DC0ABDC0A3B060B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187841</td>\n",
       "      <td>34.086128</td>\n",
       "      <td>-118.187502</td>\n",
       "      <td>34.086128</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>89</td>\n",
       "      <td>48:24.1</td>\n",
       "      <td>0.64998</td>\n",
       "      <td>0101000020E6100000D2AC03F1078C5DC059E5EE89050B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187949</td>\n",
       "      <td>34.086048</td>\n",
       "      <td>-118.187985</td>\n",
       "      <td>34.086107</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>90</td>\n",
       "      <td>48:27.1</td>\n",
       "      <td>0.40548</td>\n",
       "      <td>0101000020E61000003A101BCB088C5DC0085EDAD0040B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187950</td>\n",
       "      <td>34.085943</td>\n",
       "      <td>-118.188037</td>\n",
       "      <td>34.086084</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91</td>\n",
       "      <td>48:30.1</td>\n",
       "      <td>0.95120</td>\n",
       "      <td>0101000020E6100000C6D27772088C5DC01AF9121C050B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187869</td>\n",
       "      <td>34.085856</td>\n",
       "      <td>-118.188016</td>\n",
       "      <td>34.086093</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92</td>\n",
       "      <td>48:33.2</td>\n",
       "      <td>0.41812</td>\n",
       "      <td>0101000020E61000003D9EA053098C5DC0BEE8FE5C040B...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.187884</td>\n",
       "      <td>34.085772</td>\n",
       "      <td>-118.188069</td>\n",
       "      <td>34.086071</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93</td>\n",
       "      <td>48:36.1</td>\n",
       "      <td>0.49225</td>\n",
       "      <td>0101000020E6100000D8CBE939078C5DC01208B17AF20A...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.188068</td>\n",
       "      <td>34.085703</td>\n",
       "      <td>-118.187941</td>\n",
       "      <td>34.085525</td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>570</td>\n",
       "      <td>08:05.1</td>\n",
       "      <td>0.70652</td>\n",
       "      <td>0101000020E6100000EFB64A55EC8E5DC034C225395305...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233090</td>\n",
       "      <td>34.041638</td>\n",
       "      <td>-118.233175</td>\n",
       "      <td>34.041602</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>571</td>\n",
       "      <td>08:07.2</td>\n",
       "      <td>0.62434</td>\n",
       "      <td>0101000020E61000006C95F795EB8E5DC0CCCAC8CA5005...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233160</td>\n",
       "      <td>34.041515</td>\n",
       "      <td>-118.233129</td>\n",
       "      <td>34.041528</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td>572</td>\n",
       "      <td>08:09.1</td>\n",
       "      <td>0.74134</td>\n",
       "      <td>0101000020E6100000646933FCEA8E5DC02E5F98D64E05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233195</td>\n",
       "      <td>34.041397</td>\n",
       "      <td>-118.233092</td>\n",
       "      <td>34.041468</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572</th>\n",
       "      <td>573</td>\n",
       "      <td>08:11.2</td>\n",
       "      <td>1.23215</td>\n",
       "      <td>0101000020E6100000646933FCEA8E5DC02E5F98D64E05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233177</td>\n",
       "      <td>34.041272</td>\n",
       "      <td>-118.233092</td>\n",
       "      <td>34.041468</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>574</td>\n",
       "      <td>08:13.1</td>\n",
       "      <td>0.61319</td>\n",
       "      <td>0101000020E6100000646933FCEA8E5DC02E5F98D64E05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233144</td>\n",
       "      <td>34.041142</td>\n",
       "      <td>-118.233092</td>\n",
       "      <td>34.041468</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>574</th>\n",
       "      <td>575</td>\n",
       "      <td>08:15.1</td>\n",
       "      <td>0.51098</td>\n",
       "      <td>0101000020E6100000101E307AEA8E5DC09682A5134005...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233111</td>\n",
       "      <td>34.041012</td>\n",
       "      <td>-118.233061</td>\n",
       "      <td>34.041018</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>576</td>\n",
       "      <td>08:17.1</td>\n",
       "      <td>0.59644</td>\n",
       "      <td>0101000020E61000008A1F4518EA8E5DC06E90F6B43B05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233093</td>\n",
       "      <td>34.040878</td>\n",
       "      <td>-118.233038</td>\n",
       "      <td>34.040885</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td>577</td>\n",
       "      <td>08:19.2</td>\n",
       "      <td>0.65366</td>\n",
       "      <td>0101000020E6100000DBFE83B9E98E5DC038AC6B7A3705...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233070</td>\n",
       "      <td>34.040749</td>\n",
       "      <td>-118.233015</td>\n",
       "      <td>34.040756</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>577</th>\n",
       "      <td>578</td>\n",
       "      <td>08:21.1</td>\n",
       "      <td>0.53324</td>\n",
       "      <td>0101000020E6100000356B135BE98E5DC086A278433305...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233034</td>\n",
       "      <td>34.040622</td>\n",
       "      <td>-118.232993</td>\n",
       "      <td>34.040627</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td>579</td>\n",
       "      <td>08:23.1</td>\n",
       "      <td>1.81259</td>\n",
       "      <td>0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.232999</td>\n",
       "      <td>34.040495</td>\n",
       "      <td>-118.232961</td>\n",
       "      <td>34.040443</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td>580</td>\n",
       "      <td>08:25.2</td>\n",
       "      <td>1.15809</td>\n",
       "      <td>0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233123</td>\n",
       "      <td>34.040428</td>\n",
       "      <td>-118.232961</td>\n",
       "      <td>34.040443</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>581</td>\n",
       "      <td>08:27.1</td>\n",
       "      <td>0.84833</td>\n",
       "      <td>0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233276</td>\n",
       "      <td>34.040411</td>\n",
       "      <td>-118.232961</td>\n",
       "      <td>34.040443</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>582</td>\n",
       "      <td>08:29.1</td>\n",
       "      <td>0.92875</td>\n",
       "      <td>0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233431</td>\n",
       "      <td>34.040429</td>\n",
       "      <td>-118.232961</td>\n",
       "      <td>34.040443</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>582</th>\n",
       "      <td>583</td>\n",
       "      <td>08:31.1</td>\n",
       "      <td>0.76469</td>\n",
       "      <td>0101000020E6100000AB8DFB92F48E5DC0B2188EE02A05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233568</td>\n",
       "      <td>34.040417</td>\n",
       "      <td>-118.233678</td>\n",
       "      <td>34.040371</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>583</th>\n",
       "      <td>584</td>\n",
       "      <td>08:33.1</td>\n",
       "      <td>0.81628</td>\n",
       "      <td>0101000020E61000009F4C1A04F58E5DC0D99DC5C82A05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233710</td>\n",
       "      <td>34.040403</td>\n",
       "      <td>-118.233705</td>\n",
       "      <td>34.040368</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td>585</td>\n",
       "      <td>08:35.1</td>\n",
       "      <td>0.81139</td>\n",
       "      <td>0101000020E61000008863D92DF78E5DC0C33C59542A05...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233843</td>\n",
       "      <td>34.040396</td>\n",
       "      <td>-118.233837</td>\n",
       "      <td>34.040354</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>586</td>\n",
       "      <td>08:37.2</td>\n",
       "      <td>0.61818</td>\n",
       "      <td>0101000020E6100000AACF327AF98E5DC0E86AA6D82905...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.233984</td>\n",
       "      <td>34.040386</td>\n",
       "      <td>-118.233977</td>\n",
       "      <td>34.040340</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>587</td>\n",
       "      <td>08:39.2</td>\n",
       "      <td>1.15020</td>\n",
       "      <td>0101000020E610000017BF23CFFB8E5DC0E126255B2905...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234128</td>\n",
       "      <td>34.040382</td>\n",
       "      <td>-118.234119</td>\n",
       "      <td>34.040325</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>588</td>\n",
       "      <td>08:41.1</td>\n",
       "      <td>0.79034</td>\n",
       "      <td>0101000020E610000032EFC001FE8E5DC0F179DBE42805...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234262</td>\n",
       "      <td>34.040367</td>\n",
       "      <td>-118.234253</td>\n",
       "      <td>34.040310</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>588</th>\n",
       "      <td>589</td>\n",
       "      <td>08:43.1</td>\n",
       "      <td>0.79827</td>\n",
       "      <td>0101000020E6100000A93B871C008F5DC0B6E894732805...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234389</td>\n",
       "      <td>34.040344</td>\n",
       "      <td>-118.234382</td>\n",
       "      <td>34.040297</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>590</td>\n",
       "      <td>08:45.2</td>\n",
       "      <td>0.67925</td>\n",
       "      <td>0101000020E61000004C1A0008028F5DC0874E400C2805...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234505</td>\n",
       "      <td>34.040324</td>\n",
       "      <td>-118.234499</td>\n",
       "      <td>34.040285</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>591</td>\n",
       "      <td>08:47.2</td>\n",
       "      <td>0.83819</td>\n",
       "      <td>0101000020E610000099B40CCD068F5DC04B84870B2705...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234630</td>\n",
       "      <td>34.040314</td>\n",
       "      <td>-118.234790</td>\n",
       "      <td>34.040254</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>592</td>\n",
       "      <td>08:49.2</td>\n",
       "      <td>0.93327</td>\n",
       "      <td>0101000020E610000099B40CCD068F5DC04B84870B2705...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234758</td>\n",
       "      <td>34.040306</td>\n",
       "      <td>-118.234790</td>\n",
       "      <td>34.040254</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>593</td>\n",
       "      <td>08:51.1</td>\n",
       "      <td>0.51368</td>\n",
       "      <td>0101000020E6100000A9DBE84D078F5DC063E473F02605...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234835</td>\n",
       "      <td>34.040343</td>\n",
       "      <td>-118.234821</td>\n",
       "      <td>34.040251</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>594</td>\n",
       "      <td>08:54.2</td>\n",
       "      <td>0.49569</td>\n",
       "      <td>0101000020E6100000844EC46F078F5DC0B6A556E92605...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234866</td>\n",
       "      <td>34.040492</td>\n",
       "      <td>-118.234829</td>\n",
       "      <td>34.040250</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>595</td>\n",
       "      <td>08:57.2</td>\n",
       "      <td>0.46494</td>\n",
       "      <td>0101000020E6100000A9F957D1078F5DC03BD47E9B3205...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234897</td>\n",
       "      <td>34.040602</td>\n",
       "      <td>-118.234852</td>\n",
       "      <td>34.040607</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595</th>\n",
       "      <td>596</td>\n",
       "      <td>09:00.1</td>\n",
       "      <td>0.78236</td>\n",
       "      <td>0101000020E6100000DCA57D0F088F5DC03832355E3505...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234918</td>\n",
       "      <td>34.040685</td>\n",
       "      <td>-118.234867</td>\n",
       "      <td>34.040691</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>597</td>\n",
       "      <td>09:04.1</td>\n",
       "      <td>0.19631</td>\n",
       "      <td>0101000020E6100000582A7547088F5DC006C8A3DA3705...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.234997</td>\n",
       "      <td>34.040753</td>\n",
       "      <td>-118.234880</td>\n",
       "      <td>34.040767</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>598</td>\n",
       "      <td>09:07.2</td>\n",
       "      <td>0.61249</td>\n",
       "      <td>0101000020E6100000E00A405B088F5DC0C52BB6BB3805...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.235050</td>\n",
       "      <td>34.040774</td>\n",
       "      <td>-118.234885</td>\n",
       "      <td>34.040794</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>599</td>\n",
       "      <td>09:11.1</td>\n",
       "      <td>0.83634</td>\n",
       "      <td>0101000020E6100000312F0564088F5DC0B2F8701F3905...</td>\n",
       "      <td>http://storage6.openstreetcam.org/files/photo/...</td>\n",
       "      <td>973407</td>\n",
       "      <td>-118.235208</td>\n",
       "      <td>34.040767</td>\n",
       "      <td>-118.234887</td>\n",
       "      <td>34.040806</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>536 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id timestamp  v_value  \\\n",
       "63    64   47:30.2  1.22950   \n",
       "64    65   47:32.2  1.40779   \n",
       "65    66   47:34.1  1.35059   \n",
       "66    67   47:36.2  0.82016   \n",
       "67    68   47:38.2  0.73556   \n",
       "68    69   47:40.1  1.45878   \n",
       "69    70   47:42.1  0.94679   \n",
       "70    71   47:44.1  0.64751   \n",
       "71    72   47:46.1  0.64191   \n",
       "72    73   47:48.2  0.82615   \n",
       "73    74   47:50.1  0.93726   \n",
       "74    75   47:52.2  1.34556   \n",
       "75    76   47:54.2  0.75372   \n",
       "76    77   47:56.1  1.09329   \n",
       "77    78   47:58.1  1.31558   \n",
       "78    79   48:00.1  1.06042   \n",
       "79    80   48:02.1  0.76187   \n",
       "80    81   48:04.1  1.15798   \n",
       "81    82   48:06.1  0.42920   \n",
       "82    83   48:08.1  0.42394   \n",
       "83    84   48:11.2  0.30559   \n",
       "84    85   48:13.1  0.47298   \n",
       "85    86   48:15.1  0.62877   \n",
       "86    87   48:18.2  0.49248   \n",
       "87    88   48:21.2  0.90751   \n",
       "88    89   48:24.1  0.64998   \n",
       "89    90   48:27.1  0.40548   \n",
       "90    91   48:30.1  0.95120   \n",
       "91    92   48:33.2  0.41812   \n",
       "92    93   48:36.1  0.49225   \n",
       "..   ...       ...      ...   \n",
       "569  570   08:05.1  0.70652   \n",
       "570  571   08:07.2  0.62434   \n",
       "571  572   08:09.1  0.74134   \n",
       "572  573   08:11.2  1.23215   \n",
       "573  574   08:13.1  0.61319   \n",
       "574  575   08:15.1  0.51098   \n",
       "575  576   08:17.1  0.59644   \n",
       "576  577   08:19.2  0.65366   \n",
       "577  578   08:21.1  0.53324   \n",
       "578  579   08:23.1  1.81259   \n",
       "579  580   08:25.2  1.15809   \n",
       "580  581   08:27.1  0.84833   \n",
       "581  582   08:29.1  0.92875   \n",
       "582  583   08:31.1  0.76469   \n",
       "583  584   08:33.1  0.81628   \n",
       "584  585   08:35.1  0.81139   \n",
       "585  586   08:37.2  0.61818   \n",
       "586  587   08:39.2  1.15020   \n",
       "587  588   08:41.1  0.79034   \n",
       "588  589   08:43.1  0.79827   \n",
       "589  590   08:45.2  0.67925   \n",
       "590  591   08:47.2  0.83819   \n",
       "591  592   08:49.2  0.93327   \n",
       "592  593   08:51.1  0.51368   \n",
       "593  594   08:54.2  0.49569   \n",
       "594  595   08:57.2  0.46494   \n",
       "595  596   09:00.1  0.78236   \n",
       "596  597   09:04.1  0.19631   \n",
       "597  598   09:07.2  0.61249   \n",
       "598  599   09:11.1  0.83634   \n",
       "\n",
       "                                              geometry  \\\n",
       "63   0101000020E61000003F78F596138C5DC011F2F92A640B...   \n",
       "64   0101000020E6100000B787A8B9138C5DC096432B84630B...   \n",
       "65   0101000020E6100000EE4377D80C8C5DC0A21A129B5F0B...   \n",
       "66   0101000020E61000007CAC64E1098C5DC0290199EB5D0B...   \n",
       "67   0101000020E6100000686E8DAE068C5DC02F9D261A5C0B...   \n",
       "68   0101000020E610000084F1CA83038C5DC02A0E6F64590B...   \n",
       "69   0101000020E610000060B2F040008C5DC01891BB72580B...   \n",
       "70   0101000020E610000060B2F040008C5DC01891BB72580B...   \n",
       "71   0101000020E6100000BB31E848038C5DC05006C488490B...   \n",
       "72   0101000020E610000047E3323C048C5DC09D4D3DD1440B...   \n",
       "73   0101000020E6100000DD680B26058C5DC00C299848400B...   \n",
       "74   0101000020E61000003BD21B31008C5DC05E86C37B370B...   \n",
       "75   0101000020E61000003053812D008C5DC00A5298C1330B...   \n",
       "76   0101000020E6100000DB9B6328008C5DC0A1D8E8762E0B...   \n",
       "77   0101000020E610000081B6C723008C5DC0BAE57FB2290B...   \n",
       "78   0101000020E610000081B6C723008C5DC0BAE57FB2290B...   \n",
       "79   0101000020E61000007FF48618008C5DC0F7CB32091E0B...   \n",
       "80   0101000020E61000005F691514008C5DC0C39FF45C190B...   \n",
       "81   0101000020E61000009E72FB10008C5DC08857FA69150B...   \n",
       "82   0101000020E6100000D790771D048C5DC0D9CF3D6E0D0B...   \n",
       "83   0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...   \n",
       "84   0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...   \n",
       "85   0101000020E6100000B2F06708008C5DC026BC5D7E0A0B...   \n",
       "86   0101000020E6100000F5A2A108008C5DC06976AB58090B...   \n",
       "87   0101000020E610000062543E09008C5DC0ABDC0A3B060B...   \n",
       "88   0101000020E6100000D2AC03F1078C5DC059E5EE89050B...   \n",
       "89   0101000020E61000003A101BCB088C5DC0085EDAD0040B...   \n",
       "90   0101000020E6100000C6D27772088C5DC01AF9121C050B...   \n",
       "91   0101000020E61000003D9EA053098C5DC0BEE8FE5C040B...   \n",
       "92   0101000020E6100000D8CBE939078C5DC01208B17AF20A...   \n",
       "..                                                 ...   \n",
       "569  0101000020E6100000EFB64A55EC8E5DC034C225395305...   \n",
       "570  0101000020E61000006C95F795EB8E5DC0CCCAC8CA5005...   \n",
       "571  0101000020E6100000646933FCEA8E5DC02E5F98D64E05...   \n",
       "572  0101000020E6100000646933FCEA8E5DC02E5F98D64E05...   \n",
       "573  0101000020E6100000646933FCEA8E5DC02E5F98D64E05...   \n",
       "574  0101000020E6100000101E307AEA8E5DC09682A5134005...   \n",
       "575  0101000020E61000008A1F4518EA8E5DC06E90F6B43B05...   \n",
       "576  0101000020E6100000DBFE83B9E98E5DC038AC6B7A3705...   \n",
       "577  0101000020E6100000356B135BE98E5DC086A278433305...   \n",
       "578  0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...   \n",
       "579  0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...   \n",
       "580  0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...   \n",
       "581  0101000020E610000035FB0BD4E88E5DC09D03CC3C2D05...   \n",
       "582  0101000020E6100000AB8DFB92F48E5DC0B2188EE02A05...   \n",
       "583  0101000020E61000009F4C1A04F58E5DC0D99DC5C82A05...   \n",
       "584  0101000020E61000008863D92DF78E5DC0C33C59542A05...   \n",
       "585  0101000020E6100000AACF327AF98E5DC0E86AA6D82905...   \n",
       "586  0101000020E610000017BF23CFFB8E5DC0E126255B2905...   \n",
       "587  0101000020E610000032EFC001FE8E5DC0F179DBE42805...   \n",
       "588  0101000020E6100000A93B871C008F5DC0B6E894732805...   \n",
       "589  0101000020E61000004C1A0008028F5DC0874E400C2805...   \n",
       "590  0101000020E610000099B40CCD068F5DC04B84870B2705...   \n",
       "591  0101000020E610000099B40CCD068F5DC04B84870B2705...   \n",
       "592  0101000020E6100000A9DBE84D078F5DC063E473F02605...   \n",
       "593  0101000020E6100000844EC46F078F5DC0B6A556E92605...   \n",
       "594  0101000020E6100000A9F957D1078F5DC03BD47E9B3205...   \n",
       "595  0101000020E6100000DCA57D0F088F5DC03832355E3505...   \n",
       "596  0101000020E6100000582A7547088F5DC006C8A3DA3705...   \n",
       "597  0101000020E6100000E00A405B088F5DC0C52BB6BB3805...   \n",
       "598  0101000020E6100000312F0564088F5DC0B2F8701F3905...   \n",
       "\n",
       "                                             image_url  trip_id  original_x  \\\n",
       "63   http://storage6.openstreetcam.org/files/photo/...   973407 -118.188637   \n",
       "64   http://storage6.openstreetcam.org/files/photo/...   973407 -118.188475   \n",
       "65   http://storage6.openstreetcam.org/files/photo/...   973407 -118.188301   \n",
       "66   http://storage6.openstreetcam.org/files/photo/...   973407 -118.188122   \n",
       "67   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187925   \n",
       "68   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187757   \n",
       "69   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187670   \n",
       "70   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187639   \n",
       "71   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187626   \n",
       "72   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187621   \n",
       "73   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187607   \n",
       "74   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187604   \n",
       "75   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187602   \n",
       "76   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187603   \n",
       "77   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187613   \n",
       "78   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187618   \n",
       "79   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187626   \n",
       "80   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187628   \n",
       "81   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187624   \n",
       "82   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187615   \n",
       "83   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187601   \n",
       "84   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187627   \n",
       "85   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187686   \n",
       "86   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187760   \n",
       "87   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187841   \n",
       "88   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187949   \n",
       "89   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187950   \n",
       "90   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187869   \n",
       "91   http://storage6.openstreetcam.org/files/photo/...   973407 -118.187884   \n",
       "92   http://storage6.openstreetcam.org/files/photo/...   973407 -118.188068   \n",
       "..                                                 ...      ...         ...   \n",
       "569  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233090   \n",
       "570  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233160   \n",
       "571  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233195   \n",
       "572  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233177   \n",
       "573  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233144   \n",
       "574  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233111   \n",
       "575  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233093   \n",
       "576  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233070   \n",
       "577  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233034   \n",
       "578  http://storage6.openstreetcam.org/files/photo/...   973407 -118.232999   \n",
       "579  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233123   \n",
       "580  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233276   \n",
       "581  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233431   \n",
       "582  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233568   \n",
       "583  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233710   \n",
       "584  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233843   \n",
       "585  http://storage6.openstreetcam.org/files/photo/...   973407 -118.233984   \n",
       "586  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234128   \n",
       "587  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234262   \n",
       "588  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234389   \n",
       "589  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234505   \n",
       "590  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234630   \n",
       "591  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234758   \n",
       "592  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234835   \n",
       "593  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234866   \n",
       "594  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234897   \n",
       "595  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234918   \n",
       "596  http://storage6.openstreetcam.org/files/photo/...   973407 -118.234997   \n",
       "597  http://storage6.openstreetcam.org/files/photo/...   973407 -118.235050   \n",
       "598  http://storage6.openstreetcam.org/files/photo/...   973407 -118.235208   \n",
       "\n",
       "     original_y   snapped_x  snapped_y conversational string  \n",
       "63    34.088978 -118.188696  34.088994                        \n",
       "64    34.088864 -118.188704  34.088974                        \n",
       "65    34.088813 -118.188284  34.088855                        \n",
       "66    34.088758 -118.188103  34.088804                        \n",
       "67    34.088708 -118.187908  34.088748                        \n",
       "68    34.088622 -118.187714  34.088666                        \n",
       "69    34.088479 -118.187516  34.088637                        \n",
       "70    34.088324 -118.187516  34.088637                        \n",
       "71    34.088161 -118.187700  34.088182                        \n",
       "72    34.088000 -118.187759  34.088038                        \n",
       "73    34.087842 -118.187814  34.087899                        \n",
       "74    34.087678 -118.187512  34.087631                        \n",
       "75    34.087516 -118.187511  34.087517                        \n",
       "76    34.087355 -118.187510  34.087355                        \n",
       "77    34.087184 -118.187508  34.087210                        \n",
       "78    34.087015 -118.187508  34.087210                        \n",
       "79    34.086853 -118.187506  34.086854                        \n",
       "80    34.086711 -118.187505  34.086712                        \n",
       "81    34.086590 -118.187504  34.086591                        \n",
       "82    34.086496 -118.187751  34.086347                        \n",
       "83    34.086399 -118.187502  34.086258                        \n",
       "84    34.086357 -118.187502  34.086258                        \n",
       "85    34.086329 -118.187502  34.086258                        \n",
       "86    34.086223 -118.187502  34.086223                        \n",
       "87    34.086128 -118.187502  34.086128                        \n",
       "88    34.086048 -118.187985  34.086107                        \n",
       "89    34.085943 -118.188037  34.086084                        \n",
       "90    34.085856 -118.188016  34.086093                        \n",
       "91    34.085772 -118.188069  34.086071                        \n",
       "92    34.085703 -118.187941  34.085525                        \n",
       "..          ...         ...        ...                   ...  \n",
       "569   34.041638 -118.233175  34.041602                        \n",
       "570   34.041515 -118.233129  34.041528                        \n",
       "571   34.041397 -118.233092  34.041468                        \n",
       "572   34.041272 -118.233092  34.041468                        \n",
       "573   34.041142 -118.233092  34.041468                        \n",
       "574   34.041012 -118.233061  34.041018                        \n",
       "575   34.040878 -118.233038  34.040885                        \n",
       "576   34.040749 -118.233015  34.040756                        \n",
       "577   34.040622 -118.232993  34.040627                        \n",
       "578   34.040495 -118.232961  34.040443                        \n",
       "579   34.040428 -118.232961  34.040443                        \n",
       "580   34.040411 -118.232961  34.040443                        \n",
       "581   34.040429 -118.232961  34.040443                        \n",
       "582   34.040417 -118.233678  34.040371                        \n",
       "583   34.040403 -118.233705  34.040368                        \n",
       "584   34.040396 -118.233837  34.040354                        \n",
       "585   34.040386 -118.233977  34.040340                        \n",
       "586   34.040382 -118.234119  34.040325                        \n",
       "587   34.040367 -118.234253  34.040310                        \n",
       "588   34.040344 -118.234382  34.040297                        \n",
       "589   34.040324 -118.234499  34.040285                        \n",
       "590   34.040314 -118.234790  34.040254                        \n",
       "591   34.040306 -118.234790  34.040254                        \n",
       "592   34.040343 -118.234821  34.040251                        \n",
       "593   34.040492 -118.234829  34.040250                        \n",
       "594   34.040602 -118.234852  34.040607                        \n",
       "595   34.040685 -118.234867  34.040691                        \n",
       "596   34.040753 -118.234880  34.040767                        \n",
       "597   34.040774 -118.234885  34.040794                        \n",
       "598   34.040767 -118.234887  34.040806                        \n",
       "\n",
       "[536 rows x 11 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['conversational string']==\"\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "ename": "IndexError",
     "evalue": "index 1 is out of bounds for axis 0 with size 1",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-30-091a7f799d89>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mstreetTalk\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m118.188637\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m34.088978\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'Los Angeles'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m<ipython-input-19-3735222c9e6e>\u001b[0m in \u001b[0;36mstreetTalk\u001b[0;34m(lon, lat, cityname, networkType)\u001b[0m\n\u001b[1;32m     27\u001b[0m     \u001b[0menclosing_to\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mintersectingStreets\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mto_id\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mcitymap_edge\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     28\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 29\u001b[0;31m     \u001b[0mstreet_from\u001b[0m  \u001b[0;34m=\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mnearest_name\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0menclosing_from\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     30\u001b[0m     \u001b[0mstreet_to\u001b[0m  \u001b[0;34m=\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0mnearest_name\u001b[0m \u001b[0;32melse\u001b[0m \u001b[0menclosing_to\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     31\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mIndexError\u001b[0m: index 1 is out of bounds for axis 0 with size 1"
     ]
    }
   ],
   "source": [
    "streetTalk(-118.188637,34.088978,'Los Angeles')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}