Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, cnn, LocationDescription, Address, blocklot, block, lot, permit, FoodItems, X, Y, Latitude, Longitude, Schedule, Received, PriorPermit, ExpirationDate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | 837171 | Chilifruit 29 | Push Cart 2 | 1346000 | 24TH ST: MISSION ST to OSAGE ALY (3300 - 3322) | Assessors Block /Lot | 16MFF-0135 | REQUESTED 1 | Mangoneadas: Fruit snacks: Chamoyadas: Bionicos | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0135&ExportPDF=1&Filename=16MFF-0135_schedule.pdf | 2016-08-05 | 0 | (0, 0) | |||||||||
45 | 45 | 558549 | Raspados El Yocateco 22 | Push Cart 2 | 9117000 | MISSION ST: 17TH ST to CLARION ALY (2100 - 2131) | 2100 MISSION ST | 3576001 | 3576 39 | 001 | 14MFF-0101 | REQUESTED 1 | Shaved Ice: Tamarind: Strawberry: Lemon: horchata: hibiscus | 6006755.774 | 2106062.3680000002 | 37.763227902543896 | -122.419795019128 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=14MFF-0101&ExportPDF=1&Filename=14MFF-0101_schedule.pdf | Su/Tu/Th:12PM-6PM | 2014-05-22 | 0 | (37.7632279025439, -122.419795019128) | |||
611 | 611 | 953001 | Wonder Philly 115 | Push Cart 2 | 270002 | 04TH ST: BERRY ST to CHANNEL ST (900 - 999) | 960 04TH ST | 8708002 | 8708 86 | 002 | 17MFF-0166 | REQUESTED 1 | Hot dogs: sausages: cheesesteaks: chips: drinks | 6014277.187000001 | 2109955.224 | 37.7743376663696 | -122.394053286313 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0166&ExportPDF=1&Filename=17MFF-0166_schedule.pdf | Mo-We:9AM-5PM | 2017-03-20 | 0 | 04/01/2018 12:00:00 AM | (37.7743376663696, -122.394053286313) | ||
31 | 31 | 665120 | Gour Chaat 10 | Push Cart 2 | 3524000 | CALIFORNIA ST: DRUMM ST to DAVIS ST (1 - 99) | 1 CALIFORNIA ST | 0264004 | 0264 30 | 004 | 15MFF-0044 | REQUESTED 1 | Chaats: vegeterian wraps: chai: soft drinks | 6013552.57 | 2116844.5 | 37.7932137316634 | -122.397043036718 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0044&ExportPDF=1&Filename=15MFF-0044_schedule.pdf | Th/Fr/Sa:8AM-6PM | 2015-03-09 | 0 | (37.7932137316634, -122.397043036718) | |||
47 | 47 | 735315 | Ziaurehman Amini 16 | Push Cart 2 | 4969000 | DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6) | 1 CALIFORNIA ST | 0264004 | 0264 30 | 004 | 15MFF-0159 | REQUESTED 1 | 6013552.57 | 2116844.5 | 37.7932137316634 | -122.397043036718 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0159&ExportPDF=1&Filename=15MFF-0159_schedule.pdf | 2015-12-31 | 0 | 03/15/2016 12:00:00 AM | (37.7932137316634, -122.397043036718) | ||||
51 | 51 | 773095 | Athena SF Gyro 23 | Push Cart 2 | 30747000 | MARKET ST: 11TH ST intersection | 10 SOUTH VAN NESS AVE | 3506004 | 3506 44 | 004 | 15MFF-0145 | REQUESTED 1 | Gyro pita bread (Lamb or chicken): lamb over rice: chicken over rice: chicken biryani rice: soft drinks | 6006927.466 | 2110076.4390000002 | 37.774259263059996 | -122.419485988398 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0145&ExportPDF=1&Filename=15MFF-0145_schedule.pdf | We/Th/Fr:6AM-6PM | 2015-09-01 | 0 | (37.77425926306, -122.419485988398) | |||
139 | 139 | 934362 | Mob Dog 44 | Push Cart 2 | 8745201 | MARKET ST: 03RD ST \ KEARNY ST to GRANT AVE \ OFARRELL ST (700 - 748) -- NORTH -- | 720 MARKET ST | 0312004 | 0312 116 | 004 | 17MFF-0068 | REQUESTED 1 | Hot Dogs: Chips: Bottled Drinks | 6011475.041 | 2114841.614 | 37.7875984155546 | -122.404090439434 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0068&ExportPDF=1&Filename=17MFF-0068_schedule.pdf | Th/Fr/Sa:8AM-10PM | 2017-02-13 | 0 | 05/06/2018 12:00:00 AM | (37.7875984155546, -122.404090439434) | ||
170 | 170 | 934559 | The Sandwich Stand, LLC. 45 | Push Cart 2 | 8627000 | MAIN ST: MARKET ST to MISSION ST (1 - 99) | 58 MAIN ST | 3711005 | 3711 142 | 005 | 17MFF-0108 | REQUESTED 1 | Vietnamese sandwiches: spring rolls: bottle water: can soda: chicken and shrimp rice noodles: rice with chicken: chicken salad: noodle soup. | 6013902.41 | 2116435.193 | 37.792109338609 | -122.39580386550199 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0108&ExportPDF=1&Filename=17MFF-0108_schedule.pdf | Mo-Fr:8AM-5PM | 2017-02-13 | 0 | 05/02/2018 12:00:00 AM | (37.792109338609, -122.395803865502) | ||
52 | 52 | 773105 | Athena SF Gyro 23 | Push Cart 2 | 417000 | 08TH ST: BRANNAN ST to TOWNSEND ST (600 - 699) | 699 08TH ST | 3783009 | 3783 45 | 009 | 15MFF-0145 | REQUESTED 1 | Gyro pita bread (Lamb or chicken): lamb over rice: chicken over rice: chicken biryani rice: soft drinks | 6011509.501 | 2108803.8340000003 | 37.7710219992437 | -122.403546254184 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0145&ExportPDF=1&Filename=15MFF-0145_schedule.pdf | Mo-We:6AM-6PM | 2015-09-01 | 0 | (37.7710219992437, -122.403546254184) | |||
66 | 66 | 839523 | Halal Cart of San Francisco 30 | Push Cart 2 | 8741201 | MARKET ST: FREMONT ST \ FRONT ST to 01ST ST \ BUSH ST (400 - 498) -- NORTH -- | 1 FRONT ST | 0266009 | 0266 55 | 009 | 16MFF-0136 | REQUESTED 1 | Gyro; Chicken over rice; Gyro over rice; | 6013006.032000001 | 2116325.123 | 37.7917572059444 | -122.39889763689199 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0136&ExportPDF=1&Filename=16MFF-0136_schedule.pdf | 2016-08-12 | 0 | (37.7917572059444, -122.398897636892) | ||||
21 | 21 | 735318 | Ziaurehman Amini 16 | Push Cart 2 | 30727000 | MARKET ST: DRUMM ST intersection | 5 THE EMBARCADERO | 0234017 | 0234 20 | 017 | 15MFF-0159 | REQUESTED 1 | 6013916.72 | 2117244.027 | 37.794331003246796 | -122.395811053023 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0159&ExportPDF=1&Filename=15MFF-0159_schedule.pdf | 2015-12-31 | 0 | 03/15/2016 12:00:00 AM | (37.7943310032468, -122.395811053023) | ||||
435 | 435 | 948140 | Eli's Hot Dogs 78 | Push Cart 2 | 7504000 | JERROLD AVE: BARNEVELD AVE to END (2351 - 2369) | 101 BAY SHORE BLVD | 5559018 | 5559 46 | 018 | 17MFF-0155 | REQUESTED 1 | various styles of hot dogs & sausages: chips: breakfast sandwiches: chili: soda: water: | 6011376.107000001 | 2100039.012 | 37.7469482955131 | -122.40339096031299 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0155&ExportPDF=1&Filename=17MFF-0155_schedule.pdf | Mo/Tu/We/Th/Fr:9AM-5PM | 2017-03-14 | 1 | 03/15/2017 12:00:00 AM | (37.7469482955131, -122.403390960313) | ||
547 | 547 | 961020 | Let's Be Frank 102 | Push Cart 2 | 6816000 | HAYES ST: GOUGH ST to OCTAVIA ST (400 - 499) | 425 HAYES ST | 0817025 | 0817 367 | 025 | 17MFF-0180 | REQUESTED 1 | Hot dogs and chili | 6005815.063999999 | 2110939.7169999997 | 37.7765668965195 | -122.42339537672702 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf | Su/We:11AM-5PM | 2017-04-12 | 0 | 03/15/2018 12:00:00 AM | (37.7765668965195, -122.423395376727) | ||
14 | 14 | 639666 | Afghani Rice 11 | Push Cart 2 | 5057000 | EDDY ST: POWELL ST to CYRIL MAGNIN ST (1 - 49) | 1 POWELL ST | 0330027 | 0330 13 | 027 | 15MFF-0115 | REQUESTED 1 | Rice - Chicken & Beef: sauce: cold drinks: hot drinks | 6010285.677019999 | 2113807.83084 | 37.784693367825795 | -122.40813248678002 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0115&ExportPDF=1&Filename=15MFF-0115_schedule.pdf | Th/Fr/Sa:11AM-3PM | 2015-04-07 | 0 | 03/15/2016 12:00:00 AM | (37.7846933678258, -122.40813248678) | ||
548 | 548 | 961021 | Let's Be Frank 102 | Push Cart 2 | 8393001 | LINDEN ST: GOUGH ST to OCTAVIA ST (300 - 399) | 404 OCTAVIA ST | 0817033 | 0817 367 | 033 | 17MFF-0180 | REQUESTED 1 | Hot dogs and chili | 6005585.672 | 2110752.1969999997 | 37.776039062665895 | -122.424175571492 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf | Fr:11AM-5PM | 2017-04-12 | 0 | 03/15/2018 12:00:00 AM | (37.7760390626659, -122.424175571492) | ||
588 | 588 | 965705 | Mission Dogs 107 | Push Cart 2 | 3790000 | CASTRO ST: 17TH ST \ MARKET ST to 18TH ST (400 - 499) | 498 CASTRO ST | 2647033 | 2647 386 | 033 | 17MFF-0183 | REQUESTED 1 | Hotdogs: chili: chips: drinks | 6002252.878 | 2105381.5609999998 | 37.761103875721105 | -122.435320318835 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0183&ExportPDF=1&Filename=17MFF-0183_schedule.pdf | 2017-04-24 | 0 | (37.7611038757211, -122.435320318835) | ||||
12 | 12 | 665094 | Gour Chaat 10 | Push Cart 2 | 8742101 | MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | 555 MARKET ST | 3708057 | 3708 4 | 057 | 15MFF-0044 | REQUESTED 1 | Chaats: vegeterian wraps: chai: soft drinks | 6012693.864 | 2115651.384 | 37.7898898782098 | -122.399930411351 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0044&ExportPDF=1&Filename=15MFF-0044_schedule.pdf | Mo-We:8AM-6PM | 2015-03-09 | 0 | (37.7898898782098, -122.399930411351) | |||
34 | 34 | 656150 | Afghani Rice 11 | Push Cart 2 | 8742101 | MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | 555 MARKET ST | 3708057 | 3708 4 | 057 | 15MFF-0115 | REQUESTED 1 | Rice - Chicken & Beef: sauce: cold drinks: hot drinks | 6012693.864 | 2115651.384 | 37.7898898782098 | -122.399930411351 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=15MFF-0115&ExportPDF=1&Filename=15MFF-0115_schedule.pdf | Th/Fr/Sa:10AM-8PM | 2015-04-07 | 0 | 03/15/2016 12:00:00 AM | (37.7898898782098, -122.399930411351) | ||
65 | 65 | 839524 | Halal Cart of San Francisco 30 | Push Cart 2 | 8742101 | MARKET ST: 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | 555 MARKET ST | 3708057 | 3708 4 | 057 | 16MFF-0136 | REQUESTED 1 | Gyro; Chicken over rice; Gyro over rice; | 6012693.864 | 2115651.384 | 37.7898898782098 | -122.399930411351 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=16MFF-0136&ExportPDF=1&Filename=16MFF-0136_schedule.pdf | 2016-08-12 | 0 | (37.7898898782098, -122.399930411351) | ||||
536 | 536 | 959619 | Kabob Trolley, LLC 101 | Push Cart 2 | 267001 | 04TH ST: TOWNSEND ST to KING ST (700 - 799) | 298 KING ST | 8702606 | 8702 359 | 606 | 17MFF-0177 | REQUESTED 1 | Gyros: Kebobs: refreshments and dessert | 6014485.06287 | 2111154.5175099997 | 37.777642208509995 | -122.393418145932 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0177&ExportPDF=1&Filename=17MFF-0177_schedule.pdf | Mo-Su:10AM-8PM | 2017-04-07 | 0 | 03/15/2018 12:00:00 AM | (37.77764220851, -122.393418145932) |
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");