Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: permit, Schedule, Approved, Received, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 482 | 482 | 934542 | Think is Good Inc. 92 | Truck 1 | 5169000 | ELLIS ST: 04TH ST \ MARKET ST \ STOCKTON ST to POWELL ST (1 - 99) | 34 ELLIS ST | 0307008 | 0307 326 | 008 | 17MFF-0098 | APPROVED 5 | Sushi Burrito: Chicken Burrito: Tempura Burrito | 6009885.084 | 2114861.905 | 37.787565165378794 | -122.40959283347999 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf | Sa-Su:11AM-2PM/1PM-4PM | 03/23/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7875651653788, -122.40959283348) | |
| 486 | 486 | 934540 | Think is Good Inc. 92 | Truck 1 | 9089000 | MISSION ST: ECKER ST to SHAW ALY (521 - 548) | 536 MISSION ST | 3708098 | 3708 4 | 098 | 17MFF-0098 | APPROVED 5 | Sushi Burrito: Chicken Burrito: Tempura Burrito | 6012988.85269 | 2115411.9566599997 | 37.789248908413704 | -122.39889295934601 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf | Mo/We/Fr:10AM-3PM | 03/23/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (37.7892489084137, -122.398892959346) | |
| 487 | 487 | 934541 | Think is Good Inc. 92 | Truck 1 | 3528000 | CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) | 400 CALIFORNIA ST | 0238003 | 0238 34 | 003 | 17MFF-0098 | APPROVED 5 | Sushi Burrito: Chicken Burrito: Tempura Burrito | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf | Tu/Th:10AM-3PM | 03/23/2017 12:00:00 AM | 2017-02-13 | 0 | 03/15/2018 12:00:00 AM | (0, 0) | |||
| 504 | 504 | 957119 | Think is Good Inc. 92 | Truck 1 | 147000 | 02ND ST: BRANNAN ST to TOWNSEND ST (600 - 699) | 625 02ND ST | 3789007 | 3789 339 | 007 | 17MFF-0174 | APPROVED 5 | Sushi Burrito: Chicken Burrito: Tempura Burrito | 6015195.7020000005 | 2112613.963 | 37.7816889753451 | -122.39106181728701 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0174&ExportPDF=1&Filename=17MFF-0174_schedule.pdf | Mo-Fr:12PM-5PM | 03/31/2017 12:00:00 AM | 2017-03-30 | 0 | 03/15/2018 12:00:00 AM | (37.7816889753451, -122.391061817287) |
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");