Mobile_Food_Facility_Permit

Data source: data.sfgov.org

23 rows where Applicant = 66

View and edit SQL

Suggested facets: cnn, LocationDescription, block, 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
363 947802 Park's Catering 66 Truck 1 2477000 CESAR CHAVEZ ST: EVANS AVE to KANSAS ST (2100 - 2550) 2323 CESAR CHAVEZ ST 4342001 4342 264 001 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6012210.337 2100696.938 37.7488013777145 -122.400552458785 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:6AM-8AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7488013777145, -122.400552458785)
365 947808 Park's Catering 66 Truck 1 4615000 DAVIDSON AVE: RANKIN ST to SELBY ST (1600 - 1699) 1650 DAVIDSON AVE 5215022 5215 269 022 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6014623.707 2099886.835 37.74671130304029 -122.392150319453 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7467113030403, -122.392150319453)
368 947822 Park's Catering 66 Truck 1 3376000 BURKE AVE: END to 03RD ST (1500 - 1599) 1575 BURKE AVE 5203043 5203 63 043 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016176.0479999995 2098933.04 37.7441784473757 -122.386715929759 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:7AM-8AM/9AM-10AM/12PM-1PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7441784473757, -122.386715929759)
369 947813 Park's Catering 66 Truck 1 202101 03RD ST: EVANS AVE to FAIRFAX AVE (3801 - 3899) -- EAST -- 3801 03RD ST 5242002 5242 271 002 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6015841.555 2097791.762 37.7410262077887 -122.387792927994 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7410262077887, -122.387792927994)
371 947806 Park's Catering 66 Truck 1 8483000 LOOMIS ST: BARNEVELD AVE \ MCKINNON AVE to OAKDALE AVE (1 - 99) 10 LOOMIS ST 5560100 5560 273 100 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6011237.657000001 2098889.381 37.7437839233827 -122.40378882961001 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7437839233827, -122.40378882961)
379 947815 Park's Catering 66 Truck 1 8700000 MARIN ST: KANSAS ST to HWY 101 N ON RAMP (2500 - 2599) 2525 MARIN ST 4343001D 4343 101 001D 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6011789.79 2100273.801 37.7476160722331 -122.401976975724 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:10AM-11AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7476160722331, -122.401976975724)
383 947800 Park's Catering 66 Truck 1 9206000 MISSISSIPPI ST: END to CESAR CHAVEZ ST (1200 - 1299) 1200 MISSISSIPPI ST 4288003 4288 117 003 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6014017.542 2101712.6890000002 37.7516910357229 -122.39437421326299 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:5AM-6AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7516910357229, -122.394374213263)
385 947818 Park's Catering 66 Truck 1 9563000 NEWHALL ST: MENDELL ST to EVANS AVE (200 - 399) 300 NEWHALL ST 5203041 5203 63 041 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016565.95 2098577.827 37.743224683861605 -122.385342973421 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:10AM-11AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7432246838616, -122.385342973421)
387 947814 Park's Catering 66 Truck 1 9504000 NAPOLEON ST: EVANS AVE \ TOLAND ST to JERROLD AVE (25 - 299) 190 NAPOLEON ST 4343004 4343 101 004 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6012688.941000001 2100244.688 37.7475862762565 -122.398865700796 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7475862762565, -122.398865700796)
388 947812 Park's Catering 66 Truck 1 9563000 NEWHALL ST: MENDELL ST to EVANS AVE (200 - 399) 220 NEWHALL ST 5203040 5203 63 040 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016819.592 2098496.079 37.7430142496315 -122.384460244935 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7430142496315, -122.384460244935)
392 947819 Park's Catering 66 Truck 1 5329000 EVANS AVE: HUNTERS POINT BLVD to JENNINGS ST \ MIDDLE POINT RD (1031 - 1099) 1000 EVANS AVE 4580002 4580 187 002 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6019061.11822 2096525.4056 37.7377268665958 -122.376572914573 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:11AM-12PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7377268665958, -122.376572914573)
393 947817 Park's Catering 66 Truck 1 10397000 PHELPS ST: FAIRFAX AVE to GALVEZ AVE (500 - 599) 525 PHELPS ST 5242015 5242 271 015 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6015469.672 2098066.746 37.7417606496655 -122.38909797019501 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:10AM-11AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7417606496655, -122.389097970195)
395 947811 Park's Catering 66 Truck 1 9563000 NEWHALL ST: MENDELL ST to EVANS AVE (200 - 399) 330 NEWHALL ST 5203035 5203 63 035 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016150.748 2098500.68 37.7429898747753 -122.386773267176 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:9AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7429898747753, -122.386773267176)
397 947804 Park's Catering 66 Truck 1 5337000 EVANS AVE: RANKIN ST to SELBY ST (1800 - 1890) 1801 EVANS AVE 5232005 5232 282 005 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6014340.249 2099120.438 37.74459119509171 -122.393076880858 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:7AM-8AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7445911950917, -122.393076880858)
401 947816 Park's Catering 66 Truck 1 198201 03RD ST: ARTHUR AVE \ CARGO WAY to BURKE AVE (3400 - 3498) -- WEST -- 3450 03RD ST 5211029 5211 285 029 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6015874.731000001 2099503.899 37.7457292216884 -122.387797650837 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:10AM-11AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7457292216884, -122.387797650837)
405 947809 Park's Catering 66 Truck 1 10927000 RANKIN ST: DAVIDSON AVE to EVANS AVE (200 - 299) 220 RANKIN ST 5215016 5215 269 016 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6014805.5139999995 2099795.201 37.746469788114794 -122.39151523877199 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-9AM/12PM-1PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7464697881148, -122.391515238772)
406 947803 Park's Catering 66 Truck 1 3376000 BURKE AVE: END to 03RD ST (1500 - 1599) 1570 BURKE AVE 5203066 5203 63 066 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016479.9436099995 2099135.86798 37.7447521916164 -122.385679248721 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:7AM-8AM/10AM-11AM/12PM-1PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7447521916164, -122.385679248721)
408 947810 Park's Catering 66 Truck 1 3376000 BURKE AVE: END to 03RD ST (1500 - 1599) 1555 BURKE AVE 5203067 5203 63 067 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6016389.77775 2098759.39172 37.743713475368 -122.38596479003598 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-10AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.743713475368, -122.385964790036)
409 947821 Park's Catering 66 Truck 1 7254000 INNES AVE: ARELIOUS WALKER DR to GRIFFITH ST (800 - 899) Assessors Block 4645/Lot015 4645015 4645 288 015 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6019359.972999999 2094482.884 37.732134951922205 -122.375398078567 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo/Mo/Mo/Mo/Mo:6AM-7AM/10AM-11AM/11AM-12PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7321349519222, -122.375398078567)
413 947805 Park's Catering 66 Truck 1 9504000 NAPOLEON ST: EVANS AVE \ TOLAND ST to JERROLD AVE (25 - 299) 250 NAPOLEON ST 4343021 4343 101 021 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6012092.932999999 2099954.245 37.7467555544775 -122.400906270359 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7467555544775, -122.400906270359)
418 947820 Park's Catering 66 Truck 1 5582000 ARELIOUS WALKER DR: PALOU AVE to QUESADA AVE (1300 - 1399) Assessors Block 4755/Lot049 4755049 4755 267 049 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6018439.93443 2092406.50106 37.726382932182204 -122.378434782668 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo/Mo/Mo/Mo/Mo:6AM-7AM/10AM-11AM/11AM-12PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7263829321822, -122.378434782668)
419 947807 Park's Catering 66 Truck 1 5340000 EVANS AVE: NAPOLEON ST \ TOLAND ST to MARIN ST (2000 - 2099) 2020 EVANS AVE 4347A000 4347A 139 000 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins     0.0 0.0 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo-Fr:8AM-9AM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (0, 0)
422 947801 Park's Catering 66 Truck 1 7253000 INNES AVE: EARL ST to ARELIOUS WALKER DR (700 - 799) Assessors Block 4644/Lot008 4644008 4644 292 008 17MFF-0153 APPROVED 5 Cold Truck: Hamburger: cheeseburgers: hot dogs: hot sandwiches: cold sandwiches: egg muffins: cup of noodles: corn dogs: canned soup: coffee: hot cocoa: hot tea: gatorade: juice: milk: soda: water: fruits: fruit salad: rice pudding: yogurt: candy bars: chips: cookies: donuts: granola bars: muffins 6019956.89 2094023.408 37.7309061503597 -122.373302577485 http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0153&ExportPDF=1&Filename=17MFF-0153_schedule.pdf Mo/Mo/Mo/Mo/Mo:6AM-7AM/10AM-11AM/11AM-12PM   03/13/2017 12:00:00 AM 2017-03-13 1 03/15/2018 12:00:00 AM (37.7309061503597, -122.373302577485)

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