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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29152 | 29152 | 247788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004361.25599 | 2098418.6984200003 | 37.742104989252894 | -122.427532277614 | (37.7421049892529, -122.427532277614) | |||
| 157576 | 157576 | 247792 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113214996 | -122.42834067009 | (37.742063113215, -122.42834067009) | |||
| 163763 | 163763 | 247789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004321.812940001 | 2098415.77613 | 37.742094734277 | -122.427668451138 | (37.742094734277, -122.427668451138) | |||
| 179978 | 179978 | 247790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004284.58274 | 2098414.05293 | 37.742087896749794 | -122.42779705870501 | (37.7420878967498, -122.427797058705) | |||
| 54078 | 54078 | 175055 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.717492326377396 | -122.47783075799299 | (37.7174923263774, -122.477830757993) | |||
| 130572 | 130572 | 175056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5989706.768680001 | 2089771.1957900003 | 37.7175213699925 | -122.47757041324199 | (37.7175213699925, -122.477570413242) | |||
| 146940 | 146940 | 175054 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5989611.995 | 2089764.5445599998 | 37.717497607213 | -122.477897512877 | (37.717497607213, -122.477897512877) | |||
| 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 | |||||||||
| 13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 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) | ||||
| 73756 | 73756 | 188569 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 26 | : Yard 23 | Tree 1 | Private 1 | 5 | 6017110.36972 | 2102585.1726599997 | 37.754258135118796 | -122.383739444343 | (37.7542581351188, -122.383739444343) | ||||
| 98922 | 98922 | 188568 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 24th St | 24 | : Yard 23 | Tree 1 | Private 1 | 38 | 6017120.705080001 | 2102612.3766799998 | 37.7543334029878 | -122.38370559563499 | (37.7543334029878, -122.383705595635) | ||||
| 46909 | 46909 | 124855 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001720.89506 | 2121441.74849 | 37.805170835422004 | -122.438310816889 | (37.805170835422, -122.438310816889) | |||
| 48401 | 48401 | 124856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001727.95085 | 2121436.12662 | 37.805155800572706 | -122.438285996516 | (37.8051558005727, -122.438285996516) | |||
| 62022 | 62022 | 124857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Casa Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001735.95246 | 2121430.00924 | 37.8051394589735 | -122.438257867517 | (37.8051394589735, -122.438257867517) | |||
| 49972 | 49972 | 220283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Clarendon Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5998403.60495 | 2104683.4410599996 | 37.7589676616433 | -122.448582957854 | (37.7589676616433, -122.448582957854) | |||
| 180588 | 180588 | 188594 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Jack Balestreri Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | ||||
| 41246 | 41246 | 187776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6017085.142530001 | 2097027.7274599997 | 37.7389971337102 | -122.383439839679 | (37.7389971337102, -122.383439839679) | |||
| 152191 | 152191 | 187774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6017047.63402 | 2096978.70465 | 37.738860453846996 | -122.383566116201 | (37.738860453847, -122.383566116201) | |||
| 163207 | 163207 | 187775 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6017053.32881 | 2096987.9359900001 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | |||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 125232 | 125232 | 85499 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 59248 | 59248 | 175001 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 6000856.019180001 | 2088342.93848 | 37.714240381459 | -122.438930350851 | (37.714240381459, -122.438930350851) | |||
| 148080 | 148080 | 175002 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000849.25835 | 2088363.04115 | 37.7142951942344 | -122.438955158647 | (37.7142951942344, -122.438955158647) | |||
| 158447 | 158447 | 175003 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6000843.24005 | 2088383.1284400001 | 37.7143500070223 | -122.43897739890801 | (37.7143500070223, -122.438977398908) | |||
| 55430 | 55430 | 203781 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 8ft | 5995760.050530001 | 2094044.5460299999 | 37.729604384015296 | -122.45695604179701 | (37.7296043840153, -122.456956041797) | |||
| 150308 | 150308 | 203780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5995711.8389800005 | 2094094.29693 | 37.72973821932529 | -122.457126310455 | (37.7297382193253, -122.457126310455) | |||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 24641 | 24641 | 203805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 5993891.16391 | 2100082.05221 | 37.7460743755414 | -122.463854985838 | (37.7460743755414, -122.463854985838) | |||
| 30886 | 30886 | 203804 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5993878.73057 | 2100098.05602 | 37.746117601451104 | -122.463899139836 | (37.7461176014511, -122.463899139836) | |||
| 39955 | 39955 | 203806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5993903.6097099995 | 2100066.65342 | 37.746032811564795 | -122.463810832713 | (37.7460328115648, -122.463810832713) | |||
| 98074 | 98074 | 49016 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46202 | 5993947.57587841 | 2100008.88350341 | 37.745876723459396 | -122.463654612612 | (37.7458767234594, -122.463654612612) | ||||
| 86484 | 86484 | 46614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.46003655522199 | (37.7476978436736, -122.460036555222) | |||
| 42389 | 42389 | 203234 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994034.24105 | 2100880.02581 | 37.7482736532082 | -122.463418145541 | (37.7482736532082, -122.463418145541) | |||
| 68101 | 68101 | 203236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 5994079.6101 | 2100830.73723 | 37.7481409330618 | -122.463257685817 | (37.7481409330618, -122.463257685817) | |||
| 150145 | 150145 | 203235 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994059.91015 | 2100852.12675 | 37.748198528336 | -122.463327358969 | (37.748198528336, -122.463327358969) | |||
| 26454 | 26454 | 188657 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6016750.167669999 | 2099204.87087 | 37.744956608177205 | -122.38474966268801 | (37.7449566081772, -122.384749662688) | ||||
| 28294 | 28294 | 188658 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | ||||
| 56563 | 56563 | 188656 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016757.253769999 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | ||||
| 145989 | 145989 | 98513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.723869304698404 | -122.459376132933 | (37.7238693046984, -122.459376132933) | ||
| 76755 | 76755 | 175031 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010533.91342 | 2086822.6121900002 | 37.7106117590847 | -122.40537260647498 | (37.7106117590847, -122.405372606475) | |||
| 46841 | 46841 | 183383 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5986644.7173 | 2097225.5877 | 37.737811028917996 | -122.488701996679 | (37.737811028918, -122.488701996679) | |||
| 20854 | 20854 | 11187 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | |||
| 33162 | 33162 | 203692 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994219.3315 | 2106013.86798 | 37.762380528552 | -122.46315056576 | (37.762380528552, -122.46315056576) | |||
| 65534 | 65534 | 203694 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Judah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5994198.666809999 | 2106012.97536 | 37.762376887211296 | -122.46322197193199 | (37.7623768872113, -122.463221971932) | |||
| 137752 | 137752 | 203691 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5994228.79771 | 2106016.63225 | 37.7623886638276 | -122.463118026482 | (37.7623886638276, -122.463118026482) | |||
| 161346 | 161346 | 203693 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994214.99035 | 2106013.29581 | 37.762378707443396 | -122.46316553855301 | (37.7623787074434, -122.463165538553) | |||
| 48939 | 48939 | 124839 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001764.30069 | 2121488.69691 | 37.8053022119874 | -122.43816397199801 | (37.8053022119874, -122.438163971998) | |||
| 149733 | 149733 | 124840 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001764.3271 | 2121501.21341 | 37.805336580468996 | -122.43816477778999 | (37.805336580469, -122.43816477779) | |||
| 155406 | 155406 | 124841 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001779.40776 | 2121521.29923 | 37.805392588455895 | -122.438114029041 | (37.8053925884559, -122.438114029041) | |||
| 12986 | 12986 | 19789 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY19 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 8435 | 8435 | 19808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 11007 | 11007 | 19809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16079 | 16079 | 19828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 11240 | 11240 | 19966 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 6746 | 6746 | 20018 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 7838 | 7838 | 20021 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 12211 | 12211 | 20025 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16846 | 16846 | 20022 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 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 | ||||||||
| 162356 | 162356 | 220290 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Jarboe Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6009373.66263 | 2096847.13455 | 37.7380720514781 | -122.41008995798401 | (37.7380720514781, -122.410089957984) | |||
| 156554 | 156554 | 174988 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Madrid St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6001118.27335 | 2088513.9598599998 | 37.7147248858297 | -122.43803614326099 | (37.7147248858297, -122.438036143261) | |||
| 178719 | 178719 | 174989 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Madrid St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 6001106.19823 | 2088490.6966400002 | 37.714660323495394 | -122.438076214354 | (37.7146603234954, -122.438076214354) | |||
| 24305 | 24305 | 187754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.37985934635799 | (37.728760777668, -122.379859346358) | ||||
| 30738 | 30738 | 187755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | ||||
| 33152 | 33152 | 187750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018189.80767 | 2093163.42935 | 37.728447520437705 | -122.379352023493 | (37.7284475204377, -122.379352023493) | ||||
| 64021 | 64021 | 187756 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6018040.44211 | 2093268.12413 | 37.728726753622496 | -122.379875664545 | (37.7287267536225, -122.379875664545) | ||||
| 168868 | 168868 | 187752 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6018083.616719999 | 2093238.62842 | 37.7286481456935 | -122.379724357202 | (37.7286481456935, -122.379724357202) | ||||
| 182989 | 182989 | 187753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018088.91826 | 2093246.2132 | 37.72866926445229 | -122.37970655600901 | (37.7286692644523, -122.379706556009) | ||||
| 187072 | 187072 | 187751 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6018129.3732900005 | 2093209.5083299999 | 37.7285707113551 | -122.379564150189 | (37.7285707113551, -122.379564150189) | ||||
| 22456 | 22456 | 6155 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005964.03505 | 2113507.44339 | 37.7836256530431 | -122.42306259308901 | (37.7836256530431, -122.423062593089) | |||
| 22598 | 22598 | 6154 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005999.1714699995 | 2113512.6178599996 | 37.7836418435489 | -122.42294140222602 | (37.7836418435489, -122.422941402226) | |||
| 22757 | 22757 | 6156 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005921.456680001 | 2113500.45313 | 37.7836040567219 | -122.423209401115 | (37.7836040567219, -122.423209401115) | |||
| 80764 | 80764 | 6160 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.42271616148199 | (37.7836802135181, -122.422716161482) | |||
| 108829 | 108829 | 6161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005784.153390001 | 2113483.6570900003 | 37.783550189367794 | -122.423683223851 | (37.7835501893678, -122.423683223851) | |||
| 141102 | 141102 | 6165 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000X Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.42271616148199 | (37.7836802135181, -122.422716161482) | |||
| 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) | |
| 56931 | 56931 | 188677 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6018476.48235 | 2096364.95743 | 37.7372540964924 | -122.37858316699499 | (37.7372540964924, -122.378583166995) | |||
| 124437 | 124437 | 7872 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006017.92474 | 2113680.1220400003 | 37.7841028269903 | -122.42288843164101 | (37.7841028269903, -122.422888431641) | |||
| 138690 | 138690 | 249574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6006046.96797 | 2113547.6658099997 | 37.78374077347271 | -122.42277853591801 | (37.7837407734727, -122.422778535918) | |||
| 29838 | 29838 | 174985 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001137.792830001 | 2088470.92046 | 37.7146078192813 | -122.43796559503299 | (37.7146078192813, -122.437965595033) | |||
| 33982 | 33982 | 174986 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001150.38066 | 2088493.1361099998 | 37.7146695343409 | -122.437923676751 | (37.7146695343409, -122.437923676751) | |||
| 167953 | 167953 | 174987 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001163.67681 | 2088517.0147099998 | 37.7147358557539 | -122.43787942919701 | (37.7147358557539, -122.437879429197) | |||
| 31496 | 31496 | 220151 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005128.65815 | 2096758.77235 | 37.7375905832326 | -122.42476077930901 | (37.7375905832326, -122.424760779309) | ||||
| 60005 | 60005 | 220150 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005133.60427 | 2096768.5161400002 | 37.7376176168434 | -122.424744371178 | (37.7376176168434, -122.424744371178) | ||||
| 161044 | 161044 | 220152 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6005125.321690001 | 2096750.37402 | 37.737567334864295 | -122.424771717755 | (37.7375673348643, -122.424771717755) | ||||
| 184741 | 184741 | 139925 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6005197.5444 | 2112663.4649 | 37.78126501367171 | -122.425654271119 | (37.7812650136717, -122.425654271119) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 8575 | 8575 | 22617 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.781458374599794 | -122.424145957729 | (37.7814583745998, -122.424145957729) | ||
| 23206 | 23206 | 22612 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X5 | 6005303.8855 | 2112676.675 | 37.781307293691704 | -122.425287323246 | (37.7813072936917, -122.425287323246) |
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");