Street_Tree_List

Data source: data.sfgov.org

1,117 rows where qSpecies = 52 sorted by qSiteInfo 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, qSiteInfo, qCaretaker, qCareAssistant, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▲	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
39582	39582	229804	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	10 Crescent Ave	7	Side Yard : Yard 17	Tree 1	Private 1			6	Width 5ft		6005354.49537	2095898.81655	37.7352420900484	-122.423918818711	(37.7352420900484, -122.423918818711)
161626	161626	226818	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	272 Corbett Ave	2	Side Yard : Yard 17	Tree 1	Private 1			7	Width 3ft		5999639.14958	2105380.58985	37.7609524294432	-122.44435997895599	(37.7609524294432, -122.444359978956)
29106	29106	229884	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	137 Bradford St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 5ft		6009563.00843	2097787.4840700002	37.7406646584401	-122.409501640412	(37.7406646584401, -122.409501640412)
60525	60525	226466	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	7 28th St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6005836.7555	2099627.17961	37.7455065507954	-122.42251630979901	(37.7455065507954, -122.422516309799)
68990	68990	190712	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	204 Texas St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 3ft		6013703.78505	2106091.36578	37.763696485831204	-122.395766012395	(37.7636964858312, -122.395766012395)
73729	73729	229870	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	3952 26th St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		6004170.69747	2100746.77802	37.7484865785056	-122.42835706113001	(37.7484865785056, -122.42835706113)
118394	118394	229868	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	248 28th St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			10	Width 3ft		6004337.80093	2099585.8632799997	37.7453084292413	-122.427696518086	(37.7453084292413, -122.427696518086)
120446	120446	229783	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	975 San Bruno Ave	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			12	Width 4ft		6011090.02369	2103815.82999	37.7573026253193	-122.404646049572	(37.7573026253193, -122.404646049572)
24100	24100	229778	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011440.8047	2102625.1691799997	37.754052932322395	-122.40334914446301	(37.7540529323224, -122.403349144463)
24885	24885	229758	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011460.45759	2102239.71319	37.7529956524374	-122.40325406633801	(37.7529956524374, -122.403254066338)
27865	27865	229765	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011453.422780001	2102371.80516	37.753357955114396	-122.40328768569401	(37.7533579551144, -122.403287685694)
27981	27981	229753	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011465.791619999	2102125.84808	37.7526833017063	-122.40322761098899	(37.7526833017063, -122.403227610989)
30489	30489	229761	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011456.4035	2102287.48645	37.753126600912296	-122.40327144663401	(37.7531266009123, -122.403271446634)
31243	31243	229777	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011441.00674	2102606.02985	37.7540003912143	-122.403347099413	(37.7540003912143, -122.403347099413)
33460	33460	229759	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011459.21947	2102251.51401	37.753027985753	-122.403259178089	(37.753027985753, -122.403259178089)
35475	35475	229770	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011448.51225	2102466.33912	37.753617250356996	-122.403311317166	(37.753617250357, -122.403311317166)
35984	35984	229773	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011446.65854	2102520.5438599996	37.7537659811344	-122.403321540662	(37.7537659811344, -122.403321540662)
37674	37674	229769	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011449.91996	2102448.3530599996	37.7535679432079	-122.403305183785	(37.7535679432079, -122.403305183785)
41876	41876	229756	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.1555699995	2102190.87321	37.7528617550894	-122.40323784257299	(37.7528617550894, -122.403237842573)
42197	42197	226381	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	60 Nebraska St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6009264.00065	2097705.48363	37.740422744414396	-122.410529710297	(37.7404227444144, -122.410529710297)
45485	45485	229864	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	76 Peralta Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6010511.83754	2100376.53881	37.7478267603098	-122.406403320374	(37.7478267603098, -122.406403320374)
46451	46451	190747	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	200 Kansas St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 4ft		6011390.12769	2107238.8028700002	37.766718110788105	-122.40384902720899	(37.7667181107881, -122.403849027209)
50374	50374	226380	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	60 Nebraska St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6009262.96454	2097691.6296900003	37.740384646425795	-122.410532314727	(37.7403846464258, -122.410532314727)
52880	52880	176585	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	205 Seneca Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 6ft		5999821.59853	2090369.86807	37.719746961831	-122.442651149242	(37.719746961831, -122.442651149242)
53861	53861	176586	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	205 Seneca Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 6ft		5999824.12192	2090353.8387799999	37.7197030929005	-122.44264127649099	(37.7197030929005, -122.442641276491)
54362	54362	229782	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011435.782240001	2102697.98371	37.7542525844934	-122.40337163559201	(37.7542525844934, -122.403371635592)
56978	56978	190748	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	200 Kansas St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6011391.69355	2107207.84436	37.7666331931997	-122.403841432442	(37.7666331931997, -122.403841432442)
59146	59146	229752	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011465.52618	2102102.51804	37.7526192277045	-122.403226887931	(37.7526192277045, -122.403226887931)
61430	61430	229754	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.93054	2102145.24186	37.7527365046859	-122.403231952908	(37.7527365046859, -122.403231952908)
61898	61898	229781	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011437.0323	2102686.7718700003	37.754221869065795	-122.40336652384799	(37.7542218690658, -122.403366523848)
70859	70859	226812	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	2 Belcher St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 1ft		6003760.63198	2108231.56549	37.7690148102126	-122.430308989291	(37.7690148102126, -122.430308989291)
71654	71654	229780	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6011438.150669999	2102669.0861400003	37.7541733704045	-122.40336141212099	(37.7541733704045, -122.403361412121)
72129	72129	229771	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011447.677180001	2102483.4305	37.7536641328931	-122.403315407293	(37.7536641328931, -122.403315407293)
73438	73438	190716	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	333 Arkansas St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6012961.26572	2105490.25457	37.7620046335244	-122.398291995789	(37.7620046335244, -122.398291995789)
108696	108696	226792	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	379 Collingwood St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6002133.75148	2103664.46985	37.7563823922541	-122.435609479191	(37.7563823922541, -122.435609479191)
130489	130489	229763	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		6011453.21392	2102329.36922	37.753241423671795	-122.403285422977	(37.7532414236718, -122.403285422977)
136124	136124	229774	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011445.35286	2102545.22023	37.7538336641006	-122.403327791844	(37.7538336641006, -122.403327791844)
136900	136900	229779	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011439.173280001	2102646.69218	37.75411193863	-122.403356300366	(37.75411193863, -122.403356300366)
138131	138131	201517	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	911 Innes Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 5ft		6019123.25931	2094488.31096	37.7321368236424	-122.37621683574699	(37.7321368236424, -122.376216835747)
140184	140184	229768	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011450.10406	2102428.33109	37.7535129775571	-122.40330313873301	(37.7535129775571, -122.403303138733)
146597	146597	229766	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011452.91917	2102390.65584	37.7534096868171	-122.403290753279	(37.7534096868171, -122.403290753279)
147848	147848	229762	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011454.29465	2102314.61303	37.7532009667707	-122.403280647606	(37.7532009667707, -122.403280647606)
149742	149742	229772	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011446.86383	2102500.86077	37.7537119471592	-122.403319446151	(37.7537119471592, -122.403319446151)
154565	154565	229776	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011441.50409	2102586.88485	37.7539478510307	-122.40334403271002	(37.7539478510307, -122.40334403271)
158462	158462	229757	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011461.99954	2102213.77594	37.752924520553	-122.40324690953301	(37.752924520553, -122.403246909533)
165182	165182	226799	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	701 Sanchez St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6003733.12478	2104096.2711400003	37.7576587280713	-122.43010909155899	(37.7576587280713, -122.430109091559)
169635	169635	229751	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011465.75975	2102083.1370200003	37.7525660247145	-122.40322471696999	(37.7525660247145, -122.40322471697)
171101	171101	229764	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011452.97986	2102350.02958	37.753298139414	-122.403287685686	(37.753298139414, -122.403287685686)
179268	179268	229775	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011442.57459	2102566.84517	37.7538928862632	-122.40333892097799	(37.7538928862632, -122.403338920978)
180024	180024	229767	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011451.55336	2102410.70185	37.7534646524788	-122.40329688663799	(37.7534646524788, -122.403296886638)
180443	180443	229755	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.24481	2102169.9708	37.7528043666378	-122.40323606370701	(37.7528043666378, -122.403236063707)
180784	180784	226793	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	379 Collingwood St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6002133.14773	2103676.3157099998	37.756414883846105	-122.435612414605	(37.7564148838461, -122.435612414605)
181303	181303	229760	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011458.91565	2102265.65077	37.753066785227105	-122.40326122314501	(37.7530667852271, -122.403261223145)
18620	18620	121737	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	12	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
18708	18708	121749	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	12	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
38097	38097	190683	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1301 Minnesota St	39	Front Yard : Yard 7	Tree 1	Private 1			4			6015372.42654	2102509.7647599997	37.7539548603504	-122.389744472134	(37.7539548603504, -122.389744472134)
45346	45346	121804	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	22	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
76134	76134	121731	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	6	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
83237	83237	121751	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	14	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
83874	83874	121745	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	8	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
84849	84849	121803	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	21	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
85431	85431	121738	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	1	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
87306	87306	121748	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	11	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
88761	88761	121736	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	11	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
90523	90523	121755	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	18	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
91849	91849	121726	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	1	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
94087	94087	121729	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	4	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
97349	97349	121756	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	19	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
100467	100467	121733	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	8	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
102223	102223	121743	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	6	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
106820	106820	121744	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	7	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
113793	113793	121754	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	17	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
115454	115454	121741	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	4	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
115692	115692	121739	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	2	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
116473	116473	121727	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	2	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
116581	116581	121753	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	16	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
118593	118593	121742	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	5	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
118602	118602	121752	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	15	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
118748	118748	121728	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	3	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
123068	123068	121746	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	9	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
123543	123543	121747	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	10	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
126474	126474	121730	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	5	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
129304	129304	121740	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	3	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
131666	131666	190744	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	2086 Quesada Ave	1	Front Yard : Yard 7	Tree 1	Private 1			1			6012709.58294	2096557.7365	37.737463838180496	-122.398535643704	(37.7374638381805, -122.398535643704)
135152	135152	226806	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	190 Storrie St	8	Front Yard : Yard 7	Tree 1	Private 1			3	Width 3ft		6000773.9022	2105295.6973200003	37.7607840134024	-122.440429287805	(37.7607840134024, -122.440429287805)
138519	138519	121750	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	13	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
145396	145396	121735	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	10	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
146000	146000	121757	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	20	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
15582	15582	106047	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	618- 622 Carolina St	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			15	6x7		6012364.1992	2105044.14437	37.7607464370199	-122.40032569478599	(37.7607464370199, -122.400325694786)
25976	25976	190714	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	375 Texas St	2	: 4	Tree 1	Private 1			4	Width 5ft		6013800.48111	2105372.99908	37.761729387017496	-122.39538124017099	(37.7617293870175, -122.395381240171)
33217	33217	247662	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	108 Divisadero St	1	: 4	Tree 1	Private 1			7	Width 3ft		6001959.68947	2108344.83823	37.769223654362605	-122.436546435187	(37.7692236543626, -122.436546435187)
39045	39045	190719	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	642 Mississippi St	1	: 4	Tree 1	Private 1			13	Width 4ft		6014091.4532699995	2104130.33792	37.75833348851889	-122.39428786959	(37.7583334885189, -122.39428786959)
45365	45365	201527	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	740 Earl St	4	: 4	Tree 1	Private 1			6	Width 5ft		6020341.20189	2093704.82943	37.730052512603294	-122.371951898056	(37.7300525126033, -122.371951898056)
49682	49682	190742	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1617 Kirkwood Ave	1	: 4	Tree 1	Private 1			4	Width 4ft		6015073.9615	2096817.26033	37.738307875303796	-122.390378936647	(37.7383078753038, -122.390378936647)
57800	57800	190715	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	350 Texas St	1	: 4	Tree 1	Private 1			12	Width 4ft		6013737.51284	2105460.97147	37.7619674375704	-122.395605187539	(37.7619674375704, -122.395605187539)
61921	61921	228526	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	405 Florida St	2	: 4	Tree 1	Private 1			1	Width 3ft		6009242.70378	2106296.2843400002	37.7640099687976	-122.41121004561701	(37.7640099687976, -122.411210045617)
63247	63247	190720	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	315 Mississippi St	1	: 4	Tree 1	Private 1			8	Width 3ft		6014070.97859	2105596.2230599998	37.762357352140796	-122.394461321843	(37.7623573521408, -122.394461321843)
63954	63954	228524	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	29 Pearl St	1	: 4	Tree 1	Private 1			8	Width 3ft		6005636.60822	2108865.67188	37.7708619961085	-122.42386519303999	(37.7708619961085, -122.42386519304)
71295	71295	228531	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1744 Bryant St	1	: 4	Tree 1	Private 1			8	Width 3ft		6009451.253190001	2106552.40785	37.7647249190387	-122.41050681893199	(37.7647249190387, -122.410506818932)
72428	72428	190718	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	446 Missouri St	1	: 4	Tree 1	Private 1			6	Width 3ft		6013483.0407	2105010.44498	37.7607162323997	-122.39645373295299	(37.7607162323997, -122.396453732953)

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