Street_Tree_List

Data source: data.sfgov.org

129 rows where qSiteInfo = 9 and qSpecies = 60 sorted by DBH

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, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
89582	89582	99611	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Entrada Ct	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5992743.0	2092489.0	37.7251595224946	-122.46727314778099	(37.7251595224946, -122.467273147781)
100050	100050	112184	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	6	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
120666	120666	112186	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	4	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
146135	146135	112185	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	5	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
32360	32360	123256	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	735 07th Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		5993773.30721	2110581.94005	37.7748975441073	-122.465024972293	(37.7748975441073, -122.465024972293)
39680	39680	212217	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			6001121.36826	2095728.58105	37.734534770568	-122.438542063178	(37.734534770568, -122.438542063178)
162764	162764	212241	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			5998218.66289	2093822.9829099998	37.729136902922605	-122.448440451292	(37.7291369029226, -122.448440451292)
25850	25850	248781	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	784 Duncan St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 6ft		6001437.23624	2099723.01207	37.745520506460096	-122.43773599094	(37.7455205064601, -122.43773599094)
129617	129617	212219	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6001099.22416	2095737.89591	37.7345590873286	-122.43861928975299	(37.7345590873286, -122.438619289753)
130570	130570	212199	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	820 Bosworth St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6001716.86925	2095561.16435	37.73410893977589	-122.43647124285299	(37.7341089397759, -122.436471242853)
150282	150282	189465	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	119 Augusta St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 5ft		6011093.8491400005	2095438.52571	37.73430057630279	-122.40404328257601	(37.7343005763028, -122.404043282576)
164827	164827	212212	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6001287.33853	2095677.45112	37.7344038193788	-122.43796458870399	(37.7344038193788, -122.437964588704)
173468	173468	142407	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5997811.1032	2114546.5	37.7860151856477	-122.45134344743201	(37.7860151856477, -122.451343447432)
38991	38991	142434	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5997490.7869	2114502.336	37.7858755765928	-122.45244846114599	(37.7858755765928, -122.452448461146)
51820	51820	142425	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5997580.8071	2114513.5039	37.7859113977237	-122.45213782389	(37.7859113977237, -122.45213782389)
58549	58549	212240	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			5998225.68329	2093821.9579599998	37.7291344900407	-122.448416107518	(37.7291344900407, -122.448416107518)
1307	1307	212207	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	8	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			11			6001467.5944	2095628.72955	37.7342802902926	-122.43733789885	(37.7342802902926, -122.43733789885)
26476	26476	212215	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6001146.22542	2095720.4454400002	37.73451384602821	-122.438455541186	(37.7345138460282, -122.438455541186)
52706	52706	212226	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6000822.65215	2095879.57602	37.734932370740296	-122.439585642776	(37.7349323707403, -122.439585642776)
150003	150003	142416	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5997686.3947	2114529.7482	37.78596204808029	-122.451773694005	(37.7859620480803, -122.451773694005)
59466	59466	212242	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			5998209.43788	2093823.68596	37.729138305887496	-122.44847239338002	(37.7291383058875, -122.44847239338)
62029	62029	142422	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997618.0335	2114520.9492	37.7859339729155	-122.452009568816	(37.7859339729155, -122.452009568816)
69592	69592	142408	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997793.8437	2114545.4848	37.7860114098886	-122.451403087084	(37.7860114098886, -122.451403087084)
146892	146892	142389	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5998056.7974	2114581.3575	37.7861249604509	-122.450495929916	(37.7861249604509, -122.450495929916)
153762	153762	142436	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997474.8811	2114498.9518	37.7858653731869	-122.45250324620599	(37.7858653731869, -122.452503246206)
810	810	212202	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	800 Bosworth St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6001677.26505	2095571.4535400001	37.734134940976	-122.43660890297501	(37.734134940976, -122.436608902975)
67964	67964	142402	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5997856.7901	2114554.2838	37.7860391738166	-122.45118594545299	(37.7860391738166, -122.451185945453)
157168	157168	142428	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5997554.4102	2114510.1197	37.785900593478296	-122.45222890514201	(37.7859005934783, -122.452228905142)
169516	169516	126304	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	150 Lombard St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6011511.53944	2120807.30084	37.803980794943705	-122.40438423177	(37.8039807949437, -122.40438423177)
173890	173890	212184	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 Bosworth St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6002222.25536	2095433.9620299998	37.7337883764161	-122.434714874107	(37.7337883764161, -122.434714874107)
186334	186334	212214	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6001218.32955	2095696.7085799999	37.734452771280395	-122.438204553905	(37.7344527712804, -122.438204553905)
801	801	212193	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	720 Bosworth St	7	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			14			6002021.19403	2095482.3719	37.7339098820273	-122.43541346386002	(37.7339098820273, -122.43541346386)
25943	25943	142412	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997733.6046	2114534.6553	37.7859782253852	-122.45161071556002	(37.7859782253852, -122.45161071556)
38880	38880	175995	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5998981.8742	2090546.54145	37.7201841618528	-122.44556646533	(37.7201841618528, -122.44556646533)
39124	39124	142417	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997674.55	2114528.3945	37.785957652798	-122.451814575532	(37.785957652798, -122.451814575532)
45228	45228	142439	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997443.9155	2114497.5981	37.7858598821031	-122.45261028028901	(37.7858598821031, -122.452610280289)
52559	52559	212209	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6001437.10561	2095636.3706200002	37.7342995375914	-122.437443855175	(37.7342995375914, -122.437443855175)
60091	60091	189420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1751 22nd St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6012859.34416	2103757.23618	37.757240467778296	-122.39852289312	(37.7572404677783, -122.39852289312)
149712	149712	142432	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997511.0923	2114504.0281	37.785881385969	-122.45237833260401	(37.785881385969, -122.452378332604)
154795	154795	126169	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 6ft		5997183.22677	2113882.1582400003	37.7841551073202	-122.453467734347	(37.7841551073202, -122.453467734347)
170569	170569	175991	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5998793.1265199995	2090644.11661	37.720441303198704	-122.44622591568998	(37.7204413031987, -122.44622591569)
25216	25216	142438	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	53	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997453.3913	2114497.9365	37.7858613541886	-122.452577521257	(37.7858613541886, -122.452577521257)
37218	37218	142400	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997877.4339	2114556.6527	37.7860468601303	-122.451114694716	(37.7860468601303, -122.451114694716)
43758	43758	212210	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6001335.34031	2095664.21523	37.734370206320705	-122.437797683519	(37.7343702063207, -122.437797683519)
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)
64888	64888	142430	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997534.1049	2114507.4123	37.7858919964517	-122.452298960079	(37.7858919964517, -122.452298960079)
74139	74139	142401	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997867.6196	2114554.9606	37.7860416521682	-122.45114852731301	(37.7860416521682, -122.451148527313)
136147	136147	175994	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		5998943.08892	2090567.9508599997	37.7202407328088	-122.44570207140801	(37.7202407328088, -122.445702071408)
148651	148651	142446	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997383.6764	2114487.7839	37.785829483217896	-122.45281798111	(37.7858294832179, -122.45281798111)
155157	155157	142431	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997523.9523	2114506.3971	37.785888627357004	-122.452334011803	(37.785888627357, -122.452334011803)
167629	167629	126168	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 7ft		5997192.90233	2113882.62114	37.7841569329389	-122.45343429398199	(37.7841569329389, -122.453434293982)
187796	187796	212200	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	820 Bosworth St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6001696.91365	2095566.3144	37.7341219466514	-122.43654060398899	(37.7341219466514, -122.436540603989)
794	794	212187	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	720 Bosworth St	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			16			6002096.28779	2095466.30888	37.733870041163	-122.435152693763	(37.733870041163, -122.435152693763)
796	796	212189	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	720 Bosworth St	3	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			16			6002068.0773599995	2095471.6867	37.7338832054473	-122.435250610137	(37.7338832054473, -122.435250610137)
797	797	212191	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	720 Bosworth St	5	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			16			6002043.865019999	2095478.6742	37.7339010165159	-122.435334819059	(37.7339010165159, -122.435334819059)
1277	1277	212203	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			16			6001598.82808	2095593.8833700002	37.7341920703926	-122.436881688932	(37.7341920703926, -122.436881688932)
23588	23588	142397	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997908.5687	2114561.3906	37.7860616516624	-122.45100731899299	(37.7860616516624, -122.451007318993)
37614	37614	212222	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6000900.61271	2095850.79313	37.734857776454504	-122.43931404390699	(37.7348577764545, -122.439314043907)
38559	38559	248795	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5175 Diamond Heights Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6000777.48804	2099988.6184	37.746212262280395	-122.440036333505	(37.7462122622804, -122.440036333505)
72722	72722	126165	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	596 Spruce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 8ft		5997159.12114	2113887.69242	37.7841689209008	-122.453551530484	(37.7841689209008, -122.453551530484)
133275	133275	142433	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997499.5859	2114503.0128	37.7858779390155	-122.45241806806101	(37.7858779390155, -122.452418068061)
149196	149196	142410	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997761.6936	2114540.07	37.7859947012667	-122.45151392645799	(37.7859947012667, -122.451513926458)
169112	169112	142405	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997821.9327	2114548.5306	37.7860213812263	-122.451306126982	(37.7860213812263, -122.451306126982)
174775	174775	206424	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	215 Baden St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		6000727.34044	2094799.13402	37.7319603029265	-122.439837728124	(37.7319603029265, -122.439837728124)
182289	182289	142429	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997546.2881	2114509.7813	37.785899199038404	-122.45225698079399	(37.7858991990384, -122.452256980794)
33121	33121	212178	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	610 Bosworth St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6002338.16376	2095402.39755	37.7337082872919	-122.434311888799	(37.7337082872919, -122.434311888799)
42502	42502	142415	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997700.27	2114531.1019	37.785966559642794	-122.451725787187	(37.7859665596428, -122.451725787187)
120871	120871	142441	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997429.025	2114493.8755	37.78584880764029	-122.452661528246	(37.7858488076403, -122.452661528246)
177175	177175	212179	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 Bosworth St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6002311.738390001	2095409.55928	37.7337264518091	-122.43440376084	(37.7337264518091, -122.43440376084)
178738	178738	142394	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997948.164	2114566.1285	37.7860769274284	-122.45087067230699	(37.7860769274284, -122.450870672307)
179714	179714	212205	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6001520.45314	2095614.45375	37.7342440970832	-122.43715412776301	(37.7342440970832, -122.437154127763)
185549	185549	142444	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997400.5975	2114491.1681	37.785839744948	-122.45275968348301	(37.785839744948, -122.452759683483)
28742	28742	142387	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5998077.7796	2114584.0649	37.7861335951467	-122.450423532667	(37.7861335951467, -122.450423532667)
29344	29344	212243	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	160 Marston Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			5998464.243	2093227.24787	37.7275151923546	-122.447548599	(37.7275151923546, -122.447548599)
32312	32312	123257	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	735 07th Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		5993773.776000001	2110615.61504	37.7749900336609	-122.465025796945	(37.7749900336609, -122.465025796945)
32757	32757	142398	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997898.7544	2114559.3601	37.7860555145741	-122.451041127193	(37.7860555145741, -122.451041127193)
44314	44314	126179	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Marina Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6003111.16889	2121419.1431	37.8051877435806	-122.43349799333201	(37.8051877435806, -122.433497993332)
47032	47032	212197	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	820 Bosworth St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6001769.124890001	2095547.7255799999	37.7340750092381	-122.436289617596	(37.7340750092381, -122.436289617596)
74824	74824	142399	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997888.9402	2114558.0064	37.786051235795796	-122.45107498386601	(37.7860512357958, -122.451074983866)
75796	75796	142393	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997963.0546	2114567.8206	37.786082425901206	-122.45081927712	(37.7860824259012, -122.45081927712)
172814	172814	212211	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6001309.95525	2095671.6217	37.734389099275106	-122.43788597806999	(37.7343890992751, -122.43788597807)
29142	29142	126167	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 4ft		5997207.981819999	2113880.64934	37.784152383258295	-122.453381982209	(37.7841523832583, -122.453381982209)
36645	36645	248794	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5175 Diamond Heights Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19			6000769.8942	2099922.22188	37.7460295209503	-122.440057831812	(37.7460295209503, -122.440057831812)
58976	58976	212182	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 Bosworth St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19			6002250.2087	2095427.67097	37.7337726895439	-122.43461778151001	(37.7337726895439, -122.43461778151)
137112	137112	212158	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1340 Monterey Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 10ft		5993891.68041	2094668.0264299999	37.731208840201504	-122.463460369625	(37.7312088402015, -122.463460369625)
60448	60448	142435	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997482.3264	2114500.9823	37.7858713749679	-122.452477634253	(37.7858713749679, -122.452477634253)
63642	63642	142411	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997746.1262	2114536.3474	37.785983588517205	-122.45156751655	(37.7859835885172, -122.45156751655)
170692	170692	142443	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997409.7349	2114492.5218	37.785843985429395	-122.452728168531	(37.7858439854294, -122.452728168531)
52759	52759	142449	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	64	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 0ft		5997336.6358	2114481.6923	37.785810061623295	-122.452980287706	(37.7858100616233, -122.452980287706)
131341	131341	206419	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	560 Rockdale Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 3ft		5997931.63509	2097867.15449	37.7402248171304	-122.449724042856	(37.7402248171304, -122.449724042856)
134505	134505	175990	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5998767.87796	2090657.4852099998	37.7204765683114	-122.44631415267901	(37.7204765683114, -122.446314152679)
158283	158283	175992	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5998869.40884	2090603.9997900003	37.7203355078481	-122.445959349454	(37.7203355078481, -122.445959349454)
163868	163868	142445	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	60	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 0ft		5997392.137	2114489.8144	37.7858355432461	-122.452788856559	(37.7858355432461, -122.452788856559)
167099	167099	126287	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Florence St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21			6008482.5431699995	2118328.02028	37.797003577504604	-122.41469074658998	(37.7970035775046, -122.41469074659)
49835	49835	142396	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997922.444	2114562.4059	37.7860652337565	-122.450959387654	(37.7860652337565, -122.450959387654)
154222	154222	142437	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997464.7285	2114499.2902	37.7858657206584	-122.452538395628	(37.7858657206584, -122.452538395628)
177480	177480	142413	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997716.1759	2114533.1324	37.7859730457909	-122.451670903916	(37.7859730457909, -122.451670903916)
26390	26390	175993	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 5ft		5998911.6853	2090582.5176799998	37.720278936911605	-122.445811669969	(37.7202789369116, -122.445811669969)
73453	73453	142447	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5997374.2006	2114486.4302	37.7858252233209	-122.45285066681299	(37.7858252233209, -122.452850666813)

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