Mobile_Food_Facility_Permit

Data source: data.sfgov.org

4 rows where dayshours = "Mo/We/Fr:9AM-3PM"

View and edit SQL

Suggested facets: Applicant, Status, FoodItems, Approved, Received, ExpirationDate, 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
436 949451 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 9301000 MONTGOMERY ST: CALIFORNIA ST to SACRAMENTO ST (400 - 499) 451 MONTGOMERY ST 0240001 0240 302 001 17MFF-0158 APPROVED 5 Rotisserie Chicken; Ribs; Pork Loin; Roasted Potatoes; Chicken Wrap; Kale Salad; Drinks 6011767.937000001 2117013.017 37.7935769332618 -122.40322987670099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0158&ExportPDF=1&Filename=17MFF-0158_schedule.pdf Mo/We/Fr:9AM-3PM   03/15/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7935769332618, -122.403229876701)
438 949453 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 3419000 BUSH ST: 01ST ST \ MARKET ST to BATTERY ST (1 - 99) 1 BUSH ST 0290011 0290 16 011 17MFF-0159 APPROVED 5 Rotisserie Chicken: Ribs: Kickass Salad: Potatos w/fat dripping: chicken wrap. 6012652.373 2116027.943 37.7909215072692 -122.400100423738 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0159&ExportPDF=1&Filename=17MFF-0159_schedule.pdf Mo/We/Fr:9AM-3PM   03/15/2017 12:00:00 AM 2017-03-15 0 03/15/2018 12:00:00 AM (37.7909215072692, -122.400100423738)
468 676797 Peruchi Food Truck,LLC 85 Truck 1 4972000 DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) 253 DRUMM ST 0203013 0203 319 013 15MFF-0023 EXPIRED 2 Peruvian Chinese Food. Lomo Saltado: Arroz Con Pollo: Tipa Kay: Yuca Fries 6013507.554 2117905.099 37.796123380252105 -122.39727320433799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0023&ExportPDF=1&Filename=15MFF-0023_schedule.pdf Mo/We/Fr:9AM-3PM   03/15/2016 12:00:00 AM 2015-03-02 0 03/15/2017 12:00:00 AM (37.7961233802521, -122.397273204338)
629 850007 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 2754000 BATTERY ST: CALIFORNIA ST to HALLECK ST (200 - 230) 225 BATTERY ST 0238002 0238 34 002 16MFF-0123 APPROVED 5 Rotisserie Chicken; Ribs; Pork Loin; Roasted Potatoes; Chicken Wrap; Kale Salad; Drinks 6012600.766 2116948.597 37.7934465278161 -122.400343675592 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0123&ExportPDF=1&Filename=16MFF-0123_schedule.pdf Mo/We/Fr:9AM-3PM   02/24/2017 12:00:00 AM 2016-05-18 0 03/15/2018 12:00:00 AM (37.7934465278161, -122.400343675592)

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