Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
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)
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)
137882	137882	132117	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6013132.776319999	2119506.7755299998	37.800500329583	-122.398682475136	(37.800500329583, -122.398682475136)
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)
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)
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)
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)
138553	138553	116529	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	745X SANCHEZ ST	6	Median : Yard 3	Tree 1	DPW 2			18			6003713.0	2103768.0	37.7567562336472	-122.430155272915	(37.7567562336472, -122.430155272915)
174052	174052	194319	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			19	Width 7ft		6014937.91263	2116957.6212	37.793601355862705	-122.392257538577	(37.7936013558627, -122.392257538577)
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)
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)
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)
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)
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)
131771	131771	132074	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013098.86351	2119482.52775	37.800431861502396	-122.39879812525601	(37.8004318615024, -122.398798125256)
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)
135157	135157	132081	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	16	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012501.69351	2120366.8481099997	37.802826700352995	-122.400926752172	(37.802826700353, -122.400926752172)
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)
136668	136668	194314	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015030.092180001	2116803.1524	37.793182338337296	-122.39192778056601	(37.7931823383373, -122.391927780566)
152917	152917	194273	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Tennessee St	16	Median : Yard 3	Tree 1	DPW 2			20	Width 8ft		6015573.17514	2103426.7647700002	37.7564838780418	-122.38911425333	(37.7564838780418, -122.38911425333)
160227	160227	194315	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015053.743430001	2116822.79374	37.793237581902105	-122.391847319118	(37.7932375819021, -122.391847319118)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
150555	150555	132096	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012742.85934	2120080.46122	37.8020538004962	-122.400072065282	(37.8020538004962, -122.400072065282)
173586	173586	194339	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	15	Median : Yard 3	Tree 1	DPW 2			21	Width 8ft		6015964.49017	2112481.16819	37.781366981449295	-122.388392878343	(37.7813669814493, -122.388392878343)
176286	176286	132079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012611.87531	2120208.19637	37.8023972264213	-122.40053431322399	(37.8023972264213, -122.400534313224)
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)
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)
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)
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)
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)
129992	129992	132099	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	14	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012592.45443	2120302.68635	37.8026555899447	-122.40060816104099	(37.8026555899447, -122.400608161041)
149311	149311	132111	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011290.22315	2121683.26622	37.806373610322105	-122.40521183646999	(37.8063736103221, -122.40521183647)
162235	162235	194317	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			22	Width 7ft		6014996.79198	2116890.75749	37.7934210328094	-122.392049131461	(37.7934210328094, -122.392049131461)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
147998	147998	132115	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013243.85901	2119336.7003900004	37.8000395322586	-122.398286142085	(37.8000395322586, -122.398286142085)
150698	150698	234330	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	900x Dolores St	15	Median : Yard 3	Tree 1	DPW 2			23			6005083.062580001	2102603.58555	37.7536365264144	-122.42533423108699	(37.7536365264144, -122.425334231087)
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)
155474	155474	132089	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011437.6783	2121540.455	37.805989728403894	-122.404691478852	(37.8059897284039, -122.404691478852)
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)
168748	168748	132110	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011374.63029	2121626.67271	37.8062229369941	-122.404915741893	(37.8062229369941, -122.404915741893)
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)
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)
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)
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)
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)
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)
135993	135993	132130	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013704.00439	2118650.24995	37.79818032331121	-122.39664570406099	(37.7981803233112, -122.396645704061)
152011	152011	194318	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			24	Width 7ft		6014918.376630001	2116934.10067	37.7935356891802	-122.392323489462	(37.7935356891802, -122.392323489462)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
148681	148681	194369	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016121.084980001	2115040.32123	37.7884025145026	-122.388029770758	(37.7884025145026, -122.388029770758)
155521	155521	194340	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	16	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6015972.31673	2112547.01001	37.7815482020175	-122.388370398867	(37.7815482020175, -122.388370398867)
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)
182808	182808	194353	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016057.99648	2113605.1395799997	37.7844583353237	-122.388147851742	(37.7844583353237, -122.388147851742)

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