Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, cnn, LocationDescription, Address, blocklot, block, lot, permit, Status, FoodItems, X, Y, Latitude, Longitude, Schedule, dayshours, Approved, PriorPermit, ExpirationDate, Location
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139 | 139 | 934362 | Mob Dog 44 | Push Cart 2 | 8745201 | MARKET ST: 03RD ST \ KEARNY ST to GRANT AVE \ OFARRELL ST (700 - 748) -- NORTH -- | 720 MARKET ST | 0312004 | 0312 116 | 004 | 17MFF-0068 | REQUESTED 1 | Hot Dogs: Chips: Bottled Drinks | 6011475.041 | 2114841.614 | 37.7875984155546 | -122.404090439434 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0068&ExportPDF=1&Filename=17MFF-0068_schedule.pdf | Th/Fr/Sa:8AM-10PM | 2017-02-13 | 0 | 05/06/2018 12:00:00 AM | (37.7875984155546, -122.404090439434) | ||
170 | 170 | 934559 | The Sandwich Stand, LLC. 45 | Push Cart 2 | 8627000 | MAIN ST: MARKET ST to MISSION ST (1 - 99) | 58 MAIN ST | 3711005 | 3711 142 | 005 | 17MFF-0108 | REQUESTED 1 | Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. | 6013902.41 | 2116435.193 | 37.792109338609 | -122.39580386550199 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0108&ExportPDF=1&Filename=17MFF-0108_schedule.pdf | Mo-Fr:8AM-5PM | 2017-02-13 | 0 | 05/02/2018 12:00:00 AM | (37.792109338609, -122.395803865502) | ||
188 | 188 | 934356 | Leo's Hot Dogs 50 | Push Cart 2 | 9121000 | MISSION ST: 19TH ST to 20TH ST (2300 - 2399) | 2301 MISSION ST | 3595031 | 3595 156 | 031 | 17MFF-0067 | APPROVED 5 | Hot dogs and related toppings: non alcoholic beverages | 6007018.02 | 2104913.057 | 37.760086931987 | -122.418806481101 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0067&ExportPDF=1&Filename=17MFF-0067_schedule.pdf | Mo-Su:6PM-12AM | 02/22/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.760086931987, -122.418806481101) | |
370 | 370 | 934544 | San Francisco Street Foods, Inc. 68 | Push Cart 2 | 7038000 | HOWARD ST: 03RD ST to 04TH ST (700 - 799) | 701 HOWARD ST | 3734091 | 3734 272 | 091 | 17MFF-0100 | 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. | 6012391.612000001 | 2113335.21 | 37.7835133512454 | -122.400813391105 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0100&ExportPDF=1&Filename=17MFF-0100_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.7835133512454, -122.400813391105) | |
376 | 376 | 934543 | San Francisco Street Foods, Inc. 68 | Push Cart 2 | 30049000 | DRUMM ST: CALIFORNIA ST intersection | 5 THE EMBARCADERO | 0234 017 | 0234 20 | 017 | 17MFF-0099 | 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. | 6013916.72 | 2117244.027 | 37.794331003246796 | -122.395811053023 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0099&ExportPDF=1&Filename=17MFF-0099_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.7943310032468, -122.395811053023) | |
377 | 377 | 934712 | Halal Cart, LLC 31 | Push Cart 2 | 9301000 | MONTGOMERY ST: CALIFORNIA ST to SACRAMENTO ST (400 - 499) | 400 MONTGOMERY ST | 0239009 | 0239 81 | 009 | 17MFF-0116 | APPROVED 5 | kebabs: halal gyro: grilled halal meat: refreshments | 6011956.214 | 2116853.2 | 37.7931486269835 | -122.402567175578 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0116&ExportPDF=1&Filename=17MFF-0116_schedule.pdf | Mo/We/Fr:10AM-3PM | 03/13/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7931486269835, -122.402567175578) | |
381 | 381 | 934709 | Halal Cart, LLC 31 | Push Cart 2 | 8741101 | MARKET ST: FREMONT ST \ FRONT ST to 01ST ST \ BUSH ST (401 - 499) -- SOUTH -- | 455 MARKET ST | 3709012 | 3709 279 | 012 | 17MFF-0114 | APPROVED 5 | Gyros: Kebabs: soft drinks: and water | 6013076.33 | 2116028.637 | 37.790947041923395 | -122.39863358940399 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0114&ExportPDF=1&Filename=17MFF-0114_schedule.pdf | Mo-Su:10AM-8PM | 03/13/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7909470419234, -122.398633589404) | |
396 | 396 | 934713 | Halal Cart, LLC 31 | Push Cart 2 | 8737101 | MARKET ST: STEUART ST to SPEAR ST (1 - 99) -- SOUTH -- | 1 MARKET ST | 3713006 | 3713 79 | 006 | 17MFF-0116 | APPROVED 5 | kebabs: halal gyro: grilled halal meat: refreshments | 6014186.566000001 | 2117071.214 | 37.793871507150605 | -122.39486523862101 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0116&ExportPDF=1&Filename=17MFF-0116_schedule.pdf | Tu/Th/Fr:9AM-3PM | 03/13/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7938715071506, -122.394865238621) | |
398 | 398 | 934545 | San Francisco Street Foods, Inc. 68 | Push Cart 2 | 11222000 | SACRAMENTO ST: FRONT ST to BATTERY ST (300 - 399) | 1 THE EMBARCADERO | 0230028 | 0230 283 | 028 | 17MFF-0101 | 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. | 6012811.658 | 2117380.371 | 37.7946438346195 | -122.399644298529 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0101&ExportPDF=1&Filename=17MFF-0101_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.7946438346195, -122.399644298529) | |
402 | 402 | 934393 | Creme Brulee To Go 71 | Push Cart 2 | 8747202 | MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- | 870 MARKET ST | 0329005 | 0329 286 | 005 | 17MFF-0076 | APPROVED 5 | Kettle Corn: Pizza: Coffee: Lattes: Cappuchino: Expresso: Hot Tea | 6010493.859 | 2113955.6580000003 | 37.7851109204478 | -122.407422668277 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0076&ExportPDF=1&Filename=17MFF-0076_schedule.pdf | Mo-Fr:8AM-7PM;Sa-Su:11AM-7PM | 03/13/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7851109204478, -122.407422668277) | |
463 | 463 | 934432 | The Chai Cart 17 | Push Cart 2 | 8742101 | MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | 525 MARKET ST | 3708056 | 3708 4 | 056 | 17MFF-0086 | APPROVED 5 | Hot Indian Chai | 6012886.778 | 2115835.7 | 37.7904067199405 | -122.399275886086 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf | Mo-Fr:8AM-4PM | 03/17/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7904067199405, -122.399275886086) | |
464 | 464 | 934431 | The Chai Cart 17 | Push Cart 2 | 13060000 | VALENCIA ST: 16TH ST to 17TH ST (500 - 599) | 560 VALENCIA ST | 3568009 | 3568 317 | 009 | 17MFF-0086 | APPROVED 5 | Hot Indian Chai | 6006099.355 | 2106305.353 | 37.7638580813603 | -122.42208262099301 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0086&ExportPDF=1&Filename=17MFF-0086_schedule.pdf | Sa-Su:9AM-4PM | 03/17/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7638580813603, -122.422082620993) | |
465 | 465 | 934430 | The Chai Cart 17 | Push Cart 2 | 8739201 | MARKET ST: MAIN ST to BEALE ST \ DAVIS ST \ PINE ST (214 - 298) -- NORTH -- | 298 MARKET ST | 0264004 | 0264 30 | 004 | 17MFF-0085 | APPROVED 5 | Indian Chai (Tea) | 6013552.57 | 2116844.5 | 37.7932137316634 | -122.397043036718 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0085&ExportPDF=1&Filename=17MFF-0085_schedule.pdf | Mo-Su:7AM-6PM | 03/17/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7932137316634, -122.397043036718) | |
496 | 496 | 934394 | Creme Brulee To Go 71 | Push Cart 2 | 8747102 | MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- | 801 MARKET ST | 3705Z001 | 3705Z 333 | 001 | 17MFF-0077 | APPROVED 5 | Steak and chicken kebob:Steak and chicken kebob sandwiches:chicken teriyaki:chicken teriyaki sandwiches:garden salad side:grilled chicken burger: ground beef burgers: white rice side: canned drinks: and chips | 6010997.43389 | 2113901.46037 | 37.784990279306506 | -122.405676629072 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0077&ExportPDF=1&Filename=17MFF-0077_schedule.pdf | Mo-Su:11AM-7PM | 03/24/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7849902793065, -122.405676629072) | |
503 | 503 | 934716 | Kettle Corn Star 97 | Push Cart 2 | 8746103 | MARKET ST: YERBA BUENA LN to 04TH ST \ ELLIS ST \ STOCKTON ST (767 - 799) -- SOUTH -- | 773 MARKET ST | 3706096 | 3706 338 | 096 | 17MFF-0120 | APPROVED 5 | Kettle Corn: Funnel Cakes: Lemonade: Beverages: Flan: Hot Dogs: Falafel: Hot and Cold Sandwiches: French Fries: Baklava and Pastries | 6011371.872269999 | 2114041.46827 | 37.7853956394405 | -122.40439104283001 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0120&ExportPDF=1&Filename=17MFF-0120_schedule.pdf | Mo-Su:10AM-6PM | 03/30/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7853956394405, -122.40439104283) | |
505 | 505 | 934715 | Kettle Corn Star 97 | Push Cart 2 | 8747103 | MARKET ST: POWELL ST to 05TH ST \ CYRIL MAGNIN ST (865 - 899) -- SOUTH -- | 865 MARKET ST | 3705 042 | 3705 340 | 042 | 17MFF-0118 | APPROVED 5 | Kettle Corn: Funnel Cakes: Waffles: Lemonade | 6010561.591 | 2113530.347 | 37.783946907974205 | -122.407158344984 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0118&ExportPDF=1&Filename=17MFF-0118_schedule.pdf | Mo-Su:10AM-6PM | 03/30/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7839469079742, -122.407158344984) | |
592 | 592 | 934558 | The Sandwich Stand, LLC. 45 | Push Cart 2 | 24685000 | SANSOME ST: CALIFORNIA ST intersection | 351 CALIFORNIA ST | 0261010A | 0261 37 | 010A | 17MFF-0107 | INACTIVE 3 | Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. | 6012479.848999999 | 2116741.356 | 37.7928707497415 | -122.400747494077 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0107&ExportPDF=1&Filename=17MFF-0107_schedule.pdf | Tu/We:8AM-5PM | 2017-02-13 | 0 | 05/02/2018 12:00:00 AM | (37.7928707497415, -122.400747494077) | ||
594 | 594 | 934556 | The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 | Push Cart 2 | 24892000 | STOCKTON ST: 04TH ST \ ELLIS ST \ MARKET ST intersection | 800 MARKET ST | 0329001 | 0329 286 | 001 | 17MFF-0105 | APPROVED 5 | Soft pretzels: hot dogs: sausages: chips: popcorn: sodea: coffee: espresso: cappucino: pastries: ice cream: Italian sausages: shish-ka-bob: churros: juice: water: various drinks. | 6010729.654 | 2114081.536 | 37.785469746489895 | -122.406615761073 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0105&ExportPDF=1&Filename=17MFF-0105_schedule.pdf | Mo-Su:6AM-9PM | 05/05/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7854697464899, -122.406615761073) | |
595 | 595 | 934557 | The New York Frankfurter Co. of CA, Inc. DBA: Annie's Hot Dogs 109 | Push Cart 2 | 8747202 | MARKET ST: 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (800 - 890) -- NORTH -- | 870 MARKET ST | 0329005 | 0329 286 | 005 | 17MFF-0106 | APPROVED 5 | Soft pretzels: hot dogs: sausages: chips: popcorn: soda: espresso: cappucino: pastry: ica cream: ices: italian sausage: shish-ka-bob: churros: juice: water: various drinks | 6010493.859 | 2113955.6580000003 | 37.7851109204478 | -122.407422668277 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0106&ExportPDF=1&Filename=17MFF-0106_schedule.pdf | Mo-Su:6AM-9PM | 05/09/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7851109204478, -122.407422668277) | |
605 | 605 | 934371 | Taza Halal Cart 4 | Push Cart 2 | 8742202 | MARKET ST: BATTERY ST to SUTTER ST (540 - 558) -- NORTH -- | 532 MARKET ST | 0290012 | 0290 16 | 012 | 17MFF-0072 | ONHOLD 6 | Chicken Gyro: Lamb Gyro: Chiken Gyro Plate: Lamb Gyro Plate: Combination Gyro Plate. | 6012582.227999999 | 2115893.453 | 37.790548318183205 | -122.40033367367901 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0072&ExportPDF=1&Filename=17MFF-0072_schedule.pdf | Mo-We:9AM-8PM | 2017-02-13 | 0 | 06/29/2018 12:00:00 AM | (37.7905483181832, -122.400333673679) |
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");