Street_Tree_List

Data source: data.sfgov.org

10,815 rows where qSiteInfo = 9 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qCaretaker, qCareAssistant

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189128 189128 176796 Undocumented 2 Juniperus chinensis :: Juniper 19 103 Bowdoin St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6008486.43054 2094496.74036 37.7315686095034 -122.41299143261001 (37.7315686095034, -122.41299143261)
189127 189127 131863 Undocumented 2 Olea europaea :: Olive Tree 41 3640 Lyon St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5998876.58216 2121318.22377 37.8046694831589 -122.448144966435 (37.8046694831589, -122.448144966435)
189113 189113 123119 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 574 11th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 3ft   5992561.79357 2111542.7313099997 37.7774656852602 -122.469285763443 (37.7774656852602, -122.469285763443)
189112 189112 187998 Undocumented 2 Aloe barberae :: Tree aloe 350 2211 25th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6012098.53804 2101850.00675 37.7519612189539 -122.40102006852501 (37.7519612189539, -122.401020068525)
189099 189099 209379 Undocumented 2 Maytenus boaria :: Mayten 22 1472 16th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5991194.711759999 2105382.04286 37.7604710034619 -122.47356540841601 (37.7604710034619, -122.473565408416)
189045 189045 219314 Undocumented 2 Juniperus chinensis :: Juniper 19 322 Havelock St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 2ft   5998659.44994 2092940.88551 37.726740062192796 -122.44685317305 (37.7267400621928, -122.44685317305)
189043 189043 210132 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 360 Flood Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 4ft   5998258.462669999 2094123.67501 37.7299648080121 -122.44832450527299 (37.7299648080121, -122.448324505273)
189042 189042 178219 Undocumented 2 Pinus radiata :: Monterey Pine 3 49 Santos St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44 Width 6ft   6006726.5178 2087416.33462 37.712028383779895 -122.41857390945499 (37.7120283837799, -122.418573909455)
189036 189036 197848 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6012012.98096 2091233.72895 37.722806384392 -122.400570254626 (37.722806384392, -122.400570254626)
189023 189023 238388 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Collingwood St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6001986.47657 2105431.50433 37.7612258754818 -122.436245259426 (37.7612258754818, -122.436245259426)
189009 189009 210872 Undocumented 2 Olea europaea :: Olive Tree 41 371 Staples Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   5997627.30354 2093781.8331900002 37.72899008680061 -122.450481853864 (37.7289900868006, -122.450481853864)
189008 189008 197555 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 200 Kansas St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 4ft   6011386.38473 2107363.2099 37.7670594952368 -122.403870728771 (37.7670594952368, -122.403870728771)
189002 189002 186741 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984866.449 2106632.432 37.7635357085517 -122.495543856208 (37.7635357085517, -122.495543856208)
188996 188996 181266 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 271 Leland Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6009541.56007 2087669.1100400002 37.712880535479 -122.40886209741001 (37.712880535479, -122.40886209741)
188987 188987 207327 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 48 Gaviota Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5998437.39477 2097397.71392 37.7389647688951 -122.44794154698401 (37.7389647688951, -122.447941546984)
188984 188984 132403 Undocumented 2 Pittosporum eugenioides :: Tarata 110 93 MacOndray Ln 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6008160.59399 2119098.20458 37.799100218256704 -122.415859337341 (37.7991002182567, -122.415859337341)
188976 188976 219246 Undocumented 2 Juniperus chinensis :: Juniper 19 628 Detroit St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5999461.66823 2095170.54845 37.732907993207604 -122.44424009212 (37.7329079932076, -122.44424009212)
188972 188972 187326 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2200 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985094.7578 2099652.5203 37.7443841605942 -122.494239713708 (37.7443841605942, -122.494239713708)
188967 188967 186602 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984723.2519 2104439.4316 37.7575059562709 -122.495877337913 (37.7575059562709, -122.495877337913)
188961 188961 203619 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 624 Congo St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   6000138.382019999 2095835.3347200002 37.7347719253748 -122.441948223841 (37.7347719253748, -122.441948223841)
188958 188958 179892 Undocumented 2 Taxus baccata :: Irish Yew 241 101 Dartmouth St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 5ft   6008521.95318 2093544.0453599999 37.728954707483 -122.41280129434799 (37.728954707483, -122.412801294348)
188957 188957 186755 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1200 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 0ft   5984869.1172 2106699.1363 37.763719016073104 -122.495539548031 (37.7637190160731, -122.495539548031)
188953 188953 133198 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 556 Pine St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 5ft   6011234.26177 2116330.1506 37.7916721266196 -122.40502834240101 (37.7916721266196, -122.405028342401)
188922 188922 178091 Undocumented 2 Phoenix dactylifera :: Date Palm 65 327 Maynard St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 8ft   6005482.9740699995 2093860.26389 37.7296519293885 -122.42332975108101 (37.7296519293885, -122.423329751081)
188920 188920 186056 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1901 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984841.3927 2102202.6369 37.7513712544474 -122.495303811437 (37.7513712544474, -122.495303811437)
188908 188908 179799 Undocumented 2 Taxus baccata :: Irish Yew 241 295 Foote Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5998244.59243 2088714.2047400002 37.7151108676608 -122.44798313434099 (37.7151108676608, -122.447983134341)
188901 188901 241286 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6011463.91629 2102032.72658 37.7524275057351 -122.403227546213 (37.7524275057351, -122.403227546213)
188876 188876 211485 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 284 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   5993784.87083 2089111.53675 37.7159459124541 -122.463426547006 (37.7159459124541, -122.463426547006)
188865 188865 123165 Undocumented 2 Acer palmatum :: Japanese Maple 175 575 10th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     5992806.49433 2111572.44641 37.7775614121646 -122.46844143239099 (37.7775614121646, -122.468441432391)
188858 188858 234104 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1100 San Jose Ave 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6004777.73384 2096671.97117 37.7373324202616 -122.425967914987 (37.7373324202616, -122.425967914987)
188847 188847 186087 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1901 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984862.8194 2101833.0892 37.7503578324165 -122.495202467563 (37.7503578324165, -122.495202467563)
188844 188844 132293 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 999 North Point St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 4ft   6005925.58045 2121359.44598 37.805183106669 -122.42375411867799 (37.805183106669, -122.423754118678)
188840 188840 197904 Undocumented 2 Taxus baccata :: Irish Yew 241 654 Minnesota St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   6015148.9916199995 2105385.9246 37.761839786886 -122.39071814834699 (37.761839786886, -122.390718148347)
188836 188836 180410 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2 Still St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6003389.548769999 2094727.9749900002 37.7319160967549 -122.43062883406601 (37.7319160967549, -122.430628834066)
188832 188832 129179 Undocumented 2 Juniperus chinensis :: Juniper 19 3298 Lyon St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     5998993.68481 2120160.70419 37.801497941247895 -122.44765634587601 (37.8014979412479, -122.447656345876)
188830 188830 118808 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 894 46th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5981738.117319999 2109674.1043 37.771703578835 -122.50658917067 (37.771703578835, -122.50658917067)
188808 188808 238600 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 237 Murray St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   6005691.958380001 2095367.93673 37.733803458053295 -122.42271436928002 (37.7338034580533, -122.42271436928)
188801 188801 176786 Undocumented 2 Juniperus chinensis :: Juniper 19 623 Avalon Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6004279.230330001 2092361.41636 37.725468416325 -122.427384490226 (37.725468416325, -122.427384490226)
188791 188791 177020 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 235 Vienna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6004327.3137300005 2092022.6110200002 37.724540851055 -122.42719414780599 (37.724540851055, -122.427194147806)
188788 188788 120393 Undocumented 2 Acacia longifolia :: Golden Wattle 140 735 24th Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     5988458.36945 2110846.11582 37.7753149980476 -122.48342961272499 (37.7753149980476, -122.483429612725)
188776 188776 184016 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984928.9415 2103759.2795 37.7556504914972 -122.49511583755199 (37.7556504914972, -122.495115837552)
188775 188775 246732 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 101 Ripley St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 8ft   6008546.25114 2099104.34804 37.7442234529633 -122.41311030320101 (37.7442234529633, -122.413110303201)
188774 188774 218226 Undocumented 2 Juniperus chinensis :: Juniper 19 100 Claremont Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 8ft   5993838.37632 2098869.25868 37.7427413081634 -122.46394949738199 (37.7427413081634, -122.463949497382)
188765 188765 192981 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 706 De Haro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012076.86726 2105068.00252 37.7607959195066 -122.40132113006901 (37.7607959195066, -122.401321130069)
188722 188722 224463 Undocumented 2 Ficus Spp. :: 253 998 York St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6009934.61987 2103458.53933 37.7562569422093 -122.408616703004 (37.7562569422093, -122.408616703004)
188700 188700 136706 Undocumented 2 Taxus baccata :: Irish Yew 241 1155 Greenwich St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6007368.03811 2119831.84665 37.8010700267201 -122.418653909561 (37.8010700267201, -122.418653909561)
188698 188698 126090 Undocumented 2 Cordyline australis :: Dracena Palm 141 3655 Fillmore St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6002053.3403 2120920.92624 37.803759698423704 -122.437123039118 (37.8037596984237, -122.437123039118)
188686 188686 228980 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1300 San Jose Ave 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6003436.04165 2095624.2228 37.7343796240226 -122.430532025653 (37.7343796240226, -122.430532025653)
188684 188684 117925 Undocumented 2 Citrus aurantifolia 'Bearss' :: Seedless Lime 268 611 41st Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   5983159.2558 2111596.2777400003 37.7770648850992 -122.501815685849 (37.7770648850992, -122.501815685849)
188677 188677 218227 Undocumented 2 Juniperus chinensis :: Juniper 19 100 Claremont Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5993831.45355 2098825.44748 37.742620614658 -122.463970254628 (37.742620614658, -122.463970254628)
188673 188673 197836 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011988.43693 2091314.7241 37.7230274116816 -122.40066078576099 (37.7230274116816, -122.400660785761)
188668 188668 179643 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 2 Valerton Ct 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6001011.57815 2091346.43493 37.7224961569611 -122.43860775683999 (37.7224961569611, -122.43860775684)
188654 188654 187293 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 76 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984957.6549 2098264.4538 37.740564881128 -122.494611469439 (37.740564881128, -122.494611469439)
188651 188651 185046 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2767 34th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985833.5409 2096575.126 37.7359776633696 -122.491458724203 (37.7359776633696, -122.491458724203)
188624 188624 210462 Undocumented 2 Morus alba :: White Mulberry 112 454 Vernon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   5992502.3983 2090855.8917099999 37.7206615147909 -122.46798614126001 (37.7206615147909, -122.46798614126)
188612 188612 185532 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2201 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984892.4425 2100088.2592 37.7455687399668 -122.49497139028999 (37.7455687399668, -122.49497139029)
188611 188611 206255 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 52 Burnside Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6001154.00638 2095758.6911 37.7346193023315 -122.43843137911001 (37.7346193023315, -122.43843137911)
188592 188592 246684 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 65 Randall St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 4ft   6004997.42528 2097597.83608 37.73988704974779 -122.425274204056 (37.7398870497478, -122.425274204056)
188589 188589 175861 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 791 Cayuga Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6001276.34794 2092342.96014 37.7252474475028 -122.43776384653499 (37.7252474475028, -122.437763846535)
188579 188579 211979 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Ulloa St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 4ft   5994076.7802 2098163.7348 37.74081785256279 -122.46307399209101 (37.7408178525628, -122.463073992091)
188576 188576 202247 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 1 Kalmanovitz St 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6013203.9034 2093250.1788700002 37.728409493486296 -122.39659474307501 (37.7284094934863, -122.396594743075)
188574 188574 120103 Undocumented 2 Ilex spp :: Holly Species 163 2551 Cabrillo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 3ft   5987706.88835 2110474.6605700003 37.77425132027 -122.486001854101 (37.77425132027, -122.486001854101)
188568 188568 124552 Undocumented 2 Cedrus atlantica :: Atlas Cedar 304 18 Palm Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 7ft   5995913.7095 2114356.4263299997 37.7853844674695 -122.45789411412599 (37.7853844674695, -122.457894114126)
188565 188565 185372 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2900 Wawona St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5983789.4975 2096821.8757 37.7365355115304 -122.498543910586 (37.7365355115304, -122.498543910586)
188529 188529 219331 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5991262.34027 2090458.54246 37.7194988020073 -122.472243643342 (37.7194988020073, -122.472243643342)
188524 188524 123164 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 567 10th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     5992805.53108 2111610.19032 37.7776649910865 -122.46844751130399 (37.7776649910865, -122.468447511304)
188515 188515 244006 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 784 Duncan St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 6ft   6001421.86529 2099722.71856 37.7455188265341 -122.43778912016501 (37.7455188265341, -122.437789120165)
188499 188499 210956 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 231 Staples Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     5998549.59415 2093771.8681599998 37.729015469285706 -122.447292722094 (37.7290154692857, -122.447292722094)
188492 188492 136636 Undocumented 2 Taxus baccata :: Irish Yew 241 91 Mayfair Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5997648.25188 2114482.46822 37.785830045164296 -122.45190224489401 (37.7858300451643, -122.451902244894)
188483 188483 219209 Undocumented 2 Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 317 Staples Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5998045.0231 2093771.86028 37.72898660285129 -122.449037054315 (37.7289866028513, -122.449037054315)
188467 188467 201641 Undocumented 2 Eucalyptus viminalis :: Manna Gum 356 101 Hunters Point Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 4ft   6018954.75158 2095601.04105 37.7351828849697 -122.376876573893 (37.7351828849697, -122.376876573893)
188456 188456 209274 Undocumented 2 Maytenus boaria :: Mayten 22 843 Detroit St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   5999418.05627 2095609.3886400003 37.7341104569356 -122.44442239640199 (37.7341104569356, -122.444422396402)
188442 188442 190912 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 649 Delancey St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6015785.04565 2113121.03731 37.7831139729835 -122.38905836406799 (37.7831139729835, -122.389058364068)
188429 188429 176661 Undocumented 2 Juniperus chinensis :: Juniper 19 81 Lamartine St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6002679.168269999 2094329.6984400002 37.73078224948971 -122.43305632191002 (37.7307822494897, -122.43305632191)
188419 188419 129470 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 45 MacOndray Ln 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6008463.14234 2119145.61201 37.799247391416394 -122.414815771241 (37.7992473914164, -122.414815771241)
188400 188400 205458 Undocumented 2 Cordyline australis :: Dracena Palm 141 616 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 10ft   5998045.01508 2095019.24382 37.7324116222802 -122.44912690827299 (37.7324116222802, -122.449126908273)
188388 188388 238394 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 30 Collingwood St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6001974.4587 2105696.43162 37.761952618548605 -122.436305784682 (37.7619526185486, -122.436305784682)
188383 188383 185911 Undocumented 2 Melaleuca spp :: Melaleuca spp 130 2000 Sunset Blvd 54 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985022.4959 2101389.2174 37.7491484291729 -122.49461758404499 (37.7491484291729, -122.494617584045)
188364 188364 197059 Undocumented 2 Pyrus spp :: Pear Tree 291 2000 18th St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6011675.5931400005 2105621.49354 37.76229328623621 -122.40274789282199 (37.7622932862362, -122.402747892822)
188348 188348 218225 Undocumented 2 Juniperus chinensis :: Juniper 19 100 Claremont Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 8ft   5993843.55646 2098914.16079 37.7428648966005 -122.463934844718 (37.7428648966005, -122.463934844718)
188341 188341 179203 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 145 Blythdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6005739.90981 2087176.84104 37.711315190823996 -122.42196691216101 (37.711315190824, -122.421966912161)
188328 188328 187066 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2600 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985157.4618 2096894.5962 37.73681531194929 -122.493819701365 (37.7368153119493, -122.493819701365)
188327 188327 185942 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 2001 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984826.9443 2101536.2304 37.7495406390981 -122.495304634302 (37.7495406390981, -122.495304634302)
188308 188308 209216 Undocumented 2 Maytenus boaria :: Mayten 22 160 Hernandez Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5995450.81694 2099665.49371 37.74502036470479 -122.458431796887 (37.7450203647048, -122.458431796887)
188307 188307 130455 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2800 Divisadero St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6000633.845509999 2117965.67172 37.79556456422021 -122.441823037297 (37.7955645642202, -122.441823037297)
188303 188303 137083 Undocumented 2 Umbellularia californica :: California Bay 195 3699 Webster St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6002550.0727 2121200.5962799997 37.8045558214586 -122.435424089363 (37.8045558214586, -122.435424089363)
188290 188290 176776 Undocumented 2 Juniperus chinensis :: Juniper 19 145 Colby St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6008272.69802 2093344.33975 37.728392364995706 -122.413648871198 (37.7283923649957, -122.413648871198)
188255 188255 224438 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 177 Powhattan Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6008219.66372 2098116.4731099997 37.7414926273921 -122.414169698278 (37.7414926273921, -122.414169698278)
188236 188236 197199 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2001 Revere Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     6012275.41688 2096456.4335599998 37.737161484306704 -122.400029656869 (37.7371614843067, -122.400029656869)
188225 188225 203383 Undocumented 2 Acer palmatum :: Japanese Maple 175 281 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6000249.03164 2094925.61492 37.7322803518438 -122.44150041183701 (37.7322803518438, -122.441500411837)
188222 188222 186148 Undocumented 2 Pinus radiata :: Monterey Pine 3 1700 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984958.7864 2103269.137 37.754306442824294 -122.494976486886 (37.7543064428243, -122.494976486886)
188217 188217 136585 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 2900 Steiner St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   6002071.0497 2118131.41015 37.7961014261857 -122.436861939849 (37.7961014261857, -122.436861939849)
188162 188162 188987 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 305 Bridgeview Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6012918.6311099995 2094968.5987900002 37.73311204037989 -122.397701430785 (37.7331120403799, -122.397701430785)
188159 188159 197822 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6011948.87446 2091441.14937 37.723372343042996 -122.40080642377899 (37.723372343043, -122.400806423779)
188157 188157 222051 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6009002.14028 2107849.4775900003 37.7682611846314 -122.41215186512301 (37.7682611846314, -122.412151865123)
188140 188140 185318 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2601 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984972.2879 2097182.0069 37.7375936291819 -122.494481100117 (37.7375936291819, -122.494481100117)
188122 188122 184539 Undocumented 2 Myoporum laetum :: Myoporum 1 1939 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5981627.7505 2101868.0843 37.7502639852004 -122.50639195948 (37.7502639852004, -122.50639195948)
188107 188107 208154 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 523 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     5997951.24674 2095236.71061 37.7330033708131 -122.449466749514 (37.7330033708131, -122.449466749514)
188106 188106 205877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1337 Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5993571.02759 2097763.88788 37.7396908266808 -122.464793651423 (37.7396908266808, -122.464793651423)
188087 188087 195225 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 551 Barneveld Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6011054.22274 2097313.24893 37.739445953869705 -122.40431219245 (37.7394459538697, -122.40431219245)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 2372.019ms · Data source: data.sfgov.org