sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6478 98738 2 5 1150 Scott St 2 1 1 20 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
79819 95474 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986559.68186 2112141.60911 37.7787613662348 -122.490092832202 (37.7787613662348, -122.490092832202)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
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)
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)
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)
81972 98746 2 26 540X Eureka St 3 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
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)
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)
83482 95466 2 2 529X 30th Ave 1 1 1 4 2   5 3x3   5986555.1 2112324.8 37.7792640886788 -122.490122160768 (37.7792640886788, -122.490122160768)
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)
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)
84174 95453 2 2 601X 30th Ave 5 1 1 4 2   6 3x3   5986555.22372 2112267.25724 37.7791060998783 -122.49011749902701 (37.7791060998783, -122.490117499027)
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)
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)
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)
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)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
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)
88215 95470 2 2 539X 30th Ave 1 1 1 4 2   4 3x3   5986557.7 2112257.8 37.7790802775989 -122.49010823686399 (37.7790802775989, -122.490108236864)
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)
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)
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)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
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)
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)
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)
94912 98754 2 26 540X Eureka St 11 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
95866 95478 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986565.85749 2112005.2728 37.7783873861575 -122.49006143788601 (37.7783873861575, -122.490061437886)
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)
96989 95473 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986560.12785 2112162.57896 37.778818969517495 -122.490092832211 (37.7788189695175, -122.490092832211)
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)
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)
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)
100398 95454 2 2 601X 30th Ave 6 1 1 4 2   6 3x3   5986556.01855 2112243.67907 37.7790414073553 -122.49011301465099 (37.7790414073553, -122.490113014651)
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)
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)
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)
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)
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)
104766 95472 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986558.09049 2112203.93573 37.7789324044573 -122.49010292295799 (37.7789324044573, -122.490102922958)
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)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
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)
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)
107741 95468 2 41 535X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3 53267 5986556.7 2112284.6 37.7791538043677 -122.49011366804301 (37.7791538043677, -122.490113668043)
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)
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)
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)
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)
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)
114491 95467 2 2 533X 30th Ave 1 1 1 4 2   4 3x3   5986556.1 2112298.0 37.779190561911896 -122.490116729573 (37.7791905619119, -122.490116729573)
114699 98740 2 5 1150 Scott St 4 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
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)
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)
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)
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)
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)
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)
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)
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)
118859 95476 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986563.84754 2112047.92011 37.778504366165 -122.490071528655 (37.778504366165, -122.490071528655)
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)
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)
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)
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)
122089 95477 2 2 601X 30th Ave 1 1 1 4 2   8 3x3   5986565.00775 2112026.27031 37.7784449897253 -122.490065922262 (37.7784449897253, -122.490065922262)
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)
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)
124700 95475 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986561.73612 2112070.55828 37.7785664008394 -122.490080498329 (37.7785664008394, -122.490080498329)
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)
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)
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)
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)
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)
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)
126702 98737 2 5 1150 Scott St 1 1 1 20 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 44.309ms · Data source: data.sfgov.org