sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
80947 73875 2 191 450X Banks St 2 1 1 4 2 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
98194 70472 2 46 450X Banks St 6 1 1 4 2 06/18/1994 12:00:00 AM 4 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
100018 78992 2 55 450X Banks St 3 1 1 4 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
101641 78999 2 55 555 Tompkins Ave 2 1 1 4 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
111619 74109 2 55 555 Tompkins Ave 1 1 1 4 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
114913 73421 2 9 450X Banks St 5 1 1 4 2 06/18/1994 12:00:00 AM 10 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
118133 73874 2 55 450X Banks St 4 1 1 4 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
120907 78998 2 18 450X Banks St 1 1 1 4 2 06/18/1994 12:00:00 AM 6 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
126186 70471 2 60 450X Banks St 7 1 1 4 2 06/18/1994 12:00:00 AM 32 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
126306 70470 2 55 450X Banks St 8 1 1 4 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
140063 74108 2 55 555 Tompkins Ave 3 1 1 4 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
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)
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)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 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)
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)
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)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
81972 98746 2 26 540X Eureka St 3 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
90673 98752 2 26 540X Eureka St 9 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
92105 98750 2 26 540X Eureka St 7 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
94912 98754 2 26 540X Eureka St 11 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
108801 98744 2 16 540X Eureka St 1 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
110614 98755 2 26 540X Eureka St 12 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
110736 98753 2 26 540X Eureka St 10 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
138350 98747 2 26 540X Eureka St 4 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
139365 98751 2 26 540X Eureka St 8 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
141772 98748 2 26 540X Eureka St 5 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
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)
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)
94066 77325 2 37 165X Chattanooga St 1 1 1 4 2 11/18/1988 12:00:00 AM 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
127891 95465 2 41 601X 30th Ave 2 1 1 4 2   8 3x3   5986594.5418 2111220.3413400003 37.7762338621769 -122.489904464478 (37.7762338621769, -122.489904464478)
118537 95464 2 2 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986592.75422 2111242.97331 37.7762958987751 -122.48991231304501 (37.7762958987751, -122.489912313045)
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)
87154 95463 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727)
120350 95462 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986590.675530001 2111282.39545 37.776404019422294 -122.489922403821 (37.7764040194223, -122.489922403821)
126367 95461 2 2 601X 30th Ave 1 1 1 4 2   10 3x3   5986588.1418 2111391.86812 37.776704452390796 -122.489939222082 (37.7767044523908, -122.489939222082)
86703 95460 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.77677535046679 -122.489949313769 (37.7767753504668, -122.489949313769)
82909 95459 2 60 657X 30th Ave 1 1 1 4 2   18 3x3   5986588.2 2111449.2 37.776861872872 -122.48994323847201 (37.776861872872, -122.489943238472)
127043 95458 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986582.44659 2111474.61787 37.7769313271764 -122.48996501092199 (37.7769313271764, -122.489965010922)
115568 95457 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986582.95432 2111498.49198 37.776996908357 -122.48996501091601 (37.776996908357, -122.489965010916)
107984 95456 2 26 601X 30th Ave 1 1 1 4 2   3 3x3   5986576.02446 2111660.34524 37.7774409068096 -122.49000089052099 (37.7774409068096, -122.490000890521)
83153 95455 2 2 601X 30th Ave 1 1 1 4 2   8 3x3   5986575.69735 2111690.69221 37.777524211869896 -122.490004254704 (37.7775242118699, -122.490004254704)
124734 95452 2 2 601X 30th Ave 4 1 1 4 2   6 3x3   5986573.32223 2111731.4109099996 37.7776358751612 -122.490015466607 (37.7776358751612, -122.490015466607)
83563 95451 2 2 601X 30th Ave 3 1 1 4 2   6 3x3   5986574.08529 2111752.05161 37.777692593218106 -122.49001434550101 (37.7776925932181, -122.490014345501)
94177 95450 2 2 601X 30th Ave 2 1 1 4 2   3 3x3   5986571.54012 2111769.53516 37.777740449455294 -122.49002443626999 (37.7777404494553, -122.49002443627)
78146 95448 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986572.26887 2111788.56268 37.777792736173794 -122.49002331517599 (37.7777927361738, -122.490023315176)
118347 95483 2 2 601X 30th Ave 1 1 1 4 2   5 3x3   5986569.82886 2111856.71768 37.777979727950296 -122.490036770148 (37.7779797279503, -122.490036770148)
85371 95482 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986568.36529 2111879.34223 37.7780417630679 -122.49004349761299 (37.7780417630679, -122.490043497613)
115273 95481 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986568.37611 2111910.32722 37.778126839673 -122.490045739805 (37.778126839673, -122.490045739805)
77973 95480 2 2 601X 30th Ave 1 1 1 4 2   8 3x3   5986567.36684 2111939.07455 37.7782057127303 -122.490051346189 (37.7782057127303, -122.490051346189)
84851 95479 2 2 601X 30th Ave 1 1 1 4 2   10 3x3   5986565.4115 2111984.30283 37.7783297825409 -122.490061437893 (37.7783297825409, -122.490061437893)
Powered by Datasette · Query took 95.777ms · Data source: data.sfgov.org