sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1573 251597 9 148 1650 Valencia St 1 17 1 1           6006336.0 2100501.0 37.747934015176504 -122.42085202386299 (37.7479340151765, -122.420852023863)
2263 22364 9 25 5490X 03rd St 1 11 1 2     48 40TR   6014151.6099 2093070.9929 37.7279701830365 -122.393305916851 (37.7279701830365, -122.393305916851)
4546 7946 9 184 1701 Franklin St 1 1 1 1     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273)
7798 1716 9 30 555 Battery St 4 1 1 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
13675 18550 9 5 1700X Quesada Ave 5 11 1 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
16525 18547 9 72 1700X Quesada Ave 2 11 1 2     30 19   6014668.27449 2095058.7142299998 37.733456755021 -122.391658696189 (37.733456755021, -122.391658696189)
16768 18555 9 100 1700X Quesada Ave 10 11 1 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
16811 18551 9 100 1700X Quesada Ave 6 11 1 2     30 19   6014649.71614 2095074.3239900002 37.733498586072294 -122.391723949223 (37.7334985860723, -122.391723949223)
18163 24539 9 292 500X Cortland Ave 3 1 1 3     50 3X3   6007622.1254900005 2097206.54003 37.738960570878795 -122.41617135711999 (37.7389605708788, -122.41617135712)
20653 2618 9 103 1661X Octavia St 5 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
21449 24540 9 292 500X Cortland Ave 4 1 1 3     50 3X3   6007652.968230001 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819)
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)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
35608 194288 9 100 1700x Quesada Ave 37 3 1 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
39870 194287 9 100 1700x Quesada Ave 32 3 1 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
54354 194291 9 100 1700x Quesada Ave 41 3 1 2     38     6014364.32912 2095287.3135099998 37.7340675655682 -122.39272551607701 (37.7340675655682, -122.392725516077)
58702 194289 9 100 1700x Quesada Ave 38 3 1 2     48     6014396.14271 2095264.76436 37.734007417094 -122.39261394888901 (37.734007417094, -122.392613948889)
65300 111749 9 180 4124 23rd St 1 13 1 1           6002319.4 2102413.2 37.752957247271 -122.434877962118 (37.752957247271, -122.434877962118)
78801 2617 9 103 1661X Octavia St 4 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
80756 2614 9 103 1661X Octavia St 1 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
90443 111748 9 338 730 28th Ave 1 13 1 1           5987294.2 2110946.4 37.7755225253955 -122.48746405921301 (37.7755225253955, -122.487464059213)
94802 18548 9 100 1700X Quesada Ave 3 11 1 2     30 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
97410 113742 9 148 1580 Valencia St 2 7 1 1     80     6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
101071 111757 9 480 3440X Folsom St 1 7 1 3           6008633.6974599995 2098934.7859 37.743762781475 -122.41279594632401 (37.743762781475, -122.412795946324)
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)
116419 2615 9 103 1661X Octavia St 2 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
121641 64380 9 447 1221 Stanyan St 1 1 1 1   04/21/1988 12:00:00 AM     Permit Number 25220 5997415.00742592 2105661.0761541002 37.7615954244829 -122.452072511028 (37.7615954244829, -122.452072511028)
124625 111763 9 47 2626 Vallejo St 1 13 1 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
126137 105444 9 180 20-28 ROSEMONT PL 1 13 1 1           6005075.5 2108088.5 37.768696376708895 -122.425750755404 (37.7686963767089, -122.425750755404)
126390 2619 9 103 1661X Octavia St 6 1 1 2     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.42692897924101 (37.7877373561683, -122.426928979241)
138324 2616 9 103 1661X Octavia St 3 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
1138 44040 8 21 2504 Jackson St 1 1 1 1   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.7445400003 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121)
1723 112197 8 44 2570 Jackson St 1 1 1 1   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.792175654341605 -122.43739930364599 (37.7921756543416, -122.437399303646)
3768 228283 8 44 2036X 15th St 6 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 8 44 2036X 15th St 4 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 8 44 2036X 15th St 3 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 8 44 2036X 15th St 9 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 8 44 2036X 15th St 2 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 8 44 2036X 15th St 5 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
8183 112515 8 51 2646 Greenwich St 1 1 1 1     2 3x3   6000218.93903 2118886.7143900003 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154)
8240 111918 8 51 41 Toledo Way 1 1 1 1   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.801334410325104 -122.438264349848 (37.8013344103251, -122.438264349848)
8965 107967 8 15 2405x Scott St 4 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001240.6892800005 2116684.58018 37.792081580751294 -122.439631370586 (37.7920815807513, -122.439631370586)
9707 110499 8 51 900X JESSIE ST 1 1 1 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
11899 113090 8 9 1213 Silver Ave 1 1 1 1   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.6087200001 37.7303322746045 -122.41230559972999 (37.7303322746045, -122.41230559973)
12209 113082 8 172 414 Somerset St 1 1 1 1   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.726280612054204 -122.40751477809499 (37.7262806120542, -122.407514778095)
12972 92206 8 44 443 Madrid St 1 1 1 1   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.7684400002 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576)
13395 110744 8 172 2300x Mariposa St 4 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010545.16814 2106015.79361 37.76331276399971 -122.406685416098 (37.7633127639997, -122.406685416098)
13845 117146 8 49 928 Toland St 1 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646)
13873 110741 8 172 2300x Mariposa St 1 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.5636299998 37.7633264372932 -122.40648033199498 (37.7633264372932, -122.406480331995)
13959 110743 8 246 2300x Mariposa St 3 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010565.192009999 2106016.80838 37.7633166706365 -122.406616231274 (37.7633166706365, -122.406616231274)
14083 108447 8 87 696 Pennsylvania Ave 1 1 1 1     12 3x3   6014378.0974 2104018.3558400003 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138)
14294 110746 8 172 2300x Mariposa St 6 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010517.260009999 2106013.51672 37.7633049506856 -122.406781781161 (37.7633049506856, -122.406781781161)
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)
15089 117148 8 49 928 Toland St 3 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011961.8463 2098027.63913 37.7414581941431 -122.401224196662 (37.7414581941431, -122.401224196662)
15363 110742 8 172 2300x Mariposa St 2 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010595.22782 2106018.33058 37.7633225306396 -122.40651245401101 (37.7633225306396, -122.406512454011)
15752 117149 8 49 928 Toland St 4 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011929.155180001 2097982.19203 37.7413315821976 -122.40133403893499 (37.7413315821976, -122.401334038935)
15833 117147 8 49 928 Toland St 2 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978001 (37.7414998183769, -122.40118925978)
16141 116230 8 26 49 Grace St 1 1 1 1   09/02/2014 12:00:00 AM 3 2.5x4 Permit Number 770598 6008318.164030001 2110322.45497 37.7750129977898 -122.414692709823 (37.7750129977898, -122.414692709823)
16786 110745 8 298 2300x Mariposa St 5 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010533.01376 2106015.32988 37.763310810661295 -122.406727421634 (37.7633108106613, -122.406727421634)
18013 109951 8 147 400x CLEMENTINA ST 11 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
18623 117138 8 49 2203x NEWCOMB AVE 3 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
18811 19154 8 26 64 Sanchez St 1 1 1 1   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.274019999 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168)
18918 109119 8 44 2036x 15TH ST 5 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
19435 16276 8 2 690 Monterey Blvd 1 1 1 1     18 3X3   5997552.36845 2094747.2906 37.7316367142582 -122.45081049312799 (37.7316367142582, -122.450810493128)
25738 95912 8 12 858 34th Ave 1 1 1 1   03/17/2011 12:00:00 AM 4   Permit Number 767389 5985440.58134 2110021.2041 37.772873924382296 -122.49380788423099 (37.7728739243823, -122.493807884231)
27410 108451 8 87 696 Pennsylvania Ave 3 1 1 1     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387)
29879 97159 8 138 1079 Le Conte Ave 6 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.6057400005 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286)
33388 103092 8 250 1540 Jones St 2 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.6375599997 37.7955740826282 -122.41486325634399 (37.7955740826282, -122.414863256344)
42795 103093 8 250 1540 Jones St 3 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.79560661561779 -122.41486984389401 (37.7956066156178, -122.414869843894)
44012 114160 8 21 2250 Vallejo St 2 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.43439760046499 (37.7953804657925, -122.434397600465)
50489 108536 8 11 1036X Mission St 2 1 1 1       3x3   6009831.243980001 2112235.16984 37.780349758914795 -122.40959364419399 (37.7803497589148, -122.409593644194)
51328 109935 8 11 260 05th St 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
53719 98437 8 21 1840 Washington St 1 1 1 1   02/13/2012 12:00:00 AM 4 4x12 Permit Number 768068 6005870.33263 2116931.58044 37.7930221942694 -122.423630300016 (37.7930221942694, -122.423630300016)
62298 114159 8 21 2250 Vallejo St 1 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.795396310934294 -122.434341453993 (37.7953963109343, -122.434341453993)
62948 103091 8 250 1540 Jones St 1 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041)
64007 102480 8 21 1456 Chestnut St 1 1 1 1   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.9115400002 37.80203068792579 -122.427302455863 (37.8020306879258, -122.427302455863)
71351 101919 8 15 1401X California St 1 1 1 1   12/07/2012 12:00:00 AM 9 3x3 Permit Number 769132 6007497.406219999 2116101.25633 37.7908340376155 -122.417941633898 (37.7908340376155, -122.417941633898)
72331 97157 8 138 1079 Le Conte Ave 4 1 1 1   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771)
73660 97156 8 138 1079 Le Conte Ave 3 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.39802290784401 (37.7190195469812, -122.398022907844)
77374 109950 8 147 400x CLEMENTINA ST 10 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
77418 114246 8 21 54 COMMONWEALTH AVE 2 1 1 1       3x3   5996571.0 2114184.0 37.7849487713586 -122.45560763225201 (37.7849487713586, -122.455607632252)
77589 110797 8 58 440 29th St 1 1 1 1   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.743606443306206 -122.42986661573299 (37.7436064433062, -122.429866615733)
77766 100060 8 11 260 05th St 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
77847 103466 8 8 890X Sansome St 2 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
78583 98287 8 246 300 Mangels Ave 3 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
78687 108260 8 62 45 Belcher St 1 1 1 1   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.5446900004 37.768614322037294 -122.430103370918 (37.7686143220373, -122.430103370918)
79039 112619 8 406 3534 24th St 1 1 1 1   08/12/2015 12:00:00 AM   3x3   6005980.0 2102026.6 37.752102890525606 -122.42219142885 (37.7521028905256, -122.42219142885)
79684 107964 8 15 2401x SCOTT ST 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
79719 112585 8 48 3400x WAWONA ST 6 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
80528 108822 8 120 101x FREMONT ST 2 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
80666 85452 8 17 275 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138.0 2107427.0 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748)
Powered by Datasette · Query took 81.907ms · Data source: data.sfgov.org