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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | |
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) | |||
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) | |
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) | |
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) | |||
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) |
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");