Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, permit, Status, FoodItems, Schedule, Received, Received (date)
ExpirationDate ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75 | 75 | 559785 | Mang Hang Catering 35 | Truck 1 | 3376000 | BURKE AVE: END to 03RD ST (1500 - 1599) | 1570 BURKE AVE | 5203066 | 5203 63 | 066 | 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. | 6016479.9436099995 | 2099135.86798 | 37.7447521916164 | -122.385679248721 | 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:2PM-3PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7447521916164, -122.385679248721) | ||
| 91 | 91 | 559784 | Mang Hang Catering 35 | Truck 1 | 4614000 | DAVIDSON AVE: QUINT ST to RANKIN ST (1500 - 1599) | 1580 DAVIDSON AVE | 5216029 | 5216 76 | 029 | 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. | 6015031.248 | 2099507.747 | 37.7456930261204 | -122.390714584821 | 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:2PM-3PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7456930261204, -122.390714584821) | ||
| 107 | 107 | 934612 | May Catering 37 | Truck 1 | 13693000 | WISCONSIN ST: 16TH ST to 17TH ST (100 - 199) | 166 WISCONSIN ST | 3954017 | 3954 88 | 017 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012435.699 | 2106749.8340000003 | 37.7654338684827 | -122.400198205294 | 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:2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7654338684827, -122.400198205294) | ||
| 135 | 135 | 934613 | May Catering 37 | Truck 1 | 10659000 | POTRERO AVE: ALAMEDA ST to 15TH ST (100 - 199) | 100 POTRERO AVE | 3920001 | 3920 112 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6010116.9120000005 | 2107759.235 | 37.768075885952705 | -122.408289595287 | 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:2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7680758859527, -122.408289595287) | ||
| 298 | 298 | 934428 | John's Catering #5 59 | Truck 1 | 6742000 | HARRISON ST: ALAMEDA ST to 15TH ST (1830 - 1899) | 1830 HARRISON ST | 3550020 | 3550 230 | 020 | 17MFF-0084 | APPROVED 5 | Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) | 6008479.3379999995 | 2107759.433 | 37.7679845948645 | -122.41395382252199 | 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:2PM-3PM | 03/09/2017 12:00:00 AM | 2017-02-13 | 1 | 03/15/2018 12:00:00 AM | (37.7679845948645, -122.413953822522) | |
| 569 | 569 | 963987 | Singh Brothers Ice Cream 105 | Truck 1 | 5599000 | FITZGERALD AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1104 FITZGERALD AVE | 4914022 | 4914 374 | 022 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015221.628 | 2090210.3169999998 | 37.7201747226493 | -122.389407114342 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7201747226493, -122.389407114342) | ||
| 575 | 575 | 963986 | Singh Brothers Ice Cream 105 | Truck 1 | 13356000 | WALLACE AVE: JENNINGS ST to KEITH ST (1500 - 1599) | 1550 WALLACE AVE | 4829006 | 4829 261 | 006 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015093.174 | 2092759.834 | 37.727168068782 | -122.390029148701 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.727168068782, -122.390029148701) | ||
| 584 | 584 | 963989 | Singh Brothers Ice Cream 105 | Truck 1 | 13780000 | YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) | 1420 YOSEMITE AVE | 4831012 | 4831 32 | 012 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015609.592 | 2092025.9880000001 | 37.7251817007288 | -122.38819268844401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7251817007288, -122.388192688444) | ||
| 585 | 585 | 963988 | Singh Brothers Ice Cream 105 | Truck 1 | 10218000 | PALOU AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1101 PALOU AVE | 4757024 | 4757 385 | 024 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017464.808999999 | 2093259.551 | 37.7286714428179 | -122.38186508864099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7286714428179, -122.381865088641) |
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");