Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by qSiteInfo 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, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▲	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
38723	38723	191689	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1 01st St	27	: Yard 23	Tree 1	Private 1			3			6014402.09171	2105890.67407	37.7631842517621	-122.393336722306	(37.7631842517621, -122.393336722306)
25968	25968	249846	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	289 Greenwich St	3	Side Yard : Yard 17	Tree 1	Private 1			14	Width 0ft		6011427.16735	2120382.55668	37.8028098362532	-122.40464628970601	(37.8028098362532, -122.404646289706)
26546	26546	191706	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1499 Rankin St	7	Side Yard : Yard 17	Tree 1	Private 1			1	Width 3ft		6012685.03055	2096691.5436200001	37.7378298766422	-122.39862992054701	(37.7378298766422, -122.398629920547)
37458	37458	246770	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	99 Waltham St	3	Side Yard : Yard 17	Tree 1	Private 1			9			6009309.01668	2098932.20278	37.7437935707282	-122.410460661231	(37.7437935707282, -122.410460661231)
64078	64078	247873	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	388 Mayflower St	1	Side Yard : Yard 17	Tree 1	Private 1			9			6009888.01932	2098399.59712	37.7423635938187	-122.40842103750299	(37.7423635938187, -122.408421037503)
67005	67005	191705	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1700 Armstrong Ave	3	Side Yard : Yard 17	Tree 1	Private 1			6			6013900.77828	2092879.68746	37.727430958252604	-122.394159667654	(37.7274309582526, -122.394159667654)
77276	77276	176283	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	35 Tomaso Ct	9	Side Yard : Yard 17	Tree 1	Private 1			8	Width 3ft		6009206.42472	2086339.2337599997	37.7092101890802	-122.40992661863999	(37.7092101890802, -122.40992661864)
115840	115840	176282	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	35 Tomaso Ct	8	Side Yard : Yard 17	Tree 1	Private 1			3	Width 3ft		6009202.48899	2086331.0577900002	37.709187518951296	-122.40993964441401	(37.7091875189513, -122.409939644414)
182532	182532	247879	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	388 Mayflower St	8	Side Yard : Yard 17	Tree 1	Private 1			3			6009924.148030001	2098382.32436	37.7423181897436	-122.408294896795	(37.7423181897436, -122.408294896795)
34978	34978	249883	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	230 Greenwich St	19	Back Yard : Yard 13	Tree 1	Private 1			14	Width 0ft		6011507.08304	2120427.1107900003	37.802936637067496	-122.40437287690901	(37.8029366370675, -122.404372876909)
45069	45069	126561	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	8 Codman Pl	2	Back Yard : Yard 13	Tree 1	Private 1			7			6009832.93804	2117260.0663900003	37.7941470150322	-122.40994260678998	(37.7941470150322, -122.40994260679)
133186	133186	249880	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	230 Greenwich St	16	Back Yard : Yard 13	Tree 1	Private 1			11	Width 0ft		6011523.78476	2120446.01272	37.8029894704488	-122.404316411196	(37.8029894704488, -122.404316411196)
158045	158045	249890	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	230 Greenwich St	26	Back Yard : Yard 13	Tree 1	Private 1			11	Width 0ft		6011458.55673	2120431.8571900004	37.8029469576839	-122.40454113827101	(37.8029469576839, -122.404541138271)
184764	184764	126562	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	8 Codman Pl	1	Back Yard : Yard 13	Tree 1	Private 1			9			6009829.32931	2117256.5326099996	37.7941371098806	-122.40995484385901	(37.7941371098806, -122.409954843859)
14534	14534	18564	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1700X Quesada Ave	19	Median : Cutout 11	Tree 1	DPW 2			30	19		6014511.59225	2095170.6430400002	37.7337553901961	-122.392208220649	(37.7337553901961, -122.392208220649)
79512	79512	804	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	680X 39th Ave	2	Median : Cutout 11	Tree 1	DPW 2			3	6-HOA		5983823.94935	2111143.69789	37.7758612538886	-122.499482885033	(37.7758612538886, -122.499482885033)
155016	155016	176272	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	179 Niagara Ave	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 0ft		5999311.03211	2089604.94508	37.717617539904296	-122.444361048235	(37.7176175399043, -122.444361048235)
155390	155390	176273	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	179 Niagara Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 0ft		5999314.98259	2089602.87456	37.717612080124205	-122.444347244552	(37.7176120801242, -122.444347244552)
174539	174539	207721	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	228 Montana St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5			5994631.9391	2089350.3088	37.7166502911674	-122.460515994629	(37.7166502911674, -122.460515994629)
23535	23535	207712	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	579 Hearst Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			5997579.44084	2094367.86788	37.730596459453395	-122.450689553205	(37.7305964594534, -122.450689553205)
25243	25243	126568	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2745 Larkin St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6006520.94056	2120654.06544	37.8032799020007	-122.421643667929	(37.8032799020007, -122.421643667929)
27037	27037	207730	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	740 Foerster St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		5998158.00142	2095945.9651099998	37.7349626400957	-122.44880301654	(37.7349626400957, -122.44880301654)
29285	29285	207725	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	380 Ralston St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 6ft		5992234.508719999	2090438.5826599998	37.7195002121526	-122.468881791362	(37.7195002121526, -122.468881791362)
34006	34006	207717	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1180 Plymouth Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		5995974.63238	2091762.70234	37.723351307004705	-122.456049310222	(37.7233513070047, -122.456049310222)
34794	34794	224120	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1350 Noe St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6003219.3903	2100351.64414	37.7473477571063	-122.431618456154	(37.7473477571063, -122.431618456154)
35240	35240	207714	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	298 Staples Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			5998133.74364	2093826.5868	37.7291419427263	-122.448734282271	(37.7291419427263, -122.448734282271)
35482	35482	207723	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	301 Byxbee St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 10ft		5991929.884269999	2090544.1507700002	37.719772472009204	-122.469942439216	(37.7197724720092, -122.469942439216)
36817	36817	176286	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	901 Delano Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 6ft		5998666.60141	2089601.1299700001	37.7175702751322	-122.446588269645	(37.7175702751322, -122.446588269645)
48398	48398	224111	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1100 San Jose Ave	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6004733.53405	2096634.51546	37.7372270772601	-122.42611806850799	(37.7372270772601, -122.426118068508)
48766	48766	191702	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1998 Revere Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			6013024.54675	2095962.65305	37.7358474048249	-122.397404937794	(37.7358474048249, -122.397404937794)
51044	51044	176285	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1 Santa Barbara Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5993431.64495	2086606.10767	37.7090462435678	-122.464465643484	(37.7090462435678, -122.464465643484)
56447	56447	191691	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2301 19th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			6010894.94565	2105057.58809	37.7607013108401	-122.405408158461	(37.7607013108401, -122.405408158461)
56636	56636	207715	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	117 Judson Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			5999294.96193	2093458.5663400001	37.7281977787	-122.444693427785	(37.7281977787, -122.444693427785)
58281	58281	176277	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	190 Foote Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5998652.47444	2088356.09646	37.7141508908239	-122.44654757532301	(37.7141508908239, -122.446547575323)
68300	68300	224116	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	400 Prospect Ave	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			6006205.79839	2097605.42741	37.7399760871276	-122.421096686769	(37.7399760871276, -122.421096686769)
69216	69216	207727	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	378 Victoria St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 6ft		5993265.77465	2089711.0849799998	37.717562206406	-122.46526429632601	(37.717562206406, -122.465264296326)
71579	71579	248210	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	69 Fair Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		6007064.668	2099422.3589	37.7450133544796	-122.418255851634	(37.7450133544796, -122.418255851634)
72600	72600	187568	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	138 Alpha St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 10ft		6010896.54149	2088103.23155	37.714148350239704	-122.40420934958401	(37.7141483502397, -122.404209349584)
73834	73834	207713	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	171 Flood Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			5999625.5730099995	2094046.65577	37.7298313962868	-122.443592725033	(37.7298313962868, -122.443592725033)
75558	75558	191687	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	800 19th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 10ft		6015123.17396	2105339.16037	37.7617099499859	-122.390804173874	(37.7617099499859, -122.390804173874)
84522	84522	113121	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1x TOMASO CT	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
122151	122151	207726	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	416 Ralston St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 10ft		5992237.92359	2090619.0138400001	37.719995829436	-122.468883110676	(37.719995829436, -122.468883110676)
135662	135662	191707	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2187 Revere Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6011937.92175	2096699.9343299998	37.7378112633764	-122.401213644004	(37.7378112633764, -122.401213644004)
141988	141988	113120	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1x TOMASO CT	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
148462	148462	176280	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	600 Blanken Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6013180.81524	2086857.6738099998	37.7108556687339	-122.39622672069599	(37.7108556687339, -122.396226720696)
153779	153779	207734	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	301 Joost Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 10ft		6000042.84201	2094939.4846400002	37.7323066857905	-122.442214249597	(37.7323066857905, -122.442214249597)
157462	157462	207708	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	916 Ortega St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 1ft		5991151.901959999	2102512.9309	37.7525906994144	-122.473504184373	(37.7525906994144, -122.473504184373)
161021	161021	207707	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1254 18th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5990519.642630001	2106849.6628099997	37.7644615768749	-122.476007325895	(37.7644615768749, -122.476007325895)
161098	161098	207716	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	115 Judson Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		5999335.92351	2093459.52729	37.72820275463761	-122.44455189156601	(37.7282027546376, -122.444551891566)
162191	162191	123640	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	345 Arguello Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 6ft		5995501.56716	2113883.85045	37.784063214039605	-122.459285759007	(37.7840632140396, -122.459285759007)
163114	163114	126569	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2745 Larkin St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6006516.40415	2120646.68987	37.8032593947653	-122.42165884218599	(37.8032593947653, -122.421658842186)
165369	165369	224112	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1100 San Jose Ave	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			6004737.84332	2096628.1853599998	37.7372099397936	-122.42610271887101	(37.7372099397936, -122.426102718871)
165907	165907	126567	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2843 Larkin St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 5ft		6006455.5801099995	2121070.56705	37.8044198232789	-122.42189945398998	(37.8044198232789, -122.42189945399)
167274	167274	126570	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	94 MacOndray Ln	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			6008053.53116	2119101.30283	37.7991027057905	-122.41623003160299	(37.7991027057905, -122.416230031603)
167474	167474	207709	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	916 Ortega St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 1ft		5991129.27817	2102510.74063	37.752583375332605	-122.47358226082	(37.7525833753326, -122.47358226082)
169472	169472	207719	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	126 Brighton Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 1ft		5996251.42646	2090752.11635	37.7205923605284	-122.455019501973	(37.7205923605284, -122.455019501973)
170332	170332	191688	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	800 19th St	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6014977.94549	2105331.22601	37.761680105066105	-122.39130591015	(37.7616801050661, -122.39130591015)
172056	172056	207733	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	500 Joost Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			5998757.70005	2094996.74516	37.732390582643205	-122.446661380942	(37.7323905826432, -122.446661380942)
172414	172414	249620	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2400 Golden Gate Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 7ft		5997953.57215	2111367.44178	37.7772944806811	-122.45062126495199	(37.7772944806811, -122.450621264952)
175044	175044	207732	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	400 Congo St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 10ft		6000124.6238	2095012.3046900001	37.7325112932663	-122.441936736802	(37.7325112932663, -122.441936736802)
177554	177554	191692	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	764 De Haro St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6012093.5937	2104845.22166	37.7601851458373	-122.401247624904	(37.7601851458373, -122.401247624904)
177778	177778	176281	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	600 Blanken Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 5ft		6013188.37125	2086854.32403	37.710846891333105	-122.39620037057101	(37.7108468913331, -122.396200370571)
179929	179929	207728	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	3802 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		5990564.76109	2090542.95021	37.7196901687566	-122.47466105158199	(37.7196901687566, -122.474661051582)
180825	180825	224130	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	840 Castro St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6002416.06064	2103301.09689	37.7554006877977	-122.434607174889	(37.7554006877977, -122.434607174889)
25572	25572	191703	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1501 Quint St	2	Front Yard : Yard 7	Tree 1	Private 1			7	Width 4ft		6013259.66608	2096346.4213299998	37.7369142408999	-122.396618925818	(37.7369142408999, -122.396618925818)
34441	34441	191696	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1700 22nd St	3	Front Yard : Yard 7	Tree 1	Private 1			7			6012930.9536	2103804.38992	37.7573739307682	-122.398278546439	(37.7573739307682, -122.398278546439)
35128	35128	249903	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	300 Greenwich St	4	Front Yard : Yard 7	Tree 1	Private 1			17	Width 0ft		6011307.54061	2120412.72536	37.8028859854681	-122.40506238711399	(37.8028859854681, -122.405062387114)
36917	36917	191685	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1301 Minnesota St	13	Front Yard : Yard 7	Tree 1	Private 1			4			6015385.022890001	2102351.0583099998	37.7535197845136	-122.38968982661801	(37.7535197845136, -122.389689826618)
41768	41768	191697	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1700 22nd St	7	Front Yard : Yard 7	Tree 1	Private 1			13			6012906.9277800005	2103803.94978	37.7573713838993	-122.398361606903	(37.7573713838993, -122.398361606903)
42410	42410	126571	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1013 Vallejo St	2	Front Yard : Yard 7	Tree 1	Private 1			13			6008640.83285	2118637.5271099997	37.7978622987641	-122.414164932777	(37.7978622987641, -122.414164932777)
47316	47316	126572	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1001 Vallejo St	5	Front Yard : Yard 7	Tree 1	Private 1			6			6008680.36365	2118649.32289	37.7978969073709	-122.414028979559	(37.7978969073709, -122.414028979559)
55102	55102	191686	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1301 Minnesota St	14	Front Yard : Yard 7	Tree 1	Private 1			6			6015385.377169999	2102357.3727700002	37.7535371423304	-122.38968904242701	(37.7535371423304, -122.389689042427)
59361	59361	176270	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	195 Rome St	1	Front Yard : Yard 7	Tree 1	Private 1			3	Width 0ft		5998756.35201	2088943.21744	37.7157689240671	-122.44623074418001	(37.7157689240671, -122.44623074418)
61536	61536	246754	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1838 Alabama St	1	Front Yard : Yard 7	Tree 1	Private 1			16			6009313.62627	2099009.8875700003	37.7440071345341	-122.410450206611	(37.7440071345341, -122.410450206611)
66405	66405	249910	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	308 Greenwich St	2	Front Yard : Yard 7	Tree 1	Private 1			10	Width 0ft		6011272.31007	2120413.3018099996	37.8028855987512	-122.40518434418699	(37.8028855987512, -122.405184344187)
72590	72590	249863	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	233 Greenwich St	4	Front Yard : Yard 7	Tree 1	Private 1			6	Width 0ft		6011630.0308300005	2120434.01589	37.8029624665125	-122.40394789778799	(37.8029624665125, -122.403947897788)
133017	133017	224114	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1100 San Jose Ave	70	Front Yard : Yard 7	Tree 1	Private 1			6			6004687.50549	2096549.1812200001	37.736990167061	-122.42627113673001	(37.736990167061, -122.42627113673)
133784	133784	224113	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1100 San Jose Ave	69	Front Yard : Yard 7	Tree 1	Private 1			4			6004690.02185	2096554.43933	37.7370047468799	-122.426262810788	(37.7370047468799, -122.426262810788)
135288	135288	246764	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	70 Waltham St	8	Front Yard : Yard 7	Tree 1	Private 1			8			6009279.96949	2098891.64841	37.7436805888792	-122.410558236772	(37.7436805888792, -122.410558236772)
143567	143567	111509	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	800x BOSWORTH ST	4	Front Yard : Yard 7	Tree 1	DPW 2			4			6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
158587	158587	249981	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	224 Filbert St	2	Front Yard : Yard 7	Tree 1	Private 1			9	Width 0ft		6011659.45074	2120118.51197	37.8020978133144	-122.403823874987	(37.8020978133144, -122.403823874987)
159049	159049	224115	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1100 San Jose Ave	71	Front Yard : Yard 7	Tree 1	Private 1			8			6004680.7613	2096547.43611	37.7369849941684	-122.426294330213	(37.7369849941684, -122.426294330213)
160633	160633	176276	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	62 Tomaso Ct	7	Front Yard : Yard 7	Tree 1	Private 1			12	Width 8ft		6009192.32266	2086308.3659400002	37.7091246419674	-122.40997318013201	(37.7091246419674, -122.409973180132)
162057	162057	247967	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	16 Joy St	3	Front Yard : Yard 7	Tree 1	Private 1			4			6010333.495709999	2098927.4961099997	37.743838026898295	-122.40691790615	(37.7438380268983, -122.40691790615)
180486	180486	176271	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	195 Rome St	2	Front Yard : Yard 7	Tree 1	Private 1			3	Width 0ft		5998766.3474	2088951.7637599998	37.715792961145205	-122.446196810045	(37.7157929611452, -122.446196810045)
182683	182683	191698	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	602 Arthur Ave	35	Front Yard : Yard 7	Tree 1	Private 1			2			6015659.044530001	2099869.60737	37.7467214305684	-122.38856899259	(37.7467214305684, -122.38856899259)
184746	184746	191699	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	50 Quint St	4	Front Yard : Yard 7	Tree 1	Private 1			4	Width 6ft		6015737.97927	2099766.7157099997	37.7464432855229	-122.388288861864	(37.7464432855229, -122.388288861864)
186894	186894	246755	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1838 Alabama St	2	Front Yard : Yard 7	Tree 1	Private 1			16			6009311.20113	2098998.06122	37.7439745260177	-122.410457757318	(37.7439745260177, -122.410457757318)
187509	187509	191704	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1501 Quint St	3	Front Yard : Yard 7	Tree 1	Private 1			6	Width 4ft		6013263.69136	2096352.02038	37.736929838751294	-122.396605400918	(37.7369298387513, -122.396605400918)
78574	78574	109626	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	117 JUDSON AVE		Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x12		5999286.5	2093444.4	37.728158398345705	-122.44472166307101	(37.7281583983457, -122.444721663071)
141580	141580	109627	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	500 CIRCULAR AVE	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5999334.0	2093430.0	37.728121569817	-122.444556419888	(37.728121569817, -122.444556419888)
55093	55093	202013	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	7 Wheat St	2	: 4	Tree 1	Private 1			3	Width 3ft		6012149.42791	2091374.5561400002	37.723200675946394	-122.40010846893601	(37.7232006759464, -122.400108468936)
55948	55948	207724	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	132 Ralston St	1	: 4	Tree 1	Private 1			3	Width 3ft		5992208.616230001	2088772.7459099998	37.71492473315389	-122.46885013341999	(37.7149247331539, -122.46885013342)
129729	129729	207722	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	300 Louisburg St	1	: 4	Tree 1	Private 1			8	Width 3ft		5997412.90563	2090249.0512400002	37.7192776245304	-122.45096839786801	(37.7192776245304, -122.450968397868)
173225	173225	191701	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2025 Revere Ave	1	: 4	Tree 1	Private 1			1	Width 2ft		6012750.04967	2096000.3617900002	37.7359356579989	-122.398356633674	(37.7359356579989, -122.398356633674)
50134	50134	191700	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1700x Quesada Ave	39	Median : Yard 3	Tree 1	DPW 2			3			6014384.30677	2095263.8272900002	37.7340041867507	-122.39265480417801	(37.7340041867507, -122.392654804178)
64747	64747	191695	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	950x Kansas St	4	Median : Yard 3	Tree 1	DPW 2			4			6011603.94241	2103847.92507	37.7574194607598	-122.40287096412901	(37.7574194607598, -122.402870964129)
65580	65580	191710	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1427x Innes Ave	28	Median : Yard 3	Tree 1	DPW 2			3			6016141.2133599995	2096757.17707	37.7382020430791	-122.386684681762	(37.7382020430791, -122.386684681762)
67780	67780	191690	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	900x Carolina St	22	Median : Yard 3	Tree 1	DPW 2			2			6012468.62754	2103498.74867	37.756508943061206	-122.39985600137399	(37.7565089430612, -122.399856001374)
172289	172289	207711	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	200x Terrace Dr	31	Median : Yard 3	Tree 1	DPW 2			12			5993844.07189	2096487.62875	37.7362022754996	-122.463756979508	(37.7362022754996, -122.463756979508)

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