Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 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

- 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, qSiteInfo, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
24124	24124	234881	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29			6010567.07854	2100828.40228	37.749070568567	-122.40624413046899	(37.749070568567, -122.406244130469)
24297	24297	248119	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	9	Side Yard : Yard 17	Tree 1	Private 1			18			6010375.35501	2099399.67941	37.7451368817742	-122.40680643699301	(37.7451368817742, -122.406806436993)
25030	25030	196022	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21			6015549.75144	2110684.1794	37.7764098616684	-122.389702136539	(37.7764098616684, -122.389702136539)
25205	25205	195981	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6018524.13374	2099557.3325900002	37.746022348857295	-122.37864001312799	(37.7460223488573, -122.378640013128)
25404	25404	119731	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
26205	26205	195969	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	15	Back Yard : Yard 13	Tree 1	Private 1			8			6015417.97335	2100326.09336	37.7479614832509	-122.389434473133	(37.7479614832509, -122.389434473133)
26910	26910	195984	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018485.16554	2099556.70792	37.7460184853642	-122.378774718093	(37.7460184853642, -122.378774718093)
28429	28429	234882	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6010551.469930001	2100825.34606	37.7490613037485	-122.406297890147	(37.7490613037485, -122.406297890147)
28993	28993	196012	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015764.416780001	2110694.68671	37.7764506135265	-122.388960275907	(37.7764506135265, -122.388960275907)
29206	29206	195983	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6018491.3513	2099573.26629	37.7460642923356	-122.378754477939	(37.7460642923356, -122.378754477939)
30434	30434	248121	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	1	Front Yard : Yard 7	Tree 1	Private 1			11			6010387.395819999	2099398.52057	37.7451343735684	-122.40676472010901	(37.7451343735684, -122.406764720109)
30532	30532	119696	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
31601	31601	195958	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	4	Back Yard : Yard 13	Tree 1	Private 1			10			6015649.240619999	2100340.8983400003	37.7480149542299	-122.388635787013	(37.7480149542299, -122.388635787013)
31815	31815	196007	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015874.48096	2110701.94702	37.7764766489106	-122.388580036236	(37.7764766489106, -122.388580036236)
32073	32073	234877	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38			6010643.54009	2100844.31084	37.7491185267072	-122.405980844948	(37.7491185267072, -122.405980844948)
32347	32347	248125	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	5	Front Yard : Yard 7	Tree 1	Private 1			7			6010397.048769999	2099427.00914	37.745213137076796	-122.406733349058	(37.7452131370768, -122.406733349058)
33201	33201	195967	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	13	Back Yard : Yard 13	Tree 1	Private 1			5			6015456.783980001	2100328.64296	37.747970635647	-122.389300444473	(37.747970635647, -122.389300444473)
33236	33236	195970	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	16	Back Yard : Yard 13	Tree 1	Private 1			8			6015399.1088	2100325.42161	37.747958592828205	-122.389499659601	(37.7479585928282, -122.389499659601)
33398	33398	196014	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6015720.48392	2110692.27541	37.7764415573597	-122.389112085054	(37.7764415573597, -122.389112085054)
35883	35883	248126	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	6	Front Yard : Yard 7	Tree 1	Private 1			6			6010387.789530001	2099433.6295	37.7452307970734	-122.40676583257401	(37.7452307970734, -122.406765832574)
36690	36690	248115	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	5	Side Yard : Yard 17	Tree 1	Private 1			7			6010382.6698900005	2099427.30215	37.7452131370921	-122.406783089664	(37.7452131370921, -122.406783089664)
38334	38334	195966	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	12	Back Yard : Yard 13	Tree 1	Private 1			6			6015475.98989	2100328.78152	37.7479720808553	-122.389234040342	(37.7479720808553, -122.389234040342)
38396	38396	195968	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	14	Back Yard : Yard 13	Tree 1	Private 1			7			6015437.03514	2100327.8138099997	37.747967264084295	-122.389368677829	(37.7479672640843, -122.389368677829)
38753	38753	234884	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20			6010535.25533	2100821.90556	37.749050949857796	-122.406353718268	(37.7490509498578, -122.406353718268)
38800	38800	248116	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	6	Side Yard : Yard 17	Tree 1	Private 1			9			6010379.57479	2099419.47211	37.745191464327995	-122.406793240314	(37.745191464328, -122.406793240314)
41087	41087	196003	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015962.95079	2110705.93329	37.776492496775106	-122.388274269443	(37.7764924967751, -122.388274269443)
41709	41709	234885	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			6010529.65259	2100820.82881	37.7490476799194	-122.406373016826	(37.7490476799194, -122.406373016826)
41744	41744	248172	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	218 Esmeralda Ave	1	Side Yard : Yard 17	Tree 1	Private 1			12			6007302.01446	2098729.32454	37.74312379432521	-122.41738604353701	(37.7431237943252, -122.417386043537)
45266	45266	196009	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015830.73834	2110698.70731	37.776465329147	-122.388731129538	(37.776465329147, -122.388731129538)
46092	46092	195960	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	6	Back Yard : Yard 13	Tree 1	Private 1			8			6015597.7328	2100337.72732	37.748003392560896	-122.38881367921302	(37.7480033925609, -122.388813679213)
46532	46532	196000	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6016029.9014099995	2110710.35403	37.776508344609496	-122.38804297461999	(37.7765083446095, -122.38804297462)
46578	46578	234892	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	6	Front Yard : Yard 7	Tree 1	Private 1			18			6010653.55518	2100656.49907	37.7486033968442	-122.40593298392	(37.7486033968442, -122.40593298392)
46620	46620	248114	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	4	Side Yard : Yard 17	Tree 1	Private 1			15			6010381.0463	2099434.05906	37.7452315992509	-122.406789179902	(37.7452315992509, -122.406789179902)
46984	46984	195986	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018468.61509	2099561.7634900003	37.7460314544851	-122.378832298987	(37.7460314544851, -122.378832298987)
47853	47853	196002	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6015985.51722	2110706.0962799997	37.7764941946745	-122.38819621639799	(37.7764941946745, -122.388196216398)
50221	50221	234891	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	5	Front Yard : Yard 7	Tree 1	Private 1			12			6010619.31212	2100642.55964	37.748563207025704	-122.406050414705	(37.7485632070257, -122.406050414705)
51068	51068	201994	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013316.6056	2092506.69666	37.7263743142142	-122.396153039251	(37.7263743142142, -122.396153039251)
51090	51090	248124	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	4	Front Yard : Yard 7	Tree 1	Private 1			10			6010394.26479	2099420.04988	37.7451938726969	-122.406742485274	(37.7451938726969, -122.406742485274)
51312	51312	96980	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
51715	51715	234880	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24			6010577.49101	2100830.77043	37.7490776534227	-122.40620829069799	(37.7490776534227, -122.406208290698)
52696	52696	234902	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			6009698.6344099995	2096418.94153	37.7369145349811	-122.40893616107799	(37.7369145349811, -122.408936161078)
52998	52998	195998	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6016075.490669999	2110714.30849	37.776521728336604	-122.387885542896	(37.7765217283366, -122.387885542896)
54920	54920	248118	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	8	Side Yard : Yard 17	Tree 1	Private 1			6			6010376.970919999	2099406.95495	37.7451569492381	-122.40680136209	(37.7451569492381, -122.40680136209)
55335	55335	234886	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28			6010522.647340001	2100819.38367	37.7490433200014	-122.40639713934401	(37.7490433200014, -122.406397139344)
56013	56013	248173	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	218 Esmeralda Ave	2	Side Yard : Yard 17	Tree 1	Private 1			6			6007303.951309999	2098726.55555	37.743116300271	-122.41737915022101	(37.743116300271, -122.417379150221)
59758	59758	234871	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6010740.989580001	2100867.24575	37.7491869507297	-122.405645476962	(37.7491869507297, -122.405645476962)
60534	60534	196005	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015919.22066	2110703.31156	37.7764828749315	-122.38842536276	(37.7764828749315, -122.38842536276)
60765	60765	195957	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	3	Back Yard : Yard 13	Tree 1	Private 1			12			6015667.37966	2100340.53223	37.7480149542209	-122.38857303683399	(37.7480149542209, -122.388573036834)
61692	61692	119780	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	15	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
61850	61850	195989	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018358.23149	2099573.02507	37.7460562901585	-122.37921477706699	(37.7460562901585, -122.379214777067)
62177	62177	195962	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	8	Back Yard : Yard 13	Tree 1	Private 1			9			6015556.6084199995	2100333.99599	37.7479908676843	-122.388955626422	(37.7479908676843, -122.388955626422)
63128	63128	196020	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6015589.15281	2110687.71234	37.7764217471115	-122.38956608171999	(37.7764217471115, -122.38956608172)
65985	65985	195964	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	10	Back Yard : Yard 13	Tree 1	Private 1			8			6015516.57214	2100331.8217700003	37.7479826784534	-122.38909391965001	(37.7479826784534, -122.38909391965)
68610	68610	234900	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6009696.65795	2096435.2295400002	37.7369591476365	-122.40894414348	(37.7369591476365, -122.40894414348)
69678	69678	195997	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6016094.12732	2110713.51522	37.776520582607	-122.387821017432	(37.776520582607, -122.387821017432)
69871	69871	195990	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6018348.89198	2099575.3229	37.746062084515295	-122.379247231793	(37.7460620845153, -122.379247231793)
69986	69986	196013	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6015743.28218	2110693.6702799997	37.7764466511333	-122.38903331613899	(37.7764466511333, -122.389033316139)
70123	70123	248111	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	1	Side Yard : Yard 17	Tree 1	Private 1			24			6010383.711069999	2099443.8594400003	37.7452586580609	-122.406780656096	(37.7452586580609, -122.406780656096)
71617	71617	196015	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6015698.09519	2110690.66596	37.77643589704721	-122.38918942227899	(37.7764358970472, -122.389189422279)
72921	72921	234889	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	3	Front Yard : Yard 7	Tree 1	Private 1			25			6010620.28496	2100677.87035	37.7486602169168	-122.406049537871	(37.7486602169168, -122.406049537871)
73079	73079	196019	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6015611.09455	2110687.68162	37.776422879345496	-122.389490176245	(37.7764228793455, -122.389490176245)
73733	73733	234901	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6009690.97834	2096436.6273599998	37.7369626675976	-122.408963879105	(37.7369626675976, -122.408963879105)
74084	74084	195956	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	2	Back Yard : Yard 13	Tree 1	Private 1			9			6015682.424790001	2100340.57249	37.748015898531605	-122.388521013727	(37.7480158985316, -122.388521013727)
74090	74090	195963	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	9	Back Yard : Yard 13	Tree 1	Private 1			8			6015537.22246	2100333.68578	37.7479889413373	-122.389022641203	(37.7479889413373, -122.389022641203)
77831	77831	117475	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1200x MONTGOMERY ST	2	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011580.0	2119440.0	37.800230345698	-122.404051036068	(37.800230345698, -122.404051036068)
78277	78277	98312	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	160 Stanford Heights Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5998064.7	2096544.4	37.7366004632858	-122.449168689734	(37.7366004632858, -122.449168689734)
79566	79566	119689	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
80683	80683	119723	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
81560	81560	117474	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1200x MONTGOMERY ST	1	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011580.0	2119440.0	37.800230345698	-122.404051036068	(37.800230345698, -122.404051036068)
83899	83899	119728	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
84867	84867	119767	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
85011	85011	119690	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86483	86483	119684	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86543	86543	119734	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86843	86843	109377	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	4	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
87484	87484	96979	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
87621	87621	119685	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
87630	87630	119692	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
88222	88222	119683	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
89139	89139	119727	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
90805	90805	119770	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
92703	92703	119766	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
92884	92884	119733	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
96316	96316	119697	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	15	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
96460	96460	109375	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	2	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
97979	97979	119772	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
99317	99317	119769	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
100173	100173	119722	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
100653	100653	119693	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
101181	101181	117473	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1201x MONTGOMERY ST	1	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011733.0	2119731.0	37.8010379082809	-122.403542078239	(37.8010379082809, -122.403542078239)
101391	101391	119774	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
101847	101847	117472	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1201x MONTGOMERY ST	2	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011733.0	2119731.0	37.8010379082809	-122.403542078239	(37.8010379082809, -122.403542078239)
103536	103536	119694	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
103992	103992	119729	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
105008	105008	119726	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
106073	106073	96984	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
106450	106450	119771	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
112237	112237	109378	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	5	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
115597	115597	119725	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
117272	117272	119768	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)

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