Street_Tree_List

Data source: data.sfgov.org

116 rows where DBH = 1 and qSpecies = 48 sorted by qAddress

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
11046	11046	116538	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	1	Median : Yard 3	Tree 1	DPW 2			1	3x3		6001578.1015800005	2088233.43486	37.7139807660769	-122.436426724612	(37.7139807660769, -122.436426724612)
64913	64913	201811	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Friedell St	2	: 4	Tree 1	Private 1			1	Width 6ft		6021050.71889	2093203.62599	37.7287152512926	-122.369464359799	(37.7287152512926, -122.369464359799)
65062	65062	201810	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6021035.70856	2093179.8039900002	37.7286490171175	-122.369514606714	(37.7286490171175, -122.369514606714)
178920	178920	201812	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Friedell St	3	: 4	Tree 1	Private 1			1	Width 6ft		6021065.67541	2093224.76894	37.728774126326705	-122.369414113788	(37.7287741263267, -122.369414113788)
52877	52877	118595	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Point Lobos Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982415.15882	2112561.71552	37.7796719571588	-122.504461248614	(37.7796719571588, -122.504461248614)
25668	25668	118581	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	104 Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982478.43556	2112606.9372400003	37.7797998443253	-122.504245701476	(37.7797998443253, -122.504245701476)
104217	104217	191223	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1112 De Haro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6012178.19052	2103217.19746	37.7557196692435	-122.400840661869	(37.7557196692435, -122.400840661869)
71244	71244	227084	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1217 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010060.56336	2102014.9446799997	37.7523002058063	-122.408079341009	(37.7523002058063, -122.408079341009)
50178	50178	206987	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1248 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5992091.43933	2106913.6178900003	37.7647281934706	-122.47057562128799	(37.7647281934706, -122.470575621288)
31111	31111	207007	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	127 Westgate Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993382.1086800005	2093854.3174299998	37.7289452232334	-122.465162955333	(37.7289452232334, -122.465162955333)
41737	41737	183303	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1286 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5982766.9656	2106385.9546	37.7627357893861	-122.502786935917	(37.7627357893861, -122.502786935917)
42609	42609	227117	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	129 Rousseau St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6003535.84775	2095026.7825099998	37.7327448417949	-122.430144356698	(37.7327448417949, -122.430144356698)
73895	73895	176887	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	13 Santa Rosa Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6002286.64114	2092541.4001799999	37.725849714484404	-122.434285547657	(37.7258497144844, -122.434285547657)
138540	138540	176888	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	13 Santa Rosa Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002306.40089	2092528.2983099998	37.7258148612434	-122.43421630345301	(37.7258148612434, -122.434216303453)
148929	148929	63095	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1314 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/04/2016 12:00:00 AM	1		Permit Number 775034	5982157.61974918	2106142.20642168	37.7620306969809	-122.504876348182	(37.7620306969809, -122.504876348182)
135392	135392	181684	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1347 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986459.3313	2106064.8642	37.7620704697574	-122.48999290967501	(37.7620704697574, -122.489992909675)
167111	167111	92440	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1352 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/30/2009 12:00:00 AM	1	3x3	Permit Number 52830	5982162.933999999	2105885.2573	37.7613255007309	-122.504838927947	(37.7613255007309, -122.504838927947)
30724	30724	92441	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1368 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/30/2009 12:00:00 AM	1	3x3	Permit Number 52832	5982163.8853	2105798.2136	37.7610865595393	-122.504829187778	(37.7610865595393, -122.504829187778)
178120	178120	181690	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1374 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5982168.1662	2105754.9295	37.760967965591604	-122.504811174863	(37.7609679655916, -122.504811174863)
131058	131058	227103	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	138 Rivoli St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5998021.55452	2105968.74453	37.7624749295086	-122.449996897152	(37.7624749295086, -122.449996897152)
24816	24816	47267	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1386 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/09/2002 12:00:00 AM	1		Permit Number 45208	5988680.1995	2105896.4201	37.7617374028544	-122.48229953296001	(37.7617374028544, -122.48229953296)
34436	34436	88394	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	139 25th Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM	1	3x3	Permit Number 51373	5988000.05712	2115038.19323	37.78679857243979	-122.485322676521	(37.7867985724398, -122.485322676521)
166344	166344	118587	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	140 Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982334.052630001	2112627.33977	37.7798473711823	-122.504746689196	(37.7798473711823, -122.504746689196)
117673	117673	140302	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	143 COLE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5997780.8586	2110053.3207	37.773676357183	-122.45112394331899	(37.773676357183, -122.451123943319)
52529	52529	176915	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	143 Somerset St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6009701.03874	2093769.75693	37.7296405745301	-122.408741008189	(37.7296405745301, -122.408741008189)
171029	171029	191247	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1453 Hudson Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 6ft		6016461.47366	2096825.2224700002	37.7384066073881	-122.385582111127	(37.7384066073881, -122.385582111127)
156249	156249	206984	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1498 17th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990877.91026	2105249.91359	37.7600898599821	-122.47465142432199	(37.7600898599821, -122.474651424322)
157031	157031	206985	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1498 17th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990877.17813	2105275.0931700002	37.760158953986604	-122.474655794123	(37.7601589539866, -122.474655794123)
35959	35959	118588	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	150 Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982305.68238	2112631.11012	37.779856054488604	-122.50484511221701	(37.7798560544886, -122.504845112217)
133488	133488	118589	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	150 Point Lobos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982275.325019999	2112634.79146	37.779864376411	-122.50495040283998	(37.779864376411, -122.50495040284)
167364	167364	182307	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1509 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5987118.7965	2104973.5941	37.7591126281614	-122.487631931758	(37.7591126281614, -122.487631931758)
177014	177014	95521	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1510 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2011 12:00:00 AM	1	3x3	Permit Number 767313	5985302.4962	2104889.3961	37.7587753414156	-122.49390726731899	(37.7587753414156, -122.493907267319)
157408	157408	69788	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1526 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/27/2001 12:00:00 AM	1			5982204.5216	2104686.309	37.758035976388896	-122.50460626225299	(37.7580359763889, -122.504606262253)
58124	58124	206995	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1584 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993720.55073	2104714.02617	37.7587827556425	-122.464781251568	(37.7587827556425, -122.464781251568)
37433	37433	184723	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1635 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5983115.9866	2103988.5253	37.7561736313112	-122.501402462618	(37.7561736313112, -122.501402462618)
173458	173458	184640	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1650 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5983160.9711	2103902.0944	37.7559389581009	-122.501240500695	(37.7559389581009, -122.501240500695)
176471	176471	182700	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1651 Moraga St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5989102.9459	2103739.8915	37.7558407372502	-122.48067956122401	(37.7558407372502, -122.480679561224)
35420	35420	182699	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1659 Moraga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5989088.7291	2103739.8915	37.755839910949895	-122.480728726959	(37.7558399109499, -122.480728726959)
46405	46405	176898	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	167 Madison St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6005619.38027	2092788.13013	37.7267157831975	-122.42278201629601	(37.7267157831975, -122.422782016296)
66467	66467	176899	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	167 Madison St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6005613.54422	2092807.28897	37.7267680598911	-122.422803552358	(37.7267680598911, -122.422803552358)
75318	75318	176901	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	167 Madison St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6005600.43917	2092849.05844	37.7268820102711	-122.42285182346599	(37.7268820102711, -122.422851823466)
187445	187445	176900	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	167 Madison St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6005606.72127	2092829.9713400002	37.7268299557374	-122.42282875044701	(37.7268299557374, -122.422828750447)
46553	46553	95899	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1700 23rd Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2011 12:00:00 AM	1	3x3	Permit Number 767603	5989072.0669	2103701.2996	37.7557329794721	-122.480783524363	(37.7557329794721, -122.480783524363)
115830	115830	95897	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1700 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2011 12:00:00 AM	1	3x3	Permit Number 767603	5989075.8995	2103638.8826	37.7555618218669	-122.48076570081301	(37.7555618218669, -122.480765700813)
153240	153240	95898	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1700 23rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2011 12:00:00 AM	1	3x3	Permit Number 767603	5989073.1619	2103670.6386	37.755648856222	-122.48077749293999	(37.755648856222, -122.48077749294)
56558	56558	207005	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	171 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992787.45104	2098017.3287299997	37.7403415032629	-122.467521326669	(37.7403415032629, -122.467521326669)
70354	70354	207004	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	171 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992803.19794	2098037.0989599996	37.7403966964551	-122.46746831791	(37.7403966964551, -122.46746831791)
130143	130143	182826	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1781 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986558.6884	2103101.4836	37.7539396409234	-122.48943136928999	(37.7539396409234, -122.48943136929)
66926	66926	184599	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1795 40th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5983770.6594	2102984.6576	37.7534557168171	-122.499064248064	(37.7534557168171, -122.499064248064)
171120	171120	184598	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1795 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5983770.321	2103008.0087	37.7535198125919	-122.499067143504	(37.7535198125919, -122.499067143504)
27407	27407	98851	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1795X 31st Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/11/2012 12:00:00 AM	1	3x3	Permit Number 768753	5986486.2	2103095.0	37.7539176067687	-122.489681571094	(37.7539176067687, -122.489681571094)
35363	35363	98849	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1795X 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/11/2012 12:00:00 AM	1	3x3	Permit Number 768753	5986486.2	2103095.0	37.7539176067687	-122.489681571094	(37.7539176067687, -122.489681571094)
153201	153201	98850	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1795X 31st Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/11/2012 12:00:00 AM	1	3x3	Permit Number 768753	5986486.2	2103095.0	37.7539176067687	-122.489681571094	(37.7539176067687, -122.489681571094)
153218	153218	182607	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1867 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986269.2088	2102542.1488	37.7523869566931	-122.49039129916001	(37.7523869566931, -122.49039129916)
122015	122015	88207	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	187 Beaumont Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	1	3x3	Permit Number 51211	5996848.1239	2111670.4224	37.7780630497691	-122.454467238117	(37.7780630497691, -122.454467238117)
174137	174137	84659	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	187 Beaumont Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		1			5996845.0781	2111686.6666	37.7781074773999	-122.45447894833201	(37.7781074773999, -122.454478948332)
57165	57165	176885	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	191 Rey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008580.05361	2087004.5673599998	37.7110019335603	-122.412138452652	(37.7110019335603, -122.412138452652)
22291	22291	95431	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1938 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2011 12:00:00 AM	1	3x3	Permit Number 767296	5988810.2856	2102122.1786	37.7513819161329	-122.481573187512	(37.7513819161329, -122.481573187512)
38258	38258	113355	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	2 Point Lobos Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3X3		5982766.03998	2112575.4615	37.779730331527404	-122.503248436763	(37.7797303315274, -122.503248436763)
152469	152469	113356	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	2 Point Lobos Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3X3		5982735.90689	2112577.0088400003	37.7797328087219	-122.503352793138	(37.7797328087219, -122.503352793138)
76646	76646	46375	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	2214 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/09/2008 12:00:00 AM	1	3x3	Permit Number 51267	5982984.1214	2100027.2965	37.745289455195	-122.501565454542	(37.745289455195, -122.501565454542)
160731	160731	140699	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	224 ASHBURY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5998816.4363	2109919.7991	37.773368976906205	-122.447532121663	(37.7733689769062, -122.447532121663)
185807	185807	182658	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2242 Ortega St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5987004.6631	2102364.6195	37.751942436508706	-122.487834969288	(37.7519424365087, -122.487834969288)
28890	28890	182659	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2252 Ortega St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986985.3742	2102363.8158	37.7519391046129	-122.487901613135	(37.7519391046129, -122.487901613135)
159962	159962	207028	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	227 Ramsell St	1	: 4	Tree 1	Private 1			1	Width 3ft		5992956.15905	2088729.24095	37.7148484391912	-122.46626317241001	(37.7148484391912, -122.46626317241)
188215	188215	183121	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2327 41st Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5983581.7952	2099373.3538	37.7435289932417	-122.49945051311	(37.7435289932417, -122.49945051311)
157074	157074	201809	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	237 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6020945.51773	2093059.3003900002	37.72831318869729	-122.369818081152	(37.7283131886973, -122.369818081152)
63806	63806	181949	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2450 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986451.9754	2098568.253	37.7414863814969	-122.489467090095	(37.7414863814969, -122.489467090095)
50519	50519	201808	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	247 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6020927.8472	2093035.08257	37.7282457215548	-122.369877496672	(37.7282457215548, -122.369877496672)
53500	53500	227128	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	248 Whitney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004363.9622599995	2096949.7405400001	37.7380717187222	-122.427418297528	(37.7380717187222, -122.427418297528)
56930	56930	207038	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	270 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5994641.46146	2100307.8933900003	37.7467376875983	-122.461276941602	(37.7467376875983, -122.461276941602)
147441	147441	227568	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	287 Hartford St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002743.271790001	2104198.2878099997	37.7578827294299	-122.433539694925	(37.7578827294299, -122.433539694925)
41516	41516	46433	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	2St. Ankeny St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/30/2003 12:00:00 AM	1		Permit Number 47151	6011103.47209	2089684.5822599998	37.718501979072	-122.403605308234	(37.718501979072, -122.403605308234)
43685	43685	46431	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	2St. Ankeny St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/15/2002 12:00:00 AM	1		Permit Number 44652	6011089.42189	2089718.35805	37.7185939356546	-122.40365624942899	(37.7185939356546, -122.403656249429)
44865	44865	46434	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	2St. Ankeny St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/30/2003 12:00:00 AM	1		Permit Number 47151	6011096.25435	2089701.2859	37.7185474406786	-122.40363143174	(37.7185474406786, -122.40363143174)
101502	101502	111713	Planning Code 138.1 required 4	Lagunaria patersonii :: Primrose Tree 48	3038 CLEMENT ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/2015 12:00:00 AM	1	3x3	Permit Number 777015	5986051.0	2113265.0	37.7818161572934	-122.491935266217	(37.7818161572934, -122.491935266217)
145461	145461	111714	Planning Code 138.1 required 4	Lagunaria patersonii :: Primrose Tree 48	3038 CLEMENT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/2015 12:00:00 AM	1	3x3	Permit Number 777015	5986051.0	2113265.0	37.7818161572934	-122.491935266217	(37.7818161572934, -122.491935266217)
132152	132152	117686	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	34 Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		5982669.571880001	2112585.47797	37.7797521626965	-122.503582898398	(37.7797521626965, -122.503582898398)
82449	82449	112583	Section 143 8	Lagunaria patersonii :: Primrose Tree 48	3400x WAWONA ST	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			1	4x4		5982411.0	2096792.0	37.7363725426512	-122.50330767262899	(37.7363725426512, -122.503307672629)
175623	175623	184549	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	3501 Moraga St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5983411.1343	2103548.3965	37.754982490057	-122.50034921882099	(37.754982490057, -122.500349218821)
62998	62998	176882	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	371 Wilde Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010924.50069	2089093.90072	37.7168700890604	-122.404182392406	(37.7168700890604, -122.404182392406)
164934	164934	227107	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	39 Alma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5998391.27095	2106242.70654	37.7632483086886	-122.448737922716	(37.7632483086886, -122.448737922716)
148319	148319	207042	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	40 Vasquez Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995660.33467	2100048.89738	37.746085134133	-122.45773506422701	(37.746085134133, -122.457735064227)
149848	149848	206999	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	404 Santiago St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991570.38275	2099794.54343	37.7451509372588	-122.471858917877	(37.7451509372588, -122.471858917877)
146911	146911	79199	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	409 Laurel St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/04/2015 12:00:00 AM	1		Permit Number 777130	5998120.56156	2115036.84682	37.7873792631851	-122.450308169597	(37.7873792631851, -122.450308169597)
43034	43034	140758	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	42 TERRA VISTA AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6000316.7782	2112875.0348	37.781568928755895	-122.442554464995	(37.7815689287559, -122.442554464995)
76631	76631	207009	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	451 Hearst Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5998610.96321	2094365.8508	37.7306499124634	-122.44712329519699	(37.7306499124634, -122.447123295197)
180010	180010	118666	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	465 43rd Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5982506.22463	2112651.7557200002	37.779924536981504	-122.50415288931299	(37.7799245369815, -122.504152889313)
27198	27198	140780	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	5 Encanto Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6000014.7367	2112198.3604	37.7796937331341	-122.44355075738399	(37.7796937331341, -122.443550757384)
161979	161979	117687	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 Point Lobos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 8ft		5982599.26265	2112595.13886	37.7797745547632	-122.50382684040501	(37.7797745547632, -122.503826840405)
36328	36328	119240	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 Sutro Heights Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5981455.34518	2111336.83463	37.776252294734	-122.507690683983	(37.776252294734, -122.507690683983)
48201	48201	119241	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 Sutro Heights Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5981435.03386	2111334.77238	37.776245435782	-122.50776079209999	(37.776245435782, -122.5077607921)
68212	68212	119242	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 Sutro Heights Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5981417.66127	2111333.86508	37.7762419210818	-122.507820820241	(37.7762419210818, -122.507820820241)
158101	158101	119243	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 Sutro Heights Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5981398.37029	2111333.4256599997	37.7762395779827	-122.507887519226	(37.7762395779827, -122.507887519226)
52735	52735	176874	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	526 Lathrop Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6012843.86934	2086597.3532	37.7101221250005	-122.397373047849	(37.7101221250005, -122.397373047849)
186108	186108	176878	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	526 Lathrop Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6013154.94381	2086496.55313	37.709862662502104	-122.396290845073	(37.7098626625021, -122.396290845073)
187121	187121	58124	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	527 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1978 12:00:00 AM	1		Permit Number 17106	5991241.869630001	2111793.32926	37.778077396785	-122.473870058582	(37.778077396785, -122.473870058582)
40793	40793	78252	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	541 Naples St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/17/2015 12:00:00 AM	1	3x3	Permit Number 776648	6003018.571219999	2090471.0211200002	37.7202064317688	-122.43160757344299	(37.7202064317688, -122.431607573443)
59233	59233	108371	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	575 Paris St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		1	3x3		6001620.80772	2090281.19611	37.719605888781295	-122.43642558878	(37.7196058887813, -122.43642558878)
116120	116120	113418	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	598X BENTON AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6007207.0	2095355.0	37.7338532991757	-122.417475487879	(37.7338532991757, -122.417475487879)

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