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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25775 | 25775 | 188897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 837 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012777.55941 | 2103554.0520599997 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | |||
25791 | 25791 | 135673 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 3639 Webster St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002560.08245 | 2121134.92796 | 37.8043760820531 | -122.435384749408 | (37.8043760820531, -122.435384749408) | |||
25808 | 25808 | 188041 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 50 Sierra St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013648.115680001 | 2104149.40965 | 37.758361202031494 | -122.39582247362301 | (37.7583612020315, -122.395822473623) | |||
25860 | 25860 | 246929 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 349 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.44909608851201 | (37.7668065294199, -122.449096088512) | |||
25865 | 25865 | 196050 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 10 McLea Ct | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010085.91639 | 2109269.38137 | 37.7722206639802 | -122.408503344349 | (37.7722206639802, -122.408503344349) | |||
25874 | 25874 | 192931 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1562 11th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008981.17541 | 2108615.0151400003 | 37.7703619964339 | -122.412278495049 | (37.7703619964339, -122.412278495049) | |||
25906 | 25906 | 249410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 698 Polk St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6007114.554409999 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | |||
25909 | 25909 | 228896 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 125 Haight St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005449.71206 | 2109571.37843 | 37.772789143445294 | -122.424561878921 | (37.7727891434453, -122.424561878921) | |||
25917 | 25917 | 235705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Scott St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002413.687999999 | 2108646.89138 | 37.7700788062318 | -122.434997685721 | (37.7700788062318, -122.434997685721) | |||
25927 | 25927 | 189435 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 4 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6016869.31993 | 2097857.6531700003 | 37.741264011617496 | -122.384243845296 | (37.7412640116175, -122.384243845296) | |||
25929 | 25929 | 188459 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017898.8154 | 2096917.7474099998 | 37.7387400867836 | -122.38061886067499 | (37.7387400867836, -122.380618860675) | |||
25944 | 25944 | 233355 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 45 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5998067.992430001 | 2104637.9237599997 | 37.758823486839 | -122.449740378141 | (37.758823486839, -122.449740378141) | |||
25959 | 25959 | 199626 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 468 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014046.309230001 | 2104968.95995 | 37.76063365303771 | -122.39450272031901 | (37.7606336530377, -122.394502720319) | |||
25976 | 25976 | 190714 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 375 Texas St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.761729387017496 | -122.39538124017099 | (37.7617293870175, -122.395381240171) | |||
25995 | 25995 | 189634 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 11th St | 11 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007263.01198 | 2110493.68646 | 37.7754238188976 | -122.41835486160299 | (37.7754238188976, -122.418354861603) | |||
26062 | 26062 | 247051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 519 Valley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.743985438385295 | -122.43395073994499 | (37.7439854383853, -122.433950739945) | |||
26081 | 26081 | 249738 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 22 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000189.3449800005 | 2117178.8516 | 37.7933788258243 | -122.443304539972 | (37.7933788258243, -122.443304539972) | |||
26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
26129 | 26129 | 201124 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3275 03rd St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016063.81763 | 2100244.9969099998 | 37.7477745960196 | -122.38719549489402 | (37.7477745960196, -122.387195494894) | |||
26136 | 26136 | 188896 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 851 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012778.37681 | 2103525.2873 | 37.7565990757928 | -122.398786633697 | (37.7565990757928, -122.398786633697) | |||
26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
26165 | 26165 | 194702 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 632 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012974.17874 | 2104079.5234 | 37.758131794864504 | -122.39814835788 | (37.7581317948645, -122.39814835788) | |||
26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
26224 | 26224 | 177707 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994471.04103 | 2086660.75611 | 37.709256157011794 | -122.46087732063499 | (37.7092561570118, -122.460877320635) | |||
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) | |||
26235 | 26235 | 194704 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 656 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6012976.97974 | 2104015.65385 | 37.7579565790575 | -122.39813418994801 | (37.7579565790575, -122.398134189948) | |||
26280 | 26280 | 136663 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3109 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.803297110532895 | -122.426737318298 | (37.8032971105329, -122.426737318298) | |||
26286 | 26286 | 247164 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001468.5616 | 2108335.5699400003 | 37.76917028501371 | -122.438244553041 | (37.7691702850137, -122.438244553041) | |||
26295 | 26295 | 201309 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 11 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012928.97985 | 2092740.84393 | 37.7269956593979 | -122.397509466884 | (37.7269956593979, -122.397509466884) | |||
26296 | 26296 | 193431 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 568 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.39624530967801 | (37.7591720865425, -122.396245309678) | |||
26300 | 26300 | 230904 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 485 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5996727.95407 | 2103173.3402400003 | 37.7547253509046 | -122.454269037488 | (37.7547253509046, -122.454269037488) | |||
26308 | 26308 | 192927 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 355 11th St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008730.57327 | 2108963.75547 | 37.7713054904774 | -122.413169994818 | (37.7713054904774, -122.413169994818) | |||
26321 | 26321 | 247172 | Undocumented 2 | Malus :: Crab Apple 235 | 145 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001372.05344 | 2108496.3443400003 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | |||
26347 | 26347 | 201129 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1401 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6014506.80951 | 2101043.19718 | 37.749879938626 | -122.39263542020399 | (37.749879938626, -122.392635420204) | |||
26358 | 26358 | 188851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 397 08th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.40864614951299 | (37.7739661716411, -122.408646149513) | |||
26360 | 26360 | 249391 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 280 Turk St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008635.33064 | 2113188.0691299997 | 37.7828991069454 | -122.41379830166201 | (37.7828991069454, -122.413798301662) | |||
26368 | 26368 | 137075 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6004617.552730001 | 2110839.21576 | 37.776223284701 | -122.42753075415001 | (37.776223284701, -122.42753075415) | |||
26377 | 26377 | 225990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Pearl St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.0883599995 | 2108893.1022200002 | 37.7709353079426 | -122.42399000814 | (37.7709353079426, -122.42399000814) | |||
26381 | 26381 | 251002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5981992.43445 | 2112670.6708 | 37.7799462432625 | -122.50593169049299 | (37.7799462432625, -122.505931690493) | |||
26445 | 26445 | 195159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1190 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011918.3427099995 | 2102871.98584 | 37.7547572966145 | -122.40171504034201 | (37.7547572966145, -122.401715040342) | |||
26446 | 26446 | 238580 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 519 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | |||
26475 | 26475 | 196593 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 966 Natoma St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007961.50634 | 2109867.3377900003 | 37.7737433088451 | -122.41589423462798 | (37.7737433088451, -122.415894234628) | |||
26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
26511 | 26511 | 218506 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 331 Tara St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997624.737980001 | 2089991.46593 | 37.7185824800643 | -122.450217619562 | (37.7185824800643, -122.450217619562) | |||
26547 | 26547 | 212674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 641 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.89136 | 2090473.0375 | 37.719596745362395 | -122.46876890666 | (37.7195967453624, -122.46876890666) | |||
26551 | 26551 | 247735 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6001364.01922 | 2108734.36535 | 37.770259331626896 | -122.43863473741199 | (37.7702593316269, -122.438634737412) | |||
26563 | 26563 | 246795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 195 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010198.18555 | 2098814.08058 | 37.7435190400824 | -122.407377785258 | (37.7435190400824, -122.407377785258) | |||
26565 | 26565 | 196129 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 537 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011814.46291 | 2105877.37979 | 37.763003645435205 | -122.402285583717 | (37.7630036454352, -122.402285583717) | |||
26615 | 26615 | 201282 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 46 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012790.052209999 | 2092889.91673 | 37.727397246266605 | -122.398000193676 | (37.7273972462666, -122.398000193676) | |||
26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
26671 | 26671 | 190388 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011799.90498 | 2105067.41512 | 37.7607788503881 | -122.402278983608 | (37.7607788503881, -122.402278983608) | |||
26680 | 26680 | 234541 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 380 Valencia St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6006086.8772 | 2107446.3407400004 | 37.766990260030106 | -122.422206845872 | (37.7669902600301, -122.422206845872) | |||
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) | |||
26733 | 26733 | 188939 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2225 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.745022760504206 | -122.400588763562 | (37.7450227605042, -122.400588763562) | |||
26744 | 26744 | 132714 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3055 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 1ft | 6000441.38415 | 2118807.53005 | 37.797865116340105 | -122.4425494584 | (37.7978651163401, -122.4425494584) | |||
26748 | 26748 | 246425 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 438 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6003653.22825 | 2099843.03322 | 37.745975810733796 | -122.43008199861099 | (37.7459758107338, -122.430081998611) | |||
26803 | 26803 | 189610 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Sherman St | 23 | : 4 | Tree 1 | Private 1 | 18 | Width 10ft | 6010659.83752 | 2111049.78613 | 37.7771413675214 | -122.406643580555 | (37.7771413675214, -122.406643580555) | |||
26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
26805 | 26805 | 220769 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Elgin Park | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005807.61785 | 2108816.0076 | 37.7707352825335 | -122.423270135003 | (37.7707352825335, -122.423270135003) | |||
26810 | 26810 | 198705 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 1675 Bay Shore Blvd | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012153.96731 | 2091001.0057299999 | 37.722175235676495 | -122.400066556037 | (37.7221752356765, -122.400066556037) | |||
26842 | 26842 | 249462 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6006460.85988 | 2113718.34687 | 37.784232765583 | -122.42135874831499 | (37.784232765583, -122.421358748315) | |||
26845 | 26845 | 195029 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 603 02nd St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013830.29257 | 2113762.02506 | 37.7847654277311 | -122.39586599541599 | (37.7847654277311, -122.395865995416) | |||
26897 | 26897 | 249733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 17 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000186.12585 | 2117239.7585400003 | 37.7935458766883 | -122.4433200551 | (37.7935458766883, -122.4433200551) | |||
26928 | 26928 | 229277 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6010526.84052 | 2103899.06003 | 37.7574996640945 | -122.406599632462 | (37.7574996640945, -122.406599632462) | |||
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) | |||
26970 | 26970 | 229279 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 6 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010520.0881199995 | 2103990.76889 | 37.757751098346894 | -122.406629447707 | (37.7577510983469, -122.406629447707) | |||
27020 | 27020 | 193809 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 283 Texas St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013777.6703699995 | 2105799.42073 | 37.762898978733894 | -122.395490009551 | (37.7628989787339, -122.395490009551) | |||
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) | |||
27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
27074 | 27074 | 250328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 27th Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | |||
27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
27082 | 27082 | 193812 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 596 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6014080.0948 | 2104357.2434 | 37.75895589042771 | -122.39434303940399 | (37.7589558904277, -122.394343039404) | |||
27084 | 27084 | 224623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.759944756159996 | -122.44646337809601 | (37.75994475616, -122.446463378096) | |||
27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
27095 | 27095 | 250526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5987725.00409 | 2115456.85695 | 37.787932075559794 | -122.48630503096001 | (37.7879320755598, -122.48630503096) | |||
27104 | 27104 | 188899 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 801 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012769.67955 | 2103741.86982 | 37.757193279471295 | -122.398831911879 | (37.7571932794713, -122.398831911879) | |||
27111 | 27111 | 193054 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1998 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013745.9771300005 | 2099978.99313 | 37.7469155761867 | -122.39519189779499 | (37.7469155761867, -122.395191897795) | |||
27118 | 27118 | 219852 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 160 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997608.48937 | 2104144.50247 | 37.7574423754904 | -122.451293958747 | (37.7574423754904, -122.451293958747) | |||
27135 | 27135 | 187803 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 1022 Minna St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007519.609019999 | 2109677.8407099997 | 37.7731981416251 | -122.417409398951 | (37.7731981416251, -122.417409398951) | |||
27153 | 27153 | 197239 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 830 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394588999 | (37.7592018783746, -122.40214394589) | |||
27170 | 27170 | 211520 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 136 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 10ft | 5997136.50298 | 2089006.99788 | 37.7158514071876 | -122.451834257948 | (37.7158514071876, -122.451834257948) | |||
27268 | 27268 | 197791 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 340 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | |||
27292 | 27292 | 250990 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.57195 | 2112909.00953 | 37.7805965385427 | -122.50619104959299 | (37.7805965385427, -122.506191049593) | |||
27293 | 27293 | 200401 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 482 09th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010012.1355099995 | 2109044.8007400003 | 37.7715998853661 | -122.40874271332501 | (37.7715998853661, -122.408742713325) | |||
27313 | 27313 | 247224 | Undocumented 2 | Schinus molle :: California Pepper 138 | 135 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6001887.60725 | 2108459.11842 | 37.7695333431173 | -122.436803945272 | (37.7695333431173, -122.436803945272) | |||
27314 | 27314 | 218570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546002 | (37.7305168532543, -122.47426667546) | |||
27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
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) | |||
27358 | 27358 | 202320 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 155 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012974.90873 | 2093002.4411400002 | 37.727716509204 | -122.397369027877 | (37.727716509204, -122.397369027877) | |||
27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
27486 | 27486 | 192817 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 666 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013574.47554 | 2113201.19226 | 37.783211275117104 | -122.39671171428101 | (37.7832112751171, -122.396711714281) | |||
27501 | 27501 | 198028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010225.17287 | 2110701.2793 | 37.7761601208299 | -122.40812264516 | (37.7761601208299, -122.40812264516) | |||
27518 | 27518 | 191712 | Undocumented 2 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 18 Robblee Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6012627.22621 | 2095983.93227 | 37.7358837032551 | -122.39878013339501 | (37.7358837032551, -122.398780133395) | |||
27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
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) | |||
27608 | 27608 | 193063 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 20 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6015045.87298 | 2098929.39678 | 37.7441058081384 | -122.39062360620399 | (37.7441058081384, -122.390623606204) | |||
27627 | 27627 | 195043 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 377 06th St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6011353.00653 | 2111183.55828 | 37.777547432096206 | -122.404255094506 | (37.7775474320962, -122.404255094506) |
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");