Mobile_Food_Facility_Permit

Data source: data.sfgov.org

13 rows where Applicant = 56

View and edit SQL

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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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 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&params=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)

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