Mobile_Food_Facility_Permit

Data source: data.sfgov.org

8 rows where ExpirationDate = "03/15/2018 12:00:00 AM", PriorPermit = 0 and Status = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Applicant, FacilityType, block, lot, permit, FoodItems, Schedule, dayshours, 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
179 179 934995 Breaking Bread Inc. 47 Truck 1 2754000 BATTERY ST: CALIFORNIA ST to HALLECK ST (200 - 230) 300 CALIFORNIA ST 0238002 0238 34 002 17MFF-0124 REQUESTED 1 prepackaged food 6012600.766 2116948.597 37.7934465278161 -122.400343675592 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0124&ExportPDF=1&Filename=17MFF-0124_schedule.pdf Mo/We/Fr:2PM-6PM     2017-02-14 0 03/15/2018 12:00:00 AM (37.7934465278161, -122.400343675592)
536 536 959619 Kabob Trolley, LLC 101 Push Cart 2 267001 04TH ST: TOWNSEND ST to KING ST (700 - 799) 298 KING ST 8702606 8702 359 606 17MFF-0177 REQUESTED 1 Gyros: Kebobs: refreshments and dessert 6014485.06287 2111154.5175099997 37.777642208509995 -122.393418145932 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0177&ExportPDF=1&Filename=17MFF-0177_schedule.pdf Mo-Su:10AM-8PM     2017-04-07 0 03/15/2018 12:00:00 AM (37.77764220851, -122.393418145932)
547 547 961020 Let's Be Frank 102 Push Cart 2 6816000 HAYES ST: GOUGH ST to OCTAVIA ST (400 - 499) 425 HAYES ST 0817025 0817 367 025 17MFF-0180 REQUESTED 1 Hot dogs and chili 6005815.063999999 2110939.7169999997 37.7765668965195 -122.42339537672702 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf Su/We:11AM-5PM     2017-04-12 0 03/15/2018 12:00:00 AM (37.7765668965195, -122.423395376727)
548 548 961021 Let's Be Frank 102 Push Cart 2 8393001 LINDEN ST: GOUGH ST to OCTAVIA ST (300 - 399) 404 OCTAVIA ST 0817033 0817 367 033 17MFF-0180 REQUESTED 1 Hot dogs and chili 6005585.672 2110752.1969999997 37.776039062665895 -122.424175571492 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0180&ExportPDF=1&Filename=17MFF-0180_schedule.pdf Fr:11AM-5PM     2017-04-12 0 03/15/2018 12:00:00 AM (37.7760390626659, -122.424175571492)
633 633 976033 Plaza Garibaldy 18 Truck 1 9297000 MONTGOMERY ST: POST ST to SUTTER ST (1 - 99) 1 MONTGOMERY ST 0292002 0292 304 002 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6011970.278 2115432.874 37.789249534075104 -122.402418597294 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo/We/Fr:10AM-3PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7892495340751, -122.402418597294)
650 650 1024812 Plaza Garibaldy 18 Truck 1 3420000 BUSH ST: BATTERY ST to SANSOME ST (100 - 199) 1 BUSH ST 0290011 0290 16 011 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6012652.373 2116027.943 37.7909215072692 -122.400100423738 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo/We/Fr:10AM-3PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7909215072692, -122.400100423738)
654 654 1020424 Kabob Trolley, LLC 101 Truck 1 9101000 MISSION ST: 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) 1133 MISSION ST 3727096 3727 407 096 17MFF-0192 REQUESTED 1 Halal Gyro and Cheesesteaks 6009260.818 2111511.319 37.7783302557659 -122.411515865268 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0192&ExportPDF=1&Filename=17MFF-0192_schedule.pdf Mo/Tu/Fr:9AM-4PM     2017-09-19 0 03/15/2018 12:00:00 AM (37.7783302557659, -122.411515865268)
655 655 1024769 Plaza Garibaldy 18 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 540 HOWARD ST 3721015 3721 104 015 17MFF-0184 REQUESTED 1 Tacos: burritos: quesadillas 6013457.851 2114931.191 37.7879549596858 -122.397236543731 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0184&ExportPDF=1&Filename=17MFF-0184_schedule.pdf Mo-We:3PM-8PM     2017-05-10 0 03/15/2018 12:00:00 AM (37.7879549596858, -122.397236543731)

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