Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: cnn, LocationDescription, block, lot, Latitude, Longitude, dayshours, Location, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 224 | 224 | 945106 | F & C Catering 56 | Truck 1 | 0 | Assessors Block /Lot | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:12PM-1PM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (0, 0) | |||||||
| 225 | 225 | 945099 | F & C Catering 56 | Truck 1 | 12664000 | TOWNSEND ST: 05TH ST to 06TH ST (400 - 499) | 444 TOWNSEND ST | 3785004A | 3785 183 | 004A | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6012987.022999999 | 2110175.723 | 37.7748713162388 | -122.39853170827601 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:10AM-11AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7748713162388, -122.398531708276) | |
| 226 | 226 | 945096 | F & C Catering 56 | Truck 1 | 9058000 | MINNESOTA ST: 23RD ST to 24TH ST (1200 - 1299) | 1275 MINNESOTA ST | 4229004 | 4229 185 | 004 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6015479.602000001 | 2102615.711 | 37.754251708893705 | -122.38938122888 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:9AM-10AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7542517088937, -122.38938122888) | |
| 227 | 227 | 945102 | F & C Catering 56 | Truck 1 | 9056000 | MINNESOTA ST: 20TH ST to 22ND ST (800 - 999) | 900 MINNESOTA ST | 4106001A | 4106 84 | 001A | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 0.0 | 0.0 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:10AM-11AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (0, 0) | |||
| 228 | 228 | 945101 | F & C Catering 56 | Truck 1 | 10336000 | PENNSYLVANIA AVE: 22ND ST to 23RD ST (700 - 899) | 898 PENNSYLVANIA AVE | 4167003 | 4167 186 | 003 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6014175.628 | 2103109.247 | 37.7555344716039 | -122.39392527753901 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo/Tu/We/Th:10AM-11AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7555344716039, -122.393925277539) | |
| 229 | 229 | 945104 | F & C Catering 56 | Truck 1 | 5329000 | EVANS AVE: HUNTERS POINT BLVD to JENNINGS ST \ MIDDLE POINT RD (1031 - 1099) | 1000 EVANS AVE | 4580002 | 4580 187 | 002 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6019061.11822 | 2096525.4056 | 37.7377268665958 | -122.376572914573 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:8AM-10AM/11AM-12PM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7377268665958, -122.376572914573) | |
| 230 | 230 | 945098 | F & C Catering 56 | Truck 1 | 3076000 | BRANNAN ST: JACK LONDON ALY to 03RD ST (350 - 399) | 355 BRANNAN ST | 3788024A | 3788 188 | 024A | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6014670.893999999 | 2112213.7709999997 | 37.780561002676 | -122.39284941302401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:9AM-10AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.780561002676, -122.392849413024) | |
| 231 | 231 | 945107 | F & C Catering 56 | Truck 1 | 1403000 | 25TH ST: MICHIGAN ST to ILLINOIS ST (700 - 799) | 700 25TH ST | 4244004 | 4244 85 | 004 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6016344.255 | 2102281.09 | 37.7533808099749 | -122.386367685857 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:12PM-1PM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7533808099749, -122.386367685857) | |
| 232 | 232 | 945095 | F & C Catering 56 | Truck 1 | 193201 | 03RD ST: 24TH ST to 25TH ST (2800 - 2898) -- WEST -- | 2890 03RD ST | 4246003 | 4246 135 | 003 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6015821.245 | 2102192.556 | 37.753108749871295 | -122.38817020206601 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:6AM-9AM/12PM-1PM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7531087498713, -122.388170202066) | |
| 233 | 233 | 945100 | F & C Catering 56 | Truck 1 | 193201 | 03RD ST: 24TH ST to 25TH ST (2800 - 2898) -- WEST -- | 2800 03RD ST | 4246001 | 4246 135 | 001 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6015771.1389999995 | 2102415.24 | 37.753717416902106 | -122.38835902104401 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:10AM-11AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7537174169021, -122.388359021044) | |
| 234 | 234 | 945105 | F & C Catering 56 | Truck 1 | 5333201 | EVANS AVE: NEWHALL ST to 03RD ST (1500 - 1578) -- NORTH -- | 1550 EVANS AVE | 5203035 | 5203 63 | 035 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6016150.748 | 2098500.68 | 37.7429898747753 | -122.386773267176 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:11AM-12PM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7429898747753, -122.386773267176) | |
| 235 | 235 | 945103 | F & C Catering 56 | Truck 1 | 12491000 | TENNESSEE ST: END to 26TH ST (1500 - 1599) | 1500 TENNESSEE ST | 4294012 | 4294 189 | 012 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6015520.522999999 | 2101882.84 | 37.752241668480295 | -122.389188542589 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:8AM-10AM/10AM-11AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7522416684803, -122.389188542589) | |
| 236 | 236 | 945097 | F & C Catering 56 | Truck 1 | 379000 | 07TH ST: BERRY ST to CHANNEL ST (851 - 999) | 900 07TH ST | 3807001 | 3807 190 | 001 | 17MFF-0137 | APPROVED 5 | Cold Truck: Hot/Cold Sandwiches: Water: Soda: Juice: Snacks: Milk: Candies: Canned Food: Soups: Cup of Noodles: Fruit: Salad | 6012496.24 | 2108349.269 | 37.769828933701795 | -122.400101143043 | http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule¶ms=permit=17MFF-0137&ExportPDF=1&Filename=17MFF-0137_schedule.pdf | Mo-Fr:9AM-10AM | 03/06/2017 12:00:00 AM | 2017-03-06 | 1 | 03/15/2018 12:00:00 AM | (37.7698289337018, -122.400101143043) |
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");