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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | |||||||||
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 | ||||||||
6492 | 6492 | 20389 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
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 | ||||||||
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 | ||||||||
8460 | 8460 | 20385 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
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 | ||||||||
11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
11209 | 11209 | 20386 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
15553 | 15553 | 20453 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
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 | ||||||||
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 | ||||||||
18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
121000 | 121000 | 98352 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001689.0 | 2086535.0 | 37.709323539126004 | -122.435921964243 | (37.709323539126, -122.435921964243) | ||||
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) | ||||
69667 | 69667 | 175035 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 177 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010415.17043 | 2086409.0149299998 | 37.70946946450071 | -122.405753896527 | (37.7094694645007, -122.405753896527) | |||
86741 | 86741 | 87252 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.709857414252795 | -122.414638464087 | (37.7098574142528, -122.414638464087) | |||
150123 | 150123 | 175036 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 141 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010481.99907 | 2086582.34514 | 37.7099491314082 | -122.405535123871 | (37.7099491314082, -122.405535123871) | |||
60747 | 60747 | 175041 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Burr Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007781.09007 | 2086643.56012 | 37.7099658201356 | -122.41487433598199 | (37.7099658201356, -122.414874335982) | |||
93717 | 93717 | 25437 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2555 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1998 12:00:00 AM | 3 | 3x3 | 6010830.95304 | 2086585.06609 | 37.7099761086624 | -122.40432925767401 | (37.7099761086624, -122.404329257674) | ||
29876 | 29876 | 175037 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 137 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010487.1621199995 | 2086599.0486700002 | 37.7099952846374 | -122.40551845494 | (37.7099952846374, -122.40551845494) | |||
34165 | 34165 | 175038 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 137 Desmond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010492.95199 | 2086616.94014 | 37.7100447347569 | -122.405499703176 | (37.7100447347569, -122.405499703176) | |||
46969 | 46969 | 175039 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 131 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010504.44618 | 2086648.5226599998 | 37.7101320966946 | -122.40546219962299 | (37.7101320966946, -122.405462199623) | |||
56725 | 56725 | 175034 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010467.70028 | 2086649.8713200002 | 37.7101337451556 | -122.40558929631001 | (37.7101337451556, -122.40558929631) | |||
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) | |||||
64504 | 64504 | 175040 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 143 Talbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010245.72954 | 2086682.4738 | 37.7102108503322 | -122.406358770646 | (37.7102108503322, -122.406358770646) | |||
149496 | 149496 | 175033 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 120 Desmond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010491.77199 | 2086707.0107200001 | 37.710291984453704 | -122.40551012090401 | (37.7102919844537, -122.405510120904) | |||
40791 | 40791 | 175032 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 120 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010498.816000001 | 2086727.27775 | 37.710348027504104 | -122.405487201665 | (37.7103480275041, -122.405487201665) | |||
101675 | 101675 | 114218 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 119 TALBERT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010311.0 | 2086793.0 | 37.710517984021294 | -122.406140963349 | (37.7105179840213, -122.406140963349) | ||||
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) | |||
75768 | 75768 | 175018 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6012554.50627 | 2086829.44577 | 37.71074329033971 | -122.398389424743 | (37.7107432903397, -122.398389424743) | |||
27588 | 27588 | 175073 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1109 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001851.58682 | 2087075.00114 | 37.7108154987183 | -122.435398641242 | (37.7108154987183, -122.435398641242) | |||
26529 | 26529 | 175072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001924.03435 | 2087085.7759200002 | 37.710849198115 | -122.435149016425 | (37.710849198115, -122.435149016425) | |||
24483 | 24483 | 175030 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Desmond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010584.6901 | 2086918.2274599997 | 37.710877138233 | -122.405203838782 | (37.710877138233, -122.405203838782) | |||
157751 | 157751 | 175077 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 19 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6002777.56398 | 2087080.30562 | 37.7108826088193 | -122.432198632175 | (37.7108826088193, -122.432198632175) | |||
52049 | 52049 | 175029 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010591.02139 | 2086933.10615 | 37.7109183460773 | -122.405183003288 | (37.7109183460773, -122.405183003288) | |||
161752 | 161752 | 175008 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 162 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999477.70218 | 2087171.2320599998 | 37.710944622457795 | -122.443610214149 | (37.7109446224578, -122.443610214149) | |||
169015 | 169015 | 175028 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010596.823340001 | 2086951.5974299998 | 37.710969443768896 | -122.40516425152599 | (37.7109694437689, -122.405164251526) | |||
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) | ||||
124194 | 124194 | 121022 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014230.0 | 2086988.0 | 37.711271843415105 | -122.392609576957 | (37.7112718434151, -122.392609576957) | |||||
127894 | 127894 | 121023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014230.0 | 2086988.0 | 37.711271843415105 | -122.392609576957 | (37.7112718434151, -122.392609576957) | |||||
138492 | 138492 | 121024 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2016 12:00:00 AM | 3 | 6014230.0 | 2086988.0 | 37.711271843415105 | -122.392609576957 | (37.7112718434151, -122.392609576957) | |||
11153 | 11153 | 1849 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011118.84502 | 2087065.06419 | 37.7113101708062 | -122.40336798796301 | (37.7113101708062, -122.403367987963) | |||
92597 | 92597 | 103410 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
98508 | 98508 | 103408 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
141472 | 141472 | 103409 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
44180 | 44180 | 96530 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
108760 | 108760 | 96535 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
115161 | 115161 | 96534 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
116170 | 116170 | 96531 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
123285 | 123285 | 96536 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
129165 | 129165 | 96532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Raymond Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.40336870510401 | (37.7117912459807, -122.403368705104) | |||
63001 | 63001 | 175026 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6011082.6747 | 2087261.47183 | 37.71184744647479 | -122.403506811807 | (37.7118474464748, -122.403506811807) | |||
155049 | 155049 | 175004 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 183 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6000799.83685 | 2087474.06608 | 37.711851454751205 | -122.43906230479999 | (37.7118514547512, -122.4390623048) | |||
168683 | 168683 | 175025 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011065.88407 | 2087267.99252 | 37.7118644130932 | -122.403565303698 | (37.7118644130932, -122.403565303698) | |||
182256 | 182256 | 175024 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011045.77873 | 2087277.9512200002 | 37.7118906346058 | -122.40363549398701 | (37.7118906346058, -122.403635493987) | |||
67906 | 67906 | 175005 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 183 Curtis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6000792.5891 | 2087495.45523 | 37.7119097722015 | -122.43908888696801 | (37.7119097722015, -122.439088886968) | |||
72180 | 72180 | 175023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011015.66047 | 2087294.85448 | 37.711935365088294 | -122.40374078031601 | (37.7119353650883, -122.403740780316) | |||
151907 | 151907 | 111321 | Section 143 8 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6010185.8855099995 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | ||||
44142 | 44142 | 175006 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 183 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6000786.306609999 | 2087518.0824099998 | 37.7119715439251 | -122.439112221648 | (37.7119715439251, -122.439112221648) | |||
33185 | 33185 | 175022 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010987.763730001 | 2087310.0271299998 | 37.7119754676783 | -122.403838266825 | (37.7119754676783, -122.403838266825) | |||
31150 | 31150 | 175021 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010965.97825 | 2087320.5817900002 | 37.712003231546795 | -122.403914306301 | (37.7120032315468, -122.403914306301) | |||
184025 | 184025 | 175007 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 183 Curtis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6000780.85798 | 2087537.73014 | 37.712025182185 | -122.439132460907 | (37.712025182185, -122.439132460907) | |||
134445 | 134445 | 111324 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1X Peabody St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6010207.43823 | 2087366.89683 | 37.712087995349606 | -122.406539311355 | (37.7120879953496, -122.406539311355) | ||||
134333 | 134333 | 175019 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 245 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6012716.98126 | 2087331.8732 | 37.7121319065277 | -122.397863091124 | (37.7121319065277, -122.397863091124) | |||
50444 | 50444 | 175076 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1262 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6001389.55659 | 2087620.87899 | 37.7122881079857 | -122.437034577295 | (37.7122881079857, -122.437034577295) | |||
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) | |||
126877 | 126877 | 11850 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
139321 | 139321 | 11851 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
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) | |||
70365 | 70365 | 174994 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 86 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000642.034659999 | 2088027.29642 | 37.7133615216919 | -122.439647347957 | (37.7133615216919, -122.439647347957) | |||
31985 | 31985 | 174995 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 83 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000678.3268800005 | 2088039.7979400002 | 37.713397913659996 | -122.43952280533199 | (37.71339791366, -122.439522805332) | |||
151151 | 151151 | 174993 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 82 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000637.15099 | 2088042.2678099999 | 37.713402351819205 | -122.43966530023899 | (37.7134023518192, -122.439665300239) | |||
166682 | 166682 | 174992 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000562.83378 | 2088278.1703599999 | 37.714045857215204 | -122.439939070053 | (37.7140458572152, -122.439939070053) | |||
56037 | 56037 | 175000 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000913.68292 | 2088416.0407200002 | 37.7144443845714 | -122.43873627807899 | (37.7144443845714, -122.438736278079) | |||
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) | |||
72116 | 72116 | 174999 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6000885.12559 | 2088432.1484599998 | 37.7144869881473 | -122.438836136976 | (37.7144869881473, -122.438836136976) | |||
126068 | 126068 | 114606 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 36 CURTIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2088444.0 | 37.7144972695987 | -122.44018886970301 | (37.7144972695987, -122.440188869703) | ||||
96683 | 96683 | 11823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) |
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");