sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
20653 2618 9 103 1661X Octavia St 5 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
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)
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)
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)
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)
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)
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)
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)
8002 19938 3 103 100 STAIRWAY38 7 1 1 2     18 10ST            
7805 19939 3 103 100 STAIRWAY38 8 1 1 2     18 10ST            
14547 19940 3 103 100 STAIRWAY38 9 1 1 2     18 10ST            
14348 19941 3 103 100 STAIRWAY38 10 1 1 2     18 10ST            
1070 19942 3 103 100 STAIRWAY38 11 1 1 2     18 10ST            
6027 20016 3 103 100 STAIRWAY48 0 1 1 2     18 10ST            
8496 20017 3 103 100 STAIRWAY48 1 1 1 2     18 10ST            
6772 20314 3 103 101X Sunset Blvd 3 1 1 2     42 60            
16276 20315 3 103 101X Sunset Blvd 4 1 1 2     42 60            
12003 20316 3 103 101X Sunset Blvd 5 1 1 2     42 60            
17047 20318 3 103 101X Sunset Blvd 7 1 1 2     36 60            
17109 20319 3 103 101X Sunset Blvd 8 1 1 2     36 60            
3884 20320 3 103 101X Sunset Blvd 9 1 1 2     42 60            
8841 23183 3 103 520X Van Ness Ave 3 11 1 2   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.780702551515496 -122.42037059124901 (37.7807025515155, -122.420370591249)
656 23200 3 103 520X Van Ness Ave 2 11 1 2     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196)
7960 23202 3 103 520X Van Ness Ave 4 11 1 2     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366)
12367 24267 3 103 350X Winding Way 5 11 1 2     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.43787685174401 (37.7094338594468, -122.437876851744)
12342 24268 3 103 350X Winding Way 6 11 1 2     12 8   6001111.916180001 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566)
684 24323 1 103 600X Golden Gate Ave 10 1 1 1     12 3X3   6006332.380890001 2112512.31586 37.7809140549901 -122.42171754994101 (37.7809140549901, -122.421717549941)
19068 26911 3 103 10 Caine Ave 7 11 1 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
18271 28138 3 103 418 Eugenia Ave 2 1 1 2     90 4X5   6006975.957669999 2097881.62293 37.7407778444163 -122.41845336792801 (37.7407778444163, -122.418453367928)
19139 29600 3 103 900X Junipero Serra Blvd 9 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478)
139032 30154 3 103 410X Mansell St 23 11 1 2     24 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
48059 43994 1 103 141 Hampshire St 2 1 1 1   09/08/2000 12:00:00 AM 18   Permit Number 43551 6010001.85414 2107517.13485 37.7674046909874 -122.408670488759 (37.7674046909874, -122.408670488759)
42995 52091 1 103 300 Dorantes Ave 2 1 1 1   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.745033690620396 -122.46629968747601 (37.7450336906204, -122.466299687476)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
143929 92898 6 103 208 States St 2 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
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)
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)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
103018 104402 2 103 301 Joost Ave 1 9 1 1           6000011.7 2094912.1 37.7322297190532 -122.44231994912901 (37.7322297190532, -122.442319949129)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
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)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
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)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
109383 106792 3 103 199X ARLINGTON ST 1 11 1 2     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
106180 106794 3 103 199X ARLINGTON ST 51 11 1 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
144679 106811 3 103 3500X MISSION ST 17 11 1 2     20     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
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)
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)
111260 111511 3 103 800x BOSWORTH ST 6 7 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
102874 111513 3 103 800x BOSWORTH ST 8 7 1 2     16     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
117576 111525 3 103 900x BOSWORTH ST 3 7 1 2     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
100681 111529 3 103 900x BOSWORTH ST 7 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
92885 111536 3 103 900x BOSWORTH ST 14 7 1 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
120548 111538 3 103 900x BOSWORTH ST 16 7 1 2     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
43329 111546 3 103 900x BOSWORTH ST 24 7 1 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
141204 111548 3 103 900x BOSWORTH ST 26 7 1 2     40     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
88008 111551 3 103 900x BOSWORTH ST 29 7 1 2     27     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
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)
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)
92343 113367 3 103 6X Christopher Dr 1 7 1 2     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361)
44177 113502 3 103 200x MANSELL ST 8 11 1 2     30 3x3   6011136.0 2090597.0 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831)
71413 113506 3 103 200x Mansell St 12 11 1 2     39 3x3   6011135.08211 2090555.5358799999 37.7208952054249 -122.40355728893199 (37.7208952054249, -122.403557288932)
109652 113804 2 103 990X OSHAUGHNESSY BLVD 1 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
97315 113859 2 103 456 HILL ST 1 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
78981 113860 2 103 456 HILL ST 2 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
92750 113861 2 103 456 HILL ST 3 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
141326 113862 2 103 456 HILL ST 4 1 1 1       3x3   6003369.0 2103347.0 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346)
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)
85741 114041 3 103 95 LINARES AVE 2 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
90640 114042 3 103 95 LINARES AVE 3 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
101800 114043 3 103 95 LINARES AVE 4 7 1 2       3x3   5994258.0 2102054.0 37.751509977458795 -122.462729551044 (37.7515099774588, -122.462729551044)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
113956 114069 2 103 2 HIGUERA AVE 2 2 1 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
138466 114076 2 103 24 HIGUERA AVE 2 2 1 1     24     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
108603 114396 1 103 35 HIGUERA AVE 3 1 1 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
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)
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)
Powered by Datasette · Query took 7.896ms · Data source: data.sfgov.org