Mobile_Food_Facility_Permit

Data source: data.sfgov.org

8 rows where Applicant = 57 and dayshours = "Mo-Fr:11AM-12PM" sorted by locationid

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cnn, LocationDescription, block, lot, Received (date)

dayshours ✖

  • Mo-Fr:11AM-12PM · 8 ✖
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
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&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.7438311721327, -122.377797368962)
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&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.7479309361129, -122.415193153909)
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&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.7512694058781, -122.389894366944)
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&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.7504641155225, -122.387908325902)
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)
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&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.7484453388377, -122.38687903198)
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&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.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&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.7508496068125, -122.390027615501)

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