Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42991 | 42991 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | ||
| 83931 | 83931 | 105169 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 3 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 4x4 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 111891 | 111891 | 105167 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 1 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 8 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 117969 | 117969 | 105170 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 4 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 2 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 56265 | 56265 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 953 Indiana St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | |||||
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 141088 | 141088 | 115806 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 362 MISSOURI ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6013446.0 | 2105415.0 | 37.7618249904211 | -122.39661020099 | (37.7618249904211, -122.39661020099) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 5087 | 5087 | 150676 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 548 Rhode Island St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.983990001 | 2105812.52377 | 37.762822244976505 | -122.402486741392 | (37.7628222449765, -122.402486741392) | |
| 78331 | 78331 | 117161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | |||||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 98792 | 98792 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 238 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 134828 | 134828 | 114679 | Permitted Site 1 | Malus :: Crab Apple 235 | 836 Brussels St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | ||
| 110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
| 91613 | 91613 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 106407 | 106407 | 88454 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 111585 | 111585 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1793 | 1793 | 251713 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 5 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1795 | 1795 | 251712 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 4 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1797 | 1797 | 251710 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 2 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1799 | 1799 | 251715 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 7 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1805 | 1805 | 251709 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1807 | 1807 | 251714 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 6 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 22873 | 22873 | 251137 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828.0 | 2094364.0 | 37.7312793503434 | -122.40834398535401 | (37.7312793503434, -122.408343985354) | |
| 123053 | 123053 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 408 | 55 BRONTE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6009403.0 | 2097128.0 | 37.738844891472894 | -122.410008345842 | (37.7388448914729, -122.410008345842) | ||||
| 129263 | 129263 | 63301 | Permitted Site 1 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.745892263304896 | -122.411424351246 | (37.7458922633049, -122.411424351246) | |
| 80984 | 80984 | 88447 | Permitted Site 1 | Tree(s) :: 17 | 93 Prentiss St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51413 | 6008891.7 | 2098141.7 | 37.7415996198956 | -122.411847801096 | (37.7415996198956, -122.411847801096) | ||
| 89776 | 89776 | 98528 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 118464 | 118464 | 98529 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 98650 | 98650 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 81797 | 81797 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 811 TREAT AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 3x3 | 6008597.0 | 2103712.0 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | |||
| 2134 | 2134 | 252904 | Undocumented 2 | Magnolia champaca :: Champa 170 | 1216 Clay St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008866.0 | 2117029.0 | 37.7934583239602 | -122.41327198066799 | (37.7934583239602, -122.413271980668) | ||||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
| 54137 | 54137 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 85042 | 85042 | 106874 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 86948 | 86948 | 106872 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 111788 | 111788 | 106871 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 181559 | 181559 | 106870 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 2 | Permit Number 769156 | 6008504.136630001 | 2111439.18954 | 37.778089733190605 | -122.414128411309 | (37.7780897331906, -122.414128411309) | ||
| 79650 | 79650 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Florence St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | ||||
| 124233 | 124233 | 114680 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 54 Colby St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861.0 | 37.729793151999395 | -122.414784067206 | (37.7297931519994, -122.414784067206) | |||
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 114585 | 114585 | 115388 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 169x BOCANA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 25 | 40x50 | 6007278.0 | 2097999.0 | 37.7411171346524 | -122.417417333034 | (37.7411171346524, -122.417417333034) | |||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 914 | 914 | 225888 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 32 | 6x6 | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 80785 | 80785 | 104444 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 144956 | 144956 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 114285 | 114285 | 96183 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||||
| 138475 | 138475 | 96182 | Permitted Site 1 | Tree(s) :: 17 | 330 South Van Ness Ave | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 04/04/2011 12:00:00 AM | Permit Number 767813 | 6007366.0 | 2107749.1 | 37.7678936317448 | -122.417804012618 | (37.7678936317448, -122.417804012618) | ||||
| 123166 | 123166 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 101 LUNDYS LN | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 6006875.0 | 2098969.0 | 37.7437578546964 | -122.41887954343599 | (37.7437578546964, -122.418879543436) | ||||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 97249 | 97249 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060.0 | 2120781.0 | 37.8036588138585 | -122.41978724303999 | (37.8036588138585, -122.41978724304) | ||
| 125158 | 125158 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 6006172.0 | 2100967.0 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | |||
| 3318 | 3318 | 253415 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 Stoneybrook Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.4268599998 | 37.729984953042795 | -122.421802746417 | (37.7299849530428, -122.421802746417) | |||
| 80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 100592 | 100592 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 124370 | 124370 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 88934 | 88934 | 107130 | Property Tree 7 | Phoenix dactylifera :: Date Palm 65 | 751 DOLORES ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.42543429450701 | (37.7573290011944, -122.425434294507) | |||||
| 99196 | 99196 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 461X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005199.36333 | 2111122.83043 | 37.777034912059605 | -122.425538300101 | (37.7770349120596, -122.425538300101) | |||||
| 86717 | 86717 | 108022 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 145 | 455X Ivy St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 144227 | 144227 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 455X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 88886 | 88886 | 117247 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1096 EDDY ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6x6 | 6005188.0 | 2113045.0 | 37.7823120756394 | -122.425714454198 | (37.7823120756394, -122.425714454198) | ||||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 129310 | 129310 | 99268 | Property Tree 7 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004280.0 | 2096681.0 | 37.7373290690714 | -122.42768945491501 | (37.7373290690714, -122.427689454915) | ||||||
| 85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
| 106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
| 86498 | 86498 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 115 | 2100 MARKET ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004034.0 | 2107672.1 | 37.767494134010896 | -122.429323526179 | (37.7674941340109, -122.429323526179) | ||||||
| 85775 | 85775 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.79010430227179 | -122.42974344149499 | (37.7901043022718, -122.429743441495) | |
| 94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 129431 | 129431 | 110789 | Section 143 8 | Pinus radiata :: Monterey Pine 3 | 850x SANCHEZ ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | ||||
| 142954 | 142954 | 110788 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 95257 | 95257 | 93959 | Permitted Site 1 | Prunus spp :: Cherry 84 | 419 Elizabeth St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 53399 | 6003681.0 | 2102149.0 | 37.752309029626495 | -122.430150445418 | (37.7523090296265, -122.430150445418) | ||||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 81053 | 81053 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 93053 | 93053 | 88571 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 62 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 104222 | 104222 | 88572 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 66 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 109202 | 109202 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 112187 | 112187 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 115344 | 115344 | 88568 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 59 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 94216 | 94216 | 100680 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7' wide public RoW | 6002378.0 | 2098199.0 | 37.7413893731095 | -122.434374040118 | (37.7413893731095, -122.434374040118) | |||||
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 74401 | 74401 | 121592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002342.0 | 2100313.0 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | ||||
| 78878 | 78878 | 2044 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X Bosworth St | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 36 | Permit Number 772999 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 78259 | 78259 | 111280 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X BOSWORTH ST | 18 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) |
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");