Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135877 | 135877 | 199650 | Undocumented 2 | :: 54 | 0 | 1 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6014963.58685 | 2093280.8179400002 | 37.728591398452394 | -122.390513521988 | (37.7285913984524, -122.390513521988) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 29152 | 29152 | 247788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004361.25599 | 2098418.6984200003 | 37.742104989252894 | -122.427532277614 | (37.7421049892529, -122.427532277614) | |||
| 38229 | 38229 | 247791 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 0 30th St | 7 | : 4 | Tree 1 | Private 1 | 24 | Width 3ft | 6004198.23071 | 2098409.9185599997 | 37.74207165946871 | -122.428095342253 | (37.7420716594687, -122.428095342253) | |||
| 137783 | 137783 | 247787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004405.04711 | 2098420.28659 | 37.74211182679821 | -122.42738097477199 | (37.7421118267982, -122.427380974772) | |||
| 154157 | 154157 | 247786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004434.4666 | 2098422.1705099996 | 37.7421186634473 | -122.42727938556101 | (37.7421186634473, -122.427279385561) | |||
| 157576 | 157576 | 247792 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113214996 | -122.42834067009 | (37.742063113215, -122.42834067009) | |||
| 163763 | 163763 | 247789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004321.812940001 | 2098415.77613 | 37.742094734277 | -122.427668451138 | (37.742094734277, -122.427668451138) | |||
| 179978 | 179978 | 247790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004284.58274 | 2098414.05293 | 37.742087896749794 | -122.42779705870501 | (37.7420878967498, -122.427797058705) | |||
| 158551 | 158551 | 234052 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Brook St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005500.71002 | 2097843.84085 | 37.7405909437068 | -122.42355153917102 | (37.7405909437068, -122.423551539171) | |||
| 162260 | 162260 | 234051 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Brook St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005484.21565 | 2097842.60321 | 37.7405866143931 | -122.42360848244101 | (37.7405866143931, -122.423608482441) | |||
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
| 163467 | 163467 | 247185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.43991551320299 | (37.7706920584128, -122.439915513203) | |||
| 168367 | 168367 | 208328 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991213.15323 | 2094380.3449 | 37.7302642498839 | -122.47269945752 | (37.7302642498839, -122.47269945752) | |||
| 40887 | 40887 | 194779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Flora St | 10 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013891.08255 | 2094437.3418 | 37.7317074216406 | -122.39430219851101 | (37.7317074216406, -122.394302198511) | |||
| 47073 | 47073 | 194776 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Flora St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013845.42665 | 2094215.0863299998 | 37.731094615528995 | -122.394444484728 | (37.731094615529, -122.394444484728) | |||
| 67550 | 67550 | 189912 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013884.75868 | 2094408.4745200002 | 37.7316278064595 | -122.394322041155 | (37.7316278064595, -122.394322041155) | |||
| 72242 | 72242 | 189913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013888.27035 | 2094422.90108 | 37.731667614051 | -122.39431091023 | (37.731667614051, -122.39431091023) | |||
| 74016 | 74016 | 189915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013899.07383 | 2094479.41823 | 37.7318233991302 | -122.394277515688 | (37.7318233991302, -122.394277515688) | |||
| 133745 | 133745 | 194780 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Flora St | 12 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013896.88916 | 2094468.31049 | 37.731792778107604 | -122.394284291187 | (37.7317927781076, -122.394284291187) | |||
| 155280 | 155280 | 194778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Flora St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013858.89274 | 2094278.65917 | 37.7312699221594 | -122.394402379375 | (37.7312699221594, -122.394402379375) | |||
| 155912 | 155912 | 194777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Flora St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013848.41828 | 2094231.4751400002 | 37.731139782164604 | -122.394435289176 | (37.7311397821646, -122.394435289176) | |||
| 166137 | 166137 | 189911 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013879.72064 | 2094387.8060700002 | 37.73157077506371 | -122.394338012196 | (37.7315707750637, -122.394338012196) | |||
| 173975 | 173975 | 189914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013894.185819999 | 2094452.33408 | 37.7317487598799 | -122.394292519091 | (37.7317487598799, -122.394292519091) | |||
| 32160 | 32160 | 211179 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Geneva Ave | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5997208.95655 | 2091525.75307 | 37.7227714708997 | -122.451765419354 | (37.7227714708997, -122.451765419354) | |||
| 49831 | 49831 | 213233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5997185.51842 | 2091545.7549299998 | 37.722825048916604 | -122.451847881795 | (37.7228250489166, -122.451847881795) | |||
| 170330 | 170330 | 213234 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5997198.168740001 | 2091539.55227 | 37.72280874240921 | -122.451803705299 | (37.7228087424092, -122.451803705299) | |||
| 174489 | 174489 | 213232 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5997159.34871 | 2091557.33009 | 37.7228553326789 | -122.45193917916201 | (37.7228553326789, -122.451939179162) | |||
| 37995 | 37995 | 228900 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Haight St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006045.73511 | 2109652.55935 | 37.7730456885414 | -122.422505934299 | (37.7730456885414, -122.422505934299) | |||
| 184791 | 184791 | 213237 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 5997483.43481 | 2089893.9519099998 | 37.718306641805896 | -122.45069901764201 | (37.7183066418059, -122.450699017642) | |||
| 159564 | 159564 | 242778 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | |||
| 183368 | 183368 | 226501 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005629.7057300005 | 2108993.07475 | 37.7712114241035 | -122.42389812981199 | (37.7712114241035, -122.423898129812) | |||
| 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) | |||
| 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) | |||
| 60363 | 60363 | 250011 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005651.53308 | 2114225.44639 | 37.7855794724472 | -122.424194812544 | (37.7855794724472, -122.424194812544) | |||
| 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) | |||
| 163792 | 163792 | 250010 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005626.073059999 | 2114211.10885 | 37.785538667527206 | -122.424281876805 | (37.7855386675272, -122.424281876805) | |||
| 165900 | 165900 | 204094 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993976.27625 | 2089155.91875 | 37.7160788007751 | -122.462768183016 | (37.7160788007751, -122.462768183016) | |||
| 159175 | 159175 | 241391 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1 Scott St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002400.13721 | 2108362.4084400004 | 37.769296916741 | -122.43502420851401 | (37.769296916741, -122.435024208514) | |||
| 63754 | 63754 | 250007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Starr King Way | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6005970.87651 | 2113821.19628 | 37.784487527310795 | -122.423061232398 | (37.7844875273108, -122.423061232398) | |||
| 169165 | 169165 | 250006 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Starr King Way | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005940.10765 | 2113829.6095 | 37.784508891608 | -122.423168280499 | (37.784508891608, -122.423168280499) | |||
| 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) | |||
| 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) | |||
| 49912 | 49912 | 246603 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005584.08918 | 2109245.7263700003 | 37.7719025692852 | -122.42407388970899 | (37.7719025692852, -122.424073889709) | |||
| 76509 | 76509 | 246605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6005631.61729 | 2109252.77035 | 37.7719245936684 | -122.42390998734899 | (37.7719245936684, -122.423909987349) | |||
| 132570 | 132570 | 246600 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005541.07514 | 2109239.2971099997 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | |||
| 149193 | 149193 | 246604 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005614.489030001 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | |||
| 156968 | 156968 | 246602 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005566.51625 | 2109243.72851 | 37.77189609146429 | -122.424134533696 | (37.7718960914643, -122.424134533696) | |||
| 165531 | 165531 | 246601 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005553.210969999 | 2109241.87873 | 37.77189026116871 | -122.424180426085 | (37.7718902611687, -122.424180426085) | |||
| 131719 | 131719 | 198129 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Apollo St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013057.33243 | 2094752.72387 | 37.7325270152047 | -122.39720676767901 | (37.7325270152047, -122.397206767679) | |||
| 58584 | 58584 | 194570 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 10 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6014071.17827 | 2095379.6621299998 | 37.7343048498944 | -122.393745499263 | (37.7343048498944, -122.393745499263) | |||
| 71368 | 71368 | 194571 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 10 Bridgeview Dr | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014067.172180001 | 2095407.6295099999 | 37.7343814199646 | -122.393761306632 | (37.7343814199646, -122.393761306632) | |||
| 33800 | 33800 | 178161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.46567970845899 | (37.7124525633948, -122.465679708459) | |||
| 34540 | 34540 | 177827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 0ft | 5993584.63921 | 2087685.0546799998 | 37.712017594599295 | -122.46401514608 | (37.7120175945993, -122.46401514608) | |||
| 38392 | 38392 | 178159 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | |||
| 40640 | 40640 | 178151 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5993597.52442 | 2087641.3827799999 | 37.7118984245322 | -122.46396744335199 | (37.7118984245322, -122.463967443352) | |||
| 50141 | 50141 | 178167 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992858.09731 | 2087851.4953400001 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | |||
| 70361 | 70361 | 177828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 10 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5993567.2586900005 | 2087687.58972 | 37.712023553524205 | -122.464075401566 | (37.7120235535242, -122.464075401566) | |||
| 75963 | 75963 | 178152 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.46423106162399 | (37.7121347780763, -122.464231061624) | |||
| 130721 | 130721 | 178158 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993255.20411 | 2087840.2590599998 | 37.7124247572585 | -122.465165024673 | (37.7124247572585, -122.465165024673) | |||
| 130784 | 130784 | 178165 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 20 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | |||
| 136019 | 136019 | 206848 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5993673.9414 | 2087579.0167599998 | 37.7117315859181 | -122.46369880328001 | (37.7117315859181, -122.46369880328) | |||
| 137802 | 137802 | 206847 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5993688.70591 | 2087590.2808700001 | 37.711763365253894 | -122.463648590504 | (37.7117633652539, -122.463648590504) | |||
| 146720 | 146720 | 178155 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 10 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993366.44396 | 2087810.43567 | 37.71234928345479 | -122.46477838452499 | (37.7123492834548, -122.464778384525) | |||
| 150293 | 150293 | 178166 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 21 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992891.51235 | 2087851.5166099998 | 37.7124346884767 | -122.466422861421 | (37.7124346884767, -122.466422861421) | |||
| 155336 | 155336 | 178160 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 15 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993144.356269999 | 2087854.16093 | 37.712456535710395 | -122.465549154771 | (37.7124565357104, -122.465549154771) | |||
| 156086 | 156086 | 206846 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5993694.0595 | 2087568.4676400002 | 37.7117037797802 | -122.463628505047 | (37.7117037797802, -122.463628505047) | |||
| 156435 | 156435 | 178169 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 24 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5992786.910569999 | 2087851.5448200002 | 37.7124287295635 | -122.466784396099 | (37.7124287295635, -122.466784396099) | |||
| 157655 | 157655 | 178162 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 17 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993072.48922 | 2087856.39417 | 37.7124585223038 | -122.46579770942301 | (37.7124585223038, -122.465797709423) | |||
| 160645 | 160645 | 178163 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 18 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993033.97644 | 2087855.7565900001 | 37.712454549997204 | -122.465930773993 | (37.7124545499972, -122.465930773993) | |||
| 162182 | 162182 | 178153 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5993495.89449 | 2087748.40295 | 37.712186418929896 | -122.464326467118 | (37.7121864189299, -122.464326467118) | |||
| 164811 | 164811 | 178154 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5993415.347159999 | 2087786.9851099998 | 37.7122877131728 | -122.464607659932 | (37.7122877131728, -122.464607659932) | |||
| 170076 | 170076 | 178164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 19 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993000.50065 | 2087852.84302 | 37.71244461881 | -122.46604626403 | (37.71244461881, -122.46604626403) | |||
| 171829 | 171829 | 178157 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5993292.82373 | 2087832.959 | 37.712406882332 | -122.46503447098499 | (37.712406882332, -122.465034470985) | |||
| 173693 | 173693 | 178156 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993327.478519999 | 2087822.82752 | 37.712381061909 | -122.464913959129 | (37.712381061909, -122.464913959129) | |||
| 179412 | 179412 | 178168 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 23 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992821.74753 | 2087850.08942 | 37.712426743882 | -122.46666388422899 | (37.712426743882, -122.466663884229) | |||
| 48237 | 48237 | 205333 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 Caine Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5997549.343280001 | 2089570.2528799998 | 37.717421611803495 | -122.45044787838002 | (37.7174216118035, -122.45044787838) | |||
| 129752 | 129752 | 214001 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5997555.121730001 | 2089578.9570799998 | 37.717445842242604 | -122.450428532174 | (37.7174458422426, -122.450428532174) | |||
| 176248 | 176248 | 217532 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 12 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5997565.18295 | 2089591.75195 | 37.7174815498251 | -122.450394677186 | (37.7174815498251, -122.450394677186) | |||
| 48713 | 48713 | 197355 | Undocumented 2 | Rhamnus californica :: Coffeeberry Tree 232 | 10 Cargo Way | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6018943.2735 | 2097519.21753 | 37.740449188069896 | -122.37704929319099 | (37.7404491880699, -122.377049293191) | |||
| 71980 | 71980 | 196271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Cashmere St | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017110.310380001 | 2095865.5402400002 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | ||||
| 132405 | 132405 | 250040 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006198.948 | 2114743.14871 | 37.7870318487916 | -122.422337709814 | (37.7870318487916, -122.422337709814) | |||
| 170314 | 170314 | 250039 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Daniel Burnham Ct | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6006219.932469999 | 2114745.1148200002 | 37.78703843092679 | -122.42226524786999 | (37.7870384309268, -122.42226524787) | |||
| 173422 | 173422 | 218543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | |||
| 31686 | 31686 | 189484 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 Garlington Ct | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 8ft | 6016756.63544 | 2094656.7103 | 37.732468633912795 | -122.38441058228399 | (37.7324686339128, -122.384410582284) | |||
| 35639 | 35639 | 176145 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 6 | : 4 | Tree 1 | Private 1 | 41 | Width 0ft | 5987592.83524 | 2090286.1257900002 | 37.7188123395933 | -122.484914976763 | (37.7188123395933, -122.484914976763) | |||
| 38808 | 38808 | 176142 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 38 | Width 0ft | 5987571.34971 | 2089706.0579 | 37.7172183686082 | -122.48494670935 | (37.7172183686082, -122.48494670935) | |||
| 44967 | 44967 | 176143 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 4 | : 4 | Tree 1 | Private 1 | 60 | Width 0ft | 5987585.53383 | 2089941.9294099999 | 37.7178668382624 | -122.48491497676201 | (37.7178668382624, -122.484914976762) | |||
| 45769 | 45769 | 176148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 9 | : 4 | Tree 1 | Private 1 | 34 | Width 0ft | 5987583.49684 | 2090495.06547 | 37.7193854910228 | -122.484962576086 | (37.7193854910228, -122.484962576086) | |||
| 46715 | 46715 | 176139 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5987453.25598 | 2088569.38174 | 37.714090463565796 | -122.485271539962 | (37.7140904635658, -122.485271539962) | |||
| 49614 | 49614 | 176138 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5987453.76086 | 2088540.35852 | 37.714010802520704 | -122.485267666593 | (37.7140108025207, -122.485267666593) | |||
| 49756 | 49756 | 178276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 21 | Width 0ft | 5987587.7101300005 | 2089755.9926900002 | 37.7173564298339 | -122.4848938211 | (37.7173564298339, -122.4848938211) | |||
| 67783 | 67783 | 176150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 11 | : 4 | Tree 1 | Private 1 | 36 | Width 0ft | 5987592.48981 | 2090630.47985 | 37.7197578283347 | -122.484941420412 | (37.7197578283347, -122.484941420412) | |||
| 71082 | 71082 | 176144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 5 | : 4 | Tree 1 | Private 1 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | |||
| 72073 | 72073 | 176140 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5987455.898580001 | 2088588.29538 | 37.7141425496068 | -122.48526379321501 | (37.7141425496068, -122.485263793215) | |||
| 136102 | 136102 | 176147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 8 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987595.02111 | 2090461.3006400003 | 37.7192934526127 | -122.484920265678 | (37.7192934526127, -122.484920265678) | |||
| 149666 | 149666 | 176149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 10 | : 4 | Tree 1 | Private 1 | 58 | Width 0ft | 5987588.89275 | 2090533.04242 | 37.7194900803794 | -122.48494670933998 | (37.7194900803794, -122.48494670934) |
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");