Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by Location descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▲
60061 60061 135166 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009296.71843 2122542.1924 37.8086203551155 -122.412171482933 (37.8086203551155, -122.412171482933)
64496 64496 135164 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6009318.816980001 2122537.49043 37.808608684618605 -122.412094671852 (37.8086086846186, -122.412094671852)
52747 52747 135162 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009337.24139 2122533.99681 37.8086001257557 -122.41203066168998 (37.8086001257557, -122.41203066169)
171105 171105 135160 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009356.48989 2122529.06979 37.8085876773375 -122.411963698174 (37.8085876773375, -122.411963698174)
48102 48102 135159 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009379.72618 2122524.34495 37.8085760077391 -122.41188294806001 (37.8085760077391, -122.41188294806)
137623 137623 135158 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009395.60812 2122521.7536 37.808569783535106 -122.41182780071199 (37.8085697835351, -122.411827800712)
33779 33779 135154 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009495.3394 2122500.7310200003 37.80851765524471 -122.41148116512 (37.8085176552447, -122.41148116512)
160660 160660 135152 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6009514.303780001 2122495.80991 37.808505206806004 -122.411415185469 (37.808505206806, -122.411415185469)
58970 58970 135150 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009533.57548 2122492.01614 37.8084958709589 -122.41134822196301 (37.8084958709589, -122.411348221963)
68355 68355 135148 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009553.896240001 2122488.10727 37.808486277873605 -122.41127761976101 (37.8084862778736, -122.411277619761)
163339 163339 135128 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 7ft   6009778.15443 2122482.07693 37.808482294798104 -122.410501083081 (37.8084822947981, -122.410501083081)
169413 169413 135146 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6009571.76938 2122485.2677 37.8084794835077 -122.411215563861 (37.8084794835077, -122.411215563861)
47889 47889 135126 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6009794.33207 2122480.55113 37.808479012257706 -122.410444987853 (37.8084790122577, -122.410444987853)
150944 150944 135124 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6009811.99757 2122478.3969 37.8084740875856 -122.41038369905701 (37.8084740875856, -122.410383699057)
132500 132500 135144 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6009592.59224 2122479.55439 37.808464963961896 -122.411143096484 (37.8084649639619, -122.411143096484)
29183 29183 135142 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009611.73281 2122475.6117 37.8084552117099 -122.411076576336 (37.8084552117099, -122.411076576336)
64005 64005 135140 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009635.03806 2122470.3531 37.8084420798001 -122.410995550124 (37.8084420798001, -122.410995550124)
45068 45068 135138 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009649.7092699995 2122468.55895 37.808437976201404 -122.410944649373 (37.8084379762014, -122.410944649373)
56314 56314 135119 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6009951.286669999 2122420.2562 37.808322255030106 -122.40989754175399 (37.8083222550301, -122.409897541754)
139028 139028 135116 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6009971.32821 2122416.85808 37.8083140478199 -122.409827942302 (37.8083140478199, -122.409827942302)
176363 176363 135114 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009988.36934 2122413.52121 37.808305840604206 -122.409768730958 (37.8083058406042, -122.409768730958)
153425 153425 135111 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6010025.476419999 2122407.9816 37.8082927096198 -122.409639920168 (37.8082927096198, -122.409639920168)
179244 179244 135108 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6010050.318469999 2122404.48556 37.8082845023835 -122.40955370033998 (37.8082845023835, -122.40955370034)
49200 49200 135105 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6010067.690119999 2122402.63653 37.8082803987861 -122.409493450268 (37.8082803987861, -122.409493450268)
42866 42866 135103 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6010086.51333 2122398.36657 37.80826972922029 -122.40942800570299 (37.8082697292203, -122.409428005703)
153466 153466 134965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009712.7239 2122389.48119 37.8082243818107 -122.410720980795 (37.8082243818107, -122.410720980795)
165728 165728 134967 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6009753.391419999 2122386.8985 37.8082195704377 -122.410580057033 (37.8082195704377, -122.410580057033)
131497 131497 134966 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009730.51186 2122386.61497 37.808217509201704 -122.41065921807 (37.8082175092017, -122.41065921807)
151134 151134 134968 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009782.97322 2122383.0408 37.8082106365745 -122.41047740841101 (37.8082106365745, -122.410477408411)
181018 181018 134969 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009807.0374300005 2122379.79592 37.8082030759684 -122.410393898262 (37.8082030759684, -122.410393898262)
154015 154015 134970 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009821.57971 2122377.9972900003 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359)
34855 34855 134971 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6009844.1621199995 2122376.03453 37.8081948291999 -122.41026515223 (37.8081948291999, -122.41026515223)
181647 181647 134972 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009871.42123 2122369.22021 37.8081776467351 -122.41017033311199 (37.8081776467351, -122.410170333112)
65347 65347 134973 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009889.50127 2122368.35067 37.808176272591794 -122.41010770071001 (37.8081762725918, -122.41010770071)
137451 137451 134974 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009910.79688 2122364.91216 37.808168024892 -122.410033758463 (37.808168024892, -122.410033758463)
46112 46112 134975 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009928.574659999 2122361.54548 37.808159777214705 -122.409971995727 (37.8081597772147, -122.409971995727)
76087 76087 134976 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009945.63465 2122359.94576 37.808156340907004 -122.409912841929 (37.808156340907, -122.409912841929)
175640 175640 134977 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009962.1815599995 2122357.85605 37.808151530425704 -122.40985542918001 (37.8081515304257, -122.40985542918)
168373 168373 135089 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 47 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010261.39064 2122348.4681700002 37.8081425174406 -122.40881927081499 (37.8081425174406, -122.408819270815)
38055 38055 134980 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6009736.585940001 2122356.6353700003 37.8081355332869 -122.410636078516 (37.8081355332869, -122.410636078516)
152361 152361 134979 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6009717.25232 2122356.15564 37.808133132108395 -122.4107029539 (37.8081331321084, -122.4107029539)
29517 29517 135087 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 45 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010278.59779 2122338.55223 37.8081162545339 -122.408759020708 (37.8081162545339, -122.408759020708)
34960 34960 135084 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 42 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6010314.2182599995 2122318.99449 37.8080645489009 -122.40863436569201 (37.8080645489009, -122.408634365692)
64424 64424 135082 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 40 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6010330.81932 2122308.7922400003 37.8080374658197 -122.408576193042 (37.8080374658197, -122.408576193042)
153265 153265 134978 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2350 Stockton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6009731.6479400005 2122319.12499 37.8080322623412 -122.41065051712201 (37.8080322623412, -122.410650517122)
133811 133811 135080 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 38 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010349.21464 2122298.25404 37.8080095607584 -122.408511787199 (37.8080095607584, -122.408511787199)
73434 73434 135078 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 36 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6010369.3857 2122286.4841400003 37.80797837316371 -122.408441149043 (37.8079783731637, -122.408441149043)
33678 33678 135076 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 34 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010384.52328 2122278.10501 37.807956213866 -122.408388169972 (37.807956213866, -122.408388169972)
61053 61053 135074 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6010403.22449 2122267.85965 37.807929129896294 -122.408322726326 (37.8079291298963, -122.408322726326)
62281 62281 135072 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6010421.04395 2122258.5290599996 37.8079045082466 -122.408260398818 (37.8079045082466, -122.408260398818)
31717 31717 135070 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6010442.39712 2122245.83866 37.8078708592274 -122.4081856049 (37.8078708592274, -122.4081856049)
63768 63768 135068 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010459.38358 2122239.81285 37.8078552649664 -122.408126393527 (37.8078552649664, -122.408126393527)
144819 144819 135066 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6010478.35466 2122228.06751 37.8078240773895 -122.408059910256 (37.8078240773895, -122.408059910256)
187860 187860 135064 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6010496.20464 2122220.2308799997 37.8078035593512 -122.407997582726 (37.8078035593512, -122.407997582726)
67452 67452 135062 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6010517.55761 2122207.54054 37.8077699103182 -122.40792278972602 (37.8077699103182, -122.407922789726)
61438 61438 135060 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6010535.39568 2122199.10611 37.8077477501305 -122.407860461315 (37.8077477501305, -122.407860461315)
56874 56874 135058 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6010554.37876 2122187.95865 37.8077182047045 -122.407793978909 (37.8077182047045, -122.407793978909)
69492 69492 135056 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6010573.93776 2122175.6033099997 37.8076853749428 -122.407725418214 (37.8076853749428, -122.407725418214)
54152 54152 135194 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 33 Bay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   6010953.55365 2121723.39359 37.806464962561996 -122.40637977613301 (37.806464962562, -122.406379776133)
23600 23600 135193 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 35 Bay St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   6010885.4927900005 2121705.9799599997 37.806413341469 -122.40661408636801 (37.806413341469, -122.406614086368)
137627 137627 127077 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 235 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6002342.007569999 2121872.97995 37.806390190207296 -122.43619226415501 (37.8063901902073, -122.436192264155)
56832 56832 135192 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 35 Bay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   6010823.80585 2121697.83678 37.806387530914 -122.406826991865 (37.806387530914, -122.406826991865)
149043 149043 135191 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 35 Bay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 8ft   6010790.5648300005 2121695.9208 37.8063804101047 -122.406941893775 (37.8063804101047, -122.406941893775)
177000 177000 135190 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 35 Bay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 8ft   6010769.03716 2121693.76645 37.8063732901518 -122.407016242525 (37.8063732901518, -122.407016242525)
37106 37106 127078 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 235 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6002357.66417 2121865.24389 37.8063698385551 -122.43613752782801 (37.8063698385551, -122.436137527828)
64865 64865 111721 DPW Maintained 3 Populus spp :: Poplar Spp 276 950X Beach St 2 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
86010 86010 111722 DPW Maintained 3 Populus spp :: Poplar Spp 276 950X Beach St 3 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
91241 91241 111724 DPW Maintained 3 Populus spp :: Poplar Spp 276 950X Beach St 5 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
100349 100349 111723 DPW Maintained 3 Populus spp :: Poplar Spp 276 950X Beach St 4 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
25716 25716 135893 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 323 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
74939 74939 135892 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 323 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6001823.0897 2121828.5954400003 37.8062388262166 -122.437984887306 (37.8062388262166, -122.437984887306)
76508 76508 125805 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 349 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6001675.8593 2121806.39816 37.8061695046764 -122.43849281089399 (37.8061695046764, -122.438492810894)
178658 178658 125006 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3776 Fillmore St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6002042.338930001 2121722.74316 37.805960649714706 -122.43721855518999 (37.8059606497147, -122.43721855519)
169457 169457 136644 Undocumented 2 Taxus baccata :: Irish Yew 241 3801 Webster St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6002496.137519999 2121660.90327 37.8058166394946 -122.43564368853201 (37.8058166394946, -122.435643688532)
159262 159262 136645 Undocumented 2 Taxus baccata :: Irish Yew 241 3801 Webster St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6002496.65751 2121656.65619 37.8058050076721 -122.435641584993 (37.8058050076721, -122.435641584993)
152305 152305 136646 Undocumented 2 Taxus baccata :: Irish Yew 241 3801 Webster St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6002496.98739 2121653.0183200003 37.8057950377808 -122.435640182969 (37.8057950377808, -122.435640182969)
159857 159857 127086 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400 Jefferson St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6002483.38051 2121629.71373 37.805730276683 -122.435685603204 (37.805730276683, -122.435685603204)
165788 165788 127087 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400 Jefferson St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6002472.472999999 2121628.13466 37.8057253214215 -122.435723237152 (37.8057253214215, -122.435723237152)
179023 179023 127088 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400 Jefferson St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6002460.11203 2121626.40487 37.805719869750796 -122.43576589021002 (37.8057198697508, -122.43576589021)
26930 26930 136782 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 181 Marina Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 2ft   6002679.8644199995 2121606.5592 37.8056778588023 -122.435003985458 (37.8056778588023, -122.435003985458)
136434 136434 127093 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3760 Webster St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6002551.5488 2121587.4680000003 37.8056181528115 -122.43544667313299 (37.8056181528115, -122.435446673133)
51465 51465 131866 Undocumented 2 Olea europaea :: Olive Tree 41 555 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6000334.74544 2121624.79375 37.805594490755 -122.443120895728 (37.805594490755, -122.443120895728)
29360 29360 131865 Undocumented 2 Olea europaea :: Olive Tree 41 555 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6000313.878190001 2121622.81545 37.8055878690403 -122.443192967399 (37.8055878690403, -122.443192967399)
169619 169619 127092 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3760 Webster St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6002552.31278 2121575.31673 37.805584832026796 -122.435443159487 (37.8055848320268, -122.435443159487)
35748 35748 124820 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 290 Cervantes Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6000687.14631 2121612.80249 37.805581652937896 -122.44190050493 (37.8055816529379, -122.44190050493)
66885 66885 125017 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 159 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 2ft   6002727.1155900005 2121565.16212 37.8055668761666 -122.434837503846 (37.8055668761666, -122.434837503846)
149153 149153 124821 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 290 Cervantes Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6000708.003409999 2121598.0387 37.8055423039982 -122.44182726592399 (37.8055423039982, -122.441827265924)
69843 69843 124853 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 55 Casa Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6001524.844 2121579.60518 37.805538200384795 -122.43899915981001 (37.8055382003848, -122.43899915981)
24378 24378 124854 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 55 Casa Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6001534.02589 2121572.74926 37.8055198982766 -122.438966893034 (37.8055198982766, -122.438966893034)
180094 180094 127057 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 611 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6000007.820169999 2121578.04915 37.805447496574004 -122.44424890187099 (37.805447496574, -122.444248901871)
76946 76946 124822 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 290 Cervantes Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6000755.219269999 2121561.6527400003 37.8054450881704 -122.44166125645901 (37.8054450881704, -122.441661256459)
51880 51880 127056 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 611 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999997.13941 2121576.82436 37.805443524274004 -122.444285775883 (37.805443524274, -122.444285775883)
173613 173613 127055 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 619 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5999957.78015 2121570.64869 37.8054243219321 -122.444421539327 (37.8054243219321, -122.444421539327)
167525 167525 127054 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 619 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999943.21158 2121568.78119 37.8054183630406 -122.444471821338 (37.8054183630406, -122.444471821338)
72918 72918 125018 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 137 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 2ft   6002823.9951 2121486.12437 37.8053553592351 -122.43449658436899 (37.8053553592351, -122.434496584369)
44586 44586 125019 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 135 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6002839.24225 2121472.8453599997 37.8053197640715 -122.43444286966499 (37.8053197640715, -122.434442869665)
56366 56366 127083 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 129 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 2ft   6002845.61482 2121466.23172 37.8053019664882 -122.43442034344 (37.8053019664882, -122.43442034344)
129701 129701 127084 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 129 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 2ft   6002859.14133 2121454.4841400003 37.8052704785265 -122.43437269285499 (37.8052704785265, -122.434372692855)
136954 136954 132410 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 745 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 2ft   5999410.35977 2121494.73276 37.8051846283209 -122.446310488859 (37.8051846283209, -122.446310488859)
42156 42156 124996 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 233 Cervantes Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 2ft   6000861.45694 2121438.45328 37.8051128678164 -122.441284762493 (37.8051128678164, -122.441284762493)

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