Street_Tree_List

Data source: data.sfgov.org

195 rows where qSiteInfo = 3 and qSpecies = 100

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22823	22823	251110	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	5	Median : Yard 3	Tree 1	DPW 2
22825	22825	251109	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	3	Median : Yard 3	Tree 1	DPW 2
22828	22828	251115	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	19	Median : Yard 3	Tree 1	DPW 2
22831	22831	251116	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	20	Median : Yard 3	Tree 1	DPW 2
22832	22832	251108	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	2	Median : Yard 3	Tree 1	DPW 2
22833	22833	251113	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	15	Median : Yard 3	Tree 1	DPW 2
22838	22838	251111	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	7	Median : Yard 3	Tree 1	DPW 2
22839	22839	251114	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	16	Median : Yard 3	Tree 1	DPW 2
23802	23802	132129	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013671.61354	2118630.60451	37.79812457884061	-122.39675640879999	(37.7981245788406, -122.3967564088)
24494	24494	233935	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	9	Median : Yard 3	Tree 1	DPW 2			30			6004826.52958	2107279.95522	37.766462234780604	-122.426554344032	(37.7664622347806, -122.426554344032)
25048	25048	132103	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012095.78368	2120981.89347	37.8044928149639	-122.402374687645	(37.8044928149639, -122.402374687645)
25236	25236	194362	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016123.073030001	2114362.8388099996	37.786542411639	-122.38797559828899	(37.786542411639, -122.387975598289)
25390	25390	132077	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012714.4120000005	2120058.1365799997	37.8019909162964	-122.400168938451	(37.8019909162964, -122.400168938451)
25996	25996	194361	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016114.70966	2114269.45463	37.786285536482296	-122.38799801482	(37.7862855364823, -122.38799801482)
26160	26160	194311	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			21	Width 7ft		6015171.2298099995	2116694.38601	37.79289152546961	-122.39143182424401	(37.7928915254696, -122.391431824244)
27134	27134	194292	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	43	Median : Yard 3	Tree 1	DPW 2			38			6014354.24031	2095291.86255	37.734079495961396	-122.392760714642	(37.7340794959614, -122.392760714642)
27286	27286	132113	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6013330.52243	2119204.92075	37.7996825238869	-122.39797700193701	(37.7996825238869, -122.397977001937)
27329	27329	194334	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	10	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015942.04821	2112270.67914	37.7807877820727	-122.388455820993	(37.7807877820727, -122.388455820993)
27355	27355	234354	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			23			6004979.813630001	2104508.3497200003	37.7588607286626	-122.425826859935	(37.7588607286626, -122.425826859935)
27594	27594	194293	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	46	Median : Yard 3	Tree 1	DPW 2			28			6014318.796490001	2095319.19207	37.7341525685742	-122.392885167337	(37.7341525685742, -122.392885167337)
29064	29064	194335	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	11	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015932.5598	2112347.87113	37.7809992081901	-122.38849403588999	(37.7809992081901, -122.38849403589)
29492	29492	194379	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015888.45756	2115624.95631	37.7899948982019	-122.388875463533	(37.7899948982019, -122.388875463533)
30823	30823	132092	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011191.46105	2121714.3637599996	37.806453474602	-122.405555813649	(37.806453474602, -122.405555813649)
32862	32862	132075	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012816.85763	2119903.53523	37.8015721299035	-122.399803563704	(37.8015721299035, -122.399803563704)
33156	33156	234362	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			25			6005144.45634	2101528.47617	37.7506879938715	-122.425045428228	(37.7506879938715, -122.425045428228)
33192	33192	194377	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	14	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016027.16358	2115370.7776	37.789304668530896	-122.388377800289	(37.7893046685309, -122.388377800289)
35273	35273	233937	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			32			6004843.94175	2106947.59382	37.7655506342911	-122.42647045077801	(37.7655506342911, -122.426470450778)
35368	35368	194364	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016200.86003	2114659.13107	37.78736027221179	-122.387727152497	(37.7873602722118, -122.387727152497)
35608	35608	194288	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	37	Median : Yard 3	Tree 1	DPW 2			34			6014411.93404	2095259.01392	37.733992504551296	-122.392558950849	(37.7339925045513, -122.392558950849)
35716	35716	194337	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	13	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6015953.29851	2112409.5704799998	37.781169770014294	-122.38842659752198	(37.7811697700143, -122.388426597522)
35928	35928	194284	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	20	Median : Yard 3	Tree 1	DPW 2			31			6014504.15008	2095180.2076400002	37.733781239407	-122.392234619349	(37.733781239407, -122.392234619349)
37174	37174	132080	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		6012562.54875	2120282.53748	37.802598598112	-122.40071023410101	(37.802598598112, -122.400710234101)
38595	38595	234356	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			22			6004985.9304599995	2104422.99085	37.7586266989802	-122.42579962935301	(37.7586266989802, -122.425799629353)
39870	39870	194287	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	32	Median : Yard 3	Tree 1	DPW 2			31			6014435.322380001	2095233.3766599998	37.733923408722795	-122.392476296866	(37.7339234087228, -122.392476296866)
41054	41054	194324	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			18	Width 7ft		6014719.872819999	2117222.0655900002	37.7943153492131	-122.39303049145701	(37.7943153492131, -122.393030491457)
41120	41120	233936	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			34			6004841.8872	2106976.70647	37.7656304545194	-122.42647963012699	(37.7656304545194, -122.426479630127)
41127	41127	132091	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011272.98764	2121658.8993	37.806305741188204	-122.405269766312	(37.8063057411882, -122.405269766312)
42530	42530	194380	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015792.97899	2115653.31942	37.79006748427221	-122.38920779542102	(37.7900674842722, -122.389207795421)
42729	42729	194375	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6016059.60857	2115304.2736400003	37.7891238616108	-122.388260900137	(37.7891238616108, -122.388260900137)
43461	43461	194341	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6016036.61123	2112738.53497	37.7820776491035	-122.388161338867	(37.7820776491035, -122.388161338867)
46468	46468	194330	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	6	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6015863.586519999	2112149.96757	37.780451986896296	-122.38871883132	(37.7804519868963, -122.38871883132)
47477	47477	234367	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1650x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			44			6005309.50054	2098532.58451	37.7424712831236	-122.424261641173	(37.7424712831236, -122.424261641173)
47529	47529	132102	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6012409.883230001	2120572.1173400003	37.8033851982182	-122.401258897879	(37.8033851982182, -122.401258897879)
47801	47801	234359	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x Dolores St	13	Median : Yard 3	Tree 1	DPW 2			31			6005116.63925	2102018.48994	37.752031886768705	-122.42517648553302	(37.7520318867687, -122.425176485533)
47964	47964	234371	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			35			6005338.50183	2098008.71997	37.7410345073494	-122.42412411595	(37.7410345073494, -122.42412411595)
48046	48046	194385	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6015616.39603	2115848.18198	37.7905927414207	-122.38983237995701	(37.7905927414207, -122.389832379957)
48115	48115	132100	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	15	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012551.63717	2120363.68822	37.802820809805496	-122.400753698321	(37.8028208098055, -122.400753698321)
49252	49252	233940	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	270x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			27			6004851.53435	2106800.76384	37.7651479034782	-122.426433734123	(37.7651479034782, -122.426433734123)
49479	49479	132094	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012848.0944	2119927.2949200002	37.8016391096046	-122.39969713882601	(37.8016391096046, -122.399697138826)
50014	50014	132109	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011459.50109	2121569.1071	37.8060696196846	-122.40461797546301	(37.8060696196846, -122.404617975463)
51725	51725	194333	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	9	Median : Yard 3	Tree 1	DPW 2			31	Width 8ft		6015903.377169999	2112286.3418900003	37.78082864545979	-122.38859069771999	(37.7808286454598, -122.38859069772)
53093	53093	194359	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			33	Width 8ft		6016151.3585	2114078.17293	37.785762350501706	-122.38785786627199	(37.7857623505017, -122.387857866272)
54350	54350	194294	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	49	Median : Yard 3	Tree 1	DPW 2			27			6014297.19865	2095334.47415	37.7341933303645	-122.392960907318	(37.7341933303645, -122.392960907318)
54354	54354	194291	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	41	Median : Yard 3	Tree 1	DPW 2			38			6014364.32912	2095287.3135099998	37.7340675655682	-122.39272551607701	(37.7340675655682, -122.392725516077)
55101	55101	194331	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	7	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015869.7392	2112229.4323400003	37.7806705203569	-122.388703094985	(37.7806705203569, -122.388703094985)
55186	55186	194332	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	8	Median : Yard 3	Tree 1	DPW 2			33	Width 8ft		6015905.66871	2112206.70701	37.7806101129033	-122.38857720969601	(37.7806101129033, -122.388577209696)
56517	56517	194347	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016017.18881	2113128.44937	37.783147190320896	-122.388255753298	(37.7831471903209, -122.388255753298)
56654	56654	132101	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	17	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012520.61539	2120407.16114	37.802938445615	-122.40086410632	(37.802938445615, -122.40086410632)
58200	58200	246535	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1x Octavia St	1	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6005703.308569999	2109325.61851	37.7721286642513	-122.423667182089	(37.7721286642513, -122.423667182089)
58702	58702	194289	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	38	Median : Yard 3	Tree 1	DPW 2			48			6014396.14271	2095264.76436	37.734007417094	-122.39261394888901	(37.734007417094, -122.392613948889)
59618	59618	132097	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012695.81427	2120154.0888900002	37.8022533411719	-122.400240038841	(37.8022533411719, -122.400240038841)
59677	59677	194329	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	5	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6015829.09984	2112179.7817	37.7805319384279	-122.388840220015	(37.7805319384279, -122.388840220015)
61273	61273	194336	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	12	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015966.10007	2112335.54697	37.7809672274079	-122.38837714201799	(37.7809672274079, -122.388377142018)
61369	61369	194368	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016180.02295	2114964.39899	37.7881973143891	-122.38782055336901	(37.7881973143891, -122.387820553369)
61544	61544	132098	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012646.4501	2120224.08688	37.802442786052396	-122.40041578348699	(37.8024427860524, -122.400415783487)
62222	62222	132090	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011358.77785	2121601.92287	37.8061540939119	-122.40496885853999	(37.8061540939119, -122.40496885854)
62624	62624	132132	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013567.49669	2118786.0724	37.798545661218	-122.39712759317699	(37.798545661218, -122.397127593177)
62709	62709	132071	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013261.919290001	2119233.02284	37.7997558644996	-122.39821636821199	(37.7997558644996, -122.398216368212)
63682	63682	194360	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016108.030590001	2114179.2623099997	37.786037518748	-122.388014826737	(37.786037518748, -122.388014826737)
63890	63890	234360	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			21			6005142.56045	2101579.1271	37.7508269625113	-122.425055587855	(37.7508269625113, -122.425055587855)
65398	65398	132082	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012375.04896	2120549.1986599998	37.803320325622295	-122.40137783233999	(37.8033203256223, -122.40137783234)
66065	66065	132114	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013298.81612	2119255.09608	37.799818527453105	-122.39809024008001	(37.7998185274531, -122.39809024008)
66121	66121	194352	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016055.63748	2113520.42583	37.7842255997618	-122.388150099168	(37.7842255997618, -122.388150099168)
68375	68375	234369	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			18			6005339.90624	2098058.76544	37.7411720001789	-122.42412281821899	(37.7411720001789, -122.424122818219)
68393	68393	132116	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013189.6161	2119421.22304	37.800268589579204	-122.39847977871901	(37.8002685895792, -122.398479778719)
69507	69507	132112	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011208.1934400005	2121737.88602	37.8065189965151	-122.40549956557501	(37.8065189965151, -122.405499565575)
69876	69876	194371	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016101.395269999	2115134.80634	37.7886608582508	-122.388104490939	(37.7886608582508, -122.388104490939)
70019	70019	194312	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			25	Width 7ft		6015090.90053	2116737.38808	37.7930051404365	-122.391712777831	(37.7930051404365, -122.391712777831)
70141	70141	194290	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	40	Median : Yard 3	Tree 1	DPW 2			27			6014381.3022300005	2095272.57767	37.7340280466394	-122.39266580380101	(37.7340280466394, -122.392665803801)
70221	70221	132087	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011581.4658	2121414.5973099996	37.8056521894584	-122.40418501304501	(37.8056521894584, -122.404185013045)
70483	70483	194365	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016199.77941	2114766.14566	37.7876540501504	-122.38773836074199	(37.7876540501504, -122.387738360742)
70595	70595	132088	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011509.10408	2121480.92062	37.8058302534199	-122.404440103948	(37.8058302534199, -122.404440103948)
70617	70617	132083	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012328.94165	2120621.527	37.8035163490725	-122.401542475719	(37.8035163490725, -122.401542475719)
71379	71379	234345	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			34			6005211.50018	2100294.54181	37.7473036813364	-122.424725813644	(37.7473036813364, -122.424725813644)
71598	71598	194349	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6016039.59045	2113336.99155	37.7837210414445	-122.388192810667	(37.7837210414445, -122.388192810667)
71756	71756	233939	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	270x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			32			6004850.2917	2106826.33652	37.765218049699605	-122.426439853137	(37.7652180496996, -122.426439853137)
72003	72003	194321	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			22	Width 7ft		6014800.62587	2117118.44333	37.794035312034104	-122.392743821769	(37.7940353120341, -122.392743821769)
72308	72308	233934	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			34			6004824.15396	2107326.99928	37.7665912721916	-122.42656591108101	(37.7665912721916, -122.426565911081)
73360	73360	233933	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			35			6004817.19467	2107404.1110799997	37.76680260927	-122.426595473608	(37.76680260927, -122.426595473608)
74450	74450	132131	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6013617.689669999	2118709.1573799998	37.7983372649156	-122.39694851296001	(37.7983372649156, -122.39694851296)
75574	75574	132078	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012663.130340001	2120132.51785	37.8021922897941	-122.40035162582899	(37.8021922897941, -122.400351625829)
76413	76413	194348	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016063.83562	2113121.68463	37.783131200395296	-122.388093900527	(37.7831312003953, -122.388093900527)
76527	76527	194370	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016163.96985	2115051.82185	37.788436468407	-122.387882197423	(37.788436468407, -122.387882197423)
76777	76777	132095	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012798.77066	2120004.26494	37.801847701082394	-122.39987323058901	(37.8018477010824, -122.399873230589)
94540	94540	106114	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1752X DOLORES ST	1	Median : Yard 3	Tree 1	DPW 2						6005197.0	2098194.1	37.741535528464496	-122.424626562024	(37.7415355284645, -122.424626562024)
115831	115831	132073	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013155.58738	2119398.1180000002	37.800203252927105	-122.39859590999501	(37.8002032529271, -122.398595909995)
119303	119303	194372	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016142.80175	2115153.3259099997	37.788714002784296	-122.387962522166	(37.7887140027843, -122.387962522166)
119491	119491	234348	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	550x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			33			6004955.107340001	2105017.7620200003	37.760258058393205	-122.425948567888	(37.7602580583932, -122.425948567888)
123736	123736	234368	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			21			6005333.75186	2098133.92444	37.7413780222889	-122.42414944174	(37.7413780222889, -122.42414944174)
127243	127243	194363	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6016134.25394	2114462.08003	37.7868155249754	-122.387943842344	(37.7868155249754, -122.387943842344)

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