Street_Tree_List

Data source: data.sfgov.org

2,584 rows where qCaretaker = 1 and 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

- 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

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
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
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
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
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
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)
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)
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)
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)
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)
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)
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)
118123	118123	107815	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	311 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	3x3		5986808.71714	2113837.73031	37.7834329707826	-122.489356078034	(37.7834329707826, -122.489356078034)
46760	46760	120018	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	333 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 2ft		5986813.0635400005	2113669.74125	37.782971974652604	-122.48932868568701	(37.7829719746526, -122.489328685687)
64736	64736	120017	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	343 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5986815.03872	2113631.20342	37.7828662761015	-122.48931901802	(37.7828662761015, -122.48931901802)
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)
184572	184572	119961	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	450 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 4ft		5987197.92043	2112907.45085	37.780901400579296	-122.48794122965299	(37.7809014005793, -122.487941229653)
124558	124558	87671	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	450 El Camino Del Mar	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1		05/22/2008 12:00:00 AM		3x3	Permit Number 50395	5987244.0	2115292.0	37.787451378555396	-122.48795707816299	(37.7874513785554, -122.487957078163)
96580	96580	43346	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
106000	106000	43348	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
142204	142204	43347	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
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)
173634	173634	68443	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1274 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/26/1993 12:00:00 AM	26	7.5x7.5	Permit Number 32300	5987418.73686806	2106612.65804585	37.7636305377833	-122.486714964872	(37.7636305377833, -122.486714964872)
124518	124518	65689	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	3601 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/17/1990 12:00:00 AM	15	4x3	Permit Number 28615	5987420.04323	2111837.39532	37.7779762857803	-122.487094195586	(37.7779762857803, -122.487094195586)
169338	169338	120058	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	132 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			37	Width 4ft		5987428.81431	2115064.18199	37.7868366349011	-122.48730092667401	(37.7868366349011, -122.487300926674)
50964	50964	120056	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	142 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		5987429.57525	2114999.01583	37.786657751693504	-122.487293505702	(37.7866577516935, -122.487293505702)
172929	172929	120057	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	142 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			31	Width 4ft		5987429.900230001	2115014.31734	37.786699784202106	-122.48729350569799	(37.7866997842021, -122.487293505698)
182229	182229	106951	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	156 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/02/2014 12:00:00 AM	22	3x3	Permit Number 773389	5987431.57269	2114958.38797	37.7865463157209	-122.487283609867	(37.7865463157209, -122.487283609867)
180044	180044	120055	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	146 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 5ft		5987431.73679	2114982.94917	37.786613763301794	-122.48728484684099	(37.7866137633018, -122.487284846841)

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