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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 11570 | 11570 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987294.0 | 2096147.0 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | ||||
| 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) | |
| 96972 | 96972 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 34 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 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) | ||||||
| 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) | ||||
| 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) | ||||
| 82760 | 82760 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 84141 | 84141 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 94160 | 94160 | 113187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3340 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008444.0 | 2099179.0 | 37.7444226899799 | -122.41346914528499 | (37.7444226899799, -122.413469145285) | |||
| 103031 | 103031 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 105748 | 105748 | 120595 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 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) | |
| 115908 | 115908 | 85032 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Panorama Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997300.0 | 2101977.0 | 37.7514732863106 | -122.452204440653 | (37.7514732863106, -122.452204440653) | |||||
| 118230 | 118230 | 120598 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 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) | |||
| 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) | ||
| 78383 | 78383 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5996066.0 | 2095432.0 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | |||
| 85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | |||||
| 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) | ||||
| 101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
| 83319 | 83319 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | ||
| 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) | ||
| 92394 | 92394 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 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) | ||
| 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) | ||
| 112912 | 112912 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969.0 | 37.7375153061033 | -122.46431353926701 | (37.7375153061033, -122.464313539267) | ||
| 115585 | 115585 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584.0 | 2097045.0 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | |
| 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) | ||
| 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) | ||
| 139076 | 139076 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776555 | 5993732.7 | 2097034.0 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | ||||
| 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) | ||
| 144044 | 144044 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 146206 | 146206 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.737612976998896 | -122.464024183823 | (37.7376129769989, -122.464024183823) | ||
| 82126 | 82126 | 115125 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 82400 | 82400 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 97871 | 97871 | 115124 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 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) | |
| 112243 | 112243 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | |||
| 114111 | 114111 | 112626 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3430X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6006285.0 | 2102686.4 | 37.753931748244604 | -122.421183538041 | (37.7539317482446, -122.421183538041) | ||||
| 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) | |||
| 120452 | 120452 | 100055 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 126303 | 126303 | 100056 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 138786 | 138786 | 99099 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65X Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768467 | 5993743.4 | 2097365.9 | 37.7386079879791 | -122.464168780849 | (37.7386079879791, -122.464168780849) | |||
| 142304 | 142304 | 100054 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 8728 | 8728 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.5282099997 | 37.803122321012296 | -122.418746939923 | (37.8031223210123, -122.418746939923) | |
| 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) | |
| 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) | ||||
| 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) | ||||
| 99634 | 99634 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991942.0 | 2105939.0 | 37.7620435090796 | -122.47102148161501 | (37.7620435090796, -122.471021481615) | |||||
| 144015 | 144015 | 108197 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 930 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | |||||
| 3879 | 3879 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445.0 | 2101187.0 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | |
| 9148 | 9148 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49384 | ||||||||
| 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) | |||
| 103510 | 103510 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 53020 | 6006011.0 | 2111744.0 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | |||
| 103692 | 103692 | 57910 | Significant Tree 6 | Tree(s) :: 17 | 446 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1977 12:00:00 AM | Permit Number 16868 | 6003019.35193275 | 2099229.53580249 | 37.7442553690473 | -122.432230049776 | (37.7442553690473, -122.432230049776) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 143961 | 143961 | 116345 | Significant Tree 6 | Tree(s) :: 17 | 85x SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777165 | 5993361.0 | 2096925.0 | 37.7373753392635 | -122.465458906558 | (37.7373753392635, -122.465458906558) | |
| 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) | |
| 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) | ||||
| 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) | |||
| 94649 | 94649 | 112577 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 3326 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Permit Number 775776 | 6006851.0 | 2102663.4 | 37.753900487576296 | -122.419224541208 | (37.7539004875763, -122.419224541208) | |||
| 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) | |||||
| 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) | ||||
| 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) | |
| 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) | |||
| 164545 | 164545 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/28/2005 12:00:00 AM | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 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) | ||||
| 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) | ||||
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) |
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");