Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78 | 78 | 559780 | Mang Hang Catering 35 | Truck 1 | 12583000 | THOMAS MORE WAY: BROTHERHOOD WAY \ CHUMASERO DR to END (1 - 99) | 1 THOMAS MORE WAY | 7380027 | 7380 66 | 027 | 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. | 5991430.02662 | 2086996.77488 | 37.7100033342894 | -122.471411913129 | 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:7AM-8AM/10AM-11AM/12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7100033342894, -122.471411913129) | ||
81 | 81 | 559777 | Mang Hang Catering 35 | Truck 1 | 131000 | 02ND ST: JESSIE ST to MISSION ST (69 - 99) | 85 02ND ST | 3708019 | 3708 4 | 019 | 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. | 6012696.635 | 2115129.488 | 37.788457028828894 | -122.399884160566 | 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:7AM-8AM/10AM-11AM/12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7884570288289, -122.399884160566) | ||
85 | 85 | 559779 | Mang Hang Catering 35 | Truck 1 | 4083000 | CLAY ST: BATTERY ST to SANSOME ST (400 - 499) | 432 CLAY ST | 0206006 | 0206 72 | 006 | 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. | 6012459.069 | 2117555.691 | 37.7951055609814 | -122.400876633726 | 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:7AM-8AM/10AM-11AM/12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7951055609814, -122.400876633726) | ||
88 | 88 | 559776 | Mang Hang Catering 35 | Truck 1 | 9094000 | MISSION ST: ANNIE ST to 03RD ST (663 - 699) | 690 MISSION ST | 3707024 | 3707 22 | 024 | 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:7AM-8AM/10AM-11AM/12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (0, 0) | ||||
89 | 89 | 559778 | Mang Hang Catering 35 | Truck 1 | 12678000 | TREAT AVE: DIVISION ST \ FLORIDA ST to ALAMEDA ST (1 - 99) | Assessors Block 3902/Lot002 | 3902002 | 3902 75 | 002 | 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. | 6009046.271000001 | 2107865.259 | 37.7683069928 | -122.41200033609199 | 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:7AM-8AM/10AM-11AM/12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7683069928, -122.412000336092) |
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");