Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: cnn, LocationDescription, block, lot, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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¶ms=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) | |
251 | 251 | 934658 | Anas Goodies Catering 57 | Truck 1 | 195201 | 03RD ST: 26TH ST to CESAR CHAVEZ ST (3000 - 3098) -- WEST -- | 3000 03RD ST | 4315008 | 4315 198 | 008 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015877.515 | 2101228.261 | 37.7504641155225 | -122.387908325902 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7504641155225, -122.387908325902) | |
253 | 253 | 934655 | Anas Goodies Catering 57 | Truck 1 | 197101 | 03RD ST: MARIN ST to ARTHUR AVE \ CARGO WAY (3201 - 3399) -- EAST -- | 3305 03RD ST | 4502A002 | 4502A 200 | 002 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6018751.714 | 2098754.754 | 37.7438311721327 | -122.377797368962 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7438311721327, -122.377797368962) | |
256 | 256 | 934657 | Anas Goodies Catering 57 | Truck 1 | 1500000 | 26TH ST: MINNESOTA ST to INDIANA ST (1000 - 1099) | 1051 26TH ST | 4317015 | 4317 201 | 015 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015309.355 | 2101533.012 | 37.7512694058781 | -122.389894366944 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7512694058781, -122.389894366944) | |
261 | 261 | 934656 | Anas Goodies Catering 57 | Truck 1 | 11833000 | SHOTWELL ST: 15TH ST to 16TH ST (100 - 199) | 131 SHOTWELL ST | 5501 003 | 5501 205 | 003 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6007971.7639999995 | 2100466.349 | 37.7479309361129 | -122.415193153909 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7479309361129, -122.415193153909) | |
262 | 262 | 934661 | Anas Goodies Catering 57 | Truck 1 | 1500000 | 26TH ST: MINNESOTA ST to INDIANA ST (1000 - 1099) | 1090 26TH ST | 4293015 | 4293 192 | 015 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015191.855 | 2101658.85 | 37.7516084135789 | -122.39030948950099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7516084135789, -122.390309489501) | |
270 | 270 | 934662 | Anas Goodies Catering 57 | Truck 1 | 7200000 | INDIANA ST: 26TH ST to CESAR CHAVEZ ST (1500 - 1599) | 1575 INDIANA ST | 4317017 | 4317 201 | 017 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6015267.752 | 2101380.964 | 37.7508496068125 | -122.390027615501 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7508496068125, -122.390027615501) | |
272 | 272 | 934660 | Anas Goodies Catering 57 | Truck 1 | 197101 | 03RD ST: MARIN ST to ARTHUR AVE \ CARGO WAY (3201 - 3399) -- EAST -- | 3255 03RD ST | 4377001 | 4377 213 | 001 | 17MFF-0111 | APPROVED 5 | Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages | 6016160.221 | 2100487.333 | 37.748445338837705 | -122.38687903198 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=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.7484453388377, -122.38687903198) |
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");