Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84949 | 84949 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49875 | 5993901.0 | 2092133.0 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | |||
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 141630 | 141630 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | |||||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 143824 | 143824 | 115749 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | |||||
| 50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 78781 | 78781 | 121184 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 79242 | 79242 | 121190 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 80352 | 80352 | 121187 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 89056 | 89056 | 121188 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 90930 | 90930 | 121191 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 91506 | 91506 | 121193 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 95270 | 95270 | 121186 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104617 | 104617 | 121185 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 123005 | 123005 | 121182 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 145554 | 145554 | 121180 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | ||||
| 113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
| 2151 | 2151 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001472.0 | 2098865.0 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | ||||
| 114906 | 114906 | 105678 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 101X 03RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6012079.1 | 2114345.8 | 37.7862707590298 | -122.401965633825 | (37.7862707590298, -122.401965633825) | |||
| 128185 | 128185 | 101258 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1049 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992548.0 | 2106581.0 | 37.763841302397104 | -122.46897230376699 | (37.7638413023971, -122.468972303767) | ||||
| 1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1708 | 1708 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1710 | 1710 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 2572 | 2572 | 24480 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 108X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780363 | 6002195.08262 | 2096706.93645 | 37.737282128351005 | -122.434899824187 | (37.737282128351, -122.434899824187) | |
| 93904 | 93904 | 118327 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 109 ALPINE TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181002 | (37.7688096651516, -122.43737752181) | ||||
| 85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 138789 | 138789 | 116957 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 10x Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||||
| 175351 | 175351 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6011908.79849 | 2103025.7220099997 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | |||
| 108692 | 108692 | 116346 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 121 SAN BENITO WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777164 | 5992901.0 | 2095856.0 | 37.73441359171021 | -122.46697163304701 | (37.7344135917102, -122.466971633047) | |
| 105495 | 105495 | 112955 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 24 | 121X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991652.84779157 | 2095347.0788301998 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | |||||
| 89824 | 89824 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 104170 | 104170 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 125443 | 125443 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 15902 | 15902 | 108047 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 3x3 | 6017036.144669999 | 2097442.01922 | 37.7401319873023 | -122.383638088928 | (37.7401319873023, -122.383638088928) | ||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 143633 | 143633 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778784 | 5981521.320719999 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | |||
| 131725 | 131725 | 88148 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1475 Eddy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 6 | 3x3 | Permit Number 51176 | 6003399.3649 | 2112760.0054 | 37.781428317697795 | -122.431881978872 | (37.7814283176978, -122.431881978872) | |
| 108992 | 108992 | 88147 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 122706 | 122706 | 88146 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 128937 | 128937 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 125242 | 125242 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150x FONT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976.0 | 2089133.0 | 37.715842612516106 | -122.473136789074 | (37.7158426125161, -122.473136789074) | ||
| 80993 | 80993 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 105009 | 105009 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 119181 | 119181 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 61 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | ||
| 85687 | 85687 | 113112 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014731.0 | 2095647.0 | 37.735075549566204 | -122.391482947841 | (37.7350755495662, -122.391482947841) | |||||
| 102016 | 102016 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.44567816768298 | (37.7642451591147, -122.445678167683) | ||||||
| 84797 | 84797 | 112378 | Significant Tree 6 | :: 54 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5990394.0 | 2102783.0 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | |||
| 10151 | 10151 | 173889 | Significant Tree 6 | Gleditsia triacanthos :: Honey Locust 67 | 190 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010824.0 | 2099939.0 | 37.746642831954496 | -122.405293064953 | (37.7466428319545, -122.405293064953) | ||||
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 80520 | 80520 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | ||||
| 105823 | 105823 | 116009 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777954 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | |
| 47274 | 47274 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 97751 | 97751 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 484 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773.0 | 2097898.0 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | ||
| 3204 | 3204 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 201 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004582.0 | 2109434.0 | 37.772362894278395 | -122.427553605007 | (37.7723628942784, -122.427553605007) | ||||
| 88665 | 88665 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009924.0 | 2099647.0 | 37.745790704819704 | -122.408384592716 | (37.7457907048197, -122.408384592716) | |||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 109984 | 109984 | 116585 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2100 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011843.0 | 2103815.0 | 37.757342401329105 | -122.402041888427 | (37.7573424013291, -122.402041888427) | |||
| 44089 | 44089 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 211 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) | |||
| 108780 | 108780 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | |
| 93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
| 139196 | 139196 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.722122935753106 | -122.47143422303499 | (37.7221229357531, -122.471434223035) | ||||
| 91812 | 91812 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001257.0 | 2116757.0 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | ||||
| 98270 | 98270 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
| 121982 | 121982 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
| 2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
| 95855 | 95855 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990059.0 | 2093141.0 | 37.726794444209396 | -122.47659897114599 | (37.7267944442094, -122.476598971146) | ||||
| 20387 | 20387 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778992 | 6001431.0 | 2120732.0 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | ||
| 86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
| 13290 | 13290 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006264.0 | 2119500.0 | 37.8000966404513 | -122.42245076966002 | (37.8000966404513, -122.42245076966) | ||||
| 114328 | 114328 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001200.0 | 2116539.0 | 37.79167953949779 | -122.439761713662 | (37.7916795394978, -122.439761713662) | ||||
| 12363 | 12363 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | |
| 80217 | 80217 | 92320 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2733 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5984522.0 | 2096783.0 | 37.736471699686206 | -122.49600850837099 | (37.7364716996862, -122.496008508371) | |
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 98070 | 98070 | 88456 | Significant Tree 6 | Tree(s) :: 17 | 2801 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2008 12:00:00 AM | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 111690 | 111690 | 88457 | Significant Tree 6 | Tree(s) :: 17 | 2801 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2008 12:00:00 AM | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 9738 | 9738 | 173675 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9741 | 9741 | 173676 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9743 | 9743 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9744 | 9744 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9749 | 9749 | 173677 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 299x Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9750 | 9750 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 120295 | 120295 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | |||
| 140584 | 140584 | 117248 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x GRAYSTONE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | ||||
| 95523 | 95523 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 119 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.46331886635099 | (37.7394838741894, -122.463318866351) |
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");