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