Mobile_Food_Facility_Permit

Data source: data.sfgov.org

17 rows where Applicant = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cnn, LocationDescription, block, lot, Latitude, Longitude, dayshours, 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
549 549 934386 Two G's Catering 103 Truck 1 15028000 MISSION ROCK ST: 03RD ST to 04TH ST (500 - 599) 555 MISSION ROCK ST 8711028 8711 52 028 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     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Su:10AM-11AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
550 550 934388 Two G's Catering 103 Truck 1 7165000 ILLINOIS ST: 16TH ST to MARIPOSA ST \ TERRY A FRANCOIS BLVD (400 - 599) 409 ILLINOIS ST 3940001 3940 263 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     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Su:10AM-11AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
551 551 934381 Two G's Catering 103 Truck 1 2734000 BARNEVELD AVE: JERROLD AVE to LOOMIS ST \ MCKINNON AVE (100 - 299) 175 BARNEVELD AVE 5286A018 5286A 368 018 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 6011606.147999999 2099252.817 37.7448024193644 -122.402540218927 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:9AM-10AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7448024193644, -122.402540218927)
552 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)
553 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)
554 554 934375 Two G's Catering 103 Truck 1 3294000 BRYANT ST: LANGTON ST to KATE ST (920 - 977) 945 BRYANT ST 3780079 3780 369 079 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 6011062.6110000005 2109567.575 37.7730940844723 -122.405145856485 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.7730940844723, -122.405145856485)
555 555 934374 Two G's Catering 103 Truck 1 2863000 BEALE ST: DAVIS ST \ MARKET ST \ PINE ST to MISSION ST (1 - 99) 30 BEALE ST 3710002 3710 92 002 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 6013516.114 2116322.014 37.791777078364206 -122.397132524462 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:7AM-9AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7917770783642, -122.397132524462)
556 556 934382 Two G's Catering 103 Truck 1 13653000 WILLIAMS AVE: CERES ST to MENDELL ST (65 - 99) 71 WILLIAMS AVE 5414022 5414 28 022 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 6013782.892000001 2093534.846 37.7292233375937 -122.39461306266399 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:9AM-10AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7292233375937, -122.394613062664)
558 558 934387 Two G's Catering 103 Truck 1 12532003 TERRY A FRANCOIS BLVD: MISSION BAY BLVD to MISSION BAY BLVD (0 - 0) Assessors Block 8720/Lot008 8720008 8720 246 008 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 6016311.862000001 2108756.11 37.771158036961495 -122.38693125756201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Su:10AM-11AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7711580369615, -122.386931257562)
559 559 934383 Two G's Catering 103 Truck 1 2954000 BERRY ST: 04TH ST to 05TH ST (200 - 299) 235 BERRY ST 8708 111 8708 86 111 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 6014269.44491 2110088.45097 37.774703047468705 -122.39408939657 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:9AM-10AM/11AM-12PM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7747030474687, -122.39408939657)
560 560 934385 Two G's Catering 103 Truck 1 15024000 CHINA BASIN ST: TERRY A FRANCOIS BLVD to 03RD ST (300 - 499) 435 CHINA BASIN ST 8720001 8720 246 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     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf Mo-Su:9AM-10AM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)
561 561 934379 Two G's Catering 103 Truck 1 12665000 TOWNSEND ST: 06TH ST to 07TH ST (500 - 599) 516 TOWNSEND ST 3784007 3784 370 007 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 6012412.751 2109668.0 37.7734452149215 -122.400482576546 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.7734452149215, -122.400482576546)
562 562 934378 Two G's Catering 103 Truck 1 7195000 INDIANA ST: 20TH ST to 22ND ST (800 - 999) 975 INDIANA ST 4106023 4106 84 023 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 6015069.267999999 2104050.997 37.7581699396153 -122.390900582667 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.7581699396153, -122.390900582667)
563 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)
564 564 934384 Two G's Catering 103 Truck 1 416000 08TH ST: BRYANT ST to BRANNAN ST (500 - 599) 599 08TH ST 3780007A 3780 369 007A 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 6010905.634 2109124.318 37.7718682257671 -122.405657636251 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:12PM-2PM   04/17/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7718682257671, -122.405657636251)
565 565 934377 Two G's Catering 103 Truck 1 3295000 BRYANT ST: KATE ST to DECATUR ST (940 - 983) 950 BRYANT ST 3758127 3758 371 127 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 6010831.642000001 2109760.53 37.773610979516 -122.40595840711201 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.773610979516, -122.405958407112)
656 656 934376 Two G's Catering 103 Truck 1 3088000   840 BRANNAN ST 3780078 3780 369 078 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 6011252.805 2109369.807 37.772561689774 -122.404474024011 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.772561689774, -122.404474024011)

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