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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39376 | 39376 | 239418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2106 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6002637.419840001 | 2099337.55033 | 37.7445302890331 | -122.433558405315 | (37.7445302890331, -122.433558405315) | ||||
| 39478 | 39478 | 233321 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 101 Glenbrook Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 10ft | 5997911.86978 | 2104120.7437299998 | 37.7573945063633 | -122.450243040706 | (37.7573945063633, -122.450243040706) | |||
| 39579 | 39579 | 244952 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | |||
| 39714 | 39714 | 233979 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 984 Valencia St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6006291.32527 | 2103870.13031 | 37.7571823544938 | -122.421245715219 | (37.7571823544938, -122.421245715219) | |||
| 39973 | 39973 | 131171 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1028 Chestnut St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006900.3516 | 2120517.59651 | 37.802926579956704 | -122.420321008927 | (37.8029265799567, -122.420321008927) | |||
| 40080 | 40080 | 175138 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6004374.522580001 | 2093135.8569099999 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | |||
| 40221 | 40221 | 182926 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2646 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 5981556.704 | 2097178.5239 | 37.7373835743826 | -122.506289933268 | (37.7373835743826, -122.506289933268) | |||
| 40454 | 40454 | 128494 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 369 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6012086.37369 | 2116397.02316 | 37.791903339624206 | -122.40208472734 | (37.7919033396242, -122.40208472734) | |||
| 40524 | 40524 | 246614 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6009136.11989 | 2100236.51166 | 37.7473652210349 | -122.411150613905 | (37.7473652210349, -122.411150613905) | |||
| 40547 | 40547 | 127858 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1108 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008285.2726300005 | 2118276.37484 | 37.796850686473704 | -122.41536969425199 | (37.7968506864737, -122.415369694252) | |||
| 40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
| 40909 | 40909 | 175907 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Nueva Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6012827.98154 | 2086955.6822799998 | 37.7111051415626 | -122.39745307312401 | (37.7111051415626, -122.397453073124) | |||
| 40958 | 40958 | 245580 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1481 Noe St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003338.08753 | 2099620.14855 | 37.745345967858206 | -122.43115580621901 | (37.7453459678582, -122.431155806219) | |||
| 41155 | 41155 | 190263 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 90 New Montgomery St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012423.70042 | 2114824.63943 | 37.787604766388704 | -122.400807051507 | (37.7876047663887, -122.400807051507) | |||
| 41547 | 41547 | 215416 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | ||||
| 41613 | 41613 | 228518 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 481 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6002169.605269999 | 2103070.00392 | 37.7547521677948 | -122.435442960743 | (37.7547521677948, -122.435442960743) | |||
| 41998 | 41998 | 232864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2784 23rd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010097.8107199995 | 2102827.94887 | 37.7545346199892 | -122.408007862 | (37.7545346199892, -122.408007862) | |||
| 42262 | 42262 | 214783 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | |||
| 42492 | 42492 | 247161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2399 Market St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 5ft | 6002372.95372 | 2105936.54637 | 37.7626345492748 | -122.43494472103998 | (37.7626345492748, -122.43494472104) | |||
| 42692 | 42692 | 139101 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2533 POST ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6000038.1797 | 2113670.6976 | 37.78373772905571 | -122.443575453886 | (37.7837377290557, -122.443575453886) | |||
| 42756 | 42756 | 237448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4609 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000549.980269999 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | |||
| 42762 | 42762 | 226645 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3626 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.752004698476206 | -122.42357029633301 | (37.7520046984762, -122.423570296333) | |||
| 42808 | 42808 | 179717 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 17 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6008127.64953 | 2094206.23587 | 37.7307508001883 | -122.414211266754 | (37.7307508001883, -122.414211266754) | |||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 43451 | 43451 | 220110 | Undocumented 2 | Acacia cyclops :: Cyclops wattle 366 | 1301 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 6002012.53381 | 2100276.70293 | 37.7470735061305 | -122.435786312882 | (37.7470735061305, -122.435786312882) | |||
| 43532 | 43532 | 143415 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 585 KEARNY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011361.1919 | 2116895.7879 | 37.793232325979 | -122.40462899905899 | (37.793232325979, -122.404628999059) | |||
| 43862 | 43862 | 187987 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 2 Saint Francis Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 1ft | 6013325.607559999 | 2113213.70467 | 37.783231776967796 | -122.397573581364 | (37.7832317769678, -122.397573581364) | |||
| 44274 | 44274 | 124649 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995460.1391900005 | 2115780.29786 | 37.7892679654039 | -122.459566483421 | (37.7892679654039, -122.459566483421) | |||
| 44279 | 44279 | 248099 | Undocumented 2 | Cornus SPP :: Dogwood 336 | 10 Brewster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010433.82285 | 2099780.55401 | 37.7461859517306 | -122.40663109974301 | (37.7461859517306, -122.406631099743) | |||
| 44288 | 44288 | 175681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1633 Silliman St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6006006.09898 | 2092844.9311900001 | 37.7268935584718 | -122.421449171565 | (37.7268935584718, -122.421449171565) | |||
| 44429 | 44429 | 244865 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005730.73165 | 2096631.6868599998 | 37.737275621771104 | -122.42267009385401 | (37.7372756217711, -122.422670093854) | |||
| 44891 | 44891 | 128484 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6012215.94703 | 2116460.90061 | 37.7920859631489 | -122.40164089212 | (37.7920859631489, -122.40164089212) | |||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
| 45306 | 45306 | 223878 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 31 Bronte St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6009376.271430001 | 2097261.13323 | 37.7392089483382 | -122.410110157661 | (37.7392089483382, -122.410110157661) | |||
| 45522 | 45522 | 221192 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 38 Dolores St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6004728.48786 | 2108042.49071 | 37.7685504308788 | -122.426947766841 | (37.7685504308788, -122.426947766841) | |||
| 45848 | 45848 | 129548 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011012.0164 | 2118485.6729900003 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | |||
| 46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
| 46204 | 46204 | 213204 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 284 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 5994231.94544 | 2089668.7631299999 | 37.7175016712563 | -122.46192164217501 | (37.7175016712563, -122.461921642175) | ||||
| 46403 | 46403 | 190240 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012103.08796 | 2115166.4168599998 | 37.7885253187384 | -122.401940349294 | (37.7885253187384, -122.401940349294) | |||
| 47018 | 47018 | 130550 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 343 Maple St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 2ft | 5996664.48629 | 2115056.6733 | 37.7873502636553 | -122.45534729226699 | (37.7873502636553, -122.455347292267) | |||
| 47179 | 47179 | 190230 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013118.573340001 | 2115391.45981 | 37.7891998561378 | -122.398442699681 | (37.7891998561378, -122.398442699681) | |||
| 47236 | 47236 | 225176 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1020 Alabama St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6009156.40291 | 2103118.80305 | 37.7552804871291 | -122.411284056222 | (37.7552804871291, -122.411284056222) | |||
| 47775 | 47775 | 194581 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 608 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6013516.07962 | 2104276.2000599997 | 37.758701994708204 | -122.396288002304 | (37.7587019947082, -122.396288002304) | |||
| 48051 | 48051 | 177031 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6005122.72167 | 2093818.5342400002 | 37.729517010390204 | -122.42457221572901 | (37.7295170103902, -122.424572215729) | |||
| 48149 | 48149 | 240393 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Hill St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6006109.51353 | 2103440.5803799997 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | |||
| 48400 | 48400 | 236754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 456 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002114.12722 | 2103211.5772 | 37.755137743137496 | -122.435644946673 | (37.7551377431375, -122.435644946673) | ||||
| 48492 | 48492 | 128717 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 533 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6011384.22669 | 2117985.2759700003 | 37.7962250856765 | -122.404626027992 | (37.7962250856765, -122.404626027992) | |||
| 48660 | 48660 | 243926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 6006689.91006 | 2103386.78803 | 37.7558776711221 | -122.41983295584299 | (37.7558776711221, -122.419832955843) | |||
| 48771 | 48771 | 224476 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 3900 22nd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6002426.58546 | 2102995.56923 | 37.7545623793656 | -122.434548932106 | (37.7545623793656, -122.434548932106) | |||
| 48923 | 48923 | 245554 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 939 Valencia St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6006339.99922 | 2104098.0841099997 | 37.757811006682296 | -122.421093567011 | (37.7578110066823, -122.421093567011) | |||
| 49037 | 49037 | 194154 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 470 Carolina St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6012311.644719999 | 2105752.08257 | 37.762687347553296 | -122.40055718926901 | (37.7626873475533, -122.400557189269) | |||
| 49057 | 49057 | 142822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | |||
| 49514 | 49514 | 190071 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 760 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012081.41801 | 2104921.5268599996 | 37.7603939837179 | -122.40129509739799 | (37.7603939837179, -122.401295097398) | |||
| 49645 | 49645 | 119969 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 540 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5987222.6278800005 | 2112233.92491 | 37.7790535307721 | -122.48780625689501 | (37.7790535307721, -122.487806256895) | |||
| 50258 | 50258 | 205681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5991402.87169 | 2104383.6674599997 | 37.7577417813829 | -122.472772688422 | (37.7577417813829, -122.472772688422) | ||||
| 50427 | 50427 | 179309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.725529964113605 | -122.42865837630801 | (37.7255299641136, -122.428658376308) | |||
| 50533 | 50533 | 247288 | Undocumented 2 | :: 54 | 638 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997017.3270000005 | 2108860.304 | 37.770356897849105 | -122.453678939083 | (37.7703568978491, -122.453678939083) | |||
| 50693 | 50693 | 176103 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008313.99103 | 2086238.6229700001 | 37.7088838754685 | -122.413003909814 | (37.7088838754685, -122.413003909814) | |||
| 51153 | 51153 | 176836 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999285.39372 | 2089701.94289 | 37.7178824109155 | -122.444456635388 | (37.7178824109155, -122.444456635388) | |||
| 51159 | 51159 | 231682 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 141 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007132.37905 | 2098439.10695 | 37.7423173758515 | -122.417952030056 | (37.7423173758515, -122.417952030056) | |||
| 51492 | 51492 | 142851 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006841.0842 | 2115206.4797 | 37.7883402427205 | -122.42014895267799 | (37.7883402427205, -122.420148952678) | |||
| 51741 | 51741 | 226913 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1306 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 6001942.32599 | 2100269.94755 | 37.7470509691452 | -122.436028601948 | (37.7470509691452, -122.436028601948) | |||
| 51899 | 51899 | 232682 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600 Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007260.9226 | 2103771.47228 | 37.756966077429205 | -122.417885471231 | (37.7569660774292, -122.417885471231) | |||
| 51921 | 51921 | 126780 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1999 Greenwich St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003378.10961 | 2119281.63802 | 37.7993338540344 | -122.432421449996 | (37.7993338540344, -122.432421449996) | |||
| 52379 | 52379 | 196126 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2251 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6011345.096580001 | 2104613.5358 | 37.759507200926706 | -122.40382003306601 | (37.7595072009267, -122.403820033066) | |||
| 52585 | 52585 | 239559 | Undocumented 2 | Salix matsudana 'Tortuosa' :: Corkscrew Willow 228 | 850 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6002419.2495099995 | 2103265.93732 | 37.7553043290595 | -122.434593632903 | (37.7553043290595, -122.434593632903) | |||
| 52680 | 52680 | 96544 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.39883325906099 | (37.7924495959214, -122.398833259061) | ||
| 52776 | 52776 | 247289 | Undocumented 2 | :: 54 | 636 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997016.0452 | 2108877.8212 | 37.7704049220759 | -122.45368463790199 | (37.7704049220759, -122.453684637902) | |||
| 52886 | 52886 | 131013 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 2531 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6000837.80329 | 2118568.05574 | 37.797230171598 | -122.44116054993401 | (37.797230171598, -122.441160549934) | |||
| 52958 | 52958 | 126480 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010938.47214 | 2117002.6943099997 | 37.7935022308001 | -122.406099179531 | (37.7935022308001, -122.406099179531) | |||
| 53053 | 53053 | 219245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 16 Lobos St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 5996729.7413 | 2088712.5742099998 | 37.7150196826824 | -122.45321896478501 | (37.7150196826824, -122.453218964785) | |||
| 53458 | 53458 | 233069 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 774 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6001540.64018 | 2099730.3572 | 37.7455465535424 | -122.43737896277901 | (37.7455465535424, -122.437378962779) | |||
| 53520 | 53520 | 196107 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.759414745219296 | -122.39317961614799 | (37.7594147452193, -122.393179616148) | |||
| 53740 | 53740 | 176618 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Seneca Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000040.875469999 | 2090086.0119900003 | 37.7189800550644 | -122.441872826471 | (37.7189800550644, -122.441872826471) | |||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 54122 | 54122 | 239022 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 927 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004402.676659999 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | |||
| 54314 | 54314 | 226532 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 138 Scott St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6002359.73994 | 2109019.2730900003 | 37.7710982111319 | -122.435210930252 | (37.7710982111319, -122.435210930252) | |||
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 54480 | 54480 | 142245 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 535 Laguna St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 6004969.8237 | 2110876.0836 | 37.776344433323004 | -122.426314777435 | (37.776344433323, -122.426314777435) | |||
| 54756 | 54756 | 180379 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4172 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003597.5733199995 | 2094144.24122 | 37.7303250782211 | -122.429868027407 | (37.7303250782211, -122.429868027407) | |||
| 54860 | 54860 | 223348 | Undocumented 2 | Dypsis cabadae :: Cabada palm 271 | 148 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6005777.46751 | 2096628.97923 | 37.7372708238985 | -122.422508313901 | (37.7372708238985, -122.422508313901) | |||
| 54904 | 54904 | 233003 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 724 Anderson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6007739.01279 | 2095540.2064599998 | 37.7343917558762 | -122.415649262915 | (37.7343917558762, -122.415649262915) | |||
| 55054 | 55054 | 133041 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1540 Larkin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6007120.87894 | 2116663.94898 | 37.792357854292895 | -122.41928433701901 | (37.7923578542929, -122.419284337019) | |||
| 55135 | 55135 | 131289 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3851 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 5996400.52935 | 2115242.07144 | 37.787844168616296 | -122.45627393301201 | (37.7878441686163, -122.456273933012) | |||
| 55385 | 55385 | 177580 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 765 Morse St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 5998269.5566300005 | 2087006.2065299999 | 37.7104225210511 | -122.44777396011801 | (37.7104225210511, -122.447773960118) | |||
| 55445 | 55445 | 177587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 48 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008913.30843 | 2086433.5443799999 | 37.709452714651796 | -122.410946334729 | (37.7094527146518, -122.410946334729) | |||
| 55682 | 55682 | 124430 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 315 Cherry St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 5ft | 5996165.292669999 | 2115148.00048 | 37.7875723686265 | -122.457080995957 | (37.7875723686265, -122.457080995957) | |||
| 55793 | 55793 | 128501 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 132 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012626.68616 | 2116169.5344599998 | 37.7913088517754 | -122.4001992483 | (37.7913088517754, -122.4001992483) | |||
| 55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
| 56086 | 56086 | 142849 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1301 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006768.5938 | 2115374.6214 | 37.7887978336371 | -122.42041169750799 | (37.7887978336371, -122.420411697508) | |||
| 56310 | 56310 | 198008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 Shipley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6011263.84387 | 2111528.91648 | 37.778490722908 | -122.40458785715799 | (37.778490722908, -122.404587857158) | ||||
| 56650 | 56650 | 179810 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1367 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 5999324.75892 | 2089823.48937 | 37.71821839584229 | -122.444329297662 | (37.7182183958423, -122.444329297662) | |||
| 57065 | 57065 | 180367 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Harvard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6006338.1415099995 | 2092311.4976 | 37.7254475817356 | -122.420263462185 | (37.7254475817356, -122.420263462185) | |||
| 57091 | 57091 | 179247 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 353 Prague St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6003781.052759999 | 2089121.49913 | 37.7165441288874 | -122.42887576852199 | (37.7165441288874, -122.428875768522) | |||
| 57363 | 57363 | 231338 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1445 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 4ft | 5998276.5397 | 2105436.41376 | 37.7610278699558 | -122.44907665056499 | (37.7610278699558, -122.449076650565) | |||
| 57365 | 57365 | 128480 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012292.28897 | 2116471.0493 | 37.7921180887322 | -122.40137746002199 | (37.7921180887322, -122.401377460022) | |||
| 57735 | 57735 | 222601 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 6003357.30994 | 2096300.3154799999 | 37.7362315601275 | -122.43085246039 | (37.7362315601275, -122.43085246039) | |||
| 58150 | 58150 | 211299 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 212 Vernon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5992481.14355 | 2089300.95007 | 37.71639079536521 | -122.46794656929701 | (37.7163907953652, -122.467946569297) | |||
| 58332 | 58332 | 241490 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2115 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 6ft | 6002706.79399 | 2099384.51572 | 37.744663180953495 | -122.433321879096 | (37.7446631809535, -122.433321879096) |
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");