sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124625 111763 9 47 2626 Vallejo St 1 13 1 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
2764 253207 7 47 89 Woodhaven Ct 1 16 1 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
78509 102745 7 47 222 Moncada Way 1 7 1 1           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409)
84088 103516 7 47 980 Green St 1 13 1 1           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
140844 102706 7 47 1342 Funston Ave 1 13 1 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
145393 98880 7 47 101 Lansdale Ave 1 7 1 1     11     5994747.9 2097283.1 37.738438484278895 -122.460689725403 (37.7384384842789, -122.460689725403)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
484 205880 6 47 44 Mendosa Ave 1 1 1 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 6 47 8R Amethyst Way 3 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 6 47 2R Amethyst Way 3 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1637 251619 6 47 72R Amber Dr 2 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1645 251626 6 47 2R Amethyst Way 1 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1646 251633 6 47 14R Amethyst Way 2 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1650 251608 6 47 56R Amber Dr 1 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1651 251609 6 47 56R Amber Dr 2 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1654 251610 6 47 56R Amber Dr 3 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1820 251716 6 47 3929 19th St 1 7 1 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
2151 252916 6 47 101 Gold Mine Dr 1 1 1 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
2848 253255 6 47 270 Castenada Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3361 253428 6 47 3 Valletta Ct 1 18 1 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
9683 173631 6 47 99X Everglade Dr 1 5 1 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13307 187654 6 47 375 Woodside Ave 1 2 1 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
50101 121189 6 47 1000x Duncan St 10 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
75294 93205 6 47 400 Masonic Ave 3 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
82925 112725 6 47 40x BERNAL HEIGHTS BLVD 1 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
86774 122640 6 47 3630X 19th Ave 4 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
88391 122637 6 47 3630X 19th Ave 1 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
91819 122638 6 47 3630X 19th Ave 2 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
98176 105497 6 47 3929 19TH ST 1 7 1 1     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429)
98711 105649 6 47 3 Gonzalez Dr 1 7 1 1           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469)
103620 93204 6 47 400 Masonic Ave 1 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
108351 106363 6 47 101 URBANO DR 1 7 1 1     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
110973 106962 6 47 218 SADOWA ST 3 5 1 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
112771 109706 6 47 96 CRESTA VISTA DR   16 1 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
118374 93206 6 47 400 Masonic Ave 4 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
118710 105850 6 47 44 MENDOSA AVE 1 9 1 1     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372)
120114 122639 6 47 3630X 19th Ave 3 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
120332 103422 6 47 1365 Portola Dr 1 7 1 1         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.46532315146601 (37.7394617231066, -122.465323151466)
122936 107159 6 47 1000 ESMERALDA AVE   7 1 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
123752 95982 6 47 100 Vasquez Ave 1 13 1 1           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
125813 103600 6 47 50X Hermann St 1 7 1 1           6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
125828 112726 6 47 40x BERNAL HEIGHTS BLVD 2 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
139394 93203 6 47 400 Masonic Ave 2 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
139692 99826 6 47 1 Cascade Walk 1 7 1 1           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468)
140312 115391 6 47 21X BELMONT AVE 1 7 1 1     48     5996611.0 2106266.0 37.7632103037359 -122.45489693849501 (37.7632103037359, -122.454896938495)
140584 117248 6 47 299x GRAYSTONE TER 1 1 1 1       3x3   5999641.0 2104067.0 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093)
143237 104888 6 47 146 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
144598 99662 6 47 1337 Portola Dr 1 7 1 1           5993559.3 2097744.3 37.7396363671104 -122.46483277796801 (37.7396363671104, -122.464832777968)
145554 121180 6 47 1000x Duncan St 1 1 1 1       3x3   5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
110956 118356 5 47 100 RACCOON DR 2 16 1 1     48     5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
122672 102060 5 47 115 Kensington Way 1 13 1 1           5994908.3 2098325.8 37.741310707397396 -122.460210667073 (37.7413107073974, -122.460210667073)
129 20398 3 47 262X Sunset Blvd 43 1 1 2     24 60            
362 187139 3 47 2301 Sunset Blvd 1 9 1 1     39 Width 0ft   5984937.035 2099496.8257 37.7439474344515 -122.494773601416 (37.7439474344515, -122.494773601416)
503 8533 3 47 2100 Geary Blvd 4 11 1 2     18 6   6001504.6387 2113566.4305 37.783534963845 -122.43849459602801 (37.783534963845, -122.438494596028)
618 20377 3 47 262X Sunset Blvd 25 1 1 2     48 60            
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 3 47 401 Portola Dr 6 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 3 47 401 Portola Dr 2 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 3 47 401 Portola Dr 5 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 3 47 401 Portola Dr 1 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 3 47 401 Portola Dr 7 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
815 8534 3 47 2100 Geary Blvd 5 11 1 2   06/10/1994 12:00:00 AM 6 6   6001381.7916 2113512.2830000003 37.78337929999999 -122.43891571692801 (37.7833793, -122.438915716928)
869 124177 3 47 8X Almaden Ct 1 9 1 2     10 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
886 19568 3 47 100 STAIRWAY1 2 1 1 2     48 100ST            
1098 251438 3 47 2501X Santiago St 1 3 1 2                    
1561 8580 3 47 2200 Geary Blvd 7 11 1 2   06/01/1994 12:00:00 AM 6 6   6000778.3855 2113430.8926 37.783121473536795 -122.44099741813 (37.7831214735368, -122.44099741813)
1776 8585 3 47 2200 Geary Blvd 12 11 1 2   06/01/1994 12:00:00 AM 6 6   6000465.007 2113386.3901 37.78298142730029 -122.442078382069 (37.7829814273003, -122.442078382069)
1822 251717 3 47 1000X San Jose Ave 1 7 1 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
Powered by Datasette · Query took 12.038ms · Data source: data.sfgov.org