sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
2743 1163 3 120 2849X Alemany Blvd 12 1 1 2   03/06/2006 12:00:00 AM 3 3X3   5997232.586019999 2087721.56451 37.7123274065466 -122.451409493752 (37.7123274065466, -122.451409493752)
2745 1164 3 120 2849X Alemany Blvd 3 1 1 2   03/06/2006 12:00:00 AM 3 3X3   5997509.5346800005 2087964.66518 37.7130107600005 -122.450469794845 (37.7130107600005, -122.450469794845)
2759 253203 4 120 349 Mangels Ave 1 5 1 1       3x3   5999103.0 2095207.0 37.732987611392005 -122.44548271607799 (37.732987611392, -122.445482716078)
3717 240414 2 120 4529 18th St 1 1 1 1     6 Width 3ft   6000856.95656 2105193.67931 37.760508625697 -122.440134724763 (37.760508625697, -122.440134724763)
6203 23950 1 120 2400X Sacramento St 6 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003173.29907 2115903.30394 37.7900462027047 -122.432888683778 (37.7900462027047, -122.432888683778)
7359 23947 1 120 2400X Sacramento St 3 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003237.41295 2115911.3949 37.7900720546314 -122.432667433453 (37.7900720546314, -122.432667433453)
7562 23953 1 120 2400X Sacramento St 8 1 1 1   06/21/2001 12:00:00 AM 3 4x4   6003112.92633 2115895.6310799997 37.790021710572795 -122.433097019816 (37.7900217105728, -122.433097019816)
7630 23948 1 120 2400X Sacramento St 4 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003227.15919 2115908.88128 37.7900645713585 -122.432702730963 (37.7900645713585, -122.432702730963)
8191 23946 1 120 2400X Sacramento St 2 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003257.60965 2115913.45554 37.7900788579916 -122.43259770183201 (37.7900788579916, -122.432597701832)
8361 23951 1 120 2400X Sacramento St 7 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003144.33072 2115898.20328 37.790030554519205 -122.432988547211 (37.7900305545192, -122.432988547211)
9477 81759 1 120 461 Cortland Ave 2 1 1 1   11/22/2003 12:00:00 AM 4 3x3   6007414.19918083 2097287.04503193 37.7391699263071 -122.416895974515 (37.7391699263071, -122.416895974515)
10901 1162 3 120 2849X Alemany Blvd 2 1 1 2   03/06/2006 12:00:00 AM 3 3X3   5997216.55451 2087707.3234400002 37.7122873858304 -122.451463876663 (37.7122873858304, -122.451463876663)
11008 1185 1 120 3018 Alemany Blvd 1 1 1 1   03/06/2006 12:00:00 AM 3 3x3   5996600.75581 2087299.21077 37.7111315204793 -122.453562799904 (37.7111315204793, -122.453562799904)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
11186 108449 1 120 90-98X Prague St 3 1 1 1 1 12/22/2014 12:00:00 AM 3 3x3   6004652.59412 2090606.81694 37.7206717805504 -122.42596895909901 (37.7206717805504, -122.425968959099)
11470 1268 3 120 3995X Alemany Blvd 6 1 1 2   04/22/2008 12:00:00 AM 3 3X3   5992221.4773699995 2087241.7214099998 37.7107216517569 -122.468694342994 (37.7107216517569, -122.468694342994)
11698 1252 3 120 3802X Alemany Blvd 3 1 1 2     24 3X5   5992874.60396 2087610.17758 37.7117710535519 -122.46646377159401 (37.7117710535519, -122.466463771594)
12461 1247 1 120 3725 Alemany Blvd 1 1 1 1   04/22/2008 12:00:00 AM 3 3X3   5993078.34594 2087556.76692 37.7116361552477 -122.46575571108299 (37.7116361552477, -122.465755711083)
12709 106100 2 120 420 Lisbon St 1 1 1 1     5 3x3   6002342.776000001 2090999.30829 37.721618662355795 -122.433981312389 (37.7216186623558, -122.433981312389)
12850 1245 1 120 3715 Alemany Blvd 1 1 1 1   04/22/2008 12:00:00 AM 3 3X3   5993121.79741 2087558.19139 37.711642572828495 -122.465605635801 (37.7116425728285, -122.465605635801)
12877 1237 3 120 3702X Alemany Blvd 2 1 1 2   06/11/1992 12:00:00 AM 25 3X5   5993171.03745 2087640.69975 37.7118719610995 -122.465441440287 (37.7118719610995, -122.465441440287)
12897 1152 1 120 2685 Alemany Blvd 1 1 1 1   04/22/2008 12:00:00 AM 3 3x3   5998075.461730001 2088293.5285 37.713946117887104 -122.448537441353 (37.7139461178871, -122.448537441353)
12928 1172 3 120 2900 Alemany Blvd 7 1 1 2   03/06/2006 12:00:00 AM 3 3X3   5996885.41862 2087511.8997099998 37.7117318296412 -122.45259428042 (37.7117318296412, -122.45259428042)
13039 1238 1 120 3702X Alemany Blvd 3 1 1 1   03/06/2006 12:00:00 AM 3 3X5   5993066.57599 2087635.7513400002 37.7118523486814 -122.46580212597 (37.7118523486814, -122.46580212597)
13390 19368 3 120 352-360 06th St 1 1 1 2   08/23/2014 12:00:00 AM 3 3x3 Permit Number 54655 6011200.48284 2111246.22274 37.7777109702346 -122.40478714063299 (37.7777109702346, -122.404787140633)
13411 86613 3 120 1060 Bryant St 1 1 1 2   04/13/2007 12:00:00 AM 3 3x3   6010229.125990001 2109123.9963599998 37.7718294894697 -122.40799771313601 (37.7718294894697, -122.407997713136)
13424 86619 1 120 1090 Bryant St 5 1 1 1   04/13/2007 12:00:00 AM 3 3x3   6010092.09688 2109000.58526 37.7714829581888 -122.408463001672 (37.7714829581888, -122.408463001672)
13530 39587 1 120 1028 Rhode Island St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773106 6011879.4313 2103580.86378 37.756701548162205 -122.401899435531 (37.7567015481622, -122.401899435531)
13655 86615 3 120 1090 Bryant St 1 1 1 2   11/03/2011 12:00:00 AM 3 3x3   6010138.02723 2109041.45906 37.7715977602665 -122.40830700887 (37.7715977602665, -122.40830700887)
13769 85678 3 120 750 Bryant St 2 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012220.56503 2111028.15837 37.777169179061104 -122.40124297808501 (37.7771691790611, -122.401242978085)
13830 85692 3 120 598 Bryant St 1 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6013183.76112 2111957.2599 37.7797739691436 -122.397976147576 (37.7797739691436, -122.397976147576)
14109 85683 3 120 660 Bryant St 3 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012787.21783 2111572.91246 37.7786965462587 -122.39932098479099 (37.7786965462587, -122.399320984791)
14118 85688 3 120 510 Bryant St 1 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6013697.52765 2112441.63878 37.7811325632525 -122.396232748844 (37.7811325632525, -122.396232748844)
14169 85694 3 120 474 Bryant St 3 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6013953.88261 2112679.45572 37.7817998152473 -122.39536254686001 (37.7817998152473, -122.39536254686)
14208 85682 3 120 660 Bryant St 2 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012794.814730001 2111581.55636 37.778720703824604 -122.39929531095 (37.7787207038246, -122.39929531095)
14700 86617 1 120 1090 Bryant St 3 1 1 1   04/13/2007 12:00:00 AM 3 3x3   6010113.47615 2109019.50593 37.771536107226794 -122.408390384123 (37.7715361072268, -122.408390384123)
14735 30648 1 120 15 Lafayette St 1 1 1 1 1 01/30/1995 12:00:00 AM 10 3x3 Permit Number 34588 6007479.3068699995 2109694.71788 37.7732422146752 -122.417550006149 (37.7732422146752, -122.417550006149)
14743 85681 3 120 660 Bryant St 1 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012801.64822 2111587.40032 37.7787371308451 -122.39927208143801 (37.7787371308451, -122.399272081438)
14982 86620 3 120 1000x Bryant St 1 1 1 2   04/13/2007 12:00:00 AM 3 3x3   6010457.56671 2109345.4237900004 37.772450265390795 -122.407223128867 (37.7724502653908, -122.407223128867)
15336 86631 1 120 760 Bryant St 2 1 1 1   04/13/2007 12:00:00 AM 3 3x3   6012051.41665 2110873.5779 37.7767352984212 -122.40181725096701 (37.7767352984212, -122.401817250967)
15462 85684 3 120 660 Bryant St 4 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012659.22444 2111448.1134 37.7783467423358 -122.399755001218 (37.7783467423358, -122.399755001218)
15905 86630 1 120 760 Bryant St 1 1 1 1   04/13/2007 12:00:00 AM 3 3x3   6012073.82351 2110895.00183 37.77679537403711 -122.40174124476101 (37.7767953740371, -122.401741244761)
15929 85680 3 120 600 Bryant St 2 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012945.936430001 2111731.57619 37.7791410451674 -122.398783049916 (37.7791410451674, -122.398783049916)
15968 86616 1 120 1090 Bryant St 2 1 1 1   04/13/2007 12:00:00 AM 3 3x3   6010124.54627 2109028.5712099997 37.771561618305796 -122.408352731315 (37.7715616183058, -122.408352731315)
16091 85690 3 120 570 Bryant St 1 1 1 2   11/05/2011 12:00:00 AM 3 3x3   6013313.890430001 2112083.07139 37.780126665260795 -122.39753479629 (37.7801266652608, -122.39753479629)
16175 86618 3 120 1090 Bryant St 4 1 1 2   04/13/2007 12:00:00 AM 3 3x3   6010101.61266 2109009.68223 37.7715084692605 -122.40843072772101 (37.7715084692605, -122.408430727721)
16293 85677 3 120 750 Bryant St 1 1 1 2   04/23/2007 12:00:00 AM 3 3x3   6012237.71739 2111051.30981 37.7772337045105 -122.401185269499 (37.7772337045105, -122.401185269499)
16321 40819 1 120 1040 Howard St 1 1 1 1   10/13/2004 12:00:00 AM 8 3x3 Permit Number 47715 6010221.45597 2111748.6305299997 37.7790356940769 -122.40820938834999 (37.7790356940769, -122.40820938835)
16351 108976 1 120 542 Utah St 1 1 1 1 1 01/20/2015 12:00:00 AM 3 3x3 Permit Number 774122 6010644.88245 2105682.8661 37.7624041987112 -122.406317076271 (37.7624041987112, -122.406317076271)
17144 28496 1 120 249 Cortland Ave 2 1 1 1   11/22/2003 12:00:00 AM 4 3X3   6006869.20175 2097398.39703 37.7394450032725 -122.41878822871 (37.7394450032725, -122.41878822871)
17223 24550 1 120 322 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 12 3X3   6007090.05329 2097287.3868400003 37.739152626479004 -122.418016751571 (37.739152626479, -122.418016751571)
18213 28317 1 120 605 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 3 3X3   6007774.74538 2097230.6167 37.7390352604705 -122.41564537064501 (37.7390352604705, -122.415645370645)
18459 24557 1 120 420 Cortland Ave 1 1 1 1     12 3X3   6007316.28855 2097251.9421200003 37.7390680335725 -122.417232019338 (37.7390680335725, -122.417232019338)
18947 28316 1 120 623 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 3 3X3   6007820.63247 2097225.98476 37.73902512151621 -122.41548638578199 (37.7390251215162, -122.415486385782)
19184 28312 1 120 828 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 6 3X3   6008226.9471 2097154.6773099997 37.7388521566921 -122.414076488066 (37.7388521566921, -122.414076488066)
19836 1214 3 120 3435 Alemany Blvd 1 1 1 2   03/08/2005 12:00:00 AM 3 3X3   5993805.15459 2087379.06858 37.7111901355994 -122.463230798779 (37.7111901355994, -122.463230798779)
20306 4842 3 120 144 Cortland Ave 1 1 1 2   03/20/2003 12:00:00 AM 3 4X4   6006504.57355 2097544.92188 37.7398267906861 -122.420059351163 (37.7398267906861, -122.420059351163)
21057 28321 1 120 249 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 3 3X3   6006883.15104 2097391.09073 37.7394257272014 -122.418739480066 (37.7394257272014, -122.418739480066)
21439 28322 1 120 904 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 16 3X3   6008321.70986 2097162.43684 37.738878784720505 -122.413749390244 (37.7388787847205, -122.413749390244)
21595 28320 1 120 461 Cortland Ave 1 1 1 1   11/22/2003 12:00:00 AM 4 3X3   6007471.94186 2097274.48269 37.73913868071671 -122.416695436156 (37.7391386807167, -122.416695436156)
21618 28318 1 120 605 Cortland Ave 2 1 1 1   11/22/2003 12:00:00 AM 3 3X3   6007759.23813 2097233.8884799997 37.739043372340205 -122.41569921937 (37.7390433723402, -122.41569921937)
23337 99375 1 120 3921 Clay St 1 1 1 1   05/08/2012 12:00:00 AM 1 3x3 Permit Number 768860 5996022.78804 2115189.92908 37.7876793085021 -122.45757706543002 (37.7876793085021, -122.45757706543)
23501 187800 2 120 2 Heron St 1 4 1 1     2 Width 2ft   6009988.42633 2110014.66553 37.7742615809293 -122.40889316451499 (37.7742615809293, -122.408893164515)
23957 125326 2 120 2460 Sacramento St 1 1 1 1     4 Width 5ft   6003032.79755 2115883.1633599997 37.7899829318237 -122.433373367088 (37.7899829318237, -122.433373367088)
25119 221619 2 120 47 Santa Marina St 2 1 1 1     5 Width 3ft   6005932.22047 2097722.32528 37.7402816363019 -122.42205090971599 (37.7402816363019, -122.422050909716)
25750 187815 2 120 1020 Le Conte Ave 2 2 1 1     1 Width 2ft   6013104.719330001 2089623.63357 37.7184462121049 -122.39668350344601 (37.7184462121049, -122.396683503446)
25964 221597 2 120 1485 Sanchez St 1 1 1 1     5 Width 2ft   6003972.054219999 2099640.99596 37.7454391151181 -122.428965139531 (37.7454391151181, -122.428965139531)
26330 221652 2 120 303 30th St 1 1 1 1     1 Width 3ft   6004504.7671 2098377.5922 37.742000237123605 -122.42703313408701 (37.7420002371236, -122.427033134087)
26621 221649 2 120 2012 15th St 1 1 1 1     4 Width 2ft   6004056.31613 2107188.28381 37.76616695496121 -122.429211835283 (37.7661669549612, -122.429211835283)
27135 187803 2 120 1022 Minna St 7 4 1 1     3 Width 3ft   6007519.609019999 2109677.8407099997 37.7731981416251 -122.417409398951 (37.7731981416251, -122.417409398951)
27288 203304 2 120 1531 Funston Ave 1 1 1 1     2 Width 3ft   5992105.89675 2105003.70672 37.759484918408496 -122.470386514529 (37.7594849184085, -122.470386514529)
27584 221634 2 120 3647 22nd St 1 1 1 1     2 Width 3ft   6003905.15604 2103026.4808 37.7547310787034 -122.4294378484 (37.7547310787034, -122.4294378484)
27631 221613 2 120 803 Alvarado St 1 1 1 1     4 Width 4ft   6001111.65366 2102583.28849 37.7533556231836 -122.439066758249 (37.7533556231836, -122.439066758249)
27841 221612 2 120 443 Clipper St 1 1 1 1     9 Width 5ft   6002290.76795 2100888.56087 37.748769324440204 -122.43486795308901 (37.7487693244402, -122.434867953089)
29083 42197 1 120 1102 Bryant St 1 1 1 1 1 06/23/2000 12:00:00 AM 2   Permit Number 42472 6009958.1347199995 2108871.8243 37.771121907368496 -122.408917299608 (37.7711219073685, -122.408917299608)
29130 41280 1 120 850 Battery St 2 1 1 1   07/31/2013 12:00:00 AM 2   Permit Number 770203 6012418.570230001 2119124.3074 37.7994103467575 -122.401127041994 (37.7994103467575, -122.401127041994)
29503 221651 2 120 26 Whitney St 1 1 1 1     3 Width 3ft   6004255.76182 2098095.16165 37.7412106638496 -122.427873994815 (37.7412106638496, -122.427873994815)
30150 57960 1 120 340 Hanover St 1 1 1 1   06/24/1977 12:00:00 AM 1   Permit Number 772773 5999451.90276 2086477.9387 37.709039522936294 -122.443649609852 (37.7090395229363, -122.443649609852)
30842 221642 2 120 841 Church St 1 1 1 1     6 Width 3ft   6004373.46148 2103997.0216 37.757422458193105 -122.427887472929 (37.7574224581931, -122.427887472929)
30959 140762 2 120 48 TERRA VISTA AVE 1 1 1 1     2 Width 0ft   6000287.3355 2112871.989 37.7815588874389 -122.4426561036 (37.7815588874389, -122.4426561036)
31035 221614 2 120 801 Alvarado St 1 1 1 1     4 Width 4ft   6001153.3381 2102585.1825099997 37.7533631954543 -122.43892274080099 (37.7533631954543, -122.438922740801)
31377 140826 2 120 510 Euclid Ave 2 1 1 1     1 Width 0ft   5996775.194 2113867.2875 37.7840908785082 -122.45487829896601 (37.7840908785082, -122.454878298966)
32185 221611 2 120 80 Fountain St 1 2 1 1     8 Width 3ft   6000341.50521 2101241.8769099996 37.749628579901206 -122.441633827157 (37.7496285799012, -122.441633827157)
33273 175090 2 120 137 Otsego Ave 1 1 1 1     2 Width 3ft   6000668.43551 2092436.91423 37.7254708381835 -122.43987206783702 (37.7254708381835, -122.439872067837)
33875 123291 2 120 506 06th Ave 1 1 1 1     1 Width 3ft   5994083.888830001 2112023.10777 37.778872508647204 -122.464055253517 (37.7788725086472, -122.464055253517)
34896 36034 1 120 1660X BRYANT ST 4 1 1 1 1 04/27/1998 12:00:00 AM 4   Permit Number 39178 6009346.0 2106886.0 37.7656349852358 -122.410894426294 (37.7656349852358, -122.410894426294)
35249 221604 2 120 463 Cortland Ave 1 1 1 1     5 Width 2ft   6007492.2907300005 2097272.2195900003 37.739133611216005 -122.416624918515 (37.739133611216, -122.416624918515)
35257 187812 2 120 501 Beale St 9 1 1 1     3 Width 2ft   6015686.38843 2114228.8053599996 37.7861501840288 -122.389477068617 (37.7861501840288, -122.389477068617)
35559 221645 2 120 841 Church St 6 1 1 1     5 Width 3ft   6004369.11216 2104095.58562 37.7576928456553 -122.42790953781099 (37.7576928456553, -122.427909537811)
35619 221580 2 120 440 14th St 1 1 1 1     2 Width 4ft   6005817.51141 2107873.4848700003 37.7681478988217 -122.42316890642701 (37.7681478988217, -122.423168906427)
36454 221621 2 120 337 Cortland Ave 1 1 1 1     6 Width 3ft   6007130.842069999 2097321.03633 37.739247316122295 -122.417878106717 (37.7392473161223, -122.417878106717)
37830 221585 2 120 1801 Bryant St 10 1 1 1     5 Width 4ft   6009531.49923 2106200.8664599997 37.7637641652204 -122.410204446196 (37.7637641652204, -122.410204446196)
37897 221643 2 120 841 Church St 4 1 1 1     6 Width 3ft   6004370.46442 2104050.63168 37.757569489259 -122.42790165793899 (37.757569489259, -122.427901657939)
37925 187805 2 120 1022 Minna St 9 4 1 1     3 Width 3ft   6007514.255059999 2109673.0649599996 37.7731847273119 -122.41742758053499 (37.7731847273119, -122.417427580535)
38145 120849 2 120 459 19th Ave 1 1 1 1     2 Width 3ft   5989969.644669999 2112229.77717 37.779201991488705 -122.47830301452 (37.7792019914887, -122.47830301452)
38768 221592 2 120 1555 Hampshire St 1 1 1 1     5 Width 3ft   6010533.99072 2100457.08761 37.7480491689492 -122.40633238993799 (37.7480491689492, -122.406332389938)
39556 49560 1 120 49 Pixley St 1 1 1 1   12/08/2015 12:00:00 AM 1   Permit Number 777029 6003156.442369999 2119085.5556099997 37.798782890681 -122.433174477517 (37.798782890681, -122.433174477517)
40592 221622 2 120 583 Ogden Ave 2 1 1 1     3 Width 3ft   6007865.83541 2096101.4446400001 37.7359399216775 -122.41525051070299 (37.7359399216775, -122.415250510703)
40973 125330 2 120 1335 Jackson St 1 1 1 1     1 Width 3ft   6007763.34926 2117482.29154 37.794640982941104 -122.41711938017201 (37.7946409829411, -122.417119380172)
41082 120843 2 120 295 19th Ave 2 9 1 1     1 Width 2ft   5989915.80244 2113424.7782 37.782480005786205 -122.47857668806002 (37.7824800057862, -122.47857668806)
Powered by Datasette · Query took 2.914ms · Data source: data.sfgov.org