Street_Tree_List

Data source: data.sfgov.org

3,964 rows where qSpecies = 5 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
26568 26568 124644 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Arguello Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 9ft   5995537.35644 2115745.75128 37.7891775496077 -122.459296819974 (37.7891775496077, -122.459296819974)
31464 31464 123190 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 575 09th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 9ft   5993120.96689 2111576.90099 37.7775918025948 -122.46735389958401 (37.7775918025948, -122.467353899584)
43162 43162 123191 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 571 09th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 9ft   5993121.2243 2111602.66813 37.777662567064205 -122.467354883235 (37.7776625670642, -122.467354883235)
169555 169555 125268 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2960 Van Ness Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6005626.14224 2120703.55494 37.8033652908254 -122.42474367328 (37.8033652908254, -122.42474367328)
173924 173924 220153 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1201 San Jose Ave 8 Front Yard : Yard 7 Tree 1 Private 1     6 Width 9ft   6004145.42049 2095858.4508 37.735062921705996 -122.428096157927 (37.735062921706, -122.428096157927)
181959 181959 201376 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Fairfax Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6018269.69343 2095669.23069 37.7353323666994 -122.379249829039 (37.7353323666994, -122.379249829039)
23761 23761 123510 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2714 Fulton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 8ft   5994935.84099 2110268.0504400004 37.774102650784 -122.460980795496 (37.774102650784, -122.460980795496)
24500 24500 203904 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 5000 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5990628.04185 2093305.0064 37.7272777533559 -122.47464379357001 (37.7272777533559, -122.47464379357)
25522 25522 175043 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 199 Shakespeare St 2 Front Yard : Yard 7 Tree 1 Private 1     6 Width 8ft   5993498.29454 2086678.39145 37.709248559547504 -122.464240538697 (37.7092485595475, -122.464240538697)
25629 25629 123514 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2744 Fulton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5994834.09227 2110246.18844 37.7740367681104 -122.461331174398 (37.7740367681104, -122.461331174398)
29957 29957 187712 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 3 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6013733.01886 2087017.8562099999 37.7113262093072 -122.39432937061301 (37.7113262093072, -122.394329370613)
30017 30017 187699 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 8 Median : Yard 3 Tree 1 DPW 2     24 Width 8ft   6014113.89856 2087000.13929 37.7112987269205 -122.393011704639 (37.7112987269205, -122.393011704639)
32164 32164 188743 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 11 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014538.0462 2086963.8159 37.711222541749 -122.391543193559 (37.711222541749, -122.391543193559)
33886 33886 175014 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 81 Gillette Ave 4 Front Yard : Yard 7 Tree 1 Private 1     3 Width 8ft   6013188.07866 2087071.7521799998 37.7114438900863 -122.396216610525 (37.7114438900863, -122.396216610525)
37054 37054 175013 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 81 Gillette Ave 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 8ft   6013185.59041 2087064.24232 37.7114231310315 -122.396224684625 (37.7114231310315, -122.396224684625)
37820 37820 188744 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 12 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6014566.93251 2086961.4469700002 37.7112176404424 -122.391443188965 (37.7112176404424, -122.391443188965)
45422 45422 187710 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 1 : 4 Tree 1 Private 1     2 Width 8ft   6013683.2298 2086994.4586200002 37.7112591963142 -122.39449981823 (37.7112591963142, -122.39449981823)
47330 47330 175015 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 81 Gillette Ave 5 Front Yard : Yard 7 Tree 1 Private 1     22 Width 8ft   6013189.92411 2087076.3672900002 37.7114566649583 -122.39621055536999 (37.7114566649583, -122.39621055537)
53145 53145 203903 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 5002 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5990622.28371 2093237.1436299998 37.727091085566 -122.474658748425 (37.727091085566, -122.474658748425)
54120 54120 201561 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 200 Jerrold Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 8ft   6019745.83299 2093765.2966200002 37.730185821819795 -122.374014373583 (37.7301858218198, -122.374014373583)
55430 55430 203781 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Northwood Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 8ft   5995760.050530001 2094044.5460299999 37.729604384015296 -122.45695604179701 (37.7296043840153, -122.456956041797)
56907 56907 187701 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 10 Median : Yard 3 Tree 1 DPW 2     24 Width 8ft   6014160.4254 2086993.65928 37.7112835184788 -122.392850441814 (37.7112835184788, -122.392850441814)
57053 57053 203905 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 5000 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 8ft   5990628.4858099995 2093315.14661 37.7273056215527 -122.474642998573 (37.7273056215527, -122.474642998573)
57966 57966 188747 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 15 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6014639.494109999 2086953.6057 37.7112001369439 -122.391191848221 (37.7112001369439, -122.391191848221)
61405 61405 203902 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 5002 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5990623.0724599995 2093226.54081 37.7270620185855 -122.474655248248 (37.7270620185855, -122.474655248248)
63133 63133 188742 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 10 Median : Yard 3 Tree 1 DPW 2     16 Width 8ft   6014513.510980001 2086966.09658 37.7112274421761 -122.391628153428 (37.7112274421761, -122.391628153428)
65570 65570 188736 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014364.73249 2086978.28388 37.7112526465696 -122.39214322484 (37.7112526465696, -122.39214322484)
71411 71411 188737 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 5 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014387.73209 2086976.03412 37.7112477461551 -122.39206357459899 (37.7112477461551, -122.392063574599)
71605 71605 188746 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 14 Median : Yard 3 Tree 1 DPW 2     19 Width 8ft   6014613.42303 2086955.91765 37.7112050382485 -122.391282118582 (37.7112050382485, -122.391282118582)
75165 75165 188735 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 3 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014342.21925 2086979.24909 37.711254046810495 -122.39222110431601 (37.7112540468105, -122.392221104316)
131027 131027 118056 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 494 36th Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   5984738.41738 2112623.7667900003 37.779978707908604 -122.49642879091999 (37.7799787079086, -122.49642879092)
132230 132230 123517 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2750 Fulton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 8ft   5994790.647000001 2110238.4346 37.7740129776239 -122.46148089569901 (37.7740129776239, -122.461480895699)
133052 133052 203807 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 335x Pacheco St 20 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5994179.6676199995 2101287.15386 37.7493999011887 -122.46294480178699 (37.7493999011887, -122.462944801787)
133432 133432 203808 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 335x Pacheco St 30 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5994148.64523 2101441.5060099997 37.7498219260394 -122.46306327486 (37.7498219260394, -122.46306327486)
133838 133838 188745 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 13 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014589.916680001 2086958.4326 37.711210639227 -122.39136353872101 (37.711210639227, -122.391363538721)
134485 134485 123185 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 591 09th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 8ft   5993121.765430001 2111452.55215 37.7772504203411 -122.46734209303001 (37.7772504203411, -122.46734209303)
134750 134750 123516 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2750 Fulton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5994807.17299 2110239.19888 37.77401602731071 -122.46142378531601 (37.7740160273107, -122.461423785316)
136854 136854 123515 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2744 Fulton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   5994816.13065 2110240.7885 37.7740209075455 -122.461392914729 (37.7740209075455, -122.461392914729)
137306 137306 125295 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1306x Montgomery St 24 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6011445.958380001 2119999.7387 37.801759761770604 -122.40455429893998 (37.8017597617706, -122.40455429894)
137789 137789 188763 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 6 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014060.27429 2087007.0702 37.711314778934295 -122.39319752976601 (37.7113147789343, -122.393197529766)
147853 147853 188761 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     23 Width 8ft   6013991.40971 2087009.0790099998 37.7113164687655 -122.39343568552 (37.7113164687655, -122.39343568552)
149419 149419 188738 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 6 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014415.87146 2086974.70005 37.7112456453465 -122.39196622388799 (37.7112456453465, -122.391966223888)
150308 150308 203780 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Northwood Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 8ft   5995711.8389800005 2094094.29693 37.72973821932529 -122.457126310455 (37.7297382193253, -122.457126310455)
152573 152573 187713 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6013756.4546300005 2087023.9293400003 37.71134418764721 -122.394248794959 (37.7113441876472, -122.394248794959)
153767 153767 187700 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 9 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014134.283869999 2086999.7269 37.7112987269389 -122.392941218475 (37.7112987269389, -122.392941218475)
156272 156272 188733 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 : 4 Tree 1 Private 1     8 Width 8ft   6014289.08954 2086985.67825 37.7112687498269 -122.392405184751 (37.7112687498269, -122.392405184751)
157079 157079 187711 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6013709.84578 2087009.9917799998 37.711303326954706 -122.394408912955 (37.7113033269547, -122.394408912955)
166786 166786 188760 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6013911.80932 2087014.9974599998 37.7113282966477 -122.393711220721 (37.7113282966477, -122.393711220721)
168939 168939 188741 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 9 Median : Yard 3 Tree 1 DPW 2     19 Width 8ft   6014489.73327 2086967.85233 37.7112309432358 -122.39171045846399 (37.7112309432358, -122.391710458464)
170303 170303 188764 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014090.1968 2087004.6185400002 37.711309709434 -122.393093937756 (37.711309709434, -122.393093937756)
173558 173558 188762 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6014035.24999 2087007.2689599998 37.71131393444921 -122.39328403465299 (37.7113139344492, -122.393284034653)
174612 174612 188734 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014314.36158 2086981.8522700001 37.71125964778079 -122.39231757011801 (37.7112596477808, -122.392317570118)
174696 174696 175016 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 81 Gillette Ave 6 Front Yard : Yard 7 Tree 1 Private 1     12 Width 8ft   6013191.1859 2087080.9939 37.711469438930294 -122.396206518314 (37.7114694389303, -122.396206518314)
177577 177577 203906 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 4996 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5990638.47075 2093500.4401599998 37.727814969685 -122.47462199853001 (37.727814969685, -122.47462199853)
178538 178538 188740 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 8 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6014461.35341 2086969.95596 37.711235143968 -122.391808694124 (37.711235143968, -122.391808694124)
181734 181734 175012 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 81 Gillette Ave 2 Front Yard : Yard 7 Tree 1 Private 1     4 Width 8ft   6013182.79855 2087056.1572599998 37.71140077569589 -122.396233767795 (37.7114007756959, -122.396233767795)
186731 186731 188739 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014439.36233 2086971.4204900002 37.7112379444543 -122.39188480373801 (37.7112379444543, -122.391884803738)
2211 2211 188595 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
32101 32101 122195 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 57 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 7ft   5991459.5618199995 2114871.1888599996 37.786540956413205 -122.47334153385799 (37.7865409564132, -122.473341533858)
38647 38647 122188 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 7ft   5991455.25466 2115068.89976 37.7870835661247 -122.473370861161 (37.7870835661247, -122.473370861161)
40838 40838 203283 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 436 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 7ft   5999191.65926 2095001.09495 37.7324273055688 -122.445161400772 (37.7324273055688, -122.445161400772)
42467 42467 122191 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 33 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 7ft   5991455.42177 2114972.80191 37.7868197178511 -122.47336327131501 (37.7868197178511, -122.473363271315)
64591 64591 220140 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1201 Vermont St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 7ft   6011463.18939 2102049.1924799997 37.7524726768936 -122.40323121815399 (37.7524726768936, -122.403231218154)
64879 64879 203284 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 436 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   5999187.0289199995 2095000.6796 37.732425900820004 -122.445177379037 (37.73242590082, -122.445177379037)
69580 69580 188649 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1700x Quesada Ave 50 Median : Yard 3 Tree 1 DPW 2     3 Width 7ft   6014280.17751 2095342.33163 37.734213959905205 -122.393020304839 (37.7342139599052, -122.393020304839)
75067 75067 122189 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 21 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 7ft   5991458.245630001 2115020.83895 37.786951777712495 -122.47335700646799 (37.7869517777125, -122.473357006468)
133528 133528 122190 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 27 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 7ft   5991456.07949 2114996.8975 37.786885915721996 -122.473362753885 (37.786885915722, -122.473362753885)
157698 157698 220135 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 547 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 7ft   6004984.87724 2105183.53951 37.7607149265858 -122.42585740811701 (37.7607149265858, -122.425857408117)
161011 161011 122193 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 45 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 7ft   5991455.48516 2114922.34945 37.786681193103206 -122.473359370807 (37.7866811931032, -122.473359370807)
162653 162653 203285 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 436 Joost Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 7ft   5999181.66056 2095001.81408 37.7324287094117 -122.445196020186 (37.7324287094117, -122.445196020186)
164088 164088 220211 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1379 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 7ft   6005255.3326900005 2100269.0224200003 37.747236086469705 -122.424572428885 (37.7472360864697, -122.424572428885)
174923 174923 123557 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 127 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 7ft   5994252.36498 2114696.31424 37.7862221198903 -122.46366650040702 (37.7862221198903, -122.463666500407)
185625 185625 188596 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 7ft   6011998.11194 2102296.49626 37.7531815791825 -122.401398733471 (37.7531815791825, -122.401398733471)
23416 23416 247236 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1251 Haight St 1 : 4 Tree 1 Private 1     26 Width 6ft   6000176.36555 2108836.62464 37.770472476353 -122.442750157415 (37.770472476353, -122.442750157415)
24771 24771 220203 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1475 York St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 6ft   6010135.22584 2100726.27725 37.7487659897773 -122.407730288036 (37.7487659897773, -122.407730288036)
25674 25674 218195 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1365 Portola Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   5993371.5777900005 2097679.7437299998 37.7394482867046 -122.46547714694599 (37.7394482867046, -122.465477146946)
26768 26768 203786 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   5993506.591630001 2101771.6935400004 37.7506915308916 -122.465307488051 (37.7506915308916, -122.465307488051)
26891 26891 203788 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 6ft   5993504.43454 2101812.32675 37.7508029748893 -122.465317898622 (37.7508029748893, -122.465317898622)
27663 27663 174978 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 861 Lisbon St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 6ft   6001016.58593 2088794.32712 37.7154889282344 -122.43840769096799 (37.7154889282344, -122.438407690968)
28682 28682 220133 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 751 Dolores St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 6ft   6005049.364440001 2103949.71117 37.7573307687038 -122.42554656283501 (37.7573307687038, -122.425546562835)
31230 31230 187779 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
32173 32173 124945 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3636 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 6ft   5997417.658369999 2115427.52314 37.7884117046867 -122.452768264141 (37.7884117046867, -122.452768264141)
39168 39168 203797 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 459 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993806.730690001 2101751.7911400003 37.7506541883464 -122.46426814517599 (37.7506541883464, -122.464268145176)
40316 40316 220130 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6004868.33246 2105707.1608700003 37.7621460797944 -122.42629776564199 (37.7621460797944, -122.426297765642)
41180 41180 124880 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3820 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 6ft   5996409.41763 2115616.90715 37.7888738770624 -122.456270294343 (37.7888738770624, -122.456270294343)
45903 45903 123562 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 185 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   5994266.0456 2114375.49898 37.7853420366409 -122.463595877533 (37.7853420366409, -122.463595877533)
46456 46456 220204 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3433 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 6ft   6005486.66221 2103698.14389 37.7566647227046 -122.42401632411999 (37.7566647227046, -122.42401632412)
48994 48994 124972 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2957 Divisadero St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 6ft   6000499.51434 2118479.2792 37.7969671396726 -122.44232473490801 (37.7969671396726, -122.442324734908)
52654 52654 220128 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   6004866.25236 2105787.5349 37.762366650211796 -122.4263106826 (37.7623666502118, -122.4263106826)
52883 52883 220131 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 6ft   6004876.29383 2105622.20284 37.761913255226396 -122.42626418136999 (37.7619132552264, -122.42626418137)
53723 53723 220129 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6004868.0084 2105745.84567 37.762252280750204 -122.426301640812 (37.7622522807502, -122.426301640812)
53729 53729 124881 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3820 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 6ft   5996404.11073 2115616.49045 37.7888724282765 -122.456288625234 (37.7888724282765, -122.456288625234)
54078 54078 175055 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 0 Juan Bautista Cir 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 6ft   5989631.25858 2089762.2141 37.717492326377396 -122.47783075799299 (37.7174923263774, -122.477830757993)
59153 59153 220122 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 200 Dolores St 4 : 4 Tree 1 Private 1     6 Width 6ft   6004793.59671 2107104.43038 37.7659784237974 -122.42665575247 (37.7659784237974, -122.42665575247)
62545 62545 203698 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1696 09th Ave 1 Front Yard : Yard 7 Tree 1 Private 1     25 Width 6ft   5993434.49176 2103973.54477 37.7567330891842 -122.46571676863 (37.7567330891842, -122.46571676863)
68536 68536 218192 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1395 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 6ft   5993247.05423 2097602.68671 37.739229524809396 -122.46590209372299 (37.7392295248094, -122.465902093723)
72802 72802 203791 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1992 09th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   5993497.88442 2101974.58502 37.75124811680521 -122.46535233455 (37.7512481168052, -122.46535233455)
75986 75986 220127 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 6ft   6004864.426659999 2105831.25856 37.762486601794 -122.426320110198 (37.762486601794, -122.426320110198)
76918 76918 218194 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1385 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 6ft   5993344.71781 2097663.02929 37.739400843864004 -122.465568802264 (37.739400843864, -122.465568802264)
103959 103959 203787 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 09th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 6ft   5993505.06896 2101787.40715 37.75073458863179 -122.465313894823 (37.7507345886318, -122.465313894823)

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