Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
| 4158 | 4158 | 253614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006418.0 | 2117595.0 | 37.794874677003605 | -122.421782481899 | (37.7948746770036, -122.421782481899) | ||||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3548 | 3548 | 253473 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3541 | 3541 | 253472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 2651 | 2651 | 253156 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 654 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 40826 | 6010070.0 | 2105228.0 | 37.7611230643779 | -122.40827330718099 | (37.7611230643779, -122.408273307181) | |
| 1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1663 | 1663 | 251645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1677 | 1677 | 251644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 186216 | 186216 | 250997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | |||
| 30707 | 30707 | 250995 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 44th Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.780160200984604 | -122.505239820464 | (37.7801602009846, -122.505239820464) | |||
| 69256 | 69256 | 250924 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 279 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987109.1755800005 | 2114089.0974 | 37.7841406875769 | -122.488335102104 | (37.7841406875769, -122.488335102104) | |||
| 41962 | 41962 | 250796 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986226.25026 | 2113990.91468 | 37.7838195522695 | -122.49138243596201 | (37.7838195522695, -122.491382435962) | |||
| 168487 | 168487 | 250795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986226.21568 | 2113977.7713599997 | 37.7837834624768 | -122.491381587892 | (37.7837834624768, -122.491381587892) | |||
| 40407 | 40407 | 250787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 277 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985873.31121 | 2114054.8468299997 | 37.7839744613866 | -122.49260816604601 | (37.7839744613866, -122.492608166046) | |||
| 134897 | 134897 | 250785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 270 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5985911.734180001 | 2114095.33531 | 37.784087877591794 | -122.492478221206 | (37.7840878775918, -122.492478221206) | |||
| 66286 | 66286 | 250757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 206 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985901.09635 | 2114492.32613 | 37.785177277657496 | -122.492544270121 | (37.7851772776575, -122.492544270121) | |||
| 27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | |||
| 159690 | 159690 | 249982 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 224 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) | |||
| 173495 | 173495 | 249974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Napier Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011652.50252 | 2120258.9240099997 | 37.802482962378704 | -122.403857805517 | (37.8024829623787, -122.403857805517) | |||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 182162 | 182162 | 249963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | |||
| 76837 | 76837 | 249945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 325 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.40508728037399 | (37.8018246784261, -122.405087280374) | |||
| 184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
| 116481 | 116481 | 249933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | |||
| 58002 | 58002 | 249931 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.801791658008106 | -122.405355554416 | (37.8017916580081, -122.405355554416) | |||
| 51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 71454 | 71454 | 249847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 289 Greenwich St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831002 | (37.8028363185975, -122.40464825831) | |||
| 63079 | 63079 | 249835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | |||
| 35676 | 35676 | 249834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011234.1519 | 2120371.9476900003 | 37.8027699171526 | -122.40531347785401 | (37.8027699171526, -122.405313477854) | |||
| 39263 | 39263 | 249833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.40531050560101 | (37.8027546547576, -122.405310505601) | |||
| 30309 | 30309 | 249829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.802754654775704 | -122.405424923615 | (37.8027546547757, -122.405424923615) | |||
| 52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
| 169417 | 169417 | 249809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010708.4562800005 | 2121025.2354099997 | 37.804534279087704 | -122.407178739215 | (37.8045342790877, -122.407178739215) | |||
| 156801 | 156801 | 249808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.80451131849129 | -122.40715815553101 | (37.8045113184913, -122.407158155531) | |||
| 53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
| 184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
| 33070 | 33070 | 249679 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999741.43988 | 2117216.47572 | 37.793456580320395 | -122.44485702433998 | (37.7934565803204, -122.44485702434) | ||||
| 187086 | 187086 | 249631 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997554.63334 | 2111312.07091 | 37.777119603925904 | -122.451997320318 | (37.7771196039259, -122.451997320318) | |||
| 176069 | 176069 | 249630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997562.87533 | 2111313.0970900003 | 37.7771228936381 | -122.45196888287701 | (37.7771228936381, -122.451968882877) | |||
| 183103 | 183103 | 249629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997572.14406 | 2111315.29965 | 37.7771294721856 | -122.45193697852501 | (37.7771294721856, -122.451936978525) | |||
| 178716 | 178716 | 249411 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Olive St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6007136.98967 | 2113833.35507 | 37.7845866470086 | -122.41902773346202 | (37.7845866470086, -122.419027733462) | |||
| 183270 | 183270 | 248616 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 448 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997602.0932 | 2107487.0642 | 37.7666198391012 | -122.45155717513501 | (37.7666198391012, -122.451557175135) | |||
| 185190 | 185190 | 248612 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997643.278 | 2107552.7781 | 37.7668026311269 | -122.45141946492201 | (37.7668026311269, -122.451419464922) | |||
| 23619 | 23619 | 248592 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 825 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997630.862000001 | 2107647.8664 | 37.7670630083716 | -122.45146926878701 | (37.7670630083716, -122.451469268787) | |||
| 54247 | 54247 | 248582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 382 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998128.2588 | 2107558.6832 | 37.7668466041125 | -122.44974242989201 | (37.7668466041125, -122.449742429892) | |||
| 173548 | 173548 | 248552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 798 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999120.7811 | 2107716.3058 | 37.7673361311337 | -122.44632081075599 | (37.7673361311337, -122.446320810756) | |||
| 64955 | 64955 | 248519 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 216 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998904.7125 | 2107666.4904 | 37.7671870080394 | -122.447064573316 | (37.7671870080394, -122.447064573316) | |||
| 186881 | 186881 | 248500 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998823.4029 | 2107855.6071 | 37.767701628786995 | -122.44735942334499 | (37.767701628787, -122.447359423345) | |||
| 129738 | 129738 | 248486 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 72 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998851.7174 | 2107848.7935 | 37.767684538298 | -122.447260996941 | (37.767684538298, -122.447260996941) | |||
| 148708 | 148708 | 248485 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 771 Ashbury St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999070.9657 | 2107769.7551 | 37.767480044221294 | -122.44649696031799 | (37.7674800442213, -122.446496960318) | |||
| 150965 | 150965 | 248463 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997448.7103 | 2107810.4856 | 37.7674990867904 | -122.452111034778 | (37.7674990867904, -122.452111034778) | |||
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 154130 | 154130 | 248393 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 9 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998787.6691 | 2108112.7090000003 | 37.768405523514296 | -122.447501530188 | (37.7684055235143, -122.447501530188) | |||
| 74444 | 74444 | 248368 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999058.3983 | 2108160.556 | 37.7685523669565 | -122.446568548976 | (37.7685523669565, -122.446568548976) | |||
| 64092 | 64092 | 248265 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 152 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6006675.61536 | 2098670.66738 | 37.742927471437504 | -122.41954780781201 | (37.7429274714375, -122.419547807812) | |||
| 32768 | 32768 | 248178 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 218 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6007415.21428 | 2098671.9184 | 37.7429725382626 | -122.416990561277 | (37.7429725382626, -122.416990561277) | ||||
| 130050 | 130050 | 248147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010067.447980001 | 2099317.93989 | 37.744895209655795 | -122.407865368018 | (37.7448952096558, -122.407865368018) | |||
| 32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
| 68171 | 68171 | 248071 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 378 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010484.06828 | 2098878.7944400003 | 37.743712727062395 | -122.40639382801399 | (37.7437127270624, -122.406393828014) | |||
| 156969 | 156969 | 248056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010671.1144 | 2099351.76088 | 37.7450218521921 | -122.405780372559 | (37.7450218521921, -122.405780372559) | ||||
| 180928 | 180928 | 248055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010658.86611 | 2099354.83953 | 37.745029620524605 | -122.405822941986 | (37.7450296205246, -122.405822941986) | ||||
| 23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
| 30408 | 30408 | 248049 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010499.7614 | 2099438.0486 | 37.7452491953942 | -122.40637896223 | (37.7452491953942, -122.40637896223) | ||||
| 64801 | 64801 | 248042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 43 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010523.22894 | 2099409.2799 | 37.745171515566796 | -122.40629578842301 | (37.7451715155668, -122.406295788423) | ||||
| 32465 | 32465 | 248037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010488.35763 | 2099431.59018 | 37.745230824035204 | -122.40641793974599 | (37.7452308240352, -122.406417939746) | ||||
| 74729 | 74729 | 247959 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010396.832769999 | 2098907.5359799997 | 37.743786764640795 | -122.40669749401 | (37.7437867646408, -122.40669749401) | ||||
| 168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
| 123929 | 123929 | 247956 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 6 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010454.452819999 | 2098883.02488 | 37.7437226861619 | -122.40649652970501 | (37.7437226861619, -122.406496529705) | ||||
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 164280 | 164280 | 247909 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 582 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009857.303669999 | 2098747.94229 | 37.743318353655 | -122.408551810625 | (37.743318353655, -122.408551810625) | ||||
| 156569 | 156569 | 247882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 387 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009927.8842 | 2098400.72535 | 37.7423689240761 | -122.40828327575701 | (37.7423689240761, -122.408283275757) | ||||
| 164589 | 164589 | 247503 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 330 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002742.369 | 2109736.1981 | 37.7730884309626 | -122.433938658377 | (37.7730884309626, -122.433938658377) | |||
| 159815 | 159815 | 247496 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003128.6225 | 2110147.2235 | 37.77423891724071 | -122.432631925087 | (37.7742389172407, -122.432631925087) | |||
| 174709 | 174709 | 247456 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 356 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002732.951 | 2109802.6473 | 37.773270349556896 | -122.43397598715 | (37.7732703495569, -122.43397598715) | |||
| 46528 | 46528 | 247319 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 212 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002805.2257 | 2109276.6136 | 37.77183009226471 | -122.43368837642299 | (37.7718300922647, -122.433688376423) | |||
| 35997 | 35997 | 247303 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 871 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002435.7685 | 2109501.3624 | 37.772426226241606 | -122.434982428911 | (37.7724262262416, -122.434982428911) | |||
| 160110 | 160110 | 247064 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6002451.51604 | 2098273.39283 | 37.7415978111813 | -122.434125164359 | (37.7415978111813, -122.434125164359) | |||
| 154255 | 154255 | 247009 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Valley St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100676996 | -122.431331435716 | (37.744170100677, -122.431331435716) | |||
| 46005 | 46005 | 246996 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 41 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004880.21483 | 2101034.21529 | 37.7493159377957 | -122.425924019088 | (37.7493159377957, -122.425924019088) | |||
| 168274 | 168274 | 246994 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Clipper St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004800.19369 | 2101026.04405 | 37.7492889788029 | -122.426200152341 | (37.7492889788029, -122.426200152341) | |||
| 30439 | 30439 | 246993 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004785.89781 | 2101026.3383400002 | 37.7492889788082 | -122.426249608749 | (37.7492889788082, -122.426249608749) | |||
| 50431 | 50431 | 246992 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004752.26844 | 2101024.33311 | 37.749281571994 | -122.426365757074 | (37.749281571994, -122.426365757074) | |||
| 172356 | 172356 | 246991 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 79 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6004668.56115 | 2101021.3093 | 37.7492685372183 | -122.426655003321 | (37.7492685372183, -122.426655003321) | |||
| 175965 | 175965 | 246989 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 74 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004681.91881 | 2101068.44983 | 37.749398729370206 | -122.426612168643 | (37.7493987293702, -122.426612168643) | |||
| 158089 | 158089 | 246988 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Clipper St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004704.08454 | 2101068.9613099997 | 37.7494013868777 | -122.426535555381 | (37.7494013868777, -122.426535555381) | |||
| 186480 | 186480 | 246987 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.749401917482295 | -122.426458941248 | (37.7494019174823, -122.426458941248) | |||
| 1681 | 1681 | 246983 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 779954 | 6004884.234759999 | 2101078.02552 | 37.7494364577399 | -122.42591323621201 | (37.7494364577399, -122.425913236212) | ||
| 184567 | 184567 | 246981 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 34 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004919.80069 | 2101078.0678 | 37.7494385837369 | -122.42579025121799 | (37.7494385837369, -122.425790251218) | |||
| 69227 | 69227 | 246948 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999042.02587 | 2107640.28149 | 37.767122889331 | -122.446587742626 | (37.767122889331, -122.446587742626) | |||
| 39987 | 39987 | 246947 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999023.6641 | 2107638.02914 | 37.7671156560985 | -122.44665109090201 | (37.7671156560985, -122.446651090902) | |||
| 159282 | 159282 | 246946 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999004.098730001 | 2107636.61215 | 37.7671106477653 | -122.446718662333 | (37.7671106477653, -122.446718662333) | |||
| 169180 | 169180 | 246945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998978.56709 | 2107632.07739 | 37.767096737951604 | -122.446806645734 | (37.7670967379516, -122.446806645734) | |||
| 37687 | 37687 | 246944 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 231 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998938.52144 | 2107624.39933 | 37.76707336817729 | -122.446944604433 | (37.7670733681773, -122.446944604433) | |||
| 180618 | 180618 | 246943 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 241 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5998908.7474 | 2107621.37145 | 37.7670633533234 | -122.44704736995199 | (37.7670633533234, -122.447047369952) | |||
| 131862 | 131862 | 246936 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 301 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5998506.42404 | 2107565.9164400003 | 37.7668880934274 | -122.448434944726 | (37.7668880934274, -122.448434944726) |
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");