Mobile_Food_Facility_Permit

Data source: data.sfgov.org

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

✎ 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
11 11 654244 Tacos Esmeralda 9 Truck 1 5337000 EVANS AVE: RANKIN ST to SELBY ST (1800 - 1890) 1800 EVANS AVE 5228001 5228 11 001 15MFF-0130 REQUESTED 1 Burritos: tacos: quesadillas: and tortas 6014520.892000001 2099538.537 37.7457492406203 -122.392481487678 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0130&ExportPDF=1&Filename=15MFF-0130_schedule.pdf Th/Fr/Sa:7AM-4PM     2015-05-12 0   (37.7457492406203, -122.392481487678)
54 54 848185 Reecees Soulicious 24 Truck 1 211101 03RD ST: NEWCOMB AVE to OAKDALE AVE (4701 - 4799) -- EAST -- 4705 03RD ST 5311036 5311 47 036 16MFF-0139 REQUESTED 1 Fried Chicken: Fried Fish: Greens: Mac & Cheese: Peach Cobbler: and String beans 6015109.357999999 2095613.38 37.7350042289514 -122.39017246969999 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0139&ExportPDF=1&Filename=16MFF-0139_schedule.pdf Th/Fr/Sa:7AM-7PM     2016-09-08 0 03/15/2017 12:00:00 AM (37.7350042289514, -122.3901724697)
628 628 949474 Subs on Hubs 121 Truck 1 412000 08TH ST: FOLSOM ST to RINGOLD ST (300 - 341) 333 08TH ST 3755056 3755 121 056 17MFF-0160 APPROVED 5 Italian subs: Cuban sandwich: Gyro 6009851.369 2110277.469 37.7749754998217 -122.40938582319401 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0160&ExportPDF=1&Filename=17MFF-0160_schedule.pdf Th/Fr:12AM-2AM;We/Th:11PM-12AM   08/21/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7749754998217, -122.409385823194)
6 6 526148 Cheese Gone Wild 6 Truck 1 11544000 SANSOME ST: PINE ST to CALIFORNIA ST (200 - 299) 233 SANSOME ST 0260002 0260 6 002 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6012313.995 2116649.543 37.792609401119 -122.40131490545099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Th:10AM-2PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.792609401119, -122.401314905451)
50 50 526146 Cheese Gone Wild 6 Truck 1 13160101 VAN NESS AVE: CLAY ST to WASHINGTON ST (1801 - 1899) -- WEST -- 1801 VAN NESS AVE 0618002 0618 43 002 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6006008.931 2116666.941 37.79230338307529 -122.423131922094 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Th:6AM-10AM;Mo/Sa:6AM-8PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.7923033830753, -122.423131922094)
25 25 665242 The Whole Cart 8 Truck 1 10627000 POST ST: GRANT AVE to STOCKTON ST (200 - 299) 225 POST ST 0309027 0309 24 027 15MFF-0015 REQUESTED 1 Multiple Trucks 6011043.045 2115156.951 37.788440109524004 -122.405607286668 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0015&ExportPDF=1&Filename=15MFF-0015_schedule.pdf Tu/Fr/Sa:5PM-9PM     2015-02-25 0   (37.788440109524, -122.405607286668)
181 181 934406 Hiyaaa 48 Truck 1 2753000 BATTERY ST: PINE ST to CALIFORNIA ST (100 - 199) 111 BATTERY ST 0261005 0261 37 005 17MFF-0080 APPROVED 5 Korean Fried Chicken 6012649.223999999 2116554.374 37.7923667868831 -122.40014830676701 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0080&ExportPDF=1&Filename=17MFF-0080_schedule.pdf Tu/Fr:9AM-3PM   02/21/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7923667868831, -122.400148306767)
96 96 654163 Maiwand Halal Kabob Truck 39 Truck 1 3529000 CALIFORNIA ST: LEIDESDORFF ST to MONTGOMERY ST (449 - 499) 450 CALIFORNIA ST 0239026 0239 81 026 15MFF-0009 EXPIRED 2 Mantu: Balani: Guabili pillow: lamb shank 6012031.306 2116940.665 37.793392977019 -122.40231350368201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0009&ExportPDF=1&Filename=15MFF-0009_schedule.pdf Tu/Th/Fr:10AM-2PM   05/20/2016 12:00:00 AM 2015-02-24 0 03/15/2017 12:00:00 AM (37.793392977019, -122.402313503682)
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)
16 16 634197 Smokin Warehouse Barbecue 13 Truck 1 2767000 BATTERY ST: UNION ST to FILBERT ST (1100 - 1199) 1155 BATTERY ST 0107 007 0107 15 007 15MFF-0105 REQUESTED 1 BBQ Sandwiches: BBQ lunch platters: sides (corn bread: beans: chili: potato salad: coleslaw): water: sodas: energy drinks: housemade iced tea. 6012094.775 2119998.079 37.8017914435056 -122.402308963297 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0105&ExportPDF=1&Filename=15MFF-0105_schedule.pdf Tu/Th/Fr:11AM-2PM     2015-03-24 0 03/15/2016 12:00:00 AM (37.8017914435056, -122.402308963297)
42 42 617520 Bomba 20 Truck 1 3527000 CALIFORNIA ST: BATTERY ST to SANSOME ST (300 - 399) 345 CALIFORNIA ST 0261017 0261 37 017 15MFF-0003 REQUESTED 1 Sandwiches 6012567.025 2116641.83 37.7926023367923 -122.40043886495 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0003&ExportPDF=1&Filename=15MFF-0003_schedule.pdf Tu/Th/Fr:11AM-3PM     2015-02-05 0   (37.7926023367923, -122.40043886495)
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)
399 399 947730 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 10624001 POST ST: MONTGOMERY ST to LICK PL (1 - 40) 1 POST ST 0311015 0311 284 015 17MFF-0151 APPROVED 5 Rotisserie chicken: pork loin: ribs: chicken salad wrap: potatoes: roasted seasonal vegetables kale salad: beverages. 6011921.732000001 2115262.393 37.788778723378 -122.40257456841101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0151&ExportPDF=1&Filename=17MFF-0151_schedule.pdf Tu/Th/Fr:6PM-8PM   03/13/2017 12:00:00 AM 2017-03-13 0 03/15/2018 12:00:00 AM (37.788778723378, -122.402574568411)
180 180 844601 Plaza Garibaldy 18 Truck 1 3529000 CALIFORNIA ST: LEIDESDORFF ST to MONTGOMERY ST (449 - 499) 475 CALIFORNIA ST 0260010 0260 6 010 15MFF-0132 APPROVED 5 Tacos: burritos: quesadillas 6012002.812000001 2116560.078 37.792346385148 -122.402385322794 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0132&ExportPDF=1&Filename=15MFF-0132_schedule.pdf Tu/Th/Sa:10AM-3PM   02/01/2017 12:00:00 AM 2015-06-11 0 03/15/2018 12:00:00 AM (37.792346385148, -122.402385322794)
159 159 934547 Kara's Cupcakes 43 Truck 1 7832201 KING ST: 02ND ST to 03RD ST (100 - 198) -- NORTH -- 118 KING ST 3794010 3794 133 010 17MFF-0103 REQUESTED 1 Cupcakes 6015306.857000001 2111936.992 37.779836332883704 -122.390629949741 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/Sa:3PM-4PM;Mo/Tu/We/Th/Fr:5PM-6PM     2017-02-13 0 03/24/2018 12:00:00 AM (37.7798363328837, -122.390629949741)
487 487 934541 Think is Good Inc. 92 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 400 CALIFORNIA ST 0238003 0238 34 003 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Tu/Th:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (0, 0)
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)
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)
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)
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)
663 663 963319 Serendipity SF 129 Truck 1 10456000 PINE ST: SANSOME ST to CENTURY PL (300 - 340) 332 PINE ST 0260006 0260 6 006 17MFF-0181 REQUESTED 1 Meatloaf: Grilled Cheese: Chicken Sandwich: Caprese Salad: Kale Salad: Fries: Sweet Potato Fries: Mac and Cheese: Mashed Potatoes 6012259.225 2116546.642 37.792323803535105 -122.401497177566 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0181&ExportPDF=1&Filename=17MFF-0181_schedule.pdf Tu/Th:11AM-3PM     2017-04-14 0 04/30/2018 12:00:00 AM (37.7923238035351, -122.401497177566)
345 345 934391 Expresso Subito, LLC. 65 Truck 1 3525000 CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199) 150 CALIFORNIA ST 0236019 0236 118 019 17MFF-0075 APPROVED 5 Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. 6013145.602999999 2117020.1569999997 37.7936733815047 -122.398463509486 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0075&ExportPDF=1&Filename=17MFF-0075_schedule.pdf Tu/Th:6AM-8PM   03/10/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7936733815047, -122.398463509486)
442 442 934519 Scotch Bonnet 80 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 430 CALIFORNIA ST 0239029 0239 81 029 17MFF-0094 APPROVED 5 Jerk chicken: curry chicken: curry goat: curry dhal: Burritos: Fish: Ox tails: rice: beans: veggies. 6012181.836 2116889.9790000003 37.7932622069231 -122.40178909136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0094&ExportPDF=1&Filename=17MFF-0094_schedule.pdf Tu/Th:6AM-8PM   03/16/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7932622069231, -122.401789091363)
219 219 944367 Off the Grid Services, LLC 28 Truck 1 3075000 BRANNAN ST: STANFORD ST to JACK LONDON ALY (324 - 353) 340 BRANNAN ST 3775015 3775 68 015 17MFF-0131 APPROVED 5 Everything 6014566.387 2112472.164 37.781264686022794 -122.39322904153799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0131&ExportPDF=1&Filename=17MFF-0131_schedule.pdf Tu/Th:8AM-3PM   03/02/2017 12:00:00 AM 2017-03-02 0 03/15/2018 12:00:00 AM (37.7812646860228, -122.393229041538)
632 632 934554 Casey's Pizza, LLC 123 Truck 1 12045000 SPEAR ST: MISSION ST to HOWARD ST (100 - 199) 100 SPEAR ST 3717001 3717 387 001 17MFF-0104 APPROVED 5 Artisan Pizzas (Margherita: Yukon Potato: Zoe's Pepperoni: Funghi: Brocolli Rabe: Bacon Kale: Arugula) and Drinks. 6014423.85 2116439.642 37.7921505484817 -122.39399997405899 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0104&ExportPDF=1&Filename=17MFF-0104_schedule.pdf Tu/Th:9AM-3PM   08/29/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7921505484817, -122.393999974059)
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)
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)
3 3 531040 La Falafel 3 Truck 1 13057002 VALENCIA ST: ROSA PARKS LN to 15TH ST (338 - 399) 363 VALENCIA ST 3547033 3547 3 033 14MFF-0088 EXPIRED 2 Falafel Sandwiches: Fries: Soda: Iced Tea & Various Drinks. 6006210.45973 2107493.40775 37.767126464778 -122.421782736139 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0088&ExportPDF=1&Filename=14MFF-0088_schedule.pdf Tu/We/Th:11AM-4PM;Fr/Sa:4PM-11PM   03/31/2014 12:00:00 AM 2014-03-28 0 03/15/2015 12:00:00 AM (37.767126464778, -122.421782736139)
44 44 531039 La Falafel 3 Truck 1 13057001 VALENCIA ST: 14TH ST to ROSA PARKS LN (300 - 337) 337 VALENCIA ST 3547016 3547 3 016 14MFF-0088 EXPIRED 2 Falafel Sandwiches: Fries: Soda: Iced Tea & Various Drinks. 6006211.307999999 2107613.639 37.767456639106896 -122.42178834311599 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0088&ExportPDF=1&Filename=14MFF-0088_schedule.pdf Tu/We/Th:11AM-4PM;Fr/Sa:4PM-11PM   03/31/2014 12:00:00 AM 2014-03-28 0 03/15/2015 12:00:00 AM (37.7674566391069, -122.421788343116)
670 670 1010174 Julie's Hot Dogs 124 Truck 1 9121000 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) 2386 MISSION ST 3596119 3596 413 119 15MFF-0007 REQUESTED 1 Hot dogs: bacon-wrapped hot dogs: chicken burgers: energy drinks: water and various other drinks. 6006843.48 2104477.0730000003 37.7588799920148 -122.419379202984 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0007&ExportPDF=1&Filename=15MFF-0007_schedule.pdf Tu/We/Th:12AM-3AM;Mo-We:12PM-12AM     2015-02-23 0   (37.7588799920148, -122.419379202984)
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)
415 415 934402 Philz Coffee Truck 72 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 401 CALIFORNIA ST 0260001 0260 6 001 17MFF-0079 APPROVED 5 Hot coffee: iced coffee: hot chocolate: tea: pastries 6012304.2870000005 2116717.605 37.7927957415787 -122.40135328093099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0079&ExportPDF=1&Filename=17MFF-0079_schedule.pdf Tu/We/Th:6AM-3PM   03/14/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7927957415787, -122.401353280931)
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)
105 105 1036073 CARDONA'S FOOD TRUCK 42 Truck 1 9114000 MISSION ST: 14TH ST to 15TH ST (1800 - 1899) 1800 MISSION ST 3547001 3547 3 001 17MFF-0195 REQUESTED 1 Tacos: Burritos: Quesadillas: Various Drinks 6006564.549 2107737.695 37.7678171814141 -122.420575335142 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0195&ExportPDF=1&Filename=17MFF-0195_schedule.pdf Tu/We/Th:8AM-5PM     2017-10-26 0   (37.7678171814141, -122.420575335142)
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)
27 27 526147 Cheese Gone Wild 6 Truck 1 106000 01ST ST: NATOMA ST to HOWARD ST (165 - 199) 400 HOWARD ST 3720008 3720 26 008 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6013858.05956 2115347.09492 37.7891192076677 -122.39588103933501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Tu:10AM-3PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.7891192076677, -122.395881039335)
28 28 638845 Plaza Garibaldy 18 Truck 1 9546000 NEW MONTGOMERY ST: NATOMA ST to HOWARD ST (158 - 199) 180 NEW MONTGOMERY ST 3722022 3722 27 022 15MFF-0114 INACTIVE 3 Tacos: burritos: quesadillas 6012785.32 2114324.261 37.7862510074437 -122.399520766943 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0114&ExportPDF=1&Filename=15MFF-0114_schedule.pdf We/Th/Fr:11AM-3PM     2015-04-06 0   (37.7862510074437, -122.399520766943)
607 607 988642 Cochinita 113 Truck 1 5170000 ELLIS ST: POWELL ST to CYRIL MAGNIN ST (100 - 148) 120 ELLIS ST 0326005 0326 291 005 17MFF-0186 REQUESTED 1 Panushos: salbutes: salad: price: beans: cochinita: etc. 6010286.046 2114141.69 37.7856100863691 -122.408154764345 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0186&ExportPDF=1&Filename=17MFF-0186_schedule.pdf We/Th/Fr:11AM-5PM     2017-06-19 0   (37.7856100863691, -122.408154764345)
507 507 957191 Tres Agaves Mexican Kitchen & Tequila Lounge LLC. dba Tres Truck 98 Truck 1 711000 16TH ST: KANSAS ST to VERMONT ST (1700 - 1799) 1700 16TH ST 3935005 3935 342 005 17MFF-0175 APPROVED 5 Multiple Trucks - Everything 6011356.433999999 2107057.15 37.766217450679996 -122.403952784121 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0175&ExportPDF=1&Filename=17MFF-0175_schedule.pdf We/Th/Fr:8AM-3PM   03/30/2017 12:00:00 AM 2017-03-30 0 03/15/2018 12:00:00 AM (37.76621745068, -122.403952784121)
182 182 934405 Hiyaaa 48 Truck 1 8122000 LARKIN ST: FULTON ST to MCALLISTER ST (200 - 299) 200 LARKIN ST 0353001 0353 150 001 17MFF-0080 APPROVED 5 Korean Fried Chicken 6007971.743 2112224.278 37.7802154802881 -122.41602577015101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0080&ExportPDF=1&Filename=17MFF-0080_schedule.pdf We/Th:9AM-3PM   02/21/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7802154802881, -122.416025770151)
19 19 526150 Cheese Gone Wild 6 Truck 1 4609000 DAVIS ST: DAVIS CT \ JACKSON ST to BROADWAY (500 - 699)   0167010 0167 18 010 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6012974.89 2118691.505 37.7982529941715 -122.399171569524 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf We:6AM-3PM;Su:6AM-8PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.7982529941715, -122.399171569524)
440 440 934517 Scotch Bonnet 80 Truck 1 9297000 MONTGOMERY ST: POST ST to SUTTER ST (1 - 99) 25 MONTGOMERY ST 0292001A 0292 304 001A 17MFF-0094 APPROVED 5 Jerk chicken: curry chicken: curry goat: curry dhal: Burritos: Fish: Ox tails: rice: beans: veggies. 6011957.9229999995 2115519.499 37.789486696127796 -122.402467438004 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0094&ExportPDF=1&Filename=17MFF-0094_schedule.pdf We:6AM-8PM   03/16/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7894866961278, -122.402467438004)

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.105ms · Data source: data.sfgov.org