sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
344 251279 3 76 1200x Hudson Ave 8 1 1 2 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
358 251286 3 20 1299x Hudson Ave 7 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
375 251284 3 20 1299x Hudson Ave 5 1 1 2 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
385 251282 3 20 1299x Hudson Ave 1 1 1 2 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
390 251276 3 37 1175X Hudson Ave 4 1 1 2 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 3 37 1175x Hudson Ave 1 1 1 2 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
392 251280 3 20 1275x Hudson Ave 1 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
393 251277 3 76 1200x Hudson Ave 3 1 1 2 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
398 251281 3 20 1275x Hudson Ave 4 1 1 2 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 3 20 1299x Hudson Ave 9 1 1 2 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
409 251278 3 76 1200x Hudson Ave 4 1 1 2 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
445 251285 3 11 1299x Hudson Ave 2 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
498 248943 3 87 1500x Galvez Ave 6 1 1 2 3 04/10/2017 01:08:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
499 248944 3 87 1500x Galvez Ave 3 1 1 2 3 04/10/2017 12:58:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
507 251288 3 90 1335 Fairfax Ave 9 1 1 2 3 03/18/2017 01:58:00 PM 3 3x3   6016828.0 2097292.0 37.7397085577181 -122.38434732981199 (37.7397085577181, -122.384347329812)
517 248948 3 87 1500x Galvez Ave 18 1 1 2 3 04/10/2017 01:15:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
525 248950 3 87 1500x Galvez Ave 26 1 1 2 3 04/10/2017 01:18:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
527 248946 3 87 1500x Galvez Ave 13 1 1 2 3 04/10/2017 01:12:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
528 248942 3 88 1500x Galvez Ave 1 1 1 2 3 03/18/2017 12:56:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
679 187631 3 37 4255x Judah St 2 1 1 2 3 03/28/2017 11:56:00 AM 3 3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
746 251371 3 43 390 06th St 3 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
750 251368 3 111 270 06th St 7 1 1 2 3     3x3   6010822.0 2111616.0 37.7787051302825 -122.40612250689199 (37.7787051302825, -122.406122506892)
781 251370 3 44 390 06th St 2 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
786 251369 3 43 390 06th St 1 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
975 251421 3 15 300X King St 6 1 1 2 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
996 248949 3 87 1500x Galvez Ave 19 1 1 2 3 03/18/2017 09:13:00 AM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1063 248924 3 88 201x Cashmere St 5 1 1 2 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
1491 110535 5 22 100X ASHBURY ST 3 1 1 12 3 04/21/2015 04:52:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1496 110536 5 11 100X ASHBURY ST 4 1 1 12 3 05/29/2015 02:12:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1568 251592 3 32 1999X Hyde St 1 1 1 2 3     3x3   6007220.0 2119146.0 37.799178528828 -122.41911751038602 (37.799178528828, -122.419117510386)
1986 251131 3 26 354 05th St 1 1 1 2 3 02/14/2014 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
2087 252878 3 15 300X King St 7 1 1 2 3     3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
3317 253413 2 29 2433 23rd Ave 1 1 1 9 3     3x3   5989193.66308 2098780.80152 37.7422296590049 -122.48000293550501 (37.7422296590049, -122.480002935505)
4532 253201 3 43 800 Oak St 3 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4536 253202 3 43 800 Oak St 4 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4541 253199 3 43 800 Oak St 1 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4545 253200 3 43 800 Oak St 2 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4620 253639 3 15 4405 California St 3 1 1 2 3     3x3   5993893.0 2114132.0 37.784651953064206 -122.46486880251801 (37.7846519530642, -122.464868802518)
4668 253644 3 39 1200x La Salle Ave 12 1 1 2 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4669 253646 3 39 1200x La Salle Ave 22 1 1 2 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4719 253672 3 17 390 06th St 4 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
6296 95177 3 15 1227 Divisadero St 1 1 1 2 3   3 3x3   6001304.8007 2112660.3061 37.781035607967404 -122.439120992436 (37.7810356079674, -122.439120992436)
6709 85477 3 11 1711 Hyde St 2 1 1 2 3 02/10/2011 12:00:00 AM 18 4x4 Permit Number 56911 6007344.49108 2118216.09025 37.7966322393414 -122.418620748847 (37.7966322393414, -122.418620748847)
7078 95163 3 127 998 Divisadero St 2 1 1 2 3 04/21/2016 12:00:00 AM 3 3x3   6001491.8688 2111772.0851 37.7786074207661 -122.438410176931 (37.7786074207661, -122.438410176931)
7204 11066 3 11 1711 Hyde St 1 1 1 2 3 02/10/2011 12:00:00 AM 60 4x4 Permit Number 56911 6007343.19343 2118232.87472 37.7966782522465 -122.418626429868 (37.7966782522465, -122.418626429868)
9027 21627 3 35 1615 Sutter St 1 1 1 2 3 10/14/2010 12:00:00 AM 6 4X4 Permit Number 53778 6004639.3671 2114660.2794 37.7867162131248 -122.42772760613701 (37.7867162131248, -122.427727606137)
13274 187630 3 50 4255x Judah St 1 1 1 2 3 03/23/2015 05:35:00 PM   3x3   5981269.0 2105492.0 37.760193098921796 -122.50790142928699 (37.7601930989218, -122.507901429287)
20491 85214   52 2889 24th St 1 1 1 2 3 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.75264132339179 -122.409722943913 (37.7526413233918, -122.409722943913)
22922 251160 3 143 1126x Portola Dr 1 11 1 2 3     3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
25916 115393 2 15 800x Rutland St 2 1 1 14 3   4 3x3   6009906.5006099995 2087474.9292900001 37.712367789705 -122.407587055718 (37.712367789705, -122.407587055718)
39914 115395 2 15 800x Rutland St 4 1 1 14 3   4 3x3   6009893.891419999 2087442.30364 37.7122775004839 -122.40762833818998 (37.7122775004839, -122.40762833819)
53226 115394 2 15 800x Rutland St 3 1 1 14 3   4 3x3   6009899.82351 2087457.5745 37.7123197632209 -122.407608911042 (37.7123197632209, -122.407608911042)
61148 85309   41 1250 Haight St 1 1 1 2 3 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
79581 117011 2 22 457X CASTRO ST 1 16 1 6 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
81359 112751 2 43 135X TRENTON ST 5 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
82777 85446   127 360Y12 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
85683 87557 3 11 408X Lake St 2 1 1 2 3 08/03/2007 12:00:00 AM 3 3x3   5994236.225190001 2114896.53302 37.786770936164395 -122.463736876784 (37.7867709361644, -122.463736876784)
86565 91191 3 15 818 Van Ness Ave 5 1 1 2 3 02/05/2009 12:00:00 AM   3x3 Permit Number 52040 6006711.43287 2113326.5718900003 37.7831711713524 -122.42046403454901 (37.7831711713524, -122.420464034549)
86815 112748 2 21 135X TRENTON ST 2 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
88231 85433   127 360Y1 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
89282 91179 1 11 1 Polk St 6 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
91095 91190 3 15 818 Van Ness Ave 4 1 1 2 3 02/05/2009 12:00:00 AM   3x3 Permit Number 52040 6006711.43287 2113326.5718900003 37.7831711713524 -122.42046403454901 (37.7831711713524, -122.420464034549)
95845 85448   127 360Y14 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96265 85437   127 360Y4 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
97533 85444   127 360Y10 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98712 85439   127 360Y5 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98784 95178 3 127 1215 Divisadero St 1 1 1 2 3   3 3x3   6001286.14287 2112595.80793 37.7808574507306 -122.439180914838 (37.7808574507306, -122.439180914838)
99579 85445   127 360Y11 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
101441 112750 2 43 135X TRENTON ST 4 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
102102 108939 1 35 1801 Green St 1 1 1 14 3 01/13/2015 12:00:00 AM 3 3x3 Permit Number 774694 6004341.9 2118349.2 37.7968282226561 -122.42901988134199 (37.7968282226561, -122.429019881342)
102543 21639 3 37 1641 Sutter St 1 1 1 2 3 10/14/2010 12:00:00 AM 18 4X4 Permit Number 53778 6004750.8195846 2114677.2774985 37.7867691895303 -122.42734321826401 (37.7867691895303, -122.427343218264)
102642 85435   127 360Y3 Valencia St   1 1 2 3 08/07/2006 12:00:00 AM 3 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
103232 95167 3 127 1300 DIVISADERO ST 1 1 1 2 3   3 3x3   6001355.0 2112906.0 37.781713077167396 -122.43896494142 (37.7817130771674, -122.43896494142)
103498 85440   127 360Y6 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
105788 85443   127 360Y9 Valencia St   1 1 2 3   6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
107282 100095 1 17 4372 26th St 1 1 1 3 3 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273)
107477 106680 1 17 2200 LYON ST 2 1 1 9 3 06/24/2014 12:00:00 AM 20 3x3 Permit Number 773028 5999398.2 2116386.7 37.7911586409716 -122.445984946853 (37.7911586409716, -122.445984946853)
109671 59556 1 26 4079 Cesar Chavez St 1 1 1 5 3 02/03/1981 12:00:00 AM 15   Permit Number 18942 6003404.16952868 2100363.87266154 37.747391805572796 -122.43098037560101 (37.7473918055728, -122.430980375601)
110121 49668 3 11 2099X Beach St 1 1 1 10 3 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.44338472026199 (37.8030812490195, -122.443384720262)
114566 114692 1 48 391 Girard St 2 1 1 9 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
114568 91178 1 11 1 Polk St 5 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
114637 106120 1 37 849X Cabrillo St 2 1 1 9 3     6x9   5992954.7 2110649.6 37.775036084258794 -122.46786160539301 (37.7750360842588, -122.467861605393)
116277 102879 1 37 1680X Revere Ave 1 1 1 14 3 07/23/2010 12:00:00 AM 2 4x4 Permit Number 53643 6014844.7 2094689.6 37.732453033840706 -122.39102294843501 (37.7324530338407, -122.391022948435)
118120 114914 2 40 200x MIDDLE POINT RD 1 1 1 20 3     3x3   6017974.0 2095171.0 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959)
119540 85436   11 1397X Buchanan St 7 1 1 2 3 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304)
120602 115341 2 9 1514 SUNNYDALE AVE 2 9 1 20 3     3x3   6006572.0 2087815.0 37.7131143345755 -122.41913622882099 (37.7131143345755, -122.419136228821)
120951 85249   131 1335 Fulton St 1 1 1 2 3 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
122914 85441   127 360Y7 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123072 85434   127 360Y2 Valencia St   1 1 2 3 08/23/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
125403 91180 1 11 1 Polk St 7 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
126214 91181 1 11 1 Polk St 8 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
126348 85447   127 360Y13 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
138572 112749 2 21 135X TRENTON ST 3 1 1 20 3     3x3   6009947.0 2118097.0 37.796451422722605 -122.409607037418 (37.7964514227226, -122.409607037418)
140895 85310   41 1250 Haight St 2 1 1 2 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
143542 85442   127 360Y8 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
144030 15159 1 43 895X Mission St 13 1 1 5 3   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907)
144968 17872 8 73 2148 Pine St 2 1 1 2 3 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.788333445178104 -122.43117780902399 (37.7883334451781, -122.431177809024)
145363 85250   131 1335 Fulton St 2 1 1 2 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
147023 109910 2 15 425 07th St 4 1 1 18 3   9 3x3   6011008.58026 2110233.67588 37.774920023185295 -122.40537967513 (37.7749200231853, -122.40537967513)
Powered by Datasette · Query took 2.33ms · Data source: data.sfgov.org