3,965 rows where qSpecies_id = 70 sorted by SiteOrder

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
3798 262575 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 141 Topaz Way   Front Yard : Yard Tree Private 2       3x3   6001722 2097902 37.7405366227001 -122.436621002014 (37.7405366227001, -122.436621002014) 2 7 5 63 7
5429 116488 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2149 LYON ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
6833 109426 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 132 Locust St   Sidewalk: Curb side : Cutout Tree Private 2   02/13/2015 12:00:00 AM 3     5997544.3 2115966.4 37.7898985728773 -122.452369007612 (37.7898985728773, -122.452369007612) 11 6 1 54 31
7388 29904 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 Fell St   Sidewalk: Curb side : Cutout Tree DPW 1           6004657.19551 2110576.88809 37.7755052392808 -122.427374927138 (37.7755052392808, -122.427374927138) 7 9 11 28852 10
26139 253819 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100x Prague St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001057 2086858 37.7101745029318 -122.43812937572 (37.7101745029318, -122.43812937572) 9 7 6 28861 5
31746 104753 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2328 12TH AVE   Front Yard : Cutout Tree Private 2     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356) 1 8 4 29491 40
39912 88823 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 110 Clayton St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51710 5998275 2110294 37.7743654794888 -122.44943198445 (37.7743654794888, -122.44943198445) 15 5 11 29492 16
46279 254187 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 128 Stonecrest Dr   Sidewalk: Property side : Cutout Tree Private 2       3x3   5990776 2093635 37.7281924051657 -122.474156376051 (37.7281924051657, -122.474156376051) 9 8 4 64 40
59777 113939 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3333 BUCHANAN ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003181 2119826 37.8008173514055 -122.433142433403 (37.8008173514055, -122.433142433403) 13 9 1 57 17
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
63703 86887 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 56 Casa Way   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49816 6001536.6 2121651.4 37.8057359986938 -122.438963625045 (37.8057359986938, -122.438963625045) 13 9 1 57 17
65765 173753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1140 Lawton St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990653 2104548 37.7581495573033 -122.475378025252 (37.7581495573033, -122.475378025252) 1 8 4 56 12
81891 110202 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1039 PAGE ST   Front Yard : Cutout Tree Private 2       4x5   6001572.7 2109358.5 37.771984919077 -122.437957625293 (37.771984919077, -122.437957625293) 15 5 11 29492 9
95376 88602 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 370 Parnassus Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51547 5996151.9 2106560.1 37.7639914803102 -122.45650607155 (37.7639914803102, -122.45650607155) 15 5 11 29492 12
135252 254189 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 187x Stonecrest Dr   Front Yard : Cutout Tree Private 2       3x3   5990830 2093201 37.7270038779971 -122.473938047356 (37.7270038779971, -122.473938047356) 9 8 4 64 40
138773 88989 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1696 McAllister St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51741 5997688 2111682 37.7781429711136 -122.451562655149 (37.7781429711136, -122.451562655149) 15 6 2 54 16
140083 29905 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 Fell St   Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004657.19551 2110576.88809 37.7755052392808 -122.427374927138 (37.7755052392808, -122.427374927138) 7 9 11 28852 10
145350 107354 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 34 Princeton St   Sidewalk: Curb side : Cutout Tree Private 2   08/25/2014 12:00:00 AM     Permit Number 773911 6007504.47131 2093847.45075 37.7297306299075 -122.41634029479 (37.7297306299075, -122.41634029479) 9 3 7 309 28
148762 104745 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 845 25TH AVE   Sidewalk: Curb side : Cutout Tree Private 2     20 4x4   5988152.6 2110221.5 37.7735821764225 -122.484441503692 (37.7735821764225, -122.484441503692) 11 6 2 55 26
153430 104809 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 685 Marina Blvd   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 770974 5999736.8 2121509.8 37.8052446370698 -122.445181890463 (37.8052446370698, -122.445181890463) 13 9 1 57 17
167509 104990 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1931 21ST AVE   Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5989677.9 2102204.3 37.7516578107149 -122.478578913714 (37.7516578107149, -122.478578913714) 1 8 3 29491 35
182107 251542 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 50 Vista Ln   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 780127 5999350 2102347 37.7526064375926 -122.445141915929 (37.7526064375926, -122.445141915929) 2 5 5 63 38
184296 104943 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 830X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
192979 89262 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1 Polk St   Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
553 12808 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2112 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5   5988878.34651 2114712.3148 37.7859549296707 -122.482260152644 (37.7859549296707, -122.482260152644) 11 6 1 55 33
609 203926 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1799X 12th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5992472.81762 2103516.18857 37.7554217903919 -122.469009276583 (37.7554217903919, -122.469009276583) 1 8 4 56 12
729 203987 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1520 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992392.5651 2096889.45083 37.7372218288298 -122.46880462056 (37.7372218288298, -122.46880462056) 1 8 4 59 40
756 124716 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
837 203953 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2360 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5991715.8619 2099340.71022 37.7439132444177 -122.471322820316 (37.7439132444177, -122.471322820316) 1 8 4 29491 40
885 203703 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 633 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   5992869.03861 2105232.1882 37.7601563630469 -122.467763833333 (37.7601563630469, -122.467763833333) 1 8 4 56 12
1104 125224 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2285 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6003837.08538 2116275.37223 37.7911054341186 -122.430618599767 (37.7911054341186, -122.430618599767) 13 9 1 29490 27
1633 50106 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1550 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46830 5992376.29027554 2096837.8582672 37.7370792283941 -122.468857136293 (37.7370792283941, -122.468857136293) 1 8 4 59 40
1656 125137 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2645 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000115.81749 2117703.18818 37.7948143227728 -122.443596633488 (37.7948143227728, -122.443596633488) 13 9 1 57 27
1696 12442 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2001X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004358.0388014 2115316.8218262 37.788502995764 -122.428747755973 (37.788502995764, -122.428747755973) 13 9 11 29490 27
1805 203698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1696 09th Ave 1 Front Yard : Yard Tree Private 2     25 Width 6ft   5993434.49176 2103973.54477 37.7567330891842 -122.46571676863 (37.7567330891842, -122.46571676863) 1 8 4 56 12
1816 123121 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 586 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   5992562.41321 2111484.60446 37.7773061204935 -122.469279388077 (37.7773061204935, -122.469279388077) 11 6 2 54 11
1875 261661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26
2052 13108 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1557 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3x3   6004929.5061 2119810.12 37.8008727786968 -122.427090735634 (37.8008727786968, -122.427090735634) 13 9 1 57 17
2055 83818 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1653-1655 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22     6008323.3908 2118208.09875 37.7966653595727 -122.415232960457 (37.7966653595727, -122.415232960457) 5 1 10 28858 21
2155 174995 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 83 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6000678.32688 2088039.79794 37.71339791366 -122.439522805332 (37.71339791366, -122.439522805332) 9 7 6 28861 5
2457 115561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 44 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 4x10 Permit Number 777606 5989293.97789 2114922.2794 37.7865556002814 -122.480837576069 (37.7865556002814, -122.480837576069) 11 6 1 55 33
2541 8258 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1550 Galvez Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6015754 2097743 37.740887466773 -122.388092261865 (37.740887466773, -122.388092261865) 10 3 8 58 1
2861 116035 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 280 GLENVIEW DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5999243 2100752 37.748220848146 -122.445397263788 (37.748220848146, -122.445397263788) 2 5 5 63 38
2878 124826 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 56 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6001759.52883 2120853.50314 37.8035578671766 -122.438134955373 (37.8035578671766, -122.438134955373) 13 9 1 57 17
2948 34162 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1321 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1997 12:00:00 AM     Permit Number 37995 6002005.24557776 2100252.01136141 37.7470052949129 -122.435809748575 (37.7470052949129, -122.435809748575) 2 7 5 63 22
3045 261353 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 160 Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5990864 2091394 37.7220442755547 -122.473688749933 (37.7220442755547, -122.473688749933) 9 8 4 64 40
3224 188631 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101 Charter Oak Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27     6010953.30174 2096155.78186 37.7362621559727 -122.404579676927 (37.7362621559727, -122.404579676927) 10 3 8 58 1
3225 248333 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1329 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999495.3806 2108202.9521 37.7686937265955 -122.445060117561 (37.7686937265955, -122.445060117561) 15 5 11 29492 9
3768 262321 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Stonecrest Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990975 2093805 37.7286707085155 -122.473480827138 (37.7286707085155, -122.473480827138) 9 8 4 64 40
3855 203845 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 535 Castenada Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   5992715.17465 2100010.79955 37.7458108948644 -122.467916186599 (37.7458108948644, -122.467916186599) 1 8 4 29491 40
4435 100789 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 29 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     28 6x25 Permit Number 27110 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
4735 262469 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 35 Broadmoor Dr 1 Sidewalk: Property side : Yard Tree Private 2       2x6   5991096 2093545 37.7279638199594 -122.4730435743 (37.7279638199594, -122.4730435743) 9 8 4 64 40
4794 23518 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2701 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005659.14507 2119690.7477 37.8005862454143 -122.424557378741 (37.8005862454143, -122.424557378741) 13 9 1 57 17
4872 262191 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1799x 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12
5170 123339 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 707 04th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5994708.43965 2110694.76521 37.7752612085311 -122.461798357647 (37.7752612085311, -122.461798357647) 11 6 2 54 11
5261 262386 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 198 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private         6005187.2243 2109578.99326 37.7727952246844 -122.425470396534 (37.7727952246844, -122.425470396534) 7 9 11 28852 10
5419 87002 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 7070 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM   3x3 Permit Number 49944 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
5478 175059 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Valmar Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6005473.36477 2092951.58695 37.7271563601569 -122.423298402505 (37.7271563601569, -122.423298402505) 9 7 6 28861 5
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
5779 175064 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 68 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6007788.38725 2093731.97467 37.7294295189361 -122.415350591757 (37.7294295189361, -122.415350591757) 9 3 7 309 28
5993 121864 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 726 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5990081.19098 2110389.87046 37.7741565902544 -122.47778260073 (37.7741565902544, -122.47778260073) 11 6 2 55 26
6106 125254 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1299 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008497.00299 2116907.63911 37.7931043734065 -122.414540150606 (37.7931043734065, -122.414540150606) 5 1 10 28858 21
6497 125008 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3790 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6002036.5769 2121760.24067 37.8060632803659 -122.437241182151 (37.8060632803659, -122.437241182151) 13 9 1 57 17
6575 125025 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1442 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002295.97534 2121603.81012 37.8056485058273 -122.436332290414 (37.8056485058273, -122.436332290414) 13 9 1 57 17
6759 111228 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1113 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001842 2112262 37.7799725127801 -122.4372340286 (37.7799725127801, -122.4372340286) 15 5 11 29490 41
6793 106402 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 163 25TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 18 3x3   5987994.2 2114906.9 37.7864377375077 -122.485333302781 (37.7864377375077, -122.485333302781) 11 6 1 55 33
6854 39379 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1354 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40920 6007143.93712268 2107602.08417603 37.7674774616365 -122.418561678075 (37.7674774616365, -122.418561678075) 8 4 7 28853 19
7063 74916 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2350 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20     5991352.54702 2112035.32766 37.7787482679253 -122.473504845805 (37.7787482679253, -122.473504845805) 11 6 2 54 26
7206 264879 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 94 Stratford Dr 1 Sidewalk: Property side : Yard Tree Private 2       4x6   5990921 2091777 37.7230991995598 -122.473519640019 (37.7230991995598, -122.473519640019) 9 8 4 64 40
7614 6251 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1315 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144) 7 9 11 29490 41
7932 18681 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 155 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     23 3X3   5999165.53622 2119642.20723 37.8000841081609 -122.447024330929 (37.8000841081609, -122.447024330929) 13 9 1 57 17
8099 125296 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 510 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6010613.51109 2116010.55836 37.7907598831005 -122.407153607672 (37.7907598831005, -122.407153607672) 5 1 10 28857 6
8459 142451 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 612 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6004562.1168 2110606.9092 37.7755822921182 -122.427705966737 (37.7755822921182, -122.427705966737) 7 9 11 28852 10
8511 60095 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3343 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/19/1982 12:00:00 AM 10   Permit Number 19596 5998235.21709 2116151.87187 37.7904473875938 -122.449991880723 (37.7904473875938, -122.449991880723) 13 6 1 54 31
8673 175076 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1262 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6001389.55659 2087620.87899 37.7122881079857 -122.437034577295 (37.7122881079857, -122.437034577295) 9 7 6 28861 5
8752 7916 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1225 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6005951.06937 2114267.1292 37.7857108313539 -122.423161466763 (37.7857108313539, -122.423161466763) 13 9 1 28858 41
8928 116888 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 799X Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5999171.6155 2121461.35655 37.8050793482968 -122.447134285827 (37.8050793482968, -122.447134285827) 13 9 1 57 17
8988 125125 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2921 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft Permit Number 784827 5999533.93344 2117358.43143 37.7938345087112 -122.445585222496 (37.7938345087112, -122.445585222496) 13 9 1 57 27
9481 10434 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1457 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   5999128.9575 2108690.2041 37.7700106766776 -122.44636259864 (37.7700106766776, -122.44636259864) 15 5 11 29492 9
9651 140669 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 420 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996810.1841 2110348.4784 37.7744311612044 -122.4545029637 (37.7744311612044, -122.4545029637) 15 5 2 29492 16
10158 203254 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 355 Hazelwood Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   5996025.0602 2095489.12153 37.7335860541429 -122.456144283154 (37.7335860541429, -122.456144283154) 9 7 4 59 40
10310 23457 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2249 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5x5   6005866.88323 2118164.3475 37.7964068674367 -122.423729927819 (37.7964068674367, -122.423729927819) 13 9 1 28858 27
10456 118326 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3200 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999426 2115708 37.7892966967134 -122.445839927288 (37.7892966967134, -122.445839927288) 13 6 1 29490 31
10569 50188 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3134 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2003 12:00:00 AM 12   Permit Number 46895 5999411.86905 2119620.94961 37.8000398110413 -122.446170397871 (37.8000398110413, -122.446170397871) 13 9 1 57 17
10864 203957 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 191 Taraval St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5992667.73438 2099093.54036 37.743289595145 -122.468013518407 (37.743289595145, -122.468013518407) 1 8 4 29491 40
10950 221380 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 17 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x6   6001456.08064 2108152.14288 37.768665929923 -122.438274581434 (37.768665929923, -122.438274581434) 15 5 5 29492 3
11032 221382 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 715 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6002069.15258 2108242.45894 37.7689487658061 -122.436160481228 (37.7689487658061, -122.436160481228) 15 5 5 29492 3
11242 203747 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 265 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992322.04503 2097512.5452 37.7389286143523 -122.469093773255 (37.7389286143523, -122.469093773255) 1 8 4 59 40
11322 203935 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 30 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991414.01915 2104819.13724 37.7589381117154 -122.472765887756 (37.7589381117154, -122.472765887756) 1 8 4 56 12
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
11522 125190 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2809 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6003477.09721 2118091.6097 37.7960719563118 -122.431993895221 (37.7960719563118, -122.431993895221) 13 9 1 57 17
11631 125182 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2409 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002021.80255 2117699.99218 37.7949140656765 -122.437001442682 (37.7949140656765, -122.437001442682) 13 9 1 57 27
11987 123197 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 535 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5993108.64325 2111815.91 37.7782473453158 -122.467413915116 (37.7782473453158, -122.467413915116) 11 6 2 54 11
12035 182056 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1338 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5987434.16 2106158.3393 37.7623840025198 -122.486628260583 (37.7623840025198, -122.486628260583) 1 8 3 56 35
12317 124989 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2330 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   5999632.98493 2120193.24081 37.8016237941718 -122.445446428326 (37.8016237941718, -122.445446428326) 13 9 1 57 17
12411 260714 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2290 Lyon St 1 Back Yard : Cutout Tree Private 2       3x3 Permit Number 784756 5999390 2116615 37.7917850243096 -122.446029746387 (37.7917850243096, -122.446029746387) 13 6 1 29490 27
12430 220123 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 501 Haight St 1 : Tree Private 2     26 Width 4ft   6003680.56736 2109328.54381 37.772022309504 -122.430664217001 (37.772022309504, -122.430664217001) 15 9 11 29492 10
12775 260566 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 250 Denslowe Dr 1 Sidewalk: Property side : Yard Tree DPW 1           5990592.24818 2090826.09743 37.7204692135739 -122.474586693137 (37.7204692135739, -122.474586693137) 9 8 4 64 40
13033 20683 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1505X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984801 2104643 37.7580694516324 -122.495623472482 (37.7580694516324, -122.495623472482) 1 8 3 56 35
13449 123516 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2750 Fulton St 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 8ft   5994807.17299 2110239.19888 37.7740160273107 -122.461423785316 (37.7740160273107, -122.461423785316) 11 6 2 54 11

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);