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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 35933 | 35933 | 188732 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6014643.15959 | 2086929.06971 | 37.7111329692742 | -122.391177465365 | (37.7111329692742, -122.391177465365) | |||
| 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) | ||||
| 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) | |||
| 42001 | 42001 | 188730 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6014544.34623 | 2086934.52337 | 37.7111424598152 | -122.39151937233 | (37.7111424598152, -122.39151937233) | |||
| 68720 | 68720 | 188729 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 6014522.262519999 | 2086936.6978200001 | 37.7111472046498 | -122.391595851594 | (37.7111472046498, -122.391595851594) | |||
| 68152 | 68152 | 188728 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6014503.20591 | 2086938.3794099998 | 37.7111507641693 | -122.39166183394501 | (37.7111507641693, -122.391661833945) | |||
| 165358 | 165358 | 188727 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6014344.673219999 | 2086951.52191 | 37.7111780496084 | -122.39221068478999 | (37.7111780496084, -122.39221068479) | |||
| 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) | |||
| 34628 | 34628 | 188726 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 6014282.88696 | 2086958.43171 | 37.7111935916762 | -122.39242471805001 | (37.7111935916762, -122.39242471805) | |||
| 40250 | 40250 | 188750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6014131.496280001 | 2086972.33958 | 37.7112233718385 | -122.39294893824801 | (37.7112233718385, -122.392948938248) | |||
| 156272 | 156272 | 188733 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Executive Park Blvd | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 8ft | 6014289.08954 | 2086985.67825 | 37.7112687498269 | -122.392405184751 | (37.7112687498269, -122.392405184751) | |||
| 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) | |||
| 38609 | 38609 | 188748 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 6013906.67984 | 2086991.4991 | 37.7112634896854 | -122.39372730596399 | (37.7112634896854, -122.393727305964) | |||
| 45422 | 45422 | 187710 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 8ft | 6013683.2298 | 2086994.4586200002 | 37.7112591963142 | -122.39449981823 | (37.7112591963142, -122.39449981823) | |||
| 153046 | 153046 | 187709 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6013649.01686 | 2087002.29435 | 37.7112788096526 | -122.39461861596399 | (37.7112788096526, -122.394618615964) | |||
| 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) | ||||
| 61209 | 61209 | 187708 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 6013663.58022 | 2087013.01188 | 37.7113090475516 | -122.394569030961 | (37.7113090475516, -122.394569030961) | |||
| 151217 | 151217 | 187707 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 6013680.06159 | 2087022.4997 | 37.7113360155142 | -122.394512730686 | (37.7113360155142, -122.394512730686) | |||
| 27387 | 27387 | 187706 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6013695.628330001 | 2087031.1132200002 | 37.7113605319472 | -122.394459530409 | (37.7113605319472, -122.394459530409) | |||
| 131541 | 131541 | 188752 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 6014065.713880001 | 2087031.5756700002 | 37.7113823683797 | -122.393180442647 | (37.7113823683797, -122.393180442647) | |||
| 186948 | 186948 | 188753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6014041.0419 | 2087033.9211099998 | 37.7113874378463 | -122.393265880017 | (37.7113874378463, -122.393265880017) | |||
| 166674 | 166674 | 188754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6014012.046130001 | 2087036.3540700001 | 37.7113925073379 | -122.393366267763 | (37.7113925073379, -122.393366267763) | |||
| 76746 | 76746 | 188755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6013963.90027 | 2087039.17424 | 37.71139757590579 | -122.393532870747 | (37.7113975759058, -122.393532870747) | |||
| 41902 | 41902 | 187705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6013715.36859 | 2087039.19615 | 37.711383823464104 | -122.394391868106 | (37.7113838234641, -122.394391868106) | |||
| 30514 | 30514 | 188756 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6013935.51575 | 2087041.28736 | 37.711401800917 | -122.393631123501 | (37.711401800917, -122.393631123501) | |||
| 71147 | 71147 | 188757 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6013913.012159999 | 2087043.8965900003 | 37.711407714869 | -122.393709084803 | (37.711407714869, -122.393709084803) | |||
| 26244 | 26244 | 187704 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6013733.429690001 | 2087045.5271 | 37.7114022110065 | -122.394329886826 | (37.7114022110065, -122.394329886826) | |||
| 181227 | 181227 | 188758 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6013886.48106 | 2087045.97193 | 37.711411938995205 | -122.39380092898999 | (37.7114119389952, -122.39380092899) | |||
| 46481 | 46481 | 188759 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6013862.38947 | 2087046.45952 | 37.711411938972894 | -122.393884230478 | (37.7114119389729, -122.393884230478) | |||
| 160893 | 160893 | 187703 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6013752.04605 | 2087049.7634299998 | 37.71141487796321 | -122.39426583982099 | (37.7114148779632, -122.394265839821) | |||
| 132228 | 132228 | 187702 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 51 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6013770.9191 | 2087051.9111799998 | 37.7114218243198 | -122.39420075947099 | (37.7114218243198, -122.394200759471) | |||
| 181734 | 181734 | 175012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6013182.79855 | 2087056.1572599998 | 37.71140077569589 | -122.396233767795 | (37.7114007756959, -122.396233767795) | |||
| 37054 | 37054 | 175013 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | |||
| 33886 | 33886 | 175014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 8ft | 6013188.07866 | 2087071.7521799998 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | |||
| 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) | |||
| 47330 | 47330 | 175015 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6013189.92411 | 2087076.3672900002 | 37.7114566649583 | -122.39621055536999 | (37.7114566649583, -122.39621055537) | |||
| 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) | |||
| 174696 | 174696 | 175016 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.711469438930294 | -122.396206518314 | (37.7114694389303, -122.396206518314) | |||
| 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) | |||
| 133501 | 133501 | 175075 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1082 Munich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 6001955.35702 | 2087155.69226 | 37.7110429516559 | -122.435045755382 | (37.7110429516559, -122.435045755382) | |||
| 155490 | 155490 | 175074 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1082 Munich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 6001979.9665 | 2087165.3446 | 37.711070852213396 | -122.43496138907801 | (37.7110708522134, -122.434961389078) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");