Data source: data.sfgov.org
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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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¶ms=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) |
JSON shape: default, array, newline-delimited
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");