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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 69201 | 69201 | 234493 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3278 Market St | 1 | : Yard 23 | Tree 1 | Private 1 | 14 | Width 3ft | 5999564.06934 | 2104457.47233 | 37.758413493117104 | -122.444553299888 | (37.7584134931171, -122.444553299888) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 138227 | 138227 | 199545 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.39349639336099 | (37.7632512422621, -122.393496393361) | ||||
| 146754 | 146754 | 240351 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4090 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | |||
| 151521 | 151521 | 223316 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003622.06269 | 2104228.7754599997 | 37.7580162625599 | -122.430502643895 | (37.7580162625599, -122.430502643895) | |||
| 156510 | 156510 | 233334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 91 Stanton St | 1 | : Yard 23 | Tree 1 | Private 1 | 15 | Width 3ft | 6000284.24588 | 2103856.40307 | 37.7568041715962 | -122.442019473547 | (37.7568041715962, -122.442019473547) | |||
| 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) | ||||
| 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) | ||||
| 167772 | 167772 | 245705 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003616.02573 | 2104184.50188 | 37.757894355861396 | -122.430520363245 | (37.7578943558614, -122.430520363245) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 188614 | 188614 | 197467 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 1 | : Yard 23 | Tree 1 | Private 1 | 13 | 6017027.60375 | 2102629.3032400003 | 37.7543747331295 | -122.38402874544799 | (37.7543747331295, -122.384028745448) | ||||
| 25470 | 25470 | 223317 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | |||
| 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) | |||
| 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) | ||||
| 48394 | 48394 | 197468 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 2 | : Yard 23 | Tree 1 | Private 1 | 14 | 6017037.26149 | 2102635.05439 | 37.754391058511295 | -122.38399574663299 | (37.7543910585113, -122.383995746633) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 165472 | 165472 | 199546 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 2 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014366.09507 | 2105920.56167 | 37.7632643166198 | -122.393463315392 | (37.7632643166198, -122.393463315392) | ||||
| 172054 | 172054 | 222663 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003162.223809999 | 2104187.96649 | 37.7578781509761 | -122.43209004713002 | (37.7578781509761, -122.43209004713) | |||
| 186405 | 186405 | 224262 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 91 Stanton St | 2 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6000293.691000001 | 2103856.2070400002 | 37.7568041715846 | -122.44198679486 | (37.7568041715846, -122.44198679486) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 132798 | 132798 | 245706 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003635.70774 | 2104190.5874799998 | 37.7579121804175 | -122.430452728819 | (37.7579121804175, -122.430452728819) | |||
| 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) | ||||
| 156226 | 156226 | 223318 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003637.291809999 | 2104227.88023 | 37.75801466716629 | -122.43044991126101 | (37.7580146671663, -122.430449911261) | |||
| 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) | ||||
| 166837 | 166837 | 199547 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 3 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014373.91679 | 2105917.88241 | 37.763257394541796 | -122.39343607492201 | (37.7632573945418, -122.393436074922) | ||||
| 170165 | 170165 | 197469 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 3 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017071.17305 | 2102662.5786200003 | 37.7544685090175 | -122.383880386982 | (37.7544685090175, -122.383880386982) | ||||
| 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) | |||
| 179643 | 179643 | 222664 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 3 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003149.42788 | 2104190.19818 | 37.7578835531891 | -122.432134460156 | (37.7578835531891, -122.432134460156) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 44358 | 44358 | 245707 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4001 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003651.76342 | 2104178.89616 | 37.7578809883279 | -122.430396367393 | (37.7578809883279, -122.430396367393) | |||
| 48818 | 48818 | 222665 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6003145.04093 | 2104185.04238 | 37.7578691478694 | -122.432149263871 | (37.7578691478694, -122.432149263871) | |||
| 63729 | 63729 | 190751 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 4 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017101.49687 | 2102687.7625599997 | 37.7545393351402 | -122.38377727163 | (37.7545393351402, -122.38377727163) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 171136 | 171136 | 199548 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 4 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014382.11605 | 2105919.95745 | 37.7632635477036 | -122.39340786139499 | (37.7632635477036, -122.393407861395) | ||||
| 171294 | 171294 | 223319 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003647.0575 | 2104227.27295 | 37.7580135529116 | -122.43041609403299 | (37.7580135529116, -122.430416094033) | |||
| 24928 | 24928 | 223320 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.3788 | 2104219.57182 | 37.7579901597246 | -122.430552770305 | (37.7579901597246, -122.430552770305) | |||
| 65367 | 65367 | 222666 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6003140.83414 | 2104172.66898 | 37.7578349349576 | -122.432162929082 | (37.7578349349576, -122.432162929082) | |||
| 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) | |||
| 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) | ||||
| 77285 | 77285 | 221965 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 4001 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6003646.65326 | 2104187.9271299997 | 37.7579054957544 | -122.43041468480699 | (37.7579054957544, -122.430414684807) | |||
| 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) | ||||
| 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) | ||||
| 139126 | 139126 | 199549 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.39337283731399 | (37.7632666242892, -122.393372837314) | ||||
| 150675 | 150675 | 190752 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017117.58441 | 2102700.05767 | 37.7545739842169 | -122.383722492107 | (37.7545739842169, -122.383722492107) | ||||
| 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) | ||||
| 38165 | 38165 | 223321 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.59341 | 2104210.2360400003 | 37.757964538052796 | -122.430551361954 | (37.7579645380528, -122.430551361954) | |||
| 70813 | 70813 | 199550 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 6 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | ||||
| 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) | ||||
| 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) | |||
| 178126 | 178126 | 224454 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 4090 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6003124.6046 | 2104168.08557 | 37.7578214298263 | -122.432218730236 | (37.7578214298263, -122.432218730236) | |||
| 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) | ||||
| 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) | |||
| 41043 | 41043 | 199551 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 7 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.39331641112899 | (37.7632704697891, -122.393316411129) | ||||
| 68242 | 68242 | 223322 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003609.4958 | 2104203.70513 | 37.757946713498704 | -122.430544316686 | (37.7579467134987, -122.430544316686) | |||
| 74715 | 74715 | 234488 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4090 20th St | 7 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003119.17834 | 2104176.3954 | 37.7578439389691 | -122.43223808994101 | (37.7578439389691, -122.432238089941) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 152563 | 152563 | 234500 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 4090 20th St | 8 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6003098.9698 | 2104154.51537 | 37.757782715804204 | -122.43230641682699 | (37.7577827158042, -122.432306416827) | |||
| 170055 | 170055 | 199552 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 8 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.39328625146099 | (37.7632720076265, -122.393286251461) | ||||
| 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) | ||||
| 43379 | 43379 | 223787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4404 20th St | 9 | : Yard 23 | Tree 1 | Private 1 | 44 | Width 3ft | 6003650.35726 | 2104229.2336 | 37.75801912330729 | -122.430404821951 | (37.7580191233073, -122.430404821951) | |||
| 76538 | 76538 | 199553 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 9 | : Yard 23 | Tree 1 | Private 1 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 162377 | 162377 | 194033 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 9 | : Yard 23 | Tree 1 | Private 1 | 18 | 6017162.02159 | 2102667.2446 | 37.7544863425722 | -122.383566530788 | (37.7544863425722, -122.383566530788) | ||||
| 164374 | 164374 | 222115 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4090 20th St | 9 | : Yard 23 | Tree 1 | Private 1 | 15 | Width 3ft | 6003100.58415 | 2104168.90978 | 37.757822330949004 | -122.432301861758 | (37.757822330949, -122.432301861758) | |||
| 28022 | 28022 | 189675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 10 | : Yard 23 | Tree 1 | Private 1 | 8 | 6017194.50129 | 2102669.93128 | 37.754495514781496 | -122.383454393407 | (37.7544955147815, -122.383454393407) | ||||
| 28405 | 28405 | 199554 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 10 | : Yard 23 | Tree 1 | Private 1 | 17 | 6014431.6868199995 | 2105923.15598 | 37.763275084200295 | -122.39323663496599 | (37.7632750842003, -122.393236634966) | ||||
| 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) | ||||
| 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) | ||||
| 75344 | 75344 | 233331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4404 20th St | 10 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003656.39078 | 2104225.45781 | 37.7580090976571 | -122.430383686085 | (37.7580090976571, -122.430383686085) | |||
| 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) | |||
| 157410 | 157410 | 233500 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 4090 20th St | 10 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.43231097188601 | (37.7578610449587, -122.432310971886) | |||
| 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) |
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");