fixes

5 files changed, 213 insertions, 21 deletions

diff --git a/dashboard_website/__pycache__/router.cpython-312.pyc b/dashboard_website/__pycache__/router.cpython-312.pyc
index cf58209..75e433c 100644
--- a/dashboard_website/__pycache__/router.cpython-312.pyc
+++ b/dashboard_website/__pycache__/router.cpython-312.pyc
diff --git a/dashboard_website/clean.csv b/dashboard_website/clean.csv
new file mode 100644
index 0000000..97ec1e0
--- /dev/null
+++ b/dashboard_website/clean.csv
@@ -0,0 +1,83 @@
+name,latitude,longitude,info,status,required

+A1,42.35164841009778,-71.05025198312232,Big Milk in Seaport,UNVISITED,False

+A2,42.35204192420662,-71.04984502589399,Boston Children's Museum,UNVISITED,False

+A3,42.35365379192413,-71.04873344979373,The Barking Crab,UNVISITED,False

+A4,42.35232174594542,-71.06730451717179,Poe Statue,UNVISITED,False

+A5,42.337612650248815,-71.0110287056158,Castle Island,UNVISITED,False

+A6,42.34976169144601,-71.07862707165528,Boston Marathon Finish Line ,UNVISITED,False

+A7,42.336919155298816,-71.07614402442968,Mike's City Diner,UNVISITED,False

+A8,42.35116088481672,-71.04414268479222,Rainbow deer,UNVISITED,False

+A9,42.353452434822735,-71.07244985228881,Alexander Hamilton Statue,UNVISITED,False

+A11,42.344125784204856,-71.04533563876583,The Lawn on D,UNVISITED,False

+A12,42.3508130265764,-71.07851960278796,google store,UNVISITED,False

+A13,42.325623267831055,-71.06892860952799,Bully Boy Distillery,UNVISITED,False

+A14,42.34340157583897,-71.07234009588915,Metropolis,UNVISITED,False

+A15,42.34180009786747,-71.0805717059923,5 horse tavern,UNVISITED,False

+A16,42.34954540033214,-71.07032984692786,The Saunders Castle & The Tower,UNVISITED,False

+A17,42.34981542643222,-71.0447968583138,Puttshack Seaport,UNVISITED,False

+A18,42.33505556288115,-71.04614891514272,Fat Baby,UNVISITED,False

+A19,42.33534040115186,-71.04556560383472,broadway's best pizza,UNVISITED,False

+A20,42.3959093644735,-71.10313161148423,ink about it,UNVISITED,False

+A21,42.337764594371244,-71.04896454602633,Lithuanian Citizens Association,UNVISITED,False

+A22,42.35071062611583,-71.03841598663126,Yankee Specialty foods,UNVISITED,False

+A23,42.3420007997466,-71.0663661528146,More Amore European Nails,UNVISITED,False

+A24,42.35178477042305,-71.07680656136475,jonquils,UNVISITED,False

+Y1,42.34209907351223,-71.08605357137661,El Jefe's symphony,UNVISITED,True

+Y2,42.35233530545082,-71.06498903012464,El jefe's boston common,UNVISITED,True

+Y3,42.35175772313571,-71.11918644795296,El Jefe's BU,UNVISITED,True

+Y4,42.37325909920359,-71.1200804867238,El Jefe's Harvard,UNVISITED,True

+Y5,42.361045705234424,-71.0670310341877,anna's taqueria beacon hill,UNVISITED,True

+Y6,42.34620117887202,-71.12816716625889,anna's taqueria jfk corner,UNVISITED,True

+Y7,42.388410839642916,-71.11862758381616,anna's taqueria porter,UNVISITED,True

+Y8,42.39494456575347,-71.12177221694061,anna's taqueria davis square,UNVISITED,True

+Y9,42.32162076044001,-71.2072262219593,anna's taqueria newton highlands,UNVISITED,True

+Y10,42.3473611584311,-71.08166811261636,anna's taqueria prudential,UNVISITED,True

+Y11,42.33908135996997,-71.10775521333255,anna's taqueria longwood,UNVISITED,True

+Y12,42.341550647975176,-71.08760506136474,amelias huntington,UNVISITED,True

+Y13,42.33628405341191,-71.14997353127764,amelia's beacon st,UNVISITED,True

