Street_Tree_List

Data source: data.sfgov.org

340 rows where qSiteInfo = 2 and qSpecies = 60 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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
2611	2611	248770	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5999726.1375	2101744.56242	37.7509737525388	-122.44379789365499	(37.7509737525388, -122.443797893655)
2614	2614	248773	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5999776.82694	2101824.96428	37.751197407653706	-122.44362838043999	(37.7511974076537, -122.44362838044)
2625	2625	248771	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5999742.36883	2101773.9828	37.751055459558394	-122.4437438777	(37.7510554595584, -122.4437438777)
2626	2626	248769	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 8ft		5999705.100819999	2101709.8291	37.7508771833507	-122.443868145114	(37.7508771833507, -122.443868145114)
2629	2629	248772	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5999759.8487	2101799.49731	37.7511265131926	-122.443685263491	(37.7511265131926, -122.443685263491)
176940	176940	212100	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 San Marcos Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5993916.201859999	2100058.21492	37.746010367202004	-122.46376667868499	(37.746010367202, -122.463766678685)
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)
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)
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)
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)
66155	66155	212013	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 8ft		5992290.98987	2096599.94632	37.7364210535804	-122.469134745476	(37.7364210535804, -122.469134745476)
172767	172767	212012	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5992283.163930001	2096610.9428400001	37.736450795054104	-122.46916260289801	(37.7364507950541, -122.469162602898)
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)
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)
53888	53888	212075	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	105 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5994262.675969999	2097310.06479	37.7384845939004	-122.462369337275	(37.7384845939004, -122.462369337275)
26209	26209	212049	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5992308.89069	2096641.7463200002	37.736536860193404	-122.469075896562	(37.7365368601934, -122.469075896562)
28401	28401	212048	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992319.55717	2096621.0874299998	37.7364807523878	-122.469037515296	(37.7364807523878, -122.469037515296)
163485	163485	212060	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5994718.64937	2097902.0786900003	37.7401363633992	-122.46083570631001	(37.7401363633992, -122.46083570631)
153657	153657	250878	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986467.64007	2114737.19206	37.785882717559794	-122.490602253393	(37.7858827175598, -122.490602253393)
185329	185329	250877	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986466.719269999	2114758.04628	37.785939923445795	-122.49060697393999	(37.7859399234458, -122.49060697394)
68956	68956	212076	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994265.177680001	2097287.14402	37.738421803216795	-122.462359025655	(37.7384218032168, -122.462359025655)
67477	67477	212003	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	113 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5992389.76735	2095959.32844	37.734667784776605	-122.46874663225701	(37.7346677847766, -122.468746632257)
148973	148973	212002	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	113 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 6ft		5992392.18809	2095930.20278	37.7345879528607	-122.468736144363	(37.7345879528607, -122.468736144363)
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)
48506	48506	212001	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	115 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 6ft		5992392.76715	2095885.63472	37.7344656135867	-122.468730900434	(37.7344656135867, -122.468730900434)
185493	185493	212000	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	115 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		5992393.22124	2095853.15196	37.7343764502974	-122.468726967677	(37.7343764502974, -122.468726967677)
49262	49262	212077	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	115 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5994269.5256900005	2097215.23387	37.7382246061744	-122.46233877833099	(37.7382246061744, -122.462338778331)
166905	166905	212015	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992309.190909999	2096565.06167	37.7363263207866	-122.469069279331	(37.7363263207866, -122.469069279331)
184196	184196	212014	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 8ft		5992297.48126	2096582.96013	37.736374788861205	-122.469111066343	(37.7363747888612, -122.469111066343)
129777	129777	206391	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	120 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994239.7131	2097149.97666	37.7380437093438	-122.462437122771	(37.7380437093438, -122.462437122771)
53048	53048	212079	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	121 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		5994275.39415	2097162.78754	37.7380809394917	-122.462314685482	(37.7380809394917, -122.462314685482)
163315	163315	212078	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	121 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		5994273.7868	2097185.68954	37.738143730144294	-122.462321903428	(37.7381437301443, -122.462321903428)
68348	68348	250621	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	122 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5987113.38286	2115127.17746	37.7869912030255	-122.48839686305	(37.7869912030255, -122.48839686305)
137115	137115	250622	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	122 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5987113.07989	2115137.65362	37.7870199498697	-122.48839868145001	(37.7870199498697, -122.48839868145)
58359	58359	250880	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	123 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5986777.36802	2114746.25153	37.7859256790604	-122.489531361397	(37.7859256790604, -122.489531361397)
132020	132020	250879	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	123 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986776.16352	2114759.61772	37.7859623084516	-122.489536511807	(37.7859623084516, -122.489536511807)
138692	138692	211998	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	125 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 6ft		5992395.16554	2095801.3809099998	37.73423441228179	-122.4687164798	(37.7342344122818, -122.4687164798)
175255	175255	211999	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	125 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5992394.52086	2095824.80518	37.7342986922182	-122.468720412541	(37.7342986922182, -122.468720412541)
149152	149152	212059	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	125 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 6ft		5994018.1401	2096987.89262	37.7375859049576	-122.46319144713499	(37.7375859049576, -122.463191447135)
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)
182959	182959	206392	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	128 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5994243.34729	2097107.2475700001	37.7379265951457	-122.46242145931002	(37.7379265951457, -122.46242145931)
50755	50755	206394	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5994249.85387	2097044.36217	37.7377543021223	-122.462394403183	(37.7377543021223, -122.462394403183)
173150	173150	206393	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5994247.2311	2097076.40691	37.7378421379962	-122.462405794887	(37.7378421379962, -122.462405794887)
53083	53083	189428	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1300 19th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6013707.60664	2105261.31352	37.761417556983794	-122.39569463232401	(37.7614175569838, -122.395694632324)
170496	170496	205510	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1300 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 3ft		5992006.66495	2098453.3701299997	37.741493652599004	-122.470252695404	(37.741493652599, -122.470252695404)
61641	61641	201457	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6018132.65618	2096036.7926	37.736334061269005	-122.37974915152	(37.736334061269, -122.37974915152)
154309	154309	201459	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018080.74427	2096037.10445	37.736332053971296	-122.379928656194	(37.7363320539713, -122.379928656194)
156271	156271	201455	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018178.0225	2096034.8800400002	37.73633131204021	-122.379592166743	(37.7363313120402, -122.379592166743)
158582	158582	201456	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018152.99448	2096035.88358	37.736332687111	-122.379678769657	(37.736332687111, -122.379678769657)
167624	167624	201458	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018111.7846800005	2096036.1618400002	37.7363311780414	-122.37982126995001	(37.7363311780414, -122.37982126995)
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)
157128	157128	212004	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		5992880.81315	2095779.08404	37.7342012344874	-122.467035834859	(37.7342012344874, -122.467035834859)
135766	135766	211997	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5992398.43952	2095776.76806	37.7341670206952	-122.468703370368	(37.7341670206952, -122.468703370368)
155689	155689	211996	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5992399.479180001	2095754.0907599998	37.7341048145672	-122.468698126425	(37.7341048145672, -122.468698126425)
154648	154648	211995	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	139 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5992400.12386	2095730.66617	37.7340405337493	-122.46869419369101	(37.7340405337493, -122.468694193691)
160630	160630	212080	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	139 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		5994293.29119	2096992.2350299999	37.7376136751377	-122.46224044105101	(37.7376136751377, -122.462240441051)
176137	176137	206395	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	140 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5994257.3897	2096991.2978599998	37.7376090346331	-122.46236450071999	(37.7376090346331, -122.46236450072)
175675	175675	206420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1400 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5993578.268619999	2095109.23905	37.7324022387669	-122.464575906676	(37.7324022387669, -122.464575906676)
44553	44553	212084	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	141 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5994307.65678	2096866.6023	37.7372695459555	-122.462181664062	(37.7372695459555, -122.462181664062)
30255	30255	212081	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	143 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		5994296.308209999	2096965.44252	37.737540283266796	-122.462228067287	(37.7375402832668, -122.462228067287)
32333	32333	212083	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	147 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 6ft		5994302.639880001	2096897.5947599998	37.7373543547061	-122.462201256705	(37.7373543547061, -122.462201256705)
123445	123445	212082	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	147 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		5994300.0141900005	2096928.83449	37.7374399800784	-122.462212599849	(37.7374399800784, -122.462212599849)
70769	70769	212047	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	15 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992333.0246	2096589.6494599998	37.7363952097605	-122.468988665905	(37.7363952097605, -122.468988665905)
138123	138123	212046	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	15 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 8ft		5992343.2495099995	2096563.97487	37.736325304562	-122.468951446557	(37.736325304562, -122.468951446557)
37009	37009	212053	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	15 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5994087.049869999	2097764.2191	37.7397214737582	-122.463009504383	(37.7397214737582, -122.463009504383)
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)
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)
39956	39956	206396	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	154 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5994267.308999999	2096914.39622	37.7373984529805	-122.46232462927601	(37.7373984529805, -122.462324629276)
168582	168582	211994	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	155 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5992403.615809999	2095680.37248	37.7339026415898	-122.468678462736	(37.7339026415898, -122.468678462736)
175425	175425	212085	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	155 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 6ft		5994311.1588	2096848.70915	37.7372206174375	-122.462168258776	(37.7372206174375, -122.462168258776)
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)
62673	62673	212086	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	161 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5994321.92466	2096778.9863200001	37.7370297956816	-122.46212598164301	(37.7370297956816, -122.462125981643)
27171	27171	211993	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	163 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5992397.64836	2095631.03278	37.7337668223846	-122.468695504899	(37.7337668223846, -122.468695504899)
53311	53311	211992	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	163 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 6ft		5992401.19029	2095601.1282400002	37.7336849166126	-122.468681084285	(37.7336849166126, -122.468681084285)
155343	155343	205494	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 6ft		5993684.29468	2104301.26828	37.757647339060796	-122.464876665145	(37.7576473390608, -122.464876665145)
165310	165310	205496	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993684.9556	2104264.78094	37.7575471923763	-122.464871729673	(37.7575471923763, -122.464871729673)
185555	185555	205495	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 6ft		5993684.89778	2104284.67686	37.757601818089206	-122.464873374503	(37.7576018180892, -122.464873374503)
180770	180770	212087	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	167 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994327.30745	2096736.9968299998	37.7369148128582	-122.462104326864	(37.7369148128582, -122.462104326864)
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)

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