Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: lot, dayshours, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93 | 93 | 934593 | May Catering 37 | Truck 1 | 697000 | 16TH ST: 03RD ST to 04TH ST (500 - 599) | 500 16TH ST | 3810007 | 3810 78 | 007 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||
| 95 | 95 | 934625 | May Catering 37 | Truck 1 | 0 | Assessors Block 8710/Lot003 | 8710003 | 8710 80 | 003 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014416.532000001 | 2108607.696 | 37.7706453983908 | -122.39347693719999 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7706453983908, -122.3934769372) | |||
| 98 | 98 | 934627 | May Catering 37 | Truck 1 | 19984000 | 04TH ST: CHINA BASIN ST to MISSION BAY BLVD (1300 - 1399) | 1322 04TH ST | 1758 035 | 1758 83 | 035 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 5994967.667 | 2106540.921 | 37.7638707601661 | -122.460600563879 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7638707601661, -122.460600563879) | ||
| 99 | 99 | 934577 | May Catering 37 | Truck 1 | 9056000 | MINNESOTA ST: 20TH ST to 22ND ST (800 - 999) | 900 MINNESOTA ST | 4106001A | 4106 84 | 001A | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | 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:8AM-9AM/2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||
| 102 | 102 | 934590 | May Catering 37 | Truck 1 | 2955000 | BERRY ST: 05TH ST to 06TH ST (300 - 399) | 301 BERRY ST | 8708002 | 8708 86 | 002 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014277.187000001 | 2109955.224 | 37.7743376663696 | -122.394053286313 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7743376663696, -122.394053286313) | ||
| 103 | 103 | 934589 | May Catering 37 | Truck 1 | 6746000 | HARRISON ST: 17TH ST to MARIPOSA ST (2050 - 2149) | 2130 HARRISON ST | 3573046 | 3573 87 | 046 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008655.37685 | 2105873.06628 | 37.7628149532289 | -122.413211513673 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7628149532289, -122.413211513673) | ||
| 104 | 104 | 934602 | May Catering 37 | Truck 1 | 6747000 | HARRISON ST: MARIPOSA ST to 18TH ST (2150 - 2198) | 2150 HARRISON ST | 3573025 | 3573 87 | 025 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | 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 | (0, 0) | ||||
| 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) | ||
| 108 | 108 | 934609 | May Catering 37 | Truck 1 | 3887000 | CHANNEL ST: 03RD ST to 04TH ST (0 - 0) | Assessors Block 8711/Lot023 | 8711023 | 8711 52 | 023 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015253.3503 | 2109839.76272 | 37.774074841058294 | -122.390668458146 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7740748410583, -122.390668458146) | ||
| 109 | 109 | 934588 | May Catering 37 | Truck 1 | 2478101 | CESAR CHAVEZ ST: KANSAS ST to BAY SHORE BLVD \ VERMONT ST (2501 - 2625) -- SOUTH -- | 2501 CESAR CHAVEZ ST | 4339001 | 4339 89 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6011674.927 | 2100772.595 | 37.7489792411554 | -122.402409234561 | 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.7489792411554, -122.402409234561) | ||
| 110 | 110 | 934608 | May Catering 37 | Truck 1 | 3889000 | CHANNEL ST: END to END (0 - 0) | Assessors Block 3810/Lot008 | 3810008 | 3810 78 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013705.031 | 2109129.688 | 37.772039113525 | -122.395974631586 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.772039113525, -122.395974631586) | ||
| 111 | 111 | 934598 | May Catering 37 | Truck 1 | 1520000 | 26TH ST: SHOTWELL ST to VIRGIL ST (3251 - 3273) | 3251 26TH ST | 6572001 | 6572 90 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008228.38 | 2100763.8230000003 | 37.7487621514792 | -122.414326828755 | 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:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7487621514792, -122.414326828755) | ||
| 112 | 112 | 934617 | May Catering 37 | Truck 1 | 2953000 | BERRY ST: 03RD ST to 04TH ST (100 - 199) | 185 BERRY ST | 3803005 | 3803 91 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014943.869 | 2110666.298 | 37.7763271477899 | -122.39179682107701 | 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:6PM-7PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7763271477899, -122.391796821077) | ||
| 113 | 113 | 934618 | May Catering 37 | Truck 1 | 9086000 | MISSION ST: BEALE ST to FREMONT ST (300 - 399) | 350 MISSION ST | 3710017 | 3710 92 | 017 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013638.57 | 2115994.808 | 37.790885463501894 | -122.396685875811 | 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:6PM-7PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7908854635019, -122.396685875811) | ||
| 114 | 114 | 934619 | May Catering 37 | Truck 1 | 5372103 | EXECUTIVE PARK BLVD: CANDLESTICK COVE WAY to SANDPIPER COVE WAY \ THOMAS MELLON DR (138 - 198) | 150 EXECUTIVE PARK BLVD | 4991086 | 4991 93 | 086 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013956.743 | 2086835.501 | 37.710837931141 | -122.393543363013 | 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:7PM-8PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.710837931141, -122.393543363013) | ||
| 115 | 115 | 934575 | May Catering 37 | Truck 1 | 7502000 | JERROLD AVE: UPTON ST to NAPOLEON ST (2201 - 2299) | 2270 JERROLD AVE | 5230008 | 5230 94 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012245.5 | 2099714.018 | 37.746104451715205 | -122.400361834965 | 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:8AM-9AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7461044517152, -122.400361834965) | ||
| 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) | ||
| 119 | 119 | 934596 | May Catering 37 | Truck 1 | 2111000 | ALABAMA ST: MARIPOSA ST to 18TH ST (500 - 599) | 501 ALABAMA ST | 4018005 | 4018 98 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009055.308999999 | 2105741.745 | 37.762476819591 | -122.41181900367901 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.762476819591, -122.411819003679) | ||
| 121 | 121 | 934624 | May Catering 37 | Truck 1 | 6805000 | HAWES ST: INGERSON AVE to JAMESTOWN AVE (2900 - 2999) | 2930 HAWES ST | 4971022 | 4971 100 | 022 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014554.034 | 2089351.467 | 37.717779453627 | -122.391654765179 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Su:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.717779453627, -122.391654765179) | ||
| 122 | 122 | 934599 | May Catering 37 | Truck 1 | 9504000 | NAPOLEON ST: EVANS AVE \ TOLAND ST to JERROLD AVE (25 - 299) | 180 NAPOLEON ST | 4343004 | 4343 101 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012688.941000001 | 2100244.688 | 37.7475862762565 | -122.398865700796 | 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/11AM-12PM/2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7475862762565, -122.398865700796) | ||
| 123 | 123 | 934576 | May Catering 37 | Truck 1 | 7169000 | ILLINOIS ST: 20TH ST to 22ND ST (900 - 1099) | 1000 ILLINOIS ST | 4109001 | 4109 102 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015939.401000001 | 2104425.293 | 37.7592459190261 | -122.387917376991 | 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:8AM-9AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7592459190261, -122.387917376991) | ||
| 124 | 124 | 934587 | May Catering 37 | Truck 1 | 699001 | 16TH ST: OWENS ST to 07TH ST \ MISSISSIPPI ST (700 - 899) | Assessors Block 8727/Lot005 | 8727005 | 8727 103 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014460.137 | 2106764.375 | 37.7655864681473 | -122.393197101166 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7655864681473, -122.393197101166) | ||
| 126 | 126 | 934623 | May Catering 37 | Truck 1 | 12775000 | ULLOA ST: WOODSIDE AVE to SYDNEY WAY (1 - 56) | 2 ULLOA ST | 2914001 | 2914 105 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 5996669.215 | 2099864.483 | 37.7456366838808 | -122.454233188657 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Su:9AM-10AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7456366838808, -122.454233188657) | ||
| 127 | 127 | 934616 | May Catering 37 | Truck 1 | 4909000 | DONNER AVE: END to 03RD ST (1600 - 1699) | 1600 DONNER AVE | 4881023 | 4881 106 | 023 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014214.714 | 2091627.121 | 37.7240091065402 | -122.39298678257799 | 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:4PM-5PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7240091065402, -122.392986782578) | ||
| 128 | 128 | 934626 | May Catering 37 | Truck 1 | 0 | Assessors Block /Lot | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||||||
| 131 | 131 | 934592 | May Catering 37 | Truck 1 | 7163000 | 299 ILLINOIS ST | 3850001A | 3850 108 | 001A | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | 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:10AM-11AM/12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | |||||
| 132 | 132 | 934594 | May Catering 37 | Truck 1 | 13768000 | YORK ST: 19TH ST to 20TH ST (700 - 799) | 720 YORK ST | 4080018 | 4080 109 | 018 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009791.69356 | 2104761.23213 | 37.7598258374358 | -122.40920291508301 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7598258374358, -122.409202915083) | ||
| 133 | 133 | 934581 | May Catering 37 | Truck 1 | 10672000 | POTRERO AVE: 24TH ST to 25TH ST (1200 - 1299) | 1200 POTRERO AVE | 4265026 | 4265 110 | 026 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6010430.557 | 2102108.308 | 37.7525772700714 | -122.406806417152 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7525772700714, -122.406806417152) | ||
| 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) | ||
| 136 | 136 | 934630 | May Catering 37 | Truck 1 | 5329000 | EVANS AVE: HUNTERS POINT BLVD to JENNINGS ST \ MIDDLE POINT RD (1031 - 1099) | 1059 EVANS AVE | 4603A005 | 4603A 113 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6018579.482000001 | 2096114.542 | 37.736572182418705 | -122.378209667202 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7365721824187, -122.378209667202) | ||
| 137 | 137 | 934597 | May Catering 37 | Truck 1 | 191101 | 03RD ST: 22ND ST to 23RD ST (2501 - 2699) -- EAST -- | 2565 03RD ST | 4173001 | 4173 114 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015998.409 | 2103503.194 | 37.756717299837106 | -122.387648962993 | 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:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7567172998371, -122.387648962993) | ||
| 138 | 138 | 934628 | May Catering 37 | Truck 1 | 8715000 | MARIPOSA ST: 04TH ST \ MINNESOTA ST to INDIANA ST (700 - 799) | 777 MARIPOSA ST | 3997004 | 3997 115 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015005.348999999 | 2106106.8340000003 | 37.7638112772906 | -122.391265350599 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7638112772906, -122.391265350599) | ||
| 143 | 143 | 934610 | May Catering 37 | Truck 1 | 2477000 | CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) | 2400 CESAR CHAVEZ ST | 4328A005 | 4328A 119 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012051.606000001 | 2101106.273 | 37.749916469390996 | -122.40113011221202 | 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:6AM-7AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.749916469391, -122.401130112212) | ||
| 144 | 144 | 934578 | May Catering 37 | Truck 1 | 2109000 | ALABAMA ST: 16TH ST to 17TH ST (300 - 399) | 380 ALABAMA ST | 3967049 | 3967 120 | 049 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008823.51685 | 2106465.97879 | 37.7644523927651 | -122.41267189164499 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7644523927651, -122.412671891645) | ||
| 146 | 146 | 934615 | May Catering 37 | Truck 1 | 517000 | BRYANT ST: 11TH ST \ 13TH ST \ DIVISION ST to DIVISION ST (1300 - 1319) | 1300 BRYANT ST | 3903004 | 3903 122 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009188.668 | 2108146.472 | 37.769087126767104 | -122.41152766713199 | 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:3PM-4PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7690871267671, -122.411527667132) | ||
| 147 | 147 | 934611 | May Catering 37 | Truck 1 | 2477000 | CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) | 2300 CESAR CHAVEZ ST | 4328A007 | 4328A 119 | 007 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012256.828 | 2101112.599 | 37.7499452857571 | -122.400420884438 | 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:1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7499452857571, -122.400420884438) | ||
| 148 | 148 | 934595 | May Catering 37 | Truck 1 | 5690000 | FOLSOM ST: 16TH ST to ENTERPRISE ST (2000 - 2035) | 2000 FOLSOM ST | 3571001 | 3571 123 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008008.225 | 2106691.986 | 37.7650271638822 | -122.41550777248999 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7650271638822, -122.41550777249) | ||
| 149 | 149 | 934629 | May Catering 37 | Truck 1 | 8234000 | LE CONTE AVE: 03RD ST to KEITH ST (1039 - 1099) | 1075 LE CONTE AVE | 5476009 | 5476 124 | 009 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012695.887 | 2089756.429 | 37.7187880790201 | -122.39810598775 | 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:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7187880790201, -122.39810598775) | ||
| 151 | 151 | 934583 | May Catering 37 | Truck 1 | 7166000 | ILLINOIS ST: MARIPOSA ST \ TERRY A FRANCOIS BLVD to 18TH ST (600 - 699) | 600 ILLINOIS ST | 3994011 | 3994 125 | 011 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015910.503 | 2106215.6040000003 | 37.7641601282203 | -122.38814226212799 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7641601282203, -122.388142262128) | ||
| 152 | 152 | 934585 | May Catering 37 | Truck 1 | 13767000 | YORK ST: 18TH ST to 19TH ST (600 - 699) | 620 YORK ST | 4023012 | 4023 126 | 012 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009734.778 | 2105398.284 | 37.761571848719704 | -122.409444718958 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7615718487197, -122.409444718958) | ||
| 153 | 153 | 934606 | May Catering 37 | Truck 1 | 1259000 | 23RD ST: HARRISON ST to TREAT AVE (3000 - 3053) | 3050 23RD ST | 3639004B | 3639 127 | 004B | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008696.252 | 2102835.373 | 37.7544764341075 | -122.412855363284 | 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.7544764341075, -122.412855363284) | ||
| 154 | 154 | 934605 | May Catering 37 | Truck 1 | 718000 | 16TH ST: FLORIDA ST to ALABAMA ST (2500 - 2599) | 2500 16TH ST | 3927004 | 3927 128 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009037.016 | 2106959.859 | 37.765820454483205 | -122.411968357912 | 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.7658204544832, -122.411968357912) | ||
| 155 | 155 | 934604 | May Catering 37 | Truck 1 | 9503000 | NAPOLEON ST: SELBY ST to EVANS AVE \ TOLAND ST (1 - 98) | Assessors Block 4347a/Lot004 | 4347a004 | 4347a 129 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013931.079580001 | 2100313.06289 | 37.7478431533724 | -122.39457521495702 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7478431533724, -122.394575214957) | ||
| 156 | 156 | 934579 | May Catering 37 | Truck 1 | 1631000 | 29TH ST: DOLORES ST to CHURCH ST (200 - 299) | 210 29TH ST | 6618010 | 6618 130 | 010 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6005080.565 | 2099108.286 | 37.744039098601704 | -122.42509418633101 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7440390986017, -122.425094186331) | ||
| 157 | 157 | 934601 | May Catering 37 | Truck 1 | 6751000 | HARRISON ST: 19TH ST to MISTRAL ST (2301 - 2360) | 2301 HARRISON ST | 4083008 | 4083 131 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008876.646000001 | 2104879.645 | 37.7600996654893 | -122.412375997322 | 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:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7600996654893, -122.412375997322) | ||
| 158 | 158 | 934584 | May Catering 37 | Truck 1 | 1516000 | 26TH ST: TREAT AVE \ TREAT WAY to LUCKY ST (3133 - 3164) | 3150 26TH ST | 6524019A | 6524 132 | 019A | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008583.969 | 2101037.332 | 37.7495331145231 | -122.41311653672899 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7495331145231, -122.413116536729) | ||
| 160 | 160 | 934603 | May Catering 37 | Truck 1 | 702000 | 16TH ST: MISSOURI ST to CONNECTICUT ST (1000 - 1099) | 1006 16TH ST | 3833002 | 3833 134 | 002 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013316.557 | 2107189.386 | 37.7666898573867 | -122.39718232278 | 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/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7666898573867, -122.39718232278) | ||
| 161 | 161 | 934600 | May Catering 37 | Truck 1 | 193201 | 03RD ST: 24TH ST to 25TH ST (2800 - 2898) -- WEST -- | 2800 03RD ST | 4246001 | 4246 135 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015771.1389999995 | 2102415.24 | 37.753717416902106 | -122.38835902104401 | 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:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7537174169021, -122.388359021044) | ||
| 162 | 162 | 934574 | May Catering 37 | Truck 1 | 8700000 | MARIN ST: KANSAS ST to HWY 101 N ON RAMP (2500 - 2599) | 2525 MARIN ST | 4343001D | 4343 101 | 001D | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6011789.79 | 2100273.801 | 37.7476160722331 | -122.401976975724 | 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:7AM-8AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7476160722331, -122.401976975724) | ||
| 164 | 164 | 934622 | May Catering 37 | Truck 1 | 7428000 | JAMESTOWN AVE: GRIFFITH ST to CORONADO ST (800 - 850) | 800 JAMESTOWN AVE | 4973034 | 4973 137 | 034 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015040.705 | 2088854.908 | 37.7164430021474 | -122.389937879321 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Su:9AM-10AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7164430021474, -122.389937879321) | ||
| 165 | 165 | 934620 | May Catering 37 | Truck 1 | 9050000 | MINNA ST: 10TH ST to 11TH ST (900 - 999) | 911 MINNA ST | 3510043 | 3510 138 | 043 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008034.46 | 2110104.285 | 37.7743980109403 | -122.415658655811 | 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:8PM-9PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7743980109403, -122.415658655811) | ||
| 166 | 166 | 934614 | May Catering 37 | Truck 1 | 5340000 | EVANS AVE: NAPOLEON ST \ TOLAND ST to MARIN ST (2000 - 2099) | 2090 EVANS AVE | 4347A003 | 4347A 139 | 003 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013578.61428 | 2100360.92261 | 37.747954964567796 | -122.395797384916 | 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:3PM-4PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7479549645678, -122.395797384916) | ||
| 168 | 168 | 934573 | May Catering 37 | Truck 1 | 12626000 | TOLAND ST: END to MCKINNON AVE (600 - 799) | 600 TOLAND ST | 5285A011 | 5285A 141 | 011 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012349.895 | 2098741.535 | 37.7434400420051 | -122.399932569577 | 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:7AM-8AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7434400420051, -122.399932569577) | ||
| 169 | 169 | 934582 | May Catering 37 | Truck 1 | 1259000 | 23RD ST: HARRISON ST to TREAT AVE (3000 - 3053) | 3000 23RD ST | 3639004 | 3639 127 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | 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 | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||
| 171 | 171 | 934607 | May Catering 37 | Truck 1 | 792000 | 17TH ST: TREAT AVE to FOLSOM ST (3025 - 3099) | 3030 17TH ST | 3572005 | 3572 143 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008506.685 | 2106321.603 | 37.764038182817394 | -122.41375751658899 | 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.7640381828174, -122.413757516589) | ||
| 172 | 172 | 934586 | May Catering 37 | Truck 1 | 12685000 | TREAT AVE: MISTRAL ST to END (630 - 699) | 630 TREAT AVE | 3593038 | 3593 144 | 038 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008391.816000001 | 2104835.571 | 37.7599514294279 | -122.414049680224 | 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/11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7599514294279, -122.414049680224) | ||
| 173 | 173 | 934591 | May Catering 37 | Truck 1 | 13766000 | YORK ST: MARIPOSA ST to 18TH ST (500 - 599) | 501 YORK ST | 4015008 | 4015 145 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009887.392999999 | 2105884.09 | 37.7629143116115 | -122.40895116153798 | 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:10AM-11AM/12PM-1PM/2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7629143116115, -122.408951161538) | ||
| 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) |
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");