Street_Tree_List

Data source: data.sfgov.org

1,699 rows where PlotSize = "Width 0ft" and qSiteInfo = 2 sorted by qCareAssistant

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
27	27	244214	Private 5	Tree(s) :: 17	342 Scott St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/20/2017 12:00:00 AM	3	Width 0ft	Permit Number 779666	6002262.2202	2109717.5413	37.7730099442883	-122.43559821674499	(37.7730099442883, -122.435598216745)
35	35	183515	Undocumented 2	Myoporum laetum :: Myoporum 1	2562 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/21/2017 12:00:00 AM	3	Width 0ft	Permit Number 779639	5988336.7554	2097879.9474	37.7397063254514	-122.482899813956	(37.7397063254514, -122.482899813956)
50	50	138938	Private 5	Tree(s) :: 17	632 HAYES ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/21/2017 12:00:00 AM	3	Width 0ft	Permit Number 779650	6004797.9634	2110922.1515	37.7764612085261	-122.426912572117	(37.7764612085261, -122.426912572117)
1103	1103	211013	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	44	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5991332.59313	2093509.69784	37.727880584217	-122.47222310103399	(37.727880584217, -122.472223101034)
1368	1368	141257	Undocumented 2	Rhaphiolepis indica :: India Hawthorn 144	51 COMMONWEALTH AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5996492.2734	2114210.7856	37.7850177994523	-122.455881936455	(37.7850177994523, -122.455881936455)
1370	1370	141258	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	51 COMMONWEALTH AVE	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996495.6576	2114088.9538	37.7846834760254	-122.455861417999	(37.7846834760254, -122.455861417999)
3041	3041	182178	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1799X Lawton St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988865.0	2104441.0	37.7577519603078	-122.48155379203999	(37.7577519603078, -122.48155379204)
22365	22365	141244	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	31 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5996487.1971	2114345.4775	37.7853873361438	-122.455909239222	(37.7853873361438, -122.455909239222)
23417	23417	183167	Undocumented 2	:: 54	2422 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982411.0498	2098597.3573	37.741329561902596	-122.50344114283101	(37.7413295619026, -122.503441142831)
23447	23447	140934	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	120 JORDAN AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5996249.4558	2113606.8719	37.7833456744969	-122.456678312901	(37.7833456744969, -122.456678312901)
23481	23481	218410	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	205 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5994280.90702	2100599.38004	37.7475172792951	-122.462544833698	(37.7475172792951, -122.462544833698)
23689	23689	185447	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2400 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5985080.5667	2098519.0396	37.7412710983901	-122.494205254183	(37.7412710983901, -122.494205254183)
23724	23724	181665	Undocumented 2	:: 54	1275 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985511.3315	2106531.7973	37.7632971348656	-122.49330603001499	(37.7632971348656, -122.493306030015)
23777	23777	183752	Undocumented 2	:: 54	2287 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987917.4443	2099749.9687	37.7448165037016	-122.484486720736	(37.7448165037016, -122.484486720736)
23835	23835	182329	Undocumented 2	:: 54	1501 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985565.7361	2104954.3084	37.75896897093661	-122.493001657059	(37.7589689709366, -122.493001657059)
23915	23915	201200	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	700 Folsom St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		6012679.9726	2113219.2905	37.7832111428923	-122.399807626404	(37.7832111428923, -122.399807626404)
23926	23926	181820	Undocumented 2	:: 54	2299 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985846.0311	2099546.7997	37.7441378151504	-122.491634223287	(37.7441378151504, -122.491634223287)
23941	23941	250276	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		6008392.62375	2112125.224	37.7799671560941	-122.414562734397	(37.7799671560941, -122.414562734397)
23950	23950	184234	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1560 43rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5982828.9188	2104533.9152	37.7576542549583	-122.502435587448	(37.7576542549583, -122.502435587448)
24053	24053	181971	Undocumented 2	:: 54	2467 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985787.1457	2098434.4072	37.7410800425161	-122.49175595946801	(37.7410800425161, -122.491755959468)
24081	24081	183742	Undocumented 2	:: 54	2278 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988578.8889999995	2099828.4885	37.745070593746796	-122.482205348546	(37.7450705937468, -122.482205348546)
24101	24101	141230	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	16 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		5996536.7759	2114447.1732	37.7856694107907	-122.45574506618999	(37.7856694107907, -122.45574506619)
24126	24126	138818	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	723 Grove St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		6004379.6433	2111160.4787	37.7770919345009	-122.428376650964	(37.7770919345009, -122.428376650964)
24148	24148	182529	Undocumented 2	:: 54	1583 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986203.973999999	2104470.5925	37.7576781250927	-122.490758769583	(37.7576781250927, -122.490758769583)
24206	24206	181982	Undocumented 2	:: 54	2479 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986720.0054	2098392.2737	37.7410188327151	-122.488527415956	(37.7410188327151, -122.488527415956)
24275	24275	184454	Undocumented 2	:: 54	2153 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981374.6331	2100381.1786	37.7461664541179	-122.507156946857	(37.7461664541179, -122.507156946857)
24278	24278	183048	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2600 20th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5990217.9332	2097368.8862	37.7384123615974	-122.47635825040301	(37.7384123615974, -122.476358250403)
24286	24286	249978	Undocumented 2	Brugmansia spp :: Angel trumpet 137	13 Napier Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 0ft		6011650.66928	2120187.96882	37.8022880343123	-122.403859153579	(37.8022880343123, -122.403859153579)
24402	24402	182453	Undocumented 2	:: 54	1500 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986555.3586	2104541.3333	37.7578928802813	-122.489548755928	(37.7578928802813, -122.489548755928)
24606	24606	181614	Undocumented 2	:: 54	1246 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984927.2833	2106710.1633	37.7637526989564	-122.49533918573601	(37.7637526989564, -122.495339185736)
24610	24610	183977	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1693 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985918.7806	2103713.7918	37.7555834944248	-122.49168936146002	(37.7555834944248, -122.49168936146)
24630	24630	184291	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1543 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983404.3155	2104639.3384	37.7579775103532	-122.50045345703501	(37.7579775103532, -122.500453457035)
24723	24723	181788	Undocumented 2	:: 54	3131 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986265.505	2098198.358	37.740459860841	-122.49008463083	(37.740459860841, -122.49008463083)
24861	24861	182367	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1511 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5986186.5787	2104935.6262	37.758953963431	-122.49085314669901	(37.758953963431, -122.490853146699)
24939	24939	143093	Undocumented 2	Podocarpus gracilor :: Fern Pine 13	487 Greenwich St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		6010518.569	2120277.0289	37.8024692600192	-122.407783074103	(37.8024692600192, -122.407783074103)
25231	25231	140921	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	150 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996579.2478	2113360.6701	37.7826885995813	-122.455519569028	(37.7826885995813, -122.455519569028)
25276	25276	183998	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1600 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5984888.9105	2103901.6725	37.756039119583896	-122.495264775736	(37.7560391195839, -122.495264775736)
25293	25293	182679	Undocumented 2	:: 54	2631 Moraga St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986083.8267	2103639.2241	37.7553883964845	-122.49111310108299	(37.7553883964845, -122.491113101083)
25309	25309	184952	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101472.9274	37.749292356781794	-122.49969333533701	(37.7492923567818, -122.499693335337)
25451	25451	218361	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	319 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5993708.26635	2100090.28038	37.746086426450894	-122.46448801411199	(37.7460864264509, -122.464488014112)
25523	25523	140930	Undocumented 2	Acer palmatum :: Japanese Maple 175	118 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5996567.4031	2113640.2065	37.7834554526548	-122.455580757548	(37.7834554526548, -122.455580757548)
25600	25600	218110	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	70 Lopez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5993948.55319	2100516.17746	37.7472696806615	-122.463688045574	(37.7472696806615, -122.463688045574)
25784	25784	182377	Undocumented 2	Cordyline australis :: Dracena Palm 141	1511 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985257.4301	2104883.1297	37.7587554987564	-122.494062662548	(37.7587554987564, -122.494062662548)
25978	25978	182524	Undocumented 2	:: 54	1579 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985892.4217	2104503.3998	37.757750000215005	-122.491838645138	(37.757750000215, -122.491838645138)
25988	25988	182516	Undocumented 2	Cordyline australis :: Dracena Palm 141	1575 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985271.1371	2104502.1703	37.7577102918866	-122.493987182038	(37.7577102918866, -122.493987182038)
26093	26093	184237	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1560 43rd Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5982827.6965	2104602.0583	37.7578412848543	-122.502444857851	(37.7578412848543, -122.502444857851)
26158	26158	218116	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	55 Lopez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5994001.31011	2100596.31322	37.7474927529972	-122.46351143220899	(37.7474927529972, -122.463511432209)
26178	26178	186047	Undocumented 2	:: 54	1900 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984778.2299	2102058.2647	37.7509711496958	-122.495511585412	(37.7509711496958, -122.495511585412)
26198	26198	185271	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2601 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 0ft		5985035.5152	2097142.4375	37.7374886824299	-122.494259580727	(37.7374886824299, -122.494259580727)
26255	26255	249868	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	230 Greenwich St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		6011723.02594	2120467.18676	37.803058740725	-122.403628419935	(37.803058740725, -122.403628419935)
26303	26303	181939	Undocumented 2	Malus :: Crab Apple 235	2435 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5986090.3717	2098658.1040000003	37.7417119717507	-122.490723983614	(37.7417119717507, -122.490723983614)
26353	26353	182219	Undocumented 2	Cordyline australis :: Dracena Palm 141	1598 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985010.9097	2104360.0371	37.7573048039248	-122.494876662608	(37.7573048039248, -122.494876662608)
26432	26432	141346	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	463 BRODERICK ST	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		6001145.1037	2110334.7664	37.774641176317104	-122.439506706044	(37.7746411763171, -122.439506706044)
26491	26491	184713	Undocumented 2	:: 54	1626 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984397.6244	2104083.8858	37.756510650266705	-122.496977229466	(37.7565106502667, -122.496977229466)
26507	26507	184509	Undocumented 2	:: 54	1886 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981125.5546	2102268.3878	37.751333525850896	-122.50815826243401	(37.7513335258509, -122.508158262434)
26510	26510	182982	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2500 20th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5990198.1355	2098062.4817	37.7403156480562	-122.47647735467599	(37.7403156480562, -122.476477354676)
26576	26576	184709	Undocumented 2	:: 54	1618 40th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983775.4227	2104111.6852	37.7565504997112	-122.499131044219	(37.7565504997112, -122.499131044219)
26632	26632	182608	Undocumented 2	:: 54	1839 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985333.4224	2102688.337	37.7527336497539	-122.493638125681	(37.7527336497539, -122.493638125681)
26723	26723	183174	Undocumented 2	:: 54	2400 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984903.1916	2098438.8046	37.7410404135541	-122.494812631239	(37.7410404135541, -122.494812631239)
26822	26822	183837	Undocumented 2	:: 54	2206 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985462.2045	2100160.7045	37.745800992601	-122.4930066047	(37.745800992601, -122.4930066047)
26866	26866	182267	Undocumented 2	:: 54	1474 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986846.9486	2105227.058	37.7597927113016	-122.48859072822201	(37.7597927113016, -122.488590728222)
26920	26920	182657	Undocumented 2	:: 54	2630 Ortega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985816.7659	2102326.4814	37.75176835729211	-122.491940021962	(37.7517683572921, -122.491940021962)
26931	26931	186521	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1501 Sunset Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984773.9175	2104835.1255	37.758595388813895	-122.49573130554701	(37.7585953888139, -122.495731305547)
27002	27002	181705	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1206 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5989261.3602	2107107.536	37.7650965865931	-122.48037820612	(37.7650965865931, -122.48037820612)
27047	27047	181865	Undocumented 2	:: 54	2331 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986993.7887	2099395.3559	37.743789001507004	-122.487654458992	(37.743789001507, -122.487654458992)
27136	27136	185855	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2000 Sunset Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5984970.1707	2101389.2867	37.7491455567358	-122.494798527696	(37.7491455567358, -122.494798527696)
27139	27139	182622	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1850 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985688.7082	2102616.5515	37.752557324548796	-122.492404215168	(37.7525573245488, -122.492404215168)
27251	27251	184688	Undocumented 2	:: 54	1611 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984657.9281	2104207.7196	37.7568659135367	-122.496086155975	(37.7568659135367, -122.496086155975)
27390	27390	183785	Undocumented 2	:: 54	2146 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986125.7828	2099614.0525	37.744338818609	-122.490671864125	(37.744338818609, -122.490671864125)
27392	27392	141239	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	27 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5996486.1818	2114396.2408	37.7855266603489	-122.455916422904	(37.7855266603489, -122.455916422904)
27454	27454	189614	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 0ft		6011103.60933	2110745.72652	37.7763313085817	-122.405087010566	(37.7763313085817, -122.405087010566)
27474	27474	183607	Undocumented 2	:: 54	1 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989903.61	2101103.2452	37.748647706091596	-122.477717911497	(37.7486477060916, -122.477717911497)
27481	27481	182966	Undocumented 2	Cinnamomum camphora :: Camphor Tree 230	2430 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5989858.6972	2098819.7917	37.7423753326027	-122.477706327536	(37.7423753326027, -122.477706327536)
27597	27597	184102	Undocumented 2	:: 54	1623 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985904.0693	2104173.8569	37.7568458469392	-122.491774103994	(37.7568458469392, -122.491774103994)
27638	27638	218117	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	51 Lopez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5994004.41088	2100604.52458	37.7475154779688	-122.463501305851	(37.7475154779688, -122.463501305851)
27666	27666	183543	Undocumented 2	Arbutus unedo :: Strawberry Tree 61	2581 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5988605.1751	2097774.8752	37.7394334392266	-122.481964049119	(37.7394334392266, -122.481964049119)
27693	27693	183999	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1600 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		5984882.0685	2103992.5736	37.7562883082283	-122.49529514071399	(37.7562883082283, -122.495295140714)
27761	27761	185148	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2500 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		5985103.2864	2097852.3368	37.739441841296895	-122.494077573061	(37.7394418412969, -122.494077573061)
27770	27770	181987	Undocumented 2	:: 54	2832 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987195.8265	2098292.1009	37.7407715379119	-122.486874867312	(37.7407715379119, -122.486874867312)
27854	27854	186004	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1900 Sunset Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5984957.0471	2102005.2828	37.7508361451113	-122.49488932117599	(37.7508361451113, -122.494889321176)
28016	28016	182977	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2501 19th Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5990450.429	2097836.2467	37.7397090941282	-122.475588518051	(37.7397090941282, -122.475588518051)
28134	28134	218416	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	206 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5994263.50524	2100633.1916900002	37.747609115379	-122.46260745978901	(37.747609115379, -122.462607459789)
28174	28174	140931	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	116 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5996249.4558	2113636.3146	37.783426516311394	-122.456680442894	(37.7834265163114, -122.456680442894)
28244	28244	184686	Undocumented 2	:: 54	1606 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984083.9121	2104208.225	37.7568336628482	-122.498071323375	(37.7568336628482, -122.498071323375)
28252	28252	218356	Undocumented 2	Pinus radiata :: Monterey Pine 3	355 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 0ft		5993561.70957	2100014.8497	37.7458708634629	-122.464989307038	(37.7458708634629, -122.464989307038)
28280	28280	184225	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1500 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 0ft		5984863.4973	2104582.9422	37.757908209196295	-122.495402904025	(37.7579082091963, -122.495402904025)
28283	28283	250263	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		6008564.070780001	2112166.2785	37.780089512455895	-122.413972525522	(37.7800895124559, -122.413972525522)
28310	28310	185781	Undocumented 2	:: 54	2419 Ortega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986496.7508	2102292.5013	37.7517147795652	-122.489586075955	(37.7517147795652, -122.489586075955)
28315	28315	182384	Undocumented 2	:: 54	1539 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985884.4808	2104746.0177	37.7584156979157	-122.49188396911	(37.7584156979157, -122.49188396911)
28318	28318	182661	Undocumented 2	:: 54	2500 Ortega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986241.1388	2102339.3676	37.7518285352163	-122.490473451437	(37.7518285352163, -122.490473451437)
28356	28356	218340	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	15 Montalvo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5993385.71505	2099910.6129400004	37.745574506277	-122.465590295159	(37.745574506277, -122.465590295159)
28443	28443	182222	Undocumented 2	Cordyline australis :: Dracena Palm 141	2840 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985405.1901	2104352.0968	37.757306074239104	-122.49351252094999	(37.7573060742391, -122.49351252095)
28520	28520	184001	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1600 Sunset Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5984878.1588	2104167.5339	37.75676847179471	-122.49532156409501	(37.7567684717947, -122.495321564095)
28753	28753	185147	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2500 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5985105.4901	2097791.7341	37.7392755715004	-122.49406548841002	(37.7392755715004, -122.49406548841)
28815	28815	182351	Undocumented 2	Trachycarpus fortunei :: Windmill Palm 31	1501 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5985257.4301	2104935.3862	37.758898980602005	-122.49406651392	(37.758898980602, -122.49406651392)
28871	28871	182685	Undocumented 2	:: 54	1709 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985611.9744	2103558.0646	37.7551379747053	-122.492738908785	(37.7551379747053, -122.492738908785)
28878	28878	218420	Undocumented 2	Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 305	218 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5994226.32214	2100571.66899	37.7474380481336	-122.46273157340299	(37.7474380481336, -122.462731573403)
28995	28995	183156	Undocumented 2	Myoporum laetum :: Myoporum 1	2354 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 0ft		5981775.1553	2099067.0868	37.7425819051481	-122.50567461791901	(37.7425819051481, -122.505674617919)
29051	29051	181932	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2378 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5985195.246	2099024.2764	37.74266505256279	-122.49384596323	(37.7426650525628, -122.49384596323)
29110	29110	140804	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	90 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996555.8967	2113971.183	37.784363565831704	-122.45564449638	(37.7843635658317, -122.45564449638)

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