sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
132 116641 1 44 270 Brannan St 3 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
133 218972 2 23 742 Myra Way 1 1 1 1     10 Width 2ft Permit Number 779535 5997475.9556599995 2098006.28819 37.7405807633888 -122.451309623139 (37.7405807633888, -122.451309623139)
134 47510 1 12 54X Cayuga Ave 1 1 1 1   03/27/2017 12:00:00 AM 3 3x3 Permit Number 45390 6003705.560409999 2094600.28554 37.731583388063 -122.42952721221901 (37.731583388063, -122.429527212219)
136 213016 2 17 120 Ortega St 1 1 1 1   03/27/2017 12:00:00 AM 3 Width 2ft Permit Number 779661 5993626.83548 2102594.2327400004 37.7529569465285 -122.4649514087 (37.7529569465285, -122.4649514087)
138 72565 4 44 270 Brannan St 1 5 1 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 4 44 270 Brannan St 2 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
144 11598 1 48 4134 Judah St 1 1 1 1   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.760483446414796 -122.506543543521 (37.7604834464148, -122.506543543521)
145 111561 2 49 1498x Kansas St 2 1 1 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737)
146 97319 1 48 1038 Taraval St 1 1 1 1   03/28/2017 12:52:00 PM 3 3x3   5989945.5882 2099070.048 37.7430675136338 -122.477424174253 (37.7430675136338, -122.477424174253)
147 58021 1 48 4026 Irving St 1 1 1 1   03/28/2017 12:07:00 PM 3   Permit Number 16988 5983218.6194 2106316.5419 37.7625717348083 -122.50121971656999 (37.7625717348083, -122.50121971657)
151 36617 1 33   8 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
155 251225 2 52 1 Yukon St 1 1 1 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
156 54712 1 48 4508 Irving St 1 1 1 1   03/28/2017 11:58:00 AM 3 3x3 Permit Number 10547 5981730.2931 2106265.9364 37.762345274891 -122.506363455406 (37.762345274891, -122.506363455406)
157 3193 1 15 3698 California St 4 1 1 1     16 3X3   5996969.37189 2114704.2549799997 37.7864001056199 -122.454266992435 (37.7864001056199, -122.454266992435)
159 97322 1 48 1055 Taraval St 3 1 1 1   03/28/2017 12:42:00 PM 3 3x3   5989910.3078 2099001.0945 37.7428761380219 -122.477541124233 (37.7428761380219, -122.477541124233)
160 175377 3 53 80X Junipero Serra Blvd 10 1 1 1     2 Width 3ft   5991371.46907 2088876.77956 37.715161983326794 -122.471751215951 (37.7151619833268, -122.471751215951)
161 142720 2 54 1170 COLUMBUS AVE 3 1 1 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
164 97323 1 48 1011 Taraval St 1 1 1 1   03/28/2017 12:25:00 PM 3 3x3   5990005.0659 2099005.494 37.7428937161431 -122.477213802134 (37.7428937161431, -122.477213802134)
166 251230 2 55 99x Ogden Ave 2 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 2 55 99x Ogden Ave 1 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
169 251221 1 17 2401X Washington St 1 1 1 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 778039          
170 48827 1 11 435 Pacific Ave 1 1 1 1   11/07/2002 12:00:00 AM 5 3x3 Permit Number 46051 6011929.23024 2118387.60951 37.79736024144329 -122.402768502565 (37.7973602414433, -122.402768502565)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
172 48332 1 17   142 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
174 251226 2 56 1 Yukon St 2 1 1 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
177 97317 1 48 1000 Taraval St 2 1 1 1   03/28/2017 12:59:00 PM 3 3x3   5990071.4812 2099073.5168 37.7430843422325 -122.476989128346 (37.7430843422325, -122.476989128346)
180 18700 1 15 100X Richardson Ave 2 1 1 1     18 3X3   5999457.6873699995 2119517.78462 37.799759164102895 -122.44600442526199 (37.7997591641029, -122.446004425262)
184 138801 1 22 2375 PINE ST 2 1 1 1   05/09/1997 12:00:00 AM 2 Width 0ft   6002525.8905 2115062.7753 37.787701584977704 -122.43506851988899 (37.7877015849777, -122.435068519889)
190 57209 1 21 2898 Clay St 1 1 1 1   12/15/2014 12:00:00 AM 3   Permit Number 773671 6000999.92024 2115926.87738 37.7899874194288 -122.440410066565 (37.7899874194288, -122.440410066565)
191 210495 2 1 365 San Leandro Way 1 1 1 1     21 Width 3ft Permit Number 779799 5992304.44524 2094447.3559700001 37.7305113566072 -122.468931622808 (37.7305113566072, -122.468931622808)
193 6069 1 2 1930 Eddy St 3 1 1 1   05/26/2015 12:00:00 AM 3 3X3   6001175.3543 2112495.6639 37.7805761758993 -122.439557004629 (37.7805761758993, -122.439557004629)
194 138802 1 46 2375 PINE ST 3 1 1 1     12 Width 0ft   6002539.8455 2115065.9469 37.787711085766894 -122.435020465254 (37.7877110857669, -122.435020465254)
204 61453 1 17   1 1 1 1   06/22/1984 12:00:00 AM     Permit Number 21392          
206 4750 1 32 1201 Columbus Ave 1 1 1 1     50 3X3   6007660.31382 2121409.3470799997 37.8054178953714 -122.417754386066 (37.8054178953714, -122.417754386066)
208 100305 2 61 3701 Buchanan St 2 1 1 1     6 3x3   6003064.411830001 2121045.8637900003 37.804160163827206 -122.433633107497 (37.8041601638272, -122.433633107497)
224 117019 4 2 168 Hyde St 3 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
226 220498 1 6 217 Douglass St 1 1 1 1   12/06/1972 12:00:00 AM 8 Width 3ft Permit Number 11470 6001117.07632 2105053.576 37.760138741716794 -122.43922504972001 (37.7601387417168, -122.43922504972)
229 138803 1 46 2375 PINE ST 4 1 1 1     10 Width 0ft   6002563.9496 2115068.4842 37.787719421164496 -122.434937251329 (37.7877194211645, -122.434937251329)
232 2726 1 28 2211 Bush St 2 1 1 1     12 3x3   6002817.4873 2114756.5606 37.7868773504916 -122.43403775447099 (37.7868773504916, -122.434037754471)
233 121240 2 16 91 Commonwealth Ave 2 1 1 1   10/07/2016 12:00:00 AM 3 3x5 Permit Number 778926 5996501.4108 2113948.5087 37.7842981813685 -122.45583135787399 (37.7842981813685, -122.455831357874)
235 45975 1 17   132 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
236 8118 1 6 841 Fulton St 1 1 1 1   12/15/2005 12:00:00 AM 3 3X3   6003718.373 2111409.0283 37.777736949412606 -122.430681932079 (37.7777369494126, -122.430681932079)
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
241 251257 2 65 1748x Eucalyptus Dr 1 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
245 251255 2 17 4089x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
251 251258 2 65 1748x Eucalyptus Dr 2 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
253 251256 2 67 4091x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
254 98489 2 21 1813 Baker St 1 1 1 1   03/29/2016 12:00:00 AM 3 4.5x5 Permit Number 777656 5999969.69733 2115286.35323 37.7881699939074 -122.443928497714 (37.7881699939074, -122.443928497714)
256 221894 2 68 3164 25th St 2 1 1 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
257 251260 2 9 1163 South Van Ness Ave 3 1 1 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 2 69 1050x Sacramento St 2 1 1 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
259 141361 2 55 1499X Hayes St 4 1 1 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
260 221893 2 68 3164 25th St 3 1 1 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
261 141359 2 41 1499X Hayes St 2 1 1 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
262 141360 2 55 1499X Hayes St 3 1 1 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
263 141358 2 1 1499X Hayes St 1 1 1 1     20 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
265 109354 2 19 900x Chestnut St 1 5 1 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
266 173827 2 17 1200 04th St 12 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
267 175151 2 70 285 Santa Rosa Ave 2 1 1 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000727.04119 2093604.3094 37.728679573387495 -122.43975313162399 (37.7286795733875, -122.439753131624)
268 46773 1 11 35 San Juan Ave 2 1 1 1 1 04/03/2017 12:00:00 AM 3   Permit Number 779460 6001741.72526 2092006.08473 37.7243489150655 -122.43613098976101 (37.7243489150655, -122.436130989761)
270 28098 1 16 639 Divisadero St 1 1 1 1   11/28/2006 12:00:00 AM 3 3X3   6001577.9698 2110674.4978 37.7755986195101 -122.438033679217 (37.7755986195101, -122.438033679217)
271 175152 2 70 285 Santa Rosa Ave 8 1 1 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000750.8705 2093589.3929700002 37.728639972642604 -122.43966968351002 (37.7286399726426, -122.43966968351)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
274 173825 2 17 1200 04th St 10 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
276 173808 2 17 1201 04th St 3 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
279 48153 1 17   263 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
280 194427 2 71 905 Minna St 3 1 1 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
282 173829 2 17 1200 04th St 14 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
283 173821 2 17 1200 04th St 6 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
284 137592 1 59 1125 Steiner St 1 1 1 1   04/16/1990 12:00:00 AM 18 Width 0ft   6002857.6038 2112094.871 37.7795712988398 -122.433708655697 (37.7795712988398, -122.433708655697)
285 98003 2 72 1904 Filbert St 2 1 1 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
287 173824 2 17 1200 04th St 9 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
289 173826 2 17 1200 04th St 11 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
290 173809 2 17 1201 04th St 4 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
294 251266 5 12 10x Paloma Ave 1 1 1 1                    
297 32804 1 17 1683 Hayes St 1 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779644 5999817.40523345 2110171.54968226 37.774117372599896 -122.44408773423099 (37.7741173725999, -122.444087734231)
298 173822 2 17 1200 04th St 7 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
299 196427 2 18 25 McLea Ct 2 1 1 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
301 173819 2 17 1200 04th St 4 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
302 187663 2 17 1155 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
303 196320 2 16 905 Minna St 2 1 1 1     7 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
304 173811 2 17 1201 04th St 6 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
305 191509 2 55 905 Minna St 4 1 1 1     6 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
306 173816 2 17 1200 04th St 1 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
307 173828 2 17 1200 04th St 13 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
308 46059 1 17   101 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
310 30658 1 52 47 Lafayette St 1 1 1 1 1 01/30/1995 12:00:00 AM 6 3x3 Permit Number 34591 6007577.417719999 2109608.9608 37.7730122661246 -122.41720454865299 (37.7730122661246, -122.417204548653)
311 173810 2 17 1201 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
312 226557 1 32 320 Dolores St 2 1 1 1     16 Width 7ft   6004833.37225 2106401.74543 37.7640512674875 -122.42646813862 (37.7640512674875, -122.42646813862)
314 173820 2 17 1200 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
316 67789 1 17 7 4384 St 1 1 1 1   12/17/1992 12:00:00 AM     Permit Number 31429          
318 142205 1 17 1683 HAYES ST 1 1 1 1     3 Width 0ft Permit Number 779644 5999834.1012 2110180.6204 37.774143230926 -122.44403063203698 (37.774143230926, -122.444030632037)
320 48259 1 17   123 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 1 17   1 1 1 1   06/26/1989 12:00:00 AM     Permit Number 27118          
322 7968 1 26 1901 Franklin St 3 1 1 1   10/03/2007 12:00:00 AM 3 3X3   6005627.24821 2116610.0246200003 37.7921255585096 -122.42444850412 (37.7921255585096, -122.42444850412)
Powered by Datasette · Query took 2.046ms · Data source: data.sfgov.org