Street_Tree_List

Data source: data.sfgov.org

1,700 rows where qSiteInfo = 10 sorted by qSpecies descending

✎ 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
132359 132359 226827 Undocumented 2 Jubaea chilensis :: Chilean Wine Palm 425 450 Florida St 23 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   6009202.53701 2106019.3538599997 37.763247328434794 -122.41132940635 (37.7632473284348, -122.41132940635)
171335 171335 226826 Undocumented 2 Jubaea chilensis :: Chilean Wine Palm 425 450 Florida St 19 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   6009196.84235 2106071.88839 37.763391256830204 -122.411352813876 (37.7633912568302, -122.411352813876)
44046 44046 197976 Undocumented 2 Torreya californica :: California nutmeg 409 1098 Mississippi St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 5ft   6014198.12012 2102094.83849 37.7527503731308 -122.393776491693 (37.7527503731308, -122.393776491693)
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)
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)
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)
137712 137712 217544 Undocumented 2 Yucca spp :: Yucca 402 1242 Arguello Blvd 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     21 Width 3ft   5995842.68844 2107000.63598 37.7651833214851 -122.457607412677 (37.7651833214851, -122.457607412677)
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)
39211 39211 221969 Undocumented 2 Ailanthus altissima :: Tree Of Heaven 401 3900 22nd St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6002406.820619999 2102995.69652 37.754561606858296 -122.434617293171 (37.7545616068583, -122.434617293171)
73445 73445 187968 Undocumented 2 Ailanthus altissima :: Tree Of Heaven 401 600 Illinois St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 3ft   6015942.9159 2106228.0728700003 37.764196160851796 -122.388031024433 (37.7641961608518, -122.388031024433)
187367 187367 221970 Undocumented 2 Ailanthus altissima :: Tree Of Heaven 401 3900 22nd St 10 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6002405.12131 2102995.45063 37.7545608352344 -122.43462315224701 (37.7545608352344, -122.434623152247)
45306 45306 223878 Undocumented 2 Dicksonia antarctica :: Soft Tree Fern 397 31 Bronte St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 2ft   6009376.271430001 2097261.13323 37.7392089483382 -122.410110157661 (37.7392089483382, -122.410110157661)
35611 35611 136717 Undocumented 2 Tecoma stans :: Trumpet bush 389 1333 Pacific Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6007744.86524 2117813.8042900003 37.7955501948491 -122.41720684013201 (37.7955501948491, -122.417206840132)
165110 165110 238540 Undocumented 2 Prunus subhirtella 'Pendula' :: Weeping Cherry 370 217 Montcalm St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6009894.85304 2099616.29886 37.7457047739516 -122.40848321393699 (37.7457047739516, -122.408483213937)
29394 29394 228372 Undocumented 2 Grevillea spp :: Silkoak species 369 3784 20th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 1ft   6005132.77553 2104314.58442 37.7583373376056 -122.425284057905 (37.7583373376056, -122.425284057905)
43451 43451 220110 Undocumented 2 Acacia cyclops :: Cyclops wattle 366 1301 Diamond St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 6ft   6002012.53381 2100276.70293 37.7470735061305 -122.435786312882 (37.7470735061305, -122.435786312882)
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)
61974 61974 234468 Undocumented 2 Picea Spp :: Spruce Spp 357 1 Newburg St 8 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6002588.30489 2099995.27539 37.7463334612324 -122.433775235453 (37.7463334612324, -122.433775235453)
29706 29706 188799 Undocumented 2 Bambusa spp :: Bamboo Species 346 370 De Haro St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011991.8145 2106659.3783299997 37.7651607368141 -122.401727150587 (37.7651607368141, -122.401727150587)
37162 37162 188802 Undocumented 2 Bambusa spp :: Bamboo Species 346 370 De Haro St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011993.79056 2106593.57945 37.7649801781082 -122.401715690531 (37.7649801781082, -122.401715690531)
45522 45522 221192 Undocumented 2 Bambusa spp :: Bamboo Species 346 38 Dolores St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 8ft   6004728.48786 2108042.49071 37.7685504308788 -122.426947766841 (37.7685504308788, -122.426947766841)
51685 51685 188800 Undocumented 2 Bambusa spp :: Bamboo Species 346 370 De Haro St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011992.462119999 2106639.4556400003 37.7651060697129 -122.401723510151 (37.7651060697129, -122.401723510151)
61293 61293 188801 Undocumented 2 Bambusa spp :: Bamboo Species 346 370 De Haro St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011992.238609999 2106628.45782 37.765075859691294 -122.401723510132 (37.7650758596913, -122.401723510132)
75716 75716 188806 Undocumented 2 Bambusa spp :: Bamboo Species 346 657 Rhode Island St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011845.3937800005 2105334.97386 37.7615160462566 -122.40214046821801 (37.7615160462566, -122.402140468218)
180789 180789 221193 Undocumented 2 Bambusa spp :: Bamboo Species 346 38 Dolores St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 8ft   6004729.52945 2108000.8777 37.7684362304735 -122.42694119996901 (37.7684362304735, -122.426941199969)
180936 180936 188805 Undocumented 2 Bambusa spp :: Bamboo Species 346 657 Rhode Island St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 2ft   6011846.53747 2105316.89164 37.7614664603431 -122.402135241342 (37.7614664603431, -122.402135241342)
184783 184783 188803 Undocumented 2 Bambusa spp :: Bamboo Species 346 370 De Haro St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6011986.97083 2106581.47042 37.7649465488559 -122.401738427204 (37.7649465488559, -122.401738427204)
25116 25116 132137 Undocumented 2 Phoenix roebelenii :: Pigmy Date Palm 344 576 Sacramento St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   6011959.93168 2117122.22989 37.7938875264289 -122.40257323908999 (37.7938875264289, -122.40257323909)
75009 75009 132136 Undocumented 2 Phoenix roebelenii :: Pigmy Date Palm 344 736 Washington St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6011046.66538 2117647.10059 37.7952776660811 -122.40577023270399 (37.7952776660811, -122.405770232704)
148217 148217 132138 Undocumented 2 Phoenix roebelenii :: Pigmy Date Palm 344 576 Sacramento St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 3ft   6011951.559169999 2117121.9101400003 37.7938861810419 -122.40260218645001 (37.7938861810419, -122.40260218645)
168073 168073 136298 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 902 Vallejo St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6009157.405619999 2118748.49482 37.7981959904135 -122.412385286869 (37.7981959904135, -122.412385286869)
24220 24220 188507 Undocumented 2 Abutilon hybridum :: Flowering maple 339 1525 18th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   6013039.99307 2105636.60333 37.7624108600086 -122.398029973803 (37.7624108600086, -122.398029973803)
63035 63035 188506 Undocumented 2 Abutilon hybridum :: Flowering maple 339 1525 18th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   6013026.583219999 2105635.98577 37.762408417445 -122.39807631049999 (37.762408417445, -122.3980763105)
44279 44279 248099 Undocumented 2 Cornus SPP :: Dogwood 336 10 Brewster St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   6010433.82285 2099780.55401 37.7461859517306 -122.40663109974301 (37.7461859517306, -122.406631099743)
173984 173984 225892 Undocumented 2 Fremontodendron spp :: Flannel Bush Tree 331 5300 Diamond Heights Blvd 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 8ft   6001517.16924 2098900.94096 37.743267837842104 -122.437400739863 (37.7432678378421, -122.437400739863)
27555 27555 101445 Permitted Site 1 Prunus persica :: Peach 330 771 Stockton Tunl 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2   Permit Number 25247 6010467.187000001 2116750.7503 37.7927840821229 -122.407712097586 (37.7927840821229, -122.407712097586)
30394 30394 196366 Undocumented 2 Prunus persica :: Peach 330 1797 Bancroft Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 1ft   6013425.402509999 2092793.8234599999 37.7271687591255 -122.395797040827 (37.7271687591255, -122.395797040827)
48645 48645 196360 Undocumented 2 Prunus persica :: Peach 330 1098 Mississippi St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 5ft   6014197.98434 2102073.23717 37.7526910529733 -122.39377544938499 (37.7526910529733, -122.393775449385)
66626 66626 196361 Undocumented 2 Prunus persica :: Peach 330 628 Missouri St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2     6013522.64846 2104174.29793 37.7584225591685 -122.396258142101 (37.7584225591685, -122.396258142101)
125567 125567 143435 Undocumented 2 Prunus persica :: Peach 330 771 Stockton Tunl 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 0ft   6010446.4978 2116858.7221 37.7930793884288 -122.40779130037701 (37.7930793884288, -122.407791300377)
151402 151402 178863 Undocumented 2 Prunus persica :: Peach 330 1555 Cayuga Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 1ft   5998718.88038 2089220.60137 37.7165284168318 -122.44638020607901 (37.7165284168318, -122.446380206079)
152824 152824 101443 Permitted Site 1 Prunus persica :: Peach 330 771 Stockton Tunl 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2   Permit Number 25247 6010450.0538 2116823.4858 37.7929828371273 -122.407776510606 (37.7929828371273, -122.407776510606)
158001 158001 101444 Permitted Site 1 Prunus persica :: Peach 330 771 Stockton Tunl 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2   Permit Number 25247 6010458.7821 2116783.7237 37.7928741486166 -122.40774350511002 (37.7928741486166, -122.40774350511)
24832 24832 246304 Undocumented 2 Brachychiton populneus :: Bottle Tree 329 3996 17th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   6002336.3946 2105898.3028 37.7625274658745 -122.435068430359 (37.7625274658745, -122.435068430359)
152642 152642 246302 Undocumented 2 Brachychiton populneus :: Bottle Tree 329 3996 17th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 0ft   6002339.3547 2105882.3182 37.7624837441274 -122.43505704918002 (37.7624837441274, -122.43505704918)
157749 157749 246303 Undocumented 2 Brachychiton populneus :: Bottle Tree 329 3996 17th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   6002336.9866 2105888.8305 37.7625014908552 -122.435065705348 (37.7625014908552, -122.435065705348)
35731 35731 200325 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 6ft   6015214.59398 2115265.69066 37.788971064105795 -122.391181870273 (37.7889710641058, -122.391181870273)
60170 60170 200326 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015205.462169999 2115275.8226400004 37.7889983774274 -122.39121417389799 (37.7889983774274, -122.391214173898)
133816 133816 200328 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015179.92906 2115301.4953 37.789067451651604 -122.39130431116502 (37.7890674516516, -122.391304311165)
158144 158144 200330 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015108.79029 2115375.2587599996 37.7892660408344 -122.391555603302 (37.7892660408344, -122.391555603302)
174721 174721 200327 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015192.2800199995 2115287.61911 37.78903003626721 -122.391260607709 (37.7890300362672, -122.391260607709)
176832 176832 200331 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015095.90294 2115388.62146 37.7893020164091 -122.391601126991 (37.7893020164091, -122.391601126991)
179530 179530 200329 Undocumented 2 Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 301 Main St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 6ft   6015119.86302 2115363.24254 37.789233661647394 -122.391516452246 (37.7892336616474, -122.391516452246)
26617 26617 126477 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010973.50945 2116764.5912 37.7928504165589 -122.405961165984 (37.7928504165589, -122.405961165984)
48754 48754 126483 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 700 Grant Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010931.99435 2117065.2913900004 37.7936737449935 -122.40612600542102 (37.7936737449935, -122.406126005421)
50695 50695 126479 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010965.179380001 2116818.07903 37.7929968153971 -122.405993758332 (37.7929968153971, -122.405993758332)
52826 52826 126476 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010976.5327699995 2116742.64267 37.79279032025671 -122.405949158227 (37.7927903202567, -122.405949158227)
52958 52958 126480 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 700 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010938.47214 2117002.6943099997 37.7935022308001 -122.406099179531 (37.7935022308001, -122.406099179531)
53863 53863 126484 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 700 Grant Ave 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010928.02315 2117089.46942 37.79373990992 -122.406141450376 (37.79373990992, -122.406141450376)
58335 58335 126482 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 700 Grant Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010934.85343 2117044.17747 37.7936159311689 -122.406114624512 (37.7936159311689, -122.406114624512)
59890 59890 126490 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 48 Spofford St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010571.46321 2117448.9719700003 37.794707066936205 -122.407400541724 (37.7947070669362, -122.407400541724)
63242 63242 126485 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 730 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010918.9479 2117151.41752 37.7939094968665 -122.406177218214 (37.7939094968665, -122.406177218214)
65189 65189 126475 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010979.6308699995 2116716.2496599997 37.792718024660296 -122.405936578515 (37.7927180246603, -122.405936578515)
73908 73908 126486 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 736 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010915.83375 2117183.06415 37.793996216698204 -122.40619022421001 (37.7939962166982, -122.40619022421)
77271 77271 126489 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 740 Grant Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010909.75433 2117242.1436400004 37.7941580946843 -122.40621542412902 (37.7941580946843, -122.406215424129)
92565 92565 116410 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 600x GRANT AVE 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1           6011037.0 2116673.0 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164)
104752 104752 116408 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 600x GRANT AVE 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1           6011037.0 2116673.0 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164)
107020 107020 116412 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 600x GRANT AVE 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1           6011037.0 2116673.0 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164)
128024 128024 116409 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 600x GRANT AVE 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1           6011037.0 2116673.0 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164)
134040 134040 116415 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 616 Grant Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 3x3   6010954.90415 2116873.4164299998 37.793148183903796 -122.406033211575 (37.7931481839038, -122.406033211575)
139163 139163 116411 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 600x GRANT AVE 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1           6011037.0 2116673.0 37.7926024798136 -122.405735030164 (37.7926024798136, -122.405735030164)
146169 146169 126488 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 740 Grant Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010911.68346 2117221.5167 37.7941015659862 -122.406207295144 (37.7941015659862, -122.406207295144)
150207 150207 116416 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 654 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1     6010952.55495 2116896.00924 37.793210086935396 -122.40604293235701 (37.7932100869354, -122.406042932357)
151278 151278 116414 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 616 Grant Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1     6010958.19294 2116856.3996900003 37.7931016439695 -122.406020632759 (37.7931016439695, -122.406020632759)
155516 155516 116413 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 616 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1     6010963.21196 2116835.06885 37.7930433553227 -122.40600176317801 (37.7930433553227, -122.406001763178)
167256 167256 116417 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 654 Grant Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1     6010951.3253 2116916.7689799997 37.79326701941329 -122.406048650219 (37.7932670194133, -122.406048650219)
168534 168534 126481 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 700 Grant Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010936.07876 2117021.70057 37.793554283548104 -122.406108800487 (37.7935542835481, -122.406108800487)
175740 175740 126478 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010968.42489 2116798.92375 37.7929444011198 -122.40598117859699 (37.7929444011198, -122.405981178597)
183558 183558 126474 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 614 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010981.69424 2116687.73797 37.7926398538057 -122.40592742973301 (37.7926398538057, -122.405927429733)
187846 187846 126487 Undocumented 2 Elaeocarpus decipiens :: Japanese Blueberry Tree 326 740 Grant Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6010914.3312099995 2117201.57703 37.79404696456071 -122.40619672810301 (37.7940469645607, -122.406196728103)
177663 177663 223867 Undocumented 2 Cussonia spicata :: Cabbage tree 325 1192 Guerrero St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 2ft   6005747.79395 2102034.14409 37.7521105046093 -122.42299496946801 (37.7521105046093, -122.422994969468)
77177 77177 241121 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 783 27th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6001494.78368 2099962.34068 37.746180918217796 -122.437554137212 (37.7461809182178, -122.437554137212)
82513 82513 136720 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 1074 Vallejo St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004587.59181 2118109.43364 37.7961837897023 -122.42815263445699 (37.7961837897023, -122.428152634457)
156462 156462 215376 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 450 Orizaba Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 6ft   5994050.06731 2089427.8960900002 37.7168298353999 -122.462532844816 (37.7168298353999, -122.462532844816)
161129 161129 241127 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 3900 22nd St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6002418.3880900005 2102995.1763400002 37.7545608352381 -122.43457725265499 (37.7545608352381, -122.434577252655)
165609 165609 241128 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 3900 22nd St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6002414.71271 2102994.9709799998 37.754560062723606 -122.434589948393 (37.7545600627236, -122.434589948393)
174743 174743 241120 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 743 Duncan St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 8ft   6001715.8268 2099681.5159400003 37.745422404833704 -122.436769699986 (37.7454224048337, -122.436769699986)
175463 175463 179918 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 270 Rome St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 0ft   5998460.475459999 2088893.2905 37.7156149340708 -122.447249834324 (37.7156149340708, -122.447249834324)
184259 184259 136719 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 1074 Vallejo St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004612.94283 2118113.6441200003 37.796196784912404 -122.42806521496401 (37.7961967849124, -122.428065214964)
187991 187991 215375 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 450 Orizaba Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 6ft   5994049.9247 2089421.0969200002 37.716811158290206 -122.462532844839 (37.7168111582902, -122.462532844839)
40880 40880 227528 Undocumented 2 Liquidambar orientalis :: Oriental Sweet Gum 312 18 Worth St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6000854.651000001 2103166.63578 37.7549427269363 -122.439997349707 (37.7549427269363, -122.439997349707)
181070 181070 227527 Undocumented 2 Liquidambar orientalis :: Oriental Sweet Gum 312 18 Worth St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6000853.892999999 2103182.27868 37.7549856353975 -122.440001092669 (37.7549856353975, -122.440001092669)
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)
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)
131479 131479 233339 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 4750 17th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   5998413.4057599995 2105689.21442 37.7617298240875 -122.448621500105 (37.7617298240875, -122.448621500105)
136168 136168 233347 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 630 Alvarado St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 4ft   6002310.34466 2102682.0745599996 37.753694998543 -122.43492850446 (37.753694998543, -122.43492850446)
137842 137842 233341 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 181 Elsie St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13     6006970.42421 2098142.10929 37.7414927703813 -122.418490966799 (37.7414927703813, -122.418490966799)
149765 149765 233349 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 1847 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10     6002644.4365300005 2100086.75284 37.7465878218663 -122.433587675538 (37.7465878218663, -122.433587675538)
155251 155251 233351 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 554 Duncan St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   6002951.610280001 2099802.94851 37.745825985493795 -122.432505234436 (37.7458259854938, -122.432505234436)
161494 161494 233340 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 181 Elsie St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16     6006969.35222 2098138.0175 37.741481474889795 -122.418494383305 (37.7414814748898, -122.418494383305)

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