sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31267 140047 2 59 997 STEINER ST 1 1 1 1     17 Width 0ft   6002926.2641 2111608.0681 37.778238555435 -122.433436333455 (37.778238555435, -122.433436333455)
140393 140048 2 59 993 STEINER ST 1 1 1 1     17 Width 0ft   6002927.2794 2111591.8239 37.7781940105178 -122.433431660039 (37.7781940105178, -122.433431660039)
61935 247443 2 59 988 Oak St 1 1 1 1     20 Width 0ft   6002297.3139 2109877.1332 37.7734501371932 -122.43548824232 (37.7734501371932, -122.43548824232)
54262 247457 2 59 969 Oak St 1 1 1 1     15 Width 0ft   6002376.9254 2109837.784 37.773346615242 -122.435210039995 (37.773346615242, -122.435210039995)
153964 59661 1 59 950 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 16   Permit Number 19083 6002974.356000001 2111562.0693 37.7781149825494 -122.433266678398 (37.7781149825494, -122.433266678398)
46666 140592 2 59 950 STEINER ST 3 1 1 1     13 Width 0ft   6002968.2418 2111603.9288 37.778229571438295 -122.433290821469 (37.7782295714383, -122.433290821469)
49156 140591 2 59 950 STEINER ST 2 1 1 1     13 Width 0ft   6002971.355 2111585.6946 37.778179681485206 -122.433278748514 (37.7781796814852, -122.433278748514)
149439 140593 2 59 950 STEINER ST 4 1 1 1     4 Width 0ft   6002965.1287 2111621.7183 37.7782782403601 -122.43330286230899 (37.7782782403601, -122.433302862309)
7541 7214 1 59 950 Fillmore St 2 1 1 1     18 4X4   6003450.6988 2111662.2209 37.778416985075104 -122.431625989594 (37.7784169850751, -122.431625989594)
8928 7213 3 59 950 Fillmore St 1 1 1 2     18 4X4   6003452.6284 2111644.2112 37.7783676442869 -122.43161802827 (37.7783676442869, -122.43161802827)
1759 7200 3 59 949 Fillmore St 7 1 1 2     12 3X3   6003420.9887 2111521.8792 37.7780299575939 -122.431718745255 (37.7780299575939, -122.431718745255)
7644 7201 3 59 949 Fillmore St 8 1 1 2     12 3X3   6003424.6737 2111504.3754 37.7779821053868 -122.431704747493 (37.7779821053868, -122.431704747493)
41568 140583 2 59 949 FILLMORE ST 9 1 1 1     21 Width 0ft   6003424.6737 2111485.9504 37.7779315149131 -122.431703431668 (37.7779315149131, -122.431703431668)
133517 140585 2 59 949 FILLMORE ST 11 1 1 1     21 Width 0ft   6003432.0437 2111445.4153 37.777820633348796 -122.43167504147699 (37.7778206333488, -122.431675041477)
155611 140584 2 59 949 FILLMORE ST 10 1 1 1     19 Width 0ft   6003428.3587 2111466.6041 37.77787860365579 -122.431689302353 (37.7778786036558, -122.431689302353)
44806 59664 1 59 947 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 15 5x5 Permit Number 19086 6002929.3099 2111572.5338 37.7781411599151 -122.433423256969 (37.7781411599151, -122.433423256969)
66240 59663 1 59 943 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 16   Permit Number 19085 6002930.6636 2111548.8443 37.778076191259 -122.433416880741 (37.778076191259, -122.433416880741)
6144 7206 3 59 940 Fillmore St 1 1 1 2     18 4X4   6003460.3469 2111580.5338 37.778193239457295 -122.431586779834 (37.7781932394573, -122.431586779834)
6743 7207 3 59 940 Fillmore St 2 1 1 2     18 4X4   6003456.4877 2111615.9101 37.778290155247205 -122.431602656487 (37.7782901552472, -122.431602656487)
146907 140056 2 59 933 STEINER ST 1 1 1 1     16 Width 0ft   6002938.7857 2111497.0658 37.77793448120671 -122.433385082512 (37.7779344812067, -122.433385082512)
32530 97312 1 59 926 Taraval St 4 1 1 1   04/19/1984 12:00:00 AM 10 3x3   5990212.18 2099077.2394 37.7431027248159 -122.476502906842 (37.7431027248159, -122.476502906842)
74885 97311 1 59 926 Taraval St 1 1 1 1   04/19/1984 12:00:00 AM 7 3x3   5990303.3847 2099082.1466 37.7431214880079 -122.47618790715099 (37.7431214880079, -122.476187907151)
164818 87369 1 59 926 Taraval St 3 1 1 1   04/11/2008 12:00:00 AM 10 3x3 Permit Number 50349 5990243.3148 2099080.9621 37.7431147521003 -122.476395524083 (37.7431147521003, -122.476395524083)
73116 140597 2 59 926 FILLMORE ST 1 1 1 1     12 Width 0ft   6003478.9999 2111464.1135 37.7778746354568 -122.431513938953 (37.7778746354568, -122.431513938953)
169493 247449 2 59 919 Oak St 1 1 1 1     11 Width 0ft   6002569.9466 2109861.5161 37.773422736804 -122.434544050831 (37.773422736804, -122.434544050831)
50203 247450 2 59 917 Oak St 2 1 1 1     6 Width 0ft   6002601.5894 2109867.0536 37.773439737619704 -122.43443498999599 (37.7734397376197, -122.434434989996)
131662 247451 2 59 915 Oak St 3 1 1 1     8 Width 0ft   6002618.2019 2109871.0089 37.773451540866496 -122.434377807884 (37.7734515408665, -122.434377807884)
45616 247452 2 59 913 Oak St 4 1 1 1     8 Width 0ft   6002642.725 2109874.1732 37.773461621200795 -122.434293205315 (37.7734616212008, -122.434293205315)
175055 59662 1 59 911 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 17   Permit Number 19084 6002943.8621 2111474.7299 37.777873440392206 -122.433365924976 (37.7778734403922, -122.433365924976)
166509 59660 1 59 910 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 15   Permit Number 19082 6002982.2355 2111513.667 37.777982528898704 -122.43323596098 (37.7779825288987, -122.43323596098)
42656 140057 2 59 909 STEINER ST 1 1 1 1     17 Width 0ft   6002945.8926 2111449.3483 37.7778038640415 -122.43335708659299 (37.7778038640415, -122.433357086593)
171567 140062 2 59 907 Steiner St 1 1 1 1     13 Width 0ft   6002950.6305 2111424.6435 37.7777362996085 -122.43333893078301 (37.7777362996085, -122.433338930783)
137939 59659 1 59 906 Steiner St 1 1 1 1   03/30/1981 12:00:00 AM 16   Permit Number 19081 6002986.1752 2111478.2094 37.777885394660395 -122.43321979797301 (37.7778853946604, -122.433219797973)
71479 140063 2 59 905 Steiner St 2 1 1 1     14 Width 0ft   6002952.9994 2111406.0303 37.7776853267914 -122.433329405572 (37.7776853267914, -122.433329405572)
181301 140064 2 59 903 Steiner St 3 1 1 1     16 Width 0ft   6002956.7221 2111383.6945 37.777624209443395 -122.433314931056 (37.7776242094434, -122.433314931056)
181180 142104 2 59 902 Fell St 4 1 1 1     16 Width 0ft   6002990.6954 2110322.4378 37.774712189416704 -122.43312156093398 (37.7747121894167, -122.433121560934)
173946 138927 2 59 901 HAYES ST 1 1 1 1     14 Width 0ft   6003523.5494 2110764.9413 37.775957406614204 -122.431309905462 (37.7759574066142, -122.431309905462)
17284 16993 3 59 900 Oak St 2 1 1 2     18 3x3   6002625.7759 2109923.0859 37.7735949613156 -122.434355332323 (37.7735949613156, -122.434355332323)
19445 16994 3 59 900 Oak St 3 1 1 2     12 3x3   6002602.5998 2109922.2867 37.7735914513761 -122.434435444699 (37.7735914513761, -122.434435444699)
20899 16992 3 59 900 Oak St 1 1 1 2     18 1x1   6002640.9603 2109924.6842 37.773600211727 -122.434302921546 (37.773600211727, -122.434302921546)
148730 67753 1 59 900 Kearny St 1 1 1 1   12/04/1992 12:00:00 AM 11 3x3 Permit Number 31377 6011258.7412 2118020.5233 37.79631485229 -122.405062718866 (37.79631485229, -122.405062718866)
162030 115983 1 59 900 Kearny St 2 1 1 1     10 3x3   6011256.8768 2118034.0404 37.796351862758996 -122.40507012236701 (37.796351862759, -122.405070122367)
170111 115985 1 59 900 Kearny St 4 1 1 1     9 3x3   6011253.147999999 2118063.4049 37.7964322821358 -122.405085093558 (37.7964322821358, -122.405085093558)
182606 115984 1 59 900 Kearny St 3 1 1 1     10 3x3   6011255.4785 2118051.2862 37.796399137392896 -122.405076175742 (37.7963991373929, -122.405076175742)
38088 142102 2 59 900 Fell St 2 2 1 1     14 Width 0ft   6003042.617000001 2110331.1771 37.7747391304954 -122.43294257823798 (37.7747391304954, -122.432942578238)
7436 4702 3 59 900 Columbus Ave 1 1 1 2   02/02/1989 12:00:00 AM 30 3X3   6008773.44 2120486.1314 37.8029455537581 -122.413836905739 (37.8029455537581, -122.413836905739)
166722 141778 2 59 9 Hollis St 3 1 1 1     10 Width 0ft   6003916.891 2113262.7794 37.7828381339765 -122.430127467778 (37.7828381339765, -122.430127467778)
17157 16991 3 59 899 Oak St 2 1 1 2     12 3x3   6002773.5007 2109890.2869 37.7735132873347 -122.433841985714 (37.7735132873347, -122.433841985714)
21377 16990 3 59 899 Oak St 1 1 1 2     12 3x3   6002737.3984 2109886.1011 37.773499745425795 -122.43396656947701 (37.7734997454258, -122.433966569477)
133283 247448 2 59 899 Oak St 4 1 1 1     13 Width 0ft   6002819.5442 2109896.0423 37.7735317029302 -122.433683126065 (37.7735317029302, -122.433683126065)
184088 247447 2 59 899 Oak St 3 1 1 1     10 Width 0ft   6002801.7546 2109893.9494 37.7735249469174 -122.43374451324301 (37.7735249469174, -122.433744513243)
18945 17664 3 59 892X Oak St 2 1 1 2     18 3X3   6002741.8184 2109937.0039 37.773639762745 -122.433954919315 (37.773639762745, -122.433954919315)
17814 16989 1 59 880 Oak St 1 1 1 1     18 3X3   6002806.5013 2109946.7063 37.77367007365171 -122.433731865097 (37.7736700736517, -122.433731865097)
179842 143496 2 59 877 Kearny St 1 1 1 1     7 Width 0ft   6011215.3935 2117948.7433 37.7961153384403 -122.405207654625 (37.7961153384403, -122.405207654625)
5332 10639 3 59 877 Hayes St 1 1 1 2     12 3X3   6003685.3267 2110714.3548 37.7758276754833 -122.43074666505301 (37.7758276754833, -122.430746665053)
155471 247306 2 59 873 Page St 2 1 1 1     10 Width 0ft   6002371.1002 2109493.4114 37.772400722701796 -122.435205553676 (37.7724007227018, -122.435205553676)
48254 248610 2 59 872 Shrader St 1 1 1 1     8 Width 0ft   5997691.4278 2107516.4386 37.7667056091614 -122.4512503025 (37.7667056091614, -122.4512503025)
20398 16986 1 59 870 Oak St 1 1 1 1     18 3x3   6002847.8984 2109953.1746 37.7736901829149 -122.433589128645 (37.7736901829149, -122.433589128645)
5748 6994 3 59 870 Fell St 1 1 1 2     12 3X3   6003272.597999999 2110360.7630000003 37.77483340788321 -122.43214914086201 (37.7748334078832, -122.432149140862)
17632 16985 1 59 867 Oak St 1 1 1 1     18 3X3   6002849.3678 2109899.7049 37.7735434517189 -122.433580223732 (37.7735434517189, -122.433580223732)
156337 143497 2 59 867 Kearny St 2 1 1 1     6 Width 0ft   6011217.2579 2117938.9551 37.796088566637394 -122.40520051378999 (37.7960885666374, -122.40520051379)
47609 139282 2 59 863 FILLMORE ST 1 1 1 1     16 Width 0ft   6003442.6809 2111357.0537 37.7775786172665 -122.431631933616 (37.7775786172665, -122.431631933616)
60986 248611 2 59 862 Shrader St 1 1 1 1     4 Width 0ft   5997689.6108 2107534.9111 37.7667562259025 -122.45125791953001 (37.7667562259025, -122.45125791953)
20280 16984 3 59 861 Oak St 1 1 1 2     18 3X3   6002878.6682 2109904.9371 37.7735594804671 -122.433479243381 (37.7735594804671, -122.433479243381)
50778 140610 2 59 860 Fillmore St 3 1 1 1     18 Width 0ft   6003498.0852 2111306.0629 37.7774417494141 -122.431436630621 (37.7774417494141, -122.431436630621)
175619 244473 2 59 859 Fell St 2 1 1 1     11 Width 0ft   6003334.8057 2110313.6958 37.774707699745996 -122.43193059003599 (37.774707699746, -122.431930590036)
130403 143498 2 59 857 Kearny St 3 1 1 1     6 Width 0ft   6011217.723999999 2117930.0991 37.796064276257205 -122.40519827705499 (37.7960642762572, -122.405198277055)
31925 139285 2 59 855 FILLMORE ST 3 1 1 1     16 Width 0ft   6003448.7737 2111306.0955 37.7774390440386 -122.431607217597 (37.7774390440386, -122.431607217597)
119306 139284 2 59 855 FILLMORE ST 2 1 1 1     16 Width 0ft   6003447.6659 2111322.7123 37.7774846068582 -122.431612236467 (37.7774846068582, -122.431612236467)
147729 139283 2 59 855 FILLMORE ST 1 1 1 1     11 Width 0ft   6003446.5582 2111336.5596 37.7775225653231 -122.431617057223 (37.7775225653231, -122.431617057223)
5904 24490 1 59 852 Fell St 1 1 1 1   06/24/1995 12:00:00 AM 6 3X3   6003356.8582 2110371.9538 37.7748689119653 -122.431858466675 (37.7748689119653, -122.431858466675)
155455 140609 2 59 850 Fillmore St 2 1 1 1     18 Width 0ft   6003501.1005 2111292.4942 37.777404664022 -122.431425230844 (37.777404664022, -122.431425230844)
132506 143556 2 59 848 KEARNY ST 1 10 1 1     5 Width 0ft   6011275.0549 2117918.4465 37.796035485985705 -122.40499907891301 (37.7960354859857, -122.404999078913)
169665 143557 2 59 848 KEARNY ST 2 10 1 1     5 Width 0ft   6011271.7921 2117938.489 37.7960903354635 -122.405011780806 (37.7960903354635, -122.405011780806)
22154 16983 3 59 847 Oak St 1 1 1 2     18 3X3   6002927.3278 2109904.9371 37.773562241081706 -122.43331092272899 (37.7735622410817, -122.433310922729)
24268 139286 2 59 847 FILLMORE ST 1 1 1 1     10 Width 0ft   6003452.0971 2111280.6163 37.777369272847295 -122.431593901382 (37.7773692728473, -122.431593901382)
8030 10637 3 59 843 Hayes St 2 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003821.4079 2110734.0055 37.7758893402664 -122.43027732793101 (37.7758893402664, -122.430277327931)
8268 10636 3 59 843 Hayes St 1 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003811.0913 2110732.5317 37.7758847092198 -122.430312910525 (37.7758847092198, -122.430312910525)
64806 140608 2 59 840 Fillmore St 1 1 1 1     19 Width 0ft   6003502.6081 2111278.9255 37.7773674931794 -122.431419046703 (37.7773674931794, -122.431419046703)
21967 16981 3 59 837 Oak St 1 1 1 2     18 3X3   6002980.1732 2109918.2793 37.7736018732822 -122.433129076252 (37.7736018732822, -122.433129076252)
6126 7180 3 59 837 Fillmore St 1 1 1 2     12 3X3   6003455.9744 2111255.1372 37.7772995333232 -122.43157866908199 (37.7772995333232, -122.431578669082)
6429 7178 3 59 837 Fillmore St 2 1 1 2     12 6x6   6003458.7438 2111235.1971 37.777244939721704 -122.431567664925 (37.7772449397217, -122.431567664925)
5648 7179 3 59 833 Fillmore St 1 1 1 2     12 3X3   6003463.175 2111217.4725 37.777196523521795 -122.431551070298 (37.7771965235218, -122.431551070298)
1064 7177 1 59 827 Fillmore St 1 1 1 1     6 3X3   6003463.7289 2111198.6401 37.7771448458144 -122.431547809387 (37.7771448458144, -122.431547809387)
17671 16978 1 59 823 Oak St 1 1 1 1     12 3X3   6003035.6347 2109919.8489 37.7736093289353 -122.432937338869 (37.7736093289353, -122.432937338869)
8458 7176 1 59 821 Fillmore St 1 1 1 1     3 3X3   6003466.4983 2111179.8077 37.777093293678206 -122.43153688437401 (37.7770932936782, -122.431536884374)
180558 66720 1 59 819 Lyon St 1 1 1 1   08/13/1991 12:00:00 AM 14   Permit Number 29962 5999956.9512 2111893.0193 37.778852049002 -122.44372871968399 (37.778852049002, -122.443728719684)
8915 10629 3 59 817 Hayes St 1 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003911.8012 2110745.3047 37.775925484701794 -122.429965440473 (37.7759254847018, -122.429965440473)
31071 247300 2 59 815 Page St 1 1 1 1     6 Width 0ft   6002551.3233 2109517.7945 37.772477905220796 -122.434583889381 (37.7724779052208, -122.434583889381)
9575 23736 1 59 815 Hayes St 1 1 1 1   02/15/2005 12:00:00 AM 8 4X4   6003952.5765 2110750.7086 37.775942631605204 -122.429824773698 (37.7759426316052, -122.429824773698)
131601 140621 2 59 814 FILLMORE ST 2 1 1 1     16 Width 0ft   6003510.9001 2111228.4198 37.7772292869927 -122.431386755732 (37.7772292869927, -122.431386755732)
17964 16976 1 59 811 Oak St 1 1 1 1     45 3X3   6003075.3996 2109932.9295 37.7736475004085 -122.432800720802 (37.7736475004085, -122.432800720802)
30879 247445 2 59 811 Oak St 2 1 1 1     11 Width 0ft   6003098.9445 2109936.0688 37.7736574554899 -122.432719499751 (37.7736574554899, -122.432719499751)
166843 63488 1 59 811 Lyon St 1 1 1 1 1 04/07/1987 12:00:00 AM 12   Permit Number 24085 5999970.1497 2111784.3859 37.7785545222825 -122.443675254762 (37.7785545222825, -122.443675254762)
68519 140631 2 59 810 Fillmore St 2 1 1 1     16 Width 0ft   6003522.9612 2111140.977 37.7769898742733 -122.431338789049 (37.7769898742733, -122.431338789049)
20192 20112 3 59 809X Oak St 1 1 1 2     18 3X3   6003121.4431 2109939.2081 37.7736673511786 -122.43264189798799 (37.7736673511786, -122.432641897988)
176802 140630 2 59 808 Fillmore St 1 1 1 1     18 Width 0ft   6003528.2379 2111115.3472 37.7769198002338 -122.431318705355 (37.7769198002338, -122.431318705355)
186307 137638 2 59 807 LYON ST 1 1 1 1     16 Width 0ft   5999975.5644 2111759.3427 37.778486068888796 -122.443654723767 (37.7784860688888, -122.443654723767)
1336 7171 3 59 801 Fillmore St 3 1 1 2     12 3x3 Permit Number 780067 6003475.9145 2111120.5411 37.7769310959731 -122.431500078765 (37.7769310959731, -122.431500078765)
1340 7172 3 59 801 Fillmore St 4 1 1 2     12 3x3 Permit Number 780067 6003478.683999999 2111101.7087 37.7768795438362 -122.43148915347099 (37.7768795438362, -122.431489153471)
1343 7169 3 59 801 Fillmore St 1 1 1 2     12 3x3 Permit Number 780067 6003470.3756 2111160.9753 37.777041804334296 -122.43152212680799 (37.7770418043343, -122.431522126808)
Powered by Datasette · Query took 22.187ms · Data source: data.sfgov.org