Street_Tree_List

Data source: data.sfgov.org

340 rows where qSiteInfo = 2 and qSpecies = 60

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
9497	9497	122159	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	547 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5991246.192840001	2111684.05416	37.7777776077222	-122.473847129053	(37.7777776077222, -122.473847129053)
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)
23531	23531	212068	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	65 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 6ft		5994349.34377	2097659.88165	37.7394500943456	-122.46209504585501	(37.7394500943456, -122.462095045855)
23683	23683	250745	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 4ft		5986584.92122	2114476.3273400003	37.7851733080538	-122.490177303062	(37.7851733080538, -122.490177303062)
23722	23722	206382	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	6 San Pablo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5994455.43125	2097793.85045	37.7398240468482	-122.46173795563601	(37.7398240468482, -122.461737955636)
24416	24416	212061	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	21 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994643.85383	2097859.63633	37.740015523303704	-122.461091241468	(37.7400155233037, -122.461091241468)
24903	24903	201466	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	301 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017699.909990001	2096021.8364	37.7362691149141	-122.38124431128	(37.7362691149141, -122.38124431128)
25739	25739	212063	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	39 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994526.15715	2097790.3563900003	37.7398185241173	-122.461493163775	(37.7398185241173, -122.461493163775)
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)
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)
26629	26629	250746	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5986565.35449	2114477.9632599996	37.7851766571216	-122.490245117336	(37.7851766571216, -122.490245117336)
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)
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)
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)
28487	28487	212010	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 8ft		5992076.0582	2094714.7951200001	37.7312324797943	-122.46974064571998	(37.7312324797943, -122.46974064572)
28708	28708	212033	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	77 San Leandro Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 8ft		5992382.09631	2096171.88188	37.7352509600559	-122.468788615307	(37.7352509600559, -122.468788615307)
28741	28741	206387	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	30 San Pablo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5994342.8206	2097706.8067400004	37.7395785633932	-122.46212100211001	(37.7395785633932, -122.46212100211)
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)
29367	29367	212102	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	44 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 4ft		5993921.96235	2101201.24638	37.7491491737956	-122.463829711299	(37.7491491737956, -122.463829711299)
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)
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)
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)
31258	31258	118000	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	7 Shore View Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5984651.74201	2112846.53753	37.7805852938125	-122.49674508055	(37.7805852938125, -122.49674508055)
32205	32205	201465	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		6017857.702409999	2096046.34832	37.736345129211294	-122.380700455256	(37.7363451292113, -122.380700455256)
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)
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)
32948	32948	212023	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	60 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 8ft		5992352.18308	2096253.2392099998	37.7354726186689	-122.46889795397699	(37.7354726186689, -122.468897953977)
33597	33597	212097	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 San Marcos Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 4ft		5993967.57879	2100058.04497	37.7460128610013	-122.463589013141	(37.7460128610013, -122.463589013141)
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)
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)
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)
35345	35345	212007	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992022.6744800005	2094535.4646599998	37.7307369974034	-122.469912149146	(37.7307369974034, -122.469912149146)
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)
36013	36013	201469	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017698.8541	2095974.10398	37.7361379928748	-122.381244644042	(37.7361379928748, -122.381244644042)
36702	36702	212005	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			49	Width 8ft		5991983.8699	2094464.4262700002	37.73053970054001	-122.470041130814	(37.73053970054, -122.470041130814)
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)
37133	37133	212073	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	97 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 6ft		5994261.112380001	2097463.04726	37.7389045557057	-122.46238583625	(37.7389045557057, -122.46238583625)
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)
37267	37267	212009	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 8ft		5992050.07919	2094590.8204299998	37.730890574625896	-122.469821436321	(37.7308905746259, -122.469821436321)
37811	37811	126171	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		6000513.1495	2118370.5778099997	37.7966694514978	-122.44226974674801	(37.7966694514978, -122.442269746748)
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)
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)
38426	38426	250669	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	710 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5986459.66252	2114899.76935	37.786328641889604	-122.49064181907801	(37.7863286418896, -122.490641819078)
39555	39555	212032	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	77 San Leandro Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5992384.20886	2096144.3676099998	37.7351755348194	-122.46877931001998	(37.7351755348194, -122.46877931002)
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)
40202	40202	206386	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	30 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994357.93255	2097720.43356	37.739616849330396	-122.462069739853	(37.7396168493304, -122.462069739853)
40300	40300	206397	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	170 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994276.7477400005	2096834.22345	37.7371788619233	-122.462286182385	(37.7371788619233, -122.462286182385)
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)
41238	41238	212072	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	93 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994265.100769999	2097482.56478	37.73895837563	-122.462373461579	(37.73895837563, -122.462373461579)
42507	42507	118050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	451 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		5984672.88957	2112829.17852	37.7805388700497	-122.496670640749	(37.7805388700497, -122.496670640749)
43012	43012	212034	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	75 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		5992381.096530001	2096188.3178599998	37.7352960313735	-122.468793267506	(37.7352960313735, -122.468793267506)
43190	43190	122146	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	31 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5991133.9927199995	2114818.51521	37.7863774717716	-122.47446406594999	(37.7863774717716, -122.47446406595)
43233	43233	206380	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 San Pablo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5994546.31617	2097846.4901	37.7399738136269	-122.46142753126499	(37.7399738136269, -122.461427531265)
44070	44070	206403	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	190 San Pablo Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5994311.54051	2096607.92248	37.7365594988302	-122.462149481812	(37.7365594988302, -122.462149481812)
44074	44074	212044	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	29 San Leandro Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992357.053169999	2096532.5298400002	37.7362397619376	-122.468901434378	(37.7362397619376, -122.468901434378)
44546	44546	201472	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017871.79142	2095999.43852	37.7362171017244	-122.38064848344601	(37.7362171017244, -122.380648483446)
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)
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)
45201	45201	205498	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	339 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5992906.69703	2102511.7445400003	37.7526889062749	-122.467435765149	(37.7526889062749, -122.467435765149)
45672	45672	126172	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6000514.61681	2118336.13924	37.7965749759056	-122.44226219603901	(37.7965749759056, -122.442262196039)
46109	46109	250740	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5986687.60002	2114465.60377	37.785149860023	-122.48982128213899	(37.785149860023, -122.489821282139)
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)
46573	46573	212020	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	52 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 8ft		5992351.56186	2096319.4479099999	37.7356543752416	-122.468904918344	(37.7356543752416, -122.468904918344)
47892	47892	176012	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	460 Peninsula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		6012147.1719	2086483.56891	37.709770881279205	-122.399773002936	(37.7097708812792, -122.399773002936)
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)
48843	48843	212065	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	49 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994471.608469999	2097757.10543	37.7397240853877	-122.461679358529	(37.7397240853877, -122.461679358529)
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)
49352	49352	206404	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	266 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 4ft		5993796.30726	2096316.2667599998	37.7357290054893	-122.46390968530001	(37.7357290054893, -122.4639096853)
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)
50508	50508	201463	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017910.1596099995	2096044.43658	37.736342774794004	-122.380518954089	(37.736342774794, -122.380518954089)
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)
51230	51230	212026	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	78 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5992350.77465	2096170.19612	37.7352445218171	-122.468896782157	(37.7352445218171, -122.468896782157)
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)
52822	52822	212008	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992037.66207	2094565.76948	37.730821073223	-122.469862540745	(37.730821073223, -122.469862540745)
53020	53020	206383	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	20 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994405.7043699995	2097759.62337	37.739727205141705	-122.461907407719	(37.7397272051417, -122.461907407719)
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)
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)
53113	53113	212043	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	29 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			46	Width 8ft		5992369.57859	2096472.3022900003	37.736075115876105	-122.46885374781701	(37.7360751158761, -122.468853747817)
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)
53883	53883	212057	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	73 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 6ft		5993976.115130001	2097320.06898	37.7384955575352	-122.463360844337	(37.7384955575352, -122.463360844337)
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)
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)
55064	55064	205520	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	185 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5992406.58336	2095533.04722	37.733498294707104	-122.46865748696199	(37.7334982947071, -122.468657486962)
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)
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)
55423	55423	212055	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	55 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 6ft		5993982.62743	2097474.6766	37.738920446732294	-122.463349544345	(37.7389204467323, -122.463349544345)
56986	56986	126173	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34	Width 6ft		6000518.259380001	2118317.0827099998	37.7965228593064	-122.442248223283	(37.7965228593064, -122.442248223283)
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)
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)

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