sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4555 253633 1 37 1907 Judah St 1 1 1 1 1 01/21/2016 12:00:00 AM   3x3 Permit Number 777409          
7270 98268 1 37 401X Esmeralda Ave 1 1 1 1 1     3x3            
7799 36854 1 37   1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9099 36836 1 37   2 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9535 36839 1 37   5 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13906 36837 1 37   3 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15723 36838 1 37   4 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16572 36840 1 37   6 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
65025 179986 2 37 818 Brunswick St 1 1 1 1     6 Width 3ft   5997558.28952 2086239.87811 37.708277679339 -122.450177037641 (37.708277679339, -122.450177037641)
113003 112634 2 37 800x BRUNSWICK ST 2 1 1 1       5x6   5997602.0 2086276.0 37.70837936312 -122.450028571713 (37.70837936312, -122.450028571713)
27333 180168 2 37 5935 Mission St 2 1 1 1     5 Width 3ft   5996569.70599 2086304.01805 37.7083971704608 -122.453598302421 (37.7083971704608, -122.453598302421)
10341 15974 3 37 5933 Mission St 1 1 1 2   09/30/2016 12:00:00 AM 3 3X3   5996593.31856 2086313.8422700001 37.708425499112394 -122.453517403906 (37.7084254991124, -122.453517403906)
4188 181057 2 37 5931 Mission St 1 1 1 1   10/10/2017 03:33:00 PM 3 Width 3ft   5996618.07355 2086323.26043 37.7084527782463 -122.453432527712 (37.7084527782463, -122.453432527712)
152808 180169 2 37 5921 Mission St 2 1 1 1     7 Width 3ft   5996782.55272 2086390.1360799999 37.7086458303022 -122.45286889471001 (37.7086458303022, -122.45286889471)
68899 71587 2 37 129 Goethe St 2 1 1 1 1 09/30/1995 12:00:00 AM 5     5994891.94658 2086476.6908099998 37.7087749666595 -122.459409293405 (37.7087749666595, -122.459409293405)
26228 30542 1 37 401 Tunnel Ave 1 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011709.315719999 2086131.9776 37.7087810622767 -122.401261631812 (37.7087810622767, -122.401261631812)
165253 73605 2 37 129 Goethe St 1 1 1 1 1 09/30/1995 12:00:00 AM 5     5994880.25496 2086485.81008 37.7087993338054 -122.459450360941 (37.7087993338054, -122.459450360941)
171925 30540 1 37 401 Tunnel Ave 2 1 1 1   01/25/1995 12:00:00 AM 4   Permit Number 34540 6011709.69759 2086150.77213 37.7088326896354 -122.40126163184601 (37.7088326896354, -122.401261631846)
69006 30551 1 37 401 Tunnel Ave 3 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011709.667330001 2086170.88712 37.708887919721796 -122.401263148996 (37.7088879197218, -122.401263148996)
136313 30560 1 37 401 Tunnel Ave 4 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011710.935930001 2086190.1008799998 37.7089407476737 -122.401260113786 (37.7089407476737, -122.401260113786)
61136 71581 2 37 237 Flournoy St 1 1 1 1 1 09/30/1995 12:00:00 AM 5     5994022.886390001 2086563.0023 37.70896195100121 -122.46241911655301 (37.7089619510012, -122.462419116553)
64171 180218 2 37 241 Flournoy St 1 4 1 1     1 Width 3ft   5994016.46026 2086567.8312400002 37.70897484008071 -122.462441676038 (37.7089748400807, -122.462441676038)
76222 30559 1 37 401 Tunnel Ave 5 1 1 1   01/25/1995 12:00:00 AM 4   Permit Number 34540 6011712.00106 2086211.4280599998 37.708999367305495 -122.40125793021299 (37.7089993673055, -122.401257930213)
53016 180001 2 37 62 Tomaso Ct 6 7 1 1     22 Width 8ft   6009181.15123 2086279.38185 37.709044431429604 -122.41000974567899 (37.7090444314296, -122.410009745679)
11556 15959 1 37 5865 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5997123.14276 2086529.76075 37.7090487194007 -122.45170184265899 (37.7090487194007, -122.451701842659)
146453 30558 1 37 401 Tunnel Ave 6 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011712.43745 2086232.9055700002 37.7090583646351 -122.401257930224 (37.7090583646351, -122.401257930224)
49317 30557 1 37 401 Tunnel Ave 7 1 1 1   01/25/1995 12:00:00 AM 5   Permit Number 34540 6011712.35311 2086248.4251400002 37.7091009735907 -122.401259311574 (37.7091009735907, -122.401259311574)
101994 94597 3 37 2555 Bay Shore Blvd 12 1 1 2       3x3   6010710.5 2086281.9 37.7091369436285 -122.404724239792 (37.7091369436285, -122.404724239792)
71332 30556 1 37 401 Tunnel Ave 8 1 1 1   01/25/1995 12:00:00 AM 4   Permit Number 34540 6011713.13245 2086267.1107299998 37.709152323994395 -122.40125793023 (37.7091523239944, -122.40125793023)
30355 180399 2 37 349 Chicago Way 1 2 1 1     2 Width 6ft   6002410.48398 2086459.29818 37.7091566380421 -122.433422996175 (37.7091566380421, -122.433422996175)
58807 69328 1 37 244 Lowell St 1 1 1 1   03/23/1994 12:00:00 AM 11   Permit Number 33411 5998992.03694 2086536.8188 37.709174955430704 -122.445243198623 (37.7091749554307, -122.445243198623)
94231 15946 1 37 5809 Mission St 1 1 1 1   02/23/2005 12:00:00 AM 3 3X3   5997438.5856 2086576.5906200001 37.7091953641971 -122.450615004797 (37.7091953641971, -122.450615004797)
12447 15954 3 37 5845 Mission St 3 1 1 2   11/20/2013 12:00:00 AM 3 4x6   5997263.95979 2086584.52293 37.709207147548 -122.451219107291 (37.709207147548, -122.451219107291)
178770 30555 1 37 401 Tunnel Ave 9 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011713.20166 2086290.18715 37.7092156911269 -122.401259311564 (37.7092156911269, -122.401259311564)
130669 180221 2 37 248 Wilson St 2 4 1 1     7 Width 3ft   5994358.2246 2086656.8417599997 37.70923891700821 -122.461266945616 (37.7092389170082, -122.461266945616)
48866 180170 2 37 5845 Mission St 4 1 1 1     1 Width 4ft   5997301.475190001 2086598.6429400002 37.7092480658079 -122.45109046644501 (37.7092480658079, -122.451090466445)
51423 180184 2 37 5818 Mission St 2 1 1 1     0 Width 3ft   5997152.40975 2086607.26455 37.7092632032078 -122.451606278907 (37.7092632032078, -122.451606278907)
186634 30554 1 37 401 Tunnel Ave 10 1 1 1   01/25/1995 12:00:00 AM 4   Permit Number 34540 6011714.03756 2086311.65654 37.7092746884476 -122.401257930228 (37.7092746884476, -122.401257930228)
163068 71608 2 37 250 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5994331.5401 2086682.33238 37.7093073724942 -122.46136101741502 (37.7093073724942, -122.461361017415)
179194 30553 1 37 401 Tunnel Ave 11 1 1 1   01/25/1995 12:00:00 AM 3   Permit Number 34540 6011714.36082 2086327.5657799998 37.7093183900986 -122.40125793020701 (37.7093183900986, -122.401257930207)
183586 180171 2 37 5845 Mission St 5 1 1 1     1 Width 4ft   5997361.4678 2086623.37535 37.709319409930394 -122.450884905728 (37.7093194099304, -122.450884905728)
91890 15937 3 37 5810X MISSION ST 2 1 1 2     8 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
125217 15936 1 37 5810X MISSION ST 1 1 1 1     6 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
96741 15950 3 37 5823 MISSION ST 1 1 1 2   01/30/2014 12:00:00 AM 3 3X3   5997354.0 2086632.0 37.7093426637375 -122.450911336997 (37.7093426637375, -122.450911336997)
121724 15949 3 37 5823 MISSION ST 2 1 1 2   03/25/2015 12:00:00 AM 3 4X4   5997354.0 2086632.0 37.7093426637375 -122.450911336997 (37.7093426637375, -122.450911336997)
171613 180183 2 37 5810 Mission St 2 1 1 1     9 Width 4ft   5997223.97549 2086636.40948 37.7093473266958 -122.451361038275 (37.7093473266958, -122.451361038275)
164072 180400 2 37 511 Cordova St 1 1 1 1     1 Width 6ft   6002102.27199 2086536.9163099998 37.709352269366995 -122.434493768575 (37.709352269367, -122.434493768575)
158233 30552 1 37 401 Tunnel Ave 12 1 1 1   01/25/1995 12:00:00 AM 4   Permit Number 34540 6011714.8537800005 2086351.82742 37.709385035249795 -122.401257930217 (37.7093850352498, -122.401257930217)
68232 180182 2 37 5800 Mission St 3 1 1 1     4 Width 4ft   5997258.08151 2086650.3270400001 37.7093874940164 -122.45124416598999 (37.7093874940164, -122.45124416599)
10115 173855 2 37 511 Cordova St 1 1 1 1       5xt   6002114.0 2086554.0 37.7093998431938 -122.43445445536699 (37.7093998431938, -122.434454455367)
134205 180181 2 37 5800 Mission St 2 1 1 1     9 Width 4ft   5997274.84313 2086656.60213 37.709405683693 -122.451186687614 (37.709405683693, -122.451186687614)
11586 15945 1 37 5805 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5997438.4638 2086653.8674299999 37.7094075417074 -122.450620993373 (37.7094075417074, -122.450620993373)
178151 180180 2 37 5800 Mission St 1 1 1 1     9 Width 4ft   5997294.9638 2086664.4628599999 37.7094284194653 -122.451117714107 (37.7094284194653, -122.451117714107)
3439 251741 2 37 300 Naylor St 1 1 1 1       3x3   6002771.0 2086560.0 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389)
162187 180219 2 37 254 Wilson St 1 4 1 1     6 Width 3ft   5994266.2336800005 2086739.00195 37.7094592149324 -122.46159083107901 (37.7094592149324, -122.461590831079)
115843 180220 2 37 254 Wilson St 2 4 1 1     6 Width 3ft   5994253.3591 2086751.7904 37.7094935879269 -122.46163625403601 (37.7094935879269, -122.461636254036)
42326 179980 2 37 670 Brunswick St 14 10 1 1     7     5998613.38234 2086668.65922 37.7095153380418 -122.446561361025 (37.7095153380418, -122.446561361025)
36791 30549 1 37 401 Tunnel Ave 13 1 1 1   01/25/1995 12:00:00 AM 6   Permit Number 34540 6011714.66567 2086401.56807 37.709521602706 -122.4012620734 (37.709521602706, -122.4012620734)
137512 179979 2 37 670 Brunswick St 13 10 1 1     7     5998643.39451 2086681.70368 37.709552869435896 -122.44645857210399 (37.7095528694359, -122.446458572104)
67095 179978 2 37 670 Brunswick St 12 10 1 1     6     5998663.42353 2086686.16888 37.709566273845894 -122.446389669661 (37.7095662738459, -122.446389669661)
178864 30543 1 37 401 Tunnel Ave 14 1 1 1   01/25/1995 12:00:00 AM 5   Permit Number 34540 6011714.287140001 2086422.26625 37.7095784146801 -122.401264835207 (37.7095784146801, -122.401264835207)
67547 179977 2 37 670 Brunswick St 11 10 1 1     7     5998676.25855 2086690.45816 37.7095787843051 -122.446345618154 (37.7095787843051, -122.446345618154)
151119 180011 2 37 1 Lawrence Ave 5 1 1 1     8 Width 3ft   5997275.602999999 2086720.88269 37.7095822269181 -122.451188694021 (37.7095822269181, -122.451188694021)
12839 15933 1 37 5777 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5997625.743840001 2086728.6782200001 37.7096236730671 -122.449979113963 (37.7096236730671, -122.449979113963)
174890 180010 2 37 1 Lawrence Ave 4 1 1 1     8 Width 3ft   5997262.56254 2086737.01263 37.7096257693921 -122.45123492637501 (37.7096257693921, -122.451234926375)
53213 179976 2 37 670 Brunswick St 9 10 1 1     7     5998720.79345 2086710.36043 37.709635974902504 -122.446193129116 (37.7096359749025, -122.446193129116)
34487 180172 2 37 5775 Mission St 1 1 1 1     0 Width 3ft   5997650.14628 2086739.63291 37.709655148435296 -122.44989556423599 (37.7096551484353, -122.449895564236)
37301 180009 2 37 1 Lawrence Ave 3 1 1 1     8 Width 3ft   5997247.3865 2086752.55268 37.7096675698642 -122.45128849717399 (37.7096675698642, -122.451288497174)
175880 180179 2 37 5750 Mission St 2 1 1 1     0 Width 3ft   5997506.02305 2086750.31915 37.709676242925795 -122.450394446945 (37.7096762429258, -122.450394446945)
130318 179975 2 37 670 Brunswick St 4 10 1 1     8     5998755.4264 2086725.5872 37.7096797619799 -122.446074526535 (37.7096797619799, -122.446074526535)
12860 15932 1 37 5771 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5997674.88478 2086749.4837200001 37.709683611969 -122.44981077346 (37.709683611969, -122.44981077346)
74913 180008 2 37 1 Lawrence Ave 2 1 1 1     7 Width 3ft   5997232.2014 2086767.6701 37.7097082093476 -122.451342068885 (37.7097082093476, -122.451342068885)
161267 30541 1 37 401 Tunnel Ave 15 1 1 1   01/25/1995 12:00:00 AM 6   Permit Number 34540 6011717.72591 2086473.5246599999 37.709719351946795 -122.40125654977601 (37.7097193519468, -122.401256549776)
12612 15931 1 37 5767 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3x3   5997735.60664 2086774.39401 37.7097554839914 -122.449602702713 (37.7097554839914, -122.449602702713)
32239 68739 1 37 1 Lawrence Ave 1 1 1 1   11/16/1993 12:00:00 AM 8   Permit Number 32659 5997216.23373 2086785.97531 37.709757556936495 -122.45139857511101 (37.7097575569365, -122.451398575111)
4394 251740 2 37 240 Naylor St 1 1 1 1   10/11/2017 08:43:00 AM 3 3x3   6002635.0 2086674.0 37.709758897844296 -122.432662361521 (37.7097588978443, -122.432662361521)
172897 32268 1 37 30 Lawrence Ave 1 1 1 1   08/15/1996 12:00:00 AM 6   Permit Number 36854 5997257.50064 2086789.55506 37.709769749051205 -122.45125620791599 (37.7097697490512, -122.451256207916)
59025 30550 1 37 401 Tunnel Ave 16 1 1 1   01/25/1995 12:00:00 AM 5   Permit Number 34540 6011719.36058 2086494.9778200001 37.7097783492625 -122.40125240657801 (37.7097783492625, -122.401252406578)
137561 180217 2 37 91 Garrison Ave 1 1 1 1     3 Width 2ft   6008216.77598 2086576.98292 37.7098074845964 -122.41336381219999 (37.7098074845964, -122.4133638122)
11514 15925 3 37 5732 Mission St 1 1 1 2   12/26/2012 12:00:00 AM 3 3x3   5997636.25268 2086801.42761 37.709824027618 -122.449948033398 (37.709824027618, -122.449948033398)
178336 30561 1 37 401 Tunnel Ave 17 1 1 1   01/25/1995 12:00:00 AM 6   Permit Number 34540 6011718.102469999 2086511.71476 37.7098242353839 -122.401257930218 (37.7098242353839, -122.401257930218)
101931 15924 1 37 5732 Mission St 1 1 1 1   02/23/1995 12:00:00 AM 6 3X3   5997611.35068 2086807.7712599998 37.709840020923295 -122.450034555797 (37.7098400209233, -122.450034555797)
72054 31019 1 37 239 Naylor St 1 1 1 1 1 03/23/2001 12:00:00 AM 7   Permit Number 43764 6002675.61901 2086708.2112 37.7098551378742 -122.43252441698401 (37.7098551378742, -122.432524416984)
12524 15922 1 37 5718 Mission St 2 1 1 1   02/23/1995 12:00:00 AM 3 3X3   5997668.40751 2086814.8341299999 37.7098626786949 -122.449837866439 (37.7098626786949, -122.449837866439)
76384 30548 1 37 401 Tunnel Ave 18 1 1 1   01/25/1995 12:00:00 AM 7   Permit Number 34540 6011718.12319 2086532.40482 37.709881047334 -122.401259311572 (37.709881047334, -122.401259311572)
67527 31020 1 37 239 Naylor St 2 1 1 1 1 03/23/2001 12:00:00 AM 7   Permit Number 43764 6002665.06815 2086718.08858 37.70988166068479 -122.432561587743 (37.7098816606848, -122.432561587743)
11208 15921 1 37 5718 Mission St 1 1 1 1   02/25/1999 12:00:00 AM 3 3X3   5997690.80196 2086825.40786 37.7098929930475 -122.44976122890499 (37.7098929930475, -122.449761228905)
167337 102734 1 37 5735 Mission St 1 1 1 1   02/22/2013 12:00:00 AM 1 3x3 Permit Number 770005 5997875.716469999 2086830.45832 37.7099174384228 -122.449122496232 (37.7099174384228, -122.449122496232)
82368 31007 1 37 106 Drake St 1 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34781 6001462.17793128 2086756.21041895 37.7099180463866 -122.43672172056601 (37.7099180463866, -122.436721720566)
61969 180216 2 37 75 Garrison Ave 1 1 1 1     3 Width 2ft   6008232.1427 2086617.22115 37.709918833260396 -122.413313545478 (37.7099188332604, -122.413313545478)
62429 102735 1 37 5735 Mission St 2 1 1 1   02/22/2013 12:00:00 AM 1 3x3 Permit Number 770005 5997893.47207 2086837.6698 37.7099382550256 -122.44906164897199 (37.7099382550256, -122.449061648972)
152616 30547 1 37 401 Tunnel Ave 19 1 1 1   01/25/1995 12:00:00 AM 7   Permit Number 34540 6011718.16033 2086553.89012 37.7099400437706 -122.401260692024 (37.7099400437706, -122.401260692024)
10689 44737 1 37 220 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 10   Permit Number 43854 5992028.1183 2086972.4785799999 37.7099712034746 -122.469343044645 (37.7099712034746, -122.469343044645)
68479 179981 2 37 23 Whittier St 1 1 1 1     1 Width 5ft   5998169.97204 2086845.49283 37.7099755454025 -122.448106579751 (37.7099755454025, -122.448106579751)
4721 253670 2 37 1063 Prague St 1 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
4736 253671 2 37 1063 Prague St 2 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
158569 30546 1 37 401 Tunnel Ave 20 1 1 1   01/25/1995 12:00:00 AM 8   Permit Number 34540 6011718.58864 2086574.96985 37.7099979484159 -122.401260692029 (37.7099979484159, -122.401260692029)
78681 15919 3 37 5700 Mission St 1 1 1 2   05/11/2016 12:00:00 AM 3 3x3   5997805.8876412995 2086862.4796366 37.710001367541 -122.44936614231199 (37.710001367541, -122.449366142312)
87050 51974 1 37 5700 Mission St 1 1 1 1   08/18/2005 12:00:00 AM     Permit Number 48194 5997805.51500265 2086863.40763228 37.7100038942899 -122.44936749703399 (37.7100038942899, -122.449367497034)
122857 36234 1 37 5698 Mission St 2 1 1 1   05/05/1998 12:00:00 AM 2 3x3 Permit Number 39264 5997821.10019036 2086869.6666529 37.710021971633296 -122.449314082525 (37.7100219716333, -122.449314082525)
45187 180215 2 37 67 Garrison Ave 1 1 1 1     2 Width 2ft   6008244.87242 2086654.9382900002 37.710023111457296 -122.41327221445499 (37.7100231114573, -122.413272214455)
Powered by Datasette · Query took 44.297ms · Data source: data.sfgov.org