sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3289 253392 4 46 115 Steuart St 1 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3293 253393 4 46 115 Steuart St 2 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3299 192595 4 11 1321 Mission St 2 1 1 1   01/27/2015 12:00:00 AM 3 Width 4ft Permit Number 770747 6008285.14461 2110684.68439 37.776005738696604 -122.414832573262 (37.7760057386966, -122.414832573262)
3302 192594 4 11 1321 Mission St 1 1 1 1   01/27/2015 12:00:00 AM 2 Width 4ft Permit Number 770747 6008274.3646 2110675.08431 37.775978773435504 -122.414869184668 (37.7759787734355, -122.414869184668)
3307 192596 4 11 1335 Mission St 3 1 1 1   01/27/2015 12:00:00 AM 3 Width 4ft Permit Number 770747 6008295.90964 2110693.56586 37.776030729971794 -122.41479596277901 (37.7760307299718, -122.414795962779)
3316 253394 4 46 115 Steuart St 3 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
3345 253419 4 54 3499 Jackson St 1 1 1 1       3x3   5997570.0 2115996.0 37.78998131889129 -122.452282225129 (37.7899813188913, -122.452282225129)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
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)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
3518 201693 4 11 342 08th St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009930.218780001 2109950.89592 37.774083223805206 -122.409090015305 (37.7740832238052, -122.409090015305)
3519 253478 4 87 1222 Harrison St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3524 201692 4 11 324 08th St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009893.13849 2109987.83278 37.7741825665069 -122.409220890035 (37.7741825665069, -122.409220890035)
3525 253489 4 31 1x Gordon St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3526 201695 4 11 342 08th St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.5710299998 37.773996196412604 -122.40898095270398 (37.7739961964126, -122.408980952704)
3531 201691 4 11 324 08th St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009873.18605 2110010.6659 37.7742441430989 -122.40929152101002 (37.7742441430989, -122.40929152101)
3532 253483 4 31 1x Gordon St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 4 31 1x Gordon St 9 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3535 253480 4 87 1222 Harrison St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3538 253485 4 31 1x Gordon St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 4 31 1x Gordon St 13 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3547 201698 4 11 342 08th St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010000.12901 2109874.7171 37.773877970619296 -122.408842806955 (37.7738779706193, -122.408842806955)
3550 201694 4 11 342 08th St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009941.3987 2109939.6045 37.77405284648871 -122.40905054497101 (37.7740528464887, -122.409050544971)
3553 253492 4 31 1x Gordon St 10 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 4 31 1x Gordon St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3556 201697 4 11 342 08th St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009987.20299 2109888.7351 37.7739157367544 -122.40888850959499 (37.7739157367544, -122.408888509595)
3560 201696 4 11 342 08th St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009973.11931 2109904.86997 37.773959250457004 -122.40893836622699 (37.773959250457, -122.408938366227)
3562 253488 4 31 1x Gordon St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 4 31 1x Gordon St 11 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3565 253475 4 87 1222 Harrison St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3566 201689 4 11 324 08th St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009821.14 2110064.65257 37.774389461835206 -122.40947536940399 (37.7743894618352, -122.409475369404)
3568 253479 4 87 1222 Harrison St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3569 201699 4 11 342 08th St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010014.86815 2109861.25987 37.7738418457656 -122.408790872027 (37.7738418457656, -122.408790872027)
3570 253476 4 87 1222 Harrison St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3573 253496 4 31 1x Gordon St 14 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3575 201690 4 11 324 08th St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009863.47645 2110020.43216 37.7742704149776 -122.409325797764 (37.7742704149776, -122.409325797764)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3583 201688 4 11 324 08th St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009806.99553 2110077.79875 37.7744247656342 -122.409525226004 (37.7744247656342, -122.409525226004)
3584 253477 4 87 1222 Harrison St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3587 253494 4 31 1x Gordon St 12 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3687 152811 4 26 2901 25th St 2 1 1 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102206999 (37.7511784382559, -122.40830102207)
3691 152812 4 26 2901 25th St 3 1 1 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.751181646126795 -122.40825175271401 (37.7511816461268, -122.408251752714)
3700 152810 4 26 2901 25th St 1 1 1 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.751177979599206 -122.408352609887 (37.7511779795992, -122.408352609887)
3753 253554 4 21 1855 30th Ave 1 1 1 1   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.48826692291901 (37.7526951056681, -122.488266922919)
3809 95203 4 51 314 Walnut St 1 1 1 1     0 3x3 Permit Number 769992 5998598.6333800005 2115400.1597599997 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474)
3823 102525 4 37 310 Walnut St 1 1 1 1   01/30/2013 12:00:00 AM 0 3x3 Permit Number 769739 5998596.991169999 2115413.44206 37.7884405486385 -122.448686963531 (37.7884405486385, -122.448686963531)
3858 35488 4 69 2655 Bush St 1 1 1 1   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094)
3868 253576 4 37 2622 Judah St 1 1 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417.0 2105735.0 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097)
3890 161753 4 49 175x Newton St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022.0 2087749.0 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288)
3901 253246 4 49 1192 Naples St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001173.0 2087586.0 37.7121800264355 -122.437780563503 (37.7121800264355, -122.437780563503)
4329 239457 4 18 165 Sussex St 2 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4369 222216 4 28 2 Van Buren St 1 1 1 2     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887)
4385 224618 4 94 165 Sussex St 1 1 1 2     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198)
4401 239088 4 9 3855 26th St 1 1 1 2     13 3x3 Permit Number 780732 6004794.15723 2100737.4007099997 37.748496089721996 -122.426200479689 (37.748496089722, -122.426200479689)
4404 239458 4 18 165 Sussex St 3 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
4434 253623 4 51 1331 39th Ave 1 1 1 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 778744 5983976.422619999 2106100.27997 37.7620224120695 -122.498582815109 (37.7620224120695, -122.498582815109)
4790 158406 4 41 50 Conrad St 1 1 1 1   10/25/2017 12:00:00 AM 3 3X3 Permit Number 770857 6001789.37716 2096842.5543 37.7376314601307 -122.436312235543 (37.7376314601307, -122.436312235543)
4873 243284 4 49 1450 15th St 1 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007678.08789 2107386.86578 37.766916579475 -122.416698868869 (37.766916579475, -122.416698868869)
4880 253705 4 49 98X Shotwell St 2 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4888 151878 4 49 1450 15th St 3 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.0882099997 37.7669086438472 -122.41688659964599 (37.7669086438472, -122.416886599646)
4889 253706 4 49 98X Shotwell St 3 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4900 31068 4 49 1450 15th St 2 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007659.7746 2107385.50696 37.7669118184545 -122.41676211549999 (37.7669118184545, -122.4167621155)
4932 253743 4 11 1 Henry Adams St 9 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4941 253741 4 11 1 Henry Adams St 7 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4947 253753 4 11 2x Rhode Island St 7 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4951 253752 4 11 2x Rhode Island St 6 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4954 253735 4 11 1 Henry Adams St 1 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4958 253746 4 11 1 Henry Adams St 12 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4961 253750 4 11 2x Rhode Island St 4 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4964 253756 4 44 41x Division St 2 1 1 1   11/03/2017 12:00:00 AM 3 5x5   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4966 253751 4 11 2x Rhode Island St 5 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4970 253749 4 75 2x Rhode Island St 3 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4992 253754 4 11 2x Rhode Island St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4997 253742 4 11 1 Henry Adams St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4999 253739 4 11 1 Henry Adams St 5 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5007 253755 4 44 41x Division St 1 1 1 1   11/03/2017 12:00:00 AM 3 5x5   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5009 253747 4 11 2x Rhode Island St 1 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5010 253737 4 11 1 Henry Adams St 3 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5020 253748 4 75 2x Rhode Island St 2 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5024 253736 4 11 1 Henry Adams St 2 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5026 253744 4 11 1 Henry Adams St 10 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5027 253738 4 11 1 Henry Adams St 4 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5032 253740 4 11 1 Henry Adams St 6 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5036 253745 4 11 1 Henry Adams St 11 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5050 253762 4 54 520 08th Ave 1 1 1 1       3x3   5993490.0 2111935.0 37.778596343165496 -122.46610332918101 (37.7785963431655, -122.466103329181)
5087 150676 4 26 548 Rhode Island St 1 8 1 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
5103 253796 4 49 100 Scotia Ave 1 1 1 1   11/07/2017 12:00:00 AM 3   Permit Number 779938 6011980.63004 2095004.60122 37.733158617067296 -122.40094689916799 (37.7331586170673, -122.400946899168)
5192 243370 4 11 1 Hill St 2 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006249.2279900005 2103449.78821 37.756025819148796 -122.421361454386 (37.7560258191488, -122.421361454386)
5194 243372 4 11 1050 Valencia St 1 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006308.99467 2103436.4955 37.755992689926295 -122.42115381712 (37.7559926899263, -122.42115381712)
5195 253341 4 88 1935 46th Ave 1 5 1 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
5205 243371 4 11 1 Hill St 3 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006273.4727300005 2103450.37091 37.7560287860041 -122.42127764924 (37.7560287860041, -122.42127764924)
5242 243740 4 13 550 Laidley St 1 1 1 1   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.0557699995 2096015.8076799999 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248)
5296 117021 4 2 168 Hyde St 5 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008114.19003 2113031.70239 37.7824404814865 -122.415590162171 (37.7824404814865, -122.415590162171)
5549 117113 4 37 1650 Broadway 2 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821)
Powered by Datasette · Query took 2.496ms · Data source: data.sfgov.org