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                    
130 66855 1 22 2041 Hayes St 1 1 1 1 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
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)
736 231004 1 22 660 Alabama St 4 1 1 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008974.97232 2105068.82517 37.7606246283465 -122.412049301945 (37.7606246283465, -122.412049301945)
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)
744 231007 1 22 660 Alabama St 1 1 1 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008969.23961 2105134.95103 37.7608058732193 -122.412073802181 (37.7608058732193, -122.412073802181)
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)
756 231006 1 22 660 Alabama St 2 1 1 1   01/14/2003 12:00:00 AM 9 Width 3ft Permit Number 46247 6008972.79201 2105110.692 37.760739462776606 -122.41205980151199 (37.7607394627766, -122.412059801512)
758 231035 1 22 3050 19th St 2 1 1 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008913.51781 2104995.63577 37.7604202187369 -122.41225667301799 (37.7604202187369, -122.412256673018)
765 231003 1 22 660 Alabama St 5 1 1 1   01/14/2003 12:00:00 AM 9 Width 3ft Permit Number 46247 6008977.98805 2105043.06556 37.760554067537704 -122.412037051387 (37.7605540675377, -122.412037051387)
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)
775 231005 1 22 660 Alabama St 3 1 1 1   01/14/2003 12:00:00 AM 8 Width 3ft Permit Number 46247 6008971.29667 2105087.04019 37.7606744364044 -122.41206330170401 (37.7606744364044, -122.412063301704)
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)
2277 230875 2 22 236 Whitney St 1 1 1 1   07/10/2017 12:00:00 AM 3 Width 3ft Permit Number 780225 6004378.79824 2096997.6993900002 37.7382042419264 -122.42737041762 (37.7382042419264, -122.42737041762)
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)
2727 209330 1 22 1561 16th Ave 1 1 1 1   05/16/1994 12:00:00 AM 1 Width 1ft Permit Number 33584 5991111.55189 2104793.24425 37.7588495024191 -122.47381006179701 (37.7588495024191, -122.473810061797)
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)
3075 231047 1 22 1006 Noe St 1 1 1 1   07/24/1989 12:00:00 AM 6 Width 3ft Permit Number 27195 6003118.79075 2102352.8042 37.752836769210504 -122.432109206276 (37.7528367692105, -122.432109206276)
3102 231048 1 22 1028 Noe St 1 1 1 1   07/24/1989 12:00:00 AM 10 Width 4ft Permit Number 27198 6003126.30081 2102253.4394 37.752564362754896 -122.43207614 (37.7525643627549, -122.43207614)
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)
3356 231847 2 22 4050 17th St 2 1 1 1   08/22/2016 12:00:00 AM 3 Width 2ft Permit Number 778753 6001932.15846 2105889.72854 37.762480961257296 -122.436465919794 (37.7624809612573, -122.436465919794)
3388 102820 1 22 340 Presidio Ave 2 1 1 1     6 3x3 Permit Number 46302 5999107.42963 2115375.9923 37.7883668959543 -122.446918238085 (37.7883668959543, -122.446918238085)
3400 209440 1 22 1643 11th Ave 1 1 1 1   01/10/1994 12:00:00 AM 5 Width 4ft Permit Number 33110 5992755.638719999 2104278.4953 37.757531223117 -122.46808665218599 (37.757531223117, -122.468086652186)
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)
3471 49244 1 22 340 Presidio Ave 1 1 1 1   03/13/2003 12:00:00 AM 6 3x3 Permit Number 46302 5999109.05449 2115365.28711 37.7883375951433 -122.446911845714 (37.7883375951433, -122.446911845714)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
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)
3735 63212 1 22 450 38th Ave 2 1 1 1 1 12/18/1986 12:00:00 AM 10   Permit Number 23755 5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
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)
4160 209715 1 22 2351 12th Ave 2 1 1 1   04/30/2005 12:00:00 AM 6 Width 3ft Permit Number 46346 5992610.11483 2099444.51388 37.7442499514734 -122.468238276996 (37.7442499514734, -122.468238276996)
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)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
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)
6100 60881 1 22 1944 Mason St 1 1 1 1   05/12/1983 12:00:00 AM 10 3x3 Permit Number 20664 6009093.1364 2119961.1446 37.8015220194232 -122.412693451029 (37.8015220194232, -122.412693451029)
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)
Powered by Datasette · Query took 2.625ms · Data source: data.sfgov.org