Mobile_Food_Facility_Permit

Data source: data.sfgov.org

673 rows sorted by FacilityType descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
633 633 976033 Plaza Garibaldy 18 Truck 1 9297000 MONTGOMERY ST: POST ST to SUTTER ST (1 - 99) 1 MONTGOMERY ST 0292002 0292 304 002 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6011970.278 2115432.874 37.789249534075104 -122.402418597294 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo/We/Fr:10AM-3PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7892495340751, -122.402418597294)
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)
640 640 1013324 Wu Wei LLC dba MoBowl 125 Truck 1 4972000 DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) 253 DRUMM ST 0203013 0203 319 013 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6013507.554 2117905.099 37.796123380252105 -122.39727320433799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Tu/Th:10AM-3PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7961233802521, -122.397273204338)
641 641 1037694 Munch A Bunch 126 Truck 1 13547000 WEBSTER ST: CLAY ST to WASHINGTON ST (2200 - 2299) 2200 WEBSTER ST 0613003 0613 402 003 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-2PM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (0, 0)
642 642 1037695 Munch A Bunch 126 Truck 1 12728000 TURK ST: WEBSTER ST to FILLMORE ST (1300 - 1399) 1345 TURK ST 0756001 0756 403 001 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-11AM/12PM-1PM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (0, 0)
643 643 1037696 Munch A Bunch 126 Truck 1 9114000 MISSION ST: 14TH ST to 15TH ST (1800 - 1899) 1850 MISSION ST 3547002 3547 3 002 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6006589.562999999 2107566.187 37.767347670704105 -122.420476639081 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Sa-Su:8AM-4PM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7673476707041, -122.420476639081)
644 644 1037689 Munch A Bunch 126 Truck 1 373000 07TH ST: CLEVELAND ST to HARRISON ST (314 - 399) 355 07TH ST 3754 018 3754 404 018 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6010570.267000001 2110774.8430000003 37.7763814259936 -122.406934051626 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:8AM-9AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7763814259936, -122.406934051626)
645 645 1037693 Munch A Bunch 126 Truck 1 24215000 BRYANT ST: ALAMEDA ST intersection 1525 BRYANT ST 3922A001A 3922A 405 001A 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6009575.985 2107645.792 37.7677340926708 -122.410152601942 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-11AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7677340926708, -122.410152601942)
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)
649 649 1024464 Senor Sisig 73 Truck 1 3525000 CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199) 101 CALIFORNIA ST 0263011 0263 9 011 16MFF-0143 APPROVED 5 Senor Sisig: Filipino fusion food: tacos: burritos: nachos: rice plates. Various beverages. 6013245.668 2116754.292 37.7929489528347 -122.398098613167 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0143&ExportPDF=1&Filename=16MFF-0143_schedule.pdf Mo/We/Fr: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.7929489528347, -122.398098613167)
650 650 1024812 Plaza Garibaldy 18 Truck 1 3420000 BUSH ST: BATTERY ST to SANSOME ST (100 - 199) 1 BUSH ST 0290011 0290 16 011 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6012652.373 2116027.943 37.7909215072692 -122.400100423738 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo/We/Fr:10AM-3PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7909215072692, -122.400100423738)
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)
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)
655 655 1024769 Plaza Garibaldy 18 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 540 HOWARD ST 3721015 3721 104 015 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6013457.851 2114931.191 37.7879549596858 -122.397236543731 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo-We:3PM-8PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7879549596858, -122.397236543731)
656 656 934376 Two G's Catering 103 Truck 1 3088000   840 BRANNAN ST 3780078 3780 369 078 17MFF-0073 APPROVED 5 Cold Truck: Hot & Cold Sandwiches: Bagels: Burritos: Soups: Hot Dogs: Tacos: Pork Buns: BBQ Meat: Fruit: Various Beverages: Pasties: Pre-Packaged Snacks: Candy: Salads: Muffins: Scones: Brownies: Croissants: Energy Bars: Noodle Bowls 6011252.805 2109369.807 37.772561689774 -122.404474024011 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Fr:8AM-9AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.772561689774, -122.404474024011)
657 657 1013323 Wu Wei LLC dba MoBowl 125 Truck 1 13403000 WASHINGTON ST: THE EMBARCADERO to DRUMM ST (1 - 99) 370 DRUMM ST 0201012 0201 293 012 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6013693.222 2118189.172 37.7969137124835 -122.396650675264 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Su:10AM-11PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7969137124835, -122.396650675264)
658 658 1013320 Wu Wei LLC dba MoBowl 125 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 500 HOWARD ST 3721011 3721 104 011 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls.     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Mo/Fr:10AM-2PM     2017-08-31 1 03/15/2018 12:00:00 AM (0, 0)
659 659 1013322 Wu Wei LLC dba MoBowl 125 Truck 1 12160001 STEUART ST: HOWARD ST to END (200 - 299) 75 HOWARD ST 3741031 3741 408 031 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6015092.174 2116210.269 37.791557864154896 -122.391671499786 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Mo/We:10AM-3PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7915578641549, -122.391671499786)
660 660 1013321 Wu Wei LLC dba MoBowl 125 Truck 1 6438001 GREEN ST: THE EMBARCADERO to FRONT ST (1 - 49) 900 FRONT ST 0137001 0137 409 001 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6012874.622 2119410.253 37.800220915592206 -122.399569018577 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Fr:10AM-4PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.8002209155922, -122.399569018577)
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)
664 664 1037687 Munch A Bunch 126 Truck 1 784000 17TH ST: SAN BRUNO AVE to UTAH ST (2200 - 2299) 2222 17TH ST 3960001 3960 410 001 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6010755.356000001 2106704.644 37.7652159489938 -122.406006972029 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:5AM-6AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7652159489938, -122.406006972029)
665 665 1037688 Munch A Bunch 126 Truck 1 10293000 PARNASSUS AVE: HILLWAY AVE to 03RD AVE (400 - 599) 400 PARNASSUS AVE 1756001 1756 278 001 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 5995605.966 2106525.1040000003 37.7638640323832 -122.458391749844 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:7AM-8AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7638640323832, -122.458391749844)
666 666 1037692 Munch A Bunch 126 Truck 1 5882000 FULTON ST: FRANKLIN ST to GOUGH ST (300 - 399) 365 FULTON ST 0792 028 0792 411 028 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6005956.8 2111638.505 37.778493597185204 -122.42295474739599 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-11AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7784935971852, -122.422954747396)
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)
668 668 1037691 Munch A Bunch 126 Truck 1 8137000 LARKIN ST: FERN ST to BUSH ST (1127 - 1199) 1144 LARKIN ST 0279012 0279 412 012 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6007372.707 2115263.8019999997 37.7885275753132 -122.418313685721 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-11AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7885275753132, -122.418313685721)
669 669 1037690 Munch A Bunch 126 Truck 1 546000 12TH ST: ISIS ST to BERNICE ST (332 - 365) 333 12TH ST 3521022 3521 337 022 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6008484.985 2108791.319 37.7708182299993 -122.41400729759701 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:9AM-10AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7708182299993, -122.414007297597)
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)
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)
97 97 755221 Fruteria Serrano 40   9167000 MISSION ST: OCEAN AVE to PERSIA AVE (4650 - 4699) 4650 MISSION ST 6955044 6955 82 044 16MFF-0011 REQUESTED 1 Fruits including mangoes: pineapples: coconuts: watermelon: corn: cucumber: potatoes chips: water: Mexican drinks: sodas: juices: snow cones 6001790.666 2091754.638 37.72366127950529 -122.43594382523999 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0011&ExportPDF=1&Filename=16MFF-0011_schedule.pdf Mo/Th/Fr:11AM-6PM     2016-02-17 0 03/15/2017 12:00:00 AM (37.7236612795053, -122.43594382524)
414 414 934546 San Francisco Street Foods, Inc. 68   30735000 NEW MONTGOMERY ST: MARKET ST \ MONTGOMERY ST intersection 2 MONTGOMERY ST 0291007 0291 25 007 17MFF-0102 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. 6012142.899 2115481.242 37.789391976102706 -122.401824747121 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0102&ExportPDF=1&Filename=17MFF-0102_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.7893919761027, -122.401824747121)
630 630 1009866 Golden Gate Halal Food 122   4969000 DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6) 1 DRUMM ST 0264004 0264 30 004 16MFF-0094 REQUESTED 1 Pulao Plates & Sandwiches: Various Drinks 6013552.57 2116844.5 37.7932137316634 -122.397043036718 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0094&ExportPDF=1&Filename=16MFF-0094_schedule.pdf Mo/We/Fr:8AM-8PM     2016-04-18 0   (37.7932137316634, -122.397043036718)
631 631 1009867 Golden Gate Halal Food 122   8749101 MARKET ST: MASON ST \ TURK ST to 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST (943 - 999) -- SOUTH -- 979 MARKET ST 3704068 3704 56 068 16MFF-0094 REQUESTED 1 Pulao Plates & Sandwiches: Various Drinks 6009863.636 2112937.779 37.7822807724186 -122.40953118732 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0094&ExportPDF=1&Filename=16MFF-0094_schedule.pdf Mo/Tu/Th:8AM-8PM     2016-04-18 0   (37.7822807724186, -122.40953118732)
638 638 1012444 Golden Gate Halal Food 122   8751101 MARKET ST: 07TH ST \ CHARLES J BRENHAM PL to 08TH ST \ GROVE ST \ HYDE ST (1101 - 1199) -- SOUTH -- 1169 MARKET ST 3702051 3702 67 051 16MFF-0094 REQUESTED 1 Pulao Plates & Sandwiches: Various Drinks     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0094&ExportPDF=1&Filename=16MFF-0094_schedule.pdf We/Fr/Sa:8AM-8PM     2016-04-18 0   (0, 0)
661 661 1034228 Julie's Hot Dogs 124   9114000 MISSION ST: 14TH ST to 15TH ST (1800 - 1899) 1850 MISSION ST 3547261 3547 3 261 17MFF-0196 REQUESTED 1 Hot dogs: bacon wrap hot dogs: chicken burgers: energy drinks: water & various drinks 6006577.68992 2107569.1077799997 37.767355021369795 -122.420517913829 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0196&ExportPDF=1&Filename=17MFF-0196_schedule.pdf Su/Fr/Sa:7AM-5PM     2017-10-27 0   (37.7673550213698, -122.420517913829)
671 671 598046 Missing Link SF 130   103000 01ST ST: END to MISSION ST (72 - 99) 97 01ST ST 3709008 3709 279 008 14MFF-0133 REQUESTED 1 smoked sausages: deer: wild boar: pheasant: buffalo: beef: turkey: coleslaw: vegetarian baked beans 6013385.482999999 2115736.96 37.79016338419571 -122.39754345993 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0133&ExportPDF=1&Filename=14MFF-0133_schedule.pdf Tu/Th/Fr:11AM-9PM     2014-11-10 0   (37.7901633841957, -122.39754345993)
673 673 1039786 Julie's Hot Dogs 124   9117000 MISSION ST: 17TH ST to CLARION ALY (2100 - 2131) 2101 MISSION ST 3575091 3575 414 091 17MFF-0196 REQUESTED 1 Hot dogs: bacon wrap hot dogs: chicken burgers: energy drinks: water & various drinks 6006982.392000001 2106038.3140000002 37.7631746196338 -122.419009514771 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0196&ExportPDF=1&Filename=17MFF-0196_schedule.pdf Tu/We/Th:10AM-8PM     2017-10-27 0   (37.7631746196338, -122.419009514771)

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