food-trucks

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidlocationidApplicantFacilityTypecnnLocationDescriptionAddressblocklotblocklotpermitStatusFoodItemsXYLatitudeLongitudeScheduledayshoursNOISentApprovedReceivedPriorPermitExpirationDateLocation
15 519938 12 1 0   Assessors Block 0733/Lot010 0733010 14 010 14MFF-0009 2 Watermelon 6003818.547 2113011.835 37.782143532929 -122.43044978594901 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0009&ExportPDF=1&Filename=14MFF-0009_schedule.pdf Mo-Su:10AM-7PM   02/25/2014 12:00:00 AM 2014-02-25 1 03/15/2015 12:00:00 AM (37.782143532929, -122.430449785949)
95 934625 37 1 0   Assessors Block 8710/Lot003 8710003 80 003 17MFF-0110 1 Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks 6014416.532000001 2108607.696 37.7706453983908 -122.39347693719999 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=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.7706453983908, -122.3934769372)
128 934626 37 1 0   Assessors Block /Lot       17MFF-0110 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&params=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 (0, 0)
194 934328 52 1 0   Assessors Block /Lot       17MFF-0064 5 Cold Truck: Sandwiches: snacks: prepackaged items: beverages:     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0064&ExportPDF=1&Filename=17MFF-0064_schedule.pdf Mo-Fr:10AM-11AM   02/28/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
224 945106 56 1 0   Assessors Block /Lot       17MFF-0137 5 Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf Mo-Fr:12PM-1PM   03/06/2017 12:00:00 AM 2017-03-06 1 03/15/2018 12:00:00 AM (0, 0)
281 934422 59 1 0   50 IVY ST 0811001 219 001 17MFF-0084 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6007197.302 2111480.029 37.77812837973379 -122.418652129997 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:11AM-12PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7781283797338, -122.418652129997)
512 934806 100 1 0   Assessors Block 4103/Lot023A 4103023A 344 023A 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6014314.885 2104114.856 37.7583033956425 -122.393514054817 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7583033956425, -122.393514054817)
514 934802 100 1 0   Assessors Block 5369/Lot003 5369003 345 003 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6011013.658 2096830.358 37.738117771591895 -122.40441846721201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7381177715919, -122.404418467212)
518 934805 100 1 0   Assessors Block 5216/Lot030 5216030 76 030 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6015212.23 2099399.714 37.7454064294164 -122.390081224847 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7454064294164, -122.390081224847)
520 934800 100 1 0   Assessors Block 4227/Lot012 4227012 349 012 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6014953.292 2102226.9669999997 37.7531551067155 -122.391174184456 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7531551067155, -122.391174184456)
527 934789 100 1 0   Assessors Block 8722/Lot003 8722003 268 003 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6014776.59744 2107430.47828 37.76743301733121 -122.392149114172 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7674330173312, -122.392149114172)
538 934793 100 1 0   Assessors Block 7295/Lot022 7295022 360 022 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 5989624.723999999 2094318.981 37.7300036831892 -122.478186325415 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7300036831892, -122.478186325415)
539 934795 100 1 0   Assessors Block 4172/Lot010 4172010 361 010 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6015746.892000001 2103656.591 37.7571245603861 -122.38852951525699 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7571245603861, -122.388529515257)
540 934796 100 1 0   Assessors Block 4058/Lot010 4058010 362 010 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6015895.442000001 2105131.652 37.7611829945051 -122.388118704077 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7611829945051, -122.388118704077)
544 934804 100 1 0   Assessors Block 4046/Lot001 4046001 366 001 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6016675.163 2105416.559 37.7620084580302 -122.38544181156799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7620084580302, -122.385441811568)
545 934792 100 1 0   Assessors Block 5598/Lot031 5598031 163 031 17MFF-0123 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6010555.3679599995 2097635.85527 37.740303872806 -122.406059743494 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.740303872806, -122.406059743494)
625 949473 121 1 0   Assessors Block 8711/Lot021 8711021 52 021 17MFF-0160 5 Italian subs: Cuban sandwich: Gyro 6014914.89374 2108873.14738 37.77140194658789 -122.391771646847 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0160&ExportPDF=1&Filename=17MFF-0160_schedule.pdf Sa-Su:11AM-10PM;Mo-Fr:6PM-8PM   08/21/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7714019465879, -122.391771646847)
672 593927 131 1 0   Assessors Block /Lot       14MFF-0105 1 All Food Items     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0105&ExportPDF=1&Filename=14MFF-0105_schedule.pdf       2014-06-16 0 03/15/2015 12:00:00 AM (0, 0)
Powered by Datasette · Query took 1.417ms · Data source: data.sfgov.org