Mobile_Food_Facility_Permit

Data source: data.sfgov.org

49 rows where Approved = "03/10/2017 12:00:00 AM"

View and edit SQL

Suggested facets: Applicant, lot, permit, FoodItems, Schedule, dayshours, Received, PriorPermit, 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
302 934482 Liang Bai Ping 63 Truck 1 13780000 YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1430 YOSEMITE AVE 4831008 4831 32 008 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015560.891 2092142.1819999998 37.7254980479505 -122.388369150442 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:12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7254980479505, -122.388369150442)
315 934477 Liang Bai Ping 63 Truck 1 12570000 THOMAS AVE: HAWES ST to INGALLS ST (1200 - 1299) 1265 THOMAS AVE 4807012 4807 244 012 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6016458.774 2092565.342 37.7267096753687 -122.385294691187 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7267096753687, -122.385294691187)
316 934478 Liang Bai Ping 63 Truck 1 10972000 REVERE AVE: GRIFFITH ST to CRISP RD (1100 - 1188) 1160 REVERE AVE 4763050 4763 245 050 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017468.62 2092735.9719999998 37.7272340074959 -122.38181551187 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7272340074959, -122.38181551187)
317 934507 Mike's Catering 64 Truck 1 15024000 CHINA BASIN ST: TERRY A FRANCOIS BLVD to 03RD ST (300 - 499) 435 CHINA BASIN ST 8720001 8720 246 001 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks     0.0 0.0 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:11AM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
318 934462 Liang Bai Ping 63 Truck 1 11782000 SHAFTER AVE: GRIFFITH ST to HAWES ST (1100 - 1199) 1127 SHAFTER AVE 4793017 4793 247 017 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017324.545 2092269.6269999999 37.7259455580465 -122.382281153253 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:8AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7259455580465, -122.382281153253)
319 934505 Mike's Catering 64 Truck 1 9059000 MINNESOTA ST: 24TH ST to 25TH ST (1300 - 1399) 1310 MINNESOTA ST 4228129 4228 73 129 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015276.93755 2102418.8382900003 37.7536998999438 -122.390068346908 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:10AM-11AM/1PM-2PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7536998999438, -122.390068346908)
320 934511 Mike's Catering 64 Truck 1 15024000 CHINA BASIN ST: TERRY A FRANCOIS BLVD to 03RD ST (300 - 499) Assessors Block 8720/Lot009 8720009 8720 246 009 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6016084.592999999 2109122.779 37.7721522432444 -122.387742984116 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.7721522432444, -122.387742984116)
321 934456 Liang Bai Ping 63 Truck 1 4908000 DONNER AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1475 CARROLL AVE 4882026 4882 248 026 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6014733.709 2091343.759 37.7232598663241 -122.39117288596901 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.7232598663241, -122.391172885969)
322 934459 Liang Bai Ping 63 Truck 1 10972000 REVERE AVE: GRIFFITH ST to CRISP RD (1100 - 1188) 1145 REVERE AVE 4786077 4786 249 077 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017482.212 2092501.331 37.7265904795194 -122.381752211406 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.7265904795194, -122.381752211406)
323 943986 Expresso Subito, LLC. 65 Truck 1 5869000 FRONT ST: CALIFORNIA ST to HALLECK ST (200 - 234) 150 CALIFORNIA ST 0236019 0236 118 019 17MFF-0127 APPROVED 5 Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. 6013145.602999999 2117020.1569999997 37.7936733815047 -122.398463509486 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0127&ExportPDF=1&Filename=17MFF-0127_schedule.pdf Mo-Fr:6AM-5PM   03/10/2017 12:00:00 AM 2017-02-28 0 03/15/2018 12:00:00 AM (37.7936733815047, -122.398463509486)
324 934468 Liang Bai Ping 63 Truck 1 13139000 VAN DYKE AVE: INGALLS ST to JENNINGS ST (1300 - 1399) 1337 VAN DYKE AVE 4828029 4828 250 029 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015726.539 2092412.506 37.726249481798604 -122.38781536801399 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:9AM-10AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7262494817986, -122.387815368014)
325 934457 Liang Bai Ping 63 Truck 1 13780000 YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1420 YOSEMITE AVE 4831012 4831 32 012 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015609.592 2092025.9880000001 37.7251817007288 -122.38819268844401 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.7251817007288, -122.388192688444)
326 934475 Liang Bai Ping 63 Truck 1 7479000 JENNINGS ST: VAN DYKE AVE to WALLACE AVE (2100 - 2199) 2115 JENNINGS ST 4828021 4828 250 021 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015486.282000001 2092591.619 37.7267279782571 -122.388658428832 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.7267279782571, -122.388658428832)
327 934464 Liang Bai Ping 63 Truck 1 6542000 GRIFFITH ST: SHAFTER AVE to THOMAS AVE (1500 - 1599) 1515 GRIFFITH ST 4794009 4794 251 009 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017577.871 2092036.503 37.7253194336755 -122.381389209427 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo/Mo/Tu/Tu/We:8AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7253194336755, -122.381389209427)
328 934483 Liang Bai Ping 63 Truck 1 9743000 OFARRELL ST: BRODERICK ST to SAINT JOSEPHS AVE (2200 - 2299) 2200 OFARRELL ST 1098044 1098 252 044 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages     0.0 0.0 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:12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
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)
330 934454 Liang Bai Ping 63 Truck 1 2866000 BEALE ST: FOLSOM ST to HARRISON ST (300 - 399) 300 BEALE ST 3747022 3747 162 022 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6014804.68 2114971.1180000002 37.78813947887161 -122.392579515374 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:6AM-7AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7881394788716, -122.392579515374)
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 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)
333 934506 Mike's Catering 64 Truck 1 2477000 CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) 2200 CESAR CHAVEZ ST 4327A007 4327A 255 007 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6012474.0479999995 2101145.897 37.750048825970396 -122.39967205970899 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7500488259704, -122.399672059709)
334 934466 Liang Bai Ping 63 Truck 1 12827000 UNDERWOOD AVE: INGALLS ST to JENNINGS ST (1300 - 1399) 1351 UNDERWOOD AVE 4811005 4811 256 005 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015824.1110000005 2092689.211 37.7270146636245 -122.387497359022 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:9AM-10AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7270146636245, -122.387497359022)
335 934484 Liang Bai Ping 63 Truck 1 5452000 FELL ST: BRODERICK ST to BAKER ST (1300 - 1399) 1377 FELL ST 1214017 1214 257 017 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6000983.009 2109845.279 37.7732879404704 -122.440032316635 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:1PM-3PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7732879404704, -122.440032316635)
336 934479 Liang Bai Ping 63 Truck 1 10972000 REVERE AVE: GRIFFITH ST to CRISP RD (1100 - 1188) 1135 REVERE AVE 4786051 4786 249 051 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017542.344 2092456.505 37.726470716246 -122.381541219158 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.726470716246, -122.381541219158)
337 934480 Liang Bai Ping 63 Truck 1 10808000 QUESADA AVE: ARELIOUS WALKER DR to GRIFFITH ST (1000 - 1099) 1031 QUESADA AVE 4764 001 4764 258 001 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6018280.0479999995 2092193.457 37.7257891398124 -122.378972719624 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7257891398124, -122.378972719624)
338 934471 Liang Bai Ping 63 Truck 1 2709000 BANCROFT AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1460 BANCROFT AVE 4850038 4850 259 038 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015035.87862 2091757.7046599998 37.7244132432963 -122.390157239611 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:9AM-10AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7244132432963, -122.390157239611)
339 934510 Mike's Catering 64 Truck 1 7198000 INDIANA ST: 23RD ST to 25TH ST \ I-280 N ON RAMP (1200 - 1399) Assessors Block 4228/Lot080 4228080 4228 73 080 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015176.72777 2102413.60751 37.7536799789675 -122.390414532294 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.7536799789675, -122.390414532294)
340 934467 Liang Bai Ping 63 Truck 1 12570000 THOMAS AVE: HAWES ST to INGALLS ST (1200 - 1299) 1212 THOMAS AVE 4792029 4792 260 029 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6016791.102999999 2092542.294 37.7266647697066 -122.384144224606 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:9AM-10AM/12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7266647697066, -122.384144224606)
341 934502 Mike's Catering 64 Truck 1 7200000 INDIANA ST: 26TH ST to CESAR CHAVEZ ST (1500 - 1599) 1575 INDIANA ST 4317017 4317 201 017 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015267.752 2101380.964 37.7508496068125 -122.390027615501 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:7AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7508496068125, -122.390027615501)
342 934485 Liang Bai Ping 63 Truck 1 6540000 GRIFFITH ST: QUESADA AVE to REVERE AVE (1300 - 1399) 1300 GRIFFITH ST 4763047 4763 245 047 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017681.819 2092678.013 37.727086633951394 -122.381074448749 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:6AM-7AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7270866339514, -122.381074448749)
343 934481 Liang Bai Ping 63 Truck 1 10215000 PALOU AVE: END to GRIFFITH ST (904 - 999) Assessors Block /Lot       17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo/Mo/Mo/Mo/Mo:5AM-6AM/11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
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)
345 934391 Expresso Subito, LLC. 65 Truck 1 3525000 CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199) 150 CALIFORNIA ST 0236019 0236 118 019 17MFF-0075 APPROVED 5 Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. 6013145.602999999 2117020.1569999997 37.7936733815047 -122.398463509486 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0075&ExportPDF=1&Filename=17MFF-0075_schedule.pdf Tu/Th:6AM-8PM   03/10/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7936733815047, -122.398463509486)
346 934473 Liang Bai Ping 63 Truck 1 13355000 WALLACE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1450 WALLACE AVE 4828024 4828 250 024 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015606.538 2092377.128 37.7261456924729 -122.38822774090299 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.7261456924729, -122.388227740903)
347 934392 Expresso Subito, LLC. 65 Truck 1 9091000 MISSION ST: ANTHONY ST to 02ND ST (573 - 599) 85 02ND ST 3708019 3708 4 019 17MFF-0075 APPROVED 5 Expresso drinks: assorted beverages (canned: bottled: home made): scones: croissants: bagels: soup: chili: parfaits: smoothies: frappes: milk shakes. 6012696.635 2115129.488 37.788457028828894 -122.399884160566 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0075&ExportPDF=1&Filename=17MFF-0075_schedule.pdf     03/10/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7884570288289, -122.399884160566)
348 934513 Mike's Catering 64 Truck 1 3157000 BROADWAY: POWELL ST \ ROBERT C LEVY TUNL to MASON ST (800 - 898) -- NORTH -- 860 BROADWAY 0148009 0148 262 009 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6009425.916 2118518.297 37.7975789880604 -122.411439886089 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0092&ExportPDF=1&Filename=17MFF-0092_schedule.pdf Mo/Tu/We/Th/Fr:7AM-8AM;Mo/Mo/Tu/Tu/We:9AM-11AM;Su:9AM-2PM;Sa:9AM-3PM;Mo/Mo/Tu/Tu/We:11AM-1PM;Mo-Fr:   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7975789880604, -122.411439886089)
349 934460 Liang Bai Ping 63 Truck 1 13139000 VAN DYKE AVE: INGALLS ST to JENNINGS ST (1300 - 1399) 1370 VAN DYKE AVE 4811013 4811 256 013 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015684.098999999 2092668.764 37.7269507643782 -122.387979956262 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:8AM-9AM/12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7269507643782, -122.387979956262)
350 934463 Liang Bai Ping 63 Truck 1 12569000 THOMAS AVE: GRIFFITH ST to HAWES ST (1100 - 1199) 1180 THOMAS AVE 4793029 4793 247 029 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017060.368 2092340.381 37.726125239645 -122.383199327239 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:8AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.726125239645, -122.383199327239)
351 934504 Mike's Catering 64 Truck 1 1232000 23RD ST: END to ILLINOIS ST (100 - 699) 435 23RD ST 4232010 4232 158 010 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6016887.317000001 2102871.037 37.7550307267667 -122.384530734223 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   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7550307267667, -122.384530734223)
352 934508 Mike's Catering 64 Truck 1 7165000 ILLINOIS ST: 16TH ST to MARIPOSA ST \ TERRY A FRANCOIS BLVD (400 - 599) 409 ILLINOIS ST 3940001 3940 263 001 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks     0.0 0.0 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:11AM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
353 934470 Liang Bai Ping 63 Truck 1 2709000 BANCROFT AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1440 BANCROFT AVE 4850019 4850 259 019 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015156.082 2091667.743 37.724172892761295 -122.389735429011 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:9AM-10AM/12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7241728927613, -122.389735429011)
354 934461 Liang Bai Ping 63 Truck 1 12827000 UNDERWOOD AVE: INGALLS ST to JENNINGS ST (1300 - 1399) 1389 UNDERWOOD AVE 4811014 4811 256 014 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015603.925 2092728.532 37.7271104333828 -122.388261288144 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:8AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7271104333828, -122.388261288144)
355 934469 Liang Bai Ping 63 Truck 1 4908000 DONNER AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1450 DONNER AVE 4882025 4882 248 025 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6014749.836 2091269.372 37.723056509338896 -122.39111194064199 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:9AM-10AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7230565093389, -122.391111940642)
356 934503 Mike's Catering 64 Truck 1 2477000 CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) 2323 CESAR CHAVEZ ST 4342001 4342 264 001 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6012210.337 2100696.938 37.7488013777145 -122.400552458785 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:7AM-8AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7488013777145, -122.400552458785)
357 934465 Liang Bai Ping 63 Truck 1 2710000 BANCROFT AVE: JENNINGS ST to KEITH ST (1500 - 1599) 1555 BANCROFT AVE 4880001 4880 265 001 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6014646.012 2091759.86 37.7243975297434 -122.391505116383 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:8AM-9AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7243975297434, -122.391505116383)
358 934476 Liang Bai Ping 63 Truck 1 6792000 HAWES ST: SHAFTER AVE to THOMAS AVE (1500 - 1599) 1153 SHAFTER AVE 4793006 4793 247 006 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017053.425 2092471.602 37.7264851632165 -122.38323245870701 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7264851632165, -122.383232458707)
359 934453 Liang Bai Ping 63 Truck 1 5862000 FREMONT ST: NATOMA ST to HOWARD ST (170 - 199) Assessors Block 3720/Lot001 3720001 3720 26 001 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6013655.829 2115559.5719999997 37.789691367587 -122.396595637084 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo/Mo/Mo/Mo/Mo:5AM-6AM/11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.789691367587, -122.396595637084)
360 934458 Liang Bai Ping 63 Truck 1 13779000 YOSEMITE AVE: HAWES ST to INGALLS ST (1300 - 1399) 1335 YOSEMITE AVE 4846013 4846 266 013 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015941.755 2091544.7959999999 37.7238788408325 -122.387010878785 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/10AM-11AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7238788408325, -122.387010878785)
361 934474 Liang Bai Ping 63 Truck 1 10215000 PALOU AVE: END to GRIFFITH ST (904 - 999) 931 PALOU AVE 4755042 4755 267 042 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6018287.161 2092537.392 37.7267339112416 -122.378972005236 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:9AM-10AM/10AM-11AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7267339112416, -122.378972005236)
362 934512 Mike's Catering 64 Truck 1 12532003 TERRY A FRANCOIS BLVD: MISSION BAY BLVD to MISSION BAY BLVD (0 - 0) Assessors Block 8722/Lot005 8722005 8722 268 005 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6016501.447000001 2108199.438 37.7696400322177 -122.38623665419901 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.7696400322177, -122.386236654199)

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