Street_Tree_List

Data source: data.sfgov.org

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

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

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
167278	167278	126170	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	51 Collins St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			5998098.55352	2114264.17782	37.78525645845	-122.4503285932	(37.78525645845, -122.4503285932)
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)
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)
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)
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)
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)
175064	175064	142388	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5998066.9501	2114582.3728	37.7861283292793	-122.450460877658	(37.7861283292793, -122.450460877658)
185495	185495	201722	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Lindsay Cir	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			6016307.52162	2095597.12385	37.735025976661795	-122.386028821491	(37.7350259766618, -122.386028821491)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
184696	184696	142391	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5998019.9094	2114574.9275	37.7861051940215	-122.450623088237	(37.7861051940215, -122.450623088237)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
179112	179112	212223	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6000871.267080001	2095862.2026400003	37.7348874342912	-122.439416319315	(37.7348874342912, -122.439416319315)
165410	165410	142403	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5997842.5764	2114549.5458	37.7860253507043	-122.451234778957	(37.7860253507043, -122.451234778957)
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)
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)
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)
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)
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)
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)
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)
165664	165664	217833	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Cranleigh Dr	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			50	Width 7ft		5991415.837069999	2095795.00823	37.734160290163295	-122.47210183374399	(37.7341602901633, -122.472101833744)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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