GMS 200¶

The following script reads trip files from TripScanner App (repo: ... ) and plots the following:

- Speed versus Time
- Trajectory on a Leaflet Map

from matplotlib import pyplot as plt
import seaborn
import re
import pandas as pd
import datetime
from dateutil import parser
import folium

/projects/sage/sage-6.10/local/lib/python2.7/site-packages/matplotlib-1.5.0-py2.7-linux-x86_64.egg/matplotlib/__init__.py:872: UserWarning: axes.color_cycle is deprecated and replaced with axes.prop_cycle; please use the latter.
  warnings.warn(self.msg_depr % (key, alt_key))

Reading the text file¶

#we open the text file with the read permission
with open('trip_2.txt', 'r') as myfile:
    data=myfile.read()
#Clean up the data and split it
#data = data[2:-2].split('\n')

data

'(\n    "<+37.86698125,-122.26613173> +/- 30.00m (speed 0.88 mps / course -1.00) @ 3/10/16, 11:08:48 AM Pacific Standard Time",\n    "<+37.86698125,-122.26613173> +/- 30.00m (speed 0.88 mps / course -1.00) @ 3/10/16, 11:08:48 AM Pacific Standard Time",\n    "<+37.86698125,-122.26613173> +/- 10.00m (speed 0.00 mps / course -1.00) @ 3/10/16, 11:08:49 AM Pacific Standard Time",\n    "<+37.86698125,-122.26613173> +/- 10.00m (speed 0.00 mps / course -1.00) @ 3/10/16, 11:08:50 AM Pacific Standard Time",\n    "<+37.86698125,-122.26613173> +/- 10.00m (speed 0.00 mps / course -1.00) @ 3/10/16, 11:08:51 AM Pacific Standard Time"\n)'

Parsing the data¶

# for parsing we will use the following regEx
pattern =  "\<(.+)\,(.+)\>\s\+\/\-\s(.+)m\s\(speed\s(.+)\smps\s\/\scourse\s(.+)\)\s\@\s(.+)\sPacific Standard Time"

paresed_data  = re.findall(pattern, data)

#show the data
paresed_data

