sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
407 248462 1 16 130 Beulah St 1 1 1 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
408 23369 1 15 1350 Van Ness Ave 1 1 1 1     13 4x4   6006387.07969 2115184.64805 37.788254707334 -122.421718185767 (37.788254707334, -122.421718185767)
414 17191 1 26 1804X Bush St 2 1 1 1     10 4X4   6004806.1465 2115088.0891 37.7879003042654 -122.427181073064 (37.7879003042654, -122.427181073064)
420 54426 1 20 770 Carolina St 1 1 1 1   07/02/1973 12:00:00 AM 15 3x3 Permit Number 12242 6012397.0815 2104349.75534 37.758841631549394 -122.400163199892 (37.7588416315494, -122.400163199892)
422 23174 1 15 240 Van Ness Ave 1 1 1 5     5 3x3   6006908.21847 2111432.04348 37.777980343250796 -122.419648771078 (37.7779803432508, -122.419648771078)
424 122666 1 11 401x Laguna St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
426 21683 1 35 1840 Sutter St 1 1 1 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
430 103824 1 21 1000 Polk St 4 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006951.91038 2114418.6460599997 37.786183288961205 -122.419709589538 (37.7861832889612, -122.419709589538)
435 95185 1 15 1401X Divisadero St 6 1 1 1     3 3x3   6001223.4102 2113260.1588 37.78267801898829 -122.43944557401699 (37.7826780189883, -122.439445574017)
438 157409 1 58 125 Highland Ave 1 1 1 1   04/06/2017 12:00:00 AM 3 3x5   6005572.56549 2096690.1102099998 37.7374271143738 -122.423221099494 (37.7374271143738, -122.423221099494)
440 157410 1 58 125 Highland Ave 2 1 1 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
441 251295 1 2 220 Point Lobos Ave 1 1 1 1   06/26/1989 12:00:00 AM   3x3 Permit Number 27117 5982087.0 2112698.0 37.7800268469822 -122.50560657808902 (37.7800268469822, -122.505606578089)
442 9602 1 26 1355 Golden Gate Ave 4 1 1 1     11 3X3   6003083.4108 2112017.0963 37.779370559175206 -122.432921935155 (37.7793705591752, -122.432921935155)
444 44838 1 17   12 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
459 35612 1 46 2839 Pacific Ave 1 1 1 1   05/11/2012 12:00:00 AM 5 3x3 Permit Number 768882 6000549.03074 2116799.12347 37.792356695946005 -122.442032735847 (37.792356695946, -122.442032735847)
467 85277 1 61 801 Holladay Ave 1 1 1 1   07/24/2007 12:00:00 AM     Permit Number 49566          
468 18829 1 41 1940 Sacramento St 1 1 1 1     12 4.5x4.5   6005473.09052 2116220.8866 37.791048376629 -122.42495419379601 (37.791048376629, -122.424954193796)
469 85530 1 49 101X 12th St 2 1 1 1   05/29/2007 12:00:00 AM 6     6007333.48731 2109350.5044400003 37.772288880253704 -122.418030010287 (37.7722888802537, -122.418030010287)
488 2821 1 15 1100X California St 7 1 1 1     45 3X3   6008831.67633 2116355.92064 37.7916082855564 -122.41334312239701 (37.7916082855564, -122.413343122397)
504 81687 1 89 210 Frederick St 1 1 1 1   04/10/2017 12:00:00 AM 3   Permit Number 777040 5999000.68344445 2107685.40393875 37.7672444226119 -122.446733986311 (37.7672444226119, -122.446733986311)
506 4706 1 11 950 Columbus Ave 1 1 1 1   04/10/2017 09:29:00 PM 3 4x4   6008667.8262 2120581.3066 37.8032009492885 -122.414209123056 (37.8032009492885, -122.414209123056)
509 38234 1 68 0 16th St 4 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
510 7848 1 26 885 Franklin St 4 1 1 1     3 4X4   6006120.7355 2113033.04101 37.7823319018231 -122.422486748168 (37.7823319018231, -122.422486748168)
515 48129 1 17   297 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
524 4705 1 11 940 Columbus Ave 2 1 1 1   04/10/2017 09:01:00 PM 3 3X3   6008689.9314 2120561.6575 37.8031482394038 -122.414131236147 (37.8031482394038, -122.414131236147)
529 232316 1 92 79 Elsie St 1 1 1 1   12/28/2016 12:00:00 AM 22 Width 3ft Permit Number 778647 6007387.04905 2098921.1752299997 37.743655357512104 -122.417105607056 (37.7436553575121, -122.417105607056)
530 8262 1 87 1555 Galvez Ave 5 1 1 1   04/10/2017 01:22:00 PM 3 3x3   6016000.34735 2097516.43828 37.7402790201492 -122.38722467697501 (37.7402790201492, -122.387224676975)
531 27691 1 93 1765 Turk St 1 1 1 1   08/25/2015 12:00:00 AM 7 3X3   6001581.2067 2112155.8038 37.779666096456 -122.438128618136 (37.779666096456, -122.438128618136)
534 2998 1 15 2314 California St 1 1 1 1     45 3X3   6003265.59996 2115577.92692 37.7891580349704 -122.43254607984501 (37.7891580349704, -122.432546079845)
536 45913 1 17   59 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
538 224356 1 32 3122 16th St 1 1 1 1   08/27/1976 12:00:00 AM 20 Width 4ft Permit Number 16121 6005963.44888 2106707.74991 37.7649553019601 -122.422581275918 (37.7649553019601, -122.422581275918)
540 224369 1 32 3159 16th St 1 1 1 1   01/02/1981 12:00:00 AM 16 Width 3ft Permit Number 18874 6005753.01157 2106639.16646 37.7647551137777 -122.423304250809 (37.7647551137777, -122.423304250809)
542 224353 1 32 3024 16th St 1 1 1 1     21 Width 4ft   6006632.75905 2106740.0972599997 37.7650818572521 -122.42026859194901 (37.7650818572521, -122.420268591949)
543 224593 1 94 3131 16th St 1 1 1 1   01/02/1981 12:00:00 AM 13 Width 3ft Permit Number 18870 6005970.19181 2106649.76485 37.7647964691065 -122.42255383310801 (37.7647964691065, -122.422553833108)
544 224355 1 32 3120 16th St 1 1 1 1   08/27/1976 12:00:00 AM 23 Width 6ft Permit Number 16120 6005992.7506800005 2106707.14788 37.7649553019752 -122.42247988543501 (37.7649553019752, -122.422479885435)
547 224594 1 94 3133 16th St 1 1 1 1   01/02/1981 12:00:00 AM 14 Width 3ft Permit Number 18871 6005947.45622 2106648.2222599997 37.7647909508601 -122.42263236011001 (37.7647909508601, -122.42263236011)
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)
550 3006 1 15 2380 California St 1 1 1 1     75 3X3   6002989.49365 2115542.57517 37.7890453067372 -122.433498845012 (37.7890453067372, -122.433498845012)
554 31894 1 96 333 12th St 3 1 1 1 1 06/26/1995 12:00:00 AM 6   Permit Number 35323 6008421.36423 2108725.6861900003 37.7706344442547 -122.41422271959999 (37.7706344442547, -122.4142227196)
559 224354 1 32 3030 16th St 1 1 1 1   08/27/1976 12:00:00 AM 21 Width 4ft Permit Number 16115 6006614.25148 2106740.2812200002 37.7650813194782 -122.420332618267 (37.7650813194782, -122.420332618267)
564 222895 1 97 3080 16th St 2 1 1 1     10 Width 3ft Permit Number 27054 6006273.18784 2106724.0940099997 37.765017648370105 -122.42151112584801 (37.7650176483701, -122.421511125848)
568 222894 1 97 3080 16th St 1 1 1 1   06/14/1989 12:00:00 AM 14 Width 3ft Permit Number 27054 6006296.82054 2106727.45524 37.765028210007 -122.42142962480301 (37.765028210007, -122.421429624803)
570 22578 1 60 799X Turk St 6 1 1 1     18 4X4   6006396.3025 2112828.5224900004 37.7817858856438 -122.421518877095 (37.7817858856438, -122.421518877095)
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)
Powered by Datasette · Query took 1.978ms · Data source: data.sfgov.org