Street_Tree_List

Data source: data.sfgov.org

248 rows where qSiteInfo = 11 and qSpecies = 60 sorted by qAddress

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, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
17715	17715	16378	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000X Moraga St	1	Median : Cutout 11	Tree 1	DPW 2			18	12		5991088.16435	2103840.65792	37.756232597572605	-122.473821451692	(37.7562325975726, -122.473821451692)
31562	31562	212298	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991179.120709999	2090094.55389	37.7184945623549	-122.47250477768699	(37.7184945623549, -122.472504777687)
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)
32028	32028	212310	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991202.259869999	2090434.6504900001	37.7194297232904	-122.472449576395	(37.7194297232904, -122.472449576395)
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)
41461	41461	212306	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	22	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991196.13313	2090333.39999	37.719151359714395	-122.472463376508	(37.7191513597144, -122.472463376508)
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)
52489	52489	212303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991192.118419999	2090269.21075	37.7189748794765	-122.47247257657601	(37.7189748794765, -122.472472576576)
55711	55711	205076	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991204.8696099995	2090463.7504	37.7195097755318	-122.472442675902	(37.7195097755318, -122.472442675902)
58519	58519	212305	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991194.3003	2090309.58448	37.7190858620976	-122.47246797653901	(37.7190858620976, -122.472467976539)
62175	62175	212292	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991164.37326	2089829.54432	37.7177660575462	-122.472536442798	(37.7177660575462, -122.472536442798)
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)
66442	66442	212308	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991201.47803	2090397.56088	37.7193278390954	-122.47244957640801	(37.7193278390954, -122.472449576408)
67053	67053	212297	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991177.8274300005	2090064.7629799999	37.7184126889791	-122.47250707726002	(37.7184126889791, -122.47250707726)
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)
68407	68407	212307	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	23	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991200.212719999	2090369.09522	37.7192496061609	-122.47245187595	(37.7192496061609, -122.47245187595)
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)
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)
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)
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)
146358	146358	212299	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991184.2984	2090150.76712	37.7186492097602	-122.47249097667401	(37.7186492097602, -122.472490976674)
154256	154256	212294	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991166.95703	2089883.0190299999	37.7179130355286	-122.472531408396	(37.7179130355286, -122.472531408396)
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)
157693	157693	212304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991192.55124	2090289.74279	37.7190312804608	-122.472472576553	(37.7190312804608, -122.472472576553)
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)
162733	162733	212296	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991176.06439	2090044.25898	37.7183562879852	-122.472511677268	(37.7183562879852, -122.472511677268)
163038	163038	212302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991190.15994	2090239.4345099998	37.7188930078858	-122.47247717658001	(37.7188930078858, -122.47247717658)
166561	166561	212309	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991201.91083	2090418.0925900002	37.719384239169294	-122.472449576413	(37.7193842391693, -122.472449576413)
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)
170614	170614	212293	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991165.05081	2089858.71083	37.717846180842294	-122.472536226064	(37.7178461808423, -122.472536226064)
173416	173416	212300	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991186.31185	2090192.49351	37.7187638967107	-122.472487057435	(37.7187638967107, -122.472487057435)
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)
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)
184198	184198	212301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991188.84719	2090215.0879099998	37.7188260821255	-122.47247994019199	(37.7188260821255, -122.472479940192)
186690	186690	212295	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991170.53267	2089939.6813400001	37.7180688232854	-122.472523177809	(37.7180688232854, -122.472523177809)
77692	77692	3754	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1020 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			36	18		6012443.0515847	2103208.5839527003	37.755710788358	-122.399924077269	(37.755710788358, -122.399924077269)
95442	95442	29636	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
98950	98950	29632	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
99891	99891	29635	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
100149	100149	29637	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
103060	103060	29629	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
103985	103985	29638	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
108232	108232	29628	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
140900	140900	29634	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
143674	143674	29630	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
145795	145795	29633	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
99939	99939	19428	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1200X Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5987947.5018995	2095985.7700737999	37.7344827526385	-122.484106799366	(37.7344827526385, -122.484106799366)
78281	78281	111082	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1				3x3		5991393.0	2095322.0	37.7328602072681	-122.472146321186	(37.7328602072681, -122.472146321186)
81843	81843	23367	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1356X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			18	9		6006391.382589401	2115174.2493055	37.7882263975959	-122.42170255954201	(37.7882263975959, -122.421702559542)
78324	78324	30038	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
79082	79082	11840	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
87684	87684	11839	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
89892	89892	30039	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
93762	93762	11846	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
95638	95638	11841	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
99517	99517	11834	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
101567	101567	11830	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
102800	102800	30041	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	22	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
105964	105964	30045	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
106431	106431	11831	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
117831	117831	30043	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
119448	119448	30040	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
126132	126132	30042	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
127507	127507	30044	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
128129	128129	30046	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
138707	138707	11843	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2			3	2X2		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
139771	139771	11844	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
139855	139855	11845	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
140080	140080	11835	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
144436	144436	11832	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
144641	144641	11847	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
145215	145215	11837	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
145667	145667	11836	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
83274	83274	99496	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	3	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
87404	87404	99494	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
122780	122780	99495	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	2	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
21040	21040	16351	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	1	Median : Cutout 11	Tree 1	DPW 2			3	4-HOA		5993490.85605	2095190.6948799998	37.7326208567505	-122.464884023402	(37.7326208567505, -122.464884023402)
21308	21308	16353	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	3	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993459.40286	2095225.9506299999	37.7327158467563	-122.464995323497	(37.7327158467563, -122.464995323497)
21730	21730	16356	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	6	Median : Cutout 11	Tree 1	DPW 2			30	4-HOA		5993377.89298	2095299.30224	37.7329125518562	-122.46528244733	(37.7329125518562, -122.46528244733)
21780	21780	16352	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	2	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993475.48003	2095210.28877	37.7326737701714	-122.46493860413099	(37.7326737701714, -122.464938604131)
21807	21807	16355	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	5	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993419.93647	2095261.019	37.732809860079996	-122.46513431370501	(37.73280986008, -122.465134313705)
21945	21945	16357	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	7	Median : Cutout 11	Tree 1	DPW 2			30	4-HOA		5993334.84717	2095340.24029	37.7330224750874	-122.465434239406	(37.7330224750874, -122.465434239406)
7447	7447	23391	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Van Ness Ave	4	Median : Cutout 11	Tree 1	DPW 2		06/09/2005 12:00:00 AM	6	9		6006253.0985199995	2115767.98121	37.789848839288	-122.422223199151	(37.789848839288, -122.422223199151)
98155	98155	19460	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1700X Sloat Blvd	6	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5985858.9484667	2095882.6709765	37.7340778499573	-122.49131993236901	(37.7340778499573, -122.491319932369)
5451	5451	23407	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1748X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006159.63822	2116414.10982	37.791617675355795	-122.422592496742	(37.7916176753558, -122.422592496742)
8649	8649	23408	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1748X Van Ness Ave	4	Median : Cutout 11	Tree 1	DPW 2			30	9		6006154.759930001	2116452.2699700003	37.7917221783851	-122.42261208848801	(37.7917221783851, -122.422612088488)
2620	2620	23170	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	202X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006871.78386	2111296.65749	37.7776065535391	-122.41976520271601	(37.7776065535391, -122.419765202716)
7904	7904	23169	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	202X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			30	9		6006882.10264	2111252.84384	37.777486833097896	-122.419726396954	(37.7774868330979, -122.419726396954)
10926	10926	15989	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	236 Moncada Way	2	Median : Cutout 11	Tree 1	DPW 2			24	35M		5992398.75579	2093455.53191	37.7277935021904	-122.468533444909	(37.7277935021904, -122.468533444909)
7149	7149	23486	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2500X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			30	9		6005800.3407	2119014.80575	37.7987382537111	-122.424020688524	(37.7987382537111, -122.424020688524)
82243	82243	206416	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	255x San Marcos Ave	4	Median : Cutout 11	Tree 1	DPW 2			13	Width 5ft		5993123.33521	2100243.25688	37.7464727248457	-122.466521730189	(37.7464727248457, -122.466521730189)
171533	171533	206417	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	255x San Marcos Ave	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 5ft		5993040.30292	2100253.1432	37.7464950784009	-122.466809562712	(37.7464950784009, -122.466809562712)
97454	97454	105000	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	280X SAN MARCOS AVE	1	Median : Cutout 11	Tree 1	DPW 2			65		Tree tag no. 416	5993063.2	2100277.9	37.7465643757171	-122.466732187112	(37.7465643757171, -122.466732187112)
88606	88606	113723	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	282X MARIETTA DR	1	Median : Cutout 11	Tree 1	DPW 2				5x30		5999031.0	2097664.0	37.739729839693496	-122.445908288102	(37.7397298396935, -122.445908288102)
146180	146180	13391	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	294 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			12	5		5999337.3143931	2097513.8503676	37.739335050559	-122.44483839666701	(37.739335050559, -122.444838396667)
9682	9682	13402	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	4	Median : Cutout 11	Tree 1	DPW 2			0	5x10		5999116.0	2097588.0	37.7395260150228	-122.445608931545	(37.7395260150228, -122.445608931545)
19957	19957	13396	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			30	5		5999058.18381	2097687.6567700002	37.7397963477092	-122.44581599931999	(37.7397963477092, -122.44581599932)
88522	88522	13394	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			100	5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)
112767	112767	111778	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	3	Median : Cutout 11	Tree 1	DPW 2				5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)
141097	141097	13393	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			12	5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)

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