Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by qSiteInfo descending

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
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)
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)
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)
909	909	234895	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	3255x 24th St	6	Side Yard : Cutout 18	Tree 1	Private 1			40	Width 10ft		6007298.0	2102020.0	37.7521590216883	-122.417633107694	(37.7521590216883, -122.417633107694)
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)
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)
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)
39702	39702	195996	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	5	Side Yard : Yard 17	Tree 1	Private 1			14	Width 3ft		6012499.275719999	2097703.95349	37.7405993901482	-122.39934322143101	(37.7405993901482, -122.399343221431)
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)
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)
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)
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)
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)
127197	127197	249899	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1497 Montgomery St	3	Side Yard : Yard 17	Tree 1	Private 1			17	Width 0ft		6011381.09793	2120471.14228	37.8030504957345	-122.404811954701	(37.8030504957345, -122.404811954701)
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)
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)
154008	154008	195993	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	2	Side Yard : Yard 17	Tree 1	Private 1			23	Width 3ft		6012429.27896	2097757.0265	37.7407412159349	-122.399588970171	(37.7407412159349, -122.399588970171)
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)
156951	156951	195995	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	4	Side Yard : Yard 17	Tree 1	Private 1			23	Width 3ft		6012483.54441	2097715.89022	37.7406312890986	-122.399398452383	(37.7406312890986, -122.399398452383)
162455	162455	195979	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	900 Phelps St	1	Side Yard : Yard 17	Tree 1	Private 1			30	Width 9ft		6014704.25324	2097268.53042	37.739526454869704	-122.39168875963999	(37.7395264548697, -122.39168875964)
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)
171284	171284	249897	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1497 Montgomery St	5	Side Yard : Yard 17	Tree 1	Private 1			20	Width 0ft		6011384.61876	2120458.08201	37.8030148322229	-122.40479885070101	(37.8030148322229, -122.404798850701)
183132	183132	195994	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	3	Side Yard : Yard 17	Tree 1	Private 1			20	Width 3ft		6012438.11131	2097750.05558	37.74072256758821	-122.39955794174999	(37.7407225675882, -122.39955794175)
23421	23421	195972	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	18	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015355.8319	2100319.8042599997	37.7479407691514	-122.389648918288	(37.7479407691514, -122.389648918288)
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)
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)
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)
33977	33977	249894	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	30	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011403.76038	2120447.63681	37.802987222140395	-122.40473187458599	(37.8029872221404, -122.404731874586)
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)
42525	42525	195977	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	23	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015256.877230001	2100313.90806	37.7479190918917	-122.389990690329	(37.7479190918917, -122.389990690329)
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)
49446	49446	195978	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	24	Back Yard : Yard 13	Tree 1	Private 1			9	Width 4ft		6015236.23042	2100312.22008	37.747913311958605	-122.390061968785	(37.7479133119586, -122.390061968785)
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)
61234	61234	195975	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	21	Back Yard : Yard 13	Tree 1	Private 1			9	Width 4ft		6015294.9834	2100316.47199	37.747928245201	-122.389859098828	(37.747928245201, -122.389859098828)
61728	61728	249895	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	31	Back Yard : Yard 13	Tree 1	Private 1			18	Width 0ft		6011395.76102	2120447.38073	37.8029860719045	-122.404759538639	(37.8029860719045, -122.404759538639)
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)
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)
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)
74522	74522	249896	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	32	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011386.30387	2120437.51769	37.8029584618196	-122.404791570676	(37.8029584618196, -122.404791570676)
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)
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)
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)
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)
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)
147625	147625	195976	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	22	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015275.57642	2100315.1093900003	37.7479234275315	-122.38992611271401	(37.7479234275315, -122.389926112714)
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)
171288	171288	195971	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	17	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015377.86647	2100320.4119700002	37.7479436595871	-122.389572765484	(37.7479436595871, -122.389572765484)
171805	171805	195974	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	20	Back Yard : Yard 13	Tree 1	Private 1			12	Width 4ft		6015315.44713	2100317.81293	37.7479330619596	-122.389788429193	(37.7479330619596, -122.389788429193)
173877	173877	195973	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	19	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015335.01264	2100318.2949099997	37.747935470342895	-122.38972080559601	(37.7479354703429, -122.389720805596)
175233	175233	195961	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	7	Back Yard : Yard 13	Tree 1	Private 1			10			6015577.60391	2100335.50195	37.7479961664858	-122.388883129368	(37.7479961664858, -122.388883129368)
179584	179584	195959	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	5	Back Yard : Yard 13	Tree 1	Private 1			10			6015616.60441	2100338.74984	37.7480072461368	-122.388748492749	(37.7480072461368, -122.388748492749)
185525	185525	249893	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	29	Back Yard : Yard 13	Tree 1	Private 1			13	Width 0ft		6011394.800530001	2120441.53452	37.8029699659579	-122.404762450627	(37.8029699659579, -122.404762450627)
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)
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)
37654	37654	244429	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005659.2973	2109696.7034	37.773145089481794	-122.4238458121	(37.7731450894818, -122.4238458121)
46046	46046	244430	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005657.927	2109705.6102	37.7731694680478	-122.42385118560499	(37.7731694680478, -122.423851185605)
46340	46340	244263	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005610.4338	2110073.0988	37.7741758216851	-122.424041609468	(37.7741758216851, -122.424041609468)
47891	47891	244336	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6005628.4661	2109884.4314	37.7736588046762	-122.423965813403	(37.7736588046762, -122.423965813403)
53575	53575	244407	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005584.4651	2110232.73	37.774612664125	-122.424142794808	(37.774612664125, -122.424142794808)
59788	59788	244335	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6005630.5215	2109874.8395	37.7736325836766	-122.42395802123	(37.7736325836766, -122.42395802123)
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)
64205	64205	244403	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005596.6857	2110150.2412	37.7743868598384	-122.424094653801	(37.7743868598384, -122.424094653801)
65982	65982	244266	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005600.5046	2110125.0362	37.7743178686238	-122.42407965066499	(37.7743178686238, -122.424079650665)
66890	66890	244431	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005656.5567	2109717.2576	37.77320137163979	-122.42385675402599	(37.7732013716398, -122.423856754026)
73006	73006	244339	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	16	Median : Cutout 11	Tree 1	DPW 2			14	Width 0ft		6005625.7255	2109918.6883	37.7737527111209	-122.42397773010799	(37.7737527111209, -122.423977730108)
76412	76412	244404	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005594.3943	2110164.7531	37.7744265766299	-122.424103612435	(37.7744265766299, -122.424103612435)
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)
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)
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)
90928	90928	244261	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005613.489	2110034.9096	37.7740711358709	-122.424028324662	(37.7740711358709, -122.424028324662)
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)
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)
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)
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)
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)
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)
116487	116487	244265	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005602.0322	2110112.8157	37.7742844003359	-122.42407349716999	(37.7742844003359, -122.42407349717)
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)
118707	118707	119686	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	4	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");