Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by TreeID 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, PlantType, qCaretaker, qCareAssistant

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
4673	4673	253651	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	131 Font Blvd	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5990844.0	2088883.0	37.7151485301311	-122.473574812248	(37.7151485301311, -122.473574812248)
1614	1614	251637	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1640 Eddy St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6002593.76659	2112688.5347700003	37.7811863760687	-122.43466384314199	(37.7811863760687, -122.434663843142)
1471	1471	251536	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2799 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6002520.0	2095715.0	37.734576941489294	-122.433705562416	(37.7345769414893, -122.433705562416)
1453	1453	251535	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2799 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6002520.0	2095715.0	37.734576941489294	-122.433705562416	(37.7345769414893, -122.433705562416)
1438	1438	251533	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1201X Pierce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6002292.0	2112799.0	37.7814725496882	-122.43571571002899	(37.7814725496882, -122.435715710029)
821	821	251392	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Bosworth St	9	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2				Width 3ft		6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
813	813	251390	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Bosworth St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				Width 3ft		6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
187	187	251248	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	829 Chenery St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6001839.0	2095802.0	37.7347771581377	-122.436066227259	(37.7347771581377, -122.436066227259)
197	197	251245	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	701 Chenery St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/04/1992 12:00:00 AM				6002463.96916	2095671.24377	37.73445361741221	-122.433896153002	(37.7344536174122, -122.433896153002)
150851	150851	251082	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600x Geary Blvd	4	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5989477.5192	2112643.2957	37.7803088175248	-122.480035730601	(37.7803088175248, -122.480035730601)
44686	44686	251075	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5100x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990994.9145	2112700.954	37.7805551774565	-122.47479062026899	(37.7805551774565, -122.474790620269)
74409	74409	251072	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200x Geary Blvd	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5990697.77	2112688.192	37.7805029132293	-122.475817641236	(37.7805029132293, -122.475817641236)
32868	32868	251069	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5990794.5513	2112690.3427	37.7805144291466	-122.47548298954099	(37.7805144291466, -122.475482989541)
60953	60953	251054	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988209.3153	2112595.4218	37.7801036030677	-122.48441946896601	(37.7801036030677, -122.484419468966)
166322	166322	251051	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5900x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988530.6021	2112606.8245	37.780153615018705	-122.48330884168699	(37.7801536150187, -122.483308841687)
149750	149750	251044	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600x Geary Blvd	2	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5989568.3861	2112643.8334	37.7803155729867	-122.47972142279801	(37.7803155729867, -122.479721422798)
51690	51690	251039	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5400x Geary Blvd	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 6ft		5990159.2899	2112663.7273	37.780404505362	-122.47767868930201	(37.780404505362, -122.477678689302)
76481	76481	251028	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991390.9488	2112709.5778	37.780601797334704	-122.47342119229799	(37.7806017973347, -122.473421192298)
167379	167379	251026	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991422.3485	2112710.0201	37.780604829996	-122.47331259909599	(37.780604829996, -122.473312599096)
67631	67631	251025	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	4	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991443.5764	2112711.3468	37.7806097019127	-122.47323925917101	(37.7806097019127, -122.473239259171)
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)
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)
64763	64763	250863	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	182 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5986521.03472	2114531.78517	37.785321848163	-122.490402408767	(37.785321848163, -122.490402408767)
60705	60705	250862	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	182 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 4ft		5986521.14274	2114515.47743	37.7852770781159	-122.49040083493401	(37.7852770781159, -122.490400834934)
164039	164039	250747	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986546.42612	2114480.8056900003	37.7851833561615	-122.490310811904	(37.7851833561615, -122.490310811904)
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)
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)
69453	69453	250744	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986605.68633	2114473.44554	37.785166608101	-122.490105251155	(37.785166608101, -122.490105251155)
152428	152428	250743	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986628.9132900005	2114471.1216	37.7851615835861	-122.490024723187	(37.7851615835861, -122.490024723187)
160281	160281	250742	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 4ft		5986642.93068	2114467.77379	37.7851532099925	-122.489975981713	(37.7851532099925, -122.489975981713)
70937	70937	250741	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5986676.6053	2114467.05765	37.785153209986895	-122.489859426897	(37.7851532099869, -122.489859426897)
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)
168078	168078	250739	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 4ft		5986710.27993	2114466.3415599996	37.785153210004	-122.48974287205	(37.785153210004, -122.48974287205)
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)
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)
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)
158270	158270	250661	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5986629.196690001	2115016.79506	37.786659862212794	-122.490063893129	(37.7866598622128, -122.490063893129)
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)
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)
172011	172011	250333	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 27th Ave	1	: 4	Tree 1	Private 1			15	Width 3ft		5987387.37303	2115049.79038	37.786794702950395	-122.487443244435	(37.7867947029504, -122.487443244435)
48672	48672	250325	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	165 27th Ave	1	: 4	Tree 1	Private 1			13	Width 3ft		5987394.93306	2114848.62147	37.7862427917124	-122.487402306398	(37.7862427917124, -122.487402306398)
183252	183252	249775	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	102 Pfeiffer St	6	Side Yard : Yard 17	Tree 1	Private 1			21	Width 0ft		6010401.04426	2121152.2311400003	37.8048657692012	-122.40825153418999	(37.8048657692012, -122.40825153419)
168933	168933	249774	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	102 Pfeiffer St	5	Side Yard : Yard 17	Tree 1	Private 1			6	Width 0ft		6010412.38512	2121159.3166	37.804885859146104	-122.408212787783	(37.8048858591461, -122.408212787783)
170804	170804	249742	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	26	Front Yard : Yard 7	Tree 1	Private 1			15			6000223.59296	2117195.73646	37.7934271400971	-122.44318725311199	(37.7934271400971, -122.443187253112)
26081	26081	249738	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	22	: 4	Tree 1	Private 1			17	Width 3ft		6000189.3449800005	2117178.8516	37.7933788258243	-122.443304539972	(37.7933788258243, -122.443304539972)
150758	150758	249737	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	21	: 4	Tree 1	Private 1			31	Width 3ft		6000190.59568	2117194.0821599998	37.79342071625479	-122.443301306923	(37.7934207162548, -122.443301306923)
136241	136241	249736	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	20	: 4	Tree 1	Private 1			27	Width 3ft		6000189.43372	2117210.1069799997	37.793464649935004	-122.443306478906	(37.793464649935, -122.443306478906)
154539	154539	249734	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	18	: 4	Tree 1	Private 1			18	Width 3ft		6000189.35752	2117224.43489	37.7935039862606	-122.44330777215299	(37.7935039862606, -122.443307772153)
26897	26897	249733	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	17	: 4	Tree 1	Private 1			22	Width 3ft		6000186.12585	2117239.7585400003	37.7935458766883	-122.4433200551	(37.7935458766883, -122.4433200551)
176767	176767	249732	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	16	: 4	Tree 1	Private 1			22	Width 3ft		6000181.11943	2117259.58432	37.793600027574	-122.443338802346	(37.793600027574, -122.443338802346)
189033	189033	249723	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	7	Front Yard : Yard 7	Tree 1	Private 1			15			6000201.87433	2117349.10426	37.7938470092862	-122.443273421624	(37.7938470092862, -122.443273421624)
163343	163343	249722	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	6	Front Yard : Yard 7	Tree 1	Private 1			14			6000190.26691	2117349.57001	37.7938476262185	-122.443313617731	(37.7938476262185, -122.443313617731)
23909	23909	249678	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2400 Baker St	10	Front Yard : Yard 7	Tree 1	Private 1			24			5999727.06015	2117202.6736	37.7934178626924	-122.444905786498	(37.7934178626924, -122.444905786498)
67093	67093	249488	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500x Van Ness Ave	2	Median : Yard 3	Tree 1	DPW 2			28			6006252.337669999	2115769.3960599997	37.7898526811986	-122.422225932188	(37.7898526811986, -122.422225932188)
59551	59551	249480	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1300x Van Ness Ave	4	Median : Yard 3	Tree 1	DPW 2			18			6006341.46577	2115150.70304	37.788158930442705	-122.421873590397	(37.7881589304427, -122.421873590397)
180628	180628	249479	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1300x Van Ness Ave	3	Median : Yard 3	Tree 1	DPW 2			13			6006342.53317	2115134.23147	37.7881137637835	-122.42186872687799	(37.7881137637835, -122.421868726878)
135502	135502	249477	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1300x Van Ness Ave	1	Median : Yard 3	Tree 1	DPW 2			19			6006355.55828	2115049.12823	37.7878808258785	-122.421817614792	(37.7878808258785, -122.421817614792)
25183	25183	249466	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900x Van Ness Ave	4	Median : Yard 3	Tree 1	DPW 2			25			6006522.49711	2113836.87509	37.7845616899264	-122.421153924138	(37.7845616899264, -122.421153924138)
25906	25906	249410	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	698 Polk St	1	: 4	Tree 1	Private 1			17	Width 3ft		6007114.554409999	2113257.76141	37.7830049436594	-122.419064511231	(37.7830049436594, -122.419064511231)
132602	132602	248910	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3765 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6003294.528609999	2103577.48942	37.756209426537296	-122.431588899011	(37.7562094265373, -122.431588899011)
62471	62471	248909	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4011 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6003751.66746	2101264.8805	37.7498854469596	-122.42984300914699	(37.7498854469596, -122.429843009147)
145226	145226	248908	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4038 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6002883.45904	2102428.0017	37.753029898615296	-122.43292839784901	(37.7530298986153, -122.432928397849)
169520	169520	248907	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	579 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6001887.27932	2102476.58126	37.7531067330981	-122.43637685090799	(37.7531067330981, -122.436376850908)
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)
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)
174550	174550	248904	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4109 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			28	Width 5ft		6001658.90013	2103489.46423	37.7558748868343	-122.437239147875	(37.7558748868343, -122.437239147875)
153748	153748	248903	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	432 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6001779.16391	2103312.47449	37.7553957514195	-122.43681056786501	(37.7553957514195, -122.436810567865)
166316	166316	248902	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4016 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 3ft		6001704.771000001	2102951.17694	37.754399486961496	-122.43704197511299	(37.7543994869615, -122.437041975113)
71996	71996	248901	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4018 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 3ft		6001677.541540001	2102947.7965	37.754388657315204	-122.43713589940201	(37.7543886573152, -122.437135899402)
169769	169769	248900	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4031 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6001710.91978	2102906.53685	37.754277265496995	-122.437017515355	(37.754277265497, -122.437017515355)
170101	170101	248899	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4007 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			32	Width 3ft		6001751.7117	2102909.0732299997	37.754286548302105	-122.436876628447	(37.7542865483021, -122.436876628447)
149221	149221	248898	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4330 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 5ft		6001712.82144	2101195.45283	37.74957914598279	-122.43688845273898	(37.7495791459828, -122.436888452739)
47072	47072	248897	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2180 Harrison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008740.58831	2105563.2246	37.7619689825909	-122.412894888612	(37.7619689825909, -122.412894888612)
72127	72127	248896	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2180 Harrison St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008741.39067	2105548.32623	37.761928120121105	-122.41289106017	(37.7619281201211, -122.41289106017)
167074	167074	248895	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2180 Harrison St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008739.84494	2105526.86138	37.7618690957999	-122.412894888598	(37.7618690957999, -122.412894888598)
134440	134440	248894	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2180 Harrison St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008743.38004	2105510.2537700003	37.7618236935412	-122.412881487815	(37.7618236935412, -122.412881487815)
50570	50570	248893	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2180 Harrison St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6008745.11991	2105487.06806	37.7617601285574	-122.412873830958	(37.7617601285574, -122.412873830958)
27207	27207	248892	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft		6008750.65836	2105378.92205	37.7614634952709	-122.412847029394	(37.7614634952709, -122.412847029394)
24125	24125	248891	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008751.84514	2105355.74765	37.7613999302905	-122.412841286317	(37.7613999302905, -122.412841286317)
165418	165418	248890	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008751.960469999	2105307.2407299997	37.761266747868795	-122.412837457901	(37.7612667478688, -122.412837457901)
170374	170374	248889	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008750.48233	2105289.08158	37.761216804031896	-122.412841286292	(37.7612168040319, -122.412841286292)
76528	76528	248888	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6008755.0113	2105266.94132	37.7611562661572	-122.41282405711	(37.7611562661572, -122.41282405711)
66261	66261	248887	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008757.9269900005	2105220.03021	37.76102762264129	-122.4128106563	(37.7610276226413, -122.4128106563)
56199	56199	248886	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008759.226419999	2105202.36551	37.760979192353	-122.41280491321699	(37.760979192353, -122.412804913217)
74251	74251	248885	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft		6008756.1347199995	2105159.43583	37.7608611437375	-122.412812570938	(37.7608611437375, -122.412812570938)
36403	36403	248884	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008760.77661	2105142.80494	37.760815739663	-122.412795340833	(37.760815739663, -122.412795340833)
147186	147186	248883	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2250 Harrison St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008762.40389	2105114.10954	37.760737039994105	-122.412787684021	(37.7607370399941, -122.412787684021)
136258	136258	248882	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3178 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6008330.54248	2105655.72917	37.7621999536859	-122.414319626947	(37.7621999536859, -122.414319626947)
29616	29616	248881	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3180 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 3ft		6008291.8652099995	2105649.74551	37.762181351215	-122.414452973944	(37.762181351215, -122.414452973944)
73340	73340	248880	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3180 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6008273.77565	2105652.3739400003	37.7621875520344	-122.41451572504499	(37.7621875520344, -122.414515725045)
134688	134688	248879	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3180 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008253.91646	2105651.65095	37.762184451173205	-122.41458435948299	(37.7621844511732, -122.414584359483)
154695	154695	248878	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3198 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008231.80184	2105651.53879	37.7621829007524	-122.414660837842	(37.7621829007524, -122.414660837842)
31608	31608	248877	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3198 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft		6008213.63146	2105650.21693	37.7621782503345	-122.41472358891701	(37.7621782503345, -122.414723588917)
172023	172023	248876	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3198 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6008197.73932	2105649.4128099997	37.7621751494859	-122.414778497038	(37.7621751494859, -122.414778497038)
156055	156055	248875	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3235 19th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 5ft		6007920.63685	2105047.56348	37.7605070365959	-122.415694275785	(37.7605070365959, -122.415694275785)
149605	149605	248874	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3235 19th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 5ft		6007943.30704	2105047.09936	37.7605070365849	-122.415615836902	(37.7605070365849, -122.415615836902)
25707	25707	248873	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3160 19th St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6008240.90037	2105070.93341	37.760589203142096	-122.414588281427	(37.7605892031421, -122.414588281427)
31152	31152	248872	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3160 19th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 3ft		6008359.97725	2105071.32021	37.760596954408896	-122.41417647467699	(37.7605969544089, -122.414176474677)

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