Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by XCoord

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
5515	5515	48743	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
6135	6135	48746	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
6948	6948	20002	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY46	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
6959	6959	48747	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
7180	7180	48749	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
7696	7696	19998	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY46	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
8095	8095	50823	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/19/2004 12:00:00 AM			Permit Number 47344
8773	8773	48750	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
8939	8939	48748	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
9025	9025	48744	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
10338	10338	30354	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1956 12:00:00 AM			Permit Number 43
10647	10647	19755	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY15	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3
13566	13566	48742	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
14417	14417	48751	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
15637	15637	48745	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
16097	16097	104813	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	1601X Portola Dr	5	Front Yard : Yard 7	Tree 1	Private 1
16139	16139	19754	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY15	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3
16857	16857	50824	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/19/2004 12:00:00 AM			Permit Number 47344
189144	189144	121399	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	349X Cargo Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2
44946	44946	184527	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1961 48th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5981338.0835	2101535.3662	37.7493333765729	-122.50736894655701	(37.7493333765729, -122.507368946557)
96965	96965	112126	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	8245 Geary Blvd		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			55	3x3		5981385.27932	2112314.25515	37.7789318748139	-122.508005614464	(37.7789318748139, -122.508005614464)
75336	75336	119014	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	865 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 1ft		5982296.59784	2109865.7372	37.772262614999	-122.50467158554599	(37.772262614999, -122.504671585546)
167257	167257	100577	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1201 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		5982377.2	2106858.6	37.764010624537896	-122.504169987001	(37.7640106245379, -122.504169987001)
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)
164496	164496	119006	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 43rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5982537.41596	2111769.70858	37.7775045285794	-122.50397963664801	(37.7775045285794, -122.503979636648)
43129	43129	54833	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	601 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/10/1972 12:00:00 AM	18		Permit Number 10687	5982543.3158	2111642.14145	37.777154613505395	-122.50394977664	(37.7771546135054, -122.50394977664)
68714	68714	119004	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 43rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		5982545.54155	2111623.4074	37.7771033061655	-122.503940689292	(37.7771033061655, -122.503940689292)
169075	169075	56603	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4199@43rd Lincoln Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0			5982724.27515302	2106932.91664164	37.764235082111895	-122.50297507862801	(37.7642350821119, -122.502975078628)
77188	77188	183328	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1216 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		5982751.4929	2106821.2818	37.7639301643939	-122.502872677188	(37.7639301643939, -122.502872677188)
10109	10109	114554	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1200x 43RD AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5982778.0	2106905.0	37.764161588502795	-122.50278719613199	(37.7641615885028, -122.502787196132)
135343	135343	183274	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1243 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		5983025.1929	2106638.7454	37.7634450534429	-122.50191253924	(37.7634450534429, -122.50191253924)
184826	184826	117915	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	831 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		5983218.794509999	2110128.25948	37.7730376298846	-122.501501101241	(37.7730376298846, -122.501501101241)
27827	27827	117873	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	884 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5983275.9121900005	2109791.81143	37.772117195094	-122.50127863614401	(37.772117195094, -122.501278636144)
156959	156959	184193	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1426 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 0ft		5983421.5653	2105406.7614	37.7600856503507	-122.500450541411	(37.7600856503507, -122.500450541411)
148935	148935	117774	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3749 Clement St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 5ft		5983871.99763	2113113.23064	37.7812718378682	-122.49946225972602	(37.7812718378682, -122.499462259726)
178409	178409	117974	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	428 38th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5984093.087730001	2112943.61137	37.7808190819455	-122.498684874737	(37.7808190819455, -122.498684874737)
67841	67841	117977	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	428 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5984094.5727	2112925.96733	37.7807707236381	-122.4986784338	(37.7807707236381, -122.4986784338)
34129	34129	63191	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	480 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1986 12:00:00 AM	14	4x9	Permit Number 23731	5984103.006630001	2112603.98729	37.7798871547077	-122.49862546555599	(37.7798871547077, -122.498625465556)
188559	188559	183674	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1271 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 0ft		5984268.7246	2106531.5004	37.7632235599314	-122.49760371081301	(37.7632235599314, -122.497603710813)
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)
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)
150736	150736	118051	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	451 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5984674.55731	2112758.40863	37.7803446541387	-122.496659647186	(37.7803446541387, -122.496659647186)
160351	160351	63201	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	434 36th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1986 12:00:00 AM	17		Permit Number 23742	5984713.13689	2112937.02697	37.7808373486479	-122.496539369055	(37.7808373486479, -122.496539369055)
103615	103615	21143	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2292X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984947.8628076	2099601.6268993	37.7442358239277	-122.49474388696001	(37.7442358239277, -122.49474388696)
57355	57355	187371	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2200 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5985087.8176	2099932.3285	37.745152031922295	-122.494284331613	(37.7451520319223, -122.494284331613)
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)
60974	60974	118186	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	646 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 5ft		5985387.96232	2111474.08319	37.776860037302704	-122.494096998013	(37.7768600373027, -122.494096998013)
117813	117813	32306	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
143520	143520	32305	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
144054	144054	32304	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
98155	98155	19460	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1700X Sloat Blvd	6	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5985858.9484667	2095882.6709765	37.7340778499573	-122.49131993236901	(37.7340778499573, -122.491319932369)
69852	69852	119415	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	463 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5985915.10497	2112796.56014	37.7805220119226	-122.49237088698601	(37.7805220119226, -122.492370886986)
144522	144522	95498	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X 32nd Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4			18	3x3		5985976.055430001	2112422.37376	37.779498166536605	-122.492132474117	(37.7794981665366, -122.492132474117)
87843	87843	95499	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X 32nd Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4			18	3x3		5985977.73249	2112402.27637	37.7794430828921	-122.49212519236	(37.7794430828921, -122.49212519236)
110535	110535	95495	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X 32nd Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4			6	3x3		5986000.954969999	2111699.3103	37.7775142963957	-122.49199308703699	(37.7775142963957, -122.491993087037)
124247	124247	88364	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2559 33rd Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51343	5986101.6	2097823.5	37.739421027827	-122.490623769288	(37.739421027827, -122.490623769288)
89161	89161	9257	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6600X Geary Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	8M		5986360.871619999	2112530.52863	37.7798176164012	-122.490809209885	(37.7798176164012, -122.490809209885)
122879	122879	100167	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	710 El Camino Del Mar	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5986405.6	2114870.0	37.7862437457696	-122.49082666767099	(37.7862437457696, -122.490826667671)
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)
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)
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)
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)
96107	96107	113492	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 LAKE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986565.0	2114493.0	37.7852179229774	-122.49024745024299	(37.7852179229774, -122.490247450243)
126491	126491	113493	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 LAKE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986565.0	2114493.0	37.7852179229774	-122.49024745024299	(37.7852179229774, -122.490247450243)
139366	139366	113494	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 LAKE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986565.0	2114493.0	37.7852179229774	-122.49024745024299	(37.7852179229774, -122.490247450243)
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)
172328	172328	119945	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 6ft		5986569.07074	2113183.43269	37.7816224647501	-122.490137005951	(37.7816224647501, -122.490137005951)
124223	124223	99344	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		8	3x3		5986571.83486	2113111.88593	37.781426179231204	-122.49012217925899	(37.7814261792312, -122.490122179259)
85197	85197	99341	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	19	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		24	4x5		5986573.71046	2113038.86406	37.7812257915862	-122.49011031791001	(37.7812257915862, -122.49011031791)
107292	107292	99342	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		8	3x3		5986574.23671	2113063.60704	37.7812937594666	-122.49011031789301	(37.7812937594666, -122.490110317893)
95801	95801	99340	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		30	6x8		5986575.04866	2113011.09375	37.7811496204005	-122.49010364520299	(37.7811496204005, -122.490103645203)
91017	91017	99338	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		4	3X3		5986576.26956	2112967.74794	37.7810306764919	-122.490096232309	(37.7810306764919, -122.490096232309)
86659	86659	99336	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		3	3x3		5986577.60051	2112919.49158	37.7808982560395	-122.490088077428	(37.7808982560395, -122.490088077428)
109890	109890	99334	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	450 30th Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		4	3x3		5986579.77919	2112870.79018	37.780764663134896	-122.49007695716298	(37.7807646631349, -122.490076957163)
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)
82909	82909	95459	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	657X 30th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		18	3x3		5986588.2	2111449.2	37.776861872872	-122.48994323847201	(37.776861872872, -122.489943238472)
74498	74498	182755	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1778 31st Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		5986605.2662	2103150.8832	37.7540779977586	-122.489273926281	(37.7540779977586, -122.489273926281)
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)
62011	62011	182756	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1770 31st Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5986605.7278	2103174.4256	37.7541426657227	-122.489274060805	(37.7541426657227, -122.489274060805)
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)
127052	127052	115699	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 LAKE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x15		5986626.0	2114487.0	37.785205010982	-122.49003597043699	(37.785205010982, -122.490035970437)
127375	127375	115701	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 LAKE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x15		5986626.0	2114487.0	37.785205010982	-122.49003597043699	(37.785205010982, -122.490035970437)
139495	139495	115700	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 LAKE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x15		5986626.0	2114487.0	37.785205010982	-122.49003597043699	(37.785205010982, -122.490035970437)
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)
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)
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)
77642	77642	120125	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986678.0	2115081.0	37.786839000237705	-122.489899771602	(37.7868390002377, -122.489899771602)
88791	88791	120126	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986678.0	2115081.0	37.786839000237705	-122.489899771602	(37.7868390002377, -122.489899771602)
104796	104796	120124	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986678.0	2115081.0	37.786839000237705	-122.489899771602	(37.7868390002377, -122.489899771602)
109515	109515	120127	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986678.0	2115081.0	37.786839000237705	-122.489899771602	(37.7868390002377, -122.489899771602)
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)
80498	80498	115704	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 LAKE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x15		5986689.0	2114483.0	37.7851977068092	-122.489817718558	(37.7851977068092, -122.489817718558)
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)
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)
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)

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