sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
65477 196046 2 86 1 Lane St 20 9 1 1     15 Width 10ft   6017076.84536 2097020.9862799998 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608)
65821 196027 2 86 2 Lane St 5 9 1 1     10 Width 10ft   6017034.20589 2097061.6668900002 37.739087509266604 -122.383618319135 (37.7390875092666, -122.383618319135)
65833 249798 2 86 199 Chestnut St 6 7 1 1     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639)
65982 244266 3 86 202x Octavia St 7 11 1 2     4 Width 0ft   6005600.5046 2110125.0362 37.7743178686238 -122.42407965066499 (37.7743178686238, -122.424079650665)
65985 195964 2 86 200 Tulare St 10 13 1 1     8     6015516.57214 2100331.8217700003 37.7479826784534 -122.38909391965001 (37.7479826784534, -122.38909391965)
66652 246571 3 86 2x Octavia St 15 3 1 2     10 Width 7ft   6005693.03742 2109551.27371 37.7727476792916 -122.423718758221 (37.7727476792916, -122.423718758221)
66890 244431 3 86 102x Octavia St 5 11 1 2     9 Width 0ft   6005656.5567 2109717.2576 37.77320137163979 -122.42385675402599 (37.7732013716398, -122.423856754026)
68610 234900 2 86 50 Alemany Blvd 4 9 1 1     17     6009696.65795 2096435.2295400002 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348)
69044 196048 2 86 1 Lane St 25 9 1 1     16 Width 10ft   6017086.8639400005 2097032.1625700002 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434)
69195 246561 3 86 2x Octavia St 5 3 1 2     8 Width 7ft   6005718.25772 2109387.68034 37.7722999149342 -122.42361988494801 (37.7722999149342, -122.423619884948)
69678 195997 2 86 212 Terry A Francois Blvd 1 9 1 1     23     6016094.12732 2110713.51522 37.776520582607 -122.387821017432 (37.776520582607, -122.387821017432)
69871 195990 2 86 401 Amador St 3 2 1 1     4     6018348.89198 2099575.3229 37.746062084515295 -122.379247231793 (37.7460620845153, -122.379247231793)
69986 196013 2 86 212 Terry A Francois Blvd 17 9 1 1     17     6015743.28218 2110693.6702799997 37.7764466511333 -122.38903331613899 (37.7764466511333, -122.389033316139)
70123 248111 2 86 108 Brewster St 1 17 1 1     24     6010383.711069999 2099443.8594400003 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096)
71617 196015 2 86 212 Terry A Francois Blvd 19 9 1 1     17     6015698.09519 2110690.66596 37.77643589704721 -122.38918942227899 (37.7764358970472, -122.389189422279)
72864 234906 2 86 50 Alemany Blvd 10 9 1 1     17 Width 8ft   6009686.024230001 2096384.83518 37.7368201799074 -122.408977354526 (37.7368201799074, -122.408977354526)
72921 234889 2 86 2827 Cesar Chavez St 3 7 1 1     25     6010620.28496 2100677.87035 37.7486602169168 -122.406049537871 (37.7486602169168, -122.406049537871)
73006 244339 3 86 102x Octavia St 16 11 1 2     14 Width 0ft   6005625.7255 2109918.6883 37.7737527111209 -122.42397773010799 (37.7737527111209, -122.423977730108)
73079 196019 2 86 212 Terry A Francois Blvd 23 9 1 1     17     6015611.09455 2110687.68162 37.776422879345496 -122.389490176245 (37.7764228793455, -122.389490176245)
73353 196047 2 86 1 Lane St 23 9 1 1     21 Width 10ft   6017083.0987599995 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874)
73733 234901 2 86 50 Alemany Blvd 5 9 1 1     12     6009690.97834 2096436.6273599998 37.7369626675976 -122.408963879105 (37.7369626675976, -122.408963879105)
74084 195956 2 86 200 Tulare St 2 13 1 1     9     6015682.424790001 2100340.57249 37.748015898531605 -122.388521013727 (37.7480158985316, -122.388521013727)
74090 195963 2 86 200 Tulare St 9 13 1 1     8     6015537.22246 2100333.68578 37.7479889413373 -122.389022641203 (37.7479889413373, -122.389022641203)
74522 249896 2 86 230 Greenwich St 32 13 1 1     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676)
74651 196034 2 86 1 Lane St 1 9 1 1     19 Width 10ft   6017038.2356199995 2096967.92235 37.738830328350794 -122.38359786136002 (37.7388303283508, -122.38359786136)
76412 244404 3 86 202x Octavia St 10 11 1 2     8 Width 0ft   6005594.3943 2110164.7531 37.7744265766299 -122.424103612435 (37.7744265766299, -122.424103612435)
77831 117475 2 86 1200x MONTGOMERY ST 2 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
78042 6095 3 86 106X Saint Joseph's Ave 2 1 1 2   10/19/2015 12:00:00 AM 12 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
78277 98312 2 86 160 Stanford Heights Ave 1 2 1 1           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734)
79566 119689 3 86 4x Octavia St 7 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
80683 119723 3 86 104x Octavia St 3 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
81560 117474 2 86 1200x MONTGOMERY ST 1 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
83899 119728 3 86 104x Octavia St 8 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
84867 119767 3 86 204x Octavia St 2 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
85011 119690 3 86 4x Octavia St 8 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
85674 113134 6 86 50 03rd St 2 7 1 1   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968)
86483 119684 3 86 4x Octavia St 2 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
86543 119734 3 86 104x Octavia St 14 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
86843 109377 7 86 111 BAY ST 4 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
87484 96979 1 86 2090@Buchanan Vallejo St 2 1 1 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
87621 119685 3 86 4x Octavia St 3 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
87630 119692 3 86 4x Octavia St 10 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
88222 119683 3 86 4x Octavia St 1 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
89139 119727 3 86 104x Octavia St 7 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
89334 116094 6 86 300x EXECUTIVE PARK BLVD 4 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
90805 119770 3 86 204x Octavia St 5 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
90928 244261 3 86 202x Octavia St 2 11 1 2     5 Width 0ft   6005613.489 2110034.9096 37.7740711358709 -122.424028324662 (37.7740711358709, -122.424028324662)
91724 103067 1 86 255 Broadway 6 1 1 1   12/11/2014 12:00:00 AM 3 6x6 Permit Number 769997 6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382)
92450 116095 6 86 300x EXECUTIVE PARK BLVD 5 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
92703 119766 3 86 204x Octavia St 1 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
92884 119733 3 86 104x Octavia St 13 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
95683 91056 1 86 750 FOLSOM ST 6 1 1 1       6x4   6012569.0 2113092.0 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689)
96316 119697 3 86 4x Octavia St 15 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
96460 109375 7 86 111 BAY ST 2 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
97405 85294 1 86 2255 Mariposa St   5 2 1   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752.0 2105977.0 37.7632178155038 -122.40596731591499 (37.7632178155038, -122.405967315915)
97979 119772 3 86 204x Octavia St 7 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
99317 119769 3 86 204x Octavia St 4 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
100173 119722 3 86 104x Octavia St 2 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
100653 119693 3 86 4x Octavia St 11 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
101181 117473 2 86 1201x MONTGOMERY ST 1 20 1 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
101391 119774 3 86 204x Octavia St 9 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
101847 117472 2 86 1201x MONTGOMERY ST 2 20 1 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
102782 196025 2 86 2 Lane St 2 9 1 1     20 Width 10ft   6017042.181609999 2097072.1185299999 37.7391166482065 -122.38359146989201 (37.7391166482065, -122.383591469892)
103536 119694 3 86 4x Octavia St 12 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
103992 119729 3 86 104x Octavia St 9 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
105008 119726 3 86 104x Octavia St 6 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
106073 96984 1 86 2090@Buchanan Vallejo St 7 1 1 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
106195 116091 6 86 300x EXECUTIVE PARK BLVD 1 1 1 1     30 3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
106450 119771 3 86 204x Octavia St 6 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
108312 6094 3 86 106X Saint Joseph's Ave 1 1 1 2     20 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
110210 91057 1 86 750 FOLSOM ST 7 1 1 1     25 6x4   6012569.0 2113092.0 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689)
112237 109378 7 86 111 BAY ST 5 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
112632 6098 3 86 106X Saint Joseph's Ave 5 1 1 2     24 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
114742 116093 6 86 300x EXECUTIVE PARK BLVD 3 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
115597 119725 3 86 104x Octavia St 5 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
116487 244265 3 86 202x Octavia St 6 11 1 2     9 Width 0ft   6005602.0322 2110112.8157 37.7742844003359 -122.42407349716999 (37.7742844003359, -122.42407349717)
117272 119768 3 86 204x Octavia St 3 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
118020 116097 6 86 300x EXECUTIVE PARK BLVD 7 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
118325 109374 7 86 111 BAY ST 1 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
118707 119686 3 86 4x Octavia St 4 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
119705 116096 6 86 300x EXECUTIVE PARK BLVD 6 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
120047 195988 2 86 401 Amador St 5 2 1 1     3     6018362.603680001 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078)
120366 119775 3 86 204x Octavia St 10 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120707 119721 3 86 104x Octavia St 1 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120772 119778 3 86 204x Octavia St 13 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120932 119687 3 86 4x Octavia St 5 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
123249 24282 3 86 300X Winding Way 20 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
123390 119724 3 86 104x Octavia St 4 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
123532 119777 3 86 204x Octavia St 12 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
124714 119691 3 86 4x Octavia St 9 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
126370 119730 3 86 104x Octavia St 10 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
127197 249899 2 86 1497 Montgomery St 3 17 1 1     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701)
127758 109376 7 86 111 BAY ST 3 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
129094 119732 3 86 104x Octavia St 12 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
129623 244406 3 86 202x Octavia St 12 11 1 2     12 Width 0ft   6005586.7565 2110217.4543 37.7745708501281 -122.42413378179899 (37.7745708501281, -122.424133781799)
129839 248123 2 86 109 Brewster St 3 7 1 1     13     6010392.06783 2099413.0786599996 37.7451746083214 -122.40674959081899 (37.7451746083214, -122.406749590819)
130066 195985 2 86 401 Amador St 8 2 1 1     5     6018474.359130001 2099556.32192 37.74601682971289 -122.378812058831 (37.7460168297129, -122.378812058831)
130105 246569 3 86 2x Octavia St 13 3 1 2     9 Width 7ft   6005694.6084199995 2109539.50826 37.772715462883 -122.42371248725401 (37.772715462883, -122.423712487254)
130871 195987 2 86 401 Amador St 6 2 1 1     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441)
130896 248113 2 86 108 Brewster St 3 17 1 1     17     6010385.30327 2099441.28079 37.745251666737296 -122.40677496881099 (37.7452516667373, -122.406774968811)
132662 201996 2 86 1799 Carroll Ave 4 2 1 1     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968)
Powered by Datasette · Query took 11.253ms · Data source: data.sfgov.org