Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Applicant, FacilityType, lot, permit, FoodItems, Schedule, dayshours, Received, PriorPermit
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
660 | 660 | 1013321 | Wu Wei LLC dba MoBowl 125 | Truck 1 | 6438001 | GREEN ST: THE EMBARCADERO to FRONT ST (1 - 49) | 900 FRONT ST | 0137001 | 0137 409 | 001 | 17MFF-0191 | REQUESTED 1 | Various types of meat: veggie: and seafood bowls. | 6012874.622 | 2119410.253 | 37.800220915592206 | -122.399569018577 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf | Fr:10AM-4PM | 2017-08-31 | 1 | 03/15/2018 12:00:00 AM | (37.8002209155922, -122.399569018577) | ||
657 | 657 | 1013323 | Wu Wei LLC dba MoBowl 125 | Truck 1 | 13403000 | WASHINGTON ST: THE EMBARCADERO to DRUMM ST (1 - 99) | 370 DRUMM ST | 0201012 | 0201 293 | 012 | 17MFF-0191 | REQUESTED 1 | Various types of meat: veggie: and seafood bowls. | 6013693.222 | 2118189.172 | 37.7969137124835 | -122.396650675264 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf | Su:10AM-11PM | 2017-08-31 | 1 | 03/15/2018 12:00:00 AM | (37.7969137124835, -122.396650675264) | ||
640 | 640 | 1013324 | Wu Wei LLC dba MoBowl 125 | Truck 1 | 4972000 | DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) | 253 DRUMM ST | 0203013 | 0203 319 | 013 | 17MFF-0191 | REQUESTED 1 | Various types of meat: veggie: and seafood bowls. | 6013507.554 | 2117905.099 | 37.796123380252105 | -122.39727320433799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf | Tu/Th:10AM-3PM | 2017-08-31 | 1 | 03/15/2018 12:00:00 AM | (37.7961233802521, -122.397273204338) | ||
179 | 179 | 934995 | Breaking Bread Inc. 47 | Truck 1 | 2754000 | BATTERY ST: CALIFORNIA ST to HALLECK ST (200 - 230) | 300 CALIFORNIA ST | 0238002 | 0238 34 | 002 | 17MFF-0124 | REQUESTED 1 | prepackaged food | 6012600.766 | 2116948.597 | 37.7934465278161 | -122.400343675592 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0124&ExportPDF=1&Filename=17MFF-0124_schedule.pdf | Mo/We/Fr:2PM-6PM | 2017-02-14 | 0 | 03/15/2018 12:00:00 AM | (37.7934465278161, -122.400343675592) | ||
650 | 650 | 1024812 | Plaza Garibaldy 18 | Truck 1 | 3420000 | BUSH ST: BATTERY ST to SANSOME ST (100 - 199) | 1 BUSH ST | 0290011 | 0290 16 | 011 | 17MFF-0184 | REQUESTED 1 | Tacos: burritos: quesadillas | 6012652.373 | 2116027.943 | 37.7909215072692 | -122.400100423738 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf | Mo/We/Fr:10AM-3PM | 2017-05-10 | 0 | 03/15/2018 12:00:00 AM | (37.7909215072692, -122.400100423738) | ||
633 | 633 | 976033 | Plaza Garibaldy 18 | Truck 1 | 9297000 | MONTGOMERY ST: POST ST to SUTTER ST (1 - 99) | 1 MONTGOMERY ST | 0292002 | 0292 304 | 002 | 17MFF-0184 | REQUESTED 1 | Tacos: burritos: quesadillas | 6011970.278 | 2115432.874 | 37.789249534075104 | -122.402418597294 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf | Mo/We/Fr:10AM-3PM | 2017-05-10 | 0 | 03/15/2018 12:00:00 AM | (37.7892495340751, -122.402418597294) | ||
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) | ||
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) | ||
658 | 658 | 1013320 | Wu Wei LLC dba MoBowl 125 | Truck 1 | 7033000 | HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) | 500 HOWARD ST | 3721011 | 3721 104 | 011 | 17MFF-0191 | REQUESTED 1 | Various types of meat: veggie: and seafood bowls. | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf | Mo/Fr:10AM-2PM | 2017-08-31 | 1 | 03/15/2018 12:00:00 AM | (0, 0) | ||||
655 | 655 | 1024769 | Plaza Garibaldy 18 | Truck 1 | 7033000 | HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) | 540 HOWARD ST | 3721015 | 3721 104 | 015 | 17MFF-0184 | REQUESTED 1 | Tacos: burritos: quesadillas | 6013457.851 | 2114931.191 | 37.7879549596858 | -122.397236543731 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf | Mo-We:3PM-8PM | 2017-05-10 | 0 | 03/15/2018 12:00:00 AM | (37.7879549596858, -122.397236543731) | ||
654 | 654 | 1020424 | Kabob Trolley, LLC 101 | Truck 1 | 9101000 | MISSION ST: 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) | 1133 MISSION ST | 3727096 | 3727 407 | 096 | 17MFF-0192 | REQUESTED 1 | Halal Gyro and Cheesesteaks | 6009260.818 | 2111511.319 | 37.7783302557659 | -122.411515865268 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0192&ExportPDF=1&Filename=17MFF-0192_schedule.pdf | Mo/Tu/Fr:9AM-4PM | 2017-09-19 | 0 | 03/15/2018 12:00:00 AM | (37.7783302557659, -122.411515865268) | ||
659 | 659 | 1013322 | Wu Wei LLC dba MoBowl 125 | Truck 1 | 12160001 | STEUART ST: HOWARD ST to END (200 - 299) | 75 HOWARD ST | 3741031 | 3741 408 | 031 | 17MFF-0191 | REQUESTED 1 | Various types of meat: veggie: and seafood bowls. | 6015092.174 | 2116210.269 | 37.791557864154896 | -122.391671499786 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf | Mo/We:10AM-3PM | 2017-08-31 | 1 | 03/15/2018 12:00:00 AM | (37.7915578641549, -122.391671499786) | ||
567 | 567 | 963995 | Singh Brothers Ice Cream 105 | Truck 1 | 4938000 | KISKA RD: DORMITORY RD \ KIRKWOOD AVE to REARDON RD (141 - 199) | 195 KISKA RD | 4700052 | 4700 373 | 052 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6018976.06063 | 2093508.4787 | 37.729438288454 | -122.376657800723 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.729438288454, -122.376657800723) | ||
571 | 571 | 963991 | Singh Brothers Ice Cream 105 | Truck 1 | 6671000 | HARBOR RD: NORTHRIDGE RD to INGALLS ST (1 - 299) | 297 HARBOR RD | 4712008 | 4712 376 | 008 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017903.776000001 | 2094986.9640000002 | 37.733438811640795 | -122.38046754951799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7334388116408, -122.380467549518) | ||
572 | 572 | 963994 | Singh Brothers Ice Cream 105 | Truck 1 | 7223000 | INGALLS ST: GEORGE CT to OAKDALE AVE (1300 - 1399) | 1309 INGALLS ST | 4714002 | 4714 377 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017478.204 | 2093879.426 | 37.7303742378628 | -122.38186187865699 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7303742378628, -122.381861878657) | ||
585 | 585 | 963988 | Singh Brothers Ice Cream 105 | Truck 1 | 10218000 | PALOU AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1101 PALOU AVE | 4757024 | 4757 385 | 024 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017464.808999999 | 2093259.551 | 37.7286714428179 | -122.38186508864099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7286714428179, -122.381865088641) | ||
586 | 586 | 963992 | Singh Brothers Ice Cream 105 | Truck 1 | 10810000 | QUESADA AVE: CRISP RD to HAWES ST (1170 - 1199) | 1191 QUESADA AVE | 4763042 | 4763 245 | 042 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017387.966 | 2092923.5080000001 | 37.727744490701106 | -122.382107375242 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7277444907011, -122.382107375242) | ||
573 | 573 | 963993 | Singh Brothers Ice Cream 105 | Truck 1 | 11783000 | SHAFTER AVE: HAWES ST to INGALLS ST (1200 - 1299) | 1207 SHAFTER AVE | 4792001A | 4792 260 | 001A | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6016941.58 | 2092555.108 | 37.726708272962206 | -122.3836249172 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7267082729622, -122.3836249172) | ||
568 | 568 | 963990 | Singh Brothers Ice Cream 105 | Truck 1 | 7479000 | JENNINGS ST: VAN DYKE AVE to WALLACE AVE (2100 - 2199) | 2115 JENNINGS ST | 4828021 | 4828 250 | 021 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015486.282000001 | 2092591.619 | 37.7267279782571 | -122.388658428832 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7267279782571, -122.388658428832) | ||
575 | 575 | 963986 | Singh Brothers Ice Cream 105 | Truck 1 | 13356000 | WALLACE AVE: JENNINGS ST to KEITH ST (1500 - 1599) | 1550 WALLACE AVE | 4829006 | 4829 261 | 006 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015093.174 | 2092759.834 | 37.727168068782 | -122.390029148701 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.727168068782, -122.390029148701) | ||
584 | 584 | 963989 | Singh Brothers Ice Cream 105 | Truck 1 | 13780000 | YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) | 1420 YOSEMITE AVE | 4831012 | 4831 32 | 012 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015609.592 | 2092025.9880000001 | 37.7251817007288 | -122.38819268844401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7251817007288, -122.388192688444) | ||
576 | 576 | 963985 | Singh Brothers Ice Cream 105 | Truck 1 | 2710000 | BANCROFT AVE: JENNINGS ST to KEITH ST (1500 - 1599) | 1562 BANCROFT AVE | 4849006 | 4849 379 | 006 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014513.081 | 2092146.105 | 37.725450702172296 | -122.391991641418 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7254507021723, -122.391991641418) | ||
574 | 574 | 963984 | Singh Brothers Ice Cream 105 | Truck 1 | 4908000 | DONNER AVE: INGALLS ST to JENNINGS ST (1400 - 1499) | 1475 DONNER AVE | 4910023 | 4910 378 | 023 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014572.169 | 2091177.246 | 37.722793688759296 | -122.391719666472 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7227936887593, -122.391719666472) | ||
569 | 569 | 963987 | Singh Brothers Ice Cream 105 | Truck 1 | 5599000 | FITZGERALD AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1104 FITZGERALD AVE | 4914022 | 4914 374 | 022 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015221.628 | 2090210.3169999998 | 37.7201747226493 | -122.389407114342 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7201747226493, -122.389407114342) | ||
570 | 570 | 963978 | Singh Brothers Ice Cream 105 | Truck 1 | 6961000 | HOLLISTER AVE: HAWES ST to INGALLS ST (1000 - 1099) | 1000 HOLLISTER AVE | 4943002 | 4943 375 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014891.341 | 2089767.246 | 37.7189398190959 | -122.390517872066 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7189398190959, -122.390517872066) | ||
577 | 577 | 963979 | Singh Brothers Ice Cream 105 | Truck 1 | 7252000 | INGERSON AVE: JENNINGS ST to 03RD ST (1100 - 1199) | 1173 INGERSON AVE | 4968035 | 4968 380 | 035 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013341.727999999 | 2090348.3630000001 | 37.720449362659394 | -122.395915014237 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7204493626594, -122.395915014237) | ||
582 | 582 | 963980 | Singh Brothers Ice Cream 105 | Truck 1 | 6548000 | GRIFFITH ST: INGERSON AVE to JAMESTOWN AVE (2900 - 2999) | 2900 GRIFFITH ST | 4973001 | 4973 137 | 001 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015142.712 | 2089052.53 | 37.716991290324 | -122.38959908417 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.716991290324, -122.38959908417) | ||
580 | 580 | 963981 | Singh Brothers Ice Cream 105 | Truck 1 | 7428000 | JAMESTOWN AVE: GRIFFITH ST to CORONADO ST (800 - 850) | 800 JAMESTOWN AVE | 4973034 | 4973 137 | 034 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015040.705 | 2088854.908 | 37.7164430021474 | -122.389937879321 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7164430021474, -122.389937879321) | ||
579 | 579 | 963982 | Singh Brothers Ice Cream 105 | Truck 1 | 7819000 | KEY AVE: JENNINGS ST to 03RD ST (1000 - 1068) | 1060 KEY AVE | 4994002 | 4994 382 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013314.667 | 2089893.9819999998 | 37.7192002177133 | -122.395976731096 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7192002177133, -122.395976731096) | ||
583 | 583 | 963983 | Singh Brothers Ice Cream 105 | Truck 1 | 7492000 | JENNINGS ST: KEY AVE to LE CONTE AVE (3400 - 3499) | 3444 JENNINGS ST | 4995005 | 4995 384 | 005 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013111.658 | 2089651.112 | 37.7185220485664 | -122.396661444417 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7185220485664, -122.396661444417) | ||
578 | 578 | 963997 | Singh Brothers Ice Cream 105 | Truck 1 | 9602000 | NIBBI CT: GILLETTE AVE to END (1 - 99) | 35 NIBBI CT | 5079004 | 5079 381 | 004 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013200.29 | 2086710.154 | 37.7104516918675 | -122.39614907899599 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7104516918675, -122.396149078996) | ||
566 | 566 | 963998 | Singh Brothers Ice Cream 105 | Truck 1 | 10327000 | PENINSULA AVE: BLANKEN AVE to LATHROP AVE (300 - 399) | 360 PENINSULA AVE | 5083009 | 5083 372 | 009 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6012192.793 | 2086872.475 | 37.710841283585296 | -122.399642614963 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:5PM-6PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7108412835853, -122.399642614963) | ||
581 | 581 | 963996 | Singh Brothers Ice Cream 105 | Truck 1 | 7895000 | KIRKWOOD AVE: NEWHALL ST to PHELPS ST (1600 - 1699) | 1698 KIRKWOOD AVE | 5279027 | 5279 383 | 027 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014750.982999999 | 2097205.93 | 37.7393571608675 | -122.39152281175899 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7393571608675, -122.391522811759) | ||
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");