Street_Tree_List

Data source: data.sfgov.org

396 rows where DBH = 35

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
248 23733 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 800X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
275 818 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1385 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   5982124.8821 2105687.3873 37.7607799675436 -122.504955867812 (37.7607799675436, -122.504955867812)
345 13664 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 648 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6011893.33766 2115132.41268 37.788420242855395 -122.402663664993 (37.7884202428554, -122.402663664993)
497 14419 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 7 Median : Cutout 11 Tree 1 DPW 2     35     5998835.1676 2113089.5942 37.7820734871416 -122.447695558807 (37.7820734871416, -122.447695558807)
616 8142 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 924 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003320.2078 2111406.4501 37.777707304798206 -122.432059137251 (37.7777073047982, -122.432059137251)
867 5563 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1000 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3   6005047.93676 2102495.8008 37.753338590028 -122.42544803402399 (37.753338590028, -122.425448034024)
1163 2939 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1910 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6005122.54257 2115837.0032200003 37.789974522242105 -122.42613973678499 (37.7899745222421, -122.426139736785)
1692 2957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2045 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004590.8896 2115694.3359 37.7895527302687 -122.427969040021 (37.7895527302687, -122.427969040021)
1925 2958 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2055 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004523.0139999995 2115687.6045 37.7895304073237 -122.428203402517 (37.7895304073237, -122.428203402517)
2251 13985 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1155 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
2635 13840 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 974 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6009780.9039 2113133.8849 37.78281459658329 -122.40983125198 (37.7828145965833, -122.40983125198)
2927 13682 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6011577.51187 2114828.29204 37.787567561449706 -122.403734970715 (37.7875675614497, -122.403734970715)
3391 2983 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2226 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6003696.67837 2115640.99047 37.7893556277051 -122.431059105706 (37.7893556277051, -122.431059105706)
3452 2818 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6008957.0218 2116372.57941 37.79166106316271 -122.412910605154 (37.7916610631627, -122.412910605154)
3722 2900 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1675 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6006330.22809 2115940.35545 37.7903264863286 -122.4219685876 (37.7903264863286, -122.4219685876)
3797 2973 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2174 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6004006.64752 2115684.29812 37.789492098924605 -122.429989738932 (37.7894920989246, -122.429989738932)
3828 3019 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2490 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6002471.3865 2115470.57138 37.7888181937655 -122.43528627363999 (37.7888181937655, -122.43528627364)
3910 14420 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 8 Median : Cutout 11 Tree 1 DPW 2     35     5998841.5976 2113071.3194 37.7820236767836 -122.44767199806299 (37.7820236767836, -122.447671998063)
4300 13485 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6013562.43984 2116739.21834 37.7929252023844 -122.397001501025 (37.7929252023844, -122.397001501025)
4685 13602 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 550X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6012430.86322 2115656.01555 37.78988792923771 -122.400840701441 (37.7898879292377, -122.400840701441)
5283 2897 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1635 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6006502.249530001 2115965.50958 37.7904052534492 -122.42137519153098 (37.7904052534492, -122.421375191531)
5284 14661 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 683 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/14/2016 12:00:00 AM 35 3x3   6005906.95663 2112062.04188 37.7796537135926 -122.42315728808501 (37.7796537135926, -122.423157288085)
5287 2823 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6008783.893069999 2116347.56178 37.7915826512753 -122.41350786111401 (37.7915826512753, -122.413507861114)
5298 13176 Permitted Site 1 Tristania conferta :: 79 1964 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6002959.4463 2119614.5629 37.800224230069205 -122.43389397959601 (37.8002242300692, -122.433893979596)
5319 2956 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2022 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004492.42277 2115751.35307 37.7897037139057 -122.428313790248 (37.7897037139057, -122.428313790248)
5362 3137 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3302 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 2X3   5998543.29371 2114921.59911 37.787087006913296 -122.44883730591002 (37.7870870069133, -122.44883730591)
5368 13177 Permitted Site 1 Tristania conferta :: 79 1970 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/1995 12:00:00 AM 35 3x3   6002925.1953 2119612.0719999997 37.8002154469875 -122.434012323171 (37.8002154469875, -122.434012323171)
5380 23543 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2800X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     35 9   6005659.04127 2120027.6333 37.8015112413055 -122.424581715282 (37.8015112413055, -122.424581715282)
5402 13597 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 540 Market St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/01/1993 12:00:00 AM 35 4x4   6012489.6818699995 2115699.01218 37.7900092684568 -122.40064021469 (37.7900092684568, -122.40064021469)
5420 13483 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6013580.849640001 2116761.03172 37.7929861215694 -122.396939331812 (37.7929861215694, -122.396939331812)
5524 4635 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708)
5632 27388 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 2238 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6007145.97631 2119998.36118 37.8015147288815 -122.41943416045099 (37.8015147288815, -122.419434160451)
5634 23786 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100X Webster St 1 Median : Cutout 11 Tree 1 DPW 2     35 8X8   6003813.7072 2112544.6294 37.780860428691895 -122.43043318397301 (37.7808604286919, -122.430433183973)
5662 2799 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000X California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6009392.24103 2116434.8412200003 37.7918564390776 -122.411409144728 (37.7918564390776, -122.411409144728)
5782 29753 Permitted Site 1 Liriodendron tulipifera :: Tulip Tree 85 532 Columbus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6009968.1915 2119398.824 37.8000270997238 -122.409625640361 (37.8000270997238, -122.409625640361)
5894 13594 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 540 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6012508.056480001 2115733.02837 37.790103693670105 -122.400579030224 (37.7901036936701, -122.400579030224)
6199 2940 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1915 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6005167.0236 2115779.1152 37.789818090233204 -122.42598171365499 (37.7898180902332, -122.425981713655)
6274 2837 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1240 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6008427.79674 2116298.62891 37.7914282925179 -122.414736489715 (37.7914282925179, -122.414736489715)
6452 13171 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1940X Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003096.45 2119636.9817 37.8002935599258 -122.433421496602 (37.8002935599258, -122.433421496602)
6457 13601 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 550X Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6012438.07784 2115649.39502 37.7898701532365 -122.400815274032 (37.7898701532365, -122.400815274032)
6519 23572 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 3015 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3x3   6005516.07344 2120742.37785 37.8034656713563 -122.425127334879 (37.8034656713563, -122.425127334879)
6638 2796 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000X California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6009497.37807 2116449.99792 37.7919039520553 -122.411046440041 (37.7919039520553, -122.411046440041)
6804 2822 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6008807.12845 2116351.1139599998 37.791593709322704 -122.413427718016 (37.7915937093227, -122.413427718016)
6854 13477 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6013657.322819999 2116828.54593 37.7931757561944 -122.396679463701 (37.7931757561944, -122.396679463701)
7030 2797 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000X California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6009460.44317 2116444.9215599997 37.7918879423249 -122.411173876682 (37.7918879423249, -122.411173876682)
7246 2827 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6008639.6141099995 2116329.28167 37.791524356309296 -122.414005772556 (37.7915243563093, -122.414005772556)
7425 8168 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1160 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6002214.9627 2111253.4218 37.7772244047313 -122.435871600468 (37.7772244047313, -122.435871600468)
7501 2819 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6008928.2738 2116369.13979 37.79165000508029 -122.41300983004999 (37.7916500050803, -122.41300983005)
7509 23794 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1125 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003750.8632 2112612.5515 37.7810433657763 -122.43065544025299 (37.7810433657763, -122.430655440253)
7579 13595 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 540 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6012504.140380001 2115715.04427 37.7900540951675 -122.400591315838 (37.7900540951675, -122.400591315838)
7608 2820 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6008878.50694 2116362.65157 37.791629396227 -122.41318156457199 (37.791629396227, -122.413181564572)
7643 3187 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3633 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   5997052.1923 2114651.58 37.7862602231647 -122.453976650752 (37.7862602231647, -122.453976650752)
7749 8151 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1040 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6002784.7119 2111334.3365 37.777478924912295 -122.43390644299 (37.7774789249123, -122.43390644299)
7769 13131 Permitted Site 1 Callistemon citrinus :: Lemon Bottlebrush 28 1727 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6003964.7125 2119675.6431 37.8004489355963 -122.43041972679701 (37.8004489355963, -122.430419726797)
7782 2911 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1700 California St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6005970.58467 2115958.9426 37.790357232353294 -122.42321425205601 (37.7903572323533, -122.423214252056)
7783 2798 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000X California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6009428.97581 2116439.3572400003 37.7918708992813 -122.411282361009 (37.7918708992813, -122.411282361009)
7860 13598 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 540 Market St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6012480.80052 2115707.07395 37.7900309088423 -122.400671510176 (37.7900309088423, -122.400671510176)
7884 13758 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 844X Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6010659.886030001 2113947.47639 37.7850977469945 -122.40684768708701 (37.7850977469945, -122.406847687087)
7922 3182 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3619 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 4X4   5997107.1858 2114657.5024 37.7862796375046 -122.453786816382 (37.7862796375046, -122.453786816382)
7934 2984 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2230 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003649.5267 2115637.0296400003 37.7893420803323 -122.43122196213801 (37.7893420803323, -122.431221962138)
8063 23548 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2822 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6005698.29125 2120114.21678 37.8017511939304 -122.42445205462201 (37.8017511939304, -122.424452054622)
8371 3188 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3633 California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   5997062.6834 2114652.9337 37.7862645415865 -122.45394045226601 (37.7862645415865, -122.453940452266)
8548 2949 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2000 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004741.01767 2115786.11387 37.7898132216595 -122.427456153582 (37.7898132216595, -122.427456153582)
8551 112044 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2418 Pacific Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6002377.10471 2117102.71936 37.793294297651 -122.435729294977 (37.793294297651, -122.435729294977)
8581 13475 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6013678.69265 2116845.0896799997 37.7932223707775 -122.396606682472 (37.7932223707775, -122.396606682472)
8584 2988 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2266X California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003528.90719 2115622.95537 37.7892965998021 -122.431638286196 (37.7892965998021, -122.431638286196)
8616 23547 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2806 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6005703.65589 2120048.52482 37.801571123555895 -122.424428815235 (37.8015711235559, -122.424428815235)
8785 13129 Permitted Site 1 Tristania conferta :: 79 1721 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004129.6812 2119699.0984 37.800522681160494 -122.42985054289801 (37.8005226811605, -122.429850542898)
8821 13813 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 950 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6009924.2162 2113263.2339 37.7831777886609 -122.409344580625 (37.7831777886609, -122.409344580625)
8880 2937 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1900X California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6005218.56356 2115847.96143 37.790010037392605 -122.425808292537 (37.7900100373926, -122.425808292537)
8968 23829 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1200X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     35 20   6003737.3903 2113105.6618 37.782396560281 -122.430737249093 (37.782396560281, -122.430737249093)
9125 935 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1296X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x6   6002794.708219999 2094140.5399099998 37.7302694162157 -122.432643375557 (37.7302694162157, -122.432643375557)
9420 12628 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 840 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   5992820.04588 2114852.30881 37.786567801977796 -122.46863326133999 (37.7865678019778, -122.46863326134)
9549 14717 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 860 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6002499.3078 2111491.3684 37.77789389493321 -122.434904982102 (37.7778938949332, -122.434904982102)
10453 1134 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2571 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   5998552.04947 2088553.0790900001 37.714686023424 -122.446908847388 (37.714686023424, -122.446908847388)
10510 1087 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2174 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   5999920.01803 2089753.43888 37.718059997362396 -122.442266720544 (37.7180599973624, -122.442266720544)
10512 17351 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2465X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 5x6   5998980.538980001 2088741.4532700002 37.7152277264619 -122.445441354337 (37.7152277264619, -122.445441354337)
10725 941 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1352 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 5x5   6002586.79672 2094029.0615 37.7299515286195 -122.43335418993799 (37.7299515286195, -122.433354189938)
10776 11581 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1398X 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   5982172.447000001 2105630.3094 37.7606260461716 -122.504787135388 (37.7606260461716, -122.504787135388)
10785 1296 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 4 Median : Cutout 11 Tree 1 DPW 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
11388 1022 DPW Maintained 3 Ulmus americana :: American Elm 119 1909 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6000975.40411 2090904.61398 37.721280958817296 -122.43870115865101 (37.7212809588173, -122.438701158651)
12028 17573 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 750 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   6003469.3677199995 2090473.15538 37.720237833385404 -122.430049472832 (37.7202378333854, -122.430049472832)
12133 17594 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 808 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3x3   6003660.5889 2090352.7029799998 37.719917925661 -122.42937989966002 (37.719917925661, -122.42937989966)
12280 956 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1525 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6002060.364709999 2093260.71871 37.727811954252 -122.435119193111 (37.727811954252, -122.435119193111)
12747 1132 DPW Maintained 3 Ulmus americana :: American Elm 119 2565 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   5998605.297809999 2088582.84713 37.7147708016152 -122.446726940623 (37.7147708016152, -122.446726940623)
12800 1083 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2150 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3x3   5999998.5130900005 2089822.2609599999 37.718253440618504 -122.44200033506901 (37.7182534406185, -122.442000335069)
12852 17587 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 801X Persia Ave 11 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     35 3X3   6003703.481380001 2090378.19842 37.7199903588363 -122.42923345225901 (37.7199903588363, -122.429233452259)
12927 1025 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1948 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6000854.43502 2090852.74185 37.7211316470959 -122.439115597724 (37.7211316470959, -122.439115597724)
13013 1304 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 4000X Alemany Blvd 12 Median : Cutout 11 Tree 1 DPW 2     35 10   5991645.96929 2086939.8139900002 37.7098594231521 -122.470661434599 (37.7098594231521, -122.470661434599)
13231 17623 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1101 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6004371.84322 2089954.8563599999 37.718865768324 -122.426893019707 (37.718865768324, -122.426893019707)
13489 13996 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1169 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6008486.6991 2111764.6137 37.778982291004894 -122.414211764042 (37.7789822910049, -122.414211764042)
13545 13766 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 865 Market St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/24/1990 12:00:00 AM 35 4X4   6010539.70069 2113720.69454 37.78446833218 -122.407247500483 (37.78446833218, -122.407247500483)
13729 13674 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 681 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6011788.8197 2114903.8104 37.787786719038 -122.40300919714399 (37.787786719038, -122.403009197144)
13733 29537 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015071.7012 2091079.6967 37.7225535544976 -122.38998606447299 (37.7225535544976, -122.389986064473)
14008 13898 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1055 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/1994 12:00:00 AM 35 4X4   6009298.7870000005 2112544.6638 37.781169705303704 -122.411457539383 (37.7811697053037, -122.411457539383)
14009 13544 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 425 Market St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6013158.44707 2116241.79005 37.7915368847793 -122.398364428096 (37.7915368847793, -122.398364428096)
14133 29536 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015127.6919 2091149.846 37.7227492757118 -122.38979741293699 (37.7227492757118, -122.389797412937)
14220 13563 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 455 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6013011.94097 2116095.6901 37.791127566445496 -122.3988610823 (37.7911275664455, -122.3988610823)
14240 13858 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 995 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/01/1990 12:00:00 AM 35 4X4   6009732.8033 2112958.8474 37.7823312894321 -122.40998529993901 (37.7823312894321, -122.409985299939)
14285 11226 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/1992 12:00:00 AM 35 3X4   6018091.97554 2094860.3210200001 37.7331014580651 -122.379808087687 (37.7331014580651, -122.379808087687)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2853.178ms · Data source: data.sfgov.org