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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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");