Street_Tree_List

Data source: data.sfgov.org

166 rows where PlotSize = "Width 5ft" and qSiteInfo = 4

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
2241	2241	193105	Permitted Site 1	Magnolia grandiflora :: Southern Magnolia 21	1649 Palou Ave	1	: 4	Tree 1	Private 1		10/28/1996 12:00:00 AM	10	Width 5ft		6014582.89152	2095437.7386599998	37.734492738953	-122.39198038730301	(37.734492738953, -122.391980387303)
2381	2381	201818	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	2	: 4	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 5ft		6021088.08179	2093322.4173400002	37.7290434795636	-122.369343396492	(37.7290434795636, -122.369343396492)
2409	2409	201824	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	8	: 4	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 5ft		6021004.603680001	2093212.5880900002	37.728737329640495	-122.369624404053	(37.7287373296405, -122.369624404053)
2410	2410	201817	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	1	: 4	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 5ft		6021101.98762	2093338.62944	37.7290887577236	-122.36929644199101	(37.7290887577236, -122.369296441991)
2438	2438	201823	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	7	: 4	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 5ft		6021023.85438	2093233.10906	37.728794732485206	-122.369559269737	(37.7287947324852, -122.369559269737)
23814	23814	247646	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	2	: 4	Tree 1	Private 1			13	Width 5ft		6001616.30949	2108303.20625	37.769089824469496	-122.43773118404499	(37.7690898244695, -122.437731184045)
23951	23951	222885	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Valencia St	3	: 4	Tree 1	Private 1			18	Width 5ft		6006051.02822	2109339.24494	37.7721857010308	-122.422465357814	(37.7721857010308, -122.422465357814)
24000	24000	246500	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	273 Duncan St	1	: 4	Tree 1	Private 1			10	Width 5ft		6004745.35521	2099854.76299	37.746069811469	-122.426306403626	(37.746069811469, -122.426306403626)
24550	24550	200288	Undocumented 2	Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328	450 Texas St	6	: 4	Tree 1	Private 1			2	Width 5ft		6013765.39611	2104962.6941	37.7606008277911	-122.39547383976499	(37.7606008277911, -122.395473839765)
25127	25127	200366	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1300 Phelps St	8	: 4	Tree 1	Private 1			12	Width 5ft		6014047.106269999	2096372.4575200002	37.7370295240776	-122.393898196954	(37.7370295240776, -122.393898196954)
25976	25976	190714	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	375 Texas St	2	: 4	Tree 1	Private 1			4	Width 5ft		6013800.48111	2105372.99908	37.761729387017496	-122.39538124017099	(37.7617293870175, -122.395381240171)
26368	26368	137075	Undocumented 2	Ulmus pumila :: Siberian Elm 53	689 Hayes St	1	: 4	Tree 1	Private 1			24	Width 5ft		6004617.552730001	2110839.21576	37.776223284701	-122.42753075415001	(37.776223284701, -122.42753075415)
27058	27058	247653	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	9	: 4	Tree 1	Private 1			15	Width 5ft		6001528.81511	2108296.30035	37.7690658872209	-122.438033326596	(37.7690658872209, -122.438033326596)
28662	28662	247652	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	8	: 4	Tree 1	Private 1			14	Width 5ft		6001539.54665	2108297.82153	37.7690706742937	-122.437996315894	(37.7690706742937, -122.437996315894)
29477	29477	188598	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1050 Wisconsin St	4	: 4	Tree 1	Private 1			18	Width 5ft		6012781.12633	2102535.65122	37.7538819037331	-122.398707676819	(37.7538819037331, -122.398707676819)
30049	30049	222884	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Valencia St	1	: 4	Tree 1	Private 1			18	Width 5ft		6006058.1722800005	2109199.11331	37.7718013362	-122.422430687153	(37.7718013362, -122.422430687153)
30483	30483	187888	Undocumented 2	Acer rubrum :: Red Maple 6	1799 Indiana St	1	: 4	Tree 1	Private 1			3	Width 5ft		6015216.20725	2100273.8122	37.747806741405	-122.390128525805	(37.747806741405, -122.390128525805)
31009	31009	201796	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	1	: 4	Tree 1	Private 1			2	Width 5ft		6021152.60745	2092710.04539	37.727365560462395	-122.369078036218	(37.7273655604624, -122.369078036218)
31138	31138	249446	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1050 Ellis St	6	: 4	Tree 1	Private 1			21	Width 5ft		6005679.55916	2113469.5737	37.7835056151439	-122.424044078095	(37.7835056151439, -122.424044078095)
32042	32042	247704	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	824 Waller St	1	: 4	Tree 1	Private 1			16	Width 5ft		6001711.33695	2108752.8722599996	37.7703298987379	-122.43743469466101	(37.7703298987379, -122.437434694661)
33094	33094	189778	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	800 Wisconsin St	10	: 4	Tree 1	Private 1			32	Width 5ft		6012724.71744	2103552.97155	37.7566721007586	-122.39897415133001	(37.7566721007586, -122.39897415133)
33953	33953	247763	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	55 Alpine Ter	1	: 4	Tree 1	Private 1			1	Width 5ft		6001651.1462	2108480.6901700003	37.769579132108205	-122.43762339851101	(37.7695791321082, -122.437623398511)
35914	35914	196425	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	282 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011155.7597199995	2111427.64984	37.778206627062296	-122.404954631245	(37.7782066270623, -122.404954631245)
36083	36083	250018	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Peter Yorke Way	7	: 4	Tree 1	Private 1			11	Width 5ft		6005787.19276	2114383.50511	37.7860211214227	-122.42373671138701	(37.7860211214227, -122.423736711387)
36914	36914	247654	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	10	: 4	Tree 1	Private 1			15	Width 5ft		6001517.12711	2108295.57391	37.7690632279012	-122.438073702561	(37.7690632279012, -122.438073702561)
37013	37013	245824	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 McCoppin St	1	: 4	Tree 1	Private 1			35	Width 5ft		6006487.65936	2109176.30964	37.7717629414288	-122.42094344050899	(37.7717629414288, -122.420943440509)
37030	37030	250127	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	1798 Pine St	4	: 4	Tree 1	Private 1			22	Width 5ft		6005361.6989	2115505.86135	37.789078803778295	-122.425288702018	(37.7890788037783, -122.425288702018)
38034	38034	188335	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1490 19th St	2	: 4	Tree 1	Private 1			12	Width 5ft		6013335.43042	2105239.42727	37.761336752	-122.396980309397	(37.761336752, -122.396980309397)
39915	39915	246480	Undocumented 2	Maytenus boaria :: Mayten 22	328 Duncan St	1	: 4	Tree 1	Private 1			11	Width 5ft		6004200.75459	2099871.69589	37.7460855064407	-122.428190768384	(37.7460855064407, -122.428190768384)
40309	40309	188704	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	85 Bay View St	1	: 4	Tree 1	Private 1			31	Width 5ft		6013901.34741	2094806.9299400002	37.7327228057098	-122.394292577538	(37.7327228057098, -122.394292577538)
40505	40505	247725	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	2	: 4	Tree 1	Private 1			19	Width 5ft		6001330.00617	2108965.19653	37.770891201597706	-122.43876893155701	(37.7708912015977, -122.438768931557)
40642	40642	201160	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1601 Evans Ave	11	: 4	Tree 1	Private 1			11	Width 5ft		6014894.50289	2099040.33267	37.7444020160542	-122.391154767399	(37.7444020160542, -122.391154767399)
42190	42190	247167	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	165 Buena Vista Ave East	1	: 4	Tree 1	Private 1			2	Width 5ft		6001410.43001	2108421.56043	37.7694030871159	-122.43845178832301	(37.7694030871159, -122.438451788323)
42453	42453	247157	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	3998 17th St	1	: 4	Tree 1	Private 1			16	Width 5ft		6002464.12028	2105916.1439900002	37.762583705195105	-122.43462795013599	(37.7625837051951, -122.434627950136)
42788	42788	246481	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	330 Duncan St	1	: 4	Tree 1	Private 1			10	Width 5ft		6004176.06205	2099871.25195	37.74608289033021	-122.42827612036301	(37.7460828903302, -122.428276120363)
43387	43387	247655	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	11	: 4	Tree 1	Private 1			14	Width 5ft		6001504.48718	2108295.83572	37.769063227919105	-122.43811744198601	(37.7690632279191, -122.438117441986)
43715	43715	250016	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1250 Geary Blvd	2	: 4	Tree 1	Private 1			12	Width 5ft		6005727.9579	2114178.12622	37.785453857856396	-122.42392703849701	(37.7854538578564, -122.423927038497)
43783	43783	191833	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1900 Jerrold Ave	1	: 4	Tree 1	Private 1			27	Width 5ft		6013734.98018	2098203.9555900004	37.74204108523121	-122.395105613257	(37.7420410852312, -122.395105613257)
43967	43967	221664	Undocumented 2	Acer palmatum :: Japanese Maple 175	65 McCoppin St	1	: 4	Tree 1	Private 1			1	Width 5ft		6006280.59621	2109108.9089099998	37.771566201261294	-122.421654898657	(37.7715662012613, -122.421654898657)
45365	45365	201527	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	740 Earl St	4	: 4	Tree 1	Private 1			6	Width 5ft		6020341.20189	2093704.82943	37.730052512603294	-122.371951898056	(37.7300525126033, -122.371951898056)
45529	45529	200360	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1150 Phelps St	5	: 4	Tree 1	Private 1			6	Width 5ft		6014196.6239	2096573.2462900002	37.737589156904995	-122.393395290662	(37.737589156905, -122.393395290662)
46141	46141	200359	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1150 Phelps St	4	: 4	Tree 1	Private 1			9	Width 5ft		6014213.143619999	2096595.32013	37.737650684936796	-122.393339717964	(37.7376506849368, -122.393339717964)
48234	48234	196302	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	271 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011407.60626	2111629.45684	37.7787748169373	-122.404097603449	(37.7787748169373, -122.404097603449)
48663	48663	247726	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	3	: 4	Tree 1	Private 1			20	Width 5ft		6001333.54559	2108953.84659	37.770860238851	-122.438755875203	(37.770860238851, -122.438755875203)
49941	49941	200294	Undocumented 2	Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328	450 Texas St	13	: 4	Tree 1	Private 1			2	Width 5ft		6013773.031280001	2104844.74935	37.7602774019102	-122.395439169982	(37.7602774019102, -122.395439169982)
51493	51493	201801	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	6	: 4	Tree 1	Private 1			2	Width 5ft		6020978.953509999	2092836.83628	37.7277041785835	-122.369687123669	(37.7277041785835, -122.369687123669)
51993	51993	201805	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	10	: 4	Tree 1	Private 1			2	Width 5ft		6020879.60636	2092912.55986	37.727906650163	-122.37003580431801	(37.727906650163, -122.370035804318)
52097	52097	201804	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	9	: 4	Tree 1	Private 1			2	Width 5ft		6020904.74927	2092892.98725	37.7278542871344	-122.369947531359	(37.7278542871344, -122.369947531359)
52425	52425	247649	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	5	: 4	Tree 1	Private 1			14	Width 5ft		6001576.55462	2108299.96127	37.7690786539981	-122.437868461073	(37.7690786539981, -122.437868461073)
52799	52799	192306	Undocumented 2	Fraxinus spp :: Ash Spp 83	3600 03rd St	4	: 4	Tree 1	Private 1			21	Width 5ft		6015896.02327	2098855.55467	37.74395018136929	-122.38767879773701	(37.7439501813693, -122.387678797737)
55370	55370	201806	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	11	: 4	Tree 1	Private 1			2	Width 5ft		6020862.09511	2092930.7088400002	37.727955522906605	-122.37009759584998	(37.7279555229066, -122.37009759585)
56231	56231	228455	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	7	: 4	Tree 1	Private 1			1	Width 5ft		6009383.67351	2106374.02164	37.7642313225287	-122.410727961341	(37.7642313225287, -122.410727961341)
56871	56871	194048	Undocumented 2	Myoporum laetum :: Myoporum 1	1242 19th St	1	: 4	Tree 1	Private 1			33	Width 5ft		6013830.06416	2105268.62635	37.761444447624	-122.395271611894	(37.761444447624, -122.395271611894)
57920	57920	228456	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	8	: 4	Tree 1	Private 1			1	Width 5ft		6009403.2734199995	2106375.12773	37.7642354585115	-122.410660248687	(37.7642354585115, -122.410660248687)
57963	57963	200352	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	900 Phelps St	16	: 4	Tree 1	Private 1			14	Width 5ft		6014405.80816	2096853.92235	37.7383714555731	-122.392691664697	(37.7383714555731, -122.392691664697)
58185	58185	234552	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	599 Buchanan St	1	: 4	Tree 1	Private 1			17	Width 5ft		6004546.97055	2110414.43601	37.775052951057	-122.42774464441999	(37.775052951057, -122.42774464442)
58259	58259	241644	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	415 Oak St	1	: 4	Tree 1	Private 1			5	Width 5ft		6004982.83626	2110199.4621900003	37.774487331444895	-122.426221580476	(37.7744873314449, -122.426221580476)
58779	58779	189417	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1106 Wisconsin St	7	: 4	Tree 1	Private 1			16	Width 5ft		6012797.40104	2102195.19485	37.7529479910798	-122.39862750496799	(37.7529479910798, -122.398627504968)
59473	59473	246492	Undocumented 2	Maytenus boaria :: Mayten 22	377 Duncan St	1	: 4	Tree 1	Private 1			12	Width 5ft		6004118.95016	2099820.41125	37.7459400617793	-122.42846998271901	(37.7459400617793, -122.428469982719)
59834	59834	250019	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Peter Yorke Way	9	: 4	Tree 1	Private 1			10	Width 5ft		6005819.0053199995	2114422.18901	37.786129133596	-122.42362939977501	(37.786129133596, -122.423629399775)
60157	60157	196303	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	249 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011469.591109999	2111688.37468	37.7789400547713	-122.403887319468	(37.7789400547713, -122.403887319468)
60307	60307	188597	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1050 Wisconsin St	3	: 4	Tree 1	Private 1			15	Width 5ft		6012781.38051	2102548.17796	37.7539163136043	-122.398707676835	(37.7539163136043, -122.398707676835)
60522	60522	247645	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	1	: 4	Tree 1	Private 1			14	Width 5ft		6001626.8491400005	2108303.83597	37.7690921528084	-122.437694773193	(37.7690921528084, -122.437694773193)
60969	60969	247764	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	47 Alpine Ter	1	: 4	Tree 1	Private 1			33	Width 5ft		6001642.78328	2108514.72427	37.769672105812	-122.43765476325501	(37.769672105812, -122.437654763255)
62569	62569	201161	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1601 Evans Ave	13	: 4	Tree 1	Private 1			11	Width 5ft		6014928.29138	2099014.96701	37.744334242234395	-122.391036160304	(37.7443342422344, -122.391036160304)
62757	62757	189312	Undocumented 2	Cordyline australis :: Dracena Palm 141	1784 Revere Ave	2	: 4	Tree 1	Private 1			3	Width 5ft		6014126.96822	2095142.52205	37.733656811898	-122.393536022869	(37.733656811898, -122.393536022869)
63351	63351	200365	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1300 Phelps St	7	: 4	Tree 1	Private 1			6	Width 5ft		6014060.81183	2096393.5404700001	37.7370881751809	-122.39385228564801	(37.7370881751809, -122.393852285648)
64197	64197	224004	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	2 McCoppin St	5	: 4	Tree 1	Private 1			26	Width 5ft		6006363.216469999	2109170.7903299998	37.77174077135479	-122.42137350531	(37.7717407713548, -122.42137350531)
64408	64408	188294	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1582 12th St	2	: 4	Tree 1	Private 1			12	Width 5ft		6008162.78535	2108877.84718	37.771037714636705	-122.415127922313	(37.7710377146367, -122.415127922313)
64710	64710	242372	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	65 McCoppin St	2	: 4	Tree 1	Private 1			2	Width 5ft		6006293.4937	2109105.47321	37.7715574949158	-122.42161004138201	(37.7715574949158, -122.421610041382)
66108	66108	200287	Undocumented 2	Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328	450 Texas St	5	: 4	Tree 1	Private 1			1	Width 5ft		6013763.35516	2104980.7036599996	37.7606501645924	-122.395482160282	(37.7606501645924, -122.395482160282)
66653	66653	200293	Undocumented 2	Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328	450 Texas St	12	: 4	Tree 1	Private 1			3	Width 5ft		6013771.6868	2104857.5538	37.7603124853576	-122.39544471699699	(37.7603124853576, -122.395444716997)
67076	67076	192420	Undocumented 2	Geijera parviflora :: Australian Willow 68	2 Sierra St	4	: 4	Tree 1	Private 1			8	Width 5ft		6013708.5618199995	2104154.58233	37.7583787675789	-122.395613785069	(37.7583787675789, -122.395613785069)
67673	67673	196304	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	249 Shipley St	2	: 4	Tree 1	Private 1			1	Width 5ft		6011481.859569999	2111700.79426	37.7789748414544	-122.403845751896	(37.7789748414544, -122.403845751896)
68710	68710	188336	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1490 19th St	3	: 4	Tree 1	Private 1			11	Width 5ft		6013315.97127	2105238.81397	37.7613339848017	-122.39704756789101	(37.7613339848017, -122.397047567891)
68861	68861	197140	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	53 Pomona St	2	: 4	Tree 1	Private 1			3	Width 5ft		6014151.58684	2094423.9633799999	37.7316851643341	-122.39340063984	(37.7316851643341, -122.39340063984)
68876	68876	228449	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	1	: 4	Tree 1	Private 1			1	Width 5ft		6009256.91005	2106366.76259	37.76420428262279	-122.411165888909	(37.7642042826228, -122.411165888909)
70092	70092	249441	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1050 Ellis St	1	: 4	Tree 1	Private 1			21	Width 5ft		6005807.98079	2113486.28035	37.7835587371777	-122.42360097670601	(37.7835587371777, -122.423600976706)
70499	70499	192417	Undocumented 2	Geijera parviflora :: Australian Willow 68	2 Sierra St	1	: 4	Tree 1	Private 1			11	Width 5ft		6013758.38911	2104156.54332	37.7583869235411	-122.395441596376	(37.7583869235411, -122.395441596376)
70680	70680	249443	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1050 Ellis St	3	: 4	Tree 1	Private 1			17	Width 5ft		6005759.66207	2113481.38501	37.7835425682756	-122.423767792866	(37.7835425682756, -122.423767792866)
70745	70745	201798	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	3	: 4	Tree 1	Private 1			2	Width 5ft		6021088.33309	2092752.01283	37.7274772697451	-122.36930313385099	(37.7274772697451, -122.369303133851)
71262	71262	225252	Undocumented 2	Citrus spp :: Lemon: Orange: Lime 278	1331 Stevenson St	1	: 4	Tree 1	Private 1			1	Width 5ft		6006271.29436	2108923.54997	37.7710567254041	-122.421673906749	(37.7710567254041, -122.421673906749)
73397	73397	246510	Undocumented 2	Ceratonia siliqua :: Carob 97	231 Duncan St	1	: 4	Tree 1	Private 1			1	Width 5ft		6004993.26159	2099869.66747	37.7461247456624	-122.425450235552	(37.7461247456624, -122.425450235552)
73594	73594	188600	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1801 22nd St	2	: 4	Tree 1	Private 1			19	Width 5ft		6012542.53813	2103744.35344	37.7571874401736	-122.399617634271	(37.7571874401736, -122.399617634271)
73664	73664	228453	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	5	: 4	Tree 1	Private 1			1	Width 5ft		6009339.05918	2106371.48119	37.7642218454873	-122.41088209075899	(37.7642218454873, -122.410882090759)
74581	74581	228446	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	379 Haight St	1	: 4	Tree 1	Private 1			5	Width 5ft		6004344.901769999	2109415.2001400003	37.7722978608825	-122.428372409862	(37.7722978608825, -122.428372409862)
74635	74635	188296	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1582 12th St	4	: 4	Tree 1	Private 1			13	Width 5ft		6008131.8967699995	2108889.4185900004	37.7710677511061	-122.41523558646601	(37.7710677511061, -122.415235586466)
74661	74661	250017	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Peter Yorke Way	6	: 4	Tree 1	Private 1			10	Width 5ft		6005762.80005	2114349.91412	37.7859275118887	-122.423818714288	(37.7859275118887, -122.423818714288)
74895	74895	200358	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1150 Phelps St	3	: 4	Tree 1	Private 1			12	Width 5ft		6014239.8641	2096632.70057	37.7377548084229	-122.393249946754	(37.7377548084229, -122.393249946754)
75176	75176	246478	Undocumented 2	Maytenus boaria :: Mayten 22	324 Duncan St	1	: 4	Tree 1	Private 1			15	Width 5ft		6004249.43735	2099875.64697	37.746099109581706	-122.42802271119	(37.7460991095817, -122.42802271119)
76275	76275	247168	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	165 Buena Vista Ave East	2	: 4	Tree 1	Private 1			2	Width 5ft		6001401.68664	2108432.37227	37.769432276402796	-122.438482805937	(37.7694322764028, -122.438482805937)
112760	112760	200367	Undocumented 2	Liriodendron tulipifera :: Tulip Tree 85	1300 Phelps St	9	: 4	Tree 1	Private 1			17	Width 5ft		6014030.85339	2096351.6806400002	37.7369715717905	-122.393952936896	(37.7369715717905, -122.393952936896)
129215	129215	250538	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	81 25th Ave	1	: 4	Tree 1	Private 1			14	Width 5ft		5987993.0307599995	2115480.02727	37.7880113130196	-122.48537941992201	(37.7880113130196, -122.485379419922)
129822	129822	193646	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2088 Oakdale Ave	2	: 4	Tree 1	Private 1			16	Width 5ft		6012530.49142	2097385.7061	37.7397272896935	-122.399212954624	(37.7397272896935, -122.399212954624)
130003	130003	247648	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	4	: 4	Tree 1	Private 1			15	Width 5ft		6001589.80232	2108300.84932	37.76908184567821	-122.43782270177	(37.7690818456782, -122.43782270177)
130312	130312	198009	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	275 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011338.42729	2111564.35079	37.778592185327604	-122.404332338179	(37.7785921853276, -122.404332338179)
131340	131340	247647	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	900 Duboce Ave	3	: 4	Tree 1	Private 1			15	Width 5ft		6001603.04575	2108301.54357	37.7690845049709	-122.437776943351	(37.7690845049709, -122.437776943351)
131917	131917	247724	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	1	: 4	Tree 1	Private 1			20	Width 5ft		6001327.79784	2108980.06869	37.77093191120821	-122.438777636094	(37.7709319112082, -122.438777636094)
132208	132208	187887	Undocumented 2	Acer rubrum :: Red Maple 6	1798 Indiana St	3	: 4	Tree 1	Private 1			3	Width 5ft		6015168.3741	2100272.0996	37.7477993858291	-122.39029381222299	(37.7477993858291, -122.390293812223)
133056	133056	201799	Undocumented 2	Zelkova serrata :: Sawleaf Zelkova 174	50 Jerrold Ave	4	: 4	Tree 1	Private 1			2	Width 5ft		6021051.90692	2092781.9816400001	37.727557560315795	-122.36943113075	(37.7275575603158, -122.36943113075)

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