Mobile_Food_Facility_Permit

Data source: data.sfgov.org

142 rows where FacilityType = 1 and PriorPermit = 0 sorted by Address

✎ View and edit SQL

This data as json, CSV (advanced)

PriorPermit ✖

Link rowid locationid Applicant FacilityType cnn LocationDescription Address ▼ blocklot block lot permit Status FoodItems X Y Latitude Longitude Schedule dayshours NOISent Approved Received PriorPermit ExpirationDate Location
471 471 654165 Maiwand Halal Kabob Truck 39 Truck 1 4605000 DAVIS ST: BEALE ST \ MARKET ST \ PINE ST to CALIFORNIA ST (1 - 99) 48 DAVIS ST 0264004 0264 30 004 15MFF-0009 EXPIRED 2 Mantu: Balani: Guabili pillow: lamb shank 6013552.57 2116844.5 37.7932137316634 -122.397043036718 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0009&ExportPDF=1&Filename=15MFF-0009_schedule.pdf Mo/We/Fr:10AM-2PM   05/20/2016 12:00:00 AM 2015-02-24 0 03/15/2017 12:00:00 AM (37.7932137316634, -122.397043036718)
69 69 916855 Los 2 Cuates 32 Truck 1 141000 02ND ST: STILLMAN ST to BRYANT ST (454 - 499) 490 02ND ST 3763007 3763 58 007 16MFF-0137 REQUESTED 1 south American-Peruvian food: hot wok dishes: hot pastas: rice dishes. 6014337.512 2113125.58 37.783046099749996 -122.39406659923 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0137&ExportPDF=1&Filename=16MFF-0137_schedule.pdf Tu/We/Th:7AM-8PM     2016-08-12 0 08/12/2016 12:00:00 AM (37.78304609975, -122.39406659923)
441 441 934516 Scotch Bonnet 80 Truck 1 101000 01ST ST: STEVENSON ST to END (21 - 56) 50 01ST ST 3708055 3708 4 055 17MFF-0094 APPROVED 5 Jerk chicken: curry chicken: curry goat: curry dhal: Burritos: Fish: Ox tails: rice: beans: veggies. 6013063.33 2115738.2830000003 37.7901490737255 -122.398658184604 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0094&ExportPDF=1&Filename=17MFF-0094_schedule.pdf Mo:6AM-8PM   03/16/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7901490737255, -122.398658184604)
621 621 1001319 Bonito Poke 104 Truck 1 107000 01ST ST: HOWARD ST to TEHAMA ST (200 - 231) 505 HOWARD ST 3736183 3736 10 183 16MFF-0141 REQUESTED 1 Bonito Poke Bowls & Various Drinks 6013786.26714 2114936.80369 37.787988648995295 -122.396100668472 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0141&ExportPDF=1&Filename=16MFF-0141_schedule.pdf Tu/We/Fr:10AM-2PM     2016-11-28 0   (37.7879886489953, -122.396100668472)
434 434 948419 La Jefa 77 Truck 1 2801102 BAY SHORE BLVD: WATERLOO ST to MARENGO ST (501 - 559) -- EAST -- 531 BAY SHORE BLVD 5607038 5607 301 038 17MFF-0157 APPROVED 5 Tacos: burritos: quesadillas: tortas: nachos (refried beans: cheese sauce: salsa fresca): carnes (beef: chicken: marinated pork: fried pork): canned beans: rice: sodas: horchata drinks. 6010348.157000001 2097065.717 37.738726803987106 -122.40673602990499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0157&ExportPDF=1&Filename=17MFF-0157_schedule.pdf Mo-Su:7AM-8PM   03/14/2017 12:00:00 AM 2017-03-14 0 03/15/2018 12:00:00 AM (37.7387268039871, -122.406736029905)
125 125 934550 Kara's Cupcakes 43 Truck 1 9089000 MISSION ST: ECKER ST to SHAW ALY (521 - 548) 531 MISSION ST 3721 122 3721 104 122 17MFF-0103 REQUESTED 1 Cupcakes 6013212.407880001 2115266.03711 37.7888607015573 -122.398109238807 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0103&ExportPDF=1&Filename=17MFF-0103_schedule.pdf Tu/Th:11AM-12PM;Mo/We/Fr:1PM-2PM     2017-02-13 0 03/24/2018 12:00:00 AM (37.7888607015573, -122.398109238807)
220 220 944365 SF Cart Project 55 Truck 1 15019101 MISSION BAY BLVD SOUTH: 03RD ST \ MISSION BAY BLVD to 04TH ST \ MISSION BAY BLVD (501 - 599) 535 MISSION BAY BLVD SOUTH 8711007 8711 52 007 17MFF-0130 APPROVED 5 7 Multiple Trucks on rotation (1 on Mission Bay Blvd South & 6 on 4th St). Serving everything but hot dogs 6014983.883280001 2108042.28534 37.769124412168104 -122.391474911246 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0130&ExportPDF=1&Filename=17MFF-0130_schedule.pdf Mo-Fr:10AM-3PM   03/02/2017 12:00:00 AM 2017-03-02 0 03/15/2018 12:00:00 AM (37.7691244121681, -122.391474911246)
57 57 795863 Doc's of the Bay 25 Truck 1 13408000 WASHINGTON ST: SANSOME ST to HOTALING PL (500 - 549) 535 WASHINGTON ST 0207 033 0207 50 033 16MFF-0102 REQUESTED 1 Burgers: French Fries: Black Bean Burgers: Mac and Cheese: drinks 6012074.046 2117582.92 37.7951588416202 -122.402210795235 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0102&ExportPDF=1&Filename=16MFF-0102_schedule.pdf Tu/We/Th:6AM-2PM     2016-05-02 0 03/15/2017 12:00:00 AM (37.7951588416202, -122.402210795235)
486 486 934540 Think is Good Inc. 92 Truck 1 9089000 MISSION ST: ECKER ST to SHAW ALY (521 - 548) 536 MISSION ST 3708098 3708 4 098 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito 6012988.85269 2115411.9566599997 37.789248908413704 -122.39889295934601 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Mo/We/Fr:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7892489084137, -122.398892959346)
655 655 1024769 Plaza Garibaldy 18 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 540 HOWARD ST 3721015 3721 104 015 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6013457.851 2114931.191 37.7879549596858 -122.397236543731 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo-We:3PM-8PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7879549596858, -122.397236543731)
43 43 747679 The Brooklyn Pig Inc. 21 Truck 1 3283000 BRYANT ST: RITCH ST to ZOE ST (515 - 544) 544 BRYANT ST 3762018 3762 38 018 16MFF-0009 REQUESTED 1 Hamburgers: French fries: fried chicken and waffles: sandwiches: omelets and sodas 6013468.451 2112291.173 37.7807066695518 -122.39701469241501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0009&ExportPDF=1&Filename=16MFF-0009_schedule.pdf Th/Fr/Sa:11AM-12AM     2016-01-25 0   (37.7807066695518, -122.397014692415)
295 295 946120 Tacos El Ojo De Agua 62 Truck 1 177000 03RD ST: SOUTH PARK to VARNEY PL (548 - 586) 551 03RD ST 3775025 3775 68 025 17MFF-0141 APPROVED 5 Tacos: Burritos: Tortas: Quesadillas: Salads: Soup: Fruits: Juices: Soda: Water 6014157.282000001 2112255.562 37.7806472100484 -122.39462918166201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0141&ExportPDF=1&Filename=17MFF-0141_schedule.pdf Mo-Fr:9AM-4PM   03/09/2017 12:00:00 AM 2017-03-09 0 03/15/2018 12:00:00 AM (37.7806472100484, -122.394629181662)
10 10 526149 Cheese Gone Wild 6 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 555 HOWARD ST 3736086 3736 10 086 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6013558.062999999 2114719.339 37.787378841809996 -122.39687496716299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Fr:3PM-8PM;Th:4PM-8PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.78737884181, -122.396874967163)
430 430 934401 Philz Coffee Truck 72 Truck 1 12323000 SUTTER ST: POWELL ST to MASON ST (500 - 599) 556 SUTTER ST 0284009 0284 299 009 17MFF-0079 APPROVED 5 Hot coffee: iced coffee: hot chocolate: tea: pastries 6009899.062000001 2115524.5640000002 37.7893854510391 -122.409591260467 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0079&ExportPDF=1&Filename=17MFF-0079_schedule.pdf Th/Fr/Sa:6AM-4PM   03/14/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7893854510391, -122.409591260467)
493 493 934331 Lobsta Truck 94 Truck 1 9090000 MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) 560 MISSION ST 3708095 3708 4 095 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012851.27 2115274.827 37.788864715342996 -122.39935935136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_schedule.pdf Tu/Th:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.788864715343, -122.399359351363)
71 71 526308 Wexler, LLC 34 Truck 1 4313000 COMMERCIAL ST: LEIDESDORFF ST to MONTGOMERY ST (543 - 599) 565 COMMERCIAL ST 0228010 0228 60 010 14MFF-0052 EXPIRED 2 Traditional BBQ: Chicken: Ribs: Sandwiches: Sausages 6012004.848999999 2117204.765 37.7941166557094 -122.40242362612 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0052&ExportPDF=1&Filename=14MFF-0052_schedule.pdf Mo-Fr:9AM-4PM     2014-03-13 0 03/15/2015 12:00:00 AM (37.7941166557094, -122.40242362612)
500 500 932024 Slider Shack, LLC. 96 Truck 1 12044000 SPEAR ST: MARKET ST to MISSION ST (1 - 99) 60 SPEAR ST 3712023 3712 335 023 17MFF-0009 APPROVED 5 Sliders: Tater Tots: Beverages 6014255.311000001 2116583.43 37.7925359884311 -122.394593199235 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0009&ExportPDF=1&Filename=17MFF-0009_schedule.pdf Tu/We:10AM-3PM   04/04/2017 12:00:00 AM 2017-02-03 0 03/15/2018 12:00:00 AM (37.7925359884311, -122.394593199235)
33 33 526091 Del Popolo, LLC. 15 Truck 1 5872000 FRONT ST: JACKSON ST to PACIFIC AVE (600 - 699) 600 FRONT ST 0172010 0172 31 010 14MFF-0030 EXPIRED 2 Wood Fired Pizzas 6013015.315 2118400.114 37.7974551567824 -122.399011222821 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0030&ExportPDF=1&Filename=14MFF-0030_schedule.pdf Mo-Fr:8AM-4PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.7974551567824, -122.399011222821)
652 652 975273 Akuranvyka USA Inc 127 Truck 1 179000 03RD ST: BRANNAN ST to TOWNSEND ST (600 - 699) 601 03RD ST 3788020 3788 188 020 17MFF-0185 REQUESTED 1 Indian Street Food: Tikka Masala Burritos; Samosas; Sexy Fries (Indian-inspired poutine); Naughty Naans; Deconstructed Samosas; Kathi Rolls; Lassis and Lemonades 6014402.116 2112043.001 37.7800771744392 -122.393767294483 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0185&ExportPDF=1&Filename=17MFF-0185_schedule.pdf Tu/Th/Fr:12PM-1PM     2017-05-10 0 05/15/2018 12:00:00 AM (37.7800771744392, -122.393767294483)
504 504 957119 Think is Good Inc. 92 Truck 1 147000 02ND ST: BRANNAN ST to TOWNSEND ST (600 - 699) 625 02ND ST 3789007 3789 339 007 17MFF-0174 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito 6015195.7020000005 2112613.963 37.7816889753451 -122.39106181728701 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0174&ExportPDF=1&Filename=17MFF-0174_schedule.pdf Mo-Fr:12PM-5PM   03/31/2017 12:00:00 AM 2017-03-30 0 03/15/2018 12:00:00 AM (37.7816889753451, -122.391061817287)
637 637 934552 Casey's Pizza, LLC 123 Truck 1 9093000 MISSION ST: NEW MONTGOMERY ST to ANNIE ST (635 - 664) 654 MISSION ST 3707019 3707 22 019 17MFF-0104 APPROVED 5 Artisan Pizzas (Margherita: Yukon Potato: Zoe's Pepperoni: Funghi: Brocolli Rabe: Bacon Kale: Arugula) and Drinks. 6012296.995 2114673.5519999997 37.7871828477154 -122.401234808851 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0104&ExportPDF=1&Filename=17MFF-0104_schedule.pdf Fr:11AM-3PM   08/29/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7871828477154, -122.401234808851)
8 8 655894 Mora Taco Truck 7 Truck 1 8714000 MARIPOSA ST: TENNESSEE ST to 04TH ST \ MINNESOTA ST (600 - 699) 660 MARIPOSA ST 8724001 8724 8 001 15MFF-0006 REQUESTED 1 Tacos: quesadillas: burritos: tortas: tostadas 6015345.115 2106863.759 37.7659084792055 -122.390143076585 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0006&ExportPDF=1&Filename=15MFF-0006_schedule.pdf Mo-We:9AM-3PM     2015-02-13 0   (37.7659084792055, -122.390143076585)
58 58 812018 Spice Affairs 26 Truck 1 9094000 MISSION ST: ANNIE ST to 03RD ST (663 - 699) 667 MISSION ST 3722067 3722 27 067 16MFF-0126 REQUESTED 1 Chicken Tikka Masala: Vegetarian Rice Plate: Burritos: Tacos: Mango Lassi 6012350.571 2114444.914 37.7865580501799 -122.40103337535 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0126&ExportPDF=1&Filename=16MFF-0126_schedule.pdf       2016-05-31 0   (37.7865580501799, -122.40103337535)
221 221 944366 Off the Grid Services, LLC 28 Truck 1 307000 05TH ST: BLUXOME ST to TOWNSEND ST (650 - 699) 670 05TH ST 3785002 3785 183 002 17MFF-0131 APPROVED 5 Everything 6013152.64 2110433.77 37.775589079959396 -122.39797690638001 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0131&ExportPDF=1&Filename=17MFF-0131_schedule.pdf Mo/We/Fr:8AM-3PM   03/02/2017 12:00:00 AM 2017-03-02 0 03/15/2018 12:00:00 AM (37.7755890799594, -122.39797690638)
651 651 1009768 Akuranvyka USA Inc 127 Truck 1 11553000 SANSOME ST: GOLD ST to PACIFIC AVE (705 - 799) 727 SANSOME ST 0175003 0175 406 003 17MFF-0185 REQUESTED 1 Indian Street Food: Tikka Masala Burritos; Samosas; Sexy Fries (Indian-inspired poutine); Naughty Naans; Deconstructed Samosas; Kathi Rolls; Lassis and Lemonades 6012095.199 2118234.464 37.7969490060212 -122.402183431894 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0185&ExportPDF=1&Filename=17MFF-0185_schedule.pdf Mo/Tu/Th:12PM-1PM     2017-05-10 0 05/15/2018 12:00:00 AM (37.7969490060212, -122.402183431894)
431 431 934400 Philz Coffee Truck 72 Truck 1 9306000 MONTGOMERY ST: COLUMBUS AVE \ WASHINGTON ST to JACKSON ST (700 - 799) 735 MONTGOMERY ST 0195001 0195 300 001 17MFF-0079 APPROVED 5 Hot coffee: iced coffee: hot chocolate: tea: pastries 6011635.905 2117976.662 37.7962154965941 -122.403754558245 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0079&ExportPDF=1&Filename=17MFF-0079_schedule.pdf Mo-We:6AM-6PM   03/14/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7962154965941, -122.403754558245)
616 616 840504 Taqueria Lolita 118 Truck 1 5336000 EVANS AVE: QUINT ST to RANKIN ST (1700 - 1799) 750 PHELPS ST 5280001 5280 394 001 16MFF-0128 SUSPEND 4 Tacos: burritos: quesadillas: combination plates: tortas: tostadas 6014320.244 2097246.796 37.7394454528691 -122.39301498669799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0128&ExportPDF=1&Filename=16MFF-0128_schedule.pdf Mo-We:7AM-3PM   08/01/2017 12:00:00 AM 2016-06-22 0 03/15/2018 12:00:00 AM (37.7394454528691, -122.393014986698)
608 608 944539 Senor Sisig 73 Truck 1 480000 10TH ST: FELL ST \ MARKET ST \ POLK ST to END (1 - 18) 8 10TH ST 3507041 3507 202 041 17MFF-0133 APPROVED 5 Senor Sisig: Filipino fusion food: tacos: burritos: nachos: rice plates. Various beverages.Chairman Bao: Vegetable and meat sandwiches filled with Asian-flavored meats and vegetables. 6007585.376 2110633.378 37.77582551975829 -122.41724962664301 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0133&ExportPDF=1&Filename=17MFF-0133_schedule.pdf Mo/We/Fr:11AM-2PM   06/26/2017 12:00:00 AM 2017-03-03 0 03/15/2018 12:00:00 AM (37.7758255197583, -122.417249626643)
288 288 945982 El Calamar Perubian Food Truck 61 Truck 1 9091000 MISSION ST: ANTHONY ST to 02ND ST (573 - 599) 85 02ND ST 3708019 3708 4 019 17MFF-0138 APPROVED 5 Lomo Saltado: Jalea: Ceviche: Calamar: Tilapia plate: chicken special. Soda: Water. 6012696.635 2115129.488 37.788457028828894 -122.399884160566 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0138&ExportPDF=1&Filename=17MFF-0138_schedule.pdf Tu/We/Th:10AM-3PM   03/09/2017 12:00:00 AM 2017-03-09 0 03/15/2018 12:00:00 AM (37.7884570288289, -122.399884160566)
347 347 934392 Expresso Subito, LLC. 65 Truck 1 9091000 MISSION ST: ANTHONY ST to 02ND ST (573 - 599) 85 02ND ST 3708019 3708 4 019 17MFF-0075 APPROVED 5 Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. 6012696.635 2115129.488 37.788457028828894 -122.399884160566 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0075&ExportPDF=1&Filename=17MFF-0075_schedule.pdf     03/10/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7884570288289, -122.399884160566)
174 174 934366 Off the Grid Services, LLC 28 Truck 1 3143000 BROADWAY: DAVIS ST to FRONT ST (50 - 99) 90 BROADWAY 0140007 0140 146 007 17MFF-0069 APPROVED 5 everything except for hot dogs 6012853.387 2119060.762 37.7992601135023 -122.39961794865499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0069&ExportPDF=1&Filename=17MFF-0069_schedule.pdf Fr:10AM-3PM   03/02/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7992601135023, -122.399617948655)
218 218 934368 Off the Grid Services, LLC 28 Truck 1 3143000 BROADWAY: DAVIS ST to FRONT ST (50 - 99) 90 BROADWAY 0140007 0140 146 007 17MFF-0070 APPROVED 5 everything except for hot dogs 6012853.387 2119060.762 37.7992601135023 -122.39961794865499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0070&ExportPDF=1&Filename=17MFF-0070_schedule.pdf Mo/We/Fr:10AM-3PM   03/02/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7992601135023, -122.399617948655)
404 404 934329 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 5874000 FRONT ST: BROADWAY to VALLEJO ST (800 - 899) 90 BROADWAY 0140007 0140 146 007 17MFF-0065 APPROVED 5 Rotisserie Chicken: Ribs: Kickass Salad: Potatos w/fat dripping: chicken wrap. 6012853.387 2119060.762 37.7992601135023 -122.39961794865499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0065&ExportPDF=1&Filename=17MFF-0065_schedule.pdf Mo/We/Fr:10AM-2PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7992601135023, -122.399617948655)
609 609 956602 Senor Sisig 73 Truck 1 3143000 BROADWAY: DAVIS ST to FRONT ST (50 - 99) 90 BROADWAY 0140007 0140 146 007 17MFF-0133 APPROVED 5 Senor Sisig: Filipino fusion food: tacos: burritos: nachos: rice plates. Various beverages.Chairman Bao: Vegetable and meat sandwiches filled with Asian-flavored meats and vegetables. 6012853.387 2119060.762 37.7992601135023 -122.39961794865499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0133&ExportPDF=1&Filename=17MFF-0133_schedule.pdf Tu/Th:10AM-3PM   06/26/2017 12:00:00 AM 2017-03-03 0 03/15/2018 12:00:00 AM (37.7992601135023, -122.399617948655)
498 498 957711 Buenafe 95 Truck 1 701001 16TH ST: 07TH ST \ MISSISSIPPI ST to DAGGETT ST (900 - 959) 901 16TH ST 3949001 3949 334 001 17MFF-0176 APPROVED 5 Tacos burritos quesadillas tortas pupusas flautas tamales 6013806.356000001 2106973.63 37.766124694427 -122.39547306227 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0176&ExportPDF=1&Filename=17MFF-0176_schedule.pdf Mo-We:8AM-5PM   03/31/2017 12:00:00 AM 2017-03-31 0 03/15/2018 12:00:00 AM (37.766124694427, -122.39547306227)
646 646 955731 Senor Sisig 73 Truck 1 9097000 MISSION ST: 05TH ST to MINT ST (900 - 930) 901 MISSION ST 3725093 3725 312 093 16MFF-0143 APPROVED 5 Senor Sisig: Filipino fusion food: tacos: burritos: nachos: rice plates. Various beverages. 6010709.29 2112874.234 37.7821536409986 -122.406601106839 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0143&ExportPDF=1&Filename=16MFF-0143_schedule.pdf Tu/Th:10AM-3PM 09/15/2017 12:00:00 AM 08/04/2017 12:00:00 AM 2016-12-02 0 03/15/2018 12:00:00 AM (37.7821536409986, -122.406601106839)
491 491 955616 Tacos Santo Toribio 93 Truck 1 12628000 TOLAND ST: NEWCOMB AVE to OAKDALE AVE (900 - 999) 928 TOLAND ST 5597A001 5597A 331 001 17MFF-0171 REQUESTED 1 tacos 6011869.691000001 2098089.7830000003 37.7416236862353 -122.401547206397 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0171&ExportPDF=1&Filename=17MFF-0171_schedule.pdf       2017-03-23 0   (37.7416236862353, -122.401547206397)
626 626 949471 Subs on Hubs 121 Truck 1 3089000 BRANNAN ST: 08TH ST to 09TH ST (900 - 999) 934 BRANNAN ST 3781008 3781 399 008 17MFF-0160 APPROVED 5 Italian subs: Cuban sandwich: Gyro 6010635.811000001 2108878.801 37.7711790005481 -122.406573673429 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0160&ExportPDF=1&Filename=17MFF-0160_schedule.pdf Mo/Tu/We/Th:11AM-6PM   08/21/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7711790005481, -122.406573673429)
63 63 627558 Off the Grid Services, LLC 28 Truck 1 4609000 DAVIS ST: DAVIS CT \ JACKSON ST to BROADWAY (500 - 699) Assessors Block /Lot       15MFF-0039 REQUESTED 1 varies truck to truck     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0039&ExportPDF=1&Filename=15MFF-0039_schedule.pdf Tu/Th/Fr:10AM-3PM     2015-03-06 0   (0, 0)
614 614 997504 Munch India 41 Truck 1 10624001 POST ST: MONTGOMERY ST to LICK PL (1 - 40) Assessors Block /Lot       17MFF-0187 REQUESTED 1 Daily rotating menus consisting of various local & organic vegetable: poultry: meat: seafood : rice & bread dishes.     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0187&ExportPDF=1&Filename=17MFF-0187_schedule.pdf       2017-07-19 0 07/19/2017 12:00:00 AM (0, 0)
672 672 593927 SAS Group LLC 131 Truck 1 0   Assessors Block /Lot       14MFF-0105 REQUESTED 1 All Food Items     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0105&ExportPDF=1&Filename=14MFF-0105_schedule.pdf       2014-06-16 0 03/15/2015 12:00:00 AM (0, 0)
625 625 949473 Subs on Hubs 121 Truck 1 0   Assessors Block 8711/Lot021 8711021 8711 52 021 17MFF-0160 APPROVED 5 Italian subs: Cuban sandwich: Gyro 6014914.89374 2108873.14738 37.77140194658789 -122.391771646847 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0160&ExportPDF=1&Filename=17MFF-0160_schedule.pdf Sa-Su:11AM-10PM;Mo-Fr:6PM-8PM   08/21/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7714019465879, -122.391771646847)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Mobile_Food_Facility_Permit" (
"locationid" INTEGER,
  "Applicant" INTEGER,
  "FacilityType" INTEGER,
  "cnn" INTEGER,
  "LocationDescription" TEXT,
  "Address" TEXT,
  "blocklot" TEXT,
  "block" INTEGER,
  "lot" TEXT,
  "permit" TEXT,
  "Status" INTEGER,
  "FoodItems" TEXT,
  "X" REAL,
  "Y" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Schedule" TEXT,
  "dayshours" REAL,
  "NOISent" REAL,
  "Approved" REAL,
  "Received" TEXT,
  "PriorPermit" INTEGER,
  "ExpirationDate" REAL,
  "Location" TEXT
,
FOREIGN KEY ("Applicant") REFERENCES [Applicant](id),
    FOREIGN KEY ("FacilityType") REFERENCES [FacilityType](id),
    FOREIGN KEY ("Status") REFERENCES [Status](id),
    FOREIGN KEY ("block") REFERENCES [block](id));
CREATE INDEX ["Mobile_Food_Facility_Permit_Applicant"] ON [Mobile_Food_Facility_Permit]("Applicant");
CREATE INDEX ["Mobile_Food_Facility_Permit_FacilityType"] ON [Mobile_Food_Facility_Permit]("FacilityType");
CREATE INDEX ["Mobile_Food_Facility_Permit_Status"] ON [Mobile_Food_Facility_Permit]("Status");
CREATE INDEX ["Mobile_Food_Facility_Permit_block"] ON [Mobile_Food_Facility_Permit]("block");
Powered by Datasette · Query took 14.538ms · Data source: data.sfgov.org