sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
46 18228 3 22 1737-1795 Post St 2 1 1 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
184 138801 1 22 2375 PINE ST 2 1 1 1   05/09/1997 12:00:00 AM 2 Width 0ft   6002525.8905 2115062.7753 37.787701584977704 -122.43506851988899 (37.7877015849777, -122.435068519889)
202 138810 3 22 2355 PINE ST 6 1 1 2     11 Width 0ft   6002718.089 2115091.954 37.787792613821004 -122.434405637805 (37.787792613821, -122.434405637805)
212 138800 3 22 2375 PINE ST 1 1 1 2     7 Width 0ft   6002511.9355 2115060.8724 37.7876955676952 -122.435116665287 (37.7876955676952, -122.435116665287)
237 2654 3 22 1988 Bush St 1 1 1 2   01/30/2005 12:00:00 AM 12 3X3   6004003.2237 2114978.8425 37.7875549020514 -122.429951242636 (37.7875549020514, -122.429951242636)
278 9598 3 22 1350 Golden Gate Ave 1 1 1 2     12 3X3   6003113.217999999 2112071.7207 37.7795222347306 -122.43282272296999 (37.7795222347306, -122.43282272297)
548 18094 1 22 3001 Pine St 2 1 1 1     6 3X3   5999514.29 2114642.3727 37.786375803755895 -122.445457799993 (37.7863758037559, -122.445457799993)
686 23735 3 22 805 Webster St 2 1 1 2   03/29/2016 12:00:00 AM 12 4X4   6003900.7925 2111534.0109 37.778090453740504 -122.430059798517 (37.7780904537405, -122.430059798517)
741 9506 1 22 935 Golden Gate Ave 3 1 1 1   01/10/2002 12:00:00 AM 3 3X3   6005056.2117 2112292.3227 37.7802379614696 -122.426116783326 (37.7802379614696, -122.426116783326)
753 48 3 22 810 14th St 3 1 1 2     4 3X3   6003376.13457 2107738.85817 37.767640169485105 -122.43160376032499 (37.7676401694851, -122.431603760325)
770 231129 3 22 821 14th St 1 1 1 2     17 Width 3ft   6003305.97559 2107686.68734 37.7674929441754 -122.431842705671 (37.7674929441754, -122.431842705671)
795 140241 2 22 160 Ashbury St 3 1 1 1     2 Width 0ft   5998775.6798 2110202.3294 37.7741424035345 -122.44769344620701 (37.7741424035345, -122.447693446207)
850 14550 1 22 834 Masonic Ave 1 1 1 1   01/12/1993 12:00:00 AM 12 3X3   5999292.7589 2109954.5102 37.7734914941004 -122.445886958088 (37.7734914941004, -122.445886958088)
884 20233 1 22 1724 Steiner St 1 1 1 1     12 4X4   6002600.0088 2114219.702 37.785390928556396 -122.43475177403499 (37.7853909285564, -122.434751774035)
893 18095 3 22 3001 Pine St 3 1 1 2     15 3X3   5999540.0604 2114647.8242 37.7863922432736 -122.44536903339501 (37.7863922432736, -122.445369033395)
1080 9610 1 22 1388X Golden Gate Ave 1 1 1 3   05/01/2017 01:42:00 PM 3 3X3   6002958.1886 2112049.4711 37.7794523489738 -122.433357444963 (37.7794523489738, -122.433357444963)
1155 14734 3 22 895 McAllister St 1 1 1 2     8 4x4   6004929.3578 2111921.9134 37.7792137381495 -122.42652924677799 (37.7792137381495, -122.426529246778)
1353 14712 3 22 845 McAllister St 2 1 1 2   04/27/1993 12:00:00 AM 8 4x4   6005208.5684 2111961.5273 37.779338288494 -122.42556616152099 (37.779338288494, -122.425566161521)
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)
1498 251577 2 22 490X Ashbury St 2 1 1 1       3x3   5998892.0 2109203.0 37.7714051474644 -122.447219139052 (37.7714051474644, -122.447219139052)
1581 111 3 22 955 14th St 2 1 1 2     25 3X3   6002518.0 2107623.0 37.767273374303706 -122.43456365047399 (37.7672733743037, -122.434563650474)
1818 139879 3 22 870 MCALLISTER ST 2 1 1 2   02/16/2000 12:00:00 AM 12 Width 0ft   6005009.3284 2111993.411 37.779414573538205 -122.42625768702801 (37.7794145735382, -122.426257687028)
1897 245386 3 22 3243 Mission St 1 1 1 2   02/17/1998 12:00:00 AM 6 Width 0ft   6006500.2854 2099391.485 37.7448967968639 -122.420205198271 (37.7448967968639, -122.420205198271)
1950 252823 6 22 3852 17th St 2 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1951 9609 1 22 1386 Golden Gate Ave 1 1 1 1     6 3X3   6002986.18 2112056.6484 37.779473644014104 -122.433261123937 (37.7794736440141, -122.433261123937)
2124 22782 3 22 1866 Turk St 1 1 1 2     12 3X3   6001070.0369 2112136.3428 37.7795835769795 -122.439895576072 (37.7795835769795, -122.439895576072)
2202 139878 1 22 870 MCALLISTER ST 1 1 1 1     11 Width 0ft   6005025.9501 2111995.4887 37.779421217898204 -122.426200333481 (37.7794212178982, -122.426200333481)
2407 9490 1 22 871 Golden Gate Ave 1 1 1 1   05/06/2002 12:00:00 AM 3 3X3   6005401.3681 2112340.2476 37.7803890535333 -122.42492613811301 (37.7803890535333, -122.424926138113)
2458 9644 3 22 1495 Golden Gate Ave 2 1 1 2     8 3X3   6002520.4964 2111934.6452 37.7791122249761 -122.434863391819 (37.7791122249761, -122.434863391819)
2579 14672 3 22 739 McAllister St 1 1 1 2     12 4x4   6005639.1537 2112019.7041 37.7795223479045 -122.424080723662 (37.7795223479045, -122.424080723662)
2696 9611 1 22 1390X Golden Gate Ave 2 1 1 3   05/14/1992 12:00:00 AM 3 3X3   6002925.8908 2112046.6002 37.7794426338279 -122.43346897140499 (37.7794426338279, -122.433468971405)
2827 18276 3 22 1950 Post St 5 1 1 2     12 4X4   6002797.4872 2114109.7892 37.78510034529771 -122.434060698947 (37.7851003452977, -122.434060698947)
3222 5838 3 22 860 Eddy St 1 1 1 2   12/17/1997 12:00:00 AM 6 3X3   6006312.21276 2113211.9775099996 37.7828340176265 -122.421837034768 (37.7828340176265, -122.421837034768)
3331 140432 1 22 1499 Turk St 11 1 1 18     13 Width 0ft   6003204.3695 2112383.9326 37.7803846599605 -122.432529697936 (37.7803846599605, -122.432529697936)
3346 139859 3 22 704 McAllister St 3 1 1 2     7 Width 0ft   6005699.1313 2112090.0249 37.7797188177748 -122.423878237045 (37.7797188177748, -122.423878237045)
3348 140430 1 22 1499 TURK ST 9 1 1 18   05/18/1992 12:00:00 AM 5 Width 0ft   6003115.3712 2112373.8844 37.7803520228236 -122.432836866316 (37.7803520228236, -122.432836866316)
3353 139860 3 22 706 McAllister St 4 1 1 2   05/12/2016 12:00:00 AM 8 Width 0ft   6005680.9512 2112087.9472 37.7797120865642 -122.42394098222 (37.7797120865642, -122.42394098222)
3462 109 1 22 941 14th St 1 1 1 1     15 3X3   6002569.29571 2107648.70327 37.767346860988 -122.434388064079 (37.767346860988, -122.434388064079)
3542 9627 1 22 1415 Golden Gate Ave 1 1 1 1     12 3X3   6002784.4654 2111969.5026 37.779222918296206 -122.433952708708 (37.7792229182962, -122.433952708708)
3576 22792 1 22 1900 Turk St 1 1 1 1   06/09/1995 12:00:00 AM 6 3X3   6000871.3270000005 2112110.8774 37.7795023421352 -122.44058117022199 (37.7795023421352, -122.440581170222)
3681 210783 2 22 102 Kirkham St 3 1 1 1     8 Width 4ft   5994553.24166 2105346.7379 37.7605679917509 -122.46194732411001 (37.7605679917509, -122.46194732411)
3715 240037 2 22 4109 18th St 1 1 1 1     7 Width 3ft   6002258.67075 2105277.61191 37.7608187856797 -122.435292848592 (37.7608187856797, -122.435292848592)
3771 47 3 22 810 14th St 2 1 1 2   12/03/1998 12:00:00 AM 6 3X3   6003389.5525400005 2107739.47109 37.7676426129451 -122.431557393053 (37.7676426129451, -122.431557393053)
3777 121577 2 22 358 Walnut St 2 1 1 1     1 3x3   5998615.65144 2115302.1022900003 37.788135906006104 -122.448614380145 (37.7881359060061, -122.448614380145)
4327 103839 3 22 1552 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006685.2576 2116316.1212 37.791378262309706 -122.420766896 (37.7913782623097, -122.420766896)
4535 12416 3 22 1660 Laguna St 1 1 1 2   09/13/1989 12:00:00 AM 6 4X4   6004502.1372 2114559.4680000003 37.786431646664205 -122.428195201763 (37.7864316466642, -122.428195201763)
4607 138309 1 22 2271 Bush St 2 1 1 1   10/02/2015 12:00:00 AM 5 Width 0ft   6002610.839 2114725.8359 37.7867812584334 -122.434750511093 (37.7867812584334, -122.434750511093)
4928 24232 1 22 200X Willow St 1 1 1 1   05/02/1990 12:00:00 AM 6 4X4   6006507.65863 2113391.7198099997 37.7833385660635 -122.421173639975 (37.7833385660635, -122.421173639975)
5150 12412 3 22 1620 Laguna St 1 1 1 2     12 4X4   6004511.4773 2114458.3749 37.786154598782396 -122.428155680217 (37.7861545987824, -122.428155680217)
5265 5279 3 22 1350 Divisadero St 2 1 1 2     12 4X4   6001320.5373 2113019.2025 37.7820219415228 -122.43909228156001 (37.7820219415228, -122.43909228156)
5341 19786 3 22 100 STAIRWAY19 8 1 1 2     6 50ST            
5375 9508 1 22 935 Golden Gate Ave 5 1 1 1     6 3X3   6005101.6314 2112299.4943 37.7802602199167 -122.42596016623399 (37.7802602199167, -122.425960166234)
5378 9456 1 22 800X Golden Gate Ave 12 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005442.4 2112406.4818 37.780573233977705 -122.424788902821 (37.7805732339777, -122.424788902821)
5415 18101 1 22 3031 Pine St 1 1 1 1     6 3X3   5999398.8192 2114627.0097 37.7863270284134 -122.44585619283 (37.7863270284134, -122.44585619283)
5438 7826 3 22 807 Franklin St 3 1 1 2     6 4x4   6006132.89126 2112941.5799 37.7820814577469 -122.422438193788 (37.7820814577469, -122.422438193788)
5464 18230 3 22 1737-1795 Post St 9 1 1 2   04/09/2004 12:00:00 AM 3 3X3   6003859.0712 2114201.8624 37.7854133456405 -122.430394523724 (37.7854133456405, -122.430394523724)
5510 20148 3 22 1028 Steiner St 1 1 1 2   05/19/1999 12:00:00 AM 3 4X4   6002939.2419 2111824.3037 37.7788330206804 -122.433406894695 (37.7788330206804, -122.433406894695)
5562 2725 1 22 2211 Bush St 1 1 1 1   05/12/1992 12:00:00 AM 12 3x3   6002784.7803 2114750.1183 37.7868578053346 -122.434150452304 (37.7868578053346, -122.434150452304)
5621 6044 3 22 1834 Eddy St 1 1 1 2     12 3X3   6001440.1248 2112530.373 37.780686543842705 -122.43864352716801 (37.7806865438427, -122.438643527168)
5685 95207 2 22 2203 Divisadero St 1 1 1 1     6 3x3   6000850.32239 2115965.74375 37.7900856173129 -122.440930450291 (37.7900856173129, -122.440930450291)
5723 9483 1 22 839 Golden Gate Ave 1 1 1 1     12 3X3   6005577.0805 2112364.6521 37.7804659857949 -122.424320002456 (37.7804659857949, -122.424320002456)
5760 20149 3 22 1040 Steiner St 1 1 1 2     18 4X4   6002932.4508 2111847.2891 37.7788957475604 -122.433432030761 (37.7788957475604, -122.433432030761)
5778 24244 3 22 289X Willow St 2 1 1 2     6 4X4   6006236.37633 2113335.30136 37.7831683576867 -122.42210816146499 (37.7831683576867, -122.422108161465)
5790 18038 3 22 2809 Pine St 1 1 1 2     12 3X3   6000359.9496 2114756.9723 37.7867387044094 -122.442540272299 (37.7867387044094, -122.442540272299)
5833 18102 1 22 3037 Pine St 1 1 1 1     6 3X3   5999372.5533 2114624.5318 37.786318724964204 -122.445946887489 (37.7863187249642, -122.445946887489)
5863 9461 1 22 800X Golden Gate Ave 17 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005331.3816 2112388.6106 37.780517893039395 -122.425171696602 (37.7805178930394, -122.425171696602)
6156 99174 1 22 2100 Webster St 10 1 1 1     5 3x3   6003313.97613 2116148.97888 37.790728741394894 -122.432419507463 (37.7907287413949, -122.432419507463)
6164 5280 3 22 1350 Divisadero St 3 1 1 2     12 4X4   6001316.1378 2113050.3373 37.7821071794141 -122.43910973392799 (37.7821071794141, -122.439109733928)
6207 17935 3 22 2426 Pine St 1 1 1 2     12 3x3   6002142.0869 2115065.9831 37.787688592105205 -122.436396634074 (37.7876885921052, -122.436396634074)
6304 9451 1 22 800X Golden Gate Ave 7 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005532.2979 2112418.9375 37.7806125113537 -122.424478789137 (37.7806125113537, -122.424478789137)
6313 9487 1 22 851 Golden Gate Ave 1 1 1 1     12 3X3   6005519.3971 2112356.6652 37.7804407983566 -122.424518988404 (37.7804407983566, -122.424518988404)
6320 9597 3 22 1340 Golden Gate Ave 1 1 1 2   11/11/1994 12:00:00 AM 12 3X3   6003188.5795 2112083.2043 37.779558039769505 -122.432562836067 (37.7795580397695, -122.432562836067)
6324 14845 1 22 1328 McAllister St 1 1 1 1   05/13/1992 12:00:00 AM 10 3x3   6002789.0932 2111678.3235 37.778423675949 -122.43391588048999 (37.778423675949, -122.43391588049)
6358 14669 3 22 731 McAllister St 1 1 1 2     10 4x4   6005678.1934 2112026.9763 37.7795445196864 -122.423946185798 (37.7795445196864, -122.423946185798)
6367 24233 1 22 200X Willow St 2 1 1 1   05/30/1997 12:00:00 AM 12 4X4   6006482.09077 2113391.69124 37.7833370462081 -122.42126209278099 (37.7833370462081, -122.421262092781)
6451 17934 3 22 2424 Pine St 1 1 1 2     12 3x3   6002175.8086 2115067.4242 37.7876944650438 -122.436280066856 (37.7876944650438, -122.436280066856)
6498 18062 3 22 2901 Pine St 2 1 1 2   05/20/1994 12:00:00 AM 12 3X3   6000020.8872 2114713.4888 37.786599977163704 -122.443710218956 (37.7865999771637, -122.443710218956)
6559 18229 3 22 1737-1795 Post St 3 1 1 2   05/20/1992 12:00:00 AM 6 3X3   6003704.9298 2114183.2083 37.7853533936228 -122.43092647489901 (37.7853533936228, -122.430926474899)
6562 17937 3 22 2430 Pine St 1 1 1 2     12 3x3   6002084.443 2115054.4543 37.7876536614139 -122.436595244995 (37.7876536614139, -122.436595244995)
6812 26676 1 22 2261 Bush St 2 1 1 1     12 3x3   6002690.1285 2114739.216 37.786822497954 -122.434477145422 (37.786822497954, -122.434477145422)
6908 7825 3 22 807 Franklin St 2 1 1 2     12 4x4   6006133.13296 2112953.34413 37.7821137730772 -122.422438193776 (37.7821137730772, -122.422438193776)
6927 2732 1 22 2257 Bush St 1 1 1 1     12 3x3   6002711.9331 2114741.6938 37.786830539072206 -122.434401883901 (37.7868305390722, -122.434401883901)
7038 24234 1 22 200X Willow St 3 1 1 1     3 4X4   6006430.34404 2113385.60278 37.78331741132 -122.42144068376699 (37.78331741132, -122.421440683767)
7144 20150 3 22 1040 Steiner St 2 1 1 2     18 4X4   6002930.8836 2111873.4088 37.7789673768152 -122.433439319366 (37.7789673768152, -122.433439319366)
7151 9599 1 22 1355 Golden Gate Ave 1 1 1 1   04/06/1990 12:00:00 AM 11 3X3   6003022.227000001 2112007.7178 37.7793413376686 -122.43313292513201 (37.7793413376686, -122.433132925132)
7171 9447 1 22 800X Golden Gate Ave 3 7 1 3     12 3X3   6005622.1957 2112431.3933 37.780651788182794 -122.424168675479 (37.7806517881828, -122.424168675479)
7266 17932 3 22 2418 Pine St 1 1 1 2     12 3x3   6002216.7357 2115077.2237 37.787723697261896 -122.43613916872499 (37.7877236972619, -122.436139168725)
7350 17974 3 22 2519 Pine St 1 1 1 2     18 3x3   6001636.0692 2114939.9757 37.78731384268 -122.438138324219 (37.78731384268, -122.438138324219)
7511 17938 3 22 2432 Pine St 1 1 1 2     9 4x4   6002059.6562 2115054.4543 37.7876522528246 -122.436681002358 (37.7876522528246, -122.436681002358)
7512 9485 1 22 847 Golden Gate Ave 1 1 1 1   05/06/2002 12:00:00 AM 3 3X3   6005536.7021 2112359.7712 37.7804503039159 -122.424459343214 (37.7804503039159, -122.424459343214)
7565 18105 3 22 3053 Pine St 1 1 1 2     12 3x3   5999309.1186 2114616.1068 37.7862919697055 -122.446165748193 (37.7862919697055, -122.446165748193)
7570 9448 1 22 800X Golden Gate Ave 4 7 1 3   05/18/1992 12:00:00 AM 12 3X3   6005590.2441 2112426.5193 37.78063660125729 -122.424278864743 (37.7806366012573, -122.424278864743)
7687 5278 3 22 1350 Divisadero St 1 1 1 2     12 4X4   6001321.891 2113007.3577 37.781989495746394 -122.439086749209 (37.7819894957464, -122.439086749209)
7740 9445 1 22 800X Golden Gate Ave 1 7 1 3   03/01/1994 12:00:00 AM 12 3X3   6005680.1419 2112439.5166 37.780677364386705 -122.423968789396 (37.7806773643867, -122.423968789396)
7757 18225 3 22 1675 Post St 2 1 1 2   05/20/1992 12:00:00 AM 6 3x3   6004149.2891 2114241.9195 37.7855397675254 -122.42939331414699 (37.7855397675254, -122.429393314147)
7760 14671 3 22 735 McAllister St 1 1 1 2     16 4x4   6005659.8218 2112023.5316 37.779534024179995 -122.42400949606301 (37.77953402418, -122.424009496063)
7869 18231 3 22 1737-1795 Post St 10 1 1 2   05/20/1992 12:00:00 AM 6 3X3   6003887.3468 2114207.7531 37.785431121654895 -122.430297119046 (37.7854311216549, -122.430297119046)
7945 111904 1 22 1944 Mason St 2 1 1 1     12 3x3   6009089.4426 2119974.7658 37.801559212533604 -122.41270719679301 (37.8015592125336, -122.412707196793)
7992 111123 1 22 2196 Hayes St 1 1 1 1     18 3x3   5997448.8282 2109892.6608 37.773216211211 -122.45226088690201 (37.773216211211, -122.452260886902)
8038 18275 3 22 1950 Post St 4 1 1 2     12 4X4   6002826.7788 2114117.8444 37.7851241251679 -122.433959935292 (37.7851241251679, -122.433959935292)
Powered by Datasette · Query took 28.15ms · Data source: data.sfgov.org