trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
742	37975	7	135	1199 Tennessee St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/06/1998 12:00:00 AM			Permit Number 40204	6015599.59779117	2103398.4652457	37.7564076382433	-122.389020897855	(37.7564076382433, -122.389020897855)	10	3	8	28856	29
11617	35800	7	135		3	Sidewalk: Curb side : Cutout	Tree	2		04/22/1998 12:00:00 AM			Permit Number 39046
21509	120508	7	135	888 Brannan St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF					6011033.13178113	2109012.34051696	37.7715678900614	-122.405208723585	(37.7715678900614, -122.405208723585)	14	2	9	28853	34
24485	50762	7	135	1247 Harrison St	3	Sidewalk: Curb side : Cutout	Tree	2		12/17/2009 12:00:00 AM			Permit Number 53107	6009900.23371634	2109608.97618966	37.7731427119765	-122.409169607112	(37.7731427119765, -122.409169607112)	14	2	9	28853	34
76167	52319	7	135	4308 21st St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/05/2005 12:00:00 AM			Permit Number 48475	6001136.61726657	2103347.24100136	37.7554546726713	-122.43903517577	(37.7554546726713, -122.43903517577)	2	4	5	28862	38
93269	31426	7	135	4220 21st St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	05/01/1995 12:00:00 AM			Permit Number 35007	6001430.13223279	2103389.64483278	37.7555877996488	-122.438023150412	(37.7555877996488, -122.438023150412)	2	4	5	28862	3
99289	35774	7	135	3692 18th St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/05/1998 12:00:00 AM			Permit Number 39030	6004971.89537308	2105472.67366607	37.7615080868858	-122.425922888595	(37.7615080868858, -122.425922888595)	8	4	5	28859	19
106450	42002	7	135	240 Manor Dr	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	06/21/2000 12:00:00 AM			Permit Number 42337	5993892.40263021	2094032.39552185	37.7294635953142	-122.463411763134	(37.7294635953142, -122.463411763134)	9	8	4	59	40
123238	42052	7	135	405 Duncan St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	06/21/2000 12:00:00 AM			Permit Number 779344	6003892.7703069	2099803.34109747	37.7458803892155	-122.42925086473	(37.7458803892155, -122.42925086473)	2	7	5	63	22
126955	42928	7	135	500 Florida St	3	Sidewalk: Curb side : Cutout	Tree	2		07/05/2000 12:00:00 AM			Permit Number 42831	6009210.68116468	2105903.38929548	37.7629293730529	-122.411293045793	(37.7629293730529, -122.411293045793)	8	4	7	28859	19
133325	43908	7	135	1090 Hampshire St	3	Sidewalk: Curb side : Cutout	Tree	2		08/10/2000 12:00:00 AM			Permit Number 43506	6010229.84125337	2102875.27259753	37.7546719517198	-122.407554599825	(37.7546719517198, -122.407554599825)	2	4	7	28859	19
137847	40320	7	135	3498x 26th St	3	Sidewalk: Curb side : Cutout	Tree	2	FUF	05/13/1999 12:00:00 AM			Permit Number 41461	6006512.30004445	2100871.01023057	37.7489599147889	-122.420268642175	(37.7489599147889, -122.420268642175)	2	4	7	28859	19
141302	42940	7	135	90 14TH ST	3	Sidewalk: Curb side : Cutout	Tree	2		07/05/2000 12:00:00 AM			Permit Number 42835	6008035	2107992	37.768598204142	-122.415507210488	(37.768598204142, -122.415507210488)	8	4	7	28853	19
161093	49852	7	135	600@ WOODSIDE Portola Dr	3	Sidewalk: Curb side : Cutout	Tree	2		06/18/2003 12:00:00 AM			Permit Number 46628	5997402.05166497	2099836.0241137	37.7456005399249	-122.451697110084	(37.7456005399249, -122.451697110084)	1	7	4	59	40
163641	108141	4	135	3390x 18TH ST	3	Sidewalk: Curb side : Cutout	Tree	2				3x3		6006957.7	2105612.4	37.7620037686995	-122.419064704614	(37.7620037686995, -122.419064704614)	8	4	7	28859	19
166213	110334	1	135	53x DEARBORN ST	3	Sidewalk: Curb side : Cutout	Tree	1				3x3		6005854	2105793	37.7624374394694	-122.422894814814	(37.7624374394694, -122.422894814814)	8	4	5	28859	19
174066	36680	7	135	99X ALBION ST	3	Sidewalk: Curb side : Cutout	Tree	2		05/22/1998 12:00:00 AM	16	3x3	Permit Number 39481	6005790	2106965	37.7656518628938	-122.42319948022	(37.7656518628938, -122.42319948022)	8	4	5	28853	19