Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81044 | 81044 | 110874 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 81175 | 81175 | 116296 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | ||||
| 81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 81316 | 81316 | 94369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 81451 | 81451 | 98286 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 300 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 81452 | 81452 | 112182 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 301x CORBETT AVE | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 81845 | 81845 | 113126 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
| 82440 | 82440 | 103917 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 82447 | 82447 | 98285 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 300 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 82974 | 82974 | 113119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82981 | 82981 | 110866 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 83063 | 83063 | 93094 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 83229 | 83229 | 100849 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 83296 | 83296 | 114710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 83308 | 83308 | 85506 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 83515 | 83515 | 94380 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 83592 | 83592 | 102128 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 79 Starview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.751199689085205 | -122.451673814863 | (37.7511996890852, -122.451673814863) | ||||
| 83901 | 83901 | 99609 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 1 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
| 84132 | 84132 | 112917 | DPW Maintained 3 | Shrub :: Shrub 98 | 480X BEACON ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 6002571.0 | 2098077.0 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | |||||
| 84196 | 84196 | 94383 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 84245 | 84245 | 113122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84453 | 84453 | 116300 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 699X DETROIT ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | ||||
| 84472 | 84472 | 101657 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 320 Santa Ana Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992576.9 | 2094712.8 | 37.7312559376124 | -122.46800901581001 | (37.7312559376124, -122.46800901581) | |||||
| 84522 | 84522 | 113121 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84623 | 84623 | 110884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 84812 | 84812 | 96294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | ||
| 84868 | 84868 | 119660 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 84983 | 84983 | 96991 | Permitted Site 1 | Acer circinatum :: Vine Maple 379 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 85138 | 85138 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 201X Haight St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004725.0 | 2109149.0 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | |||||
| 85460 | 85460 | 113113 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 85824 | 85824 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 86001 | 86001 | 115786 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75 MARIETTA DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5998284.0 | 2098359.0 | 37.7415954597605 | -122.448541125431 | (37.7415954597605, -122.448541125431) | ||||
| 86086 | 86086 | 103907 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 86577 | 86577 | 115542 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 86581 | 86581 | 101227 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 367 San Benito Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | Permit Number 769219 | 5992771.0 | 2094160.5 | 37.7297506659069 | -122.467297838803 | (37.7297506659069, -122.467297838803) | |||
| 86774 | 86774 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 86945 | 86945 | 101210 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 86986 | 86986 | 100192 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 62 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | 6000448.0 | 2095531.0 | 37.7339539318334 | -122.440855946438 | (37.7339539318334, -122.440855946438) | ||||
| 87135 | 87135 | 103919 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 87589 | 87589 | 94384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87626 | 87626 | 94379 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 87647 | 87647 | 110867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 87738 | 87738 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330.0 | 2096776.0 | 37.737422605415205 | -122.43789575270901 | (37.7374226054152, -122.437895752709) | |||
| 87896 | 87896 | 85505 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 88184 | 88184 | 93087 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 88200 | 88200 | 110898 | Undocumented 2 | Betula nigra :: River Birch 266 | 800 INDIANA ST | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 88321 | 88321 | 119665 | Undocumented 2 | Schinus molle :: California Pepper 138 | 699x Missouri St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 88545 | 88545 | 113118 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 88599 | 88599 | 101205 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 88848 | 88848 | 112181 | DPW Maintained 3 | Prunus amygdalus :: Almond 63 | 301x CORBETT AVE | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 89272 | 89272 | 97967 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |||||
| 89530 | 89530 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 89582 | 89582 | 99611 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
| 89777 | 89777 | 114709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 90025 | 90025 | 110868 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 800 INDIANA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 90074 | 90074 | 119667 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 699x Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 90213 | 90213 | 100247 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
| 90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 90564 | 90564 | 100200 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095844.0 | 37.734679980307604 | -122.448958173673 | (37.7346799803076, -122.448958173673) | |||||
| 90764 | 90764 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 201X Haight St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004725.0 | 2109149.0 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | |||||
| 91385 | 91385 | 102872 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 92139 | 92139 | 117534 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 100 BRENTWOOD AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x10 | 5995843.0 | 2095739.0 | 37.7342617075966 | -122.45679177999399 | (37.7342617075966, -122.456791779994) | ||||
| 92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 93093 | 93093 | 93196 | Permitted Site 1 | Tree(s) :: 17 | 1223 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/19/2010 12:00:00 AM | Permit Number 53200 | 5988582.3 | 2106975.8 | 37.764695390778606 | -122.482717226164 | (37.7646953907786, -122.482717226164) | |||
| 93245 | 93245 | 112892 | Section 143 8 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1X WEBSTER ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 93391 | 93391 | 95532 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2569 San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/30/2010 12:00:00 AM | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | |||
| 93393 | 93393 | 103615 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 93540 | 93540 | 99608 | Permitted Site 1 | Tree(s) :: 17 | 1 Entrada Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768939 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||
| 93815 | 93815 | 112660 | Permitted Site 1 | Tree(s) :: 17 | 2101X 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2015 12:00:00 AM | Permit Number 775001 | 5993200.98623 | 2101015.16354 | 37.7485966642746 | -122.46630931333401 | (37.7485966642746, -122.466309313334) | |||
| 94145 | 94145 | 103911 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 94230 | 94230 | 72891 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 94535 | 94535 | 108345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 94629 | 94629 | 110173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 94930 | 94930 | 93090 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95242 | 95242 | 106255 | Significant Tree 6 | Tree(s) :: 17 | 1900X 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770844 | 6012067.0 | 2105610.0 | 37.7622835736204 | -122.40139334750201 | (37.7622835736204, -122.401393347502) | ||||
| 95304 | 95304 | 94385 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 95325 | 95325 | 111308 | Private 5 | Pinus radiata :: Monterey Pine 3 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x90 | 6015099.0 | 2088640.0 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | ||||
| 95920 | 95920 | 110894 | Undocumented 2 | Betula nigra :: River Birch 266 | 800 INDIANA ST | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 96674 | 96674 | 93080 | Permitted Site 1 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 96747 | 96747 | 110879 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 800 INDIANA ST | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 96813 | 96813 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||||
| 97072 | 97072 | 109666 | Undocumented 2 | Tree(s) :: 17 | 2X NIDO AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999244.0 | 2112088.0 | 37.779346725836795 | -122.446209119816 | (37.7793467258368, -122.446209119816) | |||||
| 97166 | 97166 | 108352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501x RIVERA ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 97197 | 97197 | 98836 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||||
| 97300 | 97300 | 98544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 97565 | 97565 | 106145 | Permitted Site 1 | Tree(s) :: 17 | 89 Belgrave Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 771523 | 5998082.7 | 2104872.2 | 37.7594675922154 | -122.449706395213 | (37.7594675922154, -122.449706395213) | |||||
| 97630 | 97630 | 113116 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1x TOMASO CT | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 97963 | 97963 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 98232 | 98232 | 103029 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 434 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.71859090630271 | -122.463407787149 | (37.7185909063027, -122.463407787149) | |||
| 98317 | 98317 | 121588 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4485 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000127.0 | 2101626.0 | 37.75067106531171 | -122.442403165119 | (37.7506710653117, -122.442403165119) |
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");