sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17 145278 2 10 730 11th Ave 1 1 1 1   03/20/2017 12:00:00 AM 0 Width 3ft Permit Number 779614 5992589.961569999 2110455.11477 37.774481011910204 -122.469109146279 (37.7744810119102, -122.469109146279)
719 246969 1 10 299 Noe St 1 4 1 1   09/06/2016 12:00:00 AM 9 Width 4ft Permit Number 778955 6002937.11929 2106633.84457 37.7645811776972 -122.433043298823 (37.7645811776972, -122.433043298823)
80688 14354 1 10 299X Noe St 1 1 1 1   09/06/2016 12:00:00 AM 3 3x3 Permit Number 778955 6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
30539 56277 1 10 70 Liberty St 1 1 1 1   08/03/2016 12:00:00 AM 3   Permit Number 778721 6005870.964575401 2104060.4446756 37.757681205790206 -122.42271301134599 (37.7576812057902, -122.422713011346)
4297 50999 1 10 3000X Jackson St 1 1 1 1   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999788.70466 2116412.94537 37.7912529948724 -122.444635704772 (37.7912529948724, -122.444635704772)
5689 51000 1 10 3000X Jackson St 2 1 1 1   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999777.56327 2116411.2536400002 37.7912477140612 -122.444674131902 (37.7912477140612, -122.444674131902)
113592 54987 1 10 634 16th Ave 1 1 1 1   10/01/2014 12:00:00 AM 3   Permit Number 774084 5990988.52251 2111051.18052 37.7760249826043 -122.47469228835699 (37.7760249826043, -122.474692288357)
72530 107389 2 10 299X Noe St 3 1 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
79285 107390 2 10 299X Noe St 4 5 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
98357 107387 2 10 299X Noe St 1 1 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
117322 107388 2 10 299X Noe St 2 5 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
93991 107500 2 10 1101x PAGE ST 3 1 1 1     14 4x4 Permit Number 773474 6001297.0 2109248.0 37.7716658315653 -122.438903370258 (37.7716658315653, -122.438903370258)
93662 104651 1 10 21 Beaver St   1 1 1         Permit Number 770906 6002646.8 2106754.0 37.7648946232156 -122.43405602387301 (37.7648946232156, -122.434056023873)
94677 104328 2 10 21 Beaver St 1 1 1 1       3x3 Permit Number 770906 6002767.0 2106786.0 37.76498930837 -122.433642570245 (37.76498930837, -122.433642570245)
66955 30368 1 10 406 Arkansas St 1 1 1 1   03/03/1956 12:00:00 AM 43   Permit Number 56 6012907.774259999 2105144.73435 37.761052931381 -122.398452757696 (37.761052931381, -122.398452757696)
96681 52015 1 10 282 29th St 4 1 1 1   09/12/2005 12:00:00 AM     Permit Number 48233 6004742.33522921 2099026.78484359 37.7437962026999 -122.42625790812401 (37.7437962026999, -122.426257908124)
98309 52013 1 10 282 29th St 3 1 1 1   09/12/2005 12:00:00 AM     Permit Number 48233 6004742.33522921 2099026.78484359 37.7437962026999 -122.42625790812401 (37.7437962026999, -122.426257908124)
111349 52016 1 10 282 29th St 2 1 1 1   09/12/2005 12:00:00 AM     Permit Number 48233 6004742.33522921 2099026.78484359 37.7437962026999 -122.42625790812401 (37.7437962026999, -122.426257908124)
99996 51601 1 10 1250 Page St 1 1 1 1   03/04/2005 12:00:00 AM     Permit Number 47896 6000577.00438268 2109291.24211111 37.7717435732091 -122.44139697552001 (37.7717435732091, -122.44139697552)
95437 50967 1 10 225 Rutland St 1 1 1 1   10/21/1974 12:00:00 AM     Permit Number 47461 6010511.43889259 2088929.82162599 37.7163964722207 -122.40559860260099 (37.7163964722207, -122.405598602601)
103101 49702 1 10 1260@ BAKER Page St 1 1 1 1   06/03/2003 12:00:00 AM     Permit Number 46521 6000531.35028078 2109284.92106254 37.7717236162704 -122.44155444188499 (37.7717236162704, -122.441554441885)
2149 225887 1 10 117 Conrad St 2 1 1 1   06/27/2017 12:00:00 AM 3 Width 2ft Permit Number 42143 6001804.962730001 2096660.33983 37.73713202700829 -122.436245312495 (37.7371320270083, -122.436245312495)
54662 40381 1 10 336 Jersey St 1 1 1 1   06/02/1999 12:00:00 AM     Permit Number 41493 6002951.47000009 2101559.64792523 37.7506494618032 -122.432631180412 (37.7506494618032, -122.432631180412)
108985 33805 1 10 751 Cole St 1 1 1 1   12/24/1996 12:00:00 AM   3x3 Permit Number 37823 5997939.03141438 2107846.29922309 37.7676254964359 -122.45041766938401 (37.7676254964359, -122.450417669384)
26815 68776 1 10 499 41st Ave 1 1 1 1 1 11/16/1993 12:00:00 AM 16   Permit Number 32706 5983126.84332 2112651.33679 37.7799598652159 -122.50200589693199 (37.7799598652159, -122.502005896932)
111147 54586 1 10 163 Lyon St 1 1 1 1   08/04/1987 12:00:00 AM   5x4 Permit Number 24629 6000291.49375014 2109442.50729731 37.7721426401996 -122.442395433804 (37.7721426401996, -122.442395433804)
102862 60698 1 10 918 Alabama St 1 1 1 1 1 03/05/1983 12:00:00 AM 15   Permit Number 20345 6009112.76031538 2103802.68080771 37.7571558133036 -122.411483299228 (37.7571558133036, -122.411483299228)
103883 60678 1 10 1160 Page St 1 1 1 1 1 02/05/1983 12:00:00 AM   6x5 Permit Number 20316 6001007.89737324 2109351.27378976 37.7719329428525 -122.439910797466 (37.7719329428525, -122.439910797466)
101861 59133 1 10 730 11th Ave 1 1 1 1   04/23/1980 12:00:00 AM 24   Permit Number 18438 5992594.65054267 2110474.91091897 37.7745356377316 -122.46909436740499 (37.7745356377316, -122.469094367405)
28216 58361 1 10 435 Locust St 1 1 1 1   11/20/1978 12:00:00 AM 13   Permit Number 17389 5997651.60838 2114939.03748 37.7870838556688 -122.45192358310601 (37.7870838556688, -122.451923583106)
24080 58360 1 10 457 Locust St 1 1 1 1   11/20/1978 12:00:00 AM 16   Permit Number 17388 5997662.21392 2114878.66722 37.786918702384796 -122.45188253354999 (37.7869187023848, -122.45188253355)
61916 57851 1 10 1001 Webster St 1 1 1 1   04/14/1977 12:00:00 AM 20   Permit Number 16792 6003796.0811 2112295.2301 37.780174641820004 -122.430476360985 (37.78017464182, -122.430476360985)
49132 57220 1 10 2525 Judah St 1 1 1 1   01/09/1975 12:00:00 AM 8   Permit Number 14507 5986650.329 2105697.8423 37.761073880118396 -122.489305344609 (37.7610738801184, -122.489305344609)
64512 57085 1 10 725 Rhode Island St 1 1 1 1   10/22/1974 12:00:00 AM 15   Permit Number 14352 6011859.01316 2104976.52396 37.7605325827245 -122.40206816360799 (37.7605325827245, -122.402068163608)
84944 56276 1 10 58 Liberty St 1 1 1 1   07/31/1973 12:00:00 AM 24   Permit Number 12402 6005944.89012346 2104064.54703238 37.757696640503895 -122.42245763762101 (37.7576966405039, -122.422457637621)
88944 56273 1 10 44 Liberty St 1 1 1 1   07/31/1973 12:00:00 AM 28   Permit Number 12399 6006031.13656237 2104069.3331134 37.7577146469635 -122.422159701591 (37.7577146469635, -122.422159701591)
113136 56271 1 10 38 Liberty St 1 1 1 1   07/31/1973 12:00:00 AM 30   Permit Number 12397 6006068.09932512 2104071.38429116 37.75772236378771 -122.422032014666 (37.7577223637877, -122.422032014666)
77596 56267 1 10 20 Liberty St 1 1 1 1   07/31/1973 12:00:00 AM 20 6x6 Permit Number 12393 6006178.98761338 2104077.53782444 37.7577455134305 -122.42164895373101 (37.7577455134305, -122.421648953731)
1161 228132 1 10 236 Grattan St 1 1 1 1   07/31/1973 12:00:00 AM 23 Width 3ft Permit Number 12386 5997539.90606 2106468.8722 37.7638205814857 -122.451698812867 (37.7638205814857, -122.451698812867)
41509 54991 1 10 646 16th Ave 1 1 1 1   09/12/1972 12:00:00 AM 13 3x3 Permit Number 10869 5990991.81393 2111001.00614 37.7758874082105 -122.474677239765 (37.7758874082105, -122.474677239765)
35734 54990 1 10 643 16th Ave 1 1 1 1   09/12/1972 12:00:00 AM 11   Permit Number 10868 5990941.26745 2111008.08375 37.7759039123762 -122.47485260799101 (37.7759039123762, -122.474852607991)
52930 54989 1 10 639 16th Ave 1 1 1 1   09/12/1972 12:00:00 AM 8   Permit Number 10867 5990941.20394 2111018.6338299997 37.77593287632679 -122.474853597928 (37.7759328763268, -122.474853597928)
696 5946 3 10 1415 Eddy St 3 1 1 2     12 3X3   6003699.8521 2112803.046 37.7815635260957 -122.43084551167601 (37.7815635260957, -122.430845511676)
715 246970 3 10 299 Noe St 2 4 1 2     9 Width 4ft   6002947.4073 2106634.57369 37.764583763244794 -122.43300776749099 (37.7645837632448, -122.433007767491)
1385 23847 1 10 1370 Webster St 2 1 1 1     20 3X3   6003735.9392 2113413.2165 37.7832409463281 -122.43076422395599 (37.7832409463281, -122.430764223956)
1657 251641 3 10 1785 Webster St 2 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
1662 251640 3 10 1785 Webster St 1 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
2038 23713 1 10 709 Webster St 1 1 1 1     25 4X4   6003942.7402 2111225.1787 37.7772448524761 -122.429892651683 (37.7772448524761, -122.429892651683)
2117 5944 3 10 1415 Eddy St 1 1 1 2     12 3X3   6003654.4203 2112794.2785 37.78153687853621 -122.43100205797701 (37.7815368785362, -122.431002057977)
2242 23928 3 10 1715 Webster St 2 1 1 2     70 4X4   6003464.0168 2114669.7894 37.7866757692841 -122.431794715065 (37.7866757692841, -122.431794715065)
2714 141996 3 10 818 WEBSTER ST 6 1 1 2     24 Width 0ft   6003983.1859 2111655.6546 37.7784291232811 -122.42978344870899 (37.7784291232811, -122.429783448709)
2717 141997 3 10 818 WEBSTER ST 7 1 1 2     18 Width 0ft   6003978.0604 2111685.2682 37.7785101446541 -122.42980329253 (37.7785101446541, -122.42980329253)
2718 141991 1 10 818 Webster St 1 1 1 1     9 Width 0ft   6004002.4362 2111527.1662 37.7780774159831 -122.429707688099 (37.7780774159831, -122.429707688099)
2724 141999 1 10 818 WEBSTER ST 9 1 1 1     14 Width 0ft   6003970.657000001 2111746.2039 37.778677039760794 -122.429833251248 (37.7786770397608, -122.429833251248)
2725 141994 3 10 818 Webster St 4 1 1 2     21 Width 0ft   6003989.735 2111607.5325 37.7782973627546 -122.429757359707 (37.7782973627546, -122.429757359707)
2728 142000 3 10 818 WEBSTER ST 10 1 1 2     19 Width 0ft   6003967.2401 2111768.9836 37.7787393936814 -122.429846696894 (37.7787393936814, -122.429846696894)
3202 14513 3 10 501 Masonic Ave 1 1 1 2     100 4X4   5999073.0679 2111076.7771 37.776560404910796 -122.4467276636 (37.7765604049108, -122.4467276636)
3257 253379 2 10 899 Waller St 1 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3262 253382 2 10 899 Waller St 4 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3270 253380 2 10 899 Waller St 2 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3271 253381 2 10 899 Waller St 3 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3279 253383 2 10 899 Waller St 5 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
4608 4436 3 10 1292 Church St 1 1 1 2   09/29/2017 12:00:00 AM 3 3X3   6004456.3598 2101397.3807200002 37.75028914274171 -122.42741558697901 (37.7502891427417, -122.427415586979)
4904 23927 1 10 1715 Webster St 1 1 1 1     90 4X4   6003460.7841 2114695.1886 37.7867453258178 -122.43180771362199 (37.7867453258178, -122.431807713622)
5289 5945 3 10 1415 Eddy St 2 1 1 2     16 3X3   6003671.9554 2112797.4667 37.7815466261115 -122.43094162257 (37.7815466261115, -122.43094162257)
5913 23706 3 10 700X Webster St 1 11 1 2     80 8X8   6003994.1877 2111257.6303 37.7773368699173 -122.42971699343799 (37.7773368699173, -122.429716993438)
5918 23710 3 10 700X Webster St 5 11 1 2     20 20   6003962.5277 2111419.0963 37.77777842285779 -122.429838035535 (37.7777784228578, -122.429838035535)
6042 14515 3 10 515 Masonic Ave 1 1 1 2     15 4X4   5999080.7636 2111027.2361 37.7764248176545 -122.44669747668699 (37.7764248176545, -122.446697476687)
6955 23850 1 10 1401X Webster St 3 1 1 1     12 3X3   6003612.0155 2113606.6244 37.7837649741264 -122.43120675986401 (37.7837649741264, -122.431206759864)
7093 23752 3 10 900X Webster St 8 1 1 2     34 4X4   6003928.8061 2112053.0316 37.7795171425157 -122.429999922728 (37.7795171425157, -122.429999922728)
7229 23933 3 10 1737 Webster St 2 1 1 2     45 4X4   6003453.8571 2114739.0598 37.7868653923719 -122.431834813039 (37.7868653923719, -122.431834813039)
7253 23719 3 10 780 Webster St 1 1 1 2   01/21/1999 12:00:00 AM 80 4X4   6004022.2052 2111346.6982 37.777583014840296 -122.429626425718 (37.7775830148403, -122.429626425718)
7451 28768 1 10 500X Masonic Ave 1 1 1 1     20 6X6   5999147.2771 2111039.3503 37.7764618793954 -122.446468260318 (37.7764618793954, -122.446468260318)
7466 23749 3 10 900X Webster St 5 1 1 2     12 4x4   6003935.7161 2111981.6282 37.779321477825704 -122.429970923277 (37.7793214778257, -122.429970923277)
7469 23746 3 10 900X Webster St 2 1 1 2     20 4x4   6003946.8489 2111892.9498 37.779078619397396 -122.429926083012 (37.7790786193974, -122.429926083012)
7515 23751 3 10 900X Webster St 7 1 1 2     29 4x4   6003930.3417 2112029.9983 37.7794539857546 -122.42999296692899 (37.7794539857546, -122.429992966929)
7686 23718 3 10 760 Webster St 1 1 1 2   05/19/1992 12:00:00 AM 12 4X4   6004031.4914 2111284.7902 37.7774135565599 -122.429589885322 (37.7774135565599, -122.429589885322)
7737 8094 1 10 762 Fulton St 5 1 1 19     100 3X3   6004211.6397 2111535.7715 37.7781128879326 -122.428984591665 (37.7781128879326, -122.428984591665)
7937 28767 1 10 500X Masonic Ave 2 1 1 1     20 6X6   5999141.8623 2111078.2688 37.7765684303305 -122.44648979216299 (37.7765684303305, -122.446489792163)
8490 23932 3 10 1737 Webster St 1 1 1 2     25 4x4   6003450.6245 2114754.2993 37.7869070529375 -122.43184708562299 (37.7869070529375, -122.431847085623)
8689 23745 3 10 900X Webster St 1 1 1 2     32 4x4   6003951.3115 2111867.7982 37.779009812059 -122.429908850506 (37.779009812059, -122.429908850506)
8799 23802 1 10 1160 Webster St 3 1 1 1     70 3X3   6003829.6195 2112722.1937 37.7813488773836 -122.43039080821998 (37.7813488773836, -122.43039080822)
8983 23748 3 10 900X Webster St 4 1 1 2     38 4x4   6003941.8583 2111953.2204 37.779243824898295 -122.42994764790701 (37.7792438248983, -122.429947647907)
9109 23140 1 10 1621X Church St 1 1 1 1     40 3x3   6004632.02812 2099337.8259 37.744644014501205 -122.42666146912599 (37.7446440145012, -122.426661469126)
9261 23750 1 10 900X Webster St 6 1 1 1     40 4x4   6003934.1806 2112005.4294 37.779386743058296 -122.429977933491 (37.7793867430583, -122.429977933491)
9347 23747 1 10 900X Webster St 3 1 1 1     38 4x4   6003945.3133 2111922.8931 37.779160749313895 -122.42993353175301 (37.7791607493139, -122.429933531753)
9527 9961 3 10 700X Webster St 1 1 1 2     18 4X4   6004044.3152 2111193.6969 37.777164162929 -122.429539025484 (37.777164162929, -122.429539025484)
9878 14590 3 10 1221 Masonic Ave 2 1 1 2     45 3X3   5999397.8697 2108638.7231 37.7698846777669 -122.44542873681401 (37.7698846777669, -122.445428736814)
17342 16656 3 10 200 Noe St 2 1 1 2     20 4X4   6002872.09203 2107040.69534 37.7656946022435 -122.433297284454 (37.7656946022435, -122.433297284454)
17417 14589 3 10 1221 Masonic Ave 1 1 1 2     90 3X3   5999408.7715 2108648.7165 37.769912739454604 -122.445391746523 (37.7699127394546, -122.445391746523)
17501 16632 3 10 150 Noe St 1 1 1 2     18 4X4   6002845.7066 2107359.01628 37.7665671370879 -122.433411295115 (37.7665671370879, -122.433411295115)
17618 16652 3 10 198 Noe St 1 1 1 2     24 4X5   6002855.56746 2107156.83131 37.7660125458771 -122.43336273892 (37.7660125458771, -122.43336273892)
17700 4504 3 10 1780 Church St 1 1 1 2     26 4X4   6004619.48057 2098494.87239 37.7423287477646 -122.426644841002 (37.7423287477646, -122.426644841002)
17793 16659 1 10 201 Noe St 1 1 1 1     18 3X4   6002918.29496 2107052.8377799997 37.765730563431894 -122.43313834635 (37.7657305634319, -122.43313834635)
18104 23633 3 10 198X Coleridge St 2 1 1 2     24 3X3   6006450.06706 2098653.35241 37.7428672213344 -122.42032646421801 (37.7428672213344, -122.420326464218)
18178 4495 3 10 1618 Church St 1 1 1 2   11/02/1990 12:00:00 AM 18 3x3   6004570.56721 2099356.4076799997 37.744691560861895 -122.426875312064 (37.7446915608619, -122.426875312064)
18347 14360 3 10 299X Noe St 7 1 1 2     12 4X5   6002944.99981 2106698.0348400003 37.7647578756004 -122.43302062870501 (37.7647578756004, -122.433020628705)
18383 4503 3 10 1767 Church St 1 1 1 2     12 3x3   6004674.71192 2098595.28716 37.742607586167395 -122.42646101595601 (37.7426075861674, -122.426461015956)
18531 16655 3 10 200 Noe St 1 1 1 2     24 5X4   6002860.3108 2107045.92477 37.765708292624296 -122.433338406847 (37.7657082926243, -122.433338406847)
18603 14356 3 10 299X Noe St 3 1 1 2     12 3X3   6002946.4626400005 2106656.3475200003 37.764643495314296 -122.43301259056801 (37.7646434953143, -122.433012590568)
18912 4820 3 10 398X Coleridge St 3 1 1 2     36 4x4   6006006.1956778 2097849.2293648 37.7406342583881 -122.42180414448299 (37.7406342583881, -122.421804144483)
Powered by Datasette · Query took 7.221ms · Data source: data.sfgov.org