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