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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | 848184 | Reecees Soulicious 24 | Truck 1 | 2799106 | BAY SHORE BLVD: END to OAKDALE AVE (185 - 299) -- EAST -- | 201 BAY SHORE BLVD | 5559021 | 5559 46 | 021 | 16MFF-0139 | REQUESTED 1 | Fried Chicken: Fried Fish: Greens: Mac & Cheese: Peach Cobbler: and String beans | 6011355.555 | 2099442.374 | 37.7453089086563 | -122.40342005999901 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0139&ExportPDF=1&Filename=16MFF-0139_schedule.pdf | Mo-We:7AM-7PM | 2016-09-08 | 0 | 03/15/2017 12:00:00 AM | (37.7453089086563, -122.403420059999) | ||
54 | 54 | 848185 | Reecees Soulicious 24 | Truck 1 | 211101 | 03RD ST: NEWCOMB AVE to OAKDALE AVE (4701 - 4799) -- EAST -- | 4705 03RD ST | 5311036 | 5311 47 | 036 | 16MFF-0139 | REQUESTED 1 | Fried Chicken: Fried Fish: Greens: Mac & Cheese: Peach Cobbler: and String beans | 6015109.357999999 | 2095613.38 | 37.7350042289514 | -122.39017246969999 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0139&ExportPDF=1&Filename=16MFF-0139_schedule.pdf | Th/Fr/Sa:7AM-7PM | 2016-09-08 | 0 | 03/15/2017 12:00:00 AM | (37.7350042289514, -122.3901724697) | ||
96 | 96 | 654163 | Maiwand Halal Kabob Truck 39 | Truck 1 | 3529000 | CALIFORNIA ST: LEIDESDORFF ST to MONTGOMERY ST (449 - 499) | 450 CALIFORNIA ST | 0239026 | 0239 81 | 026 | 15MFF-0009 | EXPIRED 2 | Mantu: Balani: Guabili pillow: lamb shank | 6012031.306 | 2116940.665 | 37.793392977019 | -122.40231350368201 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0009&ExportPDF=1&Filename=15MFF-0009_schedule.pdf | Tu/Th/Fr:10AM-2PM | 05/20/2016 12:00:00 AM | 2015-02-24 | 0 | 03/15/2017 12:00:00 AM | (37.793392977019, -122.402313503682) | |
471 | 471 | 654165 | Maiwand Halal Kabob Truck 39 | Truck 1 | 4605000 | DAVIS ST: BEALE ST \ MARKET ST \ PINE ST to CALIFORNIA ST (1 - 99) | 48 DAVIS ST | 0264004 | 0264 30 | 004 | 15MFF-0009 | EXPIRED 2 | Mantu: Balani: Guabili pillow: lamb shank | 6013552.57 | 2116844.5 | 37.7932137316634 | -122.397043036718 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0009&ExportPDF=1&Filename=15MFF-0009_schedule.pdf | Mo/We/Fr:10AM-2PM | 05/20/2016 12:00:00 AM | 2015-02-24 | 0 | 03/15/2017 12:00:00 AM | (37.7932137316634, -122.397043036718) | |
469 | 469 | 767078 | BHUK Burger 86 | Truck 1 | 10390000 | PHELAN AVE: GENEVA AVE \ OCEAN AVE to JUDSON AVE (1 - 199) | 11 PHELAN AVE | 3180001 | 3180 320 | 001 | 16MFF-0076 | EXPIRED 2 | Pakistani Indian food: and salad: cold and hot drinks: Pakistani soft drinks: Sohan halva: Pakistani Indian desserts: and fruit dessert | 5996539.936000001 | 2092561.48 | 37.7255769923986 | -122.454152837668 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0076&ExportPDF=1&Filename=16MFF-0076_schedule.pdf | Mo/Tu/We/Th/Fr:7AM-8PM | 03/18/2016 12:00:00 AM | 2016-03-18 | 0 | 03/15/2017 12:00:00 AM | (37.7255769923986, -122.454152837668) | |
468 | 468 | 676797 | Peruchi Food Truck,LLC 85 | Truck 1 | 4972000 | DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) | 253 DRUMM ST | 0203013 | 0203 319 | 013 | 15MFF-0023 | EXPIRED 2 | Peruvian Chinese Food. Lomo Saltado: Arroz Con Pollo: Tipa Kay: Yuca Fries | 6013507.554 | 2117905.099 | 37.796123380252105 | -122.39727320433799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0023&ExportPDF=1&Filename=15MFF-0023_schedule.pdf | Mo/We/Fr:9AM-3PM | 03/15/2016 12:00:00 AM | 2015-03-02 | 0 | 03/15/2017 12:00:00 AM | (37.7961233802521, -122.397273204338) | |
467 | 467 | 805152 | El Tonayanse #4 / #36 84 | Truck 1 | 6740000 | HARRISON ST: 13TH ST to 14TH ST (1700 - 1799) | 1717 HARRISON ST | 3901001 | 3901 318 | 001 | 16MFF-0124 | EXPIRED 2 | Tacos: Burritos: Tortas: Quesadillas | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0124&ExportPDF=1&Filename=16MFF-0124_schedule.pdf | Mo-Su:10AM-7PM | 05/18/2016 12:00:00 AM | 2016-05-18 | 1 | 03/15/2017 12:00:00 AM | (0, 0) | |||
466 | 466 | 802221 | El Tonayense #60 83 | Truck 1 | 6746000 | HARRISON ST: 17TH ST to MARIPOSA ST (2050 - 2149) | 401 TREAT AVE | 3573023 | 3573 87 | 023 | 16MFF-0119 | EXPIRED 2 | Tacos: Burritos: Tortas: Quesadillas: Drinks | 6008587.222999999 | 2105981.305 | 37.7631083253767 | -122.413454890022 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0119&ExportPDF=1&Filename=16MFF-0119_schedule.pdf | Mo-Su:10AM-4PM | 05/11/2016 12:00:00 AM | 2016-05-11 | 1 | 03/15/2017 12:00:00 AM | (37.7631083253767, -122.413454890022) | |
470 | 470 | 802222 | El Tonayense #60 83 | Truck 1 | 6752000 | HARRISON ST: MISTRAL ST to 20TH ST (2345 - 2399) | 2355 FOLSOM ST | 3593035 | 3593 144 | 035 | 16MFF-0119 | EXPIRED 2 | Tacos: Burritos: Tortas: Quesadillas: Drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0119&ExportPDF=1&Filename=16MFF-0119_schedule.pdf | Mo-Su:4PM-10PM | 05/11/2016 12:00:00 AM | 2016-05-11 | 1 | 03/15/2017 12:00:00 AM | (0, 0) |
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");