Mobile_Food_Facility_Permit

Data source: data.sfgov.org

19 rows where Applicant = 59

View and edit SQL

Suggested facets: lot, dayshours, 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
276 934412 John's Catering #5 59 Truck 1 9090000 MISSION ST: SHAW ALY to ANTHONY ST (543 - 586) 560 MISSION ST 3708095 3708 4 095 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6012851.27 2115274.827 37.788864715342996 -122.39935935136299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:6AM-7AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.788864715343, -122.399359351363)
277 934417 John's Catering #5 59 Truck 1 6745000 HARRISON ST: 16TH ST \ TREAT AVE to 17TH ST (2000 - 2099) 2010 HARRISON ST 3767079 3767 215 079 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6015409.637999999 2114757.8619999997 37.7875875047281 -122.39047154033199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:9AM-10AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7875875047281, -122.390471540332)
281 934422 John's Catering #5 59 Truck 1 0   50 IVY ST 0811001 0811 219 001 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6007197.302 2111480.029 37.77812837973379 -122.418652129997 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:11AM-12PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7781283797338, -122.418652129997)
282 934426 John's Catering #5 59 Truck 1 3309000 BRYANT ST: 19TH ST to 20TH ST (2100 - 2199) 2157 BRYANT ST 4080065 4080 109 065 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6009684.39 2104752.654 37.759796271722706 -122.40957342162399 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:12PM-1PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7597962717227, -122.409573421624)
283 934427 John's Catering #5 59 Truck 1 7031000 HOWARD ST: BEALE ST to FREMONT ST (300 - 399) 300 HOWARD ST 3719009 3719 175 009 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6014078.535 2115506.556 37.78956931389661 -122.39512939052099 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:6AM-7AM/12PM-1PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7895693138966, -122.395129390521)
285 934420 John's Catering #5 59 Truck 1 581000 14TH ST: SHOTWELL ST to SOUTH VAN NESS AVE (139 - 199) 164 14TH ST 3530048 3530 196 048 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6007633.112000001 2108061.068 37.7687652509586 -122.41690220595301 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:10AM-11AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7687652509586, -122.416902205953)
287 934416 John's Catering #5 59 Truck 1 186201 03RD ST: 16TH ST to MARIPOSA ST (1800 - 1998) -- WEST -- 1900 03RD ST 3992003 3992 222 003 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6015473.195 2106569.082 37.7651064631908 -122.38967948728998 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:9AM-10AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7651064631908, -122.38967948729)
289 934419 John's Catering #5 59 Truck 1 9506000 NATOMA ST: FREMONT ST to 01ST ST (1 - 19) 400 HOWARD ST 3720008 3720 26 008 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6013858.05956 2115347.09492 37.7891192076677 -122.39588103933501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:6AM-7AM/10AM-11AM/12PM-1PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7891192076677, -122.395881039335)
290 934423 John's Catering #5 59 Truck 1 12726000 TURK ST: GOUGH ST to LAGUNA ST (900 - 1099) 1003 TURK ST 0759001 0759 223 001 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6005248.472999999 2112517.984 37.780868436568106 -122.42546772661801 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:8AM-9AM/11AM-12PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7808684365681, -122.425467726618)
293 934418 John's Catering #5 59 Truck 1 10955000 REDWOOD ST: POLK ST to VAN NESS AVE (100 - 199) 180 REDWOOD ST 0766013 0766 226 013 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6006844.538 2112471.764 37.7808315769119 -122.41994286468201 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:9AM-10AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7808315769119, -122.419942864682)
294 934421 John's Catering #5 59 Truck 1 8756101 MARKET ST: 12TH ST \ PAGE ST to FRANKLIN ST (1591 - 1615) -- SOUTH -- 1601 MARKET ST 3505001 3505 227 001 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6006768.767000001 2109954.339 37.773915065679795 -122.420026291504 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:10AM-11AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7739150656798, -122.420026291504)
296 934415 John's Catering #5 59 Truck 1 3081000 BRANNAN ST: 05TH ST to 06TH ST \ I-280 NORTHBOUND \ I-280 SOUTHBOUND (600 - 699) 610 BRANNAN ST 3778047 3778 228 047 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6012704.159 2110820.848 37.77662691992229 -122.399555503787 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:9AM-10AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7766269199223, -122.399555503787)
297 934424 John's Catering #5 59 Truck 1 8845101 MASONIC AVE: EWING TER to TURK BLVD (200 - 298) -- EAST -- 270 MASONIC AVE 1111002 1111 229 002 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 5999084.822000001 2111935.384 37.7789185898934 -122.446748796815 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:11AM-12PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7789185898934, -122.446748796815)
298 934428 John's Catering #5 59 Truck 1 6742000 HARRISON ST: ALAMEDA ST to 15TH ST (1830 - 1899) 1830 HARRISON ST 3550020 3550 230 020 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6008479.3379999995 2107759.433 37.7679845948645 -122.41395382252199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:2PM-3PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7679845948645, -122.413953822522)
301 934411 John's Catering #5 59 Truck 1 6711000 HARRISON ST: FREMONT ST \ I-80 W OFF RAMP to 01ST ST \ I-80 E ON RAMP (400 - 499) 401 HARRISON ST 3765022 3765 169 022 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6014905.83634 2114212.65155 37.7860625210972 -122.392176463949 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:5AM-6AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7860625210972, -122.392176463949)
307 934429 John's Catering #5 59 Truck 1 513000 11TH ST: KISSLING ST to BURNS PL (236 - 276) 251 11TH ST 3517015 3517 237 015 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6008438.954 2109403.583 37.7724967778067 -122.41420984516701 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:10AM-11AM/3PM-4PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7724967778067, -122.414209845167)
308 934414 John's Catering #5 59 Truck 1 8731000 MARIPOSA ST: HAMPSHIRE ST to YORK ST (2500 - 2599) 2500 MARIPOSA ST 3971001 3971 238 001 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6009782.745 2106182.281 37.7637272136329 -122.40933414879 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:8AM-9AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7637272136329, -122.40933414879)
311 934413 John's Catering #5 59 Truck 1 10460000 PINE ST: MONTGOMERY ST to BELDEN ST (400 - 489) 555 CALIFORNIA ST 0259026 0259 241 026 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale) 6011684.217999999 2116535.691 37.7922616341775 -122.403485955391 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:7AM-8AM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (37.7922616341775, -122.403485955391)
314 934425 John's Catering #5 59 Truck 1 6834000 HAYES ST: SHRADER ST to STANYAN ST (2200 - 2299) 2200 HAYES ST 1191039 1191 243 039 17MFF-0084 APPROVED 5 Cold Truck: Soda:Chips:Candy: Cold/Hot Sandwiches: Donuts. (Pitco Wholesale)     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0084&ExportPDF=1&Filename=17MFF-0084_schedule.pdf Mo-Fr:11AM-2PM   03/09/2017 12:00:00 AM 2017-02-13 1 03/15/2018 12:00:00 AM (0, 0)

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