Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
| 263 | 263 | 141358 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
| 456 | 456 | 23112 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.396269999 | 2101132.22455 | 37.74967287242389 | -122.42054965793899 | (37.7496728724239, -122.420549657939) | |
| 523 | 523 | 247328 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003691.2873 | 2110070.3794 | 37.774059815342795 | -122.430680081912 | (37.7740598153428, -122.430680081912) | |||
| 535 | 535 | 13638 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 576 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6012273.72895 | 2115490.3220900004 | 37.7894242082171 | -122.40137272597799 | (37.7894242082171, -122.401372725978) | |||
| 538 | 538 | 224356 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3122 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | Width 4ft | Permit Number 16121 | 6005963.44888 | 2106707.74991 | 37.7649553019601 | -122.422581275918 | (37.7649553019601, -122.422581275918) | |
| 672 | 672 | 23002 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 742 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 20 | 3X3 | 6006210.140269999 | 2105247.24413 | 37.7609590106658 | -122.421624291141 | (37.7609590106658, -122.421624291141) | ||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 935 | 935 | 143018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 404 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 0ft | 6010387.0782 | 2120648.4016 | 37.80348159588821 | -122.40826430805402 | (37.8034815958882, -122.408264308054) | |||
| 1023 | 1023 | 24311 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2639 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6006902.669840001 | 2121389.92308 | 37.8053218972443 | -122.420374939461 | (37.8053218972443, -122.420374939461) | ||||
| 1035 | 1035 | 189666 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015923.45326 | 2103178.08659 | 37.7558204715491 | -122.38788550510598 | (37.7558204715491, -122.387885505106) | |||
| 1057 | 1057 | 189664 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015924.43943 | 2103136.85911 | 37.755707324239395 | -122.38787921795799 | (37.7557073242394, -122.387879217958) | |||
| 1172 | 1172 | 143012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 336 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010686.887999999 | 2120692.5302 | 37.803619545603205 | -122.40722991099 | (37.8036195456032, -122.40722991099) | |||
| 1243 | 1243 | 242621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.745585061615294 | -122.413502636934 | (37.7455850616153, -122.413502636934) | |||
| 1385 | 1385 | 23847 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.43076422395599 | (37.7832409463281, -122.430764223956) | |||
| 1770 | 1770 | 192158 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 13 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | Permit Number 779453 | 6007102.0 | 2110018.0 | 37.7741086326202 | -122.418878096719 | (37.7741086326202, -122.418878096719) | ||
| 1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
| 1962 | 1962 | 224700 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | |||
| 2012 | 2012 | 224703 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | |||
| 2139 | 2139 | 23790 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003786.8931 | 2112715.8268 | 37.7813289751352 | -122.43053816621901 | (37.7813289751352, -122.430538166219) | |||
| 2157 | 2157 | 127892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133534999 | (37.7994012851886, -122.40934133535) | |
| 2170 | 2170 | 127072 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3399X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | Permit Number 779572 | 6001832.0 | 2119600.0 | 37.800120199825 | -122.437794333712 | (37.800120199825, -122.437794333712) | ||
| 2335 | 2335 | 195021 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6013679.6407 | 2113928.34961 | 37.7852137343684 | -122.396398867136 | (37.7852137343684, -122.396398867136) | |||
| 2534 | 2534 | 141911 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | |||
| 2746 | 2746 | 181806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5986469.7425 | 2099569.8124 | 37.7442374331929 | -122.489479287744 | (37.7442374331929, -122.489479287744) | |||
| 3185 | 3185 | 3123 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3195 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 5999194.2227 | 2114949.0037 | 37.787199455340705 | -122.44658721654801 | (37.7871994553407, -122.446587216548) | |||
| 3219 | 3219 | 142514 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | |
| 4093 | 4093 | 9911 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1850 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6005261.317559999 | 2116094.86183 | 37.7906903799087 | -122.425677947496 | (37.7906903799087, -122.425677947496) | |||
| 4228 | 4228 | 248327 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1525 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5998303.294 | 2108219.7591 | 37.768671763303104 | -122.449184645334 | (37.7686717633031, -122.449184645334) | |||
| 4251 | 4251 | 246122 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1518 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | Permit Number 46036 | 5998379.9097 | 2108286.3815 | 37.768859073318 | -122.448924438468 | (37.768859073318, -122.448924438468) | ||
| 4460 | 4460 | 55487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 20 | 6x9 | Permit Number 24565 | 6003098.1372 | 2110364.0779 | 37.774832616894706 | -122.43275287348601 | (37.7748326168947, -122.432752873486) |
| 4479 | 4479 | 18084 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2982 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4.5x15 | 5999689.9288 | 2114724.6521 | 37.786611746671205 | -122.444856053153 | (37.7866117466712, -122.444856053153) | |||
| 4568 | 4568 | 142545 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009562.3577 | 2121186.5007 | 37.80491286675579 | -122.41115633279499 | (37.8049128667558, -122.411156332795) | |||
| 4570 | 4570 | 142547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.804935373675605 | -122.41098310943799 | (37.8049353736756, -122.410983109438) | |||
| 4618 | 4618 | 20216 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002742.6384 | 2113206.5206 | 37.7826170851045 | -122.434185862237 | (37.7826170851045, -122.434185862237) | |||
| 4677 | 4677 | 177598 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 4ft | 5996913.03077 | 2087421.1486099998 | 37.7114842300863 | -122.452492300898 | (37.7114842300863, -122.452492300898) | |||
| 4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
| 5117 | 5117 | 23827 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003747.0158 | 2113043.0957 | 37.7822253147353 | -122.430699482992 | (37.7822253147353, -122.430699482992) | |||
| 5212 | 5212 | 291 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.299980001 | 2093633.8541299999 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | ||
| 5349 | 5349 | 2825 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6008708.35177 | 2116339.22144 | 37.791555508841206 | -122.413768643818 | (37.7915555088412, -122.413768643818) | |||
| 5351 | 5351 | 13158 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | |||
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | |||
| 5609 | 5609 | 105280 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002863.14914 | 2118997.09169 | 37.7985233499191 | -122.43418303843399 | (37.7985233499191, -122.434183038434) | |||
| 5848 | 5848 | 2810 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009146.78627 | 2116331.3706 | 37.7915585638337 | -122.412251105309 | (37.7915585638337, -122.412251105309) | |||
| 5918 | 5918 | 23710 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003962.5277 | 2111419.0963 | 37.77777842285779 | -122.429838035535 | (37.7777784228578, -122.429838035535) | |||
| 5960 | 5960 | 23430 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006108.8789099995 | 2117166.17514 | 37.793679794731396 | -122.422821595465 | (37.7936797947314, -122.422821595465) | |||
| 6075 | 6075 | 23828 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003742.203 | 2113074.035 | 37.78230999365589 | -122.430718341656 | (37.7823099936559, -122.430718341656) | |||
| 6113 | 6113 | 106866 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1892 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6003972.43426 | 2118715.7250900003 | 37.7978136859103 | -122.430324481915 | (37.7978136859103, -122.430324481915) | |||
| 6177 | 6177 | 14545 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999282.0507 | 2110078.3239 | 37.7738308435165 | -122.445932905938 | (37.7738308435165, -122.445932905938) | |||
| 6191 | 6191 | 13159 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.43234907433599 | (37.8004302230496, -122.432349074336) | |||
| 6224 | 6224 | 2995 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2295 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003466.6985 | 2115540.8379 | 37.7890675998104 | -122.43184765502899 | (37.7890675998104, -122.431847655029) | |||
| 6470 | 6470 | 110846 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2776 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000368.55091 | 2117170.43785 | 37.793365941237894 | -122.44268387196999 | (37.7933659412379, -122.44268387197) | |||
| 6483 | 6483 | 23497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2529 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | |||
| 6499 | 6499 | 20184 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1225 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1990 12:00:00 AM | 20 | 3X3 | 6002807.5597 | 2112456.2553 | 37.780560729769505 | -122.433907617841 | (37.7805607297695, -122.433907617841) | ||
| 6652 | 6652 | 13197 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2114 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002204.6803 | 2119511.1874 | 37.799897528014704 | -122.436498357806 | (37.7998975280147, -122.436498357806) | |||
| 6677 | 6677 | 121686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6010468.2399 | 2120204.652 | 37.8022677132519 | -122.4079521316 | (37.8022677132519, -122.4079521316) | |||
| 6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
| 6800 | 6800 | 23823 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003765.5794 | 2112902.15 | 37.781839364726 | -122.430625200646 | (37.781839364726, -122.430625200646) | |||
| 6832 | 6832 | 14547 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 810 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999284.7278 | 2110047.5378 | 37.7737464656007 | -122.4459214308 | (37.7737464656007, -122.4459214308) | |||
| 6910 | 6910 | 2812 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009199.61723 | 2116339.14024 | 37.7915828617187 | -122.41206885950301 | (37.7915828617187, -122.412068859503) | |||
| 7046 | 7046 | 23478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2415 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6x6 | 6005787.44434 | 2118746.70558 | 37.798001390610104 | -122.424046238267 | (37.7980013906101, -122.424046238267) | |||
| 7073 | 7073 | 112426 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2811 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000627.2120900005 | 2116484.87099 | 37.7914982957465 | -122.441739663868 | (37.7914982957465, -122.441739663868) | |||
| 7162 | 7162 | 23924 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x1 | 6003487.1069 | 2114786.6255 | 37.7869978805436 | -122.43172317383998 | (37.7869978805436, -122.43172317384) | |||
| 7199 | 7199 | 23528 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005747.5216 | 2119833.83468 | 37.800984116282294 | -122.42426174187901 | (37.8009841162823, -122.424261741879) | |||
| 7311 | 7311 | 23920 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x12 | 6003521.972999999 | 2114612.7568 | 37.786522457310205 | -122.43159012740699 | (37.7865224573102, -122.431590127407) | |||
| 7378 | 7378 | 2811 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009171.094 | 2116334.89627 | 37.791569608406895 | -122.412167249844 | (37.7915696084069, -122.412167249844) | |||
| 7386 | 7386 | 23826 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003751.8286 | 2113008.0312 | 37.78212930904171 | -122.43068032991002 | (37.7821293090417, -122.43068032991) | |||
| 7426 | 7426 | 113070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3108 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002434.36436 | 2118927.2467400003 | 37.7983072284463 | -122.435661765772 | (37.7983072284463, -122.435661765772) | |||
| 7451 | 7451 | 28768 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6X6 | 5999147.2771 | 2111039.3503 | 37.7764618793954 | -122.446468260318 | (37.7764618793954, -122.446468260318) | |||
| 7469 | 7469 | 23746 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6003946.8489 | 2111892.9498 | 37.779078619397396 | -122.429926083012 | (37.7790786193974, -122.429926083012) | |||
| 7491 | 7491 | 11081 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1844 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007326.98106 | 2118697.88229 | 37.7979541339441 | -122.418715522107 | (37.7979541339441, -122.418715522107) | |||
| 7529 | 7529 | 13218 | DPW Maintained 3 | Tristania conferta :: 79 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.799661752140295 | -122.43835485597299 | (37.7996617521403, -122.438354855973) | ||
| 7546 | 7546 | 7345 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2201 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1995 12:00:00 AM | 20 | 3x3 | 6002814.8619099995 | 2115881.6003099997 | 37.789966273667396 | -122.434127293036 | (37.7899662736674, -122.434127293036) | ||
| 7549 | 7549 | 20215 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002743.777000001 | 2113197.981 | 37.782593702138904 | -122.434181312497 | (37.7825937021389, -122.434181312497) | |||
| 7640 | 7640 | 11018 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007538.39019 | 2117184.37476 | 37.793810319634396 | -122.417876641695 | (37.7938103196344, -122.417876641695) | |||
| 7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) | |||
| 7721 | 7721 | 13116 | Permitted Site 1 | Tristania conferta :: 79 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.42835373390601 | (37.8007297168722, -122.428353733906) | ||
| 7870 | 7870 | 3180 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3600 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5997143.3153800005 | 2114725.5274099996 | 37.7864684873854 | -122.45366673184999 | (37.7864684873854, -122.45366673185) | |||
| 7937 | 7937 | 28767 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6X6 | 5999141.8623 | 2111078.2688 | 37.7765684303305 | -122.44648979216299 | (37.7765684303305, -122.446489792163) | |||
| 7985 | 7985 | 1718 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 9x6 | 6012538.2564900005 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | |||
| 8006 | 8006 | 23900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003566.3311 | 2114312.7691 | 37.7857012808729 | -122.43141523648701 | (37.7857012808729, -122.431415236487) | |||
| 8010 | 8010 | 115555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3897 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5996212.11985 | 2115219.4068 | 37.7877711202849 | -122.45692415093201 | (37.7877711202849, -122.456924150932) | |||
| 8129 | 8129 | 57513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1534 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16366 | 6000152.6691 | 2114258.7858 | 37.7853589960394 | -122.443221617032 | (37.7853589960394, -122.443221617032) | |
| 8214 | 8214 | 23518 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1989 12:00:00 AM | 20 | 3X3 | 6005659.14507 | 2119690.7477 | 37.800586245414294 | -122.424557378741 | (37.8005862454143, -122.424557378741) | ||
| 8298 | 8298 | 99117 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 480 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6011185.797590001 | 2119018.9032900003 | 37.799052083852295 | -122.40538546587901 | (37.7990520838523, -122.405385465879) | |||
| 8325 | 8325 | 23708 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6003978.3577 | 2111349.4443 | 37.77758807209621 | -122.429778304865 | (37.7775880720962, -122.429778304865) | ||||
| 8340 | 8340 | 2994 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2295 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003422.9072 | 2115536.4587 | 37.789053093117104 | -122.43199885436 | (37.7890530931171, -122.43199885436) | |||
| 8450 | 8450 | 13160 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003384.5853 | 2119677.9886 | 37.800422496977795 | -122.43242736604999 | (37.8004224969778, -122.43242736605) | |||
| 8565 | 8565 | 4733 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3x3 | 6007980.3619 | 2121165.8966 | 37.80476744709579 | -122.416629557244 | (37.8047674470958, -122.416629557244) | |||
| 8573 | 8573 | 13460 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6013821.04796 | 2116966.87557 | 37.793564687813 | -122.396122659246 | (37.793564687813, -122.396122659246) | |||
| 8599 | 8599 | 96031 | Permitted Site 1 | Psidium guajava :: Guava tree 252 | 1116 Greenwich St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 20 | Permit Number 767346 | 6007512.843169999 | 2119899.46213 | 37.8012638333238 | -122.418157616905 | (37.8012638333238, -122.418157616905) | ||
| 8606 | 8606 | 8111 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1993 12:00:00 AM | 20 | 3X3 | 6003847.5569 | 2111477.6208 | 37.7779326053256 | -122.430239935515 | (37.7779326053256, -122.430239935515) | ||
| 8637 | 8637 | 53285 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2641 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1969 12:00:00 AM | 20 | 4x5 | Permit Number 6175 | 6005287.315119999 | 2119080.31652 | 37.798889151862 | -122.425800588941 | (37.798889151862, -122.425800588941) | |
| 8699 | 8699 | 23824 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003763.5168 | 2112936.527 | 37.78193363853529 | -122.430634790088 | (37.7819336385353, -122.430634790088) | |||
| 8710 | 8710 | 23858 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003660.3858 | 2113644.0055 | 37.7838703542221 | -122.43104208573999 | (37.7838703542221, -122.43104208574) | |||
| 8815 | 8815 | 112427 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2811 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000642.98719 | 2116486.87241 | 37.7915046899417 | -122.441685226114 | (37.7915046899417, -122.441685226114) | |||
| 9013 | 9013 | 23929 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.786647847412404 | -122.431795587112 | (37.7866478474124, -122.431795587112) |
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");