Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, lot, permit, Status, FoodItems, Schedule, Approved, Received, ExpirationDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 74 | 559786 | Mang Hang Catering 35 | Truck 1 | 7033000 | HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) | 501 HOWARD ST | 3736001 | 3736 10 | 001 | 14MFF-0109 | EXPIRED 2 | COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf | Mo-Fr:6AM-7AM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (0, 0) | ||||
| 143 | 143 | 934610 | May Catering 37 | Truck 1 | 2477000 | CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) | 2400 CESAR CHAVEZ ST | 4328A005 | 4328A 119 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012051.606000001 | 2101106.273 | 37.749916469390996 | -122.40113011221202 | 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:6AM-7AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.749916469391, -122.401130112212) | ||
| 276 | 276 | 934412 | John's Catering #5 59 | Truck 1 | 9090000 | MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) | 560 MISSION ST | 3708095 | 3708 4 | 095 | 17MFF-0084 | APPROVED 5 | Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) | 6012851.27 | 2115274.827 | 37.788864715342996 | -122.39935935136299 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf | Mo-Fr:6AM-7AM | 03/09/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.788864715343, -122.399359351363) | |
| 330 | 330 | 934454 | Liang Bai Ping 63 | Truck 1 | 2866000 | BEALE ST: FOLSOM ST to HARRISON ST (300 - 399) | 300 BEALE ST | 3747022 | 3747 162 | 022 | 17MFF-0090 | APPROVED 5 | Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages | 6014804.68 | 2114971.1180000002 | 37.78813947887161 | -122.392579515374 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf | Mo-Fr:6AM-7AM | 03/10/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7881394788716, -122.392579515374) | |
| 342 | 342 | 934485 | Liang Bai Ping 63 | Truck 1 | 6540000 | GRIFFITH ST: QUESADA AVE to REVERE AVE (1300 - 1399) | 1300 GRIFFITH ST | 4763047 | 4763 245 | 047 | 17MFF-0090 | APPROVED 5 | Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages | 6017681.819 | 2092678.013 | 37.727086633951394 | -122.381074448749 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf | Mo-Fr:6AM-7AM | 03/10/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7270866339514, -122.381074448749) | |
| 552 | 552 | 934372 | Two G's Catering 103 | Truck 1 | 185105 | 03RD ST: SOUTH ST to 16TH ST (1601 - 1799) -- EAST -- | 1799 03RD ST | 8722001 | 8722 268 | 001 | 17MFF-0073 | APPROVED 5 | Cold Truck: Hot & Cold Sandwiches: Bagels: Burritos: Soups: Hot Dogs: Tacos: Pork Buns: BBQ Meat: Fruit: Various Beverages: Pasties: Pre-Packaged Snacks: Candy: Salads: Muffins: Scones: Brownies: Croissants: Energy Bars: Noodle Bowls | 6016110.001 | 2107608.418 | 37.7679955456856 | -122.387549426547 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf | Mo-Fr:6AM-7AM | 04/17/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7679955456856, -122.387549426547) | |
| 563 | 563 | 934373 | Two G's Catering 103 | Truck 1 | 2954000 | BERRY ST: 04TH ST to 05TH ST (200 - 299) | 201 BERRY ST | 8708003 | 8708 86 | 003 | 17MFF-0073 | APPROVED 5 | Cold Truck: Hot & Cold Sandwiches: Bagels: Burritos: Soups: Hot Dogs: Tacos: Pork Buns: BBQ Meat: Fruit: Various Beverages: Pasties: Pre-Packaged Snacks: Candy: Salads: Muffins: Scones: Brownies: Croissants: Energy Bars: Noodle Bowls | 6014509.734 | 2110397.9280000003 | 37.7755661544145 | -122.393279842341 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf | Mo-Fr:6AM-7AM | 04/17/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7755661544145, -122.393279842341) |
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");