Mobile_Food_Facility_Permit

Data source: data.sfgov.org

16 rows where Applicant = 81

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: block, Latitude, Longitude, dayshours, 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
443 443 934494 Steve's Mobile Deli 81 Truck 1 12471000 TEHAMA ST: 01ST ST to MALDEN ALY (1 - 90) 90 TEHAMA ST 3736094 3736 10 094 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6013381.047 2114491.944 37.7867446133897 -122.397471456326 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-10AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7867446133897, -122.397471456326)
444 444 934501 Steve's Mobile Deli 81 Truck 1 113000 01ST ST: LANSING ST to HARRISON ST \ I-80 E ON RAMP (362 - 399) 390 01ST ST 3749058 3749 305 058 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6014531.475 2114230.765 37.7860914634251 -122.3934729318 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:6AM-7AM/11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7860914634251, -122.3934729318)
447 447 934487 Steve's Mobile Deli 81 Truck 1 11089000 RIZAL ST: TANDANG SORA to LAPU-LAPU ST (11 - 51) 50 RIZAL ST 3751169 3751 307 169 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6012738.056 2112794.897 37.7820490943809 -122.399576873623 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:6AM-7AM/11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7820490943809, -122.399576873623)
448 448 934491 Steve's Mobile Deli 81 Truck 1 12547201 THE EMBARCADERO: KING ST \ TOWNSEND ST to BRANNAN ST (2 - 28) -- EAST -- 26 THE EMBARCADERO 3714002 3714 308 002 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6014481.146000001 2117181.855 37.79419167647521 -122.393853704254 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:7AM-8AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7941916764752, -122.393853704254)
449 449 934489 Steve's Mobile Deli 81 Truck 1 12160001 STEUART ST: HOWARD ST to END (200 - 299) 275 STEUART ST 3742008 3742 309 008 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6015483.32 2116134.215 37.7913707416848 -122.39031281210698 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:7AM-8AM/9AM-10AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7913707416848, -122.390312812107)
450 450 934496 Steve's Mobile Deli 81 Truck 1 13036000 UTAH ST: ALAMEDA ST to 15TH ST (100 - 199) 101 UTAH ST 3918009 3918 310 009 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6010687.387999999 2107677.16 37.7678824549751 -122.406310586005 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-10AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7678824549751, -122.406310586005)
452 452 934500 Steve's Mobile Deli 81 Truck 1 7032000 HOWARD ST: FREMONT ST to 01ST ST (400 - 499) 480 HOWARD ST 3725 103 3725 312 103 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6010621.259 2112197.958 37.780291820591295 -122.40685797796499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7802918205913, -122.406857977965)
453 453 934497 Steve's Mobile Deli 81 Truck 1 7832101 KING ST: 02ND ST to 03RD ST (101 - 199) -- SOUTH -- 145 KING ST 3794003C 3794 133 003C 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-10AM/12PM-1PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
454 454 934492 Steve's Mobile Deli 81 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 525 HOWARD ST 3736114 3736 10 114 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6013720.948 2114874.56 37.7878141077683 -122.396322298302 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:8AM-9AM/11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7878141077683, -122.396322298302)
455 455 934499 Steve's Mobile Deli 81 Truck 1 13570000 WELSH ST: ZOE ST to 04TH ST (1 - 99) 48 WELSH ST 3776043 3776 313 043 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6013456.1110000005 2111943.313 37.779750838619 -122.397032985161 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.779750838619, -122.397032985161)
456 456 934486 Steve's Mobile Deli 81 Truck 1 149000   860 02ND ST 3794003 3794 133 003 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:6AM-7AM/11AM-12PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
457 457 934490 Steve's Mobile Deli 81 Truck 1 2994000 BLUXOME ST: 05TH ST to 06TH ST (100 - 199) 175 BLUXOME ST 3785030 3785 183 030 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6012681.98651 2110002.5888400003 37.7743789308184 -122.399574742126 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:7AM-8AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7743789308184, -122.399574742126)
458 458 934498 Steve's Mobile Deli 81 Truck 1 10658000 POTRERO AVE: 10TH ST \ BRANNAN ST \ DIVISION ST to ALAMEDA ST (1 - 99) 66 POTRERO AVE 3906004 3906 314 004 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6010061.632 2107930.589 37.76854328902421 -122.408492892439 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-11AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7685432890242, -122.408492892439)
459 459 934493 Steve's Mobile Deli 81 Truck 1 6714000 HARRISON ST: 02ND ST to VASSAR PL (600 - 622) 600 HARRISON ST 3750073 3750 315 073 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6013811.922 2113531.578 37.7841316511211 -122.39591339799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-10AM/10AM-11AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7841316511211, -122.39591339799)
460 460 934495 Steve's Mobile Deli 81 Truck 1 258000 04TH ST: CLARA ST to HARRISON ST \ I-80 W ON RAMP (368 - 427) 390 04TH ST 3752011A 3752 194 011A 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6012592.22 2112350.039 37.780819486999505 -122.400050152139 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:9AM-10AM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7808194869995, -122.400050152139)
462 462 934488 Steve's Mobile Deli 81 Truck 1 148000 02ND ST: TOWNSEND ST to KING ST (700 - 799) 750 02ND ST 3794002A 3794 133 002A 17MFF-0091 APPROVED 5 Cold Truck: Pre-packaged sandwiches: Burgers: Hot Dogs: Muffin Sandwiches: Enchiladas: Bagels: Burritos: Salads: Snacks: Beverages 6015411.83 2111996.555 37.7800057026855 -122.390270961311 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0091&ExportPDF=1&Filename=17MFF-0091_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM   03/16/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7800057026855, -122.390270961311)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 40.475ms · Data source: data.sfgov.org