Street_Tree_List

Data source: data.sfgov.org

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

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
188789	188789	1301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	4000X Alemany Blvd	9	Median : Cutout 11	Tree 1	DPW 2			32	10		5991772.09471	2087046.42932	37.7101594558675	-122.470233284447	(37.7101594558675, -122.470233284447)
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)
22414	22414	9013	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5317 Geary Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	8M		5990485.6581	2112681.4706	37.7804721580667	-122.47655093756501	(37.7804721580667, -122.476550937565)
22482	22482	9050	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5500 Geary Blvd	4	Median : Cutout 11	Tree 1	DPW 2			3	8M		5989756.3032	2112653.5115	37.7803530611008	-122.47907204579799	(37.7803530611008, -122.479072045798)
89161	89161	9257	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6600X Geary Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	8M		5986360.871619999	2112530.52863	37.7798176164012	-122.490809209885	(37.7798176164012, -122.490809209885)
17868	17868	11672	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	710X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991310.6193982	2092985.7524279999	37.7264406890913	-122.472260886614	(37.7264406890913, -122.472260886614)
140720	140720	11681	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	710X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991310.6193982	2092985.7524279999	37.7264406890913	-122.472260886614	(37.7264406890913, -122.472260886614)
20180	20180	11683	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Junipero Serra Blvd	15	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991304.64081	2092852.6411099997	37.7260748525524	-122.47227185508301	(37.7260748525524, -122.472271855083)
88970	88970	11763	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	810X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991252.992504	2092079.9575241	37.7239502662313	-122.472394094235	(37.7239502662313, -122.472394094235)
79615	79615	11764	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	810X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991252.992504	2092079.9575241	37.7239502662313	-122.472394094235	(37.7239502662313, -122.472394094235)
21009	21009	11768	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991277.20617	2091654.2371	37.7227827448208	-122.472279373401	(37.7227827448208, -122.472279373401)
21262	21262	11775	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991281.15985	2091683.9699900001	37.722864612795	-122.47226787285801	(37.722864612795, -122.472267872858)
17761	17761	11776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991282.42505	2091712.4343599998	37.7229428421321	-122.47226557329701	(37.7229428421321, -122.472265573297)
22120	22120	11777	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991284.187940001	2091732.93739	37.7229992404026	-122.472260973267	(37.7229992404026, -122.472260973267)
18437	18437	11778	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991284.6486	2091754.7927400002	37.723059276443294	-122.472260973265	(37.7230592764433, -122.472260973265)
17949	17949	11779	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991286.49524	2091779.26927	37.723126589806704	-122.47225637323	(37.7231265898067, -122.47225637323)
17196	17196	11780	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991289.71415	2091805.7046599998	37.7231993611319	-122.47224717228599	(37.7231993611319, -122.472247172286)
20900	20900	11781	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991290.20273	2091828.8846200001	37.7232630358375	-122.472247172271	(37.7232630358375, -122.472247172271)
16230	16230	11782	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991290.0959	2091855.3897900002	37.7233358062868	-122.472249472731	(37.7233358062868, -122.472249472731)
19341	19341	11783	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	15	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991294.00766	2091883.13578	37.7234122162896	-122.472237972213	(37.7234122162896, -122.472237972213)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
96198	96198	13301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	1	Median : Cutout 11	Tree 1	DPW 2			18	6		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
141679	141679	13302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	2	Median : Cutout 11	Tree 1	DPW 2			12	10		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
142098	142098	13303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	3	Median : Cutout 11	Tree 1	DPW 2			18	15		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
138487	138487	13304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	4	Median : Cutout 11	Tree 1	DPW 2			12	15		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
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)
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)
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)
90178	90178	13395	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	316 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			70	5		5999447.6447037	2097480.7016993	37.7392503280525	-122.44445454302401	(37.7392503280525, -122.444454543024)
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)
102654	102654	13397	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	326 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			80	5		5999496.7834134	2097465.9380067	37.7392125940965	-122.44428358328001	(37.7392125940965, -122.44428358328)
84548	84548	13398	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	332 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			80	5		5999526.1960451	2097456.6056762002	37.739188647769296	-122.44418121753901	(37.7391886477693, -122.444181217539)
127728	127728	13399	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	332 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			20	5x1000		5999526.1960451	2097456.6056762002	37.739188647769296	-122.44418121753901	(37.7391886477693, -122.444181217539)
111621	111621	13400	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	338 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			18	5x1000		5999551.819033401	2097447.7157589	37.7391656999261	-122.444091986476	(37.7391656999261, -122.444091986476)
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)
83854	83854	13403	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	360 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			14	5x1000		5999647.998558	2097391.335153	37.7390163784819	-122.44375539278	(37.7390163784819, -122.44375539278)
110230	110230	13411	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	368 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			20	5x1000		5999673.9454175	2097366.8297673	37.73895057241529	-122.443663920765	(37.7389505724153, -122.443663920765)
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)
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)
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)
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)
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)
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)
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)
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)
18990	18990	16587	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	7X Noe St	1	Median : Cutout 11	Tree 1	DPW 2			12	3X3		6002822.0682	2108265.0608599996	37.7690535728051	-122.433557813564	(37.7690535728051, -122.433557813564)
18870	18870	16690	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	950X Noriega St	1	Median : Cutout 11	Tree 1	DPW 2		11/07/2014 11:22:00 AM	3	8		5991053.49575	2103158.03284	37.7543562808184	-122.473891546652	(37.7543562808184, -122.473891546652)
22280	22280	16692	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	950X Noriega St	3	Median : Cutout 11	Tree 1	DPW 2		02/25/2016 08:08:00 AM	3	8		5990985.786309999	2103156.72144	37.7543487579916	-122.474125605135	(37.7543487579916, -122.474125605135)
79741	79741	16693	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X NORIEGA ST	4	Median : Cutout 11	Tree 1	DPW 2		11/07/2014 11:22:00 AM	3	8		5991142.4	2103205.1	37.7544906639436	-122.473587529216	(37.7544906639436, -122.473587529216)
114224	114224	19423	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	880X Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5988998.102828201	2096024.0271709	37.7346489082814	-122.48047736602301	(37.7346489082814, -122.480477366023)
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)
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)
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)
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)
86752	86752	23177	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
98624	98624	23178	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
123135	123135	23179	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	5	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
8553	8553	23232	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006628.60579	2113016.72655	37.7823157437221	-122.42072857987301	(37.7823157437221, -122.420728579873)
8048	8048	23233	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006624.19189	2113053.59601	37.782416729491	-122.42074646829799	(37.782416729491, -122.420746468298)
108142	108142	23236	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Van Ness Ave	6	Median : Cutout 11	Tree 1	DPW 2			30	9		6006679.199292599	2112885.0865653	37.7819571437982	-122.42054420111201	(37.7819571437982, -122.420544201112)
141522	141522	23267	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			18	3X3		6006632.086075599	2113221.2018047003	37.7828773790282	-122.420731060153	(37.7828773790282, -122.420731060153)
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)
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)
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)
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)
88720	88720	29582	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	510X Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991359.8087356	2093789.3771641003	37.7286500887761	-122.472149394695	(37.7286500887761, -122.472149394695)
17711	17711	29585	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991398.016530001	2093471.7437599998	37.7277801578055	-122.47199416782101	(37.7277801578055, -122.471994167821)
116075	116075	29587	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	610X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3X3		5991336.987432401	2093443.9543843998	37.7277003234109	-122.472203119704	(37.7277003234109, -122.472203119704)
18901	18901	29590	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991297.67299	2091930.7639	37.723543203431504	-122.47222877213301	(37.7235432034315, -122.472228772133)
13311	13311	29591	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991298.8544	2091955.25413	37.7236105159064	-122.47222647259899	(37.7236105159064, -122.472226472599)
22027	22027	29592	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			12	3X3		5991300.07797	2091981.73158	37.723683287234	-122.472224172111	(37.723683287234, -122.472224172111)
17935	17935	29599	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991176.65606	2091094.6598	37.7212404641514	-122.472586172621	(37.7212404641514, -122.472586172621)
127749	127749	29603	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
112917	112917	29604	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
87249	87249	29605	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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