sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
133456 234878 2 86 2800 Cesar Chavez St 9 9 1 1     23     6010615.53478 2100839.3237900003 37.749103267009204 -122.406077336824 (37.7491032670092, -122.406077336824)
135800 196016 2 86 212 Terry A Francois Blvd 20 9 1 1     15     6015678.42156 2110690.23877 37.77643363342779 -122.389257449686 (37.7764336334278, -122.389257449686)
137250 201997 2 86 1799 Carroll Ave 2 2 1 1     2     6013313.68951 2092516.98736 37.7264024081338 -122.39616384100201 (37.7264024081338, -122.396163841002)
137504 196017 2 86 212 Terry A Francois Blvd 21 9 1 1     16     6015653.37625 2110690.3321 37.776432501193 -122.389344095768 (37.776432501193, -122.389344095768)
137968 195965 2 86 200 Tulare St 11 13 1 1     8     6015497.16873 2100330.63483 37.747978343742794 -122.389160933554 (37.7479783437428, -122.389160933554)
138816 119735 3 86 104x Octavia St 15 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
139286 96978 1 86 2090@Buchanan Vallejo St 1 1 1 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
139912 119688 3 86 4x Octavia St 6 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
140489 119773 3 86 204x Octavia St 8 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
141279 96981 1 86 2090@Buchanan Vallejo St 4 1 1 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
141892 119779 3 86 204x Octavia St 14 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142187 119776 3 86 204x Octavia St 11 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142339 119695 3 86 4x Octavia St 13 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
146490 234888 2 86 2827 Cesar Chavez St 2 7 1 1     33     6010611.762999999 2100694.95228 37.7487066435094 -122.40608021012699 (37.7487066435094, -122.406080210127)
146994 234890 2 86 2827 Cesar Chavez St 4 7 1 1     14     6010623.85334 2100666.44158 37.7486290355994 -122.40603639336099 (37.7486290355994, -122.406036393361)
147141 234872 2 86 2800 Cesar Chavez St 2 9 1 1     31     6010732.42318 2100864.09022 37.7491778073048 -122.405674877619 (37.7491778073048, -122.405674877619)
148699 248117 2 86 108 Brewster St 7 17 1 1     6     6010378.29952 2099414.5285 37.7451778188963 -122.40679730165701 (37.7451778188963, -122.406797301657)
149012 196010 2 86 212 Terry A Francois Blvd 14 9 1 1     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109)
149276 195992 2 86 401 Amador St 1 2 1 1     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446)
149461 234894 2 86 2827 Cesar Chavez St 12 7 1 1     27     6010729.67514 2100698.35511 37.7487225812957 -122.405672708429 (37.7487225812957, -122.405672708429)
154282 248120 2 86 108 Brewster St 10 17 1 1     12     6010373.21137 2099395.33781 37.745124840742 -122.40681354343701 (37.745124840742, -122.406813543437)
157844 201995 2 86 1799 Carroll Ave 1 2 1 1     2     6013319.20907 2092521.7003099998 37.726415656052104 -122.396145090149 (37.7264156560521, -122.396145090149)
158786 195955 2 86 200 Tulare St 1 13 1 1     10     6015700.85592 2100342.37267 37.7480218628289 -122.38845740468399 (37.7480218628289, -122.388457404684)
161996 196004 2 86 212 Terry A Francois Blvd 8 9 1 1     16     6015940.35109 2110704.12187 37.776486270757204 -122.388352322497 (37.7764862707572, -122.388352322497)
164241 201993 2 86 1799 Carroll Ave 5 2 1 1     2     6013314.351009999 2092488.44605 37.726324076294205 -122.396159554816 (37.7263240762942, -122.396159554816)
165153 195980 2 86 900 Phelps St 2 17 1 1     24     6014694.29284 2097256.8818599996 37.7394939174204 -122.39172238440399 (37.7394939174204, -122.391722384404)
166489 195999 2 86 212 Terry A Francois Blvd 3 9 1 1     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214)
168626 234893 2 86 2827 Cesar Chavez St 7 7 1 1     17     6010664.01336 2100659.8191 37.7486130978165 -122.405897053323 (37.7486130978165, -122.405897053323)
168920 196006 2 86 212 Terry A Francois Blvd 10 9 1 1     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001)
169608 234873 2 86 2800 Cesar Chavez St 3 9 1 1     11     6010726.23893 2100862.83367 37.7491740112676 -122.40569617445699 (37.7491740112676, -122.405696174457)
170865 234887 2 86 2827 Cesar Chavez St 1 7 1 1     15     6010600.221609999 2100713.10517 37.7487558418292 -122.40612139908501 (37.7487558418292, -122.406121399085)
172182 234883 2 86 2800 Cesar Chavez St 14 9 1 1     22     6010542.260840001 2100823.35069 37.7490553097539 -122.406329594845 (37.7490553097539, -122.406329594845)
173066 234898 2 86 50 Alemany Blvd 2 9 1 1     24     6009700.61042 2096445.6891 37.736988088737704 -122.40893121572901 (37.7369880887377, -122.408931215729)
175233 195961 2 86 200 Tulare St 7 13 1 1     10     6015577.60391 2100335.50195 37.7479961664858 -122.388883129368 (37.7479961664858, -122.388883129368)
175927 234897 2 86 50 Alemany Blvd 1 9 1 1     4     6009692.09622 2096449.4371099998 37.7369979030329 -122.408960917621 (37.7369979030329, -122.408960917621)
177775 53540 1 86 308 04th Ave 1 1 1 1   12/05/1969 12:00:00 AM 24   Permit Number 6452 5994656.440219999 2113376.70713 37.782622110333904 -122.462172779062 (37.7826221103339, -122.462172779062)
177923 195991 2 86 401 Amador St 2 2 1 1     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321)
177942 196001 2 86 212 Terry A Francois Blvd 5 9 1 1     4     6016008.12939 2110708.52586 37.776502118610395 -122.38811816333401 (37.7765021186104, -122.388118163334)
178922 196011 2 86 212 Terry A Francois Blvd 15 9 1 1     16     6015786.39152 2110696.3042599997 37.776456272983204 -122.388884371337 (37.7764562729832, -122.388884371337)
178954 234875 2 86 2800 Cesar Chavez St 5 9 1 1     12     6010693.4536 2100854.39807 37.7491490155229 -122.405808953037 (37.7491490155229, -122.405808953037)
179584 195959 2 86 200 Tulare St 5 13 1 1     10     6015616.60441 2100338.74984 37.7480072461368 -122.388748492749 (37.7480072461368, -122.388748492749)
180616 234904 2 86 50 Alemany Blvd 8 9 1 1     15     6009689.76503 2096405.45865 37.73687701706479 -122.408965875569 (37.7368770170648, -122.408965875569)
180656 247225 2 86 754 Duboce Ave 1 9 1 1     15     6002109.5730099995 2108309.81574 37.7691360073432 -122.43602549030001 (37.7691360073432, -122.4360254903)
180682 234876 2 86 2800 Cesar Chavez St 7 9 1 1     27     6010649.76891 2100846.09542 37.749123775143204 -122.405959431208 (37.7491237751432, -122.405959431208)
181735 196008 2 86 212 Terry A Francois Blvd 12 9 1 1     15     6015854.1615699995 2110700.296 37.7764709894889 -122.388650212137 (37.7764709894889, -122.388650212137)
182597 196021 2 86 212 Terry A Francois Blvd 25 9 1 1     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543)
182677 248122 2 86 109 Brewster St 2 7 1 1     14     6010390.78091 2099407.55033 37.7451593567256 -122.406753651253 (37.7451593567256, -122.406753651253)
182816 234879 2 86 2800 Cesar Chavez St 10 9 1 1     30     6010587.102659999 2100832.95642 37.7490841933025 -122.406175207346 (37.7490841933025, -122.406175207346)
183325 196018 2 86 212 Terry A Francois Blvd 22 9 1 1     15     6015632.0470199995 2110689.9383799997 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744)
184850 234903 2 86 50 Alemany Blvd 7 9 1 1     18     6009692.653580001 2096419.54828 37.7369158659624 -122.40895688234801 (37.7369158659624, -122.408956882348)
185485 234874 2 86 2800 Cesar Chavez St 4 9 1 1     33     6010703.27515 2100855.87105 37.7491536092595 -122.40577509356001 (37.7491536092595, -122.40577509356)
185609 248127 2 86 109 Brewster St 7 7 1 1     18     6010399.6226 2099438.06548 37.7452436393873 -122.40672522818701 (37.7452436393873, -122.406725228187)
186239 234899 2 86 50 Alemany Blvd 3 9 1 1     24     6009698.94501 2096439.52165 37.7369710609585 -122.408936538802 (37.7369710609585, -122.408936538802)
187127 195982 2 86 401 Amador St 11 2 1 1     10     6018502.102580001 2099556.87815 37.746019886521296 -122.378716163238 (37.7460198865213, -122.378716163238)
16741 20051 3 86 100 STAIRWAY52 7 1 1 2     12 10            
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)
140337 113133 6 86 50 03rd St 1 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)
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)
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)
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)
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)
18395 6096 3 86 106X Saint Joseph's Ave 3 1 1 2     12 3x3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
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)
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)
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)
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)
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)
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)
144536 116092 6 86 300x EXECUTIVE PARK BLVD 2 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
7574 19781 3 86 100 STAIRWAY19 3 1 1 2     36 50ST            
13863 19841 3 86 100 STAIRWAY25 25 1 1 2     12 60X            
5897 19904 3 86 100 STAIRWAY34 2 1 1 2     12 6X6            
6788 19903 3 86 100 STAIRWAY34 1 1 1 2     12 6X6            
95683 91056 1 86 750 FOLSOM ST 6 1 1 1       6x4   6012569.0 2113092.0 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689)
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)
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)
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)
495 248613 2 86 845 Shrader St 1 1 1 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)
3855 248614 2 86 845 Shrader St 3 1 1 1     19 Width 0ft   5997650.5459 2107506.4452 37.7666758289672 -122.451390984496 (37.7666758289672, -122.451390984496)
26304 140079 2 86 100 Saint Joseph's Ave 1 1 1 1     12 Width 0ft   6000729.2298 2112451.4153 37.780429279749605 -122.44109718195499 (37.7804292797496, -122.441097181955)
33120 249800 2 86 199 Chestnut St 8 7 1 1     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551)
33977 249894 2 86 230 Greenwich St 30 13 1 1     24 Width 0ft   6011403.76038 2120447.63681 37.802987222140395 -122.40473187458599 (37.8029872221404, -122.404731874586)
37654 244429 3 86 102x Octavia St 3 11 1 2     9 Width 0ft   6005659.2973 2109696.7034 37.773145089481794 -122.4238458121 (37.7731450894818, -122.4238458121)
Powered by Datasette · Query took 6.706ms · Data source: data.sfgov.org