[('+37.33417438',
  '-122.07050306',
  '5.00',
  '33.60',
  '257.34',
  '3/11/16, 11:58:15 AM'),
 ('+37.33410968',
  '-122.07087404',
  '5.00',
  '33.62',
  '256.99',
  '3/11/16, 11:58:16 AM'),
 ('+37.33403923',
  '-122.07123245',
  '5.00',
  '33.61',
  '256.64',
  '3/11/16, 11:58:17 AM'),
 ('+37.33396475',
  '-122.07160897',
  '5.00',
  '33.51',
  '256.64',
  '3/11/16, 11:58:18 AM'),
 ('+37.33389384',
  '-122.07197743',
  '5.00',
  '33.67',
  '257.34',
  '3/11/16, 11:58:19 AM'),
 ('+37.33382775',
  '-122.07235512',
  '5.00',
  '33.85',
  '258.05',
  '3/11/16, 11:58:20 AM'),
 ('+37.33375801',
  '-122.07272963',
  '5.00',
  '33.36',
  '257.70',
  '3/11/16, 11:58:21 AM'),
 ('+37.33369775',
  '-122.07309474',
  '5.00',
  '33.08',
  '258.05',
  '3/11/16, 11:58:22 AM'),
 ('+37.33363907',
  '-122.07346522',
  '5.00',
  '32.79',
  '259.80',
  '3/11/16, 11:58:23 AM'),
 ('+37.33359159',
  '-122.07381886',
  '5.00',
  '32.16',
  '261.21',
  '3/11/16, 11:58:24 AM'),
 ('+37.33355651',
  '-122.07417592',
  '5.00',
  '32.04',
  '264.02',
  '3/11/16, 11:58:25 AM'),
 ('+37.33353728',
  '-122.07453283',
  '5.00',
  '31.86',
  '266.84',
  '3/11/16, 11:58:26 AM'),
 ('+37.33353065',
  '-122.07488445',
  '5.00',
  '31.54',
  '269.65',
  '3/11/16, 11:58:27 AM'),
 ('+37.33353363',
  '-122.07523112',
  '5.00',
  '31.34',
  '272.11',
  '3/11/16, 11:58:28 AM'),
 ('+37.33355228',
  '-122.07558936',
  '5.00',
  '31.58',
  '274.57',
  '3/11/16, 11:58:29 AM'),
 ('+37.33358308',
  '-122.07595104',
  '5.00',
  '31.84',
  '276.68',
  '3/11/16, 11:58:30 AM'),
 ('+37.33362663',
  '-122.07630560',
  '5.00',
  '31.90',
  '279.14',
  '3/11/16, 11:58:31 AM'),
 ('+37.33368006',
  '-122.07665613',
  '5.00',
  '31.92',
  '281.60',
  '3/11/16, 11:58:32 AM'),
 ('+37.33374934',
  '-122.07700482',
  '5.00',
  '32.16',
  '284.06',
  '3/11/16, 11:58:33 AM'),
 ('+37.33382825',
  '-122.07735141',
  '5.00',
  '32.58',
  '287.23',
  '3/11/16, 11:58:34 AM'),
 ('+37.33392322',
  '-122.07769942',
  '5.00',
  '32.48',
  '289.34',
  '3/11/16, 11:58:35 AM'),
 ('+37.33402871',
  '-122.07804543',
  '5.00',
  '32.47',
  '292.15',
  '3/11/16, 11:58:36 AM'),
 ('+37.33415037',
  '-122.07838406',
  '5.00',
  '32.74',
  '294.61',
  '3/11/16, 11:58:37 AM'),
 ('+37.33428050',
  '-122.07872034',
  '5.00',
  '32.85',
  '296.72',
  '3/11/16, 11:58:38 AM'),
 ('+37.33442102',
  '-122.07904631',
  '5.00',
  '32.75',
  '299.18',
  '3/11/16, 11:58:39 AM'),
 ('+37.33457244',
  '-122.07936390',
  '5.00',
  '33.02',
  '301.99',
  '3/11/16, 11:58:40 AM'),
 ('+37.33473735',
  '-122.07967470',
  '5.00',
  '33.21',
  '304.80',
  '3/11/16, 11:58:41 AM'),
 ('+37.33492184',
  '-122.07997503',
  '5.00',
  '33.41',
  '307.97',
  '3/11/16, 11:58:42 AM'),
 ('+37.33511119',
  '-122.08026077',
  '5.00',
  '33.53',
  '310.78',
  '3/11/16, 11:58:43 AM'),
 ('+37.33531428',
  '-122.08054952',
  '5.00',
  '33.75',
  '312.54',
  '3/11/16, 11:58:44 AM'),
 ('+37.33552177',
  '-122.08082252',
  '5.00',
  '33.84',
  '313.59',
  '3/11/16, 11:58:45 AM'),
 ('+37.33573891',
  '-122.08110667',
  '5.00',
  '33.94',
  '313.95',
  '3/11/16, 11:58:46 AM'),
 ('+37.33595575',
  '-122.08138403',
  '5.00',
  '33.84',
  '313.95',
  '3/11/16, 11:58:47 AM'),
 ('+37.33617167',
  '-122.08165962',
  '5.00',
  '33.81',
  '314.30',
  '3/11/16, 11:58:48 AM'),
 ('+37.33638536',
  '-122.08193111',
  '5.00',
  '33.88',
  '314.30',
  '3/11/16, 11:58:49 AM'),
 ('+37.33659906',
  '-122.08220411',
  '5.00',
  '33.62',
  '313.59',
  '3/11/16, 11:58:50 AM'),
 ('+37.33680278',
  '-122.08247812',
  '5.00',
  '33.57',
  '313.24',
  '3/11/16, 11:58:51 AM'),
 ('+37.33700550',
  '-122.08275950',
  '5.00',
  '33.61',
  '312.54',
  '3/11/16, 11:58:52 AM'),
 ('+37.33720302',
  '-122.08304213',
  '5.00',
  '33.31',
  '310.43',
  '3/11/16, 11:58:53 AM'),
 ('+37.33739630',
  '-122.08332863',
  '5.00',
  '33.20',
  '308.67',
  '3/11/16, 11:58:54 AM'),
 ('+37.33758129',
  '-122.08362627',
  '5.00',
  '33.46',
  '307.27',
  '3/11/16, 11:58:55 AM'),
 ('+37.33775509',
  '-122.08392617',
  '5.00',
  '33.24',
  '305.86',
  '3/11/16, 11:58:56 AM'),
 ('+37.33793145',
  '-122.08422750',
  '5.00',
  '33.36',
  '305.51',
  '3/11/16, 11:58:57 AM'),
 ('+37.33810893',
  '-122.08454124',
  '5.00',
  '33.63',
  '305.51',
  '3/11/16, 11:58:58 AM'),
 ('+37.33828420',
  '-122.08484542',
  '5.00',
  '33.58',
  '305.16',
  '3/11/16, 11:58:59 AM'),
 ('+37.33845490',
  '-122.08515152',
  '5.00',
  '33.66',
  '305.16',
  '3/11/16, 11:59:00 AM'),
 ('+37.33862249',
  '-122.08545696',
  '5.00',
  '33.67',
  '304.45',
  '3/11/16, 11:59:01 AM'),
 ('+37.33879885',
  '-122.08577472',
  '5.00',
  '33.54',
  '304.45',
  '3/11/16, 11:59:02 AM'),
 ('+37.33896690',
  '-122.08608946',
  '5.00',
  '33.19',
  '304.10',
  '3/11/16, 11:59:03 AM'),
 ('+37.33913576',
  '-122.08640269',
  '5.00',
  '33.22',
  '304.10',
  '3/11/16, 11:59:04 AM'),
 ('+37.33930008',
  '-122.08670293',
  '5.00',
  '33.09',
  '304.80',
  '3/11/16, 11:59:05 AM'),
 ('+37.33947623',
  '-122.08701088',
  '5.00',
  '33.09',
  '305.51',
  '3/11/16, 11:59:06 AM'),
 ('+37.33965020',
  '-122.08732093',
  '5.00',
  '32.87',
  '305.16',
  '3/11/16, 11:59:07 AM'),
 ('+37.33981846',
  '-122.08762326',
  '5.00',
  '32.90',
  '304.45',
  '3/11/16, 11:59:08 AM'),
 ('+37.33998434',
  '-122.08792937',
  '5.00',
  '32.79',
  '304.45',
  '3/11/16, 11:59:09 AM'),
 ('+37.34014930',
  '-122.08824042',
  '5.00',
  '32.63',
  '303.75',
  '3/11/16, 11:59:10 AM'),
 ('+37.34031484',
  '-122.08856086',
  '5.00',
  '32.58',
  '301.99',
  '3/11/16, 11:59:11 AM'),
 ('+37.34046597',
  '-122.08886286',
  '5.00',
  '32.61',
  '301.29',
  '3/11/16, 11:59:12 AM'),
 ('+37.34061718',
  '-122.08917878',
  '5.00',
  '32.79',
  '300.59',
  '3/11/16, 11:59:13 AM'),
 ('+37.34077165',
  '-122.08949679',
  '5.00',
  '32.93',
  '300.94',
  '3/11/16, 11:59:14 AM'),
 ('+37.34092739',
  '-122.08983097',
  '5.00',
  '32.95',
  '300.23',
  '3/11/16, 11:59:15 AM'),
 ('+37.34107194',
  '-122.09015057',
  '5.00',
  '33.16',
  '299.88',
  '3/11/16, 11:59:16 AM'),
 ('+37.34121879',
  '-122.09045668',
  '5.00',
  '32.93',
  '301.29',
  '3/11/16, 11:59:17 AM'),
 ('+37.34137909',
  '-122.09077234',
  '5.00',
  '33.04',
  '302.34',
  '3/11/16, 11:59:18 AM'),
 ('+37.34154237',
  '-122.09108423',
  '5.00',
  '32.97',
  '304.10',
  '3/11/16, 11:59:19 AM'),
 ('+37.34171403',
  '-122.09138934',
  '5.00',
  '32.90',
  '306.56',
  '3/11/16, 11:59:20 AM'),
 ('+37.34189470',
  '-122.09167600',
  '5.00',
  '32.90',
  '309.02',
  '3/11/16, 11:59:21 AM'),
 ('+37.34208941',
  '-122.09195687',
  '5.00',
  '32.76',
  '311.48',
  '3/11/16, 11:59:22 AM'),
 ('+37.34229154',
  '-122.09222300',
  '5.00',
  '32.66',
  '314.30',
  '3/11/16, 11:59:23 AM'),
 ('+37.34249590',
  '-122.09246482',
  '5.00',
  '32.24',
  '316.41',
  '3/11/16, 11:59:24 AM'),
 ('+37.34270800',
  '-122.09271200',
  '5.00',
  '32.19',
  '316.76',
  '3/11/16, 11:59:25 AM'),
 ('+37.34291352',
  '-122.09295692',
  '5.00',
  '31.66',
  '316.76',
  '3/11/16, 11:59:26 AM'),
 ('+37.34312416',
  '-122.09320284',
  '5.00',
  '31.53',
  '317.11',
  '3/11/16, 11:59:27 AM'),
 ('+37.34332805',
  '-122.09343444',
  '5.00',
  '31.35',
  '317.11',
  '3/11/16, 11:59:28 AM'),
 ('+37.34353735',
  '-122.09368045',
  '5.00',
  '31.14',
  '317.46',
  '3/11/16, 11:59:29 AM'),
 ('+37.34374576',
  '-122.09392000',
  '5.00',
  '31.14',
  '317.46',
  '3/11/16, 11:59:30 AM'),
 ('+37.34394974',
  '-122.09415478',
  '5.00',
  '30.95',
  '317.46',
  '3/11/16, 11:59:31 AM'),
 ('+37.34415677',
  '-122.09439031',
  '5.00',
  '30.74',
  '316.41',
  '3/11/16, 11:59:32 AM'),
 ('+37.34434595',
  '-122.09463741',
  '5.00',
  '31.03',
  '314.30',
  '3/11/16, 11:59:33 AM'),
 ('+37.34453978',
  '-122.09489641',
  '5.00',
  '31.08',
  '312.54',
  '3/11/16, 11:59:34 AM'),
 ('+37.34472464',
  '-122.09516438',
  '5.00',
  '31.03',
  '309.73',
  '3/11/16, 11:59:35 AM'),
 ('+37.34489320',
  '-122.09543830',
  '5.00',
  '31.26',
  '307.62',
  '3/11/16, 11:59:36 AM'),
 ('+37.34505141',
  '-122.09572596',
  '5.00',
  '31.20',
  '305.16',
  '3/11/16, 11:59:37 AM'),
 ('+37.34520782',
  '-122.09601170',
  '5.00',
  '31.12',
  '302.70',
  '3/11/16, 11:59:38 AM'),
 ('+37.34534964',
  '-122.09631924',
  '5.00',
  '31.26',
  '300.23',
  '3/11/16, 11:59:39 AM'),
 ('+37.34548953',
  '-122.09663800',
  '5.00',
  '31.71',
  '298.48',
  '3/11/16, 11:59:40 AM'),
 ('+37.34562364',
  '-122.09695274',
  '5.00',
  '32.22',
  '298.48',
  '3/11/16, 11:59:41 AM'),
 ('+37.34576798',
  '-122.09727888',
  '5.00',
  '32.81',
  '298.48',
  '3/11/16, 11:59:42 AM'),
 ('+37.34590884',
  '-122.09760787',
  '5.00',
  '33.12',
  '297.77',
  '3/11/16, 11:59:43 AM'),
 ('+37.34604924',
  '-122.09794340',
  '5.00',
  '33.66',
  '297.77',
  '3/11/16, 11:59:44 AM'),
 ('+37.34619047',
  '-122.09828781',
  '5.00',
  '33.84',
  '297.77',
  '3/11/16, 11:59:45 AM'),
 ('+37.34633112',
  '-122.09862728',
  '5.00',
  '34.15',
  '298.12',
  '3/11/16, 11:59:46 AM'),
 ('+37.34647860',
  '-122.09896549',
  '5.00',
  '34.08',
  '297.77',
  '3/11/16, 11:59:47 AM'),
 ('+37.34661640',
  '-122.09929791',
  '5.00',
  '33.93',
  '297.42',
  '3/11/16, 11:59:48 AM'),
 ('+37.34676434',
  '-122.09963352',
  '5.00',
  '34.03',
  '298.12',
  '3/11/16, 11:59:49 AM'),
 ('+37.34690805',
  '-122.09997509',
  '5.00',
  '34.21',
  '297.77',
  '3/11/16, 11:59:50 AM'),
 ('+37.34705171',
  '-122.10032243',
  '5.00',
  '34.06',
  '297.77',
  '3/11/16, 11:59:51 AM'),
 ('+37.34719244',
  '-122.10066240',
  '5.00',
  '33.72',
  '297.77',
  '3/11/16, 11:59:52 AM'),
 ('+37.34733473',
  '-122.10099349',
  '5.00',
  '33.60',
  '298.12',
  '3/11/16, 11:59:53 AM'),
 ('+37.34747663',
  '-122.10131879',
  '5.00',
  '33.39',
  '298.48',
  '3/11/16, 11:59:54 AM'),
 ('+37.34762491',
  '-122.10165130',
  '5.00',
  '33.33',
  '300.23',
  '3/11/16, 11:59:55 AM'),
 ('+37.34777737',
  '-122.10196336',
  '5.00',
  '33.26',
  '302.34',
  '3/11/16, 11:59:56 AM'),
 ('+37.34794036',
  '-122.10227399',
  '5.00',
  '33.10',
  '304.80',
  '3/11/16, 11:59:57 AM'),
 ('+37.34812405',
  '-122.10257499',
  '5.00',
  '33.07',
  '307.27',
  '3/11/16, 11:59:58 AM'),
 ('+37.34831482',
  '-122.10286198',
  '5.00',
  '33.08',
  '310.78',
  '3/11/16, 11:59:59 AM'),
 ('+37.34851318',
  '-122.10314001',
  '5.00',
  '33.00',
  '312.89',
  '3/11/16, 12:00:00 PM'),
 ('+37.34872189',
  '-122.10340186',
  '5.00',
  '33.16',
  '316.41',
  '3/11/16, 12:00:01 PM'),
 ('+37.34894824',
  '-122.10365390',
  '5.00',
  '33.12',
  '319.57',
  '3/11/16, 12:00:02 PM'),
 ('+37.34918436',
  '-122.10389589',
  '5.00',
  '32.85',
  '321.68',
  '3/11/16, 12:00:03 PM'),
 ('+37.34941931',
  '-122.10411164',
  '5.00',
  '33.18',
  '324.14',
  '3/11/16, 12:00:04 PM'),
 ('+37.34966435',
  '-122.10431859',
  '5.00',
  '32.96',
  '326.60',
  '3/11/16, 12:00:05 PM'),
 ('+37.34991623',
  '-122.10451573',
  '5.00',
  '33.20',
  '328.01',
  '3/11/16, 12:00:06 PM'),
 ('+37.35016915',
  '-122.10470860',
  '5.00',
  '33.52',
  '329.06',
  '3/11/16, 12:00:07 PM'),
 ('+37.35042203',
  '-122.10490214',
  '5.00',
  '33.52',
  '328.71',
  '3/11/16, 12:00:08 PM'),
 ('+37.35068040',
  '-122.10509685',
  '5.00',
  '33.46',
  '329.06',
  '3/11/16, 12:00:09 PM'),
 ('+37.35093530',
  '-122.10529449',
  '5.00',
  '33.33',
  '329.06',
  '3/11/16, 12:00:10 PM'),
 ('+37.35119518',
  '-122.10549440',
  '5.00',
  '33.38',
  '328.36',
  '3/11/16, 12:00:11 PM'),
 ('+37.35145376',
  '-122.10569934',
  '5.00',
  '33.23',
  '327.66',
  '3/11/16, 12:00:12 PM'),
 ('+37.35170078',
  '-122.10589849',
  '5.00',
  '33.07',
  '326.25',
  '3/11/16, 12:00:13 PM'),
 ('+37.35194528',
  '-122.10610938',
  '5.00',
  '32.97',
  '323.79',
  '3/11/16, 12:00:14 PM'),
 ('+37.35218349',
  '-122.10633762',
  '5.00',
  '32.77',
  '321.68',
  '3/11/16, 12:00:15 PM'),
 ('+37.35240938',
  '-122.10656821',
  '5.00',
  '32.63',
  '319.22',
  '3/11/16, 12:00:16 PM'),
 ('+37.35262907',
  '-122.10682025',
  '5.00',
  '32.67',
  '317.46',
  '3/11/16, 12:00:17 PM'),
 ('+37.35283833',
  '-122.10707414',
  '5.00',
  '32.52',
  '314.65',
  '3/11/16, 12:00:18 PM'),
 ('+37.35304318',
  '-122.10734680',
  '5.00',
  '32.43',
  '312.19',
  '3/11/16, 12:00:19 PM'),
 ('+37.35322775',
  '-122.10761167',
  '5.00',
  '32.14',
  '310.08',
  '3/11/16, 12:00:20 PM'),
 ('+37.35340125',
  '-122.10789012',
  '5.00',
  '32.10',
  '307.97',
  '3/11/16, 12:00:21 PM'),
 ('+37.35357644',
  '-122.10818206',
  '5.00',
  '32.00',
  '306.56',
  '3/11/16, 12:00:22 PM'),
 ('+37.35373217',
  '-122.10847987',
  '5.00',
  '31.85',
  '303.75',
  '3/11/16, 12:00:23 PM'),
 ('+37.35388229',
  '-122.10878137',
  '5.00',
  '31.58',
  '301.29',
  '3/11/16, 12:00:24 PM'),
 ('+37.35402763',
  '-122.10909116',
  '5.00',
  '31.67',
  '298.83',
  '3/11/16, 12:00:25 PM'),
 ('+37.35416275',
  '-122.10941512',
  '5.00',
  '31.82',
  '297.07',
  '3/11/16, 12:00:26 PM'),
 ('+37.35428500',
  '-122.10973833',
  '5.00',
  '31.86',
  '295.31',
  '3/11/16, 12:00:27 PM'),
 ('+37.35439853',
  '-122.11007210',
  '5.00',
  '31.97',
  '293.20',
  '3/11/16, 12:00:28 PM'),
 ('+37.35450989',
  '-122.11040469',
  '5.00',
  '32.15',
  '291.09',
  '3/11/16, 12:00:29 PM'),
 ('+37.35460422',
  '-122.11074625',
  '5.00',
  '32.24',
  '288.98',
  '3/11/16, 12:00:30 PM'),
 ('+37.35470108',
  '-122.11109678',
  '5.00',
  '32.26',
  '288.28',
  '3/11/16, 12:00:31 PM'),
 ('+37.35478615',
  '-122.11144128',
  '5.00',
  '32.37',
  '287.58',
  '3/11/16, 12:00:32 PM'),
 ('+37.35486926',
  '-122.11178469',
  '5.00',
  '32.50',
  '287.58',
  '3/11/16, 12:00:33 PM'),
 ('+37.35495920',
  '-122.11213723',
  '5.00',
  '32.48',
  '287.23',
  '3/11/16, 12:00:34 PM'),
 ('+37.35504792',
  '-122.11248818',
  '5.00',
  '32.56',
  '287.23',
  '3/11/16, 12:00:35 PM'),
 ('+37.35513836',
  '-122.11282957',
  '5.00',
  '32.55',
  '287.93',
  '3/11/16, 12:00:36 PM'),
 ('+37.35522226',
  '-122.11317885',
  '5.00',
  '32.24',
  '288.28',
  '3/11/16, 12:00:37 PM'),
 ('+37.35532071',
  '-122.11352779',
  '5.00',
  '32.42',
  '289.69',
  '3/11/16, 12:00:38 PM'),
 ('+37.35543424',
  '-122.11386968',
  '5.00',
  '32.46',
  '292.85',
  '3/11/16, 12:00:39 PM'),
 ('+37.35555758',
  '-122.11420421',
  '5.00',
  '32.28',
  '295.31',
  '3/11/16, 12:00:40 PM'),
 ('+37.35568444',
  '-122.11452423',
  '5.00',
  '32.09',
  '296.02',
  '3/11/16, 12:00:41 PM'),
 ('+37.35583234',
  '-122.11484701',
  '5.00',
  '32.58',
  '298.48',
  '3/11/16, 12:00:42 PM'),
 ('+37.35598347',
  '-122.11516142',
  '5.00',
  '32.32',
  '301.64',
  '3/11/16, 12:00:43 PM'),
 ('+37.35614335',
  '-122.11546778',
  '5.00',
  '32.62',
  '301.99',
  '3/11/16, 12:00:44 PM'),
 ('+37.35630592',
  '-122.11577145',
  '5.00',
  '32.72',
  '305.16',
  '3/11/16, 12:00:45 PM'),
 ('+37.35647419',
  '-122.11607907',
  '5.00',
  '32.53',
  '305.51',
  '3/11/16, 12:00:46 PM'),
 ('+37.35667204',
  '-122.11636489',
  '5.00',
  '32.76',
  '310.43',
  '3/11/16, 12:00:47 PM'),
 ('+37.35687073',
  '-122.11663286',
  '5.00',
  '33.00',
  '312.19',
  '3/11/16, 12:00:48 PM'),
 ('+37.35707534',
  '-122.11689874',
  '5.00',
  '32.78',
  '313.95',
  '3/11/16, 12:00:49 PM'),
 ('+37.35728082',
  '-122.11715581',
  '5.00',
  '32.38',
  '315.35',
  '3/11/16, 12:00:50 PM'),
 ('+37.35750030',
  '-122.11741087',
  '5.00',
  '32.58',
  '317.46',
  '3/11/16, 12:00:51 PM'),
 ('+37.35772158',
  '-122.11764607',
  '5.00',
  '32.78',
  '320.98',
  '3/11/16, 12:00:52 PM'),
 ('+37.35796495',
  '-122.11787221',
  '5.00',
  '33.40',
  '323.79',
  '3/11/16, 12:00:53 PM'),
 ('+37.35821377',
  '-122.11808519',
  '5.00',
  '33.51',
  '325.90',
  '3/11/16, 12:00:54 PM'),
 ('+37.35846644',
  '-122.11829223',
  '5.00',
  '33.70',
  '328.01',
  '3/11/16, 12:00:55 PM'),
 ('+37.35872263',
  '-122.11848501',
  '5.00',
  '33.80',
  '330.12',
  '3/11/16, 12:00:56 PM'),
 ('+37.35899450',
  '-122.11866179',
  '5.00',
  '34.06',
  '332.23',
  '3/11/16, 12:00:57 PM'),
 ('+37.35928216',
  '-122.11883998',
  '5.00',
  '34.42',
  '333.63',
  '3/11/16, 12:00:58 PM'),
 ('+37.35955814',
  '-122.11901575',
  '5.00',
  '34.59',
  '333.98',
  '3/11/16, 12:00:59 PM'),
 ('+37.35983897',
  '-122.11918616',
  '5.00',
  '34.77',
  '333.98',
  '3/11/16, 12:01:00 PM'),
 ('+37.36011952',
  '-122.11935530',
  '5.00',
  '35.00',
  '333.98',
  '3/11/16, 12:01:01 PM'),
 ('+37.36040727',
  '-122.11952001',
  '5.00',
  '35.10',
  '334.34',
  '3/11/16, 12:01:02 PM'),
 ('+37.36069305',
  '-122.11969553',
  '5.00',
  '35.13',
  '334.34',
  '3/11/16, 12:01:03 PM'),
 ('+37.36097430',
  '-122.11986677',
  '5.00',
  '35.10',
  '333.98',
  '3/11/16, 12:01:04 PM'),
 ('+37.36126096',
  '-122.12003751',
  '5.00',
  '34.90',
  '333.63',
  '3/11/16, 12:01:05 PM'),
 ('+37.36154377',
  '-122.12021730',
  '5.00',
  '34.65',
  '332.23',
  '3/11/16, 12:01:06 PM'),
 ('+37.36181958',
  '-122.12041830',
  '5.00',
  '34.65',
  '329.77',
  '3/11/16, 12:01:07 PM'),
 ('+37.36207862',
  '-122.12062282',
  '5.00',
  '34.69',
  '327.30',
  '3/11/16, 12:01:08 PM'),
 ('+37.36233305',
  '-122.12084385',
  '5.00',
  '34.25',
  '324.14',
  '3/11/16, 12:01:09 PM'),
 ('+37.36258266',
  '-122.12108055',
  '5.00',
  '34.47',
  '321.33',
  '3/11/16, 12:01:10 PM'),
 ('+37.36281941',
  '-122.12133444',
  '5.00',
  '34.29',
  '318.16',
  '3/11/16, 12:01:11 PM'),
 ('+37.36303768',
  '-122.12160442',
  '5.00',
  '34.35',
  '315.35',
  '3/11/16, 12:01:12 PM'),
 ('+37.36324345',
  '-122.12188572',
  '5.00',
  '34.09',
  '312.89',
  '3/11/16, 12:01:13 PM'),
 ('+37.36344328',
  '-122.12218294',
  '5.00',
  '33.75',
  '309.73',
  '3/11/16, 12:01:14 PM'),
 ('+37.36362588',
  '-122.12248745',
  '5.00',
  '33.39',
  '306.56',
  '3/11/16, 12:01:15 PM'),
 ('+37.36380169',
  '-122.12279364',
  '5.00',
  '33.18',
  '304.45',
  '3/11/16, 12:01:16 PM'),
 ('+37.36396061',
  '-122.12310285',
  '5.00',
  '32.94',
  '301.29',
  '3/11/16, 12:01:17 PM'),
 ('+37.36410876',
  '-122.12341793',
  '5.00',
  '32.74',
  '299.18',
  '3/11/16, 12:01:18 PM'),
 ('+37.36424153',
  '-122.12374717',
  '5.00',
  '32.83',
  '296.72',
  '3/11/16, 12:01:19 PM'),
 ('+37.36436332',
  '-122.12407817',
  '5.00',
  '32.76',
  '293.91',
  '3/11/16, 12:01:20 PM'),
 ('+37.36447237',
  '-122.12441747',
  '5.00',
  '32.89',
  '291.45',
  '3/11/16, 12:01:21 PM'),
 ('+37.36457081',
  '-122.12476867',
  '5.00',
  '33.08',
  '288.63',
  '3/11/16, 12:01:22 PM'),
 ('+37.36465673',
  '-122.12512859',
  '5.00',
  '33.13',
  '285.82',
  '3/11/16, 12:01:23 PM'),
 ('+37.36472923',
  '-122.12549681',
  '5.00',
  '33.43',
  '283.01',
  '3/11/16, 12:01:24 PM'),
 ('+37.36478840',
  '-122.12586327',
  '5.00',
  '33.50',
  '280.55',
  '3/11/16, 12:01:25 PM'),
 ('+37.36483488',
  '-122.12623861',
  '5.00',
  '33.57',
  '278.09',
  '3/11/16, 12:01:26 PM'),
 ('+37.36486694',
  '-122.12661646',
  '5.00',
  '33.59',
  '275.27',
  '3/11/16, 12:01:27 PM'),
 ('+37.36488463',
  '-122.12699926',
  '5.00',
  '33.47',
  '272.11',
  '3/11/16, 12:01:28 PM'),
 ('+37.36489573',
  '-122.12737863',
  '5.00',
  '33.61',
  '271.05',
  '3/11/16, 12:01:29 PM'),
 ('+37.36489494',
  '-122.12775531',
  '5.00',
  '33.61',
  '270.70',
  '3/11/16, 12:01:30 PM'),
 ('+37.36489561',
  '-122.12814457',
  '5.00',
  '33.60',
  '270.70',
  '3/11/16, 12:01:31 PM'),
 ('+37.36489536',
  '-122.12851823',
  '5.00',
  '33.32',
  '270.35',
  '3/11/16, 12:01:32 PM'),
 ('+37.36490102',
  '-122.12889651',
  '5.00',
  '33.43',
  '270.35',
  '3/11/16, 12:01:33 PM'),
 ('+37.36491300',
  '-122.12927755',
  '5.00',
  '33.43',
  '271.41',
  '3/11/16, 12:01:34 PM'),
 ('+37.36492641',
  '-122.12966111',
  '5.00',
  '33.30',
  '273.87',
  '3/11/16, 12:01:35 PM'),
 ('+37.36495642',
  '-122.13002966',
  '5.00',
  '33.15',
  '277.03',
  '3/11/16, 12:01:36 PM'),
 ('+37.36500231',
  '-122.13039762',
  '5.00',
  '33.25',
  '280.20',
  '3/11/16, 12:01:37 PM'),
 ('+37.36505801',
  '-122.13076299',
  '5.00',
  '33.16',
  '282.66',
  '3/11/16, 12:01:38 PM'),
 ('+37.36513495',
  '-122.13112023',
  '5.00',
  '33.14',
  '285.82',
  '3/11/16, 12:01:39 PM'),
 ('+37.36522619',
  '-122.13147671',
  '5.00',
  '33.13',
  '288.98',
  '3/11/16, 12:01:40 PM'),
 ('+37.36533088',
  '-122.13182204',
  '5.00',
  '33.17',
  '290.39',
  '3/11/16, 12:01:41 PM'),
 ('+37.36543834',
  '-122.13217241',
  '5.00',
  '33.19',
  '291.09',
  '3/11/16, 12:01:42 PM'),
 ('+37.36554852',
  '-122.13253006',
  '5.00',
  '33.49',
  '291.09',
  '3/11/16, 12:01:43 PM'),
 ('+37.36565505',
  '-122.13287858',
  '5.00',
  '33.39',
  '290.74',
  '3/11/16, 12:01:44 PM'),
 ('+37.36576171',
  '-122.13322476',
  '5.00',
  '33.35',
  '290.39',
  '3/11/16, 12:01:45 PM'),
 ('+37.36586640',
  '-122.13358057',
  '5.00',
  '33.38',
  '290.74',
  '3/11/16, 12:01:46 PM'),
 ('+37.36597474',
  '-122.13393420',
  '5.00',
  '33.02',
  '290.39',
  '3/11/16, 12:01:47 PM'),
 ('+37.36607239',
  '-122.13427694',
  '5.00',
  '32.69',
  '290.74',
  '3/11/16, 12:01:48 PM'),
 ('+37.36617599',
  '-122.13462026',
  '5.00',
  '32.15',
  '290.74',
  '3/11/16, 12:01:49 PM'),
 ('+37.36627984',
  '-122.13496408',
  '5.00',
  '32.03',
  '290.39',
  '3/11/16, 12:01:50 PM'),
 ('+37.36637342',
  '-122.13530514',
  '5.00',
  '32.12',
  '290.39',
  '3/11/16, 12:01:51 PM'),
 ('+37.36647610',
  '-122.13564763',
  '5.00',
  '32.20',
  '290.39',
  '3/11/16, 12:01:52 PM'),
 ('+37.36657341',
  '-122.13598643',
  '5.00',
  '32.22',
  '290.39',
  '3/11/16, 12:01:53 PM'),
 ('+37.36667454',
  '-122.13633075',
  '5.00',
  '32.17',
  '290.39',
  '3/11/16, 12:01:54 PM'),
 ('+37.36678250',
  '-122.13667173',
  '5.00',
  '32.27',
  '290.74',
  '3/11/16, 12:01:55 PM'),
 ('+37.36689180',
  '-122.13700784',
  '5.00',
  '32.41',
  '292.15',
  '3/11/16, 12:01:56 PM'),
 ('+37.36700588',
  '-122.13734664',
  '5.00',
  '32.54',
  '293.91',
  '3/11/16, 12:01:57 PM'),
 ('+37.36714083',
  '-122.13768569',
  '5.00',
  '32.98',
  '296.72',
  '3/11/16, 12:01:58 PM'),
 ('+37.36728357',
  '-122.13801602',
  '5.00',
  '33.12',
  '298.12',
  '3/11/16, 12:01:59 PM'),
 ('+37.36743034',
  '-122.13834434',
  '5.00',
  '33.46',
  '300.59',
  '3/11/16, 12:02:00 PM'),
 ('+37.36759001',
  '-122.13866201',
  '5.00',
  '33.73',
  '302.70',
  '3/11/16, 12:02:01 PM'),
 ('+37.36776176',
  '-122.13898061',
  '5.00',
  '33.89',
  '304.80',
  '3/11/16, 12:02:02 PM'),
 ('+37.36794754',
  '-122.13929619',
  '5.00',
  '34.14',
  '306.91',
  '3/11/16, 12:02:03 PM'),
 ('+37.36813371',
  '-122.13959391',
  '5.00',
  '34.03',
  '308.67',
  '3/11/16, 12:02:04 PM'),
 ('+37.36833646',
  '-122.13988803',
  '5.00',
  '34.30',
  '310.78',
  '3/11/16, 12:02:05 PM'),
 ('+37.36854278',
  '-122.14016740',
  '5.00',
  '34.22',
  '312.89',
  '3/11/16, 12:02:06 PM'),
 ('+37.36876231',
  '-122.14043713',
  '5.00',
  '34.36',
  '315.70',
  '3/11/16, 12:02:07 PM'),
 ('+37.36898397',
  '-122.14069152',
  '5.00',
  '34.00',
  '317.81',
  '3/11/16, 12:02:08 PM'),
 ('+37.36921459',
  '-122.14094005',
  '5.00',
  '34.04',
  '320.27',
  '3/11/16, 12:02:09 PM'),
 ('+37.36945654',
  '-122.14117960',
  '5.00',
  '33.99',
  '322.03',
  '3/11/16, 12:02:10 PM'),
 ('+37.36970590',
  '-122.14141823',
  '5.00',
  '33.90',
  '323.44',
  '3/11/16, 12:02:11 PM'),
 ('+37.36994839',
  '-122.14163390',
  '5.00',
  '34.01',
  '324.14',
  '3/11/16, 12:02:12 PM'),
 ('+37.37019243',
  '-122.14186189',
  '5.00',
  '33.82',
  '324.14',
  '3/11/16, 12:02:13 PM'),
 ('+37.37043777',
  '-122.14209172',
  '5.00',
  '33.88',
  '324.14',
  '3/11/16, 12:02:14 PM'),
 ('+37.37068524',
  '-122.14231367',
  '5.00',
  '33.45',
  '323.79',
  '3/11/16, 12:02:15 PM'),
 ('+37.37092857',
  '-122.14253931',
  '5.00',
  '33.73',
  '323.79',
  '3/11/16, 12:02:16 PM'),
 ('+37.37117332',
  '-122.14276269',
  '5.00',
  '33.71',
  '324.84',
  '3/11/16, 12:02:17 PM'),
 ('+37.37142067',
  '-122.14297886',
  '5.00',
  '33.47',
  '324.14',
  '3/11/16, 12:02:18 PM'),
 ('+37.37167049',
  '-122.14320232',
  '5.00',
  '33.53',
  '324.49',
  '3/11/16, 12:02:19 PM'),
 ('+37.37190954',
  '-122.14341883',
  '5.00',
  '33.17',
  '323.79',
  '3/11/16, 12:02:20 PM'),
 ('+37.37215601',
  '-122.14364204',
  '5.00',
  '33.14',
  '324.49',
  '3/11/16, 12:02:21 PM'),
 ('+37.37240005',
  '-122.14386038',
  '5.00',
  '33.14',
  '324.14',
  '3/11/16, 12:02:22 PM'),
 ('+37.37263743',
  '-122.14409064',
  '5.00',
  '33.07',
  '323.44',
  '3/11/16, 12:02:23 PM'),
 ('+37.37287229',
  '-122.14430781',
  '5.00',
  '33.28',
  '324.49',
  '3/11/16, 12:02:24 PM'),
 ('+37.37311268',
  '-122.14451887',
  '5.00',
  '33.18',
  '324.14',
  '3/11/16, 12:02:25 PM'),
 ('+37.37336271',
  '-122.14472699',
  '5.00',
  '33.53',
  '325.20',
  '3/11/16, 12:02:26 PM'),
 ('+37.37361371',
  '-122.14495984',
  '5.00',
  '33.61',
  '324.49',
  '3/11/16, 12:02:27 PM'),
 ('+37.37385134',
  '-122.14517802',
  '5.00',
  '33.55',
  '323.79',
  '3/11/16, 12:02:28 PM'),
 ('+37.37409077',
  '-122.14540877',
  '5.00',
  '33.67',
  '323.09',
  '3/11/16, 12:02:29 PM'),
 ('+37.37433481',
  '-122.14563986',
  '5.00',
  '33.67',
  '323.09',
  '3/11/16, 12:02:30 PM'),
 ('+37.37457281',
  '-122.14588663',
  '5.00',
  '33.98',
  '321.33',
  '3/11/16, 12:02:31 PM'),
 ('+37.37481249',
  '-122.14611939',
  '5.00',
  '34.05',
  '320.27',
  '3/11/16, 12:02:32 PM'),
 ('+37.37503792',
  '-122.14636347',
  '5.00',
  '33.99',
  '319.22',
  '3/11/16, 12:02:33 PM'),
 ('+37.37527039',
  '-122.14662055',
  '5.00',
  '34.10',
  '318.16',
  '3/11/16, 12:02:34 PM'),
 ('+37.37550207',
  '-122.14687494',
  '5.00',
  '34.21',
  '317.81',
  '3/11/16, 12:02:35 PM'),
 ('+37.37572427',
  '-122.14713511',
  '5.00',
  '34.32',
  '318.16',
  '3/11/16, 12:02:36 PM'),
 ('+37.37595557',
  '-122.14739872',
  '5.00',
  '34.41',
  '317.81',
  '3/11/16, 12:02:37 PM'),
 ('+37.37618545',
  '-122.14766024',
  '5.00',
  '34.35',
  '317.11',
  '3/11/16, 12:02:38 PM'),
 ('+37.37641444',
  '-122.14792309',
  '5.00',
  '34.08',
  '317.81',
  '3/11/16, 12:02:39 PM'),
 ('+37.37664016',
  '-122.14817958',
  '5.00',
  '34.08',
  '317.81',
  '3/11/16, 12:02:40 PM'),
 ('+37.37686895',
  '-122.14843858',
  '5.00',
  '34.17',
  '317.81',
  '3/11/16, 12:02:41 PM'),
 ('+37.37709618',
  '-122.14869624',
  '5.00',
  '33.59',
  '318.16',
  '3/11/16, 12:02:42 PM'),
 ('+37.37732484',
  '-122.14894979',
  '5.00',
  '33.48',
  '317.81',
  '3/11/16, 12:02:43 PM'),
 ('+37.37755308',
  '-122.14919429',
  '5.00',
  '33.76',
  '319.57',
  '3/11/16, 12:02:44 PM'),
 ('+37.37778312',
  '-122.14944148',
  '5.00',
  '33.76',
  '320.27',
  '3/11/16, 12:02:45 PM'),
 ('+37.37802720',
  '-122.14968145',
  '5.00',
  '34.04',
  '322.73',
  '3/11/16, 12:02:46 PM'),
 ('+37.37828075',
  '-122.14990349',
  '5.00',
  '33.93',
  '325.55',
  '3/11/16, 12:02:47 PM'),
 ('+37.37854172',
  '-122.15010976',
  '5.00',
  '33.94',
  '328.01',
  '3/11/16, 12:02:48 PM'),
 ('+37.37879540',
  '-122.15030297',
  '5.00',
  '33.74',
  '329.41',
  '3/11/16, 12:02:49 PM'),
 ('+37.37906991',
  '-122.15049139',
  '5.00',
  '33.75',
  '331.17',
  '3/11/16, 12:02:50 PM'),
 ('+37.37933964',
  '-122.15066314',
  '5.00',
  '33.62',
  '333.63',
  '3/11/16, 12:02:51 PM'),
 ('+37.37961188',
  '-122.15082139',
  '5.00',
  '33.85',
  '336.09',
  '3/11/16, 12:02:52 PM'),
 ('+37.37989138',
  '-122.15096748',
  '5.00',
  '33.97',
  '338.20',
  '3/11/16, 12:02:53 PM'),
 ('+37.38018479',
  '-122.15110721',
  '5.00',
  '34.27',
  '340.66',
  '3/11/16, 12:02:54 PM'),
 ('+37.38048092',
  '-122.15123277',
  '5.00',
  '34.49',
  '342.42',
  '3/11/16, 12:02:55 PM'),
 ('+37.38078049',
  '-122.15133956',
  '5.00',
  '34.73',
  '344.18',
  '3/11/16, 12:02:56 PM'),
 ('+37.38107985',
  '-122.15143117',
  '5.00',
  '34.98',
  '346.64',
  '3/11/16, 12:02:57 PM'),
 ('+37.38139635',
  '-122.15151398',
  '5.00',
  '35.01',
  '349.10',
  '3/11/16, 12:02:58 PM'),
 ('+37.38170908',
  '-122.15158724',
  '5.00',
  '35.16',
  '349.80',
  '3/11/16, 12:02:59 PM'),
 ('+37.38201841',
  '-122.15165690',
  '5.00',
  '35.16',
  '349.80',
  '3/11/16, 12:03:00 PM'),
 ('+37.38232167',
  '-122.15171758',
  '5.00',
  '35.00',
  '350.16',
  '3/11/16, 12:03:01 PM'),
 ('+37.38263980',
  '-122.15178036',
  '5.00',
  '34.97',
  '350.51',
  '3/11/16, 12:03:02 PM'),
 ('+37.38294604',
  '-122.15184264',
  '5.00',
  '34.62',
  '350.86',
  '3/11/16, 12:03:03 PM'),
 ('+37.38325235',
  '-122.15190458',
  '5.00',
  '34.39',
  '350.51',
  '3/11/16, 12:03:04 PM'),
 ('+37.38355637',
  '-122.15196543',
  '5.00',
  '34.44',
  '350.51',
  '3/11/16, 12:03:05 PM'),
 ('+37.38386583',
  '-122.15203945',
  '5.00',
  '34.13',
  '349.45',
  '3/11/16, 12:03:06 PM'),
 ('+37.38417047',
  '-122.15211170',
  '5.00',
  '34.13',
  '349.45',
  '3/11/16, 12:03:07 PM'),
 ('+37.38447544',
  '-122.15220080',
  '5.00',
  '34.65',
  '347.70',
  '3/11/16, 12:03:08 PM'),
 ('+37.38475950',
  '-122.15231454',
  '5.00',
  '34.06',
  '344.18',
  '3/11/16, 12:03:09 PM'),
 ('+37.38505698',
  '-122.15241395',
  '5.00',
  '33.77',
  '344.53',
  '3/11/16, 12:03:10 PM'),
 ('+37.38535940',
  '-122.15250213',
  '5.00',
  '33.75',
  '345.59',
  '3/11/16, 12:03:11 PM'),
 ('+37.38560981',
  '-122.15272559',
  '5.00',
  '33.44',
  '335.74',
  '3/11/16, 12:03:12 PM'),
 ('+37.38587685',
  '-122.15289608',
  '5.00',
  '33.01',
  '331.88',
  '3/11/16, 12:03:13 PM'),
 ('+37.38612831',
  '-122.15307537',
  '5.00',
  '32.94',
  '330.82',
  '3/11/16, 12:03:14 PM'),
 ('+37.38636900',
  '-122.15330226',
  '5.00',
  '32.43',
  '325.20',
  '3/11/16, 12:03:15 PM'),
 ('+37.38660109',
  '-122.15352321',
  '5.00',
  '32.22',
  '322.03',
  '3/11/16, 12:03:16 PM'),
 ('+37.38681491',
  '-122.15376042',
  '5.00',
  '31.96',
  '318.16',
  '3/11/16, 12:03:17 PM'),
 ('+37.38703695',
  '-122.15399578',
  '5.00',
  '31.83',
  '315.35',
  '3/11/16, 12:03:18 PM'),
 ('+37.38723661',
  '-122.15426073',
  '5.00',
  '31.79',
  '313.24',
  '3/11/16, 12:03:19 PM'),
 ('+37.38741594',
  '-122.15453155',
  '5.00',
  '31.67',
  '310.43',
  '3/11/16, 12:03:20 PM'),
 ('+37.38758433',
  '-122.15481075',
  '5.00',
  '31.64',
  '307.27',
  '3/11/16, 12:03:21 PM'),
 ('+37.38774539',
  '-122.15510789',
  '5.00',
  '31.84',
  '304.45',
  '3/11/16, 12:03:22 PM'),
 ('+37.38789928',
  '-122.15540746',
  '5.00',
  '31.69',
  '300.94',
  '3/11/16, 12:03:23 PM'),
 ('+37.38803876',
  '-122.15572505',
  '5.00',
  '31.75',
  '298.12',
  '3/11/16, 12:03:24 PM'),
 ('+37.38816025',
  '-122.15604700',
  '5.00',
  '31.80',
  '295.31',
  '3/11/16, 12:03:25 PM'),
 ('+37.38827425',
  '-122.15637750',
  '5.00',
  '31.93',
  '292.15',
  '3/11/16, 12:03:26 PM'),
 ('+37.38837114',
  '-122.15672040',
  '5.00',
  '31.93',
  '288.98',
  '3/11/16, 12:03:27 PM'),
 ('+37.38845823',
  '-122.15706146',
  '5.00',
  '31.89',
  '286.17',
  '3/11/16, 12:03:28 PM'),
 ('+37.38852302',
  '-122.15740629',
  '5.00',
  '32.12',
  '283.36',
  '3/11/16, 12:03:29 PM'),
 ('+37.38858496',
  '-122.15776739',
  '5.00',
  '32.31',
  '281.25',
  '3/11/16, 12:03:30 PM'),
 ('+37.38863873',
  '-122.15813200',
  '5.00',
  '32.54',
  '280.55',
  '3/11/16, 12:03:31 PM'),
 ('+37.38869141',
  '-122.15849049',
  '5.00',
  '32.54',
  '280.55',
  '3/11/16, 12:03:32 PM'),
 ('+37.38875059',
  '-122.15884924',
  '5.00',
  '32.62',
  '280.20',
  '3/11/16, 12:03:33 PM'),
 ('+37.38880101',
  '-122.15921670',
  '5.00',
  '32.60',
  '279.84',
  '3/11/16, 12:03:34 PM'),
 ('+37.38885423',
  '-122.15958014',
  '5.00',
  '32.77',
  '280.55',
  '3/11/16, 12:03:35 PM'),
 ('+37.38890729',
  '-122.15994434',
  '5.00',
  '32.94',
  '280.55',
  '3/11/16, 12:03:36 PM'),
 ('+37.38896215',
  '-122.16030945',
  '5.00',
  '32.76',
  '280.55',
  '3/11/16, 12:03:37 PM'),
 ('+37.38901726',
  '-122.16067063',
  '5.00',
  '32.51',
  '280.90',
  '3/11/16, 12:03:38 PM'),
 ('+37.38907593',
  '-122.16102912',
  '5.00',
  '32.47',
  '282.66',
  '3/11/16, 12:03:39 PM'),
 ('+37.38913788',
  '-122.16138829',
  '5.00',
  '32.34',
  '284.77',
  '3/11/16, 12:03:40 PM'),
 ('+37.38921159',
  '-122.16173186',
  '5.00',
  '32.27',
  '285.82',
  '3/11/16, 12:03:41 PM'),
 ('+37.38931302',
  '-122.16207476',
  '5.00',
  '32.50',
  '290.04',
  '3/11/16, 12:03:42 PM'),
 ('+37.38941926',
  '-122.16241959',
  '5.00',
  '32.48',
  '292.50',
  '3/11/16, 12:03:43 PM'),
 ('+37.38952910',
  '-122.16275705',
  '5.00',
  '32.48',
  '294.96',
  '3/11/16, 12:03:44 PM'),
 ('+37.38966543',
  '-122.16308369',
  '5.00',
  '32.49',
  '297.07',
  '3/11/16, 12:03:45 PM'),
 ('+37.38980415',
  '-122.16341017',
  '5.00',
  '32.35',
  '298.83',
  '3/11/16, 12:03:46 PM'),
 ('+37.38995968',
  '-122.16372751',
  '5.00',
  '32.27',
  '301.64',
  '3/11/16, 12:03:47 PM'),
 ('+37.39012296',
  '-122.16403110',
  '5.00',
  '32.15',
  '303.75',
  '3/11/16, 12:03:48 PM'),
 ('+37.39029043',
  '-122.16432732',
  '5.00',
  '32.51',
  '304.80',
  '3/11/16, 12:03:49 PM'),
 ('+37.39046125',
  '-122.16462739',
  '5.00',
  '33.08',
  '305.86',
  '3/11/16, 12:03:50 PM'),
 ('+37.39063719',
  '-122.16493601',
  '5.00',
  '33.54',
  '306.56',
  '3/11/16, 12:03:51 PM'),
 ('+37.39081987',
  '-122.16524270',
  '5.00',
  '33.66',
  '306.21',
  '3/11/16, 12:03:52 PM'),
 ('+37.39099698',
  '-122.16555409',
  '5.00',
  '33.82',
  '306.21',
  '3/11/16, 12:03:53 PM'),
 ('+37.39117204',
  '-122.16586866',
  '5.00',
  '33.86',
  '305.51',
  '3/11/16, 12:03:54 PM'),
 ('+37.39135120',
  '-122.16618625',
  '5.00',
  '33.78',
  '302.70',
  '3/11/16, 12:03:55 PM'),
 ('+37.39150270',
  '-122.16651214',
  '5.00',
  '33.55',
  '299.53',
  '3/11/16, 12:03:56 PM'),
 ('+37.39163715',
  '-122.16684775',
  '5.00',
  '33.81',
  '295.66',
  '3/11/16, 12:03:57 PM'),
 ('+37.39176380',
  '-122.16719669',
  '5.00',
  '33.76',
  '292.85',
  '3/11/16, 12:03:58 PM'),
 ('+37.39187260',
  '-122.16754831',
  '5.00',
  '33.56',
  '290.04',
  '3/11/16, 12:03:59 PM'),
 ('+37.39195948',
  '-122.16790371',
  '5.00',
  '33.32',
  '287.58',
  '3/11/16, 12:04:00 PM'),
 ('+37.39203734',
  '-122.16826622',
  '5.00',
  '33.12',
  '284.41',
  '3/11/16, 12:04:01 PM'),
 ('+37.39210109',
  '-122.16863067',
  '5.00',
  '33.03',
  '281.95',
  '3/11/16, 12:04:02 PM'),
 ('+37.39215096',
  '-122.16899562',
  '5.00',
  '32.66',
  '278.44',
  '3/11/16, 12:04:03 PM'),
 ('+37.39218696',
  '-122.16936325',
  '5.00',
  '32.58',
  '275.98',
  '3/11/16, 12:04:04 PM'),
 ('+37.39221512',
  '-122.16972115',
  '5.00',
  '32.60',
  '274.57',
  '3/11/16, 12:04:05 PM'),
 ('+37.39223168',
  '-122.17009373',
  '5.00',
  '32.52',
  '274.22',
  '3/11/16, 12:04:06 PM'),
 ('+37.39225456',
  '-122.17045658',
  '5.00',
  '32.61',
  '274.57',
  '3/11/16, 12:04:07 PM'),
 ('+37.39228038',
  '-122.17082706',
  '5.00',
  '32.92',
  '274.92',
  '3/11/16, 12:04:08 PM'),
 ('+37.39229995',
  '-122.17118816',
  '5.00',
  '32.63',
  '274.92',
  '3/11/16, 12:04:09 PM'),
 ('+37.39232727',
  '-122.17156408',
  '5.00',
  '32.51',
  '275.98',
  '3/11/16, 12:04:10 PM'),
 ('+37.39236730',
  '-122.17192878',
  '5.00',
  '32.40',
  '278.44',
  '3/11/16, 12:04:11 PM'),
 ('+37.39242056',
  '-122.17227965',
  '5.00',
  '32.30',
  '281.25',
  '3/11/16, 12:04:12 PM'),
 ('+37.39248364',
  '-122.17262850',
  '5.00',
  '32.25',
  '283.36',
  '3/11/16, 12:04:13 PM'),
 ('+37.39256301',
  '-122.17298624',
  '5.00',
  '32.26',
  '285.82',
  '3/11/16, 12:04:14 PM'),
 ('+37.39265140',
  '-122.17333149',
  '5.00',
  '32.26',
  '288.63',
  '3/11/16, 12:04:15 PM'),
 ('+37.39275592',
  '-122.17367289',
  '5.00',
  '32.32',
  '291.45',
  '3/11/16, 12:04:16 PM'),
 ('+37.39286883',
  '-122.17400749',
  '5.00',
  '32.29',
  '293.55',
  '3/11/16, 12:04:17 PM'),
 ('+37.39299238',
  '-122.17434528',
  '5.00',
  '32.41',
  '296.02',
  '3/11/16, 12:04:18 PM'),
 ('+37.39312741',
  '-122.17466882',
  '5.00',
  '32.30',
  '298.83',
  '3/11/16, 12:04:19 PM'),
 ('+37.39327728',
  '-122.17497485',
  '5.00',
  '32.30',
  '301.99',
  '3/11/16, 12:04:20 PM'),
 ('+37.39343838',
  '-122.17526897',
  '5.00',
  '32.38',
  '304.80',
  '3/11/16, 12:04:21 PM'),
 ('+37.39361482',
  '-122.17556879',
  '5.00',
  '32.38',
  '306.91',
  '3/11/16, 12:04:22 PM'),
 ('+37.39379704',
  '-122.17585612',
  '5.00',
  '32.34',
  '309.02',
  '3/11/16, 12:04:23 PM'),
 ('+37.39398630',
  '-122.17612996',
  '5.00',
  '32.59',
  '311.84',
  '3/11/16, 12:04:24 PM'),
 ('+37.39418919',
  '-122.17640321',
  '5.00',
  '32.44',
  '314.30',
  '3/11/16, 12:04:25 PM'),
 ('+37.39440066',
  '-122.17665986',
  '5.00',
  '32.57',
  '317.11',
  '3/11/16, 12:04:26 PM'),
 ('+37.39462396',
  '-122.17690042',
  '5.00',
  '32.40',
  '319.92',
  '3/11/16, 12:04:27 PM'),
 ('+37.39485119',
  '-122.17713419',
  '5.00',
  '32.60',
  '320.62',
  '3/11/16, 12:04:28 PM'),
 ('+37.39507930',
  '-122.17736604',
  '5.00',
  '32.94',
  '321.33',
  '3/11/16, 12:04:29 PM'),
 ('+37.39531442',
  '-122.17760140',
  '5.00',
  '33.11',
  '322.03',
  '3/11/16, 12:04:30 PM'),
 ('+37.39555665',
  '-122.17782746',
  '5.00',
  '33.22',
  '322.38',
  '3/11/16, 12:04:31 PM'),
 ('+37.39578711',
  '-122.17805511',
  '5.00',
  '33.14',
  '322.03',
  '3/11/16, 12:04:32 PM'),
 ('+37.39602298',
  '-122.17827723',
  '5.00',
  '33.26',
  '322.03',
  '3/11/16, 12:04:33 PM'),
 ('+37.39626220',
  '-122.17851528',
  '5.00',
  '33.46',
  '322.03',
  '3/11/16, 12:04:34 PM'),
 ('+37.39650092',
  '-122.17874520',
  '5.00',
  '33.73',
  '321.68',
  '3/11/16, 12:04:35 PM'),
 ('+37.39674290',
  '-122.17897754',
  '5.00',
  '34.05',
  '321.68',
  '3/11/16, 12:04:36 PM'),
 ('+37.39698455',
  '-122.17921131',
  '5.00',
  '34.33',
  '321.68',
  '3/11/16, 12:04:37 PM'),
 ('+37.39723081',
  '-122.17945213',
  '5.00',
  '34.62',
  '322.03',
  '3/11/16, 12:04:38 PM'),
 ('+37.39747477',
  '-122.17969227',
  '5.00',
  '34.80',
  '321.68',
  '3/11/16, 12:04:39 PM'),
 ('+37.39771939',
  '-122.17994381',
  '5.00',
  '34.93',
  '321.33',
  '3/11/16, 12:04:40 PM'),
 ('+37.39796347',
  '-122.18018889',
  '5.00',
  '34.88',
  '321.33',
  '3/11/16, 12:04:41 PM'),
 ('+37.39821434',
  '-122.18044236',
  '5.00',
  '35.09',
  '321.68',
  '3/11/16, 12:04:42 PM'),
 ('+37.39846630',
  '-122.18069307',
  '5.00',
  '35.32',
  '322.03',
  '3/11/16, 12:04:43 PM'),
 ('+37.39871722',
  '-122.18093396',
  '5.00',
  '35.41',
  '322.03',
  '3/11/16, 12:04:44 PM'),
 ('+37.39896494',
  '-122.18117586',
  '5.00',
  '35.40',
  '322.03',
  '3/11/16, 12:04:45 PM'),
 ('+37.39921816',
  '-122.18142380',
  '5.00',
  '35.33',
  '321.68',
  '3/11/16, 12:04:46 PM'),
 ('+37.39946853',
  '-122.18167400',
  '5.00',
  '35.58',
  '322.38',
  '3/11/16, 12:04:47 PM'),
 ('+37.39971672',
  '-122.18192127',
  '5.00',
  '35.22',
  '321.68',
  '3/11/16, 12:04:48 PM'),
 ('+37.39996889',
  '-122.18216065',
  '5.00',
  '34.97',
  '321.68',
  '3/11/16, 12:04:49 PM'),
 ('+37.40021150',
  '-122.18241295',
  '5.00',
  '34.94',
  '320.98',
  '3/11/16, 12:04:50 PM'),
 ('+37.40046241',
  '-122.18266432',
  '5.00',
  '34.92',
  '321.33',
  '3/11/16, 12:04:51 PM'),
 ('+37.40071157',
  '-122.18290622',
  '5.00',
  '35.04',
  '320.98',
  '3/11/16, 12:04:52 PM'),
 ('+37.40095900',
  '-122.18315500',
  '5.00',
  '35.04',
  '320.62',
  '3/11/16, 12:04:53 PM'),
 ('+37.40120241',
  '-122.18340059',
  '5.00',
  '34.97',
  '320.62',
  '3/11/16, 12:04:54 PM'),
 ('+37.40145169',
  '-122.18364475',
  '5.00',
  '34.88',
  '320.98',
  '3/11/16, 12:04:55 PM'),
 ('+37.40169564',
  '-122.18389160',
  '5.00',
  '34.80',
  '320.98',
  '3/11/16, 12:04:56 PM'),
 ('+37.40193507',
  '-122.18412948',
  '5.00',
  '34.75',
  '320.98',
  '3/11/16, 12:04:57 PM'),
 ('+37.40217513',
  '-122.18438102',
  '5.00',
  '34.63',
  '320.98',
  '3/11/16, 12:04:58 PM'),
 ('+37.40241452',
  '-122.18462099',
  '5.00',
  '34.45',
  '320.98',
  '3/11/16, 12:04:59 PM'),
 ('+37.40265001',
  '-122.18486407',
  '5.00',
  '34.25',
  '320.98',
  '3/11/16, 12:05:00 PM'),
 ('+37.40289006',
  '-122.18510882',
  '5.00',
  '34.17',
  '320.98',
  '3/11/16, 12:05:01 PM'),
 ('+37.40313012',
  '-122.18535374',
  '5.00',
  '34.12',
  '321.33',
  '3/11/16, 12:05:02 PM'),
 ('+37.40336963',
  '-122.18558910',
  '5.00',
  '34.12',
  '321.33',
  '3/11/16, 12:05:03 PM'),
 ('+37.40360986',
  '-122.18583235',
  '5.00',
  '34.11',
  '321.33',
  '3/11/16, 12:05:04 PM'),
 ('+37.40384703',
  '-122.18606520',
  '5.00',
  '34.08',
  '321.68',
  '3/11/16, 12:05:05 PM'),
 ('+37.40408658',
  '-122.18630827',
  '5.00',
  '34.00',
  '321.33',
  '3/11/16, 12:05:06 PM'),
 ('+37.40432366',
  '-122.18655336',
  '5.00',
  '33.89',
  '320.62',
  '3/11/16, 12:05:07 PM'),
 ('+37.40455890',
  '-122.18679358',
  '5.00',
  '33.83',
  '320.62',
  '3/11/16, 12:05:08 PM'),
 ('+37.40479565',
  '-122.18703280',
  '5.00',
  '33.53',
  '320.98',
  '3/11/16, 12:05:09 PM'),
 ('+37.40503252',
  '-122.18726691',
  '5.00',
  '33.50',
  '320.98',
  '3/11/16, 12:05:10 PM'),
 ('+37.40526516',
  '-122.18750898',
  '5.00',
  '33.26',
  '320.62',
  '3/11/16, 12:05:11 PM'),
 ('+37.40549529',
  '-122.18774837',
  '5.00',
  '33.18',
  '321.33',
  '3/11/16, 12:05:12 PM'),
 ('+37.40572269',
  '-122.18797644',
  '5.00',
  '33.13',
  '320.98',
  '3/11/16, 12:05:13 PM'),
 ('+37.40595558',
  '-122.18821616',
  '5.00',
  '33.07',
  '320.98',
  '3/11/16, 12:05:14 PM'),
 ('+37.40618700',
  '-122.18845228',
  '5.00',
  '32.96',
  '319.92',
  '3/11/16, 12:05:15 PM'),
 ('+37.40641352',
  '-122.18869619',
  '5.00',
  '32.90',
  '318.16',
  '3/11/16, 12:05:16 PM'),
 ('+37.40662722',
  '-122.18894731',
  '5.00',
  '32.73',
  '316.76',
  '3/11/16, 12:05:17 PM'),
 ('+37.40684142',
  '-122.18921084',
  '5.00',
  '32.72',
  '314.65',
  '3/11/16, 12:05:18 PM'),
 ('+37.40704434',
  '-122.18948518',
  '5.00',
  '32.59',
  '312.19',
  '3/11/16, 12:05:19 PM'),
 ('+37.40723826',
  '-122.18975642',
  '5.00',
  '32.64',
  '310.08',
  '3/11/16, 12:05:20 PM'),
 ('+37.40741516',
  '-122.19004383',
  '5.00',
  '32.44',
  '307.97',
  '3/11/16, 12:05:21 PM'),
 ('+37.40759705',
  '-122.19035128',
  '5.00',
  '32.41',
  '306.21',
  '3/11/16, 12:05:22 PM'),
 ('+37.40776758',
  '-122.19065295',
  '5.00',
  '32.48',
  '304.45',
  '3/11/16, 12:05:23 PM'),
 ('+37.40792864',
  '-122.19096048',
  '5.00',
  '32.40',
  '302.34',
  '3/11/16, 12:05:24 PM'),
 ('+37.40807192',
  '-122.19127153',
  '5.00',
  '32.36',
  '300.23',
  '3/11/16, 12:05:25 PM'),
 ('+37.40821220',
  '-122.19160295',
  '5.00',
  '32.36',
  '298.12',
  '3/11/16, 12:05:26 PM'),
 ('+37.40834241',
  '-122.19193731',
  '5.00',
  '32.36',
  '296.02',
  '3/11/16, 12:05:27 PM'),
 ('+37.40846332',
  '-122.19227342',
  '5.00',
  '32.48',
  '294.61',
  '3/11/16, 12:05:28 PM'),
 ('+37.40857710',
  '-122.19260911',
  '5.00',
  '32.75',
  '292.85',
  '3/11/16, 12:05:29 PM'),
 ('+37.40868950',
  '-122.19295621',
  '5.00',
  '33.01',
  '292.15',
  '3/11/16, 12:05:30 PM'),
 ('+37.40879583',
  '-122.19330498',
  '5.00',
  '33.12',
  '291.80',
  '3/11/16, 12:05:31 PM'),
 ('+37.40890928',
  '-122.19364872',
  '5.00',
  '33.19',
  '291.80',
  '3/11/16, 12:05:32 PM'),
 ('+37.40901740',
  '-122.19399146',
  '5.00',
  '33.26',
  '291.45',
  '3/11/16, 12:05:33 PM'),
 ('+37.40913001',
  '-122.19434853',
  '5.00',
  '33.41',
  '291.80',
  '3/11/16, 12:05:34 PM'),
 ('+37.40924065',
  '-122.19469587',
  '5.00',
  '33.01',
  '291.09',
  '3/11/16, 12:05:35 PM'),
 ('+37.40934673',
  '-122.19504967',
  '5.00',
  '33.39',
  '291.80',
  '3/11/16, 12:05:36 PM'),
 ('+37.40945674',
  '-122.19540213',
  '5.00',
  '33.35',
  '291.45',
  '3/11/16, 12:05:37 PM'),
 ('+37.40957019',
  '-122.19575593',
  '5.00',
  '33.38',
  '291.80',
  '3/11/16, 12:05:38 PM'),
 ('+37.40968519',
  '-122.19611107',
  '5.00',
  '33.50',
  '291.80',
  '3/11/16, 12:05:39 PM'),
 ('+37.40979918',
  '-122.19646479',
  '5.00',
  '33.58',
  '291.80',
  '3/11/16, 12:05:40 PM'),
 ('+37.40991313',
  '-122.19680962',
  '5.00',
  '33.80',
  '291.80',
  '3/11/16, 12:05:41 PM'),
 ('+37.41002813',
  '-122.19717013',
  '5.00',
  '33.85',
  '291.80',
  '3/11/16, 12:05:42 PM'),
 ('+37.41013974',
  '-122.19752560',
  '5.00',
  '33.93',
  '291.80',
  '3/11/16, 12:05:43 PM'),
 ('+37.41025751',
  '-122.19788477',
  '5.00',
  '34.04',
  '291.80',
  '3/11/16, 12:05:44 PM'),
 ('+37.41036953',
  '-122.19824251',
  '5.00',
  '34.11',
  '291.80',
  '3/11/16, 12:05:45 PM'),
 ('+37.41048306',
  '-122.19859798',
  '5.00',
  '34.26',
  '291.80',
  '3/11/16, 12:05:46 PM'),
 ('+37.41059111',
  '-122.19895765',
  '5.00',
  '34.26',
  '291.45',
  '3/11/16, 12:05:47 PM'),
 ('+37.41070502',
  '-122.19932176',
  '5.00',
  '34.71',
  '291.80',
  '3/11/16, 12:05:48 PM'),
 ('+37.41082094',
  '-122.19968311',
  '5.00',
  '34.81',
  '291.80',
  '3/11/16, 12:05:49 PM'),
 ('+37.41093715',
  '-122.20005677',
  '5.00',
  '34.85',
  '291.45',
  '3/11/16, 12:05:50 PM'),
 ('+37.41105102',
  '-122.20042583',
  '5.00',
  '34.79',
  '291.45',
  '3/11/16, 12:05:51 PM'),
 ('+37.41116820',
  '-122.20078524',
  '5.00',
  '34.82',
  '291.80',
  '3/11/16, 12:05:52 PM'),
 ('+37.41128521',
  '-122.20114273',
  '5.00',
  '34.79',
  '291.80',
  '3/11/16, 12:05:53 PM'),
 ('+37.41140537',
  '-122.20150659',
  '5.00',
  '34.80',
  '291.80',
  '3/11/16, 12:05:54 PM'),
 ('+37.41152166',
  '-122.20187338',
  '5.00',
  '34.93',
  '292.15',
  '3/11/16, 12:05:55 PM'),
 ('+37.41163599',
  '-122.20224059',
  '5.00',
  '34.77',
  '291.80',
  '3/11/16, 12:05:56 PM'),
 ('+37.41175460',
  '-122.20260026',
  '5.00',
  '34.73',
  '291.45',
  '3/11/16, 12:05:57 PM'),
 ('+37.41187169',
  '-122.20296881',
  '5.00',
  '34.81',
  '291.80',
  '3/11/16, 12:05:58 PM'),
 ('+37.41198812',
  '-122.20333192',
  '5.00',
  '34.75',
  '291.45',
  '3/11/16, 12:05:59 PM'),
 ('+37.41210932',
  '-122.20369519',
  '5.00',
  '34.73',
  '291.45',
  '3/11/16, 12:06:00 PM'),
 ('+37.41221975',
  '-122.20406123',
  '5.00',
  '34.82',
  '291.45',
  '3/11/16, 12:06:01 PM'),
 ('+37.41233794',
  '-122.20442475',
  '5.00',
  '34.65',
  '291.80',
  '3/11/16, 12:06:02 PM'),
 ('+37.41245025',
  '-122.20479062',
  '5.00',
  '34.57',
  '291.80',
  '3/11/16, 12:06:03 PM'),
 ('+37.41256089',
  '-122.20514618',
  '5.00',
  '34.47',
  '291.45',
  '3/11/16, 12:06:04 PM'),
 ('+37.41267200',
  '-122.20550149',
  '5.00',
  '34.43',
  '291.80',
  '3/11/16, 12:06:05 PM'),
 ('+37.41278750',
  '-122.20586509',
  '5.00',
  '34.42',
  '291.80',
  '3/11/16, 12:06:06 PM'),
 ('+37.41290506',
  '-122.20622074',
  '5.00',
  '34.30',
  '292.15',
  '3/11/16, 12:06:07 PM'),
 ('+37.41302483',
  '-122.20658359',
  '5.00',
  '34.32',
  '293.55',
  '3/11/16, 12:06:08 PM'),
 ('+37.41316012',
  '-122.20691443',
  '5.00',
  '34.19',
  '296.02',
  '3/11/16, 12:06:09 PM'),
 ('+37.41331028',
  '-122.20726311',
  '5.00',
  '34.17',
  '298.48',
  '3/11/16, 12:06:10 PM'),
 ('+37.41347243',
  '-122.20759654',
  '5.00',
  '34.20',
  '301.29',
  '3/11/16, 12:06:11 PM'),
 ('+37.41363889',
  '-122.20791833',
  '5.00',
  '34.26',
  '303.75',
  '3/11/16, 12:06:12 PM'),
 ('+37.41381696',
  '-122.20823265',
  '5.00',
  '34.20',
  '306.56',
  '3/11/16, 12:06:13 PM'),
 ('+37.41401360',
  '-122.20853406',
  '5.00',
  '34.08',
  '309.02',
  '3/11/16, 12:06:14 PM'),
 ('+37.41421573',
  '-122.20883313',
  '5.00',
  '34.52',
  '311.84',
  '3/11/16, 12:06:15 PM'),
 ('+37.41442675',
  '-122.20911895',
  '5.00',
  '34.31',
  '314.30',
  '3/11/16, 12:06:16 PM'),
 ('+37.41464292',
  '-122.20938734',
  '5.00',
  '34.26',
  '316.76',
  '3/11/16, 12:06:17 PM'),
 ('+37.41487543',
  '-122.20964810',
  '5.00',
  '34.35',
  '318.87',
  '3/11/16, 12:06:18 PM'),
 ('+37.41511369',
  '-122.20990190',
  '5.00',
  '34.21',
  '320.98',
  '3/11/16, 12:06:19 PM'),
 ('+37.41535131',
  '-122.21013769',
  '5.00',
  '34.26',
  '321.33',
  '3/11/16, 12:06:20 PM'),
 ('+37.41558768',
  '-122.21037783',
  '5.00',
  '34.20',
  '321.33',
  '3/11/16, 12:06:21 PM'),
 ('+37.41583072',
  '-122.21062040',
  '5.00',
  '34.20',
  '321.33',
  '3/11/16, 12:06:22 PM'),
 ('+37.41606407',
  '-122.21084956',
  '5.00',
  '33.70',
  '321.33',
  '3/11/16, 12:06:23 PM'),
 ('+37.41629629',
  '-122.21107403',
  '5.00',
  '33.64',
  '319.57',
  '3/11/16, 12:06:24 PM'),
 ('+37.41652076',
  '-122.21132892',
  '5.00',
  '33.46',
  '317.11',
  '3/11/16, 12:06:25 PM'),
 ('+37.41674342',
  '-122.21159681',
  '5.00',
  '33.44',
  '314.65',
  '3/11/16, 12:06:26 PM'),
 ('+37.41694823',
  '-122.21186670',
  '5.00',
  '33.17',
  '312.54',
  '3/11/16, 12:06:27 PM'),
 ('+37.41715007',
  '-122.21215672',
  '5.00',
  '33.26',
  '310.08',
  '3/11/16, 12:06:28 PM'),
 ('+37.41733217',
  '-122.21244011',
  '5.00',
  '33.15',
  '307.97',
  '3/11/16, 12:06:29 PM'),
 ('+37.41751498',
  '-122.21274345',
  '5.00',
  '33.08',
  '305.51',
  '3/11/16, 12:06:30 PM'),
 ('+37.41767838',
  '-122.21305870',
  '5.00',
  '32.98',
  '302.70',
  '3/11/16, 12:06:31 PM'),
 ('+37.41782917',
  '-122.21338064',
  '5.00',
  '32.82',
  '299.88',
  '3/11/16, 12:06:32 PM'),
 ('+37.41796601',
  '-122.21370276',
  '5.00',
  '32.69',
  '298.12',
  '3/11/16, 12:06:33 PM'),
 ('+37.41809689',
  '-122.21404449',
  '5.00',
  '32.75',
  '295.66',
  '3/11/16, 12:06:34 PM'),
 ('+37.41821562',
  '-122.21438304',
  '5.00',
  '32.70',
  '293.55',
  '3/11/16, 12:06:35 PM'),
 ('+37.41832178',
  '-122.21472125',
  '5.00',
  '32.57',
  '290.74',
  '3/11/16, 12:06:36 PM'),
 ('+37.41841264',
  '-122.21506373',
  '5.00',
  '32.38',
  '287.93',
  '3/11/16, 12:06:37 PM'),
 ('+37.41849109',
  '-122.21541158',
  '5.00',
  '32.22',
  '285.47',
  '3/11/16, 12:06:38 PM'),
 ('+37.41856183',
  '-122.21577393',
  '5.00',
  '32.10',
  '283.36',
  '3/11/16, 12:06:39 PM'),
 ('+37.41862281',
  '-122.21612530',
  '5.00',
  '32.23',
  '281.95',
  '3/11/16, 12:06:40 PM'),
 ('+37.41867524',
  '-122.21647315',
  '5.00',
  '32.21',
  '280.20',
  '3/11/16, 12:06:41 PM'),
 ('+37.41872658',
  '-122.21683566',
  '5.00',
  '32.50',
  '280.20',
  '3/11/16, 12:06:42 PM'),
 ('+37.41878215',
  '-122.21719827',
  '5.00',
  '32.74',
  '279.84',
  '3/11/16, 12:06:43 PM'),
 ('+37.41883236',
  '-122.21756640',
  '5.00',
  '33.12',
  '280.20',
  '3/11/16, 12:06:44 PM'),
 ('+37.41888362',
  '-122.21793663',
  '5.00',
  '33.51',
  '280.55',
  '3/11/16, 12:06:45 PM'),
 ('+37.41894149',
  '-122.21831725',
  '5.00',
  '33.84',
  '280.55',
  '3/11/16, 12:06:46 PM'),
 ('+37.41900025',
  '-122.21869720',
  '5.00',
  '33.98',
  '280.90',
  '3/11/16, 12:06:47 PM'),
 ('+37.41905687',
  '-122.21907137',
  '5.00',
  '33.98',
  '280.90',
  '3/11/16, 12:06:48 PM'),
 ('+37.41911693',
  '-122.21945669',
  '5.00',
  '34.33',
  '280.90',
  '3/11/16, 12:06:49 PM'),
 ('+37.41919475',
  '-122.21983287',
  '5.00',
  '34.26',
  '283.01',
  '3/11/16, 12:06:50 PM'),
 ('+37.41926445',
  '-122.22021307',
  '5.00',
  '34.26',
  '283.01',
  '3/11/16, 12:06:51 PM'),
 ('+37.41935866',
  '-122.22058933',
  '5.00',
  '34.50',
  '285.82',
  '3/11/16, 12:06:52 PM'),
 ('+37.41947328',
  '-122.22094841',
  '5.00',
  '34.93',
  '291.09',
  '3/11/16, 12:06:53 PM'),
 ('+37.41959201',
  '-122.22131613',
  '5.00',
  '34.94',
  '293.55',
  '3/11/16, 12:06:54 PM'),
 ('+37.41973228',
  '-122.22167110',
  '5.00',
  '34.87',
  '296.02',
  '3/11/16, 12:06:55 PM'),
 ('+37.41987612',
  '-122.22201677',
  '5.00',
  '34.81',
  '298.83',
  '3/11/16, 12:06:56 PM'),
 ('+37.42003034',
  '-122.22234886',
  '5.00',
  '34.85',
  '301.64',
  '3/11/16, 12:06:57 PM'),
 ('+37.42020951',
  '-122.22268498',
  '5.00',
  '34.62',
  '304.10',
  '3/11/16, 12:06:58 PM'),
 ('+37.42039831',
  '-122.22300357',
  '5.00',
  '34.56',
  '306.56',
  '3/11/16, 12:06:59 PM'),
 ('+37.42059239',
  '-122.22330339',
  '5.00',
  '34.57',
  '309.73',
  '3/11/16, 12:07:00 PM'),
 ('+37.42079209',
  '-122.22359156',
  '5.00',
  '34.46',
  '311.13',
  '3/11/16, 12:07:01 PM'),
 ('+37.42099640',
  '-122.22388736',
  '5.00',
  '34.33',
  '311.48',
  '3/11/16, 12:07:02 PM'),
 ('+37.42120016',
  '-122.22417637',
  '5.00',
  '34.29',
  '311.48',
  '3/11/16, 12:07:03 PM'),
 ('+37.42140481',
  '-122.22446999',
  '5.00',
  '34.11',
  '311.13',
  '3/11/16, 12:07:04 PM'),
 ('+37.42160254',
  '-122.22475346',
  '5.00',
  '34.06',
  '310.78',
  '3/11/16, 12:07:05 PM'),
 ('+37.42180622',
  '-122.22504700',
  '5.00',
  '34.15',
  '310.78',
  '3/11/16, 12:07:06 PM'),
 ('+37.42201069',
  '-122.22533902',
  '5.00',
  '34.23',
  '311.13',
  '3/11/16, 12:07:07 PM'),
 ('+37.42221534',
  '-122.22563264',
  '5.00',
  '34.15',
  '310.78',
  '3/11/16, 12:07:08 PM'),
 ('+37.42241462',
  '-122.22592475',
  '5.00',
  '34.19',
  '310.78',
  '3/11/16, 12:07:09 PM'),
 ('+37.42261989',
  '-122.22622172',
  '5.00',
  '34.07',
  '310.78',
  '3/11/16, 12:07:10 PM'),
 ('+37.42282810',
  '-122.22651609',
  '5.00',
  '34.31',
  '311.13',
  '3/11/16, 12:07:11 PM'),
 ('+37.42303224',
  '-122.22680837',
  '5.00',
  '34.60',
  '311.48',
  '3/11/16, 12:07:12 PM'),
 ('+37.42323378',
  '-122.22710299',
  '5.00',
  '34.30',
  '310.78',
  '3/11/16, 12:07:13 PM'),
 ('+37.42343910',
  '-122.22739879',
  '5.00',
  '34.40',
  '310.78',
  '3/11/16, 12:07:14 PM'),
 ('+37.42364424',
  '-122.22769744',
  '5.00',
  '34.88',
  '310.78',
  '3/11/16, 12:07:15 PM'),
 ('+37.42384553',
  '-122.22799483',
  '5.00',
  '35.16',
  '310.78',
  '3/11/16, 12:07:16 PM'),
 ('+37.42404586',
  '-122.22828543',
  '5.00',
  '35.16',
  '310.78',
  '3/11/16, 12:07:17 PM'),
 ('+37.42425797',
  '-122.22858500',
  '5.00',
  '35.48',
  '310.78',
  '3/11/16, 12:07:18 PM'),
 ('+37.42447057',
  '-122.22888717',
  '5.00',
  '35.62',
  '311.13',
  '3/11/16, 12:07:19 PM'),
 ('+37.42467819',
  '-122.22918858',
  '5.00',
  '35.86',
  '311.13',
  '3/11/16, 12:07:20 PM'),
 ('+37.42488967',
  '-122.22949008',
  '5.00',
  '35.80',
  '311.84',
  '3/11/16, 12:07:21 PM'),
 ('+37.42510651',
  '-122.22979057',
  '5.00',
  '35.88',
  '312.89',
  '3/11/16, 12:07:22 PM'),
 ('+37.42533181',
  '-122.23008100',
  '5.00',
  '35.95',
  '314.30',
  '3/11/16, 12:07:23 PM'),
 ('+37.42556261',
  '-122.23036783',
  '5.00',
  '35.73',
  '315.35',
  '3/11/16, 12:07:24 PM'),
 ('+37.42579001',
  '-122.23064896',
  '5.00',
  '35.73',
  '315.35',
  '3/11/16, 12:07:25 PM'),
 ('+37.42602726',
  '-122.23093034',
  '5.00',
  '35.64',
  '316.05',
  '3/11/16, 12:07:26 PM'),
 ('+37.42625701',
  '-122.23121884',
  '5.00',
  '35.56',
  '316.05',
  '3/11/16, 12:07:27 PM'),
 ('+37.42648156',
  '-122.23149125',
  '5.00',
  '35.28',
  '315.70',
  '3/11/16, 12:07:28 PM'),
 ('+37.42670804',
  '-122.23176442',
  '5.00',
  '35.09',
  '315.70',
  '3/11/16, 12:07:29 PM'),
 ('+37.42693422',
  '-122.23204530',
  '5.00',
  '35.02',
  '315.70',
  '3/11/16, 12:07:30 PM'),
 ('+37.42715911',
  '-122.23231779',
  '5.00',
  '35.01',
  '315.70',
  '3/11/16, 12:07:31 PM'),
 ('+37.42738525',
  '-122.23260102',
  '5.00',
  '35.00',
  '315.00',
  '3/11/16, 12:07:32 PM'),
 ('+37.42760419',
  '-122.23287838',
  '5.00',
  '34.90',
  '314.65',
  '3/11/16, 12:07:33 PM'),
 ('+37.42782208',
  '-122.23316965',
  '5.00',
  '34.57',
  '313.24',
  '3/11/16, 12:07:34 PM'),
 ('+37.42803355',
  '-122.23345363',
  '5.00',
  '34.52',
  '312.19',
  '3/11/16, 12:07:35 PM'),
 ('+37.42823660',
  '-122.23374641',
  '5.00',
  '34.40',
  '311.48',
  '3/11/16, 12:07:36 PM'),
 ('+37.42843241',
  '-122.23403357',
  '5.00',
  '34.29',
  '310.78',
  '3/11/16, 12:07:37 PM'),
 ('+37.42864388',
  '-122.23433674',
  '5.00',
  '34.21',
  '310.78',
  '3/11/16, 12:07:38 PM'),
 ('+37.42884257',
  '-122.23462642',
  '5.00',
  '33.93',
  '310.08',
  '3/11/16, 12:07:39 PM'),
 ('+37.42904315',
  '-122.23491979',
  '5.00',
  '33.79',
  '310.43',
  '3/11/16, 12:07:40 PM'),
 ('+37.42923061',
  '-122.23520217',
  '5.00',
  '33.50',
  '310.78',
  '3/11/16, 12:07:41 PM'),
 ('+37.42942843',
  '-122.23549663',
  '5.00',
  '33.30',
  '310.43',
  '3/11/16, 12:07:42 PM'),
 ('+37.42962050',
  '-122.23578187',
  '5.00',
  '33.07',
  '310.08',
  '3/11/16, 12:07:43 PM'),
 ('+37.42981596',
  '-122.23606668',
  '5.00',
  '32.93',
  '310.43',
  '3/11/16, 12:07:44 PM'),
 ('+37.43000183',
  '-122.23633968',
  '5.00',
  '32.66',
  '310.78',
  '3/11/16, 12:07:45 PM'),
 ('+37.43019797',
  '-122.23662618',
  '5.00',
  '32.66',
  '310.78',
  '3/11/16, 12:07:46 PM'),
 ('+37.43039276',
  '-122.23690446',
  '5.00',
  '32.63',
  '310.78',
  '3/11/16, 12:07:47 PM'),
 ('+37.43058329',
  '-122.23718642',
  '5.00',
  '32.83',
  '310.78',
  '3/11/16, 12:07:48 PM'),
 ('+37.43077117',
  '-122.23745867',
  '5.00',
  '32.86',
  '311.13',
  '3/11/16, 12:07:49 PM'),
 ('+37.43097283',
  '-122.23774147',
  '5.00',
  '33.10',
  '311.84',
  '3/11/16, 12:07:50 PM'),
 ('+37.43117949',
  '-122.23802512',
  '5.00',
  '33.51',
  '312.89',
  '3/11/16, 12:07:51 PM'),
 ('+37.43138640',
  '-122.23829728',
  '5.00',
  '33.61',
  '313.24',
  '3/11/16, 12:07:52 PM'),
 ('+37.43159783',
  '-122.23857312',
  '5.00',
  '33.80',
  '313.59',
  '3/11/16, 12:07:53 PM'),
 ('+37.43180499',
  '-122.23884881',
  '5.00',
  '33.85',
  '313.95',
  '3/11/16, 12:07:54 PM'),
 ('+37.43201856',
  '-122.23912625',
  '5.00',
  '33.85',
  '313.95',
  '3/11/16, 12:07:55 PM'),
 ('+37.43223557',
  '-122.23939589',
  '5.00',
  '33.95',
  '314.65',
  '3/11/16, 12:07:56 PM'),
 ('+37.43245161',
  '-122.23965330',
  '5.00',
  '33.91',
  '315.70',
  '3/11/16, 12:07:57 PM'),
 ('+37.43267436',
  '-122.23992789',
  '5.00',
  '33.62',
  '316.05',
  '3/11/16, 12:07:58 PM'),
 ('+37.43289145',
  '-122.24018480',
  '5.00',
  '33.71',
  '316.76',
  '3/11/16, 12:07:59 PM'),
 ('+37.43311575',
  '-122.24044723',
  '5.00',
  '33.61',
  '316.76',
  '3/11/16, 12:08:00 PM'),
 ('+37.43332890',
  '-122.24069492',
  '5.00',
  '33.29',
  '316.41',
  '3/11/16, 12:08:01 PM'),
 ('+37.43354365',
  '-122.24095367',
  '5.00',
  '33.21',
  '316.76',
  '3/11/16, 12:08:02 PM'),
 ('+37.43376254',
  '-122.24121250',
  '5.00',
  '33.13',
  '316.41',
  '3/11/16, 12:08:03 PM'),
 ('+37.43397854',
  '-122.24146731',
  '5.00',
  '32.97',
  '316.41',
  '3/11/16, 12:08:04 PM'),
 ('+37.43419065',
  '-122.24171885',
  '5.00',
  '33.12',
  '316.76',
  '3/11/16, 12:08:05 PM'),
 ('+37.43441436',
  '-122.24197802',
  '5.00',
  '33.17',
  '316.05',
  '3/11/16, 12:08:06 PM'),
 ('+37.43463237',
  '-122.24223434',
  '5.00',
  '33.13',
  '316.41',
  '3/11/16, 12:08:07 PM'),
 ('+37.43484389',
  '-122.24249443',
  '5.00',
  '33.14',
  '316.41',
  '3/11/16, 12:08:08 PM'),
 ('+37.43505231',
  '-122.24274589',
  '5.00',
  '33.01',
  '316.41',
  '3/11/16, 12:08:09 PM'),
 ('+37.43527279',
  '-122.24300522',
  '5.00',
  '32.93',
  '316.41',
  '3/11/16, 12:08:10 PM'),
 ('+37.43549370',
  '-122.24325056',
  '5.00',
  '33.08',
  '316.76',
  '3/11/16, 12:08:11 PM'),
 ('+37.43571050',
  '-122.24350931',
  '5.00',
  '33.14',
  '316.41',
  '3/11/16, 12:08:12 PM'),
 ('+37.43592675',
  '-122.24376328',
  '5.00',
  '33.23',
  '316.41',
  '3/11/16, 12:08:13 PM'),
 ('+37.43614275',
  '-122.24402287',
  '5.00',
  '33.25',
  '316.76',
  '3/11/16, 12:08:14 PM'),
 ('+37.43636085',
  '-122.24428128',
  '5.00',
  '33.40',
  '316.76',
  '3/11/16, 12:08:15 PM'),
 ('+37.43657798',
  '-122.24454213',
  '5.00',
  '33.58',
  '316.41',
  '3/11/16, 12:08:16 PM'),
 ('+37.43679541',
  '-122.24480163',
  '5.00',
  '33.58',
  '316.41',
  '3/11/16, 12:08:17 PM'),
 ('+37.43701413',
  '-122.24506994',
  '5.00',
  '33.62',
  '316.41',
  '3/11/16, 12:08:18 PM'),
 ('+37.43723487',
  '-122.24533942',
  '5.00',
  '33.73',
  '316.05',
  '3/11/16, 12:08:19 PM'),
 ('+37.43745284',
  '-122.24560906',
  '5.00',
  '33.53',
  '316.41',
  '3/11/16, 12:08:20 PM'),
 ('+37.43767153',
  '-122.24587351',
  '5.00',
  '33.50',
  '316.41',
  '3/11/16, 12:08:21 PM'),
 ('+37.43789180',
  '-122.24613695',
  '5.00',
  '33.50',
  '316.41',
  '3/11/16, 12:08:22 PM'),
 ('+37.43811023',
  '-122.24639931',
  '5.00',
  '33.28',
  '316.41',
  '3/11/16, 12:08:23 PM'),
 ('+37.43832108',
  '-122.24665353',
  '5.00',
  '33.22',
  '316.05',
  '3/11/16, 12:08:24 PM'),
 ('+37.43853587',
  '-122.24691999',
  '5.00',
  '33.22',
  '315.70',
  '3/11/16, 12:08:25 PM'),
 ('+37.43875183',
  '-122.24718427',
  '5.00',
  '33.22',
  '315.70',
  '3/11/16, 12:08:26 PM'),
 ('+37.43896456',
  '-122.24745174',
  '5.00',
  '33.16',
  '315.35',
  '3/11/16, 12:08:27 PM'),
 ('+37.43917407',
  '-122.24771351',
  '5.00',
  '32.95',
  '315.00',
  '3/11/16, 12:08:28 PM'),
 ('+37.43938236',
  '-122.24797460',
  '5.00',
  '32.95',
  '315.00',
  '3/11/16, 12:08:29 PM'),
 ('+37.43958193',
  '-122.24823553',
  '5.00',
  '32.54',
  '314.30',
  '3/11/16, 12:08:30 PM'),
 ('+37.43979265',
  '-122.24850384',
  '5.00',
  '32.93',
  '314.30',
  '3/11/16, 12:08:31 PM'),
 ('+37.44000262',
  '-122.24876996',
  '5.00',
  '32.88',
  '314.30',
  '3/11/16, 12:08:32 PM'),
 ('+37.44020462',
  '-122.24902871',
  '5.00',
  '32.84',
  '314.30',
  '3/11/16, 12:08:33 PM'),
 ('+37.44041320',
  '-122.24929609',
  '5.00',
  '32.84',
  '314.30',
  '3/11/16, 12:08:34 PM'),
 ('+37.44063097',
  '-122.24957228',
  '5.00',
  '32.93',
  '313.59',
  '3/11/16, 12:08:35 PM'),
 ('+37.44083486',
  '-122.24983480',
  '5.00',
  '32.84',
  '313.95',
  '3/11/16, 12:08:36 PM'),
 ('+37.44103455',
  '-122.25010327',
  '5.00',
  '32.82',
  '313.95',
  '3/11/16, 12:08:37 PM'),
 ('+37.44124096',
  '-122.25037308',
  '5.00',
  '32.82',
  '313.95',
  '3/11/16, 12:08:38 PM'),
 ('+37.44145696',
  '-122.25065195',
  '5.00',
  '33.00',
  '313.95',
  '3/11/16, 12:08:39 PM'),
 ('+37.44165540',
  '-122.25091933',
  '5.00',
  '33.04',
  '313.59',
  '3/11/16, 12:08:40 PM'),
 ('+37.44186575',
  '-122.25118672',
  '5.00',
  '32.93',
  '313.24',
  '3/11/16, 12:08:41 PM'),
 ('+37.44207177',
  '-122.25146784',
  '5.00',
  '32.88',
  '312.89',
  '3/11/16, 12:08:42 PM'),
 ('+37.44226175',
  '-122.25174277',
  '5.00',
  '32.89',
  '311.13',
  '3/11/16, 12:08:43 PM'),
 ('+37.44244976',
  '-122.25203010',
  '5.00',
  '33.09',
  '309.02',
  '3/11/16, 12:08:44 PM'),
 ('+37.44262980',
  '-122.25232825',
  '5.00',
  '32.92',
  '306.91',
  '3/11/16, 12:08:45 PM'),
 ('+37.44279802',
  '-122.25263335',
  '5.00',
  '33.02',
  '304.45',
  '3/11/16, 12:08:46 PM'),
 ('+37.44296361',
  '-122.25294834',
  '5.00',
  '32.96',
  '301.99',
  '3/11/16, 12:08:47 PM'),
 ('+37.44311620',
  '-122.25326920',
  '5.00',
  '32.88',
  '299.88',
  '3/11/16, 12:08:48 PM'),
 ('+37.44326150',
  '-122.25358947',
  '5.00',
  '32.81',
  '298.48',
  '3/11/16, 12:08:49 PM'),
 ('+37.44339993',
  '-122.25391846',
  '5.00',
  '32.76',
  '296.72',
  '3/11/16, 12:08:50 PM'),
 ('+37.44352696',
  '-122.25425533',
  '5.00',
  '32.62',
  '294.61',
  '3/11/16, 12:08:51 PM'),
 ('+37.44364246',
  '-122.25458952',
  '5.00',
  '32.61',
  '292.50',
  '3/11/16, 12:08:52 PM'),
 ('+37.44374342',
  '-122.25493183',
  '5.00',
  '32.66',
  '290.39',
  '3/11/16, 12:08:53 PM'),
 ('+37.44384262',
  '-122.25528153',
  '5.00',
  '32.69',
  '288.63',
  '3/11/16, 12:08:54 PM'),
 ('+37.44392589',
  '-122.25564044',
  '5.00',
  '32.66',
  '286.52',
  '3/11/16, 12:08:55 PM'),
 ('+37.44400414',
  '-122.25598745',
  '5.00',
  '32.57',
  '284.41',
  '3/11/16, 12:08:56 PM'),
 ('+37.44406453',
  '-122.25634385',
  '5.00',
  '32.57',
  '282.30',
  '3/11/16, 12:08:57 PM'),
 ('+37.44411847',
  '-122.25671014',
  '5.00',
  '32.43',
  '279.49',
  '3/11/16, 12:08:58 PM'),
 ('+37.44416092',
  '-122.25706779',
  '5.00',
  '32.31',
  '278.09',
  '3/11/16, 12:08:59 PM'),
 ('+37.44419763',
  '-122.25743668',
  '5.00',
  '32.30',
  '276.68',
  '3/11/16, 12:09:00 PM'),
 ('+37.44422018',
  '-122.25779040',
  '5.00',
  '32.25',
  '274.22',
  '3/11/16, 12:09:01 PM'),
 ('+37.44423451',
  '-122.25815644',
  '5.00',
  '32.29',
  '272.46',
  '3/11/16, 12:09:02 PM'),
 ('+37.44423900',
  '-122.25851887',
  '5.00',
  '32.57',
  '270.35',
  '3/11/16, 12:09:03 PM'),
 ('+37.44423414',
  '-122.25888331',
  '5.00',
  '32.66',
  '268.24',
  '3/11/16, 12:09:04 PM'),
 ('+37.44422039',
  '-122.25925044',
  '5.00',
  '32.48',
  '266.13',
  '3/11/16, 12:09:05 PM'),
 ('+37.44420115',
  '-122.25962444',
  '5.00',
  '32.48',
  '265.08',
  '3/11/16, 12:09:06 PM'),
 ('+37.44417706',
  '-122.25999425',
  '5.00',
  '32.60',
  '264.73',
  '3/11/16, 12:09:07 PM'),
 ('+37.44414135',
  '-122.26035660',
  '5.00',
  '32.45',
  '264.02',
  '3/11/16, 12:09:08 PM'),
 ('+37.44411151',
  '-122.26071711',
  '5.00',
  '32.51',
  '264.02',
  '3/11/16, 12:09:09 PM'),
 ('+37.44407878',
  '-122.26109077',
  '5.00',
  '32.65',
  '264.38',
  '3/11/16, 12:09:10 PM'),
 ('+37.44404961',
  '-122.26145748',
  '5.00',
  '32.57',
  '264.38',
  '3/11/16, 12:09:11 PM'),
 ('+37.44401797',
  '-122.26182293',
  '5.00',
  '32.35',
  '264.02',
  '3/11/16, 12:09:12 PM'),
 ('+37.44398880',
  '-122.26217958',
  '5.00',
  '32.49',
  '264.38',
  '3/11/16, 12:09:13 PM'),
 ('+37.44395519',
  '-122.26255308',
  '5.00',
  '32.35',
  '264.38',
  '3/11/16, 12:09:14 PM'),
 ('+37.44392480',
  '-122.26291149',
  '5.00',
  '32.18',
  '264.38',
  '3/11/16, 12:09:15 PM'),
 ('+37.44389345',
  '-122.26327367',
  '5.00',
  '32.04',
  '264.38',
  '3/11/16, 12:09:16 PM'),
 ('+37.44386206',
  '-122.26362152',
  '5.00',
  '31.85',
  '264.38',
  '3/11/16, 12:09:17 PM'),
 ('+37.44383398',
  '-122.26398513',
  '5.00',
  '31.86',
  '265.43',
  '3/11/16, 12:09:18 PM'),
 ('+37.44382032',
  '-122.26434982',
  '5.00',
  '32.01',
  '266.84',
  '3/11/16, 12:09:19 PM'),
 ('+37.44380955',
  '-122.26471217',
  '5.00',
  '32.07',
  '268.59',
  '3/11/16, 12:09:20 PM'),
 ('+37.44380964',
  '-122.26507343',
  '5.00',
  '32.24',
  '270.70',
  '3/11/16, 12:09:21 PM'),
 ('+37.44381697',
  '-122.26544651',
  '5.00',
  '32.14',
  '272.46',
  '3/11/16, 12:09:22 PM'),
 ('+37.44383755',
  '-122.26580291',
  '5.00',
  '32.20',
  '274.92',
  '3/11/16, 12:09:23 PM'),
 ('+37.44387418',
  '-122.26616560',
  '5.00',
  '32.18',
  '276.68',
  '3/11/16, 12:09:24 PM'),
 ('+37.44391160',
  '-122.26651906',
  '5.00',
  '32.20',
  '278.44',
  '3/11/16, 12:09:25 PM')]

