Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
127276 127276 189776 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Jack Balestreri Way 42 Front Yard : Yard 7 Tree 1 Private 1     5     6012433.20724 2104795.86153 37.760068555049 -122.400069588557 (37.760068555049, -122.400069588557)
44286 44286 189792 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 651 Missouri St 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6013593.88297 2104014.53961 37.7579878610588 -122.396000584357 (37.7579878610588, -122.396000584357)
26803 26803 189610 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Sherman St 23 : 4 Tree 1 Private 1     18 Width 10ft   6010659.83752 2111049.78613 37.7771413675214 -122.406643580555 (37.7771413675214, -122.406643580555)
188717 188717 226559 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Dolores St 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   6004935.37263 2104529.68791 37.758916806783795 -122.425982076637 (37.7589168067838, -122.425982076637)
165354 165354 189609 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Sherman St 22 : 4 Tree 1 Private 1     25 Width 10ft   6010683.9349 2111025.68412 37.777076537191 -122.40655852086799 (37.777076537191, -122.406558520868)
45367 45367 189608 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Sherman St 21 : 4 Tree 1 Private 1     27 Width 10ft   6010698.53691 2111009.64615 37.7770333175687 -122.406506877295 (37.7770333175687, -122.406506877295)
163742 163742 189680 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 21 : Yard 23 Tree 1 Private 1     9     6017213.38014 2102597.10976 37.754296605427704 -122.38338403586701 (37.7542966054277, -122.383384035867)
55860 55860 111803 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55X Sherman St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     26 3x3   6010715.3243 2110993.12608 37.7769888964448 -122.40644763986099 (37.7769888964448, -122.406447639861)
67403 67403 189713 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6012646.78195 2104977.7853099997 37.7605799833111 -122.399343702572 (37.7605799833111, -122.399343702572)
174582 174582 189679 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 20 : Yard 23 Tree 1 Private 1     12     6017238.946959999 2102621.26617 37.7543643468473 -122.383297299846 (37.7543643468473, -122.383297299846)
35783 35783 190191 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014196.52235 2116758.43159 37.7930132334149 -122.394808872924 (37.7930132334149, -122.394808872924)
43693 43693 111802 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55X Sherman St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     25 3x3   6010732.9183 2110973.0919 37.7769348714848 -122.406385364505 (37.7769348714848, -122.406385364505)
58003 58003 189678 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 19 : Yard 23 Tree 1 Private 1     15     6017295.34569 2102596.83049 37.7543003681831 -122.38310055604299 (37.7543003681831, -122.383100556043)
183627 183627 190222 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6013803.43664 2116745.28006 37.7929552586387 -122.39616805881599 (37.7929552586387, -122.396168058816)
33776 33776 128430 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011861.722680001 2116708.95786 37.792747296703 -122.402883973743 (37.792747296703, -122.402883973743)
43867 43867 189712 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6012644.68977 2104989.85234 37.7606130001075 -122.399351785657 (37.7606130001075, -122.399351785657)
51330 51330 190221 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6013811.255030001 2116734.0786 37.792924937074 -122.396140221195 (37.792924937074, -122.396140221195)
74071 74071 190190 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014188.11441 2116766.87756 37.793035956581896 -122.394838556859 (37.7930359565819, -122.394838556859)
182904 182904 111801 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55X Sherman St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x3   6010771.68914 2110936.4486 37.7768364262956 -122.40624866125401 (37.7768364262956, -122.406248661254)
185692 185692 190114 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010606.0053900005 2107358.47005 37.7670028523175 -122.406569620302 (37.7670028523175, -122.406569620302)
29719 29719 128586 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6013211.38418 2117897.25259 37.796085342709496 -122.39829746727 (37.7960853427095, -122.39829746727)
43496 43496 189711 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6012646.51479 2105003.00325 37.7606492113219 -122.39934639692899 (37.7606492113219, -122.399346396929)
64025 64025 190189 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014177.33793 2116777.5076599997 37.7930645451544 -122.394876589194 (37.7930645451544, -122.394876589194)
67162 67162 190113 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010606.3224599995 2107337.40801 37.766945038495 -122.406567039242 (37.766945038495, -122.406567039242)
74759 74759 128429 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011844.46069 2116707.43706 37.792742157061895 -122.40294359429501 (37.7927421570619, -122.402943594295)
165859 165859 111800 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55X Sherman St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x3   6010798.82321 2110910.53582 37.77676679357771 -122.40615296978599 (37.7767667935777, -122.406152969786)
170527 170527 190220 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6013821.46855 2116723.04512 37.792895209998896 -122.39610410804501 (37.7928952099989, -122.396104108045)
29372 29372 190112 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010607.49637 2107318.24064 37.766892474940704 -122.406561628027 (37.7668924749407, -122.406561628027)
31624 31624 189661 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2585 03rd St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6015908.09217 2103411.17152 37.756459622437795 -122.38795489320499 (37.7564596224378, -122.387954893205)
49011 49011 128428 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6011825.90812 2116704.07069 37.7927318778276 -122.403007550457 (37.7927318778276, -122.403007550457)
62877 62877 190188 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014167.07042 2116786.79243 37.7930894680536 -122.394912766214 (37.7930894680536, -122.394912766214)
130337 130337 190219 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6013832.7779 2116712.42243 37.792866671815204 -122.396064232074 (37.7928666718152, -122.396064232074)
133809 133809 128585 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6013200.30009 2117895.49688 37.796079904520894 -122.398335697429 (37.7960799045209, -122.398335697429)
159986 159986 247038 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 550x Valley St 16 Median : Yard 3 Tree 1 DPW 2     11     6002247.5223900005 2099161.75856 37.7440254762006 -122.434894020862 (37.7440254762006, -122.434894020862)
189040 189040 127212 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2332 Baker St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999771.60185 2117008.74774 37.7928879353713 -122.444737723873 (37.7928879353713, -122.444737723873)
6980 6980 98636 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 15 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   12 6x6   6002249.0569400005 2120273.69699 37.8019937006086 -122.436399401415 (37.8019937006086, -122.436399401415)
39281 39281 128703 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 300 Washington St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012655.23213 2117873.10702 37.795988049574206 -122.400220179125 (37.7959880495742, -122.400220179125)
41946 41946 127249 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2401 Broadway 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6002092.09211 2117350.15553 37.7939574999807 -122.436733176716 (37.7939574999807, -122.436733176716)
42155 42155 190111 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010608.178590001 2107298.817 37.7668391802187 -122.406557899443 (37.7668391802187, -122.406557899443)
44100 44100 127211 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2332 Baker St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5999776.24036 2116986.964 37.7928283876642 -122.444720107969 (37.7928283876642, -122.444720107969)
65895 65895 190167 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 70 Steuart St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6014572.75023 2116880.89964 37.793370413561796 -122.39351566853 (37.7933704135618, -122.39351566853)
130379 130379 190187 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014157.1086 2116797.9399099997 37.793119522505606 -122.394948016065 (37.7931195225056, -122.394948016065)
151223 151223 224421 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Treat Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   6008563.90171 2106197.90924 37.7637017612388 -122.413550871184 (37.7637017612388, -122.413550871184)
158652 158652 128427 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6011807.080519999 2116702.58176 37.7927267382026 -122.403072590339 (37.7927267382026, -122.403072590339)
171853 171853 126718 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2350 Green St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   6001609.63526 2118047.91792 37.7958459431991 -122.438452537456 (37.7958459431991, -122.438452537456)
172760 172760 190218 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6013843.87856 2116702.23697 37.79283932253829 -122.39602510886999 (37.7928393225383, -122.39602510887)
179585 179585 128584 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6013176.38236 2117892.90169 37.796071446395004 -122.398418275879 (37.796071446395, -122.398418275879)
3628 3628 127357 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Webster St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 4ft   6003276.2668 2116362.2656799997 37.791312234126295 -122.432565221033 (37.7913122341263, -122.432565221033)
33228 33228 224420 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Treat Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008554.675480001 2106165.5358700003 37.7636123533609 -122.41358049213999 (37.7636123533609, -122.41358049214)
54843 54843 128426 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011789.8061 2116700.43731 37.7927198853778 -122.40313220998199 (37.7927198853778, -122.403132209982)
55750 55750 126634 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2800 Divisadero St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6000614.8529199995 2118015.66138 37.7957007404413 -122.44189234447501 (37.7957007404413, -122.441892344475)
56918 56918 190166 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 70 Steuart St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6014549.85525 2116906.5438099997 37.7934395543337 -122.393596683051 (37.7934395543337, -122.393596683051)
76452 76452 192132 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 807 Mission St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 4ft   6011323.05989 2113588.9922599997 37.7841505189681 -122.40452805764299 (37.7841505189681, -122.404528057643)
116178 116178 453 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 740X 23rd Ave 14 Median : Cutout 11 Tree 1 DPW 2     12     5988823.177519999 2110218.88788 37.773614029759706 -122.482121711467 (37.7736140297597, -122.482121711467)
132581 132581 128702 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 300 Washington St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012674.0223199995 2117875.6899200003 37.7959961893179 -122.400155342505 (37.7959961893179, -122.400155342505)
137284 137284 189677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 14 : Yard 23 Tree 1 Private 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
155526 155526 190186 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014146.05348 2116808.04145 37.7931466442461 -122.394986975567 (37.7931466442461, -122.394986975567)
162286 162286 128180 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 211 Beach St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009206.52491 2122174.9503099998 37.80760693967 -122.41245764811801 (37.80760693967, -122.412457648118)
166212 166212 189710 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6012645.571 2105014.07683 37.7606795643282 -122.39935043848999 (37.7606795643282, -122.39935043849)
166467 166467 127210 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2332 Baker St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5999778.1743 2116971.1510799997 37.7927850799155 -122.44471227935699 (37.7927850799155, -122.444712279357)
167139 167139 128583 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6013161.5163900005 2117889.9024400003 37.7960623830203 -122.39846950485901 (37.7960623830203, -122.398469504859)
174941 174941 112710 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 100 North Point St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6009944.989709999 2121981.1208599997 37.8071161463469 -122.40988831469 (37.8071161463469, -122.40988831469)
175943 175943 190110 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010609.78055 2107275.1616 37.7667743175026 -122.40655069138799 (37.7667743175026, -122.406550691388)
182898 182898 190217 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6013852.83638 2116693.6107400004 37.7928161353103 -122.395993509389 (37.7928161353103, -122.395993509389)
186430 186430 128282 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Francisco St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011187.65635 2121403.39656 37.805599422647205 -122.40554706506201 (37.8055994226472, -122.405547065062)
29482 29482 128425 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011770.64614 2116698.01908 37.7927121754866 -122.403198334431 (37.7927121754866, -122.403198334431)
41170 41170 126717 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2350 Green St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6001632.11762 2118051.74254 37.7958577234076 -122.438375018588 (37.7958577234076, -122.438375018588)
54585 54585 192117 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 367 Tehama St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011557.32481 2112660.98946 37.781615529763705 -122.403652263664 (37.7816155297637, -122.403652263664)
56712 56712 190216 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6013858.93345 2116683.31017 37.792788191571 -122.395971690938 (37.792788191571, -122.395971690938)
60628 60628 112709 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 100 North Point St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6009982.61169 2121986.87678 37.8071340590486 -122.409758521838 (37.8071340590486, -122.409758521838)
62530 62530 189709 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6012645.7874300005 2105024.7394 37.760708853455704 -122.399350438495 (37.7607088534557, -122.399350438495)
64432 64432 189622 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1022 Harrison St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 0ft   6010815.005059999 2110468.41734 37.7755537439388 -122.406065837194 (37.7755537439388, -122.406065837194)
64470 64470 128677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 250 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6013274.45075 2117959.00066 37.7962584010691 -122.39808357702 (37.7962584010691, -122.39808357702)
71225 71225 192131 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 807 Mission St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6011287.52807 2113553.9917200003 37.784052429914496 -122.404648520918 (37.7840524299145, -122.404648520918)
73532 73532 224419 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Treat Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6008550.92068 2106134.213 37.7635261371397 -122.41359126333 (37.7635261371397, -122.41359126333)
74429 74429 117416 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Beach St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6010137.827269999 2122299.49705 37.8080011332052 -122.409243437841 (37.8080011332052, -122.409243437841)
86980 86980 454 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 740X 23rd Ave 13 Median : Cutout 11 Tree 1 DPW 2     12 8-HOA   5988822.540159999 2110230.27386 37.7736452554339 -122.482124750469 (37.7736452554339, -122.482124750469)
91225 91225 102347 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401X Shotwell St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6007842.0 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168)
135473 135473 128139 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2600 Jones St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007843.1671400005 2121954.12395 37.8069240026131 -122.417160222869 (37.8069240026131, -122.417160222869)
137461 137461 128179 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 211 Beach St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009178.9677099995 2122171.51863 37.8075959706319 -122.41255277389601 (37.8075959706319, -122.412552773896)
150764 150764 190185 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014134.54859 2116822.4237599997 37.793185494956205 -122.395027791311 (37.7931854949562, -122.395027791311)
162083 162083 190252 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 60 New Montgomery St 13 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6012311.13686 2114949.13545 37.787940324123895 -122.40120525333201 (37.7879403241239, -122.401205253332)
164217 164217 128281 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Francisco St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6011166.44271 2121400.19755 37.8055894527535 -122.405620252789 (37.8055894527535, -122.405620252789)
174903 174903 247035 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 550x Valley St 13 Median : Yard 3 Tree 1 DPW 2     13     6002263.72164 2099154.77603 37.7440072235471 -122.434837508343 (37.7440072235471, -122.434837508343)
178329 178329 128582 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6013142.92236 2117888.29945 37.7960569457318 -122.39853373176001 (37.7960569457318, -122.39853373176)
178819 178819 128701 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 300 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012701.41446 2117879.31888 37.796007680862495 -122.400060814761 (37.7960076808625, -122.400060814761)
179345 179345 190165 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 70 Steuart St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6014495.0412099995 2116963.1449599997 37.7935919219713 -122.393790308884 (37.7935919219713, -122.393790308884)
1055 1055 21993 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2585 03rd St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x6   6015910.4355 2103353.3332599998 37.756300940646604 -122.387942753271 (37.7563009406466, -122.387942753271)
3624 3624 127356 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Webster St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 4ft   6003284.8942599995 2116317.33043 37.7911893426569 -122.432532159241 (37.7911893426569, -122.432532159241)
24608 24608 128760 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 145 Geary St 12 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6010990.83089 2114854.39463 37.7876064418291 -122.405766620129 (37.7876064418291, -122.405766620129)
28927 28927 128021 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 590 Bay St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007952.56091 2121365.3944200003 37.8053136540608 -122.416739907614 (37.8053136540608, -122.416739907614)
31174 31174 117415 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Beach St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6010118.81969 2122297.52404 37.80799465090929 -122.409309079351 (37.8079946509093, -122.409309079351)
35970 35970 128581 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6013126.3118199995 2117886.43579 37.796050903174404 -122.398591077039 (37.7960509031744, -122.398591077039)
38994 38994 128607 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 302 Clay St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6012670.89273 2117564.301 37.795141015008895 -122.40014429162599 (37.7951410150089, -122.400144291626)
45377 45377 190109 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010611.70851 2107235.48827 37.76666549143621 -122.40654122690901 (37.7666654914362, -122.406541226909)
46777 46777 190215 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6013870.43809 2116671.60072 37.7927566802183 -122.395931063169 (37.7927566802183, -122.395931063169)
49136 49136 190184 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014124.78467 2116830.09673 37.7932060201865 -122.39506211302601 (37.7932060201865, -122.395062113026)
56824 56824 128121 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2300 Stockton St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009748.99291 2122207.7373200003 37.8077273921614 -122.410582619197 (37.8077273921614, -122.410582619197)
59862 59862 192130 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 807 Mission St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6011272.2794699995 2113542.3230000003 37.784019538101894 -122.404700454088 (37.7840195381019, -122.404700454088)
61781 61781 190251 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 60 New Montgomery St 12 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6012303.628740001 2114957.4255 37.7879626677826 -122.401231813001 (37.7879626677826, -122.401231813001)

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