Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58 | 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) | ||
| 670 | 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 | 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) | ||
| 940 | 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) | |||
| 1261 | 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) | |||
| 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) | |
| 1523 | 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) | |||
| 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) | ||||
| 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) | ||
| 1814 | 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) | |||
| 1917 | 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) | ||
| 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) | ||
| 2081 | 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 | 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) | |||
| 2121 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
| 2354 | 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 | 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 | 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 | 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 | 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) | |||
| 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) | ||||
| 2778 | 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 | 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 | 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) | |
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 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) | |||
| 2994 | 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) | |||
| 3360 | 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) | ||
| 3571 | 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 | |||||||||
| 3621 | 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 | 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) | ||||
| 3756 | 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) | ||||
| 3817 | 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) | ||||
| 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) | |||||
| 3860 | 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 | 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 | 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 | 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) | ||
| 4155 | 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 | 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) | |||
| 4480 | 4480 | 220292 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6007965.909 | 2103878.5060799997 | 37.757299618008396 | -122.415454932923 | (37.7572996180084, -122.415454932923) | |||
| 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) | ||||
| 4840 | 4840 | 64237 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.778793995563895 | -122.48794601676599 | (37.7787939955639, -122.487946016766) | |
| 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) | ||
| 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) | |||||
| 5759 | 5759 | 114574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5997452.80117 | 2115716.84337 | 37.7892081146058 | -122.45266756527201 | (37.7892081146058, -122.452667565272) | |||
| 5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
| 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) | ||||
| 6078 | 6078 | 31879 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2135 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 18 | 4x4 | Permit Number 35317 | 6002171.6748 | 2119433.3444 | 37.7996819159911 | -122.43660699413 | (37.7996819159911, -122.43660699413) | |
| 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) | |||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 6449 | 6449 | 7072 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1652 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999508.2617 | 2109836.0506 | 37.7731785369509 | -122.44513298700899 | (37.7731785369509, -122.445132987009) | |||
| 6476 | 6476 | 13064 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | |||
| 6550 | 6550 | 114575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997436.353519999 | 2115714.9226900004 | 37.789201898491704 | -122.452724333156 | (37.7892018984917, -122.452724333156) | |||
| 6625 | 6625 | 9932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005031.67767 | 2117702.0644 | 37.795090373265296 | -122.42658698402501 | (37.7950903732653, -122.426586984025) | |||
| 6667 | 6667 | 17874 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2158 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003619.9977 | 2115267.4707 | 37.7883256917387 | -122.4312977384 | (37.7883256917387, -122.4312977384) | |||
| 6676 | 6676 | 102748 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | Permit Number 20974 | 6001048.4849 | 2118395.3154599997 | 37.7967678705825 | -122.440419145231 | (37.7967678705825, -122.440419145231) | ||
| 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) | ||
| 6886 | 6886 | 55233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 24 | 4x5 | Permit Number 20974 | 6001057.82109 | 2118342.00896 | 37.7966220365405 | -122.440383014983 | (37.7966220365405, -122.440383014983) | |
| 6921 | 6921 | 53479 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.45248645079201 | (37.7893505789022, -122.452486450792) | |
| 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) | |
| 7234 | 7234 | 113746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | ||||
| 7235 | 7235 | 120506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999798.014359999 | 2116362.9569200003 | 37.791116270957 | -122.444599899165 | (37.791116270957, -122.444599899165) | |||
| 7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
| 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) | |||
| 7305 | 7305 | 7157 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003511.3637 | 2110856.3338 | 37.776207657227204 | -122.431358584421 | (37.7762076572272, -122.431358584421) | |||
| 7499 | 7499 | 104699 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6011357.95285 | 2118999.80647 | 37.7990092725121 | -122.40478840238801 | (37.7990092725121, -122.404788402388) | |||
| 7508 | 7508 | 100204 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | |||
| 7705 | 7705 | 104698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011319.973040001 | 2118997.1094299997 | 37.7989997441925 | -122.40491963593901 | (37.7989997441925, -122.404919635939) | |||
| 7745 | 7745 | 13062 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.41132460578899 | (37.8031495768645, -122.411324605789) | ||
| 7853 | 7853 | 114578 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3610 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 5997431.80475 | 2115758.42968 | 37.789321096433504 | -122.45274321263099 | (37.7893210964335, -122.452743212631) | |||
| 7973 | 7973 | 107590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | |||
| 8131 | 8131 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.434780001 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | |
| 8154 | 8154 | 104700 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011383.62949 | 2119002.34589 | 37.7990176802704 | -122.40469973101801 | (37.7990176802704, -122.404699731018) | |||
| 8469 | 8469 | 46251 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.44314853640101 | (37.7950986884031, -122.443148536401) | ||
| 8478 | 8478 | 23520 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2725 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6005647.500080001 | 2119771.5564099997 | 37.800807467849395 | -122.424603426707 | (37.8008074678494, -122.424603426707) | |||
| 8491 | 8491 | 67001 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1992 12:00:00 AM | 3 | Permit Number 30356 | 6009653.005480001 | 2118469.06923 | 37.7974565552432 | -122.410650614256 | (37.7974565552432, -122.410650614256) | ||
| 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) | |||
| 8551 | 8551 | 112044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6002377.10471 | 2117102.71936 | 37.793294297651 | -122.435729294977 | (37.793294297651, -122.435729294977) | |||
| 8571 | 8571 | 102747 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | Permit Number 20974 | 6001053.30266 | 2118369.0806400003 | 37.796696110983795 | -122.44040059224 | (37.7966961109838, -122.44040059224) | ||
| 8940 | 8940 | 9931 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005032.8646599995 | 2117688.63241 | 37.7950535595338 | -122.426581919932 | (37.7950535595338, -122.426581919932) | |||
| 9241 | 9241 | 27374 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1702 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999207.4594 | 2109789.3959999997 | 37.773033261646496 | -122.44617014115101 | (37.7730332616465, -122.446170141151) | |||
| 9391 | 9391 | 24148 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | |||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) |
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");