sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
58412 129758 2 85 311 Fulton St 1 1 1 1     3 Width 4ft   6006236.20671 2111756.75185 37.778834036391395 -122.42199657448201 (37.7788340363914, -122.421996574482)
59650 129831 2 85 354 Sacramento St 5 1 1 1     7 Width 3ft   6012476.45918 2117195.3094900004 37.7941170091435 -122.40079112993 (37.7941170091435, -122.40079112993)
61384 63581 1 85 1360 Green St 1 1 1 1 1 04/30/1987 12:00:00 AM 13   Permit Number 24204 6006506.63769 2118721.20057 37.7979719387185 -122.421555805959 (37.7979719387185, -122.421555805959)
62252 227934 2 85 1731 15th St 1 1 1 1     1 Width 3ft   6005814.854180001 2107243.32997 37.7664174935056 -122.423133300469 (37.7664174935056, -122.423133300469)
62368 39387 1 85 2710 Broadway 3 1 1 1   12/21/1998 12:00:00 AM 7   Permit Number 40925 6000579.41048 2117201.67826 37.7934637371134 -122.44195652817899 (37.7934637371134, -122.441956528179)
62703 129830 2 85 354 Sacramento St 4 1 1 1     9 Width 3ft   6012498.4118 2117199.54922 37.794129874847606 -122.400715469043 (37.7941298748476, -122.400715469043)
63351 200365 2 85 1300 Phelps St 7 4 1 1     6 Width 5ft   6014060.81183 2096393.5404700001 37.7370881751809 -122.39385228564801 (37.7370881751809, -122.393852285648)
63604 142487 2 85 1527 STOCKTON ST 1 1 1 1     9 Width 0ft   6010095.4595 2119399.2703 37.800035455862606 -122.409185274056 (37.8000354558626, -122.409185274056)
65614 228852 2 85 210 Cumberland St 7 1 1 1     3 Width 3ft   6004131.71858 2104545.14122 37.7589137859482 -122.428762589748 (37.7589137859482, -122.428762589748)
65786 129752 2 85 2407 Clay St 3 1 1 1     9 Width 4ft   6003040.06059 2116163.9449299998 37.790754298317204 -122.43336831020201 (37.7907542983172, -122.433368310202)
66199 7767 3 85 325X Fulton St 2 1 1 2   05/25/2010 12:00:00 AM   3X3   6006199.471782 2111757.686674 37.7788345313197 -122.42212372172101 (37.7788345313197, -122.422123721721)
66960 200333 2 85 903 Minnesota St 1 1 1 1     9 Width 3ft   6015264.35575 2104459.34943 37.7593020107061 -122.39025440841002 (37.7593020107061, -122.39025440841)
67057 66847 1 85 45 Ashbury St 1 1 1 1 1 11/15/1991 12:00:00 AM 2   Permit Number 30151 5998689.6182 2110496.1606 37.7749442695784 -122.448012307244 (37.7749442695784, -122.448012307244)
67539 129822 2 85 504 Sansome St 2 1 1 1     17 Width 3ft   6012331.01864 2117278.3358 37.7943368663928 -122.401300210056 (37.7943368663928, -122.401300210056)
68851 228850 2 85 210 Cumberland St 5 1 1 1     6 Width 3ft   6004169.71901 2104547.0578 37.7589211990752 -122.42863130311501 (37.7589211990752, -122.428631303115)
69203 129829 2 85 354 Sacramento St 3 1 1 1     2 Width 3ft   6012523.949659999 2117203.16491 37.7941412269928 -122.400627358876 (37.7941412269928, -122.400627358876)
69311 129760 2 85 2222 Polk St 1 1 1 1     9 Width 4ft   6006381.91218 2118496.72963 37.7973485646419 -122.421971438426 (37.7973485646419, -122.421971438426)
70036 129756 2 85 2315 Buchanan St 2 1 1 1     16 Width 5ft   6003701.89513 2116476.8237099997 37.7916509089176 -122.43110073801 (37.7916509089176, -122.43110073801)
71586 129848 2 85 103 Broadway 2 1 1 1     8 Width 4ft   6012543.75409 2118806.63113 37.7985450667665 -122.400671529986 (37.7985450667665, -122.400671529986)
72002 129820 2 85 241 Battery St 4 1 1 1     11 Width 3ft   6012651.85549 2117070.09364 37.7937829775554 -122.400175437873 (37.7937829775554, -122.400175437873)
72490 200340 2 85 750 Phelps St 23 4 1 1     8 Width 2ft   6015300.13853 2098052.9717 37.7417134289277 -122.38968320401399 (37.7417134289277, -122.389683204014)
72647 200369 2 85 650 Townsend St 10 1 1 1     7 Width 4ft   6011472.2786 2108553.20224 37.7703317423487 -122.403657370911 (37.7703317423487, -122.403657370911)
72713 208168 2 85 2590 16th Ave 2 1 1 1     11 Width 3ft   5991441.450619999 2097800.63089 37.7396687033598 -122.472159425416 (37.7396687033598, -122.472159425416)
73201 228843 2 85 707 Eugenia Ave 2 1 1 1     14 Width 3ft   6007452.7290199995 2097768.34677 37.7404936415683 -122.416796844595 (37.7404936415683, -122.416796844595)
74895 200358 2 85 1150 Phelps St 3 4 1 1     12 Width 5ft   6014239.8641 2096632.70057 37.7377548084229 -122.393249946754 (37.7377548084229, -122.393249946754)
75033 228849 2 85 210 Cumberland St 4 1 1 1     5 Width 3ft   6004184.64448 2104547.65023 37.75892367042171 -122.42857972608499 (37.7589236704217, -122.428579726085)
75153 49224 1 85 500 Howard St 13 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
75415 129774 2 85 80 Vallejo St 6 1 1 1     16 Width 3ft   6012849.953480001 2119259.82939 37.7998065134132 -122.39964381442499 (37.7998065134132, -122.399643814425)
75521 228848 2 85 210 Cumberland St 3 1 1 1     3 Width 3ft   6004199.57922 2104548.6925 37.7589273774242 -122.42852814905599 (37.7589273774242, -122.428528149056)
75710 129769 2 85 80 Vallejo St 1 1 1 1     20 Width 4ft   6013010.632 2119281.7619 37.7998756901686 -122.39908934370101 (37.7998756901686, -122.399089343701)
75743 17631 1 85 420X Phelps St 1 1 1 15   11/15/1992 12:00:00 AM 6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
76523 200341 2 85 750 Phelps St 24 4 1 1     8 Width 2ft   6015282.07626 2098027.6206799997 37.74164281866221 -122.389743887597 (37.7416428186622, -122.389743887597)
76914 129776 2 85 80 Vallejo St 8 1 1 1     18 Width 3ft   6012790.20467 2119250.54506 37.7997776901326 -122.39984991653601 (37.7997776901326, -122.399849916536)
78762 85037 1 85 170 Vasquez Ave 1 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
83164 17638 1 85 420X Phelps St 8 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
83335 31389 1 85 201 Mission St 1 1 1 1   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188)
83384 17658 1 85 1000X Phelps St 3 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
84349 96323 1 85 1300X Sansome St 6 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
84551 45668 1 85 46(REVISED) Clipper St 1 1 1 1 1 10/06/2003 12:00:00 AM     Permit Number 44364 6004865.19751473 2101080.41704042 37.7494419484142 -122.425979237767 (37.7494419484142, -122.425979237767)
85027 96326 1 85 1300X Sansome St 9 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
85032 17636 1 85 420X Phelps St 6 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
85076 97617 1 85 333 Battery St 2 1 1 1           6012618.0 2117355.0 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987)
85211 108652 2 85 1200x SANSOME ST 4 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
85402 100699 6 85 200X 01st St 6 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
85626 17642 1 85 600X Phelps St 3 1 1 15     6 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
87097 100696 6 85 200X 01st St 3 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
87423 97618 1 85 333 Battery St 3 1 1 1           6012618.0 2117355.0 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987)
87807 17661 1 85 1000X Phelps St 6 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
88337 96318 1 85 1300X Sansome St 1 1 1 1     5 4x4   6011857.0 2120322.0 37.802667576079 -122.403154578184 (37.802667576079, -122.403154578184)
88634 100146 2 85 222X Cumberland St 5 1 1 1           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895)
88835 49214 1 85 500 Howard St 19 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
89013 108651 2 85 1200x SANSOME ST 3 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
89364 100695 6 85 200X 01st St 2 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
89939 108657 2 85 1200x SANSOME ST 9 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
90132 61067 1 85 532 Columbus Ave 1 1 1 1   11/07/2002 12:00:00 AM     Permit Number 46064 6010044.29985327 2119322.50303189 37.7998218055895 -122.40935688621799 (37.7998218055895, -122.409356886218)
90452 86806 1 85 700X Phelps St 1 1 1 15     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
90885 85038 1 85 170 Vasquez Ave 2 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
90896 115305 2 85 1199x KEARNY ST 1 1 1 1       6x5   6011077.0 2118941.0 37.7988320967672 -122.405756453764 (37.7988320967672, -122.405756453764)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
91345 108649 2 85 1200x SANSOME ST 1 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
91400 49223 1 85 500 Howard St 6 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
91499 96324 1 85 1300X Sansome St 7 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
91941 52992 1 85 1800 Oakdale Ave 3 1 1 1       3x3 Permit Number 48973 6013995.42685531 2096291.44248921 37.7368042013217 -122.394071207374 (37.7368042013217, -122.394071207374)
92402 17639 1 85 420X Phelps St 9 1 1 15     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
93009 86807 1 85 700X Phelps St 2 1 1 15     6 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
93478 115306 2 85 1199x KEARNY ST 2 1 1 1       5x5   6011157.0 2118940.0 37.7988338244478 -122.405479555764 (37.7988338244478, -122.405479555764)
94447 17645 1 85 600X Phelps St 6 1 1 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
94681 63072 1 85 709 Eugenia Ave 1 1 1 1 1 11/21/1986 12:00:00 AM     Permit Number 23550 6007407.20126882 2097784.26133742 37.740534778558605 -122.416955389518 (37.7405347785586, -122.416955389518)
96672 97619 1 85 333 Battery St 4 1 1 1           6012618.0 2117355.0 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987)
98558 50617 1 85 222X Cumberland St 1 1 1 1 1 10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267)
99398 49230 1 85 500 Howard St 11 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
100107 100701 6 85 200X 01st St 8 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
100984 32407 1 85 201 Mission St 4 1 1 1   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188)
102325 17634 1 85 420X Phelps St 4 1 1 15     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
102887 100698 6 85 200X 01st St 5 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
104025 17656 1 85 1000X Phelps St 1 1 1 13   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104908 17662 1 85 1000X Phelps St 7 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
105044 108650 2 85 1200x SANSOME ST 2 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
105063 200347 2 85 900 Phelps St 9 4 1 1     11 Width 4ft   6014556.031830001 2097054.78425 37.7389313231291 -122.392186304173 (37.7389313231291, -122.392186304173)
107979 96322 1 85 1300X Sansome St 5 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
109408 17643 1 85 600X Phelps St 4 1 1 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
109863 31388 1 85 201 Mission St 2 1 1 1   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188)
111666 49232 1 85 500 Howard St 27 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
112760 200367 2 85 1300 Phelps St 9 4 1 1     17 Width 5ft   6014030.85339 2096351.6806400002 37.7369715717905 -122.393952936896 (37.7369715717905, -122.393952936896)
112988 108036 1 85 1527 Stockton St 2 1 1 1           6010078.267999999 2119414.52002 37.800076364716396 -122.4092458402 (37.8000763647164, -122.4092458402)
113579 108037 1 85 1527 Stockton St 3 1 1 1           6010078.267999999 2119414.52002 37.800076364716396 -122.4092458402 (37.8000763647164, -122.4092458402)
113875 129759 2 85 1827 Jones St 2 1 1 1     10 Width 3ft   6008241.72856 2118745.4751 37.7981362718366 -122.415553596641 (37.7981362718366, -122.415553596641)
114000 108654 2 85 1200x SANSOME ST 6 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
114181 100694 6 85 200X 01st St 1 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
116101 17647 1 85 650X Phelps St 2 1 1 15     6 2x2   6015137.8127243 2097842.4274143996 37.7411263152677 -122.39022977121401 (37.7411263152677, -122.390229771214)
116184 49225 1 85 500 Howard St 23 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
116186 108655 2 85 1200x SANSOME ST 7 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
116567 32408 1 85 201 Mission St 3 1 1 1   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188)
117411 17659 1 85 1000X Phelps St 4 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
118847 108695 1 85 511 Alvarado St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774625 6003049.10666 2102687.45843 37.7537516993963 -122.432374086122 (37.7537516993963, -122.432374086122)
119723 96319 1 85 1300X Sansome St 2 1 1 1     5 4x4   6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
120148 7766 3 85 325X Fulton St 1 1 1 2     12 3X3   6006199.471782 2111757.686674 37.7788345313197 -122.42212372172101 (37.7788345313197, -122.422123721721)
120360 108653 2 85 1200x SANSOME ST 5 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
120380 64146 1 85 465 Day St 1 1 1 1 1 12/05/1987 12:00:00 AM     Permit Number 24921 6002780.16143913 2098575.90057442 37.7424470739996 -122.433010428517 (37.7424470739996, -122.433010428517)
121680 50616 1 85 222X Cumberland St 2 1 1 1   10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267)
122054 100145 2 85 222X Cumberland St 4 1 1 1           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895)
Powered by Datasette · Query took 2.722ms · Data source: data.sfgov.org