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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31284 | 31284 | 247949 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010404.2439 | 2098872.53529 | 37.7436910749942 | -122.406669401896 | (37.7436910749942, -122.406669401896) | ||||
31310 | 31310 | 249769 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 295 Kearny St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6010840.59654 | 2120830.53405 | 37.8040070713206 | -122.40670772380399 | (37.8040070713206, -122.406707723804) | |||
31357 | 31357 | 237945 | Undocumented 2 | Prunus spp :: Cherry 84 | 99 Aztec St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | ||||
31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
31566 | 31566 | 179618 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011168.50385 | 2093508.14959 | 37.729004339277395 | -122.403649399324 | (37.7290043392774, -122.403649399324) | ||||
31588 | 31588 | 132395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6006513.4872 | 2120932.40539 | 37.8040437321931 | -122.42168924196999 | (37.8040437321931, -122.42168924197) | ||||
31792 | 31792 | 247877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 388 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009910.50595 | 2098381.82666 | 37.7423160592417 | -122.408342032063 | (37.7423160592417, -122.408342032063) | ||||
31814 | 31814 | 196480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6012679.65409 | 2096682.3113 | 37.737804227083004 | -122.39864786201001 | (37.737804227083, -122.39864786201) | |||
31946 | 31946 | 126123 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2836 Larkin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341001 | (37.8041539827815, -122.42172367341) | ||||
32035 | 32035 | 247948 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | ||||
32078 | 32078 | 195081 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 23 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014990.50186 | 2103171.25593 | 37.7557499880963 | -122.391111501888 | (37.7557499880963, -122.391111501888) | |||
32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
32469 | 32469 | 187581 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 297 Elliot St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008926.43225 | 2088428.3515400002 | 37.7149307810954 | -122.411041782475 | (37.7149307810954, -122.411041782475) | ||||
32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
32768 | 32768 | 248178 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 218 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6007415.21428 | 2098671.9184 | 37.7429725382626 | -122.416990561277 | (37.7429725382626, -122.416990561277) | ||||
33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) | ||||
33445 | 33445 | 197872 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1999 Revere Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013000.33309 | 2095912.9511400003 | 37.735709585525896 | -122.397485169905 | (37.7357095855259, -122.397485169905) | ||||
33505 | 33505 | 193829 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Phelps St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | Width 8ft | 6014453.31745 | 2096931.20635 | 37.738586300018504 | -122.392532803946 | (37.7385863000185, -122.392532803946) | |||
33553 | 33553 | 211325 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 6ft | 5991167.02607 | 2105120.24929 | 37.7597505844426 | -122.47364206215 | (37.7597505844426, -122.47364206215) | |||
33669 | 33669 | 247869 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | ||||
33944 | 33944 | 208889 | Undocumented 2 | Malus :: Crab Apple 235 | 714 Detroit St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999450.60571 | 2095416.85302 | 37.733583656540496 | -122.44429603176201 | (37.7335836565405, -122.444296031762) | ||||
34172 | 34172 | 247998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 346 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6009778.5557 | 2099261.40313 | 37.7447237943804 | -122.408860320375 | (37.7447237943804, -122.408860320375) | ||||
34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
34244 | 34244 | 196191 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 Armstrong Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013892.03543 | 2092881.8479400002 | 37.727436404540796 | -122.39419004313 | (37.7274364045408, -122.39419004313) | ||||
34593 | 34593 | 234491 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 24 Saturn St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6000385.28479 | 2106021.7264900003 | 37.762755374980394 | -122.44182544748999 | (37.7627553749804, -122.44182544749) | |||
34805 | 34805 | 236092 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000056.44576 | 2105686.72803 | 37.761816809218296 | -122.44293872364099 | (37.7618168092183, -122.442938723641) | |||
34864 | 34864 | 246661 | Undocumented 2 | Malus :: Crab Apple 235 | 3301 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6009058.25509 | 2099385.89739 | 37.7450252552125 | -122.41135978362699 | (37.7450252552125, -122.411359783627) | |||
35008 | 35008 | 250159 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999252.38937 | 2117479.90418 | 37.79415196309329 | -122.44656813112302 | (37.7941519630933, -122.446568131123) | ||||
35045 | 35045 | 247843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | ||||
35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
35370 | 35370 | 248189 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 216 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | ||||
35403 | 35403 | 125386 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 943 Vallejo St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008816.3361599995 | 2118653.07682 | 37.797914850658 | -122.413558740271 | (37.797914850658, -122.413558740271) | ||||
35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
35978 | 35978 | 175198 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 648 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6005048.079 | 2092617.03467 | 37.726213742054604 | -122.424744822616 | (37.7262137420546, -122.424744822616) | ||||
36690 | 36690 | 248115 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010382.6698900005 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | ||||
36978 | 36978 | 187575 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010832.96557 | 2089490.7918200002 | 37.7179547559905 | -122.40452670863998 | (37.7179547559905, -122.40452670864) | ||||
37058 | 37058 | 204587 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998761.6398599995 | 2095307.9959099998 | 37.733245428730996 | -122.446670146634 | (37.733245428731, -122.446670146634) | ||||
37065 | 37065 | 190085 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012534.55717 | 2096576.85892 | 37.7375065919613 | -122.399142135727 | (37.7375065919613, -122.399142135727) | ||||
37152 | 37152 | 207426 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 404 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000774.5178 | 2095253.0810900002 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | ||||
37237 | 37237 | 247874 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 388 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009897.47446 | 2098392.17671 | 37.7423437484768 | -122.408387821062 | (37.7423437484768, -122.408387821062) | ||||
37244 | 37244 | 246629 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 3300 Harrison St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009040.22496 | 2099335.66052 | 37.744886304570606 | -122.411418580397 | (37.7448863045706, -122.411418580397) | ||||
37251 | 37251 | 136604 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | |||
37458 | 37458 | 246770 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 99 Waltham St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | ||||
37530 | 37530 | 249638 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | ||||
37532 | 37532 | 247980 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009795.98268 | 2099453.55621 | 37.745252380808296 | -122.408813614968 | (37.7452523808083, -122.408813614968) | ||||
37557 | 37557 | 178348 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Bowdoin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6008413.681059999 | 2094760.49373 | 37.732288735333796 | -122.413261587147 | (37.7322887353338, -122.413261587147) | ||||
37570 | 37570 | 246644 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009046.23893 | 2099176.02556 | 37.744448319452204 | -122.41138650967899 | (37.7444483194522, -122.411386509679) | ||||
37839 | 37839 | 239036 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3911 21st St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6002387.68734 | 2103532.26119 | 37.75603379883479 | -122.43472182765801 | (37.7560337988348, -122.434721827658) | ||||
38374 | 38374 | 136055 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1114 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007559.35658 | 2119902.6850400004 | 37.8012753005604 | -122.417996888269 | (37.8012753005604, -122.417996888269) | ||||
38454 | 38454 | 249866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011357.005059999 | 2120690.5710400003 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | |||
38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
38549 | 38549 | 247912 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 399 Franconia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009971.111830001 | 2098794.45901 | 37.7434524515605 | -122.408161569622 | (37.7434524515605, -122.408161569622) | ||||
38800 | 38800 | 248116 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464327995 | -122.406793240314 | (37.745191464328, -122.406793240314) | ||||
38844 | 38844 | 132391 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6006489.423769999 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | ||||
39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
39127 | 39127 | 247002 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Valley St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003223.72191 | 2099183.9093400002 | 37.7441416748926 | -122.431520126078 | (37.7441416748926, -122.431520126078) | |||
39131 | 39131 | 234106 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 10 Crescent Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6005252.57338 | 2095904.2217 | 37.735251176793604 | -122.424271584978 | (37.7352511767936, -122.424271584978) | |||
39135 | 39135 | 247897 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 351 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010077.88258 | 2098386.8429099997 | 37.7423392041858 | -122.407763645688 | (37.7423392041858, -122.407763645688) | ||||
39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
39341 | 39341 | 218152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 22 Ashton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5994167.21256 | 2090073.13732 | 37.71860825915 | -122.46217470241601 | (37.71860825915, -122.462174702416) | ||||
39519 | 39519 | 118599 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5981986.20635 | 2112598.8818200002 | 37.7797487653148 | -122.50594791191901 | (37.7797487653148, -122.505947911919) | ||||
39582 | 39582 | 229804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Crescent Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | |||
39702 | 39702 | 195996 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6012499.275719999 | 2097703.95349 | 37.7405993901482 | -122.39934322143101 | (37.7405993901482, -122.399343221431) | |||
40020 | 40020 | 224067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6000076.797040001 | 2105677.0536599997 | 37.7617914060643 | -122.44286764213301 | (37.7617914060643, -122.442867642133) | |||
40126 | 40126 | 134511 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 4ft | 6008018.559330001 | 2112114.37672 | 37.7799163498009 | -122.41585602603399 | (37.7799163498009, -122.415856026034) | |||
40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
40913 | 40913 | 211323 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5991179.3605 | 2105090.2513200003 | 37.759668932303796 | -122.47359721564399 | (37.7596689323038, -122.473597215644) | ||||
40945 | 40945 | 196597 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1251 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6014153.4442300005 | 2104763.78989 | 37.76007625593729 | -122.39411782218599 | (37.7600762559373, -122.394117822186) | ||||
41147 | 41147 | 247005 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 401 Valley St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 8ft | 6003245.1291 | 2099189.5781900003 | 37.7441584535423 | -122.431446509373 | (37.7441584535423, -122.431446509373) | |||
41232 | 41232 | 194561 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 Kansas St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011649.57806 | 2103809.7609599996 | 37.7573172186375 | -122.40271045314199 | (37.7573172186375, -122.402710453142) | ||||
41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) | ||||
41420 | 41420 | 195079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 21 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014986.69812 | 2103234.99475 | 37.755924790211395 | -122.391129111534 | (37.7559247902114, -122.391129111534) | |||
41726 | 41726 | 247864 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 399 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009555.15097 | 2098432.68764 | 37.742435806664794 | -122.409574335293 | (37.7424358066648, -122.409574335293) | ||||
41744 | 41744 | 248172 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6007302.01446 | 2098729.32454 | 37.74312379432521 | -122.41738604353701 | (37.7431237943252, -122.417386043537) | ||||
41940 | 41940 | 201704 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | Width 0ft | 6015220.38125 | 2088614.2880799999 | 37.7157922695756 | -122.389300031678 | (37.7157922695756, -122.389300031678) | |||
41959 | 41959 | 250203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 203 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6011748.4940599995 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | |||
42172 | 42172 | 247916 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1098 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010216.5253800005 | 2098717.08126 | 37.743253727490504 | -122.407307533818 | (37.7432537274905, -122.407307533818) | ||||
42630 | 42630 | 201727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013753.9526 | 2095943.1082 | 37.7358343232928 | -122.394881707251 | (37.7358343232928, -122.394881707251) | ||||
43066 | 43066 | 195953 | Undocumented 2 | Populus alba :: White Poplar 408 | 1599 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6012519.43639 | 2096471.57125 | 37.737216651423296 | -122.39918702716999 | (37.7372166514233, -122.39918702717) | ||||
43430 | 43430 | 246655 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009062.9897 | 2099201.46712 | 37.7445191158731 | -122.411330385684 | (37.7445191158731, -122.411330385684) | ||||
43664 | 43664 | 120267 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 100 24th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988369.5187800005 | 2115107.91648 | 37.7870115292654 | -122.48404955627501 | (37.7870115292654, -122.484049556275) | ||||
43726 | 43726 | 247881 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 387 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009928.32781 | 2098399.30466 | 37.742365048010896 | -122.4082816417 | (37.7423650480109, -122.4082816417) | ||||
43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
43990 | 43990 | 134521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6007806.05941 | 2112087.1007 | 37.7798295076742 | -122.416589227122 | (37.7798295076742, -122.416589227122) | |||
44107 | 44107 | 188705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1998 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013030.362000001 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | ||||
44131 | 44131 | 246656 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009063.73811 | 2099209.72554 | 37.744541833651205 | -122.411328381118 | (37.7445418336512, -122.411328381118) | ||||
44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
44680 | 44680 | 247950 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 7 Joy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | ||||
44694 | 44694 | 132423 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.41355547121401 | (37.7979513838133, -122.413555471214) | ||||
44987 | 44987 | 134512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 4ft | 6007952.73516 | 2112091.3955099997 | 37.7798495481525 | -122.416082113806 | (37.7798495481525, -122.416082113806) | |||
45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) | ||||
45137 | 45137 | 248182 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 216 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6007496.06144 | 2098688.36246 | 37.743022237487004 | -122.41671217793899 | (37.743022237487, -122.416712177939) | ||||
45261 | 45261 | 177822 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 3ft | 6009243.51838 | 2086439.4286099998 | 37.7094873825954 | -122.40980548443899 | (37.7094873825954, -122.409805484439) | |||
45475 | 45475 | 187553 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3960 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011370.897059999 | 2088323.0132400002 | 37.7147783208511 | -122.40258523064199 | (37.7147783208511, -122.402585230642) | ||||
45814 | 45814 | 248245 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 296 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006801.134769999 | 2098995.22543 | 37.7438257043874 | -122.41913681222401 | (37.7438257043874, -122.419136812224) | ||||
45831 | 45831 | 246626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009022.37721 | 2099388.9393599997 | 37.7450315954447 | -122.411484058261 | (37.7450315954447, -122.411484058261) |
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");