Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
273 | 273 | 934642 | Anas Goodies Catering 57 | Truck 1 | 5070000 | EDDY ST: BUCHANAN ST to WEBSTER ST (1300 - 1399) | 1346 EDDY ST | 0733014 | 0733 14 | 014 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6003979.58488 | 2112907.84293 | 37.7818671175741 | -122.429885247603 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7818671175741, -122.429885247603) | |
269 | 269 | 934640 | Anas Goodies Catering 57 | Truck 1 | 2458000 | ARMSTRONG AVE: HAWES ST to INGALLS ST (1300 - 1399) | 1315 ARMSTRONG AVE | 4851017 | 4851 212 | 017 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015787.012 | 2091256.533 | 37.723078757516 | -122.387525704017 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.723078757516, -122.387525704017) | |
264 | 264 | 934636 | Anas Goodies Catering 57 | Truck 1 | 12484000 | TENNESSEE ST: 19TH ST to 20TH ST (800 - 899) | 815 TENNESSEE ST | 4059001B | 4059 207 | 001B | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015563.022999999 | 2105254.616 | 37.7615022039664 | -122.38927699608101 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7615022039664, -122.389276996081) | |
260 | 260 | 934637 | Anas Goodies Catering 57 | Truck 1 | 7195000 | INDIANA ST: 20TH ST to 22ND ST (800 - 999) | 998 INDIANA ST | 4105011 | 4105 204 | 011 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6014845.363 | 2104007.25 | 37.7580373934881 | -122.39167189068199 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7580373934881, -122.391671890682) | |
258 | 258 | 934641 | Anas Goodies Catering 57 | Truck 1 | 12483000 | TENNESSEE ST: 18TH ST to 19TH ST (700 - 799) | 790 TENNESSEE ST | 4043011B | 4043 203 | 011B | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015376.265 | 2105385.926 | 37.7618523975041 | -122.38993209325001 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7618523975041, -122.38993209325) | |
242 | 242 | 934639 | Anas Goodies Catering 57 | Truck 1 | 10332000 | PENNSYLVANIA AVE: MARIPOSA ST to I-280 S OFF RAMP (200 - 256) | 208 PENNSYLVANIA AVE | 4000053 | 4000 193 | 053 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6014208.71083 | 2105996.09175 | 37.763462959906605 | -122.39401294737699 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf | Mo-Fr:8AM-9AM | 03/08/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7634629599066, -122.394012947377) |
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");