Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, FacilityType, permit, Status, FoodItems, Schedule, Received, PriorPermit, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37 | 37 | 710566 | Mora Taco Truck 7 | Truck 1 | 10661000 | POTRERO AVE: 16TH ST to 17TH ST (300 - 399) | 359 POTRERO AVE | 3961016 | 3961 33 | 016 | 15MFF-0006 | REQUESTED 1 | Tacos: quesadillas: burritos: tortas: tostadas | 6010427.261 | 2106686.404 | 37.765147510378796 | -122.40714049370101 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0006&ExportPDF=1&Filename=15MFF-0006_schedule.pdf | Mo-We:9AM-2PM | 2015-02-13 | 0 | (37.7651475103788, -122.407140493701) | |||
| 44 | 44 | 531039 | La Falafel 3 | Truck 1 | 13057001 | VALENCIA ST: 14TH ST to ROSA PARKS LN (300 - 337) | 337 VALENCIA ST | 3547016 | 3547 3 | 016 | 14MFF-0088 | EXPIRED 2 | Falafel Sandwiches: Fries: Soda: Iced Tea & Various Drinks. | 6006211.307999999 | 2107613.639 | 37.767456639106896 | -122.42178834311599 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=14MFF-0088&ExportPDF=1&Filename=14MFF-0088_schedule.pdf | Tu/We/Th:11AM-4PM;Fr/Sa:4PM-11PM | 03/31/2014 12:00:00 AM | 2014-03-28 | 0 | 03/15/2015 12:00:00 AM | (37.7674566391069, -122.421788343116) | |
| 56 | 56 | 795864 | Doc's of the Bay 25 | Truck 1 | 731000 | 16TH ST: CALEDONIA ST to VALENCIA ST (3072 - 3099) | 3092 16TH ST | 3554016 | 3554 49 | 016 | 16MFF-0102 | REQUESTED 1 | Burgers: French Fries: Black Bean Burgers: Mac and Cheese: drinks | 6006249.865 | 2106782.214 | 37.765175917067204 | -122.421595922098 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0102&ExportPDF=1&Filename=16MFF-0102_schedule.pdf | Su:6PM-12AM | 2016-05-02 | 0 | 03/15/2017 12:00:00 AM | (37.7651759170672, -122.421595922098) | ||
| 68 | 68 | 916847 | Los 2 Cuates 32 | Truck 1 | 4801101 | DIVISADERO ST: OAK ST to FELL ST (401 - 499) -- WEST -- | 401 DIVISADERO ST | 1215016 | 1215 57 | 016 | 16MFF-0137 | REQUESTED 1 | south American-Peruvian food: hot wok dishes: hot pastas: rice dishes. | 6001606.909 | 2109860.071 | 37.773364053190896 | -122.437875225303 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0137&ExportPDF=1&Filename=16MFF-0137_schedule.pdf | Su/Fr/Sa:7AM-8PM | 2016-08-12 | 0 | 08/12/2016 12:00:00 AM | (37.7733640531909, -122.437875225303) | ||
| 117 | 117 | 934621 | May Catering 37 | Truck 1 | 9053000 | MINNESOTA ST: 04TH ST \ MARIPOSA ST to 18TH ST (500 - 599) | 535 MINNESOTA ST | 3996016 | 3996 96 | 016 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015237.97 | 2106058.2819999997 | 37.763690871096 | -122.39045738601601 | 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:12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.763690871096, -122.390457386016) | ||
| 176 | 176 | 934580 | May Catering 37 | Truck 1 | 8234000 | LE CONTE AVE: 03RD ST to KEITH ST (1039 - 1099) | 1098 LE CONTE AVE | 5475016 | 5475 147 | 016 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012690.947000001 | 2089990.938 | 37.7194317184807 | -122.398139506914 | 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:9AM-10AM/12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7194317184807, -122.398139506914) | ||
| 304 | 304 | 946059 | D & T Catering 58 | Truck 1 | 6478000 | GREEN ST: SCOTT ST to DIVISADERO ST (2500 - 2599) | 2590 GREEN ST | 0952016 | 0952 234 | 016 | 17MFF-0140 | APPROVED 5 | Cold Truck: Pre-packaged sandwiches: Chicken Bake: Canned Soup: Chili Dog: Corn Dog: Cup of Noodles: Egg Muffins: Hamburgers: Cheeseburgers: Hot Dog: Hot sandwiches: quesadillas: Beverages: Flan: Fruits: Yogurt: Candy: Cookies: Chips: Donuts: Snacks | 6000664.277319999 | 2117972.71962 | 37.7955856498634 | -122.44171824428801 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0140&ExportPDF=1&Filename=17MFF-0140_schedule.pdf | Mo-Fr:8AM-9AM | 03/09/2017 12:00:00 AM | 2017-03-09 | 1 | 03/15/2018 12:00:00 AM | (37.7955856498634, -122.441718244288) | |
| 405 | 405 | 947809 | Park's Catering 66 | Truck 1 | 10927000 | RANKIN ST: DAVIDSON AVE to EVANS AVE (200 - 299) | 220 RANKIN ST | 5215016 | 5215 269 | 016 | 17MFF-0153 | APPROVED 5 | Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins | 6014805.5139999995 | 2099795.201 | 37.746469788114794 | -122.39151523877199 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf | Mo-Fr:8AM-9AM/12PM-1PM | 03/13/2017 12:00:00 AM | 2017-03-13 | 1 | 03/15/2018 12:00:00 AM | (37.7464697881148, -122.391515238772) | |
| 425 | 425 | 946358 | San Francisco Carts & Concessions, Inc. DBA Stanley's Steamers Hot Dogs 75 | Push Cart 2 | 10628000 | POST ST: STOCKTON ST to POWELL ST (300 - 399) | 345 STOCKTON ST | 0295016 | 0295 295 | 016 | 17MFF-0142 | APPROVED 5 | Hot dogs: condiments: soft pretzels: soft drinks: coffee: cold beverages: pastries: bakery goods: cookies: ice cream: candy: soups: churros: chestnuts: nuts: fresh fruit: fruit juices: desserts: potato chips and popcorn. | 6010587.529 | 2115337.419 | 37.7889101495704 | -122.40719603412201 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0142&ExportPDF=1&Filename=17MFF-0142_schedule.pdf | Mo-Su:6AM-12AM | 03/14/2017 12:00:00 AM | 2017-03-10 | 1 | 03/15/2018 12:00:00 AM | (37.7889101495704, -122.407196034122) | |
| 598 | 598 | 960998 | Golden Catering 110 | Truck 1 | 4494000 | CRESCENT AVE: ANDERSON ST to ELLSWORTH ST (600 - 699) | 601 CRESCENT AVE | 5741016 | 5741 389 | 016 | 17MFF-0179 | APPROVED 5 | Cold Truck: Pre-packaged Sandwiches: Various Beverages: Salads: Snacks | 6007810.618 | 2095762.19 | 37.735005299128396 | -122.415417409745 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0179&ExportPDF=1&Filename=17MFF-0179_schedule.pdf | Mo/Tu/We/Th/Fr:11AM-12PM | 05/12/2017 12:00:00 AM | 2017-04-12 | 1 | 03/15/2018 12:00:00 AM | (37.7350052991284, -122.415417409745) | |
| 610 | 610 | 924719 | San Francisco's Hometown Creamery 114 | Truck 1 | 6109000 | GEARY ST: STOCKTON ST to POWELL ST (200 - 299) | 287 GEARY ST | 0314016 | 0314 298 | 016 | 17MFF-0001 | REQUESTED 1 | Ice cream | 6010359.7874 | 2114712.50286 | 37.7871815311957 | -122.40793990670099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0001&ExportPDF=1&Filename=17MFF-0001_schedule.pdf | Sa-Su:11AM-11PM;Fr:6PM-11PM | 2017-01-09 | 0 | (37.7871815311957, -122.407939906701) |
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");