Street_Tree_List

Data source: data.sfgov.org

221 rows where qSiteInfo = 2 and qSpecies = 12 sorted by TreeID

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, qCaretaker, PlantDate, DBH, PlotSize

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
9944	9944	11821	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
9947	9947	11824	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	PUC 13		03/13/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
126914	126914	94321	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
98037	98037	94322	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
108814	108814	94323	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
80442	80442	94324	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
105503	105503	94325	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
9935	9935	102960	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9934	9934	102961	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9939	9939	102963	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
91005	91005	102964	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9936	9936	102965	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	9	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9937	9937	102966	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9943	9943	102967	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9941	9941	102968	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	11	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9940	9940	102969	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9945	9945	102971	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
50724	50724	117724	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3807 Clement St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5983695.80801	2113107.7727799998	37.7812465132964	-122.50007137587299	(37.7812465132964, -122.500071375873)
135747	135747	117747	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	429 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5983737.9655	2112912.98734	37.780714163442894	-122.499911131684	(37.7807141634429, -122.499911131684)
64101	64101	117753	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5983731.68525	2113087.1052599996	37.781191871869204	-122.499945732105	(37.7811918718692, -122.499945732105)
152935	152935	117770	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984040.53311	2113104.0044	37.781256392087606	-122.498878537141	(37.7812563920876, -122.498878537141)
177515	177515	117771	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5984040.463409999	2113093.42371	37.781227336507705	-122.498877996337	(37.7812273365077, -122.498877996337)
51176	51176	117772	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 38th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5984041.4273	2113087.33396	37.7812106723648	-122.498874211765	(37.7812106723648, -122.498874211765)
135636	135636	117968	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984091.8335	2113030.1543400004	37.781056630188104	-122.498695608696	(37.7810566301881, -122.498695608696)
135404	135404	117969	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984091.66198	2113022.12438	37.7810345721966	-122.49869560869	(37.7810345721966, -122.49869560869)
66855	66855	117970	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984091.49705	2113014.4032900003	37.7810133626585	-122.49869560870899	(37.7810133626585, -122.498695608709)
45136	45136	117971	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5984092.80379	2113002.94295	37.780981972540395	-122.498690241264	(37.7809819725404, -122.498690241264)
152915	152915	117972	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	420 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984093.27919	2112967.0901900004	37.780883559180104	-122.498685947337	(37.7808835591801, -122.498685947337)
33202	33202	117973	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	420 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5984092.99553	2112953.81003	37.78084707909	-122.49868594731701	(37.78084707909, -122.498685947317)
75338	75338	118040	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3515 Clement St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5984557.88684	2113139.91684	37.781385328692295	-122.49709142693001	(37.7813853286923, -122.49709142693)
63000	63000	118045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3651 Clement St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5984110.5996900005	2113123.7061799997	37.7813145968988	-122.49863760087901	(37.7813145968988, -122.498637600879)
133215	133215	118534	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	7915 Geary Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5982448.31014	2112345.83773	37.7790811700363	-122.504330568895	(37.7790811700363, -122.504330568895)
51413	51413	118535	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	7915 Geary Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5982438.45196	2112345.43604	37.7790794873063	-122.50436464200199	(37.7790794873063, -122.504364642002)
171033	171033	119594	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3145 Cabrillo St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5985824.5308	2110420.315	37.7739922254809	-122.492509174554	(37.7739922254809, -122.492509174554)
158059	158059	120756	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	33 20th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5989560.64886	2114955.0041900002	37.7866609499601	-122.479917366138	(37.7866609499601, -122.479917366138)
65874	65874	122161	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	553 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5991248.67399	2111631.4725	37.7776333766017	-122.473834708977	(37.7776333766017, -122.473834708977)
50211	50211	123359	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	746 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994762.8096900005	2110492.85226	37.7747099388562	-122.46159563840901	(37.7747099388562, -122.461595638409)
147559	147559	124079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	701 Funston Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5991941.58389	2110150.4186299997	37.7736069135372	-122.471329782846	(37.7736069135372, -122.471329782846)
150936	150936	125586	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1570 Greenwich St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6005351.57668	2119600.69848	37.800321618997295	-122.425615279117	(37.8003216189973, -122.425615279117)
165504	165504	125598	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	55 Laurel St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5997962.54777	2116175.89912	37.790497754121795	-122.450937027734	(37.7904977541218, -122.450937027734)
27130	27130	125607	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3598 Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5997695.059280001	2115464.41968	37.7885289043451	-122.45181116876002	(37.7885289043451, -122.45181116876)
25544	25544	125658	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	481 Polk St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6007176.96722	2112501.79124	37.7809327473806	-122.418794957434	(37.7809327473806, -122.418794957434)
49921	49921	140789	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	73 COMMONWEALTH AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996497.6882	2114040.8979	37.78455164386521	-122.455850917712	(37.7845516438652, -122.455850917712)
50546	50546	175255	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	623 London St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6001218.45096	2090165.8751700001	37.7192663722334	-122.43780813275801	(37.7192663722334, -122.437808132758)
70348	70348	175268	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	17 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6000541.31656	2088471.1421	37.7145744894882	-122.440027270142	(37.7145744894882, -122.440027270142)
56647	56647	175274	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Brunswick St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6001024.26555	2087488.4047299998	37.7119035929554	-122.438287644984	(37.7119035929554, -122.438287644984)
71622	71622	175285	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Olmstead St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		6010704.73668	2090949.18251	37.7219520302409	-122.40507257466001	(37.7219520302409, -122.40507257466)
151763	151763	175286	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	325 Olmstead St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		6010711.19323	2090926.76022	37.721890824193004	-122.405048677871	(37.721890824193, -122.405048677871)
73739	73739	175291	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009654.09319	2090160.7223599998	37.7197282927946	-122.40864880611	(37.7197282927946, -122.40864880611)
55626	55626	175292	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009643.78168	2090157.44944	37.7197187285063	-122.40868421872	(37.7197187285063, -122.40868421872)
54129	54129	175293	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6009631.71188	2090153.71455	37.719707797252	-122.408725676556	(37.719707797252, -122.408725676556)
188874	188874	175294	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6009619.4023	2090150.4820700001	37.7196982320664	-122.408767998643	(37.7196982320664, -122.408767998643)
48479	48479	175295	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6009602.37667	2090145.4297599997	37.719683405831596	-122.408826494165	(37.7196834058316, -122.408826494165)
148220	148220	175296	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6009588.23355	2090141.41392	37.7196715869614	-122.40887509890499	(37.7196715869614, -122.408875098905)
165533	165533	175297	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	800 Mansell St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009452.06912	2090099.6823599997	37.7195493726733	-122.409342829102	(37.7195493726733, -122.409342829102)
157133	157133	175298	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1498 Geneva Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6002915.8546400005	2087711.61866	37.712623896842295	-122.431765713815	(37.7126238968423, -122.431765713815)
57453	57453	175343	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Rhine St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5994542.86208	2086742.78517	37.709485521912605	-122.460635037876	(37.7094855219126, -122.460635037876)
188007	188007	175344	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993634.16802	2087703.44428	37.7120709424008	-122.463845295648	(37.7120709424008, -122.463845295648)
175356	175356	175345	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993607.01879	2087723.8804799998	37.7121254907785	-122.463940612974	(37.7121254907785, -122.463940612974)
30613	30613	175346	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993589.7174	2087738.26685	37.712163995237105	-122.464001454798	(37.7121639952371, -122.464001454798)
35642	35642	175347	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993550.997219999	2087766.5420799998	37.712239400706395	-122.464137333384	(37.7122394007064, -122.464137333384)
165131	165131	175348	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993488.42633	2087804.6670900001	37.7123404763923	-122.464356361476	(37.7123404763923, -122.464356361476)
171715	171715	175349	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993438.390819999	2087824.9996200001	37.7123934203956	-122.4645307733	(37.7123934203956, -122.4645307733)
77205	77205	175350	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993275.80872	2087878.6636599998	37.7125313952921	-122.46509659705099	(37.7125313952921, -122.465096597051)
129800	129800	175351	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993236.647480001	2087885.91358	37.7125490435751	-122.465232475607	(37.7125490435751, -122.465232475607)
28433	28433	175352	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993139.4707	2087896.7194400001	37.7125731094281	-122.46556913053301	(37.7125731094281, -122.465569130533)
54006	54006	175353	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992903.53374	2087894.08049	37.712552252365796	-122.466384403718	(37.7125522523658, -122.466384403718)
185937	185937	175354	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5992875.91855	2087892.32357	37.712545834802604	-122.46647972197901	(37.7125458348026, -122.466479721979)
152811	152811	175355	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		5992860.6815599995	2087893.2281099998	37.7125474391986	-122.46653245101001	(37.7125474391986, -122.46653245101)
2716	2716	175362	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5993185.52762	2087808.44828	37.7123333942447	-122.46540353654	(37.7123333942447, -122.46540353654)
2709	2709	175364	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993263.021319999	2087797.41727	37.7123075747038	-122.465134896479	(37.7123075747038, -122.465134896479)
2702	2702	175365	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5993296.25394	2087788.76232	37.712285726578	-122.465019407322	(37.712285726578, -122.465019407322)
2705	2705	175366	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993316.47827	2087783.2739799998	37.7122718230516	-122.464949108223	(37.7122718230516, -122.464949108223)
2703	2703	175367	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993394.31846	2087754.15211	37.7121963492565	-122.464677958129	(37.7121963492565, -122.464677958129)
2722	2722	175368	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993415.10175	2087740.6954	37.7121605985029	-122.464605149022	(37.7121605985029, -122.464605149022)
2720	2720	175369	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993431.63462	2087732.39125	37.7121387503812	-122.46454740445101	(37.7121387503812, -122.464547404451)
2708	2708	175370	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993448.13741	2087722.6413599998	37.712112930839	-122.464489658971	(37.712112930839, -122.464489658971)
2721	2721	175371	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993471.88559	2087712.01586	37.712085124705204	-122.464406808033	(37.7120851247052, -122.464406808033)
27670	27670	175373	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991419.90979	2088711.03664	37.714709696259	-122.47157171488001	(37.714709696259, -122.47157171488)
50475	50475	175375	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991400.23386	2088781.3625299998	37.714901655675995	-122.471644844135	(37.714901655676, -122.471644844135)
134460	134460	175544	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001192.72242	2087375.86302	37.7116041582787	-122.437697356964	(37.7116041582787, -122.437697356964)
65186	65186	175545	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001219.37593	2087363.7539	37.7115724247979	-122.437604368864	(37.7115724247979, -122.437604368864)
132141	132141	175546	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	298 Cordova St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		6001847.622269999	2087157.43402	37.7110416161394	-122.435418236567	(37.7110416161394, -122.435418236567)
186888	186888	175547	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	348 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6002373.36986	2086487.8856799998	37.709233027364995	-122.433553309758	(37.709233027365, -122.433553309758)
148859	148859	181851	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2301 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988541.8992	2099607.3772	37.744461328811	-122.482317054002	(37.744461328811, -122.482317054002)
182404	182404	182722	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1723 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985925.1892	2103477.2512	37.754934393373496	-122.49164978734801	(37.7549343933735, -122.491649787348)
125056	125056	183143	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2315 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984514.4702	2099409.3038	37.743682379514496	-122.49622825542	(37.7436823795145, -122.49622825542)
45706	45706	183641	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1484 47th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5981572.5337	2105003.3239	37.7588692133791	-122.50681542120701	(37.7588692133791, -122.506815421207)
154783	154783	183727	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2255 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985430.1991	2099855.1597	37.744960177470205	-122.493094769051	(37.7449601774702, -122.493094769051)
65600	65600	183836	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2217 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5987592.2696	2100164.3317	37.7459352931926	-122.485641503597	(37.7459352931926, -122.485641503597)
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)
41231	41231	184943	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983564.899	2101252.9532	37.7486888648876	-122.49964782319401	(37.7486888648876, -122.499647823194)
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)
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)
134243	134243	184946	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.8532	2101319.6223	37.7488717410938	-122.49966328209801	(37.7488717410938, -122.499663282098)
154638	154638	184947	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983560.8379	2101339.2508	37.7489255759542	-122.49966824346701	(37.7489255759542, -122.499668243467)
147983	147983	184948	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.1763	2101354.4797	37.7489674101607	-122.49966819869101	(37.7489674101607, -122.499668198691)
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)
70157	70157	184950	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983557.7921	2101427.5789	37.749167921775296	-122.499685303057	(37.7491679217753, -122.499685303057)
129935	129935	184951	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101452.6221	37.7492366040439	-122.49969183478001	(37.7492366040439, -122.49969183478)

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