Street_Tree_List

Data source: data.sfgov.org

129 rows where qSiteInfo = 9 and qSpecies = 60

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: qCaretaker

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
24862	24862	142424	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997593.3287	2114514.5192	37.78591490273521	-122.452094576108	(37.7859149027352, -122.452094576108)
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)
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)
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)
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)
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)
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)
29049	29049	142409	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5997773.8768	2114540.7469	37.7859972575145	-122.45147182494699	(37.7859972575145, -122.451471824947)
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)
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)
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)
32552	32552	142395	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997933.9503	2114564.4364	37.7860714676838	-122.45091972560499	(37.7860714676838, -122.450919725605)
32697	32697	126166	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 4ft		5997218.88994	2113880.19727	37.784151767235606	-122.453344211568	(37.7841517672356, -122.453344211568)
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)
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)
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)
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)
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)
38226	38226	142419	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5997648.4915	2114525.3487	37.7859477973415	-122.451904510544	(37.7859477973415, -122.451904510544)
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)
38674	38674	217832	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Cranleigh Dr	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 7ft		5991396.48191	2095769.3933599999	37.7340888381105	-122.472166883492	(37.7340888381105, -122.472166883492)
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)
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)
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)
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)
40238	40238	142386	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5998114.6675	2114591.1717	37.786155219669396	-122.450296423393	(37.7861552196694, -122.450296423393)
41642	41642	142427	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5997563.2092	2114510.7965	37.7859029558443	-122.45219851203998	(37.7859029558443, -122.45219851204)
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)
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)
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)
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)
46803	46803	142392	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			37	Width 0ft		5997992.4973	2114571.2048	37.7860934034035	-122.450717657836	(37.7860934034035, -122.450717657836)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
65217	65217	175989	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 5ft		5998751.66703	2090666.1171099998	37.7204993436547	-122.446370809093	(37.7204993436547, -122.446370809093)
67815	67815	142414	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 0ft		5997709.7458	2114531.1019	37.7859671023257	-122.451693003671	(37.7859671023257, -122.451693003671)
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)
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)
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)
73277	73277	142420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997641.3846	2114523.995	37.785943673381205	-122.45192900064899	(37.7859436733812, -122.451929000649)
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)
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)
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)
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)
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)
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)
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)
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)
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)
134598	134598	142390	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5998035.1384	2114578.3117	37.7861153578155	-122.450570644279	(37.7861153578155, -122.450570644279)
134717	134717	123259	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	735 07th Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 4ft		5993772.600930001	2110684.43261	37.775178920555	-122.46503486093901	(37.775178920555, -122.465034860939)
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)
136328	136328	142418	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 0ft		5997662.3668	2114527.0408	37.785953238114	-122.451856628165	(37.785953238114, -122.451856628165)
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)
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)
146615	146615	126274	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1240 Lombard St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 6ft		6006421.51674	2120105.21307	37.80176728640121	-122.421948716173	(37.8017672864012, -122.421948716173)
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)
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)
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)
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)
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)
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)
150323	150323	217785	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	124 Sloat Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33			5991003.2864	2096055.6883900003	37.7348521691816	-122.473547145886	(37.7348521691816, -122.473547145886)
151963	151963	248793	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5175 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6000762.917	2099848.0736700003	37.7458255304211	-122.440076642017	(37.7458255304211, -122.440076642017)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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