sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
2134 252904 2 170 1216 Clay St 1 8 1 1       3x3   6008866.0 2117029.0 37.7934583239602 -122.41327198066799 (37.7934583239602, -122.413271980668)
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)
2712 253178 6 189 4450 24th St 2 8 1 1       Width 0ft   6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398)
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)
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)
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
4182 253620 6 142 1120 South Van Ness Ave 3 8 1 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
9862 173716 6 43 1652 Fell St 1 8 1 1           5999516.0 2109850.0 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354)
9868 173714 2 1 699x 29th St 3 8 1 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
10236 173928 2 3 51 Vulcan Stwy 1 8 1 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
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)
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
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)
56265 104652 6 94 953 Indiana St 1 8 1 1           6015057.1 2104275.7 37.758786250670205 -122.39095836980302 (37.7587862506702, -122.390958369803)
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)
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)
79308 111069 6 163 1836 08TH AVE 3 8 1 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
79626 94583 1 17 90 Joost Ave 1 8 1 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
80776 114263 2 3 800x BROTHERHOOD WAY 4 8 1 1     29     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
81797 115888 6 41 811 TREAT AVE 1 8 1 1     20 3x3   6008597.0 2103712.0 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978)
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)
83219 108097 6 17 3370 Washington St 2 8 1 1           5998663.3699 2115944.3199400003 37.789901994506 -122.44849555223101 (37.789901994506, -122.448495552231)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
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)
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)
86498 107113 6 115 2100 MARKET ST   8 1 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
86717 108022 6 145 455X Ivy St 2 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
86718 114261 2 3 800x BROTHERHOOD WAY 2 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
87119 112572 6 141 162 GRAND VIEW AVE 4 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
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)
88886 117247 2 22 1096 EDDY ST 1 8 1 1       6x6   6005188.0 2113045.0 37.7823120756394 -122.425714454198 (37.7823120756394, -122.425714454198)
88934 107130 7 65 751 DOLORES ST 1 8 1 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
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)
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)
92947 99830 6 198 2398@Steiner Broadway 1 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
93980 110202 2 5 1039 PAGE ST   8 1 1       4x5   6001572.7 2109358.5 37.771984919077 -122.43795762529301 (37.771984919077, -122.437957625293)
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)
95902 96835 6 60 6001 Geary Blvd 1 8 1 1           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894)
96445 114266 2 128 800x BROTHERHOOD WAY 7 8 1 1     9     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
98327 99832 6 198 2398@Steiner Broadway 3 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
98650 113044 6 3 500 RAYMOND AVE 3 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
98792 108275 6 238 1800x ALAMEDA ST 5 8 1 1     15     6011533.0 2107928.0 37.7686184708296 -122.40340334412501 (37.7686184708296, -122.403403344125)
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)
99011 115564 6 35 3524 Jackson St 2 8 1 1       5x10   5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
99196 108002 6 75 461X Ivy St 1 8 1 1           6005199.36333 2111122.83043 37.777034912059605 -122.425538300101 (37.7770349120596, -122.425538300101)
100592 116998 6 36 880x MCALLISTER ST 1 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
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)
102078 117000 6 36 880x MCALLISTER ST 3 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102339 113744 6 141 909 ASHBURY ST 1 8 1 1       3x3   5999156.0 2107025.0 37.7654399906909 -122.44614926226002 (37.7654399906909, -122.44614926226)
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)
103256 114928 2 3 4400x OCEAN AVE 4 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103820 111068 6 163 1836 08TH AVE 1 8 1 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
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)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
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)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
117224 117027 6 129 731 CLAYTON ST 1 8 1 1           5998515.0 2108057.0 37.768236974715705 -122.44844065135099 (37.7682369747157, -122.448440651351)
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)
118617 112451 6 129 1526 MASONIC AVE 1 8 1 1       3x6   5999767.0 2107205.0 37.7659690994291 -122.44404889486401 (37.7659690994291, -122.444048894864)
121120 103719 6 49 748 Treat Ave 1 8 1 1     8 3x3   6008496.2 2104169.0 37.758127039951205 -122.41364151852801 (37.7581270399512, -122.413641518528)
122091 114098 2 55 219x VIDAL DR 1 8 1 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
123578 114260 2 71 800x BROTHERHOOD WAY 1 8 1 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
124370 116999 6 36 880x MCALLISTER ST 2 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
124433 114265 2 47 800x BROTHERHOOD WAY 6 8 1 1     26     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
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)
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)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
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)
139185 114938 2 3 4400x OCEAN AVE 14 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
139221 99831 6 198 2398@Steiner Broadway 2 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
139674 117208 6 3 25 MIDCREST WAY 1 8 1 1     20     5997992.0 2100464.0 37.747358577228496 -122.44970241305 (37.7473585772285, -122.44970241305)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
140796 114929 2 3 4400x OCEAN AVE 5 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141088 115806 6 169 362 MISSOURI ST 1 8 1 1     12 3x3   6013446.0 2105415.0 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099)
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)
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)
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)
144227 108021 6 75 455X Ivy St 1 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
144669 114930 2 3 4400x OCEAN AVE 6 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
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)
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)
Powered by Datasette · Query took 4.797ms · Data source: data.sfgov.org