Street_Tree_List

Data source: data.sfgov.org

1,700 rows where qSiteInfo = 10 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
16896 16896 100001 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 501X 01st St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1         Address is 100 1st Street          
63333 63333 118678 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 4749 Balboa St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   5980862.87698 2110909.19366 37.77504319711021 -122.50970838455 (37.7750431971102, -122.50970838455)
38458 38458 118677 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 4749 Balboa St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   5980875.63021 2110909.60557 37.7750450801709 -122.50966429974702 (37.7750450801709, -122.509664299747)
134641 134641 184184 Undocumented 2 :: 54 1642 Lower Great Hwy 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5980990.4302 2103889.7643 37.7557774014806 -122.508745894794 (37.7557774014806, -122.508745894794)
158331 158331 184392 Undocumented 2 :: 54 2040 Lower Great Hwy 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5981213.3751 2101162.7638 37.748302968665705 -122.50777253673 (37.7483029686657, -122.50777253673)
40221 40221 182926 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2646 Lower Great Hwy 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 0ft   5981556.704 2097178.5239 37.7373835743826 -122.506289933268 (37.7373835743826, -122.506289933268)
169416 169416 183302 Undocumented 2 Cordyline australis :: Dracena Palm 141 4500 Irving St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   5981770.8567 2106269.7 37.7623579967214 -122.506223442565 (37.7623579967214, -122.506223442565)
33287 33287 118775 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 630 45th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     27 Width 2ft   5981986.088380001 2111427.82901 37.7765333919608 -122.50586147692101 (37.7765333919608, -122.505861476921)
154869 154869 117819 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 3936 Balboa St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 1ft   5983305.904569999 2111075.09338 37.775642477392395 -122.501269829965 (37.7756424773924, -122.501269829965)
75864 75864 117818 Undocumented 2 Juniperus chinensis :: Juniper 19 3936 Balboa St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 1ft   5983313.54909 2111075.82361 37.775644931310396 -122.501243440143 (37.7756449313104, -122.501243440143)
156512 156512 117781 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 563 40th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   5983463.79311 2111964.41208 37.7780935589435 -122.500789443294 (37.7780935589435, -122.500789443294)
77219 77219 118070 Undocumented 2 Juniperus chinensis :: Juniper 19 422 35th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 2ft   5985031.51413 2113017.90855 37.7810780733056 -122.49544393016599 (37.7810780733056, -122.495443930166)
158745 158745 118071 Undocumented 2 Juniperus chinensis :: Juniper 19 422 35th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 2ft   5985031.745180001 2113002.45389 37.7810356528066 -122.49544199070401 (37.7810356528066, -122.495441990704)
167495 167495 182403 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1520 35th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 0ft   5985303.3969 2104828.602 37.758608470378704 -122.49389967209801 (37.7586084703787, -122.493899672098)
175275 175275 182213 Undocumented 2 Cordyline australis :: Dracena Palm 141 2730 Lawton St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   5985735.4613 2104364.4813 37.75735939305871 -122.492371241702 (37.7573593930587, -122.492371241702)
43305 43305 250477 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 330 Seacliff Ave 11 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 4ft   5986717.515380001 2115494.0026 37.78797529338429 -122.489793444531 (37.7879752933843, -122.489793444531)
134533 134533 181882 Undocumented 2 :: 54 2339 32nd Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5986377.6918 2099330.2097 37.7435741741127 -122.48977995723999 (37.7435741741127, -122.48977995724)
136603 136603 119968 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 540 28th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 3ft   5987220.74694 2112250.93523 37.7791001265755 -122.487814013837 (37.7791001265755, -122.487814013837)
132766 132766 119970 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 542 28th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     20 Width 3ft   5987221.67588 2112220.77085 37.779017357921205 -122.487808583512 (37.7790173579212, -122.487808583512)
49645 49645 119969 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 540 28th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 3ft   5987222.6278800005 2112233.92491 37.7790535307721 -122.48780625689501 (37.7790535307721, -122.487806256895)
164089 164089 119971 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 552 28th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     20 Width 3ft   5987224.33596 2112187.66675 37.77892661860329 -122.487796948534 (37.7789266186033, -122.487796948534)
169948 169948 182141 Undocumented 2 Maytenus boaria :: Mayten 22 1414 25th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   5988378.9203 2105649.8128 37.761042756843 -122.48332344606001 (37.761042756843, -122.48332344606)
24709 24709 182142 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1418 25th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 0ft   5988379.3786 2105646.1459999997 37.761032715479395 -122.483321592218 (37.7610327154794, -122.483321592218)
175818 175818 182134 Undocumented 2 Maytenus boaria :: Mayten 22 1434 25th Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 0ft   5988383.0453 2105547.1446 37.7607610979396 -122.483301653477 (37.7607610979396, -122.483301653477)
52034 52034 182133 Undocumented 2 Cordyline australis :: Dracena Palm 141 1434 25th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   5988383.962 2105543.0196 37.760749825160204 -122.48329818067499 (37.7607498251602, -122.483298180675)
188216 188216 182185 Undocumented 2 :: 54 1638 25th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   5988431.9652 2104143.1815 37.756909042216 -122.483029559375 (37.756909042216, -122.483029559375)
157884 157884 251043 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 5527 Geary Blvd 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 2ft   5989811.4148 2112601.8948 37.780214536371105 -122.478877614898 (37.7802145363711, -122.478877614898)
152354 152354 218987 Undocumented 2 Fraxinus velutina :: Modesto Ash 405 1628 18th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 5ft   5990606.34235 2104296.88686 37.7574573626709 -122.475521050754 (37.7574573626709, -122.475521050754)
40341 40341 218986 Undocumented 2 Fraxinus velutina :: Modesto Ash 405 1628 18th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 5ft   5990607.414890001 2104273.45371 37.757393083633 -122.475515630561 (37.757393083633, -122.475515630561)
33419 33419 218015 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990772.5777900005 2099709.35635 37.7448708407289 -122.474611345145 (37.7448708407289, -122.474611345145)
75447 75447 218016 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990785.97144 2099709.33017 37.7448715449012 -122.474565030958 (37.7448715449012, -122.474565030958)
155116 155116 218017 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990797.83143 2099709.8496 37.7448736582987 -122.474524059638 (37.7448736582987, -122.474524059638)
154116 154116 218018 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990812.82418 2099712.3546 37.7448814050516 -122.474472400799 (37.7448814050516, -122.474472400799)
154305 154305 218019 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990820.542769999 2099711.9352700002 37.744880700881794 -122.474445681024 (37.7448807008818, -122.474445681024)
50974 50974 218020 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990823.88989 2099711.8646400003 37.7448807008746 -122.474434102269 (37.7448807008746, -122.474434102269)
73699 73699 218021 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 645 Santiago St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   5990833.9529 2099712.67814 37.744883517556 -122.474399365956 (37.744883517556, -122.474399365956)
162250 162250 122264 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1400 Balboa St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16 Width 4ft   5991175.02195 2111348.8824 37.7768531954343 -122.474068870116 (37.7768531954343, -122.474068870116)
28203 28203 122263 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1400 Balboa St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 4ft   5991199.98338 2111351.52204 37.7768618890602 -122.473982714477 (37.7768618890602, -122.473982714477)
179302 179302 122262 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1400 Balboa St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   5991232.29363 2111350.84044 37.7768618890585 -122.47387089491501 (37.7768618890585, -122.473870894915)
188186 188186 218852 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1346 16th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 3ft   5991155.44082 2106257.8165599997 37.7628733705378 -122.473765117276 (37.7628733705378, -122.473765117276)
182212 182212 217542 Undocumented 2 Yucca spp :: Yucca 402 1366 16th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   5991156.21032 2106109.4885 37.7624661458171 -122.473751634653 (37.7624661458171, -122.473751634653)
67868 67868 206024 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991156.52884 2106111.8053099997 37.7624725256075 -122.473750702041 (37.7624725256075, -122.473750702041)
59914 59914 206025 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1366 16th Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   5991157.5258599995 2106131.34791 37.76252624212071 -122.473748679463 (37.7625262421207, -122.473748679463)
55172 55172 217543 Undocumented 2 Yucca spp :: Yucca 402 1366 16th Ave 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   5991159.18226 2106131.31297 37.762526242118795 -122.47374294808701 (37.7625262421188, -122.473742948087)
70726 70726 207526 Undocumented 2 Dracaena draco :: Dragon Tree 361 1366 16th Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 4ft   5991165.61053 2106115.5186099997 37.7624832473222 -122.473719563019 (37.7624832473222, -122.473719563019)
50258 50258 205681 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 134 Lomita Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6     5991402.87169 2104383.6674599997 37.7577417813829 -122.472772688422 (37.7577417813829, -122.472772688422)
183958 183958 205682 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 134 Lomita Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5     5991412.37682 2104411.58455 37.757818984582705 -122.47274185157801 (37.7578189845827, -122.472741851578)
86115 86115 205683 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 134 Lomita Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4     5991416.24805 2104429.61687 37.7578687206724 -122.47272977815399 (37.7578687206724, -122.472729778154)
148664 148664 205684 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 134 Lomita Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4     5991419.75521 2104444.35599 37.757909393427205 -122.472718723697 (37.7579093934272, -122.472718723697)
187792 187792 210906 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1113 Kirkham St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   5991529.16752 2105177.12145 37.7599277068135 -122.47239375186301 (37.7599277068135, -122.472393751863)
180357 180357 211093 Undocumented 2 Pinus radiata :: Monterey Pine 3 2088 15th Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 6ft   5991644.9229 2101275.9651599997 37.749222851651 -122.471709112392 (37.749222851651, -122.471709112392)
71741 71741 211060 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2088 15th Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 6ft   5991645.7062 2101259.684 37.7491781931242 -122.471705217417 (37.7491781931242, -122.471705217417)
57486 57486 205505 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2088 15th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 6ft   5991647.261530001 2101306.76233 37.7493075480059 -122.471703269501 (37.7493075480059, -122.471703269501)
76912 76912 205506 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2088 15th Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     22 Width 6ft   5991647.44658 2101288.81124 37.749258269671394 -122.47170132158399 (37.7492582696714, -122.471701321584)
163971 163971 205504 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2088 15th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18 Width 6ft   5991648.1199199995 2101320.76563 37.7493460471025 -122.471701321557 (37.7493460471025, -122.471701321557)
34594 34594 211059 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2088 15th Ave 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16 Width 6ft   5991648.13538 2101268.0455099996 37.749201292209996 -122.47169742662201 (37.74920129221, -122.471697426622)
174453 174453 203702 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2072 15th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     19 Width 10ft   5991651.27757 2101417.16458 37.7496109163211 -122.47169742658899 (37.7496109163211, -122.471697426589)
176190 176190 211061 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2088 15th Ave 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 6ft   5991650.04455 2101251.74063 37.749156633693204 -122.47168963668999 (37.7491566336932, -122.47168963669)
164564 164564 211062 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2088 15th Ave 8 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     33 Width 6ft   5991653.15073 2101238.7756 37.7491212147934 -122.47167795088998 (37.7491212147934, -122.47167795089)
176402 176402 210907 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1009 Kirkham St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     32 Width 3ft   5991740.69924 2105187.8933900003 37.7599695243799 -122.47166295830499 (37.7599695243799, -122.471662958305)
76642 76642 179830 Undocumented 2 Taxus baccata :: Irish Yew 241 966 Randolph St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   5991498.1765 2088667.9539299998 37.7145959293389 -122.471298058377 (37.7145959293389, -122.471298058377)
60475 60475 179831 Undocumented 2 Taxus baccata :: Irish Yew 241 966 Randolph St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   5991499.58423 2088662.2150700002 37.7145802532566 -122.47129277485399 (37.7145802532566, -122.471292774854)
75602 75602 210344 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2222 15th Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 5ft   5991737.50971 2099005.7982900003 37.7429949142736 -122.47122357203399 (37.7429949142736, -122.471223572034)
43352 43352 211539 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 5ft   5991737.95589 2099026.97767 37.7430530932385 -122.471223572022 (37.7430530932385, -122.471223572022)
155751 155751 211540 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 5ft   5991738.81904 2098988.7367 37.7429481432502 -122.47121780198 (37.7429481432502, -122.47121780198)
150797 150797 214670 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2250 15th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14     5991762.46474 2100100.36567 37.7460017588674 -122.47121701506398 (37.7460017588674, -122.471217015064)
50421 50421 211541 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2222 15th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 5ft   5991738.93886 2098974.6083299997 37.742909357292596 -122.471216358549 (37.7429093572926, -122.471216358549)
173908 173908 211094 Undocumented 2 Pinus radiata :: Monterey Pine 3 66 Aerial Way 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     39 Width 4ft   5992285.42513 2102561.07483 37.752788467513206 -122.46958780504801 (37.7527884675132, -122.469587805048)
130043 130043 211339 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 66 Aerial Way 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   5992292.226009999 2102565.50209 37.7528010166768 -122.469564608839 (37.7528010166768, -122.469564608839)
154212 154212 211095 Undocumented 2 Pinus radiata :: Monterey Pine 3 66 Aerial Way 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     38 Width 4ft   5992315.3975 2102577.1661799997 37.7528343824016 -122.469485327309 (37.7528343824016, -122.469485327309)
58150 58150 211299 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 212 Vernon St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   5992481.14355 2089300.95007 37.71639079536521 -122.46794656929701 (37.7163907953652, -122.467946569297)
123984 123984 211058 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 447 Lawton St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 3ft   5992805.57319 2104540.3462 37.7582530810297 -122.467933005722 (37.7582530810297, -122.467933005722)
50595 50595 211057 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 447 Lawton St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 3ft   5992810.26786 2104540.37946 37.7582534434534 -122.467916772063 (37.7582534434534, -122.467916772063)
23569 23569 211718 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 431 Arch St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 4ft   5992705.448530001 2090061.4664900003 37.7184919399203 -122.46722653339701 (37.7184919399203, -122.467226533397)
171576 171576 211717 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 431 Arch St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 4ft   5992705.603080001 2090068.8173099998 37.7185121324114 -122.46722653337099 (37.7185121324114, -122.467226533371)
75798 75798 209607 Undocumented 2 Maytenus boaria :: Mayten 22 488 Arch St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 6ft   5992758.831730001 2090447.2277099998 37.719554228122504 -122.46707004236099 (37.7195542281225, -122.467070042361)
187861 187861 206442 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 488 Arch St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 6ft   5992758.93765 2090436.99405 37.719526135091 -122.467068932605 (37.719526135091, -122.467068932605)
32493 32493 215383 Undocumented 2 Tibochina urvilleana :: Princess Flower 260 270 Arch St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   5992739.059780001 2088994.50565 37.7155642635536 -122.467032825702 (37.7155642635536, -122.467032825702)
159117 159117 210296 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1620 10th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18 Width 3ft   5993107.6826599995 2104438.8623 37.7579918738475 -122.46688081061701 (37.7579918738475, -122.466880810617)
23836 23836 204823 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1331 09th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   5993302.77838 2106404.87542 37.7634012905668 -122.466348974927 (37.7634012905668, -122.466348974927)
181841 181841 211099 Undocumented 2 Pinus radiata :: Monterey Pine 3 501 Saint Francis Blvd 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     46 Width 10ft   5993137.63738 2096084.35497 37.7350542531473 -122.46617009617201 (37.7350542531473, -122.466170096172)
65175 65175 208929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798)
148613 148613 211089 Undocumented 2 Pinus radiata :: Monterey Pine 3 1826 09th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 3ft   5993465.35 2103031.19551 37.754147421393 -122.465541593268 (37.754147421393, -122.465541593268)
1781 1781 214663 Undocumented 2 Tree(s) :: 17 427 Kirkham St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   06/01/2017 12:00:00 AM 3 Width 4ft Permit Number 779947 5993526.84887 2105257.2946900004 37.7602632600539 -122.46549062240601 (37.7602632600539, -122.465490622406)
90472 90472 120871 Undocumented 2 Shrub :: Shrub 98 1387 08th Ave 1 Sidewalk: Curb side : Pot 10 Landscaping 2 Private 1           5993606.0 2106068.0 37.762493810072606 -122.465275766733 (37.7624938100726, -122.465275766733)
175036 175036 206722 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1754 08th Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 2ft   5993756.8033300005 2103555.3829900003 37.755603511019395 -122.46457174369199 (37.7556035110194, -122.464571743692)
162791 162791 206723 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1754 08th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 2ft   5993756.651269999 2103543.92939 37.7555720536195 -122.464571437933 (37.7555720536195, -122.464571437933)
132900 132900 203344 Undocumented 2 Acer palmatum :: Japanese Maple 175 779 Head St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   5993497.055240001 2090994.5846900002 37.721099722042496 -122.464558015558 (37.7210997220425, -122.464558015558)
159985 159985 217535 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 385 Head St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     28 Width 4ft   5993463.79196 2088414.8734 37.714014537420795 -122.464485782892 (37.7140145374208, -122.464485782892)
42892 42892 218825 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 295 Bright St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   5993731.49381 2089150.28883 37.716049240944706 -122.463613852416 (37.7160492409447, -122.463613852416)
177371 177371 208620 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 92 Allston Way 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 4ft   5993943.80464 2098648.69817 37.742141779624795 -122.46356895556801 (37.7421417796248, -122.463568955568)
123744 123744 208884 Undocumented 2 Malus :: Crab Apple 235 450 Bright St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   5993793.0659300005 2090164.68597 37.7188380799952 -122.46347460498001 (37.7188380799952, -122.46347460498)
176316 176316 210950 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 454 Bright St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 6ft   5993793.8030900005 2090199.81591 37.718934580840504 -122.46347460496901 (37.7189345808405, -122.463474604969)
73783 73783 215385 Undocumented 2 Tibochina urvilleana :: Princess Flower 260 522 Bright St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   5993803.26709 2090640.69025 37.7201456609819 -122.46347386933701 (37.7201456609819, -122.463473869337)
186557 186557 207266 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 450 Bright St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   5993794.13591 2090181.7036599999 37.7188848681307 -122.463472140835 (37.7188848681307, -122.463472140835)
186143 186143 177480 Undocumented 2 Malus :: Crab Apple 235 289 Flournoy St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3     5993810.32054 2086750.1830099998 37.7094636621006 -122.46316734172501 (37.7094636621006, -122.463167341725)
34597 34597 211298 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 401 Orizaba Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 5ft   5993996.41913 2089243.4812200002 37.7163203865396 -122.462704908526 (37.7163203865396, -122.462704908526)
31389 31389 211482 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 458 Orizaba Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 1ft   5994045.41043 2089492.79513 37.7170077644759 -122.46255364615699 (37.7170077644759, -122.462553646157)
188473 188473 215418 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10     5994025.68496 2088506.9373700002 37.7142996980529 -122.462550356439 (37.7142996980529, -122.462550356439)
34503 34503 215417 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12     5994025.97554 2088461.57938 37.7141751725286 -122.46254606394699 (37.7141751725286, -122.462546063947)

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