sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4029 159224 2 37 384 Ellington Ave 3 1 1 1   10/05/2017 10:27:00 AM 3 Width 0ft   5998600.7872 2087691.66315 37.7123235556611 -122.44667844826701 (37.7123235556611, -122.446678448267)
4032 253155 2 37 546 Ellington Ave   1 1 1   10/05/2017 11:02:00 AM 3 3x3   5997941.0 2087090.0 37.710633814489604 -122.44891554828999 (37.7106338144896, -122.44891554829)
4043 216875 2 37 668 Plymouth Ave 1 1 1 1   10/05/2017 02:30:00 PM 3 Width 3ft   5995926.39205 2089208.92779 37.7163364763159 -122.456031527941 (37.7163364763159, -122.456031527941)
4044 159331 2 37 562 Ellington Ave 1 1 1 1   10/05/2017 11:06:00 AM 3 Width 0ft   5997894.14042 2087019.0117 37.7104362168201 -122.449072394069 (37.7104362168201, -122.449072394069)
4075 1149 3 37 2678 Alemany Blvd 1 1 1 2   10/05/2017 08:44:00 AM 3 3X3   5998020.45993 2088357.3562599998 37.7141182292418 -122.448732141877 (37.7141182292418, -122.448732141877)
4136 216727 2 37 78 Miramar Ave 1 1 1 1   10/06/2017 07:54:00 AM 3 Width 3ft   5995351.20141 2090413.7990299999 37.7196117361844 -122.458106803489 (37.7196117361844, -122.458106803489)
4140 216837 2 37 263 Farallones St 1 1 1 1   10/06/2017 02:34:00 PM 3 Width 3ft   5994365.2203 2088384.89347 37.713984142135104 -122.461367955672 (37.7139841421351, -122.461367955672)
4188 181057 2 37 5931 Mission St 1 1 1 1   10/10/2017 03:33:00 PM 3 Width 3ft   5996618.07355 2086323.26043 37.7084527782463 -122.453432527712 (37.7084527782463, -122.453432527712)
4211 136890 2 37 1001x Bay St 6 1 1 1   10/10/2017 01:59:00 PM 3 Width 3ft   6005802.0 2120854.0 37.8037883050638 -122.424145815925 (37.8037883050638, -122.424145815925)
4217 216856 2 37 269 Sadowa St 1 1 1 1   10/10/2017 08:36:00 AM 3 Width 3ft   5994294.27802 2087746.4954799998 37.712227169014604 -122.461566901007 (37.7122271690146, -122.461566901007)
4259 252872 2 37 5700 Mission St 1 1 1 1   10/10/2017 03:41:00 PM 3 3x3   5997704.0 2086907.0 37.7101177815644 -122.449721490093 (37.7101177815644, -122.449721490093)
4274 252887 2 37 715 Mount Vernon Ave 1 1 1 1   10/10/2017 03:23:00 PM 3 3x3   5997288.0 2090319.0 37.719462535966294 -122.45140518978998 (37.7194625359663, -122.45140518979)
4324 251737 2 37 228 Chicago Way 1 1 1 1   10/11/2017 08:13:00 AM 3 3x3   6002872.0 2086877.0 37.7103297297312 -122.43185773233601 (37.7103297297312, -122.431857732336)
4357 180599 2 37 130 Trumbull St 1 1 1 1   10/11/2017 10:49:00 AM 3 Width 2ft   6004241.29986 2094286.4256099998 37.73075191805779 -122.427652702223 (37.7307519180578, -122.427652702223)
4365 252899 2 37 390 San Miguel St 1 1 1 1   10/11/2017 12:05:00 PM 3 3x3   5997900.0 2090079.0 37.7188385770119 -122.449272458694 (37.7188385770119, -122.449272458694)
4366 251751 2 37 125 South Hill Blvd 1 1 1 1   10/11/2017 08:38:00 AM 3 3x3   6003144.0 2086928.0 37.710485180250004 -122.430921281744 (37.71048518025, -122.430921281744)
4382 180600 2 37 142 Trumbull St 1 1 1 1   10/11/2017 10:52:00 AM 3 Width 2ft   6004316.23114 2094289.2988 37.7307640454079 -122.427393857542 (37.7307640454079, -122.427393857542)
4394 251740 2 37 240 Naylor St 1 1 1 1   10/11/2017 08:43:00 AM 3 3x3   6002635.0 2086674.0 37.709758897844296 -122.432662361521 (37.7097588978443, -122.432662361521)
4396 251750 2 37 125 South Hill Blvd 2 1 1 1   10/11/2017 08:46:00 AM 3 3x3   6003144.0 2086928.0 37.710485180250004 -122.430921281744 (37.71048518025, -122.430921281744)
4414 1175 3 37 2900 Alemany Blvd 10 1 1 2   10/11/2017 10:42:00 AM 3 3X3   5996816.67595 2087452.1631200002 37.711563867747 -122.452827563661 (37.711563867747, -122.452827563661)
4433 180628 2 37 339 Cordova St 1 1 1 1   10/11/2017 11:40:00 AM 3 Width 8ft   6001976.18123 2086917.49182 37.710390087913794 -122.43495675757299 (37.7103900879138, -122.434956757573)
4466 180840 2 37 25 Farragut Ave 1 1 1 1   10/13/2017 12:05:00 PM 3 Width 2ft   5997679.45955 2086959.0123599998 37.7102591915804 -122.449810052203 (37.7102591915804, -122.449810052203)
4469 162767 2 37 910 Capitol Ave 1 1 1 1   10/13/2017 10:46:00 AM 3 Width 0ft   5995047.74881 2089994.6551299999 37.7184434259931 -122.459125388251 (37.7184434259931, -122.459125388251)
4473 180841 2 37 25 Farragut Ave 3 1 1 1   10/13/2017 12:10:00 PM 3 Width 2ft   5997726.08242 2086911.31353 37.710130888906896 -122.449645479868 (37.7101308889069, -122.449645479868)
4489 253086 3 37 2849X Alemany Blvd 19 1 1 2   10/13/2017 10:29:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4496 30326 1 37 946 Capitol Ave 1 1 1 1   10/13/2017 11:13:00 AM 3   Permit Number 17 5995052.87017 2090222.4724 37.7190692525106 -122.459124173264 (37.7190692525106, -122.459124173264)
4500 253085 3 37 2849X Alemany Blvd 18 1 1 2   10/13/2017 10:40:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4503 162771 2 37 954 Capitol Ave 1 1 1 1   10/13/2017 10:37:00 AM 3 Width 0ft   5995054.32818 2090275.3089700001 37.7192144129887 -122.45912295737301 (37.7192144129887, -122.459122957373)
4509 162768 2 37 914 Capitol Ave 1 1 1 1   10/13/2017 10:51:00 AM 3 Width 0ft   5995049.36731 2090021.5803099999 37.7185174491889 -122.4591217424 (37.7185174491889, -122.4591217424)
4514 162766 2 37 906 Capitol Ave 1 1 1 1   10/13/2017 10:33:00 AM 3 Width 0ft   5995047.57993 2089969.8003900002 37.7183751710697 -122.459124173239 (37.7183751710697, -122.459124173239)
4555 253633 1 37 1907 Judah St 1 1 1 1 1 01/21/2016 12:00:00 AM   3x3 Permit Number 777409          
4556 136909 3 37 2210 Stockton St 1 1 1 2     2 Width 3ft   6009830.0684 2121639.18274 37.806170828478606 -122.410261867902 (37.8061708284786, -122.410261867902)
4577 143490 3 37 600 Green St 1 1 1 2   03/24/2016 08:48:00 AM 0 Width 0ft   6010035.0683 2119214.1514 37.7995237814105 -122.40938118017401 (37.7995237814105, -122.409381180174)
4578 136910 3 37 2210 Stockton St 6 1 1 2     2 Width 3ft   6009806.2153 2121790.84358 37.8065859141719 -122.410355131177 (37.8065859141719, -122.410355131177)
4638 180016 1 37 2901 Alemany Blvd 1 1 1 1   12/02/1998 12:00:00 AM 7 Width 3ft   5997041.774780001 2087538.2490700001 37.711813136431 -122.452055773566 (37.711813136431, -122.452055773566)
4691 15528 3 37 2792 Mission St 1 1 1 2   10/19/2017 09:40:00 AM 3 3X3   6007034.2153 2102142.536 37.752480630640605 -122.41855400595101 (37.7524806306406, -122.418554005951)
4699 253658 1 37 1545 Pine St 3 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4700 253660 1 37 1545 Pine St 5 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4702 253657 1 37 1545 Pine St 2 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4703 253659 1 37 1545 Pine St 4 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4709 253656 1 37 1545 Pine St 1 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4721 253670 2 37 1063 Prague St 1 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
4736 253671 2 37 1063 Prague St 2 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
4785 18290 3 37 2000 Post St 8 1 1 2   03/10/1992 12:00:00 AM 6 4X4   6002339.9537 2114048.2121 37.784905293391795 -122.43563921223101 (37.7849052933918, -122.435639212231)
4837 86169 3 37 1393 24th Ave 1 1 1 2   10/26/2017 07:03:00 PM 3 3x3   5988639.6168 2105878.5637 37.761686013326894 -122.482438582138 (37.7616860133269, -122.482438582138)
4844 253688 1 37 999 Natoma St 3 1 1 1 1         6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267)
4848 31890 1 37 999 Natoma St 1 1 1 1 1 10/14/2006 12:00:00 AM     Permit Number 35322 6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267)
4861 106723 2 37 2891 Bush St 1 1 1 1     1 4x3   5999685.7618 2114314.7923 37.785486140561105 -122.444840997242 (37.7854861405611, -122.444840997242)
5142 241731 2 37 109 Guerrero St 1 1 1 1     1 Width 2ft   6005457.0 2108414.0 37.7696116724665 -122.424454330606 (37.7696116724665, -122.424454330606)
5213 180235 2 37 3353 19th Ave 9 1 1 1     4 Width 3ft   5990554.425319999 2094179.3629700001 37.7296742505655 -122.47496207986099 (37.7296742505655, -122.474962079861)
5214 253835 2 37 3353 19th Ave 10 1 1 1       Width 3ft   5990554.425319999 2094179.3629700001 37.7296742505655 -122.47496207986099 (37.7296742505655, -122.474962079861)
5292 14530 3 37 700 Masonic Ave 1 1 1 2     60 3X3   5999227.9935 2110423.9359 37.774776718941105 -122.44614476286999 (37.7747767189411, -122.44614476287)
5307 8160 1 37 1100 Fulton St 1 1 1 1   06/09/2007 12:00:00 AM 3 3X3   6002453.143999999 2111285.6659999997 37.777326466446 -122.435049962975 (37.777326466446, -122.435049962975)
5473 52359 1 37 645 Hyde St 1 1 1 1 1 12/14/2005 12:00:00 AM 3 3x3 Permit Number 48496 6007837.48852 2114654.59381 37.786880990198 -122.41666243464199 (37.786880990198, -122.416662434642)
5493 22601 3 37 837 Turk St 2 1 1 2     12 4X4   6005919.22221 2112752.51326 37.781550271357204 -122.42316394935601 (37.7815502713572, -122.423163949356)
5549 117113 4 37 1650 Broadway 2 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821)
5644 81955 1 37 611 Hyde St 1 1 1 1 1 01/08/2013 12:00:00 AM 3 3x3 Permit Number 769820 6007855.44707 2114525.76185 37.7865282590267 -122.416591172348 (37.7865282590267, -122.416591172348)
5663 24487 1 37 618 Fell St 2 1 1 1   06/24/1995 12:00:00 AM 3 3X3   6004392.5811 2110517.0483 37.7753259646513 -122.428286026192 (37.7753259646513, -122.428286026192)
5738 117115 4 37 1650 Broadway 4 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005638.31982 2117909.64088 37.7956946025865 -122.42450268015 (37.7956946025865, -122.42450268015)
5745 18285 3 37 2000 Post St 3 1 1 2     6 4X4   6002494.2739 2114068.183 37.784968892425496 -122.435106743694 (37.7849688924255, -122.435106743694)
5767 14527 1 37 644 Masonic Ave 1 1 1 1     60 3X3   5999201.3001 2110597.4992 37.7752517549466 -122.44624958831801 (37.7752517549466, -122.446249588318)
5805 22726 1 37 1525 Turk St 3 1 1 1   03/21/1997 12:00:00 AM 12 3X3   6002762.8064 2112322.4766 37.780190867266796 -122.43405287482 (37.7801908672668, -122.43405287482)
5829 7833 1 37 880 Franklin St 1 1 1 1     6 4x4   6006176.68475 2113023.80022 37.7823096849858 -122.42229253146999 (37.7823096849858, -122.42229253147)
5891 117112 4 37 1650 Broadway 1 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005683.22125 2117915.42136 37.7957130098979 -122.424347724294 (37.7957130098979, -122.424347724294)
5967 6877 3 37 240 Fell St 1 1 1 2   08/02/2002 12:00:00 AM 12 3X3   6006250.63337 2110777.45516 37.7761459385303 -122.42187708516899 (37.7761459385303, -122.421877085169)
6033 6956 3 37 618 Fell St 1 1 1 2   06/24/1995 12:00:00 AM 3 3X3   6004409.9923 2110521.0663 37.7753379822624 -122.428226083232 (37.7753379822624, -122.428226083232)
6102 18286 3 37 2000 Post St 4 1 1 2   01/10/1994 12:00:00 AM 6 4X4   6002462.1995 2114065.7623 37.7849604244555 -122.435217537512 (37.7849604244555, -122.435217537512)
6123 22781 3 37 1860 Turk St 1 1 1 2   03/21/1997 12:00:00 AM 6 3X3   6001097.5794 2112139.8111 37.7795946678368 -122.439800543691 (37.7795946678368, -122.439800543691)
6149 14526 3 37 637 Masonic Ave 1 1 1 2     100 3X3   5999136.9105 2110609.5392 37.775281136182606 -122.446473192139 (37.7752811361826, -122.446473192139)
6166 93399 3 37 2101 Turk Blvd 1 1 1 2   12/09/2008 12:00:00 AM 3 3x3   5999866.7618 2111912.817 37.7789012639267 -122.44404214236 (37.7789012639267, -122.44404214236)
6259 110082 1 37 3028 Laguna St 1 1 1 1   03/30/2015 12:00:00 AM 3 3x3 Permit Number 773127 6003845.53754 2119275.91303 37.799344628804796 -122.43080357774299 (37.7993446288048, -122.430803577743)
6404 7830 1 37 828 Franklin St 3 1 1 1     6 4x4   6006192.27553 2112919.76373 37.7820249056667 -122.422231200417 (37.7820249056667, -122.422231200417)
6480 6980 1 37 802 Fell St 1 1 1 1   06/24/1995 12:00:00 AM 12 3X3   6003550.3934 2110396.3103 37.7749467581504 -122.431190726971 (37.7749467581504, -122.431190726971)
6490 8647 3 37 2761 Geary Blvd 2 1 1 2     3 3X3   5998533.8029 2113119.8829 37.7821394236041 -122.448740321446 (37.7821394236041, -122.448740321446)
6518 97735 3 37 1150 Francisco St 13 1 1 4 2 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.978999999 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974)
6526 7834 1 37 880 Franklin St 2 1 1 1     6 4x4   6006174.13895 2113043.71306 37.7823642171667 -122.422302754063 (37.7823642171667, -122.422302754063)
6540 7831 1 37 828 Franklin St 4 1 1 1     6 4x4   6006187.42417 2112935.31044 37.7820673194837 -122.42224908883001 (37.7820673194837, -122.42224908883)
6543 137954 2 37 1615 SUTTER ST 9 1 1 1       Width 0ft   6004801.2336 2114685.8103 37.7867954695312 -122.427169405594 (37.7867954695312, -122.427169405594)
6545 18287 3 37 2000 Post St 5 1 1 2   05/11/1990 12:00:00 AM 6 4X4   6002436.1769 2114064.5519 37.7849556232365 -122.435307480647 (37.7849556232365, -122.435307480647)
6601 8611 3 37 2486 Geary Blvd 1 1 1 2   07/28/1999 12:00:00 AM 3 3X3   5999862.6992 2113354.3551 37.7828591248206 -122.444159809177 (37.7828591248206, -122.444159809177)
6659 10663 1 37 963 Hayes St 1 1 1 1   11/25/1992 12:00:00 AM 3 3x3   6003244.5235 2110652.1051 37.77563176944871 -122.432267067771 (37.7756317694487, -122.432267067771)
6672 22644 1 37 1244 Turk St 1 1 1 1   02/02/2000 12:00:00 AM 3 3X3   6004038.676 2112547.7701 37.7808817933373 -122.429655131034 (37.7808817933373, -122.429655131034)
6675 6064 1 37 1913 Eddy St 2 1 1 1     6 4X4   6001176.3696 2112440.1627 37.78042384150729 -122.43954951236799 (37.7804238415073, -122.439549512368)
6708 26658 1 37 522 Fell St 1 1 1 1   01/22/1999 12:00:00 AM 3 2X2   6004907.91771 2110588.9523400003 37.7755525415589 -122.42650847769501 (37.7755525415589, -122.426508477695)
6811 93401 3 37 2101 Turk Blvd 3 1 1 2   12/09/2008 12:00:00 AM 3 3x3   5999912.1103 2111918.5701 37.7789196472896 -122.443885677827 (37.7789196472896, -122.443885677827)
6836 102772 1 37 1440 Filbert St 2 1 1 1     8 3x3 Permit Number 31199 6006025.32539 2119349.8465400003 37.79967089025929 -122.42326599722799 (37.7996708902593, -122.423265997228)
6895 6225 3 37 1220 Ellis St 3 1 1 2     18 3X4   6005060.4446 2113384.1056 37.783235967029206 -122.426179889067 (37.7832359670292, -122.426179889067)
6899 52360 1 37 645 Hyde St 2 1 1 1 1 12/14/2005 12:00:00 AM 3 3x3 Permit Number 48496 6007841.58942 2114643.58565 37.78685099511571 -122.416647466318 (37.7868509951157, -122.416647466318)
7019 22735 1 37 1560 Turk St 7 1 1 1   01/19/2001 12:00:00 AM 3 3X3   6002477.0092 2112332.46 37.7802020553421 -122.43504229111299 (37.7802020553421, -122.435042291113)
7060 18284 3 37 2000 Post St 2 1 1 2   03/10/1992 12:00:00 AM 6 4X4   6002520.9017 2114071.8140000002 37.784980374208104 -122.43501487991301 (37.7849803742081, -122.435014879913)
7130 22744 1 37 1575 Turk St 6 1 1 1   01/19/2001 12:00:00 AM 6 3x3   6002647.0661 2112304.2018 37.780134120032294 -122.43445196604401 (37.7801341200323, -122.434451966044)
7190 59699 1 37 3188 Washington St 1 1 1 1 1 01/05/2015 12:00:00 AM 3   Permit Number 773904 5999466.917230001 2116043.86882 37.7902212404654 -122.44572252287901 (37.7902212404654, -122.445722522879)
7210 7829 1 37 828 Franklin St 2 1 1 1     6 4x4   6006196.28269 2112899.08523 37.7819683535895 -122.422215867866 (37.7819683535895, -122.422215867866)
7237 6949 3 37 600 Fell St 1 1 1 2   06/24/1995 12:00:00 AM 3 3X3   6004493.7 2110528.4326 37.7753629442722 -122.42793704383699 (37.7753629442722, -122.427937043837)
7239 28357 1 37 3060 Sacramento St 1 1 1 1   06/02/2003 12:00:00 AM 3 3X3   6000153.01588 2115483.23318 37.7887210301107 -122.44330839538601 (37.7887210301107, -122.443308395386)
7243 116776 4 37 1106 Pacific Ave 3 1 1 1   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.41364847189399 (37.7960980717264, -122.413648471894)
7270 98268 1 37 401X Esmeralda Ave 1 1 1 1 1     3x3            
7304 117114 4 37 1650 Broadway 3 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005648.88243 2117910.88116 37.7956986045686 -122.42446621984399 (37.7956986045686, -122.424466219844)
7307 7835 1 37 880 Franklin St 3 1 1 1   09/16/1994 12:00:00 AM 6 4x4   6006172.94925 2113057.71328 37.782402591234295 -122.42230786493099 (37.7824025912343, -122.422307864931)
7363 26659 1 37 522 Fell St 2 1 1 1   01/22/1999 12:00:00 AM 3 3X3   6004893.91605 2110587.9747 37.7755490656586 -122.42655684321998 (37.7755490656586, -122.42655684322)
7390 24488 1 37 730 Fell St 1 1 1 1   06/24/1995 12:00:00 AM 6 3X3   6003912.5381 2110447.8419 37.7751087667975 -122.42994166795 (37.7751087667975, -122.42994166795)
Powered by Datasette · Query took 22.006ms · Data source: data.sfgov.org