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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6192 | 6192 | 18042 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2815 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000288.8455 | 2114746.503 | 37.7867059051394 | -122.442785522834 | (37.7867059051394, -122.442785522834) | |||
| 6251 | 6251 | 18079 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2958 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999776.6083 | 2114733.1887 | 37.786640132310296 | -122.444556777947 | (37.7866401323103, -122.444556777947) | |||
| 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) | |||
| 6397 | 6397 | 18075 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2945 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999836.3647 | 2114682.6256 | 37.786504708751 | -122.444346400919 | (37.786504708751, -122.444346400919) | |||
| 6431 | 6431 | 6926 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005147.8848 | 2110623.4947 | 37.7756609491529 | -122.425680831948 | (37.7756609491529, -122.425680831948) | |||
| 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) | |||
| 6466 | 6466 | 5201 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 730 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x6 | 6001603.6657 | 2110963.249 | 37.7763929190422 | -122.43796547839199 | (37.7763929190422, -122.437965478392) | |||
| 6519 | 6519 | 23572 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3015 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6005516.07344 | 2120742.37785 | 37.8034656713563 | -122.425127334879 | (37.8034656713563, -122.425127334879) | |||
| 6654 | 6654 | 7065 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1588 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2014 12:00:00 AM | 30 | 3X3 | 5999848.9957 | 2109884.015 | 37.7733296774154 | -122.443957794129 | (37.7733296774154, -122.443957794129) | ||
| 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) | |||
| 6669 | 6669 | 17873 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2152 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003637.0261 | 2115269.5348 | 37.7883323242451 | -122.431238970337 | (37.7883323242451, -122.431238970337) | |||
| 6683 | 6683 | 7097 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1988 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x6 | 5997952.7475 | 2109617.0075 | 37.7724881931803 | -122.450497895204 | (37.7724881931803, -122.450497895204) | |||
| 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) | ||
| 6716 | 6716 | 17870 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2140 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003687.0793 | 2115278.307 | 37.788359246862896 | -122.431066420843 | (37.7883592468629, -122.431066420843) | |||
| 6738 | 6738 | 17820 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1911 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004637.6708 | 2115354.7286 | 37.7886229005187 | -122.427782974318 | (37.7886229005187, -122.427782974318) | |||
| 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) | |
| 7022 | 7022 | 14504 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999110.8967 | 2111284.0293 | 37.7771316270833 | -122.446611718241 | (37.7771316270833, -122.446611718241) | |||
| 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) | |
| 7059 | 7059 | 18085 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2986 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999664.9755 | 2114716.7721 | 37.7865886861458 | -122.44494181853001 | (37.7865886861458, -122.44494181853) | |||
| 7077 | 7077 | 6266 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004309.6505 | 2113217.5334 | 37.7827361367074 | -122.428765457764 | (37.7827361367074, -122.428765457764) | |||
| 7116 | 7116 | 7056 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1390 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000868.0121 | 2110028.3766 | 37.77378413322079 | -122.440443239867 | (37.7737841332208, -122.440443239867) | |||
| 7128 | 7128 | 17833 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2003 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004227.6624 | 2115298.5998 | 37.788445582937 | -122.429197538284 | (37.788445582937, -122.429197538284) | |||
| 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) | |||
| 7320 | 7320 | 5190 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001706.5859 | 2110230.9953 | 37.7743881862019 | -122.43755699782899 | (37.7743881862019, -122.437556997829) | |||
| 7639 | 7639 | 18080 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2964 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999752.9685 | 2114731.2187 | 37.7866333742754 | -122.444638424012 | (37.7866333742754, -122.444638424012) | |||
| 7729 | 7729 | 5905 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1276 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6x6 | 6004411.4514 | 2112945.733 | 37.7819956014908 | -122.42839389105801 | (37.7819956014908, -122.428393891058) | |||
| 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) | ||
| 7768 | 7768 | 22759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6002316.427999999 | 2112303.8634 | 37.7801144169363 | -122.435595767889 | (37.7801144169363, -122.435595767889) | |||
| 7780 | 7780 | 18269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1933 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 12 | 3X3 | 6002915.6118 | 2114073.452 | 37.7850072757126 | -122.433649427379 | (37.7850072757126, -122.433649427379) | ||
| 7888 | 7888 | 17843 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2043 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004037.5783 | 2115265.5157 | 37.7883439798751 | -122.42985283841999 | (37.7883439798751, -122.42985283842) | |||
| 8005 | 8005 | 7086 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1842 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998607.747 | 2109706.8492 | 37.7727723426265 | -122.448238667085 | (37.7727723426265, -122.448238667085) | |||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 8063 | 8063 | 23548 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2822 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6005698.29125 | 2120114.21678 | 37.8017511939304 | -122.42445205462201 | (37.8017511939304, -122.424452054622) | |||
| 8111 | 8111 | 6041 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1830 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1990 12:00:00 AM | 3 | 3X3 | 6001487.9166 | 2112537.6047 | 37.78070911887679 | -122.438478710972 | (37.7807091188768, -122.438478710972) | ||
| 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) | |
| 8132 | 8132 | 23875 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003587.5262 | 2113806.0374 | 37.7843111243358 | -122.43130572288901 | (37.7843111243358, -122.431305722889) | |||
| 8214 | 8214 | 23518 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1989 12:00:00 AM | 20 | 3X3 | 6005659.14507 | 2119690.7477 | 37.800586245414294 | -122.424557378741 | (37.8005862454143, -122.424557378741) | ||
| 8346 | 8346 | 23481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2440 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005877.50588 | 2118803.04662 | 37.7981611731605 | -122.423738607169 | (37.7981611731605, -122.423738607169) | |||
| 8403 | 8403 | 23863 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003705.9488 | 2113626.0727 | 37.783823696929396 | -122.430883174483 | (37.7838236969294, -122.430883174483) | |||
| 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) | |||
| 8563 | 8563 | 6013 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1719 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/1993 12:00:00 AM | 12 | 3X3 | 6002233.091 | 2112591.9993 | 37.780900831757705 | -122.43590469061 | (37.7809008317577, -122.43590469061) | ||
| 8589 | 8589 | 7108 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2150 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 5997133.9635 | 2109500.6634 | 37.7721218452706 | -122.453321733951 | (37.7721218452706, -122.453321733951) | |||
| 8611 | 8611 | 5309 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001119.1558 | 2114392.6005 | 37.7857814798006 | -122.439887470169 | (37.7857814798006, -122.439887470169) | |||
| 8616 | 8616 | 23547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2806 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6005703.65589 | 2120048.52482 | 37.801571123555895 | -122.424428815235 | (37.8015711235559, -122.424428815235) | |||
| 8727 | 8727 | 7110 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1892X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998395.8128 | 2109678.4377 | 37.7726822136463 | -122.448969721072 | (37.7726822136463, -122.448969721072) | |||
| 8859 | 8859 | 5308 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1722 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001127.4861 | 2114346.0125 | 37.785654035319396 | -122.439855308268 | (37.7856540353194, -122.439855308268) | |||
| 8868 | 8868 | 7107 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2140 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 5997173.1498 | 2109507.8264 | 37.77214375901271 | -122.453186703241 | (37.7721437590127, -122.453186703241) | |||
| 8899 | 8899 | 5319 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1844 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001069.8732 | 2114771.5539 | 37.786819182767296 | -122.44008515695101 | (37.7868191827673, -122.440085156951) | |||
| 9002 | 9002 | 6927 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 488 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005098.7367 | 2110617.0491 | 37.7756404737796 | -122.425850388577 | (37.7756404737796, -122.425850388577) | |||
| 9010 | 9010 | 23574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3035 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005498.0371199995 | 2120829.33235 | 37.8037034071495 | -122.425195941456 | (37.8037034071495, -122.425195941456) | |||
| 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) | |||
| 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) | ||||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9908 | 9908 | 3768 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1098 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 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) | |
| 10113 | 10113 | 5402 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 368 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004841.2181400005 | 2106223.26914 | 37.763561657659295 | -122.426428293246 | (37.7635616576593, -122.426428293246) | |||
| 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) | |||
| 10841 | 10841 | 25393 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | |||
| 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) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 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) | |||
| 11295 | 11295 | 773 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984696.2443 | 2104420.7984 | 37.7574532129065 | -122.495969365063 | (37.7574532129065, -122.495969365063) | |||
| 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) | |||
| 11825 | 11825 | 20029 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 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) | |||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
| 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) | |||
| 13683 | 13683 | 1710 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.73374666585679 | -122.385057651709 | (37.7337466658568, -122.385057651709) | |||
| 13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
| 14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 14161 | 14161 | 24226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.38312226117901 | (37.7333610509772, -122.383122261179) | |||
| 14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
| 14364 | 14364 | 6420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | ||
| 14568 | 14568 | 8258 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1555 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2004 12:00:00 AM | 30 | 3x3 | 6015878.41647 | 2097607.57172 | 37.7405225008163 | -122.387652625679 | (37.7405225008163, -122.387652625679) | ||
| 14728 | 14728 | 6594 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6016699.98802 | 2097810.08527 | 37.741124035759796 | -122.384826027706 | (37.7411240357598, -122.384826027706) | ||
| 14857 | 14857 | 6772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.5407099999 | 37.739134988985796 | -122.38354770437401 | (37.7391349889858, -122.383547704374) | ||
| 14947 | 14947 | 24225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.401959999 | 2094982.30239 | 37.7333853506538 | -122.38301310328698 | (37.7333853506538, -122.383013103287) | ||
| 15650 | 15650 | 24228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6017105.8284599995 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | |||
| 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) | |||
| 16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
| 16537 | 16537 | 24220 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017233.65569 | 2094997.2718200001 | 37.7334301143948 | -122.38278508468001 | (37.7334301143948, -122.38278508468) | |||
| 17143 | 17143 | 10434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259863998 | (37.7700106766776, -122.44636259864) | |||
| 17243 | 17243 | 9406 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6001730.266559999 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) |
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");