Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82122 | 82122 | 100107 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 102979 | 102979 | 100108 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 109346 | 109346 | 100106 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007004.8 | 2122229.7 | 37.807633464576796 | -122.420081138169 | (37.8076334645768, -122.420081138169) | |||||
| 27184 | 27184 | 117402 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 43174 | 43174 | 117400 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 79596 | 79596 | 117399 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 110743 | 110743 | 117403 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 119625 | 119625 | 117398 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 143747 | 143747 | 117401 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 117498 | 117498 | 92896 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 226 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | 6009506.8 | 2122067.0 | 37.807327381635496 | -122.411410840149 | (37.8073273816355, -122.411410840149) | |||
| 86274 | 86274 | 21818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2693 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008270.977530001 | 2122039.96134 | 37.80718374817771 | -122.415685775277 | (37.8071837481777, -122.415685775277) | |||
| 77463 | 77463 | 21815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 85758 | 85758 | 21814 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 128123 | 128123 | 21817 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2683 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008202.62871 | 2121958.17011 | 37.8069553278433 | -122.41591651610001 | (37.8069553278433, -122.4159165161) | |||
| 104083 | 104083 | 21816 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2669 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008202.59065 | 2121958.17011 | 37.806955325703605 | -122.415916647815 | (37.8069553257036, -122.415916647815) | |||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 94842 | 94842 | 21807 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 120694 | 120694 | 21805 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 79385 | 79385 | 110987 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 81572 | 81572 | 110995 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 86422 | 86422 | 52076 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 86652 | 86652 | 110988 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 89318 | 89318 | 110998 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 94805 | 94805 | 110984 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 106836 | 106836 | 110991 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 114327 | 114327 | 110996 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 116009 | 116009 | 110992 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 127603 | 127603 | 110994 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 140077 | 140077 | 110997 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 141370 | 141370 | 110986 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 143989 | 143989 | 110990 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 145903 | 145903 | 110993 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 86004 | 86004 | 21810 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | |||
| 117172 | 117172 | 21809 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2627 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | |||
| 93596 | 93596 | 21812 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2631 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | |||
| 108656 | 108656 | 40159 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1999 12:00:00 AM | Permit Number 41353 | 6009783.18603588 | 2121626.8328918 | 37.8061342908169 | -122.41042324029499 | (37.8061342908169, -122.410423240295) | |||
| 82278 | 82278 | 11175 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 83569 | 83569 | 11177 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 110897 | 110897 | 11176 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 83928 | 83928 | 4754 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 92314 | 92314 | 4755 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 127680 | 127680 | 4753 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 105575 | 105575 | 97938 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2133 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009831.3 | 2121360.2 | 37.8054048804892 | -122.41023789601299 | (37.8054048804892, -122.410237896013) | ||||
| 119002 | 119002 | 104729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250-252 FRANCISCO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | 6010061.3 | 2121325.4 | 37.805322217951 | -122.409439489572 | (37.805322217951, -122.409439489572) | ||||
| 116330 | 116330 | 4746 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1199X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X4 | 6007816.30894 | 2121179.41413 | 37.804795334946796 | -122.417198239329 | (37.8047953349468, -122.417198239329) | |||
| 124684 | 124684 | 4747 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1199X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X4 | 6007816.30894 | 2121179.41413 | 37.804795334946796 | -122.417198239329 | (37.8047953349468, -122.417198239329) | |||
| 78720 | 78720 | 102621 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 106692 | 106692 | 102618 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 113081 | 113081 | 102620 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 118637 | 118637 | 102619 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 103697 | 103697 | 59152 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1980 12:00:00 AM | 12 | 3x3 | Permit Number 18461 | 6009909.46799044 | 2121095.5996991 | 37.804682735182794 | -122.409948693589 | (37.8046827351828, -122.409948693589) | |
| 77611 | 77611 | 102625 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 17346 | 6010349.4 | 2120908.5 | 37.804193651889 | -122.408413053021 | (37.804193651889, -122.408413053021) | ||
| 90806 | 90806 | 4728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 127950 | 127950 | 4729 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 5973 | 5973 | 12978 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 300 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6010840.9455 | 2120711.3367 | 37.803679804278104 | -122.40669811093099 | (37.8036798042781, -122.406698110931) | |||
| 113925 | 113925 | 13023 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 440 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2015 08:29:00 AM | 3 | 4X4 | 6010228.79362 | 2120718.91833 | 37.803666352876704 | -122.408817039093 | (37.8036663528767, -122.408817039093) | ||
| 85679 | 85679 | 12995 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6010700.99247 | 2120707.1444 | 37.803660461944105 | -122.407182132325 | (37.8036604619441, -122.407182132325) | |||
| 4346 | 4346 | 12986 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.40686916312401 | (37.8036540726688, -122.406869163124) | ||
| 88656 | 88656 | 12996 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 340 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010677.76597 | 2120690.6320599997 | 37.8036138232581 | -122.407261344489 | (37.8036138232581, -122.407261344489) | |||
| 117188 | 117188 | 1760 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3041X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005500.29496 | 2120778.87447 | 37.803564990343204 | -122.425184535531 | (37.8035649903432, -122.425184535531) | |||
| 102596 | 102596 | 13012 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6010380.849090001 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | |||
| 93712 | 93712 | 117188 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x6 | 6011596.0 | 2120619.0 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | ||||
| 93725 | 93725 | 117187 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 200x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x6 | 6011596.0 | 2120619.0 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | ||||
| 6631 | 6631 | 13008 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.803418967602205 | -122.40768869648399 | (37.8034189676022, -122.407688696484) | ||
| 8862 | 8862 | 13007 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.40778071851601 | (37.8034055135257, -122.407780718516) | ||
| 3424 | 3424 | 13006 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | ||
| 7836 | 7836 | 13005 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | ||
| 138898 | 138898 | 13036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:35:00 AM | 3 | 3X3 | 6010019.32094 | 2120615.54911 | 37.80337079145 | -122.40953463326599 | (37.80337079145, -122.409534633266) | ||
| 79031 | 79031 | 4709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.6629099995 | 2120633.4675 | 37.8033402849031 | -122.41445215852801 | (37.8033402849031, -122.414452158528) | ||
| 8687 | 8687 | 13035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2015 08:33:00 AM | 3 | 3X3 | 6010007.9078 | 2120594.4895 | 37.8033123274611 | -122.40957264178199 | (37.8033123274611, -122.409572641782) | ||
| 939 | 939 | 13046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.41041331411199 | (37.8032072253646, -122.410413314112) | |||
| 86960 | 86960 | 20258 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8x8 | 6009991.4611599995 | 2120547.45752 | 37.80318226771129 | -122.40962623465201 | (37.8031822677113, -122.409626234652) | |||
| 6433 | 6433 | 13039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | |||
| 86788 | 86788 | 103484 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2375X Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 9x6 | 6007909.0 | 2120582.3 | 37.803161024427794 | -122.41683514128799 | (37.8031610244278, -122.416835141288) | |||
| 101899 | 101899 | 103485 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2375X Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 9x9 | 6007909.0 | 2120582.3 | 37.803161024427794 | -122.41683514128799 | (37.8031610244278, -122.416835141288) | |||
| 122852 | 122852 | 13054 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 562 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 6009643.06131 | 2120540.81886 | 37.80314451067 | -122.41083141813 | (37.80314451067, -122.41083141813) | |||
| 7170 | 7170 | 4704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.803115382163206 | -122.414077244448 | (37.8031153821632, -122.414077244448) | |||
| 22869 | 22869 | 13081 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | ||
| 107446 | 107446 | 13077 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 645X Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 19501 | 19501 | 117186 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 80730 | 80730 | 117185 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 139922 | 139922 | 117184 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 108784 | 108784 | 98660 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 701X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6008942.64461 | 2120384.5879599997 | 37.8026762417443 | -122.41324418324 | (37.8026762417443, -122.41324418324) | |||
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 91608 | 91608 | 29910 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6008575.10006 | 2120353.4287400004 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | ||||
| 126916 | 126916 | 4701 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456691999 | (37.8025035109944, -122.41317456692) | |||
| 86525 | 86525 | 105658 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6007813.035080001 | 2120272.8882299997 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | ||||
| 138615 | 138615 | 105657 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6007813.035080001 | 2120272.8882299997 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | ||||
| 89957 | 89957 | 113573 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007813.0 | 2120272.0 | 37.802303618634795 | -122.417145352251 | (37.8023036186348, -122.417145352251) | |||
| 3707 | 3707 | 253520 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 82915 | 82915 | 95268 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2245 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 122189 | 122189 | 95269 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | |||
| 140600 | 140600 | 113574 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 98281 | 98281 | 4693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 781 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009263.30605 | 2120079.28345 | 37.801855948749 | -122.41211293899299 | (37.801855948749, -122.412112938993) | |||
| 117740 | 117740 | 117286 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3500 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6002513.0 | 2120207.0 | 37.8018255621759 | -122.43548126067199 | (37.8018255621759, -122.435481260672) | ||||
| 109853 | 109853 | 4686 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6009336.3456 | 2120034.6979099996 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | |||
| 116547 | 116547 | 4683 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) |
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");