Street_Tree_List

Data source: data.sfgov.org

262 rows where qSiteInfo = 4 and qSpecies = 15 sorted by PlotSize

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
27339	27339	178600	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	6	: 4	Tree 1	Private 1			6	Width 0ft		5989476.93903	2093627.59215	37.7280967254778	-122.478646687712	(37.7280967254778, -122.478646687712)
35225	35225	195038	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	400 02nd St	5	: 4	Tree 1	Private 1			10	Width 0ft		6014100.3392	2113471.11724	37.7839816811421	-122.394911334515	(37.7839816811421, -122.394911334515)
36451	36451	178598	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	4	: 4	Tree 1	Private 1			4	Width 0ft		5989486.74208	2093594.0787	37.728005275220795	-122.478610348783	(37.7280052752208, -122.478610348783)
45803	45803	178597	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	2	: 4	Tree 1	Private 1			11	Width 0ft		5989487.40549	2093535.0648700001	37.727843276732	-122.47860374149201	(37.727843276732, -122.478603741492)
157864	157864	178596	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	1	: 4	Tree 1	Private 1			10	Width 0ft		5989485.56542	2093493.23297	37.7277283101093	-122.47860704468799	(37.7277283101093, -122.478607044688)
188240	188240	178599	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	5	: 4	Tree 1	Private 1			9	Width 0ft		5989481.37307	2093611.3212099997	37.7280523070507	-122.47863016983999	(37.7280523070507, -122.47863016984)
65106	65106	195717	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	250 King St	1	: 4	Tree 1	Private 1			9	Width 10ft		6014883.72976	2111274.09447	37.7779926819557	-122.392047375082	(37.7779926819557, -122.392047375082)
54768	54768	249510	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	5	: 4	Tree 1	Private 1			7	Width 1ft		6006317.71181	2114977.4898599996	37.7876819902699	-122.421943465924	(37.7876819902699, -122.421943465924)
158835	158835	249509	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	4	: 4	Tree 1	Private 1			10	Width 1ft		6006315.507780001	2114994.81245	37.7877294295172	-122.421952322466	(37.7877294295172, -122.421952322466)
171879	171879	249508	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	3	: 4	Tree 1	Private 1			5	Width 1ft		6006312.75742	2115008.90991	37.7877679825424	-122.421962840029	(37.7877679825424, -122.421962840029)
172141	172141	195245	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1808 Newhall St	2	: 4	Tree 1	Private 1			3	Width 2ft		6013672.6153	2094756.94757	37.7325728473411	-122.395079867451	(37.7325728473411, -122.395079867451)
730	730	195047	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	360 06th St	2	: 4	Tree 1	DPW 2		03/26/2005 12:00:00 AM	3	Width 3ft	Permit Number 42039	6011214.59355	2111232.18316	37.777673209496605	-122.404737337955	(37.7776732094966, -122.404737337955)
748	748	195045	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	312 06th St	1	: 4	Tree 1	DPW 2			10	Width 3ft		6010980.17572	2111476.79231	37.7783317443601	-122.40556550564501	(37.7783317443601, -122.405565505645)
761	761	195041	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	402 06th St	1	: 4	Tree 1	DPW 2			28	Width 3ft		6011480.36813	2111044.01847	37.777171403968296	-122.40380468436199	(37.7771714039683, -122.403804684362)
1168	1168	218199	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	819 Ulloa St	1	: 4	Tree 1	DPW 2			13	Width 3ft		5993346.67502	2098141.32486	37.740714236277	-122.46559677389799	(37.740714236277, -122.465596773898)
24318	24318	195049	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	1	: 4	Tree 1	Private 1			8	Width 3ft		6011046.10585	2110191.14121	37.7748053308349	-122.405246869567	(37.7748053308349, -122.405246869567)
24505	24505	195054	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	820 Bryant St	1	: 4	Tree 1	Private 1			18	Width 3ft		6011686.5663	2110516.6477900003	37.775734882702295	-122.403054272047	(37.7757348827023, -122.403054272047)
26286	26286	247164	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	181 Buena Vista Ave East	1	: 4	Tree 1	Private 1			4	Width 3ft		6001468.5616	2108335.5699400003	37.76917028501371	-122.438244553041	(37.7691702850137, -122.438244553041)
26845	26845	195029	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	603 02nd St	1	: 4	Tree 1	Private 1			5	Width 3ft		6013830.29257	2113762.02506	37.7847654277311	-122.39586599541599	(37.7847654277311, -122.395865995416)
27627	27627	195043	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	377 06th St	1	: 4	Tree 1	Private 1			12	Width 3ft		6011353.00653	2111183.55828	37.777547432096206	-122.404255094506	(37.7775474320962, -122.404255094506)
28526	28526	218250	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	1	: 4	Tree 1	Private 1			14	Width 3ft		5992235.80201	2097238.62713	37.738171520993	-122.469372026199	(37.738171520993, -122.469372026199)
28563	28563	236251	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	3	: 4	Tree 1	Private 1			3	Width 3ft		6006130.65343	2109099.12846	37.77153089025921	-122.42217286498501	(37.7715308902592, -122.422172864985)
29027	29027	218251	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	2	: 4	Tree 1	Private 1			11	Width 3ft		5992250.04874	2097220.76826	37.738123308341706	-122.46932146901301	(37.7381233083417, -122.469321469013)
29514	29514	247770	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	827 Waller St	1	: 4	Tree 1	Private 1			10	Width 3ft		6001730.80568	2108705.46895	37.77020084782	-122.437363957589	(37.77020084782, -122.437363957589)
31067	31067	249497	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	2	: 4	Tree 1	Private 1			9	Width 3ft		6005893.50071	2115878.2456799997	37.7901313082605	-122.423475218205	(37.7901313082605, -122.423475218205)
31305	31305	247769	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	845 Waller St	3	: 4	Tree 1	Private 1			10	Width 3ft		6001717.5162	2108703.54506	37.7701948097837	-122.437409787932	(37.7701948097837, -122.437409787932)
32371	32371	201999	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Paul Ave	2	: 4	Tree 1	Private 1			4	Width 3ft		6012837.45496	2091269.25359	37.7229498748073	-122.397722694373	(37.7229498748073, -122.397722694373)
32756	32756	195051	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	3	: 4	Tree 1	Private 1			7	Width 3ft		6011026.68286	2110214.90007	37.7748694812702	-122.40531573155701	(37.7748694812702, -122.405315731557)
33230	33230	201628	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	401 Galvez Ave	12	: 4	Tree 1	Private 1			13	Width 3ft		6021496.8135400005	2093398.7623299998	37.729275520830996	-122.36793562924	(37.729275520831, -122.36793562924)
33901	33901	195058	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1118 Harrison St	1	: 4	Tree 1	Private 1			8	Width 3ft		6010609.31709	2110367.7626099996	37.7752658628632	-122.406770269844	(37.7752658628632, -122.406770269844)
33958	33958	247718	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Broderick St	2	: 4	Tree 1	Private 1			15	Width 3ft		6001406.2939	2108761.0042	37.7703348800695	-122.438490418696	(37.7703348800695, -122.438490418696)
34435	34435	247717	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Broderick St	1	: 4	Tree 1	Private 1			14	Width 3ft		6001409.94207	2108737.73214	37.770271188299	-122.43847613207399	(37.770271188299, -122.438476132074)
34606	34606	178520	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	74 Kelloch Ave	2	: 4	Tree 1	Private 1			10	Width 3ft		6008160.20585	2086291.9091900003	37.7090215544595	-122.413539180899	(37.7090215544595, -122.413539180899)
34947	34947	247768	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	845 Waller St	2	: 4	Tree 1	Private 1			10	Width 3ft		6001677.287330001	2108698.14738	37.7701777019594	-122.437548552425	(37.7701777019594, -122.437548552425)
35440	35440	195056	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	403 06th St	3	: 4	Tree 1	Private 1			37	Width 3ft		6011448.2097	2110981.26163	37.7769972916145	-122.403911513916	(37.7769972916145, -122.403911513916)
35767	35767	234556	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	389 Webster St	2	: 4	Tree 1	Private 1			12	Width 3ft		6004113.19649	2110015.3109999998	37.773932504618394	-122.42921669790199	(37.7739325046184, -122.429216697902)
36059	36059	218252	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	3	: 4	Tree 1	Private 1			8	Width 3ft		5992261.85147	2097209.38473	37.738092734087296	-122.469279833118	(37.7380927340873, -122.469279833118)
37327	37327	195182	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	469 Mississippi St	2	: 4	Tree 1	Private 1			12	Width 3ft		6014105.1082	2104950.4449299998	37.760586083411496	-122.39429806340901	(37.7605860834115, -122.394298063409)
41040	41040	133604	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	680 Hayes St	2	: 4	Tree 1	Private 1			12	Width 3ft		6004598.25031	2110892.9208299997	37.776369653876	-122.42760135363599	(37.776369653876, -122.427601353636)
42914	42914	195153	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	747 Rhode Island St	1	: 4	Tree 1	Private 1			16	Width 3ft		6011866.39234	2104881.06105	37.7602708746342	-122.402035931016	(37.7602708746342, -122.402035931016)
44065	44065	195063	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1440 Harrison St	25	: 4	Tree 1	Private 1			12	Width 3ft		6009088.88483	2108916.86222	37.7711968415799	-122.41192726035901	(37.7711968415799, -122.411927260359)
44707	44707	178595	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3353 19th Ave	7	: 4	Tree 1	Private 1			4	Width 3ft		5990558.26669	2094238.61672	37.729837169035896	-122.474953123505	(37.7298371690359, -122.474953123505)
45448	45448	195069	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1532 Bryant St	1	: 4	Tree 1	Private 1			13	Width 3ft		6008781.51623	2108669.00103	37.7704990234538	-122.412972936267	(37.7704990234538, -122.412972936267)
45940	45940	249496	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	1	: 4	Tree 1	Private 1			11	Width 3ft		6005857.5459	2115873.8651400004	37.7901172509642	-122.423599307579	(37.7901172509642, -122.423599307579)
47110	47110	249491	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1899 California St	1	: 4	Tree 1	Private 1			9	Width 3ft		6005331.84329	2115802.8856200003	37.7898926713456	-122.42541314481899	(37.7898926713456, -122.425413144819)
48949	48949	195178	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1512 19th St	2	: 4	Tree 1	Private 1			9	Width 3ft		6013083.6982	2105226.1685599997	37.761286330631705	-122.39785002128201	(37.7612863306317, -122.397850021282)
50863	50863	201629	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	401 Galvez Ave	13	: 4	Tree 1	Private 1			6	Width 3ft		6021522.6239599995	2093379.49172	37.7292240220626	-122.36784506930599	(37.7292240220626, -122.367845069306)
51866	51866	195042	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	402 06th St	2	: 4	Tree 1	Private 1			26	Width 3ft		6011470.44747	2111056.37562	37.7772047796221	-122.403839873012	(37.7772047796221, -122.403839873012)
53264	53264	195162	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	795 Wisconsin St	1	: 4	Tree 1	Private 1			11	Width 3ft		6012759.21465	2103840.23662	37.757462790085505	-122.398875007375	(37.7574627900855, -122.398875007375)
53391	53391	247744	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	883 Waller St	2	: 4	Tree 1	Private 1			10	Width 3ft		6001433.04575	2108666.05227	37.7700756873626	-122.43839108048701	(37.7700756873626, -122.438391080487)
53811	53811	236253	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	5	: 4	Tree 1	Private 1			11	Width 3ft		6006170.16969	2109101.8157599997	37.771540497736	-122.42203636681002	(37.771540497736, -122.42203636681)
54031	54031	195048	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	972 Harrison St	1	: 4	Tree 1	Private 1			6	Width 3ft		6011557.47777	2111276.51423	37.7778140909953	-122.403554297789	(37.7778140909953, -122.403554297789)
54039	54039	217737	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	715 Frederick St	2	: 4	Tree 1	Private 1			6	Width 3ft		5996153.98558	2107236.09361	37.7658477046389	-122.45654774598499	(37.7658477046389, -122.456547745985)
54355	54355	195037	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	712 Harrison St	8	: 4	Tree 1	Private 1			7	Width 3ft		6013186.23723	2112830.2440400003	37.782171121043795	-122.398028840679	(37.7821711210438, -122.398028840679)
54412	54412	195169	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	8	: 4	Tree 1	Private 1			13	Width 3ft		6012684.972080001	2104240.58685	37.7585579269363	-122.39915987123699	(37.7585579269363, -122.399159871237)
55191	55191	133603	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	662 Hayes St	2	: 4	Tree 1	Private 1			11	Width 3ft		6004673.73333	2110903.67068	37.776403439601395	-122.427341002593	(37.7764034396014, -122.427341002593)
56289	56289	195170	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	859 Wisconsin St	1	: 4	Tree 1	Private 1			10	Width 3ft		6012783.82646	2103478.80555	37.756471750696	-122.39876452475599	(37.756471750696, -122.398764524756)
58618	58618	247713	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	880 Waller St	1	: 4	Tree 1	Private 1			13	Width 3ft		6001495.04463	2108722.80835	37.7702350517434	-122.438180694009	(37.7702350517434, -122.438180694009)
59189	59189	195165	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	2	: 4	Tree 1	Private 1			18	Width 3ft		6012683.25425	2104289.74415	37.758692806358	-122.39916926286301	(37.758692806358, -122.399169262863)
60565	60565	195067	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Bryant St	3	: 4	Tree 1	Private 1			8	Width 3ft		6008874.83792	2108609.10047	37.7703397885684	-122.412645899583	(37.7703397885684, -122.412645899583)
62440	62440	178519	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	74 Kelloch Ave	1	: 4	Tree 1	Private 1			11	Width 3ft		6008207.90106	2086273.84024	37.7089746188665	-122.413373061735	(37.7089746188665, -122.413373061735)
62547	62547	195059	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1118 Harrison St	2	: 4	Tree 1	Private 1			8	Width 3ft		6010590.86916	2110351.5216200002	37.775220236657795	-122.406832940881	(37.7752202366578, -122.406832940881)
62830	62830	218177	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 15th Ave	1	: 4	Tree 1	Private 1			12	Width 3ft		5991929.371230001	2096655.3503299998	37.736552277270704	-122.470389035343	(37.7365522772707, -122.470389035343)
63754	63754	250007	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1 Starr King Way	2	: 4	Tree 1	Private 1			18	Width 3ft		6005970.87651	2113821.19628	37.784487527310795	-122.423061232398	(37.7844875273108, -122.423061232398)
63784	63784	247727	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	4	: 4	Tree 1	Private 1			2	Width 3ft		6001335.32176	2108938.35648	37.7708178079159	-122.43874862124599	(37.7708178079159, -122.438748621246)
64356	64356	195168	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	7	: 4	Tree 1	Private 1			17	Width 3ft		6012685.0522300005	2104255.6823299997	37.75859938027771	-122.39916065365101	(37.7585993802777, -122.399160653651)
64582	64582	195166	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	4	: 4	Tree 1	Private 1			12	Width 3ft		6012684.0082	2104282.2929599998	37.7586723890431	-122.39916613231199	(37.7586723890431, -122.399166132312)
64654	64654	247746	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	863 Waller St	2	: 4	Tree 1	Private 1			9	Width 3ft		6001497.53746	2108674.50696	37.770102569905795	-122.438168610708	(37.7701025699058, -122.438168610708)
64889	64889	247705	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	840 Waller St	1	: 4	Tree 1	Private 1			9	Width 3ft		6001690.64563	2108751.62405	37.7703252951036	-122.43750617637698	(37.7703252951036, -122.437506176377)
65287	65287	236252	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	4	: 4	Tree 1	Private 1			7	Width 3ft		6006150.96027	2109100.8645099998	37.7715368024021	-122.422102745763	(37.7715368024021, -122.422102745763)
65428	65428	212741	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	142 Vernon St	1	: 4	Tree 1	Private 1			13	Width 3ft		5992469.93504	2088840.59445	37.7151261228375	-122.467951845594	(37.7151261228375, -122.467951845594)
66605	66605	236249	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	1	: 4	Tree 1	Private 1			9	Width 3ft		6006094.40654	2109097.7198900003	37.7715249781286	-122.422298145049	(37.7715249781286, -122.422298145049)
66973	66973	195161	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1013 Rhode Island St	1	: 4	Tree 1	Private 1			17	Width 3ft		6011938.22182	2103514.77234	37.756523356495	-122.401691470003	(37.756523356495, -122.401691470003)
66996	66996	247773	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	801 Waller St	3	: 4	Tree 1	Private 1			8	Width 3ft		6001804.9938	2108715.66096	37.7702330498442	-122.437108071705	(37.7702330498442, -122.437108071705)
68395	68395	247721	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	20 Broderick St	2	: 4	Tree 1	Private 1			17	Width 3ft		6001398.10609	2108828.29534	37.770519179046296	-122.438523562338	(37.7705191790463, -122.438523562338)
69050	69050	195046	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	360 06th St	1	: 4	Tree 1	Private 1			7	Width 3ft		6011210.30238	2111237.08029	37.7776864160348	-122.404752527502	(37.7776864160348, -122.404752527502)
70963	70963	247711	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	860 Waller St	2	: 4	Tree 1	Private 1			13	Width 3ft		6001555.46179	2108730.67252	37.770260080759	-122.43797227519501	(37.770260080759, -122.437972275195)
71880	71880	247716	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	894 Waller St	2	: 4	Tree 1	Private 1			14	Width 3ft		6001434.3903	2108713.70034	37.7702065935938	-122.43838984392299	(37.7702065935938, -122.438389843923)
72189	72189	178591	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	67 Belle Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5991713.92465	2086485.44715	37.70861577046671	-122.470393502266	(37.7086157704667, -122.470393502266)
74222	74222	234548	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	474 Valencia St	3	: 4	Tree 1	Private 1			12	Width 3ft		6006115.99825	2106946.0186	37.765618136498205	-122.42207057339701	(37.7656181364982, -122.422070573397)
74778	74778	236254	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	75 McCoppin St	1	: 4	Tree 1	Private 1			13	Width 3ft		6006221.85499	2109104.7913	37.7715515827698	-122.421857795627	(37.7715515827698, -122.421857795627)
75724	75724	195057	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	109 Harrison St	1	: 4	Tree 1	Private 1			7	Width 3ft		6010680.65818	2110429.45219	37.77543923956021	-122.40652783149599	(37.7754392395602, -122.406527831496)
75899	75899	247714	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	888 Waller St	1	: 4	Tree 1	Private 1			7	Width 3ft		6001473.17505	2108719.8065400003	37.7702255656925	-122.43825612552799	(37.7702255656925, -122.438256125528)
76686	76686	247715	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	894 Waller St	1	: 4	Tree 1	Private 1			11	Width 3ft		6001455.5652	2108715.07131	37.7702115623373	-122.43831669847602	(37.7702115623373, -122.438316698476)
76961	76961	195044	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	363 06th St	4	: 4	Tree 1	Private 1			12	Width 3ft		6011215.55292	2111326.94957	37.7779334696865	-122.40474069243	(37.7779334696865, -122.40474069243)
104434	104434	247730	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	33 Broderick St	1	: 4	Tree 1	Private 1			33	Width 3ft		6001346.63748	2108846.86532	37.7705672397281	-122.438702923116	(37.7705672397281, -122.438702923116)
131284	131284	247165	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	181 Buena Vista Ave East	2	: 4	Tree 1	Private 1			5	Width 3ft		6001459.73052	2108348.46373	37.769205185885895	-122.43827602303101	(37.7692051858859, -122.438276023031)
132142	132142	247722	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	26 Broderick St	1	: 4	Tree 1	Private 1			26	Width 3ft		6001394.7832	2108843.3347	37.7705602843666	-122.438536133944	(37.7705602843666, -122.438536133944)
133140	133140	195177	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	394 19th St	1	: 4	Tree 1	Private 1			6	Width 3ft		6013172.75141	2105230.87083	37.761304201040794	-122.397542351521	(37.7613042010408, -122.397542351521)
134060	134060	195179	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1566 19th St	2	: 4	Tree 1	Private 1			3	Width 3ft		6013002.55406	2105221.11715	37.7612679412857	-122.39813031208901	(37.7612679412857, -122.398130312089)
134240	134240	195154	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	747 Rhode Island St	2	: 4	Tree 1	Private 1			13	Width 3ft		6011864.87444	2104893.13154	37.7603039328007	-122.40204202933	(37.7603039328007, -122.40204202933)
134697	134697	249498	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	4	: 4	Tree 1	Private 1			3	Width 3ft		6005924.13385	2115883.6534	37.7901478854587	-122.423369614421	(37.7901478854587, -122.423369614421)
135377	135377	218253	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	4	: 4	Tree 1	Private 1			16	Width 3ft		5992274.63868	2097193.69767	37.73805040029939	-122.46923448031299	(37.7380504002994, -122.469234480313)
135422	135422	195053	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	6	: 4	Tree 1	Private 1			14	Width 3ft		6010980.8168	2110266.80821	37.7750094445775	-122.405478049267	(37.7750094445775, -122.405478049267)
135608	135608	247203	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	891 Waller St	2	: 4	Tree 1	Private 1			17	Width 3ft		6001399.19985	2108663.63795	37.770067133033706	-122.438507979757	(37.7700671330337, -122.438507979757)
136314	136314	247247	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1100 Waller St	2	: 4	Tree 1	Private 1			9	Width 3ft		6000095.42244	2108529.4322900004	37.769624388675204	-122.443008074871	(37.7696243886752, -122.443008074871)
137336	137336	249502	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	6	: 4	Tree 1	Private 1			11	Width 3ft		6005987.727630001	2115889.97486	37.7901688315689	-122.423150034159	(37.7901688315689, -122.423150034159)
137441	137441	247723	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	36 Broderick St	1	: 4	Tree 1	Private 1			27	Width 3ft		6001391.64061	2108867.0895599998	37.7706253305347	-122.438548706468	(37.7706253305347, -122.438548706468)
137765	137765	178592	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	67 Belle Ave	2	: 4	Tree 1	Private 1			9	Width 3ft		5991724.32675	2086485.2281099998	37.7086157704725	-122.470357535671	(37.7086157704725, -122.470357535671)
137878	137878	236250	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	2	: 4	Tree 1	Private 1			9	Width 3ft		6006111.46032	2109098.98428	37.771529411789395	-122.422239244855	(37.7715294117894, -122.422239244855)

Next page

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");