Street_Tree_List

Data source: data.sfgov.org

488 rows where search matches "cherry" and qSiteInfo = 4 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, qSpecies, SiteOrder, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
71980	71980	196271	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Cashmere St	1	: 4	Tree 1	Private 1			31			6017110.310380001	2095865.5402400002	37.7358073912904	-122.383271945238	(37.7358073912904, -122.383271945238)
131	131	237033	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Octavia St	7	: 4	Tree 1	DPW 2			6	Width 4ft		6005718.98472	2109769.85153	37.7733493059578	-122.423644547079	(37.7733493059578, -122.423644547079)
135	135	237030	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Octavia St	4	: 4	Tree 1	DPW 2			5	Width 4ft		6005725.94025	2109733.85532	37.773250861665204	-122.423617927146	(37.7732508616652, -122.423617927146)
168224	168224	237032	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Octavia St	6	: 4	Tree 1	Private 1			5	Width 4ft		6005721.49565	2109758.3052	37.7733177442556	-122.423635040324	(37.7733177442556, -122.423635040324)
171710	171710	237031	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Octavia St	5	: 4	Tree 1	Private 1			5	Width 4ft		6005723.44032	2109745.94906	37.773283927046	-122.423627434762	(37.773283927046, -122.423627434762)
133460	133460	196469	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1001 Cesar Chavez St	1	: 4	Tree 1	Private 1			5	Width 3ft		6015764.4296	2101073.59632	37.750033173207	-122.388288593857	(37.750033173207, -122.388288593857)
59533	59533	196133	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1007 Rhode Island St	1	: 4	Tree 1	Private 1			11	Width 3ft		6011938.93616	2103592.2223099996	37.7567360569294	-122.401694443163	(37.7567360569294, -122.401694443163)
49374	49374	237038	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	101 Octavia St	1	: 4	Tree 1	Private 1			5	Width 4ft		6005608.429830001	2109742.33589	37.773267513529	-122.424025015163	(37.773267513529, -122.424025015163)
147759	147759	237040	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	101 Octavia St	3	: 4	Tree 1	Private 1			5	Width 4ft		6005610.09761	2109720.52403	37.7732077175873	-122.42401769467699	(37.7732077175873, -122.424017694677)
183083	183083	237039	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	101 Octavia St	2	: 4	Tree 1	Private 1			7	Width 4ft		6005609.24206	2109730.37641	37.7732347215415	-122.424021354908	(37.7732347215415, -122.424021354908)
73188	73188	196546	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	1017 Rhode Island St	1	: 4	Tree 1	Private 1			2	Width 3ft		6011946.26987	2103466.6749299997	37.7563917406915	-122.401660256322	(37.7563917406915, -122.401660256322)
76842	76842	196134	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1028 Wisconsin St	1	: 4	Tree 1	Private 1			2	Width 3ft		6012770.44441	2102683.83354	37.7542881850521	-122.398755016246	(37.7542881850521, -122.398755016246)
62370	62370	213314	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	109 Caine Ave	4	: 4	Tree 1	Private 1			5	Width 3ft		5997314.23204	2089197.70588	37.716385224975795	-122.45123369250601	(37.7163852249758, -122.451233692506)
66393	66393	213312	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	109 Caine Ave	2	: 4	Tree 1	Private 1			4	Width 3ft		5997293.25449	2089167.74263	37.716301751698204	-122.451304041065	(37.7163017516982, -122.451304041065)
147069	147069	213311	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	109 Caine Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		5997282.73831	2089151.44786	37.716256407882106	-122.451339215357	(37.7162564078821, -122.451339215357)
180916	180916	213313	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	109 Caine Ave	3	: 4	Tree 1	Private 1			5	Width 3ft		5997305.300980001	2089185.13122	37.7163501865023	-122.45126365610099	(37.7163501865023, -122.451263656101)
35379	35379	235694	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	11 Laussat St	1	: 4	Tree 1	Private 1			4	Width 3ft		6004612.357000001	2109292.4506900003	37.771975951266796	-122.42743851158501	(37.7719759512668, -122.427438511585)
51355	51355	196467	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 Cesar Chavez St	8	: 4	Tree 1	Private 1			4	Width 3ft		6015482.81101	2101057.8670900003	37.7499743755266	-122.389261356351	(37.7499743755266, -122.389261356351)
55544	55544	196465	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 Cesar Chavez St	3	: 4	Tree 1	Private 1			3	Width 3ft		6015262.99985	2101056.82815	37.7499593343528	-122.39002140848801	(37.7499593343528, -122.390021408488)
151967	151967	196468	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 Cesar Chavez St	12	: 4	Tree 1	Private 1			8	Width 3ft		6015629.24905	2101065.86664	37.7500044578413	-122.38875552004801	(37.7500044578413, -122.388755520048)
171137	171137	196466	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 Cesar Chavez St	7	: 4	Tree 1	Private 1			6	Width 3ft		6015450.2681	2101056.0343	37.7499675388841	-122.389373764399	(37.7499675388841, -122.389373764399)
149456	149456	213310	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	111 Caine Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		5997269.145819999	2089132.21478	37.716202819983	-122.451384810958	(37.716202819983, -122.451384810958)
43064	43064	212621	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	115 Beverly St	1	: 4	Tree 1	Private 1			5	Width 3ft		5991409.18042	2089964.95615	37.718152032178295	-122.471700124589	(37.7181520321783, -122.471700124589)
31639	31639	213343	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	117 Vernon St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992434.92339	2088648.0359	37.7145953816368	-122.468058861341	(37.7145953816368, -122.468058861341)
69640	69640	213344	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	117 Vernon St	3	: 4	Tree 1	Private 1			6	Width 3ft		5992432.58541	2088617.0275700002	37.7145101052228	-122.468064688059	(37.7145101052228, -122.468064688059)
33705	33705	202264	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	12 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6013090.69479	2093165.6197900001	37.728171010371796	-122.396980187094	(37.7281710103718, -122.396980187094)
29565	29565	212676	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	124 Sargent St	1	: 4	Tree 1	Private 1			2	Width 3ft		5993606.85369	2089199.82617	37.7161780760225	-122.464048258239	(37.7161780760225, -122.464048258239)
184114	184114	218215	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	126 Lenox Way	1	: 4	Tree 1	Private 1			3	Width 2ft		5993412.17188	2098613.00635	37.74201313250371	-122.465404568079	(37.7420131325037, -122.465404568079)
77199	77199	238575	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	127 Buchanan St	1	: 4	Tree 1	Private 1			7	Width 3ft		6004751.79623	2108930.40583	37.7709897493005	-122.42693039102801	(37.7709897493005, -122.426930391028)
174272	174272	238576	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	127 Buchanan St	2	: 4	Tree 1	Private 1			7	Width 3ft		6004749.172730001	2108941.84845	37.771021019622296	-122.426940280881	(37.7710210196223, -122.426940280881)
164627	164627	213356	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	128 Shields St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993609.42924	2089850.5677200002	37.717965004654495	-122.464086568463	(37.7179650046545, -122.464086568463)
159738	159738	237037	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	129 Octavia St	1	: 4	Tree 1	Private 1			6	Width 4ft		6005605.52362	2109755.39176	37.7733031977155	-122.42403599677601	(37.7733031977155, -122.424035996776)
31599	31599	218216	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	130 Lenox Way	1	: 4	Tree 1	Private 1			2	Width 2ft		5993396.63989	2098589.94545	37.7419489172986	-122.465456597447	(37.7419489172986, -122.465456597447)
28434	28434	196463	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1301 Cesar Chavez St	4	: 4	Tree 1	Private 1			4	Width 3ft		6014925.6309	2101062.89752	37.7499572830217	-122.39118848116999	(37.7499572830217, -122.39118848117)
68841	68841	196464	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1301 Cesar Chavez St	6	: 4	Tree 1	Private 1			9	Width 3ft		6015016.3527	2101061.7401099997	37.7499591392145	-122.390874677125	(37.7499591392145, -122.390874677125)
163313	163313	235664	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1301 Jessie St	1	: 4	Tree 1	Private 1			3	Width 2ft		6006467.28289	2108921.0359400003	37.771060872189295	-122.42099579632	(37.7710608721893, -122.42099579632)
163878	163878	235667	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1301 Jessie St	6	: 4	Tree 1	Private 1			3	Width 2ft		6006460.44549	2109061.9419400003	37.7714473810138	-122.42102945344801	(37.7714473810138, -122.421029453448)
182116	182116	235665	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1301 Jessie St	3	: 4	Tree 1	Private 1			3	Width 2ft		6006464.5058	2108970.07849	37.771195374787204	-122.42100888505101	(37.7711953747872, -122.421008885051)
182429	182429	235666	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1301 Jessie St	4	: 4	Tree 1	Private 1			3	Width 2ft		6006462.25734	2109005.38337	37.7712921868165	-122.421019169707	(37.7712921868165, -122.421019169707)
168203	168203	212669	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	131 Garfield St	1	: 4	Tree 1	Private 1			2	Width 3ft		5993624.744659999	2090472.09024	37.7196724386082	-122.46407872367399	(37.7196724386082, -122.464078723674)
161423	161423	196154	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1317 19th St	2	: 4	Tree 1	Private 1			3	Width 6ft		6013683.78692	2105210.99248	37.7612780613652	-122.395773489354	(37.7612780613652, -122.395773489354)
22911	22911	238577	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	133 Buchanan St	1	: 4	Tree 1	Private 1			9	Width 3ft		6004747.18096	2108954.98025	37.771056963743	-122.426948105892	(37.771056963743, -122.426948105892)
60693	60693	196132	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1333 Rhode Island St	1	: 4	Tree 1	Private 1			9	Width 3ft		6012008.04219	2102176.90375	37.7528537582936	-122.401355988713	(37.7528537582936, -122.401355988713)
181685	181685	238036	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1345 Stevenson St	1	: 4	Tree 1	Private 1			9	Width 3ft		6006282.85406	2108818.1643	37.77076801336371	-122.421626435124	(37.7707680133637, -122.421626435124)
148757	148757	196402	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	136 Langton St	1	: 4	Tree 1	Private 1			6	Width 3ft		6010324.85595	2110562.99084	37.775785993859294	-122.407768059545	(37.7757859938593, -122.407768059545)
48023	48023	196403	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	140 Langton St	1	: 4	Tree 1	Private 1			6	Width 3ft		6010340.69149	2110544.62696	37.7757364574022	-122.40771198501899	(37.7757364574022, -122.407711985019)
53636	53636	213354	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	142 Garfield St	1	: 4	Tree 1	Private 1			3	Width 3ft		5993565.63371	2090507.60393	37.7197665436602	-122.46428562440701	(37.7197665436602, -122.464285624407)
55882	55882	196536	Undocumented 2	Prunus spp :: Cherry 84	1422 Rhode Island St	1	: 4	Tree 1	Private 1			10	Width 3ft		6011983.19537	2101729.68858	37.751624416549795	-122.40141048760401	(37.7516244165498, -122.401410487604)
176483	176483	238578	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	149 Buchanan St	1	: 4	Tree 1	Private 1			2	Width 3ft		6004732.39628	2109051.52361	37.7713212124262	-122.427006123859	(37.7713212124262, -122.427006123859)
181642	181642	201265	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	15 Orsi Cir	1	: 4	Tree 1	Private 1			7	Width 2ft		6013080.9244	2093125.28837	37.728059724652	-122.397011137269	(37.728059724652, -122.397011137269)
156026	156026	237034	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	150 Octavia St	1	: 4	Tree 1	Private 1			4	Width 4ft		6005711.67822	2109842.25548	37.7735476972984	-122.423674970241	(37.7735476972984, -122.423674970241)
64861	64861	238007	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	150 Saint Germain Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5997631.46598	2104146.92887	37.757450353356795	-122.45121467184099	(37.7574503533568, -122.451214671841)
149708	149708	213331	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	151 Byxbee St	1	: 4	Tree 1	Private 1			6	Width 2ft		5991924.78555	2089552.6251599998	37.7170496899626	-122.469887910591	(37.7170496899626, -122.469887910591)
187644	187644	202304	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	152 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6012919.13392	2092996.02429	37.727695784333704	-122.397561393738	(37.7276957843337, -122.397561393738)
34750	34750	236795	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	155 Saint Germain Ave	2	: 4	Tree 1	Private 1			7	Width 3ft		5997672.865180001	2104113.27373	37.7573603150384	-122.451069070676	(37.7573603150384, -122.451069070676)
66700	66700	236794	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	155 Saint Germain Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5997639.0725300005	2104111.90279	37.75735461602879	-122.45118583956499	(37.7573546160288, -122.451185839565)
51943	51943	196184	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	160 Venus St	1	: 4	Tree 1	Private 1			6	Width 2ft		6012817.540030001	2094120.4485	37.730777564924004	-122.397991454042	(37.730777564924, -122.397991454042)
72754	72754	196140	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	2	: 4	Tree 1	Private 1			11	Width 3ft		6012891.95779	2105595.3281900003	37.762289281552	-122.398539080015	(37.762289281552, -122.398539080015)
77233	77233	196141	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	3	: 4	Tree 1	Private 1			3	Width 3ft		6012893.04995	2105563.16463	37.762201028365	-122.39853304556601	(37.762201028365, -122.398533045566)
149351	149351	196139	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	1	: 4	Tree 1	Private 1			11	Width 3ft		6012892.7022400005	2105610.51534	37.76233102358479	-122.39853757097299	(37.7623310235848, -122.398537570973)
27074	27074	250328	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	161 27th Ave	3	: 4	Tree 1	Private 1			4	Width 3ft		5987394.32135	2114885.37066	37.7863436587784	-122.487407123146	(37.7863436587784, -122.487407123146)
24067	24067	201949	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	18	: 4	Tree 1	Private 1			2	Width 3ft		6013468.57071	2092447.06427	37.7262190300648	-122.395623522912	(37.7262190300648, -122.395623522912)
54190	54190	201951	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	21	: 4	Tree 1	Private 1			2	Width 3ft		6013437.11385	2092477.4793	37.7263007937235	-122.39573439853999	(37.7263007937235, -122.39573439854)
69176	69176	201948	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	17	: 4	Tree 1	Private 1			2	Width 3ft		6013493.80219	2092427.9191599998	37.726167864948394	-122.39553495768801	(37.7261678649484, -122.395534957688)
73494	73494	201943	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	9	: 4	Tree 1	Private 1			2	Width 3ft		6013641.01292	2092357.4486099998	37.7259825542392	-122.39502112103999	(37.7259825542392, -122.39502112104)
75679	75679	201946	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	15	: 4	Tree 1	Private 1			2	Width 3ft		6013528.35075	2092407.54642	37.7261138471553	-122.395414097787	(37.7261138471553, -122.395414097787)
130580	130580	201945	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	12	: 4	Tree 1	Private 1			2	Width 3ft		6013588.62557	2092382.18651	37.72604756622879	-122.395203954116	(37.7260475662288, -122.395203954116)
134420	134420	201947	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	16	: 4	Tree 1	Private 1			2	Width 3ft		6013508.30345	2092417.8690400003	37.7261410759436	-122.39548412349801	(37.7261410759436, -122.395484123498)
147663	147663	201944	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	10	: 4	Tree 1	Private 1			2	Width 3ft		6013619.17874	2092369.08927	37.726013302964894	-122.395097415939	(37.7260133029649, -122.395097415939)
156186	156186	201950	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	19	: 4	Tree 1	Private 1			2	Width 3ft		6013454.07417	2092462.86765	37.726261616558205	-122.39567474381599	(37.7262616165582, -122.395674743816)
159357	159357	201952	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	25	: 4	Tree 1	Private 1			2	Width 2ft		6013392.01965	2092548.68574	37.726493803536	-122.395895275553	(37.726493803536, -122.395895275553)
168510	168510	201941	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	7	: 4	Tree 1	Private 1			2	Width 3ft		6013681.12245	2092335.8479	37.7259254733716	-122.394880951809	(37.7259254733716, -122.394880951809)
185938	185938	201942	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	8	: 4	Tree 1	Private 1			2	Width 3ft		6013661.36989	2092347.25444	37.7259556950922	-122.394950034125	(37.7259556950922, -122.394950034125)
52347	52347	201970	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	21	: 4	Tree 1	Private 1			3	Width 3ft		6013765.00423	2092206.62002	37.725575303453496	-122.39458193081998	(37.7255753034535, -122.39458193082)
56024	56024	201979	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	12	: 4	Tree 1	Private 1			3	Width 3ft		6013673.656359999	2092275.41387	37.7257591185834	-122.39490253103901	(37.7257591185834, -122.394902531039)
63590	63590	201983	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	8	: 4	Tree 1	Private 1			2	Width 3ft		6013616.63963	2092305.2202599999	37.7258377903696	-122.39510172187201	(37.7258377903696, -122.395101721872)
69858	69858	201984	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	4	: 4	Tree 1	Private 1			2	Width 3ft		6013594.77768	2092310.7003900001	37.7258516219291	-122.39517768132099	(37.7258516219291, -122.395177681321)
130792	130792	201976	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	15	: 4	Tree 1	Private 1			5	Width 3ft		6013710.28394	2092247.91618	37.725685652057706	-122.394773986446	(37.7256856520577, -122.394773986446)
150209	150209	201982	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	9	: 4	Tree 1	Private 1			2	Width 3ft		6013638.14457	2092296.9483299998	37.7258162731896	-122.395026801165	(37.7258162731896, -122.395026801165)
165875	165875	201977	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	14	: 4	Tree 1	Private 1			5	Width 4ft		6013690.4115699995	2092261.6964099999	37.7257223848541	-122.394843648839	(37.7257223848541, -122.394843648839)
185885	185885	201972	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	19	: 4	Tree 1	Private 1			3	Width 3ft		6013746.1142	2092220.9433400002	37.725613582194796	-122.39464823513501	(37.7256135821948, -122.394648235135)
187589	187589	201974	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	17	: 4	Tree 1	Private 1			4	Width 3ft		6013727.10603	2092236.0738	37.725654070573704	-122.39471500442	(37.7256540705737, -122.39471500442)
134258	134258	236790	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	168 Marview Way	1	: 4	Tree 1	Private 1			5	Width 3ft		5998277.67036	2103308.22186	37.755184450313	-122.448919435589	(37.755184450313, -122.448919435589)
56132	56132	235692	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	17 Laussat St	1	: 4	Tree 1	Private 1			6	Width 3ft		6004588.55294	2109288.87963	37.7719647996542	-122.427520597194	(37.7719647996542, -122.427520597194)
57333	57333	235693	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	17 Laussat St	2	: 4	Tree 1	Private 1			7	Width 3ft		6004598.976290001	2109290.88002	37.7719708817873	-122.427484684569	(37.7719708817873, -122.427484684569)
177469	177469	246812	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	170 Brewster St	1	: 4	Tree 1	Private 1			5	Width 2ft		6010217.158009999	2098948.40829	37.743888936641895	-122.407321650485	(37.7438889366419, -122.407321650485)
155512	155512	196383	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	172 Clara St	1	: 4	Tree 1	Private 1			7	Width 2ft		6012113.23171	2112074.9324	37.780037390439794	-122.40168787361799	(37.7800373904398, -122.401687873618)
73561	73561	239462	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	173 Marview Way	1	: 4	Tree 1	Private 1			3	Width 3ft		5998149.4954699995	2103367.33608	37.7553394322787	-122.449366958943	(37.7553394322787, -122.449366958943)
50719	50719	196312	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Langton St	2	: 4	Tree 1	Private 1			4	Width 3ft		6010488.38064	2110422.4509900003	37.775409257068205	-122.407192474555	(37.7754092570682, -122.407192474555)
64835	64835	196313	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Langton St	3	: 4	Tree 1	Private 1			4	Width 3ft		6010484.67452	2110427.749	37.775423596760994	-122.407205668504	(37.775423596761, -122.407205668504)
29013	29013	236797	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Saint Germain Ave	2	: 4	Tree 1	Private 1			4	Width 3ft		5997604.4379	2104110.13447	37.7573477775868	-122.45130549166299	(37.7573477775868, -122.451305491663)
59610	59610	236796	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Saint Germain Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		5997594.42954	2104109.9282	37.757346638148896	-122.451340089471	(37.7573466381489, -122.451340089471)
152134	152134	236798	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Saint Germain Ave	3	: 4	Tree 1	Private 1			5	Width 3ft		5997618.19625	2104110.26255	37.757348917040005	-122.451257919334	(37.75734891704, -122.451257919334)
170481	170481	201991	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1751 Carroll Ave	7	: 4	Tree 1	Private 1			2	Width 3ft		6013485.64387	2092346.4840900002	37.7259438069368	-122.395557457834	(37.7259438069368, -122.395557457834)
49624	49624	196458	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1760 Cesar Chavez St	4	: 4	Tree 1	Private 1			4	Width 2ft		6013820.908980001	2101070.2514	37.7499161066554	-122.395009208608	(37.7499161066554, -122.395009208608)
68445	68445	196459	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1760 Cesar Chavez St	5	: 4	Tree 1	Private 1			5	Width 2ft		6013796.36432	2101069.01684	37.7499113519264	-122.395093999398	(37.7499113519264, -122.395093999398)
146355	146355	202308	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	178 Orsi Cir	1	: 4	Tree 1	Private 1			2	Width 2ft		6013012.36975	2092926.2043	37.7275092640335	-122.39723417993099	(37.7275092640335, -122.397234179931)
130448	130448	201904	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1797 Yosemite Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		6013567.70299	2093393.69523	37.7288238003734	-122.395347110876	(37.7288238003734, -122.395347110876)
173931	173931	201905	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1797 Yosemite Ave	2	: 4	Tree 1	Private 1			2	Width 3ft		6013584.00079	2093382.5672099998	37.728794151521	-122.395289988656	(37.728794151521, -122.395289988656)
46970	46970	202265	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	18 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6013066.32076	2093183.7813900001	37.7282195215999	-122.397065722507	(37.7282195215999, -122.397065722507)

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