Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Status, PriorPermit, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | 22 | 654243 | Tacos Esmeralda 9 | Truck 1 | 5336000 | EVANS AVE: QUINT ST to RANKIN ST (1700 - 1799) | 1700 EVANS AVE | 5227001 | 5227 21 | 001 | 15MFF-0130 | REQUESTED 1 | Burritos: tacos: quesadillas: and tortas | 6014950.929 | 2099216.653 | 37.744889286143 | -122.390971976935 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0130&ExportPDF=1&Filename=15MFF-0130_schedule.pdf | Mo-We:7AM-4PM | 2015-05-12 | 0 | (37.744889286143, -122.390971976935) | |||
| 32 | 32 | 646995 | Tacos El Primo 5 | Truck 1 | 10829000 | QUINT ST: DAVIDSON AVE to EVANS AVE (300 - 399) | 1700 EVANS AVE | 5227001 | 5227 21 | 001 | 15MFF-0122 | REQUESTED 1 | Mexican food: tacos: burritos: tortas: various meat and chicken and fish plate: chile relleno plate: fish plate: bread: flan: rice pudding: bread: fruit juice: vegetable juice: coffee: tea | 6014950.929 | 2099216.653 | 37.744889286143 | -122.390971976935 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0122&ExportPDF=1&Filename=15MFF-0122_schedule.pdf | Mo-Fr:10AM-4PM | 2015-04-21 | 1 | 03/15/2016 12:00:00 AM | (37.744889286143, -122.390971976935) | ||
| 617 | 617 | 848080 | Taqueria Lolita 118 | Truck 1 | 10927000 | RANKIN ST: DAVIDSON AVE to EVANS AVE (200 - 299) | 1700 EVANS AVE | 5227001 | 5227 21 | 001 | 16MFF-0128 | SUSPEND 4 | Tacos: burritos: quesadillas: combination plates: tortas: tostadas | 6014950.929 | 2099216.653 | 37.744889286143 | -122.390971976935 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0128&ExportPDF=1&Filename=16MFF-0128_schedule.pdf | Th/Fr/Sa:7AM-3PM | 08/01/2017 12:00:00 AM | 2016-06-22 | 0 | 03/15/2018 12:00:00 AM | (37.744889286143, -122.390971976935) |
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");