+Y14,42.34706010320681,-71.08802806603468,amelia's boylston,UNVISITED,True

+Z1,42.34903375871938,-71.0885534426824,Mass Ave & Commonwealth Street Signs,UNVISITED,True

+Z2,42.34425763310416,-71.07719993693308,Holyoke & Columbus Street Signs,UNVISITED,True

+Z3,42.35187835701779,-71.07822568209997,Commonwealth & Dartmouth Street Signs,UNVISITED,True

+Z4,42.3492167599952,-71.07693786072275,Huntington & Darthmouth Street Signs,UNVISITED,True

+Z5,42.34582858505308,-71.0752559933239,Dartmouth & Columbus Street Signs,UNVISITED,True

+Z6,42.35011117747043,-71.06997069478776,Columbus & Stuart Street Signs,UNVISITED,True

+Z7,42.35108844399635,-71.06493687188616,Stuart & Tremont Street Signs,UNVISITED,True

+Z8,42.357992844142515,-71.06046321307011,Tremont & Beacon Street Signs,UNVISITED,True

+Z9,42.35622361097954,-71.06928515354731,Charles & Beacon Street Signs,UNVISITED,True

+Z10,42.35946704098799,-71.07070385722237,Charles & Revere Street Signs,UNVISITED,True

+A10,42.34885878947485,-71.08242390221116,boylston apple store,UNVISITED,False

+B1,42.368183360744695,-71.07610300605397,Cambridgeside Galleria Mall 2nd floor,UNVISITED,False

+B2,42.33424504677968,-71.09092925387209,Boston police headquarters? Round parking area behind,UNVISITED,False

+B3,42.46340302384999,-71.05912287515028,LEGO Discovery Center Boston,UNVISITED,False

+B4,42.374617100935005,-71.05692632815223,USS Constitution,UNVISITED,False

+B5,42.38196814269399,-71.10615821413666,Aeronaut Brewing Company,UNVISITED,False

+B6,42.363677779619806,-71.10110891437893,Veggie Galaxy,UNVISITED,False

+B7,42.36428024460987,-71.10203801411599,Mad Monkfish,UNVISITED,False

+B8,42.364358582942515,-71.10214131757188,Cheapo Records,UNVISITED,False

+B10,42.373627428376636,-71.12127565396639,brattle theatre,UNVISITED,False

+B12,42.36419650353893,-71.10187254148086,Phoenix Landing,UNVISITED,False

+B13,42.365017438107074,-71.10338468469307,red fox escapes,UNVISITED,False

+B14,42.38658080043406,-71.1404746131931,Fresh Pond Gas,UNVISITED,False

+B15,42.372209502489895,-71.05478713303407,USS cassin young,UNVISITED,False

+B17,42.373058980453585,-71.08039446014534,Superior Nut company,UNVISITED,False

+B18,42.364468199816535,-71.05870214425711,City Winery Boston,UNVISITED,False

+B20,42.363766006622186,-71.10102120251692,Center Theater,UNVISITED,False

+B21,42.38175468614174,-71.12877811353438,Smithsonian Observatory,UNVISITED,False

+B22,42.376679059866596,-71.11593139151414,Collection of historical instruments,UNVISITED,False

+B23,42.36595717995103,-71.09282261588774,Boston Costume / Garment District,UNVISITED,False

+B24,42.37163188273628,-71.11738396227928,Harvard lampoon,UNVISITED,False

+B25,42.365802372268284,-71.10469028746091,Lucky's tattoo and piercing,UNVISITED,False

+B26,42.38435614989647,-71.07130792007565,Schrafft's,UNVISITED,False

+B27,42.38078811925308,-71.0720109460841,Hood Park,UNVISITED,False

+B28,42.395769088595095,-71.1208025328836,Five Horses Tavern (somerville),UNVISITED,False

+B29,42.37298573598354,-71.11968386845383,Life Alive Cafe,UNVISITED,False

+B30,42.36692126085477,-71.05616358906735,Skinny House,UNVISITED,False

+B31,42.3806341524021,-71.13187597973126,cash for your warhol (tiny plaque),UNVISITED,False

+B32,42.39988588356347,-71.11802036205874,Museum of the modern Renaissance,UNVISITED,False

+B34,42.41560951967007,-71.15257248179509,Whittemore Park Monument,UNVISITED,False