Put the data in a DataFrame¶

df_data = pd.DataFrame(paresed_data, columns=["lat","long","accuracy","speed","course","timestamp"])

df_data #Notice that the timestamp is a string (just text!) we need to convert to dataTime object so that python can help us in ploting

df_data['datestamp']= pd.Series()
pd.to_datetime(df_data['datestamp'])

def parse_date(df):
    df['datestamp'] = parser.parse(df['timestamp'])
    return df
df_data = df_data.apply(parse_date, axis = 1)
df_data.set_index(df_data['datestamp'])

Plotting Trajectory on Map¶

df_data.columns

Index([u'lat', u'long', u'accuracy', u'speed', u'course', u'timestamp',
       u'datestamp'],
      dtype='object')

data_list = df_data.ix[:,[0,1,5]].values.tolist()

point_0 = data_list[0]

stamen = folium.Map(location=[point_0[0], point_0[1]], tiles='Stamen Toner',
                        zoom_start=13)

    
for point_i in data_list:

    stamen.simple_marker(location=[point_i[0], point_i[1]], popup=point_i[2])
stamen

Speed Versus Time¶

epoch = datetime.datetime(1970, 1, 1)
times = df_data.ix[:,'datestamp'].map(lambda x: (x - epoch).total_seconds())

plt.figure(figsize=(10,10))
plt.plot(list(times),list(df_data.ix[:,'speed']))
plt.title('Speed vs Time', fontsize = 20)
plt.xlabel('Epoch Time', fontsize = 15)
plt.ylabel('Speed', fontsize = 15)

