Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: block, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94 | 94 | 934561 | M M Catering 38 | Truck 1 | 9083000 | MISSION ST: STEUART ST to SPEAR ST (35 - 99) | 98 MISSION ST | 3713007 | 3713 79 | 007 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6014365.441000001 | 2116885.206 | 37.7933707169278 | -122.39423328044799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:7AM-9AM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7933707169278, -122.394233280448) | ||
| 100 | 100 | 934565 | M M Catering 38 | Truck 1 | 7173000 | ILLINOIS ST: 24TH ST to 25TH ST (1400 - 1499) | 1499 ILLINOIS ST | 4244002 | 4244 85 | 002 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6016265.425 | 2102158.675 | 37.753040320194295 | -122.38663176353799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:5PM-6PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7530403201943, -122.386631763538) | ||
| 116 | 116 | 934569 | M M Catering 38 | Truck 1 | 716000 | 16TH ST: HAMPSHIRE ST to BRYANT ST (2200 - 2399) | Assessors Block 3930A/Lot002 | 3930A002 | 3930A 95 | 002 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6009824.81 | 2107195.241 | 37.766510926908296 | -122.40926014493 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:7PM-8PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7665109269083, -122.40926014493) | ||
| 118 | 118 | 934570 | M M Catering 38 | Truck 1 | 7037000 | HOWARD ST: HAWTHORNE ST to 03RD ST (648 - 699) | 661 HOWARD ST | 3735040 | 3735 97 | 040 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6012797.551 | 2113994.294 | 37.785345676641796 | -122.39945527669799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:8PM-9PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7853456766418, -122.399455276698) | ||
| 120 | 120 | 934568 | M M Catering 38 | Truck 1 | 6603000 | HAIGHT ST: GOUGH ST to OCTAVIA ST (20 - 99) | 20 HAIGHT ST | 0853023 | 0853 99 | 023 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6005961.175 | 2109761.804 | 37.7733408773453 | -122.422806203983 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:6PM-8PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7733408773453, -122.422806203983) | ||
| 130 | 130 | 934562 | M M Catering 38 | Truck 1 | 2110000 | ALABAMA ST: 17TH ST to MARIPOSA ST (400 - 499) | 400 ALABAMA ST | 3968001 | 3968 107 | 001 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6008836.323 | 2106230.5409999997 | 37.7638066535277 | -122.412610953897 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:7AM-8AM/9AM-10AM/12PM-1PM/8PM-9PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7638066535277, -122.412610953897) | ||
| 134 | 134 | 934564 | M M Catering 38 | Truck 1 | 3144000 | BROADWAY: FRONT ST to BATTERY ST (100 - 199) | 100 BROADWAY | 0141003B | 0141 111 | 003B | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6012663.956 | 2118920.369 | 37.7988640669494 | -122.400263583781 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7988640669494, -122.400263583781) | ||
| 140 | 140 | 934560 | M M Catering 38 | Truck 1 | 9206000 | MISSISSIPPI ST: END to CESAR CHAVEZ ST (1200 - 1299) | 1200 MISSISSIPPI ST | 4288003 | 4288 117 | 003 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6014017.542 | 2101712.6890000002 | 37.7516910357229 | -122.39437421326299 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo/Tu/We/Th/Fr:12AM-5AM;Sa:2PM-6PM;Mo-Fr:3PM-6PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7516910357229, -122.394374213263) | ||
| 141 | 141 | 934563 | M M Catering 38 | Truck 1 | 12044000 | SPEAR ST: MARKET ST to MISSION ST (1 - 99) | 45 SPEAR ST | 3713006 | 3713 79 | 006 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6014186.566000001 | 2117071.214 | 37.793871507150605 | -122.39486523862101 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:7AM-8AM/9AM-11AM/12PM-1PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7938715071506, -122.394865238621) | ||
| 145 | 145 | 934572 | M M Catering 38 | Truck 1 | 6729000 | HARRISON ST: LANGTON ST to CHESLEY ST (1113 - 1144) | 1140 HARRISON ST | 3755023 | 3755 121 | 023 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6010297.8610000005 | 2110271.569 | 37.774984306068795 | -122.40784088806002 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:9PM-10PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7749843060688, -122.40784088806) | ||
| 150 | 150 | 934571 | M M Catering 38 | Truck 1 | 9094000 | MISSION ST: ANNIE ST to 03RD ST (663 - 699) | 667 MISSION ST | 3722067 | 3722 27 | 067 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6012350.571 | 2114444.914 | 37.7865580501799 | -122.40103337535 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:8PM-9PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7865580501799, -122.40103337535) | ||
| 163 | 163 | 934567 | M M Catering 38 | Truck 1 | 7196000 | INDIANA ST: 22ND ST to TUBBS ST (1000 - 1099) | 1095 INDIANA ST | 4170010 | 4170 136 | 010 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6015168.427 | 2103589.069 | 37.7569070856214 | -122.39052536813499 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:6PM-7PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7569070856214, -122.390525368135) | ||
| 167 | 167 | 934566 | M M Catering 38 | Truck 1 | 192201 | 03RD ST: 23RD ST to 24TH ST (2700 - 2798) -- WEST -- | 2700 03RD ST | 4230001 | 4230 140 | 001 | 17MFF-0109 | REQUESTED 1 | Cold Truck: sandwiches: corndogs: tacos: yogurt: snacks: candy: hot and cold drinks | 6015750.256 | 2102782.473 | 37.75472460401279 | -122.388456870373 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0109&ExportPDF=1&Filename=17MFF-0109_schedule.pdf | Mo-Fr:6PM-7PM | 2017-02-13 | 1 | 03/31/2018 12:00:00 AM | (37.7547246040128, -122.388456870373) |
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");