Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135535 | 135535 | 126618 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3301 Van Ness Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6005157.457169999 | 2122152.06561 | 37.8073160440754 | -122.426468777106 | (37.8073160440754, -122.426468777106) | |||
| 47905 | 47905 | 126466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1454 Jefferson St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002229.507119999 | 2121606.26883 | 37.80565147990821 | -122.43656248897499 | (37.8056514799082, -122.436562488975) | |||
| 95681 | 95681 | 136647 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1490 Jefferson St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002197.32767 | 2121601.5200400003 | 37.805636612315105 | -122.436673510277 | (37.8056366123151, -122.436673510277) | |||
| 37484 | 37484 | 136656 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1425 Jefferson St | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6002391.3756099995 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | |||
| 59790 | 59790 | 129202 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1425 Jefferson St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6002378.47119 | 2121561.31201 | 37.8055365042628 | -122.436043759126 | (37.8055365042628, -122.436043759126) | |||
| 35577 | 35577 | 132766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3700 Buchanan St | 10 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003086.27955 | 2121288.8809599997 | 37.804828665860704 | -122.433574810742 | (37.8048286658607, -122.433574810742) | |||
| 175863 | 175863 | 132765 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3700 Buchanan St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6003091.99833 | 2121255.71658 | 37.804737929664505 | -122.433552648755 | (37.8047379296645, -122.433552648755) | |||
| 147214 | 147214 | 125801 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | |||
| 61886 | 61886 | 125802 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002006.97076 | 2121237.2158 | 37.8046255099126 | -122.43730616445299 | (37.8046255099126, -122.437306164453) | |||
| 159810 | 159810 | 125803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154103999 | (37.8046010303654, -122.43730154104) | |||
| 188530 | 188530 | 126099 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6002384.275669999 | 2121216.1923599998 | 37.8045892267643 | -122.435998961207 | (37.8045892267643, -122.435998961207) | |||
| 176293 | 176293 | 126098 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002372.64115 | 2121214.12462 | 37.8045828883414 | -122.436039075449 | (37.8045828883414, -122.436039075449) | |||
| 51174 | 51174 | 125804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3711 Fillmore St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002009.77145 | 2121217.59748 | 37.804571802419 | -122.43729506680799 | (37.804571802419, -122.437295066808) | |||
| 186749 | 186749 | 136029 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 3743 Scott St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000599.31455 | 2121234.7075799997 | 37.804538500507995 | -122.44217730004101 | (37.804538500508, -122.442177300041) | |||
| 25791 | 25791 | 135673 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 3639 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002560.08245 | 2121134.92796 | 37.8043760820531 | -122.435384749408 | (37.8043760820531, -122.435384749408) | |||
| 151827 | 151827 | 129189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.44214075790701 | (37.8043326933704, -122.442140757907) | |||
| 176649 | 176649 | 129200 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6002139.18705 | 2121127.02263 | 37.8043304639385 | -122.436840724815 | (37.8043304639385, -122.436840724815) | |||
| 62525 | 62525 | 126096 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002623.69745 | 2121110.92365 | 37.8043137851175 | -122.43516288665899 | (37.8043137851175, -122.435162886659) | |||
| 153622 | 153622 | 132757 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3601 Laguna St | 10 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6003537.25934 | 2121091.9719700003 | 37.8043135827752 | -122.432000078959 | (37.8043135827752, -122.432000078959) | |||
| 148847 | 148847 | 126085 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.56752 | 2121160.52429 | 37.8043072893028 | -122.443842552202 | (37.8043072893028, -122.443842552202) | |||
| 130235 | 130235 | 126086 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.67456 | 2121159.0969700003 | 37.8043033763715 | -122.443842079173 | (37.8043033763715, -122.443842079173) | |||
| 151133 | 151133 | 126087 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000117.09871 | 2121156.78395 | 37.804297049633895 | -122.443840445091 | (37.8042970496339, -122.443840445091) | |||
| 162732 | 162732 | 126095 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002627.04146 | 2121100.74155 | 37.8042860176436 | -122.435150585742 | (37.8042860176436, -122.435150585742) | |||
| 59064 | 59064 | 129190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6000610.9168300005 | 2121141.44631 | 37.8042830912635 | -122.44213045078699 | (37.8042830912635, -122.442130450787) | |||
| 65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 42798 | 42798 | 137514 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3633 Webster St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002566.08313 | 2121090.5065099997 | 37.8042544532535 | -122.435360804076 | (37.8042544532535, -122.435360804076) | |||
| 49744 | 49744 | 136530 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3719 Scott St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6000612.037330001 | 2121116.27495 | 37.804214041307795 | -122.442124765264 | (37.8042140413078, -122.442124765264) | |||
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
| 45702 | 45702 | 129197 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6001606.6144900005 | 2120894.2374 | 37.8036610149183 | -122.43866704197501 | (37.8036610149183, -122.438667041975) | |||
| 37647 | 37647 | 136662 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1307 Bay St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.803611411885704 | -122.428569697738 | (37.8036114118857, -122.428569697738) | |||
| 54943 | 54943 | 136661 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1307 Bay St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6004511.51487 | 2120814.19666 | 37.8036060681264 | -122.42860877508801 | (37.8036060681264, -122.428608775088) | |||
| 49854 | 49854 | 132449 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1341 Bay St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6004363.25375 | 2120796.06015 | 37.803547878401496 | -122.429120545984 | (37.8035478784015, -122.429120545984) | |||
| 179485 | 179485 | 131091 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6004549.167669999 | 2120777.63137 | 37.8035078001114 | -122.428475867867 | (37.8035078001114, -122.428475867867) | |||
| 173357 | 173357 | 131092 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3299 Gough St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004551.929269999 | 2120763.26288 | 37.803468504236605 | -122.42846528646601 | (37.8034685042366, -122.428465286466) | |||
| 62032 | 62032 | 125937 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 3640 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 6ft | 6002179.26509 | 2120811.82356 | 37.8034672883377 | -122.43667945570401 | (37.8034672883377, -122.436679455704) | |||
| 58530 | 58530 | 125936 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 3640 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 6ft | 6002183.33436 | 2120790.5318400003 | 37.803409058151104 | -122.43666384886801 | (37.8034090581511, -122.436663848868) | |||
| 186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
| 26280 | 26280 | 136663 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3109 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.803297110532895 | -122.426737318298 | (37.8032971105329, -122.426737318298) | |||
| 173047 | 173047 | 136664 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3109 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005052.80958 | 2120674.99367 | 37.8032544709705 | -122.42672567836 | (37.8032544709705, -122.42672567836) | |||
| 177222 | 177222 | 125447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005068.7625400005 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | |||
| 162716 | 162716 | 125448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | |||
| 59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
| 164147 | 164147 | 129198 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3537 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002132.11244 | 2120360.66499 | 37.8022258462139 | -122.436810313348 | (37.8022258462139, -122.436810313348) | |||
| 135341 | 135341 | 129188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5999731.06738 | 2120400.48948 | 37.80219844206879 | -122.44512192772899 | (37.8021984420688, -122.445121927729) | |||
| 131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
| 148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
| 69475 | 69475 | 249932 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 345 Filbert St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 6011228.49404 | 2120021.60131 | 37.801807635383206 | -122.405308370584 | (37.8018076353832, -122.405308370584) | |||
| 58002 | 58002 | 249931 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.801791658008106 | -122.405355554416 | (37.8017916580081, -122.405355554416) | |||
| 60287 | 60287 | 136528 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3271 Baker St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 5999283.78896 | 2120122.72812 | 37.8014102447475 | -122.44664972480601 | (37.8014102447475, -122.446649724806) | |||
| 8599 | 8599 | 96031 | Permitted Site 1 | Psidium guajava :: Guava tree 252 | 1116 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 20 | Permit Number 767346 | 6007512.843169999 | 2119899.46213 | 37.8012638333238 | -122.418157616905 | (37.8012638333238, -122.418157616905) | ||
| 174125 | 174125 | 127070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 10 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6001375.8548 | 2119619.21037 | 37.8001469985396 | -122.43937414650499 | (37.8001469985396, -122.439374146505) | |||
| 54954 | 54954 | 127069 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 9 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6001380.49031 | 2119587.4899 | 37.800060166303396 | -122.439355830906 | (37.8000601663034, -122.439355830906) | |||
| 56968 | 56968 | 127064 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6001385.25853 | 2119550.33485 | 37.799958419693105 | -122.43933666636299 | (37.7999584196931, -122.439336666363) | |||
| 178435 | 178435 | 127063 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3252 Pierce St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001387.77011 | 2119526.14518 | 37.799892144171096 | -122.43932624052601 | (37.7998921441711, -122.439326240526) | |||
| 185111 | 185111 | 131064 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1877 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.79954355884429 | -122.430529985984 | (37.7995435588443, -122.430529985984) | |||
| 73817 | 73817 | 126076 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5999384.46531 | 2119405.9114599996 | 37.799447808926395 | -122.446249747728 | (37.7994478089264, -122.446249747728) | |||
| 76540 | 76540 | 126077 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999388.2562 | 2119380.27509 | 37.7993776348198 | -122.44623478482299 | (37.7993776348198, -122.446234784823) | |||
| 156378 | 156378 | 132713 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3055 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 1ft | 6000438.0294 | 2118824.18177 | 37.797910646325896 | -122.442562262934 | (37.7979106463259, -122.442562262934) | |||
| 26744 | 26744 | 132714 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3055 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 1ft | 6000441.38415 | 2118807.53005 | 37.797865116340105 | -122.4425494584 | (37.7978651163401, -122.4425494584) | |||
| 34884 | 34884 | 129516 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000442.909 | 2118797.59081 | 37.797837912738295 | -122.44254346802 | (37.7978379127383, -122.44254346802) | |||
| 161949 | 161949 | 129517 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000445.055869999 | 2118784.6129 | 37.7978024012088 | -122.442535107006 | (37.7978024012088, -122.442535107006) | |||
| 165862 | 165862 | 129518 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.797767715271796 | -122.44253092607 | (37.7977677152718, -122.44253092607) | |||
| 47655 | 47655 | 129519 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.25144 | 2118762.17983 | 37.79774087408789 | -122.442529358545 | (37.7977408740879, -122.442529358545) | |||
| 160826 | 160826 | 129520 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6000447.31564 | 2118755.2398900003 | 37.7977218795107 | -122.442525177605 | (37.7977218795107, -122.442525177605) | |||
| 48018 | 48018 | 136642 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3035 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6000450.1684 | 2118732.62208 | 37.797659939602106 | -122.442513681577 | (37.7976599396021, -122.442513681577) | |||
| 62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
| 35739 | 35739 | 126050 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2743 Baker St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 5999540.91098 | 2118277.28381 | 37.7963578318958 | -122.44562718666799 | (37.7963578318958, -122.445627186668) | |||
| 123746 | 123746 | 135581 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 22 Drumm St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 7ft | 6013732.77285 | 2117082.9490900002 | 37.7938784864461 | -122.39643624024099 | (37.7938784864461, -122.396436240241) | |||
| 179329 | 179329 | 249731 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Broderick St | 15 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000168.8987300005 | 2117282.9089599997 | 37.793663374005604 | -122.443382762997 | (37.7936633740056, -122.443382762997) | |||
| 130192 | 130192 | 249743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 27 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.793612148632704 | -122.443168120916 | (37.7936121486327, -122.443168120916) | |||
| 27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
| 176767 | 176767 | 249732 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 16 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000181.11943 | 2117259.58432 | 37.793600027574 | -122.443338802346 | (37.793600027574, -122.443338802346) | |||
| 186808 | 186808 | 249745 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 29 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000232.829030001 | 2117254.6491400003 | 37.793589425458606 | -122.44315952880899 | (37.7935894254586, -122.443159528809) | |||
| 46543 | 46543 | 249746 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 30 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6000233.18821 | 2117249.22853 | 37.7935745623699 | -122.44315789653 | (37.7935745623699, -122.44315789653) | |||
| 40469 | 40469 | 249747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000233.56128 | 2117245.74106 | 37.793565007967 | -122.44315635509399 | (37.793565007967, -122.443156355094) | |||
| 136197 | 136197 | 249748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 32 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6000234.88856 | 2117241.71857 | 37.7935540389482 | -122.443151473582 | (37.7935540389482, -122.443151473582) | |||
| 26897 | 26897 | 249733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 17 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000186.12585 | 2117239.7585400003 | 37.7935458766883 | -122.4433200551 | (37.7935458766883, -122.4433200551) | |||
| 39030 | 39030 | 249749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 33 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000235.88036 | 2117238.71283 | 37.7935458425285 | -122.44314782591299 | (37.7935458425285, -122.443147825913) | |||
| 148834 | 148834 | 249750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 34 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000235.93718 | 2117235.57911 | 37.7935372413976 | -122.443147404144 | (37.7935372413976, -122.443147404144) | |||
| 49386 | 49386 | 249751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 35 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000236.78022 | 2117230.8297200003 | 37.793524248891295 | -122.443144145909 | (37.7935242488913, -122.443144145909) | |||
| 62997 | 62997 | 249752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 36 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.44314321778299 | (37.7935141252181, -122.443143217783) | |||
| 154539 | 154539 | 249734 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 18 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6000189.35752 | 2117224.43489 | 37.7935039862606 | -122.44330777215299 | (37.7935039862606, -122.443307772153) | |||
| 37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
| 173393 | 173393 | 249754 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 38 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000238.64594 | 2117219.3423599997 | 37.7934928140037 | -122.443136864991 | (37.7934928140037, -122.443136864991) | |||
| 52094 | 52094 | 249755 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 39 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000239.615259999 | 2117214.478 | 37.79347951302 | -122.443133161562 | (37.79347951302, -122.443133161562) | |||
| 32459 | 32459 | 249756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 40 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6000240.43697 | 2117209.2145 | 37.7934651076862 | -122.443129940195 | (37.7934651076862, -122.443129940195) | |||
| 136241 | 136241 | 249736 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 20 | : 4 | Tree 1 | Private 1 | 27 | Width 3ft | 6000189.43372 | 2117210.1069799997 | 37.793464649935004 | -122.443306478906 | (37.793464649935, -122.443306478906) | |||
| 182870 | 182870 | 249757 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 41 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.78319 | 2117204.07092 | 37.7934510045092 | -122.443128372672 | (37.7934510045092, -122.443128372672) | |||
| 67332 | 67332 | 249758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 42 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.94884 | 2117198.36774 | 37.793435354521996 | -122.44312738972602 | (37.793435354522, -122.443127389726) | |||
| 65018 | 65018 | 249759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 43 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000241.634269999 | 2117194.01368 | 37.7934234385005 | -122.443124705245 | (37.7934234385005, -122.443124705245) | |||
| 150758 | 150758 | 249737 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 21 | : 4 | Tree 1 | Private 1 | 31 | Width 3ft | 6000190.59568 | 2117194.0821599998 | 37.79342071625479 | -122.443301306923 | (37.7934207162548, -122.443301306923) | |||
| 44486 | 44486 | 249739 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 2500 Broderick St | 23 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6000181.57325 | 2117191.47862 | 37.793413053123004 | -122.443332338011 | (37.793413053123, -122.443332338011) | |||
| 153878 | 153878 | 249760 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 44 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000241.7862599995 | 2117189.5298599997 | 37.7934111357761 | -122.44312385717699 | (37.7934111357761, -122.443123857177) | |||
| 138184 | 138184 | 249761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 45 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000243.02333 | 2117185.9818700003 | 37.793401464464395 | -122.443119321906 | (37.7934014644644, -122.443119321906) | |||
| 70038 | 70038 | 249762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 46 | : 4 | Tree 1 | Private 1 | 20 | Width 1ft | 6000243.900669999 | 2117182.35848 | 37.7933915656126 | -122.443116025908 | (37.7933915656126, -122.443116025908) | |||
| 174994 | 174994 | 249763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 47 | : 4 | Tree 1 | Private 1 | 21 | Width 1ft | 6000244.96871 | 2117178.7308099996 | 37.7933816658824 | -122.443112069768 | (37.7933816658824, -122.443112069768) | |||
| 26081 | 26081 | 249738 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 22 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000189.3449800005 | 2117178.8516 | 37.7933788258243 | -122.443304539972 | (37.7933788258243, -122.443304539972) | |||
| 184505 | 184505 | 249764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 48 | : 4 | Tree 1 | Private 1 | 23 | Width 1ft | 6000246.04856 | 2117175.67215 | 37.7933733291772 | -122.44310811365101 | (37.7933733291772, -122.443108113651) |
JSON shape: default, array, newline-delimited
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");