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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
| 1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 2198 | 2198 | 252932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091179.0 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | |||||
| 2199 | 2199 | 252934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091229.0 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | |||||
| 2201 | 2201 | 252933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 72 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091205.0 | 37.7218868659906 | -122.45197719957199 | (37.7218868659906, -122.451977199572) | |||||
| 2596 | 2596 | 253141 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2597 | 2597 | 253140 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2602 | 2602 | 253139 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2604 | 2604 | 253137 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 2605 | 2605 | 253138 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 40 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | ||||
| 3402 | 3402 | 253446 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1339 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 3x3 | 6002186.0 | 2113207.0 | 37.7825867929513 | -122.43611162356399 | (37.7825867929513, -122.436111623564) | |||
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
| 4698 | 4698 | 253662 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4701 | 4701 | 253665 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4707 | 4707 | 253664 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4708 | 4708 | 253663 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4710 | 4710 | 253661 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 6162 | 6162 | 35284 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 6472 | 6472 | 39482 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 8735 | 8735 | 35281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 9537 | 9537 | 137839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005239.1389 | 2115489.1761 | 37.7890260654428 | -122.425711556168 | (37.7890260654428, -122.425711556168) | ||||
| 9786 | 9786 | 173690 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9794 | 9794 | 173689 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9801 | 9801 | 173692 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9809 | 9809 | 173691 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9961 | 9961 | 54316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1324 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1972 12:00:00 AM | 5x5 | Permit Number 10077 | 5994279.15543647 | 2106492.16366383 | 37.7636972500787 | -122.46297836176001 | (37.7636972500787, -122.46297836176) | ||
| 11312 | 11312 | 35280 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 13255 | 13255 | 187618 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993007.0 | 2088191.0 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | ||||
| 13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13335 | 13335 | 187678 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13336 | 13336 | 187675 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13337 | 13337 | 187679 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 13578 | 13578 | 187698 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | ||||
| 13846 | 13846 | 35283 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 15904 | 15904 | 42044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16213 | 16213 | 35285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16886 | 16886 | 39481 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 18149 | 18149 | 60477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | ||
| 18794 | 18794 | 46753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.717519344442294 | -122.465247516931 | (37.7175193444423, -122.465247516931) | ||
| 18915 | 18915 | 45453 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 19497 | 19497 | 39128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.41748542832899 | (37.7546309134503, -122.417485428329) | ||
| 19552 | 19552 | 50938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.44849544098601 | (37.7617562199837, -122.448495440986) | ||
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 24666 | 24666 | 32343 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | |||
| 28412 | 28412 | 99796 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 703-705 Elizabeth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001860.0 | 2102041.0 | 37.7519091810186 | -122.43644001508301 | (37.7519091810186, -122.436440015083) | ||||
| 34894 | 34894 | 38426 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.43810110094299 | (37.7324461904854, -122.438101100943) | ||
| 49226 | 49226 | 45516 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | ||
| 50107 | 50107 | 35980 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | ||
| 58682 | 58682 | 116625 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 6 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 61147 | 61147 | 111009 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1801x WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003409.0 | 2114904.0 | 37.787315733492605 | -122.432001790592 | (37.7873157334926, -122.432001790592) | ||||
| 71191 | 71191 | 105059 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.77898372892879 | -122.487875431883 | (37.7789837289288, -122.487875431883) | ||
| 76010 | 76010 | 51223 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47589 | 5999349.25090269 | 2107863.63052883 | 37.767753693584204 | -122.44554116379601 | (37.7677536935842, -122.445541163796) | ||
| 76171 | 76171 | 49955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 823 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | Permit Number 46736 | 6012467.34839499 | 2104144.40371857 | 37.7582816988758 | -122.39990576269301 | (37.7582816988758, -122.399905762693) | ||
| 77442 | 77442 | 103580 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | ||||
| 77494 | 77494 | 44313 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2150 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.43722376982299 | (37.7847020596058, -122.437223769823) | |||
| 77501 | 77501 | 88001 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 78335 | 78335 | 47594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 78662 | 78662 | 39795 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 78743 | 78743 | 33870 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 199 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | Permit Number 37861 | 6010103.23973562 | 2099711.91394451 | 37.74597898005 | -122.407769380972 | (37.74597898005, -122.407769380972) | |||
| 78802 | 78802 | 36904 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4375 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767280 | 6000774.94181487 | 2102264.44769346 | 37.752460998779995 | -122.440208312423 | (37.75246099878, -122.440208312423) | |
| 79010 | 79010 | 50355 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 79024 | 79024 | 47597 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 79468 | 79468 | 33858 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 23 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | Permit Number 37856 | 6002262.86430125 | 2100188.3462203997 | 37.746845115916294 | -122.434914374282 | (37.7468451159163, -122.434914374282) | |||
| 79487 | 79487 | 65858 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3449 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | Permit Number 28850 | 6000757.88455321 | 2120149.39668347 | 37.8015675622019 | -122.441550624863 | (37.8015675622019, -122.441550624863) | ||
| 79738 | 79738 | 60478 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20073 | 6002219.48599286 | 2113123.74035536 | 37.7823600854243 | -122.43598981706002 | (37.7823600854243, -122.43598981706) | ||
| 79836 | 79836 | 115296 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1715 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776029 | 5993685.8 | 2103804.5 | 37.756283428586705 | -122.464835383865 | (37.7562834285867, -122.464835383865) | |||
| 80044 | 80044 | 66226 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1092 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1991 12:00:00 AM | Permit Number 29321 | 6007625.68875547 | 2109532.95268759 | 37.772806281388796 | -122.417032186184 | (37.7728062813888, -122.417032186184) | ||
| 80098 | 80098 | 42773 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 595 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | ||
| 80178 | 80178 | 36110 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1900 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43523 | 5992873.88147935 | 2102526.51410864 | 37.75272756513029 | -122.467550320151 | (37.7527275651303, -122.467550320151) | ||
| 80200 | 80200 | 45451 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 80344 | 80344 | 60649 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 292 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20280 | 6003745.89450953 | 2097926.17013377 | 37.740717794785105 | -122.42962488431101 | (37.7407177947851, -122.429624884311) | ||
| 80347 | 80347 | 47544 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 42 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.751044374772206 | -122.42607822279 | (37.7510443747722, -122.42607822279) | ||
| 80366 | 80366 | 84954 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 8 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002223.0 | 2100219.0 | 37.7469270204759 | -122.43505441311001 | (37.7469270204759, -122.43505441311) | |||||
| 80587 | 80587 | 65355 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28190 | 6002485.22206397 | 2096558.7122320998 | 37.73689160797839 | -122.433886087946 | (37.7368916079784, -122.433886087946) | ||
| 80620 | 80620 | 103583 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 55X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | ||||
| 80912 | 80912 | 66563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 223 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | Permit Number 29752 | 6004817.37970152 | 2094084.27959898 | 37.73022943927371 | -122.42564672047399 | (37.7302294392737, -122.425646720474) | ||
| 81020 | 81020 | 83372 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4570 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50810 | 6000783.84913806 | 2104682.12835594 | 37.7590998696933 | -122.440350881798 | (37.7590998696933, -122.440350881798) | ||
| 81356 | 81356 | 39618 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 172 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.45175370217501 | (37.7646857112231, -122.451753702175) | ||
| 81550 | 81550 | 52262 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 146 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | 6x10 | Permit Number 48427 | 6005571.5262701 | 2100241.30714404 | 37.7471778384958 | -122.423477084213 | (37.7471778384958, -122.423477084213) | |
| 81666 | 81666 | 47155 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 401X Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45125 | 5993485.13149709 | 2093664.18210859 | 37.7284290986601 | -122.464792998786 | (37.7284290986601, -122.464792998786) | ||
| 81690 | 81690 | 88000 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 81734 | 81734 | 37557 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4582 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1998 12:00:00 AM | Permit Number 39996 | 6000729.26896445 | 2104687.27430081 | 37.7591108913935 | -122.440540014618 | (37.7591108913935, -122.440540014618) | ||
| 81761 | 81761 | 45585 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 139 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2011 12:00:00 AM | 3x3 | Permit Number 767525 | 5998075.71843503 | 2093918.7268896 | 37.7293916194009 | -122.44894151382601 | (37.7293916194009, -122.448941513826) | ||
| 82195 | 82195 | 68282 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 584 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1993 12:00:00 AM | Permit Number 32090 | 6002991.77839865 | 2095733.01235725 | 37.73465315799589 | -122.432075753497 | (37.7346531579959, -122.432075753497) | ||
| 82259 | 82259 | 68378 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 25 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32202 | 5998511.40529692 | 2105993.51041649 | 37.762570947697704 | -122.448304473804 | (37.7625709476977, -122.448304473804) | ||
| 82339 | 82339 | 97989 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897.0 | 2099683.0 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | ||
| 82450 | 82450 | 34496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 208 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38219 | 6008611.6034595 | 2097621.61105631 | 37.7401558519993 | -122.412779523149 | (37.7401558519993, -122.412779523149) | ||
| 82701 | 82701 | 75821 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500X 30TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1989 12:00:00 AM | 3x3 | 5986580.0 | 2112184.0 | 37.7788789460419 | -122.49002566353799 | (37.7788789460419, -122.490025663538) | |||
| 82833 | 82833 | 33871 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 199 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50234 | 6010103.23973562 | 2099711.91394451 | 37.74597898005 | -122.407769380972 | (37.74597898005, -122.407769380972) | ||
| 82898 | 82898 | 48839 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1239 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46837 | 5992309.70821316 | 2098410.34670203 | 37.7413930369511 | -122.46920175462601 | (37.7413930369511, -122.469201754626) | ||
| 82917 | 82917 | 58685 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/1988 12:00:00 AM | Permit Number 17913 | 6004542.14665913 | 2100947.18708781 | 37.7490578670673 | -122.427086868373 | (37.7490578670673, -122.427086868373) |
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");