sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
96621 17118 1 43 1907 Oak St 2 1 1 1     12 3x3   5997842.841030001 2109183.73864 37.771292257165896 -122.4508468245 (37.7712922571659, -122.4508468245)
114870 52589 1 43 675 Cole St 1 1 1 1   01/27/2006 12:00:00 AM     Permit Number 774039 5997878.20498734 2108284.16023065 37.7688242695831 -122.450659631577 (37.7688242695831, -122.450659631577)
139154 106938 2 43 1607 WALLER ST 3 1 1 1     11     5997889.0 2108175.0 37.768525161365105 -122.45061442154498 (37.7685251613651, -122.450614421545)
84293 111114 1 43 2085 Hayes St 2 1 1 1     10     5997903.58032533 2109906.22418863 37.773279493542795 -122.45068882440701 (37.7732794935428, -122.450688824407)
91527 111115 1 43 2085 Hayes St 3 1 1 1     10     5997903.58032533 2109906.22418863 37.773279493542795 -122.45068882440701 (37.7732794935428, -122.450688824407)
127284 111116 1 43 2085 Hayes St 4 1 1 1     12     5997903.58032533 2109906.22418863 37.773279493542795 -122.45068882440701 (37.7732794935428, -122.450688824407)
18363 94569 1 43 100@ Cole Carl St 1 1 1 1       3x3   5998051.0 2107197.0 37.765849093366796 -122.449983584058 (37.7658490933668, -122.449983584058)
99209 94566 1 43 100 Carl St 1 1 1 1       3x3   5998051.0 2107197.0 37.765849093366796 -122.449983584058 (37.7658490933668, -122.449983584058)
108733 94567 1 43 100 Carl St 2 1 1 1       3x3   5998051.0 2107197.0 37.765849093366796 -122.449983584058 (37.7658490933668, -122.449983584058)
100007 58524 1 43 1544 Waller St 1 1 1 1   04/02/1979 12:00:00 AM     Permit Number 17701 5998255.704076401 2108272.5838384 37.7688140844915 -122.449353060877 (37.7688140844915, -122.449353060877)
98986 104241 1 43 1544 Waller St 2 1 1 1       3x3   5998256.5 2108266.6 37.768797699923 -122.44934987666001 (37.768797699923, -122.44934987666)
50412 111774 2 43 215 CLAYTON ST 2 1 1 1     11 3x3   5998260.0 2109886.0 37.773244358342296 -122.449454468346 (37.7732443583423, -122.449454468346)
84824 106999 1 43 10 Loyola Ter 3 1 1 1           5998469.2817 2110801.2236 37.7757692966762 -122.448796472896 (37.7757692966762, -122.448796472896)
71075 106808 1 43 10 LOYOLA TER 2 1 1 1     10   Permit Number 772884 5998469.3 2110801.2 37.7757692329232 -122.44879640789101 (37.7757692329232, -122.448796407891)
123862 105233 2 43 1508 WALLER ST 3 1 1 1     15 3x3   5998474.1 2108297.0 37.7688936152058 -122.448599407064 (37.7688936152058, -122.448599407064)
58723 116509 1 43 1500x Waller St 3 1 1 1   06/13/2016 12:00:00 AM 3 3x3   5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
78415 116510 1 43 1500x Waller St 4 1 1 1       3x3   5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
104104 58777 1 43 1500x Waller St 1 1 1 1   01/08/1980 12:00:00 AM   3x3 Permit Number 18128 5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
118687 116511 1 43 1500x Waller St 5 1 1 1       3x3   5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
54782 17106 1 43 1777 Oak St 1 1 1 1     18 3X3   5998507.83576 2109285.1679 37.771608801349394 -122.448553894841 (37.7716088013494, -122.448553894841)
103004 10464 3 43 1584 Haight St 2 1 1 2     18 3x3   5998533.97425 2108659.6299400004 37.7698927281656 -122.44841842514099 (37.7698927281656, -122.448418425141)
110998 17105 3 43 1763 Oak St 1 1 1 2     12 3X3   5998573.85799 2109309.47001 37.771679303532295 -122.44832727139901 (37.7716793035323, -122.448327271399)
28450 104230 2 43 409 Walnut St 1 1 1 1       14x8   5998587.6 2115205.6 37.787869332154 -122.44870447955601 (37.787869332154, -122.448704479556)
109816 10462 3 43 1576 Haight St 1 1 1 2     18 3x3   5998589.8073 2108666.88124 37.7699158304312 -122.448225822875 (37.7699158304312, -122.448225822875)
97826 116231 1 43 1486 Waller St 2 1 1 1       5x5   5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388)
110739 116232 1 43 1486 Waller St 3 1 1 1       7x7   5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388)
142435 58520 1 43 1486 Waller St 1 1 1 1   04/02/1979 12:00:00 AM   7x7 Permit Number 17697 5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388)
111498 93200 2 43 756 Clayton St 1 1 1 1       5x6   5998607.0 2107901.0 37.7678138979087 -122.448111199872 (37.7678138979087, -122.448111199872)
109937 121101 2 43 600x Belvedere St 1 1 1 1       3x3   5998712.0 2105642.0 37.761617254212396 -122.44758538801099 (37.7616172542124, -122.447585388011)
106747 58514 1 43 1460 Waller St 1 1 1 1   03/30/1979 12:00:00 AM   3x3 Permit Number 17691 5998731.52150291 2108338.88905051 37.7690233477366 -122.447712023248 (37.7690233477366, -122.447712023248)
111700 109331 2 43 1325 CLAYTON ST 1 1 1 1     22 3x3   5998933.0 2105018.0 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106)
142530 109332 2 43 1321 CLAYTON ST 1 1 1 1     22 3x3   5998933.0 2105018.0 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106)
124253 109328 2 43 1349 CLAYTON ST 1 1 1 1   02/27/2015 12:00:00 AM 3 3x3   5999000.5 2104870.1 37.7595142924854 -122.44653205153799 (37.7595142924854, -122.446532051538)
90601 16813 3 43 2097X O'Farrell St 3 1 1 2     12 4X4   5999009.37837 2112716.355 37.7810586242256 -122.44706600273899 (37.7810586242256, -122.447066002739)
107022 109334 2 43 1313 CLAYTON ST 1 1 1 1     16 3x3   5999032.0 2105350.0 37.7608337776961 -122.446457634643 (37.7608337776961, -122.446457634643)
80196 120531 1 43 1390 Waller St 4 1 1 1       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634)
107309 120530 1 43 1390 Waller St 3 1 1 1       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634)
119156 58508 1 43 1390 Waller St 1 1 1 1   03/29/1979 12:00:00 AM   3x3 Permit Number 17683 5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634)
119985 120532 1 43 1390 Waller St 5 1 1 1       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634)
91377 109333 2 43 1317 CLAYTON ST 1 1 1 1     17 3x3   5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
99268 18696 3 43 251X Richardson Ave 3 11 1 2     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.44738946108299 (37.8006252370733, -122.447389461083)
127624 18698 3 43 251X Richardson Ave 5 11 1 2     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.44738946108299 (37.8006252370733, -122.447389461083)
142606 18697 3 43 251X Richardson Ave 4 11 1 2     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.44738946108299 (37.8006252370733, -122.447389461083)
112508 107659 2 43 1324 CLAYTON ST 1 1 1 1     14 3x3   5999078.1 2104991.6 37.759852333413 -122.446272413537 (37.759852333413, -122.446272413537)
129095 107660 2 43 1316 CLAYTON ST 1 1 1 1     15 3x3   5999083.9 2105040.7 37.759987481053294 -122.446255886285 (37.7599874810533, -122.446255886285)
91548 112578 2 43 660x Ashbury St 1 1 1 1       3x3   5999086.0 2108401.0 37.7692141419233 -122.446490377962 (37.7692141419233, -122.446490377962)
11026 173949 2 43 1306 Clayton St 1 1 1 1       3x3   5999102.0 2105133.0 37.760241947595404 -122.446199926833 (37.7602419475954, -122.446199926833)
12922 173948 2 43 1300 Clayton St 1 1 1 1       3x3   5999106.0 2105162.0 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838)
143704 50980 1 43 201 Richardson Ave 1 1 1 1   07/06/2004 12:00:00 AM   3x3 Permit Number 47465 5999116.7 2119758.3 37.8004000774175 -122.447201682136 (37.8004000774175, -122.447201682136)
101755 26159 1 43 210 Richardson Ave 2 1 1 1     12 3x3   5999117.59522 2119823.02413 37.800577843616 -122.447203245105 (37.800577843616, -122.447203245105)
107852 50854 1 43 1375 Waller St 1 1 1 1   04/08/2004 12:00:00 AM     Permit Number 47369 5999134.27629696 2108342.5104784 37.76905630179421 -122.44631918531799 (37.7690563017942, -122.446319185318)
94553 16728 3 43 1519 O'Farrell St 1 1 1 2     6 4X4   5999136.4110982 2112734.4359693 37.781115526981296 -122.446627836224 (37.7811155269813, -122.446627836224)
141191 16729 3 43 1519 O'Farrell St 2 1 1 2     12 4X4   5999136.4110982 2112734.4359693 37.781115526981296 -122.446627836224 (37.7811155269813, -122.446627836224)
102677 109882 2 43 1520 PAGE ST 4 1 1 1       6x8   5999172.7 2109108.7 37.7711622584795 -122.44624140323401 (37.7711622584795, -122.446241403234)
79990 111430 2 43 500X PRESIDIO AVE 1 1 1 1       3x3   5999200.0 2114887.0 37.7870295394193 -122.446562765799 (37.7870295394193, -122.446562765799)
97522 17088 3 43 1611 Oak St 3 1 1 2     18 3x3   5999244.55181 2109378.0663400004 37.77190597325 -122.446012243601 (37.77190597325, -122.446012243601)
111696 18684 3 43 165X Richardson Ave 2 1 1 2     12 3X3   5999250.42609 2119592.6225799997 37.7999528116563 -122.446727010779 (37.7999528116563, -122.446727010779)
138552 17085 1 43 1585 Oak St 1 1 1 1     12 3x3   5999415.39608 2109426.2103 37.7720479186519 -122.445424745443 (37.7720479186519, -122.445424745443)
9862 173716 6 43 1652 Fell St 1 8 1 1           5999516.0 2109850.0 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354)
88258 109000 2 43 525x BURNETT AVE 1 1 1 1     6 2x2 circle   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
108764 109005 2 43 525x BURNETT AVE 6 1 1 1       1x1   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
111519 109004 2 43 525x BURNETT AVE 5 1 1 1       1x1   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
112794 109003 2 43 525x BURNETT AVE 4 1 1 1       1x1   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
126595 109001 2 43 525x BURNETT AVE 2 1 1 1       1x1   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
144446 109002 2 43 525x BURNETT AVE 3 1 1 1       1x1   5999530.0 2102478.0 37.7529764040195 -122.44452886107901 (37.7529764040195, -122.444528861079)
85878 92850 1 43 3150 Washington St 6 1 1 1       4x4 Permit Number 53071 5999589.0 2116381.0 37.7911538835614 -122.44532437717501 (37.7911538835614, -122.445324377175)
116825 87134 1 43 65 Mars St 1 1 1 1       3x3 Permit Number 50103 5999603.0 2105413.0 37.761039357097104 -122.44448733345502 (37.7610393570971, -122.444487333455)
92584 1668 3 43 2679X LOMBARD ST 1 1 1 2     15 3X3   5999625.0 2119128.0 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769)
105367 1669 3 43 2679X LOMBARD ST 2 1 1 2     13 3X3   5999625.0 2119128.0 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769)
122468 108098 2 43 2800X Pierce St 2 1 1 1           5999639.0 2117762.0 37.794948598912704 -122.445250712888 (37.7949485989127, -122.445250712888)
82713 61493 1 43 3149 Washington St 1 1 1 1   07/19/1984 12:00:00 AM     Permit Number 777095 5999649.96958977 2116015.59113069 37.790154046975395 -122.445087143888 (37.7901540469754, -122.445087143888)
129314 98979 2 43 38 MILEY ST 1 1 1 1     3 3x3 Permit Number 778225 5999656.0 2118689.0 37.7974948649915 -122.44525857219999 (37.7974948649915, -122.4452585722)
102629 18083 1 43 2973 Pine St 1 1 1 1     12 3X3   5999723.95099 2114672.94601 37.7864717167835 -122.444734627115 (37.7864717167835, -122.444734627115)
110357 4014 1 43 1515X Oak St 2 1 1 1     12 3X3   5999764.24548 2109470.85295 37.772190404364096 -122.44422126053001 (37.7721904043641, -122.44422126053)
113651 57604 1 43 238 Hearst Ave 1 1 1 1   11/12/1976 12:00:00 AM   3x3 Permit Number 16491 5999828.22001193 2094390.77346711 37.730787818817504 -122.44291685523399 (37.7307878188175, -122.442916855234)
116080 110926 1 43 2970 Jackson St 1 1 1 1         Permit Number 775246 5999959.8 2116452.8 37.79137218692 -122.444046586367 (37.79137218692, -122.444046586367)
101098 116493 2 43 1946 BAKER ST 1 1 1 1       3x3   5999967.0 2115587.0 37.7889953375883 -122.44395943989299 (37.7889953375883, -122.443959439893)
122994 105343 1 43 2500X Post St 1 1 1 1           5999969.06573 2113691.8640900003 37.783791904828604 -122.443816082596 (37.7837919048286, -122.443816082596)
92303 13285 3 43 2576 Lombard St 2 1 1 2   10/26/1993 12:00:00 AM 3 3X3   6000068.810330001 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799)
93129 113767 2 43 1730 BAKER ST 2 1 1 1     14 3x3   6000110.0 2114968.0 37.7873038809733 -122.443420199664 (37.7873038809733, -122.443420199664)
139960 113763 2 43 1730 BAKER ST 1 1 1 1     12 3x3   6000110.0 2114968.0 37.7873038809733 -122.443420199664 (37.7873038809733, -122.443420199664)
79945 113775 2 43 1712 BAKER ST 1 1 1 1     7 3x3   6000121.0 2114885.0 37.7870766118482 -122.443376178084 (37.7870766118482, -122.443376178084)
87299 97999 2 43 30 Eagle St 1 1 1 1     12 3x3   6000135.0 2104379.0 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957)
93909 98001 2 43 30 Eagle St 3 1 1 1     12 3x3   6000135.0 2104379.0 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957)
2631 105340 1 43 1401 Baker St 2 1 1 1   02/21/2014 12:00:00 AM 12   Permit Number 770950 6000144.5 2113810.0 37.784126280525605 -122.44321763524201 (37.7841262805256, -122.443217635242)
102716 13308 3 43 300X Lyon St 1 11 1 2     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742)
103460 13309 3 43 300X Lyon St 2 11 1 2     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742)
120460 13310 3 43 300X Lyon St 3 11 1 2     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742)
87064 58078 1 43 4624 18th St 1 1 1 1   10/28/1977 12:00:00 AM     Permit Number 17049 6000401.0 2105218.0 37.7605494356876 -122.44171341046699 (37.7605494356876, -122.441713410467)
123064 110274 2 43 4624 18TH ST 1 1 1 1     22 3x3   6000413.0 2105241.0 37.7606132717498 -122.4416735587 (37.7606132717498, -122.4416735587)
86538 13307 3 43 1377X Oak St 3 1 1 2     18 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639)
92207 13306 3 43 1377X Oak St 2 1 1 2     12 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639)
144249 13305 3 43 1377X Oak St 1 1 1 2     18 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639)
88349 59060 1 43 4437 23rd St 1 1 1 1   07/28/1992 12:00:00 AM 14 2x2 Permit Number 30882 6000423.21385776 2102243.23045707 37.75238271007429 -122.441423120737 (37.7523827100743, -122.441423120737)
98164 112394 2 43 2 AMAZON AVE   1 1 1     16 3x3   6000472.0 2089324.0 37.7169122992795 -122.440327982322 (37.7169122992795, -122.440327982322)
120173 18035 3 43 2807 Pine St 1 1 1 2     12 3X3   6000503.4629009 2114781.5023211003 37.786814236904505 -122.442045513134 (37.7868142369045, -122.442045513134)
5440 13266 3 43 2460 Lombard St 3 1 1 2   10/26/1993 12:00:00 AM 70 3X3   6000592.3683 2119282.3787 37.7991775301158 -122.44206111460501 (37.7991775301158, -122.442061114605)
89324 57802 1 43 107 Hoffman Ave 1 1 1 1   08/26/1988 12:00:00 AM 8 3x3 Permit Number 25561 6000622.33928566 2102551.03510935 37.753239209170204 -122.44075659160102 (37.7532392091702, -122.440756591601)
108226 4883 3 43 87 Crags Ct 1 1 1 2     45 2X2   6000657.525159299 2098217.505729 37.7413423773337 -122.44032415487499 (37.7413423773337, -122.440324154875)
102747 62645 1 43 400 Baker St 1 1 1 1 1 07/25/1988 12:00:00 AM     Permit Number 25453 6000705.45672766 2110331.40246789 37.7746069085927 -122.441027287197 (37.7746069085927, -122.441027287197)
101647 58071 1 43 4545 18th St 1 1 1 1   10/28/1977 12:00:00 AM 13   Permit Number 17041 6000791.5456109 2105188.83821507 37.760491609105294 -122.44036060348101 (37.7604916091053, -122.440360603481)
Powered by Datasette · Query took 17.38ms · Data source: data.sfgov.org