sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4367 253150 3 48 450X Moscow St 3 5 1 4 2 10/11/2017 09:41:00 AM 3 3x3   6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
4809 253146 3 11 260 Madrid St 12 1 1 4 2 10/25/2017 04:29:00 PM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814)
1706 192430 3 44 340 06th St 1 1 1 2 2   9 Width 3ft   6011111.5516 2111334.7393 37.7779490450386 -122.405101020214 (37.7779490450386, -122.405101020214)
9739 173683 3 103 450x Raymond Ave 2 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
2240 122755 3 55 693 Vermont St 3 1 1 4 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
2219 122754 3 55 693 Vermont St 4 1 1 4 2   16     6011277.363419999 2105334.1858 37.761482160689894 -122.404105006665 (37.7614821606899, -122.404105006665)
2232 122753 3 13 693 Vermont St 5 1 1 4 2   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421)
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
156514 122751 3 32 693 Vermont St 7 1 1 4 2   18     6011280.99043 2105260.13165 37.7612790272197 -122.40408725043301 (37.7612790272197, -122.404087250433)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2233 122749 3 94 693 Vermont St 9 1 1 4 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
172027 116857 2 44 950x Clay St 10 1 1 4 2   2 3x3   6010080.350930001 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981)
89093 116527 3 41 5732 GEARY BLVD 1 2 1 6 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
127092 116522 3 1 324 08TH AVE 1 5 1 6 2   8 3x3   5993416.0 2113304.0 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407)
77797 116382 1 21 2501 25th St 3 1 1 11 2     3x3   6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671)
170121 116065 3 32 693 Vermont St 2 1 1 4 2   20 8x7   6011274.01561 2105377.63125 37.761601265113896 -122.404119643106 (37.7616012651139, -122.404119643106)
136374 116064 3 133 693 Vermont St 1 1 1 4 2   6 8x7   6011272.30638 2105412.17877 37.761696029365794 -122.404127986133 (37.7616960293658, -122.404127986133)
65849 116063 2 440 2100x 19th St 7 1 1 4 2   19 3x3   6011332.66531 2105125.78364 37.760913024731295 -122.403899073603 (37.7609130247313, -122.403899073603)
24331 116062 2 32 2100x 19th St 6 1 1 4 2   22 3x3   6011361.02056 2105129.82914 37.7609257168785 -122.40380128939199 (37.7609257168785, -122.403801289392)
64195 116061 2 130 2100x 19th St 5 1 1 4 2   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115)
46988 116060 2 55 2100x 19th St 4 1 1 4 2   7 3x3   6011408.71891 2105130.5396 37.7609303321981 -122.403636370817 (37.7609303321981, -122.403636370817)
166938 116059 2 44 2100x 19th St 3 1 1 4 2   2 3x3   6011431.5308 2105131.75607 37.760934946603605 -122.40355755965099 (37.7609349466036, -122.403557559651)
158398 116058 2 44 2100x 19th St 2 1 1 4 2   2 3x3   6011458.59484 2105134.56728 37.760944177262004 -122.403464154268 (37.760944177262, -122.403464154268)
130071 116057 2 44 2100x 19th St 1 1 1 4 2   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266001 (37.760947638753, -122.40338680266)
129870 116056 2 5 650x Kansas St 12 1 1 4 2   23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449)
15372 116055 2 1 650x Kansas St 11 1 1 4 2 06/30/2016 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.40328006754801 (37.7611252557522, -122.403280067548)
132178 116054 2 32 650x Kansas St 10 1 1 4 2   23 4x4   6011511.93551 2105220.59815 37.761183378041395 -122.403285723377 (37.7611833780414, -122.403285723377)
35622 116053 2 32 650x Kansas St 9 1 1 4 2   11 4x4   6011508.109619999 2105241.51829 37.761240606399795 -122.40330042728901 (37.7612406063998, -122.403300427289)
128247 116052 2 5 650x KANSAS ST 8 1 1 4 2     4x4   6011530.0 2105347.0 37.761531458187 -122.403232137637 (37.761531458187, -122.403232137637)
25232 116051 2 12 650x Kansas St 7 1 1 4 2   3 4x4   6011500.28754 2105307.1354099996 37.761420339490705 -122.40333209689699 (37.7614203394907, -122.403332096897)
163065 116050 2 12 650x Kansas St 6 1 1 4 2   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949)
30215 116049 2 55 650x Kansas St 5 1 1 4 2   5 4x4   6011498.3385 2105356.0244 37.761554468880206 -122.403342277248 (37.7615544688802, -122.403342277248)
168957 116048 2 1 650x Kansas St 4 1 1 4 2   9 4x4   6011498.51602 2105372.79225 37.7616005195649 -122.403342842915 (37.7616005195649, -122.403342842915)
58238 116047 2 70 650x Kansas St 3 1 1 4 2   11 5x12   6011496.1211 2105415.8281900003 37.761718552879 -122.403354153666 (37.761718552879, -122.403354153666)
158318 116046 2 12 650x Kansas St 2 1 1 4 2   4 5x15   6011495.20108 2105434.8979700003 37.761770862847705 -122.40335867726002 (37.7617708628477, -122.40335867726)
186618 115552 2 52 925x Minnesota St 4 1 1 4 2   6 15x7   6015276.56251 2104229.2059299997 37.7586707630633 -122.390196112573 (37.7586707630633, -122.390196112573)
24594 115551 2 46 925x Minnesota St 3 1 1 4 2   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.39019037219299 (37.7585616474178, -122.390190372193)
155253 115550 2 46 925x Minnesota St 2 1 1 4 2   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.39018178636199 (37.7584697654838, -122.390181786362)
180919 115549 2 46 925x Minnesota St 1 1 1 4 2   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412)
119479 113827 2 49 1599x CASTRO ST 5 1 1 4 2 02/16/2016 05:50:00 AM 3 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078)
96908 113825 2 61 1599x CASTRO ST 3 1 1 4 2 11/10/2015 12:00:00 AM 8 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078)
140600 113574 2 43 901 LOMBARD ST 5 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
89957 113573 2 43 901 LOMBARD ST 4 1 1 4 2     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251)
143933 113572 2 21 901 LOMBARD ST 3 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
105856 113571 2 21 901 LOMBARD ST 2 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
108157 113570 2 21 901 LOMBARD ST 1 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
120376 112063 2 37 1199 VISITACION AVE 5 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
104096 112062 2 37 1199 VISITACION AVE 4 1 1 4 2 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
141095 112061 2 37 1199 VISITACION AVE 3 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140135 112060 2 37 1199 VISITACION AVE 2 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
123118 112058 2 37 1199 VISITACION AVE 1 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
29352 110960 1 26 940 Filbert St 7 1 1 4 2   10 5x5   6008419.49323 2119686.5094 37.8007301081687 -122.415005118088 (37.8007301081687, -122.415005118088)
67897 110959 1 26 940 Filbert St 6 1 1 4 2   10 5x5   6008435.0253800005 2119688.1206900002 37.800735405160296 -122.414951484348 (37.8007354051603, -122.414951484348)
166820 110958 1 26 940 Filbert St 5 1 1 4 2   11 5x5   6008447.06762 2119689.6105 37.8007401724743 -122.414909918573 (37.8007401724743, -122.414909918573)
72275 110957 1 26 940 Filbert St 4 1 1 4 2   9 5x5   6008462.007069999 2119690.6551900003 37.800743880377205 -122.41485829568998 (37.8007438803772, -122.41485829569)
73832 110956 1 26 940 Filbert St 3 1 1 4 2   7 5x5   6008474.06115 2119692.72385 37.800750237701294 -122.414816729923 (37.8007502377013, -122.414816729923)
152078 110955 1 26 940 Filbert St 2 1 1 4 2   9 5x5   6008486.881990001 2119694.39066 37.8007555347125 -122.41477248237699 (37.8007555347125, -122.414772482377)
55870 108611 2 26 2025x Taylor St 3 1 1 4 2   1 3x3   6008581.83386 2119799.52206 37.8010495338737 -122.414451351572 (37.8010495338737, -122.414451351572)
18479 107887 3 44 941 Washington St 5 1 1 4 2 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
141932 107886 3 44 941 Washington St 4 1 1 4 2 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
109673 107885 3 44 941 Washington St 3 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
103298 107884 3 44 941 Washington St 2 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
121513 107883 3 44 941 Washington St 1 1 1 4 2         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
8790 105143 2 35 432 Octavia St 1 1 1 3 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)
80252 102194 2 55 3999X Folsom St 10 1 1 4 2   4 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
107003 102193 2 55 3999X Folsom St 8 1 1 4 2   18 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
142731 102192 2 55 3999X Folsom St 7 1 1 4 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
101877 102191 2 55 3999X Folsom St 5 1 1 4 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
83864 102190 2 55 3999X Folsom St 6 1 1 4 2   6 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
127620 102189 2 55 3999X Folsom St 4 1 1 4 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
118717 102187 2 5 3999X Folsom St 2 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
86000 102186 2 5 3999X Folsom St 1 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
122742 102156 2 55 450X Banks St 11 1 1 4 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
94860 102155 2 55 450X Banks St 10 1 1 4 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
101167 102154 2 55 450X Banks St 9 1 1 4 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
106838 102115 3 2 1035 Gilman Ave 5 1 1 4 2   6 3x3 Permit Number 52469 6015181.7 2089440.8 37.7180595657824 -122.389491420596 (37.7180595657824, -122.389491420596)
111333 102034 2 37 165X Chattanooga St 14 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
125030 102033 2 37 165X Chattanooga St 13 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
99976 102032 2 37 165X Chattanooga St 12 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
118157 102031 2 37 165X Chattanooga St 11 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
80671 102030 2 37 165X Chattanooga St 10 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
103838 102029 2 37 165X Chattanooga St 9 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
126295 102028 2 37 165X Chattanooga St 8 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
105164 102027 2 37 165X Chattanooga St 7 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
140326 102026 2 37 165X Chattanooga St 6 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
92210 102025 2 37 165X Chattanooga St 5 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
127011 102024 2 37 165X Chattanooga St 4 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
142587 102023 2 37 165X Chattanooga St 3 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
128300 102022 2 37 165X Chattanooga St 2 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
5819 99697 3 26 1451 Jackson St 3 1 1 4 2   10 3x3   6007296.6569 2117418.12417 37.794438530258 -122.41872964778099 (37.794438530258, -122.418729647781)
5496 99696 3 26 1451 Jackson St 1 1 1 4 2   24 3x3   6007201.17567 2117403.71838 37.794393599230204 -122.41905900288799 (37.7943935992302, -122.419059002888)
80447 99695 3 26 1550X Washington St 6 1 1 4 2   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
107450 99694 3 26 1550X Washington St 5 1 1 4 2   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
91461 99693 3 26 1550X Washington St 4 1 1 4 2   12 3x3   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
72161 99692 3 26 1550X Washington St 3 1 1 4 2   8 2x2   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
125278 99691 3 26 1550X Washington St 2 1 1 4 2   14 3x3   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
Powered by Datasette · Query took 8.869ms · Data source: data.sfgov.org