Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
585 | 585 | 963988 | Singh Brothers Ice Cream 105 | Truck 1 | 10218000 | PALOU AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1101 PALOU AVE | 4757024 | 4757 385 | 024 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017464.808999999 | 2093259.551 | 37.7286714428179 | -122.38186508864099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7286714428179, -122.381865088641) | ||
586 | 586 | 963992 | Singh Brothers Ice Cream 105 | Truck 1 | 10810000 | QUESADA AVE: CRISP RD to HAWES ST (1170 - 1199) | 1191 QUESADA AVE | 4763042 | 4763 245 | 042 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017387.966 | 2092923.5080000001 | 37.727744490701106 | -122.382107375242 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7277444907011, -122.382107375242) | ||
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¶ms=permit=17MFF-0183&ExportPDF=1&Filename=17MFF-0183_schedule.pdf | 2017-04-24 | 0 | (37.7611038757211, -122.435320318835) | ||||
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¶ms=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¶ms=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¶ms=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) | |||
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¶ms=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) | ||
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¶ms=permit=17MFF-0187&ExportPDF=1&Filename=17MFF-0187_schedule.pdf | 2017-07-19 | 0 | 07/19/2017 12:00:00 AM | (0, 0) | ||||||||
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¶ms=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¶ms=permit=16MFF-0141&ExportPDF=1&Filename=16MFF-0141_schedule.pdf | Tu/We/Fr:10AM-2PM | 2016-11-28 | 0 | (37.7879886489953, -122.396100668472) | |||
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¶ms=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¶ms=permit=16MFF-0094&ExportPDF=1&Filename=16MFF-0094_schedule.pdf | Mo/Tu/Th:8AM-8PM | 2016-04-18 | 0 | (37.7822807724186, -122.40953118732) | ||||
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¶ms=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) | ||
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¶ms=permit=16MFF-0094&ExportPDF=1&Filename=16MFF-0094_schedule.pdf | We/Fr/Sa:8AM-8PM | 2016-04-18 | 0 | (0, 0) | ||||||
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¶ms=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) | ||
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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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) | ||
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¶ms=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¶ms=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¶ms=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¶ms=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) | ||
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¶ms=permit=17MFF-0196&ExportPDF=1&Filename=17MFF-0196_schedule.pdf | Su/Fr/Sa:7AM-5PM | 2017-10-27 | 0 | (37.7673550213698, -122.420517913829) | ||||
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¶ms=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¶ms=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) | ||
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¶ms=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) | |||
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¶ms=permit=14MFF-0133&ExportPDF=1&Filename=14MFF-0133_schedule.pdf | Tu/Th/Fr:11AM-9PM | 2014-11-10 | 0 | (37.7901633841957, -122.39754345993) | ||||
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¶ms=permit=14MFF-0105&ExportPDF=1&Filename=14MFF-0105_schedule.pdf | 2014-06-16 | 0 | 03/15/2015 12:00:00 AM | (0, 0) | |||||||||
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¶ms=permit=17MFF-0196&ExportPDF=1&Filename=17MFF-0196_schedule.pdf | Tu/We/Th:10AM-8PM | 2017-10-27 | 0 | (37.7631746196338, -122.419009514771) |
JSON shape: default, array, newline-delimited
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");