Street_Tree_List

Data source: data.sfgov.org

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
55286 55286 186809 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1200 Sunset Blvd 118 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984810.136 2106955.7691 37.7644202036906 -122.495762474243 (37.7644202036906, -122.495762474243)
173050 173050 186810 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1200 Sunset Blvd 117 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984819.4006 2106939.4198 37.7643758556702 -122.49572922497102 (37.7643758556702, -122.495729224971)
68183 68183 186811 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1200 Sunset Blvd 116 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984818.3107 2106920.8907 37.7643249161453 -122.495731627712 (37.7643249161453, -122.495731627712)
75257 75257 186812 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1200 Sunset Blvd 115 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984824.8504 2106905.6313 37.764283401100705 -122.495707883417 (37.7642834011007, -122.495707883417)
155382 155382 186813 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1200 Sunset Blvd 114 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984818.8556 2106897.4567 37.7642606048812 -122.4957280144 (37.7642606048812, -122.4957280144)
71793 71793 186814 Undocumented 2 Tree(s) :: 17 1200 Sunset Blvd 113 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984809.4922 2106874.2257 37.764196270742204 -122.495758685523 (37.7641962707422, -122.495758685523)
55485 55485 186815 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1200 Sunset Blvd 112 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984815.7546 2106849.1761 37.7641278583257 -122.49573517813299 (37.7641278583257, -122.495735178133)
129504 129504 186816 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1200 Sunset Blvd 111 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984817.9648 2106815.6539 37.7640359452212 -122.49572506094401 (37.7640359452212, -122.495725060944)
74356 74356 186817 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1200 Sunset Blvd 110 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
38561 38561 181583 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 109 Sidewalk: Property side : Yard 9 Tree 1 Private 1     54 Width 0ft   5984816.8597 2106789.1308 37.7639630555258 -122.495726926548 (37.7639630555258, -122.495726926548)
48784 48784 186818 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 108 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984817.9648 2106762.6077 37.7638902952632 -122.49572114784701 (37.7638902952632, -122.495721147847)
31887 31887 186819 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 107 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5984817.9648 2106743.4521 37.7638376993678 -122.495719734787 (37.7638376993678, -122.495719734787)
155851 155851 186820 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 106 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984828.6477 2106734.2427 37.7638130385474 -122.49568210708901 (37.7638130385474, -122.495682107089)
32317 32317 186821 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1200 Sunset Blvd 105 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984828.6477 2106722.4547 37.763780672010896 -122.49568123753599 (37.7637806720109, -122.495681237536)
65039 65039 186822 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 104 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984834.1734 2106701.8256 37.7637243538842 -122.495660604407 (37.7637243538842, -122.495660604407)
163102 163102 186823 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 103 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984834.1734 2106687.8273 37.763685918484 -122.49565957182101 (37.763685918484, -122.495659571821)
131707 131707 181584 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 102 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 0ft   5984836.752 2106666.0931 37.763626393477104 -122.495649050161 (37.7636263934771, -122.495649050161)
172544 172544 186824 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 101 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 0ft   5984835.6469 2106654.305 37.7635939619503 -122.495652002752 (37.7635939619503, -122.495652002752)
153690 153690 186825 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1200 Sunset Blvd 100 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984841.1725 2106636.9913 37.763546746968295 -122.49563161459999 (37.7635467469683, -122.4956316146)
146996 146996 186826 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1200 Sunset Blvd 99 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984816.4913 2106624.0982 37.763509900791895 -122.49571602668301 (37.7635099007919, -122.495716026683)
23749 23749 181585 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 98 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34 Width 0ft   5984843.0144 2106607.1528 37.7634649266844 -122.49562304315201 (37.7634649266844, -122.495623043152)
42516 42516 184094 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 97 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984942.4654 2104248.1437 37.756993568912705 -122.49510511552201 (37.7569935689127, -122.495105115522)
160096 160096 186833 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 97 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984849.2768 2106596.8383 37.7634369726808 -122.49560062301799 (37.7634369726808, -122.495600623018)
53983 53983 186827 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 96 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984832.3315 2106605.3109999998 37.7634592440326 -122.495659855463 (37.7634592440326, -122.495659855463)
149699 149699 184093 Undocumented 2 Cordyline australis :: Dracena Palm 141 1600 Sunset Blvd 96 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984922.9495 2104229.3007 37.7569406887046 -122.49517121838801 (37.7569406887046, -122.495171218388)
45664 45664 184092 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 95 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 0ft   5984922.9495 2104224.59 37.756927754428894 -122.49517087102 (37.7569277544289, -122.49517087102)
52631 52631 186828 Undocumented 2 Cordyline australis :: Dracena Palm 141 1200 Sunset Blvd 95 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984824.2272 2106601.6272 37.76344865476 -122.495687613477 (37.76344865476, -122.495687613477)
36960 36960 186829 Undocumented 2 Pinus Spp :: Pine Spp 105 1200 Sunset Blvd 94 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984823.8588 2106586.1554 37.763406151967004 -122.49568774634399 (37.763406151967, -122.495687746344)
162095 162095 184091 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1600 Sunset Blvd 94 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984954.5787 2104192.9608 37.756842761121895 -122.495059154794 (37.7568427611219, -122.495059154794)
39101 39101 181366 Undocumented 2 Pinus radiata :: Monterey Pine 3 1600 Sunset Blvd 93 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5984930.8531 2104160.775 37.756752998853 -122.49513883215201 (37.756752998853, -122.495138832152)
129592 129592 186830 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 93 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984826.8059 2106580.9981 37.7633921640535 -122.49567717299999 (37.7633921640535, -122.495677173)
54912 54912 186834 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1200 Sunset Blvd 92 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984853.6973 2106574.7357 37.763376544001105 -122.495583703829 (37.7633765440011, -122.495583703829)
66704 66704 181365 Undocumented 2 Pinus Spp :: Pine Spp 105 1600 Sunset Blvd 92 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984912.4611 2104151.8757 37.75672748706779 -122.495201781242 (37.7567274870678, -122.495201781242)
71028 71028 184090 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 91 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984905.3417 2104126.3643 37.7566570230164 -122.4952245211 (37.7566570230164, -122.4952245211)
177987 177987 186620 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1501 Sunset Blvd 91 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715)
47108 47108 186831 Undocumented 2 Cordyline australis :: Dracena Palm 141 1200 Sunset Blvd 90 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984823.4905 2106576.2092 37.763378820926 -122.495688286465 (37.763378820926, -122.495688286465)
72108 72108 186619 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 90 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5984733.72 2104360.7115 37.7572904258336 -122.495835328738 (37.7572904258336, -122.495835328738)
134633 134633 187307 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 90 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984946.0227 2098230.3328 37.740470513218796 -122.49464917361601 (37.7404705132188, -122.494649173616)
186034 186034 184089 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 90 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984906.5283 2104110.9388 37.7566147383421 -122.495219279964 (37.7566147383421, -122.495219279964)
40017 40017 186618 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 89 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5984770.9865 2104371.1796 37.7573213507818 -122.495707220643 (37.7573213507818, -122.495707220643)
71275 71275 187306 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 89 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984963.8587 2098228.7818 37.7404672985278 -122.494587390296 (37.7404672985278, -122.494587390296)
152873 152873 184088 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 89 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 0ft   5984924.9202 2104112.1254 37.756619073195 -122.49515576258999 (37.756619073195, -122.49515576259)
34118 34118 185363 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 0ft   5984980.3483 2096870.9998 37.7367401586853 -122.49443031260901 (37.7367401586853, -122.494430312609)
50410 50410 186835 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984844.4879 2106569.9468 37.7633628557386 -122.495615202431 (37.7633628557386, -122.495615202431)
75220 75220 184087 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1600 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554)
153678 153678 187305 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984977.8173 2098236.5366 37.740489408091605 -122.49453969916 (37.7404894080916, -122.49453969916)
173730 173730 186617 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 1501 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984770.9865 2104379.1354 37.757343195198004 -122.495707807467 (37.757343195198, -122.495707807467)
47680 47680 184086 Undocumented 2 Casuarina cunninghamiana :: Horsetail pine 123 1600 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984957.3486 2104087.5098 37.7565533840583 -122.495041800117 (37.7565533840583, -122.495041800117)
49403 49403 186616 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984717.3898 2104397.9779 37.75739179261161 -122.495894553165 (37.7573917926116, -122.495894553165)
52628 52628 185362 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984999.1909 2096870.1623 37.7367389618664 -122.494365104774 (37.7367389618664, -122.494365104774)
159647 159647 186837 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984854.0657 2106566.6314 37.7633543134405 -122.49558183188299 (37.7633543134405, -122.495581831883)
161925 161925 187304 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984974.7154 2098241.9649 37.7405041311946 -122.49455082423401 (37.7405041311946, -122.494550824234)
39632 39632 187303 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984970.4503 2098239.6385 37.7404974938989 -122.494565399613 (37.7404974938989, -122.494565399613)
51375 51375 181586 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 0ft   5984850.3819 2106547.1075 37.7633004905742 -122.495593132629 (37.7633004905742, -122.495593132629)
148491 148491 186615 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984738.326 2104396.7218 37.7573895698596 -122.495822055914 (37.7573895698596, -122.495822055914)
148559 148559 184085 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1600 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984928.3026 2104071.5069 37.756507744074604 -122.495141070042 (37.7565077440746, -122.495141070042)
151754 151754 185361 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     72 Width 0ft   5985015.9398 2096870.9998 37.7367422415889 -122.49430725909599 (37.7367422415889, -122.494307259096)
72990 72990 186838 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984850.7503 2106534.5827 37.7632661225609 -122.495590934617 (37.7632661225609, -122.495590934617)
131350 131350 186614 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984775.1737 2104397.9779 37.7573951766754 -122.495694716519 (37.7573951766754, -122.495694716519)
150966 150966 185360 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985022.2207 2096895.7045 37.7368104416486 -122.49428736403799 (37.7368104416486, -122.494287364038)
165670 165670 187302 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984968.1238 2098238.0875 37.7404930991044 -122.494573329313 (37.7404930991044, -122.494573329313)
169498 169498 184084 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984920.5061 2104059.8122 37.7564751772205 -122.495167170345 (37.7564751772205, -122.495167170345)
29536 29536 184083 Undocumented 2 Cordyline australis :: Dracena Palm 141 1600 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984945.8447 2104060.7868 37.756479336636296 -122.49507961366301 (37.7564793366363, -122.495079613663)
99051 99051 181587 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     56 Width 0ft   5984853.6973 2106515.0588 37.76321268798 -122.49557930195299 (37.76321268798, -122.495579301953)
159840 159840 186613 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984762.1933 2104405.0962 37.7574139613926 -122.49574013227699 (37.7574139613926, -122.495740132277)
161798 161798 187301 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984961.92 2098240.0262 37.740498059151705 -122.494594922206 (37.7404980591517, -122.494594922206)
162350 162350 185359 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 0ft   5984996.2598 2096910.7786 37.7368503118256 -122.49437823177 (37.7368503118256, -122.49437823177)
35253 35253 186612 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 83 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984740.0009 2104413.4707 37.7574356557736 -122.49581749901002 (37.7574356557736, -122.49581749901)
36628 36628 186839 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1200 Sunset Blvd 83 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984830.1212 2106502.1656 37.7631759062792 -122.49565989156099 (37.7631759062792, -122.495659891561)
51819 51819 184082 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 83 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984913.6842 2104051.0412 37.756450695089704 -122.49519011576 (37.7564506950897, -122.49519011576)
62450 62450 187300 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 83 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984960.7568 2098243.9036 37.7405086373666 -122.49459922981501 (37.7405086373666, -122.494599229815)
44873 44873 187299 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 82 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984957.2671 2098247.0055 37.7405169500984 -122.49461152428199 (37.7405169500984, -122.494611524282)
66347 66347 186804 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1200 Sunset Blvd 82 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984861.7413 2106944.0092 37.764390936343396 -122.495583120993 (37.7643909363434, -122.495583120993)
165792 165792 184081 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 82 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984942.4337 2104051.5284 37.7564537159438 -122.495090727248 (37.7564537159438, -122.495090727248)
167469 167469 186611 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 82 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984721.5770000005 2104411.7958 37.7574299779546 -122.49588109168998 (37.7574299779546, -122.49588109169)
171874 171874 185357 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2601 Sunset Blvd 82 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985023.8956 2096938.833 37.736928958988706 -122.494284751295 (37.7369289589887, -122.494284751295)
39750 39750 184080 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 81 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984946.8193 2104049.0919999997 37.7564472830117 -122.49507538087 (37.7564472830117, -122.49507538087)
52907 52907 187298 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 81 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984949.5124 2098247.3933 37.7405175610104 -122.49463836520799 (37.7405175610104, -122.494638365208)
67433 67433 186610 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 81 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984720.7396 2104420.1703 37.7574529229595 -122.49588460547199 (37.7574529229595, -122.495884605472)
135520 135520 186803 Undocumented 2 Tree(s) :: 17 1200 Sunset Blvd 81 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984854.4903 2106938.312 37.7643748688283 -122.495607779566 (37.7643748688283, -122.495607779566)
156868 156868 185356 Undocumented 2 Olea europaea :: Olive Tree 41 2601 Sunset Blvd 81 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985014.265 2096945.9513 37.736947940348294 -122.49431857261001 (37.7369479403483, -122.49431857261)
70272 70272 186802 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1200 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984846.4625 2106932.8738 37.76435946696029 -122.495635143928 (37.7643594669603, -122.495635143928)
71896 71896 184079 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1600 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984934.15 2104045.1938 37.75643583792721 -122.49511890768 (37.7564358379272, -122.49511890768)
153696 153696 181520 Undocumented 2 Pinus radiata :: Monterey Pine 3 1400 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     62 Width 0ft   5984870.8428 2105613.4659 37.7607381702444 -122.49545350347601 (37.7607381702444, -122.495453503476)
157552 157552 187297 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984942.9208 2098245.0668 37.7405107872571 -122.494660984587 (37.7405107872571, -122.494660984587)
172909 172909 186609 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984732.0451 2104419.3328 37.7574512855375 -122.49584544534599 (37.7574512855375, -122.495845445346)
45402 45402 223688 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 1300 San Jose Ave 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33     6003610.6352699995 2095763.96292 37.734773207799705 -122.42993836337901 (37.7347732077997, -122.429938363379)
136877 136877 181519 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1400 Sunset Blvd 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984899.8047 2105606.7824 37.76072151501489 -122.49535284581002 (37.7607215150149, -122.49535284581)
152960 152960 187296 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2401 Sunset Blvd 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984940.5944 2098249.7197 37.7405234267001 -122.494669371199 (37.7405234267001, -122.494669371199)
155155 155155 186608 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984734.9762 2104426.0324 37.757469852437794 -122.49583580278299 (37.7574698524378, -122.495835802783)
165013 165013 186801 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1200 Sunset Blvd 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984854.2314 2106929.2483 37.7643499672955 -122.495608006442 (37.7643499672955, -122.495608006442)
175953 175953 184078 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1600 Sunset Blvd 79 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984934.15 2104038.8591 37.7564184445961 -122.49511844057301 (37.7564184445961, -122.495118440573)
26088 26088 184889 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 1201 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984679.4382 2106701.786 37.763715182625106 -122.49619577469801 (37.7637151826251, -122.496195774698)
50110 50110 181518 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 1400 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984884.7668 2105589.5167 37.7606732277268 -122.495403580994 (37.7606732277268, -122.495403580994)
58217 58217 233515 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1001 San Jose Ave 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6005400.68613 2097518.02448 37.739690679175 -122.423874221345 (37.739690679175, -122.423874221345)
61223 61223 223687 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 1300 San Jose Ave 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30     6003595.322819999 2095749.76231 37.7347333489588 -122.429990291123 (37.7347333489588, -122.429990291123)
68751 68751 184077 Undocumented 2 Casuarina cunninghamiana :: Horsetail pine 123 1600 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984949.117000001 2104038.1203 37.7564172922771 -122.495066625722 (37.7564172922771, -122.495066625722)
168416 168416 186800 Undocumented 2 :: 54 1200 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984846.2035 2106925.1049 37.7643381205783 -122.495635466651 (37.7643381205783, -122.495635466651)
171617 171617 187295 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984937.4924 2098259.4132 37.7405498608751 -122.49468081101999 (37.7405498608751, -122.49468081102)
174966 174966 185935 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2000 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985034.4441 2101527.1648 37.7495278943342 -122.494586435864 (37.7495278943342, -122.494586435864)

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 1974.128ms · Data source: data.sfgov.org