Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by XCoord 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
184420	184420	201549	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 Innes Ave	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 6ft		6020789.549380001	2093251.9329799998	37.728833562500206	-122.370370588629	(37.7288335625002, -122.370370588629)
156960	156960	201545	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 Innes Ave	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27			6020633.70615	2093371.77747	37.729154078192394	-122.37091763995701	(37.7291540781924, -122.370917639957)
61517	61517	201542	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 Innes Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28			6020585.50312	2093400.1960900002	37.7292294638519	-122.37108624845699	(37.7292294638519, -122.371086248457)
156271	156271	201455	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018178.0225	2096034.8800400002	37.73633131204021	-122.379592166743	(37.7363313120402, -122.379592166743)
59201	59201	189515	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 Acacia Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018172.45187	2096173.93541	37.7367128233477	-122.379621084471	(37.7367128233477, -122.379621084471)
27752	27752	189516	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018169.488059999	2096212.3358099998	37.7368180997786	-122.37963399873699	(37.7368180997786, -122.379633998737)
56331	56331	189514	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 Acacia Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018158.36109	2096173.36001	37.7367104662145	-122.37966976297399	(37.7367104662145, -122.379669762974)
158582	158582	201456	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018152.99448	2096035.88358	37.736332687111	-122.379678769657	(37.736332687111, -122.379678769657)
186766	186766	189517	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6018151.686369999	2096212.97966	37.7368188857736	-122.37969559237301	(37.7368188857736, -122.379695592373)
72964	72964	189518	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018139.6232	2096213.2219900002	37.736818885776	-122.379737317327	(37.736818885776, -122.379737317327)
162527	162527	189513	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 Acacia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018133.38456	2096174.4339299998	37.7367120373179	-122.37975619319499	(37.7367120373179, -122.379756193195)
61641	61641	201457	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6018132.65618	2096036.7926	37.736334061269005	-122.37974915152	(37.736334061269, -122.37974915152)
71375	71375	189519	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6018116.094190001	2096214.8390400002	37.7368220280049	-122.379818780634	(37.7368220280049, -122.379818780634)
167624	167624	201458	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018111.7846800005	2096036.1618400002	37.7363311780414	-122.37982126995001	(37.7363311780414, -122.37982126995)
161351	161351	189520	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6018095.44922	2096216.97069	37.7368267422621	-122.379890308193	(37.7368267422621, -122.379890308193)
165986	165986	189512	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6018094.93182	2096176.92332	37.7367167515701	-122.379889315347	(37.7367167515701, -122.379889315347)
154309	154309	201459	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018080.74427	2096037.10445	37.736332053971296	-122.379928656194	(37.7363320539713, -122.379928656194)
41770	41770	189511	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 Acacia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018076.84879	2096177.85881	37.7367183226971	-122.379951901885	(37.7367183226971, -122.379951901885)
188914	188914	189521	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018061.54589	2096217.07965	37.7368251711525	-122.380007535722	(37.7368251711525, -122.380007535722)
171514	171514	189509	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 Ironwood Way	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6018048.65488	2096118.9108099998	37.73655490778779	-122.380045286575	(37.7365549077878, -122.380045286575)
178762	178762	189510	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 Ironwood Way	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018047.85099	2096150.4009099999	37.736641329019	-122.38005025352	(37.736641329019, -122.38005025352)
72330	72330	189508	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 Ironwood Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018046.5925199995	2096102.07056	37.7365085540177	-122.38005124726601	(37.7365085540177, -122.380051247266)
186680	186680	189507	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 Ironwood Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018046.04082	2096060.30667	37.736393848204706	-122.380050253535	(37.7363938482047, -122.380050253535)
40797	40797	189503	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Ironwood Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018009.208980001	2096118.5269	37.7365516774059	-122.38018164266501	(37.7365516774059, -122.380181642665)
134874	134874	189504	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Ironwood Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018008.38101	2096102.2661400002	37.7365069828979	-122.38018337567301	(37.7365069828979, -122.380183375673)
66916	66916	189502	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Ironwood Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018008.300980001	2096155.48748	37.7366531137419	-122.380187349771	(37.7366531137419, -122.380187349771)
28444	28444	189505	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Ironwood Way	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018007.03661	2096078.2583	37.736440987949	-122.38018635601101	(37.736440987949, -122.380186356011)
65142	65142	189506	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Ironwood Way	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018006.17491	2096063.96927	37.736401705559395	-122.380188342614	(37.7364017055594, -122.380188342614)
181975	181975	189522	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	211 Acacia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018001.89898	2096225.38149	37.7368446756287	-122.380214340243	(37.7368446756287, -122.380214340243)
73203	73203	189501	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017983.54314	2096181.73638	37.736723822038606	-122.38027477286501	(37.7367238220386, -122.380274772865)
62552	62552	201477	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017976.131469999	2095993.98649	37.7362078890842	-122.380287354394	(37.7362078890842, -122.380287354394)
172918	172918	201460	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6017973.047069999	2096042.30781	37.7363403996791	-122.380301375718	(37.7363403996791, -122.380301375718)
181318	181318	189500	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017962.8634	2096182.15193	37.7367238220301	-122.38034630134399	(37.7367238220301, -122.380346301344)
59368	59368	201476	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017960.44466	2095995.0605900001	37.736209972812	-122.38034166533899	(37.736209972812, -122.380341665339)
186199	186199	201461	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017953.45292	2096043.24066	37.7363418799584	-122.380369186391	(37.7363418799584, -122.380369186391)
168710	168710	189523	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	211 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017947.90713	2096226.7189599997	37.736845369003504	-122.380401108742	(37.7368453690035, -122.380401108742)
34315	34315	189499	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017942.78126	2096183.7002	37.7367269651779	-122.38041584233999	(37.7367269651779, -122.38041584234)
165445	165445	201475	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017932.44765	2095996.0751900002	37.73621121387271	-122.38043853402	(37.7362112138727, -122.38043853402)
186851	186851	201462	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017931.88164	2096043.5768799998	37.736341612873	-122.380443791448	(37.736341612873, -122.380443791448)
177833	177833	189498	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017927.2772	2096184.2977	37.7367277502815	-122.38046948869801	(37.7367277502815, -122.380469488698)
174570	174570	189524	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	211 Acacia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017920.34086	2096230.5560599999	37.7368543838092	-122.380496685098	(37.7368543838092, -122.380496685098)
183263	183263	201474	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017913.7738	2095996.98532	37.73621268247221	-122.380503161112	(37.7362126824722, -122.380503161112)
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)
83012	83012	201473	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017891.6083	2095998.1068	37.736214538679	-122.380579875087	(37.736214538679, -122.380579875087)
137721	137721	189525	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	213 Acacia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017891.20284	2096231.8992299999	37.7368564639644	-122.38059752247	(37.7368564639644, -122.38059752247)
178359	178359	201464	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017881.76944	2096045.3386099997	37.7363436849175	-122.380617174457	(37.7363436849175, -122.380617174457)
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)
147426	147426	189526	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	213 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017871.68809	2096232.54396	37.7368571573346	-122.380665039075	(37.7368571573346, -122.380665039075)
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)
176480	176480	189497	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017857.1903	2096185.42035	37.7367269651611	-122.380711890149	(37.7367269651611, -122.380711890149)
132446	132446	189527	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	213 Acacia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017855.19484	2096232.11788	37.7368550771857	-122.380722034501	(37.7368550771857, -122.380722034501)
71811	71811	189496	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017841.42794	2096187.45373	37.736731678516	-122.380766529361	(37.736731678516, -122.380766529361)
159773	159773	189528	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	213 Acacia Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017830.36158	2096233.12207	37.736856463959704	-122.380807964714	(37.7368564639597, -122.380807964714)
81417	81417	121357	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
82221	82221	121350	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			9	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
83964	83964	121362	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
84316	84316	121347	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
85075	85075	121356	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
91821	91821	121351	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
96657	96657	121361	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			26	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
97770	97770	121359	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
104894	104894	121349	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
107348	107348	121346	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
117953	117953	121358	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
118231	118231	121342	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			26	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
122056	122056	121360	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
124988	124988	121344	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			28	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
141420	141420	121352	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
143076	143076	121355	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
144505	144505	121348	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
40293	40293	189495	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	210 Acacia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017824.48788	2096188.08048	37.7367324645202	-122.38082514268801	(37.7367324645202, -122.380825142688)
162445	162445	189529	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	213 Acacia Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017810.85672	2096234.27169	37.7368585440828	-122.380875482215	(37.7368585440828, -122.380875482215)
13826	13826	26458	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6017771.22225	2096841.3441599999	37.738523256636896	-122.381054711725	(37.7385232566369, -122.381054711725)
15647	15647	26457	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/13/1997 12:00:00 AM	6	3x3		6017757.31102	2096823.45757	37.7384733757484	-122.381101567303	(37.7384733757484, -122.381101567303)
13778	13778	26456	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/13/1997 12:00:00 AM	6	3x3		6017743.988609999	2096808.9329900001	37.7384327587528	-122.381146620635	(37.7384327587528, -122.381146620635)
15691	15691	11881	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	400X Keith St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6017730.140319999	2096877.36865	37.7386199049771	-122.381199258841	(37.7386199049771, -122.381199258841)
182337	182337	201470	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017720.50763	2095978.01132	37.7361499169812	-122.381170049779	(37.7361499169812, -122.381170049779)
16332	16332	26455	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3	Permit Number 769095	6017718.24501	2096772.8589700002	37.738332285595206	-122.381233122826	(37.7383322855952, -122.381233122826)
16235	16235	11882	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	400X Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/08/2002 12:00:00 AM	6	3X3		6017717.79122	2096860.5282400001	37.73857298286829	-122.38124078595399	(37.7385729828683, -122.381240785954)
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)
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)
50895	50895	189459	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 Keith St	5	: 4	Tree 1	Private 1			12	Width 3ft		6017678.6985	2096804.16511	37.7384160628385	-122.381372033003	(37.7384160628385, -122.381372033003)
180128	180128	201468	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017677.66407	2095970.41595	37.7361266964906	-122.381317651001	(37.7361266964906, -122.381317651001)
76993	76993	189460	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 Keith St	6	: 4	Tree 1	Private 1			23	Width 3ft		6017666.55512	2096787.33958	37.7383691928822	-122.38141284963999	(37.7383691928822, -122.38141284964)
129658	129658	201467	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	301 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6017657.01116	2096011.92919	37.7362395434261	-122.381391943098	(37.7362395434261, -122.381391943098)
137706	137706	189461	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 Keith St	8	: 4	Tree 1	Private 1			14	Width 3ft		6017639.17726	2096752.78415	37.7382727990439	-122.381505107496	(37.7382727990439, -122.381505107496)
28920	28920	26465	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
85852	85852	26470	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
86344	86344	26471	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
124521	124521	26466	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
139672	139672	26469	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
140040	140040	26472	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Keith St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6017600.4401851	2096710.4383408	37.7381543871139	-122.381636098386	(37.7381543871139, -122.381636098386)
109437	109437	26462	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017579.033160401	2096478.0920021	37.737515228412704	-122.38169395908702	(37.7375152284127, -122.381693959087)
111799	111799	26459	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6017579.033160401	2096478.0920021	37.737515228412704	-122.38169395908702	(37.7375152284127, -122.381693959087)
115134	115134	26460	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	3x3		6017579.033160401	2096478.0920021	37.737515228412704	-122.38169395908702	(37.7375152284127, -122.381693959087)
115143	115143	26461	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	401X Keith St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017579.033160401	2096478.0920021	37.737515228412704	-122.38169395908702	(37.7375152284127, -122.381693959087)
51888	51888	189490	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 Cashmere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 4ft		6017365.32139	2095872.25334	37.7358399134893	-122.382390730173	(37.7358399134893, -122.382390730173)
125644	125644	3784	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	35 Cashmere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/31/2014 10:43:00 AM	3	3X4		6017319.3126468	2095790.6090322	37.735613192974704	-122.382544123056	(37.7356131929747, -122.382544123056)
82576	82576	14889	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	151 Mendell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6017309.26732	2098441.11643	37.7428903993232	-122.382763240232	(37.7428903993232, -122.382763240232)
90265	90265	14888	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	151 Mendell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6017309.26732	2098441.11643	37.7428903993232	-122.382763240232	(37.7428903993232, -122.382763240232)

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