sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9868 173714 2 1 699x 29th St 3 8 1 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
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)
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)
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)
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)
119856 85365 6 1 66 Clarendon Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
89532 112366 6 2 2224 Baker St 1 8 1 1       3x3 Permit Number 775823 5999858.5 2116547.8 37.791627252722 -122.444403911295 (37.791627252722, -122.444403911295)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
10236 173928 2 3 51 Vulcan Stwy 1 8 1 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
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)
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)
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)
86718 114261 2 3 800x BROTHERHOOD WAY 2 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
91895 114933 2 3 4400x OCEAN AVE 9 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
98650 113044 6 3 500 RAYMOND AVE 3 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
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)
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)
101280 113045 6 3 500 RAYMOND AVE 4 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
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)
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)
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)
118309 114264 2 3 800x BROTHERHOOD WAY 5 8 1 1     32     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
139185 114938 2 3 4400x OCEAN AVE 14 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
139674 117208 6 3 25 MIDCREST WAY 1 8 1 1     20     5997992.0 2100464.0 37.747358577228496 -122.44970241305 (37.7473585772285, -122.44970241305)
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)
78331 117161 2 5 1383X VERMONT ST 1 8 1 1           6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
93980 110202 2 5 1039 PAGE ST   8 1 1       4x5   6001572.7 2109358.5 37.771984919077 -122.43795762529301 (37.771984919077, -122.437957625293)
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)
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)
154324 112045 6 5 2418 Pacific Ave 1 8 1 1     18 3x3   6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226)
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)
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)
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)
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)
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)
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)
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)
29261 105753 6 15 3636 Buchanan St 1 8 1 1   02/21/2014 12:00:00 AM 13   Permit Number 771077 6003146.89414 2120799.57812 37.803488607670296 -122.433330062032 (37.8034886076703, -122.433330062032)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
88034 111070 6 16 1836 08TH AVE 2 8 1 1     2 3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
563 173951 6 17 2646 Union St 1 8 1 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
1358 173635 6 17 2590 Pacific Ave 1 8 1 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
2105 251411 6 17 2751 Buchanan St 1 8 1 1   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497.0 2117826.0 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505)
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)
9848 122687 6 17 1462 Funston Ave 1 8 1 1   01/04/2017 12:00:00 AM 3 3x8 Permit Number 779171 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312)
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)
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)
79626 94583 1 17 90 Joost Ave 1 8 1 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
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)
81053 88569 6 17 1335 Webster St 60 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
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)
83219 108097 6 17 3370 Washington St 2 8 1 1           5998663.3699 2115944.3199400003 37.789901994506 -122.44849555223101 (37.789901994506, -122.448495552231)
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)
85444 104728 6 17 3212 Jackson St 1 8 1 1   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492)
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)
85775 114272 6 17 2241 Sacramento St 1 8 1 1   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.79010430227179 -122.42974344149499 (37.7901043022718, -122.429743441495)
93053 88571 6 17 1335 Webster St 62 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
94493 110787 8 17 850x SANCHEZ ST 1 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
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)
97249 114184 6 17 2454 HYDE ST 1 8 1 1   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060.0 2120781.0 37.8036588138585 -122.41978724303999 (37.8036588138585, -122.41978724304)
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)
104222 88572 6 17 1335 Webster St 66 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
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)
109202 88570 6 17 1335 Webster St 61 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
112187 88567 6 17 1335 Webster St 39 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
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)
115344 88568 6 17 1335 Webster St 59 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
119427 12711 6 17 1449 Lake St 3 8 1 2   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046)
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)
128304 115100 6 17 710 PACHECO ST 1 8 1 1   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727.0 2102215.0 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741)
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)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
129398 109973 2 17 1458 43rd Ave 1 8 1 1   03/16/2015 12:00:00 AM 3 3x3   5982831.2 2105195.6 37.7594711884194 -122.502476670215 (37.7594711884194, -122.502476670215)
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)
142954 110788 8 17 850x SANCHEZ ST 2 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
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)
119287 85367 6 18 1990 09th Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.46526605884199 (37.7513105791605, -122.465266058842)
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)
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)
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)
1337 251410 6 21 2777 Pine St 1 8 1 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
Powered by Datasette · Query took 3.081ms · Data source: data.sfgov.org