sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
90012 94626 1 204 1740 Bancroft Ave 1 5 1 1   10/13/2010 12:00:00 AM 9   permit 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
116551 93975 1 161 59@ Golden gate Ave Roselyn Ter 3 5 1 1         Tree 3 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
139234 93020 1 19 1403 11th Ave 3 5 1 1     10 2x2 Tree 3 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
138791 93974 1 161 59@ Golden Gate Ave Roselyn Ter 2 5 1 1         Tree 2 on Golden Gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
87296 93973 1 161 59@ Golden gate Ave Roselyn Ter 1 5 1 1         Tree 1 on Golden gate Ave 5998204.2 2111419.4 37.777451486883294 -122.449758011487 (37.7774514868833, -122.449758011487)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
2153 251201 2 2 2000X Market St 1 5 1 1   06/27/2017 12:00:00 AM 3   Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2158 251202 2 2 2000X Market St 2 5 1 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2159 251203 2 2 2000X Market St 3 5 1 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2162 251204 2 2 2000X Market St 4 5 1 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
4916 251372 6 129 1526 Masonic Ave 1 5 1 1   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767.0 2107205.0 37.7659690994291 -122.44404889486401 (37.7659690994291, -122.444048894864)
13300 114607 2 17 2399X 15TH AVE 1 5 1 1     10   Permit Number 779471 5991654.0 2099150.0 37.7433860243849 -122.471522828523 (37.7433860243849, -122.471522828523)
10157 173899 4 46 1762 12th Ave 2 5 1 1       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653)
10163 173898 4 46 1762 12th Ave 1 5 1 1       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653)
10019 173629 6 260 10X Junipero Serra Blvd Off Ramp 1 5 1 1   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
13252 115099 2 17 1061X PACHECO ST 1 5 1 1   02/16/2017 12:00:00 AM 3 3x10 Permit Number 779333 5991641.0 2102174.0 37.7516883950984 -122.47178811631599 (37.7516883950984, -122.471788116316)
88445 122634 6 17 3680X 19th Ave 1 5 1 1   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592.0 2091224.0 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991)
103209 122566 1 95 378 Sweeny St 1 5 1 1   11/07/2016 12:00:00 AM 3 3x3 Permit Number 779091 6008597.7357 2094518.65936 37.731635041845706 -122.412608176508 (37.7316350418457, -122.412608176508)
22894 206842 6 17 218 Sadowa St 3 5 1 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288001 (37.712360795684, -122.45981072288)
22897 215094 6 17 218 Sadowa St 1 5 1 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.2030900002 37.7123610457095 -122.45974695827199 (37.7123610457095, -122.459746958272)
108066 114815 2 17 160 BRENTWOOD AVE 1 5 1 1   11/08/2016 12:00:00 AM 3 4x15 Permit Number 778944 5995496.0 2095622.0 37.7339205232551 -122.457982998117 (37.7339205232551, -122.457982998117)
9790 104876 4 227 2478 43rd Ave   5 1 1   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277)
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 6 3 3995X Alemany Blvd 6 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 6 3 3995X Alemany Blvd 14 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 6 3 3995X Alemany Blvd 5 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10006 120927 6 3 3995X Alemany Blvd 10 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 6 3 3995X Alemany Blvd 11 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10021 120935 6 3 3995X Alemany Blvd 18 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
82026 119268 1 17 109 Gates St 1 5 1 1   08/24/2016 12:00:00 AM 3 3x3 Permit Number 778717 6008342.0 2098018.0 37.741229112716105 -122.41373973636001 (37.7412291127161, -122.41373973636)
10052 121312 2 11 298X Spear St 3 5 1 1       3x4 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10061 121311 2 11 298X Spear St 2 5 1 1       3x4 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10071 121313 2 11 298X Spear St 4 5 1 1       3x4 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10075 121310 2 11 298X Spear St 1 5 1 1       3x4 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
141673 117508 2 235 21 MOUNTAIN SPRING AVE 1 5 1 1     9 3x10 Permit Number 778424 5997487.0 2104391.0 37.758112238825206 -122.451731896555 (37.7581122388252, -122.451731896555)
86503 117100 2 3 677 ULLOA ST 1 5 1 1       3x3 Permit Number 778379 5994251.0 2098113.0 37.7406885817292 -122.46246793072201 (37.7406885817292, -122.462467930722)
114540 117101 2 17 677 ULLOA ST 2 5 1 1   09/30/2016 12:00:00 AM 3 3x3 Permit Number 778379 5994251.0 2098113.0 37.7406885817292 -122.46246793072201 (37.7406885817292, -122.462467930722)
114144 116645 2 11 20 HAWTHORNE ST 2 5 1 1   04/25/2016 12:00:00 AM 3 3x3 Permit Number 778170 6012906.0 2114090.0 37.785614507123796 -122.39908679358801 (37.7856145071238, -122.399086793588)
5925 95365 1 82 661 Broadway 2 5 1 1     8 3x3 Permit Number 778058 6010478.0762 2118518.1883 37.797637647796996 -122.40779910526899 (37.797637647797, -122.407799105269)
53643 95364 1 82 661 Broadway 1 5 1 1     7 3x3 Permit Number 778058 6010448.4751 2118513.4790000003 37.797623060035 -122.407901201302 (37.797623060035, -122.407901201302)
88463 116012 2 437 250 HAZELWOOD AVE 1 5 1 1     18 10x10 Permit Number 777957 5996359.0 2095057.0 37.7324187155695 -122.454958550665 (37.7324187155695, -122.454958550665)
117259 116463 2 17 1898X FUNSTON AVE 1 5 1 1     35 3x3 Permit Number 777893 5992212.0 2102539.0 37.752723611861704 -122.46984011316201 (37.7527236118617, -122.469840113162)
126648 116460 2 17 66 AERIAL WAY 1 5 1 1     30 3x3 Permit Number 777893 5992280.0 2102576.0 37.7528291346084 -122.469607652393 (37.7528291346084, -122.469607652393)
93028 115827 6 1 60X CHUMASERO DR 1 5 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
105446 38572 1 361 1222 Palou Ave 1 5 1 1   03/25/2016 12:00:00 AM 3   Permit Number 777465 6016907.86791438 2093772.63366009 37.730049495784 -122.38382619652398 (37.730049495784, -122.383826196524)
106512 117420 1 17 77 Dorado Ter 1 5 1 1   06/08/2016 12:00:00 AM 3 3x3 Permit Number 777175 5994584.4 2093084.8 37.7269015728644 -122.46095082579399 (37.7269015728644, -122.460950825794)
53187 69218 1 17 1196 Treat Ave 1 5 1 1   11/02/2015 12:00:00 AM   3x3 Permit Number 776894 6008647.40418625 2101585.3758574 37.7510414812393 -122.412935918741 (37.7510414812393, -122.412935918741)
86280 113491 6 132 366x 07TH AVE 1 5 1 1   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712.0 2113143.0 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165)
82017 112740 2 17 2514 CLAY ST 1 5 1 1   11/09/2015 12:00:00 AM   3x3 Permit Number 776637 6002696.0 2116178.0 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658)
79092 115287 1 80 1526 12th Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 776185 5992489.2 2105046.7 37.759625121297795 -122.469064003389 (37.7596251212978, -122.469064003389)
66846 112874 6 21 2636 Vallejo St 1 5 1 1   08/25/2015 12:00:00 AM 13 3x3 Permit Number 776037 6000935.48392 2117605.97258 37.794594107573104 -122.440753504176 (37.7945941075731, -122.440753504176)
84318 114974 1 134 23 Holloway Ave 1 5 1 1   12/28/2015 12:00:00 AM     Permit Number 775981 5996745.4 2091181.1 37.7217985747524 -122.45334295571999 (37.7217985747524, -122.45334295572)
98092 115300 1 79 177 Lomita Ave 2 5 1 1   01/22/2016 12:00:00 AM     Permit Number 775793 5991298.7 2104254.5 37.757381090716 -122.473123533862 (37.757381090716, -122.473123533862)
99519 115299 1 79 177 Lomita Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 775793 5991298.7 2104254.5 37.757381090716 -122.473123533862 (37.757381090716, -122.473123533862)
105069 115270 1 264 2218 31st Ave 2 5 1 1   01/21/2016 12:00:00 AM     Permit Number 775791 5986730.3 2100136.4 37.7458083387155 -122.48861998421499 (37.7458083387155, -122.488619984215)
99798 111746 1 79 398X 03rd St 1 5 1 1   06/22/2015 12:00:00 AM 3 10x20 Permit Number 775763 6013296.047180001 2113048.21405 37.7827757318295 -122.397664238011 (37.7827757318295, -122.397664238011)
140674 111747 1 79 398X 03rd St 2 5 1 1   06/22/2015 12:00:00 AM 3 10x20 Permit Number 775763 6013296.047180001 2113048.21405 37.7827757318295 -122.397664238011 (37.7827757318295, -122.397664238011)
107475 110612 2 46 15 MAGELLAN AVE   5 1 1   05/12/2015 12:00:00 AM 3 3x3 Permit Number 775412 5994586.0 2101167.0 37.7490933856104 -122.46153099469801 (37.7490933856104, -122.461530994698)
77563 94632 1 12 3600 16th St 1 5 1 1   01/19/2016 12:00:00 AM   3x3 Permit Number 775358 6002902.0 2106490.0 37.764184223284396 -122.433154488347 (37.7641842232844, -122.433154488347)
141647 122627 4 12 34 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731.0 2094410.0 37.729968312905505 -122.49511098534401 (37.7299683129055, -122.495110985344)
109068 112659 1 17 101 Quintara St 1 5 1 1   08/14/2015 12:00:00 AM     Permit Number 775001 5993151.2 2101136.7 37.748927499569604 -122.466490304373 (37.7489274995696, -122.466490304373)
126079 110307 1 17 899x Stanyan St 2 5 1 5   04/03/2015 12:00:00 AM 3 4x11 Permit Number 774992 5997166.64381 2107575.86009 37.7668387037649 -122.45306972128999 (37.7668387037649, -122.45306972129)
15948 101850 1 37 1001X Rhode Island St 4 5 1 1   12/31/2015 12:00:00 AM 2 3x3 Permit Number 774983 6011937.4679 2103668.00433 37.7569440557359 -122.401704847401 (37.7569440557359, -122.401704847401)
63008 114541 1 51 1001X Rhode Island St 3 5 1 1   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011939.68484 2103650.19837 37.756895288204 -122.401695928834 (37.756895288204, -122.401695928834)
138648 122626 4 141 330 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613.0 2095517.0 37.73300093168071 -122.495600537949 (37.7330009316807, -122.495600537949)
101885 122625 4 141 189 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222.0 2094938.0 37.731388248087605 -122.496909587532 (37.7313882480876, -122.496909587532)
53784 113548 1 12 1911 20th St 1 5 1 1   09/30/2015 12:00:00 AM 1   Permit Number 774960 6012300.00129 2104664.7502 37.759701124429796 -122.400521077012 (37.7597011244298, -122.400521077012)
8131 112367 6 5 2770 Broadway 1 5 1 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
88436 110160 2 253 484 Sanchez St 1 5 1 1         Permit Number 774829 6003562.4 2105468.5 37.761416869861996 -122.430797452614 (37.761416869862, -122.430797452614)
86120 114712 1 161 601X Somerset St 1 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
92714 114713 1 161 601X Somerset St 2 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
97865 114715 1 161 601X Somerset St 4 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
105879 114717 1 161 601X Somerset St 6 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
110071 114718 1 161 601X Somerset St 7 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
118222 114719 1 161 601X Somerset St 8 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
125441 114716 1 161 601X Somerset St 5 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
143907 114714 1 161 601X Somerset St 3 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
121701 108636 1 80 68 Mangels Ave   5 1 1 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774603 6000942.00546 2095224.20835 37.7331396755893 -122.439126041581 (37.7331396755893, -122.439126041581)
82951 109969 6 44 1x DAVIS ST 1 5 1 1   08/28/2015 12:00:00 AM 18 3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592)
110771 109970 6 44 1x DAVIS ST 2 5 1 1   08/28/2015 12:00:00 AM   3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592)
103873 110454 1 134 7630 Geary Blvd 1 5 1 1   04/15/2015 12:00:00 AM 3 3x3 Permit Number 774506 5983294.7 2112541.2 37.7796673212814 -122.501417065582 (37.7796673212814, -122.501417065582)
119888 107369 2 17 1990X LAGUNA ST 3 5 1 1   11/21/2014 12:00:00 AM 3 3x3 Permit Number 774385 6004403.0 2115650.0 37.789420363641895 -122.42861595649099 (37.7894203636419, -122.428615956491)
81042 112562 1 17 1000X 17th Ave   5 1 1   08/06/2015 12:00:00 AM     Permit Number 774340 5990959.97324 2102133.59106 37.7515380150924 -122.47414022419301 (37.7515380150924, -122.474140224193)
117600 112563 1 17 1000X 17th Ave   5 1 1   08/06/2015 12:00:00 AM     Permit Number 774340 5990959.97324 2102133.59106 37.7515380150924 -122.47414022419301 (37.7515380150924, -122.474140224193)
90642 108476 2 1 1201X 19th Ave 2 5 1 1         Permit Number 774311 5990125.2811900005 2107203.87819 37.7654112822972 -122.477397189068 (37.7654112822972, -122.477397189068)
104770 108475 2 1 1201X 19th Ave 1 5 1 1         Permit Number 774311 5990125.2811900005 2107203.87819 37.7654112822972 -122.477397189068 (37.7654112822972, -122.477397189068)
119669 108477 2 1 1201X 19th Ave 3 5 1 1         Permit Number 774311 5990125.2811900005 2107203.87819 37.7654112822972 -122.477397189068 (37.7654112822972, -122.477397189068)
92122 115292 1 12 2058 17th Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 774300 5991031.5 2101384.0 37.7494839769409 -122.47383819807501 (37.7494839769409, -122.473838198075)
78260 108099 1 35 2390X Green St 1 5 1 1   11/20/2014 12:00:00 AM 3   Permit Number 774210 6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269)
125075 53133 1 90 925 Holloway Ave 1 5 1 1 1 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.46282963525199 (37.7216197566197, -122.462829635252)
105658 112431 2 17 19 Arguello Blvd 1 5 1 1   07/29/2015 12:00:00 AM   3x3 Permit Number 774101 5995479.0 2115773.8 37.7892512085361 -122.45950075691601 (37.7892512085361, -122.459500756916)
110265 112433 2 41 19 Arguello Blvd 3 5 1 1       3x3 Permit Number 774101 5995479.0 2115773.8 37.7892512085361 -122.45950075691601 (37.7892512085361, -122.459500756916)
99781 112425 2 41 17 Arguello Blvd 1 5 1 1   07/29/2015 12:00:00 AM   3x3 Permit Number 774100 5995478.7 2115781.3 37.789271784254495 -122.45950233827601 (37.7892717842545, -122.459502338276)
84422 107419 1 13 300 Seacliff Ave 5 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
85088 107418 1 13 300 Seacliff Ave 4 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
140378 107415 1 13 300 Seacliff Ave 1 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
142964 107417 1 13 300 Seacliff Ave 3 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
145801 107416 1 13 300 Seacliff Ave 2 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
Powered by Datasette · Query took 8.806ms · Data source: data.sfgov.org