Street_Tree_List

Data source: data.sfgov.org

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

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
45077	45077	177085	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	466 Tocoloma Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012392.66028	2086405.7608400001	37.7095709179289	-122.39891908764099	(37.7095709179289, -122.398919087641)
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)
37277	37277	177144	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	224 Naylor St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6002612.15992	2086733.11082	37.709919907953704	-122.43274552071001	(37.7099199079537, -122.43274552071)
10409	10409	104687	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	540 Blanken Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6013068.15068	2086901.5117	37.7109697693033	-122.396619189338	(37.7109697693033, -122.396619189338)
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)
59510	59510	177072	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	140 Blanken Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6012065.17517	2087224.72612	37.7118013805076	-122.400108416784	(37.7118013805076, -122.400108416784)
135468	135468	177083	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	199 Blanken Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6012071.18023	2087265.13818	37.7119126788116	-122.400090497793	(37.7119126788116, -122.400090497793)
26709	26709	177070	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	195 Allison St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 2ft		6000082.94652	2087742.95013	37.712548932973206	-122.44155935339501	(37.7125489329732, -122.441559353395)
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)
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)
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)
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)
40485	40485	177065	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	626 Madrid St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		6002192.98275	2090253.20784	37.7195615351173	-122.43444578884599	(37.7195615351173, -122.434445788846)
148258	148258	177067	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	573 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 5ft		6002673.20995	2090427.0269900002	37.720066052099206	-122.432798229977	(37.7200660520992, -122.432798229977)
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)
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)
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)
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)
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)
41100	41100	177100	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	377 Delano Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5999723.90595	2091657.9425099997	37.7232781498534	-122.443081294068	(37.7232781498534, -122.443081294068)
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)
52565	52565	177116	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	280 Vienna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6004076.346369999	2091739.8978900001	37.7237503874544	-122.42804157178101	(37.7237503874544, -122.428041571781)
10599	10599	25290	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	136 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6000711.5604	2091742.5944599998	37.7235668493142	-122.439673234935	(37.7235668493142, -122.439673234935)
73882	73882	177102	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	130 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		6000764.64112	2091750.39808	37.72359129737671	-122.439490303855	(37.7235912973767, -122.439490303855)
76560	76560	177125	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	418 Amherst St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6007739.52277	2091837.25861	37.724224288797004	-122.41538544049	(37.724224288797, -122.41538544049)
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)
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)
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)
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)
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)
45149	45149	177118	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	224 Avalon Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 2ft		6003359.98068	2092814.5992700001	37.726660722214	-122.430594576183	(37.726660722214, -122.430594576183)
106910	106910	40057	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1311 Shafter Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/19/1999 12:00:00 AM			Permit Number 41291	6016435.57889801	2093012.13201176	37.7279351895138	-122.385405998165	(37.7279351895138, -122.385405998165)
12057	12057	77641	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1300X Silliman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2	10/26/1984 12:00:00 AM	12	4x4		6006964.988919999	2093186.8525200002	37.7278864190206	-122.418158533295	(37.7278864190206, -122.418158533295)
103792	103792	35727	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	190 Dartmouth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/14/1998 12:00:00 AM			Permit Number 39007	6008565.46175199	2093223.89460892	37.7280780839519	-122.41262825854099	(37.7280780839519, -122.412628258541)
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)
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)
146083	146083	17143	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1030 Oakdale Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/12/1999 12:00:00 AM	3	3X3		6018053.0176703	2093253.3980264	37.7286870123052	-122.37983116682699	(37.7286870123052, -122.379831166827)
75215	75215	177113	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	34 Vienna St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		6005075.07966	2093337.7914900002	37.728194306415	-122.42470273344	(37.728194306415, -122.42470273344)
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)
148274	148274	72147	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	73 San Gabriel Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/26/1985 12:00:00 AM	10			6001070.59946	2093593.78195	37.7286702168354	-122.43856467842	(37.7286702168354, -122.43856467842)
123069	123069	1691	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	23 Baldwin Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6017695.7876646	2093605.1145141998	37.7296330451049	-122.381090589205	(37.7296330451049, -122.381090589205)
30591	30591	207827	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	100 Staples Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5999363.8655900005	2093797.08144	37.7291311940404	-122.444479544704	(37.7291311940404, -122.444479544704)
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)
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)
70114	70114	38632	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1595 Shafter Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/16/2011 12:00:00 AM	17	6x60	Permit Number 767658	6014957.1802	2094111.5595	37.730872092312204	-122.390593696874	(37.7308720923122, -122.390593696874)
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)
145506	145506	12205	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1365X La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016707.244956	2094751.5031778	37.7327261850679	-122.38458793904199	(37.7327261850679, -122.384587939042)
51985	51985	191495	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1198 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6016624.88641	2094815.22838	37.732896606882704	-122.38487711369301	(37.7328966068827, -122.384877113693)
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)
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)
23553	23553	200578	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1423 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6016466.7865	2094992.602	37.7333748936582	-122.385436067152	(37.7333748936582, -122.385436067152)
16766	16766	12174	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1415X La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	3X3		6016429.1110000005	2095062.9295	37.7335659143966	-122.385571222674	(37.7335659143966, -122.385571222674)
40353	40353	207983	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	620 Detroit St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5999460.54725	2095077.27531	37.7326518231051	-122.44423726735799	(37.7326518231051, -122.444237267358)
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)
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)
133974	133974	200576	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1447 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6016355.016	2095246.9114	37.7340669918878	-122.38584021234199	(37.7340669918878, -122.385840212342)
93142	93142	12170	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1421X La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/12/1993 12:00:00 AM	9	3X3		6016344.6880818	2095251.8114423	37.7340798748876	-122.38587626093799	(37.7340798748876, -122.385876260938)
112287	112287	12177	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1409X La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016344.6880818	2095251.8114423	37.7340798748876	-122.38587626093799	(37.7340798748876, -122.385876260938)
129338	129338	12165	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1439X La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016344.6880818	2095251.8114423	37.7340798748876	-122.38587626093799	(37.7340798748876, -122.385876260938)
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)
107274	107274	12183	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1445 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6016331.060111799	2095306.4617143	37.7342291794135	-122.385927185653	(37.7342291794135, -122.385927185653)
16421	16421	12185	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1445 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016337.4341	2095323.5181	37.734276365571105	-122.385906337047	(37.7342763655711, -122.385906337047)
16320	16320	12187	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1455 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016297.2469	2095451.6147	37.7346258690942	-122.386054205025	(37.7346258690942, -122.386054205025)
135248	135248	200524	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1475 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6016218.7564	2095580.3392	37.7349749763778	-122.386334547429	(37.7349749763778, -122.386334547429)
82904	82904	12198	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1485 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6016165.701365701	2095622.0691082	37.7350866214264	-122.38652088789301	(37.7350866214264, -122.386520887893)
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)
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)
39673	39673	227499	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3068 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6002862.42767	2095876.1703	37.7350389026183	-122.432533184459	(37.7350389026183, -122.432533184459)
166	166	251230	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	99x Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6007537.0	2096150.0	37.7360547576169	-122.416390866966	(37.7360547576169, -122.416390866966)
135391	135391	227357	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	701 Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6007581.53732	2096160.9049099998	37.736087204549	-122.416237655152	(37.736087204549, -122.416237655152)
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)
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)
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)
45171	45171	191505	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1499 Mendell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6015798.08452	2096291.0871299999	37.7369032520929	-122.387838548819	(37.7369032520929, -122.387838548819)
53837	53837	227249	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	140 Park St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 2ft		6005791.54038	2096357.8109900001	37.7365270503857	-122.422440395327	(37.7365270503857, -122.422440395327)
95375	95375	98676	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	199X Park St	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2					6006189.1	2096374.1	37.736594195559505	-122.421067016387	(37.7365941955595, -122.421067016387)
38841	38841	227252	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	191 Park St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 2ft		6006140.42151	2096376.3293	37.7365975725045	-122.42123547733499	(37.7365975725045, -122.421235477335)
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)
96494	96494	110186	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	625 Holly Park Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1					6006167.62160945	2096413.49051844	37.736701142359294	-122.421144072665	(37.7367011423593, -122.421144072665)
93011	93011	113435	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	198x HIGHLAND AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				4x4		6006173.0	2096415.0	37.73670559026029	-122.421125584355	(37.7367055902603, -122.421125584355)
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)
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)
101641	101641	78999	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	555 Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2	06/18/1994 12:00:00 AM	3	3x3		6008487.2849764	2096519.17342203	37.73712182063289	-122.413131433288	(37.7371218206329, -122.413131433288)
46624	46624	227354	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	625 Holly Park Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6006159.6705599995	2096547.0018900002	37.737067286627706	-122.42118104047701	(37.7370672866277, -122.421181040477)
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)
28241	28241	227326	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	279 Laidley St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004157.53404	2096855.56287	37.737801450879104	-122.42812531304199	(37.7378014508791, -122.428125313042)
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)
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)
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)
32805	32805	227501	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	49 Everson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6003541.82296	2097107.65785	37.738458790548	-122.430272104489	(37.738458790548, -122.430272104489)
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)
102595	102595	34533	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	395 Moultrie St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/22/1997 12:00:00 AM			Permit Number 38241	6007729.86435225	2097252.7163141	37.7390934181522	-122.415802113579	(37.7390934181522, -122.415802113579)
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)
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)
106709	106709	56255	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	250 Randall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/20/1973 12:00:00 AM	12	3x3	Permit Number 12381	6004004.54241313	2097731.78472111	37.740198698919	-122.428716724311	(37.740198698919, -122.428716724311)
60641	60641	227493	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	250 Randall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6003939.93238	2097767.7283	37.7402937348636	-122.42894268167299	(37.7402937348636, -122.428942681673)
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)
39838	39838	227348	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	383 Coleridge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006101.45441	2097927.38523	37.7408542283508	-122.421480324955	(37.7408542283508, -122.421480324955)
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)

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