sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
4763 220524 1 86 110 Steiner St 1 1 1 1   08/09/1974 12:00:00 AM 38 Width 3ft Permit Number 14125 6003373.13767 2108706.4584 37.770296793780396 -122.431683217203 (37.7702967937804, -122.431683217203)
23421 195972 2 86 200 Tulare St 18 13 1 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
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)
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)
24182 196031 2 86 2 Lane St 10 9 1 1     7 Width 10ft   6017021.60504 2097043.8381400001 37.7390378586108 -122.383660646635 (37.7390378586108, -122.383660646635)
24297 248119 2 86 108 Brewster St 9 17 1 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
25030 196022 2 86 212 Terry A Francois Blvd 26 9 1 1     21     6015549.75144 2110684.1794 37.7764098616684 -122.389702136539 (37.7764098616684, -122.389702136539)
25205 195981 2 86 401 Amador St 12 2 1 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
26205 195969 2 86 200 Tulare St 15 13 1 1     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)
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)
26910 195984 2 86 401 Amador St 9 2 1 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
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)
28993 196012 2 86 212 Terry A Francois Blvd 16 9 1 1     16     6015764.416780001 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907)
29206 195983 2 86 401 Amador St 10 2 1 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
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)
30434 248121 2 86 109 Brewster St 1 7 1 1     11     6010387.395819999 2099398.52057 37.7451343735684 -122.40676472010901 (37.7451343735684, -122.406764720109)
31601 195958 2 86 200 Tulare St 4 13 1 1     10     6015649.240619999 2100340.8983400003 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013)
31815 196007 2 86 212 Terry A Francois Blvd 11 9 1 1     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236)
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)
32347 248125 2 86 109 Brewster St 5 7 1 1     7     6010397.048769999 2099427.00914 37.745213137076796 -122.406733349058 (37.7452131370768, -122.406733349058)
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)
33201 195967 2 86 200 Tulare St 13 13 1 1     5     6015456.783980001 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)
33236 195970 2 86 200 Tulare St 16 13 1 1     8     6015399.1088 2100325.42161 37.747958592828205 -122.389499659601 (37.7479585928282, -122.389499659601)
33398 196014 2 86 212 Terry A Francois Blvd 18 9 1 1     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054)
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)
35215 196035 2 86 1 Lane St 2 9 1 1     18 Width 10ft   6017042.43736 2096973.9330400003 37.7388470647366 -122.38358375190501 (37.7388470647366, -122.383583751905)
35883 248126 2 86 109 Brewster St 6 7 1 1     6     6010387.789530001 2099433.6295 37.7452307970734 -122.40676583257401 (37.7452307970734, -122.406765832574)
36690 248115 2 86 108 Brewster St 5 17 1 1     7     6010382.6698900005 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664)
38334 195966 2 86 200 Tulare St 12 13 1 1     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)
38396 195968 2 86 200 Tulare St 14 13 1 1     7     6015437.03514 2100327.8138099997 37.747967264084295 -122.389368677829 (37.7479672640843, -122.389368677829)
38488 196041 2 86 1 Lane St 13 9 1 1     10 Width 10ft   6017065.52556 2097005.9762799998 37.738936325136706 -122.383506153 (37.7389363251367, -122.383506153)
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)
38800 248116 2 86 108 Brewster St 6 17 1 1     9     6010379.57479 2099419.47211 37.745191464327995 -122.406793240314 (37.745191464328, -122.406793240314)
39702 195996 2 86 2101 Newcomb Ave 5 17 1 1     14 Width 3ft   6012499.275719999 2097703.95349 37.7405993901482 -122.39934322143101 (37.7405993901482, -122.399343221431)
41087 196003 2 86 212 Terry A Francois Blvd 7 9 1 1     16     6015962.95079 2110705.93329 37.776492496775106 -122.388274269443 (37.7764924967751, -122.388274269443)
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)
41744 248172 2 86 218 Esmeralda Ave 1 17 1 1     12     6007302.01446 2098729.32454 37.74312379432521 -122.41738604353701 (37.7431237943252, -122.417386043537)
42525 195977 2 86 200 Tulare St 23 13 1 1     5 Width 4ft   6015256.877230001 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)
44122 212849 2 86 1201 Ulloa St 3 1 1 1     11 Width 3ft   5992374.69215 2098410.70315 37.7413977704887 -122.468977090726 (37.7413977704887, -122.468977090726)
45266 196009 2 86 212 Terry A Francois Blvd 13 9 1 1     16     6015830.73834 2110698.70731 37.776465329147 -122.388731129538 (37.776465329147, -122.388731129538)
46092 195960 2 86 200 Tulare St 6 13 1 1     8     6015597.7328 2100337.72732 37.748003392560896 -122.38881367921302 (37.7480033925609, -122.388813679213)
46532 196000 2 86 212 Terry A Francois Blvd 4 9 1 1     17     6016029.9014099995 2110710.35403 37.776508344609496 -122.38804297461999 (37.7765083446095, -122.38804297462)
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)
46620 248114 2 86 108 Brewster St 4 17 1 1     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902)
46771 140080 2 86 102 Saint Joseph's Ave 2 1 1 1     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881)
46984 195986 2 86 401 Amador St 7 2 1 1     3     6018468.61509 2099561.7634900003 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987)
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)
47853 196002 2 86 212 Terry A Francois Blvd 6 9 1 1     18     6015985.51722 2110706.0962799997 37.7764941946745 -122.38819621639799 (37.7764941946745, -122.388196216398)
48598 196029 2 86 2 Lane St 7 9 1 1     10 Width 10ft   6017027.27121 2097051.6476 37.7390596150087 -122.383641598974 (37.7390596150087, -122.383641598974)
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)
49446 195978 2 86 200 Tulare St 24 13 1 1     9 Width 4ft   6015236.23042 2100312.22008 37.747913311958605 -122.390061968785 (37.7479133119586, -122.390061968785)
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)
51068 201994 2 86 1799 Carroll Ave 3 2 1 1     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251)
51090 248124 2 86 109 Brewster St 4 7 1 1     10     6010394.26479 2099420.04988 37.7451938726969 -122.406742485274 (37.7451938726969, -122.406742485274)
51312 96980 1 86 2090@Buchanan Vallejo St 3 1 1 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
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)
52696 234902 2 86 50 Alemany Blvd 6 9 1 1     6     6009698.6344099995 2096418.94153 37.7369145349811 -122.40893616107799 (37.7369145349811, -122.408936161078)
52998 195998 2 86 212 Terry A Francois Blvd 2 9 1 1     18     6016075.490669999 2110714.30849 37.776521728336604 -122.387885542896 (37.7765217283366, -122.387885542896)
53814 196045 2 86 1 Lane St 19 9 1 1     12 Width 10ft   6017076.588380001 2097018.35028 37.7389709130863 -122.383468763681 (37.7389709130863, -122.383468763681)
54920 248118 2 86 108 Brewster St 8 17 1 1     6     6010376.970919999 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209)
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)
55642 196036 2 86 1 Lane St 4 9 1 1     17 Width 10ft   6017046.41048 2096978.7292799999 37.738860453849 -122.383570348389 (37.738860453849, -122.383570348389)
56013 248173 2 86 218 Esmeralda Ave 2 17 1 1     6     6007303.951309999 2098726.55555 37.743116300271 -122.41737915022101 (37.743116300271, -122.417379150221)
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)
60534 196005 2 86 212 Terry A Francois Blvd 9 9 1 1     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276)
60765 195957 2 86 200 Tulare St 3 13 1 1     12     6015667.37966 2100340.53223 37.7480149542209 -122.38857303683399 (37.7480149542209, -122.388573036834)
61094 196049 2 86 1 Lane St 26 9 1 1     35 Width 10ft   6017090.910619999 2097040.61449 37.7390328376916 -122.38342079293501 (37.7390328376916, -122.383420792935)
61234 195975 2 86 200 Tulare St 21 13 1 1     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)
61728 249895 2 86 230 Greenwich St 31 13 1 1     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639)
61850 195989 2 86 401 Amador St 4 2 1 1     3     6018358.23149 2099573.02507 37.7460562901585 -122.37921477706699 (37.7460562901585, -122.379214777067)
62070 196033 2 86 2 Lane St 13 9 1 1     6 Width 10ft   6017016.3348 2097035.41086 37.7390144276853 -122.38367828232501 (37.7390144276853, -122.383678282325)
62177 195962 2 86 200 Tulare St 8 13 1 1     9     6015556.6084199995 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422)
63128 196020 2 86 212 Terry A Francois Blvd 24 9 1 1     18     6015589.15281 2110687.71234 37.7764217471115 -122.38956608171999 (37.7764217471115, -122.38956608172)
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)
65985 195964 2 86 200 Tulare St 10 13 1 1     8     6015516.57214 2100331.8217700003 37.7479826784534 -122.38909391965001 (37.7479826784534, -122.38909391965)
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)
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)
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)
77831 117475 2 86 1200x MONTGOMERY ST 2 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
78277 98312 2 86 160 Stanford Heights Ave 1 2 1 1           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734)
81560 117474 2 86 1200x MONTGOMERY ST 1 20 1 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
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)
Powered by Datasette · Query took 6.687ms · Data source: data.sfgov.org