Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: block, lot, dayshours
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 566 | 566 | 963998 | Singh Brothers Ice Cream 105 | Truck 1 | 10327000 | PENINSULA AVE: BLANKEN AVE to LATHROP AVE (300 - 399) | 360 PENINSULA AVE | 5083009 | 5083 372 | 009 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6012192.793 | 2086872.475 | 37.710841283585296 | -122.399642614963 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:5PM-6PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7108412835853, -122.399642614963) | ||
| 583 | 583 | 963983 | Singh Brothers Ice Cream 105 | Truck 1 | 7492000 | JENNINGS ST: KEY AVE to LE CONTE AVE (3400 - 3499) | 3444 JENNINGS ST | 4995005 | 4995 384 | 005 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013111.658 | 2089651.112 | 37.7185220485664 | -122.396661444417 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7185220485664, -122.396661444417) | ||
| 578 | 578 | 963997 | Singh Brothers Ice Cream 105 | Truck 1 | 9602000 | NIBBI CT: GILLETTE AVE to END (1 - 99) | 35 NIBBI CT | 5079004 | 5079 381 | 004 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013200.29 | 2086710.154 | 37.7104516918675 | -122.39614907899599 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7104516918675, -122.396149078996) | ||
| 579 | 579 | 963982 | Singh Brothers Ice Cream 105 | Truck 1 | 7819000 | KEY AVE: JENNINGS ST to 03RD ST (1000 - 1068) | 1060 KEY AVE | 4994002 | 4994 382 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013314.667 | 2089893.9819999998 | 37.7192002177133 | -122.395976731096 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7192002177133, -122.395976731096) | ||
| 577 | 577 | 963979 | Singh Brothers Ice Cream 105 | Truck 1 | 7252000 | INGERSON AVE: JENNINGS ST to 03RD ST (1100 - 1199) | 1173 INGERSON AVE | 4968035 | 4968 380 | 035 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6013341.727999999 | 2090348.3630000001 | 37.720449362659394 | -122.395915014237 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7204493626594, -122.395915014237) | ||
| 576 | 576 | 963985 | Singh Brothers Ice Cream 105 | Truck 1 | 2710000 | BANCROFT AVE: JENNINGS ST to KEITH ST (1500 - 1599) | 1562 BANCROFT AVE | 4849006 | 4849 379 | 006 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014513.081 | 2092146.105 | 37.725450702172296 | -122.391991641418 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7254507021723, -122.391991641418) | ||
| 574 | 574 | 963984 | Singh Brothers Ice Cream 105 | Truck 1 | 4908000 | DONNER AVE: INGALLS ST to JENNINGS ST (1400 - 1499) | 1475 DONNER AVE | 4910023 | 4910 378 | 023 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014572.169 | 2091177.246 | 37.722793688759296 | -122.391719666472 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:1PM-2PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7227936887593, -122.391719666472) | ||
| 581 | 581 | 963996 | Singh Brothers Ice Cream 105 | Truck 1 | 7895000 | KIRKWOOD AVE: NEWHALL ST to PHELPS ST (1600 - 1699) | 1698 KIRKWOOD AVE | 5279027 | 5279 383 | 027 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014750.982999999 | 2097205.93 | 37.7393571608675 | -122.39152281175899 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7393571608675, -122.391522811759) | ||
| 570 | 570 | 963978 | Singh Brothers Ice Cream 105 | Truck 1 | 6961000 | HOLLISTER AVE: HAWES ST to INGALLS ST (1000 - 1099) | 1000 HOLLISTER AVE | 4943002 | 4943 375 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6014891.341 | 2089767.246 | 37.7189398190959 | -122.390517872066 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7189398190959, -122.390517872066) | ||
| 575 | 575 | 963986 | Singh Brothers Ice Cream 105 | Truck 1 | 13356000 | WALLACE AVE: JENNINGS ST to KEITH ST (1500 - 1599) | 1550 WALLACE AVE | 4829006 | 4829 261 | 006 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015093.174 | 2092759.834 | 37.727168068782 | -122.390029148701 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.727168068782, -122.390029148701) | ||
| 580 | 580 | 963981 | Singh Brothers Ice Cream 105 | Truck 1 | 7428000 | JAMESTOWN AVE: GRIFFITH ST to CORONADO ST (800 - 850) | 800 JAMESTOWN AVE | 4973034 | 4973 137 | 034 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015040.705 | 2088854.908 | 37.7164430021474 | -122.389937879321 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7164430021474, -122.389937879321) | ||
| 582 | 582 | 963980 | Singh Brothers Ice Cream 105 | Truck 1 | 6548000 | GRIFFITH ST: INGERSON AVE to JAMESTOWN AVE (2900 - 2999) | 2900 GRIFFITH ST | 4973001 | 4973 137 | 001 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015142.712 | 2089052.53 | 37.716991290324 | -122.38959908417 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:12PM-1PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.716991290324, -122.38959908417) | ||
| 569 | 569 | 963987 | Singh Brothers Ice Cream 105 | Truck 1 | 5599000 | FITZGERALD AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1104 FITZGERALD AVE | 4914022 | 4914 374 | 022 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015221.628 | 2090210.3169999998 | 37.7201747226493 | -122.389407114342 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7201747226493, -122.389407114342) | ||
| 568 | 568 | 963990 | Singh Brothers Ice Cream 105 | Truck 1 | 7479000 | JENNINGS ST: VAN DYKE AVE to WALLACE AVE (2100 - 2199) | 2115 JENNINGS ST | 4828021 | 4828 250 | 021 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015486.282000001 | 2092591.619 | 37.7267279782571 | -122.388658428832 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7267279782571, -122.388658428832) | ||
| 584 | 584 | 963989 | Singh Brothers Ice Cream 105 | Truck 1 | 13780000 | YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499) | 1420 YOSEMITE AVE | 4831012 | 4831 32 | 012 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6015609.592 | 2092025.9880000001 | 37.7251817007288 | -122.38819268844401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7251817007288, -122.388192688444) | ||
| 573 | 573 | 963993 | Singh Brothers Ice Cream 105 | Truck 1 | 11783000 | SHAFTER AVE: HAWES ST to INGALLS ST (1200 - 1299) | 1207 SHAFTER AVE | 4792001A | 4792 260 | 001A | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6016941.58 | 2092555.108 | 37.726708272962206 | -122.3836249172 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7267082729622, -122.3836249172) | ||
| 586 | 586 | 963992 | Singh Brothers Ice Cream 105 | Truck 1 | 10810000 | QUESADA AVE: CRISP RD to HAWES ST (1170 - 1199) | 1191 QUESADA AVE | 4763042 | 4763 245 | 042 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017387.966 | 2092923.5080000001 | 37.727744490701106 | -122.382107375242 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7277444907011, -122.382107375242) | ||
| 585 | 585 | 963988 | Singh Brothers Ice Cream 105 | Truck 1 | 10218000 | PALOU AVE: HAWES ST to INGALLS ST (1100 - 1199) | 1101 PALOU AVE | 4757024 | 4757 385 | 024 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017464.808999999 | 2093259.551 | 37.7286714428179 | -122.38186508864099 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:2PM-3PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7286714428179, -122.381865088641) | ||
| 572 | 572 | 963994 | Singh Brothers Ice Cream 105 | Truck 1 | 7223000 | INGALLS ST: GEORGE CT to OAKDALE AVE (1300 - 1399) | 1309 INGALLS ST | 4714002 | 4714 377 | 002 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017478.204 | 2093879.426 | 37.7303742378628 | -122.38186187865699 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7303742378628, -122.381861878657) | ||
| 571 | 571 | 963991 | Singh Brothers Ice Cream 105 | Truck 1 | 6671000 | HARBOR RD: NORTHRIDGE RD to INGALLS ST (1 - 299) | 297 HARBOR RD | 4712008 | 4712 376 | 008 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6017903.776000001 | 2094986.9640000002 | 37.733438811640795 | -122.38046754951799 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:3PM-4PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.7334388116408, -122.380467549518) | ||
| 567 | 567 | 963995 | Singh Brothers Ice Cream 105 | Truck 1 | 4938000 | KISKA RD: DORMITORY RD \ KIRKWOOD AVE to REARDON RD (141 - 199) | 195 KISKA RD | 4700052 | 4700 373 | 052 | 17MFF-0182 | REQUESTED 1 | Ice Cream: Pre-Packaged Chips: Candies: Bottled Water & Canned SODA | 6018976.06063 | 2093508.4787 | 37.729438288454 | -122.376657800723 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0182&ExportPDF=1&Filename=17MFF-0182_schedule.pdf | Mo-Fr:4PM-5PM | 2017-04-18 | 1 | 03/15/2018 12:00:00 AM | (37.729438288454, -122.376657800723) |
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");