sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19027 97174 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19781 96412 6 175 185 Chilton Ave   7 1 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
50166 95953 6 17 499 Buena Vista East Ave   7 1 1   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177.0 2107098.0 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531)
51543 95372 6 3 180 Yukon St   16 1 1     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.44240692055901 (37.7570738455347, -122.442406920559)
54776 95300 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
78391 108038 6 3 1 Twin Peaks Blvd   7 1 1           5998985.485719999 2105240.3128 37.760529947122706 -122.446610614338 (37.7605299471227, -122.446610614338)
78522 112919 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
80420 105844 6 17 355 Buena Vista Ave   7 1 1   03/03/2014 12:00:00 AM     Permit Number 771052 6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
81040 112918 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
81688 93931 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
83393 92053 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
85824 112921 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
86498 107113 6 115 2100 MARKET ST   8 1 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
87949 96848 6 75 1486 Innes Ave   7 1 1           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251)
89530 112922 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
90772 106612 6 138 1189 TENNESSEE ST   7 1 1     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024)
92048 111996 6 17 501 Point Lobos Ave   7 1 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.779687857228296 -122.508495636007 (37.7796878572283, -122.508495636007)
93582 93724 6 62 415 Belvedere St   7 1 1           5998488.0 2106798.0 37.7647785355325 -122.44844336243601 (37.7647785355325, -122.448443362436)
93720 106927 6 13 4150 24th St   5 1 1       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626)
93904 118327 6 26 109 ALPINE TER   1 1 1     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181002 (37.7688096651516, -122.43737752181)
95092 93874 6 150 2614 Sacramento St   25 1 1   04/14/2010 12:00:00 AM     Permit Number 53370 6002291.0 2115777.0 37.789649322620896 -122.43593231943599 (37.7896493226209, -122.435932319436)
96055 107245 6 17 140 CEDRO AVE   7 1 1           5991993.7 2093259.3 37.727231291852604 -122.469919436342 (37.7272312918526, -122.469919436342)
96557 107036 6 17 350 08th St   5 1 1   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826.0 2110084.0 37.774442857676505 -122.409459923405 (37.7744428576765, -122.409459923405)
96813 112924 6 3 2X Noe St   9 1 1           6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
97751 110321 6 484 1x SAN PABLO AVE   1 1 1   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773.0 2097898.0 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756)
98130 95234 6 17 7 Almaden Ct   7 1 1   01/25/2011 12:00:00 AM     Permit Number 767129 5995849.0 2112535.0 37.780379598944705 -122.457986127959 (37.7803795989447, -122.457986127959)
99064 93932 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
99731 115673 6 183 86 Stanton St   7 1 1           6000281.6 2103909.8 37.7569506357303 -122.442032456595 (37.7569506357303, -122.442032456595)
100331 112930 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
102016 105368 6 2 180 CLIFFORD TER   1 1 1           5999283.1 2106587.2 37.7642451591147 -122.44567816768298 (37.7642451591147, -122.445678167683)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
103866 87188 6 17 2119 Bush St   7 1 1   01/29/2008 12:00:00 AM     Permit Number 50204 6002998.0 2114831.0 37.787091984974104 -122.433418544226 (37.7870919849741, -122.433418544226)
105112 95242 6 3 2620 Larkin St   7 1 1     37   Permit Number 56959 6006630.0 2120172.0 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572)
105512 105130 6 17 4045 MORAGA ST   9 1 1           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635)
106619 86895 6 17 321 Haight St   7 1 1   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
109838 98274 6 82 766 Anderson St   7 1 1   01/23/2012 12:00:00 AM 18   Permit Number 768445 6007723.0 2095324.0 37.7337971999422 -122.41568932106199 (37.7337971999422, -122.415689321062)
109889 93903 6 75 546 Page St   25 1 1           6003947.0 2109752.0 37.773200107256606 -122.42977281454901 (37.7732001072566, -122.429772814549)
110495 95215 6 175 2203 Divisadero St   7 1 1           6000868.0 2115894.0 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631)
112470 110950 6 3 342 HILL ST   7 1 1     15 3x3 Permit Number 778799 6004048.0 2103384.0 37.755720828524204 -122.42896934322901 (37.7557208285242, -122.428969343229)
112771 109706 6 47 96 CRESTA VISTA DR   16 1 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
113676 95299 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
115263 97894 6 17 2927 Folsom St   7 1 1   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395.0 2101384.0 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972)
115520 112925 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
116721 105845 6 3 355 Buena Vista Ave   7 1 1           6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
117221 94066 6 161 548 Page St   25 1 1   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526)
117865 112928 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
119294 92055 6 180 1001 Potrero Ave   9 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
120702 97175 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
121702 95777 6 518 30 Onondaga Ave   7 1 1   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.721861535681704 -122.437972107548 (37.7218615356817, -122.437972107548)
122936 107159 6 47 1000 ESMERALDA AVE   7 1 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
123251 92054 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123402 98170 6 134 2324 Sacramento St   7 1 1   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.43117371849199 (37.7902385582714, -122.431173718492)
123605 92056 6 180 1001 Potrero Ave   9 1 1   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
124228 111770 6 243 707 Douglass St   8 1 1       3x3 Permit Number 775627 6001281.0 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375)
125171 107047 6 17 1933 15TH ST   7 1 1           6004592.7 2107127.1 37.766029309282295 -122.42735222853202 (37.7660293092823, -122.427352228532)
125242 111094 6 3 150x FONT BLVD   1 1 1   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976.0 2089133.0 37.715842612516106 -122.473136789074 (37.7158426125161, -122.473136789074)
126422 109061 6 3 36 ARBOR ST   7 1 1         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151)
127034 114142 6 3 99 Divisadero St   7 1 1           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265)
128076 112923 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
139354 106405 6 105 4849X 19th St   7 1 1         Permit Number 772769 5999644.57626 2104777.09851 37.759295701171105 -122.44429784106501 (37.7592957011711, -122.444297841065)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
140824 112927 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
141435 104808 6 277 1665 08th Ave   7 1 1     40     5993673.5 2104163.7 37.7572689897716 -122.46490400670099 (37.7572689897716, -122.464904006701)
141641 112926 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
142282 96784 6 175 615 Rhode Island St   5 1 1   07/19/2011 12:00:00 AM     Permit Number 767987 6011854.6 2105476.9 37.7619062576766 -122.40211860576099 (37.7619062576766, -122.402118605761)
142904 112920 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
142961 104761 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
144810 104762 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
484 205880 6 47 44 Mendosa Ave 1 1 1 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
563 173951 6 17 2646 Union St 1 8 1 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1159 112361 6 26 561X Folsom St 1 7 1 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1337 251410 6 21 2777 Pine St 1 8 1 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1358 173635 6 17 2590 Pacific Ave 1 8 1 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1645 251626 6 47 2R Amethyst Way 1 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 6 47 56R Amber Dr 1 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1674 251651 6 52 3237 Harrison St 1 1 1 1       3x3   6009049.0 2099828.0 37.746238652288106 -122.411423013741 (37.7462386522881, -122.411423013741)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1717 251661 6 41 3200X Van Ness Ave 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1719 251394 6 154 203 Corbett Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
1817 251719 6 116 1301 Clayton St 1 17 1 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
Powered by Datasette · Query took 11.588ms · Data source: data.sfgov.org