Mobile_Food_Facility_Permit

Data source: data.sfgov.org

19 rows where lot = 012

✎ 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, dayshours, 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
17 17 526417 The Creme Brulee Cart 14 Push Cart 2 8742201 MARKET ST: 01ST ST \ BUSH ST to BATTERY ST (500 - 538) -- NORTH -- 532 MARKET ST 0290012 0290 16 012 14MFF-0056 EXPIRED 2 Creme Brulee 6012582.227999999 2115893.453 37.790548318183205 -122.40033367367901 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0056&ExportPDF=1&Filename=14MFF-0056_schedule.pdf Mo-Su:11AM-9PM   03/14/2014 12:00:00 AM 2014-03-14 1 03/15/2015 12:00:00 AM (37.7905483181832, -122.400333673679)
76 76 559787 Mang Hang Catering 35 Truck 1 8848000 MASONIC AVE: MCALLISTER ST to FULTON ST (500 - 599) 599 MASONIC AVE 1108 012 1108 64 012 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. 5998797.751680001 2112598.57865 37.7807231475444 -122.447789640478 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:9AM-10AM     2014-07-10 1 03/15/2017 12:00:00 AM (37.7807231475444, -122.447789640478)
152 152 934585 May Catering 37 Truck 1 13767000 YORK ST: 18TH ST to 19TH ST (600 - 699) 620 YORK ST 4023012 4023 126 012 17MFF-0110 REQUESTED 1 Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks 6009734.778 2105398.284 37.761571848719704 -122.409444718958 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:9AM-10AM     2017-02-13 1 05/06/2018 12:00:00 AM (37.7615718487197, -122.409444718958)
212 212 934448 Mini Mobile Food Catering 53 Truck 1 110000 01ST ST: CLEMENTINA ST to FOLSOM ST (245 - 299) 245 01ST ST 3737012 3737 177 012 17MFF-0089 APPROVED 5 Cold Truck: Corn Dogs: Noodle Soups: Candy: Pre-packaged Snacks: Sandwiches: Chips: Coffee: Tea: Various Beverages 6014220.897999999 2114895.75 37.7879000978181 -122.394594036205 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0089&ExportPDF=1&Filename=17MFF-0089_schedule.pdf Mo-Fr:10AM-11AM   03/01/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7879000978181, -122.394594036205)
235 235 945103 F & C Catering 56 Truck 1 12491000 TENNESSEE ST: END to 26TH ST (1500 - 1599) 1500 TENNESSEE ST 4294012 4294 189 012 17MFF-0137 APPROVED 5 Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad 6015520.522999999 2101882.84 37.752241668480295 -122.389188542589 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf Mo-Fr:8AM-10AM/10AM-11AM   03/06/2017 12:00:00 AM 2017-03-06 1 03/15/2018 12:00:00 AM (37.7522416684803, -122.389188542589)
237 237 934659 Anas Goodies Catering 57 Truck 1 8717000 MARIPOSA ST: PENNSYLVANIA AVE to MISSISSIPPI ST (1000 - 1099) 1040 MARIPOSA ST 3987012 3987 191 012 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6014135.465 2106266.867 37.764202378301896 -122.39428524233999 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:11AM-12PM   03/08/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7642023783019, -122.39428524234)
274 274 934644 Anas Goodies Catering 57 Truck 1 12482000 TENNESSEE ST: MARIPOSA ST to 18TH ST (600 - 699) 640 TENNESSEE ST 3996012 3996 96 012 17MFF-0111 APPROVED 5 Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages 6015341.121 2106001.4280000003 37.7635404839296 -122.390096643663 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.7635404839296, -122.390096643663)
315 315 934477 Liang Bai Ping 63 Truck 1 12570000 THOMAS AVE: HAWES ST to INGALLS ST (1200 - 1299) 1265 THOMAS AVE 4807012 4807 244 012 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6016458.774 2092565.342 37.7267096753687 -122.385294691187 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:11AM-12PM   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7267096753687, -122.385294691187)
325 325 934457 Liang Bai Ping 63 Truck 1 13780000 YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1420 YOSEMITE AVE 4831012 4831 32 012 17MFF-0090 APPROVED 5 Cold Truck: Pre-packaged sandwiches: snacks: fruit: various beverages 6015609.592 2092025.9880000001 37.7251817007288 -122.38819268844401 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   03/10/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7251817007288, -122.388192688444)
381 381 934709 Halal Cart, LLC 31 Push Cart 2 8741101 MARKET ST: FREMONT ST \ FRONT ST to 01ST ST \ BUSH ST (401 - 499) -- SOUTH -- 455 MARKET ST 3709012 3709 279 012 17MFF-0114 APPROVED 5 Gyros: Kebabs: soft drinks: and water 6013076.33 2116028.637 37.790947041923395 -122.39863358940399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0114&ExportPDF=1&Filename=17MFF-0114_schedule.pdf Mo-Su:10AM-8PM   03/13/2017 12:00:00 AM 2017-02-13 0 03/15/2018 12:00:00 AM (37.7909470419234, -122.398633589404)
389 389 934520 Quan Catering 67 Truck 1 2867000 BEALE ST: HARRISON ST to BRYANT ST \ DELANCEY ST (400 - 499) 400 BEALE ST 3766012 3766 280 012 17MFF-0095 APPROVED 5 Cold Truck: Soft drinks: cup cakes: potato chips: cookies: gum: sandwiches (hot & cold): peanuts: muffins: coff (hot & cold): water: juice: yoplait: milk: orange juice: sunflower seeds: can foods: burritos: buscuits: chimichangas: rice krispies 6015274.9744 2114511.9879099997 37.786904919457 -122.390920262962 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0095&ExportPDF=1&Filename=17MFF-0095_schedule.pdf Mo-Fr:11AM-12PM   03/13/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.786904919457, -122.390920262962)
423 423 934437 Curry Up Now 74 Truck 1 24571000 WASHINGTON ST: DRUMM ST intersection 370 DRUMM ST 0201012 0201 293 012 17MFF-0088 APPROVED 5 Chicken Tiki Masala Burritos: Paneer Tiki Masala Burritos: Samosas: Mango Lassi 6013693.222 2118189.172 37.7969137124835 -122.396650675264 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0088&ExportPDF=1&Filename=17MFF-0088_schedule.pdf Mo/Tu/We/Th/Fr:2PM-3PM   03/14/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7969137124835, -122.396650675264)
520 520 934800 Natan's Catering 100 Truck 1 0   Assessors Block 4227/Lot012 4227012 4227 349 012 17MFF-0123 APPROVED 5 Burgers: melts: hot dogs: burritos:sandwiches: fries: onion rings: drinks 6014953.292 2102226.9669999997 37.7531551067155 -122.391174184456 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.7531551067155, -122.391174184456)
584 584 963989 Singh Brothers Ice Cream 105 Truck 1 13780000 YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) 1420 YOSEMITE AVE 4831012 4831 32 012 17MFF-0182 REQUESTED 1 Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA 6015609.592 2092025.9880000001 37.7251817007288 -122.38819268844401 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.7251817007288, -122.388192688444)
605 605 934371 Taza Halal Cart 4 Push Cart 2 8742202 MARKET ST: BATTERY ST to SUTTER ST (540 - 558) -- NORTH -- 532 MARKET ST 0290012 0290 16 012 17MFF-0072 ONHOLD 6 Chicken Gyro: Lamb Gyro: Chiken Gyro Plate: Lamb Gyro Plate: Combination Gyro Plate. 6012582.227999999 2115893.453 37.790548318183205 -122.40033367367901 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0072&ExportPDF=1&Filename=17MFF-0072_schedule.pdf Mo-We:9AM-8PM     2017-02-13 0 06/29/2018 12:00:00 AM (37.7905483181832, -122.400333673679)
623 623 453012 Tacos Santana 120 Truck 1 3742000 CARROLL AVE: QUINT ST to BAY SHORE BLVD \ THORNTON AVE (2100 - 2199) 2101 CARROLL AVE 5436012 5436 397 012 13MFF-0112 INACTIVE 3 Tacos: Burritos : Tortas: Quesadillas & Beverages 6011371.493 2093947.369 37.7302216813049 -122.402978526686 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=13MFF-0112&ExportPDF=1&Filename=13MFF-0112_schedule.pdf Mo-Su:10AM-9PM 07/25/2013 12:00:00 AM   2013-06-05 1 03/15/2014 12:00:00 AM (37.7302216813049, -122.402978526686)
647 647 933323 Halal Cart, LLC 31 Push Cart 2 8742202 MARKET ST: BATTERY ST to SUTTER ST (540 - 558) -- NORTH -- 532 MARKET ST 0290012 0290 16 012 16MFF-0129 SUSPEND 4 Chicken; Lamb; Kabobs; Rice 6012582.227999999 2115893.453 37.790548318183205 -122.40033367367901 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0129&ExportPDF=1&Filename=16MFF-0129_schedule.pdf Th/Fr/Sa:6AM-6PM   09/08/2017 12:00:00 AM 2016-08-01 0 03/15/2018 12:00:00 AM (37.7905483181832, -122.400333673679)
657 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)
668 668 1037691 Munch A Bunch 126 Truck 1 8137000 LARKIN ST: FERN ST to BUSH ST (1127 - 1199) 1144 LARKIN ST 0279012 0279 412 012 17MFF-0197 APPROVED 5 Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks 6007372.707 2115263.8019999997 37.7885275753132 -122.418313685721 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf Mo-Fr:10AM-11AM   11/21/2017 12:00:00 AM 2017-11-16 1 03/15/2018 12:00:00 AM (37.7885275753132, -122.418313685721)

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