sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
577 15499 1 26 2704 Mission St 3 1 1 1     12 3X3   6006991.0 2102555.0 37.7536107294676 -122.41873270043001 (37.7536107294676, -122.41873270043)
578 239543 1 52 91 Bennington St 3 1 1 1   04/12/2017 12:00:00 AM 3 2.5x4 Permit Number 779298 6007186.362369999 2097372.9446900003 37.7393929694044 -122.41768982014798 (37.7393929694044, -122.417689820148)
579 2702 1 2 2121 Bush St 2 1 1 1     12 3X3   6003192.7078 2114808.0993 37.7870401500361 -122.432743262211 (37.7870401500361, -122.432743262211)
580 48268 1 17   132 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
581 240741 1 52 91 Bennington St 2 1 1 1   04/12/2017 12:00:00 AM 3 2.5x4 Permit Number 779298 6007184.54991 2097351.72127 37.739334592605 -122.41769458294901 (37.739334592605, -122.417694582949)
583 7548 1 46 2882 Folsom St 1 1 1 1     60 5x5   6008321.80095 2101666.80438 37.751246783135 -122.414067651319 (37.751246783135, -122.414067651319)
585 236679 1 16 682 Clipper St 1 1 1 1   06/23/2000 12:00:00 AM 2 Width 3ft Permit Number 42634 6000886.69016 2100906.56017 37.7487389273654 -122.43972452598301 (37.7487389273654, -122.439724525983)
589 26916 1 15 1901 Geary Blvd 10 1 1 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
591 139532 1 89 2103 O'Farrell St 3 1 1 1   04/12/2017 12:00:00 AM 3 Width 0ft Permit Number 779818 6001200.3588 2113145.5057 37.7823618989571 -122.439517100245 (37.7823618989571, -122.439517100245)
597 251329 1 17 95x Tompkins Ave 3 1 1 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
598 22577 1 60 799X Turk St 5 1 1 1     18 4X4   6006373.00538 2112825.1930299997 37.7817754301315 -122.421599237822 (37.7817754301315, -122.421599237822)
601 225172 1 99 248 Prospect Ave 1 1 1 1   12/02/2002 12:00:00 AM 9 Width 3ft Permit Number 46150 6006535.621280001 2098220.1400900004 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071)
602 15498 1 75 2704 Mission St 2 1 1 1     12 3X3   6007015.1629 2102569.9783 37.7536532168709 -122.41865020170799 (37.7536532168709, -122.418650201708)
603 239542 1 52 91 Bennington St 4 1 1 1   04/12/2017 12:00:00 AM 3 2.5x4 Permit Number 779298 6007187.05082 2097389.73315 37.739439105535105 -122.41768862942101 (37.7394391055351, -122.417688629421)
604 171523 1 17 281 Harvard St 1 7 1 1   04/12/2017 12:00:00 AM 3 3x3 Permit Number 779632 6006304.03409 2092571.58308 37.7261597980302 -122.420399821019 (37.7261597980302, -122.420399821019)
607 65964 1 17 2655 23rd Ave 1 1 1 1   04/12/2017 12:00:00 AM 3 3x3 Permit Number 779612 5989236.70778952 2097278.67232438 37.738107703581704 -122.479744212489 (37.7381077035817, -122.479744212489)
609 13247 1 11 2372X Lombard St 1 1 1 1   06/22/1994 12:00:00 AM 40 4x4   6001031.9779 2119351.2951 37.7993917986357 -122.44054486433201 (37.7993917986357, -122.440544864332)
610 251327 1 17 95x Tompkins Ave 1 1 1 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
612 23503 1 15 2550 Van Ness Ave 4 1 1 1     12 3X3   6005820.29029 2119236.56275 37.7993482683535 -122.42396743424999 (37.7993482683535, -122.42396743425)
615 2703 1 26 2123 Bush St 1 1 1 1   02/06/1987 12:00:00 AM 12 3X3   6003147.2203 2114799.0941 37.7870128441602 -122.432899995096 (37.7870128441602, -122.432899995096)
617 57850 1 17 1700 S. Amaylett Blvd 1 1 1 1   04/14/1977 12:00:00 AM     Permit Number 16791          
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
630 20157 1 26 1100X Steiner St 2 1 1 3     18 4X4   6002895.0285 2112125.5503 37.7796576600117 -122.433581380876 (37.7796576600117, -122.433581380876)
632 44905 1 17   139 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 1 17   47 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
634 251340 1 51 2230 Ocean Ave 4 1 1 1   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
638 251341 1 50 2275 Ocean Ave 1 1 1 1   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
641 5315 1 44 1820 Divisadero St 1 1 1 1   03/22/1990 12:00:00 AM 3 3X3   6001085.4403 2114655.5077 37.7865014360219 -122.440022974412 (37.7865014360219, -122.440022974412)
649 96374 1 18 1315 Taylor St 2 1 1 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008916.2106800005 2117429.1962900003 37.7945599836999 -122.41312655846599 (37.7945599836999, -122.413126558466)
650 11111 1 11 2015 Hyde St 1 1 1 1   06/26/2012 12:00:00 AM 5 3x3   6007199.704059999 2119289.07559 37.7995702354477 -122.419197895967 (37.7995702354477, -122.419197895967)
670 13108 1 5 1557 Lombard St 1 1 1 1     60 3x3   6004929.5061 2119810.12 37.80087277869679 -122.427090735634 (37.8008727786968, -122.427090735634)
671 225029 1 43 4543 18th St 1 1 1 1   04/14/2017 12:00:00 AM 3 Width 3ft Permit Number 17041 6000793.7951 2105198.47261 37.7605181908718 -122.44035351451099 (37.7605181908718, -122.440353514511)
672 23002 1 81 742 Valencia St 1 1 1 2   02/23/1994 12:00:00 AM 20 3X3   6006210.140269999 2105247.24413 37.7609590106658 -122.421624291141 (37.7609590106658, -122.421624291141)
673 210967 1 104 375 San Benito Way 1 1 1 1   08/09/1993 12:00:00 AM 4 Width 3ft Permit Number 32251 5992728.19812 2094135.00675 37.7296781967805 -122.467443955276 (37.7296781967805, -122.467443955276)
675 47038 1 12 716 Walter St 1 1 1 1   05/02/2002 12:00:00 AM     Permit Number 45030          
676 214191 1 25 363 San Benito Way 1 1 1 1   08/10/1972 12:00:00 AM 14 Width 3ft Permit Number 10790 5992756.72765 2094187.53129 37.7298240632085 -122.467349144256 (37.7298240632085, -122.467349144256)
677 107511 1 37 2141 Chestnut St 2 1 1 1   09/18/2014 12:00:00 AM 3 3x3   6001625.68296 2119729.38155 37.8004637136911 -122.43851754404601 (37.8004637136911, -122.438517544046)
680 214193 1 25 347 San Benito Way 1 1 1 1   02/23/1972 12:00:00 AM 19 Width 3ft Permit Number 9508 5992820.4639099995 2094345.69157 37.7302620114641 -122.467140297392 (37.7302620114641, -122.467140297392)
681 204889 1 12 351 San Benito Way 1 1 1 1   11/15/2002 12:00:00 AM 8 Width 3ft Permit Number 46076 5992804.92706 2094302.99556 37.7301438819374 -122.467190906752 (37.7301438819374, -122.467190906752)
683 204884 1 12 374 San Benito Way 1 1 1 1   05/08/2002 12:00:00 AM 5 Width 3ft Permit Number 45127 5992717.9561 2094174.3336900002 37.7297855875163 -122.467482221425 (37.7297855875163, -122.467482221425)
684 24323 1 103 600X Golden Gate Ave 10 1 1 1     12 3X3   6006332.380890001 2112512.31586 37.7809140549901 -122.42171754994101 (37.7809140549901, -122.421717549941)
685 214192 1 25 359 San Benito Way 1 1 1 1   02/23/1972 12:00:00 AM 16 Width 3ft Permit Number 9509 5992777.37887 2094232.46292 37.7299486265111 -122.46728101702 (37.7299486265111, -122.46728101702)
687 13252 1 79 2395 Lombard St 3 1 1 1     14 3X3   6001005.1632 2119265.163 37.7991537757264 -122.440631471061 (37.7991537757264, -122.440631471061)
688 214188 1 25 358 San Benito Way 1 1 1 1   02/03/1972 12:00:00 AM 21 Width 3ft Permit Number 9461 5992780.99407 2094319.4986599998 37.7301878137975 -122.467274844971 (37.7301878137975, -122.467274844971)
689 48269 1 17   120 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
693 214190 1 25 393 San Benito Way 1 1 1 1   11/18/2009 12:00:00 AM 17 Width 3ft Permit Number 53039 5992606.38416 2093945.5647200001 37.7291510025005 -122.46785130231501 (37.7291510025005, -122.467851302315)
695 212430 1 16 377 San Benito Way 1 1 1 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41586 5992705.098540001 2094089.26949 37.7295512799622 -122.467520487584 (37.7295512799622, -122.467520487584)
702 212428 1 16 384 San Benito Way 1 1 1 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41587 5992676.41369 2094100.5394 37.7295805681871 -122.467620472428 (37.7295805681871, -122.467620472428)
703 204887 1 12 381 San Benito Way 1 1 1 1   06/22/2002 12:00:00 AM 7 Width 3ft Permit Number 9510 5992671.12766 2094035.9384 37.729402884631 -122.46763405038601 (37.729402884631, -122.467634050386)
705 105051 1 17 1244 Masonic Ave 1 1 1 1   04/17/2017 12:00:00 AM 3   Permit Number 779926 5999515.4 2108544.9 37.769633771891606 -122.445015457708 (37.7696337718916, -122.445015457708)
706 2833 1 2 1200 California St 5 1 1 1     6 3X3   6008452.59238 2116301.4374700002 37.7914373972624 -122.41465089583099 (37.7914373972624, -122.414650895831)
707 214065 1 106 388 San Benito Way 1 1 1 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41588 5992652.79455 2094064.0577 37.729479034728605 -122.46769947335 (37.7294790347286, -122.46769947335)
708 204885 1 12 396 San Benito Way 1 1 1 1   05/08/2002 12:00:00 AM 10 Width 3ft Permit Number 45128 5992604.93972 2093995.7294599998 37.7292886590466 -122.46785994299101 (37.7292886590466, -122.467859942991)
711 212429 1 16 384 San Benito Way 2 1 1 1   06/23/1999 12:00:00 AM 4 Width 3ft Permit Number 41587 5992663.86781 2094081.2472599999 37.7295268723689 -122.467662441966 (37.7295268723689, -122.467662441966)
714 206262 1 107 389 San Benito Way 1 1 1 1   06/30/2005 12:00:00 AM 17 Width 3ft Permit Number 48035 5992637.65541 2093989.35221 37.729273037804 -122.46774637929501 (37.729273037804, -122.467746379295)
718 99173 1 60 2100 Webster St 9 1 1 1     14 3x3 Permit Number 25928 6003311.25259 2116120.54401 37.790650512059 -122.432426898975 (37.790650512059, -122.432426898975)
719 246969 1 10 299 Noe St 1 4 1 1   09/06/2016 12:00:00 AM 9 Width 4ft Permit Number 778955 6002937.11929 2106633.84457 37.7645811776972 -122.433043298823 (37.7645811776972, -122.433043298823)
724 25734 1 100 500X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
726 44958 1 17   82 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
728 2813 1 32 1075 California St 4 1 1 1     20 2X2   6009225.04881 2116342.3210299998 37.7915930222591 -122.41198109107599 (37.7915930222591, -122.411981091076)
729 48266 1 17   130 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
730 195047 1 15 360 06th St 2 4 1 2   03/26/2005 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.777673209496605 -122.404737337955 (37.7776732094966, -122.404737337955)
734 173936 1 17 614 Alabama St 6 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
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)
739 13244 1 79 2353 Lombard St 3 1 1 1   02/18/2012 12:00:00 AM 3 3x3   6001169.3018 2119289.54 37.7992300540772 -122.44006524578501 (37.7992300540772, -122.440065245785)
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)
742 35926 1 12 2660 Pacific Ave 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773492 6001423.81293 2116968.31873 37.7928710739952 -122.43901810580799 (37.7928710739952, -122.439018105808)
743 224663 1 17 614 Alabama St 3 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008964.71968 2105285.1997599998 37.761218168313704 -122.412100053373 (37.7612181683137, -122.412100053373)
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)
751 224664 1 17 614 Alabama St 2 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008962.07625 2105304.40117 37.761270742678704 -122.412110552966 (37.7612707426787, -122.412110552966)
755 224665 1 17 614 Alabama St 1 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008961.65131 2105333.13094 37.7613496042185 -122.412114053139 (37.7613496042185, -122.412114053139)
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)
768 13057 1 21 566 Lombard St 1 1 1 1   04/04/2014 12:00:00 AM 3 2x2   6009630.8999 2120542.6321 37.8031488074681 -122.410873631329 (37.8031488074681, -122.410873631329)
771 224662 1 17 614 Alabama St 4 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008966.3106 2105264.00424 37.7611600595223 -122.412093053058 (37.7611600595223, -122.412093053058)
774 231034 1 17 3050 19th St 1 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008943.01244 2104996.16235 37.760423319597294 -122.412154701577 (37.7604233195973, -122.412154701577)
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)
776 196857 1 9 487 Tehama St 1 1 1 1     2 Width 3ft   6010733.79239 2111871.68352 37.7794022433647 -122.406445673949 (37.7794022433647, -122.406445673949)
788 173935 1 17 614 Alabama St 5 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
793 65876 1 17   1 1 1 1   05/25/1990 12:00:00 AM     Permit Number 28874          
802 64866 1 2 2185 Hayes St 1 1 1 1 1 02/02/1989 12:00:00 AM 13   Permit Number 25884 5997401.9097 2109840.7512 37.773070992957 -122.45241943675501 (37.773070992957, -122.452419436755)
809 46145 1 17   3 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44490          
814 44650 1 17   70 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
823 13156 1 79 1875 Lombard St 1 1 1 1     24 3x3   6003411.9498 2119598.2407 37.800205081624604 -122.432326975222 (37.8002050816246, -122.432326975222)
830 12894 1 16 255X Larch St 4 1 1 1   02/02/1990 12:00:00 AM 3 3X3   6006443.29256 2113021.2667 37.7823177635948 -122.421370005133 (37.7823177635948, -122.421370005133)
833 251388 1 115 1658 Quesada Ave 1 1 1 1   04/19/2017 12:00:00 AM 3     6014992.0461800005 2094842.7959900002 37.732881854221894 -122.39052423440701 (37.7328818542219, -122.390524234407)
847 107475 1 44 1099x Masonic Ave 1 1 1 1     3 3x3   5999355.4 2109104.7 37.77116170781979 -122.445609151717 (37.7711617078198, -122.445609151717)
849 93578 1 46 401X Francisco St 1 1 1 1   05/06/2010 12:00:00 AM 1 3x3 Permit Number 53401 6009309.6837 2121148.6264 37.8047947000965 -122.41202806393 (37.8047947000965, -122.41202806393)
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)
862 141567 1 17 501X Baker St 3 1 1 1   04/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779825 6000588.8239 2110706.7362 37.7756308363396 -122.44145768074499 (37.7756308363396, -122.441457680745)
864 37366 1 50 125 Street 1 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
872 5299 1 2 1635 Divisadero St 1 1 1 1     11 3x3   6001101.8528 2114070.3216 37.7848955998057 -122.43992421757 (37.7848955998057, -122.43992421757)
876 192614 1 11 1500 Mission St 1 1 1 1   06/02/2016 12:00:00 AM 4 Width 3ft   6007548.67256 2110072.64933 37.774283827466896 -122.417336847918 (37.7742838274669, -122.417336847918)
878 108700 1 21 3024 Pierce St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772805 6001479.41501 2118822.32035 37.7979648412708 -122.438958648025 (37.7979648412708, -122.438958648025)
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)
888 14525 1 55 638 Masonic Ave 1 1 1 1     45 3X3   5999197.0779 2110617.9064 37.7753075467631 -122.44626566212901 (37.7753075467631, -122.446265662129)
897 22581 1 60 799X Turk St 10 1 1 1     18 4X4   6006522.42636 2112846.04587 37.7818411112169 -122.42108379139799 (37.7818411112169, -122.421083791398)
899 23949 1 120 2400X Sacramento St 5 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003202.444680001 2115904.93175 37.7900523252984 -122.43278795880501 (37.7900523252984, -122.432787958805)
906 238924 1 9 1362 South Van Ness Ave 1 1 1 1   09/12/2016 12:00:00 AM 1 Width 3ft Permit Number 777634 6007680.96975 2101719.66165 37.751355903252 -122.41628746589 (37.751355903252, -122.41628746589)
910 7954 1 32 1756 Franklin St 1 1 1 1     14 3X3   6005736.45543 2116153.36588 37.7908778543671 -122.424038156058 (37.7908778543671, -122.424038156058)
Powered by Datasette · Query took 2.015ms · Data source: data.sfgov.org