Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34485 | 34485 | 196775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013724.81339 | 2108580.1885900004 | 37.7705314116112 | -122.395867690649 | (37.7705314116112, -122.395867690649) | ||||
34583 | 34583 | 197479 | DPW Maintained 3 | Schefflera species :: Umbrella tree 386 | 1700x Quesada Ave | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6014300.68484 | 2095327.0716 | 37.734173198123706 | -122.392948336615 | (37.7341731981237, -122.392948336615) | ||||
34680 | 34680 | 210208 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5993586.63469 | 2096365.42652 | 37.7358519005501 | -122.464638167637 | (37.7358519005501, -122.464638167637) | ||||
35273 | 35273 | 233937 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.42647045077801 | (37.7655506342911, -122.426470450778) | ||||
35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
35411 | 35411 | 190035 | DPW Maintained 3 | Chiranthodendron pentadactylon :: Monkey Hand Tree 388 | 1300x De Haro St | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012271.55994 | 2101940.28585 | 37.7522187560075 | -122.40042807090599 | (37.7522187560075, -122.400428070906) | ||||
35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
35636 | 35636 | 187736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016350.44721 | 2096194.4230400003 | 37.7366684157019 | -122.38592203240101 | (37.7366684157019, -122.385922032401) | ||||
35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
35659 | 35659 | 135604 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014333.85609 | 2117662.37655 | 37.7955028896086 | -122.394397008632 | (37.7955028896086, -122.394397008632) | ||||
35685 | 35685 | 244827 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1450x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6005245.250469999 | 2099669.70272 | 37.745589922449604 | -122.424564667746 | (37.7455899224496, -122.424564667746) | ||||
35780 | 35780 | 128877 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.0884300005 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | ||||
35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
36172 | 36172 | 194506 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016624.93937 | 2096021.7822099999 | 37.7362095654157 | -122.38496096110501 | (37.7362095654157, -122.384960961105) | ||||
36297 | 36297 | 211100 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 198x San Anselmo Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993653.9743 | 2096326.24073 | 37.735748188020395 | -122.464402505688 | (37.7357481880204, -122.464402505688) | ||||
36505 | 36505 | 135612 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014267.8224 | 2117757.0986900004 | 37.7957593033995 | -122.39463213458201 | (37.7957593033995, -122.394632134582) | ||||
36635 | 36635 | 189990 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016227.39671 | 2096690.1847299999 | 37.7380228666701 | -122.386382030231 | (37.7380228666701, -122.386382030231) | ||||
36701 | 36701 | 194508 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | ||||
36932 | 36932 | 211104 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) | ||||
36942 | 36942 | 197374 | DPW Maintained 3 | Robinia pseudoacacia :: Black Locust 169 | 950x Kansas St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6011591.5235 | 2103896.27295 | 37.7575515198905 | -122.402917314288 | (37.7575515198905, -122.402917314288) | ||||
37011 | 37011 | 187739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016069.71075 | 2096081.9732700002 | 37.736344111196 | -122.38688482859399 | (37.736344111196, -122.386884828594) | ||||
37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
37585 | 37585 | 189333 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016146.37557 | 2096749.3676 | 37.738180885651104 | -122.38666628881701 | (37.7381808856511, -122.386666288817) | ||||
37625 | 37625 | 119298 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5986043.64284 | 2112521.4673099997 | 37.77977419975021 | -122.491905961239 | (37.7797741997502, -122.491905961239) | ||||
37718 | 37718 | 197172 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 900x Carolina St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012477.22941 | 2103487.19338 | 37.756477694309204 | -122.39982544148998 | (37.7564776943092, -122.39982544149) | ||||
37982 | 37982 | 237111 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Coso Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | ||||
38054 | 38054 | 188001 | DPW Maintained 3 | Araucaria columnaris :: Coral reef araucaria 185 | 900x Carolina St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012468.44405 | 2103516.87619 | 37.7565587070327 | -122.399857908825 | (37.7565587070327, -122.399857908825) | ||||
38595 | 38595 | 234356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004985.9304599995 | 2104422.99085 | 37.7586266989802 | -122.42579962935301 | (37.7586266989802, -122.425799629353) | ||||
38640 | 38640 | 191369 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | ||||
38785 | 38785 | 136006 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007669.82361 | 2118117.1353700003 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | ||||
39338 | 39338 | 248648 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002994.42779 | 2095088.08837 | 37.7328824938235 | -122.432020555603 | (37.7328824938235, -122.432020555603) | ||||
39373 | 39373 | 206819 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5993645.71889 | 2101030.10757 | 37.7486633474324 | -122.46477253084 | (37.7486633474324, -122.46477253084) | ||||
39455 | 39455 | 211655 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993781.5938099995 | 2096511.3140900002 | 37.736263709102296 | -122.46397470897301 | (37.7362637091023, -122.463974708973) | ||||
39483 | 39483 | 211654 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993772.928590001 | 2096520.6347700001 | 37.7362888019871 | -122.464005344374 | (37.7362888019871, -122.464005344374) | ||||
39703 | 39703 | 119297 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6700x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5986078.135009999 | 2112521.2781700003 | 37.7797756964263 | -122.491786625446 | (37.7797756964263, -122.491786625446) | ||||
39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
39942 | 39942 | 194507 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016618.68245 | 2096023.0251200001 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | ||||
40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
40086 | 40086 | 190990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6016177.273030001 | 2096204.98812 | 37.7366878401785 | -122.38652151236201 | (37.7366878401785, -122.386521512362) | ||||
40179 | 40179 | 194448 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1300x De Haro St | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012284.461 | 2102001.80848 | 37.752388403216294 | -122.400387777686 | (37.7523884032163, -122.400387777686) | ||||
40612 | 40612 | 193546 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012511.31155 | 2102952.5131599996 | 37.7550114792069 | -122.39967003234699 | (37.7550114792069, -122.399670032347) | ||||
40706 | 40706 | 206477 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993822.05067 | 2096524.01563 | 37.7363009158535 | -122.463835755623 | (37.7363009158535, -122.463835755623) | ||||
40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
40944 | 40944 | 189323 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 301x Cashmere St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016365.09613 | 2096197.7024299998 | 37.736678230916795 | -122.38587161279499 | (37.7366782309168, -122.385871612795) | ||||
41120 | 41120 | 233936 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.42647963012699 | (37.7656304545194, -122.426479630127) | ||||
41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
41196 | 41196 | 209133 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6001054.84945 | 2095714.1457200001 | 37.734491350384005 | -122.43877100628 | (37.734491350384, -122.43877100628) | ||||
41450 | 41450 | 189322 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6016409.152290001 | 2096168.4415799999 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | ||||
41518 | 41518 | 203592 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1485x Northwood Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995892.33391 | 2093907.44512 | 37.729235533389705 | -122.45648881700899 | (37.7292355333897, -122.456488817009) | ||||
41584 | 41584 | 246869 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 3090x Market St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5999937.78249 | 2105312.2028200002 | 37.7607816895477 | -122.443322229632 | (37.7607816895477, -122.443322229632) | ||||
41904 | 41904 | 188655 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.38154925430099 | (37.7428536469791, -122.381549254301) | ||||
41943 | 41943 | 218261 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5992797.06764 | 2097201.3875599997 | 37.738101689549296 | -122.467428758544 | (37.7381016895493, -122.467428758544) | ||||
41956 | 41956 | 246886 | DPW Maintained 3 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3090x Market St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5999895.8145 | 2105286.9731 | 37.7607100216774 | -122.443465565401 | (37.7607100216774, -122.443465565401) | ||||
42314 | 42314 | 212140 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995385.5779099995 | 2093583.7848200002 | 37.728317733874704 | -122.458217288803 | (37.7283177338747, -122.458217288803) | ||||
42374 | 42374 | 192668 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 299x Cashmere St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016780.4943 | 2095894.1585799998 | 37.73586773939579 | -122.384414252424 | (37.7358677393958, -122.384414252424) | ||||
42524 | 42524 | 189228 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1300x De Haro St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012274.4793300005 | 2102155.74686 | 37.752810527903 | -122.40043310802 | (37.752810527903, -122.40043310802) | ||||
42786 | 42786 | 234419 | DPW Maintained 3 | Phoenix spp :: Date palm (species unknown) 319 | 200x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004837.25989 | 2107079.17093 | 37.765911535819896 | -122.426502931588 | (37.7659115358199, -122.426502931588) | ||||
43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
43126 | 43126 | 189335 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.38669889463301 | (37.7381987371688, -122.386698894633) | ||||
43128 | 43128 | 196270 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | ||||
43272 | 43272 | 234521 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 5200x Diamond Heights Blvd | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6001544.419530001 | 2098938.9857400004 | 37.7433738490244 | -122.437309239227 | (37.7433738490244, -122.437309239227) | ||||
43499 | 43499 | 204970 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995394.3543300005 | 2093951.39661 | 37.729327611382 | -122.458213544044 | (37.729327611382, -122.458213544044) | ||||
43585 | 43585 | 212135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995377.611959999 | 2093148.71744 | 37.7271226859638 | -122.45821335156201 | (37.7271226859638, -122.458213351562) | ||||
43629 | 43629 | 211101 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5993549.05492 | 2100852.54328 | 37.7481702275711 | -122.465093896362 | (37.7481702275711, -122.465093896362) | ||||
44024 | 44024 | 135602 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014349.4143900005 | 2117640.04464 | 37.7954424362789 | -122.39434160947901 | (37.7954424362789, -122.394341609479) | ||||
44208 | 44208 | 135607 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014352.16969 | 2117713.37896 | 37.7956439482691 | -122.394337212703 | (37.7956439482691, -122.394337212703) | ||||
44332 | 44332 | 188644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | ||||
44401 | 44401 | 126600 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1820x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006102.71241 | 2116870.57968 | 37.7928678157445 | -122.42282191472201 | (37.7928678157445, -122.422821914722) | ||||
44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
44746 | 44746 | 212150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995395.95716 | 2094183.25498 | 37.72996433048829 | -122.45822477747 | (37.7299643304883, -122.45822477747) | ||||
45496 | 45496 | 247037 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 550x Valley St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6002254.50848 | 2099154.508 | 37.744005964510606 | -122.434869346159 | (37.7440059645106, -122.434869346159) | ||||
45589 | 45589 | 191045 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012497.15794 | 2103097.51934 | 37.755408845542895 | -122.399729160991 | (37.7554088455429, -122.399729160991) | ||||
46004 | 46004 | 212540 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | ||||
46065 | 46065 | 205754 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Terrace Dr | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993872.8693 | 2096472.5281599998 | 37.7361624724174 | -122.46365632018 | (37.7361624724174, -122.46365632018) | ||||
46296 | 46296 | 194557 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 900x Carolina St | 69 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.39964421193301 | (37.7546723295715, -122.399644211933) | ||||
46910 | 46910 | 116450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6016873.48707 | 2095860.59847 | 37.735780731778895 | -122.384090400246 | (37.7357807317789, -122.384090400246) | ||||
47301 | 47301 | 196777 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6013719.28205 | 2108540.3195 | 37.7704216322684 | -122.39588402954901 | (37.7704216322684, -122.395884029549) | ||||
47467 | 47467 | 211597 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993315.91751 | 2096029.3267299999 | 37.734913443583004 | -122.46554972673701 | (37.734913443583, -122.465549726737) | ||||
47477 | 47477 | 234367 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | ||||
47682 | 47682 | 207809 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 200x Terrace Dr | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993795.90954 | 2096545.0474900003 | 37.736357157655604 | -122.46392766184601 | (37.7363571576556, -122.463927661846) | ||||
47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
47939 | 47939 | 211068 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | ||||
47964 | 47964 | 234371 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | ||||
48117 | 48117 | 192670 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 301x Cashmere St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6016106.910759999 | 2096136.4323599997 | 37.7364957045196 | -122.386760008065 | (37.7364957045196, -122.386760008065) | ||||
48244 | 48244 | 220434 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2x Coso Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.41804026077601 | (37.746130149684, -122.418040260776) | ||||
48270 | 48270 | 212154 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995400.46902 | 2094347.10151 | 37.7304144726506 | -122.458221033597 | (37.7304144726506, -122.458221033597) | ||||
48350 | 48350 | 135606 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014317.5714300005 | 2117686.49478 | 37.795568207348104 | -122.394455046367 | (37.7955682073481, -122.394455046367) | ||||
48651 | 48651 | 212130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995375.50202 | 2092861.84028 | 37.726334869051705 | -122.458199891406 | (37.7263348690517, -122.458199891406) | ||||
48845 | 48845 | 206816 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993579.5371900005 | 2100911.34414 | 37.7483334374322 | -122.46499276043001 | (37.7483334374322, -122.46499276043) | ||||
48906 | 48906 | 211441 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993812.00301 | 2096546.48985 | 37.7363620454614 | -122.463872125093 | (37.7363620454614, -122.463872125093) | ||||
49014 | 49014 | 194514 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016024.76116 | 2095911.2144799998 | 37.7358727531167 | -122.387028333393 | (37.7358727531167, -122.387028333393) | ||||
49060 | 49060 | 212149 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995397.3757 | 2094149.6680599998 | 37.7298721904459 | -122.45821744347602 | (37.7298721904459, -122.458217443476) | ||||
49072 | 49072 | 119929 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5987119.54861 | 2112558.01872 | 37.779937387281706 | -122.48818666733801 | (37.7799373872817, -122.488186667338) | ||||
49252 | 49252 | 233940 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004851.53435 | 2106800.76384 | 37.7651479034782 | -122.426433734123 | (37.7651479034782, -122.426433734123) | ||||
49481 | 49481 | 206479 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5993821.596580001 | 2096532.5334599998 | 37.73632427753171 | -122.463837943662 | (37.7363242775317, -122.463837943662) | ||||
49497 | 49497 | 215224 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 400x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 5995369.41897 | 2092571.1657099999 | 37.7255363969609 | -122.45819989143101 | (37.7255363969609, -122.458199891431) | ||||
49522 | 49522 | 193547 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 65 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.839980001 | 2102871.66546 | 37.7547897972265 | -122.39964523714501 | (37.7547897972265, -122.399645237145) | ||||
49786 | 49786 | 249475 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006389.52859 | 2114780.4065099997 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) |
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");