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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
35716 | 35716 | 194337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015953.29851 | 2112409.5704799998 | 37.781169770014294 | -122.38842659752198 | (37.7811697700143, -122.388426597522) | |||
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) | ||||
35824 | 35824 | 131007 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013687.07221 | 2117423.5151299997 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | |||
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) | ||||
36397 | 36397 | 195772 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013930.44742 | 2110363.9939599996 | 37.7754407791936 | -122.395281372244 | (37.7754407791936, -122.395281372244) | |||
36478 | 36478 | 133192 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | |||
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) | ||||
36823 | 36823 | 246562 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | |||
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) | ||||
37068 | 37068 | 208271 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | |||
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) | ||||
37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) | |||
37381 | 37381 | 220716 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6009255.72081 | 2100578.93816 | 37.74831215498521 | -122.410761220066 | (37.7483121549852, -122.410761220066) | |||
37384 | 37384 | 211111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 5994189.10111 | 2101103.38332 | 37.7488958572711 | -122.462898850009 | (37.7488958572711, -122.462898850009) | |||
37406 | 37406 | 222810 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3400x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 6006867.8232 | 2100561.0017 | 37.7481287283566 | -122.41901725364599 | (37.7481287283566, -122.419017253646) | |||
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) | ||||
37578 | 37578 | 206829 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 5994178.99702 | 2101301.67665 | 37.749439738457 | -122.46294817423599 | (37.749439738457, -122.462948174236) | |||
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) | ||||
37743 | 37743 | 222835 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3050x Cesar Chavez St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 6009216.18805 | 2100578.21721 | 37.74830795876021 | -122.410897872946 | (37.7483079587602, -122.410897872946) | |||
37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
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) | ||||
38029 | 38029 | 135591 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6013668.97989 | 2117535.62616 | 37.7951178808501 | -122.39668872043 | (37.7951178808501, -122.39668872043) | |||
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) | ||||
38094 | 38094 | 231477 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | |||
38423 | 38423 | 135585 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013716.425530001 | 2117200.6985 | 37.7942008889087 | -122.396501061571 | (37.7942008889087, -122.396501061571) | |||
38489 | 38489 | 214330 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | |||
38581 | 38581 | 195678 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015414.68674 | 2111779.65655 | 37.779410306669796 | -122.39024592062 | (37.7794103066698, -122.39024592062) | |||
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) | ||||
38678 | 38678 | 194023 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6011366.79301 | 2093982.63877 | 37.730318262277606 | -122.402997255042 | (37.7303182622776, -122.402997255042) | |||
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) | ||||
38839 | 38839 | 194025 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6011395.816869999 | 2093961.4424599998 | 37.730261682333605 | -122.402895424807 | (37.7302616823336, -122.402895424807) | |||
39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
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) | ||||
39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
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) | ||||
39879 | 39879 | 222824 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3200x Cesar Chavez St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6008202.20567 | 2100572.2127900003 | 37.7482345623906 | -122.41440378373001 | (37.7482345623906, -122.41440378373) | |||
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) | ||||
39986 | 39986 | 211113 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 5994180.049769999 | 2101148.49465 | 37.7490192001903 | -122.462933421744 | (37.7490192001903, -122.462933421744) | |||
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) | ||||
40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
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) | ||||
41025 | 41025 | 135586 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6013710.78377 | 2117230.4416 | 37.794282242493 | -122.39652266870701 | (37.794282242493, -122.396522668707) | |||
41054 | 41054 | 194324 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 6014719.872819999 | 2117222.0655900002 | 37.7943153492131 | -122.39303049145701 | (37.7943153492131, -122.393030491457) | |||
41103 | 41103 | 195768 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6014054.2182599995 | 2110478.98946 | 37.775763413678 | -122.394861271956 | (37.775763413678, -122.394861271956) | |||
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) | ||||
41127 | 41127 | 132091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.806305741188204 | -122.405269766312 | (37.8063057411882, -122.405269766312) | |||
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) | ||||
41368 | 41368 | 197881 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.75240923331361 | -122.38875758671101 | (37.7524092333136, -122.388757586711) | |||
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) | ||||
41580 | 41580 | 197879 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015633.716580001 | 2101939.6096099997 | 37.752403820278396 | -122.388801060829 | (37.7524038202784, -122.388801060829) | |||
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) | ||||
41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
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) | ||||
41989 | 41989 | 251049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5989182.8738 | 2112626.0902 | 37.7802444522785 | -122.481053773582 | (37.7802444522785, -122.481053773582) | |||
42114 | 42114 | 212121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 10ft | 5991706.53339 | 2095446.31972 | 37.7332196973367 | -122.47107142020398 | (37.7332196973367, -122.471071420204) | |||
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) | ||||
42530 | 42530 | 194380 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.79006748427221 | -122.38920779542102 | (37.7900674842722, -122.389207795421) | |||
42729 | 42729 | 194375 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6016059.60857 | 2115304.2736400003 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | |||
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) | ||||
43461 | 43461 | 194341 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | |||
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) |
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");