<matplotlib.text.Text at 0x7f735afb5750>

	lat	long	accuracy	speed	course	timestamp
0	+37.33417438	-122.07050306	5.00	33.60	257.34	3/11/16, 11:58:15 AM
1	+37.33410968	-122.07087404	5.00	33.62	256.99	3/11/16, 11:58:16 AM
2	+37.33403923	-122.07123245	5.00	33.61	256.64	3/11/16, 11:58:17 AM
3	+37.33396475	-122.07160897	5.00	33.51	256.64	3/11/16, 11:58:18 AM
4	+37.33389384	-122.07197743	5.00	33.67	257.34	3/11/16, 11:58:19 AM
5	+37.33382775	-122.07235512	5.00	33.85	258.05	3/11/16, 11:58:20 AM
6	+37.33375801	-122.07272963	5.00	33.36	257.70	3/11/16, 11:58:21 AM
7	+37.33369775	-122.07309474	5.00	33.08	258.05	3/11/16, 11:58:22 AM
8	+37.33363907	-122.07346522	5.00	32.79	259.80	3/11/16, 11:58:23 AM
9	+37.33359159	-122.07381886	5.00	32.16	261.21	3/11/16, 11:58:24 AM
10	+37.33355651	-122.07417592	5.00	32.04	264.02	3/11/16, 11:58:25 AM
11	+37.33353728	-122.07453283	5.00	31.86	266.84	3/11/16, 11:58:26 AM
12	+37.33353065	-122.07488445	5.00	31.54	269.65	3/11/16, 11:58:27 AM
13	+37.33353363	-122.07523112	5.00	31.34	272.11	3/11/16, 11:58:28 AM
14	+37.33355228	-122.07558936	5.00	31.58	274.57	3/11/16, 11:58:29 AM
15	+37.33358308	-122.07595104	5.00	31.84	276.68	3/11/16, 11:58:30 AM
16	+37.33362663	-122.07630560	5.00	31.90	279.14	3/11/16, 11:58:31 AM
17	+37.33368006	-122.07665613	5.00	31.92	281.60	3/11/16, 11:58:32 AM
18	+37.33374934	-122.07700482	5.00	32.16	284.06	3/11/16, 11:58:33 AM
19	+37.33382825	-122.07735141	5.00	32.58	287.23	3/11/16, 11:58:34 AM
20	+37.33392322	-122.07769942	5.00	32.48	289.34	3/11/16, 11:58:35 AM
21	+37.33402871	-122.07804543	5.00	32.47	292.15	3/11/16, 11:58:36 AM
22	+37.33415037	-122.07838406	5.00	32.74	294.61	3/11/16, 11:58:37 AM
23	+37.33428050	-122.07872034	5.00	32.85	296.72	3/11/16, 11:58:38 AM
24	+37.33442102	-122.07904631	5.00	32.75	299.18	3/11/16, 11:58:39 AM
25	+37.33457244	-122.07936390	5.00	33.02	301.99	3/11/16, 11:58:40 AM
26	+37.33473735	-122.07967470	5.00	33.21	304.80	3/11/16, 11:58:41 AM
27	+37.33492184	-122.07997503	5.00	33.41	307.97	3/11/16, 11:58:42 AM
28	+37.33511119	-122.08026077	5.00	33.53	310.78	3/11/16, 11:58:43 AM
29	+37.33531428	-122.08054952	5.00	33.75	312.54	3/11/16, 11:58:44 AM
...	...	...	...	...	...	...
641	+37.44400414	-122.25598745	5.00	32.57	284.41	3/11/16, 12:08:56 PM
642	+37.44406453	-122.25634385	5.00	32.57	282.30	3/11/16, 12:08:57 PM
643	+37.44411847	-122.25671014	5.00	32.43	279.49	3/11/16, 12:08:58 PM
644	+37.44416092	-122.25706779	5.00	32.31	278.09	3/11/16, 12:08:59 PM
645	+37.44419763	-122.25743668	5.00	32.30	276.68	3/11/16, 12:09:00 PM
646	+37.44422018	-122.25779040	5.00	32.25	274.22	3/11/16, 12:09:01 PM
647	+37.44423451	-122.25815644	5.00	32.29	272.46	3/11/16, 12:09:02 PM
648	+37.44423900	-122.25851887	5.00	32.57	270.35	3/11/16, 12:09:03 PM
649	+37.44423414	-122.25888331	5.00	32.66	268.24	3/11/16, 12:09:04 PM
650	+37.44422039	-122.25925044	5.00	32.48	266.13	3/11/16, 12:09:05 PM
651	+37.44420115	-122.25962444	5.00	32.48	265.08	3/11/16, 12:09:06 PM
652	+37.44417706	-122.25999425	5.00	32.60	264.73	3/11/16, 12:09:07 PM
653	+37.44414135	-122.26035660	5.00	32.45	264.02	3/11/16, 12:09:08 PM
654	+37.44411151	-122.26071711	5.00	32.51	264.02	3/11/16, 12:09:09 PM
655	+37.44407878	-122.26109077	5.00	32.65	264.38	3/11/16, 12:09:10 PM
656	+37.44404961	-122.26145748	5.00	32.57	264.38	3/11/16, 12:09:11 PM
657	+37.44401797	-122.26182293	5.00	32.35	264.02	3/11/16, 12:09:12 PM
658	+37.44398880	-122.26217958	5.00	32.49	264.38	3/11/16, 12:09:13 PM
659	+37.44395519	-122.26255308	5.00	32.35	264.38	3/11/16, 12:09:14 PM
660	+37.44392480	-122.26291149	5.00	32.18	264.38	3/11/16, 12:09:15 PM
661	+37.44389345	-122.26327367	5.00	32.04	264.38	3/11/16, 12:09:16 PM
662	+37.44386206	-122.26362152	5.00	31.85	264.38	3/11/16, 12:09:17 PM
663	+37.44383398	-122.26398513	5.00	31.86	265.43	3/11/16, 12:09:18 PM
664	+37.44382032	-122.26434982	5.00	32.01	266.84	3/11/16, 12:09:19 PM
665	+37.44380955	-122.26471217	5.00	32.07	268.59	3/11/16, 12:09:20 PM
666	+37.44380964	-122.26507343	5.00	32.24	270.70	3/11/16, 12:09:21 PM
667	+37.44381697	-122.26544651	5.00	32.14	272.46	3/11/16, 12:09:22 PM
668	+37.44383755	-122.26580291	5.00	32.20	274.92	3/11/16, 12:09:23 PM
669	+37.44387418	-122.26616560	5.00	32.18	276.68	3/11/16, 12:09:24 PM
670	+37.44391160	-122.26651906	5.00	32.20	278.44	3/11/16, 12:09:25 PM

	lat	long	accuracy	speed	course	timestamp	datestamp
