Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
44990 44990 215603 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 168 : 4 Tree 1 Private 1     16 Width 0ft   5991175.95809 2091313.6332900003 37.7218416708418 -122.47260454218399 (37.7218416708418, -122.472604542184)
155655 155655 206871 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 167 : 4 Tree 1 Private 1     28 Width 0ft   5991178.39011 2091334.0196900002 37.721897787630404 -122.472597620991 (37.7218977876304, -122.472597620991)
129670 129670 215602 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 166 : 4 Tree 1 Private 1     4 Width 0ft   5991204.303730001 2091328.4883700002 37.7218840999401 -122.47250764202101 (37.7218840999401, -122.472507642021)
146741 146741 211030 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 165 : 4 Tree 1 Private 1     4 Width 0ft   5991183.72988 2091349.85826 37.7219415855123 -122.47258031712099 (37.7219415855123, -122.472580317121)
169329 169329 205949 Undocumented 2 Cedrus atlantica :: Atlas Cedar 304 700 Junipero Serra Blvd 164 : 4 Tree 1 Private 1     2 Width 0ft   5991178.36244 2091356.45164 37.7219593786163 -122.47259935129601 (37.7219593786163, -122.472599351296)
183116 183116 211029 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 162 : 4 Tree 1 Private 1     5 Width 0ft   5991185.525 2091363.77787 37.721979909226704 -122.472575126241 (37.7219799092267, -122.472575126241)
44167 44167 204151 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 161 : 4 Tree 1 Private 1     6 Width 0ft   5991207.7087199995 2091371.2859599998 37.722001808625706 -122.47249899053499 (37.7220018086257, -122.472498990535)
172927 172927 211028 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 160 : 4 Tree 1 Private 1     4 Width 0ft   5991184.3391 2091378.75733 37.722020970475505 -122.472580317131 (37.7220209704755, -122.472580317131)
133970 133970 205948 Undocumented 2 Cedrus atlantica :: Atlas Cedar 304 700 Junipero Serra Blvd 159 : 4 Tree 1 Private 1     2 Width 0ft   5991180.56722 2091389.80327 37.7220510815648 -122.47259416039101 (37.7220510815648, -122.472594160391)
130653 130653 204150 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 158 : 4 Tree 1 Private 1     7 Width 0ft   5991209.7349 2091396.16713 37.722070243443206 -122.47249379964799 (37.7220702434432, -122.472493799648)
44904 44904 211027 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 157 : 4 Tree 1 Private 1     4 Width 0ft   5991179.7136 2091396.7999900002 37.7220702434165 -122.47259762098 (37.7220702434165, -122.47259762098)
57018 57018 205947 Undocumented 2 Cedrus atlantica :: Atlas Cedar 304 700 Junipero Serra Blvd 156 : 4 Tree 1 Private 1     3 Width 0ft   5991175.5044 2091410.84585 37.722108566227796 -122.472613194561 (37.7221085662278, -122.472613194561)
104287 104287 215601 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 155 : 4 Tree 1 Private 1     15 Width 0ft   5991211.33426 2091424.54649 37.7221482587196 -122.472490339055 (37.7221482587196, -122.472490339055)
177342 177342 204149 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 154 : 4 Tree 1 Private 1     6 Width 0ft   5991212.71454 2091446.3716400003 37.722208265075004 -122.47248715816299 (37.722208265075, -122.472487158163)
176049 176049 206870 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 153 : 4 Tree 1 Private 1     16 Width 0ft   5991175.977080001 2091433.26758 37.7221701581122 -122.47261319456699 (37.7221701581122, -122.472613194567)
174895 174895 211206 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 152 : 4 Tree 1 Private 1     8 Width 0ft   5991178.15034 2091465.1240400001 37.7222577538669 -122.472608003665 (37.7222577538669, -122.472608003665)
28008 28008 211205 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 151 : 4 Tree 1 Private 1     7 Width 0ft   5991189.83716 2091473.3519099997 37.72228102203729 -122.472568205077 (37.7222810220373, -122.472568205077)
135944 135944 211204 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 150 : 4 Tree 1 Private 1     8 Width 0ft   5991184.9595800005 2091479.43645 37.72229744634829 -122.47258550894101 (37.7222974463483, -122.472585508941)
156539 156539 211203 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 149 : 4 Tree 1 Private 1     5 Width 0ft   5991189.46287 2091479.34152 37.7222974463593 -122.472569935366 (37.7222974463593, -122.472569935366)
152085 152085 204148 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 148 : 4 Tree 1 Private 1     5 Width 0ft   5991212.9902099995 2091479.34405 37.7222988151126 -122.472488607883 (37.7222988151126, -122.472488607883)
73599 73599 206869 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 147 : 4 Tree 1 Private 1     26 Width 0ft   5991181.8353699995 2091497.44747 37.722346719311396 -122.472597620994 (37.7223467193114, -122.472597620994)
45625 45625 211202 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 146 : 4 Tree 1 Private 1     1 Width 0ft   5991184.50895 2091529.2933900002 37.722434315083 -122.472590699819 (37.722434315083, -122.472590699819)
62914 62914 211201 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 145 : 4 Tree 1 Private 1     1 Width 0ft   5991189.49156 2091528.1913400001 37.722431577536994 -122.47257339594101 (37.722431577537, -122.472573395941)
32909 32909 204147 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 143 : 4 Tree 1 Private 1     8 Width 0ft   5991215.11855 2091556.56269 37.7225109615814 -122.47248687756 (37.7225109615814, -122.47248687756)
147332 147332 206868 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 142 : 4 Tree 1 Private 1     24 Width 0ft   5991190.247819999 2091564.0657099998 37.7225301234522 -122.472573395965 (37.7225301234522, -122.472573395965)
61076 61076 211505 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 700 Junipero Serra Blvd 141 : 4 Tree 1 Private 1     15 Width 0ft   5991206.53214 2091576.6828700001 37.7225657096252 -122.472518024694 (37.7225657096252, -122.472518024694)
35812 35812 211504 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 700 Junipero Serra Blvd 140 : 4 Tree 1 Private 1     19 Width 0ft   5991207.795390001 2091589.11785 37.7225999261211 -122.472514564093 (37.7225999261211, -122.472514564093)
178663 178663 211503 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 700 Junipero Serra Blvd 139 : 4 Tree 1 Private 1     4 Width 0ft   5991198.47785 2091598.2870099999 37.7226245630474 -122.47254744060801 (37.7226245630474, -122.472547440608)
137218 137218 211026 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 138 : 4 Tree 1 Private 1     4 Width 0ft   5991196.61305 2091604.8062200001 37.7226423552448 -122.472554361808 (37.7226423552448, -122.472554361808)
169120 169120 211502 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 700 Junipero Serra Blvd 137 : 4 Tree 1 Private 1     6 Width 0ft   5991202.79588 2091613.1501200001 37.7226656234049 -122.47253359735501 (37.7226656234049, -122.472533597355)
44766 44766 204146 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 136 : 4 Tree 1 Private 1     7 Width 0ft   5991223.21581 2091608.2334599998 37.7226533053988 -122.472462652551 (37.7226533053988, -122.472462652551)
63674 63674 204145 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 135 : 4 Tree 1 Private 1     5 Width 0ft   5991223.03412 2091647.11797 37.722760062121104 -122.472466114031 (37.7227600621211, -122.472466114031)
53576 53576 206867 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 134 : 4 Tree 1 Private 1     5 Width 0ft   5991202.1664 2091654.5365900001 37.7227792239685 -122.47253878915501 (37.7227792239685, -122.472538789155)
35459 35459 206866 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 132 : 4 Tree 1 Private 1     28 Width 0ft   5991206.46725 2091692.32993 37.7228832440624 -122.472526676182 (37.7228832440624, -122.472526676182)
44251 44251 204144 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 131 : 4 Tree 1 Private 1     3 Width 0ft   5991226.84892 2091709.3466 37.7229311473308 -122.47245746165599 (37.7229311473308, -122.472457461656)
60657 60657 213701 Undocumented 2 Prunus spp :: Cherry 84 700 Junipero Serra Blvd 130 : 4 Tree 1 Private 1     8 Width 0ft   5991210.94255 2091714.66662 37.722944834118294 -122.47251283382201 (37.7229448341183, -122.472512833822)
185468 185468 206865 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 129 : 4 Tree 1 Private 1     25 Width 0ft   5991211.79314 2091726.01373 37.722976039705 -122.472510720395 (37.722976039705, -122.472510720395)
52116 52116 219174 Undocumented 2 Heteromeles arbutifolia :: Toyon 322 700 Junipero Serra Blvd 128 : 4 Tree 1 Private 1     25 Width 0ft   5991213.30125 2091731.56505 37.722991369546 -122.47250591174 (37.722991369546, -122.47250591174)
167990 167990 204143 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 127 : 4 Tree 1 Private 1     4 Width 0ft   5991229.50143 2091740.19596 37.7230160055595 -122.47245054047801 (37.7230160055595, -122.472450540478)
26935 26935 204142 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 126 : 4 Tree 1 Private 1     3 Width 0ft   5991215.491640001 2091740.4912900003 37.7230160055721 -122.47249899053001 (37.7230160055721, -122.47249899053)
159623 159623 210100 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 700 Junipero Serra Blvd 125 : 4 Tree 1 Private 1     6 Width 0ft   5991216.87042 2091758.40738 37.7230652785221 -122.472495529943 (37.7230652785221, -122.472495529943)
28294 28294 188658 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 124 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374)
26454 26454 188657 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 123 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6016750.167669999 2099204.87087 37.744956608177205 -122.38474966268801 (37.7449566081772, -122.384749662688)
152163 152163 207138 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 123 : 4 Tree 1 Private 1     8 Width 0ft   5991217.227519999 2091775.34767 37.7231118130309 -122.472495529957 (37.7231118130309, -122.472495529957)
56563 56563 188656 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 122 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6016757.253769999 2099196.6677 37.7449344758533 -122.384724588679 (37.7449344758533, -122.384724588679)
171798 171798 204141 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 122 : 4 Tree 1 Private 1     5 Width 0ft   5991228.41386 2091783.5857799998 37.723135080309 -122.472457461666 (37.723135080309, -122.472457461666)
188449 188449 224191 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 122 Front Yard : Yard 7 Tree 1 Private 1     3     6005002.1777800005 2096858.81533 37.7378581342538 -122.425205199076 (37.7378581342538, -122.425205199076)
132733 132733 224190 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 121 Front Yard : Yard 7 Tree 1 Private 1     5     6004977.04425 2096823.5682 37.737759933676706 -122.425289590543 (37.7377599336767, -122.425289590543)
186048 186048 204140 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 121 : 4 Tree 1 Private 1     3 Width 0ft   5991218.48026 2091787.2847 37.7231446616675 -122.472492069365 (37.7231446616675, -122.472492069365)
167615 167615 204139 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 120 : 4 Tree 1 Private 1     2 Width 0ft   5991219.21165 2091798.23539 37.7231747718824 -122.47249033908501 (37.7231747718824, -122.472490339085)
160578 160578 224189 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 119 Front Yard : Yard 7 Tree 1 Private 1     31     6004983.70643 2096876.20955 37.737904851335 -122.42527030099501 (37.737904851335, -122.425270300995)
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)
137626 137626 224272 Undocumented 2 Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 1000 San Jose Ave 118 Front Yard : Yard 7 Tree 1 Private 1     8     6005007.01889 2096875.50161 37.737904224505 -122.425189647979 (37.737904224505, -122.425189647979)
152667 152667 204138 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 118 : 4 Tree 1 Private 1     3 Width 0ft   5991222.04967 2091814.1267099997 37.723218569775796 -122.47248168668001 (37.7232185697758, -122.47248168668)
61374 61374 204137 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 117 : 4 Tree 1 Private 1     2 Width 0ft   5991221.343090001 2091828.09873 37.7232568925832 -122.472485147293 (37.7232568925832, -122.472485147293)
79463 79463 116977 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100x CARGO WAY 117 Front Yard : Yard 7 Tree 1 PUC 13 DPW for City Agency 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
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)
188340 188340 224188 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 117 Front Yard : Yard 7 Tree 1 Private 1     15     6005014.01111 2096876.39929 37.7379070843395 -122.42516553628799 (37.7379070843395, -122.425165536288)
59920 59920 224187 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 116 Front Yard : Yard 7 Tree 1 Private 1     30     6004997.70734 2096883.03935 37.737924395399205 -122.42522237880699 (37.7379243953992, -122.425222378807)
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)
135578 135578 211200 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 116 : 4 Tree 1 Private 1     19 Width 0ft   5991221.58467 2091839.55857 37.723288372446795 -122.472485147272 (37.7232883724468, -122.472485147272)
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)
133023 133023 224217 Undocumented 2 Eucalyptus Spp :: Eucalyptus 40 1000 San Jose Ave 115 Front Yard : Yard 7 Tree 1 Private 1     21     6005000.71693 2096893.74168 37.7379539516063 -122.42521273450001 (37.7379539516063, -122.4252127345)
183959 183959 204136 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 115 : 4 Tree 1 Private 1     2 Width 0ft   5991237.83729 2091850.68057 37.7233198514003 -122.472429776026 (37.7233198514003, -122.472429776026)
41931 41931 204135 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 114 : 4 Tree 1 Private 1     1 Width 0ft   5991224.97526 2091857.93043 37.72333901327 -122.47247476549299 (37.72333901327, -122.472474765493)
136349 136349 224186 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 114 Front Yard : Yard 7 Tree 1 Private 1     11     6005021.679330001 2096895.74066 37.7379606245711 -122.42514039930599 (37.7379606245711, -122.425140399306)
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)
46095 46095 224185 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 113 Front Yard : Yard 7 Tree 1 Private 1     13     6005009.48199 2096913.00579 37.7380073416725 -122.42518379971901 (37.7380073416725, -122.425183799719)
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)
180817 180817 211199 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 113 : 4 Tree 1 Private 1     19 Width 0ft   5991225.72765 2091869.87768 37.723371861005894 -122.472473035226 (37.7233718610059, -122.472473035226)
39013 39013 223986 Undocumented 2 Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 1000 San Jose Ave 112 Front Yard : Yard 7 Tree 1 Private 1     2     6005022.50641 2096918.9877400002 37.7380245025333 -122.42513919334299 (37.7380245025333, -122.425139193343)
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)
167766 167766 204134 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 112 : 4 Tree 1 Private 1     1 Width 0ft   5991228.00205 2091882.78985 37.7234074462669 -122.472466114014 (37.7234074462669, -122.472466114014)
186983 186983 206877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 112 : 4 Tree 1 Private 1     24 Width 0ft   5991127.9538900005 2090310.3975099998 37.7190842541173 -122.472697367507 (37.7190842541173, -122.472697367507)
49696 49696 248657 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1000 San Jose Ave 111 Front Yard : Yard 7 Tree 1 Private 1     6     6005025.16759 2096929.69692 37.7380540578596 -122.425130754104 (37.7380540578596, -122.425130754104)
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)
147633 147633 204392 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 900 Junipero Serra Blvd 111 : 4 Tree 1 Private 1     2 Width 0ft   5991121.6593 2090321.7694700002 37.7191151143447 -122.47271995398 (37.7191151143447, -122.47271995398)
162792 162792 204133 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 111 : 4 Tree 1 Private 1     4 Width 0ft   5991241.7215 2091892.4700799999 37.723434819851704 -122.47241939423401 (37.7234348198517, -122.472419394234)
70012 70012 204132 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 110 : 4 Tree 1 Private 1     1 Width 0ft   5991228.632230001 2091912.6848400002 37.7234895669738 -122.47246611402001 (37.7234895669738, -122.47246611402)
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)
74532 74532 211210 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Junipero Serra Blvd 110 : 4 Tree 1 Private 1     5 Width 0ft   5991130.08435 2090326.91588 37.7191297328215 -122.47269120713499 (37.7191297328215, -122.472691207135)
176014 176014 248656 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1000 San Jose Ave 110 Front Yard : Yard 7 Tree 1 Private 1     16     6005044.37292 2096931.03803 37.7380588251561 -122.42506444708 (37.7380588251561, -122.42506444708)
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)
41648 41648 204157 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 109 : 4 Tree 1 Private 1     2 Width 0ft   5991141.76494 2090345.5990099998 37.7191817082419 -122.47265219366899 (37.7191817082419, -122.472652193669)
51689 51689 223995 Undocumented 2 Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 1000 San Jose Ave 109 Front Yard : Yard 7 Tree 1 Private 1     4     6005045.35559 2096944.9067 37.7380969609067 -122.42506203599702 (37.7380969609067, -122.425062035997)
175511 175511 208978 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 700 Junipero Serra Blvd 109 : 4 Tree 1 Private 1     14 Width 0ft   5991241.872330001 2091923.37185 37.723519677182495 -122.47242112456001 (37.7235196771825, -122.47242112456)
28316 28316 224184 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1000 San Jose Ave 108 Front Yard : Yard 7 Tree 1 Private 1     29     6005030.14843 2096951.46948 37.7381141217706 -122.42511508160801 (37.7381141217706, -122.425115081608)
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)
55517 55517 206864 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 108 : 4 Tree 1 Private 1     16 Width 0ft   5991230.74264 2091941.55129 37.7235689492395 -122.472460922234 (37.7235689492395, -122.472460922234)
180338 180338 211209 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Junipero Serra Blvd 108 : 4 Tree 1 Private 1     38 Width 0ft   5991125.77037 2090347.7107799998 37.719186580775705 -122.47270763415301 (37.7191865807757, -122.472707634153)
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)
43611 43611 206876 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 107 : 4 Tree 1 Private 1     15 Width 0ft   5991129.63237 2090361.82623 37.7192255618863 -122.472695313452 (37.7192255618863, -122.472695313452)
134489 134489 204131 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 107 : 4 Tree 1 Private 1     2 Width 0ft   5991246.04706 2091955.1858 37.723607272029604 -122.472409011575 (37.7236072720296, -122.472409011575)
169087 169087 248655 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1000 San Jose Ave 107 Front Yard : Yard 7 Tree 1 Private 1     16     6005056.20315 2096946.76695 37.7381026814961 -122.425024662861 (37.7381026814961, -122.425024662861)
25562 25562 204156 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 106 : 4 Tree 1 Private 1     3 Width 0ft   5991140.12525 2090380.53407 37.719277536403496 -122.472660407165 (37.7192775364035, -122.472660407165)
64048 64048 211198 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 106 : 4 Tree 1 Private 1     31 Width 0ft   5991232.55871 2091956.46714 37.7236100095791 -122.472455731353 (37.7236100095791, -122.472455731353)
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)
177422 177422 237963 Undocumented 2 Prunus lyonii :: Catalina Cherry 300 1000 San Jose Ave 106 Front Yard : Yard 7 Tree 1 Private 1     4     6005052.98208 2096959.6805599998 37.7381379574049 -122.42503671826799 (37.7381379574049, -122.425036718268)
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)
57729 57729 204130 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 105 : 4 Tree 1 Private 1     3 Width 0ft   5991232.43649 2091974.41455 37.7236592816427 -122.47245746163901 (37.7236592816427, -122.472457461639)

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