Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1635 | 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) | ||||
| 3851 | 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) | |||||
| 5181 | 5181 | 253819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100x Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001057.0 | 2086858.0 | 37.71017450293179 | -122.43812937571998 | (37.7101745029318, -122.43812937572) | |||||
| 9962 | 9962 | 173753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1140 Lawton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990653.0 | 2104548.0 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | |||||
| 10162 | 10162 | 173888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Vasquez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995783.0 | 2100209.0 | 37.7465317821399 | -122.457322486502 | (37.7465317821399, -122.457322486502) | |||||
| 18892 | 18892 | 116488 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2149 LYON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999319.0 | 2116238.0 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | |||||
| 84801 | 84801 | 113939 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003181.0 | 2119826.0 | 37.8008173514055 | -122.43314243340299 | (37.8008173514055, -122.433142433403) | |||||
| 93980 | 93980 | 110202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1039 PAGE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.43795762529301 | (37.771984919077, -122.437957625293) | |||||
| 110015 | 110015 | 107354 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 34 Princeton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029478998 | (37.7297306299075, -122.41634029479) | ||||
| 115298 | 115298 | 104745 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 845 25TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 5988152.6 | 2110221.5 | 37.7735821764225 | -122.484441503692 | (37.7735821764225, -122.484441503692) | ||||
| 129412 | 129412 | 104753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | ||||
| 138482 | 138482 | 104990 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1931 21ST AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5989677.9 | 2102204.3 | 37.751657810714896 | -122.478578913714 | (37.7516578107149, -122.478578913714) | ||||
| 142221 | 142221 | 104943 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
| 1399 | 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) | |
| 1682 | 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) | ||
| 2037 | 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) | ||
| 2107 | 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) | |||
| 2120 | 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) | |||
| 2189 | 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) | |
| 2239 | 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 | 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) | |||
| 2746 | 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 | 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) | ||||
| 2895 | 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) | |||
| 3689 | 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 | 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) | ||||
| 3941 | 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 | 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 | 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 | 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) | ||
| 4510 | 4510 | 220293 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6008143.26275 | 2103888.31143 | 37.757336508186896 | -122.41484226615201 | (37.7573365081869, -122.414842266152) | |||
| 4534 | 4534 | 141427 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 306 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005914.5406 | 2110724.5553 | 37.7759817285641 | -122.423035961371 | (37.7759817285641, -122.423035961371) | ||||
| 5136 | 5136 | 119617 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3536 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2016 12:00:00 AM | 3 | 3x10 | 5999214.99092 | 2121000.37655 | 37.8038161003064 | -122.446950987796 | (37.8038161003064, -122.446950987796) | ||
| 5827 | 5827 | 120505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999789.0039 | 2116358.84365 | 37.7911044628415 | -122.44463077918199 | (37.7911044628415, -122.444630779182) | |||
| 6029 | 6029 | 112618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | |
| 6067 | 6067 | 114090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001183.088719999 | 2115909.2328 | 37.7899493996846 | -122.43977505527701 | (37.7899493996846, -122.439775055277) | ||||
| 6287 | 6287 | 102623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.80420514282329 | -122.40911005673401 | (37.8042051428233, -122.409110056734) | |||
| 6686 | 6686 | 114571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777013 | 5997418.550890001 | 2115712.12008 | 37.7891931831629 | -122.452785725389 | (37.7891931831629, -122.452785725389) | ||
| 7056 | 7056 | 110847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.44110318127599 | (37.7945324365719, -122.441103181276) | |
| 7274 | 7274 | 112384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3080 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x6 | 5999474.64167 | 2116368.74438 | 37.791113704275 | -122.445719170201 | (37.791113704275, -122.445719170201) | |||
| 8500 | 8500 | 104697 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011289.75094 | 2118992.82516 | 37.798986291241796 | -122.40502391323099 | (37.7989862912418, -122.405023913231) | |||
| 9853 | 9853 | 173717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004584.0 | 2110624.0 | 37.775630457098295 | -122.427631485331 | (37.7756304570983, -122.427631485331) | ||||
| 9957 | 9957 | 173686 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2211 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 3 | 6011691.0 | 2097676.0 | 37.740477553883096 | -122.402135979323 | (37.7404775538831, -122.402135979323) | |||
| 10031 | 10031 | 121152 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10078 | 10078 | 121575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57-59 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | 6x8 | Permit Number 779439 | 5991428.0 | 2114866.0 | 37.786524881607 | -122.473450350287 | (37.786524881607, -122.473450350287) | |
| 10124 | 10124 | 173862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999618.0 | 2107794.0 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | ||||
| 10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
| 10422 | 10422 | 100386 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | |||
| 10531 | 10531 | 120538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | |||
| 10853 | 10853 | 102802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.764141382947706 | -122.485851660773 | (37.7641413829477, -122.485851660773) | |||
| 10888 | 10888 | 113348 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | |||
| 10984 | 10984 | 105220 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1443 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5987410.3461 | 2105455.8349 | 37.760453729777396 | -122.48665903725299 | (37.7604537297774, -122.486659037253) | |||
| 11006 | 11006 | 120949 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2750 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5985472.8534 | 2102314.8398 | 37.7517162845821 | -122.493128443109 | (37.7517162845821, -122.493128443109) | |||
| 11670 | 11670 | 102444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.715798995606704 | -122.436645469419 | (37.7157989956067, -122.436645469419) | |||
| 12213 | 12213 | 115358 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 353 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778572 | 6001795.91538 | 2087927.53278 | 37.713153200931295 | -122.435652007258 | (37.7131532009313, -122.435652007258) | |
| 12564 | 12564 | 115359 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x6 | 6001770.67381 | 2087944.68785 | 37.7131988712114 | -122.43574047716001 | (37.7131988712114, -122.43574047716) | |||
| 13509 | 13509 | 106317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | |||
| 15924 | 15924 | 122795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | |||
| 18154 | 18154 | 111228 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 19747 | 19747 | 118326 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3200 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999426.0 | 2115708.0 | 37.7892966967134 | -122.44583992728799 | (37.7892966967134, -122.445839927288) | ||||
| 20386 | 20386 | 101023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999465.0 | 2119192.0 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | ||||
| 22309 | 22309 | 248978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987396.0 | 2097538.0 | 37.738712644317204 | -122.486127408072 | (37.7387126443172, -122.486127408072) | ||||
| 23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
| 23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 23674 | 23674 | 125034 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1467 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002193.9847099995 | 2121545.09547 | 37.8054814954333 | -122.436681037594 | (37.8054814954333, -122.436681037594) | |||
| 23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
| 23878 | 23878 | 106648 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1293 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5987685.171 | 2106501.0088 | 37.763339508501396 | -122.48578526928301 | (37.7633395085014, -122.485785269283) | ||||
| 23967 | 23967 | 184113 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2345 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5986890.7956 | 2104347.1916 | 37.7573793976552 | -122.4883744219 | (37.7573793976552, -122.4883744219) | |||
| 24253 | 24253 | 123529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2850 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5994479.78836 | 2110203.1842799997 | 37.7738982925338 | -122.462553643166 | (37.7738982925338, -122.462553643166) | |||
| 24384 | 24384 | 203942 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991551.86269 | 2098375.2612400004 | 37.7412528807104 | -122.47181953924299 | (37.7412528807104, -122.471819539243) | |||
| 24933 | 24933 | 125257 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1679 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6006675.18779 | 2116669.5471900003 | 37.792348114621205 | -122.42082683980101 | (37.7923481146212, -122.420826839801) | |||
| 24958 | 24958 | 102800 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 708 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5995062.7103 | 2110691.85511 | 37.7752736059254 | -122.460572652238 | (37.7752736059254, -122.460572652238) | ||||
| 25163 | 25163 | 125076 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2561 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002473.872140001 | 2116413.3703799997 | 37.7914070190769 | -122.435345140589 | (37.7914070190769, -122.435345140589) | |||
| 25166 | 25166 | 188682 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6018053.21017 | 2096769.99546 | 37.738342908392504 | -122.38007476635299 | (37.7383429083925, -122.380074766353) | |||
| 25424 | 25424 | 203675 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1410 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5990869.19006 | 2105764.6973 | 37.761502813611706 | -122.474719155868 | (37.7615028136117, -122.474719155868) | |||
| 25578 | 25578 | 123143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 582 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5992871.73325 | 2111517.5992400004 | 37.7774145847454 | -122.468211760136 | (37.7774145847454, -122.468211760136) | |||
| 25629 | 25629 | 123514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2744 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5994834.09227 | 2110246.18844 | 37.7740367681104 | -122.461331174398 | (37.7740367681104, -122.461331174398) | |||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 25759 | 25759 | 125026 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1448 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002274.88822 | 2121600.81722 | 37.8056390899449 | -122.436405050972 | (37.8056390899449, -122.436405050972) | |||
| 25984 | 25984 | 203972 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2595 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992046.64565 | 2097787.59989 | 37.739667928119395 | -122.470065990754 | (37.7396679281194, -122.470065990754) | |||
| 26074 | 26074 | 100245 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 539 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x4 | 5990297.625519999 | 2111697.27561 | 37.7777589234968 | -122.47712948237101 | (37.7777589234968, -122.477129482371) | |||
| 26417 | 26417 | 247936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1149 Esmeralda Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.40719593154101 | (37.7433403177918, -122.407195931541) | ||||
| 26622 | 26622 | 205143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994052.7239 | 2101916.59991 | 37.751120887023895 | -122.463429445513 | (37.7511208870239, -122.463429445513) | |||
| 26768 | 26768 | 203786 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2010 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5993506.591630001 | 2101771.6935400004 | 37.7506915308916 | -122.465307488051 | (37.7506915308916, -122.465307488051) | |||
| 26833 | 26833 | 203845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5992715.17465 | 2100010.79955 | 37.7458108948644 | -122.46791618659901 | (37.7458108948644, -122.467916186599) | |||
| 26982 | 26982 | 139794 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1680 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002025.3853 | 2112262.9143 | 37.779985446188 | -122.43659968326 | (37.779985446188, -122.43659968326) | |||
| 27121 | 27121 | 175065 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6008350.82377 | 2093981.22418 | 37.7301454998159 | -122.413423808678 | (37.7301454998159, -122.413423808678) | |||
| 27340 | 27340 | 220207 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 108 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008584.43652 | 2099064.66412 | 37.7441166332796 | -122.41297546067 | (37.7441166332796, -122.41297546067) | |||
| 27354 | 27354 | 182346 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1518 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5988091.9469 | 2104953.0189 | 37.7591128448339 | -122.48426484654499 | (37.7591128448339, -122.484264846545) | |||
| 27447 | 27447 | 122067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 119 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5990502.99469 | 2114587.30969 | 37.785706067148396 | -122.476630238281 | (37.7857060671484, -122.476630238281) | |||
| 27609 | 27609 | 125068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2735 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001667.659469999 | 2115975.31483 | 37.7901584138266 | -122.438103221909 | (37.7901584138266, -122.438103221909) | |||
| 27629 | 27629 | 123096 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 615 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5992508.96289 | 2111250.82612 | 37.776661139698206 | -122.469447267036 | (37.7766611396982, -122.469447267036) | |||
| 27646 | 27646 | 123187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 583 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5993119.00687 | 2111524.26387 | 37.777447162121796 | -122.46735685145599 | (37.7774471621218, -122.467356851456) | |||
| 27651 | 27651 | 122079 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 407 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5990576.14439 | 2112587.3908700002 | 37.780219088897795 | -122.47623103236201 | (37.7802190888978, -122.476231032362) | |||
| 27740 | 27740 | 125025 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002295.97534 | 2121603.81012 | 37.8056485058273 | -122.43633229041401 | (37.8056485058273, -122.436332290414) | |||
| 27764 | 27764 | 182538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1587 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5985892.0188 | 2104435.8019999997 | 37.757564371737296 | -122.491835062108 | (37.7575643717373, -122.491835062108) | |||
| 28094 | 28094 | 125067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2046 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 6000975.0103400005 | 2115480.36248 | 37.7887599869426 | -122.44046421475299 | (37.7887599869426, -122.440464214753) | |||
| 28132 | 28132 | 125235 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2348 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6004605.68272 | 2117291.83538 | 37.7939398966472 | -122.42803174399201 | (37.7939398966472, -122.428031743992) | |||
| 28185 | 28185 | 203813 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 5993917.658419999 | 2101338.69255 | 37.749526317999795 | -122.46385456944701 | (37.7495263179998, -122.463854569447) |
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");