Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by DBH 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, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▲	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
77244	77244	185929	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	2000 Sunset Blvd	72	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5985012.7201	2101493.4926	37.7494341681805	-122.494659074897	(37.7494341681805, -122.494659074897)
18271	18271	28138	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	418 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	4X5		6006975.957669999	2097881.62293	37.7407778444163	-122.41845336792801	(37.7407778444163, -122.418453367928)
35692	35692	209045	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	300 Melrose Ave	3	Side Yard : Yard 17	Tree 1	Private 1			88			5998032.3562900005	2095523.6559099997	37.733795893852296	-122.44920699922599	(37.7337958938523, -122.449206999226)
70101	70101	247851	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	152 Chapman St	3	Side Yard : Yard 17	Tree 1	Private 1			79			6009070.86749	2098234.59559	37.7418647407582	-122.411234858803	(37.7418647407582, -122.411234858803)
158274	158274	176343	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	450 Raymond Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			76			6008484.74111	2088383.4213400001	37.714782633086294	-122.412565284366	(37.7147826330863, -122.412565284366)
154149	154149	201514	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1001 Innes Ave	12	Front Yard : Yard 7	Tree 1	Private 1			75			6018663.55815	2094844.4948099998	37.733089515074795	-122.377830854436	(37.7330895150748, -122.377830854436)
18477	18477	4843	Permitted Site 1	Eucalyptus globulus :: Blue Gum 103	146 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X3		6006528.82493	2097534.91084	37.739800668952604	-122.419974789699	(37.7398006689526, -122.419974789699)
112663	112663	114044	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	549X ARLINGTON ST		Median : Cutout 11	Tree 1	Private 1			70			6003400.0	2095634.0	37.734404428182295	-122.430657330781	(37.7344044281823, -122.430657330781)
47690	47690	176337	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	100x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			59	Width 0ft		6011478.9031	2090656.6645400003	37.72119208331829	-122.40237590353901	(37.7211920833183, -122.402375903539)
52384	52384	208985	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	372 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			59	Width 3ft		5993126.32529	2095592.5648700001	37.7337032672843	-122.466173478533	(37.7337032672843, -122.466173478533)
160736	160736	207773	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	80 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			58	Width 10ft		5993272.22832	2097088.94625	37.7378203744176	-122.465777737259	(37.7378203744176, -122.465777737259)
153710	153710	138026	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1641 Octavia St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			57	Width 0ft		6004881.8597	2114953.8419999997	37.787535976676395	-122.426909554358	(37.7875359766764, -122.426909554358)
181003	181003	191736	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Helena St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			57			6010895.577219999	2096228.10312	37.7364575084979	-122.40478434551399	(37.7364575084979, -122.404784345514)
73493	73493	224246	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	483 Valley St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			55			6002830.24391	2099168.61142	37.744077360782796	-122.432879592517	(37.7440773607828, -122.432879592517)
74562	74562	209046	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Joost Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			55	Width 10ft		5999983.24986	2094934.98428	37.732290932375605	-122.442419949729	(37.7322909323756, -122.442419949729)
164844	164844	208930	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	435 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			55	Width 10ft		5993068.37064	2096069.711	37.735010047856704	-122.466408510055	(37.7350100478567, -122.466408510055)
46778	46778	209043	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	690 Mangels Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 10ft		5996832.93686	2095303.5906200001	37.7331229707542	-122.453337845278	(37.7331229707542, -122.453337845278)
43267	43267	121204	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	44 MacOndray Ln	1	Unaccepted Street : Cutout 20	Tree 1	Private 1			52			6008473.20212	2119153.5676	37.799269800719294	-122.41478152415002	(37.7992698007193, -122.41478152415)
61439	61439	208913	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	25 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			52	Width 10ft		5991855.18446	2096027.3519599999	37.7348236624713	-122.470599802253	(37.7348236624713, -122.470599802253)
153783	153783	191723	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	900x Carolina St	30	Median : Yard 3	Tree 1	DPW 2			50			6012476.48508	2103328.88343	37.7560429683291	-122.39981689974701	(37.7560429683291, -122.399816899747)
173688	173688	191721	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	1150x Tennessee St	7	Median : Yard 3	Tree 1	DPW 2			50			6015559.12531	2103608.85918	37.75698309171089	-122.389175557402	(37.7569830917109, -122.389175557402)
70742	70742	138025	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1651 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			49	Width 0ft		6004878.9655	2114979.8902	37.7876073348692	-122.42692142358601	(37.7876073348692, -122.426921423586)
138334	138334	207756	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	95 Kirkham St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49			5994800.39892	2105292.04488	37.7604320448233	-122.461088561491	(37.7604320448233, -122.461088561491)
176724	176724	138028	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1621 Octavia St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			49	Width 0ft		6004887.6482	2114917.9533	37.7874377625804	-122.426886970359	(37.7874377625804, -122.426886970359)
89069	89069	138024	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1661 Octavia St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			48	Width 0ft		6004873.7558	2115028.5137	37.7877405482561	-122.42694291248002	(37.7877405482561, -122.42694291248)
114729	114729	96803	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	300X Melrose Ave	1	Unaccepted Street : Yard 14	Tree 1	Private 1			48			5998134.5	2095546.7	37.733865009274204	-122.448855518806	(37.7338650092742, -122.448855518806)
165255	165255	224249	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	500x 27th St	14	Median : Cutout 11	Tree 1	DPW 2			48	Width 4ft		6002852.0087	2100065.56768	37.7465414276517	-122.432868400457	(37.7465414276517, -122.432868400457)
50349	50349	208932	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	435 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			47	Width 10ft		5992980.53983	2096066.6285400002	37.734996515770604	-122.4667119458	(37.7349965157706, -122.4667119458)
57024	57024	209025	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	36 Martha Ave	2	Front Yard : Yard 7	Tree 1	Private 1			46			6000769.58789	2095570.4874200001	37.7340806650885	-122.43974695145599	(37.7340806650885, -122.439746951456)
76551	76551	224247	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	527 Powhattan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			46			6008745.222630001	2098103.60695	37.74148680607821	-122.412351580256	(37.7414868060782, -122.412351580256)
164177	164177	224220	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1201 San Jose Ave	5	Front Yard : Yard 7	Tree 1	Private 1			46			6004122.93683	2095831.8247900002	37.734988540591395	-122.42817199506099	(37.7349885405914, -122.428171995061)
180599	180599	191725	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	950x Kansas St	6	Median : Yard 3	Tree 1	DPW 2			46			6011608.2265	2103816.01851	37.75733209161471	-122.40285390399201	(37.7573320916147, -122.402853903992)
183364	183364	247818	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1058 Jarboe Ave	1	Side Yard : Yard 17	Tree 1	Private 1			46			6009634.533480001	2096844.3676599998	37.738079072495395	-122.409187798594	(37.7380790724954, -122.409187798594)
23367	23367	208982	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	320 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 3ft		5993096.565780001	2095876.3159599998	37.7344806601409	-122.46629697974501	(37.7344806601409, -122.466296979745)
79476	79476	116530	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	745X SANCHEZ ST	7	Median : Yard 3	Tree 1	DPW 2			45			6003713.0	2103768.0	37.7567562336472	-122.430155272915	(37.7567562336472, -122.430155272915)
102986	102986	112188	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	301x CORBETT AVE	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			45	3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
169268	169268	246758	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	70 Waltham St	2	Front Yard : Yard 7	Tree 1	Private 1			45			6009165.3759699995	2098887.8964	37.743663861508395	-122.41095421008801	(37.7436638615084, -122.410954210088)
176352	176352	208925	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5992554.16067	2096052.7030900002	37.734933663950294	-122.46818506409599	(37.7349336639503, -122.468185064096)
178890	178890	207796	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5993217.29355	2096710.01575	37.736776757040204	-122.465940145823	(37.7367767570402, -122.465940145823)
179355	179355	207758	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	95 Kirkham St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			45			5994815.677630001	2105291.72467	37.7604320448236	-122.461035696659	(37.7604320448236, -122.461035696659)
66396	66396	208966	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	44 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 6ft		5993666.080159999	2097016.89785	37.7376452584166	-122.46441078125099	(37.7376452584166, -122.464410781251)
150553	150553	208928	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	335 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992778.536119999	2096059.1494200001	37.7349643200549	-122.467409794552	(37.7349643200549, -122.467409794552)
181826	181826	208924	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992506.66791	2096052.3886900002	37.7349300576612	-122.468349238953	(37.7349300576612, -122.468349238953)
184880	184880	208960	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	601 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 8ft		5993401.29019	2096115.48675	37.735154941244396	-122.465260822223	(37.7351549412444, -122.465260822223)
24602	24602	208981	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	310 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5993092.40274	2095921.0497	37.7346032476459	-122.466314622626	(37.7346032476459, -122.466314622626)
55507	55507	191724	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	950x Kansas St	5	Median : Yard 3	Tree 1	DPW 2			43			6011608.5229400005	2103823.60133	37.7573529289142	-122.402853412073	(37.7573529289142, -122.402853412073)
62516	62516	208926	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 10ft		5992668.30531	2096054.89965	37.7349462868375	-122.467790589077	(37.7349462868375, -122.467790589077)
67133	67133	209003	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	96 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5994450.97172	2101378.39351	37.7496660456507	-122.462013248027	(37.7496660456507, -122.462013248027)
134672	134672	207755	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	95 Kirkham St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43			5994788.04604	2105291.71815	37.7604304368423	-122.46113126040702	(37.7604304368423, -122.461131260407)
3884	3884	20320	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6772	6772	20314	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
12003	12003	20316	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
16276	16276	20315	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
20653	20653	2618	Landmark tree 9	Eucalyptus globulus :: Blue Gum 103	1661X Octavia St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	10X10		6004876.92395	2115038.87855	37.787769186678204	-122.42693268975599	(37.7877691866782, -122.426932689756)
34400	34400	207800	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993292.571380001	2096874.95335	37.737233976861205	-122.465691859205	(37.7372339768612, -122.465691859205)
74106	74106	207797	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993240.654130001	2096747.6644599999	37.7368814785997	-122.465862113458	(37.7368814785997, -122.465862113458)
78801	78801	2617	Landmark tree 9	Eucalyptus globulus :: Blue Gum 103	1661X Octavia St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	10X10		6004876.92395	2115038.87855	37.787769186678204	-122.42693268975599	(37.7877691866782, -122.426932689756)
80756	80756	2614	Landmark tree 9	Eucalyptus globulus :: Blue Gum 103	1661X Octavia St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	10X10		6004876.92395	2115038.87855	37.787769186678204	-122.42693268975599	(37.7877691866782, -122.426932689756)
99315	99315	3751	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	990 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			42	18		6012435.5557064	2103342.2152382	37.756077292734105	-122.399959384248	(37.7560772927341, -122.399959384248)
116419	116419	2615	Landmark tree 9	Eucalyptus globulus :: Blue Gum 103	1661X Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	10X10		6004876.92395	2115038.87855	37.787769186678204	-122.42693268975599	(37.7877691866782, -122.426932689756)
138324	138324	2616	Landmark tree 9	Eucalyptus globulus :: Blue Gum 103	1661X Octavia St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	10X10		6004876.92395	2115038.87855	37.787769186678204	-122.42693268975599	(37.7877691866782, -122.426932689756)
25962	25962	209036	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	427 Baden St	2	Front Yard : Yard 7	Tree 1	Private 1			41			6000750.14831	2095370.65935	37.7335308771479	-122.439799837889	(37.7335308771479, -122.439799837889)
55842	55842	207761	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	345 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993145.033430001	2095739.54752	37.7341079244482	-122.46611947693701	(37.7341079244482, -122.466119476937)
134583	134583	209010	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	408 Baden St	2	Front Yard : Yard 7	Tree 1	Private 1			41			6000785.06362	2095352.2063400003	37.7334821968386	-122.439677803484	(37.7334821968386, -122.439677803484)
137770	137770	208917	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992152.90186	2096040.12972	37.734875958047496	-122.46957142927499	(37.7348759580475, -122.469571429275)
153757	153757	207801	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	75 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993316.85986	2097021.89165	37.737638833663794	-122.465618555459	(37.7376388336638, -122.465618555459)
165361	165361	207798	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993265.61107	2096796.17632	37.7370161196856	-122.465779350629	(37.7370161196856, -122.465779350629)
180635	180635	208944	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992497.26068	2095992.6782799999	37.73476556447329	-122.468377420108	(37.7347655644733, -122.468377420108)
23922	23922	208951	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	440 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5993021.57409	2096009.5815299999	37.734842246953896	-122.46656593187099	(37.7348422469539, -122.466565931871)
25657	25657	208945	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5992554.30272	2095990.82137	37.73476376044329	-122.46818007286001	(37.7347637604433, -122.46818007286)
113956	113956	114069	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	2 HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40			5988091.0	2090188.0	37.7185719141165	-122.483185851801	(37.7185719141165, -122.483185851801)
123394	123394	114040	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	95 LINARES AVE	1	Front Yard : Yard 7	Tree 1	DPW 2			40	3x3		5994258.0	2102054.0	37.751509977458795	-122.462729551044	(37.7515099774588, -122.462729551044)
138343	138343	105902	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	11X ELLIOT ST	3	Unaccepted Street : Yard 14	Tree 1	DPW 2			40			6009059.0	2088845.0	37.716082244868005	-122.410612975888	(37.716082244868, -122.410612975888)
141204	141204	111548	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	900x BOSWORTH ST	26	Front Yard : Yard 7	Tree 1	DPW 2			40			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
157431	157431	207769	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	40 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5993228.66009	2097329.84492	37.7384793085579	-122.46594587182899	(37.7384793085579, -122.465945871829)
158211	158211	208916	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	47 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5992082.23886	2096035.7065400002	37.7348597288875	-122.469815411761	(37.7348597288875, -122.469815411761)
41245	41245	138027	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1631 Octavia St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			39	Width 0ft		6004885.3328	2114935.3188	37.7874853129815	-122.426896218405	(37.7874853129815, -122.426896218405)
71413	71413	113506	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	200x Mansell St	12	Median : Cutout 11	Tree 1	DPW 2			39	3x3		6011135.08211	2090555.5358799999	37.7208952054249	-122.40355728893199	(37.7208952054249, -122.403557288932)
75518	75518	191738	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	920 Vermont St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39			6011311.04969	2104026.1978700003	37.757892599481	-122.40389645386699	(37.757892599481, -122.403896453867)
131518	131518	208943	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5992457.65692	2095992.19703	37.7347619554908	-122.46851430770701	(37.7347619554908, -122.468514307707)
153159	153159	207790	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	265 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5993131.48438	2096255.5032900001	37.735523828762005	-122.466203802777	(37.735523828762, -122.466203802777)
36584	36584	208984	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	354 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 3ft		5993109.71634	2095669.50335	37.7339135629453	-122.466236489538	(37.7339135629453, -122.466236489538)
61081	61081	208914	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	45 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5991964.75621	2096031.6123	37.7348416956868	-122.470221288386	(37.7348416956868, -122.470221288386)
74311	74311	208919	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5992247.91507	2096042.0705099998	37.734886777797996	-122.469243079632	(37.734886777798, -122.469243079632)
154505	154505	208971	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	150 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 6ft		5994318.90627	2096521.2556599998	37.736321957275706	-122.462117732164	(37.7363219572757, -122.462117732164)
167382	167382	207793	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	215 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5993139.697869999	2096516.18073	37.7362400578338	-122.466194343712	(37.7362400578338, -122.466194343712)
169544	169544	247921	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	6	Side Yard : Yard 17	Tree 1	Private 1			38			6010260.8237	2098716.17835	37.7432537274883	-122.407154297447	(37.7432537274883, -122.407154297447)
172222	172222	201510	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1001 Innes Ave	8	Front Yard : Yard 7	Tree 1	Private 1			38			6018594.17439	2094891.11142	37.73321369166371	-122.378073969944	(37.7332136916637, -122.378073969944)
174300	174300	248219	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	70 Fair Ave	2	Side Yard : Yard 17	Tree 1	Private 1			38			6007128.325540001	2099340.74379	37.744792840734206	-122.418029950029	(37.7447928407342, -122.418029950029)
181159	181159	224265	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	58 Poppy Ln	1	Back Yard : Yard 13	Tree 1	Private 1			38			6002671.84671	2096513.9082400003	37.7367791753169	-122.433237644116	(37.7367791753169, -122.433237644116)
185838	185838	209018	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	33 Martha Ave	3	: Yard 23	Tree 1	Private 1			38			6000767.57935	2095529.42368	37.733967799282	-122.439750952539	(37.733967799282, -122.439750952539)
186126	186126	246762	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	70 Waltham St	6	Front Yard : Yard 7	Tree 1	Private 1			38			6009259.9688	2098886.63063	37.743665689828	-122.41062704033101	(37.743665689828, -122.410627040331)
24579	24579	247929	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1099 Esmeralda Ave	2	Side Yard : Yard 17	Tree 1	Private 1			37			6010384.7561099995	2098766.60945	37.743399135274295	-122.40672932282301	(37.7433991352743, -122.406729322823)
26365	26365	208940	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 10ft		5992201.32921	2095978.5342700002	37.7347096311457	-122.469399518468	(37.7347096311457, -122.469399518468)
50832	50832	224239	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1100 San Jose Ave	36	Front Yard : Yard 7	Tree 1	Private 1			37			6004801.05123	2096666.83115	37.7373196246961	-122.425886930149	(37.7373196246961, -122.425886930149)
17047	17047	20318	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
17109	17109	20319	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
29186	29186	209002	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	115 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 4ft		5994119.61861	2096725.9639	37.736872559114104	-122.462821593742	(37.7368725591141, -122.462821593742)
76666	76666	207779	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	126 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5993175.19587	2096740.86685	37.7368590378112	-122.46608793591001	(37.7368590378112, -122.46608793591)
76936	76936	208937	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	64 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5991925.34536	2095973.96809	37.734681140613105	-122.47035334753201	(37.7346811406131, -122.470353347532)

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