Mobile_Food_Facility_Permit

Data source: data.sfgov.org

5 rows where Applicant = 125

View and edit SQL

Suggested facets: 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
640 1013324 Wu Wei LLC dba MoBowl 125 Truck 1 4972000 DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) 253 DRUMM ST 0203013 0203 319 013 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6013507.554 2117905.099 37.796123380252105 -122.39727320433799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Tu/Th:10AM-3PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7961233802521, -122.397273204338)
657 1013323 Wu Wei LLC dba MoBowl 125 Truck 1 13403000 WASHINGTON ST: THE EMBARCADERO to DRUMM ST (1 - 99) 370 DRUMM ST 0201012 0201 293 012 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6013693.222 2118189.172 37.7969137124835 -122.396650675264 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Su:10AM-11PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7969137124835, -122.396650675264)
658 1013320 Wu Wei LLC dba MoBowl 125 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 500 HOWARD ST 3721011 3721 104 011 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls.     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Mo/Fr:10AM-2PM     2017-08-31 1 03/15/2018 12:00:00 AM (0, 0)
659 1013322 Wu Wei LLC dba MoBowl 125 Truck 1 12160001 STEUART ST: HOWARD ST to END (200 - 299) 75 HOWARD ST 3741031 3741 408 031 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6015092.174 2116210.269 37.791557864154896 -122.391671499786 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Mo/We:10AM-3PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.7915578641549, -122.391671499786)
660 1013321 Wu Wei LLC dba MoBowl 125 Truck 1 6438001 GREEN ST: THE EMBARCADERO to FRONT ST (1 - 49) 900 FRONT ST 0137001 0137 409 001 17MFF-0191 REQUESTED 1 Various types of meat: veggie: and seafood bowls. 6012874.622 2119410.253 37.800220915592206 -122.399569018577 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0191&ExportPDF=1&Filename=17MFF-0191_schedule.pdf Fr:10AM-4PM     2017-08-31 1 03/15/2018 12:00:00 AM (37.8002209155922, -122.399569018577)

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