Street_Tree_List

Data source: data.sfgov.org

863 rows where qSiteInfo = 17 sorted by SiteOrder 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, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
77273	77273	195083	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	25	Side Yard : Yard 17	Tree 1	Private 1			10	Width 4ft		6014995.62835	2103102.9826	37.755562808578404	-122.391089000875	(37.7555628085784, -122.391089000875)
48783	48783	195082	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	24	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014993.20082	2103136.83485	37.755655624926895	-122.39109976213899	(37.7556556249269, -122.391099762139)
32078	32078	195081	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	23	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014990.50186	2103171.25593	37.7557499880963	-122.391111501888	(37.7557499880963, -122.391111501888)
176180	176180	195080	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	22	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014988.8599	2103201.99322	37.755834295018204	-122.39111932871201	(37.7558342950182, -122.391119328712)
41420	41420	195079	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	21	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014986.69812	2103234.99475	37.755924790211395	-122.391129111534	(37.7559247902114, -122.391129111534)
43990	43990	134521	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	20	Side Yard : Yard 17	Tree 1	Private 1			14	Width 4ft		6007806.05941	2112087.1007	37.7798295076742	-122.416589227122	(37.7798295076742, -122.416589227122)
182626	182626	195078	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	20	Side Yard : Yard 17	Tree 1	Private 1			11	Width 4ft		6014987.06432	2103267.10016	37.7560129651346	-122.391130089079	(37.7560129651346, -122.391130089079)
184976	184976	214230	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	714 Detroit St	20	Side Yard : Yard 17	Tree 1	Private 1			7			5999463.98385	2095461.59315	37.7337072656774	-122.444252993784	(37.7337072656774, -122.444252993784)
53472	53472	207987	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	714 Detroit St	19	Side Yard : Yard 17	Tree 1	Private 1			8			5999466.174219999	2095456.6543299998	37.7336938298041	-122.444245066271	(37.7336938298041, -122.444245066271)
57595	57595	134520	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	19	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6007809.423690001	2112072.4347	37.779789427567	-122.41657654936199	(37.779789427567, -122.416576549362)
29144	29144	205629	Undocumented 2	Betula pendula :: European White Birch 146	714 Detroit St	18	Side Yard : Yard 17	Tree 1	Private 1			5			5999458.60233	2095454.85434	37.7336884554611	-122.444271115125	(37.7336884554611, -122.444271115125)
177540	177540	134519	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	18	Side Yard : Yard 17	Tree 1	Private 1			24	Width 4ft		6007845.81845	2112089.93571	37.779839527901295	-122.416451883555	(37.7798395279013, -122.416451883555)
28786	28786	214229	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	714 Detroit St	17	Side Yard : Yard 17	Tree 1	Private 1			9			5999467.99685	2095449.76583	37.7336750195872	-122.444238270085	(37.7336750195872, -122.444238270085)
66458	66458	136660	Undocumented 2	Taxus baccata :: Irish Yew 241	1599 North Point St	17	Side Yard : Yard 17	Tree 1	Private 1			14	Width 7ft		6003228.45993	2120985.21121	37.8040029344509	-122.433061071222	(37.8040029344509, -122.433061071222)
138148	138148	134518	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	17	Side Yard : Yard 17	Tree 1	Private 1			6	Width 4ft		6007848.65925	2112079.5377	37.7798111372171	-122.41644131921801	(37.7798111372171, -122.416441319218)
25566	25566	214228	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	714 Detroit St	16	Side Yard : Yard 17	Tree 1	Private 1			5			5999467.5472800005	2095443.9032	37.733658896535	-122.444239403229	(37.733658896535, -122.444239403229)
35294	35294	177823	Undocumented 2	Myoporum laetum :: Myoporum 1	35 Tomaso Ct	16	Side Yard : Yard 17	Tree 1	Private 1			15	Width 3ft		6009246.7312	2086449.12039	37.7095141743011	-122.409795064007	(37.7095141743011, -122.409795064007)
64022	64022	136289	Undocumented 2	Quercus spp :: Oak 297	2836 Larkin St	16	Side Yard : Yard 17	Tree 1	Private 1			6			6006495.00775	2121066.48783	37.80441084625	-122.42176272108101	(37.80441084625, -122.421762721081)
137288	137288	134517	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	16	Side Yard : Yard 17	Tree 1	Private 1			7	Width 4ft		6007880.14491	2112095.92317	37.7798578983531	-122.41633355704599	(37.7798578983531, -122.416333557046)
1320	1320	251503	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	15	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
45261	45261	177822	Undocumented 2	Myoporum laetum :: Myoporum 1	35 Tomaso Ct	15	Side Yard : Yard 17	Tree 1	Private 1			19	Width 3ft		6009243.51838	2086439.4286099998	37.7094873825954	-122.40980548443899	(37.7094873825954, -122.409805484439)
57891	57891	125340	Undocumented 2	Acer macrophyllum :: Big Leaf Maple 159	943 Green St	15	Side Yard : Yard 17	Tree 1	Private 1			20			6008683.32426	2118993.96894	37.798843386272395	-122.41404312948299	(37.7988433862724, -122.414043129483)
70214	70214	134516	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	15	Side Yard : Yard 17	Tree 1	Private 1			7	Width 4ft		6007879.23543	2112081.34439	37.7798178173801	-122.416335670458	(37.7798178173801, -122.416335670458)
146611	146611	206798	Undocumented 2	Cupaniopsis anacardioides :: Carrotwood 118	714 Detroit St	15	Side Yard : Yard 17	Tree 1	Private 1			13			5999465.474230001	2095438.72707	37.7336445658277	-122.444246198512	(37.7336445658277, -122.444246198512)
147910	147910	136288	Undocumented 2	Quercus spp :: Oak 297	2836 Larkin St	15	Side Yard : Yard 17	Tree 1	Private 1			5			6006500.63968	2121061.90297	37.804398574988205	-122.421742905414	(37.8043985749882, -122.421742905414)
1326	1326	251502	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	14	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
72993	72993	136716	Undocumented 2	Taxus baccata :: Irish Yew 241	1599 North Point St	14	Side Yard : Yard 17	Tree 1	Private 1			15	Width 7ft		6003215.33658	2120983.87446	37.8039985196804	-122.43310638985001	(37.8039985196804, -122.43310638985)
119320	119320	177821	Undocumented 2	Myoporum laetum :: Myoporum 1	35 Tomaso Ct	14	Side Yard : Yard 17	Tree 1	Private 1			14	Width 3ft		6009239.86768	2086426.74333	37.7094523468075	-122.40981720709101	(37.7094523468075, -122.409817207091)
148331	148331	190003	Undocumented 2	Chamaerops humilis :: Mediterranean Fan Palm 99	1750 22nd St	14	Side Yard : Yard 17	Tree 1	Private 1			7			6012781.6725699995	2103797.8962	37.7573477838951	-122.398794366977	(37.7573477838951, -122.398794366977)
177126	177126	134515	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	14	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6007920.47696	2112096.9218900003	37.7798629084902	-122.416194101002	(37.7798629084902, -122.416194101002)
183929	183929	125339	Undocumented 2	Acer macrophyllum :: Big Leaf Maple 159	943 Green St	14	Side Yard : Yard 17	Tree 1	Private 1			10			6008681.4461	2118995.9175299997	37.7988486311296	-122.414049766478	(37.7988486311296, -122.414049766478)
187806	187806	132199	Undocumented 2	Pinus radiata :: Monterey Pine 3	2836 Larkin St	14	Side Yard : Yard 17	Tree 1	Private 1			17			6006498.02761	2121046.57665	37.8043563455331	-122.42175085543998	(37.8043563455331, -122.42175085544)
1324	1324	251501	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	13	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
23842	23842	248194	Undocumented 2	Calocedrus decurrens :: Incense Cedar 177	216 Esmeralda Ave	13	Side Yard : Yard 17	Tree 1	Private 1			12			6007325.73728	2098765.61768	37.7432247818956	-122.41730658752199	(37.7432247818956, -122.417306587522)
33505	33505	193829	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	900 Phelps St	13	Side Yard : Yard 17	Tree 1	Private 1			27	Width 8ft		6014453.31745	2096931.20635	37.738586300018504	-122.392532803946	(37.7385863000185, -122.392532803946)
63782	63782	197353	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1750 22nd St	13	Side Yard : Yard 17	Tree 1	Private 1			4			6012786.799	2103803.61301	37.7573637666391	-122.398777038841	(37.7573637666391, -122.398777038841)
68308	68308	125338	Undocumented 2	Acer macrophyllum :: Big Leaf Maple 159	943 Green St	13	Side Yard : Yard 17	Tree 1	Private 1			7			6008681.05502	2118993.3413	37.7988415354762	-122.414050937395	(37.7988415354762, -122.414050937395)
73716	73716	134514	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	13	Side Yard : Yard 17	Tree 1	Private 1			15	Width 4ft		6007916.55212	2112084.22953	37.779827837626705	-122.41620677962	(37.7798278376267, -122.41620677962)
130652	130652	132198	Undocumented 2	Pinus radiata :: Monterey Pine 3	2836 Larkin St	13	Side Yard : Yard 17	Tree 1	Private 1			24			6006512.519719999	2121038.28328	37.804334391275894	-122.42170011478301	(37.8043343912759, -122.421700114783)
168341	168341	203438	Undocumented 2	Acer spp :: Maple 158	714 Detroit St	13	Side Yard : Yard 17	Tree 1	Private 1			6			5999448.55059	2095428.3134400002	37.73361500690729	-122.44430396017401	(37.7336150069073, -122.444303960174)
1348	1348	251500	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	12	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
52499	52499	248193	Undocumented 2	Myoporum laetum :: Myoporum 1	216 Esmeralda Ave	12	Side Yard : Yard 17	Tree 1	Private 1			7			6007342.31013	2098763.52222	37.74321996062879	-122.417249134357	(37.7432199606288, -122.417249134357)
70884	70884	247927	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	12	Side Yard : Yard 17	Tree 1	Private 1			34			6010318.55961	2098736.7728	37.7433135063186	-122.40695611204501	(37.7433135063186, -122.406956112045)
129644	129644	214463	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	714 Detroit St	12	Side Yard : Yard 17	Tree 1	Private 1			5			5999453.46925	2095428.5374599998	37.733615902639706	-122.44428697109	(37.7336159026397, -122.44428697109)
147117	147117	129641	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	943 Green St	12	Side Yard : Yard 17	Tree 1	Private 1			41			6008676.12705	2118976.42517	37.7987948111981	-122.41406679246201	(37.7987948111981, -122.414066792462)
150599	150599	194489	Undocumented 2	Pinus radiata :: Monterey Pine 3	1750 22nd St	12	Side Yard : Yard 17	Tree 1	Private 1			23			6012793.88135	2103795.98527	37.7573432171426	-122.398752009817	(37.7573432171426, -122.398752009817)
152906	152906	215179	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	747 Detroit St	12	Side Yard : Yard 17	Tree 1	Private 1			5			5999425.63373	2095397.4728	37.733529018245605	-122.444380974518	(37.7335290182456, -122.444380974518)
153139	153139	134513	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	12	Side Yard : Yard 17	Tree 1	Private 1			29	Width 4ft		6007949.93141	2112103.61743	37.779882948971206	-122.416092679044	(37.7798829489712, -122.416092679044)
184674	184674	126416	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2836 Larkin St	12	Side Yard : Yard 17	Tree 1	Private 1			46			6006501.512069999	2121012.26216	37.804262323204895	-122.421736358356	(37.8042623232049, -122.421736358356)
1335	1335	251499	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	11	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
29447	29447	206472	Undocumented 2	Cotoneaster SPP :: Cotoneaster 234	714 Detroit St	11	Side Yard : Yard 17	Tree 1	Private 1			7			5999457.34155	2095426.0503099998	37.733609294436796	-122.444273404802	(37.7336092944368, -122.444273404802)
44987	44987	134512	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	11	Side Yard : Yard 17	Tree 1	Private 1			13	Width 4ft		6007952.73516	2112091.3955099997	37.7798495481525	-122.416082113806	(37.7798495481525, -122.416082113806)
48369	48369	179631	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	184 Mount Vernon Ave	11	Side Yard : Yard 17	Tree 1	Private 1			10			5998932.987869999	2089405.3609099998	37.7170479506817	-122.445653426162	(37.7170479506817, -122.445653426162)
48879	48879	177820	Undocumented 2	Myoporum laetum :: Myoporum 1	35 Tomaso Ct	11	Side Yard : Yard 17	Tree 1	Private 1			16	Width 3ft		6009221.96633	2086380.57337	37.7093245702546	-122.409875820418	(37.7093245702546, -122.409875820418)
50293	50293	189299	Undocumented 2	Cordyline australis :: Dracena Palm 141	1750 22nd St	11	Side Yard : Yard 17	Tree 1	Private 1			2			6012797.06573	2103802.01858	37.7573599607159	-122.39874142030399	(37.7573599607159, -122.398741420304)
59780	59780	126415	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2836 Larkin St	11	Side Yard : Yard 17	Tree 1	Private 1			48			6006502.51226	2121001.4648	37.804232732814704	-122.421732129727	(37.8042327328147, -122.421732129727)
59867	59867	247926	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	11	Side Yard : Yard 17	Tree 1	Private 1			27			6010312.05046	2098736.31721	37.743311891127604	-122.406978587005	(37.7433118911276, -122.406978587005)
65111	65111	248192	Undocumented 2	Myoporum laetum :: Myoporum 1	216 Esmeralda Ave	11	Side Yard : Yard 17	Tree 1	Private 1			7			6007348.90224	2098760.26711	37.7432113936915	-122.41722610990101	(37.7432113936915, -122.417226109901)
132915	132915	206470	Undocumented 2	Cotoneaster SPP :: Cotoneaster 234	747 Detroit St	11	Side Yard : Yard 17	Tree 1	Private 1			1			5999427.716030001	2095403.5068599998	37.733545705162705	-122.44437420892599	(37.7335457051627, -122.444374208926)
147721	147721	136659	Undocumented 2	Taxus baccata :: Irish Yew 241	1599 North Point St	11	Side Yard : Yard 17	Tree 1	Private 1			13	Width 7ft		6003202.747769999	2120982.34817	37.8039936147875	-122.433149845112	(37.8039936147875, -122.433149845112)
157947	157947	246650	Undocumented 2	Prunus blireiana :: Flowering Plum 102	3350 Harrison St	11	Side Yard : Yard 17	Tree 1	Private 1			5			6009031.0412800005	2099150.93712	37.744378579706996	-122.411437288125	(37.744378579707, -122.411437288125)
172088	172088	125288	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	943 Green St	11	Side Yard : Yard 17	Tree 1	Private 1			1			6008674.79926	2118995.08989	37.7988459853112	-122.41407270821101	(37.7988459853112, -122.414072708211)
1341	1341	251498	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	10	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
33944	33944	208889	Undocumented 2	Malus :: Crab Apple 235	714 Detroit St	10	Side Yard : Yard 17	Tree 1	Private 1			6			5999450.60571	2095416.85302	37.733583656540496	-122.44429603176201	(37.7335836565405, -122.444296031762)
35115	35115	126414	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2836 Larkin St	10	Side Yard : Yard 17	Tree 1	Private 1			12			6006501.05561	2120998.5397099997	37.804224619123296	-122.421736962694	(37.8042246191233, -122.421736962694)
40126	40126	134511	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	10	Side Yard : Yard 17	Tree 1	Private 1			21	Width 4ft		6008018.559330001	2112114.37672	37.7799163498009	-122.41585602603399	(37.7799163498009, -122.415856026034)
46194	46194	247925	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	10	Side Yard : Yard 17	Tree 1	Private 1			25			6010304.27631	2098731.76841	37.743298966077795	-122.407005147582	(37.7432989660778, -122.407005147582)
47445	47445	248181	Undocumented 2	Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10	218 Esmeralda Ave	10	Side Yard : Yard 17	Tree 1	Private 1			32			6007478.19635	2098656.7324200002	37.7429343836221	-122.41677171036999	(37.7429343836221, -122.41677171037)
48835	48835	246649	Undocumented 2	Prunus blireiana :: Flowering Plum 102	3350 Harrison St	10	Side Yard : Yard 17	Tree 1	Private 1			5			6009030.81997	2099159.0230900003	37.744400769587	-122.411438624517	(37.744400769587, -122.411438624517)
59717	59717	178076	Undocumented 2	Persea americana :: Avocado 113	184 Mount Vernon Ave	10	Side Yard : Yard 17	Tree 1	Private 1			12			5998937.21643	2089402.34913	37.7170399224441	-122.44563859365401	(37.7170399224441, -122.445638593654)
60526	60526	224443	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	198 Corbin Pl	10	Side Yard : Yard 17	Tree 1	Private 1			15	Width 3ft		6000083.78895	2105729.05454	37.76193458623221	-122.442847194237	(37.7619345862322, -122.442847194237)
69221	69221	247529	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1101 Waller St	10	Side Yard : Yard 17	Tree 1	Private 1			2			6000073.75314	2108487.72588	37.7695086378454	-122.44308003233499	(37.7695086378454, -122.443080032335)
132613	132613	248191	Undocumented 2	Pinus radiata :: Monterey Pine 3	216 Esmeralda Ave	10	Side Yard : Yard 17	Tree 1	Private 1			33			6007363.38842	2098751.31764	37.743187635412205	-122.417175386353	(37.7431876354122, -122.417175386353)
132907	132907	125337	Undocumented 2	Acer macrophyllum :: Big Leaf Maple 159	943 Green St	10	Side Yard : Yard 17	Tree 1	Private 1			35			6008660.27555	2118990.50152	37.79883257103621	-122.414122640373	(37.7988325710362, -122.414122640373)
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)
176020	176020	178272	Undocumented 2	Pinus radiata :: Monterey Pine 3	35 Tomaso Ct	10	Side Yard : Yard 17	Tree 1	Private 1			22	Width 3ft		6009218.69223	2086367.8804	37.709289534449894	-122.409886240875	(37.7092895344499, -122.409886240875)
176813	176813	208888	Undocumented 2	Malus :: Crab Apple 235	747 Detroit St	10	Side Yard : Yard 17	Tree 1	Private 1			1			5999417.485309999	2095405.5962	37.73355085827271	-122.44440972944099	(37.7335508582727, -122.444409729441)
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)
25897	25897	134510	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	9	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6008017.687530001	2112101.62184	37.7798812789472	-122.415858138542	(37.7798812789472, -122.415858138542)
27927	27927	247528	Undocumented 2	Quercus agrifolia :: Coast Live Oak 180	1101 Waller St	9	Side Yard : Yard 17	Tree 1	Private 1			2			6000060.08033	2108486.82414	37.7695053822964	-122.443127261125	(37.7695053822964, -122.443127261125)
30032	30032	247924	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	9	Side Yard : Yard 17	Tree 1	Private 1			23			6010297.695230001	2098727.78354	37.7432876562154	-122.40702762254499	(37.7432876562154, -122.407027622545)
38547	38547	196063	Undocumented 2	Prunus spp :: Cherry 84	1751 22nd St	9	Side Yard : Yard 17	Tree 1	Private 1			3	Width 5ft		6012868.1198	2103766.18767	37.757265535503	-122.39849317144501	(37.757265535503, -122.398493171445)
46836	46836	136715	Undocumented 2	Taxus baccata :: Irish Yew 241	1599 North Point St	9	Side Yard : Yard 17	Tree 1	Private 1			9	Width 7ft		6003190.857480001	2120979.91426	37.803986257417	-122.43319081820499	(37.803986257417, -122.433190818205)
49010	49010	227460	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	198 Corbin Pl	9	Side Yard : Yard 17	Tree 1	Private 1			13	Width 3ft		6000080.81195	2105721.26672	37.7619130330842	-122.442856931222	(37.7619130330842, -122.442856931222)
55107	55107	208887	Undocumented 2	Malus :: Crab Apple 235	747 Detroit St	9	Side Yard : Yard 17	Tree 1	Private 1			5			5999422.56432	2095411.3960400003	37.733567073059895	-122.44439258657302	(37.7335670730599, -122.444392586573)
64330	64330	236093	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	200 Corbin Pl	9	Side Yard : Yard 17	Tree 1	Private 1			11	Width 3ft		6000063.11815	2105682.66467	37.7618060326498	-122.44291535476201	(37.7618060326498, -122.442915354762)
70150	70150	248180	Undocumented 2	Myoporum laetum :: Myoporum 1	218 Esmeralda Ave	9	Side Yard : Yard 17	Tree 1	Private 1			14			6007468.18996	2098662.76578	37.7429503870626	-122.416806737143	(37.7429503870626, -122.416806737143)
70995	70995	246659	Undocumented 2	Betula pendula :: European White Birch 146	3351 Harrison St	9	Side Yard : Yard 17	Tree 1	Private 1			3			6009067.50483	2099233.3158299997	37.74460681865239	-122.411317022686	(37.7446068186524, -122.411317022686)
77276	77276	176283	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	35 Tomaso Ct	9	Side Yard : Yard 17	Tree 1	Private 1			8	Width 3ft		6009206.42472	2086339.2337599997	37.7092101890802	-122.40992661863999	(37.7092101890802, -122.40992661864)
131189	131189	179497	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	653 Peru Ave	9	Side Yard : Yard 17	Tree 1	Private 1			8			6005046.66321	2092646.92983	37.7262957476241	-122.424751842734	(37.7262957476241, -122.424751842734)
133323	133323	132438	Undocumented 2	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	943 Green St	9	Side Yard : Yard 17	Tree 1	Private 1			6			6008636.9513	2118981.46679	37.798806453817896	-122.414202710601	(37.7988064538179, -122.414202710601)
147259	147259	132299	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	2836 Larkin St	9	Side Yard : Yard 17	Tree 1	Private 1			6			6006506.76363	2120995.98891	37.8042179371566	-122.421717028328	(37.8042179371566, -122.421717028328)
154255	154255	247009	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	401 Valley St	9	Side Yard : Yard 17	Tree 1	Private 1			13	Width 8ft		6003278.48209	2099193.13161	37.744170100676996	-122.431331435716	(37.744170100677, -122.431331435716)
166394	166394	250229	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	312 Filbert St	9	Side Yard : Yard 17	Tree 1	Private 1			20	Width 0ft		6011206.629819999	2120043.6184099996	37.8018668665295	-122.405385582777	(37.8018668665295, -122.405385582777)
174997	174997	176989	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	184 Mount Vernon Ave	9	Side Yard : Yard 17	Tree 1	Private 1			14			5998947.7718	2089388.6360799999	37.717002872174504	-122.445601123393	(37.7170028721745, -122.445601123393)
179689	179689	176336	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	287 Hester Ave	9	Side Yard : Yard 17	Tree 1	Private 1			31			6012249.60162	2087766.47281	37.713299190589794	-122.39950899437001	(37.7132991905898, -122.39950899437)
186195	186195	196068	Undocumented 2	Prunus spp :: Cherry 84	1700 Armstrong Ave	9	Side Yard : Yard 17	Tree 1	Private 1			3			6013885.20395	2092887.6121599998	37.727451852204204	-122.39421406314399	(37.7274518522042, -122.394214063144)
186431	186431	211852	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	714 Detroit St	9	Side Yard : Yard 17	Tree 1	Private 1			3			5999466.29609	2095415.22212	37.7335800736498	-122.44424166861602	(37.7335800736498, -122.444241668616)
188928	188928	248190	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	216 Esmeralda Ave	9	Side Yard : Yard 17	Tree 1	Private 1			8			6007395.06383	2098734.36623	37.7431428725527	-122.41706466002701	(37.7431428725527, -122.417064660027)
3743	3743	175363	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	8	Side Yard : Yard 17	Tree 1	Private 1			3	Width 5ft		5993226.79298	2087801.79474	37.71231750501779	-122.465260429219	(37.7123175050178, -122.465260429219)

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