Mobile_Food_Facility_Permit

Data source: data.sfgov.org

9 rows where Approved = "03/23/2017 12:00:00 AM" and "Received" is on date 2017-02-13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Applicant, cnn, LocationDescription, block, lot, permit, FoodItems, Schedule, dayshours, 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
480 480 934539 Tacos Rodriguez 91 Truck 1 5331101 EVANS AVE: KEITH ST to MENDELL ST (1201 - 1399) -- SOUTH -- 1275 EVANS AVE 5237033 5237 324 033 17MFF-0097 APPROVED 5 Tacos: burritos: quesadillas: soda & water 6017367.817000001 2097063.665 37.739111429745 -122.382464971136 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0097&ExportPDF=1&Filename=17MFF-0097_schedule.pdf Mo-Su:8AM-8PM   03/23/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.739111429745, -122.382464971136)
482 482 934542 Think is Good Inc. 92 Truck 1 5169000 ELLIS ST: 04TH ST \ MARKET ST \ STOCKTON ST to POWELL ST (1 - 99) 34 ELLIS ST 0307008 0307 326 008 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito 6009885.084 2114861.905 37.787565165378794 -122.40959283347999 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Sa-Su:11AM-2PM/1PM-4PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7875651653788, -122.40959283348)
486 486 934540 Think is Good Inc. 92 Truck 1 9089000 MISSION ST: ECKER ST to SHAW ALY (521 - 548) 536 MISSION ST 3708098 3708 4 098 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito 6012988.85269 2115411.9566599997 37.789248908413704 -122.39889295934601 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Mo/We/Fr:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7892489084137, -122.398892959346)
487 487 934541 Think is Good Inc. 92 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 400 CALIFORNIA ST 0238003 0238 34 003 17MFF-0098 APPROVED 5 Sushi Burrito: Chicken Burrito: Tempura Burrito     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0098&ExportPDF=1&Filename=17MFF-0098_schedule.pdf Tu/Th:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (0, 0)
489 489 934537 Tacos Rodriguez 91 Truck 1 11542000 SANSOME ST: SUTTER ST to BUSH ST (1 - 99) 1 SANSOME ST 0289003 0289 297 003 17MFF-0097 APPROVED 5 Tacos: burritos: quesadillas: soda & water 6012406.465 2115874.016 37.790485146128 -122.40094044068998 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0097&ExportPDF=1&Filename=17MFF-0097_schedule.pdf Mo-Fr:11AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.790485146128, -122.40094044069)
490 490 934538 Tacos Rodriguez 91 Truck 1 9794000 OAKDALE AVE: INDUSTRIAL ST \ SELBY ST to TOLAND ST (2100 - 2199) 2198 OAKDALE AVE 5590A008 5590A 330 008 17MFF-0097 APPROVED 5 Tacos: burritos: quesadillas: soda & water 6011973.411 2097858.615 37.740994735002396 -122.40117233538601 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0097&ExportPDF=1&Filename=17MFF-0097_schedule.pdf Mo-Fr:8AM-5PM   03/23/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7409947350024, -122.401172335386)
492 492 934332 Lobsta Truck 94 Truck 1 3528000 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (400 - 448) 430 CALIFORNIA ST 0239029 0239 81 029 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012181.836 2116889.9790000003 37.7932622069231 -122.40178909136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_schedule.pdf Mo/We/Fr:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7932622069231, -122.401789091363)
493 493 934331 Lobsta Truck 94 Truck 1 9090000 MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) 560 MISSION ST 3708095 3708 4 095 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012851.27 2115274.827 37.788864715342996 -122.39935935136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_schedule.pdf Tu/Th:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.788864715343, -122.399359351363)
494 494 934330 Lobsta Truck 94 Truck 1 10454000 PINE ST: FRONT ST to BATTERY ST (100 - 199) 100 PINE ST 0262020 0262 332 020 17MFF-0066 APPROVED 5 Lobster rolls: crab rolls: clam chowder: lobster bisque: chips: lemonade: drinks 6012991.557999999 2116647.1890000002 37.7926407167337 -122.39897033211099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0066&ExportPDF=1&Filename=17MFF-0066_schedule.pdf Mo/We/Fr:10AM-3PM   03/23/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7926407167337, -122.398970332111)

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 66.162ms · Data source: data.sfgov.org