Street_Tree_List

Data source: data.sfgov.org

213 rows where qCaretaker = 1 and 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

- 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, 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
118325	118325	109374	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	1	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
120047	120047	195988	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018362.603680001	2099564.59582	37.7460333862374	-122.379199073078	(37.7460333862374, -122.379199073078)
127758	127758	109376	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	3	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
129839	129839	248123	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	3	Front Yard : Yard 7	Tree 1	Private 1			13			6010392.06783	2099413.0786599996	37.7451746083214	-122.40674959081899	(37.7451746083214, -122.406749590819)
130066	130066	195985	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018474.359130001	2099556.32192	37.74601682971289	-122.378812058831	(37.7460168297129, -122.378812058831)
130871	130871	195987	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6018466.53487	2099573.76457	37.7460642923433	-122.378840325441	(37.7460642923433, -122.378840325441)
130896	130896	248113	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	3	Side Yard : Yard 17	Tree 1	Private 1			17			6010385.30327	2099441.28079	37.745251666737296	-122.40677496881099	(37.7452516667373, -122.406774968811)
132662	132662	201996	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013312.67339	2092499.74696	37.7263550129554	-122.396166145968	(37.7263550129554, -122.396166145968)
133456	133456	234878	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6010615.53478	2100839.3237900003	37.749103267009204	-122.406077336824	(37.7491032670092, -122.406077336824)
135800	135800	196016	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015678.42156	2110690.23877	37.77643363342779	-122.389257449686	(37.7764336334278, -122.389257449686)
137250	137250	201997	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013313.68951	2092516.98736	37.7264024081338	-122.39616384100201	(37.7264024081338, -122.396163841002)
137504	137504	196017	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015653.37625	2110690.3321	37.776432501193	-122.389344095768	(37.776432501193, -122.389344095768)
137968	137968	195965	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	11	Back Yard : Yard 13	Tree 1	Private 1			8			6015497.16873	2100330.63483	37.747978343742794	-122.389160933554	(37.7479783437428, -122.389160933554)
139286	139286	96978	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
141279	141279	96981	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
146490	146490	234888	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	2	Front Yard : Yard 7	Tree 1	Private 1			33			6010611.762999999	2100694.95228	37.7487066435094	-122.40608021012699	(37.7487066435094, -122.406080210127)
146994	146994	234890	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	4	Front Yard : Yard 7	Tree 1	Private 1			14			6010623.85334	2100666.44158	37.7486290355994	-122.40603639336099	(37.7486290355994, -122.406036393361)
147141	147141	234872	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2800 Cesar Chavez St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31			6010732.42318	2100864.09022	37.7491778073048	-122.405674877619	(37.7491778073048, -122.405674877619)
148699	148699	248117	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	7	Side Yard : Yard 17	Tree 1	Private 1			6			6010378.29952	2099414.5285	37.7451778188963	-122.40679730165701	(37.7451778188963, -122.406797301657)
149012	149012	196010	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6015807.5178	2110696.90854	37.7764591031505	-122.38881133109	(37.7764591031505, -122.38881133109)
149276	149276	195992	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018320.61791	2099573.80473	37.7460563567193	-122.379344895446	(37.7460563567193, -122.379344895446)
149461	149461	234894	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2827 Cesar Chavez St	12	Front Yard : Yard 7	Tree 1	Private 1			27			6010729.67514	2100698.35511	37.7487225812957	-122.405672708429	(37.7487225812957, -122.405672708429)
154282	154282	248120	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Brewster St	10	Side Yard : Yard 17	Tree 1	Private 1			12			6010373.21137	2099395.33781	37.745124840742	-122.40681354343701	(37.745124840742, -122.406813543437)
157844	157844	201995	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013319.20907	2092521.7003099998	37.726415656052104	-122.396145090149	(37.7264156560521, -122.396145090149)
158786	158786	195955	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	1	Back Yard : Yard 13	Tree 1	Private 1			10			6015700.85592	2100342.37267	37.7480218628289	-122.38845740468399	(37.7480218628289, -122.388457404684)
161996	161996	196004	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015940.35109	2110704.12187	37.776486270757204	-122.388352322497	(37.7764862707572, -122.388352322497)
164241	164241	201993	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013314.351009999	2092488.44605	37.726324076294205	-122.396159554816	(37.7263240762942, -122.396159554816)
165153	165153	195980	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	900 Phelps St	2	Side Yard : Yard 17	Tree 1	Private 1			24			6014694.29284	2097256.8818599996	37.7394939174204	-122.39172238440399	(37.7394939174204, -122.391722384404)
166489	166489	195999	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6016051.5903	2110711.60548	37.7765129824099	-122.387968033214	(37.7765129824099, -122.387968033214)

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