Street_Tree_List

Data source: data.sfgov.org

340 rows where qSiteInfo = 2 and qSpecies = 60 sorted by PlotSize

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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
28874	28874	218292	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39			5991223.38049	2095418.74528	37.73311602796429	-122.472739784911	(37.7331160279643, -122.472739784911)
38217	38217	176045	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			5990157.58815	2089581.85402	37.7170276349961	-122.475998332672	(37.7170276349961, -122.475998332672)
40567	40567	176049	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989054.79394	2089564.29309	37.716915411303	-122.479808833919	(37.716915411303, -122.479808833919)
40789	40789	176052	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5989234.209980001	2089407.1197400002	37.716494274064495	-122.47917719598	(37.7164942740645, -122.47917719598)
55378	55378	176054	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989245.31981	2089315.2477799999	37.7162426617475	-122.47913207879101	(37.7162426617475, -122.479132078791)
58398	58398	218290	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34			5991251.16534	2095467.63693	37.733251880466	-122.472647289653	(37.733251880466, -122.472647289653)
61517	61517	201542	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 Innes Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28			6020585.50312	2093400.1960900002	37.7292294638519	-122.37108624845699	(37.7292294638519, -122.371086248457)
62427	62427	176057	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989281.98257	2089351.5172299999	37.7163443777799	-122.479008007435	(37.7163443777799, -122.479008007435)
65336	65336	176043	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989267.954919999	2090414.23117	37.7192615104927	-122.47913418591499	(37.7192615104927, -122.479134185915)
69208	69208	176048	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989010.93647	2089619.81285	37.7170653066825	-122.479964486788	(37.7170653066825, -122.479964486788)
71511	71511	104957	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
73344	73344	176058	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Crespi Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989854.78687	2090110.33741	37.7184611570226	-122.47708355628599	(37.7184611570226, -122.477083556286)
79797	79797	114240	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	99x FONT BLVD	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990948.0	2088640.0	37.71448733391829	-122.473197635313	(37.7144873339183, -122.473197635313)
85205	85205	104946	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
86917	86917	104944	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
88948	88948	104951	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
90415	90415	104958	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
91050	91050	97402	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2 Stanford Heights Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5997807.0	2095590.8	37.7339673631019	-122.449990957178	(37.7339673631019, -122.449990957178)
94825	94825	104959	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
95555	95555	104945	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
98987	98987	104915	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	701 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
100469	100469	110542	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	996 SOUTH VAN NESS AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						6007549.0	2103894.0	37.757318718735704	-122.41689786927	(37.7573187187357, -122.41689786927)
105245	105245	114225	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	99x FONT BLVD	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			48			5990948.0	2088640.0	37.71448733391829	-122.473197635313	(37.7144873339183, -122.473197635313)
105850	105850	104948	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	535 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
109251	109251	104950	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
109801	109801	97401	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2 Stanford Heights Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5997807.0	2095590.8	37.7339673631019	-122.449990957178	(37.7339673631019, -122.449990957178)
112803	112803	104952	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
122291	122291	104956	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
144026	144026	104949	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	535 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
146250	146250	104914	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	614 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
151782	151782	218282	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5991361.16684	2095634.8342900001	37.7337173290882	-122.47227917194901	(37.7337173290882, -122.472279171949)
153594	153594	218291	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5991233.57986	2095433.30624	37.7331565991011	-122.472705584612	(37.7331565991011, -122.472705584612)
153599	153599	176040	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989182.3515099995	2090508.47222	37.719515300969206	-122.479436972335	(37.7195153009692, -122.479436972335)
154485	154485	176056	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5989277.7182599995	2089365.90518	37.7163836358725	-122.47902379861401	(37.7163836358725, -122.479023798614)
160065	160065	176051	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989218.52603	2089406.1518400002	37.7164907055632	-122.479231336085	(37.7164907055632, -122.479231336085)
161995	161995	176044	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21			5990534.22824	2089263.3063400001	37.7161748133009	-122.47467324639099	(37.7161748133009, -122.474673246391)
163843	163843	176041	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			5989102.080019999	2090436.91452	37.71931415859461	-122.479709205217	(37.7193141585946, -122.479709205217)
166239	166239	176046	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5990073.98867	2089647.08481	37.7172018948419	-122.47629205486	(37.7172018948419, -122.47629205486)
168089	168089	246700	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Bonview St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23			6007679.27037	2099071.40446	37.744084288253795	-122.41610581094801	(37.7440842882538, -122.416105810948)
173612	173612	176050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989206.756130001	2089405.10082	37.7164871361381	-122.47927194136999	(37.7164871361381, -122.47927194137)
179359	179359	176053	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989219.15665	2089312.55172	37.7162337395604	-122.479222313162	(37.7162337395604, -122.479222313162)
184066	184066	176047	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5988958.7133	2089588.42281	37.7169760831658	-122.480142699133	(37.7169760831658, -122.480142699133)
185959	185959	176042	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989234.3289	2090278.8910299998	37.7188879474116	-122.47924052173599	(37.7188879474116, -122.479240521736)
187875	187875	176055	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5989270.85841	2089380.9981799999	37.716424679123705	-122.479048612712	(37.7164246791237, -122.479048612712)
188959	188959	217849	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33			5991387.06493	2095679.62189	37.7338418033391	-122.47219289908001	(37.7338418033391, -122.47219289908)
34752	34752	183980	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1692 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 0ft		5985341.0245	2103687.7125	37.7554781047189	-122.493685471877	(37.7554781047189, -122.493685471877)
162939	162939	183979	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Moraga St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 0ft		5985375.7968	2103670.995	37.755434237268894	-122.49356398857901	(37.7554342372689, -122.493563988579)
166964	166964	140841	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	128 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		5996252.84	2113531.7423	37.7831395829214	-122.456661169882	(37.7831395829214, -122.456661169882)
177522	177522	218364	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	319 Castenada Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5993739.60333	2100127.89175	37.7461915041434	-122.464382386036	(37.7461915041434, -122.464382386036)
23485	23485	206309	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	226 Sadowa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5994744.569130001	2087779.6169999999	37.712344021541796	-122.46001297051599	(37.7123440215418, -122.460012970516)
26380	26380	206314	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3698 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		5990493.86406	2091288.56287	37.721733327719	-122.47496051233699	(37.721733327719, -122.474960512337)
27455	27455	206378	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	150 Santa Paula Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 3ft		5994003.024	2096845.2865099998	37.7371934731949	-122.463233365452	(37.7371934731949, -122.463233365452)
29617	29617	206373	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	100 Vasquez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5995163.12674	2099738.31218	37.7452037688521	-122.459431843925	(37.7452037688521, -122.459431843925)
30863	30863	212278	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991401.80678	2092732.18805	37.725749741332706	-122.47192718629	(37.7257497413327, -122.47192718629)
32429	32429	124059	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	401 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 3ft		5991855.82446	2112441.44184	37.7798924782755	-122.471793433921	(37.7798924782755, -122.471793433921)
32481	32481	212289	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991466.68956	2093787.8758599998	37.7286521512557	-122.47177979551901	(37.7286521512557, -122.471779795519)
33639	33639	206377	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	90 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5993942.45121	2097343.40128	37.738557682690704	-122.46347892981001	(37.7385576826907, -122.46347892981)
33693	33693	118440	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5201 Anza St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5982501.27886	2111662.63166	37.7772084016294	-122.504096711396	(37.7772084016294, -122.504096711396)
35172	35172	189400	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6012714.679959999	2104758.8232299997	37.7599825456822	-122.399093503057	(37.7599825456822, -122.399093503057)
35214	35214	206315	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3646 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5990563.4574	2092379.2095700002	37.72473200467321	-122.474799514783	(37.7247320046732, -122.474799514783)
35637	35637	206374	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	100 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5995150.27092	2099717.15619	37.7451449406021	-122.459474764954	(37.7451449406021, -122.459474764954)
35892	35892	222100	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	57 Hancock St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6003937.41921	2105077.62604	37.7603648636762	-122.429472541518	(37.7603648636762, -122.429472541518)
37176	37176	212288	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991464.21777	2093759.8319	37.728575006528295	-122.471786297603	(37.7285750065283, -122.471786297603)
37837	37837	212265	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5991309.65497	2091334.85858	37.7219076882615	-122.472143937306	(37.7219076882615, -122.472143937306)
44749	44749	189399	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6012714.75151	2104751.09963	37.759961342364	-122.399092713458	(37.759961342364, -122.399092713458)
46360	46360	206347	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	133 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 3ft		5993841.63688	2099869.43819	37.7454877369633	-122.464010811375	(37.7454877369633, -122.464010811375)
50060	50060	206316	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3578 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5990600.84966	2093024.2495	37.726505289668204	-122.47471731316601	(37.7265052896682, -122.474717313166)
51329	51329	212266	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991321.10084	2091550.66305	37.722500896380794	-122.472120094478	(37.7225008963808, -122.472120094478)
52214	52214	250662	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5986620.51071	2115008.0910900002	37.7866354563952	-122.490093303661	(37.7866354563952, -122.490093303661)
54224	54224	212276	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5991374.36791	2092352.51618	37.724705668918205	-122.471994379137	(37.7247056689182, -122.471994379137)
55169	55169	248818	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1506 Willard St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5996902.51958	2106005.87711	37.762512790967705	-122.453869888706	(37.7625127909677, -122.453869888706)
58919	58919	248905	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	501 Diamond St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6001859.76114	2102896.95363	37.7542594112436	-122.43650209949	(37.7542594112436, -122.43650209949)
59385	59385	206414	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Castenada Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5994391.48623	2101817.5644	37.7508684725211	-122.462250796744	(37.7508684725211, -122.462250796744)
62310	62310	212268	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991336.52605	2091747.02554	37.7230409518531	-122.47208107919201	(37.7230409518531, -122.472081079192)
66915	66915	206376	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	30 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 3ft		5994007.04944	2097673.1911400002	37.739466925149	-122.46327950607001	(37.739466925149, -122.46327950607)
67387	67387	189401	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6012714.85505	2104767.4503900004	37.760006243721705	-122.39909350306499	(37.7600062437217, -122.399093503065)
67584	67584	176011	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	114 Gillette Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		6013066.75306	2086848.56663	37.7108243147535	-122.39662031080499	(37.7108243147535, -122.396620310805)
69029	69029	122205	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 14th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 3ft		5991599.89413	2112284.80032	37.7794475722452	-122.472667377899	(37.7794475722452, -122.472667377899)
69117	69117	206412	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Castenada Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5994425.59334	2101766.9443	37.750731446411706	-122.462129181427	(37.7507314464117, -122.462129181427)
69812	69812	222120	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	750 Sanchez St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		6003682.24237	2103760.37923	37.7567335667131	-122.430261100376	(37.7567335667131, -122.430261100376)
70113	70113	250663	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5986609.275330001	2114999.44135	37.7866110505914	-122.49013153834801	(37.7866110505914, -122.490131538348)
70215	70215	212286	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5991449.46468	2093506.02846	37.7278772720107	-122.47181880990101	(37.7278772720107, -122.471818809901)
71795	71795	206372	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	66 Merced Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5995025.32274	2099934.85011	37.7457354885167	-122.45992257786699	(37.7457354885167, -122.459922577867)
73816	73816	212290	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991468.4297400005	2093810.9403799998	37.7287155813527	-122.471775459876	(37.7287155813527, -122.471775459876)
74366	74366	248906	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	501 Diamond St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6001858.61423	2102879.68438	37.7542119288535	-122.43650482983	(37.7542119288535, -122.43650482983)
97684	97684	122204	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 14th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 3ft		5991601.17725	2112249.41578	37.7793504902729	-122.472660358473	(37.7793504902729, -122.472660358473)
129564	129564	206405	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	160 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5994407.40356	2096440.94307	37.7361065336912	-122.461805940812	(37.7361065336912, -122.461805940812)
132358	132358	212095	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	351 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 3ft		5994152.80481	2101121.63697	37.748943886464296	-122.463025685905	(37.7489438864643, -122.463025685905)
134039	134039	206371	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	66 Merced Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34	Width 3ft		5995008.06409	2099920.79101	37.745695893156	-122.459981237061	(37.745695893156, -122.459981237061)
136395	136395	212274	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991367.86309	2092252.1264400003	37.724429647187705	-122.472009551601	(37.7244296471877, -122.472009551601)
147406	147406	212283	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	31	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991413.76911	2093002.29122	37.726492069641	-122.47190551083	(37.726492069641, -122.47190551083)
149912	149912	206317	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3578 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 3ft		5990608.28598	2093089.7399	37.7266855407931	-122.474696384147	(37.7266855407931, -122.474696384147)
150452	150452	206375	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Santa Paula Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5994061.2608	2097779.4801	37.7397618911113	-122.46309977833599	(37.7397618911113, -122.463099778336)
150783	150783	222943	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	236 States St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		6000769.920530001	2106548.66291	37.7642241216644	-122.44053292747	(37.7642241216644, -122.44053292747)
154093	154093	212279	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5991402.240809999	2092752.78363	37.7258063167904	-122.4719271863	(37.7258063167904, -122.4719271863)
154269	154269	212284	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991427.0234	2093184.95308	37.726994380560896	-122.471872998563	(37.7269943805609, -122.471872998563)
154943	154943	206369	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Hazelwood Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5996628.41622	2093653.8461099998	37.728581442980705	-122.45392582384301	(37.7285814429807, -122.453925823843)
155041	155041	212287	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991452.02	2093567.7865099998	37.728046992061	-122.471814475179	(37.728046992061, -122.471814475179)
155854	155854	212270	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5991340.77769	2091800.00989	37.723186679801294	-122.47207024236201	(37.7231866798013, -122.472070242362)
156092	156092	124060	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	401 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		5991866.07443	2112179.49753	37.7791738439371	-122.471738880123	(37.7791738439371, -122.471738880123)

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