In [1]:
from mpl_toolkits.basemap import Basemap
import matplotlib.pyplot as plt
import numpy as np

import pandas as pd


/Users/nlele/Projects/gas-db-experiments/env/lib/python3.6/site-packages/matplotlib/font_manager.py:280: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
  'Matplotlib is building the font cache using fc-list. '

In [119]:
import os
import json
import time

In [56]:
with open('secrets.json') as secrets_file:    
    secrets = json.load(secrets_file)
    
len(secrets)


Out[56]:
1

In [10]:
pd.read_csv('data/prices_1.csv').head(10)


Out[10]:
station_id collected reported type price user
0 14344 2017-05-13 00:02:42 +0000 2017-05-12 14:50:00 +0000 regular 3.05 crgkart13
1 14344 2017-05-13 00:02:43 +0000 2017-05-12 14:50:00 +0000 midgrade 3.19 crgkart13
2 14344 2017-05-13 00:02:44 +0000 2017-05-12 14:50:00 +0000 premium 3.33 crgkart13
3 14344 2017-05-13 00:02:44 +0000 2017-05-12 14:50:00 +0000 diesel 2.89 crgkart13
4 4030 2017-05-13 00:02:45 +0000 2017-05-12 14:51:00 +0000 regular 2.99 gedi2012
5 5017 2017-05-13 00:02:45 +0000 2017-05-12 15:41:00 +0000 regular 3.09 BlueHorse
6 3895 2017-05-13 00:02:45 +0000 2017-05-12 15:38:00 +0000 regular 3.09 BlueHorse
7 10588 2017-05-13 00:02:45 +0000 2017-05-12 14:51:00 +0000 regular 3.15 gedi2012
8 5253 2017-05-13 00:02:45 +0000 2017-05-12 15:21:00 +0000 regular 3.29 gedi2012
9 3898 2017-05-13 00:02:45 +0000 2017-05-12 15:21:00 +0000 regular 3.45 gedi2012

In [18]:
prices_files = os.listdir('data/')
prices = pd.DataFrame()
for filename in prices_files:
    p = pd.read_csv('data/' + filename)
    prices = prices.append(p)

In [22]:
prices.info()


<class 'pandas.core.frame.DataFrame'>
Int64Index: 242838 entries, 0 to 2415
Data columns (total 6 columns):
station_id    242838 non-null object
collected     242838 non-null object
reported      242838 non-null object
type          242838 non-null object
price         242838 non-null float64
user          242838 non-null object
dtypes: float64(1), object(5)
memory usage: 13.0+ MB

In [23]:
stations = prices['station_id']
stations.head(5)


Out[23]:
0    14344
1    14344
2    14344
3    14344
4     4030
Name: station_id, dtype: object

In [27]:
stations_set = set()
for s in stations:
    stations_set.add(s)

stations_list = list(stations_set)
print(stations_list)


[24627, 14338, 14339, 14340, 14341, 68612, 14343, 14344, 33799, 33802, 33800, 68617, 14346, 14345, 4111, 4112, 33809, 14347, 14355, 26635, 26637, 14354, 14359, 2074, 1051, 14368, 21024, 21026, 14370, 12324, 14372, 14371, 18223, 27178, 21025, 24618, 24619, 27179, 24621, 24622, 23598, 23600, 23599, 27183, 24624, 23595, 23596, 24630, 24626, 18226, 18227, 14394, 14395, 21077, 71743, 14400, 14401, 14402, 20035, 14403, 79938, 30490, 20551, 18230, 12361, 102474, 71752, 18232, 77394, 21076, 23637, 23638, 21079, 69205, 23639, 21080, 68607, 12380, 12381, 12382, 12383, 24160, 24161, 18235, 12384, 72800, 18234, 18236, 24159, 102505, 11882, 18237, 170604, 18238, 81018, 15485, 15486, 15487, 15488, 18241, 5253, 18242, 32392, 15497, 39049, 39051, 15501, 27789, 15504, 12437, 77466, 3900, 33959, 33960, 24231, 12977, 124084, 8885, 24758, 37049, 108220, 5431, 14526, 108223, 26311, 93895, 35018, 2253, 26319, 68316, 19689, 23274, 87276, 22766, 85744, 3317, 5442, 1273, 1274, 21318, 15609, 15611, 15612, 33022, 2302, 27180, 33020, 3334, 24842, 23819, 23822, 68374, 24855, 38171, 2330, 24859, 24860, 24861, 38170, 24863, 24864, 21793, 3362, 3363, 21794, 29985, 3366, 134943, 117539, 68386, 18219, 18220, 18221, 18222, 24877, 18224, 18225, 68397, 11571, 18228, 18229, 11572, 3895, 5432, 3896, 3898, 11578, 67386, 18231, 11575, 18239, 5440, 5441, 3901, 18243, 5444, 5445, 5446, 18759, 5448, 5447, 5443, 21317, 18764, 5453, 18254, 18255, 18256, 18257, 18258, 21330, 20815, 20816, 11606, 21329, 62808, 33650, 10588, 1373, 1374, 15710, 14215, 24419, 26631, 14694, 14182, 14696, 23403, 33644, 33645, 33646, 33647, 35696, 24945, 14706, 29036, 24946, 24947, 14701, 33143, 35697, 33649, 23418, 12154, 26636, 27006, 1922, 14213, 4998, 14214, 5000, 5001, 5002, 5003, 5004, 14216, 35726, 4999, 14224, 1426, 14327, 12292, 5017, 5018, 35738, 24476, 5021, 5022, 5023, 5024, 5020, 35740, 83871, 5019, 18857, 18859, 6064, 6065, 10677, 11587, 4027, 4028, 11709, 4030, 15806, 69053, 18881, 33218, 18883, 23597, 33221, 99717, 18233, 90570, 18895, 71120, 5585, 40401, 11592, 15826, 15825, 15827, 71130, 2523, 24620, 4063, 3040, 4066, 11595, 14308, 4068, 14309, 14311, 14312, 14313, 490, 24044, 14317, 14318, 24045, 24560, 14320, 14321, 14322, 14319, 14325, 2550, 2551, 14328, 22517, 14330, 117637, 14332, 14333, 14334, 14335]

In [235]:
stations = pd.read_csv('data/stations.csv', index_col = 0)
stations.head(5)


Out[235]:
location name address phone
station_id
14344 Atherton Shell 3201 El Camino Real Fifth Ave Atherton, CA 940... 650-367-6959
4030 Cupertino Valero 10002 N De Anza Blvd Stevens Creek Blvd Cupert... 408-996-1222
5017 Cupertino Chevron 11010 N De Anza Blvd Homestead Rd Cupertino, C... 408-773-9135
3895 Cupertino 76 21855 Homestead Rd S Bernardo Ave Cupertino, C... 408-733-9111
10588 Cupertino Chevron 10023 S De Anza Blvd Stevens Creek Blvd Cupert... 408-996-9906

In [59]:
stations.describe()


Out[59]:
location name address phone
count 336 336 336 328
unique 30 51 336 326
top Redwood_City Chevron 221 Airport Blvd Grand Ave South San Francisco... 408-847-5172
freq 28 67 1 2

In [40]:
stations.loc[490].address


Out[40]:
'150 Lawrence Expy Kifer Rd Sunnyvale, CA 94086-5328'

In [48]:
l = stations.loc[490].address.split(',')[0]
print(l)


150 Lawrence Expy Kifer Rd Sunnyvale

In [45]:
from geopy.geocoders import Nominatim
geolocator = Nominatim()
geolocator.geocode("175 5th Avenue NYC")


Out[45]:
Location(Flatiron Building, 175, 5th Avenue, Flatiron Building, Manhattan, Manhattan Community Board 5, New York County, NYC, New York, 10010, United States of America, (40.7410861, -73.9896298241625, 0.0))

In [49]:
geolocator.geocode(l)

In [57]:
from geopy.geocoders import GoogleV3
geolocator = GoogleV3(api_key=secrets['GOOGLE_GEOCODING_API_KEY'])
geolocator.geocode("175 5th Avenue NYC")


Out[57]:
Location(175 5th Ave, New York, NY 10010, USA, (40.7409928, -73.98965869999999, 0.0))

In [58]:
geolocator.geocode(stations.loc[490].address)


Out[58]:
Location(150 Lawrence Station Rd, Sunnyvale, CA 94086, USA, (37.3713248, -121.9941119, 0.0))

In [69]:
locations = {} # station_id to google location object
failures = {} # station_id to address string
for station_id,data in stations.iterrows():
    print(station_id, data.address)
    try:
        loc = geolocator.geocode(data.address)
    except Exception as e:
        failures[station_id] = data.address
    else:
        locations[station_id] = loc


14344 3201 El Camino Real Fifth Ave Atherton, CA 94027-3843
4030 10002 N De Anza Blvd Stevens Creek Blvd Cupertino, CA 95014-2251
5017 11010 N De Anza Blvd Homestead Rd Cupertino, CA 95014-0443
3895 21855 Homestead Rd S Bernardo Ave Cupertino, CA 95014-0111
10588 10023 S De Anza Blvd Stevens Creek Blvd Cupertino, CA 95014-2105
5253 5696 Stevens Creek Blvd Stern Ave Cupertino, CA 95014-3662
3898 19550 Stevens Creek Blvd Miller Ave Cupertino, CA 95014-2404
24622 929 Fremont Ave Dolores Ave Los Altos, CA 94024-6098
2074 2300 Homestead Rd Foothill Expy Los Altos, CA 94024-7338
21026 3401 Middlefield Rd Eighth Ave Menlo Park, CA 94025-3022
14332 1110 Marsh Rd Scott Dr Menlo Park, CA 94025-1014
14343 1200 El Camino Real Oak Grove Ave Menlo Park, CA 94025-4209
14330 1380 El Camino Real Glenwood Ave Menlo Park, CA 94025-4211
14341 3600 Alameda De Las Pulgas Avy Ave Menlo Park, CA 94025-6214
2550 790 N Shoreline Blvd W Middlefield Rd Mountain View, CA 94043
1373 101 E El Camino Real Grant Rd Mountain View, CA 94040-2701
4027 789 E Evelyn Ave S Bernardo Ave Mountain View, CA 94041-1614
5024 59 W El Camino Real Bay St Mountain View, CA 94040-2601
26311 495 Moffett Blvd W Middlefield Rd Mountain View, CA 94043
5021 808 N Shoreline Blvd W Middlefield Rd Mountain View, CA 94043-1931
2551 807 N Shoreline Blvd W Middlefield Rd Mountain View, CA 94043
1051 1288 W El Camino Real S Shoreline Blvd Mountain View, CA 94040-2402
5023 334 San Antonio Rd California St Mountain View, CA 94040
1274 45 W El Camino Real Grant Rd Mountain View, CA 94040-2601
1273 1220 Grant Rd Bentley Sq Mountain View, CA 94040-3227
3366 1601 Coleman Ave W Brokaw Rd Santa Clara, CA 95050-3122
18857 3725 El Camino Real Halford Ave Santa Clara, CA 95051-2804
15497 2800 Homestead Rd Kiely Blvd Santa Clara, CA 95051-3041
4063 3740 El Camino Real Halford Ave Santa Clara, CA 95051-2606
15501 3480 Homestead Rd Princeton Way Santa Clara, CA 95051-5115
5003 3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404
18254 3501 Homestead Rd Bing Dr Santa Clara, CA 95051-5116
24864 2320 El Camino Real Los Padres Blvd Santa Clara, CA 95050-4059
15806 298 Saratoga Ave Pruneridge Ave Santa Clara, CA 95050-6629
5444 5390 Great America Pkwy Old Mountain View-Alviso Rd Santa Clara, CA 95054-3602
24861 3500 Homestead Rd Princeton Way Santa Clara, CA 95051-5166
3363 2455 Lawrence Expy Monroe St Santa Clara, CA 95051-1453
15504 4185 Stevens Creek Blvd Kiely Blvd Santa Clara, CA 95051-7051
5004 500 Lawrence Expy Pruneridge Ave Santa Clara, CA 95051-5051
24859 14395 Big Basin Way Saratoga Sunnyvale Rd Saratoga, CA 95070-6089
490 150 Lawrence Expy Kifer Rd Sunnyvale, CA 94086-5328
5585 1040 Sunnyvale Saratoga Rd E Remington Dr Sunnyvale, CA 94087-2545
5000 1697 S Wolfe Rd E Homestead Rd Sunnyvale, CA 94087-4857
6065 117 W Maude Ave N Borregas Ave Sunnyvale, CA 94085-4349
5002 1296 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-2534
5445 860 W Fremont Ave Warner Ave Sunnyvale, CA 94087-3101
5001 750 S Bernardo Ave Brookfield Ave Sunnyvale, CA 94087-1009
18256 1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025
3317 1097 E Duane Ave Lawrence Expy Sunnyvale, CA 94085-2629
18764 898 E Fremont Ave S Wolfe Rd Sunnyvale, CA 94087-3601
3362 905 E El Camino Real S Wolfe Rd Sunnyvale, CA 94087-3740
18257 296 N Fair Oaks Ave E Arques Ave Sunnyvale, CA 94085-3801
3334 295 Lawrence Expy E Arques Ave Sunnyvale, CA 94085-4603
21794 996 W Evelyn Ave S Mary Ave Sunnyvale, CA 94086-5957
5446 1005 W El Camino Real S Mary Ave Sunnyvale, CA 94087-1030
5453 499 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4222
23418 498 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4221
5448 776 N Mathilda Ave Ahwanee Ave Sunnyvale, CA 94085-3510
18258 1037 Lakehaven Dr Lawrence Expy Sunnyvale, CA 94089-2029
5447 925 W Fremont Ave S Mary Ave Sunnyvale, CA 94087-3001
4998 1265 Lawrence Station Rd Elko Dr Sunnyvale, CA 94089-2219
5432 1101 N Lawrence Expy Lakehaven Dr Sunnyvale, CA 94089-2025
21793 724 N Mathilda Ave San Aleso Ave Sunnyvale, CA 94085-3510
10677 603 Old San Francisco Rd S Fair Oaks Ave Sunnyvale, CA 94086-7753
4111 699 San Antonio Rd Middlefield Rd Palo Alto, CA 94306-4712
12361 705 San Antonio Rd Middlefield Rd Palo Alto, CA 94303
18243 3601 El Camino Real Matadero Ave Palo Alto, CA 94306
18255 2495 De La Cruz Blvd Martin Ave Santa Clara, CA 95050-2922
20035 3751 Lafayette St Clyde Ave Santa Clara, CA 95054-2025
35726 18560 Prospect Rd Lawrence Expy Saratoga, CA 95070-3651
18759 698 N Fair Oaks Ave Caliente Dr Sunnyvale, CA 94085-3259
24630 801 N Fair Oaks Ave Ahwanee Ave Sunnyvale, CA 94085-3148
14696 1699 S De Anza Blvd Prospect Rd Cupertino, CA 95014-5301
15487 495 El Camino Real Middle Ave Menlo Park, CA 94025-5240
14335 275 El Camino Real Partridge Ave Menlo Park, CA 94025-5236
2523 1708 Miramonte Ave Cuesta Dr Mountain View, CA 94040-3763
2253 1963 El Camino Real Stanford Ave Palo Alto, CA 94306
2330 2200 El Camino Real College Ave Palo Alto, CA 94306
20551 12015 Saratoga Sunnyvale Rd Prospect Rd Saratoga, CA 95070-3022
5441 19990 Stevens Creek Blvd S Blaney Ave Cupertino, CA 95014-2306
3896 21530 Stevens Creek Blvd Bubb Rd Cupertino, CA 95014-1218
5440 10490 S De Anza Blvd Pacifica Dr Cupertino, CA 95014-3002
11578 20999 Stevens Creek Blvd N Stelling Rd Cupertino, CA 95014-2107
4028 10625 N De Anza Blvd Valley Green Dr Cupertino, CA 95014-2058
5022 584 N Rengstorff Ave W Middlefield Rd Mountain View, CA 94043-2814
24476 3972 El Camino Real Los Robles Ave Palo Alto, CA 94306-3318
14706 3897 El Camino Real Ventura Ave Palo Alto, CA 94306
3040 2800 Augustine Dr Bowers Ave Santa Clara, CA 95054-2801
24560 2181 Laurelwood Rd Montague Expy Santa Clara, CA 95054-2754
24863 2090 Scott Blvd Monroe St Santa Clara, CA 95050-3470
24855 12600 Saratoga Ave Bucknall Rd Saratoga, CA 95070-4189
6064 988 N San Antonio Rd Loucks Ave Los Altos, CA 94022-1331
21317 2025 El Camino Real Scott Blvd Santa Clara, CA 95050-4053
21318 1995 Warburton Ave Scott Blvd Santa Clara, CA 95050-4105
5020 1010 El Monte Ave Marich Way Mountain View, CA 94040-2321
5443 840 San Antonio Rd E Charleston Rd Palo Alto, CA 94303
4066 703 S Wolfe Rd Old San Francisco Rd Sunnyvale, CA 94086-8106
5018 4350 El Camino Real Los Altos Ave Los Altos, CA 94022-1001
14340 500 Willow Rd Coleman Ave Menlo Park, CA 94025-2617
1374 110 N Rengstorff Ave Central Expy Mountain View, CA 94043-4222
1922 835 San Antonio Rd E Charleston Rd Palo Alto, CA 94303
67386 2211 Monroe St Bailey Pl Santa Clara, CA 95050-3209
14355 201 La Cuesta Dr Alpine Rd Menlo Park, CA 94028-7532
23403 22510 Stevens Creek Blvd S Foothill Blvd Cupertino, CA 95014-5604
4112 1161 Embarcadero Rd W Bayshore Rd Palo Alto, CA 94303
24621 330 S San Antonio Rd Whitney St Los Altos, CA 94022-3614
62808 401 Main St  1st St Los Altos, CA 94022-2822
170604 830 Leong Drive Moffett Blvd Mountain View, CA 94043
14328 710 Willow Rd Okeefe St Menlo Park, CA 94025-2540
29985 2101 University Ave Donohoe St East Palo Alto, CA 94303-1715
24860 3305 El Camino Real Pomeroy Ave Santa Clara, CA 95051-2804
27183 36 Washington St Newhall St Santa Clara, CA 95050-6139
14327 2194 University Ave Bell St East Palo Alto, CA 94303-1714
14354 1399 Willow Rd Hamilton Ave Menlo Park, CA 94025-1515
68607 699 Ralston Ave Old County Rd Belmont, CA 94002-2833
68617 470 Ralston Ave Granada St Belmont, CA 94002-2830
14317 177 California Dr Howard Ave Burlingame, CA 94010-4322
12324 3035 Winchester Blvd W Hacienda Ave Campbell, CA 95008-6540
134943 950 W Hamilton Ave Marathon Dr Campbell, CA 95008-0406
24842 1370 Camden Ave Erin Way Campbell, CA 95008-6702
18859 921 W Hamilton Ave Marathon Dr Campbell, CA 95008-0405
35018 4698 Callan Blvd Serramonte Blvd Daly City, CA 94015-4316
18220 398 Gellert Blvd Hickey Blvd Daly City, CA 94015-2611
14321 390 Hickey Blvd Imperial Way Daly City, CA 94015-2761
24161 410 Hickey Blvd Imperial Way Daly City, CA 94015-2603
14325 501 Serramonte Blvd Gellert Blvd Daly City, CA 94015-4372
11571 880 E Hillsdale Blvd Edgewater Blvd Foster City, CA 94404-2401
14346 390 Foster City Blvd Chess Dr Foster City, CA 94404-1105
33647 7251 Camino Arroyo Gilman Rd Gilroy, CA 95020-7340
33645 6991 Monterey Rd W 10th St Gilroy, CA 95020-6625
33646 7000 Monterey St E 10th St Gilroy, CA 95020-6614
99717 5920 Travel Park Cir Garlic Farm Way Gilroy, CA 95020-8032
81018 7110 Camino Arroyo Renz Dr Gilroy, CA 95020-7347
33800 850 Pacheco Pass Rd Camino Arroyo Gilroy, CA 95020-7302
102474 501 Kelly Ave Cabrillo Hwy Half Moon Bay, CA 94019-1719
71120 120 San Mateo Rd Main St Half Moon Bay, CA 94019-1706
18221 201 San Mateo Rd Main St Half Moon Bay, CA 94019-1707
71130 375 Cabrillo Hwy Main St Half Moon Bay, CA 94019-1611
68316 15171 Los Gatos Blvd Lark Ave Los Gatos, CA 95032-2022
24877 400 Skyline Blvd Hillcrest Blvd Millbrae, CA 94030-2128
22766 17015 Monterey St W Dunne Ave Morgan Hill, CA 95037-3635
35738 16995 Monterey St W Dunne Ave Morgan Hill, CA 95037-5135
35696 100 Tennant Station Monterey St Morgan Hill, CA 95037-5478
14339 505 Linda Mar Blvd Coast Hwy Pacifica, CA 94044-3334
14368 765 Oddstad Blvd Terra Nova Blvd Pacifica, CA 94044-4427
15609 4475 CA-1 Fassler Ave Pacifica, CA 94044
18229 2095 Coast HWY Reina del Mar Ave Pacifica, CA 94044-3038
35697 105 Portola Rd Alpine Rd Portola Valley, CA 94028-7853
124084 2300 Middlefield Rd Woodside Rd Redwood City, CA 94063-2854
14359 610 Woodside Rd Hudson St Redwood City, CA 94061-3848
14216 895 Woodside Rd Horgan Ave Redwood City, CA 94061-3745
11572 1801 Woodside Rd Santa Clara Ave Redwood City, CA 94061-3334
27789 503 Whipple Ave Veterans Blvd Redwood City, CA 94063-1123
14333 504 Whipple Ave Veterans Blvd Redwood City, CA 94063-1124
71743 602 El Camino Real Hopkins Ave Redwood City, CA 94063-1318
18231 710 Woodside Rd Oxford St Redwood City, CA 94061-3744
15611 975 Woodside Rd Kentfield Ave Redwood City, CA 94061-3610
21024 1101 Broadway Woodside Rd Redwood City, CA 94063-3125
71752 215 El Camino Real Avondale Ave & Edgewood Rd Redwood City, CA 94062-1721
14526 582 Woodside Rd Hudson St Redwood City, CA 94061-3821
14370 639 Whipple Ave Winslow St Redwood City, CA 94063-1143
14334 585 Whipple Ave Winslow St Redwood City, CA 94063-1123
15612 1667 Woodside Rd Sequoia Ave Redwood City, CA 94061-3434
24947 2901 San Bruno Ave W Glenview Dr San Bruno, CA 94066-3718
23595 2101 San Bruno Ave W Shelter Creek Ln San Bruno, CA 94066-2836
14372 798 El Camino Real San Bruno Ave W San Bruno, CA 94066-3427
29036 2001 Rollingwood Dr Sneath Ln San Bruno, CA 94066-1929
24946 2000 Rollingwood Dr Sneath Ln San Bruno, CA 94066-1930
14371 1199 El Camino Real Sneath Ln San Bruno, CA 94066-2405
18238 512 El Camino Real Sylvan Ave San Bruno, CA 94066-4323
26635 888 El Camino Real Arroyo Ave San Carlos, CA 94070-4010
14394 1950 S Delaware St 19th Ave San Mateo, CA 94403-1426
11575 300 S Delaware St E 3rd Ave San Mateo, CA 94401-3326
12383 609 E 4th Ave S Delaware St San Mateo, CA 94401-3313
11606 404 19th Ave S Delaware St San Mateo, CA 94403-1460
23638 2800 S El Camino Real 28th Ave San Mateo, CA 94403-2729
23819 1641 Palm Ave 17th Ave San Mateo, CA 94402-2469
14182 611 E 3rd Ave S Delaware St San Mateo, CA 94401-3304
23596 1890 S Norfolk St Fashion Island Blvd San Mateo, CA 94403-1102
23600 254 E Hillsdale Blvd Saratoga Dr San Mateo, CA 94403-2819
23599 2300 S El Camino Real 23rd Ave San Mateo, CA 94403-2214
12380 880 N Delaware St Peninsula Ave San Mateo, CA 94401-1504
21330 2901 S Norfolk St E Hillsdale Blvd San Mateo, CA 94403-2017
23822 4095 Pacific Blvd Laurie Meadows Dr San Mateo, CA 94403-4666
23598 300 E Hillsdale Blvd Saratoga Dr San Mateo, CA 94403-2821
23597 790 Polhemus Rd De Anza Blvd San Mateo, CA 94402-3938
21329 1400 W Hillsdale Blvd Campus Dr San Mateo, CA 94403-3126
23637 1626 S El Camino Real Borel Ave San Mateo, CA 94402-3024
14224 1471 E 3rd Ave S Norfolk St San Mateo, CA 94401-2109
12382 451 S Airport Blvd Belle Air Rd South San Francisco, CA 94080-6909
11709 1600 El Camino Real McLellan Dr South San Francisco, CA 94080-1206
14401 110 Hickey Blvd El Camino Real South San Francisco, CA 94080
21079 698 El Camino Real W Orange Ave South San Francisco, CA 94080-4403
21076 1 Westborough Blvd El Camino Real South San Francisco, CA 94080-3162
18895 710 El Camino Real W Orange Ave South San Francisco, CA 94080-4405
37049 2950 Woodside Rd Whiskey Hill Rd Woodside, CA 94062-2444
24231 6989 Mission St Bismark St Daly City, CA 94014-2036
14345 1101 E Hillsdale Blvd Foster City Blvd Foster City, CA 94404-1609
14347 501 Foster City Blvd Triton Dr   Foster City, CA 94404-1602
33644 601 Leavesley Rd San Ysidro Ave Gilroy, CA 95020-3610
27180 17905 Monterey St Wright Ave Morgan Hill, CA 95037-3690
18881 1098 El Camino Real Brittan Ave San Carlos, CA 94070-4013
21077 209 El Camino Real Hazelwood Dr South San Francisco, CA 94080-5920
14308 701 Harbor Blvd Old County Rd Belmont, CA 94002-3925
18219 1876 El Camino Real Murchison Dr Burlingame, CA 94010-3102
14694 337 E Hamilton Ave N Central Ave Campbell, CA 95008-0247
3901 570 E Hamilton Ave Salmar Ave Campbell, CA 95008-0210
18222 5 El Camino Real Millbrae Ave Millbrae, CA 94030-2603
18225 1 Rollins Rd E Millbrae Ave Millbrae, CA 94030-3112
18227 491 El Camino Real Taylor Blvd Millbrae, CA 94030-2616
18224 320 E Millbrae Ave Rollins Rd Millbrae, CA 94030-3110
18223 501 El Camino Real Taylor Blvd Millbrae, CA 94030-2030
39049 16720 Monterey St San Pedro Ave Morgan Hill, CA 95037-5105
14701 17005 Condit Rd E Dunne Ave Morgan Hill, CA 95037-3301
24626 825 E Dunne Ave Laurel Ln Morgan Hill, CA 95037-4603
39051 15865 Monterey St Vineyard Blvd Morgan Hill, CA 95037-7122
18230 1700 Middlefield Rd Chestnut St Redwood City, CA 94063-2237
18232 690 Veterans Blvd Brewster Ave Redwood City, CA 94063-1409
40401 2215 El Camino Real Laurel St Redwood City, CA 94063-2805
69205 990 Veterans Blvd Main St Redwood City, CA 94063-1715
72800 1603 Broadway Chestnut St Redwood City, CA 94063-2401
18237 1799 El Camino Real Santa Lucia Ave San Bruno, CA 94066-5401
26636 907 Holly St Industrial Rd San Carlos, CA 94070-2539
14213 335 S Norfolk St Beacon Ave San Mateo, CA 94401-3010
15825 114 Harbor Way E Grand Ave South San Francisco, CA 94080-6108
15826 248 S Airport Blvd Mitchell Ave South San Francisco, CA 94080-6701
14318 1100 Broadway California Dr Burlingame, CA 94010-3422
14311 1000 Broadway Rollins Rd Burlingame, CA 94010-2415
14319 1390 Bayshore Hwy Burlway Rd Burlingame, CA 94010-1803
11587 1147 Rollins Rd Cadillac Way Burlingame, CA 94010-2502
14313 1101 Broadway California Dr Burlingame, CA 94010-3421
14312 1095 Carolan Ave Broadway Burlingame, CA 94010-2505
14320 601 California Dr Floribunda Ave Burlingame, CA 94010-3730
19689 2855 Winchester Blvd W Sunnyoaks Ave Campbell, CA 95008-5319
24160 295 Washington St Sullivan Ave Daly City, CA 94015-1943
24619 400 Leavesley Rd Murray Ave Gilroy, CA 95020-3609
33221 401 Leavesley Rd Murray Ave Gilroy, CA 95020-3608
24624 441 Leigh Ave Los Gatos Almaden Rd Los Gatos, CA 95032-4005
90570 16500 Lark Ave Los Gatos Blvd Los Gatos, CA 95032
12154 810 E Dunne Ave Walnut Grove Dr Morgan Hill, CA 95037-4609
18236 401 San Mateo Ave El Camino Real San Bruno, CA 94066-4415
26637 90 El Camino Real Hull Dr San Carlos, CA 94070-2426
18883 500 El Camino Real Holly St San Carlos, CA 94070-2412
26631 906 Holly St Industrial Rd San Carlos, CA 94070-2538
27006 195 El Camino Real Hull Dr San Carlos, CA 94070-2403
12384 706 E 4th Ave S El Dorado St San Mateo, CA 94401-3315
14400 400 Peninsula Ave Woodside Way San Mateo, CA 94401-1653
11592 402 S Delaware St E 4th Ave San Mateo, CA 94402-1353
14403 2300 Westborough Blvd Gellert Blvd South San Francisco, CA 94080-5407
77394 3964 Callan Blvd King Dr South San Francisco, CA 94080-5153
68612 995 Ralston Ave 6th Ave Belmont, CA 94002-2207
33802 1190 1st St Westwood Dr Gilroy, CA 95020-4862
68374 700 Blossom Hill Rd Los Gatos Blvd Los Gatos, CA 95032
14395 501 S Norfolk St Shoreview Ave San Mateo, CA 94401-3014
11595 402 N El Camino Real E Poplar Ave San Mateo, CA 94401-3710
12977 2015 Winchester Blvd W Campbell Ave Campbell, CA 95008-3419
108223 398 1st St Hanna St  Gilroy, CA 95020-5029
33799 7999 Westwood Dr 1st St Gilroy, CA 95020-4731
83871 18605 Monterey St Cochrane Rd Morgan Hill, CA 95037-3027
35740 14660 Monterey Rd E Middle Ave Morgan Hill, CA 95046-9547
18239 310 San Bruno Ave E 2nd Ave San Bruno, CA 94066-3627
8885 1589 S Bascom Ave E Hamilton Ave Campbell, CA 95008-0603
3900 2029 S Bascom Ave E Campbell Ave Campbell, CA 95008-3203
15486 950 Hillside Blvd E Market St Daly City, CA 94014-2312
68397 234 El Camino Real Edgewood Rd Redwood City, CA 94062-1722
24045 2700 Bayshore Blvd Geneva Ave Daly City, CA 94014-1632
20815 1533 W Campbell Ave N San Tomas Aquino Rd Campbell, CA 95008-1527
20816 1530 W Campbell Ave S San Tomas Aquino Rd Campbell, CA 95008-1528
14338 699 El Camino Real Brewster Ave Redwood City, CA 94063-1317
33959 8445 Cabrillo Hwy 8th St Montara, CA 94037
33960 9400 Cabrillo Hwy Vermont Ave Moss Beach, CA 94038-9625
24419 981 E Hamilton Ave S Bascom Ave Campbell, CA 95008-0648
117539 505 Skyline Dr Westmoor Ave Daly City, CA 94015-4611
23274 1860 W Campbell Ave Fulton St Campbell, CA 95008-1531
77466 15380 Los Gatos Blvd  Gateway Dr Los Gatos, CA 95032
85744 200 Los Gatos Saratoga Rd N Santa Cruz Ave Los Gatos, CA 95030
27179 255 Los Gatos Saratoga Rd Tait Ave Los Gatos, CA 95030-5316
69053 679 Hickey Blvd Gateway Dr Daly City, CA 94044
5019 601 Fremont Ave Riverside Dr Los Altos, CA 94024-4813
68386 16500 Los Gatos Blvd Spencer Ave Los Gatos, CA 95032
26319 700 Hickey Blvd Gateway Dr Pacifica, CA 94044-1213
1426 851 Cochrane Rd Madrone Pkwy Morgan Hill, CA 95037-2870
18228 498 Palmetto Ave W Manor Dr Pacifica, CA 94044-1841
93895 95 Bill Drake Way  Palmetto Ave Pacifica, CA 94044-1802
15710 100 Milagra Dr Oceana Blvd Pacifica, CA 94044-2327
38170 844 Fifth Ave Bay Rd Redwood City, CA 94063-3915
33649 2045 Ralston Ave Alameda De Las Pulgas Belmont, CA 94002-1737
32392 3001 Junipero Serra Blvd San Pedro Rd Daly City, CA 94014-2550
33809 700 1st St Miller Ave Gilroy, CA 95020-4916
24945 2690 Bayshore Blvd MacDonald Ave Daly City, CA 94014-1631
18242 123 Linden Ave Baden Ave South San Francisco, CA 94080-4701
21080 899 Airport Blvd Linden Ave South San Francisco, CA 94080-1801
18241 401 Linden Ave Miller Ave South San Francisco, CA 94080-3729
12381 300 S Airport Blvd Wonder Color Ln South San Francisco, CA 94080-6704
33022 892 John Daly Blvd Lake Merced Blvd Daly City, CA 94015-1045
24758 14000 Blossom Hill Rd Harwood Rd Los Gatos, CA 95032-5117
15488 125 Sharon Park Dr Sand Hill Rd Menlo Park, CA 94025-6846
33218 601 1st St Carmel St Gilroy, CA 95020-5033
18235 717 San Bruno Ave E 6th Ave San Bruno, CA 94066-3234
14215 35 S Linden Ave S Canal St South San Francisco, CA 94080-6407
15827 140 Produce Ave San Mateo Ave South San Francisco, CA 94080-6510
33650 3139 Jefferson Ave Alameda de las Pulgas Redwood City, CA 94062-2959
102505 5887 Monterey Rd Garlic Farm Dr Gilroy, CA 95020-9587
22517 3405 Winchester Blvd E Division St Campbell, CA 95008-6844
21025 3233 Middlefield Rd Sixth Ave Menlo Park, CA 94025-1827
18226 1009 El Camino Real Meadow Glen Ave Millbrae, CA 94030-2013
24620 5920 Travel Park Circle Garlic Farms Way Gilroy, CA 95020-8032
12437 800 El Camino Real San Bruno Ave W San Bruno, CA 94066-3137
11882 176 Gateway Blvd E Grand Ave South San Francisco, CA 94080-7049
33020 151 Southgate Ave Lake Merced Blvd Daly City, CA 94015-3160
14322 2195 Junipero Serra Blvd Citrus Ave Daly City, CA 94014-1907
24044 101 S Mayfair Ave Poncetta Dr Daly City, CA 94015-1246
18233 2108 Roosevelt Ave Upton St Redwood City, CA 94061-1304
87276 666 N Santa Cruz Ave Blossom Hill Rd Los Gatos, CA 95030
15485 2000 Ralston Ave Villa Ave Belmont, CA 94002-1738
23639 700 Polhemus Rd Bunker Hill Dr San Mateo, CA 94402-3938
14214 246 S Spruce Ave Myrtle Ave South San Francisco, CA 94080-4550
79938 590 Canyon Rd Oak Knoll Dr Redwood City, CA 94062-3020
18234 2303 Spring St  Charter St Redwood City, CA 94063-3017
33143 2428 Junipero Serra Blvd 88th St Daly City, CA 94015-1631
30490 1216 Hillside Blvd A St Daly City, CA 94014-3005
14309 1480 Broadway El Camino Real Burlingame, CA 94010-3428
38171 795 5th Ave Spring St Redwood City, CA 94063-3912
4999 1300 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-3241
24159 1690 Sullivan Ave Pierce St Daly City, CA 94015-1941
117637 17286 Skyline Blvd La Honda Rd Woodside, CA 94062-5707
108220 304 Leavesley Rd Forest St  Gilroy, CA 95020-3607
12292 2140 Winchester Blvd E Rincon Ave Campbell, CA 95008-3422
24618 390 Leavesley Rd Murray Ave Gilroy, CA 95020-3607
4068 3471 Lafayette St Aldo Ave Santa Clara, CA 95054-2707
2302 370 E Hamilton Ave N Central Ave Campbell, CA 95008-0209
5442 310 N Whisman Rd E Middlefield Rd Mountain View, CA 94043
27178 15299 Los Gatos Blvd Garden Ln Los Gatos, CA 95032-2513
5431 19030 Stevens Creek Blvd Judy Ave Cupertino, CA 95014-2502
24627 25 Washington St Newhall St Santa Clara, CA 95050-6130
14402 221 Airport Blvd Grand Ave South San Francisco, CA 94080-4741

