Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132 | 132 | 934594 | May Catering 37 | Truck 1 | 13768000 | YORK ST: 19TH ST to 20TH ST (700 - 799) | 720 YORK ST | 4080018 | 4080 109 | 018 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009791.69356 | 2104761.23213 | 37.7598258374358 | -122.40920291508301 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7598258374358, -122.409202915083) | ||
| 131 | 131 | 934592 | May Catering 37 | Truck 1 | 7163000 | 299 ILLINOIS ST | 3850001A | 3850 108 | 001A | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM/12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | |||||
| 128 | 128 | 934626 | May Catering 37 | Truck 1 | 0 | Assessors Block /Lot | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||||||
| 127 | 127 | 934616 | May Catering 37 | Truck 1 | 4909000 | DONNER AVE: END to 03RD ST (1600 - 1699) | 1600 DONNER AVE | 4881023 | 4881 106 | 023 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014214.714 | 2091627.121 | 37.7240091065402 | -122.39298678257799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:4PM-5PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7240091065402, -122.392986782578) | ||
| 126 | 126 | 934623 | May Catering 37 | Truck 1 | 12775000 | ULLOA ST: WOODSIDE AVE to SYDNEY WAY (1 - 56) | 2 ULLOA ST | 2914001 | 2914 105 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 5996669.215 | 2099864.483 | 37.7456366838808 | -122.454233188657 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Su:9AM-10AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7456366838808, -122.454233188657) | ||
| 124 | 124 | 934587 | May Catering 37 | Truck 1 | 699001 | 16TH ST: OWENS ST to 07TH ST \ MISSISSIPPI ST (700 - 899) | Assessors Block 8727/Lot005 | 8727005 | 8727 103 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014460.137 | 2106764.375 | 37.7655864681473 | -122.393197101166 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7655864681473, -122.393197101166) | ||
| 123 | 123 | 934576 | May Catering 37 | Truck 1 | 7169000 | ILLINOIS ST: 20TH ST to 22ND ST (900 - 1099) | 1000 ILLINOIS ST | 4109001 | 4109 102 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015939.401000001 | 2104425.293 | 37.7592459190261 | -122.387917376991 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:8AM-9AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7592459190261, -122.387917376991) | ||
| 122 | 122 | 934599 | May Catering 37 | Truck 1 | 9504000 | NAPOLEON ST: EVANS AVE \ TOLAND ST to JERROLD AVE (25 - 299) | 180 NAPOLEON ST | 4343004 | 4343 101 | 004 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012688.941000001 | 2100244.688 | 37.7475862762565 | -122.398865700796 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:9AM-10AM/11AM-12PM/2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7475862762565, -122.398865700796) | ||
| 121 | 121 | 934624 | May Catering 37 | Truck 1 | 6805000 | HAWES ST: INGERSON AVE to JAMESTOWN AVE (2900 - 2999) | 2930 HAWES ST | 4971022 | 4971 100 | 022 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014554.034 | 2089351.467 | 37.717779453627 | -122.391654765179 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Su:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.717779453627, -122.391654765179) | ||
| 119 | 119 | 934596 | May Catering 37 | Truck 1 | 2111000 | ALABAMA ST: MARIPOSA ST to 18TH ST (500 - 599) | 501 ALABAMA ST | 4018005 | 4018 98 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6009055.308999999 | 2105741.745 | 37.762476819591 | -122.41181900367901 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.762476819591, -122.411819003679) | ||
| 117 | 117 | 934621 | May Catering 37 | Truck 1 | 9053000 | MINNESOTA ST: 04TH ST \ MARIPOSA ST to 18TH ST (500 - 599) | 535 MINNESOTA ST | 3996016 | 3996 96 | 016 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015237.97 | 2106058.2819999997 | 37.763690871096 | -122.39045738601601 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.763690871096, -122.390457386016) | ||
| 115 | 115 | 934575 | May Catering 37 | Truck 1 | 7502000 | JERROLD AVE: UPTON ST to NAPOLEON ST (2201 - 2299) | 2270 JERROLD AVE | 5230008 | 5230 94 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012245.5 | 2099714.018 | 37.746104451715205 | -122.400361834965 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:8AM-9AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7461044517152, -122.400361834965) | ||
| 114 | 114 | 934619 | May Catering 37 | Truck 1 | 5372103 | EXECUTIVE PARK BLVD: CANDLESTICK COVE WAY to SANDPIPER COVE WAY \ THOMAS MELLON DR (138 - 198) | 150 EXECUTIVE PARK BLVD | 4991086 | 4991 93 | 086 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013956.743 | 2086835.501 | 37.710837931141 | -122.393543363013 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:7PM-8PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.710837931141, -122.393543363013) | ||
| 113 | 113 | 934618 | May Catering 37 | Truck 1 | 9086000 | MISSION ST: BEALE ST to FREMONT ST (300 - 399) | 350 MISSION ST | 3710017 | 3710 92 | 017 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013638.57 | 2115994.808 | 37.790885463501894 | -122.396685875811 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:6PM-7PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7908854635019, -122.396685875811) | ||
| 112 | 112 | 934617 | May Catering 37 | Truck 1 | 2953000 | BERRY ST: 03RD ST to 04TH ST (100 - 199) | 185 BERRY ST | 3803005 | 3803 91 | 005 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014943.869 | 2110666.298 | 37.7763271477899 | -122.39179682107701 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:6PM-7PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7763271477899, -122.391796821077) | ||
| 111 | 111 | 934598 | May Catering 37 | Truck 1 | 1520000 | 26TH ST: SHOTWELL ST to VIRGIL ST (3251 - 3273) | 3251 26TH ST | 6572001 | 6572 90 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008228.38 | 2100763.8230000003 | 37.7487621514792 | -122.414326828755 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:11AM-12PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7487621514792, -122.414326828755) | ||
| 110 | 110 | 934608 | May Catering 37 | Truck 1 | 3889000 | CHANNEL ST: END to END (0 - 0) | Assessors Block 3810/Lot008 | 3810008 | 3810 78 | 008 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6013705.031 | 2109129.688 | 37.772039113525 | -122.395974631586 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.772039113525, -122.395974631586) | ||
| 109 | 109 | 934588 | May Catering 37 | Truck 1 | 2478101 | CESAR CHAVEZ ST: KANSAS ST to BAY SHORE BLVD \ VERMONT ST (2501 - 2625) -- SOUTH -- | 2501 CESAR CHAVEZ ST | 4339001 | 4339 89 | 001 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6011674.927 | 2100772.595 | 37.7489792411554 | -122.402409234561 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:9AM-10AM/12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7489792411554, -122.402409234561) | ||
| 108 | 108 | 934609 | May Catering 37 | Truck 1 | 3887000 | CHANNEL ST: 03RD ST to 04TH ST (0 - 0) | Assessors Block 8711/Lot023 | 8711023 | 8711 52 | 023 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6015253.3503 | 2109839.76272 | 37.774074841058294 | -122.390668458146 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7740748410583, -122.390668458146) | ||
| 107 | 107 | 934612 | May Catering 37 | Truck 1 | 13693000 | WISCONSIN ST: 16TH ST to 17TH ST (100 - 199) | 166 WISCONSIN ST | 3954017 | 3954 88 | 017 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6012435.699 | 2106749.8340000003 | 37.7654338684827 | -122.400198205294 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7654338684827, -122.400198205294) | ||
| 104 | 104 | 934602 | May Catering 37 | Truck 1 | 6747000 | HARRISON ST: MARIPOSA ST to 18TH ST (2150 - 2198) | 2150 HARRISON ST | 3573025 | 3573 87 | 025 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:12PM-1PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||
| 103 | 103 | 934589 | May Catering 37 | Truck 1 | 6746000 | HARRISON ST: 17TH ST to MARIPOSA ST (2050 - 2149) | 2130 HARRISON ST | 3573046 | 3573 87 | 046 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6008655.37685 | 2105873.06628 | 37.7628149532289 | -122.413211513673 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7628149532289, -122.413211513673) | ||
| 102 | 102 | 934590 | May Catering 37 | Truck 1 | 2955000 | BERRY ST: 05TH ST to 06TH ST (300 - 399) | 301 BERRY ST | 8708002 | 8708 86 | 002 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014277.187000001 | 2109955.224 | 37.7743376663696 | -122.394053286313 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7743376663696, -122.394053286313) | ||
| 99 | 99 | 934577 | May Catering 37 | Truck 1 | 9056000 | MINNESOTA ST: 20TH ST to 22ND ST (800 - 999) | 900 MINNESOTA ST | 4106001A | 4106 84 | 001A | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:8AM-9AM/2PM-3PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) | ||||
| 98 | 98 | 934627 | May Catering 37 | Truck 1 | 19984000 | 04TH ST: CHINA BASIN ST to MISSION BAY BLVD (1300 - 1399) | 1322 04TH ST | 1758 035 | 1758 83 | 035 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 5994967.667 | 2106540.921 | 37.7638707601661 | -122.460600563879 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:9AM-10AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7638707601661, -122.460600563879) | ||
| 95 | 95 | 934625 | May Catering 37 | Truck 1 | 0 | Assessors Block 8710/Lot003 | 8710003 | 8710 80 | 003 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 6014416.532000001 | 2108607.696 | 37.7706453983908 | -122.39347693719999 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo/Mo/Mo/Mo/Mo:9AM-10AM/10AM-11AM/12PM-1PM/1PM-2PM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (37.7706453983908, -122.3934769372) | |||
| 93 | 93 | 934593 | May Catering 37 | Truck 1 | 697000 | 16TH ST: 03RD ST to 04TH ST (500 - 599) | 500 16TH ST | 3810007 | 3810 78 | 007 | 17MFF-0110 | REQUESTED 1 | Cold Truck: Sandwiches: fruit: snacks: candy: hot and cold drinks | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0110&ExportPDF=1&Filename=17MFF-0110_schedule.pdf | Mo-Fr:10AM-11AM | 2017-02-13 | 1 | 05/06/2018 12:00:00 AM | (0, 0) |
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");