Mobile_Food_Facility_Permit

Data source: data.sfgov.org

64 rows where FacilityType = 2 sorted by blocklot

✎ View and edit SQL

This data as json, CSV (advanced)

FacilityType ✖

  • Push Cart · 39 ✖
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
594 594 934556 The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 Push Cart 2 24892000 STOCKTON ST: 04TH ST \ ELLIS ST \ MARKET ST intersection 800 MARKET ST 0329001 0329 286 001 17MFF-0105 APPROVED 5 Soft pretzels: hot dogs: sausages: chips: popcorn: sodea: coffee: espresso: cappucino: pastries: ice cream: Italian sausages: shish-ka-bob: churros: juice: water: various drinks. 6010729.654 2114081.536 37.785469746489895 -122.406615761073 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0105&ExportPDF=1&Filename=17MFF-0105_schedule.pdf Mo-Su:6AM-9PM   05/05/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7854697464899, -122.406615761073)
402 402 934393 Creme Brulee To Go 71 Push Cart 2 8747202 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- 870 MARKET ST 0329005 0329 286 005 17MFF-0076 APPROVED 5 Kettle Corn: Pizza: Coffee: Lattes: Cappuchino: Expresso: Hot Tea 6010493.859 2113955.6580000003 37.7851109204478 -122.407422668277 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0076&ExportPDF=1&Filename=17MFF-0076_schedule.pdf Mo-Fr:8AM-7PM;Sa-Su:11AM-7PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7851109204478, -122.407422668277)
595 595 934557 The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 Push Cart 2 8747202 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- 870 MARKET ST 0329005 0329 286 005 17MFF-0106 APPROVED 5 Soft pretzels: hot dogs: sausages: chips: popcorn: soda: espresso: cappucino: pastry: ica cream: ices: italian sausage: shish-ka-bob: churros: juice: water: various drinks 6010493.859 2113955.6580000003 37.7851109204478 -122.407422668277 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0106&ExportPDF=1&Filename=17MFF-0106_schedule.pdf Mo-Su:6AM-9PM   05/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7851109204478, -122.407422668277)
14 14 639666 Afghani Rice 11 Push Cart 2 5057000 EDDY ST: POWELL ST to CYRIL MAGNIN ST (1 - 49) 1 POWELL ST 0330027 0330 13 027 15MFF-0115 REQUESTED 1 Rice - Chicken & Beef: sauce: cold drinks: hot drinks 6010285.677019999 2113807.83084 37.784693367825795 -122.40813248678002 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0115&ExportPDF=1&Filename=15MFF-0115_schedule.pdf Th/Fr/Sa:11AM-3PM     2015-04-07 0 03/15/2016 12:00:00 AM (37.7846933678258, -122.40813248678)
439 439 934302 Yummy Hot Dogs 79 Push Cart 2 8749201 MARKET ST: MASON ST \ TURK ST to 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST (950 - 998) -- NORTH -- 954 MARKET ST 0342001 0342 303 001 17MFF-0063 APPROVED 5 Hot dogs: pretzels: chips: juices and cold drinks 6009859.555 2113263.691 37.7831754207336 -122.409568315547 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0063&ExportPDF=1&Filename=17MFF-0063_schedule.pdf Tu/Th/Sa:10AM-7PM   03/15/2017 12:00:00 AM 2017-02-11 0 03/15/2018 12:00:00 AM (37.7831754207336, -122.409568315547)
620 620 1007163 Bay Area Dots, LLC 119 Push Cart 2 2846000 BEACH ST: HYDE ST to LARKIN ST (700 - 799) 900 BEACH ST 0405007 0405 396 007 17MFF-0189 APPROVED 5 Hot dogs: condiments: soft pretzels: soft drinks: coffee:cold beverages: pastries: bakery goods: cookies: icecream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. 6005830.4143900005 2122293.82162 37.8077432884455 -122.42414994487 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0189&ExportPDF=1&Filename=17MFF-0189_schedule.pdf Mo-Su:6AM-12AM   08/14/2017 12:00:00 AM 2017-08-09 1 03/15/2018 12:00:00 AM (37.8077432884455, -122.42414994487)
177 177 719119 HALAL SF GYRO 46 Push Cart 2 8753201 MARKET ST: 09TH ST \ LARKIN ST to 10TH ST \ FELL ST \ POLK ST (1300 - 1398) -- NORTH -- 1390 MARKET ST 0813007 0813 148 007 15MFF-0138 APPROVED 5 Gyro Sandwich: Chicken Sandwich: Lamb over rice: chicken over rice: fish sandwich & fish over rice 6007563.51849 2111143.00298 37.7772235984329 -122.417361361253 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0138&ExportPDF=1&Filename=15MFF-0138_schedule.pdf Mo-We:6AM-4PM   02/10/2017 12:00:00 AM 2015-07-31 0 03/15/2018 12:00:00 AM (37.7772235984329, -122.417361361253)
547 547 961020 Let's Be Frank 102 Push Cart 2 6816000 HAYES ST: GOUGH ST to OCTAVIA ST (400 - 499) 425 HAYES ST 0817025 0817 367 025 17MFF-0180 REQUESTED 1 Hot dogs and chili 6005815.063999999 2110939.7169999997 37.7765668965195 -122.42339537672702 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf Su/We:11AM-5PM     2017-04-12 0 03/15/2018 12:00:00 AM (37.7765668965195, -122.423395376727)
548 548 961021 Let's Be Frank 102 Push Cart 2 8393001 LINDEN ST: GOUGH ST to OCTAVIA ST (300 - 399) 404 OCTAVIA ST 0817033 0817 367 033 17MFF-0180 REQUESTED 1 Hot dogs and chili 6005585.672 2110752.1969999997 37.776039062665895 -122.424175571492 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf Fr:11AM-5PM     2017-04-12 0 03/15/2018 12:00:00 AM (37.7760390626659, -122.424175571492)
588 588 965705 Mission Dogs 107 Push Cart 2 3790000 CASTRO ST: 17TH ST \ MARKET ST to 18TH ST (400 - 499) 498 CASTRO ST 2647033 2647 386 033 17MFF-0183 REQUESTED 1 Hotdogs: chili: chips: drinks 6002252.878 2105381.5609999998 37.761103875721105 -122.435320318835 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0183&ExportPDF=1&Filename=17MFF-0183_schedule.pdf       2017-04-24 0   (37.7611038757211, -122.435320318835)
51 51 773095 Athena SF Gyro 23 Push Cart 2 30747000 MARKET ST: 11TH ST intersection 10 SOUTH VAN NESS AVE 3506004 3506 44 004 15MFF-0145 REQUESTED 1 Gyro pita bread (Lamb or chicken): lamb over rice: chicken over rice: chicken biryani rice: soft drinks 6006927.466 2110076.4390000002 37.774259263059996 -122.419485988398 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0145&ExportPDF=1&Filename=15MFF-0145_schedule.pdf We/Th/Fr:6AM-6PM     2015-09-01 0   (37.77425926306, -122.419485988398)
178 178 719121 HALAL SF GYRO 46 Push Cart 2 8753101 MARKET ST: 09TH ST \ LARKIN ST to 10TH ST \ FELL ST \ POLK ST (1301 - 1399) -- SOUTH -- 1301 MARKET ST 3508001 3508 149 001 15MFF-0138 APPROVED 5 Gyro Sandwich: Chicken Sandwich: Lamb over rice: chicken over rice: fish sandwich & fish over rice 6007839.137 2110959.852 37.7767362127501 -122.416394930077 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0138&ExportPDF=1&Filename=15MFF-0138_schedule.pdf Th/Fr/Sa:6AM-4PM   02/10/2017 12:00:00 AM 2015-07-31 0 03/15/2018 12:00:00 AM (37.7767362127501, -122.416394930077)
464 464 934431 The Chai Cart 17 Push Cart 2 13060000 VALENCIA ST: 16TH ST to 17TH ST (500 - 599) 560 VALENCIA ST 3568009 3568 317 009 17MFF-0086 APPROVED 5 Hot Indian Chai 6006099.355 2106305.353 37.7638580813603 -122.42208262099301 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf Sa-Su:9AM-4PM   03/17/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7638580813603, -122.422082620993)
45 45 558549 Raspados El Yocateco 22 Push Cart 2 9117000 MISSION ST: 17TH ST to CLARION ALY (2100 - 2131) 2100 MISSION ST 3576001 3576 39 001 14MFF-0101 REQUESTED 1 Shaved Ice: Tamarind: Strawberry: Lemon: horchata: hibiscus 6006755.774 2106062.3680000002 37.763227902543896 -122.419795019128 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0101&ExportPDF=1&Filename=14MFF-0101_schedule.pdf Su/Tu/Th:12PM-6PM     2014-05-22 0   (37.7632279025439, -122.419795019128)
188 188 934356 Leo's Hot Dogs 50 Push Cart 2 9121000 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) 2301 MISSION ST 3595031 3595 156 031 17MFF-0067 APPROVED 5 Hot dogs and related toppings: non alcoholic beverages 6007018.02 2104913.057 37.760086931987 -122.418806481101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0067&ExportPDF=1&Filename=17MFF-0067_schedule.pdf Mo-Su:6PM-12AM   02/22/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.760086931987, -122.418806481101)
67 67 334914 Halal Cart, LLC 31 Push Cart 2 8748101 MARKET ST: 05TH ST \ CYRIL MAGNIN ST to MASON ST \ TURK ST (901 - 941) -- SOUTH -- 901 MARKET ST 3704001 3704 56 001 11MFF-0175 INACTIVE 3 Kebab: Halal Gyros: Grilled Halal Meat: Beverages 6010303.105 2113361.952 37.7834700660829 -122.408040736138 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=11MFF-0175&ExportPDF=1&Filename=11MFF-0175_schedule.pdf Sa-Su:12AM-3AM;Mo-Su:10AM-8PM;Fr/Sa:9PM-12AM     2011-09-26 0   (37.7834700660829, -122.408040736138)
437 437 934303 Yummy Hot Dogs 79 Push Cart 2 8749101 MARKET ST: MASON ST \ TURK ST to 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST (943 - 999) -- SOUTH -- 945 MARKET ST 3704240 3704 56 240 17MFF-0063 APPROVED 5 Hot dogs: pretzels: chips: juices and cold drinks 6010068.04758 2113135.15204 37.782834163698396 -122.40883794044599 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0063&ExportPDF=1&Filename=17MFF-0063_schedule.pdf Mo/We/Fr:10AM-7PM   03/15/2017 12:00:00 AM 2017-02-11 0 03/15/2018 12:00:00 AM (37.7828341636984, -122.408837940446)
505 505 934715 Kettle Corn Star 97 Push Cart 2 8747103 MARKET ST: POWELL ST to 05TH ST \ CYRIL MAGNIN ST (865 - 899) -- SOUTH -- 865 MARKET ST 3705 042 3705 340 042 17MFF-0118 APPROVED 5 Kettle Corn: Funnel Cakes: Waffles: Lemonade 6010561.591 2113530.347 37.783946907974205 -122.407158344984 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0118&ExportPDF=1&Filename=17MFF-0118_schedule.pdf Mo-Su:10AM-6PM   03/30/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7839469079742, -122.407158344984)
496 496 934394 Creme Brulee To Go 71 Push Cart 2 8747102 MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- 801 MARKET ST 3705Z001 3705Z 333 001 17MFF-0077 APPROVED 5 Steak and chicken kebob:Steak and chicken kebob sandwiches:chicken teriyaki:chicken teriyaki sandwiches:garden salad side:grilled chicken burger: ground beef burgers: white rice side: canned drinks: and chips 6010997.43389 2113901.46037 37.784990279306506 -122.405676629072 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0077&ExportPDF=1&Filename=17MFF-0077_schedule.pdf Mo-Su:11AM-7PM   03/24/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7849902793065, -122.405676629072)
503 503 934716 Kettle Corn Star 97 Push Cart 2 8746103 MARKET ST: YERBA BUENA LN to 04TH ST \ ELLIS ST \ STOCKTON ST (767 - 799) -- SOUTH -- 773 MARKET ST 3706096 3706 338 096 17MFF-0120 APPROVED 5 Kettle Corn: Funnel Cakes: Lemonade: Beverages: Flan: Hot Dogs: Falafel: Hot and Cold Sandwiches: French Fries: Baklava and Pastries 6011371.872269999 2114041.46827 37.7853956394405 -122.40439104283001 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0120&ExportPDF=1&Filename=17MFF-0120_schedule.pdf Mo-Su:10AM-6PM   03/30/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7853956394405, -122.40439104283)
23 23 364218 The Chai Cart 17 Push Cart 2 9543000 NEW MONTGOMERY ST: AMBROSE BIERCE ST to MISSION ST (77 - 99) 79 NEW MONTGOMERY ST 3707014 3707 22 014 12MFF-0083 SUSPEND 4 Hot Indian Chai (Tea) 6012504.312000001 2114926.774 37.7878896999061 -122.400535326777 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=12MFF-0083&ExportPDF=1&Filename=12MFF-0083_schedule.pdf Mo-Su:7AM-6PM     2012-04-03 0   (37.7878896999061, -122.400535326777)
463 463 934432 The Chai Cart 17 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 525 MARKET ST 3708056 3708 4 056 17MFF-0086 APPROVED 5 Hot Indian Chai 6012886.778 2115835.7 37.7904067199405 -122.399275886086 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf Mo-Fr:8AM-4PM   03/17/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7904067199405, -122.399275886086)
4 4 626189 Taza Halal Cart 4 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 555 MARKET ST 3708057 3708 4 057 15MFF-0024 INACTIVE 3 Chicken gyro: lamb gyro: chicken gyro plate:lamb gyro plate: combination gyro plate 6012693.864 2115651.384 37.7898898782098 -122.399930411351 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0024&ExportPDF=1&Filename=15MFF-0024_schedule.pdf Mo-We:10AM-9PM     2015-03-02 0   (37.7898898782098, -122.399930411351)
12 12 665094 Gour Chaat 10 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 555 MARKET ST 3708057 3708 4 057 15MFF-0044 REQUESTED 1 Chaats: vegeterian wraps: chai: soft drinks 6012693.864 2115651.384 37.7898898782098 -122.399930411351 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0044&ExportPDF=1&Filename=15MFF-0044_schedule.pdf Mo-We:8AM-6PM     2015-03-09 0   (37.7898898782098, -122.399930411351)
34 34 656150 Afghani Rice 11 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 555 MARKET ST 3708057 3708 4 057 15MFF-0115 REQUESTED 1 Rice - Chicken & Beef: sauce: cold drinks: hot drinks 6012693.864 2115651.384 37.7898898782098 -122.399930411351 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0115&ExportPDF=1&Filename=15MFF-0115_schedule.pdf Th/Fr/Sa:10AM-8PM     2015-04-07 0 03/15/2016 12:00:00 AM (37.7898898782098, -122.399930411351)
65 65 839524 Halal Cart of San Francisco 30 Push Cart 2 8742101 MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- 555 MARKET ST 3708057 3708 4 057 16MFF-0136 REQUESTED 1 Gyro; Chicken over rice; Gyro over rice; 6012693.864 2115651.384 37.7898898782098 -122.399930411351 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0136&ExportPDF=1&Filename=16MFF-0136_schedule.pdf       2016-08-12 0   (37.7898898782098, -122.399930411351)
613 613 945062 Faith Sandwich 117 Push Cart 2 9090000 MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) 560 MISSION ST 3708095 3708 4 095 17MFF-0135 APPROVED 5 Vietnamese sandwiches: various meat rice plates & bowls: vermicelli: spring rolls: sticky rice: Vietnamese Goi: pho: noodles: coffee: various flavored tea : various soda and juices: water 6012851.27 2115274.827 37.788864715342996 -122.39935935136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0135&ExportPDF=1&Filename=17MFF-0135_schedule.pdf Mo-Fr:8AM-3PM   07/18/2017 12:00:00 AM 2017-03-06 0 03/15/2018 12:00:00 AM (37.788864715343, -122.399359351363)
381 381 934709 Halal Cart, LLC 31 Push Cart 2 8741101 MARKET ST: FREMONT ST \ FRONT ST to 01ST ST \ BUSH ST (401 - 499) -- SOUTH -- 455 MARKET ST 3709012 3709 279 012 17MFF-0114 APPROVED 5 Gyros: Kebabs: soft drinks: and water 6013076.33 2116028.637 37.790947041923395 -122.39863358940399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0114&ExportPDF=1&Filename=17MFF-0114_schedule.pdf Mo-Su:10AM-8PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7909470419234, -122.398633589404)
170 170 934559 The Sandwich Stand, LLC. 45 Push Cart 2 8627000 MAIN ST: MARKET ST to MISSION ST (1 - 99) 58 MAIN ST 3711005 3711 142 005 17MFF-0108 REQUESTED 1 Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. 6013902.41 2116435.193 37.792109338609 -122.39580386550199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0108&ExportPDF=1&Filename=17MFF-0108_schedule.pdf Mo-Fr:8AM-5PM     2017-02-13 0 05/02/2018 12:00:00 AM (37.792109338609, -122.395803865502)
396 396 934713 Halal Cart, LLC 31 Push Cart 2 8737101 MARKET ST: STEUART ST to SPEAR ST (1 - 99) -- SOUTH -- 1 MARKET ST 3713006 3713 79 006 17MFF-0116 APPROVED 5 kebabs: halal gyro: grilled halal meat: refreshments 6014186.566000001 2117071.214 37.793871507150605 -122.39486523862101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0116&ExportPDF=1&Filename=17MFF-0116_schedule.pdf Tu/Th/Fr:9AM-3PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7938715071506, -122.394865238621)
410 410 947734 Halal Cart of San Francisco 30 Push Cart 2 8737101 MARKET ST: STEUART ST to SPEAR ST (1 - 99) -- SOUTH -- 1 MARKET ST 3713006 3713 79 006 17MFF-0152 APPROVED 5 Halal Gyro over Rice: Halal Chicken over Rice: Halal Gyro: and Chicken Sandwich 6014186.566000001 2117071.214 37.793871507150605 -122.39486523862101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0152&ExportPDF=1&Filename=17MFF-0152_schedule.pdf Mo/We:10AM-4PM   03/13/2017 12:00:00 AM 2017-03-13 0 03/15/2018 12:00:00 AM (37.7938715071506, -122.394865238621)
35 35 321365 Sausage Slinger 19 Push Cart 2 9544000 NEW MONTGOMERY ST: MISSION ST to MINNA ST (100 - 130) 100 NEW MONTGOMERY ST 3722071 3722 27 071 11MFF-0070 SUSPEND 4 Hot Dogs: Chips and Soda 6012529.293 2114617.375 37.7870415558717 -122.400427155584 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=11MFF-0070&ExportPDF=1&Filename=11MFF-0070_schedule.pdf Mo-Fr:8AM-6PM     2011-04-11 0 03/15/2013 12:00:00 AM (37.7870415558717, -122.400427155584)
370 370 934544 San Francisco Street Foods, Inc. 68 Push Cart 2 7038000 HOWARD ST: 03RD ST to 04TH ST (700 - 799) 701 HOWARD ST 3734091 3734 272 091 17MFF-0100 APPROVED 5 Hot dogs: condiments: soft pretzels: soft drinks: coffee: cold beverages: pastries: bakery goods: cookies: ice cream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. 6012391.612000001 2113335.21 37.7835133512454 -122.400813391105 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0100&ExportPDF=1&Filename=17MFF-0100_schedule.pdf Mo-Su:6AM-12AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7835133512454, -122.400813391105)
52 52 773105 Athena SF Gyro 23 Push Cart 2 417000 08TH ST: BRANNAN ST to TOWNSEND ST (600 - 699) 699 08TH ST 3783009 3783 45 009 15MFF-0145 REQUESTED 1 Gyro pita bread (Lamb or chicken): lamb over rice: chicken over rice: chicken biryani rice: soft drinks 6011509.501 2108803.8340000003 37.7710219992437 -122.403546254184 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0145&ExportPDF=1&Filename=15MFF-0145_schedule.pdf Mo-We:6AM-6PM     2015-09-01 0   (37.7710219992437, -122.403546254184)
90 90 526152 A Taste of Chicago 36 Push Cart 2 13660000 WILLIAMS AVE: APOLLO ST to PHELPS ST \ VESTA ST (300 - 399) 345 WILLIAMS AVE 5423A009 5423A 5 009 14MFF-0036 EXPIRED 2 Breakfast sandwiches: mixed coffee drinks: fried chicken: hamburgers: hot dogs: hot links: tacos: pizza: rotisserrie chicken: fish sticks: deli sandwiches: burritos: philly cheese steak: rice: baked potato: cold beverages: teas: juices: salads: bbq ribs: french fries: yogurt and bread 6012447.306 2093773.9340000001 37.7298054805741 -122.39924710472401 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0036&ExportPDF=1&Filename=14MFF-0036_schedule.pdf Su/Fr/Sa:6AM-8PM     2014-03-13 0 03/15/2014 12:00:00 AM (37.7298054805741, -122.399247104724)
435 435 948140 Eli's Hot Dogs 78 Push Cart 2 7504000 JERROLD AVE: BARNEVELD AVE to END (2351 - 2369) 101 BAY SHORE BLVD 5559018 5559 46 018 17MFF-0155 REQUESTED 1 various styles of hot dogs & sausages: chips: breakfast sandwiches: chili: soda: water: 6011376.107000001 2100039.012 37.7469482955131 -122.40339096031299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0155&ExportPDF=1&Filename=17MFF-0155_schedule.pdf Mo/Tu/We/Th/Fr:9AM-5PM     2017-03-14 1 03/15/2017 12:00:00 AM (37.7469482955131, -122.403390960313)
536 536 959619 Kabob Trolley, LLC 101 Push Cart 2 267001 04TH ST: TOWNSEND ST to KING ST (700 - 799) 298 KING ST 8702606 8702 359 606 17MFF-0177 REQUESTED 1 Gyros: Kebobs: refreshments and dessert 6014485.06287 2111154.5175099997 37.777642208509995 -122.393418145932 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0177&ExportPDF=1&Filename=17MFF-0177_schedule.pdf Mo-Su:10AM-8PM     2017-04-07 0 03/15/2018 12:00:00 AM (37.77764220851, -122.393418145932)
611 611 953001 Wonder Philly 115 Push Cart 2 270002 04TH ST: BERRY ST to CHANNEL ST (900 - 999) 960 04TH ST 8708002 8708 86 002 17MFF-0166 REQUESTED 1 Hot dogs: sausages: cheesesteaks: chips: drinks 6014277.187000001 2109955.224 37.7743376663696 -122.394053286313 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0166&ExportPDF=1&Filename=17MFF-0166_schedule.pdf Mo-We:9AM-5PM     2017-03-20 0 04/01/2018 12:00:00 AM (37.7743376663696, -122.394053286313)
427 427 948215 Got Snacks 76 Push Cart 2 184001 03RD ST: TERRY A FRANCOIS BLVD to CHANNEL (1000 - 1099) 1020 03RD ST 8714002 8714 296 002 17MFF-0156 APPROVED 5 sunflower seeds: crackerjacks: bottled water: peanuts: candy 6015168.306 2110364.21 37.775510138049505 -122.390999306002 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0156&ExportPDF=1&Filename=17MFF-0156_schedule.pdf Mo-Su:10AM-9PM   03/14/2017 12:00:00 AM 2017-03-14 1 03/15/2018 12:00:00 AM (37.7755101380495, -122.390999306002)

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