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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
248 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");