sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
89521 6272 1 53 1420X Ellis St 2 1 1 1     18 4X4   6003992.005369999 2113234.0209999997 37.782763424573005 -122.429865551596 (37.782763424573, -122.429865551596)
89632 215576 2 53 95 Kirkham St 4 2 1 1     39 Width 3ft   5994736.06961 2105294.2713 37.7604344559039 -122.461311206651 (37.7604344559039, -122.461311206651)
89901 11849 3 53 1401X Junipero Serra Blvd 2 1 1 2     18 3   5991539.129622 2088082.4465586997 37.712990637147605 -122.471113878415 (37.7129906371476, -122.471113878415)
89919 1440 3 53 126 Arguello Blvd 1 1 1 2     100 5X5   5995572.08179 2115303.34583 37.7879648202564 -122.459144627311 (37.7879648202564, -122.459144627311)
89969 1617 3 53 764 Arguello Blvd 1 1 1 2     135 3X3   5995701.56639 2110898.08045 37.775876579407296 -122.458377647589 (37.7758765794073, -122.458377647589)
90284 401 3 53 3790X 19th Ave 12 1 1 2     12 2   5990481.9086 2090947.8037400001 37.7207969949539 -122.474976977183 (37.7207969949539, -122.474976977183)
90643 11668 3 53 700X Junipero Serra Blvd 7 1 1 2     18 4x4   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
90813 26778 3 53 800X Junipero Serra Blvd 31 1 1 2     18 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
90931 11627 3 53 300X Junipero Serra Blvd 6 1 1 2     18 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195)
91570 1435 1 53 101X Arguello Blvd 1 1 1 1     35 5   5995475.980819999 2115376.20265 37.7881593402184 -122.459482395726 (37.7881593402184, -122.459482395726)
91709 1533 3 53 470X Arguello Blvd 2 1 1 2     125 3X3   5995618.147655 2113146.451022 37.7820452142616 -122.458829030077 (37.7820452142616, -122.458829030077)
91904 11692 1 53 799X Junipero Serra Blvd 9 1 1 13     24 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
92480 10715 3 53 50X Hollis St 2 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
92672 85425 1 53 799X Junipero Serra Blvd 29 1 1 13     36 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
92989 26772 3 53 800X Junipero Serra Blvd 6 1 1 2     12 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
93005 7472 1 53 2637 Folsom St 2 1 1 1     60 4X4   6008329.443080001 2103061.47825 37.75507667179011 -122.41413988378599 (37.7550766717901, -122.414139883786)
93568 1421 1 53 50 Arguello Blvd 3 1 1 1     90 3x12   5995527.212040001 2115624.1968 37.7888432106719 -122.459323111848 (37.7888432106719, -122.459323111848)
93750 6280 3 53 1475 Ellis St 3 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
94026 29916 3 53 810 Junipero Serra Blvd 5 1 1 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
94173 117256 3 53 1570 31ST AVE 4 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94286 19045 3 53 111 Sagamore St 1 1 1 2     35 3X3   5995778.761022701 2087391.1107423 37.7113367008986 -122.45641043862801 (37.7113367008986, -122.456410438628)
94466 7473 3 53 2650X Folsom St 1 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
94747 114034 6 53 198x FONT BLVD 1 1 1 1     40 3x3   5990818.0 2089012.0 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302)
94750 11616 3 53 80X Junipero Serra Blvd 11 1 1 2     18 2x2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
94783 39243 1 53 3934 Clay St 1 1 1 1   12/11/1998 12:00:00 AM     Permit Number 40874 5995936.27284071 2115227.33652665 37.7877770492494 -122.457879097389 (37.7877770492494, -122.457879097389)
94881 19090 3 53 260 Sagamore St 1 1 1 2     25 3X4   5994507.8215972 2087458.0224558997 37.7114473793836 -122.460807943318 (37.7114473793836, -122.460807943318)
95505 1429 3 53 75X Arguello Blvd 2 1 1 2     100 5   5995465.54596 2115556.4736099998 37.788653715516205 -122.45953155962 (37.7886537155162, -122.45953155962)
95650 7425 1 53 2501 Folsom St 1 1 1 1     60 3X3   6008288.6679 2103807.30911 37.7571222633799 -122.414333665067 (37.7571222633799, -122.414333665067)
95655 29917 3 53 810 Junipero Serra Blvd 6 1 1 2     18 3x3   5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
95703 6273 1 53 1420X Ellis St 3 1 1 1     18 4X4   6003962.5783400005 2113230.61655 37.78275241032 -122.42996711374701 (37.78275241032, -122.429967113747)
96651 10718 3 53 50X Hollis St 5 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
96797 1620 3 53 777 Arguello Blvd 1 1 1 2     125 3X3   5995637.36215 2110958.16718 37.776037871937206 -122.45860409582599 (37.7760378719372, -122.458604095826)
98239 1470 3 53 215 Arguello Blvd 1 1 1 2     24 3X3   5995496.39039 2114788.7917299997 37.786547641872296 -122.45936922598 (37.7865476418723, -122.45936922598)
98822 51906 1 53 157 Day St 1 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48113 6004926.17092668 2098691.36646376 37.7428856098168 -122.42559837996599 (37.7428856098168, -122.425598379966)
99073 108311 2 53 439x ARLINGTON ST 1 13 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
99379 1642 3 53 860 Arguello Blvd 1 1 1 2     100 3X3   5995719.79795 2110383.37965 37.7744643941763 -122.45827731837299 (37.7744643941763, -122.458277318373)
99544 6284 3 53 1475 Ellis St 7 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
99894 1541 3 53 470X Arguello Blvd 10 1 1 2     90 3X3   5995618.147655 2113146.451022 37.7820452142616 -122.458829030077 (37.7820452142616, -122.458829030077)
100033 10714 3 53 50X Hollis St 1 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
100073 11656 1 53 699X Junipero Serra Blvd 16 1 1 13     18 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
100174 1637 3 53 830 Arguello Blvd 1 1 1 2     40 3X3   5995713.25263 2110507.70954 37.7748053952412 -122.45830896062701 (37.7748053952412, -122.458308960627)
101162 87591 3 53 3840 19th Ave 2 1 1 2     60     5990782.62319 2090250.3116099997 37.7188992769151 -122.473886649335 (37.7188992769151, -122.473886649335)
101312 6282 3 53 1475 Ellis St 5 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
102679 19106 3 53 3155X Alemany Blvd 2 1 1 2     24 3x3   5995592.56281 2086919.9321700002 37.7100322629968 -122.457019923286 (37.7100322629968, -122.457019923286)
103593 10720 3 53 50X Hollis St 7 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
103661 1035 3 53 1989X Alemany Blvd 1 1 1 2     45 3X6   6000752.12664 2090469.86783 37.7200745396752 -122.439441815719 (37.7200745396752, -122.439441815719)
104190 1423 3 53 50 Arguello Blvd 1 1 1 2     30 3x5   5995562.14611 2115577.70158 37.7887175558035 -122.459198877421 (37.7887175558035, -122.459198877421)
104261 137068 2 53 7 Laurel St 2 1 1 1     16 Width 3ft   5997936.78651 2116362.08959 37.7910075087313 -122.45103959183001 (37.7910075087313, -122.45103959183)
104287 215601 2 53 700 Junipero Serra Blvd 155 4 1 1     15 Width 0ft   5991211.33426 2091424.54649 37.7221482587196 -122.472490339055 (37.7221482587196, -122.472490339055)
104574 11619 3 53 80X Junipero Serra Blvd 18 1 1 2     18 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
104642 1257 3 53 3801 Alemany Blvd 1 1 1 2     18 1X3   5992919.7951 2087516.7094700001 37.7115170200575 -122.46630079139099 (37.7115170200575, -122.466300791391)
106471 7479 3 53 2650X Folsom St 7 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
106502 6275 3 53 1421X Ellis St 1 1 1 2     12 4X4   6003957.217759999 2113179.66455 37.782612205263796 -122.429982023346 (37.7826122052638, -122.429982023346)
106977 11873 1 53 1499X Junipero Serra Blvd 3 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
107025 1514 3 53 390 Arguello Blvd 1 1 1 2     55 4X6   5995592.131 2113860.45299 37.7840041772291 -122.458970748307 (37.7840041772291, -122.458970748307)
107061 6276 3 53 1421X Ellis St 2 1 1 2     12 4X4   6003957.217759999 2113179.66455 37.782612205263796 -122.429982023346 (37.7826122052638, -122.429982023346)
107172 4850 3 53 1499X ALEMANY BLVD 2 1 1 2     18 6x6   6002180.0 2093376.0 37.728135283202704 -122.43471385212 (37.7281352832027, -122.43471385212)
107731 1531 3 53 445 Arguello Blvd 5 1 1 2     70 3X3   5995560.27463 2113085.81754 37.7818754042369 -122.459024851411 (37.7818754042369, -122.459024851411)
108076 11722 1 53 899X Junipero Serra Blvd 13 1 1 13     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
108172 1468 3 53 200 Arguello Blvd 2 1 1 2     18 3X3   5995558.6934 2114767.33782 37.786492317136606 -122.459152120252 (37.7864923171366, -122.459152120252)
109658 11633 1 53 499X Junipero Serra Blvd 1 1 1 13     30 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
109973 99911 2 53 400 Fair Oaks St 1 1 1 1       3x3   6005460.7 2101331.3 37.750164452601794 -122.42393781012501 (37.7501644526018, -122.423937810125)
110227 11741 3 53 900X Junipero Serra Blvd 19 1 1 2     18 3X3   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
110485 1001 3 53 1731 Alemany Blvd 1 1 1 2     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202)
111027 6274 3 53 1420X Ellis St 4 1 1 2     18 4X4   6003886.01337 2113219.41254 37.782717310542395 -122.430231196525 (37.7827173105424, -122.430231196525)
111256 104704 1 53 3590X Clay St 1 1 1 1   03/06/2014 12:00:00 AM   3x3 Permit Number 771748 5997841.875 2115466.23587 37.7885422986565 -122.451303342479 (37.7885422986565, -122.451303342479)
111277 11695 1 53 799X Junipero Serra Blvd 12 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
112174 400 3 53 3790X 19th Ave 11 1 1 2     22 2   5990476.72602 2090904.23897 37.7206770765591 -122.474991713144 (37.7206770765591, -122.474991713144)
112238 7474 3 53 2650X Folsom St 2 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
112240 1060 3 53 2059X Alemany Blvd 1 1 1 2     45 3X3   6000457.1646300005 2090146.24433 37.7191691518296 -122.440438198589 (37.7191691518296, -122.440438198589)
112345 26171 1 53 799X Junipero Serra Blvd 16 1 1 13   03/01/2000 12:00:00 AM 30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
113163 11689 1 53 799X Junipero Serra Blvd 2 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
113267 393 3 53 3790X 19th Ave 4 1 1 2     23 2   5990507.18031 2090652.7596599997 37.7199883416446 -122.47486809669701 (37.7199883416446, -122.474868096697)
113757 6416 3 53 400X Arguello Blvd 1 1 1 2     40 6x5   5995602.32868 2113744.52068 37.7836864443545 -122.458927071616 (37.7836864443545, -122.458927071616)
113834 1543 3 53 470X Arguello Blvd 12 1 1 2     70 3X3   5995618.1476548 2113146.4510222 37.782045214262205 -122.458829030078 (37.7820452142622, -122.458829030078)
113835 5927 3 53 1335 Eddy St 3 1 1 2   07/26/2016 12:00:00 AM 12 4X4   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
113884 11686 1 53 799X Junipero Serra Blvd 8 1 1 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
114019 1027 3 53 1965X Alemany Blvd 1 1 1 2   06/15/1992 12:00:00 AM 31 3X3   6000825.64245 2090608.45865 37.7204592623287 -122.439197625247 (37.7204592623287, -122.439197625247)
114194 1058 3 53 2055X Alemany Blvd 1 1 1 2     35 3X3   6000480.4143 2090166.82631 37.719226989106005 -122.440359308841 (37.719226989106, -122.440359308841)
114366 1525 3 53 439 Arguello Blvd 1 1 1 2     24 5X7   5995548.96018 2113291.48375 37.7824394582911 -122.459078890487 (37.7824394582911, -122.459078890487)
114677 7481 3 53 2650X Folsom St 9 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
114688 1471 1 53 223 Arguello Blvd 1 1 1 1     100 3X3   5995498.41446 2114753.58122 37.7864510796736 -122.459359672388 (37.7864510796736, -122.459359672388)
114875 415 3 53 3862 19th Ave 1 1 1 2     70 2X6   5990878.963880001 2090116.60552 37.718537732694394 -122.473543893183 (37.7185377326944, -122.473543893183)
115146 26486 3 53 1475 Ellis St 8 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
115302 10716 3 53 50X Hollis St 3 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
115742 394 3 53 3790X 19th Ave 5 1 1 2     30 2   5990492.73788 2090676.25296 37.720052011465896 -122.474919732673 (37.7200520114659, -122.474919732673)
116279 1181 3 53 3003 Alemany Blvd 1 1 1 2     45 3x3   5996737.10872 2087300.2249 37.7111421206036 -122.45309160658 (37.7111421206036, -122.45309160658)
117028 137076 2 53 689 Hayes St 4 4 1 1     19 Width 4ft   6004731.627309999 2110853.90859 37.776270079140396 -122.427137185641 (37.7762700791404, -122.427137185641)
117409 227 3 53 2968 19th Ave 1 1 1 2     22 2X3   5990630.67566 2095430.1647700001 37.7331130547028 -122.474789735965 (37.7331130547028, -122.474789735965)
117946 1434 3 53 100X Arguello Blvd 2 1 1 2     125 3X5   5995535.03638 2115411.50396 37.7882596635004 -122.459280632339 (37.7882596635004, -122.459280632339)
118300 1581 3 53 629 Arguello Blvd 1 1 1 2     125 3X3   5995601.12395 2111917.66113 37.7786703056802 -122.458798934123 (37.7786703056802, -122.458798934123)
118796 11718 1 53 899X Junipero Serra Blvd 7 1 1 13     36 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
119155 99894 6 53 1636 Bush St 1 7 1 1   07/11/2012 12:00:00 AM     Permit Number 768849 6005665.0 2115204.0 37.7882670981083 -122.424217840789 (37.7882670981083, -122.424217840789)
119227 1030 1 53 1989X Alemany Blvd 3 1 1 1     34 3X6   6000847.46445 2090663.0926299999 37.7206105166164 -122.43912610743799 (37.7206105166164, -122.439126107438)
119337 1597 3 53 714 Arguello Blvd 1 1 1 2     35 3X3   5995688.036 2111228.67679 37.7767835321697 -122.458448388127 (37.7767835321697, -122.458448388127)
120071 1029 3 53 1989X Alemany Blvd 4 1 1 2     36 3X6   6000859.82003 2090688.3349 37.7206805292285 -122.43908520635401 (37.7206805292285, -122.439085206354)
120429 1430 3 53 75X Arguello Blvd 3 1 1 2     40 5   5995476.6114 2115563.93405 37.7886748361207 -122.45949381562299 (37.7886748361207, -122.459493815623)
120490 11712 3 53 800X Junipero Serra Blvd 2 1 1 2     24 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
120708 1551 3 53 530 Arguello Blvd 2 1 1 2     125 3X3   5995634.85993 2112642.48366 37.7806624148094 -122.458734717129 (37.7806624148094, -122.458734717129)
121533 93024 1 53 394 Fair Oaks St 3 1 1 1         Tree 3 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
Powered by Datasette · Query took 2.681ms · Data source: data.sfgov.org