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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114706 | 114706 | 96989 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 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) | ||||
| 106196 | 106196 | 96990 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 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) | ||||
| 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) | ||||
| 79404 | 79404 | 97051 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 80849 | 80849 | 97052 | Property Tree 7 | Pyrus spp :: Pear Tree 291 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 127434 | 127434 | 97236 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 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) | |||
| 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) | |||
| 100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
| 100757 | 100757 | 97298 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 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) | |||||
| 112388 | 112388 | 97300 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 105617 | 105617 | 97301 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1051 Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/20/2011 12:00:00 AM | Permit Number 768134 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||
| 120600 | 120600 | 97302 | Permitted Site 1 | Salix spp :: Willow 218 | 1051 Portola Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 138871 | 138871 | 97543 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 128441 | 128441 | 97544 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 129336 | 129336 | 97545 | Permitted Site 1 | Cercis canadensis :: Eastern Redbud 299 | 2001 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | ||||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 102330 | 102330 | 97684 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1648x York St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 768220 | 6010545.0 | 2100072.0 | 37.7469924183851 | -122.40626719199601 | (37.7469924183851, -122.406267191996) | |
| 126095 | 126095 | 97964 | Permitted Site 1 | Tree(s) :: 17 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 12 | 4x4 | Permit Number 768496 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |
| 112608 | 112608 | 97965 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4x4 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | ||||
| 89952 | 89952 | 97966 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1626 Shrader St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 4x4 | 5998119.3 | 2105007.8 | 37.7598420097441 | -122.44958958605899 | (37.7598420097441, -122.449589586059) | |||
| 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) | |||||
| 138917 | 138917 | 98077 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6001992.2 | 2108216.2 | 37.768872292925295 | -122.436424775079 | (37.7688722929253, -122.436424775079) | |||||
| 88130 | 88130 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 140636 | 140636 | 98141 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75 Starview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997450.6 | 2101840.3 | 37.7511065679937 | -122.45167379040899 | (37.7511065679937, -122.451673790409) | ||||
| 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) | |||
| 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) | |||
| 78583 | 78583 | 98287 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 300 Mangels Ave | 3 | 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) | |||
| 119061 | 119061 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 4 | 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) | |||
| 127682 | 127682 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 5 | 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) | |||
| 116414 | 116414 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 6 | 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) | |||
| 143976 | 143976 | 98358 | Undocumented 2 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 224@Napier Filbert St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6011805.0 | 2120142.0 | 37.802170435804896 | -122.403321855362 | (37.8021704358049, -122.403321855362) | ||||
| 117949 | 117949 | 98373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 701@ de Soto Urbano Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993201.0 | 2091808.0 | 37.7233160913053 | -122.46564044909799 | (37.7233160913053, -122.465640449098) | |||||
| 99055 | 99055 | 98374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 55717 | 55717 | 98543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 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) | |||||
| 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) | |||||
| 145559 | 145559 | 98736 | Undocumented 2 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000827.4 | 2096045.9 | 37.73538932786521 | -122.439581147409 | (37.7353893278652, -122.439581147409) | ||||||
| 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) | |||||
| 6592 | 6592 | 98837 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 89948 | 89948 | 98838 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||
| 14567 | 14567 | 98839 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 118436 | 118436 | 98840 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||||
| 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) | |||
| 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) | |||||
| 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) | |||||
| 114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 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) | |||||
| 139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 106068 | 106068 | 100123 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 126282 | 126282 | 100190 | Undocumented 2 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802.0 | 2103239.0 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | |||
| 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) | ||||
| 127969 | 127969 | 100199 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095813.0 | 37.7345948616995 | -122.44895594133499 | (37.7345948616995, -122.448955941335) | |||||
| 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) | |||||
| 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) | |||
| 129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | 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) | |||
| 97623 | 97623 | 100396 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 500X Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 3 | 3x9 | Permit Number 769101 | 5994983.3 | 2103652.8 | 37.755941622135296 | -122.460337221652 | (37.7559416221353, -122.460337221652) | |
| 124585 | 124585 | 100843 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 113536 | 113536 | 100844 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 1 Estero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 109239 | 109239 | 100845 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Estero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 105655 | 105655 | 100846 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 79153 | 79153 | 100847 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 49954 | 49954 | 100848 | Undocumented 2 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 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) | |||||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 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) | |||
| 114794 | 114794 | 101206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 2 | 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) | |||
| 54624 | 54624 | 101207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 3 | 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) | |||
| 20373 | 20373 | 101208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 4 | 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) | |||
| 80374 | 80374 | 101209 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 5 | 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) | |||
| 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) | |||
| 123859 | 123859 | 101211 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 7 | 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) | |||
| 113655 | 113655 | 101212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 8 | 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) | |||
| 105636 | 105636 | 101226 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 367 San Benito Way | 2 | 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) | |||
| 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) | |||
| 111919 | 111919 | 101477 | Permitted Site 1 | Tree(s) :: 17 | 1 Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | Permit Number 769453 | 5996419.1 | 2103319.0 | 37.7551075796122 | -122.455347659049 | (37.7551075796122, -122.455347659049) | |||
| 89847 | 89847 | 101525 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 630 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 15 ft wide public RoW | 6001829.0 | 2099440.0 | 37.744765690220106 | -122.436361083968 | (37.7447656902201, -122.436361083968) | |||
| 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) | |||||
| 102548 | 102548 | 101898 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 105468 | 105468 | 101899 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
| 35564 | 35564 | 102050 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2023 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 1 | Permit Number 770150 | 6012608.45431 | 2096904.7337099998 | 37.738410985264004 | -122.398909642062 | (37.738410985264, -122.398909642062) | ||
| 106403 | 106403 | 102105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 769122 | 6002645.0 | 2099438.0 | 37.7448065304391 | -122.43353937189501 | (37.7448065304391, -122.433539371895) | |||
| 115530 | 115530 | 102127 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 79 Starview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.751199689085205 | -122.451673814863 | (37.7511996890852, -122.451673814863) | ||||
| 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) | ||||
| 108542 | 108542 | 102129 | Permitted Site 1 | Tree(s) :: 17 | 79 Starview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.751199689085205 | -122.451673814863 | (37.7511996890852, -122.451673814863) | |||
| 112949 | 112949 | 102366 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 3500 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769587 | 5988245.5 | 2095259.3 | 37.7325053993107 | -122.483023305965 | (37.7325053993107, -122.483023305965) | ||||
| 144633 | 144633 | 102464 | Undocumented 2 | Tree(s) :: 17 | 280 Casitas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5994944.5 | 2096334.7 | 37.735845720803 | -122.459941299214 | (37.735845720803, -122.459941299214) | ||||
| 30529 | 30529 | 102468 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998217.7 | 2104179.8 | 37.757574157371295 | -122.44918961776699 | (37.7575741573713, -122.449189617767) | |||||
| 129340 | 129340 | 102476 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 760 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 101581 | 101581 | 102477 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 760 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 138626 | 138626 | 102585 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | |||
| 118196 | 118196 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | ||||
| 97449 | 97449 | 102592 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765.0 | 2094428.0 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | |
| 97641 | 97641 | 102753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 3x9 | 5992553.895830001 | 2111741.50306 | 37.778011002181 | -122.469327555756 | (37.778011002181, -122.469327555756) | |||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 |
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");