Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, 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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
39003 | 39003 | 174984 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1005 Madrid St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6001116.49451 | 2088434.7952400001 | 37.7145074162652 | -122.438036624391 | (37.7145074162652, -122.438036624391) | |||
167983 | 167983 | 174983 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1005 Madrid St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6001103.82585 | 2088413.5291400002 | 37.7144483038197 | -122.438078889846 | (37.7144483038197, -122.438078889846) | |||
57310 | 57310 | 125264 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1009 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008170.85008 | 2118913.6211 | 37.79859397459521 | -122.415810770352 | (37.7985939745952, -122.415810770352) | |||
38066 | 38066 | 111168 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6003190.196690001 | 2119810.74673 | 37.8007759915841 | -122.43310951858999 | (37.8007759915841, -122.43310951859) | |||
71650 | 71650 | 111167 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003205.803309999 | 2119813.99508 | 37.80078579597271 | -122.433055745441 | (37.8007857959727, -122.433055745441) | |||
156773 | 156773 | 111166 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6003221.39002 | 2119816.29205 | 37.800792986965796 | -122.43300197316499 | (37.8007929869658, -122.433001973165) | |||
116268 | 116268 | 42069 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
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) | |||
13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
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) | |||
164024 | 164024 | 120378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5987994.967999999 | 2115215.60018 | 37.7872853847458 | -122.485353306378 | (37.7872853847458, -122.485353306378) | |||
57184 | 57184 | 120073 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987689.48695 | 2115234.87158 | 37.787320497195 | -122.48641160802299 | (37.787320497195, -122.486411608023) | |||
154594 | 154594 | 120071 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987688.6545 | 2115263.0140400003 | 37.787397719801604 | -122.486416555063 | (37.7873977198016, -122.486416555063) | |||
186296 | 186296 | 120072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987688.32967 | 2115247.71242 | 37.7873556870051 | -122.486416555037 | (37.7873556870051, -122.486416555037) | |||
42043 | 42043 | 188631 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6010953.30174 | 2096155.7818599998 | 37.7362621559727 | -122.404579676927 | (37.7362621559727, -122.404579676927) | ||||
75315 | 75315 | 188632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Charter Oak Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010956.26861 | 2096182.79853 | 37.7363365038229 | -122.404571320413 | (37.7363365038229, -122.404571320413) | ||||
90217 | 90217 | 115147 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
96999 | 96999 | 115142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
104010 | 104010 | 115146 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
108315 | 108315 | 115143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
118266 | 118266 | 115144 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
128837 | 128837 | 115141 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
138505 | 138505 | 115140 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
139204 | 139204 | 115145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
169297 | 169297 | 175017 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Nueva Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | Width 4ft | 6013060.88681 | 2087564.6207700002 | 37.712790132022704 | -122.39669075108101 | (37.7127901320227, -122.396690751081) | |||
58205 | 58205 | 188572 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.6155199995 | 2106524.04213 | 37.764918870439 | -122.39365939726801 | (37.764918870439, -122.393659397268) | ||||
157254 | 157254 | 188571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014323.12928 | 2106506.5800900003 | 37.764871007621004 | -122.39365293923599 | (37.764871007621, -122.393652939236) | ||||
174896 | 174896 | 188573 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014313.95748 | 2106525.31857 | 37.764921949722705 | -122.393685974041 | (37.7649219497227, -122.393685974041) | ||||
175480 | 175480 | 188574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.12378 | 2106534.34369 | 37.7649471289393 | -122.39366181916 | (37.7649471289393, -122.39366181916) | ||||
116158 | 116158 | 89312 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) |
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");