In [169]:
for station_id, loc in locations.items():
    if loc:
        print("{0},\"{1}\",{2},{3}".format(station_id, loc.address, loc.latitude, loc.longitude))


4030,"10002 N De Anza Blvd, Cupertino, CA 95014, USA",37.3233881,-122.031775
10588,"10023 S De Anza Blvd, Cupertino, CA 95014, USA",37.3225474,-122.0327352
24622,"929 Fremont Ave, Los Altos Hills, CA 94024, USA",37.354072,-122.088676
21026,"3401 Middlefield Rd, Menlo Park, CA 94025, USA",37.470637,-122.2018526
2550,"790 W Middlefield Rd, Mountain View, CA 94043, USA",37.40240319999999,-122.0746349
5021,"808 W Middlefield Rd, Mountain View, CA 94043, USA",37.4027409,-122.0744995
2551,"807 W Middlefield Rd, Mountain View, CA 94043, USA",37.4034812,-122.0750682
5023,"334 San Antonio Rd, Mountain View, CA 94040, USA",37.4057671,-122.1115097
1274,"45 W El Camino Real, Mountain View, CA 94040, USA",37.3802487,-122.0735976
3366,"1601 Coleman Ave, Santa Clara, CA 95050, USA",37.3571955,-121.9390321
15501,"3480 Homestead Rd, Santa Clara, CA 95051, USA",37.3375681,-121.9925939
15806,"Pruneridge Ave, Santa Clara, CA 95050, USA",37.3299577,-121.9590566
5004,"500 Lawrence Expy, Santa Clara, CA 95051, USA",37.3317165,-121.99595
490,"150 Lawrence Station Rd, Sunnyvale, CA 94086, USA",37.3713248,-121.9941119
6065,"117 W Maude Ave, Sunnyvale, CA 94085, USA",37.3887177,-122.0264364
5445,"860 Warner Ave, Sunnyvale, CA 94087, USA",37.3520427,-122.0484812
18764,"898 N Wolfe Rd, Sunnyvale, CA 94085, USA",37.3837069,-122.0141017
21794,"996 Mary Evelyn Dr, San Jose, CA 95123, USA",37.2283966,-121.8341257
18258,"1037 Lakehaven Dr, Sunnyvale, CA 94089, USA",37.3964369,-121.9970684
4998,"1265 Lawrence Station Rd, Sunnyvale, CA 94089, USA",37.4059137,-121.9961508
10677,"603 Old San Francisco Rd, Sunnyvale, CA 94086, USA",37.367653,-122.022535
18255,"2495 De La Cruz Blvd, Santa Clara, CA 95050, USA",37.3663062,-121.9411486
14696,"1699 S De Anza Blvd, Cupertino, CA 95014, USA",37.2942887,-122.0326298
14335,"275 El Camino Real, Menlo Park, CA 94025, USA",37.4487312,-122.1751301
20551,"12015 Saratoga Sunnyvale Rd, Saratoga, CA 95070, USA",37.2936062,-122.0328269
5022,"584 N Rengstorff Ave, Mountain View, CA 94043, USA",37.4114282,-122.0930948
24560,"2181 Laurelwood Rd, Santa Clara, CA 95054, USA",37.3843199,-121.9620266
24863,"2090 Scott Blvd, Santa Clara, CA 95050, USA",37.360778,-121.9601311
6064,"988 N San Antonio Rd, Los Altos, CA 94022, USA",37.399846,-122.1145759
4066,"854 Old San Francisco Rd, Sunnyvale, CA 94086, USA",37.3662839,-122.0169509
14340,"500 Coleman Ave, Menlo Park, CA 94025, USA",37.4616602,-122.1600963
1922,"835 San Antonio Rd, Palo Alto, CA 94303, USA",37.4216074,-122.1022659
4112,"1161 Embarcadero Rd, Palo Alto, CA 94303, USA",37.44724,-122.125827
14328,"710 Okeefe St, Menlo Park, CA 94025, USA",37.4638912,-122.1578014
29985,"Donohoe St, East Palo Alto, CA 94303, USA",37.4627033,-122.142644
27183,"Newhall St, Santa Clara, CA 95050, USA",37.3377148,-121.9413046
14327,"Bell St, East Palo Alto, CA 94303, USA",37.4655891,-122.1409568
14354,"1399 Hamilton Ave, Menlo Park, CA 94025, USA",37.4777723,-122.1492287
14317,"177 Howard Ave, Burlingame, CA 94010, USA",37.5845773,-122.3352076
134943,"950 W Hamilton Ave, Campbell, CA 95008, USA",37.2937317,-121.9657519
18220,"398 Gellert Blvd, Daly City, CA 94015, USA",37.664917,-122.46946
14325,"501 Gellert Blvd, Daly City, CA 94015, USA",37.66145789999999,-122.4687883
33647,"7251 Camino Arroyo, Gilroy, CA 95020, USA",37.0083814,-121.5566111
99717,"5920 Travel Park Cir, Gilroy, CA 95020, USA",36.9849134,-121.5557849
33800,"7210 Camino Arroyo # 106, Gilroy, CA 95020, USA",37.0089557,-121.5538244
71120,"120 Main St, Half Moon Bay, CA 94019, USA",37.4693459,-122.4315594
35738,"16995 Monterey Rd, Morgan Hill, CA 95037, USA",37.1249181,-121.6501173
14339,"Pacifica, CA 94044, USA",37.584178,-122.486442
15609,"Fassler Ave, Pacifica, CA 94044, USA",37.6005159,-122.4874725
35697,"7853 Alpine Rd, Portola Valley, CA 94028, USA",37.34204769999999,-122.2020287
14359,"610 Hudson St, Redwood City, CA 94061, USA",37.4772489,-122.2364659
11572,"Santa Clara Ave, Redwood City, CA 94061, USA",37.4505457,-122.2253481
18231,"710 Oxford St, Redwood City, CA 94061, USA",37.4706494,-122.2299804
15611,"975 Kentfield Ave, Redwood City, CA 94061, USA",37.4682079,-122.2325198
14526,"582 Hudson St, Redwood City, CA 94062, USA",37.4774327,-122.2367005
15612,"Sequoia Ave, Redwood City, CA 94061, USA",37.4524888,-122.2243816
24947,"Glenview Dr, San Bruno, CA 94066, USA",37.6205106,-122.4415352
23595,"2101 Shelter Creek Ln, San Bruno, CA 94066, USA",37.619843,-122.428366
14372,"798 El Camino Real, San Bruno, CA 94066, USA",37.628657,-122.416196
29036,"2001 Rollingwood Dr, San Bruno, CA 94066, USA",37.6301945,-122.4366865
12383,"609 E 4th Ave, San Mateo, CA 94401, USA",37.5667929,-122.319122
23819,"1641 Palm Ave, San Mateo, CA 94402, USA",37.5534636,-122.3126031
23600,"Saratoga Dr, San Mateo, CA 94403, USA",37.5460193,-122.2953329
12380,"880 N Delaware St, San Mateo, CA 94401, USA",37.5804021,-122.3341259
23822,"Laurie Meadows Dr, San Mateo, CA 94403, USA",37.53184359999999,-122.2843995
23598,"Saratoga Dr, San Mateo, CA 94403, USA",37.5460193,-122.2953329
21329,"1400 Campus Dr, San Mateo, CA 94403, USA",37.5367258,-122.3239319
37049,"Whiskey Hill Rd, Woodside, CA 94062, USA",37.4206439,-122.2439828
14345,"1101 Foster City Blvd, Foster City, CA 94404, USA",37.5538278,-122.2551935
14347,"Triton Dr, Foster City, CA 94404, USA",37.564431,-122.2698698
14694,"337 E Hamilton Ave, Campbell, CA 95008, USA",37.2945539,-121.9439233
18224,"200 Rollins Rd, Millbrae, CA 94030, USA",37.600025,-122.387183
18230,"1700 Middlefield Rd, Redwood City, CA 94063, USA",37.4819245,-122.22144
18232,"690 Veterans Blvd, Redwood City, CA 94063, USA",37.4913221,-122.2310576
15826,"111 Mitchell Ave, South San Francisco, CA 94080, USA",37.6495037,-122.4044027
14318,"1100 Broadway, Burlingame, CA 94010, USA",37.5874984,-122.3640599
19689,"2855 Winchester Blvd, Campbell, CA 95008, USA",37.2719534,-121.954675
18236,"401 El Camino Real, San Bruno, CA 94066, USA",37.6216429,-122.4117647
27006,"195 El Camino Real, San Carlos, CA 94070, USA",37.5121502,-122.2657066
12384,"706 E 4th Ave, San Mateo, CA 94401, USA",37.5669011,-122.3181914
14400,"1505 Woodside Rd, Redwood City, CA 94061, USA",37.4564956,-122.2277797
68374,"700 Blossom Hill Rd, Los Gatos, CA 95032, USA",37.2352252,-121.962704
12977,"2509 Winchester Blvd, Campbell, CA 95008, USA",37.2794488,-121.9508662
18239,"310 2nd Ave, San Bruno, CA 94066, USA",37.6249362,-122.4073147
8885,"1589 E Hamilton Ave, Campbell, CA 95008, USA",37.29441600000001,-121.9322064
3900,"E Campbell Ave, Campbell, CA 95008, USA",37.2870871,-121.9366533
24045,"2700 Geneva Ave, Daly City, CA 94014, USA",37.7067696,-122.4156761
20815,"1533 S San Tomas Aquino Rd, Campbell, CA 95008, USA",37.2805894,-121.9777367
20816,"1530 S San Tomas Aquino Rd, Campbell, CA 95008, USA",37.2691284,-121.9722765
33959,"8445 Cabrillo Hwy, Montara, CA 94037, USA",37.5416467,-122.5157743
24419,"981 E Hamilton Ave, Campbell, CA 95008, USA",37.2949069,-121.9321128
23274,"Fulton St, Campbell, CA 95008, USA",37.2849919,-121.9824725
77466,"Gateway Dr, Los Gatos, CA 95032, USA",37.24598659999999,-121.9572167
85744,"200 Saratoga Los Gatos Rd, Los Gatos, CA 95030, USA",37.22945170000001,-121.9811326
68386,"16500 Spencer Ave, Los Gatos, CA 95032, USA",37.2284408,-121.9653386
15710,"100 Milagra Dr, Pacifica, CA 94044, USA",37.6458323,-122.4909392
32392,"3001 Junipero Serra Blvd, Daly City, CA 94014, USA",37.6866068,-122.4702924
24945,"MacDonald Ave, Daly City, CA 94014, USA",37.70618890000001,-122.4098617
18241,"401 Linden Ave, South San Francisco, CA 94080, USA",37.6563811,-122.4098673
15827,"219 S San Mateo Dr, San Mateo, CA 94401, USA",37.5649477,-122.3245029
33650,"3139 Jefferson Ave, Redwood City, CA 94062, USA",37.4695857,-122.2467551
102505,"5887 Monterey Rd, Gilroy, CA 95020, USA",36.9843968,-121.5577523
24620,"5920 Travel Park Cir, Gilroy, CA 95020, USA",36.9849134,-121.5557849
11882,"Rand Ave, Oakland, CA 94610, USA",37.8112953,-122.2451399
33020,"151 Southgate Ave, Daly City, CA 94015, USA",37.6971786,-122.4833333
18233,"2108 Upton St, Redwood City, CA 94061, USA",37.4664839,-122.241549
87276,"666 N Santa Cruz Ave, Los Gatos, CA 95030, USA",37.2353545,-121.977285
2302,"370 E Hamilton Ave, Campbell, CA 95008, USA",37.2940145,-121.9432447
5442,"310 E Middlefield Rd, Mountain View, CA 94043, USA",37.3972447,-122.0593265
27178,"15299 Garden Ln, Los Gatos, CA 95032, USA",37.2460281,-121.9583548
24627,"Newhall St, Santa Clara, CA 95050, USA",37.3377148,-121.9413046
14344,"3201 El Camino Real, Atherton, CA 94027, USA",37.4672615,-122.2085332
3898,"19550 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226857,-122.0146754
14343,"1200 El Camino Real, Menlo Park, CA 94025, USA",37.4546956,-122.184417
14330,"1380 El Camino Real, Menlo Park, CA 94025, USA",37.4558736,-122.1868615
1051,"1288 W El Camino Real, Mountain View, CA 94040, USA",37.3885421,-122.0886162
4063,"3740 El Camino Real, Santa Clara, CA 95051, USA",37.3519021,-121.998781
1373,"101 E El Camino Real, Mountain View, CA 94040, USA",37.37989,-122.0729094
5024,"59 W El Camino Real, Mountain View, CA 94040, USA",37.3807009,-122.0745955
26311,"495 Moffett Blvd, Mountain View, CA 94043, USA",37.3999171,-122.0730247
3363,"2455 Lawrence Expy, Santa Clara, CA 95051, USA",37.3665207,-121.9955382
24859,"14395 Big Basin Way, Saratoga, CA 95070, USA",37.2595184,-122.0324297
5446,"1005 W El Camino Real, Sunnyvale, CA 94087, USA",37.37231140000001,-122.0489535
5453,"499 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3894997,-122.0311046
5448,"776 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3953283,-122.0283161
5447,"925 W Fremont Ave, Sunnyvale, CA 94087, USA",37.3525608,-122.0516256
12361,"705 San Antonio Rd, Palo Alto, CA 94303, USA",37.4167336,-122.1036466
18243,"3601 El Camino Real, Palo Alto, CA 94306, USA",37.41879900000001,-122.133202
2523,"1708 Miramonte Ave, Mountain View, CA 94040, USA",37.3731445,-122.0874172
2253,"1963 El Camino Real, Palo Alto, CA 94306, USA",37.4281669,-122.1492135
2330,"2200 El Camino Real, Palo Alto, CA 94306, USA",37.4256823,-122.1475717
5441,"19990 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3224757,-122.0227974
4028,"10625 N De Anza Blvd, Cupertino, CA 95014, USA",37.3321694,-122.0327595
14706,"3897 El Camino Real, Palo Alto, CA 94306, USA",37.4172891,-122.1302921
3040,"2800 Augustine Dr, Santa Clara, CA 95054, USA",37.3821107,-121.97839
5018,"4350 El Camino Real, Los Altos, CA 94022, USA",37.404101,-122.1182024
14355,"201 La Cuesta Dr, Portola Valley, CA 94028, USA",37.4027681,-122.1930214
23403,"22510 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.321588,-122.0681706
170604,"830 Leong Dr, Mountain View, CA 94043, USA",37.4052523,-122.067024
12324,"3035 Winchester Blvd, Campbell, CA 95008, USA",37.2696252,-121.9562234
18859,"921 W Hamilton Ave, Campbell, CA 95008, USA",37.2945224,-121.9655613
35018,"4698 Callan Blvd, Daly City, CA 94015, USA",37.6690312,-122.4749403
14321,"Shell Car wash, 390 Hickey Blvd, Daly City, CA 94015, USA",37.6637457,-122.4637933
11571,"880 E Hillsdale Blvd, Foster City, CA 94404, USA",37.5537815,-122.2774724
14346,"390 Foster City Blvd, Foster City, CA 94404, USA",37.564867,-122.2755846
102474,"501 Kelly Ave, Half Moon Bay, CA 94019, USA",37.4644308,-122.4334313
18221,"201 San Mateo Rd, Half Moon Bay, CA 94019, USA",37.4676174,-122.4296766
71130,"375 Cabrillo Hwy, Half Moon Bay, CA 94019, USA",37.4725397,-122.4354503
68316,"15171 Los Gatos Blvd, Los Gatos, CA 95032, USA",37.2484687,-121.9565062
24877,"400 Skyline Blvd, Millbrae, CA 94030, USA",37.5899283,-122.4120203
22766,"17015 Monterey Rd, Morgan Hill, CA 95037, USA",37.12541179999999,-121.6507078
14368,"765 Oddstad Blvd, Pacifica, CA 94044, USA",37.5837264,-122.4740135
124084,"2300 Middlefield Rd, Redwood City, CA 94063, USA",37.4783934,-122.2162731
14216,"895 Woodside Rd, Redwood City, CA 94061, USA",37.4646051,-122.2242495
71743,"602 El Camino Real, Redwood City, CA 94063, USA",37.488624,-122.2380526
24946,"2000 Rollingwood Dr, San Bruno, CA 94066, USA",37.6303808,-122.4363566
18238,"512 El Camino Real, San Bruno, CA 94066, USA",37.6237076,-122.4126685
26635,"888 El Camino Real, San Carlos, CA 94070, USA",37.503231,-122.2560388
11575,"300 S Delaware St, San Mateo, CA 94401, USA",37.566802,-122.3200717
23599,"2300 S El Camino Real, San Mateo, CA 94403, USA",37.5453918,-122.3070982
23637,"1626 S El Camino Real, San Mateo, CA 94402, USA",37.5526006,-122.3151468
14224,"1471 E 3rd Ave, San Mateo, CA 94401, USA",37.5733019,-122.3117882
12382,"451 S Airport Blvd, South San Francisco, CA 94080, USA",37.6424644,-122.4005569
14401,"110 Hickey Blvd, South San Francisco, CA 94080, USA",37.6666459,-122.4523082
21079,"698 El Camino Real, South San Francisco, CA 94080, USA",37.65012919999999,-122.4301603
21076,"1 Westborough Blvd, South San Francisco, CA 94080, USA",37.6550488,-122.4343653
27180,"17905 Monterey Rd, Morgan Hill, CA 95037, USA",37.134998,-121.6590039
18881,"1098 El Camino Real, San Carlos, CA 94070, USA",37.500762,-122.2530284
18222,"5 El Camino Real, Millbrae, CA 94030, USA",37.59837,-122.3882342
18227,"491 El Camino Real, Millbrae, CA 94030, USA",37.6027075,-122.3932113
18223,"501 El Camino Real, Millbrae, CA 94030, USA",37.60307359999999,-122.3936499
40401,"2215 El Camino Real, Redwood City, CA 94063, USA",37.4760258,-122.2204291
26636,"907 Holly St, San Carlos, CA 94070, USA",37.511558,-122.2579051
15825,"114 Harbor Way, South San Francisco, CA 94080, USA",37.6537747,-122.40076
14320,"601 California Dr, Burlingame, CA 94010, USA",37.5816598,-122.3505965
24624,"441 Leigh Ave, Los Gatos, CA 95032, USA",37.2432408,-121.9231377
90570,"16500 Lark Ave, Los Gatos, CA 95032, USA",37.2479686,-121.9574046
14403,"2300 Westborough Blvd, South San Francisco, CA 94080, USA",37.6434721,-122.4535456
14395,"501 S Norfolk St, San Mateo, CA 94401, USA",37.5717304,-122.3093277
11595,"402 N El Camino Real, San Mateo, CA 94401, USA",37.5703288,-122.3355555
83871,"18605 Monterey Rd, Morgan Hill, CA 95037, USA",37.14454569999999,-121.6650928
35740,"14660 Monterey Rd, Morgan Hill, CA 95037, USA",37.1047203,-121.630602
15486,"950 Hillside Blvd, Daly City, CA 94014, USA",37.6903469,-122.4615547
14338,"699 El Camino Real, Redwood City, CA 94063, USA",37.4877463,-122.2360099
5019,"601 Fremont Ave, Los Altos, CA 94024, USA",37.36158770000001,-122.098762
38170,"844 Fifth Ave, Redwood City, CA 94063, USA",37.4812404,-122.198454
33022,"892 John Daly Blvd, Daly City, CA 94015, USA",37.7020206,-122.4839414
15488,"125 Sharon Park Dr, Menlo Park, CA 94025, USA",37.4239353,-122.1961347
18235,"717 San Bruno Ave E, San Bruno, CA 94066, USA",37.6310801,-122.4064441
12437,"800 El Camino Real, San Bruno, CA 94066, USA",37.6293435,-122.4166572
79938,"590 Canyon Rd, Emerald Hills, CA 94062, USA",37.4718088,-122.2606758
30490,"1216 Hillside Blvd, Daly City, CA 94014, USA",37.6858002,-122.4598765
14402,"221 Airport Blvd, South San Francisco, CA 94080, USA",37.654572,-122.4082951
18883,"500 El Camino Real, San Carlos, CA 94070, USA",37.5081856,-122.2619431
18895,"710 El Camino Real, South San Francisco, CA 94080, USA",37.6505991,-122.4303466

