sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
186618 115552 2 52 925x Minnesota St 4 1 1 4 2   6 15x7   6015276.56251 2104229.2059299997 37.7586707630633 -122.390196112573 (37.7586707630633, -122.390196112573)
183769 95151 1 2 250 23rd Ave 7 1 1 4 2   13     5988720.99449 2113605.53219 37.7829068638151 -122.482723403965 (37.7829068638151, -122.482723403965)
183247 98791 3 44 950 Clay St 6 1 1 4 2   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484)
180919 115549 2 46 925x Minnesota St 1 1 1 4 2   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412)
174085 43304 3 32 693 Vermont St 11 1 1 4 2 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205)
172027 116857 2 44 950x Clay St 10 1 1 4 2   2 3x3   6010080.350930001 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981)
172003 98805 3 44 950x Clay St 7 1 1 4 2 03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010143.10639 2117195.10642 37.793986029186 -122.408864800763 (37.793986029186, -122.408864800763)
170121 116065 3 32 693 Vermont St 2 1 1 4 2   20 8x7   6011274.01561 2105377.63125 37.761601265113896 -122.404119643106 (37.7616012651139, -122.404119643106)
168957 116048 2 1 650x Kansas St 4 1 1 4 2   9 4x4   6011498.51602 2105372.79225 37.7616005195649 -122.403342842915 (37.7616005195649, -122.403342842915)
166938 116059 2 44 2100x 19th St 3 1 1 4 2   2 3x3   6011431.5308 2105131.75607 37.760934946603605 -122.40355755965099 (37.7609349466036, -122.403557559651)
166820 110958 1 26 940 Filbert St 5 1 1 4 2   11 5x5   6008447.06762 2119689.6105 37.8007401724743 -122.414909918573 (37.8007401724743, -122.414909918573)
163336 95153 1 2 250 23rd Ave 9 1 1 4 2   18     5988721.4522400005 2113658.22406 37.783051567455004 -122.482725682991 (37.783051567455, -122.482725682991)
163065 116050 2 12 650x Kansas St 6 1 1 4 2   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949)
159681 73495 1 2 250 23rd Ave 1 1 1 4 2 03/11/1995 12:00:00 AM 10     5988730.14838 2113498.62278 37.7826138532986 -122.482683898749 (37.7826138532986, -122.482683898749)
158398 116058 2 44 2100x 19th St 2 1 1 4 2   2 3x3   6011458.59484 2105134.56728 37.760944177262004 -122.403464154268 (37.760944177262, -122.403464154268)
158318 116046 2 12 650x Kansas St 2 1 1 4 2   4 5x15   6011495.20108 2105434.8979700003 37.761770862847705 -122.40335867726002 (37.7617708628477, -122.40335867726)
156514 122751 3 32 693 Vermont St 7 1 1 4 2   18     6011280.99043 2105260.13165 37.7612790272197 -122.40408725043301 (37.7612790272197, -122.404087250433)
155253 115550 2 46 925x Minnesota St 2 1 1 4 2   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.39018178636199 (37.7584697654838, -122.390181786362)
152078 110955 1 26 940 Filbert St 2 1 1 4 2   9 5x5   6008486.881990001 2119694.39066 37.8007555347125 -122.41477248237699 (37.8007555347125, -122.414772482377)
151441 70932 1 2 250 23rd Ave 2 1 1 4 2 03/11/1995 12:00:00 AM 14     5988727.46903 2113517.2675099997 37.7826648905872 -122.48269453478301 (37.7826648905872, -122.482694534783)
146991 95155 1 10 250 23rd Ave 11 1 1 4 2   16     5988718.098730001 2113738.3311400004 37.7832713237769 -122.482743157022 (37.7832713237769, -122.482743157022)
146100 43905 1 35 1050 York St 1 1 1 4 2 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
145918 47257 3 2 1035 Gilman Ave 3 1 1 4 2 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52469 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
145909 42986 3 155 2X Yale St 4 1 1 4 2 09/16/2000 12:00:00 AM 3 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
145720 98741 2 51 1150 Scott St 5 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
145659 99685 3 17 165 Grattan St 7 1 1 4 2   8 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
145524 96494 3 189 2500X Harrison St 4 1 1 4 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
145453 95270 3 21 2245 Jones St 9 1 1 4 2 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
145283 76112 3 21 380 Webster St 8 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
145208 95259 3 51 2290X 14th Ave 7 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
145137 77213 3 184 499X Hearst Ave 20 5 1 4 2 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
145003 99547 3 15 200X Henry St 1 1 1 4 2   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147)
144911 76325 3 2 3899X Kirkham St 11 1 1 4 2 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
144736 96510 3 150 2360X Harrison St 12 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
144482 98742 2 51 1150 Scott St 6 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
144409 42358 3 28 380X Flood Ave 17 1 1 4 2 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
144344 99682 3 55 165 Grattan St 4 1 1 4 2   3 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
144331 99257 3 26 151X Palm Ave 3 1 1 4 2   10 3x3   5995884.6314900005 2113369.4177200003 37.782672735096504 -122.457923263549 (37.7826727350965, -122.457923263549)
143933 113572 2 21 901 LOMBARD ST 3 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
143508 95265 3 15 2245 Jones St 3 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
143471 99669 3 17 150X Alma St 7 1 1 4 2   3 3x6   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
143233 76675 3 11 163X London St 8 1 1 4 2 05/08/1992 12:00:00 AM 8 3x3   6002837.0 2092721.0 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389)
143137 76749 3 25 200X Farallones St 5 1 1 4 2 11/20/1989 12:00:00 AM 8 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
143015 75386 3 184 163X London St 5 1 1 4 2 05/08/1992 12:00:00 AM 10 3x3   6002837.0 2092721.0 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389)
142922 95471 2 41 601X 30th Ave 1 1 1 4 2   4 3x3   5986558.17112 2112222.9767400003 37.778984690357 -122.49010404497 (37.778984690357, -122.49010404497)
142799 99688 3 17 165 Grattan St 10 1 1 4 2   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
142763 98802 3 44 950x CLAY ST 3 1 1 4 2 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
142748 37835 3 42 450X Moscow St 21 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
142732 76271 3 2 3899X Kirkham St 9 1 1 4 2 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
142731 102192 2 55 3999X Folsom St 7 1 1 4 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
142697 99369 3 2 451X 29th Ave 23 1 1 4 2   12 3x3   5986847.81361 2112672.3215799998 37.7802353734381 -122.489135113122 (37.7802353734381, -122.489135113122)
142663 42642 3 5 1600X GREEN ST 1 1 1 4 2 06/26/2000 12:00:00 AM 5 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
142592 96085 3 51 2290X 14th Ave 11 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
142587 102023 2 37 165X Chattanooga St 3 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
142357 42987 3 155 2X Yale St 5 1 1 4 2 09/16/2000 12:00:00 AM 8 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
142333 99366 3 2 451X 29th Ave 20 1 1 4 2   10 3x3   5986848.25067 2112734.65735 37.7804065552175 -122.48913818535101 (37.7804065552175, -122.489138185351)
141932 107886 3 44 941 Washington St 4 1 1 4 2 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
141821 99680 3 26 165 Grattan St 2 1 1 4 2   5 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
141815 98973 3 49 825 Shotwell St 7 1 1 4 2   8 3x3   6008234.2 2102998.9 37.754899496003105 -122.414464835105 (37.7548994960031, -122.414464835105)
141772 98748 2 26 540X Eureka St 5 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
141689 75040 3 17 499X Hearst Ave 2 5 1 4 2 05/15/1999 12:00:00 AM 18 6x20   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
141465 97247 3 12 301X Excelsior Ave 3 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003399.0 2092092.0 37.7246788362927 -122.43040815339701 (37.7246788362927, -122.430408153397)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141095 112061 2 37 1199 VISITACION AVE 3 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140800 47197 3 39 2899X Clement St 1 1 1 4 2 05/08/2002 12:00:00 AM 3 3x3   5986581.22601267 2112881.07204474 37.7807929786872 -122.490072708464 (37.7807929786872, -122.490072708464)
140600 113574 2 43 901 LOMBARD ST 5 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
140357 73285 3 5 1600X GREEN ST 10 1 1 4 2 11/20/1999 12:00:00 AM 13 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
140326 102026 2 37 165X Chattanooga St 6 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
140274 99024 3 49 3351X 23rd St 6 1 1 4 2   10 3x3   6006571.0 2102346.4 37.753014305467794 -122.420170352411 (37.7530143054678, -122.420170352411)
140146 42356 3 28 380X Flood Ave 15 1 1 4 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
140135 112060 2 37 1199 VISITACION AVE 2 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140063 74108 2 55 555 Tompkins Ave 3 1 1 4 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
139987 77634 3 55 2X Yale St 10 1 1 4 2 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
139761 97062 3 11 1599X Newcomb Ave 3 1 1 4 2   6 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
139596 73288 3 5 1600X GREEN ST 7 1 1 4 2 11/20/1999 12:00:00 AM 8 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
139544 47198 3 2 450 30th Ave 7 1 1 4 2 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.00139 2112756.95832 37.780452359911706 -122.490053975567 (37.7804523599117, -122.490053975567)
139482 97079 3 17 1551 Newcomb Ave 11 1 1 4 2   16 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
139365 98751 2 26 540X Eureka St 8 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
139322 37829 3 42 450X Moscow St 16 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
139260 99329 3 2 450 30th Ave 5 1 1 4 2   5 3x3   5986584.84396 2112715.96758 37.7803398602424 -122.49004804489701 (37.7803398602424, -122.490048044897)
139199 77209 3 28 499X Hearst Ave 16 1 1 4 2 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138862 47202 3 39 2801X Clement St 4 1 1 4 2 05/08/2002 12:00:00 AM 12 3x3 Permit Number 45157 5986698.68199 2113217.08014 37.7817224192006 -122.489691093913 (37.7817224192006, -122.489691093913)
138703 95262 3 51 2290X 14th Ave 10 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
138574 98575 3 26 301X Francisco St 13 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138394 99673 3 17 1250X Shrader St 3 1 1 4 2   8 4x4   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
138385 76170 3 11 2999X Polk St 2 1 1 4 2 11/16/1996 12:00:00 AM 5 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
138350 98747 2 26 540X Eureka St 4 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
138342 99556 3 15 200X Henry St 10 1 1 4 2   30 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147)
138303 99357 3 2 451X 29th Ave 11 1 1 4 2   3 3x3   5986839.06552 2112970.96623 37.7810548559101 -122.489187339385 (37.7810548559101, -122.489187339385)
136374 116064 3 133 693 Vermont St 1 1 1 4 2   6 8x7   6011272.30638 2105412.17877 37.761696029365794 -122.404127986133 (37.7616960293658, -122.404127986133)
136322 98804 3 44 950x Clay St 1 1 1 4 2 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.358630001 2117215.00262 37.794049298296706 -122.408332474088 (37.7940492982967, -122.408332474088)
132178 116054 2 32 650x Kansas St 10 1 1 4 2   23 4x4   6011511.93551 2105220.59815 37.761183378041395 -122.403285723377 (37.7611833780414, -122.403285723377)
130071 116057 2 44 2100x 19th St 1 1 1 4 2   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266001 (37.760947638753, -122.40338680266)
129870 116056 2 5 650x Kansas St 12 1 1 4 2   23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449)
129440 99676 3 17 1250X Shrader St 6 1 1 4 2   14 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
129289 30741 3 20 490X Page St 4 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
129243 47256 3 2 1035 Gilman Ave 2 1 1 4 2 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
129053 99029 3 49 200X Bartlett St 3 1 1 4 2   10 3x3   6006692.0 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314)
129020 77649 3 55 1300X Silliman St 10 1 1 4 2 10/26/1984 12:00:00 AM 3 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
Powered by Datasette · Query took 3.237ms · Data source: data.sfgov.org