Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by PlotSize 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

- 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, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▲	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
162455	162455	195979	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	900 Phelps St	1	Side Yard : Yard 17	Tree 1	Private 1			30	Width 9ft		6014704.25324	2097268.53042	37.739526454869704	-122.39168875963999	(37.7395264548697, -122.39168875964)
176864	176864	135666	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3001 Divisadero St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 9ft		6000472.49775	2118651.8946700003	37.797439556256705	-122.442430617479	(37.7974395562567, -122.442430617479)
72864	72864	234906	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 8ft		6009686.024230001	2096384.83518	37.7368201799074	-122.408977354526	(37.7368201799074, -122.408977354526)
156252	156252	234905	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 8ft		6009688.58582	2096390.10165	37.736834783993004	-122.40896886942	(37.736834783993, -122.40896886942)
160001	160001	196024	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1670 Owen St	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 8ft		6013848.21751	2107498.5657599997	37.7675683801977	-122.39536504787701	(37.7675683801977, -122.395365047877)
173216	173216	196023	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1670 Owen St	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6013858.29957	2107482.27299	37.7675242045935	-122.395329033601	(37.7675242045935, -122.395329033601)
176193	176193	234907	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 8ft		6009682.36778	2096375.42259	37.7367941301369	-122.40898933260401	(37.7367941301369, -122.408989332604)
28694	28694	246559	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	3	Median : Yard 3	Tree 1	DPW 2			6	Width 7ft		6005723.21879	2109372.62983	37.7722588698898	-122.42360165389299	(37.7722588698898, -122.423601653893)
28854	28854	246564	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	8	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6005706.72335	2109459.01828	37.7724951406584	-122.423664856449	(37.7724951406584, -122.423664856449)
30102	30102	246567	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	11	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6005696.09569	2109523.68249	37.7726720930872	-122.423706217176	(37.7726720930872, -122.423706217176)
32751	32751	246565	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	9	Median : Yard 3	Tree 1	DPW 2			11	Width 7ft		6005706.10974	2109468.40026	37.772520866678796	-122.423667646169	(37.7725208666788, -122.423667646169)
36823	36823	246562	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	6	Median : Yard 3	Tree 1	DPW 2			16	Width 7ft		6005708.50416	2109443.88838	37.7724536981194	-122.423657620518	(37.7724536981194, -122.423657620518)
58148	58148	246560	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	4	Median : Yard 3	Tree 1	DPW 2			5	Width 7ft		6005720.56075	2109380.70244	37.772280885298	-122.423611422347	(37.772280885298, -122.423611422347)
62755	62755	246558	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	2	Median : Yard 3	Tree 1	DPW 2			7	Width 7ft		6005725.55596	2109365.49138	37.772239401347605	-122.423593061791	(37.7722394013476, -122.423593061791)
66652	66652	246571	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	15	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6005693.03742	2109551.27371	37.7727476792916	-122.423718758221	(37.7727476792916, -122.423718758221)
69195	69195	246561	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	5	Median : Yard 3	Tree 1	DPW 2			8	Width 7ft		6005718.25772	2109387.68034	37.7722999149342	-122.42361988494801	(37.7722999149342, -122.423619884948)
130105	130105	246569	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	13	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6005694.6084199995	2109539.50826	37.772715462883	-122.42371248725401	(37.772715462883, -122.423712487254)
152965	152965	246568	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	12	Median : Yard 3	Tree 1	DPW 2			7	Width 7ft		6005695.27816	2109533.51475	37.7726990439551	-122.423709744321	(37.7726990439551, -122.423709744321)
159619	159619	246563	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	7	Median : Yard 3	Tree 1	DPW 2			14	Width 7ft		6005707.64026	2109451.4652299997	37.7724744535597	-122.42366114764499	(37.7724744535597, -122.423661147645)
164121	164121	246566	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	10	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6005705.41603	2109475.54193	37.772540436826	-122.42367055365101	(37.772540436826, -122.423670553651)
171792	171792	246570	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	14	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6005693.82305	2109545.39115	37.7727315715478	-122.423715622299	(37.7727315715478, -122.423715622299)
178229	178229	246557	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	1	Median : Yard 3	Tree 1	DPW 2			11	Width 7ft		6005728.07536	2109359.1735900003	37.7722221964256	-122.4235838977	(37.7722221964256, -122.4235838977)
23421	23421	195972	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	18	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015355.8319	2100319.8042599997	37.7479407691514	-122.389648918288	(37.7479407691514, -122.389648918288)
42525	42525	195977	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	23	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015256.877230001	2100313.90806	37.7479190918917	-122.389990690329	(37.7479190918917, -122.389990690329)
49446	49446	195978	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	24	Back Yard : Yard 13	Tree 1	Private 1			9	Width 4ft		6015236.23042	2100312.22008	37.747913311958605	-122.390061968785	(37.7479133119586, -122.390061968785)
61234	61234	195975	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	21	Back Yard : Yard 13	Tree 1	Private 1			9	Width 4ft		6015294.9834	2100316.47199	37.747928245201	-122.389859098828	(37.747928245201, -122.389859098828)
147625	147625	195976	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	22	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015275.57642	2100315.1093900003	37.7479234275315	-122.38992611271401	(37.7479234275315, -122.389926112714)
171288	171288	195971	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	17	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015377.86647	2100320.4119700002	37.7479436595871	-122.389572765484	(37.7479436595871, -122.389572765484)
171805	171805	195974	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	20	Back Yard : Yard 13	Tree 1	Private 1			12	Width 4ft		6015315.44713	2100317.81293	37.7479330619596	-122.389788429193	(37.7479330619596, -122.389788429193)
173877	173877	195973	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	19	Back Yard : Yard 13	Tree 1	Private 1			10	Width 4ft		6015335.01264	2100318.2949099997	37.747935470342895	-122.38972080559601	(37.7479354703429, -122.389720805596)
3856	3856	246917	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	845 Shrader St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 3ft		5997637.485090001	2107521.28402	37.766715824697	-122.451437229753	(37.766715824697, -122.451437229753)
4763	4763	220524	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	110 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/1974 12:00:00 AM	38	Width 3ft	Permit Number 14125	6003373.13767	2108706.4584	37.770296793780396	-122.431683217203	(37.7702967937804, -122.431683217203)
23464	23464	121867	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	382 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5990303.78145	2112825.7530799997	37.7808577673116	-122.477190674715	(37.7808577673116, -122.477190674715)
29497	29497	135665	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		5996326.409519999	2114621.95963	37.7861372526689	-122.45648551290199	(37.7861372526689, -122.456485512902)
39702	39702	195996	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	5	Side Yard : Yard 17	Tree 1	Private 1			14	Width 3ft		6012499.275719999	2097703.95349	37.7405993901482	-122.39934322143101	(37.7405993901482, -122.399343221431)
44122	44122	212849	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1201 Ulloa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5992374.69215	2098410.70315	37.7413977704887	-122.468977090726	(37.7413977704887, -122.468977090726)
49096	49096	212850	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	32 Malta Dr	32	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 3ft		5999489.821880001	2096117.1264	37.7355086796695	-122.444210754429	(37.7355086796695, -122.444210754429)
134366	134366	135663	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5996346.46825	2114626.15487	37.78614992323771	-122.456416418905	(37.7861499232377, -122.456416418905)
154008	154008	195993	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	2	Side Yard : Yard 17	Tree 1	Private 1			23	Width 3ft		6012429.27896	2097757.0265	37.7407412159349	-122.399588970171	(37.7407412159349, -122.399588970171)
156951	156951	195995	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	4	Side Yard : Yard 17	Tree 1	Private 1			23	Width 3ft		6012483.54441	2097715.89022	37.7406312890986	-122.399398452383	(37.7406312890986, -122.399398452383)
161540	161540	135664	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5996336.60886	2114624.27331	37.786144190959504	-122.45645039347099	(37.7861441909595, -122.456450393471)
180467	180467	246918	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	845 Shrader St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 3ft		5997638.105140001	2107510.95773	37.7666875068428	-122.451434340243	(37.7666875068428, -122.451434340243)
183132	183132	195994	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2101 Newcomb Ave	3	Side Yard : Yard 17	Tree 1	Private 1			20	Width 3ft		6012438.11131	2097750.05558	37.74072256758821	-122.39955794174999	(37.7407225675882, -122.39955794175)
909	909	234895	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	3255x 24th St	6	Side Yard : Cutout 18	Tree 1	Private 1			40	Width 10ft		6007298.0	2102020.0	37.7521590216883	-122.417633107694	(37.7521590216883, -122.417633107694)
24182	24182	196031	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 10ft		6017021.60504	2097043.8381400001	37.7390378586108	-122.383660646635	(37.7390378586108, -122.383660646635)
35215	35215	196035	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 10ft		6017042.43736	2096973.9330400003	37.7388470647366	-122.38358375190501	(37.7388470647366, -122.383583751905)
38488	38488	196041	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 10ft		6017065.52556	2097005.9762799998	37.738936325136706	-122.383506153	(37.7389363251367, -122.383506153)
47717	47717	234909	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 10ft		6009677.77783	2096362.7223200002	37.73675900081071	-122.409004306302	(37.7367590008107, -122.409004306302)
48598	48598	196029	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 10ft		6017027.27121	2097051.6476	37.7390596150087	-122.383641598974	(37.7390596150087, -122.383641598974)
53814	53814	196045	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 10ft		6017076.588380001	2097018.35028	37.7389709130863	-122.383468763681	(37.7389709130863, -122.383468763681)
55642	55642	196036	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 10ft		6017046.41048	2096978.7292799999	37.738860453849	-122.383570348389	(37.738860453849, -122.383570348389)
61094	61094	196049	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			35	Width 10ft		6017090.910619999	2097040.61449	37.7390328376916	-122.38342079293501	(37.7390328376916, -122.383420792935)
62070	62070	196033	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6017016.3348	2097035.41086	37.7390144276853	-122.38367828232501	(37.7390144276853, -122.383678282325)
65477	65477	196046	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 10ft		6017076.84536	2097020.9862799998	37.7389781652152	-122.383468058608	(37.7389781652152, -122.383468058608)
65821	65821	196027	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 10ft		6017034.20589	2097061.6668900002	37.739087509266604	-122.383618319135	(37.7390875092666, -122.383618319135)
69044	69044	196048	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 10ft		6017086.8639400005	2097032.1625700002	37.7390094067689	-122.383434196434	(37.7390094067689, -122.383434196434)
73353	73353	196047	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 10ft		6017083.0987599995	2097027.5652	37.7389965752218	-122.383446894874	(37.7389965752218, -122.383446894874)
74651	74651	196034	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 10ft		6017038.2356199995	2096967.92235	37.738830328350794	-122.38359786136002	(37.7388303283508, -122.38359786136)
102782	102782	196025	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 10ft		6017042.181609999	2097072.1185299999	37.7391166482065	-122.38359146989201	(37.7391166482065, -122.383591469892)
146435	146435	196026	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 10ft		6017039.21913	2097067.45785	37.7391036871735	-122.383601388517	(37.7391036871735, -122.383601388517)
147185	147185	196028	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 10ft		6017030.6363699995	2097056.65947	37.7390735625998	-122.383630312507	(37.7390735625998, -122.383630312507)
148840	148840	196044	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 10ft		6017074.4672	2097014.32935	37.7389597551859	-122.38347581797701	(37.7389597551859, -122.383475817977)
149400	149400	196040	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 10ft		6017061.14337	2096999.0636099998	37.738917102131204	-122.383520823632	(37.7389171021312, -122.383520823632)
150116	150116	196042	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 10ft		6017068.02223	2097008.3641400002	37.7389430197102	-122.383497686772	(37.7389430197102, -122.383497686772)
152860	152860	196043	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 10ft		6017069.89025	2097009.95172	37.7389474821301	-122.38349133844801	(37.7389474821301, -122.383491338448)
155952	155952	196030	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 10ft		6017023.70578	2097046.84349	37.739046226814	-122.38365359234601	(37.739046226814, -122.383653592346)
162017	162017	196037	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 10ft		6017049.14343	2096982.7375599998	37.7388716108342	-122.383561177999	(37.7388716108342, -122.383561177999)
166201	166201	196038	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 10ft		6017052.09274	2096987.35134	37.7388844423585	-122.38355130167	(37.7388844423585, -122.38355130167)
168448	168448	196039	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1 Lane St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 10ft		6017058.78761	2096996.2330599998	37.7389091998064	-122.38352877183998	(37.7389091998064, -122.38352877184)
172242	172242	234908	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 10ft		6009679.550530001	2096368.23252	37.73677422993671	-122.408998565949	(37.7367742299367, -122.408998565949)
187036	187036	196032	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	2 Lane St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 10ft		6017018.892530001	2097040.8451099999	37.7390294904202	-122.383669817022	(37.7390294904202, -122.383669817022)
188309	188309	234896	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 10ft		6007240.7393	2101963.9408299997	37.7520018736867	-122.41782715109501	(37.7520018736867, -122.417827151095)
495	495	248613	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	845 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			28	Width 0ft		5997648.1233	2107524.615	37.766725579885	-122.451400674442	(37.766725579885, -122.451400674442)
3855	3855	248614	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	845 Shrader St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5997650.5459	2107506.4452	37.7666758289672	-122.451390984496	(37.7666758289672, -122.451390984496)
26304	26304	140079	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	100 Saint Joseph's Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6000729.2298	2112451.4153	37.780429279749605	-122.44109718195499	(37.7804292797496, -122.441097181955)
33120	33120	249800	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	199 Chestnut St	8	Front Yard : Yard 7	Tree 1	Private 1			16	Width 0ft		6010811.58408	2121055.18857	37.8046222939481	-122.406823966551	(37.8046222939481, -122.406823966551)
33977	33977	249894	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	30	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011403.76038	2120447.63681	37.802987222140395	-122.40473187458599	(37.8029872221404, -122.404731874586)
37654	37654	244429	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005659.2973	2109696.7034	37.773145089481794	-122.4238458121	(37.7731450894818, -122.4238458121)
46046	46046	244430	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005657.927	2109705.6102	37.7731694680478	-122.42385118560499	(37.7731694680478, -122.423851185605)
46340	46340	244263	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005610.4338	2110073.0988	37.7741758216851	-122.424041609468	(37.7741758216851, -122.424041609468)
46771	46771	140080	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	102 Saint Joseph's Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6000726.8608	2112462.5832	37.7804598090154	-122.441106178881	(37.7804598090154, -122.441106178881)
47891	47891	244336	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6005628.4661	2109884.4314	37.7736588046762	-122.423965813403	(37.7736588046762, -122.423965813403)
53575	53575	244407	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005584.4651	2110232.73	37.774612664125	-122.424142794808	(37.774612664125, -122.424142794808)
59788	59788	244335	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6005630.5215	2109874.8395	37.7736325836766	-122.42395802123	(37.7736325836766, -122.42395802123)
61728	61728	249895	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	31	Back Yard : Yard 13	Tree 1	Private 1			18	Width 0ft		6011395.76102	2120447.38073	37.8029860719045	-122.404759538639	(37.8029860719045, -122.404759538639)
64205	64205	244403	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005596.6857	2110150.2412	37.7743868598384	-122.424094653801	(37.7743868598384, -122.424094653801)
65833	65833	249798	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	199 Chestnut St	6	Front Yard : Yard 7	Tree 1	Private 1			14	Width 0ft		6010832.73906	2121063.1197	37.8046452545423	-122.406751316639	(37.8046452545423, -122.406751316639)
65982	65982	244266	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005600.5046	2110125.0362	37.7743178686238	-122.42407965066499	(37.7743178686238, -122.424079650665)
66890	66890	244431	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005656.5567	2109717.2576	37.77320137163979	-122.42385675402599	(37.7732013716398, -122.423856754026)
73006	73006	244339	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	16	Median : Cutout 11	Tree 1	DPW 2			14	Width 0ft		6005625.7255	2109918.6883	37.7737527111209	-122.42397773010799	(37.7737527111209, -122.423977730108)
74522	74522	249896	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	32	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011386.30387	2120437.51769	37.8029584618196	-122.404791570676	(37.8029584618196, -122.404791570676)
76412	76412	244404	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005594.3943	2110164.7531	37.7744265766299	-122.424103612435	(37.7744265766299, -122.424103612435)
90928	90928	244261	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005613.489	2110034.9096	37.7740711358709	-122.424028324662	(37.7740711358709, -122.424028324662)
116487	116487	244265	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005602.0322	2110112.8157	37.7742844003359	-122.42407349716999	(37.7742844003359, -122.42407349717)
127197	127197	249899	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1497 Montgomery St	3	Side Yard : Yard 17	Tree 1	Private 1			17	Width 0ft		6011381.09793	2120471.14228	37.8030504957345	-122.404811954701	(37.8030504957345, -122.404811954701)
129623	129623	244406	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		6005586.7565	2110217.4543	37.7745708501281	-122.42413378179899	(37.7745708501281, -122.424133781799)
136078	136078	244264	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005607.3787	2110087.6108	37.7742154956389	-122.42405320983299	(37.7742154956389, -122.424053209833)
136569	136569	244337	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		6005627.7809	2109896.0788	37.7736907469384	-122.423969012041	(37.7736907469384, -122.423969012041)
147500	147500	244428	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	102x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005659.9824	2109685.0561	37.7731131474821	-122.423842613892	(37.7731131474821, -122.423842613892)
147941	147941	244402	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005599.7408	2110138.7844	37.774355574729796	-122.424083270702	(37.7743555747298, -122.424083270702)

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