sf-trees

Data source: data.sfgov.org

Custom SQL query returning 46 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185 251243 2 58 299x Chapman St 1 1 1 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
6711 31341 1 58 430 Hayes St 2 1 1 1   12/29/2014 12:00:00 AM 3 3x3 Permit Number 772811 6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703)
9782 159354 4 58 417x Ellington Ave 1 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.44701212372802 (37.7119283225022, -122.447012123728)
10397 108837 1 58 699 Paris St 2 1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001210.74249 2089636.42248 37.7178121756617 -122.437796877731 (37.7178121756617, -122.437796877731)
10903 110032 1 58 630 Edinburgh St 1 1 1 1 1 03/19/2015 12:00:00 AM 3 3x3 Permit Number 775191 6002420.02658 2090107.3938799999 37.719174047824104 -122.433650566035 (37.7191740478241, -122.433650566035)
11143 109071 1 58 35 Mount Vernon Ave 1 1 1 1 1 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772757 5999530.156 2088703.36466 37.715154504538795 -122.443538910497 (37.7151545045388, -122.443538910497)
12013 116582 1 58 195 Maynard St 1 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778001 6004664.28928 2093799.33843 37.729438402445105 -122.426155697039 (37.7294384024451, -122.426155697039)
12022 108898 1 58 378 Allison St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772818 6000293.95374 2086893.3367700002 37.7102281038126 -122.440769142495 (37.7102281038126, -122.440769142495)
12119 102524 1 58 154 Wilde Ave 1 1 1 1   07/03/2013 12:00:00 AM 16 3x3 Permit Number 770317 6011839.9295 2088903.3705900002 37.7163980403033 -122.401004803454 (37.7163980403033, -122.401004803454)
12216 108836 1 58 699 Paris St 1 1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001204.89947 2089626.81587 37.717785465811296 -122.437816386741 (37.7177854658113, -122.437816386741)
12503 93870 1 58 400-422X Tocoloma Ave 3 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012462.01959 2086667.4072599998 37.7102932120209 -122.398697717749 (37.7102932120209, -122.398697717749)
12527 108378 1 58 358 Edinburgh St 2 1 1 1 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773808 6003377.41913 2091635.77484 37.7234249209965 -122.43045021882 (37.7234249209965, -122.43045021882)
12634 109574 1 58 400 France Ave 1 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002013.87176 2089826.5009400002 37.7183797243364 -122.435034407708 (37.7183797243364, -122.435034407708)
13070 93869 1 58 400-422X Tocoloma Ave 2 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012466.99875 2086683.8296 37.7103385819422 -122.398681660343 (37.7103385819422, -122.398681660343)
13992 108725 1 58 877 Rhode Island St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773104 6011895.30838 2104315.65478 37.758720008153 -122.401896177292 (37.758720008153, -122.401896177292)
16644 80780 1 58 702 Vermont St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773102 6011234.66837 2105019.04099 37.760614457905795 -122.404230490851 (37.7606144579058, -122.404230490851)
40968 91228 1 58 250 Texas St 2 1 1 1   02/02/2010 12:00:00 AM 4 3x3 Permit Number 53161 6013714.91861 2105876.83519 37.7631080513185 -122.39571247215 (37.7631080513185, -122.39571247215)
45347 108716 1 58 201 Randall St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773302 6004213.21698 2097517.4141599997 37.73962189424871 -122.427979939698 (37.7396218942487, -122.427979939698)
79940 37260 1 58 801X Church St 3 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
83513 102091 1 58 27 Santa Ana Ave 3 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
83692 109401 2 58 1588 WALLER ST 4 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
84993 117424 2 58 600x POWHATTAN AVE 1 1 1 1     2 3x3   6008524.0 2098073.0 37.7413903494898 -122.41311433102699 (37.7413903494898, -122.413114331027)
90437 109398 2 58 1588 WALLER ST 1 1 1 1   02/13/2015 12:00:00 AM 3 3x3 Permit Number 774632 5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
91902 91227 1 58 250 Texas St 1 1 1 1   02/02/2010 12:00:00 AM   3x3 Permit Number 53161 6013717.0 2105930.0 37.763254145992796 -122.39570899856199 (37.7632541459928, -122.395708998562)
94670 109400 2 58 1588 WALLER ST 3 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
96969 109399 2 58 1588 WALLER ST 2 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
97134 122681 2 58 598x Powhattan Ave 3 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
97304 37262 1 58 801X Church St 4 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
105253 109313 1 58 3261 Harrison St 1 1 1 1 1 01/05/2016 12:00:00 AM   3x3 Permit Number 771278 6009056.2 2099704.9 37.745901050724 -122.411389421874 (37.745901050724, -122.411389421874)
107044 107197 6 58 339 Kirkham St 1 8 1 1   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.5874099997 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688)
109034 88642 1 58 637 Noe St   1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51602 6003051.0 2104517.0 37.758775291756294 -122.43249820666401 (37.7587752917563, -122.432498206664)
110009 108903 1 58 200 Cordova St 1 1 1 1 1     3x3 Permit Number 772783 6001785.77868 2087307.18495 37.7114492867677 -122.43564268921001 (37.7114492867677, -122.43564268921)
112848 37261 1 58 801X Church St 1 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
114122 102090 1 58 27 Santa Ana Ave 2 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
116475 109575 1 58 400 France Ave 2 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002004.0 2089808.9 37.7183308355338 -122.43506727205299 (37.7183308355338, -122.435067272053)
118878 108906 1 58 214 Bradford St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772968 6009519.2 2097295.6 37.7393115967784 -122.40961840488701 (37.7393115967784, -122.409618404887)
122286 97347 1 58 1130 Cole St 1 1 1 1   09/22/2011 12:00:00 AM   3x3 Permit Number 768267 5998216.1 2106370.5 37.7635891788793 -122.449352986262 (37.7635891788793, -122.449352986262)
125228 109402 2 58 1588 WALLER ST 5 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
125714 102089 1 58 27 Santa Ana Ave 1 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
127137 122679 2 58 598x Powhattan Ave 1 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
129111 51597 1 58 1478 Masonic Ave 1 1 1 1   03/04/2005 12:00:00 AM   3x3 Permit Number 47890 5999641.13876025 2107457.97579425 37.766656526924294 -122.444502404738 (37.7666565269243, -122.444502404738)
140417 108905 1 58 200 Cordova St 2 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772783 6001785.8 2087307.2 37.7114493293027 -122.43564261659901 (37.7114493293027, -122.435642616599)
140864 53611 1 58 2266 15th Ave 1 1 1 1   12/18/1969 12:00:00 AM   3x3 Permit Number 50102 5991755.89113084 2099997.75858136 37.7457196459604 -122.47123227110201 (37.7457196459604, -122.471232271102)
144281 122680 2 58 598x Powhattan Ave 2 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
167905 94813 1 58 2948 Fillmore St 1 1 1 1   11/09/2010 12:00:00 AM 2 3x3 Permit Number 53896 6002515.07841 2118365.04564 37.7967681547718 -122.43534223486799 (37.7967681547718, -122.435342234868)
184518 39934 1 58 186 Arleta Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 3 3x3 Permit Number 41205 6010249.35801 2088014.8431799999 37.7138694695674 -122.40644005139299 (37.7138694695674, -122.406440051393)
Powered by Datasette · Query took 4.544ms · Data source: data.sfgov.org