Mobile_Food_Facility_Permit

7 rows where lot = 018

Search:

descending

Link	rowid ▼	locationid	Applicant	FacilityType	cnn	LocationDescription	Address	blocklot	block	lot	permit	Status	FoodItems	X	Y	Latitude	Longitude	Schedule	dayshours	Approved	Received	PriorPermit	ExpirationDate	Location
43	43	747679	The Brooklyn Pig Inc. 21	Truck 1	3283000	BRYANT ST: RITCH ST to ZOE ST (515 - 544)	544 BRYANT ST	3762018	3762 38	018	16MFF-0009	REQUESTED 1	Hamburgers: French fries: fried chicken and waffles: sandwiches: omelets and sodas	6013468.451	2112291.173	37.7807066695518	-122.39701469241501	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=16MFF-0009&ExportPDF=1&Filename=16MFF-0009_schedule.pdf	Th/Fr/Sa:11AM-12AM		2016-01-25	0		(37.7807066695518, -122.397014692415)
72	72	559775	Mang Hang Catering 35	Truck 1	8848000	MASONIC AVE: MCALLISTER ST to FULTON ST (500 - 599)	500 MASONIC AVE	1175018	1175 61	018	14MFF-0109	EXPIRED 2	COLD TRUCK. Deli: bbq chicken skewer: Chinese spring roll: Chinese fried rice/noodle: fried chicken leg/wing: bbq chicken sandwich: chicken cheese burger: burrito: lumpia. Snack: sunflower seeds: muffins: chips: snickers: kit-kat: 10 types of chocolate. Drinks: Coke: 7-Up: Dr. Pepper: Pepsi: Redbull: Vitamin Water: Rockstar: Coconut Juice: Water. Hot drinks: coffee: tea.	5999194.35773	2111070.4801	37.776550042819096	-122.446307635558	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0109&ExportPDF=1&Filename=14MFF-0109_schedule.pdf	Mo-Fr:6AM-7AM/11AM-12PM		2014-07-10	1	03/15/2017 12:00:00 AM	(37.7765500428191, -122.446307635558)
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&params=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)
239	239	934638	Anas Goodies Catering 57	Truck 1	9061000	MINNESOTA ST: END to 26TH ST (1400 - 1499)	1400 MINNESOTA ST	4293018	4293 192	018	17MFF-0111	APPROVED 5	Cold Truck: Sandwiches: Noodles: Pre-packaged Snacks: Candy: Desserts Various Beverages	6015242.857999999	2101827.597	37.7520745862084	-122.390144900822	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0111&ExportPDF=1&Filename=17MFF-0111_schedule.pdf	Mo-Fr:8AM-9AM/11AM-12PM	03/08/2017 12:00:00 AM	2017-02-13	1	03/15/2018 12:00:00 AM	(37.7520745862084, -122.390144900822)
435	435	948140	Eli's Hot Dogs 78	Push Cart 2	7504000	JERROLD AVE: BARNEVELD AVE to END (2351 - 2369)	101 BAY SHORE BLVD	5559018	5559 46	018	17MFF-0155	REQUESTED 1	various styles of hot dogs & sausages: chips: breakfast sandwiches: chili: soda: water:	6011376.107000001	2100039.012	37.7469482955131	-122.40339096031299	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0155&ExportPDF=1&Filename=17MFF-0155_schedule.pdf	Mo/Tu/We/Th/Fr:9AM-5PM		2017-03-14	1	03/15/2017 12:00:00 AM	(37.7469482955131, -122.403390960313)
551	551	934381	Two G's Catering 103	Truck 1	2734000	BARNEVELD AVE: JERROLD AVE to LOOMIS ST \ MCKINNON AVE (100 - 299)	175 BARNEVELD AVE	5286A018	5286A 368	018	17MFF-0073	APPROVED 5	Cold Truck: Hot & Cold Sandwiches: Bagels: Burritos: Soups: Hot Dogs: Tacos: Pork Buns: BBQ Meat: Fruit: Various Beverages: Pasties: Pre-Packaged Snacks: Candy: Salads: Muffins: Scones: Brownies: Croissants: Energy Bars: Noodle Bowls	6011606.147999999	2099252.817	37.7448024193644	-122.402540218927	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0073&ExportPDF=1&Filename=17MFF-0073_schedule.pdf	Mo-Fr:9AM-10AM	04/17/2017 12:00:00 AM	2017-02-13	1	03/15/2018 12:00:00 AM	(37.7448024193644, -122.402540218927)
644	644	1037689	Munch A Bunch 126	Truck 1	373000	07TH ST: CLEVELAND ST to HARRISON ST (314 - 399)	355 07TH ST	3754 018	3754 404	018	17MFF-0197	APPROVED 5	Cold Truck: packaged sandwiches: pitas: breakfast: cold and hot drinks: snacks	6010570.267000001	2110774.8430000003	37.7763814259936	-122.406934051626	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=17MFF-0197&ExportPDF=1&Filename=17MFF-0197_schedule.pdf	Mo-Fr:8AM-9AM	11/21/2017 12:00:00 AM	2017-11-16	1	03/15/2018 12:00:00 AM	(37.7763814259936, -122.406934051626)

Advanced export

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");