167 rows where qSpecies_id = 159 sorted by Supervisor Districts

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▼ Zip Codes Neighborhoods (old)
982 104688 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
10181 136982 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 318 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 Width 3ft   5998604.86094 2115349.07691 37.7882642689212 -122.448655097854 (37.7882642689212, -122.448655097854) 13 6 1 54 31
17717 136981 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 318 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 Width 4ft   5998609.50296 2115332.42012 37.7882187992024 -122.448637837165 (37.7882187992024, -122.448637837165) 13 6 1 54 31
39900 57666 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1859 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2018 12:00:00 AM 3   Permit Number 781473 6001486.9188 2114903.6541 37.787205629264 -122.43865174857 (37.787205629264, -122.43865174857) 13 6 1 29490 27
55452 35488 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094) 15 6 1 29490 27
81956 122427 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
99982 122422 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
113221 122425 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
119455 101645 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2609 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/07/2018 12:00:00 AM   3x3   6001467 2114916 37.7872383947834 -122.438721548179 (37.7872383947834, -122.438721548179) 13 6 1 29490 27
124129 117585 Undocumented 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 3100X FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002493 2118872 37.7981588656011 -122.435454914846 (37.7981588656011, -122.435454914846) 13 9 1 57 17
130756 12817 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2140 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2014 12:00:00 AM 2 5   5988770.65902 2114708.68477 37.7859386982185 -122.482632451333 (37.7859386982185, -122.482632451333) 11 6 1 55 33
136423 122426 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 8 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
159819 122424 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
162627 35487 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557) 15 6 1 29490 27
163167 137064 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2781 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999684.54965 2118419.78923 37.7967573134519 -122.445140418692 (37.7967573134519, -122.445140418692) 13 9 1 57 17
172560 122428 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 10 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
177350 122423 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
150004 137065 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 11 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6012521.25442 2120194.7201 37.8023551696124 -122.400846960714 (37.8023551696124, -122.400846960714) 3 1 10 28860 6
174409 251259 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1050x Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009753 2116795 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148) 3 1 10 28857 21
190126 137066 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 12 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     7     6012425.54206 2120223.78485 37.8024296352708 -122.401180217987 (37.8024296352708, -122.401180217987) 3 1 10 28860 6
54956 256925 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 307 Page St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2019 12:00:00 AM 3   Permit Number 782767 6005088.03267 2109871.77531 37.7735935283003 -122.425834355986 (37.7735935283003, -122.425834355986) 7 9 11 28852 10
59178 69599 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 366 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/2014 12:00:00 AM 3   Permit Number 773624 6004805.18148758 2109878.85249056 37.7735969721496 -122.42681328543 (37.7735969721496, -122.42681328543) 7 9 11 28852 10
83007 88649 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 135 Fillmore St   Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778385 6003732.7 2108890.4 37.7708222270411 -122.43045261887 (37.7708222270411, -122.43045261887) 15 9 11 29492 10
104174 115167 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1157 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM     Permit Number 777350 5997321.9 2106236.4 37.7631697841866 -122.452436048563 (37.7631697841866, -122.452436048563) 15 5 11 29492 12
115102 254629 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 321 Page St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 01/09/2019 12:00:00 AM 3 6x18 Permit Number 782768 6005023.51354 2109862.79569 37.7735652261688 -122.426056898155 (37.7735652261688, -122.426056898155) 7 9 11 28852 10
163686 87185 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1245 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2008 12:00:00 AM   3x3 Permit Number 50187 5999399.3 2108538 37.7696081992395 -122.445416546032 (37.7696081992395, -122.445416546032) 15 5 11 29492 9
25567 120786 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 253 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5989295.33642 2113646.62963 37.7830531045228 -122.480739452185 (37.7830531045228, -122.480739452185) 11 6 2 55 26
133485 112783 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 506 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM     Permit Number 774416 5992870.4 2111974.5 37.7786690335249 -122.468249618869 (37.7786690335249, -122.468249618869) 11 6 2 54 11
35067 242786 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 410 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005479.73909 2101277.25684 37.7500171373833 -122.423868129325 (37.7500171373833, -122.423868129325) 2 4 5 28859 19
36146 95382 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 4317 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767252 6001161 2101705 37.7509468617733 -122.438833174961 (37.7509468617733, -122.438833174961) 2 4 5 28862 22
42323 242765 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 64 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2018 12:00:00 AM 3 Width 3ft Permit Number 780725 6002894.46914 2108642.40455 37.7700937736426 -122.433334350915 (37.7700937736426, -122.433334350915) 15 5 5 29492 9
72098 116842 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1110 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6003795.63291288 2101809.17317596 37.7513824368578 -122.429729790926 (37.7513824368578, -122.429729790926) 2 4 5 28862 22
94194 72489 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 410 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2013 12:00:00 AM 3 4x4 Permit Number 775549 6005471.04760898 2101307.0300515 37.7500983970927 -122.423900301836 (37.7500983970927, -122.423900301836) 2 4 5 28859 19
98457 49040 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1110 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46215 6003795.63291288 2101809.17317596 37.7513824368578 -122.429729790926 (37.7513824368578, -122.429729790926) 2 4 5 28862 22
120261 95393 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 3965 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767262 6004412 2100353 37.747419006534 -122.427494591738 (37.747419006534, -122.427494591738) 2 7 5 63 22
124132 32862 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 367 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/28/2012 12:00:00 AM     Permit Number 769301 6002770.016647 2101497.55213803 37.7504686693665 -122.433254224 (37.7504686693665, -122.433254224) 2 4 5 28862 22
126279 59736 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 916 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/19/2016 12:00:00 AM     Permit Number 775357 6003734.07108678 2102930.08592587 37.7544567132931 -122.430022630753 (37.7544567132931, -122.430022630753) 2 4 5 28862 22
133246 242790 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 444 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001493.01525 2103141.50906 37.7549100545634 -122.437787910606 (37.7549100545634, -122.437787910606) 2 4 5 28862 22
135579 81136 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 4657 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2012 12:00:00 AM   3x3 Permit Number 768983 6000147.95764033 2105151.97717561 37.7603537323491 -122.442583825347 (37.7603537323491, -122.442583825347) 2 4 5 28862 3
160830 33043 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 418 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2015 12:00:00 AM     Permit Number 775549 6005473.51792127 2101262.44502377 37.7499761163357 -122.423888589368 (37.7499761163357, -122.423888589368) 2 4 5 28859 19
168278 98852 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 64 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2012 12:00:00 AM   3x3 Permit Number 768793 6002914.9 2108659.2 37.770141048876 -122.433264881179 (37.770141048876, -122.433264881179) 15 5 5 29492 9
182317 110252 Undocumented 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1514 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2015 12:00:00 AM 3 3x3 Permit Number 774936 6002531.9 2101059.9 37.7492534689809 -122.434046366801 (37.7492534689809, -122.434046366801) 2 4 5 28862 22
8086 160876 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 623 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 11:58:00 AM 3 Width 0ft   6002712.67368 2089986.17958 37.7188578210185 -122.432630343637 (37.7188578210185, -122.432630343637) 9 7 6 28861 5
59924 180577 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 106 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004093.30661 2094009.22503 37.7299824149549 -122.428144590899 (37.7299824149549, -122.428144590899) 9 7 6 28861 5
75931 180576 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 100 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004076.33336 2094007.41244 37.7299764776345 -122.428203140362 (37.7299764776345, -122.428203140362) 9 7 6 28861 5
98757 114871 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 539 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2015 12:00:00 AM 3 3x3   6003469.27137 2090174.15825 37.7194168476851 -122.430028488037 (37.7194168476851, -122.430028488037) 9 7 6 28861 5
99426 180574 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 605 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002770.24765 2090074.97352 37.7191048944443 -122.432437671986 (37.7191048944443, -122.432437671986) 9 7 6 28861 5
125147 180578 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 106 Ney St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004112.42356 2094009.69579 37.7299847891668 -122.42807853481 (37.7299847891668, -122.42807853481) 9 7 6 28861 5
131946 160542 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 787 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 08:58:00 AM 3 Width 0ft   6001926.33849 2089244.23873 37.7167759911908 -122.435295346912 (37.7167759911908, -122.435295346912) 9 7 6 28861 5
145974 83897 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 177 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50522 6001329.15000051 2093174.60526977 37.7275339578399 -122.437640847728 (37.7275339578399, -122.437640847728) 9 7 6 28861 25
161825 254647 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1123 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2018 12:00:00 AM 3 3x3 Permit Number 781530 6001667.85915 2087035.00325 37.7106952372321 -122.436030785046 (37.7106952372321, -122.436030785046) 9 7 6 28861 5
163444 108833 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 79 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774661 6003925.19138 2094039.50832 37.7300560527634 -122.428727943603 (37.7300560527634, -122.428727943603) 9 7 6 28861 5
167974 180575 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 185 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004602.74534 2093797.60717 37.7294301700595 -122.426368337242 (37.7294301700595, -122.426368337242) 9 7 6 28861 5
182624 160541 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 795 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 09:01:00 AM 3 Width 0ft   6001897.94252 2089197.43685 37.7166458709939 -122.435390151656 (37.7166458709939, -122.435390151656) 9 7 6 28861 5
188982 17508 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 209 Persia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/25/2008 12:00:00 AM 3 3X3   6002263.2849739 2091285.3954444 37.7223996821352 -122.434276533913 (37.7223996821352, -122.434276533913) 9 7 6 28861 5
194429 160546 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 755 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 08:38:00 AM 3 4x5   6002026.63127 2089400.9055 37.7172118584185 -122.434959882691 (37.7172118584185, -122.434959882691) 9 7 6 28861 5
7874 85664 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2774 FOLSOM ST 1 Sidewalk: Property side : Cutout Tree Private 2   09/14/2007 12:00:00 AM 3 5x5 Permit Number 49691 6008274 2102260 37.7528728796483 -122.414274918711 (37.7528728796483, -122.414274918711) 2 4 7 28859 19
15322 85866 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2000 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 5 3x3   6008038 2106791 37.7653007068824 -122.415411798097 (37.7653007068824, -122.415411798097) 8 4 7 28859 19
22172 85861 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1900 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 3 3x3   6008004 2107379 37.7669133068935 -122.415571030805 (37.7669133068935, -122.415571030805) 8 4 7 28853 19
25748 103737 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2075 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 9 3x3   6008144.6 2106350.8 37.7640980107115 -122.415011932629 (37.7640980107115, -122.415011932629) 8 4 7 28859 19
28508 85867 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2108 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 3 3x3   6008073 2106151 37.7635453824423 -122.415245432357 (37.7635453824423, -122.415245432357) 8 4 7 28859 19
29011 85871 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2366 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 6 3x3   6008161 2104646 37.759417944294 -122.414834546653 (37.759417944294, -122.414834546653) 2 4 7 28859 19
30448 96190 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2889 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2007 12:00:00 AM 3 3x3   6008375.88429 2101615.45305 37.7511088214431 -122.413876992419 (37.7511088214431, -122.413876992419) 2 4 7 28859 19
34339 85878 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2460 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2013 12:00:00 AM 9 3x3   6008191 2104098 37.7579149473155 -122.414692010384 (37.7579149473155, -122.414692010384) 2 4 7 28859 19
42017 38309 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2000 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2016 12:00:00 AM 3   Permit Number 771420 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
45256 103729 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2331 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2007 12:00:00 AM 3 3x3   6008229.6 2104850.4 37.7599830341433 -122.414611757947 (37.7599830341433, -122.414611757947) 2 4 7 28859 19
52003 85872 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2380 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2007 12:00:00 AM 3 3x3   6008166 2104564 37.7591930720313 -122.414811450754 (37.7591930720313, -122.414811450754) 2 4 7 28859 19
54123 116788 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 530 CRESCENT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6007719 2095661 37.7347223035732 -122.415727003996 (37.7347223035732, -122.415727003996) 2 7 7 28859 2
69276 85860 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1740X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 3 3x3   6007977 2108187 37.7691303681921 -122.415721637336 (37.7691303681921, -122.415721637336) 8 4 7 28853 19
70445 103734 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2121 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 8 3x3   6008239 2106082 37.7633652523205 -122.414666405954 (37.7633652523205, -122.414666405954) 8 4 7 28859 19
74193 242789 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 305 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007810.4861 2106094.80833 37.7633763361668 -122.416149407388 (37.7633763361668, -122.416149407388) 8 4 7 28859 19
75103 103725 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2899X Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2007 12:00:00 AM 3 3x3   6008379.2 2101559.4 37.7509550985774 -122.413861561675 (37.7509550985774, -122.413861561675) 2 4 7 28859 19
77094 85869 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2270 Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 3 3x3   6008114.589813 2105604.399495 37.7620468810261 -122.415062894122 (37.7620468810261, -122.415062894122) 2 4 7 28859 19
79038 85862 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1916 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 3 3x3   6008009 2107284 37.766652740099 -122.415547009853 (37.766652740099, -122.415547009853) 8 4 7 28853 19
81139 255311 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2570 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2018 12:00:00 AM 3   Permit Number 781842 6008232.7883 2103462.52902 37.7561724366372 -122.414502522334 (37.7561724366372, -122.414502522334) 2 4 7 28859 19
82923 242782 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 3060 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009196.55797 2101026.42039 37.7495375244342 -122.41099740632 (37.7495375244342, -122.41099740632) 2 4 7 28859 19
83919 103728 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2335 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008231 2104824.3 37.7599114481852 -122.414605069015 (37.7599114481852, -122.414605069015) 2 4 7 28859 19
86435 103735 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2101 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 8 3x3   6008250.5 2106082.2 37.7633664475813 -122.414626645226 (37.7633664475813, -122.414626645226) 8 4 7 28859 19
88081 103740 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2075 Folsom St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008144.6 2106350.8 37.7640980107115 -122.415011932629 (37.7640980107115, -122.415011932629) 8 4 7 28859 19
88597 85875 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2430 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 5 3x3   6008182 2104273 37.7583949516436 -122.414735520813 (37.7583949516436, -122.414735520813) 2 4 7 28859 19
92822 85865 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1942 FOLSOM ST 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 8 3x3   6008004.1 2107116.2 37.7661917249755 -122.415552076688 (37.7661917249755, -122.415552076688) 8 4 7 28853 19
95123 85868 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2140 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 3 3x3   6008084 2105965 37.7630352876724 -122.415194219578 (37.7630352876724, -122.415194219578) 8 4 7 28859 19
95264 103755 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2310 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 3 3x3   6008013.6 2104845.6 37.7599577167173 -122.41535846005 (37.7599577167173, -122.41535846005) 2 4 7 28859 19
96928 99977 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2295 Folsom St 15 Sidewalk: Curb side : Cutout Tree DPW 1         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
97196 85877 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2456 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2013 12:00:00 AM 3 3x3   6008190 2104121 37.7579780438756 -122.414697096466 (37.7579780438756, -122.414697096466) 2 4 7 28859 19
103349 242788 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 305 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007812.97751 2106058.80596 37.7632776220932 -122.416138240487 (37.7632776220932, -122.416138240487) 8 4 7 28859 19
104943 85876 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2448 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 3 3x3   6008187 2104168 37.7581069265794 -122.414710797864 (37.7581069265794, -122.414710797864) 2 4 7 28859 19
108578 103731 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2225 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008315.8 2105284.4 37.7611795410637 -122.414344341073 (37.7611795410637, -122.414344341073) 2 4 7 28859 19
115415 99976 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2295 Folsom St 14 Sidewalk: Curb side : Cutout Tree DPW 1           6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
122454 85879 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2470 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 3 3x3   6008200.675657 2104045.307158 37.7577708084255 -122.414654818932 (37.7577708084255, -122.414654818932) 2 4 7 28859 19
125246 57650 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 72 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2015 12:00:00 AM 20 5x5 Permit Number 775745 6006036.17591453 2097613.2408617 37.7399879775785 -122.421683726825 (37.7399879775785, -122.421683726825) 2 7 7 28859 2
131318 99947 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 522 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2012 12:00:00 AM   4x4 Permit Number 54785 6007824 2104880.2 37.7600420622217 -122.416016646831 (37.7600420622217, -122.416016646831) 2 4 7 28859 19
136252 103733 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2225 Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008315.8 2105284.4 37.7611795410637 -122.414344341073 (37.7611795410637, -122.414344341073) 2 4 7 28859 19
137903 103727 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2485 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008277.2 2103979.5 37.7575944160951 -122.414385508985 (37.7575944160951, -122.414385508985) 2 4 7 28859 19
138343 103730 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2315 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2007 12:00:00 AM 3 3x3   6008264.6 2104925.3 37.7601906586786 -122.414496009535 (37.7601906586786, -122.414496009535) 2 4 7 28859 19
138404 85874 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2424 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2007 12:00:00 AM 5 3x3   6008180 2104307 37.7584881954941 -122.414744843888 (37.7584881954941, -122.414744843888) 2 4 7 28859 19
144641 85864 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 1942 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 6 3x3   6008004.1 2107116.2 37.7661917249755 -122.415552076688 (37.7661917249755, -122.415552076688) 8 4 7 28853 19
149271 103739 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2075 Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008144.6 2106350.8 37.7640980107115 -122.415011932629 (37.7640980107115, -122.415011932629) 8 4 7 28859 19
151445 103736 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2101 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 8 3x3   6008250.5 2106082.2 37.7633664475813 -122.414626645226 (37.7633664475813, -122.414626645226) 8 4 7 28859 19
161036 116356 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2752 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6008296 2102398 37.7532530322434 -122.414208601119 (37.7532530322434, -122.414208601119) 2 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);