Street_Tree_List

Data source: data.sfgov.org

1,699 rows where PlotSize = "Width 0ft" and qSiteInfo = 2 sorted by rowid 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

- 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, PlantDate

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189064	189064	185387	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2300 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 0ft		5985052.012999999	2099287.3331	37.743378953957794	-122.494360600593	(37.7433789539578, -122.494360600593)
189029	189029	140863	Undocumented 2	:: 54	106 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5996246.41	2113718.2127	37.7836512118011	-122.45669690496901	(37.7836512118011, -122.456696904969)
189021	189021	182962	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2050 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5989686.5492	2098375.4265	37.741145229321496	-122.47826907299999	(37.7411452293215, -122.478269073)
189016	189016	182660	Undocumented 2	:: 54	1890 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986007.8679	2102386.3122	37.75194380463171	-122.49128357776199	(37.7519438046317, -122.491283577762)
188965	188965	182974	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2501 19th Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5990445.6911	2097993.6128	37.7401409062913	-122.475616387366	(37.7401409062913, -122.475616387366)
188962	188962	182197	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1584 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 0ft		5985008.2078	2104414.5267	37.7574542590905	-122.494890024235	(37.7574542590905, -122.494890024235)
188944	188944	184944	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101275.9659	37.748751952115505	-122.49965537495702	(37.7487519521155, -122.499655374957)
188884	188884	186847	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2700 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5985140.3975	2096462.5634	37.73562806681571	-122.493846870805	(37.7356280668157, -122.493846870805)
188849	188849	247498	Undocumented 2	Photinia fraseri :: Photinia: Chinese photinia 104	348 Scott St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		6002258.2648	2109741.2734	37.7730748820821	-122.43561359709	(37.7730748820821, -122.43561359709)
188784	188784	184377	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988408.1936	2100317.5308	37.7464034445307	-122.48283140934299	(37.7464034445307, -122.482831409343)
188760	188760	218430	Undocumented 2	Maytenus boaria :: Mayten 22	81 Lopez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5993974.36108	2100474.97529	37.7471580370095	-122.463595814708	(37.7471580370095, -122.463595814708)
188705	188705	186849	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2700 Sunset Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985134.8973	2096609.0061	37.7360298376031	-122.493876675464	(37.7360298376031, -122.493876675464)
188521	188521	250295	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		6008359.254290001	2112041.46764	37.7797353063774	-122.41467224575199	(37.7797353063774, -122.414672245752)
188455	188455	218334	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	2 Montalvo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		5993385.371119999	2099847.32805	37.745400722182296	-122.46558688764699	(37.7454007221823, -122.465586887647)
188447	188447	218307	Undocumented 2	Maytenus boaria :: Mayten 22	465 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5992940.20866	2099905.7467	37.7455354388055	-122.46713042103998	(37.7455354388055, -122.46713042104)
188435	188435	186529	Undocumented 2	:: 54	1500 37th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984686.823	2104775.4574	37.7584264560006	-122.496028111274	(37.7584264560006, -122.496028111274)
188366	188366	184365	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2246 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5981748.9474	2099793.4739	37.7445748198756	-122.505819075039	(37.7445748198756, -122.505819075039)
188349	188349	182371	Undocumented 2	Cordyline australis :: Dracena Palm 141	1510 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985921.5907	2104932.1472	37.7589289271259	-122.491769330525	(37.7589289271259, -122.491769330525)
188344	188344	183795	Undocumented 2	:: 54	2290 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985480.5542	2099650.3252	37.744400702172605	-122.492905567796	(37.7444007021726, -122.492905567796)
188332	188332	143031	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	301 LOMBARD ST	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		6010830.5748	2120664.6828	37.8035511239121	-122.406730709589	(37.8035511239121, -122.406730709589)
188296	188296	182616	Undocumented 2	:: 54	1856 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987553.0951	2102630.1854	37.7527035840583	-122.485957928463	(37.7527035840583, -122.485957928463)
188246	188246	249930	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	345 Filbert St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		6011183.60917	2120017.47195	37.8017937876064	-122.40546340291999	(37.8017937876064, -122.40546340292)
188211	188211	182131	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2600 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		5987946.7845	2098317.4825	37.740884983303204	-122.484280230772	(37.7408849833032, -122.484280230772)
188195	188195	183817	Undocumented 2	:: 54	2133 Rivera St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5986490.2175	2100252.0265	37.74611180538629	-122.48945864467301	(37.7461118053863, -122.489458644673)
188156	188156	250298	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		6008400.93583	2112028.98514	37.7797033741539	-122.414527167109	(37.7797033741539, -122.414527167109)
188133	188133	183803	Undocumented 2	:: 54	2222 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986396.7617	2100091.5728	37.7456657864188	-122.489770000258	(37.7456657864188, -122.489770000258)
188050	188050	250293	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		6008341.16975	2112039.72315	37.7797295003499	-122.414734684778	(37.7797295003499, -122.414734684778)
187996	187996	140851	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	571 Euclid Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 0ft		5996626.4577	2113806.2024	37.7839146219169	-122.45538845370001	(37.7839146219169, -122.4553884537)
187995	187995	187310	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2200 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 0ft		5985030.9318	2099750.1318	37.7446484400934	-122.49446760159401	(37.7446484400934, -122.494467601594)
187933	187933	141037	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	168 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5996266.0384	2113205.8421	37.7822455054095	-122.456591933359	(37.7822455054095, -122.456591933359)
187803	187803	182417	Undocumented 2	:: 54	1544 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984999.4264	2104687.6498	37.758203665254996	-122.494940531373	(37.758203665255, -122.494940531373)
187768	187768	182630	Undocumented 2	:: 54	1858 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986937.5539	2102606.5337	37.752602752659705	-122.488084813705	(37.7526027526597, -122.488084813705)
187701	187701	182499	Undocumented 2	:: 54	1567 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985270.2162	2104558.8043	37.7578657392797	-122.493994540633	(37.7578657392797, -122.493994540633)
187636	187636	183293	Undocumented 2	:: 54	1286 42nd Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983075.6533	2106421.6609	37.76285196523921	-122.50172195396401	(37.7628519652392, -122.501721953964)
187627	187627	184329	Undocumented 2	:: 54	1571 42nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983101.4912	2104441.3261	37.757416043664996	-122.501486086821	(37.757416043665, -122.501486086821)
187567	187567	218314	Undocumented 2	Ceratonia siliqua :: Carob 97	437 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5993129.70143	2099920.62697	37.7455872325622	-122.466476271275	(37.7455872325622, -122.466476271275)
187527	187527	183391	Undocumented 2	Cordyline australis :: Dracena Palm 141	2670 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5988981.484	2097172.4205	37.7378011335163	-122.48061886239599	(37.7378011335163, -122.480618862396)
187493	187493	183973	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1679 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5987776.9086	2103868.5958	37.756116965025605	-122.48527481394301	(37.7561169650256, -122.485274813943)
187448	187448	184439	Undocumented 2	:: 54	2131 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982299.7091	2100588.462	37.7467900380649	-122.503973554813	(37.7467900380649, -122.503973554813)
187430	187430	218414	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	200 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5994295.2079300005	2100668.92449	37.747709054341	-122.46250042605101	(37.747709054341, -122.462500426051)
187417	187417	218328	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	446 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5993017.38918	2099944.3564400002	37.7456459061356	-122.46686635132099	(37.7456459061356, -122.466866351321)
187361	187361	182210	Undocumented 2	:: 54	1590 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985631.6222	2104402.5116	37.757457742400796	-122.49273315414801	(37.7574577424008, -122.492733154148)
187360	187360	185788	Undocumented 2	:: 54	1911 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986591.7328	2102227.8108	37.7515427017776	-122.48925286425501	(37.7515427017776, -122.489252864255)
187306	187306	140811	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	92 Commonwealth Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996557.5888	2113916.3587	37.784213129993795	-122.455634678211	(37.7842131299938, -122.455634678211)
187265	187265	183138	Undocumented 2	:: 54	3521 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981925.3562	2099416.4074	37.7435498815044	-122.50518115930201	(37.7435498815044, -122.505181159302)
187264	187264	182228	Undocumented 2	:: 54	1674 21st Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989678.7682	2103975.7002	37.7565216554044	-122.478705447978	(37.7565216554044, -122.478705447978)
187250	187250	181883	Undocumented 2	:: 54	2362 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986739.9723	2099172.336	37.7431618411675	-122.48851569655001	(37.7431618411675, -122.48851569655)
187217	187217	185849	Undocumented 2	:: 54	2010 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986971.0019	2101557.3753	37.749723998312895	-122.487892067667	(37.7497239983129, -122.487892067667)
187070	187070	186110	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1700 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984921.7411	2103055.8274	37.7537185848112	-122.495088868687	(37.7537185848112, -122.495088868687)
187066	187066	245846	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	301 Oak St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		6005500.1805	2110269.8913	37.7747099408336	-122.424436996012	(37.7747099408336, -122.424436996012)
186889	186889	183225	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2195 Rivera St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5981668.485	2100141.7164	37.7455262605285	-122.506123109259	(37.7455262605285, -122.506123109259)
186774	186774	185814	Undocumented 2	:: 54	2046 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989455.7955	2101408.9048	37.7494609681644	-122.479288789487	(37.7494609681644, -122.479288789487)
186756	186756	182869	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1847 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5988126.7611	2102732.0567	37.753016709320995	-122.48398158304701	(37.753016709321, -122.483981583047)
186739	186739	184949	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983558.4689	2101406.2583	37.749109421016605	-122.499681387134	(37.7491094210166, -122.499681387134)
186681	186681	182992	Undocumented 2	Maytenus boaria :: Mayten 22	2503 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5989828.2405	2098307.499	37.7409669421836	-122.4777741965	(37.7409669421836, -122.4777741965)
186494	186494	182276	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	3150 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985061.2024	2105018.6781	37.759116193094	-122.494751291704	(37.759116193094, -122.494751291704)
186486	186486	185852	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2000 Sunset Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5984979.0546	2101113.8863	37.7483899025069	-122.494747505835	(37.7483899025069, -122.494747505835)
186473	186473	183880	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2130 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5988854.6643	2100842.9028	37.747871944579295	-122.48132604988501	(37.7478719445793, -122.481326049885)
186339	186339	183428	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2430 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5989548.6064	2098792.6969999997	37.742282937054	-122.478776534673	(37.742282937054, -122.478776534673)
186300	186300	183883	Undocumented 2	:: 54	2130 24th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988850.4477	2100968.5581	37.7482167156371	-122.481349831083	(37.7482167156371, -122.481349831083)
186278	186278	218119	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	51 Lopez Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5994014.29186	2100634.4512400003	37.747598218302606	-122.463469309776	(37.7475982183026, -122.463469309776)
186212	186212	200198	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	3125 Jennings St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		6013701.6232	2090281.2208	37.720285019418505	-122.394666263771	(37.7202850194185, -122.394666263771)
186147	186147	182765	Undocumented 2	:: 54	1762 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986291.289	2103252.0043	37.7543373159435	-122.490367159029	(37.7543373159435, -122.490367159029)
186076	186076	218347	Undocumented 2	Maytenus boaria :: Mayten 22	385 Castenada Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5993396.13105	2100054.6409	37.7459705712792	-122.465564740015	(37.7459705712792, -122.465564740015)
186044	186044	185736	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2119 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5987568.4406	2100856.1259	37.7478333870661	-122.485774665371	(37.7478333870661, -122.485774665371)
186033	186033	141235	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	21 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996484.8281	2114408.7624	37.7855609636266	-122.455922011814	(37.7855609636266, -122.455922011814)
185948	185948	218383	Undocumented 2	Tree(s) :: 17	398 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		5993334.06783	2100029.01263	37.745896622722704	-122.465777482764	(37.7458966227227, -122.465777482764)
185919	185919	185272	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2601 Sunset Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		5985037.6088	2097047.3872	37.7372278222653	-122.49424533831801	(37.7372278222653, -122.494245338318)
185483	185483	184626	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1779 40th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5983767.9520000005	2103067.9093	37.7536841440078	-122.499079761427	(37.7536841440078, -122.499079761427)
185376	185376	184529	Undocumented 2	:: 54	1996 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981188.5011	2101512.3535	37.7492613780766	-122.50788448891899	(37.7492613780766, -122.507884488919)
185311	185311	184600	Undocumented 2	:: 54	1767 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984384.3874	2103165.544	37.7539883630109	-122.496955228039	(37.7539883630109, -122.496955228039)
185229	185229	218397	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	253 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5994133.69186	2100284.3945299997	37.746643929681504	-122.463031040447	(37.7466439296815, -122.463031040447)
185224	185224	182761	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1771 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5988107.0179	2103255.9052	37.754453907013605	-122.484088270186	(37.7544539070136, -122.484088270186)
185171	185171	186527	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1501 Sunset Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 0ft		5984784.1762	2104491.144	37.7576515120855	-122.495670454629	(37.7576515120855, -122.495670454629)
185011	185011	184464	Undocumented 2	Myoporum laetum :: Myoporum 1	2149 48th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5981372.6025	2100411.6366	37.746249963664496	-122.50716622744899	(37.7462499636645, -122.507166227449)
184961	184961	183873	Undocumented 2	:: 54	2254 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987953.2904	2099959.924	37.7453950726433	-122.484378169146	(37.7453950726433, -122.484378169146)
184799	184799	184945	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101296.9480000003	37.7488095631642	-122.49965692549101	(37.7488095631642, -122.499656925491)
184575	184575	182425	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1538 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988098.2611	2104825.7625	37.758763800953005	-122.484233676535	(37.758763800953, -122.484233676535)
184402	184402	182590	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2485 26th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5988273.6999	2098412.9174	37.7411660521999	-122.48315688603998	(37.7411660521999, -122.48315688604)
184345	184345	186048	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1901 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984869.5399	2102133.1444	37.7511820951047	-122.49520135249901	(37.7511820951047, -122.495201352499)
184322	184322	183815	Undocumented 2	:: 54	2137 Rivera St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5986412.1243	2100248.6126	37.746097872473506	-122.48972842623199	(37.7460978724735, -122.489728426232)
184288	184288	184151	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1585 44th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5982482.7335	2104338.124	37.7570963201307	-122.503618318652	(37.7570963201307, -122.503618318652)
184229	184229	218417	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	206 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5994252.951119999	2100616.68956	37.7475631968785	-122.462642758156	(37.7475631968785, -122.462642758156)
184171	184171	182345	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1522 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		5988093.404	2104933.5905	37.7590595845641	-122.484258382398	(37.7590595845641, -122.484258382398)
184004	184004	185782	Undocumented 2	:: 54	1939 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986599.433999999	2102039.387	37.751025790613205	-122.489212380971	(37.7510257906132, -122.489212380971)
183851	183851	183451	Undocumented 2	:: 54	2515 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988280.1843	2098179.6898	37.7405260477437	-122.48311737481701	(37.7405260477437, -122.483117374817)
183828	183828	183865	Undocumented 2	:: 54	2254 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988574.1949	2099980.8342	37.745488621810395	-122.48223273912	(37.7454886218104, -122.48223273912)
183805	183805	182740	Undocumented 2	:: 54	1758 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986288.2261	2103274.6696	37.7543993697777	-122.490379418445	(37.7543993697777, -122.490379418445)
183796	183796	182261	Undocumented 2	:: 54	1458 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984977.3774	2105263.7356	37.759784145824796	-122.495059264357	(37.7597841458248, -122.495059264357)
183761	183761	218369	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	320 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5993682.16645	2100114.37861	37.7461510895044	-122.46458001298001	(37.7461510895044, -122.46458001298)
183738	183738	183807	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2207 28th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5987587.5755	2100244.1318	37.7461541295061	-122.48566359052799	(37.7461541295061, -122.485663590528)
183692	183692	181692	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1363 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985221.299	2105936.0122	37.7616443068738	-122.494265225231	(37.7616443068738, -122.494265225231)
183672	183672	200636	Undocumented 2	:: 54	1301 Quesada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016782.3625	2093458.8747	37.729181036936396	-122.384238246013	(37.7291810369364, -122.384238246013)
183610	183610	182279	Undocumented 2	Prunus blireiana :: Flowering Plum 102	1496 Kirkham St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5984984.0246	2105052.8568	37.7592055205034	-122.495020725609	(37.7592055205034, -122.495020725609)
183590	183590	185662	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2101 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 0ft		5984918.2965	2100689.2549	37.7472204240024	-122.49492629785699	(37.7472204240024, -122.494926297857)
183525	183525	140797	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	81 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5996499.7187	2113990.1346	37.784412377895606	-122.45584022202699	(37.7844123778956, -122.455840222027)
183485	183485	218120	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	45 Lopez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5994017.79191	2100645.88828	37.7476298231751	-122.46345803676701	(37.7476298231751, -122.463458036767)
183469	183469	181965	Undocumented 2	:: 54	2423 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987019.5087	2098756.0771	37.7420352120933	-122.48751857494499	(37.7420352120933, -122.487518574945)
183358	183358	182230	Undocumented 2	:: 54	1423 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986783.0013	2105561.4949	37.7607072513694	-122.48883647166402	(37.7607072513694, -122.488836471664)
183233	183233	186926	Undocumented 2	:: 54	2800 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985157.2666	2096011.7096	37.734391129301	-122.493755335707	(37.734391129301, -122.493755335707)

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