sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
108029 86830 1 24 144 Noe St 2 1 1 1     6 3x3 unpermitted private planting on DPW-maintained street 6002845.0 2107418.0 37.7667290519071 -122.43341795453999 (37.7667290519071, -122.43341795454)
109303 93030 1 142 45 Jersey St 2 1 1 1     9 3x3 undocumented 6004830.0 2101620.0 37.7509215289079 -122.42613936044901 (37.7509215289079, -122.426139360449)
128235 93029 1 25 45 Jersey St 1 1 1 1     9 5x6 undocumented 6004830.0 2101620.0 37.7509215289079 -122.42613936044901 (37.7509215289079, -122.426139360449)
20491 85214   52 2889 24th St 1 1 1 2 3 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.75264132339179 -122.409722943913 (37.7526413233918, -122.409722943913)
145363 85250   131 1335 Fulton St 2 1 1 2 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
120951 85249   131 1335 Fulton St 1 1 1 2 3 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
340 191854 3 39 573 10th St 1 9 1 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
95838 92924 2 15 2725X 14th Ave 4 1 1 1     14 3x3 tree 4 on 14th st 5992210.0 2097192.0 37.7380420035645 -122.46945784276001 (37.7380420035645, -122.46945784276)
84452 92923 2 15 2725X 14th Ave 3 1 1 1     10 3x3 tree 3 on 14th st 5992210.0 2097192.0 37.7380420035645 -122.46945784276001 (37.7380420035645, -122.46945784276)
89271 92926 2 15 398 West Portal Ave 2 1 1 1     14   tree 2 on 15th st 5991862.0 2096794.0 37.7369290786614 -122.470632059845 (37.7369290786614, -122.470632059845)
122422 92922 2 15 2725X 14th Ave 2 1 1 1     10 3x3 tree 2 on 14th st. 5992210.0 2097192.0 37.7380420035645 -122.46945784276001 (37.7380420035645, -122.46945784276)
81647 92928 2 15 301 West Portal Ave 2 1 1 1     10   tree 2 on 14th st 5992361.0 2097058.0 37.7376827987343 -122.46892601674101 (37.7376827987343, -122.468926016741)
84463 92925 2 15 398 West Portal Ave 1 1 1 1     14   tree 1 on 15th st 5991862.0 2096794.0 37.7369290786614 -122.470632059845 (37.7369290786614, -122.470632059845)
127493 92943 2 15 2800X 15TH AVE 1 1 1 1     12   tree 1 on 15th st 5991935.0 2096694.0 37.7366587249535 -122.470372388311 (37.7366587249535, -122.470372388311)
79068 92921 2 15 2725X 14th Ave 1 1 1 1     13 3x3 tree 1 on 14th st. 5992210.0 2097192.0 37.7380420035645 -122.46945784276001 (37.7380420035645, -122.46945784276)
122362 92927 2 15 301 West Portal Ave 1 1 1 1     10   tree 1 on 14th st 5992361.0 2097058.0 37.7376827987343 -122.46892601674101 (37.7376827987343, -122.468926016741)
14802 24222 8 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
114717 99960 2 119 279 Filbert St 1 14 1 1         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.80189375856779 -122.40421070766001 (37.8018937585678, -122.40421070766)
127330 109501 5 119 1400X on Filbert Montgomery St 1 14 1 1         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.802105381717894 -122.404424889694 (37.8021053817179, -122.404424889694)
17026 16614 1 18 107 Noe St 1 1 1 1     3 3X3 privately planted on dpw street without permit 6002879.45304 2107636.12058 37.7673299123847 -122.433314375152 (37.7673299123847, -122.433314375152)
83526 86829 3 11 258 Noe St 1 1 1 2   06/13/2009 12:00:00 AM 3 3x3 privately planted on DPW street; unpermitted 6002882.169263 2106798.606637 37.765030457224704 -122.43324512978701 (37.7650304572247, -122.433245129787)
124310 16684 3 11 262 Noe St 1 1 1 2   12/17/1998 12:00:00 AM 3 4x4 privately planted on DPW street; unpermitted 6002878.0000942005 2106783.4724173998 37.7649886658228 -122.4332584684 (37.7649886658228, -122.4332584684)
21175 5356 3 90 220 Dolores St 1 1 1 2   07/11/2015 03:17:00 PM 3 6x6 posted for removal 3/27/14 DPW 6004796.958190001 2107043.90776 37.765812433218706 -122.426639815582 (37.7658124332187, -122.426639815582)
90012 94626 1 204 1740 Bancroft Ave 1 5 1 1   10/13/2010 12:00:00 AM 9   permit 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
8577 11027 1 32 1441 Hyde St 1 1 1 1     70 3x3 owner Victor Seeto signed agreement 3/10/10 to maintain bricks in tree basin in a safe/accessible manner that does not damage tree or restrict growth. 6007472.87331 2117336.51186 37.7942243630038 -122.418114127466 (37.7942243630038, -122.418114127466)
138801 115762 2 54 84X Cordova St 1 1 1 1     3   on Athens Street frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
145417 115870 2 54 84X Cordova St 4 1 1 1         on Athens St. Frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
143047 115869 2 54 84X Cordova St 2 1 1 1         on Athens St frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
110767 110456 3 11 200X Masonic Ave 9 1 1 2       3x3 next to cross walk 5998971.779069999 2112109.89902 37.7793913048339 -122.44715241864401 (37.7793913048339, -122.447152418644)
99668 104881 5 262 101 Gonzalez Dr 1 2 1 1         missing? 5990474.7 2090014.4 37.718233681711204 -122.47493379652201 (37.7182336817112, -122.474933796522)
111624 104922 2 75 750 Gonzalez Dr 3 3 1 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
114615 104938 2 262 101 Gonzalez Dr 2 2 1 1         missing? 5990474.7 2090014.4 37.718233681711204 -122.47493379652201 (37.7182336817112, -122.474933796522)
97339 85212 1 51 229 Broad St 1 1 1 1   07/02/2007 12:00:00 AM 3 3x3 maintenance agreement through 7/2/2010 5994738.0 2088050.0 37.7130860517587 -122.46005525076299 (37.7130860517587, -122.460055250763)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
104879 94466 1 62 4128 17th St   1 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
144608 94467 1 62 4128 17th St   1 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
80892 104890 2 54 150 Gonzalez Dr 1 2 1 1         empty 5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
3514 21564 3 112 1450 Sutter St 1 1 1 2     9 4X4 dead 6005645.68769 2114853.19648 37.787302788433706 -122.424259698627 (37.7873027884337, -122.424259698627)
105077 85251 1 12 1151 Geneva Ave 1 1 1 1   07/19/2007 12:00:00 AM 3 3x3 Under 3yr maintenance agreement. Expires 6/15/2010. 6001497.16836 2088486.70556 37.714671592027294 -122.43672457862 (37.7146715920273, -122.43672457862)
61148 85309   41 1250 Haight St 1 1 1 2 3 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
140895 85310   41 1250 Haight St 2 1 1 2 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
19901 21524 1 37 2709X Diamond St 2 1 1 1     3   Tree was replanted 02/06/07 6002363.91789 2096241.5628900002 37.7360139044279 -122.434282822689 (37.7360139044279, -122.434282822689)
97454 105000 3 60 280X SAN MARCOS AVE 1 11 1 2     65   Tree tag no. 416 5993063.2 2100277.9 37.7465643757171 -122.466732187112 (37.7465643757171, -122.466732187112)
112265 104738 2 208 200X Fair Oaks St 1 1 1 1         Tree on the 23rd St side of property 6005413.0 2102541.0 37.753483315938 -122.42418878244499 (37.753483315938, -122.424188782445)
7216 92890 2 44 800 Montgomery St 2 1 1 1     12 3x3 Tree no. 2 on Montgomery 6011720.98401 2118117.86666 37.796607963049 -122.403470105059 (37.796607963049, -122.403470105059)
106271 92908 2 44 802 Montgomery St 2 1 1 1     12 3x3 Tree no. 2 on Jackson St. 6011726.0 2118056.0 37.796438372253796 -122.40344839382601 (37.7964383722538, -122.403448393826)
120551 13294 1 11 2680X Lombard St 3 1 1 1   11/16/2001 12:00:00 AM 8 3X3 Tree located adjacent to 3000 Baker 5999556.3855 2119169.40502 37.798808242360295 -122.445637828136 (37.7988082423603, -122.445637828136)
128507 110558 3 43 1X Otis St 1 1 1 1       3x3 Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection 6007165.9 2109609.0 37.7729892139286 -122.418628045346 (37.7729892139286, -122.418628045346)
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
22308 248932 9 24 46 Cook St 1 7 1 1         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
114869 111205 9 24 46 COOK ST   13 1 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
92869 99821 2 218 1230 Twin Peaks Blvd 1 13 1 1     11   Tree closest to sidewalk and retaining wall 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
99553 93063 1 17 145 Woodland Ave 5 1 1 1       2.5x2.5 Tree 5 on Willard. 5996969.6 2105856.9 37.7621075834522 -122.453627125583 (37.7621075834522, -122.453627125583)
76486 93151 2 26 284X Funston Ave 5 1 1 1     6   Tree 5 on Funston. 5991864.0342 2113562.75305 37.782971765930796 -122.471846777677 (37.7829717659308, -122.471846777677)
128840 94065 1 28 98 Ney St 5 1 1 1         Tree 5 on Craut 6004036.0 2094004.0 37.7299648256421 -122.42834233456199 (37.7299648256421, -122.428342334562)
96625 93062 1 17 145 Woodland Ave 4 1 1 1     8 2.5x2.5 Tree 4 on Willard. 5996969.6 2105856.9 37.7621075834522 -122.453627125583 (37.7621075834522, -122.453627125583)
126310 92977 1 26 1741 Turk St 4 1 1 1     7   Tree 4 on Seymour St. 6001670.119 2112142.3771 37.779634286353996 -122.437820070618 (37.779634286354, -122.437820070618)
97926 93120 1 15 1555 Hayes St 4 1 1 1     6 3x3 Tree 4 on Lyon St 6000421.0 2110261.0 37.774397395284 -122.44200622209299 (37.774397395284, -122.442006222093)
354 93479 2 32 113X Leroy Pl 4 1 1 1     9 1.5x3 Tree 4 on Leroy 6008317.250990001 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331)
116724 93001 1 21 395 03rd St 4 1 1 1     9 3x3 Tree 4 on Harrison St 6013360.4 2113007.0 37.7826661507953 -122.397438711561 (37.7826661507953, -122.397438711561)
105829 94064 1 28 98 Ney St 4 1 1 1         Tree 4 on Craut 6004036.0 2094004.0 37.7299648256421 -122.42834233456199 (37.7299648256421, -122.428342334562)
95827 93061 1 17 145 Woodland Ave 3 1 1 1       2.5x2.5 Tree 3 on Willard. 5996969.6 2105856.9 37.7621075834522 -122.453627125583 (37.7621075834522, -122.453627125583)
180376 92976 1 26 1741 Turk St 3 1 1 1     8   Tree 3 on Seymour St. 6001673.9808 2112126.93 37.779592092116395 -122.437805604344 (37.7795920921164, -122.437805604344)
3947 93478 2 32 113X Leroy Pl 3 1 1 1     9 1.5x3 Tree 3 on Leroy 6008314.47624 2116646.88711 37.792378156480396 -122.415153240053 (37.7923781564804, -122.415153240053)
139372 93000 1 21 395 03rd St 3 1 1 1     7 3x3 Tree 3 on Harrison St 6013360.4 2113007.0 37.7826661507953 -122.397438711561 (37.7826661507953, -122.397438711561)
116551 93975 1 161 59@ Golden gate Ave Roselyn Ter 3 5 1 1         Tree 3 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
177136 93149 2 26 284X Funston Ave 3 1 1 1     7   Tree 3 on Funston. 5991868.14141 2113524.63495 37.782867341772295 -122.47182978962499 (37.7828673417723, -122.471829789625)
145528 94063 1 28 98 Ney St 3 1 1 1         Tree 3 on Craut 6004036.0 2094004.0 37.7299648256421 -122.42834233456199 (37.7299648256421, -122.428342334562)
121533 93024 1 53 394 Fair Oaks St 3 1 1 1         Tree 3 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
103513 93863 1 11 729 Tennessee St 3 1 1 1       3x3 Tree 3 on 18th St. 6015474.0 2105663.0 37.76261860269621 -122.38961341567699 (37.7626186026962, -122.389613415677)
139234 93020 1 19 1403 11th Ave 3 5 1 1     10 2x2 Tree 3 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
83213 93060 1 17 145 Woodland Ave 2 1 1 1       2.5x5 Tree 2 on Willard 5996969.6 2105856.9 37.7621075834522 -122.453627125583 (37.7621075834522, -122.453627125583)
179113 92975 1 26 1741 Turk St 2 1 1 1     7   Tree 2 on Seymour St. 6001675.9117 2112115.8273 37.7795617167054 -122.437798129123 (37.7795617167054, -122.437798129123)
90092 93735 2 60 201@ Page Central Ave 2 1 1 1         Tree 2 on Page St. 5999812.1 2109210.9 37.771479369328205 -122.44403704657 (37.7714793693282, -122.44403704657)
7611 93477 2 32 113X Leroy Pl 2 1 1 1     12 1.5x3 Tree 2 on Leroy 6008311.901880001 2116662.47431 37.7924208104303 -122.415163251278 (37.7924208104303, -122.415163251278)
100435 92999 1 21 395 03rd St 2 1 1 1     8 3x3 Tree 2 on Harrison St 6013360.4 2113007.0 37.7826661507953 -122.397438711561 (37.7826661507953, -122.397438711561)
138791 93974 1 161 59@ Golden Gate Ave Roselyn Ter 2 5 1 1         Tree 2 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
53961 93148 2 26 284X Funston Ave 2 1 1 1     7 3x5 Tree 2 on Funston. 5991866.59303 2113502.9352 37.7828076706429 -122.471833564338 (37.7828076706429, -122.471833564338)
142740 94062 1 28 98 Ney St 2 1 1 1         Tree 2 on Craut 6004036.0 2094004.0 37.7299648256421 -122.42834233456199 (37.7299648256421, -122.428342334562)
120498 93977 1 16 75 Loraine Ct 2 1 1 1     15 3x3 Tree 2 on Anza. 5996139.989030001 2112289.25125 37.7797215523196 -122.45696168713002 (37.7797215523196, -122.45696168713)
144992 93023 1 53 394 Fair Oaks St 2 1 1 1         Tree 2 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
103081 93862 1 11 729 Tennessee St 2 1 1 1       3x3 Tree 2 on 18th St. 6015474.0 2105663.0 37.76261860269621 -122.38961341567699 (37.7626186026962, -122.389613415677)
89654 93059 1 17 145 Woodland Ave 1 1 1 1       2.5x5 Tree 1 on Willard 5996969.6 2105856.9 37.7621075834522 -122.453627125583 (37.7621075834522, -122.453627125583)
141818 92965 1 2 3650X Rivera St 1 1 1 1     6 3x3 Tree 1 on Rivera St 5981790.1 2100170.3 37.7456119015234 -122.505704709348 (37.7456119015234, -122.505704709348)
119539 92973 1 44 10 Diamond St 1 1 1 1         Tree 1 on Market St. 6001664.0 2105786.0 37.7621809066996 -122.437385951828 (37.7621809066996, -122.437385951828)
6822 93476 2 32 113X Leroy Pl 1 1 1 1     8 3x3 Tree 1 on Leroy. 6008309.35619 2116677.55783 37.79246208300879 -122.41517312764499 (37.7924620830088, -122.415173127645)
145724 93021 1 2 1403 11th Ave 1 1 1 1     4 4x4 Tree 1 on Judah 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
100287 92998 1 21 395 03rd St 1 1 1 1     11 3x3 Tree 1 on Harrison St 6013360.4 2113007.0 37.7826661507953 -122.397438711561 (37.7826661507953, -122.397438711561)
87296 93973 1 161 59@ Golden gate Ave Roselyn Ter 1 5 1 1         Tree 1 on Golden gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
177671 93147 2 26 284X Funston Ave 1 1 1 1     9   Tree 1 on Funston. 5991866.22681 2113485.5569 37.7827599334256 -122.47183356435801 (37.7827599334256, -122.471833564358)
121161 94061 1 28 98 Ney St 1 1 1 1         Tree 1 on Craut. 6004036.0 2094004.0 37.7299648256421 -122.42834233456199 (37.7299648256421, -122.428342334562)
90151 94067 1 17 729 Tennessee St 1 1 1 1   04/27/2010 12:00:00 AM   3x3 Tree 1 on 18th St. 6015474.0 2105663.0 37.76261860269621 -122.38961341567699 (37.7626186026962, -122.389613415677)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
104270 75029 2 80 141X Arleta Ave 1 1 1 13 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104340 74892 2 80 141X Arleta Ave 2 1 1 13 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
145874 100769 2 47 3701 21st St   7 1 1     55   Street tree w/in RoW 6003717.0 2103606.0 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292)
104353 98250 1 17 650 Eddy St   1 2 1         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554)
141034 4148 3 18 3631 Cesar Chavez St 1 1 1 2   02/17/1999 12:00:00 AM 3 3X3 She would like to be kept in the loop on what happens with this. 6006082.4281665 2100506.5376626 37.7479349243864 -122.421729258843 (37.7479349243864, -122.421729258843)
Powered by Datasette · Query took 94.157ms · Data source: data.sfgov.org