sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
79071 95369   17 27 Hartford St   8 2 1   02/18/2011 12:00:00 AM       6002651.0 2105744.0 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968)
2436 110026 1 175 2585 Pacific Ave 2 8 1 1   03/18/2015 12:00:00 AM 3   Permit Number 779691 6001774.18039 2116969.68651 37.7928947585324 -122.437805917729 (37.7928947585324, -122.437805917729)
5622 87285 1 36 1820 Webster St 1 8 1 1     24 3x3 Permit Number 50302 6003460.507999999 2115059.4384 37.7877454479518 -122.43183468665801 (37.7877454479518, -122.431834686658)
8205 110025 1 15 2585 Pacific Ave 1 8 1 1   03/18/2015 12:00:00 AM 3   Permit Number 774536 6001760.7528800005 2116964.32872 37.7928792839017 -122.437851993568 (37.7928792839017, -122.437851993568)
11497 69940 1 49 1295 30th Ave 1 8 1 1   05/06/2016 12:00:00 AM 3 5x5 Permit Number 778203 5986757.5345 2106473.3538 37.7632094781069 -122.488991584645 (37.7632094781069, -122.488991584645)
46828 84740 1 7 143 Alhambra St 1 8 1 1   03/27/2007 12:00:00 AM 13 4x6 Permit Number 49254 6001588.49283 2120281.76365 37.8019782934262 -122.438685839601 (37.8019782934262, -122.438685839601)
56651 31242 1 155 2523 17th Ave 1 8 1 1   02/08/2008 12:00:00 AM 5 3x3 Permit Number 50225 5991071.12499 2098214.14208 37.7407826611875 -122.473469993967 (37.7407826611875, -122.473469993967)
66196 107892 1 88 162 Brewster St   8 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
78703 105804 1 68 117 ALPINE TER 1 8 1 1   04/10/2014 12:00:00 AM 14 3x3 Permit Number 772090 6001724.2 2108149.5 37.7686739192463 -122.437346990121 (37.7686739192463, -122.437346990121)
79626 94583 1 17 90 Joost Ave 1 8 1 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
80037 86731 1 100 2 Pico Ave   8 1 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
80053 109497 1 254 785 Mangels Ave 1 8 1 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 771883 5996438.0 2095245.0 37.732939449865896 -122.45469900823 (37.7329394498659, -122.45469900823)
80436 87674 1 40 770 Golden Gate Ave 10 8 1 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
80984 88447 1 17 93 Prentiss St 1 8 1 1   07/14/2008 12:00:00 AM   3x3 Permit Number 51413 6008891.7 2098141.7 37.7415996198956 -122.411847801096 (37.7415996198956, -122.411847801096)
85057 115566 1 17 2026 36TH AVE 1 8 1 1   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777529 5985134.0 2101392.0 37.7491625951009 -122.49423221215099 (37.7491625951009, -122.494232212151)
85532 108239 1 17 15 ASHBURY TER 1 8 1 1   01/14/2015 12:00:00 AM 3 5x50 Permit Number 774721 5999554.7 2106911.6 37.7651513833487 -122.444762103204 (37.7651513833487, -122.444762103204)
85808 98327 1 176 143 Alhambra St 2 8 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49254 6001613.1 2120268.4 37.8019430002039 -122.43859972925199 (37.8019430002039, -122.438599729252)
86072 54809 1 12 150 Carmel St 2 8 1 1   03/12/2007 12:00:00 AM 5 3x3 Permit Number 773425 5998092.51354995 2105385.25255364 37.760876867329294 -122.449709427273 (37.7608768673293, -122.449709427273)
89222 89359 1 35 308 Tocoloma Ave 3 8 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.39839375585301 (37.7112369933076, -122.398393755853)
89776 98528 1 136 428 11th St 1 8 1 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
95257 93959 1 84 419 Elizabeth St   8 1 1       3x3 Permit Number 53399 6003681.0 2102149.0 37.752309029626495 -122.430150445418 (37.7523090296265, -122.430150445418)
95797 114729 1 51 1930 35TH AVE 1 8 1 1   12/03/2015 12:00:00 AM   4x4   5985421.0 2102058.0 37.7510080399178 -122.493288836187 (37.7510080399178, -122.493288836187)
102290 31648 1 17 4500 Ulloa St 3 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
104090 87073 1 82 395 Byxbee St 4 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
104759 87819 1 47 390 Lansdale Ave 1 8 1 1         Permit Number 50681 5995630.7 2096410.1 37.736092191921294 -122.457574304331 (37.7360921919213, -122.457574304331)
106143 87075 1 45 395 Byxbee St 6 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
110088 114688 1 88 231 Dwight St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.723279336417704 -122.404549596707 (37.7232793364177, -122.404549596707)
110241 87072 1 82 395 Byxbee St 3 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
111937 87074 1 45 395 Byxbee St 5 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
113089 87675 1 40 770 Golden Gate Ave 11 8 1 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
113764 31646 1 17 4500 Ulloa St 2 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
117945 104498 1 526 26 Allston Way 2 8 1 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
117993 108442 1 77 750 12th Ave   8 1 1 1     3x3 Permit Number 773771 5992283.6285 2110333.09253 37.7741282667999 -122.470159914203 (37.7741282667999, -122.470159914203)
118464 98529 1 136 428 11th St 2 8 1 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
124233 114680 1 80 54 Colby St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774571 6007954.9 2093861.0 37.729793151999395 -122.414784067206 (37.7297931519994, -122.414784067206)
127496 36443 1 17 1260 Plymouth Ave 1 8 1 1   11/20/2009 12:00:00 AM   3x3 Permit Number 53041 5995883.45550893 2092448.59347632 37.725229366758 -122.456414062747 (37.725229366758, -122.456414062747)
127767 31647 1 17 4500 Ulloa St 4 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
128374 104497 1 526 26 Allston Way 1 8 1 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
129263 63301 1 17 3261 Harrison St 1 8 1 1 1 01/26/1987 12:00:00 AM 18   Permit Number 53402 6009046.03746796 2099701.90725396 37.745892263304896 -122.411424351246 (37.7458922633049, -122.411424351246)
134828 114679 1 235 836 Brussels St 1 8 1 1   12/01/2015 12:00:00 AM 1   Permit Number 774714 6011176.24092 2090873.36995 37.7217702116011 -122.403437363447 (37.7217702116011, -122.403437363447)
138475 96182 1 17 330 South Van Ness Ave   8 2 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
139591 87070 1 88 395 Byxbee St 1 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
140914 114321 1 12 2118 47th Ave 1 8 2 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
142230 120534 1 12 2043 32nd Ave 1 8 1 1   08/10/2016 12:00:00 AM 3 3x3   5986293.0 2101328.0 37.7490546230695 -122.49021972232599 (37.7490546230695, -122.490219722326)
143622 87071 1 88 395 Byxbee St 2 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
148125 79257 1 12 571 35th Ave 1 8 1 1   12/06/2007 12:00:00 AM 11 3x3 Permit Number 49957 5985010.61242 2111991.22713 37.7782578784089 -122.495440495889 (37.7782578784089, -122.495440495889)
2134 252904 2 170 1216 Clay St 1 8 1 1       3x3   6008866.0 2117029.0 37.7934583239602 -122.41327198066799 (37.7934583239602, -122.413271980668)
2767 252950 2 15 261x Winding Way 2 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
2772 252949 2 15 261x Winding Way 1 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
3269 253386 2 142 726 El Camino Del Mar 1 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3272 253387 2 142 726 El Camino Del Mar 2 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
9868 173714 2 1 699x 29th St 3 8 1 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
10183 173712 2 17 699x 29th St 1 8 1 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
10195 173713 2 17 699x 29th St 2 8 1 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
10236 173928 2 3 51 Vulcan Stwy 1 8 1 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
22873 251137 2 11 25x Goettingen St 1 8 1 1   03/10/2017 12:00:00 AM 3 3x3 Permit Number 779273 6009828.0 2094364.0 37.7312793503434 -122.40834398535401 (37.7312793503434, -122.408343985354)
58682 116625 2 41 5732X GEARY BLVD 6 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
74401 121592 2 55 4233 Cesar Chavez St 1 8 1 1       3x3   6002342.0 2100313.0 37.7471918787018 -122.434649642859 (37.7471918787018, -122.434649642859)
77706 114927 2 3 4400x OCEAN AVE 1 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
78331 117161 2 5 1383X VERMONT ST 1 8 1 1           6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
78663 114932 2 3 4400x OCEAN AVE 8 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
80776 114263 2 3 800x BROTHERHOOD WAY 4 8 1 1     29     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
82056 114939 2 3 4400x OCEAN AVE 15 8 1 1     36 3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
82154 114926 2 3 4400x OCEAN AVE 2 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
84743 116631 2 41 5732X GEARY BLVD 12 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
85675 108214 2 1 1611 47th Ave 1 8 1 1     15 3x3   5981530.432709999 2104091.45519 37.756363002508294 -122.50689338520701 (37.7563630025083, -122.506893385207)
86718 114261 2 3 800x BROTHERHOOD WAY 2 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
88886 117247 2 22 1096 EDDY ST 1 8 1 1       6x6   6005188.0 2113045.0 37.7823120756394 -122.425714454198 (37.7823120756394, -122.425714454198)
89540 112569 2 141 162 GRAND VIEW AVE 1 8 1 1     7 3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
91895 114933 2 3 4400x OCEAN AVE 9 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
93980 110202 2 5 1039 PAGE ST   8 1 1       4x5   6001572.7 2109358.5 37.771984919077 -122.43795762529301 (37.771984919077, -122.437957625293)
94216 100680 2 1 387 Beacon St   8 1 1         7' wide public RoW 6002378.0 2098199.0 37.7413893731095 -122.434374040118 (37.7413893731095, -122.434374040118)
96445 114266 2 128 800x BROTHERHOOD WAY 7 8 1 1     9     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
98858 114924 2 3 37X EVERGLADE DR 1 8 1 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
98906 116629 2 41 5732X GEARY BLVD 10 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
100355 116620 2 41 5732X GEARY BLVD 1 8 1 6 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
100601 114931 2 3 4400x OCEAN AVE 7 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
100636 114940 2 3 4400x OCEAN AVE 16 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
101205 114262 2 3 800x BROTHERHOOD WAY 3 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
102481 114925 2 71 4400x OCEAN AVE 3 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
102533 112571 2 141 162 GRAND VIEW AVE 3 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
103011 114923 2 3 51X EVERGLADE DR 1 8 1 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
103199 114934 2 71 4400x OCEAN AVE 10 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103256 114928 2 3 4400x OCEAN AVE 4 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
104404 106685 2 19 100 Yukon St   8 1 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
105054 104686 2 22 140 26TH AVE   8 1 1     22 4x4   5987812.9 2115041.6 37.786797021543 -122.485970438221 (37.786797021543, -122.485970438221)
106106 114937 2 3 4400x OCEAN AVE 13 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113343 116624 2 41 5732X GEARY BLVD 5 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
114585 115388 2 47 169x BOCANA ST 1 8 1 1     25 40x50   6007278.0 2097999.0 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034)
117877 112570 2 141 162 GRAND VIEW AVE 2 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
118309 114264 2 3 800x BROTHERHOOD WAY 5 8 1 1     32     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
119101 116621 2 41 5732X GEARY BLVD 2 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
122091 114098 2 55 219x VIDAL DR 1 8 1 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
123578 114260 2 71 800x BROTHERHOOD WAY 1 8 1 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
Powered by Datasette · Query took 4.525ms · Data source: data.sfgov.org