Mobile_Food_Facility_Permit

Data source: data.sfgov.org

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

✎ 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
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)
492 492 934332 Lobsta Truck 94 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 430 CALIFORNIA ST 0239029 0239 81 029 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012181.836 2116889.9790000003 37.7932622069231 -122.40178909136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_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.7932622069231, -122.401789091363)
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)
494 494 934330 Lobsta Truck 94 Truck 1 10454000 PINE ST: FRONT ST to BATTERY ST (100 - 199) 100 PINE ST 0262020 0262 332 020 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012991.557999999 2116647.1890000002 37.7926407167337 -122.39897033211099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_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.7926407167337, -122.398970332111)
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)
499 499 932023 Slider Shack, LLC. 96 Truck 1 7032000 HOWARD ST: FREMONT ST to 01ST ST (400 - 499) 400 HOWARD ST 3720008 3720 26 008 17MFF-0009 APPROVED 5 Sliders: Tater Tots: Beverages 6013858.05956 2115347.09492 37.7891192076677 -122.39588103933501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0009&ExportPDF=1&Filename=17MFF-0009_schedule.pdf Mo/Th/Fr:10AM-3PM   04/04/2017 12:00:00 AM 2017-02-03 0 03/15/2018 12:00:00 AM (37.7891192076677, -122.395881039335)
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)
506 506 957190 Tres Agaves Mexican Kitchen & Tequila Lounge LLC. dba Tres Truck 98 Truck 1 10995000 RHODE ISLAND ST: 16TH ST to 17TH ST (300 - 399) 301 RHODE ISLAND ST 3956025 3956 341 025 17MFF-0175 APPROVED 5 Multiple Trucks - Everything 6011875.761 2106770.6319999998 37.765459737468206 -122.40213637617902 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0175&ExportPDF=1&Filename=17MFF-0175_schedule.pdf Mo-We:8AM-3PM   03/30/2017 12:00:00 AM 2017-03-30 0 03/15/2018 12:00:00 AM (37.7654597374682, -122.402136376179)
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)
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)
557 557 1001301 Bonito Poke 104 Truck 1 7032000 HOWARD ST: FREMONT ST to 01ST ST (400 - 499) 400 HOWARD ST 3720008 3720 26 008 16MFF-0141 REQUESTED 1 Bonito Poke Bowls & Various Drinks 6013858.05956 2115347.09492 37.7891192076677 -122.39588103933501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0141&ExportPDF=1&Filename=16MFF-0141_schedule.pdf Mo/Fr:10AM-2PM     2016-11-28 0   (37.7891192076677, -122.395881039335)
619 619 1001542 Bonito Poke 104 Truck 1 7165000 ILLINOIS ST: 16TH ST to MARIPOSA ST \ TERRY A FRANCOIS BLVD (400 - 599) 409 ILLINOIS ST 3940003 3940 263 003 16MFF-0141 REQUESTED 1 Bonito Poke Bowls & Various Drinks 6016152.96291 2106970.02895 37.7662450471029 -122.38735628651101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0141&ExportPDF=1&Filename=16MFF-0141_schedule.pdf Th/Fr/Sa:10AM-10PM     2016-11-28 0   (37.7662450471029, -122.387356286511)
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)
591 591 934409 Sanguchon 108 Truck 1 12045000 SPEAR ST: MISSION ST to HOWARD ST (100 - 199) 100 SPEAR ST 3717001 3717 387 001 17MFF-0082 APPROVED 5 Peruvian Food 6014423.85 2116439.642 37.7921505484817 -122.39399997405899 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0082&ExportPDF=1&Filename=17MFF-0082_schedule.pdf Mo-Fr:11AM-3PM   05/01/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7921505484817, -122.393999974059)
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)
615 615 934407 Sanguchon 108 Truck 1 3529000 CALIFORNIA ST: LEIDESDORFF ST to MONTGOMERY ST (449 - 499) 475 CALIFORNIA ST 0260010 0260 6 010 17MFF-0081 APPROVED 5 Peruvian food 6012002.812000001 2116560.078 37.792346385148 -122.402385322794 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0081&ExportPDF=1&Filename=17MFF-0081_schedule.pdf Mo/We/Fr:11AM-3PM   07/31/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.792346385148, -122.402385322794)
602 602 959665 Giant Burrito 111 Truck 1 2800102 BAY SHORE BLVD: FLOWER ST to CORTLAND AVE (341 - 489) -- EAST -- 353 BAY SHORE BLVD 5598030 5598 163 030 17MFF-0178 APPROVED 5 Tacos: Burritos: Tostadas: Flautas: Tostadas: Tortas: Pozole Menudo 6010751.382 2098146.819 37.7417178307439 -122.40541797744801 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0178&ExportPDF=1&Filename=17MFF-0178_schedule.pdf Mo/Tu/We/Th/Fr:7AM-6PM   05/26/2017 12:00:00 AM 2017-04-07 0 03/15/2018 12:00:00 AM (37.7417178307439, -122.405417977448)
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)
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)
606 606 988643 Cochinita 113 Truck 1 1329000 24TH ST: UTAH ST to POTRERO AVE (2600 - 2699) 2601 24TH ST 4264001 4264 393 001 17MFF-0186 REQUESTED 1 Panushos: salbutes: salad: price: beans: cochinita: etc. 6010800.766 2102190.03 37.7528223681215 -122.405531919216 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0186&ExportPDF=1&Filename=17MFF-0186_schedule.pdf Mo/Tu/Sa:11AM-5PM     2017-06-19 0   (37.7528223681215, -122.405531919216)
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)
610 610 924719 San Francisco's Hometown Creamery 114 Truck 1 6109000 GEARY ST: STOCKTON ST to POWELL ST (200 - 299) 287 GEARY ST 0314016 0314 298 016 17MFF-0001 REQUESTED 1 Ice cream 6010359.7874 2114712.50286 37.7871815311957 -122.40793990670099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0001&ExportPDF=1&Filename=17MFF-0001_schedule.pdf Sa-Su:11AM-11PM;Fr:6PM-11PM     2017-01-09 0   (37.7871815311957, -122.407939906701)
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)
617 617 848080 Taqueria Lolita 118 Truck 1 10927000 RANKIN ST: DAVIDSON AVE to EVANS AVE (200 - 299) 1700 EVANS AVE 5227001 5227 21 001 16MFF-0128 SUSPEND 4 Tacos: burritos: quesadillas: combination plates: tortas: tostadas 6014950.929 2099216.653 37.744889286143 -122.390971976935 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0128&ExportPDF=1&Filename=16MFF-0128_schedule.pdf Th/Fr/Sa:7AM-3PM   08/01/2017 12:00:00 AM 2016-06-22 0 03/15/2018 12:00:00 AM (37.744889286143, -122.390971976935)
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)
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)
627 627 949472 Subs on Hubs 121 Truck 1 302000 05TH ST: HARRISON ST \ I-80 W OFF RAMP to PERRY ST (400 - 449) 400 05TH ST 3760001 3760 400 001 17MFF-0160 APPROVED 5 Italian subs: Cuban sandwich: Gyro 6012059.645 2111592.733 37.778710391900894 -122.40183935033001 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:12AM-2AM;Fr/Sa:11PM-12AM   08/21/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7787103919009, -122.40183935033)
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)
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)
634 634 934555 Casey's Pizza, LLC 123 Truck 1 11544000 SANSOME ST: PINE ST to CALIFORNIA ST (200 - 299) 231 SANSOME ST 0260002 0260 6 002 17MFF-0104 APPROVED 5 Artisan Pizzas (Margherita: Yukon Potato: Zoe's Pepperoni: Funghi: Brocolli Rabe: Bacon Kale: Arugula) and Drinks. 6012313.995 2116649.543 37.792609401119 -122.40131490545099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0104&ExportPDF=1&Filename=17MFF-0104_schedule.pdf Mo/We:10AM-2PM   08/29/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.792609401119, -122.401314905451)
635 635 934553 Casey's Pizza, LLC 123 Truck 1 10624001 POST ST: MONTGOMERY ST to LICK PL (1 - 40) 1 POST ST 0311015 0311 284 015 17MFF-0104 APPROVED 5 Artisan Pizzas (Margherita: Yukon Potato: Zoe's Pepperoni: Funghi: Brocolli Rabe: Bacon Kale: Arugula) and Drinks. 6011921.732000001 2115262.393 37.788778723378 -122.40257456841101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0104&ExportPDF=1&Filename=17MFF-0104_schedule.pdf Sa:12PM-4PM;Tu/We/Th:3PM-8PM   08/29/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.788778723378, -122.402574568411)
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)
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)
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)
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)
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)
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)
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)
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)
662 662 1022810 Serendipity SF 129 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 400 CALIFORNIA ST 0239003 0239 81 003 17MFF-0181 REQUESTED 1 Meatloaf: Grilled Cheese: Chicken Sandwich: Caprese Salad: Kale Salad: Fries: Sweet Potato Fries: Mac and Cheese: Mashed Potatoes 6012277.507999999 2116903.356 37.793304275561 -122.40145899841299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0181&ExportPDF=1&Filename=17MFF-0181_schedule.pdf Su/We/Sa:11AM-3PM     2017-04-14 0 04/30/2018 12:00:00 AM (37.793304275561, -122.401458998413)
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)
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 15.308ms · Data source: data.sfgov.org