Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 188702 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Evans Ave | 2 | : 4 | Tree 1 | DPW 2 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | |||
| 7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 516 | 516 | 188685 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300 Evans Ave | 14 | : 4 | Tree 1 | DPW 2 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.857919999 | 2096944.2017700002 | 37.738810795988606 | -122.38074156686301 | (37.7388107959886, -122.380741566863) | ||
| 576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
| 586 | 586 | 237035 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | ||
| 596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
| 622 | 622 | 237036 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.053180001 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | ||
| 643 | 643 | 239154 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 6 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387848999 | (37.773736235682, -122.42371387849) | ||
| 652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
| 661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
| 663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
| 665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
| 666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
| 715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
| 748 | 748 | 195045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 312 06th St | 1 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010980.17572 | 2111476.79231 | 37.7783317443601 | -122.40556550564501 | (37.7783317443601, -122.405565505645) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 808 | 808 | 193091 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 1 | : 4 | Tree 1 | DPW 2 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.6759099998 | 37.7400464320877 | -122.38515006152201 | (37.7400464320877, -122.385150061522) | ||
| 840 | 840 | 193039 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1800 Evans Ave | 10 | : 4 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 5 | Width 4ft | 6014331.82546 | 2099544.27863 | 37.7457545046729 | -122.39313565907699 | (37.7457545046729, -122.393135659077) | ||
| 1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
| 1127 | 1127 | 188687 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 30 | : 4 | Tree 1 | DPW 2 | 03/18/2017 12:53:00 PM | 3 | Width 4ft | 6017556.40659 | 2097171.27575 | 37.7394173230594 | -122.381820390005 | (37.7394173230594, -122.381820390005) | ||
| 1132 | 1132 | 188688 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 37 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816543996 | -122.382223941884 | (37.739646816544, -122.382223941884) | ||
| 1134 | 1134 | 188691 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 45 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.740314314066296 | -122.38339440233999 | (37.7403143140663, -122.38339440234) | ||
| 1139 | 1139 | 188692 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 46 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | ||
| 1145 | 1145 | 188690 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1300 Evans Ave | 44 | : 4 | Tree 1 | DPW 2 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | ||
| 1158 | 1158 | 190438 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1350 Evans Ave | 4 | : 4 | Tree 1 | DPW 2 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.740742144938395 | -122.38415488076001 | (37.7407421449384, -122.38415488076) | ||
| 1167 | 1167 | 190439 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1350 Evans Ave | 6 | : 4 | Tree 1 | DPW 2 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.740810800972206 | -122.384272247659 | (37.7408108009722, -122.384272247659) | ||
| 1168 | 1168 | 218199 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Ulloa St | 1 | : 4 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.46559677389799 | (37.740714236277, -122.465596773898) | |||
| 1173 | 1173 | 190143 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1200 Fairfax Ave | 7 | : 4 | Tree 1 | DPW 2 | 03/18/2017 10:47:00 AM | 3 | Width 4ft | 6017523.521480001 | 2096815.65975 | 37.738439056714704 | -122.381909364434 | (37.7384390567147, -122.381909364434) | ||
| 1541 | 1541 | 196583 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010636.210390001 | 2110621.8756 | 37.7759651028325 | -122.406695151275 | (37.7759651028325, -122.406695151275) | |||
| 1544 | 1544 | 196581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | : 4 | Tree 1 | DPW 2 | 10 | Width 3ft | 6010649.28152 | 2110608.88242 | 37.77593015789721 | -122.40664901875 | (37.7759301578972, -122.40664901875) | |||
| 1554 | 1554 | 196582 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010641.65206 | 2110616.23142 | 37.7759499096844 | -122.40667592917801 | (37.7759499096844, -122.406675929178) | |||
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
| 2381 | 2381 | 201818 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.4173400002 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | ||
| 2409 | 2409 | 201824 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 8 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.603680001 | 2093212.5880900002 | 37.728737329640495 | -122.369624404053 | (37.7287373296405, -122.369624404053) | ||
| 2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
| 2438 | 2438 | 201823 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 7 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.728794732485206 | -122.369559269737 | (37.7287947324852, -122.369559269737) | ||
| 2514 | 2514 | 246848 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001221.8841699995 | 2109765.97896 | 37.773083798207296 | -122.439200331843 | (37.7730837982073, -122.439200331843) | |||
| 2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
| 2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
| 2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
| 2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
| 2546 | 2546 | 246846 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.773202168766105 | -122.43925359959101 | (37.7732021687661, -122.439253599591) | |||
| 2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
| 2553 | 2553 | 246842 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : 4 | Tree 1 | DPW for City Agency 10 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | |||
| 2554 | 2554 | 246844 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : 4 | Tree 1 | DPW for City Agency 10 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.773282406297895 | -122.439268674924 | (37.7732824062979, -122.439268674924) | |||
| 2946 | 2946 | 228442 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 413 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | ||
| 2970 | 2970 | 228443 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 401 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.42901857547301 | (37.7722283522845, -122.429018575473) | ||
| 2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
| 3025 | 3025 | 228441 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 419 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | ||
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 3210 | 3210 | 194747 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1580 Burke Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016181.61808 | 2099214.241 | 37.74495087589921 | -122.386716274933 | (37.7449508758992, -122.386716274933) | |||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3247 | 3247 | 188481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 10 | : 4 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.744701017238796 | -122.38630272799999 | (37.7447010172388, -122.386302728) | ||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
| 22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
| 22878 | 22878 | 211497 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991316.04145 | 2093239.9376700001 | 37.7271389322076 | -122.472260663898 | (37.7271389322076, -122.472260663898) | |||
| 22880 | 22880 | 230389 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 51 13th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.41515479496701 | (37.7693998171644, -122.415154794967) | |||
| 22911 | 22911 | 238577 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 133 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | |||
| 23411 | 23411 | 195158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1188 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | |||
| 23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 23436 | 23436 | 187515 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012570.47183 | 2088125.85933 | 37.7143038745038 | -122.398425150324 | (37.7143038745038, -122.398425150324) | |||
| 23455 | 23455 | 194596 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 800 Wisconsin St | 7 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012720.64304 | 2103613.2936299997 | 37.7568375049672 | -122.398992475934 | (37.7568375049672, -122.398992475934) | |||
| 23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 23483 | 23483 | 234406 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 147 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6006058.10348 | 2108951.831 | 37.7711223543454 | -122.422413351811 | (37.7711223543454, -122.422413351811) | |||
| 23494 | 23494 | 219849 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Skyview Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997939.73785 | 2101790.86322 | 37.7509988274335 | -122.449978746126 | (37.7509988274335, -122.449978746126) | |||
| 23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
| 23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
| 23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
| 23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
| 23570 | 23570 | 250043 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.787002430166396 | -122.422547022523 | (37.7870024301664, -122.422547022523) | |||
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23603 | 23603 | 231527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 127 Scott St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6002315.440669999 | 2108966.67057 | 37.7709512619163 | -122.435360399361 | (37.7709512619163, -122.435360399361) | |||
| 23608 | 23608 | 210892 | Undocumented 2 | Paulownia tomentosa :: Empress Tree 332 | 210 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992474.84263 | 2089237.23886 | 37.7162154959333 | -122.467963716667 | (37.7162154959333, -122.467963716667) | |||
| 23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
| 23679 | 23679 | 191569 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6015206.39657 | 2097489.64193 | 37.7401614427971 | -122.38996799323401 | (37.7401614427971, -122.389967993234) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 23726 | 23726 | 192170 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601 Kansas St | 9 | : 4 | Tree 1 | Private 1 | 51 | Width 7ft | 6011813.79085 | 2100866.0430099997 | 37.749243580141204 | -122.40193560806001 | (37.7492435801412, -122.40193560806) | |||
| 23741 | 23741 | 234546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 390 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | |||
| 23764 | 23764 | 197793 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 66 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | |||
| 23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 23879 | 23879 | 193824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.742145929985796 | -122.388466689285 | (37.7421459299858, -122.388466689285) | |||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 23940 | 23940 | 190941 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1701 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.733476418703496 | -122.39409234708599 | (37.7334764187035, -122.394092347086) | |||
| 23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
| 23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) |
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");