Street_Tree_List

Data source: data.sfgov.org

195 rows where qSiteInfo = 3 and qSpecies = 100 sorted by SiteOrder

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
131405	131405	194320	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			23	Width 7ft		6014831.89764	2117081.36813	37.7939352489635	-122.392633022622	(37.7939352489635, -122.392633022622)
133649	133649	234347	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	550x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			28			6004944.62757	2105117.25917	37.760530661773	-122.425991895418	(37.760530661773, -122.425991895418)
134092	134092	194378	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6015852.133669999	2115594.9283	37.7899104347693	-122.388999044794	(37.7899104347693, -122.388999044794)
152768	152768	194354	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6016129.928040001	2113821.08982	37.7850552711313	-122.387914064893	(37.7850552711313, -122.387914064893)
156879	156879	233941	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	370x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			32			6004887.91201	2106172.4684599997	37.7634248105293	-122.426263176805	(37.7634248105293, -122.426263176805)
161954	161954	234349	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			29			6004962.28051	2104795.65924	37.7596486220069	-122.42590794909599	(37.7596486220069, -122.425907949096)
164848	164848	234326	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			27			6005043.60607	2103360.12702	37.755711583428294	-122.425524518639	(37.7557115834283, -122.425524518639)
166867	166867	132106	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011673.52168	2121373.1691	37.8055435810345	-122.40386352159099	(37.8055435810345, -122.403863521591)
22832	22832	251108	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	2	Median : Yard 3	Tree 1	DPW 2
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)
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)
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)
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)
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)
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)
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)
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)
133391	133391	194310	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015149.43028	2116672.0498900004	37.7928289857212	-122.39150569005301	(37.7928289857212, -122.391505690053)
137727	137727	246536	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1x Octavia St	2	Median : Yard 3	Tree 1	DPW 2			31	Width 8ft		6005696.49055	2109344.97624	37.7721814310539	-122.42369214280501	(37.7721814310539, -122.423692142805)
147393	147393	194355	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016135.3126300005	2113894.74213	37.785257802049706	-122.38790057687001	(37.7852578020497, -122.38790057687)
153490	153490	132085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012153.585109999	2120867.04559	37.8041806971541	-122.402166580042	(37.8041806971541, -122.402166580042)
157237	157237	234355	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			27			6004978.4588	2104465.76881	37.7587437349524	-122.425828514675	(37.7587437349524, -122.425828514675)
162596	162596	194326	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	2	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015764.48229	2112042.08861	37.7801502823482	-122.38905414805599	(37.7801502823482, -122.389054148056)
164800	164800	233942	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	450x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			35			6004917.83694	2105642.84744	37.7619722884988	-122.426121969753	(37.7619722884988, -122.426121969753)
165757	165757	234350	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			25			6004963.57632	2104757.16703	37.759543004714	-122.425900727537	(37.759543004714, -122.425900727537)
177459	177459	132104	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			19	Width 10ft		6012041.8343	2121038.82925	37.8046461349625	-122.402565391602	(37.8046461349625, -122.402565391602)
182277	182277	194342	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016043.56926	2112825.74631	37.7823174973895	-122.38814335514999	(37.7823174973895, -122.38814335515)
182641	182641	233932	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			24			6004814.58298	2107439.6885599997	37.7669001488458	-122.426607040704	(37.7669001488458, -122.426607040704)
186566	186566	132093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012902.31977	2119848.32419	37.8014252975988	-122.39950394556699	(37.8014252975988, -122.399503945567)
22825	22825	251109	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	3	Median : Yard 3	Tree 1	DPW 2
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)
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)
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)
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)
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)
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)
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)
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)
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)
136050	136050	132086	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011972.21269	2121045.33445	37.8046601095467	-122.402806783124	(37.8046601095467, -122.402806783124)
138222	138222	194356	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016092.96172	2113985.53296	37.7855047469016	-122.38805343733401	(37.7855047469016, -122.388053437334)
154721	154721	234361	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			27			6005142.97819	2101556.59196	37.75076510982829	-122.42505254004699	(37.7507651098283, -122.425052540047)
156409	156409	194327	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	3	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6015782.92624	2112129.67425	37.780391795274	-122.388996458319	(37.780391795274, -122.388996458319)
157962	157962	194366	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016195.859569999	2114866.22772	37.78792863564279	-122.387758908461	(37.7879286356428, -122.387758908461)
174328	174328	234327	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			29			6005045.03345	2103276.5066400003	37.755482062073604	-122.425513631455	(37.7554820620736, -122.425513631455)
177827	177827	234351	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			30			6004966.99113	2104720.1905900002	37.759441669116796	-122.425886285347	(37.7594416691168, -122.425886285347)
182110	182110	194322	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			22	Width 7ft		6014773.3420400005	2117151.64182	37.7941249519603	-122.392840551058	(37.7941249519603, -122.392840551058)
182470	182470	132107	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011604.73213	2121437.1460700002	37.805715402812204	-122.40410608402901	(37.8057154028122, -122.404106084029)
182585	182585	194343	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016001.634319999	2112937.23784	37.7826213045779	-122.38829621649799	(37.7826213045779, -122.388296216498)
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)
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)
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)
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)
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)
130698	130698	234352	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			45			6004969.77736	2104678.02917	37.7593260612613	-122.425873648056	(37.7593260612613, -122.425873648056)
148964	148964	234370	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			35			6005335.592730001	2098044.06455	37.7411313913144	-122.42413668757	(37.7411313913144, -122.42413668757)
153149	153149	194381	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6015827.50848	2115690.11268	37.79017042428	-122.389090895237	(37.79017042428, -122.389090895237)
153572	153572	194344	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016049.59347	2112931.0937900003	37.7826070916921	-122.38812986802	(37.7826070916921, -122.38812986802)
158245	158245	194357	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x King St	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016143.59514	2113983.21728	37.7855011936686	-122.387878097405	(37.7855011936686, -122.387878097405)
164090	164090	194328	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	4	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6015816.38649	2112097.21372	37.7803045205874	-122.388878435804	(37.7803045205874, -122.388878435804)
167096	167096	234328	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			23			6005051.1738	2103243.46642	37.7553916882954	-122.425490044948	(37.7553916882954, -122.425490044948)
168474	168474	132105	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012001.46692	2121074.30881	37.8047412994387	-122.402707584299	(37.8047412994387, -122.402707584299)
170250	170250	233938	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			33			6004845.02149	2106914.0966	37.7654587199743	-122.426464330874	(37.7654587199743, -122.426464330874)
171516	171516	194323	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			15	Width 7ft		6014746.37404	2117187.8708099998	37.7942229303951	-122.39293639989201	(37.7942229303951, -122.392936399892)
178718	178718	194367	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016138.88729	2114959.31506	37.7881810762396	-122.38796252216999	(37.7881810762396, -122.38796252217)
179789	179789	234357	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			24			6004986.096919999	2104380.3629099997	37.758509662101204	-122.425796019476	(37.7585096621012, -122.425796019476)
22823	22823	251110	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	5	Median : Yard 3	Tree 1	DPW 2
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)
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)
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)
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)
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)
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)
131012	131012	234358	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			23			6004991.05597	2104342.31446	37.7584054702508	-122.425776160656	(37.7584054702508, -122.425776160656)
133036	133036	132072	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013209.184309999	2119314.66631	37.799977100409	-122.39840458371201	(37.799977100409, -122.398404583712)
151204	151204	234363	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			25			6005145.85028	2101496.26634	37.7505996318694	-122.425038316369	(37.7505996318694, -122.425038316369)
163146	163146	194345	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016011.38638	2113034.09815	37.7828878015789	-122.388269240457	(37.7828878015789, -122.388269240457)
164266	164266	132076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012766.891340001	2119978.53875	37.8017752858665	-122.399981740966	(37.8017752858665, -122.399981740966)
170290	170290	194382	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6015730.53426	2115716.1031299997	37.7902364120368	-122.389428237241	(37.7902364120368, -122.389428237241)
176923	176923	132084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012274.61558	2120706.35336	37.8037462301721	-122.401736440606	(37.8037462301721, -122.401736440606)
181994	181994	132108	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011532.668269999	2121506.48507	37.8059017639302	-122.404360356561	(37.8059017639302, -122.404360356561)
182038	182038	234353	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			22			6004972.999969999	2104631.70012	37.7591990347337	-122.425859204936	(37.7591990347337, -122.425859204936)
183458	183458	194358	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016102.75205	2114084.3299	37.7857765633769	-122.388026462162	(37.7857765633769, -122.388026462162)
187874	187874	194313	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			12	Width 7ft		6015116.8381	2116756.98357	37.793060384871	-122.391624402345	(37.793060384871, -122.391624402345)
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)
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)
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)
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)
130735	130735	194346	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016057.40985	2113028.64004	37.782875364847705	-122.388109635977	(37.7828753648477, -122.388109635977)
132937	132937	234364	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			23			6005148.136969999	2101464.62312	37.7505128760752	-122.425028157637	(37.7505128760752, -122.425028157637)

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