Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: cnn, LocationDescription, lot, Latitude, Longitude, dayshours, Location, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72 | 72 | 559775 | Mang Hang Catering 35 | Truck 1 | 8848000 | MASONIC AVE: MCALLISTER ST to FULTON ST (500 - 599) | 500 MASONIC AVE | 1175018 | 1175 61 | 018 | 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. | 5999194.35773 | 2111070.4801 | 37.776550042819096 | -122.446307635558 | 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/11AM-12PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7765500428191, -122.446307635558) | ||
| 73 | 73 | 559781 | Mang Hang Catering 35 | Truck 1 | 2488201 | CESAR CHAVEZ ST: SOUTH VAN NESS AVE to CAPP ST \ MISSION ST (3300 - 3398) -- NORTH -- | 3300 CESAR CHAVEZ ST | 6571011 | 6571 62 | 011 | 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. | 6007693.812999999 | 2100697.425 | 37.7485497942591 | -122.416170662008 | 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:8AM-9AM/11AM-12PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7485497942591, -122.416170662008) | ||
| 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) | ||||
| 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) | ||
| 76 | 76 | 559787 | Mang Hang Catering 35 | Truck 1 | 8848000 | MASONIC AVE: MCALLISTER ST to FULTON ST (500 - 599) | 599 MASONIC AVE | 1108 012 | 1108 64 | 012 | 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. | 5998797.751680001 | 2112598.57865 | 37.7807231475444 | -122.447789640478 | 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:9AM-10AM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7807231475444, -122.447789640478) | ||
| 77 | 77 | 559771 | Mang Hang Catering 35 | Truck 1 | 10477000 | PINE ST: POLK ST to VAN NESS AVE (1500 - 1599) | 1540 PINE ST | 0646005 | 0646 65 | 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. | 6006569.835 | 2115753.4930000002 | 37.789826918763296 | -122.42112628905599 | 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.7898269187633, -122.421126289056) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 83 | 83 | 559773 | Mang Hang Catering 35 | Truck 1 | 5073000 | EDDY ST: STEINER ST to PIERCE ST (1600 - 1699) | 1652 EDDY ST | 0730 044 | 0730 70 | 044 | 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. | 6002540.818 | 2112839.086 | 37.781596745760204 | -122.43485778844 | 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:11AM-12PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7815967457602, -122.43485778844) | ||
| 84 | 84 | 559772 | Mang Hang Catering 35 | Truck 1 | 13064000 | VALENCIA ST: 18TH ST to 19TH ST (700 - 799) | 740 VALENCIA ST | 3588006 | 3588 71 | 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. | 6006152.35 | 2105247.76 | 37.7609571682785 | -122.421824199358 | 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:11AM-12PM | 2014-07-10 | 1 | 03/15/2017 12:00:00 AM | (37.7609571682785, -122.421824199358) | ||
| 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) | ||
| 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) | ||
| 87 | 87 | 559789 | Mang Hang Catering 35 | Truck 1 | 5178000 | ELLIS ST: LARKIN ST to POLK ST (700 - 799) | 730 ELLIS ST | 0717006 | 0717 74 | 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. | 6007315.572000001 | 2113769.269 | 37.7844207368995 | -122.418405351782 | 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.7844207368995, -122.418405351782) | ||
| 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) | ||
| 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) |
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");