Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6541 | 6541 | 33662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 453 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2016 12:00:00 AM | 3 | Permit Number 37750 | 6005235.3039 | 2110769.7304 | 37.7760674161616 | -122.425388836438 | (37.7760674161616, -122.425388836438) | ||
| 20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
| 23064 | 23064 | 13226 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2265 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 6001595.9478 | 2119347.0943 | 37.7994123621689 | -122.438593032687 | (37.7994123621689, -122.438593032687) | ||||
| 23068 | 23068 | 15298 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 6006986.0945 | 2109290.5977 | 37.772104832379604 | -122.419227425547 | (37.7721048323796, -122.419227425547) | ||||
| 23207 | 23207 | 7224 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 6003339.1357 | 2111756.6534 | 37.778669949054 | -122.432018673024 | (37.778669949054, -122.432018673024) | ||||
| 23286 | 23286 | 4726 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6008251.3021 | 2120879.6119999997 | 37.803996615927794 | -122.41567165532301 | (37.8039966159278, -122.415671655323) | ||||
| 23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
| 24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
| 25086 | 25086 | 59963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 15 | Permit Number 19442 | 6005413.5665 | 2111133.9591 | 37.777077569392 | -122.424798095948 | (37.777077569392, -122.424798095948) | |
| 25536 | 25536 | 59622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | |
| 25581 | 25581 | 64501 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | |
| 26086 | 26086 | 59151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | ||
| 26569 | 26569 | 32778 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.775491837653796 | -122.43967909765101 | (37.7754918376538, -122.439679097651) | |
| 26993 | 26993 | 101263 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 20727 | 5989478.8752 | 2106534.6445 | 37.76353621964879 | -122.479583963683 | (37.7635362196488, -122.479583963683) | |||
| 27948 | 27948 | 58051 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.791740674082796 | -122.421003598405 | (37.7917406740828, -122.421003598405) | ||
| 29034 | 29034 | 64425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | ||
| 29179 | 29179 | 63908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | ||
| 29471 | 29471 | 56977 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441002 | (37.8046566775876, -122.40963527441) | ||
| 30976 | 30976 | 31653 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.787060100362794 | -122.428333544653 | (37.7870601003628, -122.428333544653) | ||
| 31733 | 31733 | 33694 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.777091471020704 | -122.424910846803 | (37.7770914710207, -122.424910846803) | ||
| 34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
| 35309 | 35309 | 64038 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | ||
| 35357 | 35357 | 59593 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.785250588527205 | -122.44319409038201 | (37.7852505885272, -122.443194090382) | ||
| 35499 | 35499 | 66182 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.42868702120701 | (37.7879922787707, -122.428687021207) | ||
| 36366 | 36366 | 33642 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005736999 | (37.776111096903, -122.42556005737) | |
| 36487 | 36487 | 49516 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1910@ BUSH ST Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.43511829939699 | (37.7872040200664, -122.435118299397) | |||
| 37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
| 39524 | 39524 | 47470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | ||
| 41330 | 41330 | 57327 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.785592057564294 | -122.44539352748501 | (37.7855920575643, -122.445393527485) | ||
| 41574 | 41574 | 57511 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | ||
| 41838 | 41838 | 108009 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.42529935055799 | (37.7770313396992, -122.425299350558) | ||||
| 42034 | 42034 | 55481 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | ||
| 44704 | 44704 | 110911 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6013393.5354 | 2113814.1809 | 37.784884328260105 | -122.397380700853 | (37.7848843282601, -122.397380700853) | ||||
| 45497 | 45497 | 72023 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1989 12:00:00 AM | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.40754355100599 | (37.7919886256319, -122.407543551006) | ||
| 46391 | 46391 | 35162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 9 | Permit Number 38693 | 6002611.6162 | 2110373.5603 | 37.7748310484791 | -122.434436527113 | (37.7748310484791, -122.434436527113) | |
| 47374 | 47374 | 70252 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1993 12:00:00 AM | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.43945159440399 | (37.7750685309709, -122.439451594404) | ||
| 49361 | 49361 | 38058 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | |
| 49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) | ||
| 50229 | 50229 | 110907 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | ||||
| 51113 | 51113 | 53752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.805163775279205 | -122.40921280301701 | (37.8051637752792, -122.409212803017) | ||
| 53528 | 53528 | 65955 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | ||
| 53659 | 53659 | 59958 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 515 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 17 | Permit Number 19435 | 6005418.82 | 2111104.349 | 37.7769965639956 | -122.42477781542601 | (37.7769965639956, -122.424777815426) | |
| 54193 | 54193 | 59956 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | ||
| 54324 | 54324 | 58879 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.785611411881106 | -122.44517715647801 | (37.7856114118811, -122.445177156478) | ||
| 54431 | 54431 | 58709 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1952 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1979 12:00:00 AM | 14 | Permit Number 17941 | 6003655.3938 | 2118679.8466 | 37.797697209655496 | -122.431418967171 | (37.7976972096555, -122.431418967171) | ||
| 56825 | 56825 | 108010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6005279.8436 | 2111122.0196 | 37.777037232737705 | -122.42525983588001 | (37.7770372327377, -122.42525983588) | ||||
| 57074 | 57074 | 66506 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2458 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 15 | Permit Number 29669 | 6001738.4652 | 2114659.4492 | 37.7865494118178 | -122.43776395706001 | (37.7865494118178, -122.43776395706) | |
| 59550 | 59550 | 110908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013338.0101 | 2113761.7403 | 37.784737246892796 | -122.39756912252199 | (37.7847372468928, -122.397569122522) | ||||
| 60145 | 60145 | 61078 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.44437783777398 | (37.7837992291467, -122.444377837774) | ||
| 60560 | 60560 | 60603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631004 | -122.431018929857 | (37.775379238631, -122.431018929857) | |
| 61042 | 61042 | 38609 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | |
| 62836 | 62836 | 71305 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.43946897716299 | (37.7744467352044, -122.439468977163) | ||
| 63452 | 63452 | 54834 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | ||
| 64396 | 64396 | 98493 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | ||||
| 64732 | 64732 | 56926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.774200340216396 | -122.439438484322 | (37.7742003402164, -122.439438484322) | ||
| 66083 | 66083 | 59960 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 492 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 21 | Permit Number 19438 | 6005457.1486 | 2111358.1318 | 37.777695554426295 | -122.424663282479 | (37.7776955544263, -122.424663282479) | |
| 66240 | 66240 | 59663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 943 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19085 | 6002930.6636 | 2111548.8443 | 37.778076191259 | -122.433416880741 | (37.778076191259, -122.433416880741) | ||
| 66427 | 66427 | 49435 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1919 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2003 12:00:00 AM | 8 | Permit Number 46373 | 6001939.0069 | 2115153.2685 | 37.7879167140987 | -122.437105502206 | (37.7879167140987, -122.437105502206) | ||
| 67147 | 67147 | 92952 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1334 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6006791.0528 | 2115558.9055 | 37.789305097845 | -122.42034707761499 | (37.789305097845, -122.420347077615) | ||||
| 67726 | 67726 | 57633 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 486 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1976 12:00:00 AM | 19 | Permit Number 16531 | 6005481.2851 | 2111360.2306 | 37.7777026803458 | -122.42457993532899 | (37.7777026803458, -122.424579935329) | ||
| 68178 | 68178 | 32290 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | ||
| 69466 | 69466 | 66825 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.77334802445179 | -122.450216391954 | (37.7733480244518, -122.450216391954) | |
| 72576 | 72576 | 56573 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | ||||
| 75416 | 75416 | 33693 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.42485326118401 | (37.7771015944949, -122.424853261184) | ||
| 75417 | 75417 | 57820 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2357 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1977 12:00:00 AM | 11 | Permit Number 16759 | 6002204.3143 | 2114668.0157 | 37.7865994109848 | -122.43615284952499 | (37.7865994109848, -122.436152849525) | ||
| 75917 | 75917 | 68430 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | ||
| 76775 | 76775 | 57510 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | ||
| 86975 | 86975 | 53539 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 322 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1969 12:00:00 AM | Permit Number 776401 | 5995280.52661988 | 2113383.63166464 | 37.78267703677329 | -122.460014224406 | (37.7826770367733, -122.460014224406) | |||
| 130494 | 130494 | 59752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.78409195734471 | -122.44085723976299 | (37.7840919573447, -122.440857239763) | ||
| 131001 | 131001 | 66378 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | 8 | Permit Number 29503 | 6003604.7588 | 2110527.1817 | 37.7753091794017 | -122.43101200799299 | (37.7753091794017, -122.431012007993) | |
| 131817 | 131817 | 45603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.779665941263104 | -122.43171536011101 | (37.7796659412631, -122.431715360111) | ||
| 132110 | 132110 | 119622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6000135.3841 | 2112812.4267 | 37.781386681539395 | -122.44317750199 | (37.7813866815394, -122.44317750199) | ||||
| 132537 | 132537 | 55484 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.43641927844601 | (37.7762536529278, -122.436419278446) | ||
| 133205 | 133205 | 62731 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | ||
| 133674 | 133674 | 56572 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.40919745742201 | (37.805281025756, -122.409197457422) | ||||
| 134254 | 134254 | 59957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 539 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 12 | Permit Number 19434 | 6005396.005 | 2111241.6 | 37.7773721331465 | -122.424866506623 | (37.7773721331465, -122.424866506623) | |
| 134348 | 134348 | 97114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.47821424615101 | (37.7540855022306, -122.478214246151) | |||
| 134965 | 134965 | 63910 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1991 12:00:00 AM | 14 | Permit Number 30246 | 6009385.3216 | 2121038.8544 | 37.804497537044895 | -122.411758548847 | (37.8044975370449, -122.411758548847) | ||
| 136991 | 136991 | 66504 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2456 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 5 | Permit Number 29667 | 6001757.7853 | 2114663.6996 | 37.786562180873 | -122.437697418913 | (37.786562180873, -122.437697418913) | |
| 137082 | 137082 | 62689 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276000001 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | ||
| 137939 | 137939 | 59659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.777885394660395 | -122.43321979797301 | (37.7778853946604, -122.433219797973) | ||
| 147652 | 147652 | 64012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923078999 | (37.7757444404433, -122.44883923079) | ||
| 149706 | 149706 | 92953 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1338 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6006789.4485 | 2115574.9476 | 37.7893490550841 | -122.420353767408 | (37.7893490550841, -122.420353767408) | ||||
| 151231 | 151231 | 54831 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.781366286141896 | -122.443343289517 | (37.7813662861419, -122.443343289517) | ||
| 152051 | 152051 | 55477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11429 | 6002598.3437 | 2110470.6592 | 37.7750969045142 | -122.43448938343799 | (37.7750969045142, -122.434489383438) | ||
| 152460 | 152460 | 62957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | ||
| 153102 | 153102 | 55473 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.43741173817101 | (37.7760618062261, -122.437411738171) | ||
| 153964 | 153964 | 59661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356000001 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | ||
| 155737 | 155737 | 64843 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 618 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 11 | Permit Number 29500 | 6003607.7064 | 2110511.4611 | 37.7752661815317 | -122.431000689329 | (37.7752661815317, -122.431000689329) | |
| 156324 | 156324 | 77283 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1210 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | ||
| 156483 | 156483 | 32296 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | ||
| 156651 | 156651 | 105961 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6005800.4768 | 2111198.1428 | 37.777275647690296 | -122.42346421459601 | (37.7772756476903, -122.423464214596) | ||||
| 157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
| 158599 | 158599 | 112132 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 6003600.3374 | 2110567.9569 | 37.775420887509796 | -122.431030213476 | (37.7754208875098, -122.431030213476) | |||
| 160231 | 160231 | 59592 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1610 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 13 | Permit Number 18989 | 6000112.8301 | 2114568.7427 | 37.7862077855538 | -122.44338171916701 | (37.7862077855538, -122.443381719167) | ||
| 161016 | 161016 | 66368 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | |
| 162063 | 162063 | 53066 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | ||
| 162322 | 162322 | 66562 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.783393648613796 | -122.45029037155099 | (37.7833936486138, -122.450290371551) | |
| 162434 | 162434 | 67469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | |
| 163956 | 163956 | 108011 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) |
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");