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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24386 | 24386 | 125162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2667 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6000844.12478 | 2117536.98502 | 37.7943994826029 | -122.441064665996 | (37.7943994826029, -122.441064665996) | |||
24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
24414 | 24414 | 205283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 5994526.48433 | 2100257.0572599997 | 37.7465914866063 | -122.46167083296801 | (37.7465914866063, -122.461670832968) | |||
24416 | 24416 | 212061 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994643.85383 | 2097859.63633 | 37.740015523303704 | -122.461091241468 | (37.7400155233037, -122.461091241468) | |||
24438 | 24438 | 118836 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 600 46th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5981651.25866 | 2111619.12831 | 37.77703893001029 | -122.50703392298401 | (37.7770389300103, -122.507033922984) | |||
24441 | 24441 | 213456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993116.56669 | 2099668.45247 | 37.7448940675206 | -122.46650336333799 | (37.7448940675206, -122.466503363338) | |||
24464 | 24464 | 124319 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 125 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5996196.09521 | 2113578.46254 | 37.783264606053294 | -122.456860862891 | (37.7832646060533, -122.456860862891) | |||
24473 | 24473 | 250486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 220 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5987923.25995 | 2115358.25633 | 37.7876728999176 | -122.485611871313 | (37.7876728999176, -122.485611871313) | |||
24498 | 24498 | 210813 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 486 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994698.943 | 2100017.50065 | 37.745943650072704 | -122.46105713288401 | (37.7459436500727, -122.461057132884) | |||
24504 | 24504 | 241043 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 300 Virginia Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6006909.48713 | 2098350.81017 | 37.742062385665605 | -122.418716463718 | (37.7420623856656, -122.418716463718) | |||
24520 | 24520 | 250561 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 445 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987169.29864 | 2115304.2119400003 | 37.7874805511254 | -122.488216423958 | (37.7874805511254, -122.488216423958) | |||
24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
24576 | 24576 | 250559 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 415 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987302.16749 | 2115278.75264 | 37.7874183980764 | -122.487754859517 | (37.7874183980764, -122.487754859517) | |||
24582 | 24582 | 179929 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 325 Olmstead St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6010709.09006 | 2090936.6373700001 | 37.7219178272384 | -122.405056643155 | (37.7219178272384, -122.405056643155) | |||
24597 | 24597 | 206648 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.46176019139799 | (37.748320765087, -122.461760191398) | |||
24602 | 24602 | 208981 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | |||
24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
24610 | 24610 | 183977 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1693 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985918.7806 | 2103713.7918 | 37.7555834944248 | -122.49168936146002 | (37.7555834944248, -122.49168936146) | |||
24621 | 24621 | 205635 | Undocumented 2 | Betula spp :: Birch 95 | 20 Belmont Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5996782.71205 | 2106151.6508299997 | 37.762906178688105 | -122.454294786868 | (37.7629061786881, -122.454294786868) | ||||
24629 | 24629 | 208390 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 151 Elmwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5994957.667859999 | 2092685.59829 | 37.725826932848705 | -122.459631554564 | (37.7258269328487, -122.459631554564) | |||
24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
24641 | 24641 | 203805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 5993891.16391 | 2100082.05221 | 37.7460743755414 | -122.463854985838 | (37.7460743755414, -122.463854985838) | |||
24653 | 24653 | 178297 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 654 Brotherhood Way | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5989773.99422 | 2088725.52612 | 37.7146541208759 | -122.47726167241001 | (37.7146541208759, -122.47726167241) | |||
24718 | 24718 | 229095 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 170 Santa Marina St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6006508.76919 | 2097364.11009 | 37.739330558251204 | -122.42003201627199 | (37.7393305582512, -122.420032016272) | |||
24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
24725 | 24725 | 206493 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 1473 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991137.15941 | 2105390.2414599997 | 37.7604901815048 | -122.47376505163 | (37.7604901815048, -122.47376505163) | |||
24730 | 24730 | 222027 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 310 Liberty St | 60 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003716.8909599995 | 2103932.15667 | 37.7572071892775 | -122.430153527076 | (37.7572071892775, -122.430153527076) | |||
24748 | 24748 | 210946 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996128.662169999 | 2088702.9665 | 37.714958832754 | -122.455295843853 | (37.714958832754, -122.455295843853) | ||||
24755 | 24755 | 117990 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 38 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 10ft | 5984444.7207 | 2112850.37395 | 37.780583695587396 | -122.49746153818899 | (37.7805836955874, -122.497461538189) | |||
24760 | 24760 | 188680 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6018245.47476 | 2096448.1212400002 | 37.7374697107694 | -122.37938765012501 | (37.7374697107694, -122.379387650125) | ||||
24768 | 24768 | 250528 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 76 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5987723.676030001 | 2115494.19027 | 37.7880345047402 | -122.48631236764099 | (37.7880345047402, -122.486312367641) | |||
24777 | 24777 | 123037 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 598 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991936.90153 | 2111420.91872 | 37.777095091129105 | -122.471438573307 | (37.7770950911291, -122.471438573307) | |||
24784 | 24784 | 232225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 Germania St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004247.320040001 | 2108919.60304 | 37.7709315496771 | -122.42867461895099 | (37.7709315496771, -122.428674618951) | |||
24799 | 24799 | 120350 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2122 Lake St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988813.63616 | 2114710.28976 | 37.7859456052821 | -122.482483881641 | (37.7859456052821, -122.482483881641) | |||
24806 | 24806 | 250749 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2845 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986570.97427 | 2114425.38607 | 37.785032623492896 | -122.490221805991 | (37.7850326234929, -122.490221805991) | |||
24808 | 24808 | 210655 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 302 Westgate Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5993736.1298400005 | 2094686.96853 | 37.731251887161605 | -122.463999505972 | (37.7312518871616, -122.463999505972) | |||
24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
24880 | 24880 | 178117 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988789.573419999 | 2089765.1297400002 | 37.717451446800204 | -122.480740256365 | (37.7174514468002, -122.480740256365) | ||||
24901 | 24901 | 188434 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 406 Arkansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6012917.44565 | 2105140.82493 | 37.7610427357449 | -122.39841903400499 | (37.7610427357449, -122.398419034005) | |||
24903 | 24903 | 201466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Catalina St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6017699.909990001 | 2096021.8364 | 37.7362691149141 | -122.38124431128 | (37.7362691149141, -122.38124431128) | |||
24912 | 24912 | 208332 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3688 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5990508.376069999 | 2091529.5417099998 | 37.7223958366684 | -122.47492792990299 | (37.7223958366684, -122.474927929903) | |||
24937 | 24937 | 250897 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 257 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986796.26236 | 2114206.96718 | 37.7844460622777 | -122.489426325065 | (37.7844460622777, -122.489426325065) | |||
24939 | 24939 | 143093 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 487 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6010518.569 | 2120277.0289 | 37.8024692600192 | -122.407783074103 | (37.8024692600192, -122.407783074103) | |||
24979 | 24979 | 177920 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989764.376630001 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | ||||
24990 | 24990 | 130764 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2672 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6000780.4951599995 | 2117576.2259299997 | 37.794503603424 | -122.441287648428 | (37.794503603424, -122.441287648428) | |||
24993 | 24993 | 205648 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 146 Forest Hill Path | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994467.18853 | 2101084.43805 | 37.7488598520055 | -122.461935856854 | (37.7488598520055, -122.461935856854) | |||
25022 | 25022 | 231947 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.73712794050989 | -122.42510507394199 | (37.7371279405099, -122.425105073942) | |||
25026 | 25026 | 124921 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Maple St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5996572.93556 | 2115696.21149 | 37.789101010747 | -122.455710282907 | (37.789101010747, -122.455710282907) | |||
25031 | 25031 | 126107 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2520 Baker St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5999698.94271 | 2117540.8900200003 | 37.794344910846206 | -122.44502739999201 | (37.7943449108462, -122.445027399992) | |||
25036 | 25036 | 127225 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999606.34401 | 2117712.3673 | 37.7948104565905 | -122.44536013655501 | (37.7948104565905, -122.445360136555) | |||
25069 | 25069 | 219107 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1950 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5993858.1687 | 2102183.92132 | 37.751843672172704 | -122.464121636607 | (37.7518436721727, -122.464121636607) | |||
25078 | 25078 | 238351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 737 Sanchez St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003693.255030001 | 2104105.37257 | 37.7576814602529 | -122.43024762673001 | (37.7576814602529, -122.43024762673) | |||
25079 | 25079 | 204442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.743367092409294 | -122.472569777984 | (37.7433670924093, -122.472569777984) | |||
25100 | 25100 | 205364 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 250 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994743.5494800005 | 2100407.30657 | 37.747016525988705 | -122.460931137866 | (37.7470165259887, -122.460931137866) | |||
25105 | 25105 | 189974 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 875 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6011341.45696 | 2104259.23548 | 37.75853416774461 | -122.40380768986999 | (37.7585341677446, -122.40380768987) | |||
25120 | 25120 | 206614 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.45992114704399 | (37.7468396428317, -122.459921147044) | |||
25162 | 25162 | 120283 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 139 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988317.15466 | 2115062.63745 | 37.786884157218 | -122.484227400222 | (37.786884157218, -122.484227400222) | ||||
25172 | 25172 | 236015 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 310 Liberty St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6004218.97965 | 2103943.63081 | 37.757267119188796 | -122.42841792725001 | (37.7572671191888, -122.42841792725) | |||
25204 | 25204 | 209684 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1853 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991553.70129 | 2102821.79388 | 37.7534620165755 | -122.472137217586 | (37.7534620165755, -122.472137217586) | |||
25205 | 25205 | 195981 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6018524.13374 | 2099557.3325900002 | 37.746022348857295 | -122.37864001312799 | (37.7460223488573, -122.378640013128) | ||||
25231 | 25231 | 140921 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 150 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5996579.2478 | 2113360.6701 | 37.7826885995813 | -122.455519569028 | (37.7826885995813, -122.455519569028) | |||
25262 | 25262 | 237451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000528.815780001 | 2101672.95433 | 37.7508228849759 | -122.441017024421 | (37.7508228849759, -122.441017024421) | |||
25266 | 25266 | 215207 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993414.72395 | 2095618.6966 | 37.7337916535606 | -122.465178304956 | (37.7337916535606, -122.465178304956) | |||
25275 | 25275 | 212516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1845 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5992439.35548 | 2095372.08993 | 37.7330582393366 | -122.468532478509 | (37.7330582393366, -122.468532478509) | |||
25276 | 25276 | 183998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5984888.9105 | 2103901.6725 | 37.756039119583896 | -122.495264775736 | (37.7560391195839, -122.495264775736) | |||
25277 | 25277 | 210945 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5996140.80305 | 2088701.9398299998 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | ||||
25285 | 25285 | 123524 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 2828 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 5994582.70338 | 2110216.80029 | 37.7739416046925 | -122.46219863345199 | (37.7739416046925, -122.462198633452) | |||
25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
25300 | 25300 | 117795 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3755 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983918.45231 | 2111030.33934 | 37.7755555482917 | -122.499147602329 | (37.7755555482917, -122.499147602329) | |||
25309 | 25309 | 184952 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1990 41st Ave | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5983556.4384 | 2101472.9274 | 37.749292356781794 | -122.49969333533701 | (37.7492923567818, -122.499693335337) | |||
25325 | 25325 | 213664 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994722.94591 | 2098926.36641 | 37.7429490497558 | -122.460895067856 | (37.7429490497558, -122.460895067856) | |||
25337 | 25337 | 250803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | |||
25340 | 25340 | 199360 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1451 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012046.6036 | 2101626.2388 | 37.7513439035983 | -122.401183943899 | (37.7513439035983, -122.401183943899) | ||||
25344 | 25344 | 122178 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 14th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991537.96133 | 2113933.9799 | 37.7839721798897 | -122.47300192398501 | (37.7839721798897, -122.473001923985) | |||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
25383 | 25383 | 215678 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 485 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993337.59359 | 2099437.5964200003 | 37.744272947131 | -122.465722330041 | (37.744272947131, -122.465722330041) | |||
25388 | 25388 | 203818 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1615 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993134.0104 | 2095339.6445 | 37.7330092541688 | -122.466128535825 | (37.7330092541688, -122.466128535825) | |||
25415 | 25415 | 209553 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 95 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5993698.07886 | 2101380.70554 | 37.7496290187806 | -122.46461692652599 | (37.7496290187806, -122.464616926526) | |||
25444 | 25444 | 198476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6015193.91802 | 2104744.93458 | 37.7600822588968 | -122.390517973622 | (37.7600822588968, -122.390517973622) | |||
25451 | 25451 | 218361 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993708.26635 | 2100090.28038 | 37.746086426450894 | -122.46448801411199 | (37.7460864264509, -122.464488014112) | |||
25453 | 25453 | 214924 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 21 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995755.7199 | 2100107.06397 | 37.7462503243014 | -122.457409444002 | (37.7462503243014, -122.457409444002) | |||
25462 | 25462 | 250940 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987097.72783 | 2114420.3103099996 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | |||
25464 | 25464 | 213655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994743.32278 | 2099041.60515 | 37.7432666390437 | -122.460832960696 | (37.7432666390437, -122.460832960696) | |||
25478 | 25478 | 213643 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999510.3328 | 2096092.78198 | 37.73544300577971 | -122.44413809190901 | (37.7354430057797, -122.444138091909) | |||
25481 | 25481 | 198281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017868.75025 | 2099595.89007 | 37.7460920687928 | -122.380908946009 | (37.7460920687928, -122.380908946009) | |||
25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
25493 | 25493 | 207183 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995337.35676 | 2098242.98475 | 37.7411079873364 | -122.458721155571 | (37.7411079873364, -122.458721155571) | |||
25518 | 25518 | 203700 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 75 Farnsworth Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5996532.95426 | 2106404.6778599997 | 37.7635866003516 | -122.455176893212 | (37.7635866003516, -122.455176893212) | |||
25523 | 25523 | 140930 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 118 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5996567.4031 | 2113640.2065 | 37.7834554526548 | -122.455580757548 | (37.7834554526548, -122.455580757548) | |||
25544 | 25544 | 125658 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 481 Polk St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6007176.96722 | 2112501.79124 | 37.7809327473806 | -122.418794957434 | (37.7809327473806, -122.418794957434) | |||
25554 | 25554 | 219562 | Undocumented 2 | Ulmus americana :: American Elm 119 | 474 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993376.84863 | 2099471.9511 | 37.7443695406169 | -122.465589090967 | (37.7443695406169, -122.465589090967) | |||
25587 | 25587 | 228713 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6001884.184859999 | 2108235.8291 | 37.7689200513416 | -122.436799796678 | (37.7689200513416, -122.436799796678) | |||
25588 | 25588 | 213562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 145 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996449.59751 | 2094511.04667 | 37.7309248558938 | -122.454605908258 | (37.7309248558938, -122.454605908258) | |||
25589 | 25589 | 178865 | Undocumented 2 | Prunus persica :: Peach 330 | 1260 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6000973.92591 | 2087218.6697900002 | 37.711160097322995 | -122.438442319358 | (37.711160097323, -122.438442319358) | |||
25591 | 25591 | 211573 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 38 San Fernando Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5992093.28359 | 2096279.5496599998 | 37.735529899171794 | -122.469794973768 | (37.7355298991718, -122.469794973768) | |||
25593 | 25593 | 215447 | Undocumented 2 | Ulmus americana :: American Elm 119 | 110 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992597.98393 | 2095879.53795 | 37.7344607266837 | -122.468020961215 | (37.7344607266837, -122.468020961215) | |||
25600 | 25600 | 218110 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 70 Lopez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5993948.55319 | 2100516.17746 | 37.7472696806615 | -122.463688045574 | (37.7472696806615, -122.463688045574) | |||
25618 | 25618 | 241059 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6005916.7260300005 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) |
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");