Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, 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) | |||
| 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) | |||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 395 | 395 | 249557 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005881.27559 | 2115126.52616 | 37.788066583556706 | -122.423464052238 | (37.7880665835567, -122.423464052238) | |
| 404 | 404 | 249555 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.787898211588704 | -122.423418809148 | (37.7878982115887, -122.423418809148) | |
| 406 | 406 | 249556 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005884.0832400005 | 2115105.79396 | 37.7880098165527 | -122.423452863778 | (37.7880098165527, -122.423452863778) | |
| 413 | 413 | 249558 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005877.98213 | 2115146.79048 | 37.7881220384566 | -122.42347688825899 | (37.7881220384566, -122.423476888259) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 827 | 827 | 191800 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 5 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.739438732322704 | -122.37827876085301 | (37.7394387323227, -122.378278760853) | |
| 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) | ||
| 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) | ||
| 1165 | 1165 | 249373 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 649 Jones St | 1 | : 4 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.1661400003 | 37.78713740130579 | -122.4133182966 | (37.7871374013058, -122.4133182966) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
| 24334 | 24334 | 246922 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 417 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 5997854.3485 | 2107475.00928 | 37.7666011818151 | -122.45068380291 | (37.7666011818151, -122.45068380291) | |||
| 24628 | 24628 | 193040 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1890 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | |||
| 24639 | 24639 | 229283 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 12 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010503.18066 | 2104324.48808 | 37.758666470594896 | -122.40671143888099 | (37.7586664705949, -122.406711438881) | |||
| 24687 | 24687 | 188070 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6012192.04216 | 2096531.53608 | 37.737363051155796 | -122.400323196466 | (37.7373630511558, -122.400323196466) | |||
| 25112 | 25112 | 192821 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 674 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013431.41739 | 2113070.8325900002 | 37.782845374266 | -122.39719749747101 | (37.782845374266, -122.397197497471) | |||
| 25775 | 25775 | 188897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 837 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012777.55941 | 2103554.0520599997 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | |||
| 25860 | 25860 | 246929 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 349 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5998314.74139 | 2107540.20293 | 37.7668065294199 | -122.44909608851201 | (37.7668065294199, -122.449096088512) | |||
| 25909 | 25909 | 228896 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 125 Haight St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005449.71206 | 2109571.37843 | 37.772789143445294 | -122.424561878921 | (37.7727891434453, -122.424561878921) | |||
| 25959 | 25959 | 199626 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 468 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014046.309230001 | 2104968.95995 | 37.76063365303771 | -122.39450272031901 | (37.7606336530377, -122.394502720319) | |||
| 26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
| 26235 | 26235 | 194704 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 656 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6012976.97974 | 2104015.65385 | 37.7579565790575 | -122.39813418994801 | (37.7579565790575, -122.398134189948) | |||
| 26321 | 26321 | 247172 | Undocumented 2 | Malus :: Crab Apple 235 | 145 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001372.05344 | 2108496.3443400003 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | |||
| 26347 | 26347 | 201129 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1401 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6014506.80951 | 2101043.19718 | 37.749879938626 | -122.39263542020399 | (37.749879938626, -122.392635420204) | |||
| 26445 | 26445 | 195159 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1190 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011918.3427099995 | 2102871.98584 | 37.7547572966145 | -122.40171504034201 | (37.7547572966145, -122.401715040342) | |||
| 26551 | 26551 | 247735 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6001364.01922 | 2108734.36535 | 37.770259331626896 | -122.43863473741199 | (37.7702593316269, -122.438634737412) | |||
| 26680 | 26680 | 234541 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 380 Valencia St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6006086.8772 | 2107446.3407400004 | 37.766990260030106 | -122.422206845872 | (37.7669902600301, -122.422206845872) | |||
| 26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
| 26842 | 26842 | 249462 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6006460.85988 | 2113718.34687 | 37.784232765583 | -122.42135874831499 | (37.784232765583, -122.421358748315) | |||
| 26928 | 26928 | 229277 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6010526.84052 | 2103899.06003 | 37.7574996640945 | -122.406599632462 | (37.7574996640945, -122.406599632462) | |||
| 26970 | 26970 | 229279 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 6 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010520.0881199995 | 2103990.76889 | 37.757751098346894 | -122.406629447707 | (37.7577510983469, -122.406629447707) | |||
| 27082 | 27082 | 193812 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 596 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6014080.0948 | 2104357.2434 | 37.75895589042771 | -122.39434303940399 | (37.7589558904277, -122.394343039404) | |||
| 27095 | 27095 | 250526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5987725.00409 | 2115456.85695 | 37.787932075559794 | -122.48630503096001 | (37.7879320755598, -122.48630503096) | |||
| 27111 | 27111 | 193054 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1998 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013745.9771300005 | 2099978.99313 | 37.7469155761867 | -122.39519189779499 | (37.7469155761867, -122.395191897795) | |||
| 27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
| 27608 | 27608 | 193063 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 20 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6015045.87298 | 2098929.39678 | 37.7441058081384 | -122.39062360620399 | (37.7441058081384, -122.390623606204) | |||
| 27797 | 27797 | 193506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 559 Texas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013849.93104 | 2104490.9158099997 | 37.7593101288798 | -122.395148422779 | (37.7593101288798, -122.395148422779) | |||
| 28090 | 28090 | 189890 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016847.575680001 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | |||
| 28141 | 28141 | 189133 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 1451 19th St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013351.15838 | 2105193.33432 | 37.761211066357205 | -122.396922680856 | (37.7612110663572, -122.396922680856) | |||
| 28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
| 28240 | 28240 | 201168 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 30 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015234.89257 | 2098788.2579099997 | 37.7437287547683 | -122.38996015566099 | (37.7437287547683, -122.389960155661) | |||
| 28714 | 28714 | 193502 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 612 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6012667.6634599995 | 2104536.12346 | 37.7593684409261 | -122.39924047836399 | (37.7593684409261, -122.399240478364) | |||
| 28807 | 28807 | 192846 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 360 03rd St | 4 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013234.4384699995 | 2113062.86242 | 37.782812522018496 | -122.39787840748501 | (37.7828125220185, -122.397878407485) | |||
| 28870 | 28870 | 193050 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1940 Evans Ave | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013815.46024 | 2099929.58477 | 37.7467837751701 | -122.39494816981701 | (37.7467837751701, -122.394948169817) | |||
| 28877 | 28877 | 188060 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1241 Evans Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017512.496169999 | 2097088.9484700002 | 37.7391888439962 | -122.381966489387 | (37.7391888439962, -122.381966489387) | |||
| 29065 | 29065 | 234039 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 93 Scott St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6002347.866230001 | 2108745.44445 | 37.770345671048204 | -122.435232412346 | (37.7703456710482, -122.435232412346) | |||
| 29147 | 29147 | 191581 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 29 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6015243.91638 | 2097975.462 | 37.741497485528896 | -122.389872190262 | (37.7414974855289, -122.389872190262) | |||
| 29418 | 29418 | 247623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 261 Bradford St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6009541.508359999 | 2097060.7150400002 | 37.738667903594205 | -122.409524699022 | (37.7386679035942, -122.409524699022) | |||
| 29466 | 29466 | 250525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 5987725.71266 | 2115440.30097 | 37.7878866588866 | -122.486301363544 | (37.7878866588866, -122.486301363544) | |||
| 29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
| 29840 | 29840 | 246959 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2173 15th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6003061.26496 | 2107089.31896 | 37.7658388409276 | -122.43264645046699 | (37.7658388409276, -122.432646450467) | |||
| 29985 | 29985 | 193072 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 37 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015318.00876 | 2098725.46335 | 37.7435609430974 | -122.38966837242201 | (37.7435609430974, -122.389668372422) | |||
| 30229 | 30229 | 247702 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6001763.91466 | 2108760.8160200003 | 37.770354699327 | -122.43725339763701 | (37.770354699327, -122.437253397637) | |||
| 30460 | 30460 | 188821 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1360 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6011964.420059999 | 2102037.47464 | 37.7524684824455 | -122.40149704467 | (37.7524684824455, -122.40149704467) | |||
| 30480 | 30480 | 193101 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1224 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6017385.96084 | 2096915.0483 | 37.7387043603066 | -122.382391900165 | (37.7387043603066, -122.382391900165) | |||
| 30598 | 30598 | 247170 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6001370.95103 | 2108474.04291 | 37.7695449452612 | -122.438592105046 | (37.7695449452612, -122.438592105046) | |||
| 30622 | 30622 | 234040 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 93 Scott St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6002349.12315 | 2108730.6280900002 | 37.7703050603571 | -122.43522700473301 | (37.7703050603571, -122.435227004733) | |||
| 30636 | 30636 | 193062 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014912.025280001 | 2099027.7617599997 | 37.7443684713257 | -122.391093299634 | (37.7443684713257, -122.391093299634) | |||
| 30640 | 30640 | 201159 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 9 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014843.2374599995 | 2099080.51228 | 37.7445094958311 | -122.39133484225 | (37.7445094958311, -122.39133484225) | |||
| 30679 | 30679 | 188074 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 13 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6012318.61445 | 2096437.2512599998 | 37.7371112221076 | -122.399878955661 | (37.7371112221076, -122.399878955661) | |||
| 30711 | 30711 | 247235 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 49 Castro St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6002189.582769999 | 2108332.3938700003 | 37.7692025463843 | -122.435750357108 | (37.7692025463843, -122.435750357108) | |||
| 30749 | 30749 | 247700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6001801.87342 | 2108765.96342 | 37.7703709905579 | -122.43712246712099 | (37.7703709905579, -122.437122467121) | |||
| 30830 | 30830 | 193060 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6014829.68404 | 2099091.25794 | 37.744538248958605 | -122.39138245865699 | (37.7445382489586, -122.391382458657) | |||
| 30898 | 30898 | 193032 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1995 Evans Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013856.76211 | 2099814.34392 | 37.746469644669105 | -122.394797281563 | (37.7464696446691, -122.394797281563) | |||
| 31134 | 31134 | 246971 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002932.26985 | 2106723.06084 | 37.7648258688387 | -122.433066446456 | (37.7648258688387, -122.433066446456) | |||
| 31149 | 31149 | 247701 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Waller St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6001785.70024 | 2108763.50636 | 37.770363324741794 | -122.43717823411001 | (37.7703633247418, -122.43717823411) | |||
| 31173 | 31173 | 225996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 47 Octavia St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005638.67194 | 2109514.80428 | 37.7726444739859 | -122.423904220905 | (37.7726444739859, -122.423904220905) | |||
| 31300 | 31300 | 200349 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014526.629869999 | 2097016.7538700001 | 37.738825266977294 | -122.392285304228 | (37.7388252669773, -122.392285304228) | |||
| 31354 | 31354 | 194737 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013962.08957 | 2105226.07234 | 37.7613349452796 | -122.394812007068 | (37.7613349452796, -122.394812007068) | |||
| 31382 | 31382 | 249379 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 774 Geary St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6008031.48613 | 2114489.63478 | 37.786438961746505 | -122.415979559602 | (37.7864389617465, -122.415979559602) | |||
| 31843 | 31843 | 247696 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Central Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5999969.16959 | 2108614.08966 | 37.769849637370896 | -122.443450859673 | (37.7698496373709, -122.443450859673) | |||
| 31894 | 31894 | 193038 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1925 Evans Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013953.00674 | 2099743.1247 | 37.7462794425459 | -122.39445948992399 | (37.7462794425459, -122.394459489924) | |||
| 32350 | 32350 | 246968 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 298 Noe St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6002885.77984 | 2106576.3697599997 | 37.764420453563105 | -122.43321676096201 | (37.7644204535631, -122.433216760962) | |||
| 32351 | 32351 | 189916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1771 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013954.80906 | 2095907.8137599998 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | |||
| 32444 | 32444 | 250071 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1520 Gough St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005405.66402 | 2115050.94063 | 37.787832188740396 | -122.425104206101 | (37.7878321887404, -122.425104206101) | |||
| 32533 | 32533 | 201128 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1401 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014473.96426 | 2101041.60815 | 37.7498737512866 | -122.39274889036301 | (37.7498737512866, -122.392748890363) |
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");