food-trucks

This data as json, CSV

rowid	locationid	Applicant	FacilityType	cnn	LocationDescription	Address	blocklot	block	lot	permit	Status	FoodItems	X	Y	Latitude	Longitude	Schedule	dayshours	Approved	Received	PriorPermit	ExpirationDate	Location
2	526124	2	1	7205101	INDUSTRIAL ST: PALOU AVE to QUESADA AVE (51 - 99) -- SOUTH --	75 INDUSTRIAL ST	5332023	2	023	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6012049.291	2097209.482	37.739216586262295	-122.400864373304	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:9AM-10AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7392165862623, -122.400864373304)
6	526148	6	1	11544000	SANSOME ST: PINE ST to CALIFORNIA ST (200 - 299)	233 SANSOME ST	0260002	6	002	14MFF-0035	2	Grilled Cheese Sandwiches	6012313.995	2116649.543	37.792609401119	-122.40131490545099	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf	Th:10AM-2PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.792609401119, -122.401314905451)
7	526123	2	1	11372000	SAN BRUNO AVE: HALE ST to SILVER AVE (2362 - 2399)	2380 SAN BRUNO AVE	5881002	7	002	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6010557.2129999995	2094814.259	37.7325564744198	-122.40585465611	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:9AM-10AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7325564744198, -122.40585465611)
10	526149	6	1	7033000	HOWARD ST: 01ST ST to MALDEN ALY (500 - 589)	555 HOWARD ST	3736086	10	086	14MFF-0035	2	Grilled Cheese Sandwiches	6013558.062999999	2114719.339	37.787378841809996	-122.39687496716299	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf	Fr:3PM-8PM;Th:4PM-8PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.78737884181, -122.396874967163)
13	526128	2	1	5118000	EGBERT AVE: NEWHALL ST to PHELPS ST (1800 - 1899)	1828 EGBERT AVE	5434B005	12	005	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6012179.37	2092973.822	37.7275936019207	-122.400117226063	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:10AM-11AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7275936019207, -122.400117226063)
18	526090	15	1	8733000	MARIPOSA ST: BRYANT ST to FLORIDA ST (2700 - 2799)	2772 MARIPOSA ST	3970004	17	004	14MFF-0030	2	Wood Fired Pizzas	6009371.839	2106032.5	37.763292918729	-122.41074477293002	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0030&ExportPDF=1&Filename=14MFF-0030_schedule.pdf	Sa-Su:8AM-11PM;Mo-Fr:5PM-11PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.763292918729, -122.41074477293)
19	526150	6	1	4609000	DAVIS ST: DAVIS CT \ JACKSON ST to BROADWAY (500 - 699)		0167010	18	010	14MFF-0035	2	Grilled Cheese Sandwiches	6012974.89	2118691.505	37.7982529941715	-122.399171569524	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf	We:6AM-3PM;Su:6AM-8PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.7982529941715, -122.399171569524)
20	526129	2	1	2709000	BANCROFT AVE: INGALLS ST to JENNINGS ST (1400 - 1499)	1455 BANCROFT AVE	4879022	19	022	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6014981.941000001	2091509.43	37.723728538541	-122.39032635776199	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:10AM-11AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.723728538541, -122.390326357762)
24	526132	2	1	5118000	EGBERT AVE: NEWHALL ST to PHELPS ST (1800 - 1899)	1843 EGBERT AVE	5447053	23	053	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6011893.793	2092823.701	37.7271654734939	-122.401093930725	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:10AM-11AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7271654734939, -122.401093930725)
27	526147	6	1	106000	01ST ST: NATOMA ST to HOWARD ST (165 - 199)	400 HOWARD ST	3720008	26	008	14MFF-0035	2	Grilled Cheese Sandwiches	6013858.05956	2115347.09492	37.7891192076677	-122.39588103933501	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf	Tu:10AM-3PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.7891192076677, -122.395881039335)
29	526127	2	1	13784000	YOSEMITE AVE: LANE ST to MENDELL ST (1700 - 1799)	1760 YOSEMITE AVE	5414020	28	020	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6013838.475	2093363.33	37.7287554795043	-122.39440890150101	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:9AM-10AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7287554795043, -122.394408901501)
33	526091	15	1	5872000	FRONT ST: JACKSON ST to PACIFIC AVE (600 - 699)	600 FRONT ST	0172010	31	010	14MFF-0030	2	Wood Fired Pizzas	6013015.315	2118400.114	37.7974551567824	-122.399011222821	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0030&ExportPDF=1&Filename=14MFF-0030_schedule.pdf	Mo-Fr:8AM-4PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.7974551567824, -122.399011222821)
39	526133	2	1	11546000	SANSOME ST: HALLECK ST to SACRAMENTO ST (334 - 399)	350 SANSOME ST	0238006	34	006	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6012413.268999999	2117074.903	37.7937828768391	-122.40100131199301	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:6AM-8AM/11AM-12PM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7937828768391, -122.401001311993)
40	526131	2	1	5117000	EGBERT AVE: END to NEWHALL ST (1700 - 1798)	1785 EGBERT AVE	5431A002	35	002	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6012684.311000001	2092414.5769999998	37.726086170672296	-122.398332406177	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:10AM-11AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7260861706723, -122.398332406177)
41	526130	2	1	9792000	OAKDALE AVE: QUINT ST to RANKIN ST (1900 - 1999)	1900 OAKDALE AVE	5314001	36	001	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6013438.391	2096848.22	37.7383020209625	-122.396036145058	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:10AM-11AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7383020209625, -122.396036145058)
49	526126	2	1	13780000	YOSEMITE AVE: INGALLS ST to JENNINGS ST (1400 - 1499)	1485 YOSEMITE AVE	4847025	42	025	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.	6015155.575	2092076.679	37.7252957217827	-122.389765731256	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:9AM-10AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(37.7252957217827, -122.389765731256)
50	526146	6	1	13160101	VAN NESS AVE: CLAY ST to WASHINGTON ST (1801 - 1899) -- WEST --	1801 VAN NESS AVE	0618002	43	002	14MFF-0035	2	Grilled Cheese Sandwiches	6006008.931	2116666.941	37.79230338307529	-122.423131922094	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0035&ExportPDF=1&Filename=14MFF-0035_schedule.pdf	Th:6AM-10AM;Mo/Sa:6AM-8PM	03/13/2014 12:00:00 AM	2014-03-13	0	03/15/2015 12:00:00 AM	(37.7923033830753, -122.423131922094)
62	526125	2	1	223201	03RD ST: ARMSTRONG AVE to BANCROFT AVE (5600 - 5698) -- WEST --	5600 03RD ST	5421003	54	003	14MFF-0034	2	Cold Truck: Cheeseburgers: Burgers: Chicken Bake: Chili Dogs: Hot Dogs: Corn Dogs: Cup of Noodles: Egg Muffins: Tamales: Hot Sandwiches Quesadillas: Gatorade: Juice: Soda: Mikl: Coffee: Hot Cocoa: Hot Tea: Flan: Fruits: Fruit Salad: Yogurt: Candy: Chips: Donuts: Cookies: Granola: Muffins & Various Drinks & Pre-Packaged Snacks.			0.0	0.0	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0034&ExportPDF=1&Filename=14MFF-0034_schedule.pdf	Mo-Fr:9AM-10AM	03/13/2014 12:00:00 AM	2014-03-13	1	03/15/2015 12:00:00 AM	(0, 0)
71	526308	34	1	4313000	COMMERCIAL ST: LEIDESDORFF ST to MONTGOMERY ST (543 - 599)	565 COMMERCIAL ST	0228010	60	010	14MFF-0052	2	Traditional BBQ: Chicken: Ribs: Sandwiches: Sausages	6012004.848999999	2117204.765	37.7941166557094	-122.40242362612	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0052&ExportPDF=1&Filename=14MFF-0052_schedule.pdf	Mo-Fr:9AM-4PM		2014-03-13	0	03/15/2015 12:00:00 AM	(37.7941166557094, -122.40242362612)
90	526152	36	2	13660000	WILLIAMS AVE: APOLLO ST to PHELPS ST \ VESTA ST (300 - 399)	345 WILLIAMS AVE	5423A009	5	009	14MFF-0036	2	Breakfast sandwiches: mixed coffee drinks: fried chicken: hamburgers: hot dogs: hot links: tacos: pizza: rotisserrie chicken: fish sticks: deli sandwiches: burritos: philly cheese steak: rice: baked potato: cold beverages: teas: juices: salads: bbq ribs: french fries: yogurt and bread	6012447.306	2093773.9340000001	37.7298054805741	-122.39924710472401	http://bsm.sfdpw.org/PermitsTracker/reports/report.aspx?title=schedule&report=rptSchedule&params=permit=14MFF-0036&ExportPDF=1&Filename=14MFF-0036_schedule.pdf	Su/Fr/Sa:6AM-8PM		2014-03-13	0	03/15/2014 12:00:00 AM	(37.7298054805741, -122.399247104724)

food-trucks

Custom SQL query returning 20 rows (hide)

Query parameters