Mobile_Food_Facility_Permit

Data source: data.sfgov.org

142 rows where FacilityType = 1 and PriorPermit = 0 sorted by X descending

✎ 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
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)
417 417 934389 Senor Sisig 73 Truck 1 5170000 ELLIS ST: POWELL ST to CYRIL MAGNIN ST (100 - 148) 120 ELLIS ST 0326005 0326 291 005 17MFF-0074 APPROVED 5 Filipino fusion food: taco: burrito: nachos: rice plates 6010286.046 2114141.69 37.7856100863691 -122.408154764345 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0074&ExportPDF=1&Filename=17MFF-0074_schedule.pdf Sa-Su:11AM-6PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7856100863691, -122.408154764345)
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)
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)
482 482 934542 Think is Good Inc. 92 Truck 1 5169000 ELLIS ST: 04TH ST \ MARKET ST \ STOCKTON ST to POWELL ST (1 - 99) 34 ELLIS ST 0307008 0307 326 008 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito 6009885.084 2114861.905 37.787565165378794 -122.40959283347999 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Sa-Su:11AM-2PM/1PM-4PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7875651653788, -122.40959283348)
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)
604 604 934536 Rita's Catering 112 Truck 1 9100000 MISSION ST: 06TH ST to 07TH ST (1000 - 1099) 1028 MISSION ST 3703033 3703 392 033 17MFF-0096 APPROVED 5 Filipino Food 6009812.085 2112361.07 37.7806943774082 -122.409668813219 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0096&ExportPDF=1&Filename=17MFF-0096_schedule.pdf Mo/We/Fr:7AM-3PM   05/31/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7806943774082, -122.409668813219)
18 18 526090 Del Popolo, LLC. 15 Truck 1 8733000 MARIPOSA ST: BRYANT ST to FLORIDA ST (2700 - 2799) 2772 MARIPOSA ST 3970004 3970 17 004 14MFF-0030 EXPIRED 2 Wood Fired Pizzas 6009371.839 2106032.5 37.763292918729 -122.41074477293002 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0030&ExportPDF=1&Filename=14MFF-0030_schedule.pdf Sa-Su:8AM-11PM;Mo-Fr:5PM-11PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.763292918729, -122.41074477293)
654 654 1020424 Kabob Trolley, LLC 101 Truck 1 9101000 MISSION ST: 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) 1133 MISSION ST 3727096 3727 407 096 17MFF-0192 REQUESTED 1 Halal Gyro and Cheesesteaks 6009260.818 2111511.319 37.7783302557659 -122.411515865268 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0192&ExportPDF=1&Filename=17MFF-0192_schedule.pdf Mo/Tu/Fr:9AM-4PM     2017-09-19 0 03/15/2018 12:00:00 AM (37.7783302557659, -122.411515865268)
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)
653 653 498118 Mario's Colombian and Mexican Food 128 Truck 1 12033000 SOUTH VAN NESS AVE: 26TH ST to CESAR CHAVEZ ST (1500 - 1599) 1575 SOUTH VAN NESS AVE 6571027 6571 62 027 13MFF-0130 REQUESTED 1 Mexican: Tacos: quesadillas: burritos: tortas. Colombian: Chorizo con arepa: potatoes & sausage: empanadas: arepa rellana: potatoes & guacamole. 6007869.1110000005 2100671.835 37.748489384977496 -122.415562670854 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=13MFF-0130&ExportPDF=1&Filename=13MFF-0130_schedule.pdf Mo-We:10AM-8PM     2013-11-20 0   (37.7484893849775, -122.415562670854)
1 1 751253 Pipo's Grill 1 Truck 1 5688000 FOLSOM ST: 14TH ST to 15TH ST (1800 - 1899) 1800 FOLSOM ST 3549083 3549 1 083 16MFF-0010 REQUESTED 1 Tacos: Burritos: Hot Dogs: and Hamburgers 6007856.719 2107724.046 37.7678524427181 -122.416104892532 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0010&ExportPDF=1&Filename=16MFF-0010_schedule.pdf       2016-02-04 0   (37.7678524427181, -122.416104892532)
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)
48 48 631837 Del Popolo, LLC. 15 Truck 1 8754201 MARKET ST: 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- 1438 MARKET ST 0835002 0835 41 002 15MFF-0068 EXPIRED 2 Pizza & various drinks 6007245.87 2110789.475 37.776235018471205 -122.418435137885 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0068&ExportPDF=1&Filename=15MFF-0068_schedule.pdf Mo-We:8AM-3PM   03/13/2015 12:00:00 AM 2015-03-13 0 03/15/2016 12:00:00 AM (37.7762350184712, -122.418435137885)
30 30 634196 Smokin Warehouse Barbecue 13 Truck 1 24388000 SOUTH VAN NESS AVE: 12TH ST \ MISSION ST \ OTIS ST intersection 1655 MISSION ST 3514119 3514 29 119 15MFF-0105 REQUESTED 1 BBQ Sandwiches: BBQ lunch platters: sides (corn bread: beans: chili: potato salad: coleslaw): water: sodas: energy drinks: housemade iced tea. 6007105.13431 2109091.10143 37.7715637663341 -122.41880150543899 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0105&ExportPDF=1&Filename=15MFF-0105_schedule.pdf Mo/We:11AM-4PM     2015-03-24 0 03/15/2016 12:00:00 AM (37.7715637663341, -122.418801505439)
667 667 1039596 Julie's Hot Dogs 124 Truck 1 9121000 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) 2365 MISSION ST 3595024 3595 156 024 17MFF-0190 APPROVED 5 Hot dogs: Bacon wrapped hot dogs: soda: water: sports drinks: energy drinks: chips 6007087.512999999 2104603.286 37.759240285150206 -122.418544171117 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0190&ExportPDF=1&Filename=17MFF-0190_schedule.pdf     08/28/2017 12:00:00 AM 2017-08-24 0 03/15/2018 12:00:00 AM (37.7592402851502, -122.418544171117)
639 639 1010510 Julie's Hot Dogs 124 Truck 1 9122002 MISSION ST: CATHERINE CT to 21ST ST (2430 - 2499) 2445 MISSION ST 3610026 3610 401 026 17MFF-0190 APPROVED 5 Hot dogs: Bacon wrapped hot dogs: soda: water: sports drinks: energy drinks: chips 6007052.821 2104129.899 37.757938520741895 -122.418630583281 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0190&ExportPDF=1&Filename=17MFF-0190_schedule.pdf Su/Fr/Sa:12AM-3AM;Th/Fr/Sa:10PM-12AM   08/28/2017 12:00:00 AM 2017-08-24 0 03/15/2018 12:00:00 AM (37.7579385207419, -122.418630583281)
55 55 795865 Doc's of the Bay 25 Truck 1 9124000 MISSION ST: 22ND ST to 23RD ST (2600 - 2699) 2600 MISSION ST 3636001 3636 48 001 16MFF-0102 REQUESTED 1 Burgers: French Fries: Black Bean Burgers: Mac and Cheese: drinks 6006899.272000001 2103162.0409999997 37.7552723597518 -122.419092971602 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0102&ExportPDF=1&Filename=16MFF-0102_schedule.pdf Su:12AM-2AM;Sa:6PM-12AM     2016-05-02 0 03/15/2017 12:00:00 AM (37.7552723597518, -122.419092971602)
286 286 946047 The Huge Hotdog Concession 60 Truck 1 10567000 POLK ST: BUSH ST to AUSTIN ST \ FRANK NORRIS ST (1300 - 1329) 1300 POLK ST 0668004A 0668 221 004A 17MFF-0139 APPROVED 5 Hotdogs: chips: soda: nuts: crackers 6006861.832 2115401.583 37.7888771172666 -122.420091020038 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0139&ExportPDF=1&Filename=17MFF-0139_schedule.pdf Su/Fr/Sa:8PM-2AM   03/09/2017 12:00:00 AM 2017-03-09 0 03/15/2018 12:00:00 AM (37.7888771172666, -122.420091020038)
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)
106 106 1036076 CARDONA'S FOOD TRUCK 42 Truck 1 9114000 MISSION ST: 14TH ST to 15TH ST (1800 - 1899) 1888 MISSION ST 3547003 3547 3 003 17MFF-0195 REQUESTED 1 Tacos: Burritos: Quesadillas: Various Drinks 6006630.753 2107401.4280000003 37.766897602559204 -122.42032247306801 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0195&ExportPDF=1&Filename=17MFF-0195_schedule.pdf Su/Fr/Sa:8AM-5PM     2017-10-26 0   (37.7668976025592, -122.420322473068)
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)
56 56 795864 Doc's of the Bay 25 Truck 1 731000 16TH ST: CALEDONIA ST to VALENCIA ST (3072 - 3099) 3092 16TH ST 3554016 3554 49 016 16MFF-0102 REQUESTED 1 Burgers: French Fries: Black Bean Burgers: Mac and Cheese: drinks 6006249.865 2106782.214 37.765175917067204 -122.421595922098 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0102&ExportPDF=1&Filename=16MFF-0102_schedule.pdf Su:6PM-12AM     2016-05-02 0 03/15/2017 12:00:00 AM (37.7651759170672, -122.421595922098)
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)
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)
475 475 953153 Alfaro Truck 88 Truck 1 13057001 VALENCIA ST: 14TH ST to ROSA PARKS LN (300 - 337) 306 VALENCIA ST 3546001 3546 322 001 17MFF-0167 APPROVED 5 Burritos: Tacos: Tortas: Quesadillas & Various Drinks. 6006013.135 2107762.89 37.76785526935429 -122.422484404162 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0167&ExportPDF=1&Filename=17MFF-0167_schedule.pdf Th/Fr/Sa:2PM-10PM   03/21/2017 12:00:00 AM 2017-03-21 0 03/15/2018 12:00:00 AM (37.7678552693543, -122.422484404162)
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)
636 636 934551 Casey's Pizza, LLC 123 Truck 1 5442000 FELL ST: GOUGH ST to OCTAVIA ST (300 - 399) 368 FELL ST 0817032 0817 367 032 17MFF-0104 APPROVED 5 Artisan Pizzas (Margherita: Yukon Potato: Zoe's Pepperoni: Funghi: Brocolli Rabe: Bacon Kale: Arugula) and Drinks. 6005654.042 2110754.304 37.776048708092205 -122.42393921117201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0104&ExportPDF=1&Filename=17MFF-0104_schedule.pdf Su:12PM-8PM;Fr:3PM-8PM;Sa:4PM-8PM   08/29/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7760487080922, -122.423939211172)
424 424 934403 Philz Coffee Truck 72 Truck 1 8701000 MARINA BLVD: LAGUNA ST to BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST (1 - 99) 15 MARINA BLVD 0446002 0446 294 002 17MFF-0079 APPROVED 5 Hot coffee: iced coffee: hot chocolate: tea: pastries 6003247.31181 2121194.21345 37.804577869090096 -122.43301077434299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0079&ExportPDF=1&Filename=17MFF-0079_schedule.pdf Sa-Su:6AM-8PM   03/14/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.8045778690901, -122.433010774343)
603 603 959666 Giant Burrito 111 Truck 1 6148201 GENEVA AVE: PRAGUE ST to LINDA VISTA STPS (1500 - 1598) -- SOUTH -- 1500 GENEVA AVE 6418065 6418 391 065 17MFF-0178 APPROVED 5 Tacos: Burritos: Tostadas: Flautas: Tostadas: Tortas: Pozole Menudo 6002948.585 2087593.93 37.712302604744394 -122.431644190373 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0178&ExportPDF=1&Filename=17MFF-0178_schedule.pdf Su:7AM-6PM   05/26/2017 12:00:00 AM 2017-04-07 0 03/15/2018 12:00:00 AM (37.7123026047444, -122.431644190373)
68 68 916847 Los 2 Cuates 32 Truck 1 4801101 DIVISADERO ST: OAK ST to FELL ST (401 - 499) -- WEST -- 401 DIVISADERO ST 1215016 1215 57 016 16MFF-0137 REQUESTED 1 south American-Peruvian food: hot wok dishes: hot pastas: rice dishes. 6001606.909 2109860.071 37.773364053190896 -122.437875225303 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0137&ExportPDF=1&Filename=16MFF-0137_schedule.pdf Su/Fr/Sa:7AM-8PM     2016-08-12 0 08/12/2016 12:00:00 AM (37.7733640531909, -122.437875225303)
469 469 767078 BHUK Burger 86 Truck 1 10390000 PHELAN AVE: GENEVA AVE \ OCEAN AVE to JUDSON AVE (1 - 199) 11 PHELAN AVE 3180001 3180 320 001 16MFF-0076 EXPIRED 2 Pakistani Indian food: and salad: cold and hot drinks: Pakistani soft drinks: Sohan halva: Pakistani Indian desserts: and fruit dessert 5996539.936000001 2092561.48 37.7255769923986 -122.454152837668 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0076&ExportPDF=1&Filename=16MFF-0076_schedule.pdf Mo/Tu/We/Th/Fr:7AM-8PM   03/18/2016 12:00:00 AM 2016-03-18 0 03/15/2017 12:00:00 AM (37.7255769923986, -122.454152837668)
70 70 931094 Swell Cream & Coffee 33 Truck 1 12410000 TARAVAL ST: 34TH AVE to 35TH AVE (2400 - 2499) 2450 TARAVAL ST 2363022 2363 59 022 17MFF-0002 REQUESTED 1 Ice cream: coffee: pastries 5985532.259 2098975.331 37.742550373559205 -122.49267708221501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0002&ExportPDF=1&Filename=17MFF-0002_schedule.pdf       2017-01-30 0 01/30/2018 12:00:00 AM (37.7425503735592, -122.492677082215)
92 92 931093 Swell Cream & Coffee 33 Truck 1 12412000 TARAVAL ST: 36TH AVE to SUNSET BLVD (2600 - 2649) 2401 36TH AVE 2389001 2389 77 001 17MFF-0002 REQUESTED 1 Ice cream: coffee: pastries 5985030.8 2098527.088 37.741290284770706 -122.49437792043501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0002&ExportPDF=1&Filename=17MFF-0002_schedule.pdf       2017-01-30 0 01/30/2018 12:00:00 AM (37.7412902847707, -122.494377920435)
60 60 654049 Betty McGee Creole 27 Truck 1 19983000 04TH ST: MISSION ROCK ST to CHINA BASIN ST (1200 - 1299) 1201 04TH ST 8711028 8711 52 028 15MFF-0129 EXPIRED 2 Cajun: PoBoy Sandwiches: Salmon: Shrimp: Catfish: Oysters: Sausages: Gumbo: Fries: Salad: Pies: Cookies: Cake: Chips: Beignets: Waffles: Beverages     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0129&ExportPDF=1&Filename=15MFF-0129_schedule.pdf Mo-Su:8AM-4PM   05/11/2015 12:00:00 AM 2015-05-11 0 03/15/2016 12:00:00 AM (0, 0)
61 61 617523 Bomba 20 Truck 1 11544000 SANSOME ST: PINE ST to CALIFORNIA ST (200 - 299) 220 SANSOME ST 2617617 2617 53 617 15MFF-0004 REQUESTED 1 Sandwiches     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0004&ExportPDF=1&Filename=15MFF-0004_schedule.pdf Mo/We/Fr:11AM-3PM     2015-02-05 0   (0, 0)
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)
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)
495 495 944574 Senor Sisig 73 Truck 1 10456000 PINE ST: SANSOME ST to CENTURY PL (300 - 340) 300 PINE ST 0260005 0260 6 005 17MFF-0134 APPROVED 5 Filipino fusion food: tacos: burritos: nachos: rice plates. Various beverages.     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0134&ExportPDF=1&Filename=17MFF-0134_schedule.pdf Mo-Fr:11AM-2PM   03/24/2017 12:00:00 AM 2017-03-03 0 03/15/2018 12:00:00 AM (0, 0)
593 593 934408 Sanguchon 108 Truck 1 8722000 MARIPOSA ST: ARKANSAS ST to CAROLINA ST (1500 - 1699) 1601 MARIPOSA ST 4006005 4006 388 005 17MFF-0082 APPROVED 5 Peruvian Food     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0082&ExportPDF=1&Filename=17MFF-0082_schedule.pdf Sa:11AM-4PM   05/01/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (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)

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