sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3094 253300 2 79 844 33rd Ave 1 5 1 1       3x3   5985769.0 2110141.0 37.773222058846 -122.492680686455 (37.773222058846, -122.492680686455)
8882 99306 1 79 1345 Turk St 4 1 1 1   05/02/2012 12:00:00 AM   3x3 Permit Number 768843 6003605.0174 2112439.8748 37.780560974986 -122.43114766452 (37.780560974986, -122.43114766452)
85477 49069 1 79 1298 Ocean Ave 1 1 1 1   12/29/2015 12:00:00 AM   3x3 Permit Number 776020 5995836.31315767 2092013.47244835 37.724031921729704 -122.45654557668001 (37.7240319217297, -122.45654557668)
98092 115300 1 79 177 Lomita Ave 2 5 1 1   01/22/2016 12:00:00 AM     Permit Number 775793 5991298.7 2104254.5 37.757381090716 -122.473123533862 (37.757381090716, -122.473123533862)
99519 115299 1 79 177 Lomita Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 775793 5991298.7 2104254.5 37.757381090716 -122.473123533862 (37.757381090716, -122.473123533862)
108387 114594 1 79 2584 Sutter St 1 1 1 1   11/30/2015 12:00:00 AM     Permit Number 775079 6000253.6 2114128.6 37.78500729421621 -122.442863075731 (37.7850072942162, -122.442863075731)
114827 114595 1 79 2584 Sutter St 2 1 1 1   11/30/2015 12:00:00 AM     Permit Number 775079 6000253.6 2114128.6 37.78500729421621 -122.442863075731 (37.7850072942162, -122.442863075731)
70474 103963 1 79 2534 Sutter St 2 1 1 1   12/21/2015 12:00:00 AM 0   Permit Number 773267 6000467.0 2114127.0 37.7850150648369 -122.442124666784 (37.7850150648369, -122.442124666784)
880 246102 3 79 1764 Waller St 4 1 1 2     1 Width 0ft   5997188.4287 2108119.9769 37.768333957535795 -122.453033652641 (37.7683339575358, -122.453033652641)
1242 138398 3 79 2445 PINE ST 16 1 1 2     1 Width 0ft   6002388.1124 2115043.7135 37.787641421844896 -122.435543840756 (37.7876414218449, -122.435543840756)
21334 10471 3 79 1628 Haight St 1 1 1 2   09/06/2011 12:00:00 AM 1 3x3   5998338.8079 2108630.4441 37.769801430915706 -122.44909139548 (37.7698014309157, -122.44909139548)
22844 141842 2 79 1268 BUCHANAN ST 1 1 1 1     1 Width 0ft   6004263.4746 2112800.275 37.7815878353953 -122.42889544965401 (37.7815878353953, -122.428895449654)
23211 10510 3 79 1793 Haight St 1 1 1 2   06/09/1992 12:00:00 AM 1     5997601.0333 2108476.5582 37.7693366759731 -122.451632224006 (37.7693366759731, -122.451632224006)
23333 10480 3 79 1665 Haight St 1 1 1 2   06/09/1992 12:00:00 AM 1 3X3   5998086.3169 2108545.149 37.7695527882164 -122.44995860301701 (37.7695527882164, -122.449958603017)
29655 22495 3 79 6315 03rd St 1 1 1 2   06/07/2011 12:00:00 AM 1 3x3   6013233.044 2090405.2973 37.7205996457096 -122.396294690849 (37.7205996457096, -122.396294690849)
46012 200909 2 79 3801 03rd St 13 1 1 1     1 Width 0ft   6015806.4577 2098231.0621 37.7422304915422 -122.38794492958598 (37.7422304915422, -122.387944929586)
54568 140188 2 79 294 Shrader St 2 1 1 1     1 Width 0ft   5997403.6344 2109575.9167 37.772343924669 -122.452394356341 (37.772343924669, -122.452394356341)
56800 143430 2 79 855 SACRAMENTO ST 4 1 1 1     1 Width 0ft   6010708.6813 2116911.5375 37.7932390808025 -122.406887849913 (37.7932390808025, -122.406887849913)
58587 200519 3 79 1400x La Salle Ave 62 11 1 2     1 Width 0ft   6016469.2023 2095054.3401 37.7335445478075 -122.38543201583401 (37.7335445478075, -122.385432015834)
62042 199712 2 79 1510 Wallace Ave 2 1 1 1     1 Width 0ft   6015224.5084 2092584.2998 37.726693369942396 -122.389562869076 (37.7266933699424, -122.389562869076)
68582 53100 1 79 560@ PINE Presidio Ave 1 1 1 1   06/07/2011 12:00:00 AM 1   Permit Number 767803 5999200.432999999 2114690.2424 37.7864893192828 -122.446547106561 (37.7864893192828, -122.446547106561)
70495 199819 2 79 2225 Ingalls St 1 1 1 1     1 Width 0ft   6015792.5909 2091976.5907 37.7250562032851 -122.387556629575 (37.7250562032851, -122.387556629575)
70894 200763 2 79 5299 03rd St 1 1 1 1     1 Width 0ft   6014413.6169 2093574.8725 37.7293682877316 -122.392435373742 (37.7293682877316, -122.392435373742)
76028 141362 2 79 1116 FELL ST 1 1 1 1     1 Width 0ft   6002077.2497 2110193.7413 37.774306963236796 -122.436272137566 (37.7743069632368, -122.436272137566)
123425 200225 2 79 3098 Ingalls St 5 1 1 1     1 Width 0ft   6014353.5321 2090113.0139 37.7198593794464 -122.392401052747 (37.7198593794464, -122.392401052747)
147212 51915 1 79 1738 Lombard St 2 1 1 1   01/28/2008 12:00:00 AM 1 3x3 Permit Number 50190 6004018.6596 2119764.7731 37.8006967192313 -122.430239410546 (37.8006967192313, -122.430239410546)
151205 200143 2 79 6215 03rd St 1 1 1 1     1 Width 0ft   6013445.5739 2090955.2697 37.7221215837156 -122.395598549244 (37.7221215837156, -122.395598549244)
156891 137780 2 79 1773 Golden Gate Ave 6 1 1 1     1 Width 0ft   6001115.5375 2111737.5615 37.7784912146937 -122.439709572654 (37.7784912146937, -122.439709572654)
160132 96027 1 79 724 Larkin St 1 1 1 1 1 01/21/2016 12:00:00 AM 1 3x3 Permit Number 773631 6007519.56601 2113828.09623 37.7845937435516 -122.41770377222001 (37.7845937435516, -122.41770377222)
160708 140352 2 79 1314 ELLIS ST 6 1 1 1     1 Width 0ft   6004399.7686 2113290.1868 37.7829407248934 -122.428458867439 (37.7829407248934, -122.428458867439)
164839 68142 1 79 2532 Sutter St 1 1 1 1 1 05/20/1993 12:00:00 AM 1   Permit Number 31896 6000452.2737 2114128.7986 37.785019164077 -122.442175744115 (37.785019164077, -122.442175744115)
171007 200910 2 79 3801 03rd St 14 1 1 1     1 Width 0ft   6015813.5433 2098253.2638 37.74229184539389 -122.387921978414 (37.7422918453939, -122.387921978414)
175295 142498 2 79 535 COLUMBUS AVE 1 1 1 1     1 Width 0ft   6009947.0726 2119329.9097 37.79983669458289 -122.409693853229 (37.7998366945829, -122.409693853229)
177451 143428 2 79 855 SACRAMENTO ST 2 1 1 1     1 Width 0ft   6010669.142000001 2116906.4357 37.793222859977604 -122.407024299384 (37.7932228599776, -122.407024299384)
182734 143433 2 79 855 SACRAMENTO ST 7 1 1 1     1 Width 0ft   6010770.5411 2116920.4657 37.7932670566772 -122.406674439368 (37.7932670566772, -122.406674439368)
187133 143427 2 79 855 SACRAMENTO ST 1 1 1 1     1 Width 0ft   6010650.0101 2116903.247 37.793213033950295 -122.407090272453 (37.7932130339503, -122.407090272453)
3047 246310 3 79 1601 Mission St 5 1 1 2   09/06/2012 10:05:00 AM 2 Width 0ft   6007075.5388 2109348.1328 37.7722678469563 -122.41892211112301 (37.7722678469563, -122.418922111123)
9586 115011 2 79 1600 Scott St 1 1 1 1     2 3x3   6001663.1427 2114000.6718 37.784736294492795 -122.437977348952 (37.7847362944928, -122.437977348952)
9849 106206 3 79 1600X Fillmore St 4 1 1 2     2 5x5   6003113.3747 2114020.7176 37.784873699559 -122.432961462333 (37.784873699559, -122.432961462333)
23200 22221 3 79 4301 03rd St 3 1 1 2   11/10/1997 12:00:00 AM 2 3x3   6015398.3252 2096867.7861 37.7384645963363 -122.389260963878 (37.7384645963363, -122.389260963878)
23303 22490 3 79 6300 03rd St 1 1 1 2     2     6013127.1033 2090369.4903 37.7204954312128 -122.396658388199 (37.7204954312128, -122.396658388199)
24026 140096 2 79 515 GOUGH ST 2 1 1 1     2 Width 0ft   6005837.0353 2111584.8045 37.7783393900211 -122.42336524088002 (37.7783393900211, -122.42336524088)
29400 141784 2 79 1380 Eddy St 1 1 1 1     2 Width 0ft   6003871.6154 2112872.0612 37.7817627549494 -122.43025621822599 (37.7817627549494, -122.430256218226)
30173 199711 2 79 1510 Wallace Ave 1 1 1 1     2 Width 0ft   6015245.4888 2092572.1176 37.7266610833371 -122.389489489481 (37.7266610833371, -122.389489489481)
30969 140095 2 79 515 GOUGH ST 1 1 1 1     2 Width 0ft   6005831.7882 2111608.4162 37.77840392585679 -122.423385071553 (37.7784039258568, -122.423385071553)
39705 137779 2 79 1773 Golden Gate Ave 5 1 1 1     2 Width 0ft   6001099.2377 2111735.524 37.7784846924631 -122.439765813586 (37.7784846924631, -122.439765813586)
40049 140097 2 79 515 GOUGH ST 3 1 1 1     2 Width 0ft   6005837.56 2111570.1127 37.7782990795293 -122.42336238105301 (37.7782990795293, -122.423362381053)
41688 143431 2 79 855 SACRAMENTO ST 5 1 1 1     2 Width 0ft   6010731.6396 2116914.7262 37.7932491208157 -122.40680863713301 (37.7932491208157, -122.406808637133)
44265 199765 2 79 2010 Ingalls St 1 1 1 1     2 Width 0ft   6016065.7481 2092407.7615 37.726255239445 -122.386642398454 (37.726255239445, -122.386642398454)
49458 142626 2 79 735 COLUMBUS AVE 1 1 1 1     2 Width 0ft   6009290.0663 2119929.1695 37.8014452745633 -122.412009721134 (37.8014452745633, -122.412009721134)
49502 200163 2 79 1200 Fitzgerald Ave 1 1 1 1     2 Width 0ft   6014648.9326 2090536.3198 37.721038093310796 -122.39140952495899 (37.7210380933108, -122.391409524959)
53947 142158 2 79 1401 GROVE ST 1 1 1 1     2 Width 0ft   6001026.1857 2110695.1979 37.7756240617542 -122.439943915036 (37.7756240617542, -122.439943915036)
62156 51913 1 79 1734 Lombard St 2 1 1 1   01/28/2008 12:00:00 AM 2 3x3 Permit Number 50189 6004067.1338 2119771.0279 37.8007166387692 -122.43007211626801 (37.8007166387692, -122.430072116268)
64856 139755 2 79 1151 Gough St 3 1 1 1     2 Width 0ft   6005560.6004 2113546.3461 37.7837096962291 -122.42446109226499 (37.7837096962291, -122.424461092265)
66323 200509 2 79 5999 03rd St 2 1 1 1     2 Width 0ft   6013721.597 2091689.1509 37.7241520241375 -122.39469576540199 (37.7241520241375, -122.394695765402)
67296 140186 2 79 2098 FELL ST 1 1 1 1     2 Width 0ft   5997442.3009 2109546.1708 37.7722644652587 -122.45225845928302 (37.7722644652587, -122.452258459283)
67395 143429 2 79 855 SACRAMENTO ST 3 1 1 1     2 Width 0ft   6010687.6362 2116910.2621 37.7932344012545 -122.406960577759 (37.7932344012545, -122.406960577759)
68894 137924 2 79 1901 WEBSTER ST 3 1 1 1     2 Width 0ft   6003382.682999999 2115264.2206 37.78830331594779 -122.432118575792 (37.7883033159478, -122.432118575792)
71623 199816 2 79 2222 Ingalls St 1 1 1 1     2 Width 0ft   6015734.8816 2091975.4915 37.72504998848329 -122.387756049526 (37.7250499884833, -122.387756049526)
73293 137778 2 79 1773 Golden Gate Ave 4 1 1 1     2 Width 0ft   6001070.034 2111731.4491 37.7784718415014 -122.43986654775298 (37.7784718415014, -122.439866547753)
75080 139733 2 79 1181 Gough St 8 1 1 1     2 Width 0ft   6005538.6858 2113694.4096 37.784115004469 -122.42454744419399 (37.784115004469, -122.424547444194)
75175 113554 2 79 400X Larkin St 1 1 1 1     2 3x3   6007659.5152 2112834.4553 37.781873320553295 -122.41714916120002 (37.7818733205533, -122.4171491612)
132522 141862 2 79 1150 TURK ST 1 1 1 1     2 Width 0ft   6004492.6811 2112607.5904 37.7810717419138 -122.428088768812 (37.7810717419138, -122.428088768812)
149612 141846 2 79 1273 EDDY ST 1 1 1 1     2 Width 0ft   6004395.0795 2112899.1361 37.781866731536 -122.42844720804399 (37.781866731536, -122.428447208044)
152647 200243 2 79 3099 Ingalls St 4 1 1 1     2 Width 0ft   6014440.6296 2090158.0853 37.719987972824896 -122.39210313506099 (37.7199879728249, -122.392103135061)
153307 50650 1 79 821 Folsom St 4 1 1 1   01/19/2012 12:00:00 AM 2   Permit Number 768661 6012184.2732 2112660.7106 37.7816497657614 -122.401483287822 (37.7816497657614, -122.401483287822)
153665 140099 2 79 515 GOUGH ST 5 1 1 1     2 Width 0ft   6005844.3812 2111525.5128 37.7781770040399 -122.423335612643 (37.7781770040399, -122.423335612643)
154567 89052 1 79 2420 Sutter St 2 1 1 1   05/20/2011 12:00:00 AM 2 3x3 Permit Number 767132 6000895.8744 2114188.3074 37.7852078310557 -122.440645300245 (37.7852078310557, -122.440645300245)
161724 141773 2 79 1310 Webster St 2 1 1 1     2 Width 0ft   6003760.0771 2113253.4803 37.7828037182207 -122.43066931421998 (37.7828037182207, -122.43066931422)
171370 89051 1 79 2420 Sutter St 1 1 1 1   05/20/2011 12:00:00 AM 2 3x3 Permit Number 767132 6000933.3562 2114194.3706 37.7852266134024 -122.440516060128 (37.7852266134024, -122.440516060128)
171611 94414 1 79 5800 03rd St 1 7 1 1   07/29/2010 12:00:00 AM 2 3x3 Permit Number 53653 6013808.0998 2092150.7804 37.7254243749067 -122.394429043825 (37.7254243749067, -122.394429043825)
172364 245185 2 79 1134 Page St 1 1 1 1     2 Width 0ft   6001109.3879 2109363.1674 37.77197137649289 -122.43956058787501 (37.7719713764929, -122.439560587875)
176512 143432 2 79 855 SACRAMENTO ST 6 1 1 1     2 Width 0ft   6010753.9601 2116917.9148 37.793259124815705 -122.406731631165 (37.7932591248157, -122.406731631165)
182384 246258 2 79 258 Noe St 1 1 1 1     2 Width 0ft   6002882.0144 2106736.0778 37.764858759447996 -122.433241197137 (37.764858759448, -122.433241197137)
182627 200520 3 79 1400x La Salle Ave 63 11 1 2     2 Width 0ft   6016476.5475 2095041.1188 37.7335086511389 -122.38540570010599 (37.7335086511389, -122.385405700106)
184769 199885 2 79 1624 Ingalls St 3 1 1 1     2 Width 0ft   6016716.7638 2093277.2481 37.728678698833605 -122.384452383066 (37.7286786988336, -122.384452383066)
187341 138720 2 79 2921 PINE ST 2 1 1 1     2 Width 0ft   5999959.1608 2114707.5789 37.7865802293131 -122.44392335178699 (37.7865802293131, -122.443923351787)
189058 200839 2 79 1499 16th St 3 1 1 1     2 Width 0ft   6012131.3311 2106987.3608 37.7660690877931 -122.40126764344 (37.7660690877931, -122.40126764344)
739 13244 1 79 2353 Lombard St 3 1 1 1   02/18/2012 12:00:00 AM 3 3x3   6001169.3018 2119289.54 37.7992300540772 -122.44006524578501 (37.7992300540772, -122.440065245785)
979 200925 2 79 4100 03rd St 3 1 1 1   04/26/2017 12:00:00 AM 3 Width 0ft   6015478.3928 2097437.2349 37.7400326248174 -122.389023874228 (37.7400326248174, -122.389023874228)
984 24262 3 79 600X Willow St 6 1 1 2   11/19/2004 12:00:00 AM 3 3X3   6004514.0905 2113119.5269 37.7824786038336 -122.428051195433 (37.7824786038336, -122.428051195433)
1088 7067 3 79 1600 Fell St 1 1 1 2   07/26/2016 12:00:00 AM 3 3x3   5999719.0796 2109864.829 37.773269585855104 -122.444405811275 (37.7732695858551, -122.444405811275)
2361 12987 1 79 318 Lombard St 1 1 1 1   08/19/2006 12:00:00 AM 3 3X3   6010766.7048 2120702.1725 37.8036504876245 -122.406954379692 (37.8036504876245, -122.406954379692)
2471 7042 1 79 1300 Fell St 1 1 1 1   12/11/2009 12:00:00 AM 3 3X3   6001153.5455 2110065.6201 37.7739026486508 -122.43945820683099 (37.7739026486508, -122.439458206831)
2670 246001 3 79 1437 Haight St 1 1 1 2   06/29/2007 12:00:00 AM 3 Width 0ft   5999214.6581 2108701.4088 37.7700463362513 -122.446066968815 (37.7700463362513, -122.446066968815)
2847 7089 1 79 1874 Fell St 1 1 1 1   04/25/2009 12:00:00 AM 3 3x3   5998459.5467 2109686.5004 37.7727079965007 -122.448749840415 (37.7727079965007, -122.448749840415)
2872 7051 1 79 1350 Fell St 1 1 1 1   02/25/2008 12:00:00 AM 3 3X3   6000969.3144 2110039.798 37.773821261144 -122.440093639062 (37.773821261144, -122.440093639062)
2968 7092 1 79 1926 Fell St 1 1 1 1   12/10/2009 12:00:00 AM 3 3X3   5998180.0393 2109648.8744 37.7725886979314 -122.449713970747 (37.7725886979314, -122.449713970747)
3080 28823 1 79 1054 Fell St 1 1 1 1   03/08/2006 12:00:00 AM 3 3X3   6002356.6442 2110231.7539 37.77442720694221 -122.435308381556 (37.7744272069422, -122.435308381556)
3260 42633 3 79 1651 Union St 1 1 1 4 2 06/22/2016 02:56:00 PM 3 5x5 Permit Number 45045 6005048.16251 2118816.23898 37.7981505449739 -122.426609321383 (37.7981505449739, -122.426609321383)
3588 24306 1 79 1513 Golden Gate Ave 1 1 1 1   10/21/1994 12:00:00 AM 3     6002219.6394 2111892.3425 37.7789789862822 -122.435901149592 (37.7789789862822, -122.435901149592)
3704 6903 1 79 333 Fell St 4 1 1 1   09/19/2017 12:00:00 AM 3 3X3   6005734.9676 2110651.7554 37.775771702887894 -122.42365197493 (37.7757717028879, -122.42365197493)
4200 28075 1 79 915 Columbus Ave 2 1 1 1   07/17/2010 12:00:00 AM 3 3X3   6008651.5543 2120512.2278 37.8030103621977 -122.41426054224199 (37.8030103621977, -122.414260542242)
4388 251703 2 79 123 Trumbull St 1 1 1 1   10/11/2017 10:45:00 AM 3 3x3   6004216.0 2094352.0 37.7309305395323 -122.42774483827299 (37.7309305395323, -122.427744838273)
4690 253527 3 79 100 Haight St 2 1 1 2   10/19/2017 09:54:00 AM 3 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
4692 6906 3 79 333 Fell St 7 1 1 2   10/19/2017 09:59:00 AM 3 3X3   6005816.7808 2110662.8487 37.7758067801978 -122.423369750882 (37.7758067801978, -122.423369750882)
5258 7076 1 79 1712 Fell St 1 1 1 1   07/11/2008 12:00:00 AM 3 3x3   5999133.3592 2109779.0297 37.7730005664352 -122.44642571608499 (37.7730005664352, -122.446425716085)
5310 6936 3 79 528 Fell St 2 1 1 2   02/22/2008 12:00:00 AM 3 3X3   6004857.7315 2110586.3971 37.775542688283 -122.426681902022 (37.775542688283, -122.426681902022)
5315 18239 1 79 1790X Post St 5 1 1 1   01/12/2000 12:00:00 AM 3 4X4   6003687.2504 2114237.8837 37.7855025167716 -122.43099154386499 (37.7855025167716, -122.430991543865)
5743 12280 1 79 741 Laguna St 1 1 1 1   06/10/1997 12:00:00 AM 3 3X3   6004879.1558 2111501.6218 37.7780568825374 -122.42667297875201 (37.7780568825374, -122.426672978752)
5834 6999 3 79 950X Fell St 3 1 1 2   03/08/2006 12:00:00 AM 3 3X3   6002754.2205 2110289.0229 37.774607023478 -122.433937185692 (37.774607023478, -122.433937185692)
Powered by Datasette · Query took 12.197ms · Data source: data.sfgov.org