Mobile_Food_Facility_Permit

Data source: data.sfgov.org

4 rows where block = 73

View and edit SQL

Suggested facets: Applicant, permit, Status, FoodItems, Schedule, 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
86 559783 Mang Hang Catering 35 Truck 1 9058000 MINNESOTA ST: 23RD ST to 24TH ST (1200 - 1299) 1240 MINNESOTA ST 4228015 4228 73 015 14MFF-0109 EXPIRED 2 COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea. 6015191.235 2102753.826 37.7546149514892 -122.39038813202 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf Mo-Fr:1PM-2PM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7546149514892, -122.39038813202)
319 934505 Mike's Catering 64 Truck 1 9059000 MINNESOTA ST: 24TH ST to 25TH ST (1300 - 1399) 1310 MINNESOTA ST 4228129 4228 73 129 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015276.93755 2102418.8382900003 37.7536998999438 -122.390068346908 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0092&ExportPDF=1&Filename=17MFF-0092_schedule.pdf Mo-Fr:10AM-11AM/1PM-2PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7536998999438, -122.390068346908)
339 934510 Mike's Catering 64 Truck 1 7198000 INDIANA ST: 23RD ST to 25TH ST \ I-280 N ON RAMP (1200 - 1399) Assessors Block 4228/Lot080 4228080 4228 73 080 17MFF-0092 APPROVED 5 Cold Truck: packaged sandwiches: snacks: candy: hot and cold drinks 6015176.72777 2102413.60751 37.7536799789675 -122.390414532294 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0092&ExportPDF=1&Filename=17MFF-0092_schedule.pdf Mo/Mo/Mo/Mo/Mo:7AM-8AM/9AM-11AM;Su/Su/Su/Su/Su:9AM-2PM;Sa/Sa/Sa/Sa/Sa:9AM-3PM;Mo/Mo/Mo/Mo/Mo:11AM-1   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7536799789675, -122.390414532294)
553 934380 Two G's Catering 103 Truck 1 1407000 25TH ST: MINNESOTA ST to I-280 N ON RAMP \ INDIANA ST (1100 - 1199) 1150 25TH ST 4228017 4228 73 017 17MFF-0073 APPROVED 5 Cold Truck: Hot & Cold Sandwiches: Bagels: Burritos: Soups: Hot Dogs: Tacos: Pork Buns: BBQ Meat: Fruit: Various Beverages: Pasties: Pre-Packaged Snacks: Candy: Salads: Muffins: Scones: Brownies: Croissants: Energy Bars: Noodle Bowls 6015221.227000001 2102215.701 37.75313903797839 -122.39024681698099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Fr:8AM-9AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7531390379784, -122.390246816981)

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