sf-trees

Data source: data.sfgov.org

Custom SQL query returning 81 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5413 14844 3 85 1327 McAllister St 1 1 1 2   07/16/1987 12:00:00 AM 6 3x3   6002796.5861 2111629.8173 37.7782909152526 -122.43388649174999 (37.7782909152526, -122.43388649175)
7889 29752 1 85 532 Columbus Ave 1 1 1 1     45 3x3   6009988.1989 2119378.2609 37.7999717596155 -122.40955495470502 (37.7999717596155, -122.409554954705)
15015 106001 2 85 901 Minnesota St 1 1 1 1     9 3x3   6015262.44728 2104479.57944 37.75935745211439 -122.390262422266 (37.7593574521144, -122.390262422266)
16326 66490 1 85 280 07th St 1 1 1 1 1 07/13/2015 12:00:00 AM 3   Permit Number 775748 6010181.76408 2110999.12752 37.776975511839396 -122.408293821201 (37.7769755118394, -122.408293821201)
16571 97169 3 85 290 08th St 1 1 1 2     3 3x3   6009519.6482 2110372.42586 37.7752176376301 -122.410540028225 (37.7752176376301, -122.410540028225)
16836 15111 3 85 201 Mission St 1 1 1 2     18 4X4   6013962.82131 2116101.4847 37.79119641403479 -122.395571449475 (37.7911964140348, -122.395571449475)
24184 208171 2 85 158 Merced Ave 1 1 1 1     3 Width 4ft   5994395.10908 2099344.18308 37.744077400365 -122.46205892188401 (37.744077400365, -122.462058921884)
25678 129817 2 85 241 Battery St 1 1 1 1     8 Width 3ft   6012643.50693 2117148.0023 37.793996430738 -122.40020979915899 (37.793996430738, -122.400209799159)
28769 129827 2 85 354 Sacramento St 1 1 1 1     18 Width 3ft   6012617.00039 2117213.20404 37.7941739812068 -122.400306096749 (37.7941739812068, -122.400306096749)
31378 129821 2 85 504 Sansome St 1 1 1 1     15 Width 3ft   6012337.50928 2117203.47544 37.7941316797929 -122.40127248843201 (37.7941316797929, -122.401272488432)
32287 227937 2 85 465 Day St 1 1 1 1     16 Width 4ft   6002968.42227 2098587.5279900003 37.7424896769594 -122.43236030960699 (37.7424896769594, -122.432360309607)
33596 227938 2 85 25 Chattanooga St 1 1 1 1     4 Width 3ft   6004713.51107 2103480.2352 37.756022715594604 -122.426674645426 (37.7560227155946, -122.426674645426)
34082 129826 2 85 510 Battery St 1 1 1 1     8 Width 3ft   6012620.11049 2117309.3448900003 37.7944381345611 -122.400302091187 (37.7944381345611, -122.400302091187)
36450 39386 1 85 2710 Broadway 1 1 1 1   12/21/1998 12:00:00 AM 9   Permit Number 40925 6000600.16704 2117204.05937 37.7934714577907 -122.441884880082 (37.7934714577907, -122.441884880082)
36798 129763 2 85 1379 Green St 1 1 1 1     11 Width 4ft   6006382.65003 2118656.3506099996 37.7977868852004 -122.421980230217 (37.7977868852004, -122.421980230217)
38264 200368 2 85 199 Mission St 1 1 1 1     7 Width 4ft   6014118.97804 2116248.97229 37.7916100652992 -122.395041482589 (37.7916100652992, -122.395041482589)
38577 129810 2 85 435 Sacramento St 1 1 1 1     9 Width 3ft   6012477.08259 2117150.1123 37.7939929431787 -122.40078579605101 (37.7939929431787, -122.400785796051)
39753 129794 2 85 1180 Sansome St 1 1 1 1     8 Width 4ft   6011926.85553 2120176.70877 37.802272542593 -122.40290261667101 (37.802272542593, -122.402902616671)
40130 228846 2 85 210 Cumberland St 1 1 1 1     7 Width 3ft   6004252.08143 2104552.56077 37.758940969765 -122.428346847525 (37.758940969765, -122.428346847525)
41186 228842 2 85 1010 Ashbury St 1 1 1 1     9 Width 3ft   5999127.094409999 2106474.67422 37.7639272833421 -122.446209649681 (37.7639272833421, -122.446209649681)
43828 208173 2 85 170 Vasquez Ave 1 2 1 1     9 Width 3ft   5994847.17518 2099430.14012 37.744339434016794 -122.460502016448 (37.7443394340168, -122.460502016448)
46833 227936 2 85 167 Valley St 1 1 1 1     26 Width 5ft   6004844.7517 2099277.52267 37.7444904598682 -122.42592162061001 (37.7444904598682, -122.42592162061)
47917 129784 2 85 1600 Montgomery St 1 9 1 1     9 Width 3ft   6011334.32807 2120989.68408 37.8044716700829 -122.405010336152 (37.8044716700829, -122.405010336152)
51118 62971 1 85 1833 Jones St 1 1 1 1 1 08/21/1986 12:00:00 AM 6   Permit Number 23358 6008235.84849 2118785.82593 37.7982467346621 -122.415576801855 (37.7982467346621, -122.415576801855)
53935 208172 2 85 154 Merced Ave 1 1 1 1     4 Width 4ft   5994418.094740001 2099364.4172099996 37.7441342815725 -122.46198091018499 (37.7441342815725, -122.461980910185)
55932 143040 2 85 1760 Grant Ave 1 1 1 1     16 Width 0ft   6010444.0727 2120551.0606 37.8032175128046 -122.408060206321 (37.8032175128046, -122.408060206321)
57135 65057 1 85 750 Battery St 1 1 1 1   05/23/1989 12:00:00 AM 14   Permit Number 27011 6012481.29964 2118678.07069 37.7981885871952 -122.400878606079 (37.7981885871952, -122.400878606079)
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)
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)
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)
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)
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)
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)
78762 85037 1 85 170 Vasquez Ave 1 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
129842 228840 2 85 104 Chattanooga St 1 1 1 1     8 Width 4ft   6004701.59069 2103023.11733 37.754766903184 -122.426683319388 (37.754766903184, -122.426683319388)
133858 38495 1 85 1353 Green St 1 1 1 1 1 12/05/1998 12:00:00 AM 9 3x3 Permit Number 40489 6006548.48859 2118678.2473299997 37.7978563596483 -122.421407937635 (37.7978563596483, -122.421407937635)
134068 142927 2 85 501 Vallejo St 1 1 1 1     17 Width 0ft   6011089.2103 2118971.3611 37.79891614378229 -122.405716341604 (37.7989161437823, -122.405716341604)
134069 124474 2 85 344 Willard St North 1 1 1 1     4 Width 3ft   5996301.59979 2110522.81259 37.7748806555631 -122.45627485050899 (37.7748806555631, -122.456274850509)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
145231 68365 1 85 945 Sacramento St 1 1 1 1 1 08/09/1993 12:00:00 AM     Permit Number 32186 6010298.82314684 2116844.8632648997 37.7930330672197 -122.40830128766501 (37.7930330672197, -122.408301287665)
151478 228845 2 85 4526 20th St 1 1 1 1     17 Width 3ft   6001290.00365 2104097.6707200003 37.7575238972389 -122.438558485713 (37.7575238972389, -122.438558485713)
154064 208170 2 85 1225 Willard St 1 1 1 1     22 Width 3ft   5996717.7598 2107182.54151 37.7657330159006 -122.454593911282 (37.7657330159006, -122.454593911282)
155277 228844 2 85 709 Eugenia Ave 1 1 1 1     10 Width 3ft   6007473.725769999 2097767.91667 37.7404936415809 -122.416724215363 (37.7404936415809, -122.416724215363)
156540 129834 2 85 733 Front St 1 1 1 1     13 Width 4ft   6012777.11642 2118676.9470599997 37.7982019978752 -122.399854906882 (37.7982019978752, -122.399854906882)
157370 129766 2 85 1375 Green St 1 1 1 1     10 Width 5ft   6006461.42741 2118668.07402 37.797823517302206 -122.42170847129199 (37.7978235173022, -122.421708471292)
158244 129814 2 85 433 Sacramento St 1 1 1 1     8 Width 3ft   6012557.97886 2117161.9578299997 37.7940299799473 -122.40050671752199 (37.7940299799473, -122.400506717522)
160462 177154 2 85 734 Peru Ave 1 9 1 1     6 Width 8ft   6005364.09678 2092392.61851 37.725615388036104 -122.42363641630301 (37.7256153880361, -122.423636416303)
161074 129768 2 85 489 Vallejo St 1 1 1 1     7 Width 5ft   6011131.656690001 2118977.1984099997 37.7989345451634 -122.40556987367201 (37.7989345451634, -122.405569873672)
161111 129785 2 85 1160 Sansome St 1 1 1 1     7 Width 4ft   6011966.59622 2119867.2001900002 37.8014249261853 -122.402743314356 (37.8014249261853, -122.402743314356)
164671 64662 1 85 2786 Filbert St 1 1 1 1   04/17/1989 12:00:00 AM 14 6x4 Permit Number 26052 5999613.31909 2118454.39818 37.796848274496206 -122.445389381638 (37.7968482744962, -122.445389381638)
166496 51593 1 85 1960 Hayes St 1 1 1 1   11/08/2010 12:00:00 AM 1 3x3 Permit Number 53890 5998519.8939 2110042.61 37.773689232881395 -122.44856674553301 (37.7736892328814, -122.448566745533)
166582 142921 2 85 546 COLUMBUS AVE 1 1 1 1     13 Width 0ft   6009942.6265 2119419.3871 37.800082128353 -122.409715557637 (37.800082128353, -122.409715557637)
168272 129750 2 85 2320 Chestnut St 1 1 1 1     6 Width 3ft   6000760.50701 2119657.6711 37.800217563850296 -122.44150624394301 (37.8002175638503, -122.441506243943)
168339 49588 1 85 2333 REVISED Buchanan St 1 1 1 1   05/16/2003 12:00:00 AM 16   Permit Number 46464 6003709.90767 2116419.2146400004 37.7914931831193 -122.431068901134 (37.7914931831193, -122.431068901134)
169203 129777 2 85 900 Front St 1 1 1 1     18 Width 3ft   6012748.89649 2119266.86751 37.79982020469429 -122.399994005922 (37.7998202046943, -122.399994005922)
169282 200361 2 85 1300 Phelps St 1 4 1 1     7 Width 5ft   6014182.02229 2096553.32448 37.7375336444497 -122.39344438196699 (37.7375336444497, -122.393444381967)
169758 208167 2 85 2590 16th Ave 1 1 1 1     9 Width 3ft   5991441.567009999 2097783.56953 37.7396218639513 -122.47215777968201 (37.7396218639513, -122.472157779682)
173137 227935 2 85 705 Treat Ave 1 1 1 1     1 Width 4ft   6008535.61915 2104408.30699 37.7587863358342 -122.413522114462 (37.7587863358342, -122.413522114462)
176440 62970 1 85 1827 Jones St 1 1 1 1 1 08/21/1986 12:00:00 AM 10   Permit Number 23357 6008241.174219999 2118766.33453 37.7981935154844 -122.41555699245701 (37.7981935154844, -122.415556992457)
179760 129847 2 85 103 Broadway 1 1 1 1     8 Width 4ft   6012509.67235 2118803.01279 37.798533230779 -122.40078920986099 (37.798533230779, -122.400789209861)
184232 129802 2 85 901 Sacramento St 1 10 1 1     10 Width 3ft   6010252.4995 2116845.85776 37.79303320378 -122.40846164098801 (37.79303320378, -122.408461640988)
187275 129839 2 85 238 Pacific Ave 1 1 1 1     13 Width 4ft   6012727.894069999 2118536.52905 37.7978136994111 -122.400015365729 (37.7978136994111, -122.400015365729)
187663 129748 2 85 2300 Chestnut St 1 1 1 1     7 Width 3ft   6000804.68172 2119664.29702 37.800238273442396 -122.441353858292 (37.8002382734424, -122.441353858292)
188297 129845 2 85 485 Pacific Ave 1 1 1 1     16 Width 2ft   6011739.20457 2118363.85261 37.797284398923004 -122.40342437184201 (37.797284398923, -122.403424371842)
Powered by Datasette · Query took 4.587ms · Data source: data.sfgov.org