Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by Longitude

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
6018	6018	19926	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY37	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	20ST
7267	7267	19835	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY25	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60X
8172	8172	19836	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY25	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60X
11287	11287	20003	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY46	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	2
15209	15209	19838	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY25	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60X
16686	16686	19817	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY25	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
17045	17045	19792	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	100 STAIRWAY19	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	20ST
26210	26210	118831	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	662 46th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5981671.941000001	2111218.67307	37.775940615740105	-122.50693266579799	(37.7759406157401, -122.506932665798)
177760	177760	184363	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2251 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5981706.71	2099767.9271	37.7445021893581	-122.50596322728998	(37.7445021893581, -122.50596322729)
168183	168183	118733	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	706 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5982303.905590001	2110925.66237	37.7751732905824	-122.504724857451	(37.7751732905824, -122.504724857451)
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)
186390	186390	62603	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	792 37th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/22/1986 12:00:00 AM	6		Permit Number 22911	5984491.42084	2110500.08946	37.7741332293959	-122.497126446837	(37.7741332293959, -122.497126446837)
73148	73148	183678	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	3623 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5984470.6439	2106306.3709	37.7626172515097	-122.49688873282601	(37.7626172515097, -122.496888732826)
160122	160122	181986	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2475 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5985788.161	2098383.3055	37.7409397902725	-122.491748687988	(37.7409397902725, -122.491748687988)
41649	41649	73939	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1450 Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/22/1995 12:00:00 AM	2			5988330.9539	2099688.5183	37.744671848150894	-122.483052396761	(37.7446718481509, -122.483052396761)
63802	63802	183573	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2587 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5988295.3826	2097727.4025	37.7392850696685	-122.483031684036	(37.7392850696685, -122.483031684036)
172227	172227	120404	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	527 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5988748.3356	2111702.11927	37.777682216959704	-122.482489301184	(37.7776822169597, -122.482489301184)
24799	24799	120350	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2122 Lake St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5988813.63616	2114710.28976	37.7859456052821	-122.482483881641	(37.7859456052821, -122.482483881641)
75891	75891	61497	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	137 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/20/1984 12:00:00 AM	9		Permit Number 21447	5989576.46395	2114470.4752700003	37.7853314889271	-122.479827181582	(37.7853314889271, -122.479827181582)
74925	74925	61499	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	154 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/27/1984 12:00:00 AM	7		Permit Number 21452	5989629.6033	2114330.31946	37.7849497475064	-122.47963307901001	(37.7849497475064, -122.47963307901)
70263	70263	48553	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	378 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/2002 12:00:00 AM	3		Permit Number 45869	5990302.44703	2112853.20794	37.780933073312504	-122.477197298017	(37.7809330733125, -122.477197298017)
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)
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)
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)
80361	80361	115303	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	916 Ortega St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/25/2016 12:00:00 AM		4x4	Permit Number 775645	5991143.3	2102523.7	37.7526197703983	-122.473534716603	(37.7526197703983, -122.473534716603)
100949	100949	121598	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	916 Ortega St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				4x4		5991143.3	2102523.7	37.7526197703983	-122.473534716603	(37.7526197703983, -122.473534716603)
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)
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)
158994	158994	207710	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	641 Moraga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992286.81518	2103851.81856	37.7563325940936	-122.46967695664	(37.7563325940936, -122.46967695664)
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)
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)
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)
57318	57318	218344	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	385 Castenada Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5993369.339269999	2100022.3312	37.745880311731	-122.46565503467501	(37.745880311731, -122.465655034675)
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)
151623	151623	207729	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	10 Mendosa Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993528.0302800005	2101159.3791400003	37.749011508281995	-122.46518888187799	(37.749011508282, -122.465188881878)
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)
41072	41072	32329	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	1884 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/02/1996 12:00:00 AM	5		Permit Number 36893	5993786.54543	2102682.50055	37.7532085147622	-122.46440551389601	(37.7532085147622, -122.464405513896)
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)
172703	172703	176284	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	251 De Long St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 10ft		5993742.60383	2086796.45358	37.7095868089467	-122.46340473574101	(37.7095868089467, -122.463404735741)
168654	168654	207720	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	750 Grafton Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5994515.7556300005	2090598.91337	37.7200719768186	-122.46100802721901	(37.7200719768186, -122.461008027219)
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)
154658	154658	207718	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	315 Faxon Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5994723.84306	2090686.3460799998	37.7203240181088	-122.46029507616998	(37.7203240181088, -122.46029507617)
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)
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)
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)
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)
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)
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)
94834	94834	99679	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	165 Grattan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		10	3x3		5997880.8	2106478.8	37.7638673579207	-122.45052048585899	(37.7638673579207, -122.450520485859)
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)
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)
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)
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)
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)
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)
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)
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)
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)
158863	158863	176275	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	23 Byron Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5999165.787269999	2086612.0753799998	37.7093915094837	-122.444648098339	(37.7093915094837, -122.444648098339)
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)
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)
150484	150484	88782	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	166 Havelock St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/02/2008 12:00:00 AM	9	3x3	Permit Number 51699	5999327.1574099995	2092949.02389	37.7268005308142	-122.444545520761	(37.7268005308142, -122.444545520761)
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)
138223	138223	57922	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	539 Brunswick St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/24/1977 12:00:00 AM	5		Permit Number 16880	5999313.15008	2086900.5185900002	37.7101919177852	-122.444159502961	(37.7101919177852, -122.444159502961)
154979	154979	224128	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	18 Portola Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5999679.40978	2101490.53022	37.750273576386704	-122.443941232111	(37.7502735763867, -122.443941232111)
161284	161284	207731	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	32 Malta Dr	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5999573.254930001	2096045.34694	37.735316349769704	-122.443917140176	(37.7353163497697, -122.443917140176)
172510	172510	224129	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	26 Portola Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999702.07185	2101445.78437	37.7501520078164	-122.44385965101499	(37.7501520078164, -122.443859651015)
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)
33648	33648	224127	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	950 Corbett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999802.0318599995	2102082.0449599996	37.7519047262434	-122.443559684852	(37.7519047262434, -122.443559684852)
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)
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)
65151	65151	176278	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	87 Seneca Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 1ft		6000216.84897	2089896.4695599999	37.7184696403425	-122.441250964156	(37.7184696403425, -122.441250964156)
37671	37671	176274	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	775 London St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6000713.865119999	2089358.3764799999	37.7170204575094	-122.439494437135	(37.7170204575094, -122.439494437135)
153224	153224	176279	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	671 London St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6001065.40936	2089903.8077599998	37.7185380904529	-122.43831837391001	(37.7185380904529, -122.43831837391)
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)
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)
166383	166383	176290	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	324 Naylor St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6002773.326830001	2086530.28935	37.7093721434675	-122.43217402313101	(37.7093721434675, -122.432174023131)
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)
184788	184788	224119	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	410 Valley St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		6003252.6682	2099235.68131	37.744285469291896	-122.43142373132099	(37.7442854692919, -122.431423731321)
46503	46503	176289	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	140 South Hill Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		6003155.69301	2086832.03957	37.710222356236	-122.430874024341	(37.710222356236, -122.430874024341)
157517	157517	224132	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	310 Liberty St	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		6004003.018680001	2103934.91108	37.7572309538551	-122.42916418288401	(37.7572309538551, -122.429164182884)
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)
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)
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)
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)
17577	17577	5550	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	951 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1998 12:00:00 AM	18	6		6005117.32575	2102805.17707	37.7541919854752	-122.425230085106	(37.7541919854752, -122.425230085106)
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)
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)
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)
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)
171139	171139	126563	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1519 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6006819.81222	2117673.20836	37.795112068514705	-122.420397705787	(37.7951120685147, -122.420397705787)
154781	154781	126564	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1519 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6006833.89403	2117675.37487	37.7951188107324	-122.42034913432501	(37.7951188107324, -122.420349134325)
177924	177924	126565	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1519 Pacific Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6006864.87455	2117678.3281900003	37.795128665521	-122.420242146478	(37.795128665521, -122.420242146478)
71206	71206	126566	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1519 Pacific Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6006877.845840001	2117681.84008	37.79513903917879	-122.420197513099	(37.7951390391788, -122.420197513099)
153997	153997	111169	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	1469 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	3x3		6007081.20428	2117722.0309900003	37.795260849674705	-122.41949671281701	(37.7952608496747, -122.419496712817)
49466	49466	224126	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	3213 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006857.14128	2103777.70396	37.7569604557817	-122.41928234412902	(37.7569604557817, -122.419282344129)
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)
181257	181257	176287	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1565 Bacon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6006970.59339	2091697.7707099998	37.723798037137	-122.418033639041	(37.723798037137, -122.418033639041)

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