+B35,42.37613947126408,-71.03579919649276,Kelley Square Pub,UNVISITED,False

+B36,42.379795,-71.096687,"Gracie's Ice Cream (Union Square, Somerville)",UNVISITED,False

+B37,42.36554646872598,-71.10287876718864,Blick art materials,UNVISITED,False

+B39,42.3736,-71.098656,Bom Dough (Inman Square),UNVISITED,False

+B40,42.37377276050066,-71.10038678773157,1369 Coffee House,UNVISITED,False

diff --git a/dashboard_website/dirt.csv b/dashboard_website/dirt.csv
index 3f25af6..6a7797f 100644
--- a/dashboard_website/dirt.csv
+++ b/dashboard_website/dirt.csv
@@ -1,11 +1,43 @@
-Clue ID,Clue,Clue Name,"Coords (lat, long - right click on google maps and click coords to copy)",Required
-Z1,Mass Ave & Commonwealth Street Signs,Mass Ave & Commonwealth Street Signs,"42.34903375871938, -71.0885534426824",True
-Z2,Holyoke & Columbus Street Signs,Holyoke & Columbus Street Signs,"42.34425763310416, -71.07719993693308",True
-Z3,Commonwealth & Dartmouth Street Signs,Commonwealth & Dartmouth Street Signs,"42.35187835701779, -71.07822568209997",True
-Z4,Huntington & Darthmouth Street Signs,Huntington & Darthmouth Street Signs,"42.3492167599952, -71.07693786072275",True
-Z5,Dartmouth & Columbus Street Signs,Dartmouth & Columbus Street Signs,"42.34582858505308, -71.0752559933239",True
-Z6,Columbus & Stuart Street Signs,Columbus & Stuart Street Signs,"42.35011117747043, -71.06997069478776",True
-Z7,Stuart & Tremont Street Signs,Stuart & Tremont Street Signs,"42.35108844399635, -71.06493687188616",True
-Z8,Tremont & Beacon Street Signs,Tremont & Beacon Street Signs,"42.357992844142515, -71.06046321307011",True
-Z9,Charles & Beacon Street Signs,Charles & Beacon Street Signs,"42.35622361097954, -71.06928515354731",True
-Z10,Charles & Revere Street Signs,Charles & Revere Street Signs,"42.35946704098799, -71.07070385722237",True
+Clue ID,Clue,Name of place,"Coords (lat, long) (right click near place on google maps, then click the coordinates to copy)",Google Maps Link

+B1,Location of mars in the meseum of science community solar system,Cambridgeside Galleria Mall 2nd floor,"42.368183360744695, -71.07610300605397",https://maps.app.goo.gl/eVmprWs233mp5ubt5

+B2,A nice round place to park a police car,Boston police headquarters? Round parking area behind,"42.33424504677968, -71.09092925387209",

+B3,Where you can see a view of boston from space made of lego,LEGO Discovery Center Boston,"42.394875055962245, -71.07947217596747",https://maps.app.goo.gl/b4pGaQkKXkgQBmcL6

+B4,Boston frigate with freedom of speech,USS Constitution,"42.374617100935005, -71.05692632815223",https://maps.app.goo.gl/jnbdiM4eXDnkpPkj7

+B5,A brewing company fit for spacefarers,Aeronaut Brewing Company,"42.38196814269399, -71.10615821413666",

+B6,Milky way restaurant minus the milk,Veggie Galaxy,"42.363677779619806, -71.10110891437893",https://maps.app.goo.gl/cSfk3PEupBGYChvT6

+B7,I guess being turned into sushi doesn't make a happy fish,Mad Monkfish,"42.36428024460987, -71.10203801411599",

+B8,A GOOD PLACE TO SHOP FOR VINYLS IF YOU ARE PINCHING PENNINES [sic],Cheapo Records,"42.364358582942515, -71.10214131757188",

+B9,Stop in this store for a place to sleep before hiking mount greylock,,,

+B10,You can't brattle on and on while the show is happening,brattle theatre,"42.373627428376636, -71.12127565396639",

+B11,This structure sure knows how to hold a grudge!,,,

+B12,Sports bar where you'll be reborn,Phoenix Landing,"42.36419650353893, -71.10187254148086",

