trees
3,965 rows where qSpecies_id = 70 sorted by SiteOrder
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );