Data source: data.sfgov.org
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) |
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");