sf-trees

Data source: data.sfgov.org

Custom SQL query returning 29 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7743 121449 6 2 1274 Filbert St 1 7 1 1     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562)
9444 173598 6 123 1771 11th Ave 1 5 1 1     12 3x3   5992768.0 2103420.0 37.7551747322674 -122.467981458634 (37.7551747322674, -122.467981458634)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10991 116458 6 267 777 Brotherhood Way 1 2 1 1     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
20387 121368 6 142 245 Mallorca Way 1 1 1 1     12 3x3 Permit Number 778992 6001431.0 2120732.0 37.8032055622797 -122.439263127997 (37.8032055622797, -122.439263127997)
58626 101743 6 15 1590 Broadway 4 7 1 1   12/21/2012 12:00:00 AM 12   Permit Number 769428 6006129.33795 2117976.30804 37.795905370388205 -122.422808406898 (37.7959053703882, -122.422808406898)
77206 107056 6 26 601X Davis St 1 7 1 1   07/23/2014 12:00:00 AM 12   Permit Number 771755 6013142.97136 2118525.3196099997 37.797806054267895 -122.39857828598 (37.7978060542679, -122.39857828598)
80137 101978 6 25 25X Tiffany Ave 1 7 1 1     12     6006502.0 2099737.0 37.7458455996049 -122.420223786963 (37.7458455996049, -122.420223786963)
81326 99859 6 193 4443 19th St 1 7 1 1     12     6001193.1 2104609.9 37.7589248414166 -122.43893032447399 (37.7589248414166, -122.438930324474)
82400 115123 6 11 499X MAIN ST 1 1 1 1     12     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
90057 111634 6 142 3009 26th St 1 1 1 1 1   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187)
93681 96767 6 94 2229 Webster St 1 1 1 1     12   Permit Number 768245 6003236.0 2116309.0 37.7911636966224 -122.43270073645701 (37.7911636966224, -122.432700736457)
98300 94851 6 5 1107 Bowdoin St 2 7 1 1   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
102600 106362 6 116 1645 WEBSTER ST 1 7 1 1     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178)
102912 119613 6 125 2X Sutter St 1 5 1 1     12 3x3   6012582.0 2115890.0 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
104664 122689 6 364 2590 Pacific Ave 2 7 1 1     12 3x8   6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
111867 112057 6 62 762 FUNSTON AVE 2 1 1 1 1   12     5991999.0 2110277.0 37.773957792878704 -122.47114039751001 (37.7739577928787, -122.47114039751)
114111 112626 6 11 3430X 23rd St 2 1 1 1     12     6006285.0 2102686.4 37.753931748244604 -122.421183538041 (37.7539317482446, -122.421183538041)
115729 105234 6 41 250 STATES ST 5 7 1 1     12     6000595.6 2106681.2 37.7645781078798 -122.441145360444 (37.7645781078798, -122.441145360444)
120572 113234 6 21 2023 43RD AVE 1 7 1 1     12 3x3   5982877.0 2101339.0 37.748884737458795 -122.50203289923901 (37.7488847374588, -122.502032899239)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
140509 114146 6 140 1200x JUNIPERO SERRA BLVD 3 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
141088 115806 6 169 362 MISSOURI ST 1 8 1 1     12 3x3   6013446.0 2105415.0 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
175351 106611 6 28 1154 Rhode Island St 1 1 1 1     12 4x4   6011908.79849 2103025.7220099997 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609)
Powered by Datasette · Query took 14.899ms · Data source: data.sfgov.org