Street_Tree_List

Data source: data.sfgov.org

488 rows where search matches "cherry" and qSiteInfo = 4

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
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)
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)
23580	23580	212649	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	321 Vernon St	1	: 4	Tree 1	Private 1			10	Width 3ft		5992450.10328	2090020.5964400002	37.7183649772426	-122.468106177365	(37.7183649772426, -122.468106177365)
23687	23687	235690	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	63 Laussat St	1	: 4	Tree 1	Private 1			8	Width 2ft		6004411.60055	2109266.67882	37.7718938314631	-122.428131106459	(37.7718938314631, -122.428131106459)
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)
24236	24236	213361	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	25 Elmhurst Dr	6	: 4	Tree 1	Private 1			2	Width 3ft		5991216.12738	2094471.85178	37.730515676960394	-122.47269584493701	(37.7305156769604, -122.472695844937)
25052	25052	196384	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	99 Stillman St	3	: 4	Tree 1	Private 1			7	Width 0ft		6013750.52811	2112736.60264	37.781945415491705	-122.396070069587	(37.7819454154917, -122.396070069587)
25220	25220	235688	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	242 Church St	1	: 4	Tree 1	Private 1			7	Width 2ft		6004123.15327	2107397.4194400003	37.766744974426395	-122.428995570805	(37.7667449744264, -122.428995570805)
25347	25347	235710	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2800 18th St	3	: 4	Tree 1	Private 1			2	Width 3ft		6009444.36409	2105489.04346	37.7618047771799	-122.41045555487301	(37.7618047771799, -122.410455554873)
25479	25479	246475	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	318 Duncan St	1	: 4	Tree 1	Private 1			14	Width 3ft		6004316.48172	2099879.2195200003	37.7461127118429	-122.427791134863	(37.7461127118429, -122.427791134863)
25698	25698	202267	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	28 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6013033.98272	2093207.99375	37.728284203554395	-122.397179214247	(37.7282842035544, -122.397179214247)
25791	25791	135673	Undocumented 2	Prunus caroliniana :: Carolina Cherry Laurel 133	3639 Webster St	1	: 4	Tree 1	Private 1			5	Width 3ft		6002560.08245	2121134.92796	37.8043760820531	-122.435384749408	(37.8043760820531, -122.435384749408)
25917	25917	235705	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	50 Scott St	9	: 4	Tree 1	Private 1			6	Width 3ft		6002413.687999999	2108646.89138	37.7700788062318	-122.434997685721	(37.7700788062318, -122.434997685721)
26446	26446	238580	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	519 Hickory St	1	: 4	Tree 1	Private 1			7	Width 2ft		6004286.86456	2110289.10974	37.7746941188733	-122.428635472355	(37.7746941188733, -122.428635472355)
26547	26547	212674	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	641 Garfield St	1	: 4	Tree 1	Private 1			4	Width 3ft		5992267.89136	2090473.0375	37.719596745362395	-122.46876890666	(37.7195967453624, -122.46876890666)
26563	26563	246795	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	195 Brewster St	1	: 4	Tree 1	Private 1			2	Width 2ft		6010198.18555	2098814.08058	37.7435190400824	-122.407377785258	(37.7435190400824, -122.407377785258)
26565	26565	196129	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	537 Rhode Island St	2	: 4	Tree 1	Private 1			7	Width 3ft		6011814.46291	2105877.37979	37.763003645435205	-122.402285583717	(37.7630036454352, -122.402285583717)
27049	27049	215254	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	3	: 4	Tree 1	Private 1			2	Width 0ft		5991351.0324800005	2093792.6407400002	37.7286585418478	-122.472179972231	(37.7286585418478, -122.472179972231)
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)
27319	27319	246424	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	418 Duncan St	1	: 4	Tree 1	Private 1			17	Width 4ft		6003710.7768	2099847.4001700003	37.7459910605319	-122.429883314964	(37.7459910605319, -122.429883314964)
28020	28020	213316	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	325 Howth St	2	: 4	Tree 1	Private 1			3	Width 3ft		5997165.98186	2090264.50059	37.7193059055324	-122.451823029928	(37.7193059055324, -122.451823029928)
28254	28254	235714	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	575 Florida St	1	: 4	Tree 1	Private 1			1	Width 3ft		6009284.05083	2105508.94115	37.761850423188704	-122.41101142226499	(37.7618504231887, -122.411011422265)
28326	28326	215253	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	2	: 4	Tree 1	Private 1			4	Width 0ft		5991347.53031	2093798.3248599998	37.7286739463434	-122.47219249348998	(37.7286739463434, -122.47219249349)
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)
28821	28821	235706	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	50 Scott St	11	: 4	Tree 1	Private 1			7	Width 3ft		6002406.66247	2108692.93634	37.7702048354241	-122.43502528051701	(37.7702048354241, -122.435025280517)
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)
29054	29054	238048	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	400 Lily St	3	: 4	Tree 1	Private 1			6	Width 3ft		6004553.97154	2110004.0488299998	37.7739265241283	-122.427691180609	(37.7739265241283, -122.427691180609)
29237	29237	196145	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	356 Arkansas St	1	: 4	Tree 1	Private 1			4	Width 3ft		6012905.6272599995	2105323.15012	37.7615427021613	-122.398472702866	(37.7615427021613, -122.398472702866)
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)
29741	29741	196461	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	615 Mississippi St	1	: 4	Tree 1	Private 1			1	Width 3ft		6014144.28645	2104277.08263	37.7587393543665	-122.39411542098999	(37.7587393543665, -122.39411542099)
30069	30069	215263	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	70	: 4	Tree 1	Private 1			12	Width 0ft		5991309.897609999	2093234.8571099997	37.727124626686795	-122.47228153268298	(37.7271246266868, -122.472281532683)
30088	30088	212617	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	35 Margaret Ave	2	: 4	Tree 1	Private 1			6	Width 3ft		5997114.72788	2089830.80854	37.7181121526199	-122.45196892242599	(37.7181121526199, -122.451968922426)
30292	30292	238053	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	426 Lily St	2	: 4	Tree 1	Private 1			9	Width 3ft		6004459.53739	2109991.5945200003	37.773886985434295	-122.428016956418	(37.7738869854343, -122.428016956418)
30296	30296	202045	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	41 Exeter St	1	: 4	Tree 1	Private 1			1	Width 3ft		6012584.35783	2091031.2434099999	37.7222822496095	-122.39858091108201	(37.7222822496095, -122.398580911082)
30439	30439	246993	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	55 Clipper St	1	: 4	Tree 1	Private 1			13	Width 3ft		6004785.89781	2101026.3383400002	37.7492889788082	-122.426249608749	(37.7492889788082, -122.426249608749)
30441	30441	196549	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	40 Ledyard St	1	: 4	Tree 1	Private 1			7	Width 2ft		6011616.35938	2095078.6456799998	37.7333416013201	-122.402211492182	(37.7333416013201, -122.402211492182)
30707	30707	250995	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	453 44th Ave	2	: 4	Tree 1	Private 1			5	Width 3ft		5982194.00965	2112744.27477	37.780160200984604	-122.505239820464	(37.7801602009846, -122.505239820464)
30783	30783	202270	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	38 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6012994.98381	2093237.0284400003	37.728361755688894	-122.39731607130301	(37.7283617556889, -122.397316071303)
31006	31006	202273	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	50 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6012938.89237	2093280.23143	37.7284772592045	-122.397513012032	(37.7284772592045, -122.397513012032)
31016	31016	238039	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	89 Elgin Park	1	: 4	Tree 1	Private 1			3	Width 3ft		6005843.94387	2108584.75014	37.7701023549756	-122.423128042119	(37.7701023549756, -122.423128042119)
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)
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)
31680	31680	212666	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	772 Head St	2	: 4	Tree 1	Private 1			5	Width 3ft		5993533.344330001	2090952.0360299998	37.72098498564	-122.464429488032	(37.72098498564, -122.464429488032)
31801	31801	213330	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	217 Byxbee St	3	: 4	Tree 1	Private 1			4	Width 2ft		5991929.42464	2089936.9124	37.7181051172336	-122.46989983921101	(37.7181051172336, -122.469899839211)
31951	31951	246463	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	200 Duncan St	4	: 4	Tree 1	Private 1			9	Width 3ft		6005105.34641	2099923.38039	37.746278561223605	-122.42506648135	(37.7462785612236, -122.42506648135)
31968	31968	213326	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	333 Byxbee St	1	: 4	Tree 1	Private 1			7	Width 3ft		5991939.8499300005	2090759.9353900002	37.7203655398194	-122.46992369461701	(37.7203655398194, -122.469923694617)
32271	32271	237025	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	6	: 4	Tree 1	Private 1			3	Width 6ft		6005760.04076	2109480.81274	37.7725579925006	-122.423481975714	(37.7725579925006, -122.423481975714)
32294	32294	213357	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	25 Ralston St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992244.95419	2088111.9424400001	37.7131124256698	-122.468676481533	(37.7131124256698, -122.468676481533)
32448	32448	212637	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	401 Ralston St	2	: 4	Tree 1	Private 1			4	Width 3ft		5992197.26293	2090572.74875	37.719866447546394	-122.469020294145	(37.7198664475464, -122.469020294145)
32713	32713	196317	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	333 11th St	6	: 4	Tree 1	Private 1			4	Width 3ft		6008676.43803	2109018.47977	37.7714527113022	-122.413361122339	(37.7714527113022, -122.413361122339)
32814	32814	214424	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	732 Shields St	1	: 4	Tree 1	Private 1			1	Width 3ft		5992045.199469999	2089870.8873400001	37.7179305201634	-122.469494855606	(37.7179305201634, -122.469494855606)
32988	32988	196389	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	93 Stillman St	1	: 4	Tree 1	Private 1			1	Width 3ft		6013924.26567	2112893.70041	37.7823864349182	-122.395480022606	(37.7823864349182, -122.395480022606)
33080	33080	215260	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	43	: 4	Tree 1	Private 1			10	Width 0ft		5991332.77888	2093518.51077	37.7279047930719	-122.472223101042	(37.7279047930719, -122.472223101042)
33154	33154	196457	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1950 Cesar Chavez St	13	: 4	Tree 1	Private 1			3	Width 3ft		6012824.47283	2101012.7675799998	37.7497028090569	-122.398450923095	(37.7497028090569, -122.398450923095)
33576	33576	196395	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	260 Clara St	3	: 4	Tree 1	Private 1			9	Width 3ft		6011460.59942	2111454.8789	37.7782984271806	-122.40390199009501	(37.7782984271806, -122.403901990095)
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)
33781	33781	196319	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	83 Lafayette St	1	: 4	Tree 1	Private 1			10	Width 3ft		6007736.57644	2109492.64153	37.7727018336483	-122.416645755806	(37.7727018336483, -122.416645755806)
33949	33949	196186	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Venus St	2	: 4	Tree 1	Private 1			7	Width 3ft		6012832.08257	2093948.98425	37.7303075693197	-122.397929154401	(37.7303075693197, -122.397929154401)
34648	34648	215261	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	67	: 4	Tree 1	Private 1			2	Width 0ft		5991310.9639	2093247.2582599998	37.7271587388628	-122.47227875017799	(37.7271587388628, -122.472278750178)
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)
34816	34816	215255	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	500 Junipero Serra Blvd	4	: 4	Tree 1	Private 1			10	Width 0ft		5991357.82029	2093790.0929299998	37.7286519390174	-122.47215632095501	(37.7286519390174, -122.472156320955)
34926	34926	235675	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Pearl St	2	: 4	Tree 1	Private 1			10	Width 3ft		6005643.27449	2108641.45468	37.7702467258258	-122.423826188538	(37.7702467258258, -122.423826188538)
34982	34982	235712	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2800 18th St	5	: 4	Tree 1	Private 1			2	Width 3ft		6009409.0711	2105486.80385	37.7617966491233	-122.410577461607	(37.7617966491233, -122.410577461607)
35000	35000	235716	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	575 Florida St	3	: 4	Tree 1	Private 1			7	Width 3ft		6009284.605280001	2105547.28061	37.7619557256901	-122.411012212741	(37.7619557256901, -122.411012212741)
35009	35009	196179	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1998 Carroll Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		6012048.7693	2093556.75708	37.7291869385061	-122.40060964941401	(37.7291869385061, -122.400609649414)
35028	35028	196446	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	701 Wisconsin St	1	: 4	Tree 1	Private 1			4	Width 3ft		6012741.003	2104236.29493	37.7585492646472	-122.398965788556	(37.7585492646472, -122.398965788556)
35195	35195	196310	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	928 Clara St	3	: 4	Tree 1	Private 1			1	Width 3ft		6011726.41935	2111671.91567	37.778909207118204	-122.402997684908	(37.7789092071182, -122.402997684908)
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)
35914	35914	196425	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	282 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011155.7597199995	2111427.64984	37.778206627062296	-122.404954631245	(37.7782066270623, -122.404954631245)
36042	36042	235681	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	350 Church St	2	: 4	Tree 1	Private 1			4	Width 3ft		6004154.18633	2106828.24499	37.765183915022895	-122.428847651203	(37.7651839150229, -122.428847651203)
36200	36200	235700	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	51 Webster St	1	: 4	Tree 1	Private 1			9	Width 3ft		6004285.19479	2108787.04893	37.7705697317337	-122.428534159217	(37.7705697317337, -122.428534159217)
36513	36513	235731	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2727 Mariposa St	1	: 4	Tree 1	Private 1			5	Width 3ft		6009390.15483	2105905.76988	37.7629459737104	-122.41067247408199	(37.7629459737104, -122.410672474082)
37111	37111	212660	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	229 Victoria St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993215.92884	2088803.0771700002	37.7150661605497	-122.46537066722401	(37.7150661605497, -122.465370667224)
38004	38004	238044	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	38 Dolores St	13	: 4	Tree 1	Private 1			2	Width 3ft		6004736.08926	2107889.20151	37.7681299654601	-122.426910555597	(37.7681299654601, -122.426910555597)
38214	38214	212630	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	186 Byxbee St	2	: 4	Tree 1	Private 1			2	Width 2ft		5991963.5826	2089803.15651	37.7177398306004	-122.46977203837099	(37.7177398306004, -122.469772038371)
38490	38490	235671	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	33 Elgin Park	1	: 4	Tree 1	Private 1			6	Width 3ft		6005828.27728	2108838.78299	37.7707989842116	-122.423200292771	(37.7707989842116, -122.423200292771)
38693	38693	213308	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	219 Tara St	1	: 4	Tree 1	Private 1			3	Width 3ft		5997858.51511	2090428.8363400002	37.719796773473604	-122.44944104777001	(37.7197967734736, -122.44944104777)
39164	39164	238056	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	439 Lily St	1	: 4	Tree 1	Private 1			9	Width 2ft		6004411.75821	2109960.94242	37.773800119011895	-122.428180047573	(37.7738001190119, -122.428180047573)
39473	39473	250644	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2610 Lake St	5	: 4	Tree 1	Private 1			4	Width 3ft		5987312.1046400005	2114657.5756599996	37.785713403992	-122.487674827026	(37.785713403992, -122.487674827026)
39806	39806	202011	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	35 Wheat St	1	: 4	Tree 1	Private 1			10	Width 3ft		6012102.79015	2091227.84985	37.722795249884896	-122.40025938868601	(37.7227952498849, -122.400259388686)
39978	39978	196453	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1950 Cesar Chavez St	7	: 4	Tree 1	Private 1			2	Width 3ft		6012987.92898	2101021.89129	37.749736965294794	-122.39788632150601	(37.7497369652948, -122.397886321506)
40068	40068	196188	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	88 Neptune St	1	: 4	Tree 1	Private 1			6	Width 3ft		6013049.10875	2093942.96421	37.7303031239855	-122.39717843815001	(37.7303031239855, -122.39717843815)
40286	40286	178844	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	52 Tomaso Ct	1	: 4	Tree 1	Private 1			16	Width 2ft		6009171.05644	2086338.49099	37.7092061672978	-122.410048805012	(37.7092061672978, -122.410048805012)
40323	40323	212653	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	238 Vernon St	1	: 4	Tree 1	Private 1			2	Width 3ft		5992477.51296	2089454.93509	37.716813391295204	-122.467970312297	(37.7168133912952, -122.467970312297)
40407	40407	250787	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	277 32nd Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5985873.31121	2114054.8468299997	37.7839744613866	-122.49260816604601	(37.7839744613866, -122.492608166046)
40635	40635	196144	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	354 Arkansas St	2	: 4	Tree 1	Private 1			4	Width 3ft		6012902.24063	2105349.71395	37.7616154519153	-122.39848627993901	(37.7616154519153, -122.398486279939)
40677	40677	238040	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	49 Pearl St	1	: 4	Tree 1	Private 1			10	Width 3ft		6005642.224280001	2108761.00256	37.7705749163322	-122.423838323102	(37.7705749163322, -122.423838323102)
40758	40758	235696	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	437 Webster St	1	: 4	Tree 1	Private 1			5	Width 3ft		6004075.95102	2110295.93849	37.7747009303442	-122.429365551889	(37.7747009303442, -122.429365551889)
41344	41344	196448	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2 Madera St	2	: 4	Tree 1	Private 1			6	Width 3ft		6012976.23669	2103282.94556	37.755944680513295	-122.398085357651	(37.7559446805133, -122.398085357651)
41983	41983	212629	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	186 Byxbee St	1	: 4	Tree 1	Private 1			3	Width 2ft		5991963.2488	2089763.89053	37.717631996493395	-122.46977033503599	(37.7176319964934, -122.469770335036)
42217	42217	237026	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	7	: 4	Tree 1	Private 1			3	Width 6ft		6005759.75569	2109493.68206	37.7725933124646	-122.423483876889	(37.7725933124646, -122.423483876889)
42699	42699	196153	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	672 Missouri St	1	: 4	Tree 1	Private 1			7	Width 3ft		6013557.16695	2103938.65044	37.7577774430852	-122.39612224644699	(37.7577774430852, -122.396122246447)
42959	42959	213345	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	542 Arch St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992754.74517	2090800.4755	37.7205239248105	-122.46710983737499	(37.7205239248105, -122.467109837375)
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)
43246	43246	247776	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	228 30th St	1	: 4	Tree 1	Private 1			1	Width 3ft		6005091.07435	2098463.74529	37.7422699303121	-122.425011997728	(37.7422699303121, -122.425011997728)
43621	43621	239463	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	200 Palo Alto Ave	1	: 4	Tree 1	Private 1			6	Width 3ft		5997639.21555	2103894.3138099997	37.7567571793145	-122.451169653584	(37.7567571793145, -122.451169653584)
44292	44292	202136	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2655 Newhall St	1	: 4	Tree 1	Private 1			5	Width 3ft		6012733.3643	2093424.9143700001	37.7288630827546	-122.398233684638	(37.7288630827546, -122.398233684638)
45488	45488	238055	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	438 Lily St	1	: 4	Tree 1	Private 1			9	Width 2ft		6004413.04242	2109984.42979	37.7738646822544	-122.428177279482	(37.7738646822544, -122.428177279482)
45677	45677	237019	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	203 Webster St	2	: 4	Tree 1	Private 1			3	Width 3ft		6004185.26879	2109539.80191	37.7726309526779	-122.428933479791	(37.7726309526779, -122.428933479791)

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