Street_Tree_List

Data source: data.sfgov.org

392 rows where SiteOrder = 2 and qSpecies = 55 sorted by XCoord

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, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
10204	10204	173902	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	601x Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1
70732	70732	46972	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1686 44th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/01/2002 12:00:00 AM	2		Permit Number 44991	5982549.0126	2103652.333	37.755217228081996	-122.50333832645	(37.755217228082, -122.50333832645)
71064	71064	183299	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1286 42nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5983077.482999999	2106392.3859	37.7627716918826	-122.501713459776	(37.7627716918826, -122.501713459776)
179715	179715	120187	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	218 26th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5987760.31768	2114496.30361	37.7852967290916	-122.486112314519	(37.7852967290916, -122.486112314519)
147156	147156	182589	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2483 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5988272.3462	2098420.0243	37.741185487105	-122.483162087393	(37.741185487105, -122.483162087393)
64567	64567	120483	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2309 Lake St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 1ft		5988277.53401	2114625.15663	37.7856806525102	-122.48433237916201	(37.7856806525102, -122.484332379162)
154151	154151	101278	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2323 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		5988527.6084	2106443.4757	37.763230591454395	-122.482867371906	(37.7632305914544, -122.482867371906)
168055	168055	120397	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	101 23rd Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 1ft		5988633.138590001	2114628.42785	37.785710333915404	-122.48310234386899	(37.7857103339154, -122.483102343869)
44679	44679	101107	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1790 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3X3	Permit Number 14067	5988779.1453	2103160.9003	37.7542321578078	-122.48175694812299	(37.7542321578078, -122.481756948123)
55289	55289	177095	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	0 Serrano Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			48			5989637.49515	2090738.06528	37.720172132515	-122.47788049948	(37.720172132515, -122.47788049948)
74160	74160	122271	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1600 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5990587.5386	2111332.78753	37.776774954972204	-122.476099955577	(37.7767749549722, -122.476099955577)
41939	41939	207892	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2119 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5990666.05125	2100929.33737	37.7482144184726	-122.47506873135299	(37.7482144184726, -122.475068731353)
170030	170030	122095	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	585 16th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		5990929.30413	2111377.25898	37.776916873099	-122.474920945501	(37.776916873099, -122.474920945501)
136063	136063	122093	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	701 16th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5990957.61701	2110561.8313599997	37.774679572778204	-122.474763472642	(37.7746795727782, -122.474763472642)
34798	34798	122131	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1 15th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			5991115.120209999	2115013.7594	37.786912464412104	-122.47454361357	(37.7869124644121, -122.47454361357)
64682	64682	207404	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2692 16th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991464.58809	2097102.41328	37.737752914457396	-122.472028548874	(37.7377529144574, -122.472028548874)
157262	157262	207897	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	450 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991557.6312	2097072.51432	37.7376762031927	-122.471704678736	(37.7376762031927, -122.471704678736)
171151	171151	207895	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2405 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5991680.9977	2099010.21605	37.7430037753042	-122.47141929508801	(37.7430037753042, -122.471419295088)
77315	77315	207890	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1585 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991722.660569999	2104556.3453900004	37.7582344164913	-122.47167932056999	(37.7582344164913, -122.47167932057)
138220	138220	207375	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1240 14th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 5ft		5991777.760009999	2107019.09717	37.7649996682339	-122.471668232808	(37.7649996682339, -122.471668232808)
64994	64994	207926	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1630 Portola Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5991910.04045	2096405.2401	37.7358644199941	-122.470437659868	(37.7358644199941, -122.470437659868)
36586	36586	207860	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	88 Ralston St	2	: 4	Tree 1	Private 1			6	Width 3ft		5992206.435269999	2088409.02561	37.7139259191081	-122.468831219804	(37.7139259191081, -122.468831219804)
36298	36298	207910	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	272 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992257.40464	2097504.13559	37.7389017884968	-122.46931665586	(37.7389017884968, -122.46931665586)
45797	45797	207862	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	50 Vernon St	2	: 4	Tree 1	Private 1			13	Width 3ft		5992461.4298	2088225.8604700002	37.7134377203567	-122.467936556254	(37.7134377203567, -122.467936556254)
49286	49286	207854	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	258 Vernon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		5992483.5365	2089596.1759	37.717201552190105	-122.467959759631	(37.7172015521901, -122.467959759631)
151691	151691	217705	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	200 West Portal Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5992558.2572	2097459.9542	37.7387978584587	-122.468273243142	(37.7387978584587, -122.468273243142)
172277	172277	207907	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	200 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992559.1719	2097834.73481	37.7398269642322	-122.468297338164	(37.7398269642322, -122.468297338164)
51405	51405	207949	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2300 09th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5992678.23044	2100499.52384	37.74715067338229	-122.468079477383	(37.7471506733823, -122.468079477383)
123815	123815	207396	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	347 Noriega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5992865.43172	2103190.1743799997	37.754549316717	-122.467627800978	(37.754549316717, -122.467627800978)
25839	25839	36982	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	251 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/29/1998 12:00:00 AM	9		Permit Number 39606	5993044.7391	2113780.4585	37.7836377719626	-122.467777899893	(37.7836377719626, -122.467777899893)
159856	159856	123767	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	801 Cabrillo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		5993113.80746	2110684.76111	37.7751418134998	-122.467313779933	(37.7751418134998, -122.467313779933)
93704	93704	111067	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1800 10TH AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5993175.0	2103134.0	37.754412945302796	-122.46655315826901	(37.7544129453028, -122.466553158269)
25228	25228	123214	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	598 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5993175.3131800005	2111469.83533	37.7773009664124	-122.467158112666	(37.7773009664124, -122.467158112666)
183091	183091	207373	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	805 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5993247.553309999	2106602.4010900003	37.7639404575053	-122.46655433693701	(37.7639404575053, -122.466554336937)
100780	100780	63619	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	801X Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/19/1987 12:00:00 AM			Permit Number 24261	5993268.63068404	2106608.32607844	37.7639579422382	-122.466481867874	(37.7639579422382, -122.466481867874)
149924	149924	123764	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	773 Cabrillo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		5993275.9255	2110687.3078900003	37.775158163745395	-122.466753167394	(37.7751581637454, -122.466753167394)
131503	131503	177093	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1 Santa Barbara Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		5993374.13741	2086578.2467	37.7089664287264	-122.464662374692	(37.7089664287264, -122.464662374692)
149724	149724	207388	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	337 Judah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		5993451.68275	2105929.50616	37.7621046417451	-122.46579942622499	(37.7621046417451, -122.465799426225)
163811	163811	207919	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1475 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993555.00989	2095089.8986	37.73234779381271	-122.464654913005	(37.7323477938127, -122.464654913005)
129054	129054	101245	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1301X 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/28/1972 12:00:00 AM			Permit Number 9950	5993577.2	2106568.3	37.763865841987204	-122.465411719392	(37.7638658419872, -122.465411719392)
167970	167970	207952	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2101 09th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993588.025769999	2101347.20495	37.7495306895917	-122.464995058183	(37.7495306895917, -122.464995058183)
58174	58174	207384	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1313 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		5993603.41826	2106572.0507	37.7638776524679	-122.465321311553	(37.7638776524679, -122.465321311553)
36010	36010	124006	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	317 06th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993993.05196	2113317.82829	37.782422226449	-122.46446352346001	(37.782422226449, -122.46446352346)
59408	59408	124243	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	498 Clement St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5994055.9779900005	2113538.58434	37.7830319899727	-122.464261860643	(37.7830319899727, -122.464261860643)
63027	63027	207411	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	368 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994209.72393	2101319.30186	37.7494899026486	-122.462843199076	(37.7494899026486, -122.462843199076)
68993	68993	207925	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	275 Magellan Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		5994659.0424	2100279.1844900004	37.746659871972795	-122.461214068202	(37.7466598719728, -122.461214068202)
149944	149944	207913	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	100 Merced Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5994687.05198	2099628.96292	37.7448761386401	-122.461070093006	(37.7448761386401, -122.461070093006)
130205	130205	207917	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1 Pacheco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5994692.52857	2099722.50735	37.7451333033531	-122.461057935084	(37.7451333033531, -122.461057935084)
128670	128670	122343	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1250X Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5994723.0	2112183.0	37.7793483429351	-122.461855927769	(37.7793483429351, -122.461855927769)
35972	35972	207841	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	314 Faxon Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		5994779.70633	2090681.1537400002	37.72031297444521	-122.460101600536	(37.7203129744452, -122.460101600536)
160540	160540	207838	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	506 Faxon Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 1ft		5994800.95024	2091971.89024	37.7238582494329	-122.46012162930401	(37.7238582494329, -122.460121629304)
172576	172576	30910	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	500 Faxon Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/13/1995 12:00:00 AM	11		Permit Number 34732	5994801.3845	2091947.2904299998	37.723790729247	-122.46011834680901	(37.723790729247, -122.460118346809)
2689	2689	207839	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	626X Holloway Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5994826.85492	2091253.8672900002	37.721888220645	-122.459980091334	(37.721888220645, -122.459980091334)
150511	150511	207974	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1 Cresta Vista Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995054.28957	2096220.4880400002	37.7355384364438	-122.45955344665501	(37.7355384364438, -122.459553446655)
71982	71982	207810	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	275 Dalewood Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		5995297.028940001	2097233.56959	37.73833406445161	-122.458787531816	(37.7383340644516, -122.458787531816)
40319	40319	207930	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	101 San Ramon Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995748.4181	2092708.16322	37.7259343298845	-122.45689963632499	(37.7259343298845, -122.456899636325)
26392	26392	207957	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	70 Woodside Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5995759.15859	2100245.2253900003	37.7466298786655	-122.45740754733102	(37.7466298786655, -122.457407547331)
159506	159506	124556	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	84 Palm Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5995918.89064	2113938.27362	37.784236629732	-122.45784591951	(37.784236629732, -122.45784591951)
30756	30756	124328	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	116 Palm Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		5995929.77747	2113622.35703	37.783369832624004	-122.45778538742901	(37.783369832624, -122.457785387429)
49063	49063	207971	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	204 Cresta Vista Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5996300.1100699995	2096185.08811	37.735512794089104	-122.455243639995	(37.7355127940891, -122.455243639995)
38698	38698	207413	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	916 Rockdale Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		5996523.58257	2098185.78837	37.741019048902004	-122.45461550759701	(37.741019048902, -122.454615507597)
179791	179791	36154	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	70 Commonwealth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/01/1998 12:00:00 AM	6		Permit Number 39238	5996549.8051	2114133.6254	37.7848092398389	-122.45567731688699	(37.7848092398389, -122.455677316887)
42435	42435	141709	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	449 PARKER AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5997090.1697	2111836.8374	37.7785338604663	-122.453641938936	(37.7785338604663, -122.453641938936)
71584	71584	97818	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	431 Spruce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x3		5997175.35999	2114852.37402	37.7868186114345	-122.453565028427	(37.7868186114345, -122.453565028427)
10235	10235	173926	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	601x Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997414.0	2094357.0	37.7305571474498	-122.451260720639	(37.7305571474498, -122.451260720639)
185675	185675	141039	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	82 Cook St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5997548.9955	2113146.6183	37.7821564681962	-122.45214922274799	(37.7821564681962, -122.452149222748)
186286	186286	129567	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	245 Locust St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5997570.752730001	2115509.3434099997	37.788645132713796	-122.45224449091101	(37.7886451327138, -122.452244490911)
88091	88091	87157	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	237 Rivoli St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 50138	5997662.0	2105892.0	37.762243628012705	-122.451234923187	(37.7622436280127, -122.451234923187)
178368	178368	244024	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1849 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5997729.8005	2108843.8889	37.7703526453668	-122.45121332138099	(37.7703526453668, -122.451213321381)
107897	107897	96699	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1849 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		5997732.0	2108845.0	37.770355822096704	-122.451205793491	(37.7703558220967, -122.451205793491)
130223	130223	227191	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1132 Shrader St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5997742.39239	2106527.65668	37.76399358315221	-122.45100271691999	(37.7639935831522, -122.45100271692)
2916	2916	140305	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2084 HAYES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5997929.2973	2109958.9845	37.7734258317863	-122.450603670824	(37.7734258317863, -122.450603670824)
174337	174337	227172	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	146 Alma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5998001.55588	2106218.8561400003	37.7631605285516	-122.450084092719	(37.7631605285516, -122.450084092719)
147509	147509	207966	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	735 Foerster St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5998008.19389	2095778.9308900002	37.7344954360226	-122.449308921174	(37.7344954360226, -122.449308921174)
61889	61889	227166	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	119 Grattan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5998061.28283	2106501.90787	37.7639411347101	-122.44989791865	(37.7639411347101, -122.44989791865)
95860	95860	114797	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	103 Grattan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5998130.990703201	2106502.59817932	37.7639470183873	-122.44965687078998	(37.7639470183873, -122.44965687079)
40083	40083	227170	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1105 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5998136.607340001	2106470.82303	37.7638600931786	-122.449635154751	(37.7638600931786, -122.449635154751)
104594	104594	121622	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	298X Staples Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5998141.0	2093851.0	37.72920939055871	-122.44871095421401	(37.7292093905587, -122.448710954214)
143245	143245	17111	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1837 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		5998183.72781	2109230.9980599997	37.7714415276809	-122.44967109380501	(37.7714415276809, -122.449671093805)
50841	50841	207969	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	195 Los Palmos Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5998222.895169999	2096278.92785	37.735880587118004	-122.44860262962798	(37.735880587118, -122.448602629628)
179120	179120	227177	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	73 Grattan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5998245.928280001	2106526.60293	37.7640195043316	-122.44926106735399	(37.7640195043316, -122.449261067354)
25638	25638	139004	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	155 CLAYTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5998267.7815	2110059.6372	37.7737215666049	-122.44944006458599	(37.7737215666049, -122.449440064586)
37891	37891	227521	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1500 Cole St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			10	Width 4ft		5998355.105169999	2105264.42447	37.7605601235622	-122.448792539459	(37.7605601235622, -122.448792539459)
38750	38750	208004	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	551 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 10ft		5998446.15319	2094958.3543599998	37.7322673692323	-122.447735703852	(37.7322673692323, -122.447735703852)
33361	33361	246400	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	612 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998516.7885	2108556.8079	37.7696094224276	-122.448470464048	(37.7696094224276, -122.448470464048)
176161	176161	31106	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	101 Edna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/21/1995 12:00:00 AM	18		Permit Number 34835	5998729.12577	2093250.24462	37.7275934702536	-122.446634555042	(37.7275934702536, -122.446634555042)
35313	35313	208011	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	126 Edna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5998765.6075	2093383.3893099998	37.727961138279205	-122.446518012793	(37.7279611382792, -122.446518012793)
183136	183136	207985	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	394 Mangels Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5998813.609180001	2095274.4257	37.733156221377	-122.446488060895	(37.733156221377, -122.446488060895)
66300	66300	248391	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	34 Downey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		5998818.8605	2108083.3346	37.7683266513008	-122.447391527869	(37.7683266513008, -122.447391527869)
67695	67695	248438	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	68 Downey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998841.1184	2107924.1979	37.7678909740755	-122.447303085161	(37.7678909740755, -122.447303085161)
182667	182667	244099	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1601 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5998841.7867	2108999.0531	37.7708422919425	-122.44737814683	(37.7708422919425, -122.44737814683)
66423	66423	245944	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	91 Downey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5998846.1151	2107698.4389	37.7672713824524	-122.44726955191003	(37.7672713824524, -122.44726955191)
173020	173020	248521	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	218 Downey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998872.007	2107700.4072	37.767278266344704	-122.44718013758002	(37.7672782663447, -122.44718013758)
80541	80541	111018	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	90x DOWNEY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/14/2015 12:00:00 AM		3x3		5998894.0	2107683.0	37.7672317271747	-122.447102814384	(37.7672317271747, -122.447102814384)
89173	89173	117520	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1601 PAGE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5998904.0	2109014.0	37.7708868872166	-122.447164026359	(37.7708868872166, -122.447164026359)
34744	34744	177051	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	765 Delano Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5998951.86154	2090168.3011	37.7191438872553	-122.44564302283199	(37.7191438872553, -122.445643022832)
36259	36259	208014	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	58 Marston Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			5998954.765869999	2093228.45695	37.7275465328469	-122.44585295156901	(37.7275465328469, -122.445852951569)
66479	66479	246041	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	635 Ashbury St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5998971.6377	2108485.0374	37.769438354581	-122.446891997517	(37.769438354581, -122.446891997517)
187210	187210	177060	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	550 Geneva Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		5999004.711019999	2090533.4907900002	37.7201496314864	-122.445486588437	(37.7201496314864, -122.445486588437)
72935	72935	227182	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	833 Ashbury St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		5999113.50291	2107439.01972	37.7665743577377	-122.44632603544399	(37.7665743577377, -122.446326035444)

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