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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56524 | 56524 | 191026 | Undocumented 2 | Cussonia spicata :: Cabbage tree 325 | 1 01st St | 36 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014407.16325 | 2105848.78864 | 37.7630695252734 | -122.39331625017 | (37.7630695252734, -122.39331625017) | ||||
| 59106 | 59106 | 189293 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 35 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014389.3663800005 | 2105866.30731 | 37.7631166389548 | -122.39337903001801 | (37.7631166389548, -122.393379030018) | ||||
| 134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
| 137382 | 137382 | 189292 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 33 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014376.229280001 | 2105886.6133 | 37.763171664875294 | -122.393425888311 | (37.7631716648753, -122.393425888311) | ||||
| 157392 | 157392 | 190908 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1 01st St | 32 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014392.80706 | 2105893.3505 | 37.7631910848138 | -122.393369022367 | (37.7631910848138, -122.393369022367) | ||||
| 58033 | 58033 | 189291 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 31 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014386.77773 | 2105894.3895799997 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | ||||
| 70245 | 70245 | 190636 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 30 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014391.99798 | 2105898.86804 | 37.763206189822796 | -122.393372206868 | (37.7632061898228, -122.393372206868) | ||||
| 73004 | 73004 | 190635 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 28 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014407.37845 | 2105898.42582 | 37.7632058300952 | -122.393318979581 | (37.7632058300952, -122.393318979581) | ||||
| 38723 | 38723 | 191689 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 01st St | 27 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014402.09171 | 2105890.67407 | 37.7631842517621 | -122.393336722306 | (37.7631842517621, -122.393336722306) | ||||
| 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) | ||||
| 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) | ||||
| 152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
| 29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
| 32102 | 32102 | 189290 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 23 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014424.75736 | 2105899.2532900004 | 37.7632090676603 | -122.39325892915501 | (37.7632090676603, -122.393258929155) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 147367 | 147367 | 194594 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 22 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 182983 | 182983 | 194593 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 21 | : Yard 23 | Tree 1 | Private 1 | 19 | 6014441.963140001 | 2105885.02123 | 37.763170945392496 | -122.393198423694 | (37.7631709453925, -122.393198423694) | ||||
| 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) | ||||
| 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) | ||||
| 163548 | 163548 | 189289 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 20 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014461.84726 | 2105889.9963 | 37.76318571047079 | -122.393129998769 | (37.7631857104708, -122.393129998769) | ||||
| 174582 | 174582 | 189679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 20 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017238.946959999 | 2102621.26617 | 37.7543643468473 | -122.383297299846 | (37.7543643468473, -122.383297299846) | ||||
| 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) | ||||
| 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) | ||||
| 137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 153276 | 153276 | 199557 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 18 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 130707 | 130707 | 190965 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 24th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6017293.94065 | 2102634.4333599997 | 37.754403540203796 | -122.38310803210899 | (37.7544035402038, -122.383108032109) | ||||
| 177343 | 177343 | 199556 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 17 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014441.57524 | 2105911.35616 | 37.7632432338158 | -122.39320160818599 | (37.7632432338158, -122.393201608186) | ||||
| 23829 | 23829 | 191740 | Undocumented 2 | Eucalyptus gunnii :: Cider Gum 337 | 1 24th St | 16 | : Yard 23 | Tree 1 | Private 1 | 26 | 6017295.65111 | 2102637.55401 | 37.7544122033759 | -122.383102334025 | (37.7544122033759, -122.383102334025) | ||||
| 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) | ||||
| 59596 | 59596 | 199511 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014447.50245 | 2105911.75995 | 37.7632446718137 | -122.393181136026 | (37.7632446718137, -122.393181136026) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 38976 | 38976 | 199555 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014446.64039 | 2105914.6589900004 | 37.763252584054605 | -122.393184320496 | (37.7632525840546, -122.393184320496) | ||||
| 49572 | 49572 | 189393 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 24th St | 15 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.38314741343201 | (37.7544303427117, -122.383147413432) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 137284 | 137284 | 189677 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017255.58244 | 2102660.6719 | 37.754473466102795 | -122.38324251223801 | (37.7544734661028, -122.383242512238) | ||||
| 153814 | 153814 | 199510 | Undocumented 2 | Quercus engelmannii :: Engelmann oak 453 | 1 01st St | 14 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014434.26374 | 2105920.54159 | 37.7632680488164 | -122.39322753922801 | (37.7632680488164, -122.393227539228) | ||||
| 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) | ||||
| 24708 | 24708 | 199517 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 13 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014420.56618 | 2105901.8129 | 37.763215862946 | -122.39327360428801 | (37.763215862946, -122.393273604288) | ||||
| 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) | ||||
| 115484 | 115484 | 191739 | Undocumented 2 | Eucalyptus gunnii :: Cider Gum 337 | 1 24th St | 13 | : Yard 23 | Tree 1 | Private 1 | 30 | 6017219.14558 | 2102678.7213 | 37.754521012359206 | -122.383369778001 | (37.7545210123592, -122.383369778001) | ||||
| 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) | ||||
| 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) | |||
| 48813 | 48813 | 199516 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 12 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014441.55665 | 2105919.02201 | 37.7632642815347 | -122.393202208925 | (37.7632642815347, -122.393202208925) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 61562 | 61562 | 189676 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 11 | : Yard 23 | Tree 1 | Private 1 | 11 | 6017209.44087 | 2102637.39107 | 37.754406991811294 | -122.383400462871 | (37.7544069918113, -122.383400462871) | ||||
| 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) | ||||
| 134619 | 134619 | 199515 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 11 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014438.12631 | 2105919.24405 | 37.7632647006382 | -122.393214088968 | (37.7632647006382, -122.393214088968) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) |
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");