Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13675 | 13675 | 18550 | Landmark tree 9 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700X Quesada Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014656.2717 | 2095062.2920900001 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | |||
| 151907 | 151907 | 111321 | Section 143 8 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6010185.8855099995 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | ||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 78383 | 78383 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5996066.0 | 2095432.0 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | |||
| 78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
| 79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 79771 | 79771 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 595X San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006124.4715599995 | 2100100.1430599997 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | |||||
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | |||||
| 85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
| 89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
| 91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
| 102846 | 102846 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 103243 | 103243 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 105103 | 105103 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 105444 | 105444 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 107871 | 107871 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 118749 | 118749 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 138465 | 138465 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 Fairfax Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||||
| 154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
| 171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) | ||||
| 13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
| 18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 5 | 5 | 188702 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Evans Ave | 2 | : 4 | Tree 1 | DPW 2 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | |||
| 7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 1084 | 1084 | 8287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | ||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1171 | 1171 | 172952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.42498731221201 | (37.8034425497953, -122.424987312212) | ||
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 1297 | 1297 | 245226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 451 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005125.512 | 2110566.2977 | 37.7755026358833 | -122.42575415301701 | (37.7755026358833, -122.425754153017) | |||
| 1309 | 1309 | 9930 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6005037.50257 | 2117672.2143200003 | 37.7950087418189 | -122.42656470240699 | (37.7950087418189, -122.426564702407) | |||
| 1376 | 1376 | 141859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6004579.5781 | 2112622.703 | 37.7811181533984 | -122.42778922577801 | (37.7811181533984, -122.427789225778) | |||
| 1407 | 1407 | 220312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.759158924972404 | -122.436118906483 | (37.7591589249724, -122.436118906483) | ||
| 1431 | 1431 | 220311 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 18 | Width 3ft | 6001938.02984 | 2104676.35813 | 37.7591496745354 | -122.436358769151 | (37.7591496745354, -122.436358769151) | ||
| 1479 | 1479 | 23464 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2305 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005842.187999999 | 2118344.10635 | 37.796899045714504 | -122.423828167031 | (37.7968990457145, -122.423828167031) | |||
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 1555 | 1555 | 18077 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.44440512772499 | (37.7866642791044, -122.444405127725) | |||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1784 | 1784 | 7098 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2006 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997799.556 | 2109595.5069 | 37.772420388962296 | -122.451026246506 | (37.7724203889623, -122.451026246506) | |||
| 1983 | 1983 | 124970 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 4ft | 5999252.18429 | 2119704.33945 | 37.8002596566144 | -122.446728969472 | (37.8002596566144, -122.446728969472) | |||
| 2007 | 2007 | 124969 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 5999290.62404 | 2119668.8610400003 | 37.800164438189896 | -122.44659339936199 | (37.8001644381899, -122.446593399362) | |||
| 2110 | 2110 | 140215 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 736 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | Width 0ft | 6003875.2018 | 2110441.9467 | 37.7750904655336 | -122.430070401808 | (37.7750904655336, -122.430070401808) | |||
| 2269 | 2269 | 125219 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6003923.5815 | 2115960.33762 | 37.7902453288032 | -122.430296840347 | (37.7902453288032, -122.430296840347) | |||
| 2529 | 2529 | 141382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1294X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001285.0 | 2110102.0 | 37.7740100190711 | -122.439006092772 | (37.7740100190711, -122.439006092772) | |||
| 2681 | 2681 | 10334 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002067.0 | 2109164.0 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | |||
| 2794 | 2794 | 7088 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998522.1287 | 2109694.9471 | 37.7727347674481 | -122.448533971797 | (37.7727347674481, -122.448533971797) | |||
| 2828 | 2828 | 7026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1138 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6001973.7961 | 2110177.6605 | 37.7742569308448 | -122.436628850709 | (37.7742569308448, -122.436628850709) | |||
| 2844 | 2844 | 17858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003631.9915 | 2115212.7417 | 37.7881760994608 | -122.43125233371799 | (37.7881760994608, -122.431252333718) | |||
| 2971 | 2971 | 7062 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000002.1366 | 2109905.8257 | 37.773398298516 | -122.44342962722 | (37.773398298516, -122.44342962722) | |||
| 3010 | 3010 | 245175 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1128 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6000703.1785 | 2108961.6377 | 37.770845749220705 | -122.44093688299 | (37.7708457492207, -122.44093688299) | |||
| 3196 | 3196 | 9420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6005985.41292 | 2112474.4888400002 | 37.780790619431706 | -122.422915195091 | (37.7807906194317, -122.422915195091) | |||
| 3374 | 3374 | 26538 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008873.5963 | 2121134.1535 | 37.8047304843802 | -122.413536170716 | (37.8047304843802, -122.413536170716) | |||
| 3385 | 3385 | 23505 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6005801.9507 | 2119345.52815 | 37.7996464242096 | -122.424038648866 | (37.7996464242096, -122.424038648866) | |||
| 3503 | 3503 | 14499 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 5999064.4701 | 2111602.7455 | 37.7780040877061 | -122.44679526057199 | (37.7780040877061, -122.446795260572) | |||
| 3572 | 3572 | 7105 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2130 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 5997237.8283 | 2109516.8856 | 37.7721723399981 | -122.452963630149 | (37.7721723399981, -122.452963630149) | |||
| 3767 | 3767 | 7104 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2100 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997303.9815 | 2109524.8914 | 37.7721981126985 | -122.452735379757 | (37.7721981126985, -122.452735379757) | |||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 4407 | 4407 | 5225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.43853244967698 | (37.779223304768, -122.438532449677) | |||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 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) | |||
| 5001 | 5001 | 17864 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.78822595410529 | -122.430845453567 | (37.7882259541053, -122.430845453567) | |||
| 5165 | 5165 | 18104 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3047 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999356.199 | 2114621.5583 | 37.786309626644 | -122.446003255008 | (37.786309626644, -122.446003255008) | |||
| 5167 | 5167 | 27271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2134 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 6006018.78384 | 2117780.42149 | 37.7953612769429 | -122.42317701472 | (37.7953612769429, -122.42317701472) | |||
| 5281 | 5281 | 17859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003647.2236 | 2115215.6899 | 37.7881850576658 | -122.431199843789 | (37.7881850576658, -122.431199843789) | |||
| 5371 | 5371 | 18271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1949 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002897.9436 | 2114073.452 | 37.785006273193495 | -122.43371055367399 | (37.7850062731935, -122.433710553674) | |||
| 5383 | 5383 | 23482 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005868.84657 | 2118854.8733 | 37.7983029872579 | -122.423772257989 | (37.7983029872579, -122.423772257989) | |||
| 5388 | 5388 | 6963 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004011.7809 | 2110463.0214 | 37.7751560657789 | -122.42959944801599 | (37.7751560657789, -122.429599448016) | |||
| 5395 | 5395 | 5286 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1363 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001243.7155 | 2113125.1285 | 37.78230841581821 | -122.439365644426 | (37.7823084158182, -122.439365644426) | |||
| 5421 | 5421 | 13063 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.41113795910499 | (37.803120257284, -122.411137959105) | |||
| 5472 | 5472 | 6255 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 3X3 | 6004589.0866 | 2113270.6263 | 37.782897727980206 | -122.427802511173 | (37.7828977279802, -122.427802511173) | |||
| 5528 | 5528 | 23516 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2656 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/26/1994 12:00:00 AM | 30 | 5x5 | 6005775.26266 | 2119527.50037 | 37.800144566769205 | -122.42414394780899 | (37.8001445667692, -122.424143947809) | ||
| 5576 | 5576 | 14497 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | |||
| 5588 | 5588 | 9934 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005029.63249 | 2117730.67065 | 37.7951688031463 | -122.426596098652 | (37.7951688031463, -122.426596098652) |
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");