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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8599 | 8599 | 96031 | Permitted Site 1 | Psidium guajava :: Guava tree 252 | 1116 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 20 | Permit Number 767346 | 6007512.843169999 | 2119899.46213 | 37.8012638333238 | -122.418157616905 | (37.8012638333238, -122.418157616905) | ||
| 23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
| 25060 | 25060 | 85220 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 3 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.776221041753296 | -122.48131384215401 | (37.7762210417533, -122.481313842154) | ||
| 28493 | 28493 | 92501 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 2 | : 4 | Tree 1 | Private 1 | 24 | 6013077.25048 | 2110692.4491 | 37.7762951549369 | -122.398255852047 | (37.7762951549369, -122.398255852047) | ||||
| 29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
| 34923 | 34923 | 196938 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1675 Howard St | 1 | : 4 | Tree 1 | Private 1 | 7 | 6007452.5571800005 | 2108703.80636 | 37.7705199011999 | -122.417572293134 | (37.7705199011999, -122.417572293134) | ||||
| 35275 | 35275 | 223973 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3977 22nd St | 3 | : 4 | Tree 1 | Private 1 | 15 | 6001912.30882 | 2102919.7297900002 | 37.754324934974704 | -122.436322006668 | (37.7543249349747, -122.436322006668) | ||||
| 35354 | 35354 | 194072 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2280 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | 6011322.76778 | 2098041.04793 | 37.7414593371741 | -122.40343486513399 | (37.7414593371741, -122.403434865134) | ||||
| 37008 | 37008 | 189993 | Undocumented 2 | Chamaecyparis lawsoniana :: Port Orford Cedar 378 | 1791 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6014078.264280001 | 2095121.8090099997 | 37.733597231818294 | -122.393702958643 | (37.7335972318183, -122.393702958643) | ||||
| 38291 | 38291 | 223754 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3980 22nd St | 4 | : 4 | Tree 1 | Private 1 | 8 | 6001944.38394 | 2102944.60727 | 37.754395065001795 | -122.436212863153 | (37.7543950650018, -122.436212863153) | ||||
| 41205 | 41205 | 234007 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 3978 22nd St | 1 | : 4 | Tree 1 | Private 1 | 12 | 6001985.80169 | 2102958.64311 | 37.7544359571599 | -122.43607063447399 | (37.7544359571599, -122.436070634474) | ||||
| 42670 | 42670 | 85223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013205.26566 | 2109218.0492700003 | 37.7722539164092 | -122.397709569661 | (37.7722539164092, -122.397709569661) | ||
| 42782 | 42782 | 232102 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 3974 22nd St | 2 | : 4 | Tree 1 | Private 1 | 4 | 6002009.98359 | 2102946.50265 | 37.7544039961563 | -122.435986138674 | (37.7544039961563, -122.435986138674) | ||||
| 43035 | 43035 | 89163 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 370 03rd St | 2 | : 4 | Tree 1 | Private 1 | 16 | 6013087.00779 | 2113212.8469599998 | 37.783216133267295 | -122.39839898634399 | (37.7832161332673, -122.398398986344) | ||||
| 46225 | 46225 | 233148 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3980 22nd St | 10 | : 4 | Tree 1 | Private 1 | 6 | 6001886.52284 | 2102943.06219 | 37.7543875349734 | -122.4364128508 | (37.7543875349734, -122.4364128508) | ||||
| 47597 | 47597 | 188667 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Dorman Ave | 2 | : 4 | Tree 1 | Private 1 | 24 | 6011636.48706 | 2097465.68323 | 37.7398970259256 | -122.402309681047 | (37.7398970259256, -122.402309681047) | ||||
| 49427 | 49427 | 85218 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989075.71612 | 2111192.27037 | 37.7763013532486 | -122.481319447652 | (37.7763013532486, -122.481319447652) | ||
| 54411 | 54411 | 234398 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3980 22nd St | 8 | : 4 | Tree 1 | Private 1 | 32 | 6001905.073469999 | 2102956.38941 | 37.7544251823875 | -122.436349651817 | (37.7544251823875, -122.436349651817) | ||||
| 58582 | 58582 | 194070 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 41 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.40272769043501 | (37.7396392352499, -122.402727690435) | ||||
| 58614 | 58614 | 233147 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3978 22nd St | 3 | : 4 | Tree 1 | Private 1 | 2 | 6001977.86453 | 2102958.17095 | 37.7544342097936 | -122.43609804939899 | (37.7544342097936, -122.436098049399) | ||||
| 59958 | 59958 | 236142 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3977 22nd St | 4 | : 4 | Tree 1 | Private 1 | 14 | 6001927.54464 | 2102912.4498900003 | 37.7543058117913 | -122.436268796465 | (37.7543058117913, -122.436268796465) | ||||
| 63293 | 63293 | 221406 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 1 | : 4 | Tree 1 | Private 1 | 11 | 6001983.388259999 | 2102912.1826400002 | 37.7543082507347 | -122.43607565629 | (37.7543082507347, -122.43607565629) | ||||
| 65577 | 65577 | 194073 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2275 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | 6011416.20922 | 2097909.60407 | 37.741103639116 | -122.403102531469 | (37.741103639116, -122.403102531469) | ||||
| 66795 | 66795 | 239604 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3980 22nd St | 1 | : 4 | Tree 1 | Private 1 | 1 | 6001965.58933 | 2102953.1428400003 | 37.754419706414396 | -122.436140140357 | (37.7544197064144, -122.436140140357) | ||||
| 71883 | 71883 | 231780 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3980 22nd St | 3 | : 4 | Tree 1 | Private 1 | 1 | 6001950.55974 | 2102952.70608 | 37.7544176532747 | -122.43619208522101 | (37.7544176532747, -122.436192085221) | ||||
| 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) | ||||
| 79586 | 79586 | 94645 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 30 Middle Point Rd | 34 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 108522 | 108522 | 113066 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 7 | : 4 | Tree 1 | DPW 2 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 109421 | 109421 | 194074 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | 6011541.53422 | 2097819.64053 | 37.7408636163769 | -122.40266287538999 | (37.7408636163769, -122.40266287539) | ||||
| 113544 | 113544 | 94646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Middle Point Rd | 35 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
| 117769 | 117769 | 115188 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 5 | : 4 | Tree 1 | DPW 2 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | ||||
| 135233 | 135233 | 240289 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 7 | : 4 | Tree 1 | Private 1 | 13 | 6001910.30544 | 2102943.06886 | 37.7543889046321 | -122.436330605077 | (37.7543889046321, -122.436330605077) | ||||
| 137822 | 137822 | 103130 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 418 28th Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | 5987189.392469999 | 2113118.1924900003 | 37.781479539688505 | -122.487986220863 | (37.7814795396885, -122.487986220863) | ||||
| 140036 | 140036 | 105148 | Permitted Site 1 | Tree(s) :: 17 | 185 Stratford Dr | : 4 | Tree 1 | Private 1 | 12/26/2013 12:00:00 AM | Permit Number 770387 | 5990916.9 | 2091282.3 | 37.7217406386467 | -122.473497746062 | (37.7217406386467, -122.473497746062) | ||||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 147668 | 147668 | 187743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Dukes Ct | 1 | : 4 | Tree 1 | Private 1 | 19 | 6016146.18996 | 2096242.03151 | 37.736787833093096 | -122.386631563293 | (37.7367878330931, -122.386631563293) | ||||
| 149852 | 149852 | 233316 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3980 22nd St | 9 | : 4 | Tree 1 | Private 1 | 8 | 6001893.377180001 | 2102947.6571 | 37.7544005409683 | -122.43638947561001 | (37.7544005409683, -122.43638947561) | ||||
| 153415 | 153415 | 223755 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3980 22nd St | 6 | : 4 | Tree 1 | Private 1 | 12 | 6001922.63409 | 2102946.0543299997 | 37.7543978025168 | -122.436288183156 | (37.7543978025168, -122.436288183156) | ||||
| 157200 | 157200 | 92502 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 05th St | 3 | : 4 | Tree 1 | Private 1 | 23 | 6013059.80814 | 2110709.8757599997 | 37.776342032988296 | -122.39831741332199 | (37.7763420329883, -122.398317413322) | ||||
| 157888 | 157888 | 190136 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 78 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | 6011218.70135 | 2097332.49038 | 37.739507976518105 | -122.40374484797199 | (37.7395079765181, -122.403744847972) | ||||
| 158311 | 158311 | 188666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 40 | 6011771.1347199995 | 2097510.17605 | 37.740026709069795 | -122.40184724967199 | (37.7400267090698, -122.401847249672) | ||||
| 160756 | 160756 | 223753 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3978 22nd St | 2 | : 4 | Tree 1 | Private 1 | 17 | 6001987.952740001 | 2102949.8404200003 | 37.7544119092884 | -122.436062565734 | (37.7544119092884, -122.436062565734) | ||||
| 162208 | 162208 | 194502 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 299 Cashmere St | 17 | : 4 | Tree 1 | Private 1 | 14 | 6016706.5669 | 2095967.5431400002 | 37.7360651504892 | -122.38467496140301 | (37.7360651504892, -122.384674961403) | ||||
| 165999 | 165999 | 199400 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 299 Cashmere St | 16 | : 4 | Tree 1 | Private 1 | 38 | 6016698.52819 | 2095954.85127 | 37.7360298565815 | -122.384701870897 | (37.7360298565815, -122.384701870897) | ||||
| 170711 | 170711 | 221407 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 2 | : 4 | Tree 1 | Private 1 | 11 | 6001990.14587 | 2102921.253 | 37.7543335396806 | -122.436052935814 | (37.7543335396806, -122.436052935814) | ||||
| 172073 | 172073 | 85219 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 2 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.796080001 | 2111176.31145 | 37.77625759727871 | -122.481314542866 | (37.7762575972787, -122.481314542866) | ||
| 172327 | 172327 | 194517 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 15 Reuel Ct | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017370.3907699995 | 2096095.6605599998 | 37.7364536252419 | -122.382388741749 | (37.7364536252419, -122.382388741749) | ||||
| 173838 | 173838 | 239665 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3977 22nd St | 7 | : 4 | Tree 1 | Private 1 | 1 | 6001970.62949 | 2102924.4427900002 | 37.7543411893077 | -122.436120656556 | (37.7543411893077, -122.436120656556) | ||||
| 178052 | 178052 | 220578 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 3980 22nd St | 5 | : 4 | Tree 1 | Private 1 | 9 | 6001940.74385 | 2102950.1671 | 37.7544101241454 | -122.43622584935899 | (37.7544101241454, -122.436225849359) | ||||
| 178327 | 178327 | 221408 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 3 | : 4 | Tree 1 | Private 1 | 11 | 6001990.46485 | 2102928.2110200003 | 37.7543526628574 | -122.43605233056999 | (37.7543526628574, -122.43605233057) | ||||
| 179437 | 179437 | 237912 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3974 22nd St | 3 | : 4 | Tree 1 | Private 1 | 20 | 6002002.928859999 | 2102961.58207 | 37.7544449998516 | -122.436011614667 | (37.7544449998516, -122.436011614667) | ||||
| 181266 | 181266 | 194071 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2260 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | 6011443.9729 | 2097950.47892 | 37.7412174231363 | -122.403009408459 | (37.7412174231363, -122.403009408459) | ||||
| 184168 | 184168 | 223976 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Gough St | 1 | : 4 | Tree 1 | Private 1 | 24 | 6006664.524230001 | 2109235.5502400002 | 37.771935569896996 | -122.420335857614 | (37.771935569897, -122.420335857614) | ||||
| 3873 | 3873 | 228872 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | : 4 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 4x7 | Permit Number 780415 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.42927346400101 | (37.7698314611737, -122.429273464001) | |
| 22878 | 22878 | 211497 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991316.04145 | 2093239.9376700001 | 37.7271389322076 | -122.472260663898 | (37.7271389322076, -122.472260663898) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
| 25051 | 25051 | 204106 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 15 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991380.91771 | 2094122.22642 | 37.7295652311304 | -122.47210067183399 | (37.7295652311304, -122.472100671834) | |||
| 25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
| 25171 | 25171 | 211740 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Junipero Serra Blvd | 63 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991241.75535 | 2092369.0008200002 | 37.72474325697279 | -122.47245400105601 | (37.7247432569728, -122.472454001056) | |||
| 25562 | 25562 | 204156 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 106 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.12525 | 2090380.53407 | 37.719277536403496 | -122.472660407165 | (37.7192775364035, -122.472660407165) | |||
| 25615 | 25615 | 178137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992316.61451 | 2087859.0919400002 | 37.712422298533895 | -122.46841041712901 | (37.7124222985339, -122.468410417129) | |||
| 26232 | 26232 | 211495 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 65 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991310.32822 | 2093255.28671 | 37.72718074619429 | -122.472281532691 | (37.7271807461943, -122.472281532691) | |||
| 26683 | 26683 | 206855 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5991362.72494 | 2093965.51745 | 37.7291338947086 | -122.472152147225 | (37.7291338947086, -122.472152147225) | |||
| 26935 | 26935 | 204142 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 126 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991215.491640001 | 2091740.4912900003 | 37.7230160055721 | -122.47249899053001 | (37.7230160055721, -122.47249899053) | |||
| 27022 | 27022 | 211487 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 300 Junipero Serra Blvd | 26 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991384.264769999 | 2094458.5137 | 37.730488785420704 | -122.47211360318701 | (37.7304887854207, -122.472113603187) | |||
| 27049 | 27049 | 215254 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991351.0324800005 | 2093792.6407400002 | 37.7286585418478 | -122.472179972231 | (37.7286585418478, -122.472179972231) | |||
| 27339 | 27339 | 178600 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5989476.93903 | 2093627.59215 | 37.7280967254778 | -122.478646687712 | (37.7280967254778, -122.478646687712) | |||
| 27602 | 27602 | 178277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5987671.03855 | 2088779.0413099998 | 37.7146788207357 | -122.484534178617 | (37.7146788207357, -122.484534178617) | |||
| 27988 | 27988 | 206453 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 38 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991335.3896699995 | 2093546.9091299998 | 37.72798291897001 | -122.47221614476999 | (37.72798291897, -122.47221614477) | |||
| 28008 | 28008 | 211205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 151 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991189.83716 | 2091473.3519099997 | 37.72228102203729 | -122.472568205077 | (37.7222810220373, -122.472568205077) | |||
| 28326 | 28326 | 215253 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991347.53031 | 2093798.3248599998 | 37.7286739463434 | -122.47219249348998 | (37.7286739463434, -122.47219249349) | |||
| 28511 | 28511 | 176155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 9 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5988052.58895 | 2088755.4955 | 37.71463638173179 | -122.48321367528798 | (37.7146363817318, -122.483213675288) | |||
| 28705 | 28705 | 206872 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991149.64989 | 2090725.7488 | 37.7202259623434 | -122.47265264062 | (37.7202259623434, -122.47265264062) | |||
| 29056 | 29056 | 219541 | Undocumented 2 | Ulmus americana :: American Elm 119 | 300 Junipero Serra Blvd | 20 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5991386.1412 | 2094492.53294 | 37.730582302308896 | -122.472109594875 | (37.7305823023089, -122.472109594875) | |||
| 29067 | 29067 | 211025 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 95 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.723956281843705 | -122.472457461651 | (37.7239562818437, -122.472457461651) | |||
| 29175 | 29175 | 219547 | Undocumented 2 | Ulmus americana :: American Elm 119 | 500 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991319.77336 | 2093416.99308 | 37.727625298167204 | -122.47226066389999 | (37.7276252981672, -122.4722606639) | |||
| 29263 | 29263 | 208368 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 58 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991246.556369999 | 2092406.78265 | 37.7248472743708 | -122.472440157794 | (37.7248472743708, -122.472440157794) | |||
| 29429 | 29429 | 176035 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Junipero Serra Blvd | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991271.23185 | 2089055.1505099998 | 37.7156459462668 | -122.472110669573 | (37.7156459462668, -122.472110669573) | |||
| 29593 | 29593 | 204122 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 72 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991266.86488 | 2092279.49348 | 37.7244989453441 | -122.472360679302 | (37.7244989453441, -122.472360679302) | |||
| 29819 | 29819 | 211182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 300 Junipero Serra Blvd | 19 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991394.30224 | 2094494.67005 | 37.7305886425487 | -122.47208153692699 | (37.7305886425487, -122.472081536927) | |||
| 29859 | 29859 | 178135 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992385.6999699995 | 2087851.7958799999 | 37.7124062555186 | -122.46817110840401 | (37.7124062555186, -122.468171108404) | |||
| 29922 | 29922 | 215600 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5991265.7011400005 | 2092317.6532400001 | 37.724603655215894 | -122.472367482699 | (37.7246036552159, -122.472367482699) | |||
| 30069 | 30069 | 215263 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991309.897609999 | 2093234.8571099997 | 37.727124626686795 | -122.47228153268298 | (37.7271246266868, -122.472281532683) | |||
| 31270 | 31270 | 204114 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Junipero Serra Blvd | 61 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991316.326090001 | 2093291.62937 | 37.727280881195604 | -122.472263446404 | (37.7272808811956, -122.472263446404) | |||
| 32065 | 32065 | 178289 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 18 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5988700.42615 | 2088712.0601 | 37.71455479883021 | -122.480971333587 | (37.7145547988302, -122.480971333587) | |||
| 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) | |||
| 32467 | 32467 | 213749 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 300 Junipero Serra Blvd | 35 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991393.22767 | 2094416.1838099998 | 37.730373076833 | -122.472079533242 | (37.730373076833, -122.472079533242) | |||
| 32663 | 32663 | 211491 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 20 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991339.7288 | 2093695.49673 | 37.7283911545133 | -122.472211971033 | (37.7283911545133, -122.472211971033) | |||
| 32909 | 32909 | 204147 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 143 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991215.11855 | 2091556.56269 | 37.7225109615814 | -122.47248687756 | (37.7225109615814, -122.47248687756) | |||
| 33005 | 33005 | 211017 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.724986969654495 | -122.47240103009399 | (37.7249869696545, -122.472401030094) | |||
| 33080 | 33080 | 215260 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991332.77888 | 2093518.51077 | 37.7279047930719 | -122.472223101042 | (37.7279047930719, -122.472223101042) | |||
| 33743 | 33743 | 213275 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991009.60744 | 2091179.22643 | 37.7214629924139 | -122.473169770586 | (37.7214629924139, -122.473169770586) | |||
| 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) | |||
| 34026 | 34026 | 204127 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 91 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991259.14537 | 2092125.38495 | 37.7240753547864 | -122.472376135061 | (37.7240753547864, -122.472376135061) | |||
| 34161 | 34161 | 178282 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5988239.0242099995 | 2088743.05539 | 37.7146130722195 | -122.482568375746 | (37.7146130722195, -122.482568375746) | |||
| 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) | |||
| 34648 | 34648 | 215261 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991310.9639 | 2093247.2582599998 | 37.7271587388628 | -122.47227875017799 | (37.7271587388628, -122.472278750178) | |||
| 34816 | 34816 | 215255 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991357.82029 | 2093790.0929299998 | 37.7286519390174 | -122.47215632095501 | (37.7286519390174, -122.472156320955) |
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");