Street_Tree_List

Data source: data.sfgov.org

884 rows where qSpecies = 100 sorted by TreeID descending

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, qSiteInfo, qCaretaker, PlantDate, PermitNotes

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22831	22831	251116	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	20	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
22839	22839	251114	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	16	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
22824	22824	251112	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	14	Median : 22	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
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
22832	22832	251108	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	2	Median : Yard 3	Tree 1	DPW 2
171600	171600	248622	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	142x McCoppin St	2	Median : Cutout 11	Tree 1	DPW 2			26	Width 0ft		6005746.1935	2109104.2775	37.7715233357229	-122.423503100629	(37.7715233357229, -122.423503100629)
148059	148059	248621	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	132x McCoppin St	1	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6005771.7237	2109102.262	37.7715192426118	-122.42341464686501	(37.7715192426118, -122.423414646865)
38993	38993	248619	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1801x Market St	1	Median : Cutout 11	Tree 1	DPW 2			25	Width 0ft		6005765.0052	2109117.0426	37.7715594473913	-122.42343893750099	(37.7715594473913, -122.423438937501)
176298	176298	247642	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	632 Banks St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 4ft		6008490.96565	2095907.56445	37.7354426820387	-122.41307547425501	(37.7354426820387, -122.413075474255)
181931	181931	247638	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	360 Bradford St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			6009465.98098	2096572.55437	37.7373232876386	-122.40975139021499	(37.7373232876386, -122.409751390215)
32528	32528	247549	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	815 Buena Vista Ave West	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32	Width 2ft		6000106.41756	2108406.30035	37.7692869261681	-122.44296119951099	(37.7692869261681, -122.442961199511)
76588	76588	247039	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	574 Valley St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 6ft		6002246.4280199995	2099186.76685	37.7440940809725	-122.43489959305	(37.7440940809725, -122.43489959305)
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)
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)
135557	135557	246409	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2190x Market St	2	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6003700.7355	2107248.5843	37.7663123894934	-122.43044602180001	(37.7663123894934, -122.4304460218)
182459	182459	246404	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2000x Market St	3	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6004606.9445	2108108.5245	37.7687248704296	-122.427372879895	(37.7687248704296, -122.427372879895)
64559	64559	246403	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2000x Market St	2	Median : Cutout 11	Tree 1	DPW 2			25	Width 0ft		6004628.6575	2108127.683	37.7687787030374	-122.427299141169	(37.7687787030374, -122.427299141169)
36176	36176	246402	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2000x Market St	1	Median : Cutout 11	Tree 1	DPW 2			30	Width 0ft		6004659.311000001	2108158.3365	37.7688646036969	-122.42719529666901	(37.7688646036969, -122.427195296669)
136243	136243	246359	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2150x Market St	2	Median : Cutout 11	Tree 1	DPW 2			26	Width 0ft		6003779.011	2107326.8598	37.766531748826	-122.430180866432	(37.766531748826, -122.430180866432)
178250	178250	246357	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2100x Market St	4	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6003963.462	2107490.3857	37.7669911968193	-122.429554546796	(37.7669911968193, -122.429554546796)
181978	181978	246356	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2100x Market St	3	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6003986.7122	2107511.3108	37.7670499684983	-122.429475620431	(37.7670499684983, -122.429475620431)
24559	24559	246349	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2190x Market St	1	Median : Cutout 11	Tree 1	DPW 2			31	Width 0ft		6003723.2107	2107266.4094	37.766362606026796	-122.430369556243	(37.7663626060268, -122.430369556243)
54798	54798	246348	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2150x Market St	1	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6003809.2361	2107348.5599	37.766593043924	-122.430077871393	(37.766593043924, -122.430077871393)
132737	132737	246343	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2020x Market St	5	Median : Cutout 11	Tree 1	DPW 2			26	Width 0ft		6004317.012999999	2107828.8108	37.767940442417604	-122.428355792358	(37.7679404424176, -122.428355792358)
25198	25198	246342	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2020x Market St	4	Median : Cutout 11	Tree 1	DPW 2			30	Width 0ft		6004356.6072	2107872.2367	37.7680619198287	-122.42822193571301	(37.7680619198287, -122.428221935713)
76295	76295	246340	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	2020x Market St	6	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6004296.5773	2107812.2068	37.767893695460295	-122.428425293549	(37.7678936954603, -122.428425293549)
172817	172817	245965	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1950x Market St	3	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6005023.4835	2108512.8969	37.7698587289196	-122.425960891085	(37.7698587289196, -122.425960891085)
170480	170480	245964	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1950x Market St	2	Median : Cutout 11	Tree 1	DPW 2			25	Width 0ft		6005048.2837	2108538.5237	37.7699304954931	-122.42587693213301	(37.7699304954931, -122.425876932133)
172221	172221	245963	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1950x Market St	1	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6005062.3371	2108554.2304	37.7699744164919	-122.425829439833	(37.7699744164919, -122.425829439833)
72198	72198	245079	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	154 Baker St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			38	Width 0ft		6000824.0394	2109520.8819	37.7723881764486	-122.440558941181	(37.7723881764486, -122.440558941181)
181231	181231	234403	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	175 Valencia St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 6ft		6006066.151819999	2108969.9418900004	37.771172536524794	-122.42238679931101	(37.7711725365248, -122.422386799311)
177164	177164	234402	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	667 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 3ft		6002514.48058	2108813.7305400004	37.7705426279609	-122.434660977745	(37.7705426279609, -122.434660977745)
171635	171635	234401	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	3899 19th St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 3ft		6003740.055819999	2104771.47672	37.75951307439	-122.430133288745	(37.75951307439, -122.430133288745)
174148	174148	234400	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	4 Corwin St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43	Width 3ft		6001132.8816599995	2103964.26051	37.7571486461001	-122.439092314277	(37.7571486461001, -122.439092314277)
35925	35925	234399	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	319 Virginia Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 3ft		6006918.01461	2098154.19018	37.7415229912067	-122.418673038125	(37.7415229912067, -122.418673038125)
54411	54411	234398	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	3980 22nd St	8	: 4	Tree 1	Private 1			32			6001905.073469999	2102956.38941	37.7544251823875	-122.436349651817	(37.7544251823875, -122.436349651817)
132990	132990	234397	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	3932 22nd St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			25	Width 4ft		6002267.50929	2102984.90864	37.7545240763369	-122.435098296447	(37.7545240763369, -122.435098296447)
39811	39811	234396	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1351 Douglass St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 6ft		6001401.68154	2099734.75899	37.74555073898829	-122.43785977451701	(37.7455507389883, -122.437859774517)
58910	58910	234395	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	217 Ogden Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		6008499.5527	2096078.48845	37.735912484272205	-122.413057867339	(37.7359124842722, -122.413057867339)
182456	182456	234394	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1350 Noe St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30			6003187.2989	2100371.4904099996	37.7474004312881	-122.431730842629	(37.7474004312881, -122.431730842629)
163198	163198	234393	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1557 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003994.29589	2099192.81462	37.7442097715744	-122.42885628561001	(37.7442097715744, -122.42885628561)
185824	185824	234392	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1379 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 7ft		6005257.78896	2100266.47383	37.7472292273428	-122.424563754022	(37.7472292273428, -122.424563754022)
174857	174857	234391	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1600 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 6ft		6005241.74432	2098978.16752	37.743690926593295	-122.424527610268	(37.7436909265933, -122.424527610268)
23789	23789	234390	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1600 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 6ft		6005245.617219999	2098983.50062	37.7437057887861	-122.42451459797199	(37.7437057887861, -122.424514597972)
54191	54191	234389	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1488 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			26	Width 6ft		6005200.95707	2099699.7446	37.7456699090375	-122.424719964457	(37.7456699090375, -122.424719964457)
132845	132845	234388	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1069 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	Width 5ft		6005149.23502	2102137.71701	37.7523610979942	-122.425072246905	(37.7523610979942, -122.425072246905)
55136	55136	234387	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	986 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6005043.99676	2102621.6014400003	37.7536837866767	-122.425470611492	(37.7536837866767, -122.425470611492)
32517	32517	234386	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	800 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6004984.24145	2103652.12046	37.7565099745835	-122.42575060280899	(37.7565099745835, -122.425750602809)
170283	170283	234385	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	384 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004737.93375	2109866.7423400003	37.773559918201606	-122.427045042888	(37.7735599182016, -122.427045042888)
63620	63620	234384	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	899 Hampshire St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		6010216.7904900005	2104076.88773	37.757970587791	-122.407684453188	(37.757970587791, -122.407684453188)
158189	158189	234383	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	3483 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005156.87556	2103096.1087599997	37.7549930502992	-122.425114011399	(37.7549930502992, -122.425114011399)
60454	60454	234382	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	2624 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6010280.44455	2103423.11774	37.7561790447523	-122.40741821967501	(37.7561790447523, -122.407418219675)
173622	173622	234381	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	200 Eugenia Ave	2	Front Yard : Yard 7	Tree 1	Private 1			10			6006554.5281	2098105.53483	37.74136892295	-122.41992640079599	(37.74136892295, -122.419926400796)
149367	149367	234380	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1001 San Jose Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		6005142.82168	2096774.43039	37.7376343766353	-122.424712922782	(37.7376343766353, -122.424712922782)
176009	176009	234379	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	246 Bemis St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39			6003018.34772	2096316.7253	37.736257406663704	-122.432025563025	(37.7362574066637, -122.432025563025)
26354	26354	234378	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1 Bird St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			37	Width 5ft		6005998.07456	2105729.78745	37.7622720010628	-122.42239202167299	(37.7622720010628, -122.422392021673)
70062	70062	234377	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1750 Harrison St	3	: 4	Tree 1	Private 1			3	Width 2ft		6008587.9096	2108086.3181	37.768888242332004	-122.413601406792	(37.768888242332, -122.413601406792)
23714	23714	234376	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1750 Harrison St	2	: 4	Tree 1	Private 1			6	Width 2ft		6008587.75214	2108113.66978	37.7689633348285	-122.41360388622499	(37.7689633348285, -122.413603886225)
159189	159189	234375	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	581 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 9ft		6004995.06327	2105009.72546	37.760238249920604	-122.425809806971	(37.7602382499206, -122.425809806971)
39479	39479	234374	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	581 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 9ft		6004996.87402	2105008.5457599997	37.760235113069896	-122.425803460464	(37.7602351130699, -122.425803460464)
179975	179975	234373	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	581 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 9ft		6004999.25531	2105001.6441599997	37.76021629747461	-122.42579473344401	(37.7602162974746, -122.425794733444)
188102	188102	234372	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	3782 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			32	Width 3ft		6005314.45638	2100807.30331	37.74871742098671	-122.424406263843	(37.7487174209867, -122.424406263843)
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)
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)
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)
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)
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)
149136	149136	234366	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	9 Duncan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006381.599330001	2099941.08815	37.746399194477206	-122.420654601644	(37.7463991944772, -122.420654601644)
158301	158301	234365	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005150.81264	2101423.31762	37.7503996118641	-122.425015966416	(37.7503996118641, -122.425015966416)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
133800	133800	234346	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005214.83803	2100265.33674	37.74722367943539	-122.424712194312	(37.7472236794354, -122.424712194312)
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)
42292	42292	234344	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	751 Dolores St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		6005051.924	2103931.9938	37.757282265587	-122.42553644996299	(37.757282265587, -122.425536449963)
137503	137503	234343	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	769 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 7ft		6005056.066269999	2103868.0427200003	37.7571069049763	-122.42551757317601	(37.7571069049763, -122.425517573176)
72691	72691	234342	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	500 Dolores St	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 6ft		6004943.9168300005	2104413.64545	37.7585986644128	-122.425944266413	(37.7585986644128, -122.425944266413)
72122	72122	234341	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	420 Dolores St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			35	Width 3ft		6004869.93402	2105476.5468200003	37.7615129588681	-122.42627580688401	(37.7615129588681, -122.426275806884)
181869	181869	234340	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	420 Dolores St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			39	Width 3ft		6004869.08955	2105489.95301	37.7615497213531	-122.42627968206499	(37.7615497213531, -122.426279682065)
25705	25705	234339	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	420 Dolores St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 3ft		6004868.93824	2105500.74139	37.7615793351331	-122.426280973507	(37.7615793351331, -122.426280973507)
44771	44771	234338	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	420 Dolores St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			37	Width 3ft		6004867.72819	2105514.5268599996	37.761617118366104	-122.42628614009199	(37.7616171183661, -122.426286140092)

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