sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
77244 185929 2 103 2000 Sunset Blvd 72 9 1 1     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897)
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)
78601 92035 1 103 10 Elk St 3 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
78801 2617 9 103 1661X Octavia St 4 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
78981 113860 2 103 456 HILL ST 2 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
79476 116530 3 103 745X SANCHEZ ST 7 3 1 2     45     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
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)
84894 105492 2 103 1575 07TH AVE 6 1 1 1     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571)
85741 114041 3 103 95 LINARES AVE 2 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
87799 13410 3 103 364 Marietta Dr 3 11 1 2     12 5   5999660.108164 2097381.7238333 37.738990678772396 -122.443712833155 (37.7389906787724, -122.443712833155)
88008 111551 3 103 900x BOSWORTH ST 29 7 1 2     27     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
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)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
89710 92040 1 103 10 Elk St 8 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
90554 114400 2 103 1X HIGUERA AVE 3 5 1 1     22 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
90640 114042 3 103 95 LINARES AVE 3 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
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)
92750 113861 2 103 456 HILL ST 3 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
92823 116020 2 103 2023 09TH AVE 2 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
92885 111536 3 103 900x BOSWORTH ST 14 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
95756 92036 1 103 10 Elk St 4 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
97315 113859 2 103 456 HILL ST 1 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
97794 92038 1 103 10 Elk St 6 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
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)
100681 111529 3 103 900x BOSWORTH ST 7 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
101800 114043 3 103 95 LINARES AVE 4 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
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)
102874 111513 3 103 800x BOSWORTH ST 8 7 1 2     16     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
102986 112188 3 103 301x CORBETT AVE 2 9 1 2     45 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)
105251 92899 6 103 208 States St 3 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
106180 106794 3 103 199X ARLINGTON ST 51 11 1 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
108603 114396 1 103 35 HIGUERA AVE 3 1 1 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
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)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
113582 114403 2 103 1X HIGUERA AVE 6 1 1 1     25 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
113956 114069 2 103 2 HIGUERA AVE 2 2 1 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
114512 108201 2 103 90 Reuel Ct 2 7 1 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
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)
115215 92034 1 103 10 Elk St 2 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
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)
116419 2615 9 103 1661X Octavia St 2 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
117576 111525 3 103 900x BOSWORTH ST 3 7 1 2     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
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)
119339 121341 2 103 401X Cargo Way 2 17 1 1     18 3x3   6017217.0 2098844.0 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195)
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)
120548 111538 3 103 900x BOSWORTH ST 16 7 1 2     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
121824 92039 1 103 10 Elk St 7 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
122260 66251 1 103 35 HIGUERA AVE 2 1 1 1   10/24/1990 12:00:00 AM     Permit Number 29352 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
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)
124116 224234 2 103 1100 San Jose Ave 24 7 1 1     13     6004836.880530001 2096694.1378 37.7373966273622 -122.425764994654 (37.7373966273622, -122.425764994654)
126390 2619 9 103 1661X Octavia St 6 1 1 2     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.42692897924101 (37.7877373561683, -122.426928979241)
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)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
128237 92037 1 103 10 Elk St 5 1 1 1       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.44267015975201 (37.7402285519688, -122.442670159752)
128646 92900 6 103 208 States St 4 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
128787 116019 2 103 2023 09TH AVE 1 1 1 1       6x6   5993447.0 2101700.0 37.7504912419676 -122.46550835159401 (37.7504912419676, -122.465508351594)
128978 122678 2 103 701x Powhattan Ave 1 1 1 1     36 3x3   6008711.0 2098131.0 37.741560100881 -122.412471846631 (37.741560100881, -122.412471846631)
130011 209032 2 103 38 Martha Ave 1 7 1 1     5     6000749.17916 2095580.7996200002 37.7341078183059 -122.43981824973301 (37.7341078183059, -122.439818249733)
130074 207792 2 103 255 Santa Clara Ave 2 2 1 1     28 Width 10ft   5993127.3071800005 2096365.9249099998 37.7358267779692 -122.46622626692499 (37.7358267779692, -122.466226266925)
130326 209005 2 103 172 Kensington Way 1 2 1 1     14 Width 3ft   5994782.01847 2098589.82391 37.7420283868014 -122.460666429624 (37.7420283868014, -122.460666429624)
130507 207805 2 103 35 Santa Clara Ave 1 2 1 1     29 Width 10ft   5993257.8737699995 2097404.51842 37.738686028527 -122.46585029007099 (37.738686028527, -122.465850290071)
130593 191727 2 103 1790 23rd St 1 9 1 1     21     6013509.42079 2102917.94191 37.7549721419751 -122.396215837988 (37.7549721419751, -122.396215837988)
130703 224266 2 103 2300 22nd St 2 7 1 1     28     6011271.09407 2103721.28577 37.75705314619071 -122.404013180481 (37.7570531461907, -122.404013180481)
131518 208943 2 103 200 Saint Francis Blvd 2 2 1 1     39 Width 10ft   5992457.65692 2095992.19703 37.7347619554908 -122.46851430770701 (37.7347619554908, -122.468514307707)
131911 207759 2 103 315 Santa Clara Ave 1 2 1 1     20 Width 10ft   5993145.97421 2095838.45755 37.7343795610583 -122.46612340966999 (37.7343795610583, -122.46612340967)
132331 208961 2 103 1575 07th Ave 6 1 1 1     18 Width 2ft   5993977.82871 2104681.32491 37.75870779624321 -122.463889098911 (37.7587077962432, -122.463889098911)
133032 209000 2 103 135 Yerba Buena Ave 5 2 1 1     27 Width 4ft   5994206.5655 2096669.1829099997 37.7367216600723 -122.462516864768 (37.7367216600723, -122.462516864768)
133286 209001 2 103 125 Yerba Buena Ave 1 2 1 1     24 Width 4ft   5994148.93284 2096709.76404 37.7368297666801 -122.462719067425 (37.7368297666801, -122.462719067425)
133399 224230 2 103 1100 San Jose Ave 20 7 1 1     9     6004850.154069999 2096702.7007099998 37.7374208892559 -122.425719711103 (37.7374208892559, -122.425719711103)
133823 207795 2 103 213 Santa Clara Ave 2 2 1 1     35 Width 10ft   5993167.32945 2096610.60875 37.7365009277821 -122.466105670558 (37.7365009277821, -122.466105670558)
134583 209010 2 103 408 Baden St 2 7 1 1     41     6000785.06362 2095352.2063400003 37.7334821968386 -122.439677803484 (37.7334821968386, -122.439677803484)
134672 207755 2 103 95 Kirkham St 6 9 1 1     43     5994788.04604 2105291.71815 37.7604304368423 -122.46113126040702 (37.7604304368423, -122.461131260407)
134906 191730 2 103 100 Hampshire St 2 7 1 1     24     6009966.3806300005 2107638.17528 37.767735053365705 -122.40880172773399 (37.7677350533657, -122.408801727734)
135102 224232 2 103 1100 San Jose Ave 22 7 1 1     6     6004847.66693 2096700.7431599998 37.7374153737207 -122.425728171024 (37.7374153737207, -122.425728171024)
135413 208934 2 103 405 Saint Francis Blvd 2 2 1 1     33 Width 10ft   5992888.064180001 2096062.32962 37.734979374706505 -122.467031351742 (37.7349793747065, -122.467031351742)
135905 224240 2 103 1100 San Jose Ave 42 7 1 1     36     6004759.95311 2096625.2597 37.7372031562031 -122.426026066958 (37.7372031562031, -122.426026066958)
136867 224241 2 103 1100 San Jose Ave 41 7 1 1     15     6004764.42793 2096634.9587599998 37.7372300405369 -122.42601128568998 (37.7372300405369, -122.42601128569)
137042 207787 2 103 292 Santa Clara Ave 1 2 1 1     15 Width 10ft   5993086.25016 2096104.5741400002 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661)
137374 224256 2 103 355 Buena Vista Ave East 12 9 1 1     24 Width 3ft   6001050.217680001 2107873.3371599996 37.7678773063135 -122.439658435714 (37.7678773063135, -122.439658435714)
137770 208917 2 103 101 Saint Francis Blvd 3 2 1 1     41 Width 10ft   5992152.90186 2096040.12972 37.734875958047496 -122.46957142927499 (37.7348759580475, -122.469571429275)
138324 2616 9 103 1661X Octavia St 3 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
138334 207756 2 103 95 Kirkham St 7 9 1 1     49     5994800.39892 2105292.04488 37.7604320448233 -122.461088561491 (37.7604320448233, -122.461088561491)
Powered by Datasette · Query took 6.232ms · Data source: data.sfgov.org