sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
80776 114263 2 3 800x BROTHERHOOD WAY 4 8 1 1     29     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
86718 114261 2 3 800x BROTHERHOOD WAY 2 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
96445 114266 2 128 800x BROTHERHOOD WAY 7 8 1 1     9     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
101205 114262 2 3 800x BROTHERHOOD WAY 3 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
118309 114264 2 3 800x BROTHERHOOD WAY 5 8 1 1     32     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
123578 114260 2 71 800x BROTHERHOOD WAY 1 8 1 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
124433 114265 2 47 800x BROTHERHOOD WAY 6 8 1 1     26     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
11071 113042 6 62 500 Raymond Ave 1 8 1 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
50075 113043 6 3 500 RAYMOND AVE 2 8 1 1   10/06/2015 12:00:00 AM   3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
98650 113044 6 3 500 RAYMOND AVE 3 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
101280 113045 6 3 500 RAYMOND AVE 4 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
122091 114098 2 55 219x VIDAL DR 1 8 1 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
108375 111357 6 3 600x MANSELL ST 1 8 1 2     48 3x3   6010142.0 2090267.0 37.720047423695505 -122.40696976451099 (37.7200474236955, -122.406969764511)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
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)
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)
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)
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)
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)
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)
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)
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)
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)
81076 88608 6 17 350 Urbano Dr 1 8 1 1   08/01/2008 12:00:00 AM     Permit Number 51562 5991996.0 2092560.0 37.72531132011171 -122.46986059313801 (37.7253113201117, -122.469860593138)
139135 112417 2 5 98X BROADMOOR DR 1 8 1 1     28 3x3   5990934.0 2093194.0 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435)
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
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)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
3709 253265 6 19 180 San Aleso Ave 1 8 1 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
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)
77706 114927 2 3 4400x OCEAN AVE 1 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
78663 114932 2 3 4400x OCEAN AVE 8 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
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)
91895 114933 2 3 4400x OCEAN AVE 9 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
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)
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)
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)
106106 114937 2 3 4400x OCEAN AVE 13 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
139185 114938 2 3 4400x OCEAN AVE 14 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
140796 114929 2 3 4400x OCEAN AVE 5 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141835 114936 2 3 4400x OCEAN AVE 12 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141973 114935 2 3 4400x OCEAN AVE 11 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
144669 114930 2 3 4400x OCEAN AVE 6 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
79626 94583 1 17 90 Joost Ave 1 8 1 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
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)
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)
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)
78259 111280 3 143 700X BOSWORTH ST 18 8 1 2     48     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
78878 2044 3 143 700X Bosworth St 1 8 1 2     36   Permit Number 772999 6002154.6210393 2095431.8532492002 37.733778746199796 -122.43494855504801 (37.7337787461998, -122.434948555048)
13821 105161 6 18 1600X Oakdale Ave 2 8 1 19     13 3x3   6014869.34112 2095641.8363700002 37.735069048787 -122.39100428831499 (37.735069048787, -122.391004288315)
42991 105168 6 60 4755X 03RD ST 2 8 1 19     23 3x3 Permit Number 770204 6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
83931 105169 7 60 4755X 03RD ST 3 8 1 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
111891 105167 7 60 4755X 03RD ST 1 8 1 19     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
117969 105170 7 21 4755X 03RD ST 4 8 1 19     2 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
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)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
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)
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)
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)
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)
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)
91973 106184 6 41 1327 ULLOA ST 1 8 1 1 1   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077)
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)
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)
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)
111849 117150 8 49 928 TOLAND ST 5 8 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950.0 2098029.0 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936)
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)
97229 85428 6 17 43 Ora Way 1 8 1 1   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.741605021987205 -122.437232403771 (37.7416050219872, -122.437232403771)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
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)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
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)
129412 104753 2 5 2328 12TH AVE   8 1 1     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356)
105928 109708 6 17 621 Laguna Honda Blvd 3 8 1 1 1 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.745700269008296 -122.457505029341 (37.7457002690083, -122.457505029341)
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)
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)
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)
139674 117208 6 3 25 MIDCREST WAY 1 8 1 1     20     5997992.0 2100464.0 37.747358577228496 -122.44970241305 (37.7473585772285, -122.44970241305)
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)
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)
125158 116956 6 143 380 SAN JOSE AVE 1 8 1 1     28 3x3   6006172.0 2100967.0 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126)
103688 92051 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
140608 92050 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
85684 116955 6 46 818 Douglass St 1 8 1 1     6 3x3   6001245.0 2101454.0 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352)
Powered by Datasette · Query took 4.525ms · Data source: data.sfgov.org