Street_Tree_List

Data source: data.sfgov.org

3,964 rows where qSpecies = 5

View and edit SQL

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
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 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 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)
31 22614 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
58 4749 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1255 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.805773032263296 -122.41826116482599 (37.8057730322633, -122.418261164826)
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)
85 22613 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
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 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 20019 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY48 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 10ST            
670 13108 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1557 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3x3   6004929.5061 2119810.12 37.80087277869679 -122.427090735634 (37.8008727786968, -122.427090735634)
769 110848 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2668 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 778643 6000804.34505 2117582.1485 37.7945212238167 -122.441205550194 (37.7945212238167, -122.441205550194)
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)
940 51496 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1350 REVISED Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/2005 12:00:00 AM     Permit Number 47808 6000958.86990754 2110035.78536621 37.773809648853 -122.44012948036101 (37.773809648853, -122.440129480361)
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 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 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 20024 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY48 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
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 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)
1261 122608 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1214 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5987092.2626 2106978.1702 37.7646150951119 -122.487870979055 (37.7646150951119, -122.487870979055)
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 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 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)
1399 116632 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2332 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/15/2017 12:00:00 AM 17 3x3 Permit Number 779740 5991403.36215 2112037.8136299998 37.7787580362874 -122.473329239514 (37.7787580362874, -122.473329239514)
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 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 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 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)
1523 142666 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2310 MASON ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6008911.1908 2121214.7045 37.8049537680909 -122.413411770849 (37.8049537680909, -122.413411770849)
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)
1635 251542 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 50 Vista Ln   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 780127 5999350.0 2102347.0 37.752606437592604 -122.445141915929 (37.7526064375926, -122.445141915929)
1647 20023 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY48 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
1682 120803 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 711 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 Width 2ft   5989721.4593400005 2110495.24706 37.774425041585296 -122.479034671677 (37.7744250415853, -122.479034671677)
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)
1814 105384 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2853 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x3   5999429.08796 2117689.0147700002 37.794736216656794 -122.445971784396 (37.7947362166568, -122.445971784396)
1909 125218 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2101 Washington St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     13 Width 4ft   6005090.35688 2116771.11072 37.7925375271472 -122.42631763077499 (37.7925375271472, -122.426317630775)
1917 125217 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2101 Washington St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     29 Width 5ft Permit Number 768908 6005070.35193 2116772.06135 37.79253900653 -122.426386916319 (37.79253900653, -122.426386916319)
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 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)
2037 124755 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2040 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft Permit Number 779873 6003722.50351 2117641.05418 37.794848756005 -122.431112566798 (37.794848756005, -122.431112566798)
2081 252873 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Broderick St 7 Front Yard : Yard 7 Tree 1 Private 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
2107 250672 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 726 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   5986349.68151 2114864.86182 37.786226371002705 -122.491019750162 (37.7862263710027, -122.491019750162)
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)
2120 110253 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1322 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6000252.5201 2113528.9926 37.783360865552396 -122.442823740221 (37.7833608655524, -122.442823740221)
2121 79286 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1322 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2001 12:00:00 AM 15 3x3   6000254.8822 2113507.7337 37.7833026287552 -122.442814041263 (37.7833026287552, -122.442814041263)
2188 124801 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2898 Union St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft Permit Number 780062 5999229.08983 2118053.40815 37.7957253216105 -122.446690033314 (37.7957253216105, -122.446690033314)
2189 124797 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2898 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 Width 3ft Permit Number 780062 5999308.846 2118065.45598 37.795762957336706 -122.446414930702 (37.7957629573367, -122.446414930702)
2194 23455 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2240 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6005973.83981 2118127.35599 37.796311335142995 -122.423357203778 (37.796311335143, -122.423357203778)
2211 188595 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2230 112042 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2418 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM 17 3x3 Permit Number 776583 6002409.604230001 2117108.01013 37.79331067070571 -122.435617223266 (37.7933106707057, -122.435617223266)
2239 203945 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2579 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991715.80084 2097896.7211700003 37.7399484158804 -122.471217847832 (37.7399484158804, -122.471217847832)
2248 125016 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3399X Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6001832.0 2119600.0 37.800120199825 -122.437794333712 (37.800120199825, -122.437794333712)
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)
2354 18870 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2269 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6003913.0 2115924.0 37.790144955549394 -122.430330857904 (37.7901449555494, -122.430330857904)
2379 17840 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2017 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004165.4355 2115291.4590000003 37.7884224532463 -122.429412324105 (37.7884224532463, -122.429412324105)
2394 125087 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2498X Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2440 125088 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2498X Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2463 106683 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 125 Maple St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 6x300   5996555.44655 2115800.39633 37.789386070660704 -122.45577832652201 (37.7893860706607, -122.455778326522)
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 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)
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)
2777 253179 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 201x Drake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001862.0 2086566.0 37.709418484595 -122.43532626528601 (37.709418484595, -122.435326265286)
2778 246114 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1418 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2003 12:00:00 AM 13 Width 0ft Permit Number 47096 5998969.2151 2108370.2652 37.769123080801 -122.44689211719 (37.769123080801, -122.44689211719)
2779 246118 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1420 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/1993 12:00:00 AM 6 Width 0ft Permit Number 31980 5998892.5994 2108357.8492 37.769084612317705 -122.44715623175301 (37.7690846123177, -122.447156231753)
2780 246115 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1410 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2003 12:00:00 AM 13 Width 0ft Permit Number 47096 5998952.8623 2108365.1171 37.769108011186106 -122.446948309851 (37.7691080111861, -122.446948309851)
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 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 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)
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)
2895 114573 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3621 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5997465.48926 2115720.33673 37.7892184334409 -122.452623918478 (37.7892184334409, -122.452623918478)
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)
2994 142170 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1477 GROVE ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6000804.7229 2110664.0211 37.7755258488103 -122.440707770392 (37.7755258488103, -122.440707770392)
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 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)
3360 124968 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2822 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/05/2017 12:00:00 AM 3 Width 3ft   6001569.39846 2118152.80963 37.7961316595979 -122.438599283427 (37.7961316595979, -122.438599283427)
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 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 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)
3571 39975 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 0 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 41235          
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)
3621 249566 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1201 Franklin St 1 : 4 Tree 1 Private 1     16 Width 4ft   6005942.163819999 2114329.62673 37.7858819315591 -122.42319672154899 (37.7858819315591, -122.423196721549)
3689 252876 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1400 Baker St 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3694 252874 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Post St 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
3756 252875 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Post St 2 Front Yard : Yard 7 Tree 1 Private 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
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)
3817 253560 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 535 Castenada Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5992829.16774 2099990.2564 37.7457610706327 -122.46752052447701 (37.7457610706327, -122.467520524477)
3819 19829 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY25 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60X            
3851 252871 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2557 Sutter St   Front Yard : Yard 7 Tree 1 Private 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
3860 30022 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1659 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2016 10:15:00 AM 3 3x3   5998115.9942 2108549.9942 37.76956778996521 -122.449856300055 (37.7695677899652, -122.449856300055)
3903 220233 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Ashbury St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   05/23/1987 12:00:00 AM 39 Width 4ft Permit Number 12054 5999170.85741 2106639.03394 37.764381073148705 -122.44607010996201 (37.7643810731487, -122.446070109962)
3914 23457 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2249 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 5x5   6005866.883230001 2118164.3475 37.7964068674367 -122.42372992781901 (37.7964068674367, -122.423729927819)
3941 116781 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 200 Locust St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/10/2016 12:00:00 AM 3 3x3 Permit Number 778230 5997601.127169999 2115625.0178 37.788964483784106 -122.452147749912 (37.7889644837841, -122.452147749912)
4010 253604 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 267 Teresita Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x10   5997729.0 2098564.0 37.7421265906625 -122.450474893449 (37.7421265906625, -122.450474893449)
4105 253605 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 301 Teresita Blvd 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   5997753.0 2098469.0 37.741867117319 -122.45038506263799 (37.741867117319, -122.450385062638)
4138 203734 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2328 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft Permit Number 770921 5992653.8964 2099572.36715 37.7446035325326 -122.468096189498 (37.7446035325326, -122.468096189498)
4155 203731 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2342 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2004 12:00:00 AM 16 Width 4ft Permit Number 47446 5992657.79242 2099436.17889 37.7442298192534 -122.468072813407 (37.7442298192534, -122.468072813407)
4264 107589 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2760 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3   6000110.02976 2118059.62225 37.7957926664564 -122.443642277677 (37.7957926664564, -122.443642277677)
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 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)

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 1734.579ms · Data source: data.sfgov.org