sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21692 26 3 16 736 14th St 1 1 1 2   03/12/1992 12:00:00 AM 12 3X3   6003885.725319999 2107769.72577 37.7677537952191 -122.4298433527 (37.7677537952191, -122.4298433527)
82272 27 1 16 740 14th St 1 1 1 1   03/26/2008 12:00:00 AM 3 3X3   6003877.1873918 2107766.1695161 37.767743547109106 -122.429872630659 (37.7677435471091, -122.429872630659)
83332 428 3 16 804X Guerrero St 1 1 1 2     20 2x2   6005618.5318457 2104291.1657751 37.7583004664994 -122.423602431641 (37.7583004664994, -122.423602431641)
58709 445 3 16 700X 23rd Ave 6 11 1 2     3 8-HOA   5988818.925419999 2110381.03816 37.774059002147204 -122.482148301598 (37.7740590021472, -122.482148301598)
103854 446 3 16 700x 23rd Ave 4 11 1 2     3     5988817.30903 2110408.41055 37.7741340651206 -122.48215589864901 (37.7741340651206, -122.482155898649)
117979 476 3 16 1110X Guerrero St 2 1 1 2     25 2x2   6005715.8108342 2102491.4524088 37.753364362762 -122.42313807467801 (37.753364362762, -122.423138074678)
93563 1338 1 16 141 Amber Dr 1 1 1 1     16 3X3   5999313.5622646 2099540.0406869 37.744897128473895 -122.44506614647499 (37.7448971284739, -122.445066146475)
23107 1354 3 16 290 Amber Dr 1 1 1 2     5 3X3   5999954.53574 2099301.98481 37.7442800472965 -122.442832694476 (37.7442800472965, -122.442832694476)
23318 1917 3 16 12 Bell Ct 1 1 1 2     10 3X3   6016599.627230001 2095217.01267 37.7339984292864 -122.384992424754 (37.7339984292864, -122.384992424754)
6925 2462 3 16 1826 Buchanan St 1 1 1 2   02/17/1998 12:00:00 AM 3 4X4   6003992.7724 2114732.7916 37.78687871637621 -122.429969843785 (37.7868787163762, -122.429969843785)
6439 2463 3 16 1826 Buchanan St 2 1 1 2   07/23/1997 12:00:00 AM 3 4X4   6003987.7732 2114755.2881 37.7869402029829 -122.429988745219 (37.7869402029829, -122.429988745219)
6513 2467 1 16 1848 Buchanan St 1 1 1 1   09/13/1989 12:00:00 AM 12 4X4   6003976.525 2114838.4 37.7871677703016 -122.430033592456 (37.7871677703016, -122.430033592456)
8099 2468 1 16 1860 Buchanan St 1 1 1 1   06/11/1997 12:00:00 AM 3 4X4   6003974.6503 2114875.8941 37.787270613481205 -122.430042754186 (37.7872706134812, -122.430042754186)
6896 2469 1 16 1875 Buchanan St 1 1 1 1   02/18/1998 12:00:00 AM 7 5x5   6003922.3005 2114887.2882 37.7872989338532 -122.43022468652201 (37.7872989338532, -122.430224686522)
5336 2470 1 16 1875 Buchanan St 2 1 1 1   02/18/1998 12:00:00 AM 7 5x5   6003922.7717 2114866.5529 37.787242026635 -122.43022157640499 (37.787242026635, -122.430221576405)
22376 2581 1 16 1671 Bush St 1 1 1 1   08/20/1990 12:00:00 AM 12 4X4   6005533.42791 2115131.9638 37.7880618747142 -122.42466793237699 (37.7880618747142, -122.424667932377)
96619 2639 1 16 1909 Bush St 1 1 1 1     6 4X4   6004357.24991 2114951.14345 37.787498890276396 -122.42872440700899 (37.7874988902764, -122.428724407009)
98972 2640 1 16 1909 Bush St 2 1 1 1   09/08/2015 12:00:00 AM 6 4X4   6004357.24991 2114951.14345 37.787498890276396 -122.42872440700899 (37.7874988902764, -122.428724407009)
7618 2643 1 16 1911 Bush St 1 1 1 1     6 4X4   6004268.353999999 2114955.8815 37.7875068682146 -122.429032306872 (37.7875068682146, -122.429032306872)
7538 2644 1 16 1911 Bush St 2 1 1 1     6 4X4   6004293.9749 2114957.7562 37.787513465908496 -122.42894379742201 (37.7875134659085, -122.428943797422)
6599 2653 1 16 1971 Bush St 1 1 1 1   08/18/1992 12:00:00 AM 3 4X4   6004104.0049 2114930.2605 37.78742721503939 -122.42959909363199 (37.7874272150394, -122.429599093632)
2113 2684 1 16 2100 Bush St 2 1 1 1     8 3X3   6003399.8502 2114890.5748 37.787278352566105 -122.432032487909 (37.7872783525661, -122.432032487909)
22000 4189 3 16 3854 Cesar Chavez St 1 1 1 2   04/17/1998 12:00:00 AM 6 3X3   6004813.31142 2100488.37375 37.747813401782 -122.426116518959 (37.747813401782, -122.426116518959)
21429 4275 3 16 4215 Cesar Chavez St 1 1 1 2     12 3X3   6002481.0949 2100316.7179400004 37.7472099827631 -122.434168929879 (37.7472099827631, -122.434168929879)
18253 4301 1 16 4374 Cesar Chavez St 1 1 1 1     6 3X3   6001502.87912 2100307.76951 37.7471298441855 -122.43755087718 (37.7471298441855, -122.43755087718)
22236 4405 3 16 1050 Church St 1 1 1 2   09/01/1993 12:00:00 AM 12 3X3   6004381.0178 2102775.98302 37.7540702011025 -122.42777434091299 (37.7540702011025, -122.427774340913)
20087 4439 3 16 1302 Church St 1 1 1 2     12 3X3   6004459.83721 2101280.4453 37.749968261937106 -122.42739523262699 (37.7499682619371, -122.427395232627)
21867 4450 3 16 1368 Church St 1 1 1 2     20 3X3   6004484.29512 2100913.96053 37.748963363065 -122.427284553034 (37.748963363065, -122.427284553034)
21005 4464 3 16 1467 Church St 1 1 1 2   11/01/1992 12:00:00 AM 6 3X3   6004576.21057 2100336.17551 37.7473820968062 -122.42692556438801 (37.7473820968062, -122.426925564388)
18906 5095 3 16 2611 Diamond St 1 1 1 2   02/04/2004 12:00:00 AM 6 3X3   6002301.7516 2096545.88638 37.7368459778655 -122.43451950896099 (37.7368459778655, -122.434519508961)
21743 5096 3 16 2617 Diamond St 1 1 1 2   11/08/2005 12:00:00 AM 15 4x7   6002321.1773 2096442.08451 37.7365620645731 -122.43444492640499 (37.7365620645731, -122.434444926405)
20053 5099 1 16 2621 Diamond St 1 1 1 1     20 3X3   6002328.495730001 2096416.0838900001 37.736491088285796 -122.434417765086 (37.7364910882858, -122.434417765086)
104519 5100 3 16 2621 Diamond St 2 1 1 2     10 3X3   6002314.2781061 2096520.2165863998 37.7367762056107 -122.43447436453998 (37.7367762056107, -122.43447436454)
17693 5140 1 16 2922 Diamond St 1 1 1 1   04/26/2011 12:00:00 AM 3 3x3   6002319.208819999 2095185.9682200002 37.7331129460068 -122.43436195314399 (37.7331129460068, -122.434361953144)
127211 5818 3 16 959 Duncan St 1 1 1 2     18 3X3   6000256.5254907 2099603.3351939 37.7451246954454 -122.441810105191 (37.7451246954454, -122.441810105191)
14939 6391 3 16 16 Espanola St 1 1 1 2   12/27/2007 12:00:00 AM 6 3X3   6018056.47068 2094273.68663 37.7314887164161 -122.379890092347 (37.7314887164161, -122.379890092347)
8873 8201 3 16 1360 Fulton St 1 1 1 2     30 3X3   6001243.6294 2111120.8056 37.7768050488635 -122.439222237812 (37.7768050488635, -122.439222237812)
20164 8289 3 16 50 Garcia Ave 1 11 1 2     3 8   5995199.8326 2099398.11528 37.7442717834334 -122.459280291049 (37.7442717834334, -122.459280291049)
19524 8290 3 16 50 Garcia Ave 2 11 1 2     30 8   5995181.45452 2099378.2291200003 37.7442161243666 -122.45934239824899 (37.7442161243666, -122.459342398249)
94053 8779 3 16 3520 Geary Blvd 2 1 1 2     6 3X3   5996174.45541 2112935.09179 37.78149683844121 -122.45688917879801 (37.7814968384412, -122.456889178798)
17743 9991 3 16 43 Guerrero St 1 1 1 2     6 2X2   6005443.377280001 2108628.68203 37.7702003684767 -122.424516723968 (37.7702003684767, -122.424516723968)
19389 9994 3 16 102 Guerrero St 1 1 1 2     12 2X2   6005389.27087 2108406.08421 37.7695861126487 -122.424688040346 (37.7695861126487, -122.424688040346)
122521 10018 1 16 205 Guerrero St 1 1 1 1   09/28/1993 12:00:00 AM 6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862)
127019 10019 1 16 205 Guerrero St 2 1 1 1     6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862)
20708 10039 3 16 360 Guerrero St 2 1 1 2   01/25/1991 12:00:00 AM 20 3X3   6005477.1925800005 2106955.99773 37.765609486820004 -122.424280773358 (37.76560948682, -122.424280773358)
21906 10040 3 16 360 Guerrero St 3 1 1 2     12 3X3   6005476.568580001 2106925.6543400004 37.7655261358546 -122.424280773346 (37.7655261358546, -122.424280773346)
10080 10041 3 16 360 Guerrero St 4 1 1 2   02/02/1991 12:00:00 AM 20 3X3   6005475.31081 2106892.46038 37.765434922114295 -122.42428276264299 (37.7654349221143, -122.424282762643)
19778 10042 3 16 360 Guerrero St 5 1 1 2     20 3X3   6005475.5325 2106875.27322 37.7653877427782 -122.424280773365 (37.7653877427782, -122.424280773365)
143257 10045 1 16 375 Guerrero St 3 1 1 1   03/11/2007 12:00:00 AM 6 2X2   6005552.9439989 2106809.2959801997 37.7652109557568 -122.424008332395 (37.7652109557568, -122.424008332395)
21684 10064 1 16 512 Guerrero St 1 1 1 1   01/01/1991 12:00:00 AM 30 3X3   6005527.25593 2105966.68025 37.762895882361 -122.42403725491 (37.762895882361, -122.42403725491)
22175 10077 3 16 611 Guerrero St 1 1 1 2     12 3x3   6005621.78486 2105416.8204099997 37.761391433480895 -122.423671214664 (37.7613914334809, -122.423671214664)
19892 10082 3 16 635 Guerrero St 1 1 1 2     12 2X2   6005631.678069999 2105272.5638099997 37.7609958972634 -122.42362674139 (37.7609958972634, -122.42362674139)
102338 10097 3 16 744 Guerrero St 1 1 1 2     30 2X2   6005593.39843 2104652.72108 37.759291793936896 -122.423715061076 (37.7592917939369, -122.423715061076)
21103 10099 1 16 750 Guerrero St 1 1 1 1   05/22/1995 12:00:00 AM 30 2x2   6005606.10854 2104557.89173 37.7590321322447 -122.423664360924 (37.7590321322447, -122.423664360924)
20555 10100 3 16 750 Guerrero St 2 1 1 2   05/22/1995 12:00:00 AM 40 2x2   6005607.26399 2104540.55602 37.758984597670896 -122.423659132264 (37.7589845976709, -122.423659132264)
17392 10106 3 16 785 Guerrero St 1 1 1 2     12 2X2   6005679.329609999 2104414.6071 37.7586428391006 -122.42340094141399 (37.7586428391006, -122.423400941414)
17729 10111 1 16 817 Guerrero St 1 1 1 1     6 2x2   6005691.67507 2104204.22323 37.758065870971706 -122.423343289458 (37.7580658709717, -122.423343289458)
20450 10113 3 16 827 Guerrero St 1 1 1 2     3 3X3   6005696.52511 2104103.91625 37.757790725171 -122.423319385483 (37.757790725171, -122.423319385483)
17273 10114 3 16 827 Guerrero St 2 1 1 2     12 3x3   6005696.25247 2104120.31934 37.7578357488369 -122.423321494416 (37.7578357488369, -122.423321494416)
19264 10115 3 16 827 Guerrero St 3 1 1 2     3 3x3   6005698.17392 2104144.57278 37.75790245155879 -122.42331657330901 (37.7579024515588, -122.423316573309)
19926 10117 3 16 845 Guerrero St 1 1 1 2     12 3X3   6005699.222580001 2104067.01691 37.757689560440795 -122.42330743349301 (37.7576895604408, -122.423307433493)
81532 10118 3 16 845 Guerrero St 2 1 1 2   02/01/1990 12:00:00 AM 3 3X3   6005704.2510557 2104056.9285895 37.7576621440613 -122.423289325813 (37.7576621440613, -122.423289325813)
145891 10119 3 16 850 Guerrero St 1 1 1 2   07/06/1992 12:00:00 AM 18 3X3   6005631.880167 2104012.3184419 37.757535570368 -122.423536442741 (37.757535570368, -122.423536442741)
20712 10140 3 16 906 Guerrero St 1 1 1 2   01/19/1991 12:00:00 AM 8 2x2   6005653.96599 2103626.9979 37.7564788166491 -122.423432668582 (37.7564788166491, -122.423432668582)
17320 10141 3 16 906 Guerrero St 2 1 1 2     12 2x2   6005654.69613 2103615.0906 37.7564461631881 -122.423429297021 (37.7564461631881, -122.423429297021)
19048 10142 1 16 915 Guerrero St 1 1 1 1     6 2x2   6005723.61297 2103645.6305400003 37.7565339082426 -122.42319312877599 (37.7565339082426, -122.423193128776)
17636 10167 3 16 1021 Guerrero St 1 1 1 2     12 2X2   6005764.985230001 2102811.5808900003 37.7542461363638 -122.422990770503 (37.7542461363638, -122.422990770503)
18974 10193 1 16 1170 Guerrero St 1 1 1 1     10 2x2   6005736.259869999 2102154.58599 37.752440559408896 -122.42304341594699 (37.7524405594089, -122.423043415947)
21320 10210 1 16 1306 Guerrero St 1 1 1 1   06/02/1992 12:00:00 AM 18 2X2   6005782.73241 2101317.8159 37.7501456037461 -122.42282324301901 (37.7501456037461, -122.422823243019)
21423 10225 3 16 1399 Guerrero St 1 1 1 2     12 3X3   6005877.37579 2100867.12021 37.748913436323704 -122.422463939564 (37.7489134363237, -122.422463939564)
16482 11411 3 16 1482 Innes Ave 1 1 1 2   11/10/1992 12:00:00 AM 6 3X4   6016167.7351400005 2096777.3502099998 37.738258902726 -122.38659438804599 (37.738258902726, -122.386594388046)
16028 11414 3 16 1486 Innes Ave 1 1 1 2     6 3X4   6016137.01095 2096800.6040700001 37.738321052161005 -122.386702239228 (37.738321052161, -122.386702239228)
15803 11415 3 16 1486 Innes Ave 2 1 1 2     12 3X4   6016124.41895 2096811.6938599998 37.7383508053301 -122.386746549719 (37.7383508053301, -122.386746549719)
91150 11948 3 16 298 Kensington Way 1 11 1 2     6 8   5994171.1384101 2099119.7549802 37.743448279624 -122.462817078393 (37.743448279624, -122.462817078393)
100288 11949 3 16 298 Kensington Way 2 11 1 2     6 8   5994171.1384101 2099119.7549802 37.743448279624 -122.462817078393 (37.743448279624, -122.462817078393)
2078 12419 1 16 1691 Laguna St 3 1 1 1   06/11/1997 12:00:00 AM 3 4X4   6004453.7544 2114557.5752 37.786423711867705 -122.42836245915599 (37.7864237118677, -122.428362459156)
141587 12438 3 16 1595X Laguna St 4 1 1 2   01/30/2005 12:00:00 AM 3 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765)
106552 12610 3 16 724 Lake St 1 1 1 2     20 3X3   5993191.3891199995 2114869.36762 37.7866360851499 -122.46734975656099 (37.7866360851499, -122.467349756561)
111468 12764 1 16 1806 Lake St 2 1 1 1   11/01/2007 12:00:00 AM 6 2X2   5989816.9164 2114746.4277 37.7861031429404 -122.47901548994699 (37.7861031429404, -122.479015489947)
127444 12766 3 16 1816 Lake St 1 1 1 2     40 3X3   5989782.53842 2114745.3914099997 37.7860983011374 -122.479134351427 (37.7860983011374, -122.479134351427)
1181 12891 1 16 255X Larch St 1 1 1 1   03/25/2005 12:00:00 AM 3 3X3   6006369.20019 2113010.28335 37.7822834283719 -122.421625551994 (37.7822834283719, -122.421625551994)
5916 12892 1 16 255X Larch St 2 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006398.20739 2113019.98592 37.7823117048675 -122.421525889114 (37.7823117048675, -122.421525889114)
6904 12893 1 16 255X Larch St 3 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006421.0816 2113018.78056 37.7823096849762 -122.421446668727 (37.7823096849762, -122.421446668727)
830 12894 1 16 255X Larch St 4 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006443.29256 2113021.2667 37.7823177635948 -122.421370005133 (37.7823177635948, -122.421370005133)
91375 13073 1 16 645X Lombard St 3 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
81488 13074 1 16 645X Lombard St 4 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
9526 14741 3 16 900 Pierce St 1 1 1 2     12 4X4   6002478.8616 2111661.3163 37.7783593683998 -122.434987870066 (37.7783593683998, -122.434987870066)
21476 16622 1 16 133 Noe St 1 1 1 1     6 3X3   6002888.88219 2107504.60291 37.766969331884 -122.433272362446 (37.766969331884, -122.433272362446)
9608 16823 3 16 2139X O'Farrell St 3 1 1 2     6 4X4   6001040.8337 2113118.4303 37.7822784765294 -122.440067043321 (37.7822784765294, -122.440067043321)
19522 17054 3 16 1267 Oak St 1 1 1 2     12 3X3   6000942.0344 2109636.8826 37.77271340359871 -122.44015910616301 (37.7727134035987, -122.440159106163)
22170 17373 1 16 1050X Masonic Ave 3 1 1 1     8 3X3   5999390.9816 2109231.8772 37.771512935512796 -122.44549522045601 (37.7715129355128, -122.445495220456)
14318 17462 1 16 2022 Palou Ave 1 1 1 1     6 3X3   6012632.03621 2096963.3752099997 37.7385733165067 -122.398832221241 (37.7385733165067, -122.398832221241)
18523 18424 3 16 974 Potrero Ave 1 1 1 2     6 3X3   6010455.61637 2103584.4912099997 37.7566319433297 -122.40682378579099 (37.7566319433297, -122.406823785791)
8439 19025 3 16 3170 Sacramento St 4 5 1 2     8 2X2   5999621.132119999 2115414.4338700003 37.7885017807754 -122.445143681435 (37.7885017807754, -122.445143681435)
7408 19027 3 16 3170 Sacramento St 1 1 1 2     12 2x2   5999630.40201 2115407.06556 37.7884820784247 -122.44511107923 (37.7884820784247, -122.44511107923)
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
10575 20040 3 16 100 STAIRWAY51 11 1 1 2     6 ST            
12976 20042 3 16 100 STAIRWAY51 13 1 1 2     3 ST            
14695 20043 3 16 100 STAIRWAY51 14 1 1 2     3 ST            
Powered by Datasette · Query took 38.596ms · Data source: data.sfgov.org