datestamp
2016-03-11 11:58:15	+37.33417438	-122.07050306	5.00	33.60	257.34	3/11/16, 11:58:15 AM	2016-03-11 11:58:15
2016-03-11 11:58:16	+37.33410968	-122.07087404	5.00	33.62	256.99	3/11/16, 11:58:16 AM	2016-03-11 11:58:16
2016-03-11 11:58:17	+37.33403923	-122.07123245	5.00	33.61	256.64	3/11/16, 11:58:17 AM	2016-03-11 11:58:17
2016-03-11 11:58:18	+37.33396475	-122.07160897	5.00	33.51	256.64	3/11/16, 11:58:18 AM	2016-03-11 11:58:18
2016-03-11 11:58:19	+37.33389384	-122.07197743	5.00	33.67	257.34	3/11/16, 11:58:19 AM	2016-03-11 11:58:19
2016-03-11 11:58:20	+37.33382775	-122.07235512	5.00	33.85	258.05	3/11/16, 11:58:20 AM	2016-03-11 11:58:20
2016-03-11 11:58:21	+37.33375801	-122.07272963	5.00	33.36	257.70	3/11/16, 11:58:21 AM	2016-03-11 11:58:21
2016-03-11 11:58:22	+37.33369775	-122.07309474	5.00	33.08	258.05	3/11/16, 11:58:22 AM	2016-03-11 11:58:22
2016-03-11 11:58:23	+37.33363907	-122.07346522	5.00	32.79	259.80	3/11/16, 11:58:23 AM	2016-03-11 11:58:23
2016-03-11 11:58:24	+37.33359159	-122.07381886	5.00	32.16	261.21	3/11/16, 11:58:24 AM	2016-03-11 11:58:24
2016-03-11 11:58:25	+37.33355651	-122.07417592	5.00	32.04	264.02	3/11/16, 11:58:25 AM	2016-03-11 11:58:25
2016-03-11 11:58:26	+37.33353728	-122.07453283	5.00	31.86	266.84	3/11/16, 11:58:26 AM	2016-03-11 11:58:26
2016-03-11 11:58:27	+37.33353065	-122.07488445	5.00	31.54	269.65	3/11/16, 11:58:27 AM	2016-03-11 11:58:27
2016-03-11 11:58:28	+37.33353363	-122.07523112	5.00	31.34	272.11	3/11/16, 11:58:28 AM	2016-03-11 11:58:28
2016-03-11 11:58:29	+37.33355228	-122.07558936	5.00	31.58	274.57	3/11/16, 11:58:29 AM	2016-03-11 11:58:29
2016-03-11 11:58:30	+37.33358308	-122.07595104	5.00	31.84	276.68	3/11/16, 11:58:30 AM	2016-03-11 11:58:30
2016-03-11 11:58:31	+37.33362663	-122.07630560	5.00	31.90	279.14	3/11/16, 11:58:31 AM	2016-03-11 11:58:31
2016-03-11 11:58:32	+37.33368006	-122.07665613	5.00	31.92	281.60	3/11/16, 11:58:32 AM	2016-03-11 11:58:32
2016-03-11 11:58:33	+37.33374934	-122.07700482	5.00	32.16	284.06	3/11/16, 11:58:33 AM	2016-03-11 11:58:33
2016-03-11 11:58:34	+37.33382825	-122.07735141	5.00	32.58	287.23	3/11/16, 11:58:34 AM	2016-03-11 11:58:34
2016-03-11 11:58:35	+37.33392322	-122.07769942	5.00	32.48	289.34	3/11/16, 11:58:35 AM	2016-03-11 11:58:35
2016-03-11 11:58:36	+37.33402871	-122.07804543	5.00	32.47	292.15	3/11/16, 11:58:36 AM	2016-03-11 11:58:36
2016-03-11 11:58:37	+37.33415037	-122.07838406	5.00	32.74	294.61	3/11/16, 11:58:37 AM	2016-03-11 11:58:37
2016-03-11 11:58:38	+37.33428050	-122.07872034	5.00	32.85	296.72	3/11/16, 11:58:38 AM	2016-03-11 11:58:38
2016-03-11 11:58:39	+37.33442102	-122.07904631	5.00	32.75	299.18	3/11/16, 11:58:39 AM	2016-03-11 11:58:39
2016-03-11 11:58:40	+37.33457244	-122.07936390	5.00	33.02	301.99	3/11/16, 11:58:40 AM	2016-03-11 11:58:40
2016-03-11 11:58:41	+37.33473735	-122.07967470	5.00	33.21	304.80	3/11/16, 11:58:41 AM	2016-03-11 11:58:41
2016-03-11 11:58:42	+37.33492184	-122.07997503	5.00	33.41	307.97	3/11/16, 11:58:42 AM	2016-03-11 11:58:42
2016-03-11 11:58:43	+37.33511119	-122.08026077	5.00	33.53	310.78	3/11/16, 11:58:43 AM	2016-03-11 11:58:43
2016-03-11 11:58:44	+37.33531428	-122.08054952	5.00	33.75	312.54	3/11/16, 11:58:44 AM	2016-03-11 11:58:44
...	...	...	...	...	...	...	...
2016-03-11 12:08:56	+37.44400414	-122.25598745	5.00	32.57	284.41	3/11/16, 12:08:56 PM	2016-03-11 12:08:56
2016-03-11 12:08:57	+37.44406453	-122.25634385	5.00	32.57	282.30	3/11/16, 12:08:57 PM	2016-03-11 12:08:57
2016-03-11 12:08:58	+37.44411847	-122.25671014	5.00	32.43	279.49	3/11/16, 12:08:58 PM	2016-03-11 12:08:58
2016-03-11 12:08:59	+37.44416092	-122.25706779	5.00	32.31	278.09	3/11/16, 12:08:59 PM	2016-03-11 12:08:59
2016-03-11 12:09:00	+37.44419763	-122.25743668	5.00	32.30	276.68	3/11/16, 12:09:00 PM	2016-03-11 12:09:00
2016-03-11 12:09:01	+37.44422018	-122.25779040	5.00	32.25	274.22	3/11/16, 12:09:01 PM	2016-03-11 12:09:01
2016-03-11 12:09:02	+37.44423451	-122.25815644	5.00	32.29	272.46	3/11/16, 12:09:02 PM	2016-03-11 12:09:02
2016-03-11 12:09:03	+37.44423900	-122.25851887	5.00	32.57	270.35	3/11/16, 12:09:03 PM	2016-03-11 12:09:03
2016-03-11 12:09:04	+37.44423414	-122.25888331	5.00	32.66	268.24	3/11/16, 12:09:04 PM	2016-03-11 12:09:04
2016-03-11 12:09:05	+37.44422039	-122.25925044	5.00	32.48	266.13	3/11/16, 12:09:05 PM	2016-03-11 12:09:05
2016-03-11 12:09:06	+37.44420115	-122.25962444	5.00	32.48	265.08	3/11/16, 12:09:06 PM	2016-03-11 12:09:06
2016-03-11 12:09:07	+37.44417706	-122.25999425	5.00	32.60	264.73	3/11/16, 12:09:07 PM	2016-03-11 12:09:07
2016-03-11 12:09:08	+37.44414135	-122.26035660	5.00	32.45	264.02	3/11/16, 12:09:08 PM	2016-03-11 12:09:08
2016-03-11 12:09:09	+37.44411151	-122.26071711	5.00	32.51	264.02	3/11/16, 12:09:09 PM	2016-03-11 12:09:09
2016-03-11 12:09:10	+37.44407878	-122.26109077	5.00	32.65	264.38	3/11/16, 12:09:10 PM	2016-03-11 12:09:10
2016-03-11 12:09:11	+37.44404961	-122.26145748	5.00	32.57	264.38	3/11/16, 12:09:11 PM	2016-03-11 12:09:11
2016-03-11 12:09:12	+37.44401797	-122.26182293	5.00	32.35	264.02	3/11/16, 12:09:12 PM	2016-03-11 12:09:12
2016-03-11 12:09:13	+37.44398880	-122.26217958	5.00	32.49	264.38	3/11/16, 12:09:13 PM	2016-03-11 12:09:13
2016-03-11 12:09:14	+37.44395519	-122.26255308	5.00	32.35	264.38	3/11/16, 12:09:14 PM	2016-03-11 12:09:14
2016-03-11 12:09:15	+37.44392480	-122.26291149	5.00	32.18	264.38	3/11/16, 12:09:15 PM	2016-03-11 12:09:15
2016-03-11 12:09:16	+37.44389345	-122.26327367	5.00	32.04	264.38	3/11/16, 12:09:16 PM	2016-03-11 12:09:16
2016-03-11 12:09:17	+37.44386206	-122.26362152	5.00	31.85	264.38	3/11/16, 12:09:17 PM	2016-03-11 12:09:17
2016-03-11 12:09:18	+37.44383398	-122.26398513	5.00	31.86	265.43	3/11/16, 12:09:18 PM	2016-03-11 12:09:18
2016-03-11 12:09:19	+37.44382032	-122.26434982	5.00	32.01	266.84	3/11/16, 12:09:19 PM	2016-03-11 12:09:19
2016-03-11 12:09:20	+37.44380955	-122.26471217	5.00	32.07	268.59	3/11/16, 12:09:20 PM	2016-03-11 12:09:20
2016-03-11 12:09:21	+37.44380964	-122.26507343	5.00	32.24	270.70	3/11/16, 12:09:21 PM	2016-03-11 12:09:21
2016-03-11 12:09:22	+37.44381697	-122.26544651	5.00	32.14	272.46	3/11/16, 12:09:22 PM	2016-03-11 12:09:22
2016-03-11 12:09:23	+37.44383755	-122.26580291	5.00	32.20	274.92	3/11/16, 12:09:23 PM	2016-03-11 12:09:23
2016-03-11 12:09:24	+37.44387418	-122.26616560	5.00	32.18	276.68	3/11/16, 12:09:24 PM	2016-03-11 12:09:24
2016-03-11 12:09:25	+37.44391160	-122.26651906	5.00	32.20	278.44	3/11/16, 12:09:25 PM	2016-03-11 12:09:25