Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by SiteOrder 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
49696	49696	248657	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1000 San Jose Ave	111	Front Yard : Yard 7	Tree 1	Private 1			6			6005025.16759	2096929.69692	37.7380540578596	-122.425130754104	(37.7380540578596, -122.425130754104)
176014	176014	248656	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1000 San Jose Ave	110	Front Yard : Yard 7	Tree 1	Private 1			16			6005044.37292	2096931.03803	37.7380588251561	-122.42506444708	(37.7380588251561, -122.42506444708)
169087	169087	248655	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1000 San Jose Ave	107	Front Yard : Yard 7	Tree 1	Private 1			16			6005056.20315	2096946.76695	37.7381026814961	-122.425024662861	(37.7381026814961, -122.425024662861)
47336	47336	206320	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700 Junipero Serra Blvd	102	: 4	Tree 1	Private 1			17	Width 0ft		5991249.508230001	2092024.39965	37.7237975164261	-122.47240209038601	(37.7237975164261, -122.472402090386)
54591	54591	248654	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1000 San Jose Ave	81	Front Yard : Yard 7	Tree 1	Private 1			15			6005089.97805	2097022.6793	37.7383130275105	-122.42491328541901	(37.7383130275105, -122.424913285419)
182006	182006	142450	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28	Width 0ft		5997309.2236	2114478.6465	37.7858001276963	-122.45307490578199	(37.7858001276963, -122.453074905782)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
70458	70458	205113	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	52	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991352.77429	2092808.82601	37.7259573327624	-122.47210226989701	(37.7259573327624, -122.472102269897)
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)
134038	134038	212168	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	51	Median : Cutout 11	Tree 1	DPW 2			28	Width 5ft		5999567.44917	2097481.1748599997	37.7392584623161	-122.444040348193	(37.7392584623161, -122.444040348193)
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)
48363	48363	205112	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	50	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991349.718230001	2092758.5362599997	37.7258190727658	-122.47210917039699	(37.7258190727658, -122.472109170397)
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)
30424	30424	205111	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	49	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991346.44389	2092729.4529400002	37.725739027717204	-122.472118370494	(37.7257390277172, -122.472118370494)
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)
47368	47368	248653	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1001 San Jose Ave	48	Front Yard : Yard 7	Tree 1	Private 1			19			6005296.42687	2097177.8941099998	37.738750871460205	-122.424210521903	(37.7387508714602, -122.424210521903)
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)
172148	172148	205110	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	48	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991343.90426	2092703.6667900002	37.725668078393504	-122.472125270987	(37.7256680783935, -122.472125270987)
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)
159485	159485	205109	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	47	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991344.09487	2092681.13577	37.7256062248454	-122.472122970506	(37.7256062248454, -122.472122970506)
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)
38069	38069	206319	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Junipero Serra Blvd	45	: 4	Tree 1	Private 1			16	Width 0ft		5991343.42057	2093507.86668	37.7278761829176	-122.472185537258	(37.7278761829176, -122.472185537258)
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)
156791	156791	248646	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	701 Church St	45	Front Yard : Yard 7	Tree 1	Private 1			24			6004337.8277	2104713.595	37.759387983176	-122.42806177235501	(37.759387983176, -122.428061772355)
68941	68941	205108	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	44	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		5991339.84346	2092605.6938200002	37.7253988339751	-122.472132170572	(37.7253988339751, -122.472132170572)
70422	70422	205090	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	44	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991232.93514	2090942.88536	37.7208269864641	-122.472380575028	(37.7208269864641, -122.472380575028)
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)
30306	30306	248645	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	701 Church St	43	Front Yard : Yard 7	Tree 1	Private 1			26			6004348.66213	2104681.30747	37.7592999422487	-122.428022000737	(37.7592999422487, -122.428022000737)
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)
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)
169141	169141	205089	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	42	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991231.16702	2090890.57712	37.7206832586037	-122.47238287549601	(37.7206832586037, -122.472382875496)
31200	31200	205107	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	41	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991336.964	2092532.2101	37.7251968993055	-122.472136770613	(37.7251968993055, -122.472136770613)
44624	44624	205088	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	41	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991229.30633	2090865.43732	37.7206141232198	-122.47238747550301	(37.7206141232198, -122.472387475503)
9233	9233	25445	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	40	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	3X3		6016123.98501	2095766.22901	37.735480146065505	-122.386675167071	(37.7354801460655, -122.386675167071)
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)
55194	55194	248652	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1001 San Jose Ave	40	Front Yard : Yard 7	Tree 1	Private 1			15			6005286.42848	2097142.8356	37.7386540441353	-122.42424259893801	(37.7386540441353, -122.424242598938)
65755	65755	205087	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	40	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991229.32936	2090834.95737	37.7205304341251	-122.47238517504499	(37.7205304341251, -122.472385175045)
66048	66048	205106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	40	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991333.82922	2092509.74916	37.7251350457334	-122.47214597065901	(37.7251350457334, -122.472145970659)
132536	132536	212167	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	40	Median : Cutout 11	Tree 1	DPW 2			16	Width 5ft		5999468.42079	2097513.2025099997	37.7393407529711	-122.444385043934	(37.7393407529711, -122.444385043934)
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)
47528	47528	205105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	39	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991330.58276	2092481.99012	37.7250586384304	-122.472155170739	(37.7250586384304, -122.472155170739)
162734	162734	212166	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	39	Median : Cutout 11	Tree 1	DPW 2			15	Width 5ft		5999464.98652	2097513.89815	37.7393424670869	-122.444396968055	(37.7393424670869, -122.444396968055)
182927	182927	205086	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	39	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991226.90116	2090814.4677099998	37.7204740340313	-122.472392075543	(37.7204740340313, -122.472392075543)
9314	9314	12158	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	38	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6016158.70701	2095735.6730099998	37.735398167686206	-122.38655298897699	(37.7353981676862, -122.386552988977)
156267	156267	205085	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	38	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991225.77549	2090792.62573	37.720413996187	-122.47239437511601	(37.720413996187, -122.472394375116)
161718	161718	205104	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	38	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991328.11288	2092459.51484	37.7249967839599	-122.47216207124399	(37.7249967839599, -122.472162071244)
183413	183413	142423	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 0ft		5997605.1735	2114516.8881	37.7859220855908	-122.45205376754801	(37.7859220855908, -122.452053767548)
9353	9353	12157	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	37	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6016176.76201	2095719.00601	37.73535340295211	-122.386489403775	(37.7353534029521, -122.386489403775)
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)
67761	67761	206306	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	37	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991444.74092	2094236.6421299998	37.7298830812226	-122.471888366154	(37.7298830812226, -122.471888366154)
182952	182952	205103	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	37	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991326.973119999	2092437.01185	37.724934930379206	-122.47216437168899	(37.7249349303792, -122.472164371689)
9472	9472	12156	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	36	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6016192.73501	2095700.95101	37.7353047117642	-122.386432920212	(37.7353047117642, -122.386432920212)
67638	67638	205084	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991220.51447	2090732.43963	37.720248435491904	-122.472408175222	(37.7202484354919, -122.472408175222)
149555	149555	206305	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991441.0529	2094219.4945900002	37.729835784970795	-122.471899866683	(37.7298357849708, -122.471899866683)
181938	181938	205102	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991324.44766	2092411.88768	37.7248657994962	-122.472171271311	(37.7248657994962, -122.472171271311)
20236	20236	29626	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991174.60245	2090776.1353200001	37.720365755664794	-122.47257006037901	(37.7203657556648, -122.472570060379)
69407	69407	205083	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991217.1837	2090700.70485	37.720161106826	-122.472417376171	(37.720161106826, -122.472417376171)
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)
137633	137633	212165	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	35	Median : Cutout 11	Tree 1	DPW 2			24	Width 5ft		5999417.343780001	2097526.3409700003	37.73937391367561	-122.444562589009	(37.7393739136756, -122.444562589009)
156000	156000	206304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991440.53654	2094194.9922900002	37.72976847791129	-122.47189986669599	(37.7297684779113, -122.471899866696)
157717	157717	205101	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991325.17756	2092383.3819099998	37.724787571970296	-122.47216667126101	(37.7247875719703, -122.472166671261)
166630	166630	189402	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900x Carolina St	35	Median : Yard 3	Tree 1	DPW 2			31			6012483.079	2103205.45107	37.755704417647294	-122.399785428875	(37.7557044176473, -122.399785428875)
9127	9127	12154	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	34	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6016226.76201	2095667.61701	37.735215066832104	-122.386312951947	(37.7352150668321, -122.386312951947)
31895	31895	206303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991439.20179	2094163.2193200001	37.7296811600564	-122.47190216624901	(37.7296811600564, -122.471902166249)
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)
72304	72304	205082	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991216.27623	2090657.6545099998	37.720042848675604	-122.47241737616501	(37.7200428486756, -122.472417376165)
161984	161984	205100	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991322.5960099995	2092355.6088599998	37.724711164672705	-122.472173571767	(37.7247111646727, -122.472173571767)
14800	14800	12153	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6016182.90625	2095712.9210700002	37.7353370350581	-122.386467736523	(37.7353370350581, -122.386467736523)
133644	133644	205099	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	33	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991320.805269999	2092333.78187	37.724651129544	-122.47217817178002	(37.724651129544, -122.47217817178)
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)
14350	14350	12152	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/17/1996 12:00:00 AM	6	3X3		6016198.01461	2095698.1267099997	37.7352972490591	-122.386414469663	(37.7352972490591, -122.386414469663)
31596	31596	205081	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	32	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		5991210.7499	2090584.88401	37.7198427189488	-122.47243117628099	(37.7198427189488, -122.472431176281)
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)
45530	45530	206423	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	400x Marietta Dr	32	Median : Cutout 11	Tree 1	DPW 2			14	Width 3ft		5999166.42001	2097010.61151	37.737943522178504	-122.445393096728	(37.7379435221785, -122.445393096728)
108860	108860	24456	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	12	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
147406	147406	212283	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	31	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991413.76911	2093002.29122	37.726492069641	-122.47190551083	(37.726492069641, -122.47190551083)
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)
174777	174777	205080	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	31	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		5991211.60542	2090562.33735	37.7197808608892	-122.47242657625	(37.7197808608892, -122.47242657625)
14130	14130	12150	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/17/1996 12:00:00 AM	2	3X3		6016234.16268	2095665.57813	37.735209878118	-122.386287222793	(37.735209878118, -122.386287222793)
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)
71529	71529	176016	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700x Mansell St	30	Median : Cutout 11	Tree 1	DPW 2			31	Width 0ft		6009216.97292	2089964.58671	37.7191652533595	-122.410145941702	(37.7191652533595, -122.410145941702)
73785	73785	205079	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	30	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		5991209.0936900005	2090537.87387	37.7197135448202	-122.47243347583	(37.7197135448202, -122.47243347583)
80752	80752	24398	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/01/2000 12:00:00 AM	12	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
159831	159831	212282	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	30	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991411.32325	2092975.49462	37.7264183513201	-122.471912013829	(37.7264183513201, -122.471912013829)
15841	15841	12149	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X La Salle Ave	29	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6016248.95724	2095649.3696400002	37.735166191751	-122.38623494249399	(37.735166191751, -122.386234942494)
43527	43527	205098	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991316.70247	2092233.8206900002	37.724376423516105	-122.472185071407	(37.7243764235161, -122.472185071407)
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)
158549	158549	205078	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991207.21899	2090512.07145	37.7196425892212	-122.47243807587601	(37.7196425892212, -122.472438075876)
164373	164373	212164	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	29	Median : Cutout 11	Tree 1	DPW 2			18	Width 5ft		5999306.41715	2097560.47752	37.7394613142828	-122.444948576214	(37.7394613142828, -122.444948576214)
165991	165991	206302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991428.71854	2094013.04751	37.729268219243394	-122.471927466905	(37.7292682192434, -122.471927466905)
39182	39182	205077	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	28	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991206.77223	2090490.8774299999	37.719584369801396	-122.47243807587601	(37.7195843698014, -122.472438075876)

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