Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | 44 | 226925 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 19 | Width 4ft | 6002565.841680001 | 2099976.66752 | 37.746281093695 | -122.433851580699 | (37.746281093695, -122.433851580699) | |||
| 173 | 173 | 175044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 5991568.948890001 | 2087568.2224599998 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | |||
| 195 | 195 | 138365 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.78603526200121 | -122.43425424087799 | (37.7860352620012, -122.434254240878) | |||
| 315 | 315 | 127442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 4ft | 6005941.14617 | 2117647.79475 | 37.794992735681504 | -122.423436220932 | (37.7949927356815, -122.423436220932) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 680 | 680 | 214193 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 19 | Width 3ft | Permit Number 9508 | 5992820.4639099995 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | |
| 827 | 827 | 191800 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 5 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.739438732322704 | -122.37827876085301 | (37.7394387323227, -122.378278760853) | |
| 895 | 895 | 209148 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5995023.415709999 | 2107016.68952 | 37.7651803042563 | -122.46044222322901 | (37.7651803042563, -122.460442223229) | |||
| 900 | 900 | 140947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 1037 | 1037 | 189668 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015920.2977599995 | 2103253.32542 | 37.7560268866495 | -122.387901667748 | (37.7560268866495, -122.387901667748) | |||
| 1062 | 1062 | 189665 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015925.0907 | 2103156.8300799998 | 37.755762196378996 | -122.387878359099 | (37.755762196379, -122.387878359099) | |||
| 1306 | 1306 | 127778 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1459 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6007455.77406 | 2117413.73976 | 37.794435449198495 | -122.418178770753 | (37.7944354491985, -122.418178770753) | |||
| 1477 | 1477 | 138092 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1890 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6003632.0 | 2114586.0 | 37.7864552256154 | -122.43120755079399 | (37.7864552256154, -122.431207550794) | |||
| 1492 | 1492 | 224530 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6008605.155040001 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 1970 | 1970 | 224702 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007468.557569999 | 2102099.5649099997 | 37.752387084812604 | -122.417048929078 | (37.7523870848126, -122.417048929078) | |||
| 2017 | 2017 | 13264 | DPW Maintained 3 | Tristania conferta :: 79 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | ||
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 2043 | 2043 | 127861 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007317.93078 | 2118761.71757 | 37.798128900073294 | -122.418751368192 | (37.7981289000733, -122.418751368192) | |||
| 2060 | 2060 | 127860 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 6ft | 6007322.606430001 | 2118731.77235 | 37.798046941256 | -122.418733064272 | (37.798046941256, -122.418733064272) | |||
| 2120 | 2120 | 110253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6000252.5201 | 2113528.9926 | 37.783360865552396 | -122.442823740221 | (37.7833608655524, -122.442823740221) | |||
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
| 2628 | 2628 | 248767 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5999684.377780001 | 2101641.28638 | 37.750687799606105 | -122.443934882898 | (37.7506877996061, -122.443934882898) | |||
| 2686 | 2686 | 234760 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 252 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004468.902369999 | 2109137.1444099997 | 37.77154140335671 | -122.427923663451 | (37.7715414033567, -122.427923663451) | |||
| 2688 | 2688 | 1096 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2310 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 19 | 3X3 | 5999487.90061 | 2089338.3878900001 | 37.71689572423529 | -122.443730556927 | (37.7168957242353, -122.443730556927) | ||
| 2728 | 2728 | 142000 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6003967.2401 | 2111768.9836 | 37.7787393936814 | -122.429846696894 | (37.7787393936814, -122.429846696894) | |||
| 2885 | 2885 | 205488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5990862.44739 | 2105654.74875 | 37.761200533507 | -122.474734450646 | (37.761200533507, -122.474734450646) | |||
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 3154 | 3154 | 142517 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 402 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6010454.8754 | 2118953.3694 | 37.798831249998 | -122.40791009059299 | (37.798831249998, -122.407910090593) | |||
| 3434 | 3434 | 225969 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005840.01853 | 2101965.4750599996 | 37.751927158923294 | -122.422671163153 | (37.7519271589233, -122.422671163153) | |||
| 3595 | 3595 | 229132 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 869 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1983 12:00:00 AM | 19 | Width 3ft | Permit Number 21019 | 6007588.0617 | 2104611.24937 | 37.759290317716 | -122.41681359176901 | (37.759290317716, -122.416813591769) | |
| 3602 | 3602 | 202609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | Permit Number 779780 | 6011126.85654 | 2109894.99849 | 37.773996705425795 | -122.40494667944799 | (37.7739967054258, -122.404946679448) | ||
| 3855 | 3855 | 248614 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | |||
| 3975 | 3975 | 102690 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2121 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6001369.63978 | 2115762.6346400003 | 37.789557495824106 | -122.43911909516501 | (37.7895574958241, -122.439119095165) | |||
| 4294 | 4294 | 248325 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 19 | Width 0ft | Permit Number 17699 | 5998266.3488 | 2108214.611 | 37.7686555147255 | -122.44931206435 | (37.7686555147255, -122.44931206435) | |
| 8020 | 8020 | 2680 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2015 12:00:00 AM | 19 | 3X3 | 6003616.3325 | 2114868.6836 | 37.7872305155325 | -122.43128194219 | (37.7872305155325, -122.43128194219) | ||
| 8927 | 8927 | 102693 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2101 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 6001381.172669999 | 2115690.38087 | 37.789359761877705 | -122.439074012167 | (37.7893597618777, -122.439074012167) | |||
| 9059 | 9059 | 896 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 4X4 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 9100 | 9100 | 3097 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3007 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 5999906.6277 | 2115044.4472 | 37.787502185214 | -122.444129317901 | (37.787502185214, -122.444129317901) | |||
| 9461 | 9461 | 22540 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1441X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 12X6 | 6002335.8535400005 | 2093628.68187 | 37.728837937275 | -122.43419311802099 | (37.728837937275, -122.434193118021) | |||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9779 | 9779 | 114426 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 486 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 4x4 | 5985968.50007 | 2112632.43388 | 37.7800744897886 | -122.49217408228901 | (37.7800744897886, -122.492174082289) | |||
| 11467 | 11467 | 908 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1210 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6003130.076330001 | 2094257.46245 | 37.730609472638704 | -122.431492307321 | (37.7306094726387, -122.431492307321) | |||
| 11628 | 11628 | 967 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1580 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001819.4833 | 2093012.65258 | 37.7271171398355 | -122.435934181229 | (37.7271171398355, -122.435934181229) | |||
| 11682 | 11682 | 17519 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.721830100172504 | -122.433396514735 | (37.7218301001725, -122.433396514735) | |||
| 11718 | 11718 | 17568 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6003419.6169300005 | 2090505.6702299998 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | |||
| 12118 | 12118 | 905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1183 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3X3 | 6003394.233080001 | 2094256.01413 | 37.7306204641588 | -122.43057897475599 | (37.7306204641588, -122.430578974756) | |||
| 13010 | 13010 | 1050 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2034 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 19 | 3X3 | 6000505.7027 | 2090306.7882 | 37.7196127326146 | -122.440281928494 | (37.7196127326146, -122.440281928494) | ||
| 13185 | 13185 | 98922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2507 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 5989831.2863 | 2098268.2421 | 37.7408593296697 | -122.47776079641599 | (37.7408593296697, -122.477760796416) | |||
| 18522 | 18522 | 7034 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1235 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001440.3818 | 2110052.83399 | 37.7738838611848 | -122.438465078521 | (37.7738838611848, -122.438465078521) | |||
| 19346 | 19346 | 5493 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 8 | 6005041.71749 | 2104164.91103 | 37.7579212248917 | -122.425588324648 | (37.7579212248917, -122.425588324648) | |||
| 20407 | 20407 | 10110 | Permitted Site 1 | Morus alba :: White Mulberry 112 | 808 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 2X2 | 6005630.36176 | 2104174.0616099997 | 37.7579795935988 | -122.42355319303101 | (37.7579795935988, -122.423553193031) | |||
| 22818 | 22818 | 61336 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1482 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1984 12:00:00 AM | 19 | Permit Number 21241 | 6011993.29551 | 2101466.3865799997 | 37.7509020100245 | -122.401357057985 | (37.7509020100245, -122.401357057985) | ||
| 22854 | 22854 | 176359 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350x Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6001093.21408 | 2086592.19305 | 37.7094467152559 | -122.437985185864 | (37.7094467152559, -122.437985185864) | |||
| 22992 | 22992 | 135234 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6012203.157240001 | 2120302.31676 | 37.802632855975794 | -122.401955307707 | (37.8026328559758, -122.401955307707) | |||
| 23006 | 23006 | 5050 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5399X Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6001979.62541 | 2098516.88417 | 37.7422395880754 | -122.43577421703002 | (37.7422395880754, -122.43577421703) | ||||
| 23052 | 23052 | 14947 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6016779.8000300005 | 2097854.44087 | 37.741250241204604 | -122.384553152708 | (37.7412502412046, -122.384553152708) | |||
| 23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
| 23111 | 23111 | 7884 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1187 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 6005973.3508 | 2114075.31974 | 37.7851854273041 | -122.423070740949 | (37.7851854273041, -122.423070740949) | ||||
| 23171 | 23171 | 12955 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 814X Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001915.22155 | 2095840.63175 | 37.7348875620173 | -122.43580546667 | (37.7348875620173, -122.43580546667) | |||
| 23179 | 23179 | 7484 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2678 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6008256.897969999 | 2102850.5873 | 37.754493538061205 | -122.414375845389 | (37.7544935380612, -122.414375845389) | |||
| 23239 | 23239 | 6566 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/02/1992 12:00:00 AM | 19 | 3X3 | 6016992.23508 | 2097474.99816 | 37.7402201136747 | -122.383792207542 | (37.7402201136747, -122.383792207542) | ||
| 23260 | 23260 | 7885 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1187 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6005978.9516900005 | 2114038.3694 | 37.785084286843 | -122.42304873632901 | (37.785084286843, -122.423048736329) | |||
| 23322 | 23322 | 23886 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6003218.9262 | 2113924.0949 | 37.784614384352004 | -122.432589384494 | (37.784614384352, -122.432589384494) | |||
| 23465 | 23465 | 139181 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002385.219 | 2113786.8905 | 37.7841903415453 | -122.43546390872 | (37.7841903415453, -122.43546390872) | |||
| 23477 | 23477 | 248545 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 117 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997472.7852 | 2107770.5122 | 37.7673907090912 | -122.45202487899999 | (37.7673907090912, -122.452024879) | |||
| 23531 | 23531 | 212068 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.46209504585501 | (37.7394500943456, -122.462095045855) | |||
| 23563 | 23563 | 227340 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3925 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008430.643540001 | 2096807.7680099998 | 37.7379110584464 | -122.41334767206499 | (37.7379110584464, -122.413347672065) | |||
| 23593 | 23593 | 140908 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2313 Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000568.9025 | 2113347.1332 | 37.782879558173 | -122.44171612920601 | (37.782879558173, -122.441716129206) | |||
| 23637 | 23637 | 130611 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3680 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5996671.03627 | 2115980.2192 | 37.7898864489512 | -122.45539140311199 | (37.7898864489512, -122.455391403112) | |||
| 23655 | 23655 | 139251 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004405.5927 | 2111207.184 | 37.7772216441057 | -122.42829021337201 | (37.7772216441057, -122.428290213372) | |||
| 23662 | 23662 | 130000 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1047 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6006030.0944 | 2113466.83966 | 37.7835178926838 | -122.422831166043 | (37.7835178926838, -122.422831166043) | |||
| 23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
| 24152 | 24152 | 139672 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2130 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001050.5296 | 2113171.6663 | 37.7824252009505 | -122.44003731838 | (37.7824252009505, -122.44003731838) | |||
| 24188 | 24188 | 247556 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6000035.32206 | 2108353.94379 | 37.7691391145131 | -122.443203353661 | (37.7691391145131, -122.443203353661) | |||
| 24226 | 24226 | 57083 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 700 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 19 | Permit Number 14350 | 6012989.82027 | 2103754.31377 | 37.7572397114663 | -122.39807144786501 | (37.7572397114663, -122.398071447865) | ||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 24279 | 24279 | 138266 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 GEARY BLVD | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999024.6838 | 2113178.2607 | 37.7823277718518 | -122.44704630425699 | (37.7823277718518, -122.447046304257) | |||
| 24316 | 24316 | 239651 | Undocumented 2 | Schinus molle :: California Pepper 138 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002456.2179 | 2103744.6121099996 | 37.7566207539655 | -122.434500008976 | (37.7566207539655, -122.434500008976) | |||
| 24384 | 24384 | 203942 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991551.86269 | 2098375.2612400004 | 37.7412528807104 | -122.47181953924299 | (37.7412528807104, -122.471819539243) | |||
| 24901 | 24901 | 188434 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 406 Arkansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6012917.44565 | 2105140.82493 | 37.7610427357449 | -122.39841903400499 | (37.7610427357449, -122.398419034005) | |||
| 24910 | 24910 | 113499 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | 3x3 | 6011193.56936 | 2090563.5306400002 | 37.7209204242214 | -122.403355677147 | (37.7209204242214, -122.403355677147) | |||
| 24957 | 24957 | 224820 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3524 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6004882.0996199995 | 2103123.1726599997 | 37.755051835399705 | -122.42606619199499 | (37.7550518353997, -122.426066191995) | |||
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 25217 | 25217 | 127431 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1875 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6005225.57495 | 2117450.29564 | 37.7944100397319 | -122.42589813929399 | (37.7944100397319, -122.425898139294) | |||
| 25340 | 25340 | 199360 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1451 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012046.6036 | 2101626.2388 | 37.7513439035983 | -122.401183943899 | (37.7513439035983, -122.401183943899) | ||||
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25643 | 25643 | 127808 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1800 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6007828.1115 | 2118582.72513 | 37.797666143125895 | -122.416973299697 | (37.7976661431259, -122.416973299697) | |||
| 25733 | 25733 | 245683 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3678 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6003829.6930599995 | 2103071.3220900004 | 37.7548499295039 | -122.429702017943 | (37.7548499295039, -122.429702017943) | |||
| 25886 | 25886 | 221655 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 1801 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6009351.71824 | 2099059.68883 | 37.7441460132414 | -122.410322008262 | (37.7441460132414, -122.410322008262) | |||
| 25945 | 25945 | 131514 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6007419.30162 | 2110999.92133 | 37.7768226154073 | -122.41785010991501 | (37.7768226154073, -122.417850109915) | |||
| 25972 | 25972 | 40007 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.6170400002 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | |
| 25979 | 25979 | 230591 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 558 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002744.70121 | 2102714.47284 | 37.7538086090057 | -122.433428718568 | (37.7538086090057, -122.433428718568) | |||
| 26134 | 26134 | 222947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 366 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003535.08021 | 2108659.73976 | 37.7701776938656 | -122.43111972360799 | (37.7701776938656, -122.431119723608) | |||
| 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) | |||
| 26257 | 26257 | 226491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008819.815769999 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | |||
| 26352 | 26352 | 194553 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 400 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6011164.90304 | 2106222.9906900004 | 37.7639163349965 | -122.40455653108101 | (37.7639163349965, -122.404556531081) | ||||
| 26510 | 26510 | 182982 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 20th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5990198.1355 | 2098062.4817 | 37.7403156480562 | -122.47647735467599 | (37.7403156480562, -122.476477354676) | |||
| 26557 | 26557 | 135019 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012262.47408 | 2120253.63382 | 37.8025024947586 | -122.401746616425 | (37.8025024947586, -122.401746616425) |
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");