Street_Tree_List

Data source: data.sfgov.org

117 rows where DBH = 2 and qSpecies = 49

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

- 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, PlantDate, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
5159	5159	242086	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4185 25th St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002948.22198	2101215.85126	37.7497052929799	-122.432617857444	(37.7497052929799, -122.432617857444)
13664	13664	6735	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1300X Fairfax Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2007 12:00:00 AM	2	3x3		6017028.4506	2097182.15302	37.7394180218109	-122.383646604615	(37.7394180218109, -122.383646604615)
24319	24319	176264	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	165 Brussels St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010291.19923	2093895.2108900002	37.7300180820504	-122.40670958899099	(37.7300180820504, -122.406709588991)
25831	25831	124534	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	951 Balboa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992622.68332	2111346.9142400003	37.7769315430211	-122.46906087290701	(37.7769315430211, -122.469060872907)
27081	27081	176269	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	273 Curtis St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6000993.66237	2087160.73145	37.711002134104795	-122.43836995721901	(37.7110021341048, -122.438369957219)
27220	27220	223532	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	529 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002464.30667	2099434.4104	37.744786420455604	-122.434163917953	(37.7447864204556, -122.434163917953)
28046	28046	207672	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	542 Kirkham St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993147.42915	2105300.29395	37.76035943445	-122.46680597172801	(37.76035943445, -122.466805971728)
28440	28440	122307	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1617 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990526.29521	2111270.38864	37.7766000733292	-122.47630725349701	(37.7766000733292, -122.476307253497)
29213	29213	224107	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	33 Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006435.98558	2109358.16079	37.7722593483308	-122.421135098612	(37.7722593483308, -122.421135098612)
33337	33337	90910	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	701 Cabrillo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/20/2008 12:00:00 AM	2	3x3		5993421.38614	2110692.4955700003	37.775180801458504	-122.46625036777999	(37.7751808014585, -122.46625036778)
33588	33588	246054	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	634 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5998531.0214	2108461.1139	37.76934748481371	-122.448414340817	(37.7693474848137, -122.448414340817)
34266	34266	223612	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	263 Bartlett St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006747.68104	2102305.49378	37.752911939936	-122.419556452085	(37.752911939936, -122.419556452085)
38313	38313	123775	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	999 Cabrillo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992633.47404	2110664.4807700003	37.775058388598794	-122.46897386925899	(37.7750583885988, -122.468973869259)
38407	38407	250069	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	307 Austin St	2	: 4	Tree 1	Private 1			2	Width 2ft		6005709.21572	2115345.18544	37.7886572546664	-122.424074905926	(37.7886572546664, -122.424074905926)
38665	38665	191094	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1951 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6012582.07272	2102822.21844	37.754657662544396	-122.39941617174401	(37.7546576625444, -122.399416171744)
41407	41407	223561	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	441 Banks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008606.47777	2096794.40952	37.737884249652	-122.412738780697	(37.737884249652, -122.412738780697)
42596	42596	50218	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2536 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/21/2003 12:00:00 AM	2		Permit Number 46925	5987649.93004	2111223.20837	37.776303303016796	-122.48625384500099	(37.7763033030168, -122.486253845001)
42706	42706	207630	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1262 07th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993959.14351	2106898.71187	37.7647950868467	-122.464114690252	(37.7647950868467, -122.464114690252)
43374	43374	224074	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4399 17th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000120.5306	2105737.1003400004	37.7619587726053	-122.442720697406	(37.7619587726053, -122.442720697406)
43423	43423	223650	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1810 Harrison St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008607.48155	2107905.0791700003	37.7683917014338	-122.413520888701	(37.7683917014338, -122.413520888701)
43973	43973	123776	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	999 Cabrillo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992611.69228	2110664.0229	37.775055872901504	-122.469049183134	(37.7750558729015, -122.469049183134)
45440	45440	122167	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	701 15th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991287.4219	2110535.49053	37.7746263536906	-122.47362070062799	(37.7746263536906, -122.473620700628)
46557	46557	223382	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	806 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009885.43506	2104480.3357599997	37.75905981068829	-122.40885888955	(37.7590598106883, -122.40885888955)
46956	46956	139822	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	901 Laguna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004862.1416	2111993.2601	37.7794058385578	-122.426766857751	(37.7794058385578, -122.426766857751)
47324	47324	114551	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	815 Rhode Island St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/24/2015 12:00:00 AM	2		Permit Number 777069	6011882.52063	2104552.93824	37.759370822322005	-122.401957083855	(37.759370822322, -122.401957083855)
48360	48360	207679	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2167 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990677.2269	2100653.21825	37.7474569149997	-122.475009933665	(37.7474569149997, -122.475009933665)
49953	49953	176241	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	901 Olmstead St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009064.8482099995	2090413.67882	37.7203898385876	-122.410703479104	(37.7203898385876, -122.410703479104)
51143	51143	191669	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	240 12th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007874.13645	2108978.90348	37.771298965913	-122.41613352894501	(37.771298965913, -122.416133528945)
53498	53498	119937	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2655 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5987300.155230001	2111149.41702	37.7760803002726	-122.48745837531901	(37.7760803002726, -122.487458375319)
54461	54461	224056	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4609 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000381.16624	2105168.69891	37.7604129369301	-122.441778467817	(37.7604129369301, -122.441778467817)
56090	56090	223381	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	800 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009884.55803	2104492.7286900003	37.759093789753706	-122.408862797106	(37.7590937897537, -122.408862797106)
57587	57587	126531	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1870 Jackson St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6005210.197000001	2117169.09516	37.7936370652524	-122.42593132247801	(37.7936370652524, -122.425931322478)
57943	57943	95767	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	291 Munich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2011 12:00:00 AM	2	3x3	Permit Number 767502	6004463.995209999	2090737.7812599998	37.721020719304704	-122.426630208134	(37.7210207193047, -122.426630208134)
58777	58777	223520	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	78 Richland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004976.40139	2096163.67746	37.7359479859053	-122.425244869978	(37.7359479859053, -122.425244869978)
59341	59341	191681	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1241 Oakdale Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017111.18893	2093915.9080299998	37.7304541363294	-122.383133251796	(37.7304541363294, -122.383133251796)
59512	59512	104074	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	841 32nd Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		08/06/2013 12:00:00 AM	2		Permit Number 770392	5986000.25731	2110187.13166	37.7733622428275	-122.491884144737	(37.7733622428275, -122.491884144737)
60285	60285	92546	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1534 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/23/2009 12:00:00 AM	2	3x3	Permit Number 52889	5985305.6485	2104749.3445	37.7583909829975	-122.493886044317	(37.7583909829975, -122.493886044317)
60322	60322	191676	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	288 12th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008127.34613	2108835.28118	37.770918846754896	-122.415247494384	(37.7709188467549, -122.415247494384)
62138	62138	223651	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1810 Harrison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008609.3878	2107944.17122	37.768499146138794	-122.413517060262	(37.7684991461388, -122.413517060262)
63639	63639	140140	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	229 ASHBURY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5998771.9778	2109907.5347	37.7733327611881	-122.44768502615801	(37.7733327611881, -122.447685026158)
64893	64893	126530	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1870 Jackson St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6005227.379509999	2117173.30895	37.7936496062927	-122.425872169587	(37.7936496062927, -122.425872169587)
67430	67430	123739	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	301 Cabrillo St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5994624.79373	2110737.82643	37.7753746276433	-122.46209082933599	(37.7753746276433, -122.462090829336)
69266	69266	207677	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2179 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991297.81767	2100622.90222	37.7474096214735	-122.472861782445	(37.7474096214735, -122.472861782445)
69493	69493	224039	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	442 Alvarado St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003480.14562	2102754.58142	37.7539604352279	-122.430888246193	(37.7539604352279, -122.430888246193)
70246	70246	56379	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	191@ 23rd Ave 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/27/2012 12:00:00 AM	2		Permit Number 769038	5988661.1856	2114079.0461	37.7842035193233	-122.482965030995	(37.7842035193233, -122.482965030995)
70429	70429	246160	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	654 Shrader St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5997594.3711	2108214.0054	37.7686153917025	-122.451636326624	(37.7686153917025, -122.451636326624)
71947	71947	223610	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3326 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006853.80851	2102650.17167	37.7538643237834	-122.419213890411	(37.7538643237834, -122.419213890411)
73409	73409	124532	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	951 Balboa St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992651.91776	2111347.60988	37.7769351421706	-122.468959793565	(37.7769351421706, -122.468959793565)
73786	73786	94516	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1106X Wisconsin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4		08/27/2010 12:00:00 AM	2		Permit Number 53703	6012787.7377	2102360.9473599996	37.753402573178896	-122.39867255379299	(37.7534025731789, -122.398672553793)
75498	75498	223446	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	422 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003080.60278	2099509.24195	37.7450268497235	-122.43203822730699	(37.7450268497235, -122.432038227307)
76430	76430	246381	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1655 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6006946.7351	2109071.9998	37.771502397852394	-122.419348063063	(37.7715023978524, -122.419348063063)
89235	89235	90546	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	826 Cabrillo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/14/2008 12:00:00 AM	2	3x3		5993034.20515	2110734.5298200003	37.775273869360596	-122.467592759821	(37.7752738693606, -122.467592759821)
90346	90346	6736	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1300X Fairfax Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/30/2011 12:00:00 AM	2	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
94858	94858	90330	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1831 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/27/2008 12:00:00 AM	2	3x3		5989853.25507	2111244.33044	37.7764894706591	-122.478633563095	(37.7764894706591, -122.478633563095)
129655	129655	223664	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	730 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001679.46689	2102069.69668	37.751977715197896	-122.437066377309	(37.7519777151979, -122.437066377309)
129858	129858	223479	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	354 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007707.4423	2097481.9178400002	37.7397214944505	-122.41589586509599	(37.7397214944505, -122.415895865096)
130791	130791	246163	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	642 Shrader St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5997583.9235	2108279.5679	37.7687948112177	-122.451677193811	(37.7687948112177, -122.451677193811)
132105	132105	223588	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	730 Jarboe Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6009063.074440001	2096876.2654900001	37.738134625423704	-122.411165877211	(37.7381346254237, -122.411165877211)
133684	133684	114562	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1815 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/24/2015 12:00:00 AM	2		Permit Number 774856	6005427.7937900005	2117145.93262	37.793585761622296	-122.425176769692	(37.7935857616223, -122.425176769692)
134886	134886	189256	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2249 Quesada Ave	2	: 4	Tree 1	Private 1			2	Width 2ft		6011764.59549	2097191.48709	37.739151291890394	-122.401847463703	(37.7391512918904, -122.401847463703)
135242	135242	223583	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	324 Park St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006884.54394	2096272.5735799999	37.736354605371105	-122.418655365578	(37.7363546053711, -122.418655365578)
135386	135386	224073	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4399 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000107.64	2105738.17174	37.7619609795428	-122.442765357751	(37.7619609795428, -122.442765357751)
138101	138101	223649	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1812 Harrison St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008605.946830001	2107884.1672900002	37.768334196103794	-122.413524717993	(37.7683341961038, -122.413524717993)
140292	140292	114248	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2151 15TH AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/30/2015 12:00:00 AM	2		Permit Number 776062	5991602.0	2100781.0	37.7478613219593	-122.47182147099899	(37.7478613219593, -122.471821470999)
146540	146540	207635	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1450 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		5994307.66331	2105637.8573	37.761353188916395	-122.462817781532	(37.7613531889164, -122.462817781532)
147235	147235	250068	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	307 Austin St	1	: 4	Tree 1	Private 1			2	Width 2ft		6005700.31875	2115344.38579	37.7886545567034	-122.424105631271	(37.7886545567034, -122.424105631271)
147331	147331	207534	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1531 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990839.1284300005	2104968.89337	37.7593160059549	-122.474765039286	(37.7593160059549, -122.474765039286)
147534	147534	207648	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1575 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992116.65286	2104730.33527	37.7587349341825	-122.47032940670401	(37.7587349341825, -122.470329406704)
149397	149397	207535	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1531 17th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990841.25621	2104949.97528	37.7592641852056	-122.47475629966499	(37.7592641852056, -122.474756299665)
150096	150096	245045	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	145 Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6000757.5634	2109534.6757	37.7724222651654	-122.44078987699699	(37.7724222651654, -122.440789876997)
150522	150522	95601	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	131 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/03/2011 12:00:00 AM	2		Permit Number 767201	5990817.89228	2114523.5069	37.78554914201	-122.475536133375	(37.78554914201, -122.475536133375)
151697	151697	176253	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	95 Delta St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010117.92765	2089629.2495	37.7182949452416	-122.407008046982	(37.7182949452416, -122.407008046982)
152172	152172	207594	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	234 Granada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995665.5459199995	2091502.05532	37.7226178864794	-122.45709891259199	(37.7226178864794, -122.457098912592)
152503	152503	126527	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2951 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6000010.3248	2116722.18707	37.792114735156495	-122.443891135382	(37.7921147351565, -122.443891135382)
152786	152786	137794	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2001 CALIFORNIA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004786.5899	2115639.5455	37.7894133591775	-122.42728803293801	(37.7894133591775, -122.427288032938)
153551	153551	223587	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	730 Jarboe Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6009072.26343	2096875.24392	37.7381323357409	-122.411134034011	(37.7381323357409, -122.411134034011)
154440	154440	224108	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	33 Gough St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006456.73439	2109332.89582	37.7721911464267	-122.42106153228998	(37.7721911464267, -122.42106153229)
155026	155026	81551	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	555 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/18/2008 12:00:00 AM	2	3x3	Permit Number 50132	6009979.0752	2111765.16578	37.7790675210845	-122.409049052091	(37.7790675210845, -122.409049052091)
156446	156446	207676	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2151 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991619.02228	2100784.58126	37.7478721400825	-122.471762870272	(37.7478721400825, -122.471762870272)
158063	158063	224110	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	33 Gough St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006506.1757	2109285.6019900003	37.7720640758221	-122.42088715194599	(37.7720640758221, -122.420887151946)
158644	158644	224101	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	2x Gough St	5	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006607.58912	2109275.93798	37.7720432565284	-122.42053566810101	(37.7720432565284, -122.420535668101)
161497	161497	34683	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1901X Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2013 12:00:00 AM	2		Permit Number 770151	6003781.4605	2118989.07405	37.79855341247529	-122.43100482351002	(37.7985534124753, -122.43100482351)
162143	162143	224093	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	353 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004017.83242	2109024.56898	37.7712067701103	-122.429475909489	(37.7712067701103, -122.429475909489)
162676	162676	223559	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	625 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007671.64487	2096429.5044900002	37.7368297864509	-122.41594513085899	(37.7368297864509, -122.415945130859)
164326	164326	176240	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	901 Olmstead St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009052.31678	2090410.35877	37.7203800198047	-122.41074656201	(37.7203800198047, -122.41074656201)
164580	164580	223455	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	574 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5998649.42348	2105858.64067	37.762208518815605	-122.44781741086399	(37.7622085188156, -122.447817410864)
164816	164816	61923	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1901X Filbert St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/07/2008 12:00:00 AM	2	3x3	Permit Number 51174	6003804.33633	2118991.0529099996	37.79856014209621	-122.430925807306	(37.7985601420962, -122.430925807306)
167082	167082	223574	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	51 Wool St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007417.99776	2097972.4007200003	37.7410519748757	-122.41693138589599	(37.7410519748757, -122.416931385896)
168571	168571	223562	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	441 Banks St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008607.931030001	2096810.15163	37.737927555622	-122.412734868636	(37.737927555622, -122.412734868636)
168938	168938	223521	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	793 27th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001408.82629	2099966.50087	37.7461874535894	-122.437851664431	(37.7461874535894, -122.437851664431)
169465	169465	94326	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	354 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/2010 12:00:00 AM	2	3x3	Permit Number 53626	5989679.6833	2112963.89728	37.7812008439985	-122.479359820471	(37.7812008439985, -122.479359820471)
169817	169817	207647	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1520 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992154.93945	2105081.8462	37.7597023043237	-122.470222592396	(37.7597023043237, -122.470222592396)
170042	170042	95763	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	417 Moscow St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2011 12:00:00 AM	2	3x3	Permit Number 767499	6004111.77372	2090686.36945	37.7208596345484	-122.42784407254999	(37.7208596345484, -122.42784407255)
170052	170052	223613	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	269 Bartlett St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006752.54464	2102227.65938	37.7526984984487	-122.41953411112699	(37.7526984984487, -122.419534111127)
170510	170510	224072	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4399 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000093.36595	2105737.39642	37.7619580369572	-122.44281467028401	(37.7619580369572, -122.442814670284)
171263	171263	224040	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3968 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003356.286169999	2102454.69012	37.7531299859864	-122.431295175934	(37.7531299859864, -122.431295175934)
172025	172025	191679	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	604 Keith St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6017194.35691	2096452.8116900001	37.7374245657007	-122.383022220618	(37.7374245657007, -122.383022220618)
172833	172833	191675	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	252 12th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008016.56974	2108896.04904	37.7710794746583	-122.415634977181	(37.7710794746583, -122.415634977181)
173021	173021	123774	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	921 Cabrillo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5992733.94745	2110666.6416700003	37.7750701263922	-122.468626470068	(37.7750701263922, -122.468626470068)
173060	173060	223666	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1511 Castro St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002610.0457	2101075.27233	37.74930011242971	-122.43377723644699	(37.7493001124297, -122.433777236447)

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