sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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          
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
85076 97617 1 85 333 Battery St 2 1 1 1           6012618.0 2117355.0 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987)
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)
87423 97618 1 85 333 Battery St 3 1 1 1           6012618.0 2117355.0 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987)
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)
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)
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)
90885 85038 1 85 170 Vasquez Ave 2 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
123909 17641 1 85 600X Phelps St 2 1 1 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
145002 17644 1 85 600X Phelps St 5 1 1 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
37396 7768 3 85 325X Fulton St 3 1 1 2     12 3X3   6006199.471782 2111757.686674 37.7788345313197 -122.42212372172101 (37.7788345313197, -122.422123721721)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
125491 17660 1 85 1000X Phelps St 5 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
145599 17635 1 85 420X Phelps St 5 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
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)
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)
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)
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)
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)
85211 108652 2 85 1200x SANSOME ST 4 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
89013 108651 2 85 1200x SANSOME ST 3 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
89939 108657 2 85 1200x SANSOME ST 9 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
91345 108649 2 85 1200x SANSOME ST 1 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
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)
105044 108650 2 85 1200x SANSOME ST 2 1 1 1       3x3   6011928.0 2119969.0 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163)
Powered by Datasette · Query took 3.588ms · Data source: data.sfgov.org