sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
162455 195979 2 86 900 Phelps St 1 17 1 1     30 Width 9ft   6014704.25324 2097268.53042 37.739526454869704 -122.39168875963999 (37.7395264548697, -122.39168875964)
165153 195980 2 86 900 Phelps St 2 17 1 1     24     6014694.29284 2097256.8818599996 37.7394939174204 -122.39172238440399 (37.7394939174204, -122.391722384404)
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)
3856 246917 2 86 845 Shrader St 2 9 1 1     17 Width 3ft   5997637.485090001 2107521.28402 37.766715824697 -122.451437229753 (37.766715824697, -122.451437229753)
180467 246918 2 86 845 Shrader St 4 9 1 1     22 Width 3ft   5997638.105140001 2107510.95773 37.7666875068428 -122.451434340243 (37.7666875068428, -122.451434340243)
180656 247225 2 86 754 Duboce Ave 1 9 1 1     15     6002109.5730099995 2108309.81574 37.7691360073432 -122.43602549030001 (37.7691360073432, -122.4360254903)
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)
47717 234909 2 86 50 Alemany Blvd 13 9 1 1     17 Width 10ft   6009677.77783 2096362.7223200002 37.73675900081071 -122.409004306302 (37.7367590008107, -122.409004306302)
52696 234902 2 86 50 Alemany Blvd 6 9 1 1     6     6009698.6344099995 2096418.94153 37.7369145349811 -122.40893616107799 (37.7369145349811, -122.408936161078)
68610 234900 2 86 50 Alemany Blvd 4 9 1 1     17     6009696.65795 2096435.2295400002 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348)
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)
73733 234901 2 86 50 Alemany Blvd 5 9 1 1     12     6009690.97834 2096436.6273599998 37.7369626675976 -122.408963879105 (37.7369626675976, -122.408963879105)
156252 234905 2 86 50 Alemany Blvd 9 9 1 1     18 Width 8ft   6009688.58582 2096390.10165 37.736834783993004 -122.40896886942 (37.736834783993, -122.40896886942)
172242 234908 2 86 50 Alemany Blvd 12 9 1 1     20 Width 10ft   6009679.550530001 2096368.23252 37.73677422993671 -122.408998565949 (37.7367742299367, -122.408998565949)
173066 234898 2 86 50 Alemany Blvd 2 9 1 1     24     6009700.61042 2096445.6891 37.736988088737704 -122.40893121572901 (37.7369880887377, -122.408931215729)
175927 234897 2 86 50 Alemany Blvd 1 9 1 1     4     6009692.09622 2096449.4371099998 37.7369979030329 -122.408960917621 (37.7369979030329, -122.408960917621)
176193 234907 2 86 50 Alemany Blvd 11 9 1 1     18 Width 8ft   6009682.36778 2096375.42259 37.7367941301369 -122.40898933260401 (37.7367941301369, -122.408989332604)
180616 234904 2 86 50 Alemany Blvd 8 9 1 1     15     6009689.76503 2096405.45865 37.73687701706479 -122.408965875569 (37.7368770170648, -122.408965875569)
184850 234903 2 86 50 Alemany Blvd 7 9 1 1     18     6009692.653580001 2096419.54828 37.7369158659624 -122.40895688234801 (37.7369158659624, -122.408956882348)
186239 234899 2 86 50 Alemany Blvd 3 9 1 1     24     6009698.94501 2096439.52165 37.7369710609585 -122.408936538802 (37.7369710609585, -122.408936538802)
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)
30532 119696 3 86 4x Octavia St 14 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
79566 119689 3 86 4x Octavia St 7 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)
86483 119684 3 86 4x Octavia St 2 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
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)
96316 119697 3 86 4x Octavia St 15 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)
103536 119694 3 86 4x Octavia St 12 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
118707 119686 3 86 4x Octavia St 4 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)
124714 119691 3 86 4x Octavia St 9 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
139912 119688 3 86 4x Octavia St 6 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)
25205 195981 2 86 401 Amador St 12 2 1 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
26910 195984 2 86 401 Amador St 9 2 1 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
29206 195983 2 86 401 Amador St 10 2 1 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
46984 195986 2 86 401 Amador St 7 2 1 1     3     6018468.61509 2099561.7634900003 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987)
61850 195989 2 86 401 Amador St 4 2 1 1     3     6018358.23149 2099573.02507 37.7460562901585 -122.37921477706699 (37.7460562901585, -122.379214777067)
69871 195990 2 86 401 Amador St 3 2 1 1     4     6018348.89198 2099575.3229 37.746062084515295 -122.379247231793 (37.7460620845153, -122.379247231793)
120047 195988 2 86 401 Amador St 5 2 1 1     3     6018362.603680001 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078)
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)
149276 195992 2 86 401 Amador St 1 2 1 1     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446)
177923 195991 2 86 401 Amador St 2 2 1 1     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321)
187127 195982 2 86 401 Amador St 11 2 1 1     10     6018502.102580001 2099556.87815 37.746019886521296 -122.378716163238 (37.7460198865213, -122.378716163238)
23464 121867 2 86 382 18th Ave 2 1 1 1     7 Width 3ft   5990303.78145 2112825.7530799997 37.7808577673116 -122.477190674715 (37.7808577673116, -122.477190674715)
29497 135665 2 86 3790 California St 4 9 1 1     16 Width 3ft   5996326.409519999 2114621.95963 37.7861372526689 -122.45648551290199 (37.7861372526689, -122.456485512902)
134366 135663 2 86 3790 California St 1 9 1 1     10 Width 3ft   5996346.46825 2114626.15487 37.78614992323771 -122.456416418905 (37.7861499232377, -122.456416418905)
161540 135664 2 86 3790 California St 3 9 1 1     10 Width 3ft   5996336.60886 2114624.27331 37.786144190959504 -122.45645039347099 (37.7861441909595, -122.456450393471)
909 234895 7 86 3255x 24th St 6 18 1 1     40 Width 10ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
49096 212850 2 86 32 Malta Dr 32 2 1 1     32 Width 3ft   5999489.821880001 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429)
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)
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)
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)
176864 135666 2 86 3001 Divisadero St 4 2 1 1     42 Width 9ft   6000472.49775 2118651.8946700003 37.797439556256705 -122.442430617479 (37.7974395562567, -122.442430617479)
28694 246559 3 86 2x Octavia St 3 3 1 2     6 Width 7ft   6005723.21879 2109372.62983 37.7722588698898 -122.42360165389299 (37.7722588698898, -122.423601653893)
28854 246564 3 86 2x Octavia St 8 3 1 2     9 Width 7ft   6005706.72335 2109459.01828 37.7724951406584 -122.423664856449 (37.7724951406584, -122.423664856449)
30102 246567 3 86 2x Octavia St 11 3 1 2     10 Width 7ft   6005696.09569 2109523.68249 37.7726720930872 -122.423706217176 (37.7726720930872, -122.423706217176)
32751 246565 3 86 2x Octavia St 9 3 1 2     11 Width 7ft   6005706.10974 2109468.40026 37.772520866678796 -122.423667646169 (37.7725208666788, -122.423667646169)
36823 246562 3 86 2x Octavia St 6 3 1 2     16 Width 7ft   6005708.50416 2109443.88838 37.7724536981194 -122.423657620518 (37.7724536981194, -122.423657620518)
58148 246560 3 86 2x Octavia St 4 3 1 2     5 Width 7ft   6005720.56075 2109380.70244 37.772280885298 -122.423611422347 (37.772280885298, -122.423611422347)
62755 246558 3 86 2x Octavia St 2 3 1 2     7 Width 7ft   6005725.55596 2109365.49138 37.772239401347605 -122.423593061791 (37.7722394013476, -122.423593061791)
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)
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)
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)
152965 246568 3 86 2x Octavia St 12 3 1 2     7 Width 7ft   6005695.27816 2109533.51475 37.7726990439551 -122.423709744321 (37.7726990439551, -122.423709744321)
159619 246563 3 86 2x Octavia St 7 3 1 2     14 Width 7ft   6005707.64026 2109451.4652299997 37.7724744535597 -122.42366114764499 (37.7724744535597, -122.423661147645)
164121 246566 3 86 2x Octavia St 10 3 1 2     9 Width 7ft   6005705.41603 2109475.54193 37.772540436826 -122.42367055365101 (37.772540436826, -122.423670553651)
171792 246570 3 86 2x Octavia St 14 3 1 2     9 Width 7ft   6005693.82305 2109545.39115 37.7727315715478 -122.423715622299 (37.7727315715478, -122.423715622299)
178229 246557 3 86 2x Octavia St 1 3 1 2     11 Width 7ft   6005728.07536 2109359.1735900003 37.7722221964256 -122.4235838977 (37.7722221964256, -122.4235838977)
46578 234892 2 86 2827 Cesar Chavez St 6 7 1 1     18     6010653.55518 2100656.49907 37.7486033968442 -122.40593298392 (37.7486033968442, -122.40593298392)
50221 234891 2 86 2827 Cesar Chavez St 5 7 1 1     12     6010619.31212 2100642.55964 37.748563207025704 -122.406050414705 (37.7485632070257, -122.406050414705)
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)
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)
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)
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)
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)
24124 234881 2 86 2800 Cesar Chavez St 12 9 1 1     29     6010567.07854 2100828.40228 37.749070568567 -122.40624413046899 (37.749070568567, -122.406244130469)
28429 234882 2 86 2800 Cesar Chavez St 13 9 1 1     14     6010551.469930001 2100825.34606 37.7490613037485 -122.406297890147 (37.7490613037485, -122.406297890147)
32073 234877 2 86 2800 Cesar Chavez St 8 9 1 1     38     6010643.54009 2100844.31084 37.7491185267072 -122.405980844948 (37.7491185267072, -122.405980844948)
38753 234884 2 86 2800 Cesar Chavez St 15 9 1 1     20     6010535.25533 2100821.90556 37.749050949857796 -122.406353718268 (37.7490509498578, -122.406353718268)
41709 234885 2 86 2800 Cesar Chavez St 16 9 1 1     7     6010529.65259 2100820.82881 37.7490476799194 -122.406373016826 (37.7490476799194, -122.406373016826)
51715 234880 2 86 2800 Cesar Chavez St 11 9 1 1     24     6010577.49101 2100830.77043 37.7490776534227 -122.40620829069799 (37.7490776534227, -122.406208290698)
55335 234886 2 86 2800 Cesar Chavez St 17 9 1 1     28     6010522.647340001 2100819.38367 37.7490433200014 -122.40639713934401 (37.7490433200014, -122.406397139344)
59758 234871 2 86 2800 Cesar Chavez St 1 9 1 1     17     6010740.989580001 2100867.24575 37.7491869507297 -122.405645476962 (37.7491869507297, -122.405645476962)
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)
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)
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)
Powered by Datasette · Query took 5.27ms · Data source: data.sfgov.org