sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10282 173941 2 36 3750 18th St 4 1 1 4       3x3   6004590.0 2105440.0 37.7613967828987 -122.42724138037701 (37.7613967828987, -122.427241380377)
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)
42976 113471 2 59 450 CHURCH ST 28 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
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)
63146 75990 2 273 350 Broadway 1 1 1 4 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
63419 106952 2 17 399X SOMERSET ST 1 1 1 4       3x3   6009953.0 2092875.0 37.7271978698015 -122.40780687976499 (37.7271978698015, -122.407806879765)
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)
77944 95496 2 2 600X 32nd Ave 2 1 1 4     5 3x3   5986002.12653 2111683.71465 37.7774715436696 -122.491987885766 (37.7774715436696, -122.491987885766)
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)
79513 95519 2 51 600X 32nd Ave 1 1 1 4     5 3x3   5985993.74648 2111883.3180400003 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445)
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)
80997 113469 2 59 450 CHURCH ST 26 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
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)
87131 113474 2 59 450 CHURCH ST 31 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
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)
87843 95499 2 60 600X 32nd Ave 21 1 1 4     18 3x3   5985977.73249 2112402.27637 37.7794430828921 -122.49212519236 (37.7794430828921, -122.49212519236)
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)
89483 113468 2 59 450 CHURCH ST 4 1 1 4   06/21/2016 02:14:00 PM 3 6x7   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
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)
91382 95488 2 51 600X 32nd Ave 10 1 1 4     6 3x3   5986007.7101 2111508.12486 37.776989750535 -122.491955639862 (37.776989750535, -122.491955639862)
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)
92566 113466 2 59 450 CHURCH ST 2 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
93185 95510 2 37 500X 32nd Ave 10 1 1 4   02/19/2015 02:35:00 PM 3 3x3   5985969.9 2112493.2 37.7796922752829 -122.49215898451901 (37.7796922752829, -122.492158984519)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
93377 95497 2 51 600X 32nd Ave 1 1 1 4     6 3x3   5985999.2312900005 2111660.71954 37.777408236422296 -122.491996207782 (37.7774082364223, -122.491996207782)
93703 97898 2 49 375X Precita Ave 4 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
93918 95500 2 11 600X 32nd Ave 20 1 1 4     8 3x3   5985980.30461 2112381.8602 37.779387176289504 -122.49211479078899 (37.7793871762895, -122.492114790789)
94030 95491 2 51 600X 32nd Ave 7 1 1 4     3 3x3   5986009.30138 2111441.61533 37.776807227327396 -122.491945237383 (37.7768072273274, -122.491945237383)
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)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
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)
96050 113472 2 59 450 CHURCH ST 29 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
96578 95515 2 51 600X 32nd Ave 5 1 1 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045)
96802 95494 2 51 600X 32nd Ave 4 1 1 4     3 3x3   5986000.13497 2111717.2940599998 37.7775636267397 -122.491997248036 (37.7775636267397, -122.491997248036)
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)
96961 97902 2 62 375X Precita Ave 8 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
97325 97901 2 62 375X Precita Ave 7 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
99549 97896 2 49 375X Precita Ave 2 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
101527 95518 2 51 600X 32nd Ave 2 1 1 4     5 3x3   5985992.056890001 2111902.81718 37.778072548088495 -122.49203885528601 (37.7780725480885, -122.492038855286)
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)
102729 95507 2 11 600X 32nd Ave 13 1 1 4     10 3x3   5985983.58763 2112182.96811 37.778841267423296 -122.492088785464 (37.7788412674233, -122.492088785464)
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)
106045 95504 2 37 600X 32nd Ave 16 1 1 4     3 3x3   5985982.4173 2112269.2292400002 37.779078047402294 -122.492099187045 (37.7790780474023, -122.492099187045)
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)
107004 95516 2 51 600X 32nd Ave 4 1 1 4     5 3x3   5985994.45155 2111944.6872400003 37.778187651292896 -122.492033654948 (37.7781876512929, -122.492033654948)
107506 95505 2 37 600X 32nd Ave 15 1 1 4     3 3x3   5985982.87909 2112248.55872 37.7790213190615 -122.49209606719299 (37.7790213190615, -122.492096067193)
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)
107934 95238 2 26 1220 Noe St 5 1 1 4 4     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
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)
108047 95503 2 11 600X 32nd Ave 17 1 1 4     8 3x3   5985983.49633 2112291.6636099997 37.7791397088392 -122.49209710655701 (37.7791397088392, -122.492097106557)
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)
108571 95509 2 51 600X 32nd Ave 11 1 1 4   02/19/2015 02:37:00 PM 3 3x3   5985988.58257 2112092.73248 37.7785937981587 -122.492064860632 (37.7785937981587, -122.492064860632)
108801 98744 2 16 540X Eureka St 1 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
109167 97897 2 49 375X Precita Ave 3 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
110535 95495 2 60 600X 32nd Ave 3 1 1 4     6 3x3   5986000.954969999 2111699.3103 37.7775142963957 -122.49199308703699 (37.7775142963957, -122.491993087037)
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)
Powered by Datasette · Query took 76.559ms · Data source: data.sfgov.org