In [72]:
print(len(locations))
print(len(failures))


252
84

In [76]:
for station_id, address in failures.items():
    print("{0},{1}".format(station_id, address))


14344,3201 El Camino Real Fifth Ave Atherton, CA 94027-3843
3898,19550 Stevens Creek Blvd Miller Ave Cupertino, CA 95014-2404
14343,1200 El Camino Real Oak Grove Ave Menlo Park, CA 94025-4209
14330,1380 El Camino Real Glenwood Ave Menlo Park, CA 94025-4211
1373,101 E El Camino Real Grant Rd Mountain View, CA 94040-2701
5024,59 W El Camino Real Bay St Mountain View, CA 94040-2601
26311,495 Moffett Blvd W Middlefield Rd Mountain View, CA 94043
1051,1288 W El Camino Real S Shoreline Blvd Mountain View, CA 94040-2402
4063,3740 El Camino Real Halford Ave Santa Clara, CA 95051-2606
3363,2455 Lawrence Expy Monroe St Santa Clara, CA 95051-1453
24859,14395 Big Basin Way Saratoga Sunnyvale Rd Saratoga, CA 95070-6089
5446,1005 W El Camino Real S Mary Ave Sunnyvale, CA 94087-1030
5453,499 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4222
5448,776 N Mathilda Ave Ahwanee Ave Sunnyvale, CA 94085-3510
5447,925 W Fremont Ave S Mary Ave Sunnyvale, CA 94087-3001
12361,705 San Antonio Rd Middlefield Rd Palo Alto, CA 94303
18243,3601 El Camino Real Matadero Ave Palo Alto, CA 94306
2523,1708 Miramonte Ave Cuesta Dr Mountain View, CA 94040-3763
2253,1963 El Camino Real Stanford Ave Palo Alto, CA 94306
2330,2200 El Camino Real College Ave Palo Alto, CA 94306
5441,19990 Stevens Creek Blvd S Blaney Ave Cupertino, CA 95014-2306
4028,10625 N De Anza Blvd Valley Green Dr Cupertino, CA 95014-2058
14706,3897 El Camino Real Ventura Ave Palo Alto, CA 94306
3040,2800 Augustine Dr Bowers Ave Santa Clara, CA 95054-2801
5018,4350 El Camino Real Los Altos Ave Los Altos, CA 94022-1001
14355,201 La Cuesta Dr Alpine Rd Menlo Park, CA 94028-7532
23403,22510 Stevens Creek Blvd S Foothill Blvd Cupertino, CA 95014-5604
170604,830 Leong Drive Moffett Blvd Mountain View, CA 94043
12324,3035 Winchester Blvd W Hacienda Ave Campbell, CA 95008-6540
18859,921 W Hamilton Ave Marathon Dr Campbell, CA 95008-0405
35018,4698 Callan Blvd Serramonte Blvd Daly City, CA 94015-4316
14321,390 Hickey Blvd Imperial Way Daly City, CA 94015-2761
11571,880 E Hillsdale Blvd Edgewater Blvd Foster City, CA 94404-2401
14346,390 Foster City Blvd Chess Dr Foster City, CA 94404-1105
102474,501 Kelly Ave Cabrillo Hwy Half Moon Bay, CA 94019-1719
18221,201 San Mateo Rd Main St Half Moon Bay, CA 94019-1707
71130,375 Cabrillo Hwy Main St Half Moon Bay, CA 94019-1611
68316,15171 Los Gatos Blvd Lark Ave Los Gatos, CA 95032-2022
24877,400 Skyline Blvd Hillcrest Blvd Millbrae, CA 94030-2128
22766,17015 Monterey St W Dunne Ave Morgan Hill, CA 95037-3635
14368,765 Oddstad Blvd Terra Nova Blvd Pacifica, CA 94044-4427
124084,2300 Middlefield Rd Woodside Rd Redwood City, CA 94063-2854
14216,895 Woodside Rd Horgan Ave Redwood City, CA 94061-3745
71743,602 El Camino Real Hopkins Ave Redwood City, CA 94063-1318
24946,2000 Rollingwood Dr Sneath Ln San Bruno, CA 94066-1930
18238,512 El Camino Real Sylvan Ave San Bruno, CA 94066-4323
26635,888 El Camino Real Arroyo Ave San Carlos, CA 94070-4010
11575,300 S Delaware St E 3rd Ave San Mateo, CA 94401-3326
23599,2300 S El Camino Real 23rd Ave San Mateo, CA 94403-2214
23637,1626 S El Camino Real Borel Ave San Mateo, CA 94402-3024
14224,1471 E 3rd Ave S Norfolk St San Mateo, CA 94401-2109
12382,451 S Airport Blvd Belle Air Rd South San Francisco, CA 94080-6909
14401,110 Hickey Blvd El Camino Real South San Francisco, CA 94080
21079,698 El Camino Real W Orange Ave South San Francisco, CA 94080-4403
21076,1 Westborough Blvd El Camino Real South San Francisco, CA 94080-3162
18895,710 El Camino Real W Orange Ave South San Francisco, CA 94080-4405
27180,17905 Monterey St Wright Ave Morgan Hill, CA 95037-3690
18881,1098 El Camino Real Brittan Ave San Carlos, CA 94070-4013
18222,5 El Camino Real Millbrae Ave Millbrae, CA 94030-2603
18227,491 El Camino Real Taylor Blvd Millbrae, CA 94030-2616
18223,501 El Camino Real Taylor Blvd Millbrae, CA 94030-2030
40401,2215 El Camino Real Laurel St Redwood City, CA 94063-2805
26636,907 Holly St Industrial Rd San Carlos, CA 94070-2539
15825,114 Harbor Way E Grand Ave South San Francisco, CA 94080-6108
14320,601 California Dr Floribunda Ave Burlingame, CA 94010-3730
24624,441 Leigh Ave Los Gatos Almaden Rd Los Gatos, CA 95032-4005
90570,16500 Lark Ave Los Gatos Blvd Los Gatos, CA 95032
18883,500 El Camino Real Holly St San Carlos, CA 94070-2412
14403,2300 Westborough Blvd Gellert Blvd South San Francisco, CA 94080-5407
14395,501 S Norfolk St Shoreview Ave San Mateo, CA 94401-3014
11595,402 N El Camino Real E Poplar Ave San Mateo, CA 94401-3710
83871,18605 Monterey St Cochrane Rd Morgan Hill, CA 95037-3027
35740,14660 Monterey Rd E Middle Ave Morgan Hill, CA 95046-9547
15486,950 Hillside Blvd E Market St Daly City, CA 94014-2312
14338,699 El Camino Real Brewster Ave Redwood City, CA 94063-1317
5019,601 Fremont Ave Riverside Dr Los Altos, CA 94024-4813
38170,844 Fifth Ave Bay Rd Redwood City, CA 94063-3915
33022,892 John Daly Blvd Lake Merced Blvd Daly City, CA 94015-1045
15488,125 Sharon Park Dr Sand Hill Rd Menlo Park, CA 94025-6846
18235,717 San Bruno Ave E 6th Ave San Bruno, CA 94066-3234
12437,800 El Camino Real San Bruno Ave W San Bruno, CA 94066-3137
79938,590 Canyon Rd Oak Knoll Dr Redwood City, CA 94062-3020
30490,1216 Hillside Blvd A St Daly City, CA 94014-3005
14402,221 Airport Blvd Grand Ave South San Francisco, CA 94080-4741

In [123]:
failures_1 = pd.read_csv('data/failures_1.csv', header=None, names=['station_id', 'address', 'zip'], index_col = 0)
failures_1.head(5)


Out[123]:
address zip
station_id
14344 3201 El Camino Real Atherton CA 94027-3843
3898 19550 Stevens Creek Blvd Cupertino CA 95014-2404
14343 1200 El Camino Real Menlo Park CA 94025-4209
14330 1380 El Camino Real Menlo Park CA 94025-4211
1373 101 E El Camino Real Mountain View CA 94040-2701

In [87]:
geolocator.geocode(failures_1.iloc[0].address)


Out[87]:
Location(3201 El Camino Real, Atherton, CA 94027, USA, (37.4672615, -122.2085332, 0.0))

In [89]:
failures_2 = {} # station_id to address
for station_id,data in failures_1.iterrows():
    print(station_id, data.address)
    try:
        loc = geolocator.geocode(data.address)
    except Exception as e:
        failures_2[station_id] = data.address
    else:
        locations[station_id] = loc


14344 3201 El Camino Real Atherton
3898 19550 Stevens Creek Blvd Cupertino
14343 1200 El Camino Real Menlo Park
14330 1380 El Camino Real Menlo Park
1373 101 E El Camino Real Mountain View
5024 59 W El Camino Real Mountain View
26311 495 Moffett Blvd Mountain View
1051 1288 W El Camino Real Mountain View
4063 3740 El Camino Real Santa Clara
3363 2455 Lawrence Expy Santa Clara
24859 14395 Big Basin Way Saratoga
5446 1005 W El Camino Real Sunnyvale
5453 499 N Mathilda Ave Sunnyvale
5448 776 N Mathilda Ave Sunnyvale
5447 925 W Fremont Ave Sunnyvale
12361 705 San Antonio Rd Palo Alto
18243 3601 El Camino Real Palo Alto
2523 1708 Miramonte Ave Mountain View
2253 1963 El Camino Real Palo Alto
2330 2200 El Camino Real Palo Alto
5441 19990 Stevens Creek Blvd Cupertino
4028 10625 N De Anza Blvd Cupertino
14706 3897 El Camino Real Palo Alto
3040 2800 Augustine Dr Santa Clara
5018 4350 El Camino Real Los Altos
14355 201 La Cuesta Dr Menlo Park
23403 22510 Stevens Creek Blvd Cupertino
170604 830 Leong Drive Mountain View
12324 3035 Winchester Blvd Campbell
18859 921 W Hamilton Ave Campbell
35018 4698 Callan Blvd Daly City
14321 390 Hickey Blvd Daly City
11571 880 E Hillsdale Blvd Foster City
14346 390 Foster City Blvd Foster City
102474 501 Kelly Ave Half Moon Bay
18221 201 San Mateo Rd Half Moon Bay
71130 375 Cabrillo Hwy Half Moon Bay
68316 15171 Los Gatos Blvd Los Gatos
24877 400 Skyline Blvd Millbrae
22766 17015 Monterey St Morgan Hill
14368 765 Oddstad Blvd Pacifica
124084 2300 Middlefield Rd Woodside Rd Redwood City
14216 895 Woodside Rd Redwood City
71743 602 El Camino Real Redwood City
24946 2000 Rollingwood Dr San Bruno
18238 512 El Camino Real San Bruno
26635 888 El Camino Real San Carlos
11575 300 S Delaware St San Mateo
23599 2300 S El Camino Real San Mateo
23637 1626 S El Camino Real San Mateo
14224 1471 E 3rd Ave San Mateo
12382 451 S Airport Blvd South San Francisco
14401 110 Hickey Blvd South San Francisco
21079 698 El Camino Real South San Francisco
21076 1 Westborough Blvd South San Francisco
18895 710 El Camino Real South San Francisco
27180 17905 Monterey Morgan Hill
18881 1098 El Camino Real San Carlos
18222 5 El Camino Real Millbrae
18227 491 El Camino Real Millbrae
18223 501 El Camino Real Millbrae
40401 2215 El Camino Real Redwood City
26636 907 Holly St San Carlos
15825 114 Harbor Way South San Francisco
14320 601 California Dr Burlingame
24624 441 Leigh Ave Los Gatos
90570 16500 Lark Ave Los Gatos
18883 500 El Camino Real San Carlos
14403 2300 Westborough Blvd South San Francisco
14395 501 S Norfolk St San Mateo
11595 402 N El Camino Real San Mateo
83871 18605 Monterey Morgan Hill
35740 14660 Monterey Rd Morgan Hill
15486 950 Hillside Blvd Daly City
14338 699 El Camino Real Redwood City
5019 601 Fremont Ave Los Altos
38170 844 Fifth Ave Redwood City
33022 892 John Daly Blvd Daly City
15488 125 Sharon Park Dr Menlo Park
18235 717 San Bruno Ave San Bruno
12437 800 El Camino Real W San Bruno
79938 590 Canyon Rd Dr Redwood City
30490 1216 Hillside Blvd Daly City
14402 221 Airport Blvd South San Francisco

In [90]:
print(len(locations))
print(len(failures_2))


334
2

In [91]:
print(failures_2)


{18895: '710 El Camino Real South San Francisco', 18883: '500 El Camino Real San Carlos'}

In [97]:
locations[18895] = geolocator.geocode('710 El Camino Real, South San Francisco, CA 94080')

In [95]:
locations[18883] = geolocator.geocode('500 El Camino Real, San Carlos, CA 94070')

In [98]:
len(locations)


Out[98]:
336

In [117]:
failures_4 = []
locations_2 = {}
for station_id, loc in locations.items():
    if loc:
        locations_2[station_id] = loc
    else:
        failures_4.append(station_id)

In [120]:
print(len(locations_2))
print(len(failures_4))


194
142

In [136]:
failures_1.index


Out[136]:
Int64Index([ 14344,   3898,  14343,  14330,   1373,   5024,  26311,   1051,
              4063,   3363,  24859,   5446,   5453,   5448,   5447,  12361,
             18243,   2523,   2253,   2330,   5441,   4028,  14706,   3040,
              5018,  14355,  23403, 170604,  12324,  18859,  35018,  14321,
             11571,  14346, 102474,  18221,  71130,  68316,  24877,  22766,
             14368, 124084,  14216,  71743,  24946,  18238,  26635,  11575,
             23599,  23637,  14224,  12382,  14401,  21079,  21076,  18895,
             27180,  18881,  18222,  18227,  18223,  40401,  26636,  15825,
             14320,  24624,  90570,  18883,  14403,  14395,  11595,  83871,
             35740,  15486,  14338,   5019,  38170,  33022,  15488,  18235,
             12437,  79938,  30490,  14402],
           dtype='int64', name='station_id')

In [105]:
print(locations[490].address)
print(locations[490].latitude)
print(locations[490].longitude)


150 Lawrence Station Rd, Sunnyvale, CA 94086, USA
37.3713248
-121.9941119

In [179]:
def print_locations_dict(locations):
    for station_id, loc in locations.items():
        if loc:
            print("{0},\"{1}\",{2},{3}".format(station_id, loc.address, loc.latitude, loc.longitude))

In [149]:
def google_geocoding(stations_df, skip):
    locations = {} # station_id to google location object
    failures = {} # station_id to address string
    for station_id,data in stations_df.iterrows():
        if station_id in skip:
            continue
        print("{0},\"{1}\"".format(station_id, data.address))
        try:
            loc = geolocator.geocode(data.address)
        except Exception as e:
            print(e)
            failures[station_id] = data.address
        else:
            locations[station_id] = loc
        time.sleep(3) # rate limiting
    return locations, failures

In [150]:
locations_3, failures_5 = google_geocoding(stations, locations_2.keys())


