Mobile_Food_Facility_Permit

Data source: data.sfgov.org

48 rows where lot = 002

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: FacilityType, Status, Approved, Received, PriorPermit, ExpirationDate, Received (date)

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
6 6 526148 Cheese Gone Wild 6 Truck 1 11544000 SANSOME ST: PINE ST to CALIFORNIA ST (200 - 299) 233 SANSOME ST 0260002 0260 6 002 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6012313.995 2116649.543 37.792609401119 -122.40131490545099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Th:10AM-2PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.792609401119, -122.401314905451)
7 7 526123 Bach Catering 2 Truck 1 11372000 SAN BRUNO AVE: HALE ST to SILVER AVE (2362 - 2399) 2380 SAN BRUNO AVE 5881002 5881 7 002 14MFF-0034 EXPIRED 2 Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks. 6010557.2129999995 2094814.259 37.7325564744198 -122.40585465611 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf Mo-Fr:9AM-10AM   03/13/2014 12:00:00 AM 2014-03-13 1 03/15/2015 12:00:00 AM (37.7325564744198, -122.40585465611)
40 40 526131 Bach Catering 2 Truck 1 5117000 EGBERT AVE: END to NEWHALL ST (1700 - 1798) 1785 EGBERT AVE 5431A002 5431A 35 002 14MFF-0034 EXPIRED 2 Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks. 6012684.311000001 2092414.5769999998 37.726086170672296 -122.398332406177 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf Mo-Fr:10AM-11AM   03/13/2014 12:00:00 AM 2014-03-13 1 03/15/2015 12:00:00 AM (37.7260861706723, -122.398332406177)
48 48 631837 Del Popolo, LLC. 15 Truck 1 8754201 MARKET ST: 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- 1438 MARKET ST 0835002 0835 41 002 15MFF-0068 EXPIRED 2 Pizza & various drinks 6007245.87 2110789.475 37.776235018471205 -122.418435137885 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0068&ExportPDF=1&Filename=15MFF-0068_schedule.pdf Mo-We:8AM-3PM   03/13/2015 12:00:00 AM 2015-03-13 0 03/15/2016 12:00:00 AM (37.7762350184712, -122.418435137885)
50 50 526146 Cheese Gone Wild 6 Truck 1 13160101 VAN NESS AVE: CLAY ST to WASHINGTON ST (1801 - 1899) -- WEST -- 1801 VAN NESS AVE 0618002 0618 43 002 14MFF-0035 EXPIRED 2 Grilled Cheese Sandwiches 6006008.931 2116666.941 37.79230338307529 -122.423131922094 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf Th:6AM-10AM;Mo/Sa:6AM-8PM   03/13/2014 12:00:00 AM 2014-03-13 0 03/15/2015 12:00:00 AM (37.7923033830753, -122.423131922094)
89 89 559778 Mang Hang Catering 35 Truck 1 12678000 TREAT AVE: DIVISION ST \ FLORIDA ST to ALAMEDA ST (1 - 99) Assessors Block 3902/Lot002 3902002 3902 75 002 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6009046.271000001 2107865.259 37.7683069928 -122.41200033609199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7683069928, -122.412000336092)
100 100 934565 M M Catering 38 Truck 1 7173000 ILLINOIS ST: 24TH ST to 25TH ST (1400 - 1499) 1499 ILLINOIS ST 4244002 4244 85 002 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6016265.425 2102158.675 37.753040320194295 -122.38663176353799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:5PM-6PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7530403201943, -122.386631763538)
102 102 934590 May Catering 37 Truck 1 2955000 BERRY ST: 05TH ST to 06TH ST (300 - 399) 301 BERRY ST 8708002 8708 86 002 17MFF-0110 REQUESTED 1 Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks 6014277.187000001 2109955.224 37.7743376663696 -122.394053286313 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf Mo-Fr:10AM-11AM     2017-02-13 1 05/06/2018 12:00:00 AM (37.7743376663696, -122.394053286313)
116 116 934569 M M Catering 38 Truck 1 716000 16TH ST: HAMPSHIRE ST to BRYANT ST (2200 - 2399) Assessors Block 3930A/Lot002 3930A002 3930A 95 002 17MFF-0109 REQUESTED 1 Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks 6009824.81 2107195.241 37.766510926908296 -122.40926014493 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf Mo-Fr:7PM-8PM     2017-02-13 1 03/31/2018 12:00:00 AM (37.7665109269083, -122.40926014493)
160 160 934603 May Catering 37 Truck 1 702000 16TH ST: MISSOURI ST to CONNECTICUT ST (1000 - 1099) 1006 16TH ST 3833002 3833 134 002 17MFF-0110 REQUESTED 1 Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks 6013316.557 2107189.386 37.7666898573867 -122.39718232278 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf Mo-Fr:12PM-1PM/1PM-2PM     2017-02-13 1 05/06/2018 12:00:00 AM (37.7666898573867, -122.39718232278)
179 179 934995 Breaking Bread Inc. 47 Truck 1 2754000 BATTERY ST: CALIFORNIA ST to HALLECK ST (200 - 230) 300 CALIFORNIA ST 0238002 0238 34 002 17MFF-0124 REQUESTED 1 prepackaged food 6012600.766 2116948.597 37.7934465278161 -122.400343675592 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0124&ExportPDF=1&Filename=17MFF-0124_schedule.pdf Mo/We/Fr:2PM-6PM     2017-02-14 0 03/15/2018 12:00:00 AM (37.7934465278161, -122.400343675592)
208 208 934451 Mini Mobile Food Catering 53 Truck 1 8958000 MENDELL ST: GALVEZ AVE to HUDSON AVE (600 - 699) 620 MENDELL ST 5254002 5254 173 002 17MFF-0089 APPROVED 5 Cold Truck: Corn Dogs: Noodle Soups: Candy: Pre-packaged Snacks: Sandwiches: Chips: Coffee: Tea: Various Beverages 6016250.092 2097183.501 37.7393786694373 -122.386337945153 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0089&ExportPDF=1&Filename=17MFF-0089_schedule.pdf Sa:11AM-2PM   03/01/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7393786694373, -122.386337945153)
221 221 944366 Off the Grid Services, LLC 28 Truck 1 307000 05TH ST: BLUXOME ST to TOWNSEND ST (650 - 699) 670 05TH ST 3785002 3785 183 002 17MFF-0131 APPROVED 5 Everything 6013152.64 2110433.77 37.775589079959396 -122.39797690638001 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0131&ExportPDF=1&Filename=17MFF-0131_schedule.pdf Mo/We/Fr:8AM-3PM   03/02/2017 12:00:00 AM 2017-03-02 0 03/15/2018 12:00:00 AM (37.7755890799594, -122.39797690638)
229 229 945104 F & C Catering 56 Truck 1 5329000 EVANS AVE: HUNTERS POINT BLVD to JENNINGS ST \ MIDDLE POINT RD (1031 - 1099) 1000 EVANS AVE 4580002 4580 187 002 17MFF-0137 APPROVED 5 Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad 6019061.11822 2096525.4056 37.7377268665958 -122.376572914573 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf Mo-Fr:8AM-10AM/11AM-12PM   03/06/2017 12:00:00 AM 2017-03-06 1 03/15/2018 12:00:00 AM (37.7377268665958, -122.376572914573)
243 243 934632 Anas Goodies Catering 57 Truck 1 187101 03RD ST: MARIPOSA ST to 18TH ST (2001 - 2099) -- EAST -- 2085 03RD ST 3994002 3994 125 002 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6015805.902000001 2105904.117 37.7632990560446 -122.388482306805 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf Mo-Fr:7AM-8AM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7632990560446, -122.388482306805)
247 247 934654 Anas Goodies Catering 57 Truck 1 2477000 CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) 2150 CESAR CHAVEZ ST 4324002 4324 195 002 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6013011.36 2101203.484 37.7502368847791 -122.397818031719 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf Mo-Fr:10AM-11AM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7502368847791, -122.397818031719)
253 253 934655 Anas Goodies Catering 57 Truck 1 197101 03RD ST: MARIN ST to ARTHUR AVE \ CARGO WAY (3201 - 3399) -- EAST -- 3305 03RD ST 4502A002 4502A 200 002 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6018751.714 2098754.754 37.7438311721327 -122.377797368962 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf Mo-Fr:11AM-12PM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7438311721327, -122.377797368962)
292 292 946065 D & T Catering 58 Truck 1 11708000 SCOTT ST: PACIFIC AVE to BROADWAY (2500 - 2599) 2521 SCOTT ST 0961002 0961 225 002 17MFF-0140 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Chicken Bake: Canned Soup: Chili Dog: Corn Dog: Cup of Noodles: Egg Muffins: Hamburgers: Cheeseburgers: Hot Dog: Hot sandwiches: quesadillas: Beverages: Flan: Fruits: Yogurt: Candy: Cookies: Chips: Donuts: Snacks 6001109.10398 2117139.2549900003 37.7933225090245 -122.44011927447399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0140&ExportPDF=1&Filename=17MFF-0140_schedule.pdf Mo-Fr:9AM-10AM   03/09/2017 12:00:00 AM 2017-03-09 1 03/15/2018 12:00:00 AM (37.7933225090245, -122.440119274474)
297 297 934424 John's Catering #5 59 Truck 1 8845101 MASONIC AVE: EWING TER to TURK BLVD (200 - 298) -- EAST -- 270 MASONIC AVE 1111002 1111 229 002 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 5999084.822000001 2111935.384 37.7789185898934 -122.446748796815 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:11AM-12PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7789185898934, -122.446748796815)
329 329 934514 Mike's Catering 64 Truck 1 12068000 STANFORD ST: BRANNAN ST to TOWNSEND ST (1 - 100) Assessors Block 3788/Lot002 3788002 3788 188 002 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015005.151000001 2112394.09 37.7810746780754 -122.391705661167 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0092&ExportPDF=1&Filename=17MFF-0092_schedule.pdf Mo/Mo/Mo/Mo/Mo:7AM-8AM/9AM-11AM;Su/Su/Su/Su/Su:9AM-2PM;Sa/Sa/Sa/Sa/Sa:9AM-3PM;Mo/Mo/Mo/Mo/Mo:11AM-1   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7810746780754, -122.391705661167)
331 331 934455 Liang Bai Ping 63 Truck 1 8630000 MAIN ST: FOLSOM ST to HARRISON ST (300 - 399) 201 FOLSOM ST 3746002 3746 253 002 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015208.50366 2114965.06729 37.7881452832928 -122.39118192026301 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo-Fr:7AM-8AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7881452832928, -122.391181920263)
332 332 934509 Mike's Catering 64 Truck 1 3145000 BROADWAY: BATTERY ST to SANSOME ST (200 - 299) 250 BROADWAY 0142002 0142 254 002 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6012219.674 2118889.65 37.7987549364009 -122.40179879385401 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0092&ExportPDF=1&Filename=17MFF-0092_schedule.pdf Mo-Fr:9AM-10AM/1PM-2PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7987549364009, -122.401798793854)
344 344 934472 Liang Bai Ping 63 Truck 1 13356000 WALLACE AVE: JENNINGS ST to KEITH ST (1500 - 1599) 1500 WALLACE AVE 4829002 4829 261 002 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015315.254 2092594.2759999998 37.726725793811795 -122.389249858027 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo-Fr:10AM-11AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7267257938118, -122.389249858027)
364 364 934532 Quan Catering 67 Truck 1 15086000   3305 03RD ST 4502A002 4502A 200 002 17MFF-0095 APPROVED 5 Cold Truck: Soft drinks: cup cakes: potato chips: cookies: gum: sandwiches (hot & cold): peanuts: muffins: coff (hot & cold): water: juice: yoplait: milk: orange juice: sunflower seeds: can foods: burritos: buscuits: chimichangas: rice krispies 6018751.714 2098754.754 37.7438311721327 -122.377797368962 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0095&ExportPDF=1&Filename=17MFF-0095_schedule.pdf Mo-Fr:7AM-8AM/10AM-12PM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7438311721327, -122.377797368962)
366 366 934524 Quan Catering 67 Truck 1 2476000 CESAR CHAVEZ ST: CONNECTICUT ST to EVANS AVE (1900 - 2099) 2190 CESAR CHAVEZ ST 4324002 4324 195 002 17MFF-0095 APPROVED 5 Cold Truck: Soft drinks: cup cakes: potato chips: cookies: gum: sandwiches (hot & cold): peanuts: muffins: coff (hot & cold): water: juice: yoplait: milk: orange juice: sunflower seeds: can foods: burritos: buscuits: chimichangas: rice krispies 6013011.36 2101203.484 37.7502368847791 -122.397818031719 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0095&ExportPDF=1&Filename=17MFF-0095_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7502368847791, -122.397818031719)
367 367 934529 Quan Catering 67 Truck 1 2826101 BAY SHORE BLVD: VISITACION AVE to SUNNYDALE AVE (2501 - 2599) -- EAST -- 2555 BAY SHORE BLVD 5100002 5100 270 002 17MFF-0095 APPROVED 5 Cold Truck: Soft drinks: cup cakes: potato chips: cookies: gum: sandwiches (hot & cold): peanuts: muffins: coff (hot & cold): water: juice: yoplait: milk: orange juice: sunflower seeds: can foods: burritos: buscuits: chimichangas: rice krispies 6010877.081 2086365.3769999999 37.7093754640014 -122.404154378509 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0095&ExportPDF=1&Filename=17MFF-0095_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7093754640014, -122.404154378509)
369 369 947813 Park's Catering 66 Truck 1 202101 03RD ST: EVANS AVE to FAIRFAX AVE (3801 - 3899) -- EAST -- 3801 03RD ST 5242002 5242 271 002 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6015841.555 2097791.762 37.7410262077887 -122.387792927994 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7410262077887, -122.387792927994)
392 392 947819 Park's Catering 66 Truck 1 5329000 EVANS AVE: HUNTERS POINT BLVD to JENNINGS ST \ MIDDLE POINT RD (1031 - 1099) 1000 EVANS AVE 4580002 4580 187 002 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6019061.11822 2096525.4056 37.7377268665958 -122.376572914573 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:11AM-12PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7377268665958, -122.376572914573)
420 420 934390 Senor Sisig 73 Truck 1 132000 02ND ST: MISSION ST to MINNA ST (100 - 130) 120 02ND ST 3722002 3722 27 002 17MFF-0074 APPROVED 5 Filipino fusion food: taco: burrito: nachos: rice plates 6012781.49 2114784.339 37.787514060738104 -122.399566331429 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0074&ExportPDF=1&Filename=17MFF-0074_schedule.pdf Mo-Fr:11AM-2PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7875140607381, -122.399566331429)
424 424 934403 Philz Coffee Truck 72 Truck 1 8701000 MARINA BLVD: LAGUNA ST to BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST (1 - 99) 15 MARINA BLVD 0446002 0446 294 002 17MFF-0079 APPROVED 5 Hot coffee: iced coffee: hot chocolate: tea: pastries 6003247.31181 2121194.21345 37.804577869090096 -122.43301077434299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0079&ExportPDF=1&Filename=17MFF-0079_schedule.pdf Sa-Su:6AM-8PM   03/14/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.8045778690901, -122.433010774343)
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)
446 446 934518 Scotch Bonnet 80 Truck 1 11543000 SANSOME ST: BUSH ST to PINE ST (100 - 199) 115 SANSOME ST 0268002 0268 306 002 17MFF-0094 APPROVED 5 Jerk chicken: curry chicken: curry goat: curry dhal: Burritos: Fish: Ox tails: rice: beans: veggies. 6012385.284 2116217.3 37.7914265413321 -122.401037856688 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0094&ExportPDF=1&Filename=17MFF-0094_schedule.pdf Fr:6AM-8PM   03/16/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7914265413321, -122.401037856688)
448 448 934491 Steve's Mobile Deli 81 Truck 1 12547201 THE EMBARCADERO: KING ST \ TOWNSEND ST to BRANNAN ST (2 - 28) -- EAST -- 26 THE EMBARCADERO 3714002 3714 308 002 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6014481.146000001 2117181.855 37.79419167647521 -122.393853704254 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:7AM-8AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7941916764752, -122.393853704254)
451 451 949936 San Pancho's Tacos 82 Truck 1 2178101 ALEMANY BLVD: SICKLES AVE to I-280 N ON RAMP \ REGENT ST \ SAN JOSE AVE (3101 - 3155) -- SOUTH -- 3119 ALEMANY BLVD 7146002 7146 311 002 17MFF-0163 APPROVED 5 Tacos: Burritos: Quesadillas: Tortas: Nachos: Hot Dogs:Soda: Water: Fruit Drinks 5996113.792 2086967.583 37.710193019975705 -122.455221906126 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0163&ExportPDF=1&Filename=17MFF-0163_schedule.pdf Sa-Su:7AM-8PM   03/16/2017 12:00:00 AM 2017-03-16 1 03/15/2018 12:00:00 AM (37.7101930199757, -122.455221906126)
485 485 949545 Eva's Catering 89 Truck 1 5340000 EVANS AVE: NAPOLEON ST \ TOLAND ST to MARIN ST (2000 - 2099) 2045 EVANS AVE 4343002 4343 101 002 17MFF-0162 APPROVED 5 Cold Truck: Burrito: Corn Dog: Salads: Sandwiches: Quesadilla: Tacos: Fried Rice: Cow Mein: Chinese Rice: Noodle Plates: Soup: Bacon: Eggs: Ham: Avacado: Sausages: Beverages 6013220.459 2100301.58 37.7477720916075 -122.397031718978 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0162&ExportPDF=1&Filename=17MFF-0162_schedule.pdf Su:10AM-2PM   03/22/2017 12:00:00 AM 2017-03-15 1 03/15/2018 12:00:00 AM (37.7477720916075, -122.397031718978)
510 510 934790 Natan's Catering 100 Truck 1 5340000 EVANS AVE: NAPOLEON ST \ TOLAND ST to MARIN ST (2000 - 2099) 2045 EVANS AVE 4343002 4343 101 002 17MFF-0123 APPROVED 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6013220.459 2100301.58 37.7477720916075 -122.397031718978 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7477720916075, -122.397031718978)
523 523 934799 Natan's Catering 100 Truck 1 381000 07TH ST: HOOPER ST to IRWIN ST (1100 - 1199) 1140 07TH ST 3820002 3820 352 002 17MFF-0123 APPROVED 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6012967.316000001 2107764.443 37.7682493867935 -122.39843065021401 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7682493867935, -122.398430650214)
542 542 934812 Natan's Catering 100 Truck 1 1400001 25TH ST: MARYLAND ST to MICHIGAN ST (400 - 699) Assessors Block 4241/Lot002 4241002 4241 364 002 17MFF-0123 APPROVED 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6016991.219 2102253.193 37.7533400011811 -122.384128384237 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7533400011811, -122.384128384237)
555 555 934374 Two G's Catering 103 Truck 1 2863000 BEALE ST: DAVIS ST \ MARKET ST \ PINE ST to MISSION ST (1 - 99) 30 BEALE ST 3710002 3710 92 002 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 6013516.114 2116322.014 37.791777078364206 -122.397132524462 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:7AM-9AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7917770783642, -122.397132524462)
570 570 963978 Singh Brothers Ice Cream 105 Truck 1 6961000 HOLLISTER AVE: HAWES ST to INGALLS ST (1000 - 1099) 1000 HOLLISTER AVE 4943002 4943 375 002 17MFF-0182 REQUESTED 1 Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA 6014891.341 2089767.246 37.7189398190959 -122.390517872066 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf Mo-Fr:12PM-1PM     2017-04-18 1 03/15/2018 12:00:00 AM (37.7189398190959, -122.390517872066)
572 572 963994 Singh Brothers Ice Cream 105 Truck 1 7223000 INGALLS ST: GEORGE CT to OAKDALE AVE (1300 - 1399) 1309 INGALLS ST 4714002 4714 377 002 17MFF-0182 REQUESTED 1 Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA 6017478.204 2093879.426 37.7303742378628 -122.38186187865699 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf Mo-Fr:4PM-5PM     2017-04-18 1 03/15/2018 12:00:00 AM (37.7303742378628, -122.381861878657)
579 579 963982 Singh Brothers Ice Cream 105 Truck 1 7819000 KEY AVE: JENNINGS ST to 03RD ST (1000 - 1068) 1060 KEY AVE 4994002 4994 382 002 17MFF-0182 REQUESTED 1 Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA 6013314.667 2089893.9819999998 37.7192002177133 -122.395976731096 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf Mo-Fr:1PM-2PM     2017-04-18 1 03/15/2018 12:00:00 AM (37.7192002177133, -122.395976731096)
596 596 953322 The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 Push Cart 2 12195000 STOCKTON ST: OFARRELL ST to GEARY ST (100 - 199) 101 STOCKTON ST 0314002 0314 298 002 17MFF-0170 APPROVED 5 Soft Pretzels: hot dogs: sausage: chips: popcorn: soda: espresso: cappucino: pastries: ice cream: italian sausages: shish-ka-bob: churros: juice: water: various drinks 6010660.159 2114587.863 37.786856111883104 -122.406891892997 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0170&ExportPDF=1&Filename=17MFF-0170_schedule.pdf Mo-Su:6AM-9PM   05/09/2017 12:00:00 AM 2017-03-22 1 03/15/2018 12:00:00 AM (37.7868561118831, -122.406891892997)
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)
629 629 850007 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 2754000 BATTERY ST: CALIFORNIA ST to HALLECK ST (200 - 230) 225 BATTERY ST 0238002 0238 34 002 16MFF-0123 APPROVED 5 Rotisserie Chicken; Ribs; Pork Loin; Roasted Potatoes; Chicken Wrap; Kale Salad; Drinks 6012600.766 2116948.597 37.7934465278161 -122.400343675592 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0123&ExportPDF=1&Filename=16MFF-0123_schedule.pdf Mo/We/Fr:9AM-3PM   02/24/2017 12:00:00 AM 2016-05-18 0 03/15/2018 12:00:00 AM (37.7934465278161, -122.400343675592)
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)
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)

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