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)
184785 113031 3 1 251 06th Ave 2 1 1 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665)
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)
177834 100976 3 22 450X Chestnut St 8 1 1 4 4   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876)
177652 115972 3 8 1599x 30th Ave 9 1 1 4     8 3x3   5986817.4474 2104547.1317 37.757924098588795 -122.488642781125 (37.7579240985888, -122.488642781125)
176592 34689 1 55 3101X Webster St 3 1 1 4 4 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.79943447017929 -122.434367321195 (37.7994344701793, -122.434367321195)
175061 115966 3 8 1599x 30th Ave 3 1 1 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582)
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)
168456 115973 3 8 1599x 30TH AVE 10 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
166994 34691 1 55 3101X Webster St 5 1 1 4 4 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.43435014504699 (37.7993346796145, -122.434350145047)
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)
166151 115971 3 8 1599x 30th Ave 8 1 1 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.48865668838499 (37.757993947556, -122.488656688385)
164886 115968 3 8 1599x 30th Ave 5 1 1 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.48866427663799 (37.7582024774349, -122.488664276638)
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)
161870 98647 1 55 2110 Greenwich St 4 1 1 4 4   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619)
160302 115965 3 8 1599x 30th Ave 2 1 1 4     7 3x3   5986811.649 2104744.2782 37.758465070521105 -122.488677324697 (37.7584650705211, -122.488677324697)
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)
153048 98645 1 55 2110 Greenwich St 2 1 1 4 4   9 5x5   6002788.88101 2119245.38589 37.799200885676605 -122.434457791187 (37.7992008856766, -122.434457791187)
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)
147766 100979 3 22 450X Chestnut St 11 1 1 4 4   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727)
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)
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)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145311 100972 3 26 450X Chestnut St 4 1 1 4 4 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
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)
145041 92956 1 5 300 Seneca Ave 1 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
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)
144522 95498 2 60 600X 32nd Ave 22 1 1 4     18 3x3   5985976.055430001 2112422.37376 37.779498166536605 -122.492132474117 (37.7794981665366, -122.492132474117)
144514 96603 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
144168 113470 2 59 450 CHURCH ST 27 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
144074 92957 1 5 300 Seneca Ave 2 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
144041 97895 2 49 375X Precita Ave 1 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
143214 96582 3 131 401x Otsego Ave 7 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
143144 105784 2 53 1570 31ST AVE 1 1 1 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
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)
142924 108788 1 51 1100-1198X Schwerin St 4 1 1 4 1 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682)
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)
142420 95236 2 26 1220 Noe St 2 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
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)
142332 95517 2 51 600X 32nd Ave 3 1 1 4     10 3x3   5985993.99278 2111923.13747 37.778128454962 -122.49203365493601 (37.778128454962, -122.492033654936)
142324 117253 6 143 2500x 34TH AVE 3 17 1 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
142264 96605 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
141798 95490 2 51 600X 32nd Ave 8 1 1 4     3 3x3   5986007.65609 2111463.21002 37.7768664240251 -122.49195251911199 (37.7768664240251, -122.491952519112)
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)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
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)
141236 112028 3 2 2101x 22nd Ave 8 1 1 4   07/23/2015 12:00:00 AM 3 9x9   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
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)
141032 96584 3 131 401x Otsego Ave 9 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
140987 95489 2 51 600X 32nd Ave 9 1 1 4     6 3x3   5986007.8525 2111486.5622099997 37.7769305539658 -122.49195355936199 (37.7769305539658, -122.491953559362)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
140524 107868 3 15 830X Harrison St 1 1 1 4           6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
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)
Powered by Datasette · Query took 2.753ms · Data source: data.sfgov.org