sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
558 251320 2 25 35 Park St 3 1 1 1       Width 3ft   6004965.06472 2096463.48809 37.7367705580153 -122.425305393447 (37.7367705580153, -122.425305393447)
580 48268 1 17   132 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
588 251328 2 17 95x Tompkins Ave 2 1 1 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
592 251331 2 32 2232 Webster St 2 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
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)
599 251330 2 32 2232 Webster St 1 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
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)
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)
626 251342 3 50 2275 Ocean Ave 2 1 1 2   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
628 251337 3 51 2230 Ocean Ave 1 1 1 2   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
629 251338 3 51 2230 Ocean Ave 2 1 1 2   05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
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)
635 251315 2 49 399X 12th St 5 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
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)
644 251319 2 49 399X 12th St 1 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
645 251316 2 49 399X 12th St 4 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
651 251359 2 2 4050 Geary Blvd 2 1 1 1       3x3   5994421.0 2112898.0 37.7812941506761 -122.462952553035 (37.7812941506761, -122.462952553035)
655 251353 2 26 510 22nd Ave 4 1 1 1       Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
667 251356 2 54 519 22nd Ave 1 1 1 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
674 251361 3 44 301 07th St 2 1 1 2       3x3   6010388.0 2110913.0 37.7767505721368 -122.40757431033701 (37.7767505721368, -122.407574310337)
675 47038 1 12 716 Walter St 1 1 1 1   05/02/2002 12:00:00 AM     Permit Number 45030          
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
689 48269 1 17   120 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
709 251360 3 44 301 07th St 1 1 1 2   03/29/1991 12:00:00 AM   3x3   6010388.0 2110913.0 37.7767505721368 -122.40757431033701 (37.7767505721368, -122.407574310337)
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
726 44958 1 17   82 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
729 48266 1 17   130 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
746 251371 3 43 390 06th St 3 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
747 251378 3 47 401 Portola Dr 6 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 3 47 401 Portola Dr 2 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
750 251368 3 111 270 06th St 7 1 1 2 3     3x3   6010822.0 2111616.0 37.7787051302825 -122.40612250689199 (37.7787051302825, -122.406122506892)
752 251380 2 12 731 Huron Ave 1 1 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
757 251377 3 47 401 Portola Dr 5 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 3 47 401 Portola Dr 1 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 3 47 401 Portola Dr 7 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
767 251382 2 58 731 Huron Ave 1 7 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
780 251383 2 113 49x Milan Ter 1 13 1 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
781 251370 3 44 390 06th St 2 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
782 251385 2 47 138x Gladeview Way 2 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
783 251381 2 12 731 Huron Ave 2 1 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
784 251384 2 47 138x Gladeview Way 1 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
786 251369 3 43 390 06th St 1 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
793 65876 1 17   1 1 1 1   05/25/1990 12:00:00 AM     Permit Number 28874          
809 46145 1 17   3 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44490          
813 251390 3 60 800x Bosworth St 7 1 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
814 44650 1 17   70 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
820 251223 3 12 80X Junipero Serra Blvd 22 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
821 251392 3 60 800x Bosworth St 9 5 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
844 251224 3 12 80X Junipero Serra Blvd 23 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
855 251398 2 94 299 Townsend St 3 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
858 251395 2 118 2101 26th St   1 1 1       3x3   6012226.0 2101445.0 37.750856267744496 -122.400550836744 (37.7508562677445, -122.400550836744)
859 251396 2 94 299 Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
864 37366 1 50 125 Street 1 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
881 251399 3 94 841 Columbus Ave 1 1 1 2       3x3   6008927.4869099995 2120274.72498 37.802373734427796 -122.413288863041 (37.8023737344278, -122.413288863041)
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
892 251400 2 111 101 Rhine St 5 2 1 1       Width 3ft   5994375.43496 2086552.5575599999 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
921 30278 1 17   1 1 1 1         Permit Number 128          
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
937 45898 1 17   26 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
938 251414 2 29 10x Jones St 2 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
940 51496 1 5 1350 REVISED Fell St 1 1 1 1   03/16/2005 12:00:00 AM     Permit Number 47808 6000958.86990754 2110035.78536621 37.773809648853 -122.44012948036101 (37.773809648853, -122.440129480361)
947 251413 2 29 10x Jones St 1 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
952 48321 1 17   187 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
953 46022 1 17   215 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
954 251405 1 59 540 LOMBARD ST 1 1 1 1   01/21/2016 12:08:00 PM   Width 0ft   6009678.016 2120549.6995 37.8031708545804 -122.410711083519 (37.8031708545804, -122.410711083519)
955 251402 2 106 190 University St 1 1 1 1       3x3   6007981.0 2093052.0 37.7275732783897 -122.41463660892599 (37.7275732783897, -122.414636608926)
961 251408 2 47 75 Christmas Tree Point Rd 1 1 1 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
963 251419 2 50 39 Jones St 2 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
967 251416 2 29 10x Jones St 4 1 1 1       3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
970 251418 2 50 39 Jones St 1 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
971 251415 2 29 10x Jones St 3 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
975 251421 3 15 300X King St 6 1 1 2 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1010 45949 1 17   146 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1015 48313 1 17   179 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1029 251428 2 47 5030 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1038 57888 1 17 2382 Fost St 1 1 1 1   05/04/1977 12:00:00 AM     Permit Number 16841          
1048 251423 3 53 2162 Alemany Blvd 1 1 1 2       3x3   5999946.0 2089791.0 37.718164612456604 -122.44217960719999 (37.7181646124566, -122.4421796072)
1067 48140 1 17   250 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1086 48227 1 17   9 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
Powered by Datasette · Query took 102.155ms · Data source: data.sfgov.org