Street_Tree_List

Data source: data.sfgov.org

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

View and edit SQL

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
65523 201544 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 601 Innes Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6020625.625519999 2093377.92947 37.7291705267859 -122.370946000964 (37.7291705267859, -122.370946000964)
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)
137993 187765 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 91 Kiska Rd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26     6019429.17387 2093568.53818 37.7296281423191 -122.375095487273 (37.7296281423191, -122.375095487273)
46008 187764 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 91 Kiska Rd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6019412.692980001 2093581.83976 37.729663759061 -122.37515338563 (37.729663759061, -122.37515338563)
79463 116977 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100x CARGO WAY 117 Front Yard : Yard 7 Tree 1 PUC 13 DPW for City Agency 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
118559 3686 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 100X Cargo Way 1 Median : Cutout 11 Tree 1 Port 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
70829 187762 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 135 Reardon Rd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19     6018971.39793 2093438.5075400001 37.72924590436129 -122.37666906882099 (37.7292459043613, -122.376669068821)
75816 187763 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 135 Reardon Rd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25     6018954.68397 2093453.67115 37.7292866202724 -122.376727902495 (37.7292866202724, -122.376727902495)
168459 188642 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2x Cargo Way 3 Median : Yard 3 Tree 1 DPW 2     9     6018846.51114 2097536.89048 37.7404923843103 -122.377385089264 (37.7404923843103, -122.377385089264)
15245 11544 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 101X Jennings St 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/23/1997 12:00:00 AM 3 3X3   6018840.43674 2097157.24182 37.7394496095988 -122.37737975539 (37.7394496095988, -122.37737975539)
36188 201372 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 57 Hare St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31     6018490.42115 2095382.8253 37.734558123266204 -122.378466804612 (37.7345581232662, -122.378466804612)
56931 188677 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1001 Evans Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   6018476.48235 2096364.95743 37.7372540964924 -122.37858316699499 (37.7372540964924, -122.378583166995)
158166 188643 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 2 Median : Yard 3 Tree 1 DPW 2     17     6018388.81738 2097879.37789 37.7414075614118 -122.378991412446 (37.7414075614118, -122.378991412446)
63519 187749 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1020 Griffith St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38     6018386.6897599995 2093315.1959 37.7288750976933 -122.378681918831 (37.7288750976933, -122.378681918831)
109795 6435 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173)
123001 6443 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/29/1990 12:00:00 AM 12 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173)
143273 6432 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173)
49471 201375 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Fairfax Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26     6018327.36542 2095666.8943900003 37.7353291318294 -122.379050271262 (37.7353291318294, -122.379050271262)
159053 201374 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Hare St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26     6018319.37911 2095383.7784900002 37.7345513108793 -122.37905822666 (37.7345513108793, -122.37905822666)
44332 188644 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 4 Median : Yard 3 Tree 1 DPW 2     27     6018318.49597 2097930.97465 37.7415453582258 -122.379238145042 (37.7415453582258, -122.379238145042)
14364 6420 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/29/1990 12:00:00 AM 12 3x3   6018302.7051 2096585.42337 37.7378498712671 -122.379199309611 (37.7378498712671, -122.379199309611)
137238 188678 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6018276.23172 2096494.25688 37.7375980862711 -122.37928451136999 (37.7375980862711, -122.37928451137)
172072 187778 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.37928476769899 (37.7376023175876, -122.379284767699)
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)
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)
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)
182693 187780 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 3 Side Yard : Yard 17 Tree 1 Private 1     4 Width 6ft   6018250.04699 2096453.9006400001 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948)
14006 6423 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3x3   6018250.03314 2096623.41897 37.7379512950012 -122.37938406274901 (37.7379512950012, -122.379384062749)
24760 188680 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6018245.47476 2096448.1212400002 37.7374697107694 -122.37938765012501 (37.7374697107694, -122.379387650125)
113544 94646 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 30 Middle Point Rd 35 : 4 Tree 1 Private 1           6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
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)
33152 187750 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     6018189.80767 2093163.42935 37.728447520437705 -122.379352023493 (37.7284475204377, -122.379352023493)
16182 6428 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/29/1990 12:00:00 AM 6 3x3   6018145.74781 2096700.42192 37.7381569780515 -122.379749980697 (37.7381569780515, -122.379749980697)
137062 188645 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 8 Median : Yard 3 Tree 1 DPW 2     25     6018140.58939 2098064.90862 37.7419033019107 -122.37986259559601 (37.7419033019107, -122.379862595596)
187072 187751 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29     6018129.3732900005 2093209.5083299999 37.7285707113551 -122.379564150189 (37.7285707113551, -122.379564150189)
16697 6429 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6018128.86285 2096712.12629 37.738188184545706 -122.37980917407499 (37.7381881845457, -122.379809174075)
15979 6431 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1100X Evans Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6018097.17297 2096735.7519999999 37.738251307945596 -122.379920384224 (37.7382513079456, -122.379920384224)
55759 188646 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 9 Median : Yard 3 Tree 1 DPW 2     5     6018092.675340001 2098102.14022 37.74200288923021 -122.380030855133 (37.7420028892302, -122.380030855133)
182989 187753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6018088.91826 2093246.2132 37.72866926445229 -122.37970655600901 (37.7286692644523, -122.379706556009)
168868 187752 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6018083.616719999 2093238.62842 37.7286481456935 -122.379724357202 (37.7286481456935, -122.379724357202)
187551 188647 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 10 Median : Yard 3 Tree 1 DPW 2     17     6018073.116719999 2098111.74487 37.7420281826481 -122.38009915058001 (37.7420281826481, -122.38009915058)
25166 188682 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 1 : 4 Tree 1 Private 1     12 Width 3ft   6018053.21017 2096769.99546 37.738342908392504 -122.38007476635299 (37.7383429083925, -122.380074766353)
24305 187754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6018045.40924 2093280.41562 37.728760777668 -122.37985934635799 (37.728760777668, -122.379859346358)
30738 187755 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6018042.26935 2093273.64193 37.7287420052256 -122.379869730822 (37.7287420052256, -122.379869730822)
64021 187756 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6018040.44211 2093268.12413 37.728726753622496 -122.379875664545 (37.7287267536225, -122.379875664545)
37898 188683 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 3 : 4 Tree 1 Private 1     13 Width 3ft   6018037.89274 2096788.1105 37.7383918036295 -122.380128985564 (37.7383918036295, -122.380128985564)
137718 188648 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 11 Median : Yard 3 Tree 1 DPW 2     17     6018027.576669999 2098147.2670299998 37.7421232068329 -122.380259083311 (37.7421232068329, -122.380259083311)
169587 188684 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 6 : 4 Tree 1 Private 1     18 Width 4ft   6017995.68606 2096837.1750400001 37.7385241964319 -122.380278326092 (37.7385241964319, -122.380278326092)
86341 3693 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300X Cargo Way 2 Median : Cutout 11 Tree 1 DPW 2     12 8   6017817.275253 2098336.256691 37.742630528905295 -122.380999383309 (37.7426305289053, -122.380999383309)
104843 3692 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300X Cargo Way 1 Median : Cutout 11 Tree 1 DPW 2     18 8   6017817.275253 2098336.256691 37.742630528905295 -122.380999383309 (37.7426305289053, -122.380999383309)
129605 188664 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 501 Amador St 11 Front Yard : Yard 7 Tree 1 Private 1     10 Width 1ft   6017799.2263400005 2099547.3837200003 37.745955042685 -122.381145981202 (37.745955042685, -122.381145981202)
82695 6463 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Evans Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017761.749009999 2097023.16401 37.7390219747502 -122.381100103845 (37.7390219747502, -122.381100103845)
29 188686 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 20 : 4 Tree 1 DPW 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
41904 188655 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300x Cargo Way 5 Median : Yard 3 Tree 1 DPW 2     22     6017659.9469 2098420.67777 37.7428536469791 -122.38154925430099 (37.7428536469791, -122.381549254301)
158739 188663 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 501 Amador St 10 Front Yard : Yard 7 Tree 1 Private 1     10 Width 1ft   6017654.784080001 2099538.16845 37.745921765085605 -122.38164480728099 (37.7459217650856, -122.381644807281)
88874 6714 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
92763 6718 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
106616 6706 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
106856 6717 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
123898 6740 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300X Fairfax Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
142561 6729 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
144451 6739 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300X Fairfax Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
144696 6745 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300X Fairfax Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
156153 187757 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1040 Palou Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23     6017577.45499 2093289.4287599998 37.7287597011768 -122.38147773753 (37.7287597011768, -122.38147773753)
13460 6707 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017570.5024 2096779.6090000002 37.7383426628708 -122.381744418894 (37.7383426628708, -122.381744418894)
133165 187758 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1040 Palou Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6017560.01516 2093300.23406 37.7287884075452 -122.38153877989299 (37.7287884075452, -122.381538779893)
16323 6708 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Fairfax Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3x3   6017556.67213 2096791.48157 37.738374498884795 -122.38179306321899 (37.7383744988848, -122.381793063219)
79802 28708 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Evans Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017551.81801 2097178.22601 37.7394361536971 -122.38183673875 (37.7394361536971, -122.38183673875)
165389 187759 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1040 Palou Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32     6017547.84189 2093311.88395 37.7288197237472 -122.381581673978 (37.7288197237472, -122.381581673978)
152333 188671 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1200 Fairfax Ave 6 : 4 Tree 1 Private 1     25 Width 4ft   6017541.51277 2096801.60961 37.7384014713541 -122.381846181672 (37.7384014713541, -122.381846181672)
149025 187760 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1040 Palou Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6017527.04391 2093321.80664 37.7288458211654 -122.381654264546 (37.7288458211654, -122.381654264546)
82774 6753 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1215 Fairfax Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
66689 187761 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1040 Palou Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6017511.07328 2093334.4830599998 37.7288797462969 -122.381710357951 (37.7288797462969, -122.381710357951)
13761 6553 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1275 Evans Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x8   6017462.04156 2097126.1556099998 37.7392882208803 -122.382143528109 (37.7392882208803, -122.382143528109)
14724 28654 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1275 Evans Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/2004 12:00:00 AM 3 6x3   6017442.42343 2097139.5251799999 37.739323847514 -122.38221228939 (37.739323847514, -122.38221228939)
80080 6479 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Evans Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6017436.11701 2097265.30001 37.739668851651395 -122.382242842132 (37.7396688516514, -122.382242842132)
175369 188654 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300x Cargo Way 12 Median : Yard 3 Tree 1 DPW 2     1     6017424.39169 2098619.4012 37.7433862929421 -122.382377569482 (37.7433862929421, -122.382377569482)
142726 188672 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1224 Fairfax Ave 3 : 4 Tree 1 Private 1     14 Width 4ft   6017423.588719999 2096888.36438 37.738633169988205 -122.38225994355301 (37.7386331699882, -122.382259943553)
133833 188653 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300x Cargo Way 13 Median : Yard 3 Tree 1 DPW 2     1     6017421.68385 2098629.86939 37.7434148869 -122.382387660761 (37.7434148869, -122.382387660761)
153654 188652 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300x Cargo Way 14 Median : Yard 3 Tree 1 DPW 2     19     6017392.84765 2098647.1595799997 37.7434607693943 -122.382488572792 (37.7434607693943, -122.382488572792)
23364 6747 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1215 Fairfax Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6017390.63175 2096829.5691799999 37.7384699097667 -122.382369804725 (37.7384699097667, -122.382369804725)
164503 187777 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1215 Fairfax Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6017388.24402 2096830.64368 37.738472728238605 -122.382378135159 (37.7384727282386, -122.382378135159)
136589 188651 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 300x Cargo Way 15 Median : Yard 3 Tree 1 DPW 2     6     6017373.9642900005 2098663.52344 37.7435046581055 -122.38255500572399 (37.7435046581055, -122.382555005724)
129938 188673 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1224 Fairfax Ave 6 : 4 Tree 1 Private 1     17 Width 3ft   6017369.130609999 2096930.52417 37.738745924277396 -122.382451168193 (37.7387459242774, -122.382451168193)
39606 188674 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1270 Fairfax Ave 1 : 4 Tree 1 Private 1     17 Width 3ft   6017349.18345 2096943.80807 37.7387812973263 -122.382521060803 (37.7387812973263, -122.382521060803)
69392 187748 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1322 Hudson Ave 49 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6017296.567009999 2095239.40453 37.734098438398 -122.382584422552 (37.734098438398, -122.382584422552)
53934 188689 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 42 : 4 Tree 1 Private 1     11 Width 3ft   6017291.85289 2097369.22431 37.739946237732205 -122.38274888066799 (37.7399462377322, -122.382748880668)
138453 6486 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1200X Evans Ave 28 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017283.44001 2097385.77201 37.739991209593605 -122.38277912044599 (37.7399912095936, -122.382779120446)
170827 187722 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 65 Whitney Young Cir 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 3ft   6017248.253740001 2094957.0025400002 37.73332034944129 -122.38273181334401 (37.7333203494413, -122.382731813344)
7 188697 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1301 Evans Ave 13 : 4 Tree 1 DPW 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
20374 6568 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1301 Evans Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6017234.1596238 2097288.6286052 37.7397217505579 -122.382942754401 (37.7397217505579, -122.382942754401)
16537 24220 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 52 Whitney Young Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6017233.65569 2094997.2718200001 37.7334301143948 -122.38278508468001 (37.7334301143948, -122.38278508468)
177120 187721 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 65 Whitney Young Cir 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6017221.17911 2094948.917 37.733296652317705 -122.38282485627899 (37.7332966523177, -122.382824856279)
99473 3689 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 200X Cargo Way 3 Median : Cutout 11 Tree 1 Port 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127580 3691 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 200X Cargo Way 5 Median : Cutout 11 Tree 1 Port 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127726 3690 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 200X Cargo Way 4 Median : Cutout 11 Tree 1 Port 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
128521 3688 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 200X Cargo Way 2 Median : Cutout 11 Tree 1 Port 9     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
140153 3687 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 200X Cargo Way 1 Median : Cutout 11 Tree 1 Port 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
117732 6771 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1275 Fairfax Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6017217.4089567 2096970.3613046003 37.738846926957706 -122.382978527185 (37.7388469269577, -122.382978527185)
82822 3694 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 400X Cargo Way 1 Median : Cutout 11 Tree 1 DPW 2     12 8   6017199.673908999 2098835.752969 37.7439679357533 -122.383169649574 (37.7439679357533, -122.383169649574)

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