Street_Tree_List

Data source: data.sfgov.org

101 rows where qLegalStatus = 6 and qSiteInfo = 9

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: qSpecies, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
272	272	251264	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
277	277	251265	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
293	293	251262	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
300	300	251263	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
1025	1025	251425	Significant Tree 6	Pittosporum spp :: Pittosporum spp 128	5016 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999555.0	2100128.0	37.7465253005744	-122.444273545879	(37.7465253005744, -122.444273545879)
1027	1027	251426	Significant Tree 6	Pinus radiata :: Monterey Pine 3	5020 Diamond Heights Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999455.0	2100046.0	37.7462944425817	-122.44461344107401	(37.7462944425817, -122.444613441074)
1030	1030	251424	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	5016 Diamond Heights Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5999555.0	2100128.0	37.7465253005744	-122.444273545879	(37.7465253005744, -122.444273545879)
1956	1956	252838	Significant Tree 6	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	99 Pond St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6003330.0	2106021.0	37.7629207320267	-122.43164067381399	(37.7629207320267, -122.431640673814)
2003	2003	127110	Significant Tree 6	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3201 Laguna St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 6ft		6003718.35126	2119752.0994	37.8006449063974	-122.431277695812	(37.8006449063974, -122.431277695812)
2059	2059	173596	Significant Tree 6	Tree(s) :: 17	200 Howard St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3	Permit Number 779179	6014439.0	2115766.0	37.790301726009204	-122.393900378517	(37.7903017260092, -122.393900378517)
3147	3147	253098	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1290 Portola Dr	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2		08/22/2017 12:00:00 AM	3	3x3		5994035.0	2097938.0	37.740195634398	-122.463202075736	(37.740195634398, -122.463202075736)
3158	3158	253097	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1290 Portola Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	DPW 4	08/22/2017 12:00:00 AM	3	3x3		5994035.0	2097938.0	37.740195634398	-122.463202075736	(37.740195634398, -122.463202075736)
3799	3799	178336	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	2	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			29	Width 8ft		5998664.9682	2091522.93582	37.722847017548204	-122.44673211618999	(37.7228470175482, -122.44673211619)
3801	3801	177109	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	16	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			6	Width 5ft		5998958.08532	2091518.52367	37.72285164275971	-122.445718558684	(37.7228516427597, -122.445718558684)
3803	3803	178335	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	1	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			33	Width 8ft		5998656.04486	2091523.1214700001	37.72284701755029	-122.44676297552601	(37.7228470175503, -122.446762975526)
3805	3805	177105	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	12	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			4	Width 5ft		5998924.5969	2091518.7811599998	37.7228504376811	-122.445834339179	(37.7228504376811, -122.445834339179)
3806	3806	177110	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	17	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			6	Width 5ft		5998978.57855	2091518.5364400002	37.722852847868	-122.445647719081	(37.722852847868, -122.445647719081)
3808	3808	177108	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	15	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			5	Width 5ft		5998950.80755	2091518.23612	37.7228504376851	-122.44574369563999	(37.7228504376851, -122.44574369564)
3811	3811	177743	Significant Tree 6	Metrosideros excelsa :: New Zealand Xmas Tree 2	401 Ocean Ave	4	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			37			5998700.41574	2091522.98281	37.722849171448395	-122.446609585371	(37.7228491714484, -122.446609585371)
3818	3818	178337	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	3	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			29			5998676.28102	2091524.0079700002	37.7228506076618	-122.44669308741301	(37.7228506076618, -122.446693087413)
3826	3826	177104	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	11	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			4	Width 5ft		5998921.0818300005	2091519.29315	37.722851642780796	-122.44584652679501	(37.7228516427808, -122.445846526795)
3827	3827	177106	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	13	Sidewalk: Property side : Yard 9	Tree 1	MTA 6			7	Width 5ft		5998933.177730001	2091518.16383	37.7228492325857	-122.44580463279199	(37.7228492325857, -122.445804632792)
4549	4549	226945	Significant Tree 6	Juniperus chinensis :: Juniper 19	998 Chenery St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 1ft		6001140.61217	2096125.6115299999	37.735626018710896	-122.438503967885	(37.7356260187109, -122.438503967885)
4659	4659	253652	Significant Tree 6	Pinus radiata :: Monterey Pine 3	131 Font Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				10x10		5990844.0	2088883.0	37.7151485301311	-122.473574812248	(37.7151485301311, -122.473574812248)
10208	10208	173903	Significant Tree 6	Pinus radiata :: Monterey Pine 3	675 Corbett Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999984.0	2103563.0	37.7559814441149	-122.44303676104799	(37.7559814441149, -122.443036761048)
18031	18031	96327	Significant Tree 6	Cordyline australis :: Dracena Palm 141	296 Randall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 767829	6003708.0	2097940.0	37.7407536226533	-122.429756895294	(37.7407536226533, -122.429756895294)
18402	18402	48402	Significant Tree 6	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	706 Wisconsin St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		11/19/2010 12:00:00 AM			Permit Number 53935	6012689.64928807	2104214.1545054	37.7584856101735	-122.399141839868	(37.7584856101735, -122.399141839868)
22892	22892	251144	Significant Tree 6	Eucalyptus globulus :: Blue Gum 103	200X Clarendon Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5996559.0	2104265.0	37.7577130831875	-122.454932197022	(37.7577130831875, -122.454932197022)
22896	22896	251145	Significant Tree 6	Eucalyptus globulus :: Blue Gum 103	200X Clarendon Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5996559.0	2104265.0	37.7577130831875	-122.454932197022	(37.7577130831875, -122.454932197022)
43173	43173	112929	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
78153	78153	104715	Significant Tree 6	Juniperus chinensis :: Juniper 19	3618 22nd St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 770676	6004228.3	2103103.8	37.7549616692716	-122.42832583872601	(37.7549616692716, -122.428325838726)
78522	78522	112919	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
79584	79584	116089	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	98x WOODWARD ST	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6006422.0	2107919.0	37.7683069672649	-122.421081271108	(37.7683069672649, -122.421081271108)
79699	79699	110954	Significant Tree 6	Pinus radiata :: Monterey Pine 3	126X Mendell St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		05/12/2015 12:00:00 AM	3			6017060.745069999	2098543.2218400002	37.74315702656929	-122.38362967653299	(37.7431570265693, -122.383629676533)
80719	80719	116576	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	2500x OCEAN AVE	1	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	DPW 4		30	10X10		5991377.0	2094742.0	37.7312667472315	-122.472159374256	(37.7312667472315, -122.472159374256)
81040	81040	112918	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
81189	81189	98546	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	555@Rio Teresita Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999006.5	2097247.3	37.7385842819574	-122.445963035448	(37.7385842819574, -122.445963035448)
82216	82216	116521	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	70 BEAUMONT AVE	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	3x3		5996728.0	2112568.0	37.7805206716372	-122.454947659336	(37.7805206716372, -122.454947659336)
85138	85138	103617	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	201X Haight St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004725.0	2109149.0	37.7715884407354	-122.427038651796	(37.7715884407354, -122.427038651796)
85824	85824	112921	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
86774	86774	122640	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630X 19th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x8		5990614.0	2091411.0	37.7220764711857	-122.47455416918999	(37.7220764711857, -122.47455416919)
87738	87738	87239	Significant Tree 6	Tree(s) :: 17	233 Arbor St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		02/14/2008 12:00:00 AM			Permit Number 50269	6001330.0	2096776.0	37.737422605415205	-122.43789575270901	(37.7374226054152, -122.437895752709)
88130	88130	98104	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1@Carl Irving St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			5995817.2	2106753.3	37.7645027364821	-122.45767767256001	(37.7645027364821, -122.45767767256)
88391	88391	122637	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630X 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x8		5990614.0	2091411.0	37.7220764711857	-122.47455416918999	(37.7220764711857, -122.47455416919)
89530	89530	112922	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
90764	90764	103616	Significant Tree 6	Pittosporum crassifolium :: Karo Tree 108	201X Haight St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004725.0	2109149.0	37.7715884407354	-122.427038651796	(37.7715884407354, -122.427038651796)
91700	91700	95229	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	1@Carl Irving St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1		11/16/2010 12:00:00 AM	15			5995817.2	2106753.3	37.7645027364821	-122.45767767256001	(37.7645027364821, -122.45767767256)
91819	91819	122638	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630X 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x8		5990614.0	2091411.0	37.7220764711857	-122.47455416918999	(37.7220764711857, -122.47455416919)
92995	92995	105436	Significant Tree 6	Tree(s) :: 17	610 PARNASSUS AVE	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1		03/05/2014 12:00:00 AM	15		Permit Number 771221	5995151.3	2106193.4	37.762927120328996	-122.459940260935	(37.762927120329, -122.459940260935)
93393	93393	103615	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
95242	95242	106255	Significant Tree 6	Tree(s) :: 17	1900X 18th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 770844	6012067.0	2105610.0	37.7622835736204	-122.40139334750201	(37.7622835736204, -122.401393347502)
96595	96595	106311	Significant Tree 6	Pinus canariensis :: Canary Island Pine 71	99X Clearfield Dr	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/15/2014 12:00:00 AM			Permit Number 772542	5985798.26078	2095453.4648400003	37.73289581695511	-122.49149816384899	(37.7328958169551, -122.491498163849)
96813	96813	112924	Significant Tree 6	Pinus radiata :: Monterey Pine 3	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1						6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
97963	97963	104717	Significant Tree 6	Juniperus chinensis :: Juniper 19	3618 22nd St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 770676	6004228.3	2103103.8	37.7549616692716	-122.42832583872601	(37.7549616692716, -122.428325838726)
100197	100197	103618	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	201X Haight St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004725.0	2109149.0	37.7715884407354	-122.427038651796	(37.7715884407354, -122.427038651796)
100331	100331	112930	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
100567	100567	103612	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
103243	103243	116088	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	98x WOODWARD ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6006422.0	2107919.0	37.7683069672649	-122.421081271108	(37.7683069672649, -122.421081271108)
104669	104669	95231	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	1@Carl Irving St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1		11/16/2010 12:00:00 AM				5995817.2	2106753.3	37.7645027364821	-122.45767767256001	(37.7645027364821, -122.45767767256)
105512	105512	105130	Significant Tree 6	Tree(s) :: 17	4045 MORAGA ST		Sidewalk: Property side : Yard 9	Tree 1	Private 1						5981665.2	2103465.9	37.7546533409301	-122.506380933635	(37.7546533409301, -122.506380933635)
106567	106567	106109	Significant Tree 6	Magnolia champaca :: Champa 170	135 MENDOSA AVE	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/23/2014 12:00:00 AM			Permit Number 772704	5992893.2	2100790.2	37.747961208182	-122.467357269235	(37.747961208182, -122.467357269235)
107866	107866	112769	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
107871	107871	116087	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	98x WOODWARD ST	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6006422.0	2107919.0	37.7683069672649	-122.421081271108	(37.7683069672649, -122.421081271108)
111177	111177	110952	Significant Tree 6	Pinus radiata :: Monterey Pine 3	220 Newhall St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1		05/12/2015 12:00:00 AM	3			6016803.8	2098347.9	37.7426065069695	-122.38450453105301	(37.7426065069695, -122.384504531053)
111205	111205	112771	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
111635	111635	110951	Significant Tree 6	Pinus radiata :: Monterey Pine 3	220 Newhall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		05/12/2015 12:00:00 AM	3			6016803.8	2098347.9	37.7426065069695	-122.38450453105301	(37.7426065069695, -122.384504531053)
111811	111811	112770	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
112127	112127	110953	Significant Tree 6	Pinus radiata :: Monterey Pine 3	220 Newhall St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1		05/12/2015 12:00:00 AM	3			6016803.8	2098347.9	37.7426065069695	-122.38450453105301	(37.7426065069695, -122.384504531053)
112482	112482	112773	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
112529	112529	104716	Significant Tree 6	Juniperus chinensis :: Juniper 19	3618 22nd St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 770676	6004228.3	2103103.8	37.7549616692716	-122.42832583872601	(37.7549616692716, -122.428325838726)
114318	114318	103614	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
115212	115212	112774	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
115520	115520	112925	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
115705	115705	117417	Significant Tree 6	Magnolia grandiflora :: Southern Magnolia 21	2835 Washington St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x10	Permit Number 778177	6001153.1	2116153.5	37.790618387033206	-122.439896334555	(37.7906183870332, -122.439896334555)
116414	116414	98290	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
117806	117806	110559	Significant Tree 6	Platanus x hispanica :: Sycamore: London Plane 15	320x FULTON ST	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				10x36		6006080.0	2112015.0	37.7795343118474	-122.422555311635	(37.7795343118474, -122.422555311635)
117865	117865	112928	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
118196	118196	102589	Significant Tree 6	Pinus radiata :: Monterey Pine 3	5157 Diamond Heights Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6000788.8	2100195.2	37.7467801300642	-122.440012028415	(37.7467801300642, -122.440012028415)
118710	118710	105850	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	44 MENDOSA AVE	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			100	6x15		5993395.1	2101192.7	37.7490953323683	-122.465650972372	(37.7490953323683, -122.465650972372)
119061	119061	98288	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
119294	119294	92055	Significant Tree 6	Quercus agrifolia :: Coast Live Oak 180	1001 Potrero Ave		Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 52180	6010509.9	2103658.3	37.7568376430251	-122.406641253674	(37.7568376430251, -122.406641253674)
119616	119616	110560	Significant Tree 6	Platanus x hispanica :: Sycamore: London Plane 15	320x FULTON ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				10x36		6006080.0	2112015.0	37.7795343118474	-122.422555311635	(37.7795343118474, -122.422555311635)
120114	120114	122639	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630X 19th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x8		5990614.0	2091411.0	37.7220764711857	-122.47455416918999	(37.7220764711857, -122.47455416919)
120703	120703	105435	Significant Tree 6	Tree(s) :: 17	610 PARNASSUS AVE	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		03/05/2014 12:00:00 AM	16		Permit Number 771221	5995151.3	2106193.4	37.762927120328996	-122.459940260935	(37.762927120329, -122.459940260935)
121815	121815	112772	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
122346	122346	87242	Significant Tree 6	Pinus radiata :: Monterey Pine 3	4131 Geary Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 50271	5994116.9	2112250.5	37.779498769084604	-122.46395756623998	(37.7794987690846, -122.46395756624)
122520	122520	100850	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1 Estero Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5992057.7	2091642.6	37.7227959320346	-122.469580550695	(37.7227959320346, -122.469580550695)
122848	122848	96328	Significant Tree 6	Cordyline australis :: Dracena Palm 141	296 Randall St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 767829	6003708.0	2097940.0	37.7407536226533	-122.429756895294	(37.7407536226533, -122.429756895294)
123605	123605	92056	Significant Tree 6	Quercus agrifolia :: Coast Live Oak 180	1001 Potrero Ave		Sidewalk: Property side : Yard 9	Tree 1	Private 1		06/16/2009 12:00:00 AM			Permit Number 52180	6010509.9	2103658.3	37.7568376430251	-122.406641253674	(37.7568376430251, -122.406641253674)
125535	125535	116090	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	98x WOODWARD ST	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6006422.0	2107919.0	37.7683069672649	-122.421081271108	(37.7683069672649, -122.421081271108)
127682	127682	98289	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
128076	128076	112923	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
138814	138814	103611	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
140824	140824	112927	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
141641	141641	112926	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM		3x3	Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
142007	142007	106310	Significant Tree 6	Pinus canariensis :: Canary Island Pine 71	99X Clearfield Dr	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/15/2014 12:00:00 AM			Permit Number 772542	5985798.26078	2095453.4648400003	37.73289581695511	-122.49149816384899	(37.7328958169551, -122.491498163849)
142904	142904	112920	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	2X Noe St		Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/27/2015 12:00:00 AM			Permit Number 775129	6002836.07968	2107997.59158	37.7683199626551	-122.43349023202299	(37.7683199626551, -122.433490232023)
143283	143283	106107	Significant Tree 6	Magnolia champaca :: Champa 170	135 MENDOSA AVE	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/23/2014 12:00:00 AM			Permit Number 772704	5992893.2	2100790.2	37.747961208182	-122.467357269235	(37.747961208182, -122.467357269235)
144880	144880	103613	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
150859	150859	106257	Significant Tree 6	Platanus x hispanica :: Sycamore: London Plane 15	1900X 18th St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13		Permit Number 770844	6011994.4738300005	2105627.58235	37.762327804017296	-122.401645425613	(37.7623278040173, -122.401645425613)

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