Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, cnn, LocationDescription, block, lot, Status, FoodItems, dayshours, Approved, Received, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | 526417 | The Creme Brulee Cart 14 | Push Cart 2 | 8742201 | MARKET ST: 01ST ST \ BUSH ST to BATTERY ST (500 - 538) -- NORTH -- | 532 MARKET ST | 0290012 | 0290 16 | 012 | 14MFF-0056 | EXPIRED 2 | Creme Brulee | 6012582.227999999 | 2115893.453 | 37.790548318183205 | -122.40033367367901 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=14MFF-0056&ExportPDF=1&Filename=14MFF-0056_schedule.pdf | Mo-Su:11AM-9PM | 03/14/2014 12:00:00 AM | 2014-03-14 | 1 | 03/15/2015 12:00:00 AM | (37.7905483181832, -122.400333673679) | |
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) | |
433 | 433 | 946375 | San Francisco Carts & Concessions, Inc. DBA Stanley's Steamers Hot Dogs 75 | Push Cart 2 | 6108000 | GEARY ST: GRANT AVE to STOCKTON ST (100 - 199) | 100 GEARY ST | 0309003 | 0309 24 | 003 | 17MFF-0144 | 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. | 6011136.441000001 | 2114963.525 | 37.7879142297241 | -122.405270523095 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0144&ExportPDF=1&Filename=17MFF-0144_schedule.pdf | Mo-Su:6AM-12AM | 03/14/2017 12:00:00 AM | 2017-03-10 | 1 | 03/15/2018 12:00:00 AM | (37.7879142297241, -122.405270523095) | |
435 | 435 | 948140 | Eli's Hot Dogs 78 | Push Cart 2 | 7504000 | JERROLD AVE: BARNEVELD AVE to END (2351 - 2369) | 101 BAY SHORE BLVD | 5559018 | 5559 46 | 018 | 17MFF-0155 | REQUESTED 1 | various styles of hot dogs & sausages: chips: breakfast sandwiches: chili: soda: water: | 6011376.107000001 | 2100039.012 | 37.7469482955131 | -122.40339096031299 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0155&ExportPDF=1&Filename=17MFF-0155_schedule.pdf | Mo/Tu/We/Th/Fr:9AM-5PM | 2017-03-14 | 1 | 03/15/2017 12:00:00 AM | (37.7469482955131, -122.403390960313) | ||
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) | |
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) | |
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) | |
416 | 416 | 944213 | San Francisco Street Foods, Inc. 68 | Push Cart 2 | 10625000 | POST ST: KEARNY ST to ROBERT KIRK LN (100 - 140) | 100 POST ST | 0294004 | 0294 290 | 004 | 17MFF-0128 | 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. | 6011057.082 | 2115445.537 | 37.789233282896106 | -122.40557905421001 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0128&ExportPDF=1&Filename=17MFF-0128_schedule.pdf | Mo-Su:6AM-12AM | 03/13/2017 12:00:00 AM | 2017-03-01 | 1 | 03/15/2018 12:00:00 AM | (37.7892332828961, -122.40557905421) | |
425 | 425 | 946358 | San Francisco Carts & Concessions, Inc. DBA Stanley's Steamers Hot Dogs 75 | Push Cart 2 | 10628000 | POST ST: STOCKTON ST to POWELL ST (300 - 399) | 345 STOCKTON ST | 0295016 | 0295 295 | 016 | 17MFF-0142 | 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. | 6010587.529 | 2115337.419 | 37.7889101495704 | -122.40719603412201 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0142&ExportPDF=1&Filename=17MFF-0142_schedule.pdf | Mo-Su:6AM-12AM | 03/14/2017 12:00:00 AM | 2017-03-10 | 1 | 03/15/2018 12:00:00 AM | (37.7889101495704, -122.407196034122) | |
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¶ms=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) | |
429 | 429 | 946474 | San Francisco Carts & Concessions, Inc. DBA Stanley's Steamers Hot Dogs 75 | Push Cart 2 | 6109000 | GEARY ST: STOCKTON ST to POWELL ST (200 - 299) | 251 GEARY ST | 0314014 | 0314 298 | 014 | 17MFF-0146 | 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. | 6010516.291 | 2114707.404 | 37.7871762917416 | -122.407398075958 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0146&ExportPDF=1&Filename=17MFF-0146_schedule.pdf | Mo-Su:6AM-12AM | 03/14/2017 12:00:00 AM | 2017-03-10 | 1 | 03/15/2018 12:00:00 AM | (37.7871762917416, -122.407398075958) | |
432 | 432 | 946402 | San Francisco Carts & Concessions, Inc. DBA Stanley's Steamers Hot Dogs 75 | Push Cart 2 | 6109000 | GEARY ST: STOCKTON ST to POWELL ST (200 - 299) | 233 GEARY ST | 0314001 | 0314 298 | 001 | 17MFF-0145 | 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. | 6010666.538 | 2114728.492 | 37.787242602596706 | -122.40687973821301 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0145&ExportPDF=1&Filename=17MFF-0145_schedule.pdf | Mo-Su:6AM-12AM | 03/14/2017 12:00:00 AM | 2017-03-10 | 1 | 03/15/2018 12:00:00 AM | (37.7872426025967, -122.406879738213) | |
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¶ms=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) | |
618 | 618 | 1007144 | Bay Area Dots, LLC 119 | Push Cart 2 | 25524000 | TAYLOR ST: BAY ST intersection | 567 BAY ST | 0043001 | 0043 395 | 001 | 17MFF-0188 | 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. | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0188&ExportPDF=1&Filename=17MFF-0188_schedule.pdf | Mo-Su:6AM-12AM | 08/14/2017 12:00:00 AM | 2017-08-09 | 1 | 03/15/2018 12:00:00 AM | (0, 0) | |||
620 | 620 | 1007163 | Bay Area Dots, LLC 119 | Push Cart 2 | 2846000 | BEACH ST: HYDE ST to LARKIN ST (700 - 799) | 900 BEACH ST | 0405007 | 0405 396 | 007 | 17MFF-0189 | APPROVED 5 | Hot dogs: condiments: soft pretzels: soft drinks: coffee:cold beverages: pastries: bakery goods: cookies: icecream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. | 6005830.4143900005 | 2122293.82162 | 37.8077432884455 | -122.42414994487 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0189&ExportPDF=1&Filename=17MFF-0189_schedule.pdf | Mo-Su:6AM-12AM | 08/14/2017 12:00:00 AM | 2017-08-09 | 1 | 03/15/2018 12:00:00 AM | (37.8077432884455, -122.42414994487) |
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");