sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
5 188702 3 5 1501 Evans Ave 2 4 1 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
7 188697 3 5 1301 Evans Ave 13 4 1 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
24 22346 3 11 5280 03rd St 1 1 1 2   06/27/2014 12:00:00 AM 3 3x3   6014341.487000001 2093641.8617 37.7295482207565 -122.39268941982701 (37.7295482207565, -122.392689419827)
25 23567 3 15 2975 Van Ness Ave 1 1 1 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
29 188686 3 5 1300 Evans Ave 20 4 1 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
32 10933 3 11 1359 Hudson Ave 1 1 1 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
36 13434 3 15 2X Market St 2 1 1 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
42 28375 3 21 3014 Sacramento St 1 1 1 1   10/09/2003 12:00:00 AM 3 3x3 Permit Number 54020 6000248.590919999 2115494.6796 37.788757908594896 -122.442978542939 (37.7887579085949, -122.442978542939)
46 18228 3 22 1737-1795 Post St 2 1 1 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
47 17325 3 23 150 Otis St 1 1 1 2   08/31/2016 12:00:00 AM 3 3x3   6006651.4447 2108878.4679400004 37.7709543699737 -122.420355751511 (37.7709543699737, -122.420355751511)
48 3528 3 11 201X Cargo Way 38 1 1 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
72 25725 3 15 729 Grove St 1 1 1 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
97 5266 3 26 1245 Divisadero St 2 1 1 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
105 6251 3 5 1315 Ellis St 1 1 1 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
106 10645 3 36 906 Hayes St 3 1 1 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
109 9895 3 40 1800X Pine St 1 1 1 2     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873)
112 9896 3 11 1800X Pine St 2 1 1 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
117 220007 3 42 929 Valencia St 1 1 1 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
123 18916 3 41 2621 Sacramento St 1 1 1 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
124 20281 3 2 20X Sunset Blvd 2 1 1 2     12 60            
126 228560 3 11 700 Valencia St 2 1 1 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
127 18052 3 46 2840 Pine St 2 1 1 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
129 20398 3 47 262X Sunset Blvd 43 1 1 2     24 60            
131 237033 3 18 100 Octavia St 7 4 1 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 3 18 100 Octavia St 4 4 1 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
137 228561 3 11 700 Valencia St 1 1 1 2     7 Width 3ft   6006199.77605 2105468.2728 37.7615653191939 -122.42167583577299 (37.7615653191939, -122.421675835773)
140 6337 3 2 1916 Ellis St 1 1 1 2     18 3X3   6001700.9234 2112915.307 37.7817583075946 -122.437768878541 (37.7817583075946, -122.437768878541)
141 832 3 48 1396 47th Ave 1 1 1 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)
143 18836 3 32 2055 Sacramento St 2 1 1 2     12 3X3   6004953.14987 2116100.2629400003 37.7906877916676 -122.426744576702 (37.7906877916676, -122.426744576702)
148 175046 3 2 80X Junipero Serra Blvd 3 1 1 2     4 Width 3ft   5991566.54873 2087591.2585200001 37.7116435395983 -122.47098334961399 (37.7116435395983, -122.470983349614)
149 26071 3 50 247 Orizaba Ave 1 1 1 2   03/28/2017 01:41:00 PM 3 3X3   5993990.1569314 2088190.8403771 37.7134297247264 -122.46265023824101 (37.7134297247264, -122.462650238241)
150 11606 3 48 4200x Judah St 1 1 1 2   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.76045094714279 -122.507135818078 (37.7604509471428, -122.507135818078)
152 24532 3 48 1395 47th Ave 1 1 1 2   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.50709148147499 (37.7607233666377, -122.507091481475)
153 5972 3 26 1550 Eddy St 1 1 1 2   02/02/1990 12:00:00 AM 8 3X3   6003044.0843 2112751.363 37.7813844410266 -122.43311045884899 (37.7813844410266, -122.433110458849)
154 830 3 51 1384 47th Ave 1 1 1 2   03/28/2017 12:15:00 PM 3 5.5x6.5   5981549.5887 2105676.5499 37.7607163481902 -122.506944712409 (37.7607163481902, -122.506944712409)
158 21682 3 35 1830 Sutter St 1 1 1 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
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)
163 29943 3 51 242 Broad St 1 1 1 2   03/28/2017 12:23:00 PM 3 3x3   5994593.32204167 2088106.90572275 37.7132339790874 -122.460559423837 (37.7132339790874, -122.460559423837)
165 11582 3 48 4000 Judah St 1 1 1 2   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.760550193841404 -122.505003612665 (37.7605501938414, -122.505003612665)
173 175044 3 2 80x Junipero Serra Blvd 1 1 1 2     19 Width 3ft   5991568.948890001 2087568.2224599998 37.7115804269636 -122.470973377029 (37.7115804269636, -122.470973377029)
175 17881 3 41 2205 Pine St 1 1 1 2     12 3X3   6003346.6048 2115178.7939 37.7880667103656 -122.432237297056 (37.7880667103656, -122.432237297056)
176 24515 3 11 2030 Fell St 1 1 1 2   04/07/2016 07:40:00 AM 3 3X3   5997710.2902 2109583.0289 37.772381016672895 -122.45133412385 (37.7723810166729, -122.45133412385)
178 2985 3 15 2253 California St 1 1 1 2     65 3X3   6003588.0004 2115559.2302 37.789124975971106 -122.431429279776 (37.7891249759711, -122.431429279776)
179 182083 3 48 1101 Taraval St 1 1 1 2   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.742858080169505 -122.47800774412599 (37.7428580801695, -122.478007744126)
181 9914 3 32 1900 Gough St 1 1 1 2     126 3X3   6005235.69262 2116267.9294 37.7911641319684 -122.42577893234899 (37.7911641319684, -122.425778932349)
182 93463 3 57 1739 Taraval St 1 1 1 2   03/28/2017 01:05:00 PM 3 3x3   5987772.1588 2098929.0107 37.7425539090053 -122.48492886712098 (37.7425539090053, -122.484928867121)
183 15429 3 32 2125 Mission St 1 1 1 2   04/09/2015 12:00:00 AM 15 4X4   6006871.98757 2105962.63928 37.762960616913205 -122.41938599878401 (37.7629606169132, -122.419385998784)
186 138359 3 59 2060 SUTTER ST 1 1 1 2     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.43386429175101 (37.7860784126894, -122.433864291751)
187 251248 3 60 829 Chenery St 1 1 1 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
188 138368 3 59 2060 SUTTER ST 10 1 1 2     13 Width 0ft   6002679.2262 2114443.3671 37.786009553218996 -122.434493703661 (37.786009553219, -122.434493703661)
189 138807 3 46 2355 PINE ST 3 1 1 2     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462)
192 138369 3 59 2060 SUTTER ST 11 1 1 2     16 Width 0ft   6002665.8461 2114439.4026 37.78599790817471 -122.434539711553 (37.7859979081747, -122.434539711553)
195 138365 3 59 2060 SUTTER ST 7 1 1 2     19 Width 0ft   6002748.6045 2114451.296 37.78603526200121 -122.43425424087799 (37.7860352620012, -122.434254240878)
196 251246 3 2 722X Mendell St 2 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
197 251245 3 60 701 Chenery St 1 1 1 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
198 103786 3 21 1221 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006804.9894 2115120.2532 37.7881014522033 -122.420267712778 (37.7881014522033, -122.420267712778)
199 138362 3 59 2060 SUTTER ST 4 1 1 2     15 Width 0ft   6002806.585 2114457.2427 37.78605488083279 -122.434054069465 (37.7860548808328, -122.434054069465)
201 138367 3 59 2060 SUTTER ST 9 1 1 2     15 Width 0ft   6002691.6152 2114444.3582 37.7860129777854 -122.434450912019 (37.7860129777854, -122.434450912019)
202 138810 3 22 2355 PINE ST 6 1 1 2     11 Width 0ft   6002718.089 2115091.954 37.787792613821004 -122.434405637805 (37.787792613821, -122.434405637805)
207 138805 3 46 2355 PINE ST 1 1 1 2     11 Width 0ft   6002622.3069 2115079.2676 37.787752342886 -122.434736117903 (37.787752342886, -122.434736117903)
210 13438 3 15 2X Market St 6 1 1 2   12/12/2002 12:00:00 AM 6 4x4   6014077.43398 2117238.82075 37.794325647358704 -122.395254594939 (37.7943256473587, -122.395254594939)
211 138370 3 59 2060 SUTTER ST 12 1 1 2     16 Width 0ft   6002647.5104 2114436.9248 37.7859900638921 -122.434602970779 (37.7859900638921, -122.434602970779)
212 138800 3 22 2375 PINE ST 1 1 1 2     7 Width 0ft   6002511.9355 2115060.8724 37.7876955676952 -122.435116665287 (37.7876955676952, -122.435116665287)
213 28640 3 35 1300 Webster St 2 11 1 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
215 17196 3 21 2235X Octavia St 5 11 1 2     24 20   6004629.787409999 2116932.39582 37.792954330542 -122.42792271466601 (37.792954330542, -122.427922714666)
216 138364 3 59 2060 SUTTER ST 6 1 1 2     18 Width 0ft   6002783.7892 2114453.2783 37.7860427018539 -122.43413265320801 (37.7860427018539, -122.434132653208)
217 138366 3 59 2060 SUTTER ST 8 1 1 2     18 Width 0ft   6002708.9598 2114445.3493 37.7860166836287 -122.43439097535801 (37.7860166836287, -122.434390975358)
218 11423 3 2 722X Mendell St 1 1 1 2     0 3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
219 138804 3 46 2375 PINE ST 5 1 1 2     1 Width 0ft   6002587.4194 2115073.5588 37.787734687268795 -122.43485641346001 (37.7877346872688, -122.43485641346)
220 138363 3 59 2060 SUTTER ST 5 1 1 2     16 Width 0ft   6002798.656 2114455.2605 37.7860489882217 -122.434081359893 (37.7860489882217, -122.434081359893)
221 138361 3 59 2060 SUTTER ST 3 1 1 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
222 251247 3 2 722X Mendell St 3 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
223 23789 3 62 1100X Webster St 4 11 1 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
225 138808 3 46 2355 PINE ST 4 1 1 2   06/06/2015 11:29:00 AM 5 Width 0ft   6002680.0299 2115089.4167 37.787783486631206 -122.434537133485 (37.7877834866312, -122.434537133485)
227 13622 3 15 562 Market St 1 1 1 2     18 4x4   6012358.746590001 2115584.5782 37.789687756343604 -122.401085198325 (37.7896877563436, -122.401085198325)
228 246283 3 59 2125 Mission St 2 1 1 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
230 138371 3 59 2060 SUTTER ST 13 1 1 2     17 Width 0ft   6002611.3346 2114434.4469999997 37.785981206770394 -122.434727951803 (37.7859812067704, -122.434727951803)
231 138360 3 59 2060 SUTTER ST 2 1 1 2     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385)
234 26932 3 26 1570 Golden Gate Ave 1 1 1 2   04/05/2000 12:00:00 AM 3 3X3   6002097.1307 2111930.5841 37.7790770280177 -122.43632769328998 (37.7790770280177, -122.43632769329)
237 2654 3 22 1988 Bush St 1 1 1 2   01/30/2005 12:00:00 AM 12 3X3   6004003.2237 2114978.8425 37.7875549020514 -122.429951242636 (37.7875549020514, -122.429951242636)
238 251251 3 63 321X Corbett Ave 2 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
239 251252 3 63 321X Corbett Ave 3 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
242 194017 3 2 717 Mendell St 3 1 1 2     22 Width 4ft   6016141.23024 2096883.95841 37.7385501598741 -122.386693461838 (37.7385501598741, -122.386693461838)
243 2928 3 15 1834 California St 1 1 1 2     25 3X3   6005568.20527 2115901.70542 37.7901773571486 -122.42460238530501 (37.7901773571486, -122.424602385305)
244 9908 3 2 1809 Gough St 2 1 1 2     14 6x6   6005225.98494 2115998.17525 37.79042290624211 -122.425793311632 (37.7904229062421, -122.425793311632)
246 251253 3 21 1350 Howard St 3 1 1 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
247 251250 3 63 321X Corbett Ave 1 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
248 23733 3 15 800X Webster St 8 11 1 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
250 24634 3 9 507 Divisadero St 1 1 1 2   10/29/2011 12:00:00 AM 3 3x3   6001641.187000001 2110229.9881 37.774381702191896 -122.437783152308 (37.7743817021919, -122.437783152308)
252 182864 3 17 1674 27th Ave 1 1 1 2   02/02/2016 10:49:00 AM 1 Width 0ft   5987818.6474 2103915.1987 37.7562473553988 -122.485133888104 (37.7562473553988, -122.485133888104)
255 19810 3 24 100 STAIRWAY24 1 1 1 2     12 100ST            
264 20199 3 26 1300X Steiner St 7 1 1 2   01/02/1991 12:00:00 AM 12 3X3   6002784.1975 2112923.5771 37.7818425521761 -122.434021853774 (37.7818425521761, -122.434021853774)
269 127441 3 32 2101 Van Ness Ave 4 1 1 2     15 Width 4ft   6005937.76794 2117668.55868 37.795049557533105 -122.423449386982 (37.7950495575331, -122.423449386982)
273 20166 3 59 1155X Steiner St 7 1 1 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
275 818 3 2 1385 45th Ave 1 1 1 2     35 4x4   5982124.8821 2105687.3873 37.7607799675436 -122.504955867812 (37.7607799675436, -122.504955867812)
Powered by Datasette · Query took 1.641ms · Data source: data.sfgov.org