5017,"11010 N De Anza Blvd Homestead Rd Cupertino, CA 95014-0443"
3895,"21855 Homestead Rd S Bernardo Ave Cupertino, CA 95014-0111"
5253,"5696 Stevens Creek Blvd Stern Ave Cupertino, CA 95014-3662"
2074,"2300 Homestead Rd Foothill Expy Los Altos, CA 94024-7338"
14332,"1110 Marsh Rd Scott Dr Menlo Park, CA 94025-1014"
14341,"3600 Alameda De Las Pulgas Avy Ave Menlo Park, CA 94025-6214"
4027,"789 E Evelyn Ave S Bernardo Ave Mountain View, CA 94041-1614"
1273,"1220 Grant Rd Bentley Sq Mountain View, CA 94040-3227"
18857,"3725 El Camino Real Halford Ave Santa Clara, CA 95051-2804"
15497,"2800 Homestead Rd Kiely Blvd Santa Clara, CA 95051-3041"
5003,"3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404"
18254,"3501 Homestead Rd Bing Dr Santa Clara, CA 95051-5116"
24864,"2320 El Camino Real Los Padres Blvd Santa Clara, CA 95050-4059"
5444,"5390 Great America Pkwy Old Mountain View-Alviso Rd Santa Clara, CA 95054-3602"
24861,"3500 Homestead Rd Princeton Way Santa Clara, CA 95051-5166"
15504,"4185 Stevens Creek Blvd Kiely Blvd Santa Clara, CA 95051-7051"
5585,"1040 Sunnyvale Saratoga Rd E Remington Dr Sunnyvale, CA 94087-2545"
5000,"1697 S Wolfe Rd E Homestead Rd Sunnyvale, CA 94087-4857"
5002,"1296 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-2534"
5001,"750 S Bernardo Ave Brookfield Ave Sunnyvale, CA 94087-1009"
18256,"1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025"
Service timed out
3317,"1097 E Duane Ave Lawrence Expy Sunnyvale, CA 94085-2629"
3362,"905 E El Camino Real S Wolfe Rd Sunnyvale, CA 94087-3740"
Service timed out
18257,"296 N Fair Oaks Ave E Arques Ave Sunnyvale, CA 94085-3801"
3334,"295 Lawrence Expy E Arques Ave Sunnyvale, CA 94085-4603"
23418,"498 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4221"
5432,"1101 N Lawrence Expy Lakehaven Dr Sunnyvale, CA 94089-2025"
21793,"724 N Mathilda Ave San Aleso Ave Sunnyvale, CA 94085-3510"
4111,"699 San Antonio Rd Middlefield Rd Palo Alto, CA 94306-4712"
20035,"3751 Lafayette St Clyde Ave Santa Clara, CA 95054-2025"
Service timed out
35726,"18560 Prospect Rd Lawrence Expy Saratoga, CA 95070-3651"
18759,"698 N Fair Oaks Ave Caliente Dr Sunnyvale, CA 94085-3259"
24630,"801 N Fair Oaks Ave Ahwanee Ave Sunnyvale, CA 94085-3148"
15487,"495 El Camino Real Middle Ave Menlo Park, CA 94025-5240"
Service timed out
3896,"21530 Stevens Creek Blvd Bubb Rd Cupertino, CA 95014-1218"
5440,"10490 S De Anza Blvd Pacifica Dr Cupertino, CA 95014-3002"
Service timed out
11578,"20999 Stevens Creek Blvd N Stelling Rd Cupertino, CA 95014-2107"
24476,"3972 El Camino Real Los Robles Ave Palo Alto, CA 94306-3318"
Service timed out
24855,"12600 Saratoga Ave Bucknall Rd Saratoga, CA 95070-4189"
21317,"2025 El Camino Real Scott Blvd Santa Clara, CA 95050-4053"
Service timed out
21318,"1995 Warburton Ave Scott Blvd Santa Clara, CA 95050-4105"
5020,"1010 El Monte Ave Marich Way Mountain View, CA 94040-2321"
5443,"840 San Antonio Rd E Charleston Rd Palo Alto, CA 94303"
1374,"110 N Rengstorff Ave Central Expy Mountain View, CA 94043-4222"
Service timed out
67386,"2211 Monroe St Bailey Pl Santa Clara, CA 95050-3209"
24621,"330 S San Antonio Rd Whitney St Los Altos, CA 94022-3614"
62808,"401 Main St  1st St Los Altos, CA 94022-2822"
24860,"3305 El Camino Real Pomeroy Ave Santa Clara, CA 95051-2804"
Service timed out
68607,"699 Ralston Ave Old County Rd Belmont, CA 94002-2833"
68617,"470 Ralston Ave Granada St Belmont, CA 94002-2830"
24842,"1370 Camden Ave Erin Way Campbell, CA 95008-6702"
24161,"410 Hickey Blvd Imperial Way Daly City, CA 94015-2603"
33645,"6991 Monterey Rd W 10th St Gilroy, CA 95020-6625"
33646,"7000 Monterey St E 10th St Gilroy, CA 95020-6614"
81018,"7110 Camino Arroyo Renz Dr Gilroy, CA 95020-7347"
35696,"100 Tennant Station Monterey St Morgan Hill, CA 95037-5478"
Service timed out
18229,"2095 Coast HWY Reina del Mar Ave Pacifica, CA 94044-3038"
Service timed out
27789,"503 Whipple Ave Veterans Blvd Redwood City, CA 94063-1123"
Service timed out
14333,"504 Whipple Ave Veterans Blvd Redwood City, CA 94063-1124"
Service timed out
21024,"1101 Broadway Woodside Rd Redwood City, CA 94063-3125"
71752,"215 El Camino Real Avondale Ave & Edgewood Rd Redwood City, CA 94062-1721"
14370,"639 Whipple Ave Winslow St Redwood City, CA 94063-1143"
14334,"585 Whipple Ave Winslow St Redwood City, CA 94063-1123"
14371,"1199 El Camino Real Sneath Ln San Bruno, CA 94066-2405"
Service timed out
14394,"1950 S Delaware St 19th Ave San Mateo, CA 94403-1426"
11606,"404 19th Ave S Delaware St San Mateo, CA 94403-1460"
23638,"2800 S El Camino Real 28th Ave San Mateo, CA 94403-2729"
Service timed out
14182,"611 E 3rd Ave S Delaware St San Mateo, CA 94401-3304"
23596,"1890 S Norfolk St Fashion Island Blvd San Mateo, CA 94403-1102"
Service timed out
21330,"2901 S Norfolk St E Hillsdale Blvd San Mateo, CA 94403-2017"
23597,"790 Polhemus Rd De Anza Blvd San Mateo, CA 94402-3938"
11709,"1600 El Camino Real McLellan Dr South San Francisco, CA 94080-1206"
Service timed out
24231,"6989 Mission St Bismark St Daly City, CA 94014-2036"
33644,"601 Leavesley Rd San Ysidro Ave Gilroy, CA 95020-3610"
21077,"209 El Camino Real Hazelwood Dr South San Francisco, CA 94080-5920"
Service timed out
14308,"701 Harbor Blvd Old County Rd Belmont, CA 94002-3925"
18219,"1876 El Camino Real Murchison Dr Burlingame, CA 94010-3102"
Service timed out
3901,"570 E Hamilton Ave Salmar Ave Campbell, CA 95008-0210"
Service timed out
18225,"1 Rollins Rd E Millbrae Ave Millbrae, CA 94030-3112"
Service timed out
39049,"16720 Monterey St San Pedro Ave Morgan Hill, CA 95037-5105"
14701,"17005 Condit Rd E Dunne Ave Morgan Hill, CA 95037-3301"
24626,"825 E Dunne Ave Laurel Ln Morgan Hill, CA 95037-4603"
39051,"15865 Monterey St Vineyard Blvd Morgan Hill, CA 95037-7122"
Service timed out
69205,"990 Veterans Blvd Main St Redwood City, CA 94063-1715"
Service timed out
72800,"1603 Broadway Chestnut St Redwood City, CA 94063-2401"
18237,"1799 El Camino Real Santa Lucia Ave San Bruno, CA 94066-5401"
Service timed out
14213,"335 S Norfolk St Beacon Ave San Mateo, CA 94401-3010"
14311,"1000 Broadway Rollins Rd Burlingame, CA 94010-2415"
Service timed out
14319,"1390 Bayshore Hwy Burlway Rd Burlingame, CA 94010-1803"
11587,"1147 Rollins Rd Cadillac Way Burlingame, CA 94010-2502"
14313,"1101 Broadway California Dr Burlingame, CA 94010-3421"
14312,"1095 Carolan Ave Broadway Burlingame, CA 94010-2505"
24160,"295 Washington St Sullivan Ave Daly City, CA 94015-1943"
24619,"400 Leavesley Rd Murray Ave Gilroy, CA 95020-3609"
Service timed out
33221,"401 Leavesley Rd Murray Ave Gilroy, CA 95020-3608"
12154,"810 E Dunne Ave Walnut Grove Dr Morgan Hill, CA 95037-4609"
26637,"90 El Camino Real Hull Dr San Carlos, CA 94070-2426"
Service timed out
26631,"906 Holly St Industrial Rd San Carlos, CA 94070-2538"
11592,"402 S Delaware St E 4th Ave San Mateo, CA 94402-1353"
Service timed out
77394,"3964 Callan Blvd King Dr South San Francisco, CA 94080-5153"
Service timed out
68612,"995 Ralston Ave 6th Ave Belmont, CA 94002-2207"
33802,"1190 1st St Westwood Dr Gilroy, CA 95020-4862"
108223,"398 1st St Hanna St  Gilroy, CA 95020-5029"
33799,"7999 Westwood Dr 1st St Gilroy, CA 95020-4731"
Service timed out
68397,"234 El Camino Real Edgewood Rd Redwood City, CA 94062-1722"
33960,"9400 Cabrillo Hwy Vermont Ave Moss Beach, CA 94038-9625"
Service timed out
117539,"505 Skyline Dr Westmoor Ave Daly City, CA 94015-4611"
27179,"255 Los Gatos Saratoga Rd Tait Ave Los Gatos, CA 95030-5316"
69053,"679 Hickey Blvd Gateway Dr Daly City, CA 94044"
26319,"700 Hickey Blvd Gateway Dr Pacifica, CA 94044-1213"
Service timed out
1426,"851 Cochrane Rd Madrone Pkwy Morgan Hill, CA 95037-2870"
18228,"498 Palmetto Ave W Manor Dr Pacifica, CA 94044-1841"
Service timed out
93895,"95 Bill Drake Way  Palmetto Ave Pacifica, CA 94044-1802"
Service timed out
15710,"100 Milagra Dr Oceana Blvd Pacifica, CA 94044-2327"
33649,"2045 Ralston Ave Alameda De Las Pulgas Belmont, CA 94002-1737"
33809,"700 1st St Miller Ave Gilroy, CA 95020-4916"
18242,"123 Linden Ave Baden Ave South San Francisco, CA 94080-4701"
21080,"899 Airport Blvd Linden Ave South San Francisco, CA 94080-1801"
12381,"300 S Airport Blvd Wonder Color Ln South San Francisco, CA 94080-6704"
24758,"14000 Blossom Hill Rd Harwood Rd Los Gatos, CA 95032-5117"
33218,"601 1st St Carmel St Gilroy, CA 95020-5033"
14215,"35 S Linden Ave S Canal St South San Francisco, CA 94080-6407"
22517,"3405 Winchester Blvd E Division St Campbell, CA 95008-6844"
Service timed out
21025,"3233 Middlefield Rd Sixth Ave Menlo Park, CA 94025-1827"
18226,"1009 El Camino Real Meadow Glen Ave Millbrae, CA 94030-2013"
Service timed out
14322,"2195 Junipero Serra Blvd Citrus Ave Daly City, CA 94014-1907"
24044,"101 S Mayfair Ave Poncetta Dr Daly City, CA 94015-1246"
15485,"2000 Ralston Ave Villa Ave Belmont, CA 94002-1738"
Service timed out
23639,"700 Polhemus Rd Bunker Hill Dr San Mateo, CA 94402-3938"
14214,"246 S Spruce Ave Myrtle Ave South San Francisco, CA 94080-4550"
18234,"2303 Spring St  Charter St Redwood City, CA 94063-3017"
33143,"2428 Junipero Serra Blvd 88th St Daly City, CA 94015-1631"
14309,"1480 Broadway El Camino Real Burlingame, CA 94010-3428"
38171,"795 5th Ave Spring St Redwood City, CA 94063-3912"
Service timed out
4999,"1300 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-3241"
24159,"1690 Sullivan Ave Pierce St Daly City, CA 94015-1941"
117637,"17286 Skyline Blvd La Honda Rd Woodside, CA 94062-5707"
108220,"304 Leavesley Rd Forest St  Gilroy, CA 95020-3607"
12292,"2140 Winchester Blvd E Rincon Ave Campbell, CA 95008-3422"
24618,"390 Leavesley Rd Murray Ave Gilroy, CA 95020-3607"
4068,"3471 Lafayette St Aldo Ave Santa Clara, CA 95054-2707"
5431,"19030 Stevens Creek Blvd Judy Ave Cupertino, CA 95014-2502"

In [166]:
print(len(locations_2))
print(len(locations_3))
print(len(failures_5))


194
104
38

In [164]:
locations_4 = {}
for station_id, loc in locations.items():
    if loc:
        locations_4[station_id] = loc
for station_id, loc in locations_3.items():
    if loc:
        locations_4[station_id] = loc

In [165]:
print(len(locations_4))


195

In [171]:
locations_4 = locations.copy()
locations_4.update(locations_2)
locations_4.update(locations_3)
locations_4.update(locations_4)

locations_5 = {}
for k,v in locations_4.items():
    if v:
        locations_5[k] = v
        
print(len(locations_5))


195

In [172]:
def successive_google_geocoding(stations_df, base_locations):
    locations = base_locations.copy()
    while len(locations) < 336:
        temp_locations, temp_failures = google_geocoding(stations_df, locations.keys())
        print(len(temp_locations))
        print(len(temp_failures))
        locations.update(temp_locations)
    return locations

In [174]:
locations_6 = successive_google_geocoding(stations, locations_5)


5017,"11010 N De Anza Blvd Homestead Rd Cupertino, CA 95014-0443"
3895,"21855 Homestead Rd S Bernardo Ave Cupertino, CA 95014-0111"
5253,"5696 Stevens Creek Blvd Stern Ave Cupertino, CA 95014-3662"
2074,"2300 Homestead Rd Foothill Expy Los Altos, CA 94024-7338"
14332,"1110 Marsh Rd Scott Dr Menlo Park, CA 94025-1014"
14341,"3600 Alameda De Las Pulgas Avy Ave Menlo Park, CA 94025-6214"
4027,"789 E Evelyn Ave S Bernardo Ave Mountain View, CA 94041-1614"
1273,"1220 Grant Rd Bentley Sq Mountain View, CA 94040-3227"
18857,"3725 El Camino Real Halford Ave Santa Clara, CA 95051-2804"
Service timed out
15497,"2800 Homestead Rd Kiely Blvd Santa Clara, CA 95051-3041"
5003,"3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404"
Service timed out
18254,"3501 Homestead Rd Bing Dr Santa Clara, CA 95051-5116"
24864,"2320 El Camino Real Los Padres Blvd Santa Clara, CA 95050-4059"
5444,"5390 Great America Pkwy Old Mountain View-Alviso Rd Santa Clara, CA 95054-3602"
24861,"3500 Homestead Rd Princeton Way Santa Clara, CA 95051-5166"
15504,"4185 Stevens Creek Blvd Kiely Blvd Santa Clara, CA 95051-7051"
5585,"1040 Sunnyvale Saratoga Rd E Remington Dr Sunnyvale, CA 94087-2545"
5000,"1697 S Wolfe Rd E Homestead Rd Sunnyvale, CA 94087-4857"
Service timed out
5002,"1296 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-2534"
5001,"750 S Bernardo Ave Brookfield Ave Sunnyvale, CA 94087-1009"
18256,"1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025"
Service timed out
3317,"1097 E Duane Ave Lawrence Expy Sunnyvale, CA 94085-2629"
3362,"905 E El Camino Real S Wolfe Rd Sunnyvale, CA 94087-3740"
18257,"296 N Fair Oaks Ave E Arques Ave Sunnyvale, CA 94085-3801"
3334,"295 Lawrence Expy E Arques Ave Sunnyvale, CA 94085-4603"
23418,"498 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4221"
5432,"1101 N Lawrence Expy Lakehaven Dr Sunnyvale, CA 94089-2025"
21793,"724 N Mathilda Ave San Aleso Ave Sunnyvale, CA 94085-3510"
4111,"699 San Antonio Rd Middlefield Rd Palo Alto, CA 94306-4712"
20035,"3751 Lafayette St Clyde Ave Santa Clara, CA 95054-2025"
35726,"18560 Prospect Rd Lawrence Expy Saratoga, CA 95070-3651"
18759,"698 N Fair Oaks Ave Caliente Dr Sunnyvale, CA 94085-3259"
24630,"801 N Fair Oaks Ave Ahwanee Ave Sunnyvale, CA 94085-3148"
15487,"495 El Camino Real Middle Ave Menlo Park, CA 94025-5240"
3896,"21530 Stevens Creek Blvd Bubb Rd Cupertino, CA 95014-1218"
5440,"10490 S De Anza Blvd Pacifica Dr Cupertino, CA 95014-3002"
Service timed out
11578,"20999 Stevens Creek Blvd N Stelling Rd Cupertino, CA 95014-2107"
Service timed out
24476,"3972 El Camino Real Los Robles Ave Palo Alto, CA 94306-3318"
24855,"12600 Saratoga Ave Bucknall Rd Saratoga, CA 95070-4189"
21317,"2025 El Camino Real Scott Blvd Santa Clara, CA 95050-4053"
21318,"1995 Warburton Ave Scott Blvd Santa Clara, CA 95050-4105"
5020,"1010 El Monte Ave Marich Way Mountain View, CA 94040-2321"
5443,"840 San Antonio Rd E Charleston Rd Palo Alto, CA 94303"
1374,"110 N Rengstorff Ave Central Expy Mountain View, CA 94043-4222"
67386,"2211 Monroe St Bailey Pl Santa Clara, CA 95050-3209"
Service timed out
24621,"330 S San Antonio Rd Whitney St Los Altos, CA 94022-3614"
62808,"401 Main St  1st St Los Altos, CA 94022-2822"
24860,"3305 El Camino Real Pomeroy Ave Santa Clara, CA 95051-2804"
68607,"699 Ralston Ave Old County Rd Belmont, CA 94002-2833"
68617,"470 Ralston Ave Granada St Belmont, CA 94002-2830"
24842,"1370 Camden Ave Erin Way Campbell, CA 95008-6702"
24161,"410 Hickey Blvd Imperial Way Daly City, CA 94015-2603"
33645,"6991 Monterey Rd W 10th St Gilroy, CA 95020-6625"
33646,"7000 Monterey St E 10th St Gilroy, CA 95020-6614"
81018,"7110 Camino Arroyo Renz Dr Gilroy, CA 95020-7347"
35696,"100 Tennant Station Monterey St Morgan Hill, CA 95037-5478"
18229,"2095 Coast HWY Reina del Mar Ave Pacifica, CA 94044-3038"
27789,"503 Whipple Ave Veterans Blvd Redwood City, CA 94063-1123"
14333,"504 Whipple Ave Veterans Blvd Redwood City, CA 94063-1124"
21024,"1101 Broadway Woodside Rd Redwood City, CA 94063-3125"
71752,"215 El Camino Real Avondale Ave & Edgewood Rd Redwood City, CA 94062-1721"
14370,"639 Whipple Ave Winslow St Redwood City, CA 94063-1143"
14334,"585 Whipple Ave Winslow St Redwood City, CA 94063-1123"
14371,"1199 El Camino Real Sneath Ln San Bruno, CA 94066-2405"
14394,"1950 S Delaware St 19th Ave San Mateo, CA 94403-1426"
11606,"404 19th Ave S Delaware St San Mateo, CA 94403-1460"
23638,"2800 S El Camino Real 28th Ave San Mateo, CA 94403-2729"
Service timed out
14182,"611 E 3rd Ave S Delaware St San Mateo, CA 94401-3304"
23596,"1890 S Norfolk St Fashion Island Blvd San Mateo, CA 94403-1102"
21330,"2901 S Norfolk St E Hillsdale Blvd San Mateo, CA 94403-2017"
23597,"790 Polhemus Rd De Anza Blvd San Mateo, CA 94402-3938"
11709,"1600 El Camino Real McLellan Dr South San Francisco, CA 94080-1206"
24231,"6989 Mission St Bismark St Daly City, CA 94014-2036"
33644,"601 Leavesley Rd San Ysidro Ave Gilroy, CA 95020-3610"
21077,"209 El Camino Real Hazelwood Dr South San Francisco, CA 94080-5920"
14308,"701 Harbor Blvd Old County Rd Belmont, CA 94002-3925"
18219,"1876 El Camino Real Murchison Dr Burlingame, CA 94010-3102"
3901,"570 E Hamilton Ave Salmar Ave Campbell, CA 95008-0210"
18225,"1 Rollins Rd E Millbrae Ave Millbrae, CA 94030-3112"
39049,"16720 Monterey St San Pedro Ave Morgan Hill, CA 95037-5105"
Service timed out
14701,"17005 Condit Rd E Dunne Ave Morgan Hill, CA 95037-3301"
24626,"825 E Dunne Ave Laurel Ln Morgan Hill, CA 95037-4603"
39051,"15865 Monterey St Vineyard Blvd Morgan Hill, CA 95037-7122"
Service timed out
69205,"990 Veterans Blvd Main St Redwood City, CA 94063-1715"
72800,"1603 Broadway Chestnut St Redwood City, CA 94063-2401"
18237,"1799 El Camino Real Santa Lucia Ave San Bruno, CA 94066-5401"
14213,"335 S Norfolk St Beacon Ave San Mateo, CA 94401-3010"
14311,"1000 Broadway Rollins Rd Burlingame, CA 94010-2415"
14319,"1390 Bayshore Hwy Burlway Rd Burlingame, CA 94010-1803"
11587,"1147 Rollins Rd Cadillac Way Burlingame, CA 94010-2502"
14313,"1101 Broadway California Dr Burlingame, CA 94010-3421"
14312,"1095 Carolan Ave Broadway Burlingame, CA 94010-2505"
24160,"295 Washington St Sullivan Ave Daly City, CA 94015-1943"
24619,"400 Leavesley Rd Murray Ave Gilroy, CA 95020-3609"
33221,"401 Leavesley Rd Murray Ave Gilroy, CA 95020-3608"
12154,"810 E Dunne Ave Walnut Grove Dr Morgan Hill, CA 95037-4609"
26637,"90 El Camino Real Hull Dr San Carlos, CA 94070-2426"
26631,"906 Holly St Industrial Rd San Carlos, CA 94070-2538"
11592,"402 S Delaware St E 4th Ave San Mateo, CA 94402-1353"
Service timed out
77394,"3964 Callan Blvd King Dr South San Francisco, CA 94080-5153"
Service timed out
68612,"995 Ralston Ave 6th Ave Belmont, CA 94002-2207"
33802,"1190 1st St Westwood Dr Gilroy, CA 95020-4862"
108223,"398 1st St Hanna St  Gilroy, CA 95020-5029"
33799,"7999 Westwood Dr 1st St Gilroy, CA 95020-4731"
68397,"234 El Camino Real Edgewood Rd Redwood City, CA 94062-1722"
33960,"9400 Cabrillo Hwy Vermont Ave Moss Beach, CA 94038-9625"
117539,"505 Skyline Dr Westmoor Ave Daly City, CA 94015-4611"
27179,"255 Los Gatos Saratoga Rd Tait Ave Los Gatos, CA 95030-5316"
69053,"679 Hickey Blvd Gateway Dr Daly City, CA 94044"
26319,"700 Hickey Blvd Gateway Dr Pacifica, CA 94044-1213"
1426,"851 Cochrane Rd Madrone Pkwy Morgan Hill, CA 95037-2870"
18228,"498 Palmetto Ave W Manor Dr Pacifica, CA 94044-1841"
93895,"95 Bill Drake Way  Palmetto Ave Pacifica, CA 94044-1802"
33649,"2045 Ralston Ave Alameda De Las Pulgas Belmont, CA 94002-1737"
33809,"700 1st St Miller Ave Gilroy, CA 95020-4916"
18242,"123 Linden Ave Baden Ave South San Francisco, CA 94080-4701"
21080,"899 Airport Blvd Linden Ave South San Francisco, CA 94080-1801"
12381,"300 S Airport Blvd Wonder Color Ln South San Francisco, CA 94080-6704"
24758,"14000 Blossom Hill Rd Harwood Rd Los Gatos, CA 95032-5117"
33218,"601 1st St Carmel St Gilroy, CA 95020-5033"
14215,"35 S Linden Ave S Canal St South San Francisco, CA 94080-6407"
22517,"3405 Winchester Blvd E Division St Campbell, CA 95008-6844"
21025,"3233 Middlefield Rd Sixth Ave Menlo Park, CA 94025-1827"
18226,"1009 El Camino Real Meadow Glen Ave Millbrae, CA 94030-2013"
Service timed out
14322,"2195 Junipero Serra Blvd Citrus Ave Daly City, CA 94014-1907"
24044,"101 S Mayfair Ave Poncetta Dr Daly City, CA 94015-1246"
15485,"2000 Ralston Ave Villa Ave Belmont, CA 94002-1738"
23639,"700 Polhemus Rd Bunker Hill Dr San Mateo, CA 94402-3938"
14214,"246 S Spruce Ave Myrtle Ave South San Francisco, CA 94080-4550"
18234,"2303 Spring St  Charter St Redwood City, CA 94063-3017"
33143,"2428 Junipero Serra Blvd 88th St Daly City, CA 94015-1631"
14309,"1480 Broadway El Camino Real Burlingame, CA 94010-3428"
38171,"795 5th Ave Spring St Redwood City, CA 94063-3912"
Service timed out
4999,"1300 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-3241"
24159,"1690 Sullivan Ave Pierce St Daly City, CA 94015-1941"
117637,"17286 Skyline Blvd La Honda Rd Woodside, CA 94062-5707"
108220,"304 Leavesley Rd Forest St  Gilroy, CA 95020-3607"
12292,"2140 Winchester Blvd E Rincon Ave Campbell, CA 95008-3422"
24618,"390 Leavesley Rd Murray Ave Gilroy, CA 95020-3607"
4068,"3471 Lafayette St Aldo Ave Santa Clara, CA 95054-2707"
5431,"19030 Stevens Creek Blvd Judy Ave Cupertino, CA 95014-2502"
127
14
18857,"3725 El Camino Real Halford Ave Santa Clara, CA 95051-2804"
5003,"3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404"
Service timed out
5000,"1697 S Wolfe Rd E Homestead Rd Sunnyvale, CA 94087-4857"
18256,"1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025"
Service timed out
5440,"10490 S De Anza Blvd Pacifica Dr Cupertino, CA 95014-3002"
11578,"20999 Stevens Creek Blvd N Stelling Rd Cupertino, CA 95014-2107"
67386,"2211 Monroe St Bailey Pl Santa Clara, CA 95050-3209"
23638,"2800 S El Camino Real 28th Ave San Mateo, CA 94403-2729"
39049,"16720 Monterey St San Pedro Ave Morgan Hill, CA 95037-5105"
39051,"15865 Monterey St Vineyard Blvd Morgan Hill, CA 95037-7122"
11592,"402 S Delaware St E 4th Ave San Mateo, CA 94402-1353"
Service timed out
77394,"3964 Callan Blvd King Dr South San Francisco, CA 94080-5153"
18226,"1009 El Camino Real Meadow Glen Ave Millbrae, CA 94030-2013"
38171,"795 5th Ave Spring St Redwood City, CA 94063-3912"
Service timed out
10
4
5003,"3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404"
18256,"1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025"
11592,"402 S Delaware St E 4th Ave San Mateo, CA 94402-1353"
38171,"795 5th Ave Spring St Redwood City, CA 94063-3912"
4
0

In [175]:
locations_6


