sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2772 252949 2 15 261x Winding Way 1 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
2810 23452 1 15 2209 Van Ness Ave 1 1 1 1     12 3X3   6005880.951090001 2118079.82441 37.796175582497504 -122.423675237326 (37.7961755824975, -122.423675237326)
2877 2888 1 15 1541 California St 1 1 1 1     65 3X3   6007004.32462 2116031.27674 37.7906141281881 -122.41964270965201 (37.7906141281881, -122.419642709652)
2892 99717 5 15 1415 Scott St 5 1 1 1     12 3x3   6001694.9164 2113468.8804 37.7832779377979 -122.437829320807 (37.7832779377979, -122.437829320807)
2941 246063 1 15 657 Ashbury St 1 1 1 1     15 Width 0ft Permit Number 41993 5998975.8774 2108455.663 37.769357942133205 -122.446875218626 (37.7693579421332, -122.446875218626)
2942 95170 1 15 1306 Divisadero St 1 1 1 1   05/06/2015 12:00:00 AM 3 3x3   6001329.6747 2112935.9507 37.781793873207 -122.439054702012 (37.781793873207, -122.439054702012)
3160 109437 1 15 940 Grove St 3 1 1 1     16 4x6   6003136.3777 2111029.1486 37.7766609049 -122.432668109569 (37.7766609049, -122.432668109569)
3168 33093 1 15   9 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
3185 3123 1 15 3195 California St 1 1 1 1     20 3X2   5999194.2227 2114949.0037 37.787199455340705 -122.44658721654801 (37.7871994553407, -122.446587216548)
3277 3186 1 15 3633 California St 1 1 1 1     45 3X3   5997046.4391 2114650.2263 37.7862561763922 -122.45399645741999 (37.7862561763922, -122.45399645742)
3301 3014 1 15 2450 California St 2 1 1 1     22 3X3   6002569.4448 2115483.65814 37.7888596947603 -122.43494794241501 (37.7888596947603, -122.434947942415)
3391 2983 1 15 2226 California St 1 1 1 1     35 3X3   6003696.67837 2115640.99047 37.7893556277051 -122.431059105706 (37.7893556277051, -122.431059105706)
3415 58712 1 15 688 Hayes St 1 1 1 1   05/10/1979 12:00:00 AM 12 3x3 Permit Number 17946 6004581.34636 2110890.2862299997 37.776361463754604 -122.427659641397 (37.7763614637546, -122.427659641397)
3442 2868 1 15 1389 California St 1 1 1 1     12 3X3   6007715.890269999 2116130.82655 37.790927523941704 -122.417187783496 (37.7909275239417, -122.417187783496)
3452 2818 1 15 1100X California St 4 1 1 1     35 3X3   6008957.0218 2116372.57941 37.79166106316271 -122.412910605154 (37.7916610631627, -122.412910605154)
3454 23347 1 15 1245 Van Ness Ave 1 1 1 1     6 0   6006327.19373 2114871.36437 37.7873911306548 -122.421903118752 (37.7873911306548, -122.421903118752)
3457 108164 1 15 1501X Filbert St 2 1 1 1   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005639.99861 2119248.14004 37.7993698763863 -122.42459213123301 (37.7993698763863, -122.424592131233)
3460 249511 1 15 1243 Van Ness Ave 1 1 1 1     7 Width 4ft   6006333.62129 2114827.84877 37.7872720100542 -122.421877788428 (37.7872720100542, -122.421877788428)
3631 133550 1 15 3498 Clay St 2 1 1 1   05/07/2014 12:00:00 AM 1 Width 3ft Permit Number 772596 5998146.13345 2115528.5550599997 37.7887308273139 -122.450255153677 (37.7887308273139, -122.450255153677)
3632 122539 2 15 3443 Clay St 3 1 1 1     12 3x3 Permit Number 779060 5998247.97366 2115501.74936 37.788663053514 -122.44990087023001 (37.788663053514, -122.44990087023)
3633 133551 1 15 3498 Clay St 3 1 1 1   05/07/2014 12:00:00 AM 1 Width 3ft Permit Number 772596 5998134.73529 2115528.0239 37.788728716592104 -122.45029455117701 (37.7887287165921, -122.450294551177)
3638 2840 1 15 1255 California St 1 1 1 1     8 3x3   6008320.47773 2116218.27733 37.7912016363983 -122.41510212258301 (37.7912016363983, -122.415102122583)
3673 3073 1 15 2880 California St 1 1 1 1   10/12/1998 12:00:00 AM 3 3X3   6000583.9217 2115208.18648 37.7879903857924 -122.44179777983999 (37.7879903857924, -122.44179777984)
3722 2900 1 15 1675 California St 1 1 1 1     35 3X3   6006330.22809 2115940.35545 37.7903264863286 -122.4219685876 (37.7903264863286, -122.4219685876)
3836 3098 1 15 3014 California St 1 1 1 1     14 3x3   5999901.41366 2115112.8463 37.7876896938595 -122.444152274206 (37.7876896938595, -122.444152274206)
3891 2801 1 15 1000X California St 6 1 1 1     25 3X3   6009324.7749 2116423.80567 37.791822353872796 -122.411641798449 (37.7918223538728, -122.411641798449)
4009 34002 1 15   1 1 1 1         Permit Number 37940          
4013 253610 2 15 1075 Mission St 16 1 1 1       Width 4ft   6009725.02676 2112060.52163 37.7798642637711 -122.40994876804 (37.7798642637711, -122.40994876804)
4171 39901 1 15   3 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
4313 2803 1 15 1055 California St 2 1 1 1     25 3X3   6009318.69522 2116357.3469700003 37.791639533399795 -122.41165813642999 (37.7916395333998, -122.41165813643)
4339 3082 1 15 2913 California St 1 1 1 1     45 3X3   6000319.2838 2115099.7465 37.7876775552832 -122.442705587482 (37.7876775552832, -122.442705587482)
4361 2887 1 15 1530 California St 1 1 1 1     65 3x3   6007023.220480001 2116101.4928900003 37.7908079887437 -122.41958231479401 (37.7908079887437, -122.419582314794)
4460 55487 1 15 601 Steiner St 2 1 1 1 1 07/16/1987 12:00:00 AM 20 6x9 Permit Number 24565 6003098.1372 2110364.0779 37.774832616894706 -122.43275287348601 (37.7748326168947, -122.432752873486)
4471 100799 2 15 2455 Jackson St 1 1 1 1     18 3x3   6002438.67863 2116735.02721 37.7922882071812 -122.435489929626 (37.7922882071812, -122.435489929626)
4495 2802 1 15 1055 California St 1 1 1 1     25 3X3   6009267.5769 2116351.4322900004 37.7916204254988 -122.411834587904 (37.7916204254988, -122.411834587904)
4567 109546 2 15 300x Van Ness Ave 2 1 1 1     4 3x3   6006868.4272 2111721.79621 37.778773692788 -122.419806988803 (37.778773692788, -122.419806988803)
4621 122573 2 15 2014 Buchanan St 1 1 1 1     12 4x4   6003898.8446 2115409.2515 37.7887307847056 -122.430343093484 (37.7887307847056, -122.430343093484)
4628 3096 1 15 3003 California St 1 1 1 1     45 3X3   5999955.8775 2115049.7006 37.787519419160795 -122.443959301682 (37.7875194191608, -122.443959301682)
4639 102681 2 15 2100 Scott St 1 1 1 1     24 4x4   6001426.627069999 2115693.54787 37.7893710438761 -122.43891697256399 (37.7893710438761, -122.438916972564)
4715 103364 2 15 1171X Sacramento St 3 1 1 1 7   3 3x3   6009173.30525 2116699.27717 37.79257023366971 -122.412185363057 (37.7925702336697, -122.412185363057)
4730 234655 2 15 437 Noe St 1 1 1 1     16 6x12   6002991.56268 2105705.90685 37.762036373292 -122.432788699846 (37.762036373292, -122.432788699846)
4737 18665 1 15 68 Richardson Ave 1 1 1 1     18 3X3   5999650.82657 2119343.62461 37.799291994198796 -122.445323565644 (37.7992919941988, -122.445323565644)
4784 248429 1 15 735 Clayton St 1 1 1 1     10 Width 0ft   5998546.7685 2108037.7588 37.7681859595657 -122.448329381959 (37.7681859595657, -122.448329381959)
4818 2858 1 15 1350 California St 1 1 1 1     10 3X3   6007920.97179 2116228.0555 37.7912060259903 -122.416485098214 (37.7912060259903, -122.416485098214)
4826 248398 1 15 726 Clayton St 1 1 1 1     18 Width 0ft   5998582.351 2108084.2431 37.768315627898005 -122.448209653817 (37.768315627898, -122.448209653817)
4842 53619 1 15 2635 Scott St 1 1 1 1   12/29/1969 12:00:00 AM 14 6x9 Permit Number 6550 6001139.602580001 2117434.01333 37.794133574667 -122.44003489281 (37.794133574667, -122.44003489281)
4897 27584 1 15 1785 Turk St 1 1 1 1   09/29/2000 12:00:00 AM 3 3X3   6001489.4944 2112142.9438 37.77962556986321 -122.43844496845199 (37.7796255698632, -122.438444968452)
4910 24648 1 15 1401X Divisadero St 3 1 1 1   10/19/1995 12:00:00 AM 3 3X3   6001203.4433 2113355.9321 37.782939851650895 -122.439521518598 (37.7829398516509, -122.439521518598)
5033 69190 1 15 2401 Jackson St 1 1 1 1   01/27/1994 12:00:00 AM 12 3x3 Permit Number 33233 6002598.67193 2116757.13717 37.7923580008738 -122.43493793203501 (37.7923580008738, -122.434937932035)
5139 235614 2 15 573 Valencia St 1 1 1 1     7 Width 3ft   6006249.0 2106283.0 37.7638051443341 -122.421563455709 (37.7638051443341, -122.421563455709)
5166 235615 2 15 573 Valencia St 2 1 1 1     6 Width 3ft   6006249.0 2106283.0 37.7638051443341 -122.421563455709 (37.7638051443341, -122.421563455709)
5215 3081 1 15 2912 California St 1 1 1 1     3 3x3   6000297.468780001 2115166.83236 37.787860511999995 -122.442785882062 (37.787860512, -122.442785882062)
5243 2979 1 15 2201 California St 2 1 1 1     25 3X2   6003796.8849 2115584.1912 37.7892053489441 -122.430708347922 (37.7892053489441, -122.430708347922)
5274 58105 1 15 920 Van Ness Ave 1 1 1 1   12/29/1977 12:00:00 AM 5   Permit Number 17081 6006591.68402 2113670.96002 37.7841100278879 -122.42090277676701 (37.7841100278879, -122.420902776767)
5283 2897 1 15 1635 California St 1 1 1 1     35 3X3   6006502.249530001 2115965.50958 37.7904052534492 -122.42137519153098 (37.7904052534492, -122.421375191531)
5301 45635 1 15 851 Van Ness Ave 4 1 1 1   08/23/2002 12:00:00 AM 7   Permit Number 44342 6006530.053069999 2113426.6825900003 37.7834358277545 -122.421098647281 (37.7834358277545, -122.421098647281)
5305 3116 1 15 3151 California St 1 1 1 1     45 3X3   5999317.7381 2114962.1143 37.7872425080555 -122.44616082493799 (37.7872425080555, -122.446160824938)
5319 2956 1 15 2022 California St 1 1 1 1     35 3X3   6004492.42277 2115751.35307 37.7897037139057 -122.428313790248 (37.7897037139057, -122.428313790248)
5330 103513 2 15 1859 Green St 2 1 1 1     8 3x3   6004155.22179 2118342.1254 37.7967982290065 -122.429665326519 (37.7967982290065, -122.429665326519)
5345 2950 1 15 2000 California St 2 1 1 1     11 3X3   6004708.4584 2115781.93381 37.7897999027004 -122.427568507708 (37.7897999027004, -122.427568507708)
5346 109550 2 15 300x Van Ness Ave 6 1 1 1     4 3x3   6006859.56746 2111778.81942 37.778929765630295 -122.41984168553999 (37.7789297656303, -122.41984168554)
5349 2825 1 15 1100X California St 11 1 1 1     20 3X3   6008708.35177 2116339.22144 37.791555508841206 -122.413768643818 (37.7915555088412, -122.413768643818)
5354 109556 2 15 300x Van Ness Ave 12 1 1 1     4 3x3   6006837.67499 2111950.4922 37.7793999042174 -122.41992960596501 (37.7793999042174, -122.419929605965)
5362 3137 1 15 3302 California St 1 1 1 1     35 2X3   5998543.29371 2114921.59911 37.787087006913296 -122.44883730591002 (37.7870870069133, -122.44883730591)
5376 112253 2 15 3401 Washington St 1 1 1 1     12 3x3   5998472.27762 2115859.72352 37.789658787381796 -122.449150614422 (37.7896587873818, -122.449150614422)
5394 2865 1 15 1370 California St 1 1 1 1     14 3X3   6007816.79371 2116213.72438 37.7911608170581 -122.41684453654699 (37.7911608170581, -122.416844536547)
5398 98494 2 15 2820 Baker St 1 1 1 1     14 3x3   5999556.928169999 2118555.98315 37.79712398054429 -122.44559181541099 (37.7971239805443, -122.445591815411)
5414 3114 1 15 3150 California St 3 1 1 1     12 3X2   5999305.56047 2115029.35273 37.7874264317373 -122.446207795272 (37.7874264317373, -122.446207795272)
5426 2882 1 15 1499 California St 1 1 1 1     45 3X3   6007281.77747 2116069.5098599996 37.7907347317813 -122.418685448789 (37.7907347317813, -122.418685448789)
5447 3170 1 15 3468X California St 2 1 1 1     45 3X3   5997817.62351 2114819.66546 37.786765599102395 -122.45134059761001 (37.7867655991024, -122.45134059761)
5468 3007 1 15 2383 California St 1 1 1 1     16 2X3   6003000.8179 2115475.95 37.788863013488296 -122.433454901543 (37.7888630134883, -122.433454901543)
5470 100796 2 15 2477 Jackson St 1 1 1 1     16 3x3   6002339.98716 2116721.3494700002 37.79224504601171 -122.43583042464199 (37.7922450460117, -122.435830424642)
5488 5869 1 15 1010X Eddy St 2 1 1 1     12 3X3   6005558.007 2113111.8938 37.7825166508653 -122.424439152252 (37.7825166508653, -122.424439152252)
5489 92814 1 15 2801 Jackson St 1 1 1 1   11/06/2009 12:00:00 AM 6 3x3 Permit Number 53021 6000681.38674 2116493.06256 37.791523874264705 -122.44155280902201 (37.7915238742647, -122.441552809022)
5505 3198 1 15 3700X California St 5 1 1 1     8 3X3   5996450.47097 2114631.1669799997 37.786169655243704 -122.45605696165501 (37.7861696552437, -122.456056961655)
5519 2854 1 15 1325 California St 1 1 1 1     45 3X3   6007999.55811 2116173.32334 37.7910601640548 -122.41620931301 (37.7910601640548, -122.41620931301)
5537 108160 1 15 2559 Van Ness Ave 3 1 1 1   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005726.72514 2119185.00062 37.7992014090788 -122.42428753355301 (37.7992014090788, -122.424287533553)
5599 3028 1 15 2545 California St 1 1 1 1     65 3X3   6002144.8336 2115361.2222 37.7884993990958 -122.436408269694 (37.7884993990958, -122.436408269694)
5609 105280 2 15 3017 Webster St 1 1 1 1     20 3x3   6002863.14914 2118997.09169 37.7985233499191 -122.43418303843399 (37.7985233499191, -122.434183038434)
5610 109560 2 15 300x Van Ness Ave 16 1 1 1     4 3x3   6006827.8052900005 2112008.26753 37.7795579852454 -122.41996785053101 (37.7795579852454, -122.419967850531)
5640 79352 2 15 2909 Bush St 1 1 1 1 1 09/08/2001 12:00:00 AM 8 3x3   5999487.033 2114286.0485 37.785395874336 -122.445526470028 (37.785395874336, -122.445526470028)
5656 95168 1 15 1304 Divisadero St 1 1 1 1     3 3x3   6001332.382 2112914.9685 37.7817364154726 -122.43904383182199 (37.7817364154726, -122.439043831822)
5658 13028 1 15 454 Lombard St 3 1 1 1     30 3X3   6010168.2162 2120621.6241 37.8033958137672 -122.40901980222401 (37.8033958137672, -122.409019802224)
5662 2799 1 15 1000X California St 4 1 1 1     35 3X3   6009392.24103 2116434.8412200003 37.7918564390776 -122.411409144728 (37.7918564390776, -122.411409144728)
5711 2967 1 15 2119 California St 1 1 1 1     45 3X3   6004200.3541 2115640.9046 37.7893839195842 -122.42931643968201 (37.7893839195842, -122.429316439682)
5720 2839 1 15 1245 California St 1 1 1 1     25 3X3   6008398.91585 2116229.07014 37.791235678433296 -122.414831492307 (37.7912356784333, -122.414831492307)
5727 3064 1 15 2825 California St 1 1 1 1     30 3X3   6000790.4891 2115166.9367 37.787888892538206 -122.44108013491501 (37.7878888925382, -122.441080134915)
5749 3071 1 15 2870 California St 1 1 1 1   06/19/1998 12:00:00 AM 3 3X3   6000614.84019 2115212.41465 37.7880037569245 -122.44169111125 (37.7880037569245, -122.44169111125)
5779 24620 1 15 1008 Divisadero St 1 1 1 1     5 3x3   6001476.3994 2111883.9213 37.7789136147751 -122.43847170626499 (37.7789136147751, -122.438471706265)
5817 103362 2 15 1171X Sacramento St 1 1 1 1 7   12 3x3   6009111.87446 2116690.2667799997 37.7925420462198 -122.41239727931601 (37.7925420462198, -122.412397279316)
5850 26674 1 15 1825 Sutter St 2 1 1 1     24 3x3   6003781.9718 2114546.3993 37.786354989662705 -122.430685859171 (37.7863549896627, -122.430685859171)
5857 99700 2 15 1412 Jackson St 1 1 1 1     30 4x4   6007375.87378 2117463.43004 37.794567388720296 -122.41845876116301 (37.7945673887203, -122.418458761163)
5882 109553 2 15 300x Van Ness Ave 9 1 1 1     4 3x3   6006853.14044 2111821.07903 37.7790454382325 -122.41986691873801 (37.7790454382325, -122.419866918738)
5892 23502 1 15 2550 Van Ness Ave 3 1 1 1     12 3X3   6005823.04846 2119213.04912 37.7992838616217 -122.423956217027 (37.7992838616217, -122.423956217027)
5912 35691 1 15   1 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
5935 18670 1 15 99X Richardson Ave 1 1 1 1     12 2x2   5999509.53732 2119357.2628900004 37.799321375051704 -122.445813455145 (37.7993213750517, -122.445813455145)
5953 18676 1 15 133 Richardson Ave 1 1 1 1     12 4X4   5999263.47679 2119581.27708 37.7999224054595 -122.44668103382901 (37.7999224054595, -122.446681033829)
5955 30167 1 15 3110 California St 1 1 1 1   04/04/2007 12:00:00 AM 3 3X3   5999426.69765 2115046.3511900003 37.7874800223365 -122.445789909978 (37.7874800223365, -122.445789909978)
5956 2708 1 15 2140 Bush St 3 1 1 1     18 3X3   6003264.856000001 2114868.535 37.7872101826993 -122.43249796405 (37.7872101826993, -122.43249796405)
5983 7747 1 15 400X Franklin St 4 1 1 1     12 3X3   6006377.68827 2111578.0704799998 37.7783513990461 -122.421494439834 (37.7783513990461, -122.421494439834)
6002 95174 1 15 999 Divisadero St 2 1 1 1     5 3x3   6001433.5416 2111715.5330000003 37.7784488251579 -122.43860789955099 (37.7784488251579, -122.438607899551)
Powered by Datasette · Query took 32.157ms · Data source: data.sfgov.org