Mobile_Food_Facility_Permit

Data source: data.sfgov.org

7 rows where dayshours = "Mo-Fr:6AM-7AM"

View and edit SQL

Suggested facets: Applicant, lot, 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
74 559786 Mang Hang Catering 35 Truck 1 7033000 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) 501 HOWARD ST 3736001 3736 10 001 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.     0.0 0.0 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:6AM-7AM     2014-07-10 1 03/15/2017 12:00:00 AM (0, 0)
143 934610 May Catering 37 Truck 1 2477000 CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) 2400 CESAR CHAVEZ ST 4328A005 4328A 119 005 17MFF-0110 REQUESTED 1 Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks 6012051.606000001 2101106.273 37.749916469390996 -122.40113011221202 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf Mo-Fr:6AM-7AM     2017-02-13 1 05/06/2018 12:00:00 AM (37.749916469391, -122.401130112212)
276 934412 John's Catering #5 59 Truck 1 9090000 MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) 560 MISSION ST 3708095 3708 4 095 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6012851.27 2115274.827 37.788864715342996 -122.39935935136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:6AM-7AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.788864715343, -122.399359351363)
330 934454 Liang Bai Ping 63 Truck 1 2866000 BEALE ST: FOLSOM ST to HARRISON ST (300 - 399) 300 BEALE ST 3747022 3747 162 022 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6014804.68 2114971.1180000002 37.78813947887161 -122.392579515374 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo-Fr:6AM-7AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7881394788716, -122.392579515374)
342 934485 Liang Bai Ping 63 Truck 1 6540000 GRIFFITH ST: QUESADA AVE to REVERE AVE (1300 - 1399) 1300 GRIFFITH ST 4763047 4763 245 047 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6017681.819 2092678.013 37.727086633951394 -122.381074448749 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0090&ExportPDF=1&Filename=17MFF-0090_schedule.pdf Mo-Fr:6AM-7AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7270866339514, -122.381074448749)
552 934372 Two G's Catering 103 Truck 1 185105 03RD ST: SOUTH ST to 16TH ST (1601 - 1799) -- EAST -- 1799 03RD ST 8722001 8722 268 001 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 6016110.001 2107608.418 37.7679955456856 -122.387549426547 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:6AM-7AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7679955456856, -122.387549426547)
563 934373 Two G's Catering 103 Truck 1 2954000 BERRY ST: 04TH ST to 05TH ST (200 - 299) 201 BERRY ST 8708003 8708 86 003 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 6014509.734 2110397.9280000003 37.7755661544145 -122.393279842341 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:6AM-7AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7755661544145, -122.393279842341)

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