Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38615 | 38615 | 177876 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4117 San Bruno Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.40219173226299 | (37.7124588649577, -122.402191732263) | |||
| 158856 | 158856 | 177486 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 601 La Grande Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | 6004368.23495 | 2089081.7920799998 | 37.7164683196427 | -122.42684334834999 | (37.7164683196427, -122.42684334835) | ||||
| 122547 | 122547 | 176099 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 43 | 6004400.9540099995 | 2089156.27858 | 37.716674693347 | -122.42673555649999 | (37.716674693347, -122.4267355565) | ||||
| 162701 | 162701 | 176100 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 19 | 6004405.409030001 | 2089175.08917 | 37.7167265950249 | -122.42672149649799 | (37.7167265950249, -122.426721496498) | ||||
| 45680 | 45680 | 176101 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 26 | 6004411.36222 | 2089192.97967 | 37.716776055035794 | -122.426702192554 | (37.7167760550358, -122.426702192554) | ||||
| 26291 | 26291 | 178180 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 491 La Grande Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 20 | 6004422.927759999 | 2089235.71163 | 37.716894041605 | -122.42666525741001 | (37.716894041605, -122.42666525741) | ||||
| 123420 | 123420 | 178181 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 491 La Grande Ave | 5 | : Yard 23 | Tree 1 | Private 1 | 23 | 6004429.890380001 | 2089255.59598 | 37.7169490333536 | -122.42664260617501 | (37.7169490333536, -122.426642606175) | ||||
| 37053 | 37053 | 218147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Ashton Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | ||||
| 39362 | 39362 | 214005 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 50 Circular Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 17 | 6000114.23279 | 2093911.68117 | 37.7294886448689 | -122.441893693449 | (37.7294886448689, -122.441893693449) | ||||
| 44764 | 44764 | 205937 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 50 Circular Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000127.5419 | 2093913.2935099998 | 37.7294938303644 | -122.44184779835501 | (37.7294938303644, -122.441847798355) | ||||
| 129806 | 129806 | 234413 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 280 Justin Dr | 1 | : Yard 23 | Tree 1 | Private 1 | 26 | Width 3ft | 6005966.47626 | 2094899.24737 | 37.7325320253145 | -122.42173199844 | (37.7325320253145, -122.42173199844) | |||
| 49162 | 49162 | 234414 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 280 | 2 | : Yard 23 | Tree 1 | Private 1 | 23 | Width 3ft | 6005979.042880001 | 2094923.96665 | 37.7326006076366 | -122.421690307661 | (37.7326006076366, -122.421690307661) | |||
| 163941 | 163941 | 211530 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 321 Melrose Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 16 | 5997959.2212 | 2095523.47143 | 37.733791203898704 | -122.44945983462699 | (37.7337912038987, -122.449459834627) | ||||
| 164257 | 164257 | 205447 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 321 Melrose Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 2 | 5997960.43745 | 2095528.68593 | 37.7338055912481 | -122.44945600530001 | (37.7338055912481, -122.4494560053) | ||||
| 32540 | 32540 | 210191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Melrose Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 5997966.64829 | 2095534.3479400002 | 37.7338214930658 | -122.44943494048799 | (37.7338214930658, -122.449434940488) | ||||
| 28853 | 28853 | 209017 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 25 | 6000774.79116 | 2095519.5815700002 | 37.7339411856303 | -122.43972531378401 | (37.7339411856303, -122.439725313784) | ||||
| 63043 | 63043 | 209019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000764.3171 | 2095528.5679900001 | 37.7339652640682 | -122.43976216978201 | (37.7339652640682, -122.439762169782) | ||||
| 185838 | 185838 | 209018 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | ||||
| 153234 | 153234 | 209020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 33 Martha Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | ||||
| 108835 | 108835 | 113062 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 3 | : Yard 23 | Tree 1 | DPW 2 | 08/18/2016 09:59:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
| 119367 | 119367 | 113063 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 4 | : Yard 23 | Tree 1 | DPW 2 | 08/18/2016 09:56:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
| 76157 | 76157 | 233604 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 10 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6010160.0797 | 2099615.7154599996 | 37.7457180218657 | -122.40756605383301 | (37.7457180218657, -122.407566053833) | |||
| 154537 | 154537 | 233603 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 9 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010152.72418 | 2099634.5230799997 | 37.7457692517475 | -122.40759281407101 | (37.7457692517475, -122.407592814071) | |||
| 31996 | 31996 | 237002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6010115.457330001 | 2099644.6115099997 | 37.745794866235 | -122.40772238927 | (37.745794866235, -122.40772238927) | |||
| 134356 | 134356 | 233602 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 8 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010143.5997 | 2099646.47131 | 37.7458015482156 | -122.40762520763701 | (37.7458015482156, -122.407625207637) | |||
| 152462 | 152462 | 233605 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 12 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.745808231063705 | -122.407697037414 | (37.7458082310637, -122.407697037414) | |||
| 40295 | 40295 | 233234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 7 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6010136.86006 | 2099655.53222 | 37.7458260502241 | -122.40764915121099 | (37.7458260502241, -122.407649151211) | |||
| 161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
| 156957 | 156957 | 233233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 6 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010125.251569999 | 2099665.5030400003 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | |||
| 37555 | 37555 | 237003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010106.165469999 | 2099668.32603 | 37.7458594609566 | -122.40775619120001 | (37.7458594609566, -122.4077561912) | |||
| 70403 | 70403 | 233232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 5 | : Yard 23 | Tree 1 | Private 1 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | |||
| 25729 | 25729 | 233231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | |||
| 73122 | 73122 | 225894 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 199 Franconia St | 17 | : Yard 23 | Tree 1 | Private 1 | 7 | Width 3ft | 6010105.1921 | 2099680.51389 | 37.7458928716644 | -122.407760416232 | (37.7458928716644, -122.407760416232) | |||
| 37605 | 37605 | 237004 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6010095.49496 | 2099684.36191 | 37.7459028946219 | -122.40779421904101 | (37.7459028946219, -122.407794219041) | |||
| 173331 | 173331 | 233230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 3 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010120.38838 | 2099686.6934 | 37.745910689944104 | -122.407708305 | (37.7459106899441, -122.407708305) | |||
| 32348 | 32348 | 233229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 2 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010110.29265 | 2099690.9553400003 | 37.745921827136996 | -122.407743515268 | (37.745921827137, -122.407743515268) | |||
| 169576 | 169576 | 233228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010113.61596 | 2099694.13241 | 37.7459307367175 | -122.407732247644 | (37.7459307367175, -122.407732247644) | |||
| 154821 | 154821 | 237005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 16 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010090.49979 | 2099699.0653 | 37.7459429872721 | -122.40781252834101 | (37.7459429872721, -122.407812528341) | |||
| 151779 | 151779 | 241988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Franconia St | 18 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010085.85388 | 2099710.92257 | 37.745975284649 | -122.40782942930299 | (37.745975284649, -122.407829429303) | |||
| 46299 | 46299 | 233305 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 170 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 17 | 6000606.984180001 | 2100509.57943 | 37.7476329887819 | -122.44066327429199 | (37.7476329887819, -122.440663274292) | ||||
| 187327 | 187327 | 233306 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 174 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 26 | 6000631.47853 | 2100513.23992 | 37.7476444344533 | -122.44057883696999 | (37.7476444344533, -122.44057883697) | ||||
| 150305 | 150305 | 234860 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 2 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000574.359 | 2100517.55086 | 37.7476530184698 | -122.44077666170799 | (37.7476530184698, -122.440776661708) | ||||
| 76142 | 76142 | 234859 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 6000570.21064 | 2100519.3738 | 37.7476577875765 | -122.44079113720801 | (37.7476577875765, -122.440791137208) | ||||
| 174541 | 174541 | 234949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 176 Carnelian Way | 1 | : Yard 23 | Tree 1 | Private 1 | 21 | 6000647.81323 | 2100527.14319 | 37.74768353965921 | -122.44052334968599 | (37.7476835396592, -122.440523349686) | ||||
| 35549 | 35549 | 192359 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 3 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015007.494080001 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | ||||
| 33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
| 173611 | 173611 | 192357 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.39086983518801 | (37.7528860304727, -122.390869835188) | ||||
| 74692 | 74692 | 196073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014983.580569999 | 2102134.9117099997 | 37.752904023218605 | -122.391063005979 | (37.7529040232186, -122.391063005979) | ||||
| 132022 | 132022 | 196279 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 6 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.39105995634701 | (37.7529045205317, -122.391059956347) | ||||
| 54292 | 54292 | 192358 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015008.12096 | 2102140.25985 | 37.752920069827 | -122.39097851376499 | (37.752920069827, -122.390978513765) | ||||
| 30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
| 60677 | 60677 | 192360 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 8 | : Yard 23 | Tree 1 | Private 1 | 5 | 6015020.29565 | 2102164.4791599996 | 37.75298724647129 | -122.39093810360399 | (37.7529872464713, -122.390938103604) | ||||
| 158947 | 158947 | 194032 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 25th St | 9 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015018.29801 | 2102168.6663599997 | 37.7529986327902 | -122.39094530450599 | (37.7529986327902, -122.390945304506) | ||||
| 66429 | 66429 | 194526 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 15 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.39104563107401 | (37.7530413020381, -122.391045631074) | ||||
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 186761 | 186761 | 194527 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 16 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.39111409374901 | (37.7530595798584, -122.391114093749) | ||||
| 66873 | 66873 | 196280 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.39093196394501 | (37.7530717153135, -122.390931963945) | ||||
| 130300 | 130300 | 196281 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 12 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015018.372359999 | 2102200.19302 | 37.7530852024401 | -122.39094725063102 | (37.7530852024401, -122.390947250631) | ||||
| 137606 | 137606 | 196282 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 13 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015015.25562 | 2102205.64875 | 37.75310000977571 | -122.39095841029499 | (37.7531000097757, -122.390958410295) | ||||
| 130498 | 130498 | 196075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014963.469190001 | 2102214.24517 | 37.753120740043705 | -122.391138100256 | (37.7531207400437, -122.391138100256) | ||||
| 50679 | 50679 | 199427 | Undocumented 2 | Ficus Spp. :: 253 | 1 25th St | 14 | : Yard 23 | Tree 1 | Private 1 | 3 | 6015002.60045 | 2102216.7826799997 | 37.7531298789641 | -122.391002952844 | (37.7531298789641, -122.391002952844) | ||||
| 133863 | 133863 | 196076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 18 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014971.87416 | 2102223.03647 | 37.753145345506795 | -122.39110964840401 | (37.7531453455068, -122.391109648404) | ||||
| 151585 | 151585 | 196077 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 19 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | ||||
| 60000 | 60000 | 192362 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 20 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | ||||
| 167241 | 167241 | 194528 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 21 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014977.555240001 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | ||||
| 56490 | 56490 | 196563 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 25th St | 22 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014971.47986 | 2102285.2089 | 37.7533160359259 | -122.391115357305 | (37.7533160359259, -122.391115357305) | ||||
| 181215 | 181215 | 194529 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1 25th St | 23 | : Yard 23 | Tree 1 | Private 1 | 2 | 6014967.185409999 | 2102296.35434 | 37.753346400626 | -122.39113098750201 | (37.753346400626, -122.391130987502) | ||||
| 51964 | 51964 | 192363 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014946.149019999 | 2102349.52066 | 37.753491216648705 | -122.39120745237899 | (37.7534912166487, -122.391207452379) | ||||
| 162156 | 162156 | 193474 | Undocumented 2 | Mangifera indica :: Mango 549 | 1310 Indiana St | 25 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014936.17409 | 2102358.6880200002 | 37.7535158347022 | -122.391242588881 | (37.7535158347022, -122.391242588881) | ||||
| 184577 | 184577 | 192373 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 18 | : Yard 23 | Tree 1 | Private 1 | 17 | 6015020.94183 | 2102357.50513 | 37.7535172906979 | -122.390949358625 | (37.7535172906979, -122.390949358625) | ||||
| 53317 | 53317 | 189283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015000.28938 | 2102358.87265 | 37.753519899631904 | -122.391020875425 | (37.7535198996319, -122.391020875425) | ||||
| 25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
| 180257 | 180257 | 189221 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1310 Indiana St | 14 | : Yard 23 | Tree 1 | Private 1 | 1 | 6015010.96324 | 2102373.3642599997 | 37.7535602828051 | -122.39098497537901 | (37.7535602828051, -122.390984975379) | ||||
| 75684 | 75684 | 194428 | Undocumented 2 | Pinus contorta :: Shore Pine 423 | 1310 Indiana St | 13 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014998.917640001 | 2102376.22038 | 37.7535674566975 | -122.391026831646 | (37.7535674566975, -122.391026831646) | ||||
| 151834 | 151834 | 194402 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 1310 Indiana St | 12 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014991.28899 | 2102382.99945 | 37.7535856472653 | -122.39105368718799 | (37.7535856472653, -122.391053687188) | ||||
| 56522 | 56522 | 194260 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 24 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014928.75103 | 2102386.78077 | 37.7535925594679 | -122.391270223251 | (37.7535925594679, -122.391270223251) | ||||
| 31965 | 31965 | 192372 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 11 | : Yard 23 | Tree 1 | Private 1 | 18 | 6015021.64054 | 2102392.08058 | 37.753612266314796 | -122.39094935864401 | (37.7536122663148, -122.390949358644) | ||||
| 74435 | 74435 | 192364 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 23 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014928.1243 | 2102399.042 | 37.7536261914184 | -122.391273247671 | (37.7536261914184, -122.391273247671) | ||||
| 36486 | 36486 | 192371 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 10 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015009.21329 | 2102415.55606 | 37.7536760354269 | -122.390993975811 | (37.7536760354269, -122.390993975811) | ||||
| 164046 | 164046 | 194259 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 22 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014914.86206 | 2102424.38068 | 37.753695030018 | -122.391320882968 | (37.753695030018, -122.391320882968) | ||||
| 70325 | 70325 | 192365 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 21 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014917.078430001 | 2102437.6688900003 | 37.7537316396243 | -122.391314147037 | (37.7537316396243, -122.391314147037) | ||||
| 148293 | 148293 | 192370 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 9 | : Yard 23 | Tree 1 | Private 1 | 8 | 6015014.73228 | 2102443.11605 | 37.7537520155509 | -122.390976815833 | (37.7537520155509, -122.390976815833) | ||||
| 40383 | 40383 | 192366 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 20 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014913.1297 | 2102461.68379 | 37.7537973602844 | -122.39132948139 | (37.7537973602844, -122.39132948139) | ||||
| 171000 | 171000 | 192369 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 8 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014983.64642 | 2102476.35721 | 37.7538415637469 | -122.391086641939 | (37.7538415637469, -122.391086641939) | ||||
| 188821 | 188821 | 192368 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014962.221059999 | 2102496.55555 | 37.753895835135104 | -122.39116214813801 | (37.7538958351351, -122.391162148138) | ||||
| 35640 | 35640 | 192367 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 6 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014979.384930001 | 2102511.0329 | 37.75393653934321 | -122.39110380282101 | (37.7539365393432, -122.391103802821) | ||||
| 136962 | 136962 | 188006 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1310 Indiana St | 5 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014970.94657 | 2102528.93122 | 37.7539852160557 | -122.39113423586399 | (37.7539852160557, -122.391134235864) | ||||
| 75041 | 75041 | 194131 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1310 Indiana St | 4 | : Yard 23 | Tree 1 | Private 1 | 37 | 6014985.85621 | 2102536.5970099997 | 37.754007092062004 | -122.391083210127 | (37.754007092062, -122.391083210127) | ||||
| 153691 | 153691 | 188436 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1310 Indiana St | 3 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014947.70455 | 2102543.51938 | 37.7540239822338 | -122.391215632613 | (37.7540239822338, -122.391215632613) | ||||
| 31493 | 31493 | 188360 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 1310 Indiana St | 19 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014888.31128 | 2102546.96867 | 37.7540301569914 | -122.391421271577 | (37.7540301569914, -122.391421271577) | ||||
| 150778 | 150778 | 188007 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1310 Indiana St | 2 | : Yard 23 | Tree 1 | Private 1 | 9 | 6015000.133780001 | 2102555.57956 | 37.7540600063901 | -122.391035161147 | (37.7540600063901, -122.391035161147) | ||||
| 165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
| 73756 | 73756 | 188569 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 26 | : Yard 23 | Tree 1 | Private 1 | 5 | 6017110.36972 | 2102585.1726599997 | 37.754258135118796 | -122.383739444343 | (37.7542581351188, -122.383739444343) | ||||
| 134718 | 134718 | 196565 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 24th St | 22 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017179.65065 | 2102592.91539 | 37.7542832244069 | -122.38350039013599 | (37.7542832244069, -122.383500390136) | ||||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 181761 | 181761 | 192393 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1 24th St | 25 | : Yard 23 | Tree 1 | Private 1 | 3 | 6017132.65269 | 2102598.1255200002 | 37.7542949326738 | -122.38366328523001 | (37.7542949326738, -122.38366328523) | ||||
| 163742 | 163742 | 189680 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 21 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017213.38014 | 2102597.10976 | 37.754296605427704 | -122.38338403586701 | (37.7542966054277, -122.383384035867) | ||||
| 58003 | 58003 | 189678 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 19 | : Yard 23 | Tree 1 | Private 1 | 15 | 6017295.34569 | 2102596.83049 | 37.7543003681831 | -122.38310055604299 | (37.7543003681831, -122.383100556043) | ||||
| 168798 | 168798 | 196566 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 24th St | 23 | : Yard 23 | Tree 1 | Private 1 | 13 | 6017174.3189900005 | 2102601.55087 | 37.7543066409576 | -122.38351942967199 | (37.7543066409576, -122.383519429672) | ||||
| 98922 | 98922 | 188568 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 24 | : Yard 23 | Tree 1 | Private 1 | 38 | 6017120.705080001 | 2102612.3766799998 | 37.7543334029878 | -122.38370559563499 | (37.7543334029878, -122.383705595635) |
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");