Mobile_Food_Facility_Permit

Data source: data.sfgov.org

6 rows where Applicant = 70 sorted by Longitude

View and edit SQL

Suggested facets: FoodItems, dayshours, Approved, Received, 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)
399 947730 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 10624001 POST ST: MONTGOMERY ST to LICK PL (1 - 40) 1 POST ST 0311015 0311 284 015 17MFF-0151 APPROVED 5 Rotisserie chicken: pork loin: ribs: chicken salad wrap: potatoes: roasted seasonal vegetables kale salad: beverages. 6011921.732000001 2115262.393 37.788778723378 -122.40257456841101 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0151&ExportPDF=1&Filename=17MFF-0151_schedule.pdf Tu/Th/Fr:6PM-8PM   03/13/2017 12:00:00 AM 2017-03-13 0 03/15/2018 12:00:00 AM (37.788778723378, -122.402574568411)
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)
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)
404 934329 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 5874000 FRONT ST: BROADWAY to VALLEJO ST (800 - 899) 90 BROADWAY 0140007 0140 146 007 17MFF-0065 APPROVED 5 Rotisserie Chicken: Ribs: Kickass Salad: Potatos w/fat dripping: chicken wrap. 6012853.387 2119060.762 37.7992601135023 -122.39961794865499 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0065&ExportPDF=1&Filename=17MFF-0065_schedule.pdf Mo/We/Fr:10AM-2PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7992601135023, -122.399617948655)
390 947726 Roadside Rotisserie Corporation / Country Grill 70 Truck 1 3075000 BRANNAN ST: STANFORD ST to JACK LONDON ALY (324 - 353) 333 BRANNAN ST 3788042 3788 188 042 17MFF-0149 APPROVED 5 Rotisserie Chicken; Ribs; Pork Loin; Roasted Potatoes; Chicken Wrap; Kale Salad; Drinks 6014798.469 2112341.208 37.780918000993 -122.39241698313299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0149&ExportPDF=1&Filename=17MFF-0149_schedule.pdf Mo/Tu/Th:9AM-6PM   03/13/2017 12:00:00 AM 2017-03-13 0 03/15/2018 12:00:00 AM (37.780918000993, -122.392416983133)

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