Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by SiteOrder 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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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
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
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)
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)
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)
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)
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)
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
23748	23748	224117	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2818 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6009831.98095	2102814.76339	37.754483528604396	-122.40892624516701	(37.7544835286044, -122.408926245167)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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