Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by qAddress

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)
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)
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)
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
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
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
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
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
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)
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)
2713	2713	109887	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1024 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10			6009193.94635	2118049.36414	37.796278400188704	-122.412209406439	(37.7962784001887, -122.412209406439)
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)
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)
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)
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)
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)
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)
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)
135365	135365	224124	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1244 Treat Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6008668.58024	2101297.73586	37.7502528748804	-122.412842355611	(37.7502528748804, -122.412842355611)
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)
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)
54742	54742	72881	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	130 Alpha St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/21/1998 12:00:00 AM	8			6010899.06821	2088108.5640200002	37.714163133309896	-122.40420099129601	(37.7141631333099, -122.404200991296)
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)
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)
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)
39445	39445	224131	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1340 Alabama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		6009255.1331	2101276.97976	37.7502287892492	-122.41081254437799	(37.7502287892492, -122.410812544378)
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)
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)
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)
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)
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)
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)
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)
27406	27406	111563	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1498x Kansas St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x3		6011720.06091	2101415.9054400004	37.750748151322604	-122.40229838558001	(37.7507481513226, -122.40229838558)
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)
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)
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)
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)
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)
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)
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)
37208	37208	224118	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1525 Florida St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009611.07907	2100364.72243	37.7477438841853	-122.409517278718	(37.7477438841853, -122.409517278718)
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)
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)
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)
165090	165090	73562	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1620 La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/21/1988 12:00:00 AM	8			6015449.230359999	2096256.56638	37.7367891335144	-122.389042293172	(37.7367891335144, -122.389042293172)
179174	179174	71359	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1620 La Salle Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/21/1988 12:00:00 AM	7			6015449.34332	2096256.73769	37.7367896101585	-122.389041914574	(37.7367896101585, -122.389041914574)
177598	177598	65002	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	1628 Visitacion Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/31/1989 12:00:00 AM	7		Permit Number 26041	6007789.57951	2087924.3929599999	37.713483198176796	-122.414935588817	(37.7134831981768, -122.414935588817)
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)
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)
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)
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)
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)
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)
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)
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)
62610	62610	224125	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1745 Folsom St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6008033.82801	2108179.5959900003	37.7691132329216	-122.415524547646	(37.7691132329216, -122.415524547646)
133319	133319	54637	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	1747 Quint St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1972 12:00:00 AM	1		Permit Number 10460	6012648.74415	2095666.1739599998	37.7350124040996	-122.39868344459299	(37.7350124040996, -122.398683444593)
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)
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)
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)
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)
73220	73220	246771	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1850 Alabama St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6009333.37029	2098874.50038	37.743636497837	-122.410372378408	(37.743636497837, -122.410372378408)
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)
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)
15545	15545	17442	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	1944 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6013068.40824	2096637.6125599998	37.73770314508	-122.39730060745501	(37.73770314508, -122.397300607455)
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)
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)
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)
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)
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)
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)
32095	32095	224121	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	211 Ogden Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		6008290.10508	2096093.22608	37.7359411906366	-122.413783055452	(37.7359411906366, -122.413783055452)
151773	151773	224122	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	211 Ogden Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6008272.03754	2096094.4851799998	37.73594363319479	-122.41384561137899	(37.7359436331948, -122.413845611379)
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)
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)
50631	50631	191693	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2212 25th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6012143.16846	2101895.7398	37.752089281506706	-122.400868941954	(37.7520892815067, -122.400868941954)
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)
180758	180758	191694	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2250 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6012110.050319999	2101893.7239200003	37.7520818989832	-122.400983328513	(37.7520818989832, -122.400983328513)
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)
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)
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)
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)
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)
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)
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)
2765	2765	173854	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	240 Missouri St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6013446.0	2105960.0	37.763321440581	-122.396648407729	(37.763321440581, -122.396648407729)
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)
154589	154589	201358	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	245 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 2ft		6013008.61874	2092664.0279400002	37.726789172374794	-122.39722877051001	(37.7267891723748, -122.39722877051)
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)
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)
21420	21420	7445	Permitted Site 1	Eriobotrya japonica :: Edible Loquat 190	2548 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	3X3		6008209.4393	2103591.6656299997	37.7565257046152	-122.41459240931201	(37.7565257046152, -122.414592409312)
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)

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