Street_Tree_List

Data source: data.sfgov.org

479 rows where qSiteInfo = 2 and qSpecies = 5 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 479 ✖
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188929 188929 203816 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1625 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5993083.51125 2095334.29452 37.7329916508262 -122.466302734486 (37.7329916508262, -122.466302734486)
188911 188911 203784 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2050 09th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5993499.63978 2101506.86367 37.7499639748735 -122.465312293131 (37.7499639748735, -122.465312293131)
188710 188710 125209 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2008 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6004952.53327 2116801.7834099997 37.7926139551121 -122.426796690615 (37.7926139551121, -122.426796690615)
188352 188352 188681 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     6018210.72448 2096306.49238 37.7370789094531 -122.379497963675 (37.7370789094531, -122.379497963675)
188319 188319 220213 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 483 Valley St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6002841.26892 2099164.12546 37.744065668695995 -122.43284115011801 (37.744065668696, -122.432841150118)
188120 188120 205124 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1253 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5994307.62301 2097874.46117 37.740036874108704 -122.462254855373 (37.7400368741087, -122.462254855373)
187226 187226 250936 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 242 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5987145.66978 2114320.34633 37.7847777601171 -122.488225846157 (37.7847777601171, -122.488225846157)
186948 186948 188753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6014041.0419 2087033.9211099998 37.7113874378463 -122.393265880017 (37.7113874378463, -122.393265880017)
186846 186846 203759 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   5991717.96646 2096103.43353 37.735024627670896 -122.471079748847 (37.7350246276709, -122.471079748847)
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)
185614 185614 203928 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 700 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5991222.21621 2101152.9176 37.7488605291971 -122.473161852043 (37.7488605291971, -122.473161852043)
185542 185542 122911 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 12th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   5992125.45609 2114866.3571099997 37.786566225914704 -122.471037373124 (37.7865662259147, -122.471037373124)
185538 185538 220222 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 62 Carmel St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5998653.96279 2105407.43218 37.7609698726686 -122.44776922698999 (37.7609698726686, -122.44776922699)
185399 185399 124305 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 169 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5996209.822430001 2113206.80783 37.782244929320605 -122.456786484191 (37.7822449293206, -122.456786484191)
184739 184739 247539 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6000199.67712 2108517.8655 37.7695985727307 -122.442646631948 (37.7695985727307, -122.442646631948)
184607 184607 203680 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1482 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5991507.32785 2105347.89761 37.760395348885396 -122.472481734348 (37.7603953488854, -122.472481734348)
184256 184256 124645 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5995523.4178 2115711.6457 37.7890831035356 -122.45934257475001 (37.7890831035356, -122.45934257475)
184171 184171 182345 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1522 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5988093.404 2104933.5905 37.7590595845641 -122.484258382398 (37.7590595845641, -122.484258382398)
183354 183354 122128 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 11 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 5ft   5990802.7595 2114921.6323700002 37.7866414061123 -122.47561756924699 (37.7866414061123, -122.475617569247)
183092 183092 185661 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2101 Sunset Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5984918.7868 2100743.1942 37.7473685553138 -122.494928578961 (37.7473685553138, -122.494928578961)
182642 182642 221374 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 653 Sanchez St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6003693.10013 2104500.87823 37.7587674158898 -122.43027637896401 (37.7587674158898, -122.430276378964)
182301 182301 123980 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 37 07th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5993612.60829 2115222.17553 37.7876291067421 -122.46591809710199 (37.7876291067421, -122.465918097102)
181912 181912 220225 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 62 Carmel St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5998611.48778 2105405.4167299997 37.7609619109939 -122.44791598376301 (37.7609619109939, -122.447915983763)
181703 181703 203825 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1485 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5992686.00639 2097037.5899200002 37.737645530001295 -122.46780083956301 (37.7376455300013, -122.467800839563)
181643 181643 124952 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 232 Maple St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5996648.67677 2115450.86718 37.7884317073951 -122.455430490336 (37.7884317073951, -122.455430490336)
181604 181604 125231 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2330 Octavia St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6004617.74457 2117190.62158 37.793662671658794 -122.427982792965 (37.7936626716588, -122.427982792965)
181518 181518 124953 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 222 Maple St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5996648.39198 2115469.91468 37.788483990383895 -122.45543285283999 (37.7884839903839, -122.45543285284)
181463 181463 203766 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   5991897.53803 2096297.49982 37.7355678694505 -122.470473041024 (37.7355678694505, -122.470473041024)
181227 181227 188758 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6013886.48106 2087045.97193 37.711411938995205 -122.39380092898999 (37.7114119389952, -122.39380092899)
181178 181178 188679 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6018264.75043 2096477.95592 37.7375526939091 -122.379323076118 (37.7375526939091, -122.379323076118)
181060 181060 124812 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3434 Baker St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5999269.00527 2120608.3176700003 37.8027426982766 -122.44673584208401 (37.8027426982766, -122.446735842084)
180977 180977 188570 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 328 Pennsylvania Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 4ft   6014297.15986 2105489.9838099997 37.76207821336379 -122.39367160286601 (37.7620782133638, -122.393671602866)
180782 180782 203705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2104 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991328.52937 2101050.88664 37.748586533643206 -122.472786786201 (37.7485865336432, -122.472786786201)
180424 180424 250722 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2720 Lake St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5987022.28567 2114476.78778 37.7852001042432 -122.48866421169501 (37.7852001042432, -122.488664211695)
180387 180387 218196 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1365 Portola Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   5993444.70941 2097719.48366 37.7395616201724 -122.46522717769699 (37.7395616201724, -122.465227177697)
179656 179656 125179 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2401 Broadway 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   6002026.35862 2117343.77621 37.793936248109 -122.436960163797 (37.793936248109, -122.436960163797)
179567 179567 203838 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 41 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995240.511630001 2099477.4925700002 37.744492072368494 -122.45914537927 (37.7444920723685, -122.45914537927)
179417 179417 218193 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1395 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   5993287.55487 2097626.31365 37.739296734747796 -122.46576377800301 (37.7392967347478, -122.465763778003)
179386 179386 123392 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 701 03rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5995019.32935 2110726.33262 37.775365776212794 -122.46072521493099 (37.7753657762128, -122.460725214931)
179379 179379 218114 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 84 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   5993940.18965 2100447.16397 37.7470797051661 -122.463711957653 (37.7470797051661, -122.463711957653)
179031 179031 203988 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 665 Faxon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   5994873.24978 2092595.62975 37.72557504624321 -122.459916865398 (37.7255750462432, -122.459916865398)
178789 178789 125121 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2950 Broadway 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   5999507.62206 2117045.21754 37.7929730040528 -122.44565372745001 (37.7929730040528, -122.44565372745)
178721 178721 181633 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1258 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 0ft   5985863.7631 2106655.7682 37.763658132222204 -122.49209623052401 (37.7636581322222, -122.492096230524)
178719 178719 174989 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Madrid St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6001106.19823 2088490.6966400002 37.714660323495394 -122.438076214354 (37.7146603234954, -122.438076214354)
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)
178510 178510 186524 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 0ft   5984779.5703 2104623.8794 37.7580156968567 -122.495696174096 (37.7580156968567, -122.495696174096)
178378 178378 125207 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2006 Washington St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6004999.73752 2116807.3116599997 37.792631803077505 -122.426633755938 (37.7926318030775, -122.426633755938)
178141 178141 204009 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1283 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993898.99812 2097834.64802 37.7399040199511 -122.463664812507 (37.7399040199511, -122.463664812507)
178064 178064 205141 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 44 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5994106.119580001 2101835.51566 37.750901326556104 -122.463238916037 (37.7509013265561, -122.463238916037)
177882 177882 125234 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2330 Octavia St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6004612.95687 2117230.04971 37.793770660429395 -122.428002169785 (37.7937706604294, -122.428002169785)
177716 177716 203802 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 365 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994147.85172 2101219.85432 37.7492132810743 -122.46304993880501 (37.7492132810743, -122.463049938805)
177615 177615 121885 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 50 18th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   5990230.47733 2114817.75454 37.7863229938727 -122.477589910296 (37.7863229938727, -122.477589910296)
177544 177544 247541 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6000212.071930001 2108508.7313900003 37.769574199310895 -122.442603102947 (37.7695741993109, -122.442603102947)
176445 176445 203795 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1987 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5993770.85444 2101945.8628 37.7511849916116 -122.46440629632299 (37.7511849916116, -122.464406296323)
176234 176234 203790 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1992 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993499.03124 2101963.03013 37.7512164561752 -122.46534752948999 (37.7512164561752, -122.46534752949)
176171 176171 203785 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2050 09th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 2ft   5993499.774119999 2101557.36546 37.750102647629795 -122.465315496537 (37.7501026476298, -122.465315496537)
176106 176106 125227 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2300 Octavia St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6004627.2188 2117121.15907 37.7934724812315 -122.42794505924 (37.7934724812315, -122.42794505924)
175451 175451 122997 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 46 07th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5993657.6185800005 2115186.4679 37.7875336597893 -122.465759776221 (37.7875336597893, -122.465759776221)
175326 175326 205129 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1259 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5994442.86239 2097881.87819 37.7400650255914 -122.461787794274 (37.7400650255914, -122.461787794274)
175300 175300 203798 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 157 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   5993557.614440001 2101625.80582 37.750293902849705 -122.465120453365 (37.7502939028497, -122.465120453365)
175229 175229 247538 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     6000181.2283 2108513.20093 37.769584713305996 -122.442710110591 (37.769584713306, -122.442710110591)
174510 174510 186187 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Sunset Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 0ft   5984844.927999999 2103185.6655 37.75407058719129 -122.495364076569 (37.7540705871913, -122.495364076569)
174333 174333 125228 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2300 Octavia St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6004625.81379 2117138.7984700003 37.793520835060896 -122.42795117821998 (37.7935208350609, -122.42795117822)
173880 173880 217754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 401 West Portal Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 3ft   5991873.84206 2096589.33357 37.7363678011265 -122.470576214823 (37.7363678011265, -122.470576214823)
173701 173701 203240 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 175 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 3ft   5994884.38137 2099419.15994 37.7443114255431 -122.460372570763 (37.7443114255431, -122.460372570763)
173681 173681 203814 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 56 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 4ft   5993922.85447 2101318.67342 37.749471649993794 -122.463835148597 (37.7494716499938, -122.463835148597)
173544 173544 123391 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 707 03rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5995020.45861 2110702.63135 37.7753007637734 -122.46071959059401 (37.7753007637734, -122.460719590594)
173496 173496 174998 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 47 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6000602.5075 2088281.5503900002 37.714057396398395 -122.43980218511601 (37.7140573963984, -122.439802185116)
172412 172412 123979 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 37 07th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5993614.27275 2115203.75558 37.787578626625205 -122.46591099951401 (37.7875786266252, -122.465910999514)
171918 171918 203812 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 66 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 4ft   5993893.78776 2101368.05149 37.749605554551394 -122.463939245113 (37.7496055545514, -122.463939245113)
171905 171905 250845 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 236 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986530.263669999 2114217.2530099996 37.7844587724096 -122.490347333357 (37.7844587724096, -122.490347333357)
171725 171725 204007 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1283 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993845.40791 2097825.84553 37.739876762413104 -122.463849464887 (37.7398767624131, -122.463849464887)
171707 171707 183318 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3915 Lincoln Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   5983544.4671 2106954.7342 37.764343159359 -122.50013992674 (37.764343159359, -122.50013992674)
171441 171441 125106 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3167 Jackson St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 5ft   5999044.89731 2116267.38185 37.7908108440947 -122.447198767233 (37.7908108440947, -122.447198767233)
171116 171116 205130 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1261 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5994507.93911 2097882.15417 37.740069529391796 -122.46156280728201 (37.7400695293918, -122.461562807282)
171036 171036 203817 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1615 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5993108.74619 2095336.27282 37.7329985387476 -122.46621563515 (37.7329985387476, -122.46621563515)
170983 170983 182041 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 13427 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5987431.7408 2106123.9873 37.762289540332 -122.48663410511499 (37.762289540332, -122.486634105115)
170837 170837 247540 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6000206.9211 2108513.1896 37.7695861468207 -122.442621239574 (37.7695861468207, -122.442621239574)
170633 170633 188637 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Helena St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6011019.03327 2096193.8561200001 37.736370373201105 -122.40435509372699 (37.7363703732011, -122.404355093727)
170564 170564 123982 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 37 07th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5993611.16787 2115251.25881 37.7877088783639 -122.465925194685 (37.7877088783639, -122.465925194685)
170284 170284 203794 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1985 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 4ft   5993770.666019999 2101997.95892 37.7513280233814 -122.464410729968 (37.7513280233814, -122.464410729968)
169618 169618 122912 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 12th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5992124.93885 2114841.8023599996 37.7864987754489 -122.471037373141 (37.7864987754489, -122.471037373141)
169399 169399 203238 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Vasquez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5995797.188519999 2100201.6485900003 37.746512411912796 -122.457272892729 (37.7465124119128, -122.457272892729)
168936 168936 218127 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 17 Lopez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5994170.50628 2100846.31461 37.7481889406764 -122.46294450229601 (37.7481889406764, -122.462944502296)
168865 168865 218317 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 415 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   5993222.51881 2099928.76058 37.7456149208919 -122.46615591658801 (37.7456149208919, -122.466155916588)
168770 168770 203996 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 855 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5996332.325619999 2094668.8718700001 37.7313514789886 -122.455022734117 (37.7313514789886, -122.455022734117)
168429 168429 203801 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 369 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   5994146.49034 2101232.72643 37.7492485462011 -122.463055580263 (37.7492485462011, -122.463055580263)
168033 168033 124774 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2600 Baker St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5999661.41962 2117791.9791599996 37.7950321934456 -122.44517529440901 (37.7950321934456, -122.445175294409)
167983 167983 174983 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1005 Madrid St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6001103.82585 2088413.5291400002 37.7144483038197 -122.438078889846 (37.7144483038197, -122.438078889846)
167875 167875 123383 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 735 03rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5995024.65215 2110563.31085 37.7749184678293 -122.46069498573999 (37.7749184678293, -122.46069498574)
167392 167392 250806 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 279 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986182.48717 2114056.1831799997 37.7839962033991 -122.491538643706 (37.7839962033991, -122.491538643706)
166756 166756 204008 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1283 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5993871.95865 2097835.5698700002 37.7399049930254 -122.463758369879 (37.7399049930254, -122.463758369879)
166674 166674 188754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014012.046130001 2087036.3540700001 37.7113925073379 -122.393366267763 (37.7113925073379, -122.393366267763)
166668 166668 203925 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1755 12th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 3ft   5992470.0212900005 2103495.15392 37.755363873152 -122.469017416317 (37.755363873152, -122.469017416317)
165930 165930 203799 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 387 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5994124.71734 2101400.57412 37.7497081591019 -122.46314304833 (37.7497081591019, -122.46314304833)
165752 165752 183054 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 800 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5990379.5296 2097036.3868 37.7375087738287 -122.475775260297 (37.7375087738287, -122.475775260297)
165672 165672 125211 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2008 Washington St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6004908.14442 2116797.12616 37.7925986576615 -122.42694994588601 (37.7925986576615, -122.426949945886)
165631 165631 123352 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 700 04th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5994755.62289 2110723.92096 37.775343978546 -122.461637255574 (37.775343978546, -122.461637255574)
165358 165358 188727 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014344.673219999 2086951.52191 37.7111780496084 -122.39221068478999 (37.7111780496084, -122.39221068479)
165268 165268 125284 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1022 Vallejo St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6008534.98172 2118654.3458 37.797902532623205 -122.414532399365 (37.7979025326232, -122.414532399365)

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