+B13,Who let the fox out??,red fox escapes,"42.365017438107074, -71.10338468469307",

+B14,I GUESS GASOLINE IS FRESH BUT I WOULD BE CONCERNED IF THERE WAS A WHOLE POND OF IT,Fresh Pond Gas,"42.38658080043406, -71.1404746131931",https://maps.app.goo.gl/42UZvghSZwGjznkM8

+B15,The world war 2 era neighbor of old ironsides,USS cassin young,"42.372209502489895, -71.05478713303407",

+B16,This roller skating performer and self proclaimed police officer was anything but a square ,,,

+B17,deez company aren't inferior,Superior Nut company,"42.373058980453585, -71.08039446014534",

+B18,The best place to eat food while listening to marshall crenshaw,City Winery Boston,"42.364468199816535, -71.05870214425711",

+B19,What a ten-billionare makes,,,

+B20,Plays and musicals that go right in the middle,Center Theater,"42.363766006622186, -71.10102120251692",https://maps.app.goo.gl/P9MDiKjVN8MdCquy8

+B21,THIS OBSERVATORY OFTEN GETS CONFUSED FOR A MUSEUM,Smithsonian Observatory,"42.38175468614174, -71.12877811353438",

+B22,"WHERE HARVARD KEEPS THEIR 
+HANDSOME GREGORIAN REFLECTING 
+TELESCOPE",Collection of historical instruments,"42.376679059866596, -71.11593139151414",

+B23,NEED A COSTUME? I KNOW A DISTRICT,Boston Costume / Garment District,"42.36595717995103, -71.09282261588774",

+B24,HARVARD'S ONLY CASTLE,Harvard lampoon,"42.37163188273628, -71.11738396227928",

+B25,YOULL GET INKED HERE IF THE STARS ALIGN IN YOUR FAVOR,Lucky's tattoo and piercing,"42.365802372268284, -71.10469028746091",

+B26,CANDY FACTORY TURNED OFFICE BUILDING,Schrafft's,"42.38435614989647, -71.07130792007565",

+B27,"WHERE THE HOOD, WHERE THE HOOD, WHERE THE HOOD AT? APPARENTLY THIS PARK",Hood Park,"42.38078811925308, -71.0720109460841",

+B28,NOT ONE HORSE NOT TWO HORSES NOT THREE HORSES NOT FOUR HORSES BUT,Five Horses Tavern (somerville),"42.395769088595095, -71.1208025328836",

+B29,HOPEFULLY THIS CAFE IS KEEPING HARVARD STUDENTS ALIVE OTHERWISE ITS NAME SURE IS MISLEADING,Life Alive Cafe,"42.37298573598354, -71.11968386845383",

+B30,THE HOUSE THAT SPITE BUILT - ATLAS OBSCURA,Skinny House,"42.36692126085477, -71.05616358906735",

+B31,SIX ONE SEVEN FIVE FIVE THREE ONE ONE ZERO THREE,cash for your warhol (tiny plaque),"42.3806341524021, -71.13187597973126",

+B32,LE MUSEE DE LA REBIRTH MODERNE,Museum of the modern Renaissance,"42.39988588356347, -71.11802036205874",

+B33,I WANT YOU TO IMMORTALIZE ME IN STONE,George Washington Statue in Boston Public Garden,,

+B34,"HE WAS SHOT, BAYONETED, BEATEN AND LEFT FOR DEAD BUT RECOVERED AND LIVED TO BE 98 YEARS OF AGE",Whittemore Park Monument,"42.41560951967007, -71.15257248179509",

+B35,DASH DOT DASH SPACE DOT SPACE DOT DASH DOT DOT SPACE DOT DASH DOT DOT SPACE DOT SPACE DASH DOT DASH DASH (Kelley),Kelley Square Pub,"42.37613947126408, -71.03579919649276",

+B36,800 HEARTS OF FURY ITS OK TO CRY IN THIS PLACE WITH A NICE COLD LOCALLY MADE PINT,"Gracie's Ice Cream (Union Square, Somerville)","42.379795, -71.096687",

+B37,Feeling crafty near central,Blick art materials,"42.36554646872598, -71.10287876718864",https://maps.app.goo.gl/rN8cXkFMbpvMFLS68

+B38,A club for yankees fish to get that bread,,,

