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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 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 | ||||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
| 10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
| 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) | |||
| 57966 | 57966 | 188747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6014639.494109999 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | |||
| 71605 | 71605 | 188746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | |||
| 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) | |||
| 133838 | 133838 | 188745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014589.916680001 | 2086958.4326 | 37.711210639227 | -122.39136353872101 | (37.711210639227, -122.391363538721) | |||
| 37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
| 32164 | 32164 | 188743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | |||
| 63133 | 63133 | 188742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6014513.510980001 | 2086966.09658 | 37.7112274421761 | -122.391628153428 | (37.7112274421761, -122.391628153428) | |||
| 168939 | 168939 | 188741 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.39171045846399 | (37.7112309432358, -122.391710458464) | |||
| 178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
| 186731 | 186731 | 188739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014439.36233 | 2086971.4204900002 | 37.7112379444543 | -122.39188480373801 | (37.7112379444543, -122.391884803738) | |||
| 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) | |||
| 149419 | 149419 | 188738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014415.87146 | 2086974.70005 | 37.7112456453465 | -122.39196622388799 | (37.7112456453465, -122.391966223888) | |||
| 71411 | 71411 | 188737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014387.73209 | 2086976.03412 | 37.7112477461551 | -122.39206357459899 | (37.7112477461551, -122.392063574599) | |||
| 65570 | 65570 | 188736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | |||
| 75165 | 75165 | 188735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014342.21925 | 2086979.24909 | 37.711254046810495 | -122.39222110431601 | (37.7112540468105, -122.392221104316) | |||
| 174612 | 174612 | 188734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014314.36158 | 2086981.8522700001 | 37.71125964778079 | -122.39231757011801 | (37.7112596477808, -122.392317570118) | |||
| 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) | |||
| 56907 | 56907 | 187701 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | |||
| 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) | |||
| 153767 | 153767 | 187700 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014134.283869999 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | |||
| 30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | |||
| 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) | |||
| 170303 | 170303 | 188764 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014090.1968 | 2087004.6185400002 | 37.711309709434 | -122.393093937756 | (37.711309709434, -122.393093937756) | |||
| 137789 | 137789 | 188763 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014060.27429 | 2087007.0702 | 37.711314778934295 | -122.39319752976601 | (37.7113147789343, -122.393197529766) | |||
| 173558 | 173558 | 188762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6014035.24999 | 2087007.2689599998 | 37.71131393444921 | -122.39328403465299 | (37.7113139344492, -122.393284034653) | |||
| 147853 | 147853 | 188761 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 8ft | 6013991.40971 | 2087009.0790099998 | 37.7113164687655 | -122.39343568552 | (37.7113164687655, -122.39343568552) | |||
| 157079 | 157079 | 187711 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013709.84578 | 2087009.9917799998 | 37.711303326954706 | -122.394408912955 | (37.7113033269547, -122.394408912955) | |||
| 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) |
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");