Mobile_Food_Facility_Permit

Data source: data.sfgov.org

7 rows where lot = 024

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Status, Received, PriorPermit, Received (date)

lot ✖

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
88 88 559776 Mang Hang Catering 35 Truck 1 9094000 MISSION ST: ANNIE ST to 03RD ST (663 - 699) 690 MISSION ST 3707024 3707 22 024 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:7AM-8AM/10AM-11AM/12PM-1PM     2014-07-10 1 03/15/2017 12:00:00 AM (0, 0)
201 201 944291 Linda's Catering 54 Truck 1 12662000 TOWNSEND ST: LUSK ST to 04TH ST (252 - 299) 260 TOWNSEND ST 3787024 3787 164 024 17MFF-0129 APPROVED 5 Hot Dogs: Hamburgers: Nachos: Steaks: Pastas: Asian Dishes: Tri-Tip Sandwiches: Sodas & Water 6014193.326 2111344.676 37.7781481274607 -122.394440688559 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0129&ExportPDF=1&Filename=17MFF-0129_schedule.pdf Mo-Fr:12PM-10PM   03/01/2017 12:00:00 AM 2017-03-01 1 03/15/2018 12:00:00 AM (37.7781481274607, -122.394440688559)
245 245 934663 Anas Goodies Catering 57 Truck 1 7195000 INDIANA ST: 20TH ST to 22ND ST (800 - 999) 951 INDIANA ST 4106024 4106 84 024 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6015057.091 2104275.668 37.758786162305604 -122.390958398693 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf Mo-Fr:12PM-1PM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7587861623056, -122.390958398693)
346 346 934473 Liang Bai Ping 63 Truck 1 13355000 WALLACE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1450 WALLACE AVE 4828024 4828 250 024 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015606.538 2092377.128 37.7261456924729 -122.38822774090299 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:10AM-11AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7261456924729, -122.388227740903)
515 515 934815 Natan's Catering 100 Truck 1 2157202 ALEMANY BLVD: FOLSOM ST to ELLSWORTH ST \ I-280 S OFF RAMP \ I-280 S ON RAMP (400 - 498) -- NORTH -- 400 ALEMANY BLVD 5843024 5843 346 024 17MFF-0123 APPROVED 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6008042.13742 2095078.99168 37.7331423951426 -122.41456863241899 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0123&ExportPDF=1&Filename=17MFF-0123_schedule.pdf     04/07/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7331423951426, -122.414568632419)
585 585 963988 Singh Brothers Ice Cream 105 Truck 1 10218000 PALOU AVE: HAWES ST to INGALLS ST (1100 - 1199) 1101 PALOU AVE 4757024 4757 385 024 17MFF-0182 REQUESTED 1 Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA 6017464.808999999 2093259.551 37.7286714428179 -122.38186508864099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf Mo-Fr:2PM-3PM     2017-04-18 1 03/15/2018 12:00:00 AM (37.7286714428179, -122.381865088641)
667 667 1039596 Julie's Hot Dogs 124 Truck 1 9121000 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) 2365 MISSION ST 3595024 3595 156 024 17MFF-0190 APPROVED 5 Hot dogs: Bacon wrapped hot dogs: soda: water: sports drinks: energy drinks: chips 6007087.512999999 2104603.286 37.759240285150206 -122.418544171117 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0190&ExportPDF=1&Filename=17MFF-0190_schedule.pdf     08/28/2017 12:00:00 AM 2017-08-24 0 03/15/2018 12:00:00 AM (37.7592402851502, -122.418544171117)

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