Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: lot, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137 | 137 | 934597 | May Catering 37 | Truck 1 | 191101 | 03RD ST: 22ND ST to 23RD ST (2501 - 2699) -- EAST -- | 2565 03RD ST | 4173001 | 4173 114 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015998.409 | 2103503.194 | 37.756717299837106 | -122.387648962993 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7567172998371, -122.387648962993) | ||
161 | 161 | 934600 | May Catering 37 | Truck 1 | 193201 | 03RD ST: 24TH ST to 25TH ST (2800 - 2898) -- WEST -- | 2800 03RD ST | 4246001 | 4246 135 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015771.1389999995 | 2102415.24 | 37.753717416902106 | -122.38835902104401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7537174169021, -122.388359021044) | ||
111 | 111 | 934598 | May Catering 37 | Truck 1 | 1520000 | 26TH ST: SHOTWELL ST to VIRGIL ST (3251 - 3273) | 3251 26TH ST | 6572001 | 6572 90 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008228.38 | 2100763.8230000003 | 37.7487621514792 | -122.414326828755 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7487621514792, -122.414326828755) | ||
157 | 157 | 934601 | May Catering 37 | Truck 1 | 6751000 | HARRISON ST: 19TH ST to MISTRAL ST (2301 - 2360) | 2301 HARRISON ST | 4083008 | 4083 131 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008876.646000001 | 2104879.645 | 37.7600996654893 | -122.412375997322 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7600996654893, -122.412375997322) |
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");