Mobile_Food_Facility_Permit

Data source: data.sfgov.org

9 rows where lot = 013

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Applicant, FacilityType, cnn, LocationDescription, Address, blocklot, block, permit, Status, FoodItems, X, Y, Latitude, Longitude, Schedule, Approved, Received, PriorPermit, ExpirationDate, Location, 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
26 26 626192 Taza Halal Cart 4 Push Cart 2 8742203 MARKET ST: SUTTER ST to 02ND ST (560 - 574) -- NORTH -- 572 MARKET ST 0291013 0291 25 013 15MFF-0026 INACTIVE 3 Gyro Sandwich: Chicken Sandwich: lamb over rice: chicken over rice: combination over rice 6012285.359 2115631.172 37.789811597719 -122.40134238933399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0026&ExportPDF=1&Filename=15MFF-0026_schedule.pdf Mo-We:10AM-9PM     2015-03-02 0   (37.789811597719, -122.401342389334)
238 238 934648 Anas Goodies Catering 57 Truck 1 8714000 MARIPOSA ST: TENNESSEE ST to 04TH ST \ MINNESOTA ST (600 - 699) 601 MARIPOSA ST 3996013 3996 96 013 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6015331.083 2106187.955 37.7640520899242 -122.390144393988 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:9AM-10AM/12PM-1PM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7640520899242, -122.390144393988)
293 293 934418 John's Catering #5 59 Truck 1 10955000 REDWOOD ST: POLK ST to VAN NESS AVE (100 - 199) 180 REDWOOD ST 0766013 0766 226 013 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6006844.538 2112471.764 37.7808315769119 -122.41994286468201 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:9AM-10AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7808315769119, -122.419942864682)
349 349 934460 Liang Bai Ping 63 Truck 1 13139000 VAN DYKE AVE: INGALLS ST to JENNINGS ST (1300 - 1399) 1370 VAN DYKE AVE 4811013 4811 256 013 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015684.098999999 2092668.764 37.7269507643782 -122.387979956262 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:8AM-9AM/12PM-1PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7269507643782, -122.387979956262)
360 360 934458 Liang Bai Ping 63 Truck 1 13779000 YOSEMITE AVE: HAWES ST to INGALLS ST (1300 - 1399) 1335 YOSEMITE AVE 4846013 4846 266 013 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015941.755 2091544.7959999999 37.7238788408325 -122.387010878785 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:7AM-8AM/10AM-11AM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7238788408325, -122.387010878785)
382 382 947840 DO UC US Mobile Catering 69 Truck 1 185104 03RD ST: MISSION BAY BLVD to SOUTH ST (1401 - 1599) -- EAST -- 1501 03RD ST 8720013 8720 246 013 17MFF-0154 APPROVED 5 Cold truck: sandwiches: salads: beverages: chips: candy: cookies: coffee: tea: drinks 6015663.1841400005 2108672.3934400002 37.770892231031794 -122.389169231483 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0154&ExportPDF=1&Filename=17MFF-0154_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7708922310318, -122.389169231483)
468 468 676797 Peruchi Food Truck,LLC 85 Truck 1 4972000 DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) 253 DRUMM ST 0203013 0203 319 013 15MFF-0023 EXPIRED 2 Peruvian Chinese Food. Lomo Saltado: Arroz Con Pollo: Tipa Kay: Yuca Fries 6013507.554 2117905.099 37.796123380252105 -122.39727320433799 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=15MFF-0023&ExportPDF=1&Filename=15MFF-0023_schedule.pdf Mo/We/Fr:9AM-3PM   03/15/2016 12:00:00 AM 2015-03-02 0 03/15/2017 12:00:00 AM (37.7961233802521, -122.397273204338)
587 587 934435 JapaCurry 106 Truck 1 9092000 MISSION ST: 02ND ST to NEW MONTGOMERY ST (600 - 634) 602 MISSION ST 3707013 3707 22 013 17MFF-0087 APPROVED 5 Katsu Curry: KUROBUTA Sausage Curry: Vegetable Curry: Veggie Croquette Curry: Chicken NANBAN Bento: Nori Bento: water: soda: green tea 6012606.129 2114955.147 37.787973283216 -122.40018504988899 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0087&ExportPDF=1&Filename=17MFF-0087_schedule.pdf We/Th:10AM-2PM   04/24/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.787973283216, -122.400185049889)
640 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)

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