Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 79 | 79 | 559782 | Mang Hang Catering 35 | Truck 1 | 9101000 | MISSION ST: 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) | 1118 MISSION ST | 3702032 | 3702 67 | 032 | 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. | 6009238.199 | 2111812.954 | 37.7791572053411 | -122.411615430519 | 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:12PM-1PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7791572053411, -122.411615430519) | ||
| 82 | 82 | 559788 | Mang Hang Catering 35 | Truck 1 | 1177000 | 22ND ST: SAN BRUNO AVE to UTAH ST (2400 - 2449) | 2401 22ND ST | 4154001 | 4154 69 | 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. | 6010945.915 | 2103212.154 | 37.7556370098323 | -122.405101930379 | 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:10AM-11AM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7556370098323, -122.405101930379) | ||
| 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) | ||
| 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) | ||
| 80 | 80 | 559774 | Mang Hang Catering 35 | Truck 1 | 144000 | 02ND ST: FEDERAL ST to SOUTH PARK (519 - 548) | 544 02ND ST | 3775005 | 3775 68 | 005 | 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. | 6014572.797 | 2112894.0930000003 | 37.7824235632947 | -122.393236399398 | 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/11AM-12PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7824235632947, -122.393236399398) | ||
| 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) | ||
| 86 | 86 | 559783 | Mang Hang Catering 35 | Truck 1 | 9058000 | MINNESOTA ST: 23RD ST to 24TH ST (1200 - 1299) | 1240 MINNESOTA ST | 4228015 | 4228 73 | 015 | 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. | 6015191.235 | 2102753.826 | 37.7546149514892 | -122.39038813202 | 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:1PM-2PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7546149514892, -122.39038813202) | ||
| 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) | ||
| 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) | ||||
| 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) |
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");