sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
6027 20016 3 103 100 STAIRWAY48 0 1 1 2     18 10ST            
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
2603 253136 2 103 3059 Pine St 1 1 1 1       4x5   5999298.0 2114593.0 37.786227889505604 -122.446202552789 (37.7862278895056, -122.446202552789)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
3850 207785 2 103 290 Santa Clara Ave 1 2 1 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
6891 7808 1 103 700X Franklin St 1 1 1 1     18 4X4   6006239.03041 2112534.82936 37.7809706070447 -122.422042095466 (37.7809706070447, -122.422042095466)
8496 20017 3 103 100 STAIRWAY48 1 1 1 2     18 10ST            
9488 17957 1 103 2500 Pine St 1 1 1 1     24 3x3   6001928.8852 2115030.4127 37.7875788082428 -122.437131721785 (37.7875788082428, -122.437131721785)
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
18477 4843 1 103 146 Cortland Ave 1 1 1 1     70 3X3   6006528.82493 2097534.91084 37.739800668952604 -122.419974789699 (37.7398006689526, -122.419974789699)
20364 4837 1 103 127 Cortland Ave 1 1 1 1     3 3X3   6006404.24922 2097646.68025 37.7401005434118 -122.420413452032 (37.7401005434118, -122.420413452032)
22892 251144 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22896 251145 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
23367 208982 2 103 320 Santa Clara Ave 1 2 1 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
24602 208981 2 103 310 Santa Clara Ave 1 2 1 1     43 Width 3ft   5993092.40274 2095921.0497 37.7346032476459 -122.466314622626 (37.7346032476459, -122.466314622626)
27200 209021 2 103 34 Martha Ave 1 7 1 1     25     6000790.06178 2095561.6998400001 37.7340577017886 -122.43967553722 (37.7340577017886, -122.43967553722)
28258 208938 2 103 66 Saint Francis Blvd 1 2 1 1     28 Width 10ft   5991979.81471 2095977.19537 37.7346931510662 -122.470165265142 (37.7346931510662, -122.470165265142)
28853 209017 2 103 33 Martha Ave 1 23 1 1     25     6000774.79116 2095519.5815700002 37.7339411856303 -122.43972531378401 (37.7339411856303, -122.439725313784)
29038 208963 2 103 90 Yerba Buena Ave 1 2 1 1     30 Width 6ft   5993939.166669999 2096822.57013 37.7371274206966 -122.463452499655 (37.7371274206966, -122.463452499655)
29186 209002 2 103 115 Yerba Buena Ave 1 2 1 1     36 Width 4ft   5994119.61861 2096725.9639 37.736872559114104 -122.462821593742 (37.7368725591141, -122.462821593742)
29388 207794 2 103 213 Santa Clara Ave 1 2 1 1     19 Width 10ft   5993149.25155 2096563.99491 37.736371894833 -122.46616478658999 (37.736371894833, -122.46616478659)
32381 207778 2 103 124 Santa Clara Ave 1 2 1 1     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.46600517310699 (37.7369852648432, -122.466005173107)
33664 207789 2 103 275 Santa Clara Ave 1 2 1 1     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.46619907325199 (37.735400404893, -122.466199073252)
33873 208955 2 103 630 Saint Francis Blvd 1 2 1 1     35 Width 8ft   5993530.979180001 2095998.56422 37.7348413791301 -122.464803955838 (37.7348413791301, -122.464803955838)
36584 208984 2 103 354 Santa Clara Ave 1 2 1 1     38 Width 3ft   5993109.71634 2095669.50335 37.7339135629453 -122.466236489538 (37.7339135629453, -122.466236489538)
36907 208993 2 103 31 Yerba Buena Ave 1 2 1 1     28 Width 4ft   5993535.26127 2097150.77507 37.7380053101076 -122.46487280074899 (37.7380053101076, -122.464872800749)
37470 176346 2 103 40 Teddy Ave 1 9 1 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
40215 207788 2 103 285 Santa Clara Ave 1 2 1 1     19 Width 10ft   5993135.10109 2096167.2284099997 37.7352816566244 -122.46618488553001 (37.7352816566244, -122.46618488553)
41418 207775 2 103 110 Santa Clara Ave 1 2 1 1     27 Width 10ft   5993244.34274 2096906.29835 37.737317260394 -122.465860883191 (37.737317260394, -122.465860883191)
41832 208941 2 103 130 Saint Francis Blvd 1 2 1 1     30 Width 10ft   5992287.573419999 2095984.60456 37.734731282309106 -122.469101787134 (37.7347312823091, -122.469101787134)
43077 191722 2 103 1100 25th St 1 2 1 1     18     6014479.640380001 2101959.5389 37.752394509601494 -122.392793471535 (37.7523945096015, -122.392793471535)
43267 121204 2 103 44 MacOndray Ln 1 20 1 1     52     6008473.20212 2119153.5676 37.799269800719294 -122.41478152415002 (37.7992698007193, -122.41478152415)
43824 207767 2 103 20 Santa Clara Ave 1 2 1 1     26 Width 10ft   5993205.662140001 2097402.75145 37.7386781648646 -122.466030683288 (37.7386781648646, -122.466030683288)
44792 208974 2 103 130 Yerba Buena Ave 1 2 1 1     25 Width 6ft   5994229.97779 2096604.2011400003 37.7365445844613 -122.462431207033 (37.7365445844613, -122.462431207033)
46031 207784 2 103 270 Santa Clara Ave 1 2 1 1     24 Width 10ft   5993081.2153199995 2096255.53806 37.735521023771604 -122.466377603044 (37.7355210237716, -122.466377603044)
47668 208973 2 103 136 Yerba Buena Ave 1 2 1 1     17 Width 6ft   5994259.725980001 2096572.0955299998 37.7364581434207 -122.46232602774799 (37.7364581434207, -122.462326027748)
48153 209013 2 103 412 Baden St 1 17 1 1     20     6000780.48794 2095392.50815 37.7335925958074 -122.439696511209 (37.7335925958074, -122.439696511209)
48548 65198 1 103 371 Madrid St 1 1 1 1 1 07/29/1989 12:00:00 AM 34   Permit Number 27183 6003158.74485 2091706.4873099998 37.7236066919673 -122.431211180179 (37.7236066919673, -122.431211180179)
51382 207780 2 103 250 Santa Clara Ave 1 2 1 1     20 Width 10ft   5993075.61435 2096444.65306 37.7360399631594 -122.46641070800501 (37.7360399631594, -122.466410708005)
52363 208968 2 103 34 Yerba Buena Ave 1 2 1 1     23 Width 6ft   5993576.11533 2097077.3704400002 37.737806114757795 -122.46472622025298 (37.7378061147578, -122.464726220253)
52384 208985 2 103 372 Santa Clara Ave 1 2 1 1     59 Width 3ft   5993126.32529 2095592.5648700001 37.7337032672843 -122.466173478533 (37.7337032672843, -122.466173478533)
53478 207782 2 103 260 Santa Clara Ave 1 2 1 1     24 Width 10ft   5993076.07579 2096352.6988099997 37.7357875063795 -122.466402431535 (37.7357875063795, -122.466402431535)
53855 208983 2 103 330 Santa Clara Ave 1 2 1 1     35 Width 3ft   5993097.51511 2095800.07009 37.73427136274 -122.466288158284 (37.73427136274, -122.466288158284)
55842 207761 2 103 345 Santa Clara Ave 1 2 1 1     41 Width 10ft   5993145.033430001 2095739.54752 37.7341079244482 -122.46611947693701 (37.7341079244482, -122.466119476937)
56581 209009 2 103 408 Baden St 1 7 1 1     9     6000785.2821 2095342.6683900002 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582)
60450 207766 2 103 14 Santa Clara Ave 1 2 1 1     32 Width 10ft   5993184.09693 2097461.91411 37.7388393665447 -122.46610954301799 (37.7388393665447, -122.466109543018)
60463 207807 2 103 25 Santa Clara Ave 1 2 1 1     22 Width 10ft   5993231.15579 2097483.74028 37.7389020106052 -122.46594842230199 (37.7389020106052, -122.465948422302)
61081 208914 2 103 45 Saint Francis Blvd 1 2 1 1     38 Width 10ft   5991964.75621 2096031.6123 37.7348416956868 -122.470221288386 (37.7348416956868, -122.470221288386)
61439 208913 2 103 25 Saint Francis Blvd 1 2 1 1     52 Width 10ft   5991855.18446 2096027.3519599999 37.7348236624713 -122.470599802253 (37.7348236624713, -122.470599802253)
63161 208994 2 103 21 Yerba Buena Ave 1 2 1 1     29 Width 4ft   5993511.280230001 2097168.00802 37.7380512447772 -122.46495696559799 (37.7380512447772, -122.464956965598)
63741 246757 2 103 70 Waltham St 1 7 1 1     27     6009117.20748 2098899.99025 37.7436943673943 -122.41112161978998 (37.7436943673943, -122.41112161979)
64417 224250 2 103 425 Eugenia Ave 1 1 1 1     34 Width 5ft   6007149.05774 2097827.31438 37.740638468384795 -122.417851002914 (37.7406384683848, -122.417851002914)
64951 208942 2 103 200 Saint Francis Blvd 1 2 1 1     32 Width 10ft   5992406.13159 2095989.66706 37.7347520323855 -122.468692262863 (37.7347520323855, -122.468692262863)
65175 208929 2 103 501 Saint Francis Blvd 1 10 1 1     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798)
65901 208933 2 103 405 Saint Francis Blvd 1 2 1 1     31 Width 10ft   5992936.60702 2096064.2661700002 37.7349874937845 -122.466863664131 (37.7349874937845, -122.466863664131)
66396 208966 2 103 44 Yerba Buena Ave 1 2 1 1     44 Width 6ft   5993666.080159999 2097016.89785 37.7376452584166 -122.46441078125099 (37.7376452584166, -122.464410781251)
67133 209003 2 103 96 Castenada Ave 1 2 1 1     43 Width 3ft   5994450.97172 2101378.39351 37.7496660456507 -122.462013248027 (37.7496660456507, -122.462013248027)
69718 208957 2 103 625 Saint Francis Blvd 1 2 1 1     18 Width 8ft   5993588.443419999 2096129.23717 37.73520348755321 -122.46461476908001 (37.7352034875532, -122.46461476908)
72305 208950 2 103 440 Saint Francis Blvd 1 2 1 1     26 Width 10ft   5992985.54967 2096006.72468 37.734832323836706 -122.46669027215599 (37.7348323238367, -122.466690272156)
73251 208996 2 103 11 Yerba Buena Ave 1 2 1 1     29 Width 4ft   5993421.96829 2097241.5815 37.7382481090644 -122.465271101502 (37.7382481090644, -122.465271101502)
73538 207772 2 103 60 Santa Clara Ave 1 2 1 1     25 Width 10ft   5993256.95856 2097201.9739 37.7381298392237 -122.46583874187 (37.7381298392237, -122.46583874187)
74311 208919 2 103 101 Saint Francis Blvd 1 2 1 1     38 Width 10ft   5992247.91507 2096042.0705099998 37.734886777797996 -122.469243079632 (37.734886777798, -122.469243079632)
74562 209046 2 103 301 Joost Ave 1 9 1 1     55 Width 10ft   5999983.24986 2094934.98428 37.732290932375605 -122.442419949729 (37.7322909323756, -122.442419949729)
75055 208997 2 103 10 Yerba Buena Ave 1 2 1 1     31 Width 4ft   5993343.646380001 2097250.7379 37.738268733207605 -122.465542562746 (37.7382687332076, -122.465542562746)
75518 191738 2 103 920 Vermont St 1 2 1 1     39     6011311.04969 2104026.1978700003 37.757892599481 -122.40389645386699 (37.757892599481, -122.403896453867)
76551 224247 2 103 527 Powhattan Ave 1 2 1 1     46     6008745.222630001 2098103.60695 37.74148680607821 -122.412351580256 (37.7414868060782, -122.412351580256)
76666 207779 2 103 126 Santa Clara Ave 1 2 1 1     36 Width 10ft   5993175.19587 2096740.86685 37.7368590378112 -122.46608793591001 (37.7368590378112, -122.46608793591)
76936 208937 2 103 64 Saint Francis Blvd 1 2 1 1     36 Width 10ft   5991925.34536 2095973.96809 37.734681140613105 -122.47035334753201 (37.7346811406131, -122.470353347532)
76953 208935 2 103 3 Saint Francis Blvd 1 2 1 1     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.47074216493401 (37.7346627188958, -122.470742164934)
77267 207777 2 103 118 Santa Clara Ave 1 2 1 1     34 Width 10ft   5993220.0955300005 2096827.0991599998 37.737098400464795 -122.465938963216 (37.7370984004648, -122.465938963216)
77296 209024 2 103 36 Martha Ave 1 7 1 1     32     6000772.29534 2095570.30388 37.7340803152378 -122.43973757782601 (37.7340803152378, -122.439737577826)
80756 2614 9 103 1661X Octavia St 1 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
89069 138024 2 103 1661 Octavia St 1 1 1 1     48 Width 0ft   6004873.7558 2115028.5137 37.7877405482561 -122.42694291248002 (37.7877405482561, -122.42694291248)
90816 119631 2 103 265 Fowler Ave 1 9 1 1     15 3x5   5997384.0 2099137.0 37.7436801569324 -122.451709113802 (37.7436801569324, -122.451709113802)
92339 115295 6 103 500X 08TH ST 1 1 1 1       3x3   6010511.0 2109243.0 37.77217202356729 -122.407031076357 (37.7721720235673, -122.407031076357)
92343 113367 3 103 6X Christopher Dr 1 7 1 2     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
97315 113859 2 103 456 HILL ST 1 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
99243 122535 2 103 199x Coso Ave 1 1 1 1     21 3x3   6007478.0 2099565.0 37.7454282725128 -122.41683672388399 (37.7454282725128, -122.416836723884)
99315 3751 3 103 990 Carolina St 1 11 1 2     42 18   6012435.5557064 2103342.2152382 37.756077292734105 -122.399959384248 (37.7560772927341, -122.399959384248)
102861 112189 3 103 301x CORBETT AVE 1 9 1 2     12 3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
103214 106173 6 103 267 Green St 1 7 1 1         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
109383 106792 3 103 199X ARLINGTON ST 1 11 1 2     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
109652 113804 2 103 990X OSHAUGHNESSY BLVD 1 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
114900 208965 2 103 56 Yerba Buena Ave 1 2 1 1     24 Width 6ft   5993745.43898 2096960.72106 37.7374955851482 -122.464132325055 (37.7374955851482, -122.464132325055)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
116196 92033 1 103 10 Elk St 1 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
119166 92897 6 103 208 States St 1 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
119476 108200 2 103 90 Reuel Ct 1 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
123394 114040 3 103 95 LINARES AVE 1 7 1 2     40 3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
127109 208991 2 103 45 Yerba Buena Ave 1 2 1 1     28 Width 4ft   5993638.39674 2097082.374 37.73782344378579 -122.46451124811199 (37.7378234437858, -122.464511248112)
128787 116019 2 103 2023 09TH AVE 1 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
Powered by Datasette · Query took 3.978ms · Data source: data.sfgov.org