Out[175]:
{490: Location(150 Lawrence Station Rd, Sunnyvale, CA 94086, USA, (37.3713248, -121.9941119, 0.0)),
 1051: Location(1288 W El Camino Real, Mountain View, CA 94040, USA, (37.3885421, -122.0886162, 0.0)),
 1273: None,
 1274: Location(45 W El Camino Real, Mountain View, CA 94040, USA, (37.3802487, -122.0735976, 0.0)),
 1373: Location(101 E El Camino Real, Mountain View, CA 94040, USA, (37.37989, -122.0729094, 0.0)),
 1374: None,
 1426: None,
 1922: Location(835 San Antonio Rd, Palo Alto, CA 94303, USA, (37.4216074, -122.1022659, 0.0)),
 2074: None,
 2253: Location(1963 El Camino Real, Palo Alto, CA 94306, USA, (37.4281669, -122.1492135, 0.0)),
 2302: Location(370 E Hamilton Ave, Campbell, CA 95008, USA, (37.2940145, -121.9432447, 0.0)),
 2330: Location(2200 El Camino Real, Palo Alto, CA 94306, USA, (37.4256823, -122.1475717, 0.0)),
 2523: Location(1708 Miramonte Ave, Mountain View, CA 94040, USA, (37.3731445, -122.0874172, 0.0)),
 2550: Location(790 W Middlefield Rd, Mountain View, CA 94043, USA, (37.40240319999999, -122.0746349, 0.0)),
 2551: Location(807 W Middlefield Rd, Mountain View, CA 94043, USA, (37.4034812, -122.0750682, 0.0)),
 3040: Location(2800 Augustine Dr, Santa Clara, CA 95054, USA, (37.3821107, -121.97839, 0.0)),
 3317: None,
 3334: None,
 3362: None,
 3363: Location(2455 Lawrence Expy, Santa Clara, CA 95051, USA, (37.3665207, -121.9955382, 0.0)),
 3366: Location(1601 Coleman Ave, Santa Clara, CA 95050, USA, (37.3571955, -121.9390321, 0.0)),
 3895: None,
 3896: None,
 3898: Location(19550 Stevens Creek Blvd, Cupertino, CA 95014, USA, (37.3226857, -122.0146754, 0.0)),
 3900: Location(E Campbell Ave, Campbell, CA 95008, USA, (37.2870871, -121.9366533, 0.0)),
 3901: Location(570 E Hamilton AVE, Campbell, CA 95008, United States, (37.293891, -121.939809, 0.0)),
 4027: None,
 4028: Location(10625 N De Anza Blvd, Cupertino, CA 95014, USA, (37.3321694, -122.0327595, 0.0)),
 4030: Location(10002 N De Anza Blvd, Cupertino, CA 95014, USA, (37.3233881, -122.031775, 0.0)),
 4063: Location(3740 El Camino Real, Santa Clara, CA 95051, USA, (37.3519021, -121.998781, 0.0)),
 4066: Location(854 Old San Francisco Rd, Sunnyvale, CA 94086, USA, (37.3662839, -122.0169509, 0.0)),
 4068: None,
 4111: None,
 4112: Location(1161 Embarcadero Rd, Palo Alto, CA 94303, USA, (37.44724, -122.125827, 0.0)),
 4998: Location(1265 Lawrence Station Rd, Sunnyvale, CA 94089, USA, (37.4059137, -121.9961508, 0.0)),
 4999: None,
 5000: None,
 5001: None,
 5002: None,
 5003: None,
 5004: Location(500 Lawrence Expy, Santa Clara, CA 95051, USA, (37.3317165, -121.99595, 0.0)),
 5017: None,
 5018: Location(4350 El Camino Real, Los Altos, CA 94022, USA, (37.404101, -122.1182024, 0.0)),
 5019: Location(601 Fremont Ave, Los Altos, CA 94024, USA, (37.36158770000001, -122.098762, 0.0)),
 5020: None,
 5021: Location(808 W Middlefield Rd, Mountain View, CA 94043, USA, (37.4027409, -122.0744995, 0.0)),
 5022: Location(584 N Rengstorff Ave, Mountain View, CA 94043, USA, (37.4114282, -122.0930948, 0.0)),
 5023: Location(334 San Antonio Rd, Mountain View, CA 94040, USA, (37.4057671, -122.1115097, 0.0)),
 5024: Location(59 W El Camino Real, Mountain View, CA 94040, USA, (37.3807009, -122.0745955, 0.0)),
 5253: None,
 5431: None,
 5432: None,
 5440: None,
 5441: Location(19990 Stevens Creek Blvd, Cupertino, CA 95014, USA, (37.3224757, -122.0227974, 0.0)),
 5442: Location(310 E Middlefield Rd, Mountain View, CA 94043, USA, (37.3972447, -122.0593265, 0.0)),
 5443: None,
 5444: None,
 5445: Location(860 Warner Ave, Sunnyvale, CA 94087, USA, (37.3520427, -122.0484812, 0.0)),
 5446: Location(1005 W El Camino Real, Sunnyvale, CA 94087, USA, (37.37231140000001, -122.0489535, 0.0)),
 5447: Location(925 W Fremont Ave, Sunnyvale, CA 94087, USA, (37.3525608, -122.0516256, 0.0)),
 5448: Location(776 N Mathilda Ave, Sunnyvale, CA 94085, USA, (37.3953283, -122.0283161, 0.0)),
 5453: Location(499 N Mathilda Ave, Sunnyvale, CA 94085, USA, (37.3894997, -122.0311046, 0.0)),
 5585: None,
 6064: Location(988 N San Antonio Rd, Los Altos, CA 94022, USA, (37.399846, -122.1145759, 0.0)),
 6065: Location(117 W Maude Ave, Sunnyvale, CA 94085, USA, (37.3887177, -122.0264364, 0.0)),
 8885: Location(1589 E Hamilton Ave, Campbell, CA 95008, USA, (37.29441600000001, -121.9322064, 0.0)),
 10588: Location(10023 S De Anza Blvd, Cupertino, CA 95014, USA, (37.3225474, -122.0327352, 0.0)),
 10677: Location(603 Old San Francisco Rd, Sunnyvale, CA 94086, USA, (37.367653, -122.022535, 0.0)),
 11571: Location(880 E Hillsdale Blvd, Foster City, CA 94404, USA, (37.5537815, -122.2774724, 0.0)),
 11572: Location(Santa Clara Ave, Redwood City, CA 94061, USA, (37.4505457, -122.2253481, 0.0)),
 11575: Location(300 S Delaware St, San Mateo, CA 94401, USA, (37.566802, -122.3200717, 0.0)),
 11578: None,
 11587: None,
 11592: None,
 11595: Location(402 N El Camino Real, San Mateo, CA 94401, USA, (37.5703288, -122.3355555, 0.0)),
 11606: None,
 11709: None,
 11882: Location(Rand Ave, Oakland, CA 94610, USA, (37.8112953, -122.2451399, 0.0)),
 12154: None,
 12292: None,
 12324: Location(3035 Winchester Blvd, Campbell, CA 95008, USA, (37.2696252, -121.9562234, 0.0)),
 12361: Location(705 San Antonio Rd, Palo Alto, CA 94303, USA, (37.4167336, -122.1036466, 0.0)),
 12380: Location(880 N Delaware St, San Mateo, CA 94401, USA, (37.5804021, -122.3341259, 0.0)),
 12381: None,
 12382: Location(451 S Airport Blvd, South San Francisco, CA 94080, USA, (37.6424644, -122.4005569, 0.0)),
 12383: Location(609 E 4th Ave, San Mateo, CA 94401, USA, (37.5667929, -122.319122, 0.0)),
 12384: Location(706 E 4th Ave, San Mateo, CA 94401, USA, (37.5669011, -122.3181914, 0.0)),
 12437: Location(800 El Camino Real, San Bruno, CA 94066, USA, (37.6293435, -122.4166572, 0.0)),
 12977: Location(2509 Winchester Blvd, Campbell, CA 95008, USA, (37.2794488, -121.9508662, 0.0)),
 14182: None,
 14213: None,
 14214: None,
 14215: None,
 14216: Location(895 Woodside Rd, Redwood City, CA 94061, USA, (37.4646051, -122.2242495, 0.0)),
 14224: Location(1471 E 3rd Ave, San Mateo, CA 94401, USA, (37.5733019, -122.3117882, 0.0)),
 14308: None,
 14309: None,
 14311: None,
 14312: None,
 14313: None,
 14317: Location(177 Howard Ave, Burlingame, CA 94010, USA, (37.5845773, -122.3352076, 0.0)),
 14318: Location(1100 Broadway, Burlingame, CA 94010, USA, (37.5874984, -122.3640599, 0.0)),
 14319: None,
 14320: Location(601 California Dr, Burlingame, CA 94010, USA, (37.5816598, -122.3505965, 0.0)),
 14321: Location(Shell Car wash, 390 Hickey Blvd, Daly City, CA 94015, USA, (37.6637457, -122.4637933, 0.0)),
 14322: None,
 14325: Location(501 Gellert Blvd, Daly City, CA 94015, USA, (37.66145789999999, -122.4687883, 0.0)),
 14327: Location(Bell St, East Palo Alto, CA 94303, USA, (37.4655891, -122.1409568, 0.0)),
 14328: Location(710 Okeefe St, Menlo Park, CA 94025, USA, (37.4638912, -122.1578014, 0.0)),
 14330: Location(1380 El Camino Real, Menlo Park, CA 94025, USA, (37.4558736, -122.1868615, 0.0)),
 14332: None,
 14333: None,
 14334: None,
 14335: Location(275 El Camino Real, Menlo Park, CA 94025, USA, (37.4487312, -122.1751301, 0.0)),
 14338: Location(699 El Camino Real, Redwood City, CA 94063, USA, (37.4877463, -122.2360099, 0.0)),
 14339: Location(Pacifica, CA 94044, USA, (37.584178, -122.486442, 0.0)),
 14340: Location(500 Coleman Ave, Menlo Park, CA 94025, USA, (37.4616602, -122.1600963, 0.0)),
 14341: None,
 14343: Location(1200 El Camino Real, Menlo Park, CA 94025, USA, (37.4546956, -122.184417, 0.0)),
 14344: Location(3201 El Camino Real, Atherton, CA 94027, USA, (37.4672615, -122.2085332, 0.0)),
 14345: Location(1101 Foster City Blvd, Foster City, CA 94404, USA, (37.5538278, -122.2551935, 0.0)),
 14346: Location(390 Foster City Blvd, Foster City, CA 94404, USA, (37.564867, -122.2755846, 0.0)),
 14347: Location(Triton Dr, Foster City, CA 94404, USA, (37.564431, -122.2698698, 0.0)),
 14354: Location(1399 Hamilton Ave, Menlo Park, CA 94025, USA, (37.4777723, -122.1492287, 0.0)),
 14355: Location(201 La Cuesta Dr, Portola Valley, CA 94028, USA, (37.4027681, -122.1930214, 0.0)),
 14359: Location(610 Hudson St, Redwood City, CA 94061, USA, (37.4772489, -122.2364659, 0.0)),
 14368: Location(765 Oddstad Blvd, Pacifica, CA 94044, USA, (37.5837264, -122.4740135, 0.0)),
 14370: None,
 14371: None,
 14372: Location(798 El Camino Real, San Bruno, CA 94066, USA, (37.628657, -122.416196, 0.0)),
 14394: None,
 14395: Location(501 S Norfolk St, San Mateo, CA 94401, USA, (37.5717304, -122.3093277, 0.0)),
 14400: Location(1505 Woodside Rd, Redwood City, CA 94061, USA, (37.4564956, -122.2277797, 0.0)),
 14401: Location(110 Hickey Blvd, South San Francisco, CA 94080, USA, (37.6666459, -122.4523082, 0.0)),
 14402: Location(221 Airport Blvd, South San Francisco, CA 94080, USA, (37.654572, -122.4082951, 0.0)),
 14403: Location(2300 Westborough Blvd, South San Francisco, CA 94080, USA, (37.6434721, -122.4535456, 0.0)),
 14526: Location(582 Hudson St, Redwood City, CA 94062, USA, (37.4774327, -122.2367005, 0.0)),
 14694: Location(337 E Hamilton Ave, Campbell, CA 95008, USA, (37.2945539, -121.9439233, 0.0)),
 14696: Location(1699 S De Anza Blvd, Cupertino, CA 95014, USA, (37.2942887, -122.0326298, 0.0)),
 14701: None,
 14706: Location(3897 El Camino Real, Palo Alto, CA 94306, USA, (37.4172891, -122.1302921, 0.0)),
 15485: None,
 15486: Location(950 Hillside Blvd, Daly City, CA 94014, USA, (37.6903469, -122.4615547, 0.0)),
 15487: None,
 15488: Location(125 Sharon Park Dr, Menlo Park, CA 94025, USA, (37.4239353, -122.1961347, 0.0)),
 15497: None,
 15501: Location(3480 Homestead Rd, Santa Clara, CA 95051, USA, (37.3375681, -121.9925939, 0.0)),
 15504: None,
 15609: Location(Fassler Ave, Pacifica, CA 94044, USA, (37.6005159, -122.4874725, 0.0)),
 15611: Location(975 Kentfield Ave, Redwood City, CA 94061, USA, (37.4682079, -122.2325198, 0.0)),
 15612: Location(Sequoia Ave, Redwood City, CA 94061, USA, (37.4524888, -122.2243816, 0.0)),
 15710: Location(100 Milagra Dr, Pacifica, CA 94044, USA, (37.6458323, -122.4909392, 0.0)),
 15806: Location(Pruneridge Ave, Santa Clara, CA 95050, USA, (37.3299577, -121.9590566, 0.0)),
 15825: Location(114 Harbor Way, South San Francisco, CA 94080, USA, (37.6537747, -122.40076, 0.0)),
 15826: Location(111 Mitchell Ave, South San Francisco, CA 94080, USA, (37.6495037, -122.4044027, 0.0)),
 15827: Location(219 S San Mateo Dr, San Mateo, CA 94401, USA, (37.5649477, -122.3245029, 0.0)),
 18219: None,
 18220: Location(398 Gellert Blvd, Daly City, CA 94015, USA, (37.664917, -122.46946, 0.0)),
 18221: Location(201 San Mateo Rd, Half Moon Bay, CA 94019, USA, (37.4676174, -122.4296766, 0.0)),
 18222: Location(5 El Camino Real, Millbrae, CA 94030, USA, (37.59837, -122.3882342, 0.0)),
 18223: Location(501 El Camino Real, Millbrae, CA 94030, USA, (37.60307359999999, -122.3936499, 0.0)),
 18224: Location(200 Rollins Rd, Millbrae, CA 94030, USA, (37.600025, -122.387183, 0.0)),
 18225: None,
 18226: None,
 18227: Location(491 El Camino Real, Millbrae, CA 94030, USA, (37.6027075, -122.3932113, 0.0)),
 18228: None,
 18229: None,
 18230: Location(1700 Middlefield Rd, Redwood City, CA 94063, USA, (37.4819245, -122.22144, 0.0)),
 18231: Location(710 Oxford St, Redwood City, CA 94061, USA, (37.4706494, -122.2299804, 0.0)),
 18232: Location(690 Veterans Blvd, Redwood City, CA 94063, USA, (37.4913221, -122.2310576, 0.0)),
 18233: Location(2108 Upton St, Redwood City, CA 94061, USA, (37.4664839, -122.241549, 0.0)),
 18234: None,
 18235: Location(717 San Bruno Ave E, San Bruno, CA 94066, USA, (37.6310801, -122.4064441, 0.0)),
 18236: Location(401 El Camino Real, San Bruno, CA 94066, USA, (37.6216429, -122.4117647, 0.0)),
 18237: None,
 18238: Location(512 El Camino Real, San Bruno, CA 94066, USA, (37.6237076, -122.4126685, 0.0)),
 18239: Location(310 2nd Ave, San Bruno, CA 94066, USA, (37.6249362, -122.4073147, 0.0)),
 18241: Location(401 Linden Ave, South San Francisco, CA 94080, USA, (37.6563811, -122.4098673, 0.0)),
 18242: None,
 18243: Location(3601 El Camino Real, Palo Alto, CA 94306, USA, (37.41879900000001, -122.133202, 0.0)),
 18254: None,
 18255: Location(2495 De La Cruz Blvd, Santa Clara, CA 95050, USA, (37.3663062, -121.9411486, 0.0)),
 18256: None,
 18257: None,
 18258: Location(1037 Lakehaven Dr, Sunnyvale, CA 94089, USA, (37.3964369, -121.9970684, 0.0)),
 18759: None,
 18764: Location(898 N Wolfe Rd, Sunnyvale, CA 94085, USA, (37.3837069, -122.0141017, 0.0)),
 18857: None,
 18859: Location(921 W Hamilton Ave, Campbell, CA 95008, USA, (37.2945224, -121.9655613, 0.0)),
 18881: Location(1098 El Camino Real, San Carlos, CA 94070, USA, (37.500762, -122.2530284, 0.0)),
 18883: Location(500 El Camino Real, San Carlos, CA 94070, USA, (37.5081856, -122.2619431, 0.0)),
 18895: Location(710 El Camino Real, South San Francisco, CA 94080, USA, (37.6505991, -122.4303466, 0.0)),
 19689: Location(2855 Winchester Blvd, Campbell, CA 95008, USA, (37.2719534, -121.954675, 0.0)),
 20035: None,
 20551: Location(12015 Saratoga Sunnyvale Rd, Saratoga, CA 95070, USA, (37.2936062, -122.0328269, 0.0)),
 20815: Location(1533 S San Tomas Aquino Rd, Campbell, CA 95008, USA, (37.2805894, -121.9777367, 0.0)),
 20816: Location(1530 S San Tomas Aquino Rd, Campbell, CA 95008, USA, (37.2691284, -121.9722765, 0.0)),
 21024: None,
 21025: None,
 21026: Location(3401 Middlefield Rd, Menlo Park, CA 94025, USA, (37.470637, -122.2018526, 0.0)),
 21076: Location(1 Westborough Blvd, South San Francisco, CA 94080, USA, (37.6550488, -122.4343653, 0.0)),
 21077: None,
 21079: Location(698 El Camino Real, South San Francisco, CA 94080, USA, (37.65012919999999, -122.4301603, 0.0)),
 21080: None,
 21317: None,
 21318: None,
 21329: Location(1400 Campus Dr, San Mateo, CA 94403, USA, (37.5367258, -122.3239319, 0.0)),
 21330: None,
 21793: None,
 21794: Location(996 Mary Evelyn Dr, San Jose, CA 95123, USA, (37.2283966, -121.8341257, 0.0)),
 22517: None,
 22766: Location(17015 Monterey Rd, Morgan Hill, CA 95037, USA, (37.12541179999999, -121.6507078, 0.0)),
 23274: Location(Fulton St, Campbell, CA 95008, USA, (37.2849919, -121.9824725, 0.0)),
 23403: Location(22510 Stevens Creek Blvd, Cupertino, CA 95014, USA, (37.321588, -122.0681706, 0.0)),
 23418: None,
 23595: Location(2101 Shelter Creek Ln, San Bruno, CA 94066, USA, (37.619843, -122.428366, 0.0)),
 23596: None,
 23597: None,
 23598: Location(Saratoga Dr, San Mateo, CA 94403, USA, (37.5460193, -122.2953329, 0.0)),
 23599: Location(2300 S El Camino Real, San Mateo, CA 94403, USA, (37.5453918, -122.3070982, 0.0)),
 23600: Location(Saratoga Dr, San Mateo, CA 94403, USA, (37.5460193, -122.2953329, 0.0)),
 23637: Location(1626 S El Camino Real, San Mateo, CA 94402, USA, (37.5526006, -122.3151468, 0.0)),
 23638: None,
 23639: None,
 23819: Location(1641 Palm Ave, San Mateo, CA 94402, USA, (37.5534636, -122.3126031, 0.0)),
 23822: Location(Laurie Meadows Dr, San Mateo, CA 94403, USA, (37.53184359999999, -122.2843995, 0.0)),
 24044: None,
 24045: Location(2700 Geneva Ave, Daly City, CA 94014, USA, (37.7067696, -122.4156761, 0.0)),
 24159: None,
 24160: None,
 24161: None,
 24231: None,
 24419: Location(981 E Hamilton Ave, Campbell, CA 95008, USA, (37.2949069, -121.9321128, 0.0)),
 24476: None,
 24560: Location(2181 Laurelwood Rd, Santa Clara, CA 95054, USA, (37.3843199, -121.9620266, 0.0)),
 24618: None,
 24619: None,
 24620: Location(5920 Travel Park Cir, Gilroy, CA 95020, USA, (36.9849134, -121.5557849, 0.0)),
 24621: None,
 24622: Location(929 Fremont Ave, Los Altos Hills, CA 94024, USA, (37.354072, -122.088676, 0.0)),
 24624: Location(441 Leigh Ave, Los Gatos, CA 95032, USA, (37.2432408, -121.9231377, 0.0)),
 24626: None,
 24627: Location(Newhall St, Santa Clara, CA 95050, USA, (37.3377148, -121.9413046, 0.0)),
 24630: None,
 24758: None,
 24842: None,
 24855: None,
 24859: Location(14395 Big Basin Way, Saratoga, CA 95070, USA, (37.2595184, -122.0324297, 0.0)),
 24860: None,
 24861: None,
 24863: Location(2090 Scott Blvd, Santa Clara, CA 95050, USA, (37.360778, -121.9601311, 0.0)),
 24864: None,
 24877: Location(400 Skyline Blvd, Millbrae, CA 94030, USA, (37.5899283, -122.4120203, 0.0)),
 24945: Location(MacDonald Ave, Daly City, CA 94014, USA, (37.70618890000001, -122.4098617, 0.0)),
 24946: Location(2000 Rollingwood Dr, San Bruno, CA 94066, USA, (37.6303808, -122.4363566, 0.0)),
 24947: Location(Glenview Dr, San Bruno, CA 94066, USA, (37.6205106, -122.4415352, 0.0)),
 26311: Location(495 Moffett Blvd, Mountain View, CA 94043, USA, (37.3999171, -122.0730247, 0.0)),
 26319: None,
 26631: None,
 26635: Location(888 El Camino Real, San Carlos, CA 94070, USA, (37.503231, -122.2560388, 0.0)),
 26636: Location(907 Holly St, San Carlos, CA 94070, USA, (37.511558, -122.2579051, 0.0)),
 26637: None,
 27006: Location(195 El Camino Real, San Carlos, CA 94070, USA, (37.5121502, -122.2657066, 0.0)),
 27178: Location(15299 Garden Ln, Los Gatos, CA 95032, USA, (37.2460281, -121.9583548, 0.0)),
 27179: None,
 27180: Location(17905 Monterey Rd, Morgan Hill, CA 95037, USA, (37.134998, -121.6590039, 0.0)),
 27183: Location(Newhall St, Santa Clara, CA 95050, USA, (37.3377148, -121.9413046, 0.0)),
 27789: None,
 29036: Location(2001 Rollingwood Dr, San Bruno, CA 94066, USA, (37.6301945, -122.4366865, 0.0)),
 29985: Location(Donohoe St, East Palo Alto, CA 94303, USA, (37.4627033, -122.142644, 0.0)),
 30490: Location(1216 Hillside Blvd, Daly City, CA 94014, USA, (37.6858002, -122.4598765, 0.0)),
 32392: Location(3001 Junipero Serra Blvd, Daly City, CA 94014, USA, (37.6866068, -122.4702924, 0.0)),
 33020: Location(151 Southgate Ave, Daly City, CA 94015, USA, (37.6971786, -122.4833333, 0.0)),
 33022: Location(892 John Daly Blvd, Daly City, CA 94015, USA, (37.7020206, -122.4839414, 0.0)),
 33143: None,
 33218: None,
 33221: None,
 33644: None,
 33645: None,
 33646: None,
 33647: Location(7251 Camino Arroyo, Gilroy, CA 95020, USA, (37.0083814, -121.5566111, 0.0)),
 33649: Location(Belmont, CA 94002, USA, (37.51207, -122.29482, 0.0)),
 33650: Location(3139 Jefferson Ave, Redwood City, CA 94062, USA, (37.4695857, -122.2467551, 0.0)),
 33799: None,
 33800: Location(7210 Camino Arroyo # 106, Gilroy, CA 95020, USA, (37.0089557, -121.5538244, 0.0)),
 33802: None,
 33809: None,
 33959: Location(8445 Cabrillo Hwy, Montara, CA 94037, USA, (37.5416467, -122.5157743, 0.0)),
 33960: None,
 35018: Location(4698 Callan Blvd, Daly City, CA 94015, USA, (37.6690312, -122.4749403, 0.0)),
 35696: None,
 35697: Location(7853 Alpine Rd, Portola Valley, CA 94028, USA, (37.34204769999999, -122.2020287, 0.0)),
 35726: None,
 35738: Location(16995 Monterey Rd, Morgan Hill, CA 95037, USA, (37.1249181, -121.6501173, 0.0)),
 35740: Location(14660 Monterey Rd, Morgan Hill, CA 95037, USA, (37.1047203, -121.630602, 0.0)),
 37049: Location(Whiskey Hill Rd, Woodside, CA 94062, USA, (37.4206439, -122.2439828, 0.0)),
 38170: Location(844 Fifth Ave, Redwood City, CA 94063, USA, (37.4812404, -122.198454, 0.0)),
 38171: None,
 39049: None,
 39051: None,
 40401: Location(2215 El Camino Real, Redwood City, CA 94063, USA, (37.4760258, -122.2204291, 0.0)),
 62808: None,
 67386: None,
 68316: Location(15171 Los Gatos Blvd, Los Gatos, CA 95032, USA, (37.2484687, -121.9565062, 0.0)),
 68374: Location(700 Blossom Hill Rd, Los Gatos, CA 95032, USA, (37.2352252, -121.962704, 0.0)),
 68386: Location(16500 Spencer Ave, Los Gatos, CA 95032, USA, (37.2284408, -121.9653386, 0.0)),
 68397: None,
 68607: None,
 68612: None,
 68617: None,
 69053: None,
 69205: None,
 71120: Location(120 Main St, Half Moon Bay, CA 94019, USA, (37.4693459, -122.4315594, 0.0)),
 71130: Location(375 Cabrillo Hwy, Half Moon Bay, CA 94019, USA, (37.4725397, -122.4354503, 0.0)),
 71743: Location(602 El Camino Real, Redwood City, CA 94063, USA, (37.488624, -122.2380526, 0.0)),
 71752: None,
 72800: None,
 77394: None,
 77466: Location(Gateway Dr, Los Gatos, CA 95032, USA, (37.24598659999999, -121.9572167, 0.0)),
 79938: Location(590 Canyon Rd, Emerald Hills, CA 94062, USA, (37.4718088, -122.2606758, 0.0)),
 81018: None,
 83871: Location(18605 Monterey Rd, Morgan Hill, CA 95037, USA, (37.14454569999999, -121.6650928, 0.0)),
 85744: Location(200 Saratoga Los Gatos Rd, Los Gatos, CA 95030, USA, (37.22945170000001, -121.9811326, 0.0)),
 87276: Location(666 N Santa Cruz Ave, Los Gatos, CA 95030, USA, (37.2353545, -121.977285, 0.0)),
 90570: Location(16500 Lark Ave, Los Gatos, CA 95032, USA, (37.2479686, -121.9574046, 0.0)),
 93895: None,
 99717: Location(5920 Travel Park Cir, Gilroy, CA 95020, USA, (36.9849134, -121.5557849, 0.0)),
 102474: Location(501 Kelly Ave, Half Moon Bay, CA 94019, USA, (37.4644308, -122.4334313, 0.0)),
 102505: Location(5887 Monterey Rd, Gilroy, CA 95020, USA, (36.9843968, -121.5577523, 0.0)),
 108220: None,
 108223: None,
 117539: None,
 117637: None,
 124084: Location(2300 Middlefield Rd, Redwood City, CA 94063, USA, (37.4783934, -122.2162731, 0.0)),
 134943: Location(950 W Hamilton Ave, Campbell, CA 95008, USA, (37.2937317, -121.9657519, 0.0)),
 170604: Location(830 Leong Dr, Mountain View, CA 94043, USA, (37.4052523, -122.067024, 0.0))}

In [177]:
locations_7 = {}
for k,v in locations_6.items():
    if v:
        locations_7[k] = v
        
print(len(locations_7))


197

In [180]:
print_locations_dict(locations_7)


4030,"10002 N De Anza Blvd, Cupertino, CA 95014, USA",37.3233881,-122.031775
10588,"10023 S De Anza Blvd, Cupertino, CA 95014, USA",37.3225474,-122.0327352
24622,"929 Fremont Ave, Los Altos Hills, CA 94024, USA",37.354072,-122.088676
21026,"3401 Middlefield Rd, Menlo Park, CA 94025, USA",37.470637,-122.2018526
2550,"790 W Middlefield Rd, Mountain View, CA 94043, USA",37.40240319999999,-122.0746349
5021,"808 W Middlefield Rd, Mountain View, CA 94043, USA",37.4027409,-122.0744995
2551,"807 W Middlefield Rd, Mountain View, CA 94043, USA",37.4034812,-122.0750682
5023,"334 San Antonio Rd, Mountain View, CA 94040, USA",37.4057671,-122.1115097
1274,"45 W El Camino Real, Mountain View, CA 94040, USA",37.3802487,-122.0735976
3366,"1601 Coleman Ave, Santa Clara, CA 95050, USA",37.3571955,-121.9390321
15501,"3480 Homestead Rd, Santa Clara, CA 95051, USA",37.3375681,-121.9925939
15806,"Pruneridge Ave, Santa Clara, CA 95050, USA",37.3299577,-121.9590566
5004,"500 Lawrence Expy, Santa Clara, CA 95051, USA",37.3317165,-121.99595
490,"150 Lawrence Station Rd, Sunnyvale, CA 94086, USA",37.3713248,-121.9941119
6065,"117 W Maude Ave, Sunnyvale, CA 94085, USA",37.3887177,-122.0264364
5445,"860 Warner Ave, Sunnyvale, CA 94087, USA",37.3520427,-122.0484812
18764,"898 N Wolfe Rd, Sunnyvale, CA 94085, USA",37.3837069,-122.0141017
21794,"996 Mary Evelyn Dr, San Jose, CA 95123, USA",37.2283966,-121.8341257
18258,"1037 Lakehaven Dr, Sunnyvale, CA 94089, USA",37.3964369,-121.9970684
4998,"1265 Lawrence Station Rd, Sunnyvale, CA 94089, USA",37.4059137,-121.9961508
10677,"603 Old San Francisco Rd, Sunnyvale, CA 94086, USA",37.367653,-122.022535
18255,"2495 De La Cruz Blvd, Santa Clara, CA 95050, USA",37.3663062,-121.9411486
14696,"1699 S De Anza Blvd, Cupertino, CA 95014, USA",37.2942887,-122.0326298
14335,"275 El Camino Real, Menlo Park, CA 94025, USA",37.4487312,-122.1751301
20551,"12015 Saratoga Sunnyvale Rd, Saratoga, CA 95070, USA",37.2936062,-122.0328269
5022,"584 N Rengstorff Ave, Mountain View, CA 94043, USA",37.4114282,-122.0930948
24560,"2181 Laurelwood Rd, Santa Clara, CA 95054, USA",37.3843199,-121.9620266
24863,"2090 Scott Blvd, Santa Clara, CA 95050, USA",37.360778,-121.9601311
6064,"988 N San Antonio Rd, Los Altos, CA 94022, USA",37.399846,-122.1145759
4066,"854 Old San Francisco Rd, Sunnyvale, CA 94086, USA",37.3662839,-122.0169509
14340,"500 Coleman Ave, Menlo Park, CA 94025, USA",37.4616602,-122.1600963
1922,"835 San Antonio Rd, Palo Alto, CA 94303, USA",37.4216074,-122.1022659
4112,"1161 Embarcadero Rd, Palo Alto, CA 94303, USA",37.44724,-122.125827
14328,"710 Okeefe St, Menlo Park, CA 94025, USA",37.4638912,-122.1578014
29985,"Donohoe St, East Palo Alto, CA 94303, USA",37.4627033,-122.142644
27183,"Newhall St, Santa Clara, CA 95050, USA",37.3377148,-121.9413046
14327,"Bell St, East Palo Alto, CA 94303, USA",37.4655891,-122.1409568
14354,"1399 Hamilton Ave, Menlo Park, CA 94025, USA",37.4777723,-122.1492287
14317,"177 Howard Ave, Burlingame, CA 94010, USA",37.5845773,-122.3352076
134943,"950 W Hamilton Ave, Campbell, CA 95008, USA",37.2937317,-121.9657519
18220,"398 Gellert Blvd, Daly City, CA 94015, USA",37.664917,-122.46946
14325,"501 Gellert Blvd, Daly City, CA 94015, USA",37.66145789999999,-122.4687883
33647,"7251 Camino Arroyo, Gilroy, CA 95020, USA",37.0083814,-121.5566111
99717,"5920 Travel Park Cir, Gilroy, CA 95020, USA",36.9849134,-121.5557849
33800,"7210 Camino Arroyo # 106, Gilroy, CA 95020, USA",37.0089557,-121.5538244
71120,"120 Main St, Half Moon Bay, CA 94019, USA",37.4693459,-122.4315594
35738,"16995 Monterey Rd, Morgan Hill, CA 95037, USA",37.1249181,-121.6501173
14339,"Pacifica, CA 94044, USA",37.584178,-122.486442
15609,"Fassler Ave, Pacifica, CA 94044, USA",37.6005159,-122.4874725
35697,"7853 Alpine Rd, Portola Valley, CA 94028, USA",37.34204769999999,-122.2020287
14359,"610 Hudson St, Redwood City, CA 94061, USA",37.4772489,-122.2364659
11572,"Santa Clara Ave, Redwood City, CA 94061, USA",37.4505457,-122.2253481
18231,"710 Oxford St, Redwood City, CA 94061, USA",37.4706494,-122.2299804
15611,"975 Kentfield Ave, Redwood City, CA 94061, USA",37.4682079,-122.2325198
14526,"582 Hudson St, Redwood City, CA 94062, USA",37.4774327,-122.2367005
15612,"Sequoia Ave, Redwood City, CA 94061, USA",37.4524888,-122.2243816
24947,"Glenview Dr, San Bruno, CA 94066, USA",37.6205106,-122.4415352
23595,"2101 Shelter Creek Ln, San Bruno, CA 94066, USA",37.619843,-122.428366
14372,"798 El Camino Real, San Bruno, CA 94066, USA",37.628657,-122.416196
29036,"2001 Rollingwood Dr, San Bruno, CA 94066, USA",37.6301945,-122.4366865
12383,"609 E 4th Ave, San Mateo, CA 94401, USA",37.5667929,-122.319122
23819,"1641 Palm Ave, San Mateo, CA 94402, USA",37.5534636,-122.3126031
23600,"Saratoga Dr, San Mateo, CA 94403, USA",37.5460193,-122.2953329
12380,"880 N Delaware St, San Mateo, CA 94401, USA",37.5804021,-122.3341259
23822,"Laurie Meadows Dr, San Mateo, CA 94403, USA",37.53184359999999,-122.2843995
23598,"Saratoga Dr, San Mateo, CA 94403, USA",37.5460193,-122.2953329
21329,"1400 Campus Dr, San Mateo, CA 94403, USA",37.5367258,-122.3239319
37049,"Whiskey Hill Rd, Woodside, CA 94062, USA",37.4206439,-122.2439828
14345,"1101 Foster City Blvd, Foster City, CA 94404, USA",37.5538278,-122.2551935
14347,"Triton Dr, Foster City, CA 94404, USA",37.564431,-122.2698698
14694,"337 E Hamilton Ave, Campbell, CA 95008, USA",37.2945539,-121.9439233
18224,"200 Rollins Rd, Millbrae, CA 94030, USA",37.600025,-122.387183
18230,"1700 Middlefield Rd, Redwood City, CA 94063, USA",37.4819245,-122.22144
18232,"690 Veterans Blvd, Redwood City, CA 94063, USA",37.4913221,-122.2310576
15826,"111 Mitchell Ave, South San Francisco, CA 94080, USA",37.6495037,-122.4044027
14318,"1100 Broadway, Burlingame, CA 94010, USA",37.5874984,-122.3640599
19689,"2855 Winchester Blvd, Campbell, CA 95008, USA",37.2719534,-121.954675
18236,"401 El Camino Real, San Bruno, CA 94066, USA",37.6216429,-122.4117647
27006,"195 El Camino Real, San Carlos, CA 94070, USA",37.5121502,-122.2657066
12384,"706 E 4th Ave, San Mateo, CA 94401, USA",37.5669011,-122.3181914
14400,"1505 Woodside Rd, Redwood City, CA 94061, USA",37.4564956,-122.2277797
68374,"700 Blossom Hill Rd, Los Gatos, CA 95032, USA",37.2352252,-121.962704
12977,"2509 Winchester Blvd, Campbell, CA 95008, USA",37.2794488,-121.9508662
18239,"310 2nd Ave, San Bruno, CA 94066, USA",37.6249362,-122.4073147
8885,"1589 E Hamilton Ave, Campbell, CA 95008, USA",37.29441600000001,-121.9322064
3900,"E Campbell Ave, Campbell, CA 95008, USA",37.2870871,-121.9366533
24045,"2700 Geneva Ave, Daly City, CA 94014, USA",37.7067696,-122.4156761
20815,"1533 S San Tomas Aquino Rd, Campbell, CA 95008, USA",37.2805894,-121.9777367
20816,"1530 S San Tomas Aquino Rd, Campbell, CA 95008, USA",37.2691284,-121.9722765
33959,"8445 Cabrillo Hwy, Montara, CA 94037, USA",37.5416467,-122.5157743
24419,"981 E Hamilton Ave, Campbell, CA 95008, USA",37.2949069,-121.9321128
23274,"Fulton St, Campbell, CA 95008, USA",37.2849919,-121.9824725
77466,"Gateway Dr, Los Gatos, CA 95032, USA",37.24598659999999,-121.9572167
85744,"200 Saratoga Los Gatos Rd, Los Gatos, CA 95030, USA",37.22945170000001,-121.9811326
68386,"16500 Spencer Ave, Los Gatos, CA 95032, USA",37.2284408,-121.9653386
15710,"100 Milagra Dr, Pacifica, CA 94044, USA",37.6458323,-122.4909392
32392,"3001 Junipero Serra Blvd, Daly City, CA 94014, USA",37.6866068,-122.4702924
24945,"MacDonald Ave, Daly City, CA 94014, USA",37.70618890000001,-122.4098617
18241,"401 Linden Ave, South San Francisco, CA 94080, USA",37.6563811,-122.4098673
15827,"219 S San Mateo Dr, San Mateo, CA 94401, USA",37.5649477,-122.3245029
33650,"3139 Jefferson Ave, Redwood City, CA 94062, USA",37.4695857,-122.2467551
102505,"5887 Monterey Rd, Gilroy, CA 95020, USA",36.9843968,-121.5577523
24620,"5920 Travel Park Cir, Gilroy, CA 95020, USA",36.9849134,-121.5557849
11882,"Rand Ave, Oakland, CA 94610, USA",37.8112953,-122.2451399
33020,"151 Southgate Ave, Daly City, CA 94015, USA",37.6971786,-122.4833333
18233,"2108 Upton St, Redwood City, CA 94061, USA",37.4664839,-122.241549
87276,"666 N Santa Cruz Ave, Los Gatos, CA 95030, USA",37.2353545,-121.977285
2302,"370 E Hamilton Ave, Campbell, CA 95008, USA",37.2940145,-121.9432447
5442,"310 E Middlefield Rd, Mountain View, CA 94043, USA",37.3972447,-122.0593265
27178,"15299 Garden Ln, Los Gatos, CA 95032, USA",37.2460281,-121.9583548
24627,"Newhall St, Santa Clara, CA 95050, USA",37.3377148,-121.9413046
14344,"3201 El Camino Real, Atherton, CA 94027, USA",37.4672615,-122.2085332
3898,"19550 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226857,-122.0146754
14343,"1200 El Camino Real, Menlo Park, CA 94025, USA",37.4546956,-122.184417
14330,"1380 El Camino Real, Menlo Park, CA 94025, USA",37.4558736,-122.1868615
1051,"1288 W El Camino Real, Mountain View, CA 94040, USA",37.3885421,-122.0886162
4063,"3740 El Camino Real, Santa Clara, CA 95051, USA",37.3519021,-121.998781
1373,"101 E El Camino Real, Mountain View, CA 94040, USA",37.37989,-122.0729094
5024,"59 W El Camino Real, Mountain View, CA 94040, USA",37.3807009,-122.0745955
26311,"495 Moffett Blvd, Mountain View, CA 94043, USA",37.3999171,-122.0730247
3363,"2455 Lawrence Expy, Santa Clara, CA 95051, USA",37.3665207,-121.9955382
24859,"14395 Big Basin Way, Saratoga, CA 95070, USA",37.2595184,-122.0324297
5446,"1005 W El Camino Real, Sunnyvale, CA 94087, USA",37.37231140000001,-122.0489535
5453,"499 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3894997,-122.0311046
5448,"776 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3953283,-122.0283161
5447,"925 W Fremont Ave, Sunnyvale, CA 94087, USA",37.3525608,-122.0516256
12361,"705 San Antonio Rd, Palo Alto, CA 94303, USA",37.4167336,-122.1036466
18243,"3601 El Camino Real, Palo Alto, CA 94306, USA",37.41879900000001,-122.133202
2523,"1708 Miramonte Ave, Mountain View, CA 94040, USA",37.3731445,-122.0874172
2253,"1963 El Camino Real, Palo Alto, CA 94306, USA",37.4281669,-122.1492135
2330,"2200 El Camino Real, Palo Alto, CA 94306, USA",37.4256823,-122.1475717
5441,"19990 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3224757,-122.0227974
4028,"10625 N De Anza Blvd, Cupertino, CA 95014, USA",37.3321694,-122.0327595
14706,"3897 El Camino Real, Palo Alto, CA 94306, USA",37.4172891,-122.1302921
3040,"2800 Augustine Dr, Santa Clara, CA 95054, USA",37.3821107,-121.97839
5018,"4350 El Camino Real, Los Altos, CA 94022, USA",37.404101,-122.1182024
14355,"201 La Cuesta Dr, Portola Valley, CA 94028, USA",37.4027681,-122.1930214
23403,"22510 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.321588,-122.0681706
170604,"830 Leong Dr, Mountain View, CA 94043, USA",37.4052523,-122.067024
12324,"3035 Winchester Blvd, Campbell, CA 95008, USA",37.2696252,-121.9562234
18859,"921 W Hamilton Ave, Campbell, CA 95008, USA",37.2945224,-121.9655613
35018,"4698 Callan Blvd, Daly City, CA 94015, USA",37.6690312,-122.4749403
14321,"Shell Car wash, 390 Hickey Blvd, Daly City, CA 94015, USA",37.6637457,-122.4637933
11571,"880 E Hillsdale Blvd, Foster City, CA 94404, USA",37.5537815,-122.2774724
14346,"390 Foster City Blvd, Foster City, CA 94404, USA",37.564867,-122.2755846
102474,"501 Kelly Ave, Half Moon Bay, CA 94019, USA",37.4644308,-122.4334313
18221,"201 San Mateo Rd, Half Moon Bay, CA 94019, USA",37.4676174,-122.4296766
71130,"375 Cabrillo Hwy, Half Moon Bay, CA 94019, USA",37.4725397,-122.4354503
68316,"15171 Los Gatos Blvd, Los Gatos, CA 95032, USA",37.2484687,-121.9565062
24877,"400 Skyline Blvd, Millbrae, CA 94030, USA",37.5899283,-122.4120203
22766,"17015 Monterey Rd, Morgan Hill, CA 95037, USA",37.12541179999999,-121.6507078
14368,"765 Oddstad Blvd, Pacifica, CA 94044, USA",37.5837264,-122.4740135
124084,"2300 Middlefield Rd, Redwood City, CA 94063, USA",37.4783934,-122.2162731
14216,"895 Woodside Rd, Redwood City, CA 94061, USA",37.4646051,-122.2242495
71743,"602 El Camino Real, Redwood City, CA 94063, USA",37.488624,-122.2380526
24946,"2000 Rollingwood Dr, San Bruno, CA 94066, USA",37.6303808,-122.4363566
18238,"512 El Camino Real, San Bruno, CA 94066, USA",37.6237076,-122.4126685
26635,"888 El Camino Real, San Carlos, CA 94070, USA",37.503231,-122.2560388
11575,"300 S Delaware St, San Mateo, CA 94401, USA",37.566802,-122.3200717
23599,"2300 S El Camino Real, San Mateo, CA 94403, USA",37.5453918,-122.3070982
23637,"1626 S El Camino Real, San Mateo, CA 94402, USA",37.5526006,-122.3151468
14224,"1471 E 3rd Ave, San Mateo, CA 94401, USA",37.5733019,-122.3117882
12382,"451 S Airport Blvd, South San Francisco, CA 94080, USA",37.6424644,-122.4005569
14401,"110 Hickey Blvd, South San Francisco, CA 94080, USA",37.6666459,-122.4523082
21079,"698 El Camino Real, South San Francisco, CA 94080, USA",37.65012919999999,-122.4301603
21076,"1 Westborough Blvd, South San Francisco, CA 94080, USA",37.6550488,-122.4343653
27180,"17905 Monterey Rd, Morgan Hill, CA 95037, USA",37.134998,-121.6590039
18881,"1098 El Camino Real, San Carlos, CA 94070, USA",37.500762,-122.2530284
18222,"5 El Camino Real, Millbrae, CA 94030, USA",37.59837,-122.3882342
18227,"491 El Camino Real, Millbrae, CA 94030, USA",37.6027075,-122.3932113
18223,"501 El Camino Real, Millbrae, CA 94030, USA",37.60307359999999,-122.3936499
40401,"2215 El Camino Real, Redwood City, CA 94063, USA",37.4760258,-122.2204291
26636,"907 Holly St, San Carlos, CA 94070, USA",37.511558,-122.2579051
15825,"114 Harbor Way, South San Francisco, CA 94080, USA",37.6537747,-122.40076
14320,"601 California Dr, Burlingame, CA 94010, USA",37.5816598,-122.3505965
24624,"441 Leigh Ave, Los Gatos, CA 95032, USA",37.2432408,-121.9231377
90570,"16500 Lark Ave, Los Gatos, CA 95032, USA",37.2479686,-121.9574046
14403,"2300 Westborough Blvd, South San Francisco, CA 94080, USA",37.6434721,-122.4535456
14395,"501 S Norfolk St, San Mateo, CA 94401, USA",37.5717304,-122.3093277
11595,"402 N El Camino Real, San Mateo, CA 94401, USA",37.5703288,-122.3355555
83871,"18605 Monterey Rd, Morgan Hill, CA 95037, USA",37.14454569999999,-121.6650928
35740,"14660 Monterey Rd, Morgan Hill, CA 95037, USA",37.1047203,-121.630602
15486,"950 Hillside Blvd, Daly City, CA 94014, USA",37.6903469,-122.4615547
14338,"699 El Camino Real, Redwood City, CA 94063, USA",37.4877463,-122.2360099
5019,"601 Fremont Ave, Los Altos, CA 94024, USA",37.36158770000001,-122.098762
38170,"844 Fifth Ave, Redwood City, CA 94063, USA",37.4812404,-122.198454
33022,"892 John Daly Blvd, Daly City, CA 94015, USA",37.7020206,-122.4839414
15488,"125 Sharon Park Dr, Menlo Park, CA 94025, USA",37.4239353,-122.1961347
18235,"717 San Bruno Ave E, San Bruno, CA 94066, USA",37.6310801,-122.4064441
12437,"800 El Camino Real, San Bruno, CA 94066, USA",37.6293435,-122.4166572
79938,"590 Canyon Rd, Emerald Hills, CA 94062, USA",37.4718088,-122.2606758
30490,"1216 Hillside Blvd, Daly City, CA 94014, USA",37.6858002,-122.4598765
14402,"221 Airport Blvd, South San Francisco, CA 94080, USA",37.654572,-122.4082951
18883,"500 El Camino Real, San Carlos, CA 94070, USA",37.5081856,-122.2619431
18895,"710 El Camino Real, South San Francisco, CA 94080, USA",37.6505991,-122.4303466
3901,"570 E Hamilton AVE, Campbell, CA 95008, United States",37.293891,-121.939809
33649,"Belmont, CA 94002, USA",37.51207,-122.29482

In [182]:
# make locations dict into a pandas dataframe
def locations_df(locations):
    stations_df = pd.DataFrame(columns = ['station_id', 'address', 'latitude', 'longitude'])
    for station_id, loc in locations.items():
        row = {'station_id': station_id, 'address': loc.address, 'latitude': loc.latitude, 'longitude': loc.longitude}
        stations_df = stations_df.append(row, ignore_index=True)
    return stations_df

In [221]:
locations_8 = pd.read_csv('data/locations_7.csv',header=0, index_col=0)
locations_8.head(5)


Out[221]:
address latitude longitude
station_id
4030 10002 N De Anza Blvd, Cupertino, CA 95014, USA 37.323388 -122.031775
10588 10023 S De Anza Blvd, Cupertino, CA 95014, USA 37.322547 -122.032735
24622 929 Fremont Ave, Los Altos Hills, CA 94024, USA 37.354072 -122.088676
21026 3401 Middlefield Rd, Menlo Park, CA 94025, USA 37.470637 -122.201853
2550 790 W Middlefield Rd, Mountain View, CA 94043,... 37.402403 -122.074635

In [209]:
# print a csv of the remaining stations that aren't in locations_8
station_ids = set(stations.index)
found_station_ids = set(locations_8.index)
missing_ids = station_ids - found_station_ids
for station_id in missing_ids:
    print("{0},\"{1}\"".format(station_id, stations.loc[station_id].address))


68612,"995 Ralston Ave 6th Ave Belmont, CA 94002-2207"
14341,"3600 Alameda De Las Pulgas Avy Ave Menlo Park, CA 94025-6214"
12292,"2140 Winchester Blvd E Rincon Ave Campbell, CA 95008-3422"
33799,"7999 Westwood Dr 1st St Gilroy, CA 95020-4731"
26631,"906 Holly St Industrial Rd San Carlos, CA 94070-2538"
68617,"470 Ralston Ave Granada St Belmont, CA 94002-2830"
33802,"1190 1st St Westwood Dr Gilroy, CA 95020-4862"
26637,"90 El Camino Real Hull Dr San Carlos, CA 94070-2426"
4111,"699 San Antonio Rd Middlefield Rd Palo Alto, CA 94306-4712"
33809,"700 1st St Miller Ave Gilroy, CA 95020-4916"
2074,"2300 Homestead Rd Foothill Expy Los Altos, CA 94024-7338"
21024,"1101 Broadway Woodside Rd Redwood City, CA 94063-3125"
21025,"3233 Middlefield Rd Sixth Ave Menlo Park, CA 94025-1827"
14370,"639 Whipple Ave Winslow St Redwood City, CA 94063-1143"
14371,"1199 El Camino Real Sneath Ln San Bruno, CA 94066-2405"
24618,"390 Leavesley Rd Murray Ave Gilroy, CA 95020-3607"
27179,"255 Los Gatos Saratoga Rd Tait Ave Los Gatos, CA 95030-5316"
23596,"1890 S Norfolk St Fashion Island Blvd San Mateo, CA 94403-1102"
24621,"330 S San Antonio Rd Whitney St Los Altos, CA 94022-3614"
23597,"790 Polhemus Rd De Anza Blvd San Mateo, CA 94402-3938"
24619,"400 Leavesley Rd Murray Ave Gilroy, CA 95020-3609"
24626,"825 E Dunne Ave Laurel Ln Morgan Hill, CA 95037-4603"
24630,"801 N Fair Oaks Ave Ahwanee Ave Sunnyvale, CA 94085-3148"
14394,"1950 S Delaware St 19th Ave San Mateo, CA 94403-1426"
20035,"3751 Lafayette St Clyde Ave Santa Clara, CA 95054-2025"
71752,"215 El Camino Real Avondale Ave & Edgewood Rd Redwood City, CA 94062-1721"
77394,"3964 Callan Blvd King Dr South San Francisco, CA 94080-5153"
21077,"209 El Camino Real Hazelwood Dr South San Francisco, CA 94080-5920"
23638,"2800 S El Camino Real 28th Ave San Mateo, CA 94403-2729"
69205,"990 Veterans Blvd Main St Redwood City, CA 94063-1715"
21080,"899 Airport Blvd Linden Ave South San Francisco, CA 94080-1801"
23639,"700 Polhemus Rd Bunker Hill Dr San Mateo, CA 94402-3938"
12381,"300 S Airport Blvd Wonder Color Ln South San Francisco, CA 94080-6704"
24159,"1690 Sullivan Ave Pierce St Daly City, CA 94015-1941"
72800,"1603 Broadway Chestnut St Redwood City, CA 94063-2401"
24161,"410 Hickey Blvd Imperial Way Daly City, CA 94015-2603"
24160,"295 Washington St Sullivan Ave Daly City, CA 94015-1943"
81018,"7110 Camino Arroyo Renz Dr Gilroy, CA 95020-7347"
15485,"2000 Ralston Ave Villa Ave Belmont, CA 94002-1738"
15487,"495 El Camino Real Middle Ave Menlo Park, CA 94025-5240"
5253,"5696 Stevens Creek Blvd Stern Ave Cupertino, CA 95014-3662"
15497,"2800 Homestead Rd Kiely Blvd Santa Clara, CA 95051-3041"
39049,"16720 Monterey St San Pedro Ave Morgan Hill, CA 95037-5105"
39051,"15865 Monterey St Vineyard Blvd Morgan Hill, CA 95037-7122"
27789,"503 Whipple Ave Veterans Blvd Redwood City, CA 94063-1123"
15504,"4185 Stevens Creek Blvd Kiely Blvd Santa Clara, CA 95051-7051"
24231,"6989 Mission St Bismark St Daly City, CA 94014-2036"
33960,"9400 Cabrillo Hwy Vermont Ave Moss Beach, CA 94038-9625"
24758,"14000 Blossom Hill Rd Harwood Rd Los Gatos, CA 95032-5117"
108220,"304 Leavesley Rd Forest St  Gilroy, CA 95020-3607"
108223,"398 1st St Hanna St  Gilroy, CA 95020-5029"
93895,"95 Bill Drake Way  Palmetto Ave Pacifica, CA 94044-1802"
26319,"700 Hickey Blvd Gateway Dr Pacifica, CA 94044-1213"
3317,"1097 E Duane Ave Lawrence Expy Sunnyvale, CA 94085-2629"
1273,"1220 Grant Rd Bentley Sq Mountain View, CA 94040-3227"
3334,"295 Lawrence Expy E Arques Ave Sunnyvale, CA 94085-4603"
24842,"1370 Camden Ave Erin Way Campbell, CA 95008-6702"
24855,"12600 Saratoga Ave Bucknall Rd Saratoga, CA 95070-4189"
38171,"795 5th Ave Spring St Redwood City, CA 94063-3912"
24860,"3305 El Camino Real Pomeroy Ave Santa Clara, CA 95051-2804"
24861,"3500 Homestead Rd Princeton Way Santa Clara, CA 95051-5166"
24864,"2320 El Camino Real Los Padres Blvd Santa Clara, CA 95050-4059"
21793,"724 N Mathilda Ave San Aleso Ave Sunnyvale, CA 94085-3510"
3362,"905 E El Camino Real S Wolfe Rd Sunnyvale, CA 94087-3740"
117539,"505 Skyline Dr Westmoor Ave Daly City, CA 94015-4611"
18219,"1876 El Camino Real Murchison Dr Burlingame, CA 94010-3102"
68397,"234 El Camino Real Edgewood Rd Redwood City, CA 94062-1722"
18225,"1 Rollins Rd E Millbrae Ave Millbrae, CA 94030-3112"
18226,"1009 El Camino Real Meadow Glen Ave Millbrae, CA 94030-2013"
18228,"498 Palmetto Ave W Manor Dr Pacifica, CA 94044-1841"
18229,"2095 Coast HWY Reina del Mar Ave Pacifica, CA 94044-3038"
5431,"19030 Stevens Creek Blvd Judy Ave Cupertino, CA 95014-2502"
3895,"21855 Homestead Rd S Bernardo Ave Cupertino, CA 95014-0111"
5432,"1101 N Lawrence Expy Lakehaven Dr Sunnyvale, CA 94089-2025"
3896,"21530 Stevens Creek Blvd Bubb Rd Cupertino, CA 95014-1218"
11578,"20999 Stevens Creek Blvd N Stelling Rd Cupertino, CA 95014-2107"
67386,"2211 Monroe St Bailey Pl Santa Clara, CA 95050-3209"
18237,"1799 El Camino Real Santa Lucia Ave San Bruno, CA 94066-5401"
18234,"2303 Spring St  Charter St Redwood City, CA 94063-3017"
5440,"10490 S De Anza Blvd Pacifica Dr Cupertino, CA 95014-3002"
18242,"123 Linden Ave Baden Ave South San Francisco, CA 94080-4701"
5443,"840 San Antonio Rd E Charleston Rd Palo Alto, CA 94303"
5444,"5390 Great America Pkwy Old Mountain View-Alviso Rd Santa Clara, CA 95054-3602"
21317,"2025 El Camino Real Scott Blvd Santa Clara, CA 95050-4053"
21318,"1995 Warburton Ave Scott Blvd Santa Clara, CA 95050-4105"
18759,"698 N Fair Oaks Ave Caliente Dr Sunnyvale, CA 94085-3259"
11587,"1147 Rollins Rd Cadillac Way Burlingame, CA 94010-2502"
11592,"402 S Delaware St E 4th Ave San Mateo, CA 94402-1353"
18254,"3501 Homestead Rd Bing Dr Santa Clara, CA 95051-5116"
18256,"1198 W El Camino Real S Bernardo Ave Sunnyvale, CA 94087-1025"
18257,"296 N Fair Oaks Ave E Arques Ave Sunnyvale, CA 94085-3801"
21330,"2901 S Norfolk St E Hillsdale Blvd San Mateo, CA 94403-2017"
11606,"404 19th Ave S Delaware St San Mateo, CA 94403-1460"
62808,"401 Main St  1st St Los Altos, CA 94022-2822"
1374,"110 N Rengstorff Ave Central Expy Mountain View, CA 94043-4222"
14182,"611 E 3rd Ave S Delaware St San Mateo, CA 94401-3304"
33644,"601 Leavesley Rd San Ysidro Ave Gilroy, CA 95020-3610"
33645,"6991 Monterey Rd W 10th St Gilroy, CA 95020-6625"
33646,"7000 Monterey St E 10th St Gilroy, CA 95020-6614"
14701,"17005 Condit Rd E Dunne Ave Morgan Hill, CA 95037-3301"
35696,"100 Tennant Station Monterey St Morgan Hill, CA 95037-5478"
33143,"2428 Junipero Serra Blvd 88th St Daly City, CA 94015-1631"
23418,"498 N Mathilda Ave W Maude Ave Sunnyvale, CA 94085-4221"
12154,"810 E Dunne Ave Walnut Grove Dr Morgan Hill, CA 95037-4609"
14213,"335 S Norfolk St Beacon Ave San Mateo, CA 94401-3010"
14214,"246 S Spruce Ave Myrtle Ave South San Francisco, CA 94080-4550"
14215,"35 S Linden Ave S Canal St South San Francisco, CA 94080-6407"
5000,"1697 S Wolfe Rd E Homestead Rd Sunnyvale, CA 94087-4857"
5001,"750 S Bernardo Ave Brookfield Ave Sunnyvale, CA 94087-1009"
5002,"1296 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-2534"
5003,"3595 Benton St Lawrence Expy Santa Clara, CA 95051-4404"
4999,"1300 Sunnyvale Saratoga Rd E Fremont Ave Sunnyvale, CA 94087-3241"
117637,"17286 Skyline Blvd La Honda Rd Woodside, CA 94062-5707"
35726,"18560 Prospect Rd Lawrence Expy Saratoga, CA 95070-3651"
1426,"851 Cochrane Rd Madrone Pkwy Morgan Hill, CA 95037-2870"
5017,"11010 N De Anza Blvd Homestead Rd Cupertino, CA 95014-0443"
24476,"3972 El Camino Real Los Robles Ave Palo Alto, CA 94306-3318"
5020,"1010 El Monte Ave Marich Way Mountain View, CA 94040-2321"
18857,"3725 El Camino Real Halford Ave Santa Clara, CA 95051-2804"
4027,"789 E Evelyn Ave S Bernardo Ave Mountain View, CA 94041-1614"
11709,"1600 El Camino Real McLellan Dr South San Francisco, CA 94080-1206"
69053,"679 Hickey Blvd Gateway Dr Daly City, CA 94044"
33218,"601 1st St Carmel St Gilroy, CA 95020-5033"
33221,"401 Leavesley Rd Murray Ave Gilroy, CA 95020-3608"
5585,"1040 Sunnyvale Saratoga Rd E Remington Dr Sunnyvale, CA 94087-2545"
14308,"701 Harbor Blvd Old County Rd Belmont, CA 94002-3925"
14309,"1480 Broadway El Camino Real Burlingame, CA 94010-3428"
4068,"3471 Lafayette St Aldo Ave Santa Clara, CA 95054-2707"
14311,"1000 Broadway Rollins Rd Burlingame, CA 94010-2415"
14312,"1095 Carolan Ave Broadway Burlingame, CA 94010-2505"
14313,"1101 Broadway California Dr Burlingame, CA 94010-3421"
24044,"101 S Mayfair Ave Poncetta Dr Daly City, CA 94015-1246"
14319,"1390 Bayshore Hwy Burlway Rd Burlingame, CA 94010-1803"
14322,"2195 Junipero Serra Blvd Citrus Ave Daly City, CA 94014-1907"
22517,"3405 Winchester Blvd E Division St Campbell, CA 95008-6844"
14332,"1110 Marsh Rd Scott Dr Menlo Park, CA 94025-1014"
14333,"504 Whipple Ave Veterans Blvd Redwood City, CA 94063-1124"
14334,"585 Whipple Ave Winslow St Redwood City, CA 94063-1123"
68607,"699 Ralston Ave Old County Rd Belmont, CA 94002-2833"

In [211]:
missing = pd.read_csv('data/missing.csv', header=0, index_col=0)
missing.head(5)


Out[211]:
address
station_id
68612 995 Ralston Ave Belmont, CA 94002-2207
14341 3600 Alameda De Las Pulgas Menlo Park, CA 9402...
12292 2140 Winchester Blvd Campbell, CA 95008-3422
33799 7999 Westwood Dr, CA 95020-4731
26631 906 Holly St San Carlos, CA 94070-2538

In [215]:
[(i, missing.loc[i].address) for i in missing.index]


Out[215]:
[(68612, '995 Ralston Ave Belmont, CA 94002-2207'),
 (14341, '3600 Alameda De Las Pulgas Menlo Park, CA 94025-6214'),
 (12292, '2140 Winchester Blvd Campbell, CA 95008-3422'),
 (33799, '7999 Westwood Dr, CA 95020-4731'),
 (26631, '906 Holly St San Carlos, CA 94070-2538'),
 (68617, '470 Ralston Ave Belmont, CA 94002-2830'),
 (33802, '1190 1st St Gilroy, CA 95020-4862'),
 (26637, '90 El Camino Real San Carlos, CA 94070-2426'),
 (4111, '699 San Antonio Rd Palo Alto, CA 94306-4712'),
 (33809, '700 1st St Gilroy, CA 95020-4916'),
 (2074, '2300 Homestead Rd Los Altos, CA 94024-7338'),
 (21024, '1101 Broadway Redwood City, CA 94063-3125'),
 (21025, '3233 Middlefield Rd Menlo Park, CA 94025-1827'),
 (14370, '639 Whipple Ave Redwood City, CA 94063-1143'),
 (14371, '1199 El Camino Real San Bruno, CA 94066-2405'),
 (24618, '390 Leavesley Rd Gilroy, CA 95020-3607'),
 (27179, '255 Los Gatos Saratoga Rd Los Gatos, CA 95030-5316'),
 (23596, '1890 S Norfolk St San Mateo, CA 94403-1102'),
 (24621, '330 S San Antonio Rd Los Altos, CA 94022-3614'),
 (23597, '790 Polhemus Rd San Mateo, CA 94402-3938'),
 (24619, '400 Leavesley Rd Gilroy, CA 95020-3609'),
 (24626, '825 E Dunne Ave Morgan Hill, CA 95037-4603'),
 (24630, '801 N Fair Oaks Ave Sunnyvale, CA 94085-3148'),
 (14394, '1950 S Delaware St San Mateo, CA 94403-1426'),
 (20035, '3751 Lafayette St Santa Clara, CA 95054-2025'),
 (71752, '215 El Camino Real Redwood City, CA 94062-1721'),
 (77394, '3964 Callan Blvd South San Francisco, CA 94080-5153'),
 (21077, '209 El Camino Real South San Francisco, CA 94080-5920'),
 (23638, '2800 S El Camino Real San Mateo, CA 94403-2729'),
 (69205, '990 Veterans Blvd Redwood City, CA 94063-1715'),
 (21080, '899 Airport Blvd South San Francisco, CA 94080-1801'),
 (23639, '700 Polhemus Rd San Mateo, CA 94402-3938'),
 (12381, '300 S Airport Blvd South San Francisco, CA 94080-6704'),
 (24159, '1690 Sullivan Ave Daly City, CA 94015-1941'),
 (72800, '1603 Broadway Redwood City, CA 94063-2401'),
 (24161, '410 Hickey Blvd Daly City, CA 94015-2603'),
 (24160, '295 Washington St Daly City, CA 94015-1943'),
 (81018, '7110 Camino Arroyo Gilroy, CA 95020-7347'),
 (15485, '2000 Ralston Ave Belmont, CA 94002-1738'),
 (15487, '495 El Camino Real Menlo Park, CA 94025-5240'),
 (5253, '5696 Stevens Creek Blvd Cupertino, CA 95014-3662'),
 (15497, '2800 Homestead Rd Santa Clara, CA 95051-3041'),
 (39049, '16720 Monterey St Morgan Hill, CA 95037-5105'),
 (39051, '15865 Monterey St Morgan Hill, CA 95037-7122'),
 (27789, '503 Whipple Ave Redwood City, CA 94063-1123'),
 (15504, '4185 Stevens Creek Blvd Santa Clara, CA 95051-7051'),
 (24231, '6989 Mission St Daly City, CA 94014-2036'),
 (33960, '9400 Cabrillo Hwy Moss Beach, CA 94038-9625'),
 (24758, '14000 Blossom Hill Rd Los Gatos, CA 95032-5117'),
 (108220, '304 Leavesley Rd Gilroy, CA 95020-3607'),
 (108223, '398 1st St Gilroy, CA 95020-5029'),
 (93895, '95 Bill Drake Way  Pacifica, CA 94044-1802'),
 (26319, '700 Hickey Blvd Pacifica, CA 94044-1213'),
 (3317, '1097 E Duane Ave Sunnyvale, CA 94085-2629'),
 (1273, '1220 Grant Rd Mountain View, CA 94040-3227'),
 (3334, '295 Lawrence Expy Sunnyvale, CA 94085-4603'),
 (24842, '1370 Camden Ave Campbell, CA 95008-6702'),
 (24855, '12600 Saratoga Ave Saratoga, CA 95070-4189'),
 (38171, '795 5th Ave Redwood City, CA 94063-3912'),
 (24860, '3305 El Camino Real Santa Clara, CA 95051-2804'),
 (24861, '3500 Homestead Rd Santa Clara, CA 95051-5166'),
 (24864, '2320 El Camino Real Santa Clara, CA 95050-4059'),
 (21793, '724 N Mathilda Ave Sunnyvale, CA 94085-3510'),
 (3362, '905 E El Camino Real Sunnyvale, CA 94087-3740'),
 (117539, '505 Skyline Dr Daly City, CA 94015-4611'),
 (18219, '1876 El Camino Real Burlingame, CA 94010-3102'),
 (68397, '234 El Camino Real Redwood City, CA 94062-1722'),
 (18225, '1 Rollins Rd Millbrae, CA 94030-3112'),
 (18226, '1009 El Camino Real Millbrae, CA 94030-2013'),
 (18228, '498 Palmetto Ave Dr Pacifica, CA 94044-1841'),
 (18229, '2095 Coast HWY Pacifica, CA 94044-3038'),
 (5431, '19030 Stevens Creek Blvd Cupertino, CA 95014-2502'),
 (3895, '21855 Homestead Rd Cupertino, CA 95014-0111'),
 (5432, '1101 N Lawrence Expy Sunnyvale, CA 94089-2025'),
 (3896, '21530 Stevens Creek Blvd Cupertino, CA 95014-1218'),
 (11578, '20999 Stevens Creek Blvd Cupertino, CA 95014-2107'),
 (67386, '2211 Monroe St Santa Clara, CA 95050-3209'),
 (18237, '1799 El Camino Real San Bruno, CA 94066-5401'),
 (18234, '2303 Spring St Redwood City, CA 94063-3017'),
 (5440, '10490 S De Anza Blvd Cupertino, CA 95014-3002'),
 (18242, '123 Linden Ave South San Francisco, CA 94080-4701'),
 (5443, '840 San Antonio Rd Palo Alto, CA 94303'),
 (5444, '5390 Great America Pkwy Santa Clara, CA 95054-3602'),
 (21317, '2025 El Camino Real Santa Clara, CA 95050-4053'),
 (21318, '1995 Warburton Ave Santa Clara, CA 95050-4105'),
 (18759, '698 N Fair Oaks Ave Sunnyvale, CA 94085-3259'),
 (11587, '1147 Rollins Rd Burlingame, CA 94010-2502'),
 (11592, '402 S Delaware St San Mateo, CA 94402-1353'),
 (18254, '3501 Homestead Rd Santa Clara, CA 95051-5116'),
 (18256, '1198 W El Camino Real Sunnyvale, CA 94087-1025'),
 (18257, '296 N Fair Oaks Ave Sunnyvale, CA 94085-3801'),
 (21330, '2901 S Norfolk St San Mateo, CA 94403-2017'),
 (11606, '404 19th Ave San Mateo, CA 94403-1460'),
 (62808, '401 Main St Los Altos, CA 94022-2822'),
 (1374, '110 N Rengstorff Ave Mountain View, CA 94043-4222'),
 (14182, '611 E 3rd Ave San Mateo, CA 94401-3304'),
 (33644, '601 Leavesley Rd Gilroy, CA 95020-3610'),
 (33645, '6991 Monterey Rd Gilroy, CA 95020-6625'),
 (33646, '7000 Monterey St Gilroy, CA 95020-6614'),
 (14701, '17005 Condit Rd Morgan Hill, CA 95037-3301'),
 (35696, '100 Tennant Station Morgan Hill, CA 95037-5478'),
 (33143, '2428 Junipero Serra Blvd Daly City, CA 94015-1631'),
 (23418, '498 N Mathilda Ave Sunnyvale, CA 94085-4221'),
 (12154, '810 E Dunne Ave Morgan Hill, CA 95037-4609'),
 (14213, '335 S Norfolk St San Mateo, CA 94401-3010'),
 (14214, '246 S Spruce Ave South San Francisco, CA 94080-4550'),
 (14215, '35 S Linden Ave South San Francisco, CA 94080-6407'),
 (5000, '1697 S Wolfe Rd Sunnyvale, CA 94087-4857'),
 (5001, '750 S Bernardo Ave Sunnyvale, CA 94087-1009'),
 (5002, '1296 Sunnyvale Saratoga Rd Sunnyvale, CA 94087-2534'),
 (5003, '3595 Benton St Santa Clara, CA 95051-4404'),
 (4999, '1300 Sunnyvale Saratoga Rd Sunnyvale, CA 94087-3241'),
 (117637, '17286 Skyline Blvd Woodside, CA 94062-5707'),
 (35726, '18560 Prospect Rd Saratoga, CA 95070-3651'),
 (1426, '851 Cochrane Rd Morgan Hill, CA 95037-2870'),
 (5017, '11010 N De Anza Blvd Cupertino, CA 95014-0443'),
 (24476, '3972 El Camino Real Palo Alto, CA 94306-3318'),
 (5020, '1010 El Monte Ave Mountain View, CA 94040-2321'),
 (18857, '3725 El Camino Real Santa Clara, CA 95051-2804'),
 (4027, '789 E Evelyn Ave Mountain View, CA 94041-1614'),
 (11709, '1600 El Camino Real South San Francisco, CA 94080-1206'),
 (69053, '679 Hickey Blvd Daly City, CA 94044'),
 (33218, '601 1st St Gilroy, CA 95020-5033'),
 (33221, '401 Leavesley Rd Gilroy, CA 95020-3608'),
 (5585, '1040 Sunnyvale Saratoga Rd Sunnyvale, CA 94087-2545'),
 (14308, '701 Harbor Blvd Belmont, CA 94002-3925'),
 (14309, '1480 Broadway Burlingame, CA 94010-3428'),
 (4068, '3471 Lafayette Santa Clara, CA 95054-2707'),
 (14311, '1000 Broadway Burlingame, CA 94010-2415'),
 (14312, '1095 Carolan Ave Burlingame, CA 94010-2505'),
 (14313, '1101 Broadway Burlingame, CA 94010-3421'),
 (24044, '101 S Mayfair Ave Daly City, CA 94015-1246'),
 (14319, '1390 Bayshore Hwy Burlingame, CA 94010-1803'),
 (14322, '2195 Junipero Serra Blvd Daly City, CA 94014-1907'),
 (22517, '3405 Winchester Blvd Campbell, CA 95008-6844'),
 (14332, '1110 Marsh Rd Menlo Park, CA 94025-1014'),
 (14333, '504 Whipple Ave Redwood City, CA 94063-1124'),
 (14334, '585 Whipple Ave Redwood City, CA 94063-1123'),
 (68607, '699 Ralston Ave Belmont, CA 94002-2833')]

In [218]:
locations_9 = {} # station_id to google location object
remaining = [(i, missing.loc[i].address) for i in missing.index] # station_id
while len(remaining) > 0:
    station_id, address = remaining.pop()
#     print("{0},\"{1}\"".format(station_id, address))
    try:
        loc = geolocator.geocode(address)
    except Exception as e:
        print(e)
        remaining.append((station_id, address))
    else:
        if loc:
            locations_9[station_id] = loc
            print("{0},\"{1}\",{2},{3}".format(station_id, loc.address, loc.latitude, loc.longitude))
        else:
            print("None found for station_id:{0} address:\"{1}\"".format(station_id, address))
    time.sleep(3) # rate limiting


68607,"699 Ralston Ave, Belmont, CA 94002, USA",37.5209944,-122.2747726
14334,"585 Whipple Ave, Redwood City, CA 94063, USA",37.4936723,-122.2352483
14333,"504 Whipple Ave, Redwood City, CA 94063, USA",37.4946046,-122.2349779
14332,"1110 Marsh Rd, Menlo Park, CA 94025, USA",37.4807452,-122.1835784
22517,"3405 Winchester Blvd, Campbell, CA 95008, USA",37.2634276,-121.9611803
14322,"2195 Junipero Serra Blvd, Daly City, CA 94014, USA",37.6978517,-122.470482
14319,"1390 Old Bayshore Hwy, Burlingame, CA 94010, USA",37.596303,-122.3649243
24044,"101 S Mayfair Ave, Daly City, CA 94015, USA",37.703591,-122.4755826
14313,"1101 Broadway, Burlingame, CA 94010, USA",37.5872453,-122.3634522
14312,"1095 Carolan Ave, Burlingame, CA 94010, USA",37.587666,-122.3623954
Service timed out
14311,"1000 Broadway, Burlingame, CA 94010, USA",37.58882390000001,-122.362766
4068,"3471 Lafayette St, Santa Clara, CA 95054, USA",37.3835604,-121.9505832
14309,"1480 Broadway, Burlingame, CA 94010, USA",37.584588,-122.3663676
14308,"701 Harbor Blvd, Belmont, CA 94002, USA",37.5174544,-122.2712294
5585,"1040 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3586578,-122.0318173
33221,"401 Leavesley Rd, Gilroy, CA 95020, USA",37.0218954,-121.56912
33218,"601 1st St, Gilroy, CA 95020, USA",37.0137425,-121.5806065
69053,"679 Hickey Blvd, Pacifica, CA 94044, USA",37.659615,-122.478494
11709,"1600 El Camino Real, South San Francisco, CA 94080, USA",37.6656027,-122.4488714
4027,"789 E Evelyn Ave, Mountain View, CA 94041, USA",37.3854371,-122.0528886
18857,"3725 El Camino Real, Santa Clara, CA 95051, USA",37.3527799,-121.9987067
5020,"1010 El Monte Ave, Mountain View, CA 94040, USA",37.3905325,-122.0961785
24476,"3972 El Camino Real, Palo Alto, CA 94306, USA",37.4160321,-122.1293045
5017,"11010 N De Anza Blvd, Cupertino, CA 95014, USA",37.3379097,-122.0318624
1426,"851 Cochrane Rd, Morgan Hill, CA 95037, USA",37.1519182,-121.655548
35726,"18560 Prospect Rd, Saratoga, CA 95070, USA",37.2916675,-121.9957883
117637,"17286 Skyline Blvd, Woodside, CA 94062, USA",37.3878818,-122.2669805
4999,"1300 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3517654,-122.031929
5003,"3595 Benton St, Santa Clara, CA 95051, USA",37.34585,-121.9952685
5002,"1296 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3526576,-122.0318157
5001,"750 S Bernardo Ave, Sunnyvale, CA 94087, USA",37.3707222,-122.0568769
5000,"1697 S Wolfe Rd, Sunnyvale, CA 94087, USA",37.3381478,-122.0147469
14215,"35 S Linden Ave, South San Francisco, CA 94080, USA",37.6500028,-122.4116949
14214,"246 S Spruce Ave, South San Francisco, CA 94080, USA",37.6473114,-122.4207027
14213,"335 S Norfolk St, San Mateo, CA 94401, USA",37.5726155,-122.3104126
12154,"810 E Dunne Ave, Morgan Hill, CA 95037, USA",37.1297974,-121.6374213
23418,"498 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3891367,-122.0299268
33143,"2428 Junipero Serra Blvd, Daly City, CA 94015, USA",37.692722,-122.4712426
35696,"Tennant Station, Morgan Hill, CA 95037, USA",37.1145682,-121.6385262
14701,"17005 Condit Rd, Morgan Hill, CA 95037, USA",37.133027,-121.6309077
33646,"7000 Monterey Rd, Gilroy, CA 95020, USA",37.0008422,-121.565372
33645,"6991 Monterey Rd, Gilroy, CA 95020, USA",36.9999731,-121.5658612
33644,"601 Leavesley Rd, Gilroy, CA 95020, USA",37.0236436,-121.564619
14182,"611 E 3rd Ave, San Mateo, CA 94401, USA",37.567517,-122.320076
1374,"110 N Rengstorff Ave, Mountain View, CA 94043, USA",37.403605,-122.0975802
62808,"401 Main St, Los Altos, CA 94022, USA",37.37742300000001,-122.1178666
11606,"404 19th Ave, San Mateo, CA 94403, USA",37.5518614,-122.3047474
21330,"2901 S Norfolk St, San Mateo, CA 94403, USA",37.5460672,-122.2844306
18257,"296 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3812745,-122.0178386
Service timed out
18256,"1198 W El Camino Real, Sunnyvale, CA 94087, USA",37.3734768,-122.0561422
18254,"3501 Homestead Rd, Santa Clara, CA 95051, USA",37.3382145,-121.9933205
11592,"402 S Delaware St, San Mateo, CA 94402, USA",37.5661304,-122.3189582
11587,"1147 Rollins Rd, Burlingame, CA 94010, USA",37.5885162,-122.3605955
18759,"698 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3908661,-122.0139282
21318,"1995 Warburton Ave, Santa Clara, CA 95050, USA",37.356038,-121.9590427
21317,"2025 El Camino Real, Santa Clara, CA 95050, USA",37.3528544,-121.9612654
5444,"5390 Great America Pkwy, Santa Clara, CA 95054, USA",37.4102623,-121.9781893
5443,"840 San Antonio Rd, Palo Alto, CA 94303, USA",37.4216078,-122.1014157
18242,"123 Linden Ave, South San Francisco, CA 94080, USA",37.6540008,-122.4107952
5440,"10490 S De Anza Blvd, Cupertino, CA 95014, USA",37.3158559,-122.0319438
18234,"2303 Spring St, Redwood City, CA 94063, USA",37.4836101,-122.2128576
18237,"1799 El Camino Real, San Bruno, CA 94066, USA",37.61481870000001,-122.4061935
67386,"2211 Monroe St, Santa Clara, CA 95050, USA",37.361831,-121.9621354
11578,"20999 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.323212,-122.0409997
3896,"21530 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3224637,-122.0515374
5432,"1101 Lawrence Expy, Sunnyvale, CA 94089, USA",37.3963616,-121.9962175
Service timed out
3895,"21855 Homestead Rd, Cupertino, CA 95014, USA",37.3375537,-122.0586488
5431,"19030 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226904,-122.0051231
18229,"2095 Pacific Coast Hwy, Pacifica, CA 94044, USA",37.6140351,-122.4863662
18228,"498 Palmetto Ave, Pacifica, CA 94044, USA",37.6495633,-122.4912539
18226,"1009 El Camino Real, Millbrae, CA 94030, USA",37.6059168,-122.3973679
18225,"1 Rollins Rd, Millbrae, CA 94030, USA",37.600242,-122.3834758
68397,"234 El Camino Real, Redwood City, CA 94062, USA",37.4917118,-122.2423102
18219,"1876 El Camino Real, Burlingame, CA 94010, USA",37.5967924,-122.3850616
117539,"505 Skyline Dr, Daly City, CA 94015, USA",37.6831156,-122.4898125
3362,"905 E El Camino Real, Sunnyvale, CA 94087, USA",37.35331499999999,-122.0135458
21793,"724 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3940074,-122.0288172
24864,"2320 El Camino Real, Santa Clara, CA 95050, USA",37.3519156,-121.9652154
24861,"3500 Homestead Rd, Santa Clara, CA 95051, USA",37.3374968,-121.9931905
24860,"3305 El Camino Real, Santa Clara, CA 95051, USA",37.3527969,-121.9871653
38171,"795 Fifth Ave, Redwood City, CA 94063, USA",37.4798358,-122.2001544
24855,"12600 Saratoga Ave, Saratoga, CA 95070, USA",37.2842854,-121.9993055
24842,"1370 Camden Ave, Campbell, CA 95008, USA",37.2691681,-121.9443854
3334,"295 Lawrence Expy, Sunnyvale, CA 94085, USA",37.3801143,-121.9964766
1273,"1220 Grant Rd, Mountain View, CA 94040, USA",37.3781802,-122.075306
3317,"1097 E Duane Ave, Sunnyvale, CA 94085, USA",37.3873025,-121.9965454
26319,"700 Hickey Blvd, Pacifica, CA 94044, USA",37.6596424,-122.4773912
93895,"95 Bill Drake Way, Pacifica, CA 94044, USA",37.6513856,-122.4911524
108223,"398 1st St, Gilroy, CA 95020, USA",37.01304289999999,-121.5765969
108220,"304 Leavesley Rd, Gilroy, CA 95020, USA",37.0203637,-121.5718146
24758,"14000 Blossom Hill Rd, Los Gatos, CA 95032, USA",37.2362588,-121.9134443
33960,"9400 Cabrillo Hwy, Moss Beach, CA 94038, USA",37.5286572,-122.5147127
24231,"6989 Mission St, Daly City, CA 94014, USA",37.6959437,-122.4642117
15504,"4185 Stevens Creek Blvd, Santa Clara, CA 95051, USA",37.3234878,-121.9748412
27789,"503 Whipple Ave, Redwood City, CA 94063, USA",37.494234,-122.2345272
39051,"15865 Monterey Rd, Morgan Hill, CA 95037, USA",37.1103969,-121.64063
39049,"16720 Monterey Rd, Morgan Hill, CA 95037, USA",37.1215628,-121.647455
15497,"2800 Homestead Rd, Santa Clara, CA 95051, USA",37.3380075,-121.9769578
5253,"5696 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226475,-122.0029747
15487,"495 El Camino Real, Menlo Park, CA 94025, USA",37.4500531,-122.1771562
15485,"2000 Ralston Ave, Belmont, CA 94002, USA",37.5126391,-122.293709
81018,"7110 Camino Arroyo, Gilroy, CA 95020, USA",37.0066498,-121.5519855
24160,"295 Washington St, Daly City, CA 94015, USA",37.6876625,-122.4719754
24161,"410 Hickey Blvd, Daly City, CA 94015, USA",37.6636977,-122.4645084
72800,"1603 Broadway, Redwood City, CA 94063, USA",37.4867052,-122.2188094
24159,"1690 Sullivan Ave, Daly City, CA 94015, USA",37.6862185,-122.4725062
12381,"300 S Airport Blvd, South San Francisco, CA 94080, USA",37.6463214,-122.4058812
23639,"700 Polhemus Rd, San Mateo, CA 94402, USA",37.520815,-122.3395814
21080,"899 Airport Blvd, South San Francisco, CA 94080, USA",37.6610776,-122.4047814
69205,"990 Veterans Blvd, Redwood City, CA 94063, USA",37.4896943,-122.2273269
23638,"2800 S El Camino Real, San Mateo, CA 94403, USA",37.541364,-122.30294
21077,"209 El Camino Real, South San Francisco, CA 94080, USA",37.6427595,-122.4256869
77394,"3964 Callan Blvd, South San Francisco, CA 94080, USA",37.6501903,-122.4684468
71752,"215 El Camino Real, Redwood City, CA 94062, USA",37.492573,-122.2425892
20035,"3751 Lafayette St, Santa Clara, CA 95054, USA",37.3877219,-121.9532647
14394,"1950 S Delaware St, San Mateo, CA 94403, USA",37.5517535,-122.305703
24630,"801 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3931571,-122.0143474
24626,"825 E Dunne Ave, Morgan Hill, CA 95037, USA",37.1307698,-121.6367534
24619,"400 Leavesley Rd, Gilroy, CA 95020, USA",37.0211484,-121.5687206
23597,"790 Polhemus Rd, San Mateo, CA 94402, USA",37.5197401,-122.3378333
24621,"330 S San Antonio Rd, Los Altos, CA 94022, USA",37.3769579,-122.1145811
23596,"1890 S Norfolk St, San Mateo, CA 94403, USA",37.5543296,-122.2922794
27179,"255 Saratoga Los Gatos Rd, Los Gatos, CA 95030, USA",37.229868,-121.9828149
24618,"390 Leavesley Rd, Gilroy, CA 95020, USA",37.0210275,-121.569434
14371,"1199 El Camino Real, San Bruno, CA 94066, USA",37.63624009999999,-122.4213671
14370,"639 Whipple Ave, Redwood City, CA 94063, USA",37.4931246,-122.2361667
21025,"3233 Middlefield Rd, Menlo Park, CA 94025, USA",37.4716961,-122.2033201
21024,"1101 Broadway, Redwood City, CA 94063, USA",37.4866877,-122.2133228
2074,"2300 Homestead Rd, Los Altos, CA 94024, USA",37.3375748,-122.0679454
33809,"700 1st St, Gilroy, CA 95020, USA",37.0129938,-121.5822601
4111,"699 San Antonio Rd, Palo Alto, CA 94306, USA",37.4161981,-122.1039929
26637,"90 El Camino Real, San Carlos, CA 94070, USA",37.5118427,-122.2669679
33802,"1190 1st St, Gilroy, CA 95020, USA",37.0133388,-121.5933614
68617,"470 Ralston Ave, Belmont, CA 94002, USA",37.52353530000001,-122.2733848
26631,"906 Holly St, San Carlos, CA 94070, USA",37.51183899999999,-122.2583753
33799,"7999 Westwood Dr, Gilroy, CA 95020, USA",37.0131642,-121.5941416
12292,"2140 Winchester Blvd, Campbell, CA 95008, USA",37.2846573,-121.9493445
14341,"3600 Alameda de las Pulgas, Menlo Park, CA 94025, USA",37.4315666,-122.2014719
68612,"995 Ralston Ave, Belmont, CA 94002, USA",37.519182,-122.2768291

In [219]:
print_locations_dict(locations_9)


68607,"699 Ralston Ave, Belmont, CA 94002, USA",37.5209944,-122.2747726
14334,"585 Whipple Ave, Redwood City, CA 94063, USA",37.4936723,-122.2352483
14333,"504 Whipple Ave, Redwood City, CA 94063, USA",37.4946046,-122.2349779
14332,"1110 Marsh Rd, Menlo Park, CA 94025, USA",37.4807452,-122.1835784
22517,"3405 Winchester Blvd, Campbell, CA 95008, USA",37.2634276,-121.9611803
14322,"2195 Junipero Serra Blvd, Daly City, CA 94014, USA",37.6978517,-122.470482
14319,"1390 Old Bayshore Hwy, Burlingame, CA 94010, USA",37.596303,-122.3649243
24044,"101 S Mayfair Ave, Daly City, CA 94015, USA",37.703591,-122.4755826
14313,"1101 Broadway, Burlingame, CA 94010, USA",37.5872453,-122.3634522
14312,"1095 Carolan Ave, Burlingame, CA 94010, USA",37.587666,-122.3623954
14311,"1000 Broadway, Burlingame, CA 94010, USA",37.58882390000001,-122.362766
4068,"3471 Lafayette St, Santa Clara, CA 95054, USA",37.3835604,-121.9505832
14309,"1480 Broadway, Burlingame, CA 94010, USA",37.584588,-122.3663676
14308,"701 Harbor Blvd, Belmont, CA 94002, USA",37.5174544,-122.2712294
5585,"1040 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3586578,-122.0318173
33221,"401 Leavesley Rd, Gilroy, CA 95020, USA",37.0218954,-121.56912
33218,"601 1st St, Gilroy, CA 95020, USA",37.0137425,-121.5806065
69053,"679 Hickey Blvd, Pacifica, CA 94044, USA",37.659615,-122.478494
11709,"1600 El Camino Real, South San Francisco, CA 94080, USA",37.6656027,-122.4488714
4027,"789 E Evelyn Ave, Mountain View, CA 94041, USA",37.3854371,-122.0528886
18857,"3725 El Camino Real, Santa Clara, CA 95051, USA",37.3527799,-121.9987067
5020,"1010 El Monte Ave, Mountain View, CA 94040, USA",37.3905325,-122.0961785
24476,"3972 El Camino Real, Palo Alto, CA 94306, USA",37.4160321,-122.1293045
5017,"11010 N De Anza Blvd, Cupertino, CA 95014, USA",37.3379097,-122.0318624
1426,"851 Cochrane Rd, Morgan Hill, CA 95037, USA",37.1519182,-121.655548
35726,"18560 Prospect Rd, Saratoga, CA 95070, USA",37.2916675,-121.9957883
117637,"17286 Skyline Blvd, Woodside, CA 94062, USA",37.3878818,-122.2669805
4999,"1300 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3517654,-122.031929
5003,"3595 Benton St, Santa Clara, CA 95051, USA",37.34585,-121.9952685
5002,"1296 Sunnyvale Saratoga Rd, Sunnyvale, CA 94087, USA",37.3526576,-122.0318157
5001,"750 S Bernardo Ave, Sunnyvale, CA 94087, USA",37.3707222,-122.0568769
5000,"1697 S Wolfe Rd, Sunnyvale, CA 94087, USA",37.3381478,-122.0147469
14215,"35 S Linden Ave, South San Francisco, CA 94080, USA",37.6500028,-122.4116949
14214,"246 S Spruce Ave, South San Francisco, CA 94080, USA",37.6473114,-122.4207027
14213,"335 S Norfolk St, San Mateo, CA 94401, USA",37.5726155,-122.3104126
12154,"810 E Dunne Ave, Morgan Hill, CA 95037, USA",37.1297974,-121.6374213
23418,"498 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3891367,-122.0299268
33143,"2428 Junipero Serra Blvd, Daly City, CA 94015, USA",37.692722,-122.4712426
35696,"Tennant Station, Morgan Hill, CA 95037, USA",37.1145682,-121.6385262
14701,"17005 Condit Rd, Morgan Hill, CA 95037, USA",37.133027,-121.6309077
33646,"7000 Monterey Rd, Gilroy, CA 95020, USA",37.0008422,-121.565372
33645,"6991 Monterey Rd, Gilroy, CA 95020, USA",36.9999731,-121.5658612
33644,"601 Leavesley Rd, Gilroy, CA 95020, USA",37.0236436,-121.564619
14182,"611 E 3rd Ave, San Mateo, CA 94401, USA",37.567517,-122.320076
1374,"110 N Rengstorff Ave, Mountain View, CA 94043, USA",37.403605,-122.0975802
62808,"401 Main St, Los Altos, CA 94022, USA",37.37742300000001,-122.1178666
11606,"404 19th Ave, San Mateo, CA 94403, USA",37.5518614,-122.3047474
21330,"2901 S Norfolk St, San Mateo, CA 94403, USA",37.5460672,-122.2844306
18257,"296 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3812745,-122.0178386
18256,"1198 W El Camino Real, Sunnyvale, CA 94087, USA",37.3734768,-122.0561422
18254,"3501 Homestead Rd, Santa Clara, CA 95051, USA",37.3382145,-121.9933205
11592,"402 S Delaware St, San Mateo, CA 94402, USA",37.5661304,-122.3189582
11587,"1147 Rollins Rd, Burlingame, CA 94010, USA",37.5885162,-122.3605955
18759,"698 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3908661,-122.0139282
21318,"1995 Warburton Ave, Santa Clara, CA 95050, USA",37.356038,-121.9590427
21317,"2025 El Camino Real, Santa Clara, CA 95050, USA",37.3528544,-121.9612654
5444,"5390 Great America Pkwy, Santa Clara, CA 95054, USA",37.4102623,-121.9781893
5443,"840 San Antonio Rd, Palo Alto, CA 94303, USA",37.4216078,-122.1014157
18242,"123 Linden Ave, South San Francisco, CA 94080, USA",37.6540008,-122.4107952
5440,"10490 S De Anza Blvd, Cupertino, CA 95014, USA",37.3158559,-122.0319438
18234,"2303 Spring St, Redwood City, CA 94063, USA",37.4836101,-122.2128576
18237,"1799 El Camino Real, San Bruno, CA 94066, USA",37.61481870000001,-122.4061935
67386,"2211 Monroe St, Santa Clara, CA 95050, USA",37.361831,-121.9621354
11578,"20999 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.323212,-122.0409997
3896,"21530 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3224637,-122.0515374
5432,"1101 Lawrence Expy, Sunnyvale, CA 94089, USA",37.3963616,-121.9962175
3895,"21855 Homestead Rd, Cupertino, CA 95014, USA",37.3375537,-122.0586488
5431,"19030 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226904,-122.0051231
18229,"2095 Pacific Coast Hwy, Pacifica, CA 94044, USA",37.6140351,-122.4863662
18228,"498 Palmetto Ave, Pacifica, CA 94044, USA",37.6495633,-122.4912539
18226,"1009 El Camino Real, Millbrae, CA 94030, USA",37.6059168,-122.3973679
18225,"1 Rollins Rd, Millbrae, CA 94030, USA",37.600242,-122.3834758
68397,"234 El Camino Real, Redwood City, CA 94062, USA",37.4917118,-122.2423102
18219,"1876 El Camino Real, Burlingame, CA 94010, USA",37.5967924,-122.3850616
117539,"505 Skyline Dr, Daly City, CA 94015, USA",37.6831156,-122.4898125
3362,"905 E El Camino Real, Sunnyvale, CA 94087, USA",37.35331499999999,-122.0135458
21793,"724 N Mathilda Ave, Sunnyvale, CA 94085, USA",37.3940074,-122.0288172
24864,"2320 El Camino Real, Santa Clara, CA 95050, USA",37.3519156,-121.9652154
24861,"3500 Homestead Rd, Santa Clara, CA 95051, USA",37.3374968,-121.9931905
24860,"3305 El Camino Real, Santa Clara, CA 95051, USA",37.3527969,-121.9871653
38171,"795 Fifth Ave, Redwood City, CA 94063, USA",37.4798358,-122.2001544
24855,"12600 Saratoga Ave, Saratoga, CA 95070, USA",37.2842854,-121.9993055
24842,"1370 Camden Ave, Campbell, CA 95008, USA",37.2691681,-121.9443854
3334,"295 Lawrence Expy, Sunnyvale, CA 94085, USA",37.3801143,-121.9964766
1273,"1220 Grant Rd, Mountain View, CA 94040, USA",37.3781802,-122.075306
3317,"1097 E Duane Ave, Sunnyvale, CA 94085, USA",37.3873025,-121.9965454
26319,"700 Hickey Blvd, Pacifica, CA 94044, USA",37.6596424,-122.4773912
93895,"95 Bill Drake Way, Pacifica, CA 94044, USA",37.6513856,-122.4911524
108223,"398 1st St, Gilroy, CA 95020, USA",37.01304289999999,-121.5765969
108220,"304 Leavesley Rd, Gilroy, CA 95020, USA",37.0203637,-121.5718146
24758,"14000 Blossom Hill Rd, Los Gatos, CA 95032, USA",37.2362588,-121.9134443
33960,"9400 Cabrillo Hwy, Moss Beach, CA 94038, USA",37.5286572,-122.5147127
24231,"6989 Mission St, Daly City, CA 94014, USA",37.6959437,-122.4642117
15504,"4185 Stevens Creek Blvd, Santa Clara, CA 95051, USA",37.3234878,-121.9748412
27789,"503 Whipple Ave, Redwood City, CA 94063, USA",37.494234,-122.2345272
39051,"15865 Monterey Rd, Morgan Hill, CA 95037, USA",37.1103969,-121.64063
39049,"16720 Monterey Rd, Morgan Hill, CA 95037, USA",37.1215628,-121.647455
15497,"2800 Homestead Rd, Santa Clara, CA 95051, USA",37.3380075,-121.9769578
5253,"5696 Stevens Creek Blvd, Cupertino, CA 95014, USA",37.3226475,-122.0029747
15487,"495 El Camino Real, Menlo Park, CA 94025, USA",37.4500531,-122.1771562
15485,"2000 Ralston Ave, Belmont, CA 94002, USA",37.5126391,-122.293709
81018,"7110 Camino Arroyo, Gilroy, CA 95020, USA",37.0066498,-121.5519855
24160,"295 Washington St, Daly City, CA 94015, USA",37.6876625,-122.4719754
24161,"410 Hickey Blvd, Daly City, CA 94015, USA",37.6636977,-122.4645084
72800,"1603 Broadway, Redwood City, CA 94063, USA",37.4867052,-122.2188094
24159,"1690 Sullivan Ave, Daly City, CA 94015, USA",37.6862185,-122.4725062
12381,"300 S Airport Blvd, South San Francisco, CA 94080, USA",37.6463214,-122.4058812
23639,"700 Polhemus Rd, San Mateo, CA 94402, USA",37.520815,-122.3395814
21080,"899 Airport Blvd, South San Francisco, CA 94080, USA",37.6610776,-122.4047814
69205,"990 Veterans Blvd, Redwood City, CA 94063, USA",37.4896943,-122.2273269
23638,"2800 S El Camino Real, San Mateo, CA 94403, USA",37.541364,-122.30294
21077,"209 El Camino Real, South San Francisco, CA 94080, USA",37.6427595,-122.4256869
77394,"3964 Callan Blvd, South San Francisco, CA 94080, USA",37.6501903,-122.4684468
71752,"215 El Camino Real, Redwood City, CA 94062, USA",37.492573,-122.2425892
20035,"3751 Lafayette St, Santa Clara, CA 95054, USA",37.3877219,-121.9532647
14394,"1950 S Delaware St, San Mateo, CA 94403, USA",37.5517535,-122.305703
24630,"801 N Fair Oaks Ave, Sunnyvale, CA 94085, USA",37.3931571,-122.0143474
24626,"825 E Dunne Ave, Morgan Hill, CA 95037, USA",37.1307698,-121.6367534
24619,"400 Leavesley Rd, Gilroy, CA 95020, USA",37.0211484,-121.5687206
23597,"790 Polhemus Rd, San Mateo, CA 94402, USA",37.5197401,-122.3378333
24621,"330 S San Antonio Rd, Los Altos, CA 94022, USA",37.3769579,-122.1145811
23596,"1890 S Norfolk St, San Mateo, CA 94403, USA",37.5543296,-122.2922794
27179,"255 Saratoga Los Gatos Rd, Los Gatos, CA 95030, USA",37.229868,-121.9828149
24618,"390 Leavesley Rd, Gilroy, CA 95020, USA",37.0210275,-121.569434
14371,"1199 El Camino Real, San Bruno, CA 94066, USA",37.63624009999999,-122.4213671
14370,"639 Whipple Ave, Redwood City, CA 94063, USA",37.4931246,-122.2361667
21025,"3233 Middlefield Rd, Menlo Park, CA 94025, USA",37.4716961,-122.2033201
21024,"1101 Broadway, Redwood City, CA 94063, USA",37.4866877,-122.2133228
2074,"2300 Homestead Rd, Los Altos, CA 94024, USA",37.3375748,-122.0679454
33809,"700 1st St, Gilroy, CA 95020, USA",37.0129938,-121.5822601
4111,"699 San Antonio Rd, Palo Alto, CA 94306, USA",37.4161981,-122.1039929
26637,"90 El Camino Real, San Carlos, CA 94070, USA",37.5118427,-122.2669679
33802,"1190 1st St, Gilroy, CA 95020, USA",37.0133388,-121.5933614
68617,"470 Ralston Ave, Belmont, CA 94002, USA",37.52353530000001,-122.2733848
26631,"906 Holly St, San Carlos, CA 94070, USA",37.51183899999999,-122.2583753
33799,"7999 Westwood Dr, Gilroy, CA 95020, USA",37.0131642,-121.5941416
12292,"2140 Winchester Blvd, Campbell, CA 95008, USA",37.2846573,-121.9493445
14341,"3600 Alameda de las Pulgas, Menlo Park, CA 94025, USA",37.4315666,-122.2014719
68612,"995 Ralston Ave, Belmont, CA 94002, USA",37.519182,-122.2768291

In [220]:
locations_10 = pd.read_csv('data/locations_9.csv', header=0, index_col=0)
locations_10.head(5)


Out[220]:
address latitude longitude
station_id
68607 699 Ralston Ave, Belmont, CA 94002, USA 37.520994 -122.274773
14334 585 Whipple Ave, Redwood City, CA 94063, USA 37.493672 -122.235248
14333 504 Whipple Ave, Redwood City, CA 94063, USA 37.494605 -122.234978
14332 1110 Marsh Rd, Menlo Park, CA 94025, USA 37.480745 -122.183578
22517 3405 Winchester Blvd, Campbell, CA 95008, USA 37.263428 -121.961180

In [232]:
# combine locations1,7,9 csv
locations_combined = pd.read_csv('data/locations_1.csv', header=0, index_col=0)
locations_combined = locations_combined.append(pd.read_csv('data/locations_7.csv', header=0, index_col=0))
locations_combined = locations_combined.append(pd.read_csv('data/locations_9.csv', header=0, index_col=0))
locations_combined = locations_combined.drop_duplicates()
locations_combined.info()


<class 'pandas.core.frame.DataFrame'>
Int64Index: 336 entries, 4030 to 23598
Data columns (total 3 columns):
address      336 non-null object
latitude     336 non-null float64
longitude    336 non-null float64
dtypes: float64(2), object(1)
memory usage: 10.5+ KB

In [233]:
locations_combined.head(5)


Out[233]:
address latitude longitude
station_id
4030 10002 N De Anza Blvd, Cupertino, CA 95014, USA 37.323388 -122.031775
10588 10023 S De Anza Blvd, Cupertino, CA 95014, USA 37.322547 -122.032735
24622 929 Fremont Ave, Los Altos Hills, CA 94024, USA 37.354072 -122.088676
21026 3401 Middlefield Rd, Menlo Park, CA 94025, USA 37.470637 -122.201853
2550 790 W Middlefield Rd, Mountain View, CA 94043,... 37.402403 -122.074635

In [234]:
# missing stations
missing_2 = list(set(stations.index) - set(locations_combined.index))
print(missing_2)
for station_id in missing_2:
    print("{0},\"{1}\"".format(station_id, stations.loc[station_id].address))


[]
24627,"25 Washington St Santa Clara, CA 95050-6130"
24620,"5920 Travel Park Circle Gilroy, CA 95020-8032"
23598,"300 E Hillsdale Blvd San Mateo, CA 94403-2821"

In [231]:
missing_3 = [(24627, "25 Washington St Santa Clara, CA 95050-6130"),
             (24620, "5920 Travel Park Circle Gilroy, CA 95020-8032"),
             (23598, "300 E Hillsdale Blvd San Mateo, CA 94403-2821")]

for station_id, address in missing_3:
    loc = geolocator.geocode(address)
    print("{0},\"{1}\",{2},{3}".format(station_id, loc.address, loc.latitude, loc.longitude))


24627,"25 Washington St, Santa Clara, CA 95050, USA",37.3383115,-121.9377117
24620,"5920 Travel Park Cir, Gilroy, CA 95020, USA",36.9847743,-121.5559988
23598,"300 E Hillsdale Blvd, San Mateo, CA 94403, USA",37.5414265,-122.2902084

In [240]:
# combine locations_combined with stations
# (station_id, address, latitude, longitude) from locations_combined
# (station_id, locations, name, phone) from stations
stations_combined = locations_combined.join(stations, rsuffix="_old")
stations_combined = stations_combined[['location','name','address','latitude','longitude','phone']]
stations_combined.head(5)


Out[240]:
location name address latitude longitude phone
station_id
4030 Cupertino Valero 10002 N De Anza Blvd, Cupertino, CA 95014, USA 37.323388 -122.031775 408-996-1222
10588 Cupertino Chevron 10023 S De Anza Blvd, Cupertino, CA 95014, USA 37.322547 -122.032735 408-996-9906
24622 Los Altos Shell 929 Fremont Ave, Los Altos Hills, CA 94024, USA 37.354072 -122.088676 650-949-3746
21026 Menlo Park Quik Stop 3401 Middlefield Rd, Menlo Park, CA 94025, USA 37.470637 -122.201853 650-365-5783
2550 Mountain View ARCO 790 W Middlefield Rd, Mountain View, CA 94043,... 37.402403 -122.074635 (650) 934-2630

In [248]:
stations_combined.info()


<class 'pandas.core.frame.DataFrame'>
Int64Index: 336 entries, 4030 to 23598
Data columns (total 6 columns):
location     336 non-null object
name         336 non-null object
address      336 non-null object
latitude     336 non-null float64
longitude    336 non-null float64
phone        328 non-null object
dtypes: float64(2), object(4)
memory usage: 28.4+ KB

In [253]:
# export to csv
stations_combined.to_csv('data/stations_combined.csv')

In [ ]: