Street_Tree_List

Data source: data.sfgov.org

392 rows where SiteOrder = 2 and qSpecies = 55 sorted by rowid 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

- 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
188803	188803	201857	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1104 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6010239.403	2110891.1863	37.776682357885896	-122.408086815194	(37.7766823578859, -122.408086815194)
188519	188519	129635	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1181 Union St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6007311.91376	2119137.96682	37.799161647339204	-122.41879888656099	(37.7991616473392, -122.418798886561)
188060	188060	244960	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	202 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6005166.2714	2109775.654	37.7733340235563	-122.425556873948	(37.7733340235563, -122.425556873948)
188009	188009	177141	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	355 Naples St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003671.36983	2091507.3370599998	37.7230889064227	-122.429424930532	(37.7230889064227, -122.429424930532)
187892	187892	177123	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	342 Harvard St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		6006356.99395	2092231.60745	37.7252292829921	-122.4201926235	(37.7252292829921, -122.4201926235)
187836	187836	138111	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2109 BUSH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003316.4709	2114827.0332	37.787099156045606	-122.432316422563	(37.7870991560456, -122.432316422563)
187511	187511	226663	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	109 Buchanan St	2	: 4	Tree 1	Private 1			10	Width 4ft		6004754.99125	2108900.4446099997	37.77090766370029	-122.426917205171	(37.7709076637003, -122.426917205171)
187508	187508	191440	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2212 25th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		6012152.298359999	2101896.5627900003	37.75209205051161	-122.40083742701401	(37.7520920505116, -122.400837427014)
187310	187310	227505	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	11 Ohlone Way	2	Back Yard : Yard 13	Tree 1	Private 1			4	Width 2ft		6002170.3179	2096422.89629	37.7365008135581	-122.434965139225	(37.7365008135581, -122.434965139225)
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)
186910	186910	200608	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1403 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6016392.0635	2095142.0480000002	37.7337811080514	-122.385704820187	(37.7337811080514, -122.385704820187)
186737	186737	73860	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1652 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/11/1993 12:00:00 AM	12			6008793.24364	2118610.57457	37.7977968533	-122.41363563948299	(37.7977968533, -122.413635639483)
186582	186582	191488	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	288 07th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6010222.32118	2110959.01545	37.776867644449204	-122.40815069140301	(37.7768676444492, -122.408150691403)
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)
185859	185859	226736	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3652 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 6ft		6005358.92953	2102566.09607	37.7535491707736	-122.424377554773	(37.7535491707736, -122.424377554773)
185710	185710	129631	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2615 Larkin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6006581.14621	2120178.38554	37.8019772007523	-122.421401522778	(37.8019772007523, -122.421401522778)
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)
184929	184929	227509	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	41 Brady St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006621.39205	2109628.6264	37.7730124325176	-122.420512962002	(37.7730124325176, -122.420512962002)
183260	183260	207993	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	395 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 10ft		5999470.9807400005	2094940.5496900002	37.732277001865604	-122.444191374942	(37.7322770018656, -122.444191374942)
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)
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)
183038	183038	227370	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1156 Shotwell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008042.48405	2101188.10567	37.749916692119704	-122.414999684386	(37.7499166921197, -122.414999684386)
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)
182178	182178	129664	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2208 Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6009352.05636	2121603.21217	37.8060452561514	-122.411913571751	(37.8060452561514, -122.411913571751)
180646	180646	177121	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	163 Vienna St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		6004588.387180001	2092450.0669200001	37.7257293114356	-122.426322070732	(37.7257293114356, -122.426322070732)
180220	180220	248212	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	67 Fair Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			45	Width 6ft		6007009.12213	2099449.33024	37.745084284924104	-122.41844983181801	(37.7450842849241, -122.418449831818)
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)
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)
179685	179685	191464	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	54 South Park	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6014410.7663900005	2112744.50721	37.7820038318593	-122.393786484975	(37.7820038318593, -122.393786484975)
179639	179639	227393	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	300 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6009249.42963	2104535.9463	37.7591768592327	-122.411062434482	(37.7591768592327, -122.411062434482)
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)
178675	178675	227219	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1167 Shotwell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6008083.6938	2101143.88138	37.7497975778031	-122.41485404907101	(37.7497975778031, -122.414854049071)
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)
178138	178138	227473	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	17 Uranus Ter	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5999351.603080001	2105616.9876200003	37.7615851087781	-122.445371470721	(37.7615851087781, -122.445371470721)
178025	178025	140574	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1223 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003276.6668	2111699.7696	37.778510218571	-122.432230713465	(37.778510218571, -122.432230713465)
177334	177334	226748	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	100 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6004804.2033400005	2108897.19386	37.7709015204117	-122.42674674767001	(37.7709015204117, -122.42674674767)
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)
176142	176142	227395	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2080 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6008020.65806	2106222.1524400003	37.76373780876379	-122.41543150465401	(37.7637378087638, -122.415431504654)
174993	174993	129644	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	724 Francisco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 4ft		6007831.26083	2120995.6473	37.804291598853	-122.41713346715099	(37.804291598853, -122.417133467151)
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)
173295	173295	200059	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1801 Lane St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 0ft		6014873.6392	2094076.1095	37.7307701187384	-122.390880037484	(37.7307701187384, -122.390880037484)
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)
172950	172950	245069	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	4 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000408.7062	2108954.5393	37.7708094828751	-122.441954956883	(37.7708094828751, -122.441954956883)
172939	172939	201861	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1116 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6010150.0088	2110807.2194	37.7764467987551	-122.408390133412	(37.7764467987551, -122.408390133412)
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)
172527	172527	177103	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	154 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 2ft		6000580.38347	2091726.23406	37.723514460202395	-122.440125516598	(37.7235144602024, -122.440125516598)
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)
171878	171878	114459	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1455 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		6000893.3376	2110327.3177	37.7746063922099	-122.44037707870399	(37.7746063922099, -122.440377078704)
171526	171526	227230	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3181 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6007086.84974	2103201.10663	37.755390186427704	-122.418447040308	(37.7553901864277, -122.418447040308)
171159	171159	140600	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	864 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6003675.8209	2111455.7518	37.7778628297475	-122.430832469608	(37.7778628297475, -122.430832469608)
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)
170238	170238	249928	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	363 Filbert St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 0ft		6011076.21302	2120004.52946	37.801752245226396	-122.40583413315001	(37.8017522452264, -122.40583413315)
170145	170145	129621	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1513 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 2ft		6007498.65921	2116790.1578900004	37.792725661708005	-122.417986155759	(37.792725661708, -122.417986155759)
170068	170068	227213	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1085 South Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007654.8641	2103387.34278	37.7559335082294	-122.416495860392	(37.7559335082294, -122.416495860392)
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)
169584	169584	191480	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	526 05th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6012537.84104	2111160.5359	37.7775503530914	-122.400154712085	(37.7775503530914, -122.400154712085)
168146	168146	141896	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	601 Redwood St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004778.1201	2112091.5685	37.7796710183851	-122.427064527635	(37.7796710183851, -122.427064527635)
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)
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)
167423	167423	227307	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	415 Beacon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6002310.77433	2098320.0282799997	37.741717872474396	-122.434615134802	(37.7417178724744, -122.434615134802)
166078	166078	226668	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	298 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008865.94709	2106940.47139	37.7657576213427	-122.412558680646	(37.7657576213427, -122.412558680646)
165909	165909	227209	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	35 Powhattan Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 3ft		6007561.8732	2098204.30964	37.741696837339504	-122.416450338512	(37.7416968373395, -122.416450338512)
165763	165763	245038	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	52 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000374.8769	2109186.6782	37.7714449501468	-122.44208863854901	(37.7714449501468, -122.442088638549)
164252	164252	138669	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1716 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999601.6075	2114746.9787	37.7866680088585	-122.44516322805	(37.7866680088585, -122.44516322805)
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)
163086	163086	129581	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2845 Green St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		5999473.29615	2117693.165	37.794750136363	-122.445819117259	(37.794750136363, -122.445819117259)
162552	162552	191452	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	110 Main St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6014395.4165199995	2116019.0408900003	37.790994095352296	-122.39406889728501	(37.7909940953523, -122.394068897285)
162490	162490	227199	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	385 Prentiss St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6008809.712730001	2097016.0222900002	37.738504155041	-122.41205175259199	(37.738504155041, -122.412051752592)
161571	161571	107462	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1629 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5			6008769.702769999	2118455.29192	37.797369163620296	-122.41370610855101	(37.7973691636203, -122.413706108551)
161120	161120	129572	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2267 Francisco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000506.86895	2119922.56555	37.8009304402543	-122.442402956127	(37.8009304402543, -122.442402956127)
160780	160780	141899	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	911 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6004810.4487	2112001.6361	37.779425914208204	-122.426946282067	(37.7794259142082, -122.426946282067)
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)
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)
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)
159411	159411	227462	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	236 Corbett Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 2ft		5999847.6804	2105560.7222700003	37.7614589240024	-122.44365170527	(37.7614589240024, -122.44365170527)
159296	159296	129606	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2101 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6005930.11566	2117709.2304599998	37.7951608000883	-122.42347875793301	(37.7951608000883, -122.423478757933)
159072	159072	227265	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	748 Duncan St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6			6001689.18438	2099736.15615	37.7455709197615	-122.436865735887	(37.7455709197615, -122.436865735887)
158690	158690	227202	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	178 Highland Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		6006026.759740001	2096606.67629	37.737223645453	-122.421644810956	(37.737223645453, -122.421644810956)
158351	158351	227361	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	790 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6009073.26024	2104604.24835	37.7593545203172	-122.41167654103701	(37.7593545203172, -122.411676541037)
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)
156744	156744	227456	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	34 Levant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6000235.72024	2106677.53152	37.7645475295791	-122.442389820631	(37.7645475295791, -122.442389820631)
155916	155916	227375	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	395 Bartlett St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6006792.166780001	2101508.46009	37.7507259731465	-122.419346074576	(37.7507259731465, -122.419346074576)
155829	155829	226710	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	401 Guerrero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6005556.79259	2106601.59112	37.7646408648026	-122.423980249586	(37.7646408648026, -122.423980249586)
155175	155175	227259	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1035 Douglass St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 1ft		6001350.9072	2100668.98044	37.748113001917	-122.438102253317	(37.748113001917, -122.438102253317)
154902	154902	191501	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	299x Cashmere St	2	Median : Yard 3	Tree 1	DPW 2			27			6016915.88272	2095866.14342	37.735798300938704	-122.383944206463	(37.7357983009387, -122.383944206463)
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)
153647	153647	191443	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	394 19th St	2	: 4	Tree 1	Private 1			10	Width 3ft		6013161.12259	2105230.3834700002	37.7613022153415	-122.397582536801	(37.7613022153415, -122.397582536801)
153048	153048	98645	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	2110 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW 4		9	5x5		6002788.88101	2119245.38589	37.799200885676605	-122.434457791187	(37.7992008856766, -122.434457791187)
152449	152449	227507	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	78 Colton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006662.68149	2109606.33946	37.7729535646992	-122.420368554271	(37.7729535646992, -122.420368554271)
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)
151424	151424	177077	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	490 Blanken Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012777.255059999	2087037.0196900002	37.7113256535156	-122.39763409854099	(37.7113256535156, -122.397634098541)
150807	150807	227206	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	533 Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6008501.51256	2096513.03778	37.7371057722089	-122.413081808196	(37.7371057722089, -122.413081808196)
150581	150581	227386	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3130 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008951.42637	2104520.01405	37.7591163969354	-122.412091950499	(37.7591163969354, -122.412091950499)
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)
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)
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)
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)
149480	149480	227321	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	4356 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6000855.67889	2102314.56215	37.7526031972881	-122.43993270375799	(37.7526031972881, -122.439932703758)
149225	149225	129559	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2661 Greenwich St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 1ft		6000174.650330001	2118828.48318	37.7979074402255	-122.443473935388	(37.7979074402255, -122.443473935388)
148408	148408	137991	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1908 BUCHANAN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003942.8867	2115083.0611	37.7878376428475	-122.430167434422	(37.7878376428475, -122.430167434422)

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