Street_Tree_List

Data source: data.sfgov.org

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

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
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)
582	582	27390	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	2240 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6007140.50399	2120032.48345	37.8016081117892	-122.419455519354	(37.8016081117892, -122.419455519354)
2283	2283	7972	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1950 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6005640.29534	2116816.4309400003	37.7926930351995	-122.424418048575	(37.7926930351995, -122.424418048575)
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)
2886	2886	7974	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1955 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005597.935869999	2116784.08675	37.7926018340689	-122.424562312409	(37.7926018340689, -122.424562312409)
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)
4694	4694	7986	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	2111 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005534.41759	2117282.00669	37.7939654095207	-122.424817527421	(37.7939654095207, -122.424817527421)
5334	5334	17712	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1214 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	3X3		6002329.348999999	2112708.9615	37.7812274480895	-122.435580057373	(37.7812274480895, -122.435580057373)
6112	6112	17719	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1250 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3X3		6002302.3774	2112913.4677	37.78178743852221	-122.43568800125799	(37.7817874385222, -122.435688001258)
6348	6348	7967	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1901 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6005619.52925	2116640.16995	37.7922078941213	-122.424477357045	(37.7922078941213, -122.424477357045)
6879	6879	6058	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1905 Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	4X4		6001281.6188	2112455.0533	37.780470716869395	-122.439186474434	(37.7804707168694, -122.439186474434)
7479	7479	7952	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	1740 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6005743.00192	2116111.2494799998	37.7907625828685	-122.424012509171	(37.7907625828685, -122.424012509171)
7554	7554	12324	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1005 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6004768.4493	2112339.49	37.780351202823205	-122.427115646852	(37.7803512028232, -122.427115646852)
9709	9709	121554	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	330 Eureka St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3	Permit Number 779292	6001441.0	2103840.0	37.7568249841019	-122.438017823933	(37.7568249841019, -122.438017823933)
10204	10204	173902	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	601x Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1
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)
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)
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)
14345	14345	25704	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	564 06th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3X3		6012091.3603	2110309.05533	37.7751874779549	-122.401639385748	(37.7751874779549, -122.401639385748)
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)
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)
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)
17545	17545	17038	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	1200X Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6001065.34359	2109713.09337	37.772929678688506	-122.43973803201	(37.7729296786885, -122.43973803201)
18911	18911	12302	DPW Maintained 3	Ligustrum lucidum :: Glossy Privet 55	945X McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6004623.92182	2111884.23425	37.7790930089412	-122.42758319096399	(37.7790930089412, -122.427583190964)
23372	23372	137917	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	408 AUSTIN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005199.6845	2115305.406	37.7885192491697	-122.425834977285	(37.7885192491697, -122.425834977285)
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)
24110	24110	227479	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	245 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003729.9589599995	2109287.5082400003	37.771912433934105	-122.430490439197	(37.7719124339341, -122.430490439197)
24229	24229	141575	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1478 Grove St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6000744.6746	2110704.0393	37.7756323088735	-122.44091836280899	(37.7756323088735, -122.440918362809)
24609	24609	227488	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	363 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6003985.989080001	2109021.37679	37.771196202169705	-122.429585829147	(37.7711962021697, -122.429585829147)
25107	25107	191446	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2 Tulare St	2	Front Yard : Yard 7	Tree 1	Private 1			7			6016252.95003	2100312.60959	37.747970718394704	-122.386546192477	(37.7479707183947, -122.386546192477)
25221	25221	129562	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3299 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6000843.46741	2119560.3613299998	37.7999551030067	-122.441212183615	(37.7999551030067, -122.441212183615)
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)
25497	25497	227302	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1287 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6003266.52543	2100725.05977	37.7483757406618	-122.43148211980301	(37.7483757406618, -122.431482119803)
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)
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)
26441	26441	226744	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1198 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6010266.86598	2102287.21405	37.753059346011895	-122.40738510305599	(37.7530593460119, -122.407385103056)
26570	26570	226725	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2730 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6010324.661	2102839.65935	37.754579472764895	-122.407224175681	(37.7545794727649, -122.407224175681)
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)
26782	26782	141376	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	340 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6000731.9492	2110174.3711	37.7741772489645	-122.440924377301	(37.7741772489645, -122.440924377301)
27711	27711	142321	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1542 HAYES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000429.2107	2110311.8766	37.7745375574505	-122.441981472333	(37.7745375574505, -122.441981472333)
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)
29149	29149	226660	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2 Dolores St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6004732.5122	2108095.82328	37.7686970968169	-122.426937645858	(37.7686970968169, -122.426937645858)
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)
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)
31106	31106	114466	Permitted Site 1	Ligustrum lucidum :: Glossy Privet 55	2351 Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	3x3		6009278.4623	2121786.53745	37.8065444922964	-122.412181221704	(37.8065444922964, -122.412181221704)
31136	31136	201239	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	832 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6012006.1458	2112576.455	37.7814084789041	-122.4020936026	(37.7814084789041, -122.4020936026)
31254	31254	129563	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2270 Francisco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6000463.82549	2119961.7151099998	37.8010354810636	-122.442554716754	(37.8010354810636, -122.442554716754)
31932	31932	191468	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1 Jack London Aly	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6014292.29593	2112680.8823700002	37.7818225483087	-122.394191885869	(37.7818225483087, -122.394191885869)
32071	32071	227389	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3014 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009181.84583	2104530.5514	37.759158255859106	-122.411295791464	(37.7591582558591, -122.411295791464)
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)
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)
33884	33884	227436	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	18 Caselli Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6000934.92196	2104940.29183	37.759817324036796	-122.439846911128	(37.7598173240368, -122.439846911128)
34201	34201	142176	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1480 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000776.2338	2110357.6285	37.774682949664204	-122.44078433758999	(37.7746829496642, -122.44078433759)
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)
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)
34920	34920	226714	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1208 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6010278.22843	2102080.18456	37.7524915248726	-122.407331215672	(37.7524915248726, -122.407331215672)
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)
35392	35392	227233	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	3591 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006377.06245	2104334.1505299998	37.7584612794952	-122.420982147336	(37.7584612794952, -122.420982147336)
35764	35764	143380	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1897 Union St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003965.1287	2118668.8078	37.7976844492982	-122.430346412036	(37.7976844492982, -122.430346412036)
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)
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)
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)
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)
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)
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)
37569	37569	141819	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1045 LAGUNA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004740.795	2112530.2338	37.7808733743326	-122.42722490683998	(37.7808733743326, -122.42722490684)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
41149	41149	227215	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	775 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6009110.12793	2104609.60949	37.759371308854604	-122.411549412872	(37.7593713088546, -122.411549412872)
41223	41223	129612	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	711 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6009194.012019999	2115430.46227	37.789087538016794	-122.41202400940399	(37.7890875380168, -122.412024009404)
41490	41490	227279	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	4530 25th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 4ft		6000798.050340001	2101148.90098	37.749399291454	-122.44004841589701	(37.749399291454, -122.440048415897)
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)
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)
42439	42439	227449	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	791 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003106.45388	2103637.56402	37.7563637151333	-122.432243615346	(37.7563637151333, -122.432243615346)
42545	42545	227299	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	4233 Cesar Chavez St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6002389.0649	2100323.63751	37.7472237585745	-122.43448765677499	(37.7472237585745, -122.434487656775)
42571	42571	226722	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1111 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6010289.0097	2102653.41278	37.7540660857915	-122.40733433900499	(37.7540660857915, -122.407334339005)
43200	43200	226750	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	188 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6004784.115	2109030.2086099996	37.7712656109374	-122.426825708165	(37.7712656109374, -122.426825708165)
43940	43940	227468	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	43 Uranus Ter	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5999310.34636	2105508.81384	37.7612857352771	-122.445506381621	(37.7612857352771, -122.445506381621)
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)
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)
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)
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)
45235	45235	129609	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1700 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6005904.29601	2117592.2982	37.794838276212396	-122.423559780579	(37.7948382762124, -122.423559780579)
45322	45322	191483	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	701 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6012443.09783	2111154.5350900004	37.7775285931066	-122.40048204100701	(37.7775285931066, -122.400482041007)
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)
45868	45868	129601	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	2230 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6005516.8194699995	2117765.82234	37.795292851133794	-122.424912856464	(37.7952928511338, -122.424912856464)
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)
46792	46792	226717	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1266 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		6010290.67208	2101875.6000099997	37.7519304774296	-122.407273762489	(37.7519304774296, -122.407273762489)
47017	47017	129614	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1050 Van Ness Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6006528.24106	2114177.52587	37.7854973571526	-122.42115824896999	(37.7854973571526, -122.42115824897)
47166	47166	227292	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	1831 Castro St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6002653.15618	2100170.70248	37.746818822623894	-122.433563522461	(37.7468188226239, -122.433563522461)
47461	47461	247844	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	151 Chapman St	2	Side Yard : Yard 17	Tree 1	Private 1			23			6009115.842759999	2098211.0441099997	37.7418025958075	-122.41107768521002	(37.7418025958075, -122.41107768521)

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