sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
129389 97178 1 85 222X Cumberland St 7 1 1 1   06/03/2015 12:00:00 AM 3 4x4 Permit Number 774483 6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895)
146016 108433 1 85 222x Cumberland St 6 1 1 1   06/03/2015 12:00:00 AM 3 4x4 Permit Number 774483 6004156.2455400005 2104544.03717 37.758912142621206 -122.428677685352 (37.7589121426212, -122.428677685352)
139630 108490 1 85 1198 Folsom St 2 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773696 6009647.20295 2110306.76017 37.7750444852375 -122.410094148747 (37.7750444852375, -122.410094148747)
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)
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)
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)
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)
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)
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)
139348 100700 6 85 200X 01st St 7 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)
139418 100697 6 85 200X 01st St 4 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)
19672 96325 1 85 1300X Sansome St 8 1 1 1   06/06/2011 12:00:00 AM 5 4x4 Permit Number 768012 6011919.0 2120150.9 37.8022012393453 -122.40292798450399 (37.8022012393453, -122.402927984504)
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)
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)
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)
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)
142828 50615 1 85 222X Cumberland St 3 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)
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)
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)
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)
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)
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)
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)
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)
144578 49226 1 85 500 Howard St 26 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)
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)
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)
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)
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)
134375 39384 1 85 2710 Broadway 2 1 1 1   12/21/1998 12:00:00 AM 7   Permit Number 40925 6000588.20452 2117202.1206900002 37.793465453027395 -122.441926131987 (37.7934654530274, -122.441926131987)
168945 39385 1 85 2710 Broadway 4 1 1 1   12/21/1998 12:00:00 AM 9   Permit Number 40925 6000567.4477 2117199.7395900004 37.7934577323376 -122.441997780973 (37.7934577323376, -122.441997780973)
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)
32103 38388 1 85 1150 Phelps St 2 1 1 1   08/17/1998 12:00:00 AM 5   Permit Number 40446 6014255.1081300005 2096652.83017 37.737810927032704 -122.39319864851801 (37.7378109270327, -122.393198648518)
1981 35702 1 85   15 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
5612 35700 1 85   14 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
7342 35697 1 85   8 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
8272 35698 1 85   10 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10284 35699 1 85   11 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11246 35705 1 85   7 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11435 35694 1 85   4 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11560 35695 1 85   5 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11610 35704 1 85   17 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
12226 35696 1 85   6 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
14850 35701 1 85   13 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15690 35690 1 85   9 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15799 35703 1 85   16 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15958 35692 1 85   2 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
16152 35693 1 85   3 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
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)
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)
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)
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)
138977 32406 1 85 201 Mission St 5 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
460 142327 2 85 1652 Hayes St 2 1 1 1     12 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
2250 200335 1 85 750 Phelps St 7 4 1 15     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847)
2256 200334 1 85 750 Phelps St 4 4 1 15   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.742565908900204 -122.388913512973 (37.7425659089002, -122.388913512973)
3401 29754 1 85 532 Columbus Ave 3 1 1 1     45 3x3   6009953.7417 2119408.8277 37.800053757708994 -122.40967634888099 (37.800053757709, -122.409676348881)
4102 253611 2 85 900 Front St 12 1 1 1       Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
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)
5782 29753 1 85 532 Columbus Ave 2 1 1 1     35 3x3   6009968.1915 2119398.824 37.8000270997238 -122.409625640361 (37.8000270997238, -122.409625640361)
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)
13467 15114 3 85 201 Mission St 4 1 1 2     12 4X4   6014005.1464 2116140.60731 37.79130618976829 -122.39542774681001 (37.7913061897683, -122.39542774681)
13518 106002 2 85 901 Minnesota St 2 1 1 1     12 3x3   6015261.96303 2104498.62679 37.759409725189705 -122.39026542781299 (37.7594097251897, -122.390265427813)
13924 15115 3 85 201 Mission St 5 1 1 2     12 4X4   6014020.20981 2116155.23725 37.7913471979732 -122.395376652733 (37.7913471979732, -122.395376652733)
14159 15120 3 85 201 Mission St 10 1 1 2     12 4X4   6014101.62567 2116233.31764 37.791566116339204 -122.395100425058 (37.7915661163392, -122.395100425058)
14190 15118 3 85 201 Mission St 8 1 1 2     12 4X4   6014060.69419 2116194.6265 37.7914576032294 -122.395239337045 (37.7914576032294, -122.395239337045)
14513 15112 3 85 201 Mission St 2 1 1 2     12 4X4   6013977.3910300005 2116114.5164400004 37.7912330065583 -122.395521951701 (37.7912330065583, -122.395521951701)
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)
15272 15116 3 85 201 Mission St 6 1 1 2     6 4X4   6014033.6168599995 2116167.8327099998 37.7913825278275 -122.39533114703 (37.7913825278275, -122.39533114703)
15920 15117 3 85 201 Mission St 7 1 1 2     12 4X4   6014044.26076 2116180.71375 37.7914184881275 -122.39529522181401 (37.7914184881275, -122.395295221814)
16130 15119 3 85 201 Mission St 9 1 1 2     6 4X4   6014087.04677 2116219.82682 37.7915282629576 -122.395149922854 (37.7915282629576, -122.395149922854)
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)
16815 15113 3 85 201 Mission St 3 1 1 2     12 4X4   6013991.513259999 2116128.24604 37.7912714903321 -122.395474051105 (37.7912714903321, -122.395474051105)
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)
23670 129807 2 85 901 Sacramento St 6 10 1 1     11 Width 3ft   6010390.20829 2116866.53247 37.793097682469394 -122.407986617304 (37.7930976824694, -122.407986617304)
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)
24992 129842 2 85 750 Battery St 2 1 1 1     14 Width 4ft   6012477.73931 2118700.3434099997 37.7982495441479 -122.400892491621 (37.7982495441479, -122.400892491621)
25127 200366 2 85 1300 Phelps St 8 4 1 1     12 Width 5ft   6014047.106269999 2096372.4575200002 37.7370295240776 -122.393898196954 (37.7370295240776, -122.393898196954)
25573 129783 2 85 900 Front St 11 1 1 1     18 Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
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)
28250 129809 2 85 901 Sacramento St 8 10 1 1     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.40789173971399 (37.7931091785103, -122.407891739714)
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)
29650 129819 2 85 241 Battery St 3 1 1 1     2 Width 3ft   6012648.9601 2117092.8382099997 37.793845267304505 -122.400187054399 (37.7938452673045, -122.400187054399)
30051 129811 2 85 435 Sacramento St 2 1 1 1     7 Width 3ft   6012498.509190001 2117154.1734 37.794005289065794 -122.40071194282801 (37.7940052890658, -122.400711942828)
30254 129837 2 85 733 Front St 4 1 1 1     10 Width 4ft   6012785.655809999 2118614.3901400003 37.79803070759829 -122.399820962885 (37.7980307075983, -122.399820962885)
30478 140287 2 85 1960 HAYES ST 3 1 1 1     9 Width 0ft   5998483.9171 2110037.6666 37.7736736024147 -122.448690838206 (37.7736736024147, -122.448690838206)
31300 200349 2 85 900 Phelps St 11 4 1 1     8 Width 4ft   6014526.629869999 2097016.7538700001 37.738825266977294 -122.392285304228 (37.7388252669773, -122.392285304228)
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)
31897 129849 2 85 103 Broadway 3 1 1 1     9 Width 4ft   6012584.80341 2118810.70115 37.798558531416795 -122.400529771657 (37.7985585314168, -122.400529771657)
32083 129818 2 85 241 Battery St 2 1 1 1     9 Width 3ft   6012648.53437 2117119.11483 37.79391739292829 -122.400190373809 (37.7939173929283, -122.400190373809)
Powered by Datasette · Query took 7.441ms · Data source: data.sfgov.org