Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 2196 | 2196 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 90158 | 90158 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 122098 | 122098 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 86608 | 86608 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | |||
| 98898 | 98898 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 2 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 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) | |
| 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) | |
| 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) | |
| 138618 | 138618 | 114405 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 86962 | 86962 | 114103 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 118949 | 118949 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 91565 | 91565 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 138436 | 138436 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 11055 | 11055 | 116459 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 10x20 | Permit Number 777772 | 5989848.42836 | 2088633.8329099999 | 37.7144066723949 | -122.476997704287 | (37.7144066723949, -122.476997704287) | ||
| 119511 | 119511 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 314 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 28447 | 28447 | 116579 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 93221 | 93221 | 106514 | Significant Tree 6 | Tree(s) :: 17 | 190 EUCALYPTUS DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | |||||
| 99170 | 99170 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 49231 | 49231 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 113067 | 113067 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||
| 111867 | 111867 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
| 124187 | 124187 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
| 11052 | 11052 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3X10 | Permit Number 778829 | 5992111.480830001 | 2087185.8440900003 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | ||
| 106567 | 106567 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 170 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | |||
| 88059 | 88059 | 88281 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51275 | 5993125.0 | 2098282.0 | 37.7410877064311 | -122.466373457073 | (37.7410877064311, -122.466373457073) | ||
| 98089 | 98089 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1860 09TH AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494.0 | 2102835.0 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | ||
| 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) | ||||
| 88225 | 88225 | 104494 | Significant Tree 6 | Acer circinatum :: Vine Maple 379 | 171 SAN MARCOS AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770388 | 5993514.0 | 2100282.0 | 37.7466016393389 | -122.465173679454 | (37.7466016393389, -122.465173679454) | ||||
| 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) | ||
| 80520 | 80520 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | ||||
| 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) | ||
| 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) | ||
| 88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
| 79722 | 79722 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788.0 | 2100441.0 | 37.7470540096767 | -122.46423776520399 | (37.7470540096767, -122.464237765204) | |||
| 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) | ||||
| 2848 | 2848 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 270 Castenada Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3147 | 3147 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | ||
| 109474 | 109474 | 98302 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 141630 | 141630 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | |||||
| 118550 | 118550 | 104037 | Significant Tree 6 | Tree(s) :: 17 | 520X Oak Park Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995008.5 | 2103700.7 | 37.756074592877496 | -122.46025354267599 | (37.7560745928775, -122.460253542676) | |||||
| 95122 | 95122 | 91107 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208.0 | 2110277.0 | 37.774142880877704 | -122.46004000497801 | (37.7741428808777, -122.460040004978) | ||
| 96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 118056 | 118056 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 89893 | 89893 | 111037 | Significant Tree 6 | Magnolia spp :: Magnolia 89 | 3991-3997 Washington St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | |||||
| 114812 | 114812 | 100474 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 164 | 930 Monterey Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.45688058924699 | (37.7312506649165, -122.456880589247) | |||||
| 117755 | 117755 | 107142 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 2694 MCALLISTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996297.4 | 2110789.6 | 37.7756129427938 | -122.45630867288999 | (37.7756129427938, -122.45630867289) | ||||
| 140306 | 140306 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 124304 | 124304 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 301 Hazelwood Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 143196 | 143196 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 99011 | 99011 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 3524 Jackson St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||||
| 58944 | 58944 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 1409 | 1409 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 146331 | 146331 | 91111 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 111811 | 111811 | 112770 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 100317 | 100317 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998153.40008835 | 2095558.62470631 | 37.733898832504295 | -122.448791034412 | (37.7338988325043, -122.448791034412) | |||||
| 83219 | 83219 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5998663.3699 | 2115944.3199400003 | 37.789901994506 | -122.44849555223101 | (37.789901994506, -122.448495552231) | |||||
| 183483 | 183483 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | ||
| 3799 | 3799 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.722847017548204 | -122.44673211618999 | (37.7228470175482, -122.44673211619) | |||
| 139394 | 139394 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 93355 | 93355 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
| 49634 | 49634 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 79568 | 79568 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 2 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 144323 | 144323 | 115460 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/02/2016 12:00:00 AM | 3 | Permit Number 776150 | 5999012.8 | 2102131.7 | 37.7519960240451 | -122.446292521132 | (37.7519960240451, -122.446292521132) | ||
| 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) | ||||
| 81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 1646 | 1646 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1609 | 1609 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1637 | 1637 | 251619 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 1623 | 1623 | 251613 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 60R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1651 | 1651 | 251609 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 1616 | 1616 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1611 | 1611 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 48R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999482.0 | 2100041.0 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | |||||
| 1608 | 1608 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999509.0 | 2100035.0 | 37.746267320465705 | -122.444425925791 | (37.7462673204657, -122.444425925791) | |||||
| 1025 | 1025 | 251425 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 5016 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | |||||
| 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) | |||
| 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) | |||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 84673 | 84673 | 110840 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | |||||
| 110611 | 110611 | 121178 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 990x Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 6000056.0 | 2099639.0 | 37.7452111944111 | -122.442506045398 | (37.7452111944111, -122.442506045398) | |||
| 3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
| 2169 | 2169 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2712 | 2712 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 4450 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 0ft | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | ||||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 107216 | 107216 | 121169 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 900x Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 6000584.0 | 2099647.0 | 37.745263242779004 | -122.44068088983101 | (37.745263242779, -122.440680889831) |
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");