+B39,DREAMING OF PAO DE QUEJO COFFEE AND COZY CAMBRIDGE CAFES,Bom Dough (Inman Square),"42.373600, -71.098656",

+B40,A year before timur named samarkand capital of the empire - grab a hot honey latte and watch it go down,1369 Coffee House,"42.37377276050066, -71.10038678773157",
\ No newline at end of file
diff --git a/dashboard_website/router.py b/dashboard_website/router.py
index b30dca7..122f767 100644
--- a/dashboard_website/router.py
+++ b/dashboard_website/router.py
@@ -129,7 +129,8 @@ def cluster_and_optimize(
     #        return -1, [], [], []
     #    routes[i] = resp
     clue_pool = []
-    routes = __balance_waypoints(routes, bikes, end, times, clue_pool, max_max_time, minimal)
+    routes_done = [False for bike in bikes if bike.status != "DISABLED"]
+    routes = __balance_waypoints(routes, bikes, end, times, clue_pool, routes_done, max_max_time, minimal)
     if routes == -1:
         return -1, [], [], []
     
@@ -285,7 +286,7 @@ def __minimize_route_time_diff(
     return routes, times
 
 def __balance_waypoints(
-    routes: [Clue], bikes: [Bike], end: Point, times, clue_pool: [Clue], max_time, minimal
+    routes: [Clue], bikes: [Bike], end: Point, times, clue_pool: [Clue], routes_done: [bool], max_time, minimal
 ):
     """
     Takes a list of coordinates, a start point, an end point, and a maximum time and returns a list of coordinates
@@ -303,8 +304,8 @@ def __balance_waypoints(
     time_balances = [ (max_times[i] - times[i]) for i in range(len(times))]
     print(time_balances)
     balanced = True
-    for balance in time_balances:
-        if balance < 0:
+    for i, balance in enumerate(time_balances):
+        if balance < 0 and (not routes_done[active_indices[i]]):
             balanced = False
             break
     if balanced:
@@ -312,12 +313,14 @@ def __balance_waypoints(
     # shorten too-long routes
     for i, time_balance in enumerate(time_balances):
         print(i, time_balance)
-        if time_balance < 0: # route too long
+        if time_balance < 0 and (not routes_done[active_indices[i]]): # route too long
             route_mean = __mean_center(routes[active_indices[i]])
-            farthest_coordinates = __find_farthest_coordinates(routes[active_indices[i]], route_mean, max(1,min(int(-1*time_balance/0.12),int(len(routes[active_indices[i]])*0.75))))
+            s, farthest_coordinates = __find_farthest_coordinates(routes[active_indices[i]], route_mean, max(1,min(int(-1*time_balance/0.12),int(len(routes[active_indices[i]])*0.5))))
             for farthest_coordinate in farthest_coordinates:
                 routes[active_indices[i]].remove(farthest_coordinate)
                 clue_pool.append(farthest_coordinate)
+            if s == -1:
+                routes_done[active_indices[i]] = True
     # lengthen routes with spare room
     for i, time_balance in enumerate(time_balances):
         if time_balance > 0.15: # route too short
@@ -337,7 +340,7 @@ def __balance_waypoints(
                                         __clues_to_string([end])[:-1],
                                     ) * bikes[i].time_modifier
         
-    return __balance_waypoints(routes, bikes, end, times, clue_pool, max_time, minimal)
+    return __balance_waypoints(routes, bikes, end, times, clue_pool, routes_done, max_time, minimal)
 
 
 
@@ -373,7 +376,7 @@ def __remove_longest_waypoints(
     if route_time > max_time:
         print(route_time)
         route_mean = __mean_center(route_coordinates)
-        farthest_coordinates = __find_farthest_coordinates(route_coordinates, route_mean)
+        _, farthest_coordinates = __find_farthest_coordinates(route_coordinates, route_mean)
         for farthest_coordinate in farthest_coordinates:
             route_coordinates.remove(farthest_coordinate)
 
@@ -473,13 +476,15 @@ def __find_farthest_coordinates(clues: [Clue], centroid: Point, n:int=1):
     :param centroid: the centroid
     :return: the clue in the list that is farthest from the centroid
     """
-    
+    print(len(clues),n)
     farthest_coordinates = []
     for _ in range(min(len(clues),n)):
         farthest_coordinate = clues[0]
         # remove only unrequired clues
         i = 1
         while farthest_coordinate.required or (farthest_coordinate in farthest_coordinates):
+            if i >= len(clues):
+                return -1, farthest_coordinates
             farthest_coordinate = clues[i]
             i += 1 
 
@@ -492,7 +497,7 @@ def __find_farthest_coordinates(clues: [Clue], centroid: Point, n:int=1):
         
         farthest_coordinates.append(farthest_coordinate)
 
-    return farthest_coordinates
+    return 0, farthest_coordinates
 
 
 def __mean_center(clues: [Clue]):
diff --git a/dashboard_website/savefile.csv b/dashboard_website/savefile.csv
index 5dbcd46..5a93132 100644
--- a/dashboard_website/savefile.csv
+++ b/dashboard_website/savefile.csv
@@ -9,3 +9,75 @@ Z7,42.35108844399635,-71.06493687188616,Stuart & Tremont Street Signs,UNVISITED,
 Z8,42.357992844142515,-71.06046321307011,Tremont & Beacon Street Signs,UNVISITED,True

 Z9,42.35622361097954,-71.06928515354731,Charles & Beacon Street Signs,UNVISITED,True

 Z10,42.35946704098799,-71.07070385722237,Charles & Revere Street Signs,UNVISITED,True

+Y1,42.34209907351223,-71.08605357137661,El Jefe's symphony,UNVISITED,True

+Y2,42.35233530545082,-71.06498903012464,El jefe's boston common,UNVISITED,True

+Y3,42.35175772313571,-71.11918644795296,El Jefe's BU,UNVISITED,True

+Y4,42.37325909920359,-71.1200804867238,El Jefe's Harvard,UNVISITED,True

+Y5,42.361045705234424,-71.0670310341877,anna's taqueria beacon hill,UNVISITED,True

+Y6,42.34620117887202,-71.12816716625889,anna's taqueria jfk corner,UNVISITED,True

+Y7,42.388410839642916,-71.11862758381616,anna's taqueria porter,UNVISITED,True

+Y8,42.39494456575347,-71.12177221694061,anna's taqueria davis square,UNVISITED,True

+Y9,42.32162076044001,-71.2072262219593,anna's taqueria newton highlands,UNVISITED,True

+Y10,42.3473611584311,-71.08166811261636,anna's taqueria prudential,UNVISITED,True

+Y11,42.33908135996997,-71.10775521333255,anna's taqueria longwood,UNVISITED,True

+Y12,42.341550647975176,-71.08760506136474,amelias huntington,UNVISITED,True

+Y13,42.33628405341191,-71.14997353127764,amelia's beacon st,UNVISITED,True

+Y14,42.34706010320681,-71.08802806603468,amelia's boylston,UNVISITED,True

+A1,42.35164841009778,-71.05025198312232,Big Milk in Seaport,UNVISITED,False

+A2,42.35204192420662,-71.04984502589399,Boston Children's Museum,UNVISITED,False

+A3,42.35365379192413,-71.04873344979373,The Barking Crab,UNVISITED,False

+A4,42.35232174594542,-71.06730451717179,Poe Statue,UNVISITED,False

+A5,42.337612650248815,-71.0110287056158,Castle Island,UNVISITED,False

+A6,42.34976169144601,-71.07862707165528,Boston Marathon Finish Line ,UNVISITED,False

+A7,42.336919155298816,-71.07614402442968,Mike's City Diner,UNVISITED,False

+A8,42.35116088481672,-71.04414268479222,Rainbow deer,UNVISITED,False

+A9,42.353452434822735,-71.07244985228881,Alexander Hamilton Statue,UNVISITED,False

+A10,42.34885878947485,-71.08242390221116,boylston apple store,UNVISITED,False

+A11,42.344125784204856,-71.04533563876583,The Lawn on D,UNVISITED,False

+A12,42.3508130265764,-71.07851960278796,google store,UNVISITED,False

+A13,42.325623267831055,-71.06892860952799,Bully Boy Distillery,UNVISITED,False

+A14,42.34340157583897,-71.07234009588915,Metropolis,UNVISITED,False

+A15,42.34180009786747,-71.0805717059923,5 horse tavern,UNVISITED,False

+A16,42.34954540033214,-71.07032984692786,The Saunders Castle & The Tower,UNVISITED,False

+A17,42.34981542643222,-71.0447968583138,Puttshack Seaport,UNVISITED,False

+A18,42.33505556288115,-71.04614891514272,Fat Baby,UNVISITED,False

+A19,42.33534040115186,-71.04556560383472,broadway's best pizza,UNVISITED,False

+A20,42.3959093644735,-71.10313161148423,ink about it,UNVISITED,False

+A21,42.337764594371244,-71.04896454602633,Lithuanian Citizens Association,UNVISITED,False

+A22,42.35071062611583,-71.03841598663126,Yankee Specialty foods,UNVISITED,False

+A23,42.3420007997466,-71.0663661528146,More Amore European Nails,UNVISITED,False

+A24,42.35178477042305,-71.07680656136475,jonquils,UNVISITED,False

+B1,42.368183360744695,-71.07610300605397,Cambridgeside Galleria Mall 2nd floor,UNVISITED,False

+B2,42.33424504677968,-71.09092925387209,Boston police headquarters? Round parking area behind,UNVISITED,False

+B3,42.394875055962245,-71.07947217596747,LEGO Discovery Center Boston,UNVISITED,False

+B4,42.374617100935005,-71.05692632815223,USS Constitution,UNVISITED,False

+B5,42.38196814269399,-71.10615821413666,Aeronaut Brewing Company,UNVISITED,False

+B6,42.363677779619806,-71.10110891437893,Veggie Galaxy,UNVISITED,False

+B7,42.36428024460987,-71.10203801411599,Mad Monkfish,UNVISITED,False

+B8,42.364358582942515,-71.10214131757188,Cheapo Records,UNVISITED,False

+B10,42.373627428376636,-71.12127565396639,brattle theatre,UNVISITED,False

+B12,42.36419650353893,-71.10187254148086,Phoenix Landing,UNVISITED,False

+B13,42.365017438107074,-71.10338468469307,red fox escapes,UNVISITED,False

+B14,42.38658080043406,-71.1404746131931,Fresh Pond Gas,UNVISITED,False

+B15,42.372209502489895,-71.05478713303407,USS cassin young,UNVISITED,False

+B17,42.373058980453585,-71.08039446014534,Superior Nut company,UNVISITED,False

+B18,42.364468199816535,-71.05870214425711,City Winery Boston,UNVISITED,False

+B20,42.363766006622186,-71.10102120251692,Center Theater,UNVISITED,False

+B21,42.38175468614174,-71.12877811353438,Smithsonian Observatory,UNVISITED,False

+B22,42.376679059866596,-71.11593139151414,Collection of historical instruments,UNVISITED,False

+B23,42.36595717995103,-71.09282261588774,Boston Costume / Garment District,UNVISITED,False

+B24,42.37163188273628,-71.11738396227928,Harvard lampoon,UNVISITED,False

+B25,42.365802372268284,-71.10469028746091,Lucky's tattoo and piercing,UNVISITED,False

+B26,42.38435614989647,-71.07130792007565,Schrafft's,UNVISITED,False

+B27,42.38078811925308,-71.0720109460841,Hood Park,UNVISITED,False

+B28,42.395769088595095,-71.1208025328836,Five Horses Tavern (somerville),UNVISITED,False

+B29,42.37298573598354,-71.11968386845383,Life Alive Cafe,UNVISITED,False

+B30,42.36692126085477,-71.05616358906735,Skinny House,UNVISITED,False

+B31,42.3806341524021,-71.13187597973126,cash for your warhol (tiny plaque),UNVISITED,False

+B32,42.39988588356347,-71.11802036205874,Museum of the modern Renaissance,UNVISITED,False

+B34,42.41560951967007,-71.15257248179509,Whittemore Park Monument,UNVISITED,False

+B35,42.37613947126408,-71.03579919649276,Kelley Square Pub,UNVISITED,False

+B36,42.379795,-71.096687,"Gracie's Ice Cream (Union Square, Somerville)",UNVISITED,False

+B37,42.36554646872598,-71.10287876718864,Blick art materials,UNVISITED,False

+B39,42.3736,-71.098656,Bom Dough (Inman Square),UNVISITED,False

+B40,42.37377276050066,-71.10038678773157,1369 Coffee House,UNVISITED,False